Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

TICKET_ONE_IF_BLOCKER

Arguments:

NameData TypeDefault ValueIn/Out
SEVERITYVARCHAR2 IN
STATUSVARCHAR2 IN

Returns:

INTEGER(38.0)

Source

Source
     1: function ticket_one_if_blocker (severity IN varchar, status IN varchar)
     2: return integer
     3: is
     4: BEGIN
     5:   IF ((severity = 'showstopper') AND (status <> 'closed') AND (status <> 'deferred')) THEN
     6:     return 1;
     7:   ELSE
     8:     return 0;
     9:   END IF;
    10: END ticket_one_if_blocker;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002