APPS.IEM_ROUTE_PUB dependencies on IEM_ROUTE_RULES

Line 36: key iem_route_rules.key_type_code%type,

32: G_PKG_NAME VARCHAR2(100):= 'IEM_ROUTE_PUB';
33:
34: --The record type for passing rules
35: TYPE Rules_rec_type is RECORD (
36: key iem_route_rules.key_type_code%type,
37: operator iem_route_rules.operator_type_code%type,
38: value iem_route_rules.value%type);
39:
40: --The table type for passing rules

Line 37: operator iem_route_rules.operator_type_code%type,

33:
34: --The record type for passing rules
35: TYPE Rules_rec_type is RECORD (
36: key iem_route_rules.key_type_code%type,
37: operator iem_route_rules.operator_type_code%type,
38: value iem_route_rules.value%type);
39:
40: --The table type for passing rules
41: TYPE Rules_tbl_type IS table of Rules_rec_type INDEX BY BINARY_INTEGER;

Line 38: value iem_route_rules.value%type);

34: --The record type for passing rules
35: TYPE Rules_rec_type is RECORD (
36: key iem_route_rules.key_type_code%type,
37: operator iem_route_rules.operator_type_code%type,
38: value iem_route_rules.value%type);
39:
40: --The table type for passing rules
41: TYPE Rules_tbl_type IS table of Rules_rec_type INDEX BY BINARY_INTEGER;
42:

Line 55: keyToFind iem_route_rules.key_type_code%type;

51:
52: x number := 1;
53: y number := 1;
54:
55: keyToFind iem_route_rules.key_type_code%type;
56: operator iem_route_rules.operator_type_code%type;
57: valueToFind iem_route_rules.value%type;
58:
59: foundKey Boolean;

Line 56: operator iem_route_rules.operator_type_code%type;

52: x number := 1;
53: y number := 1;
54:
55: keyToFind iem_route_rules.key_type_code%type;
56: operator iem_route_rules.operator_type_code%type;
57: valueToFind iem_route_rules.value%type;
58:
59: foundKey Boolean;
60: foundKeyValue Boolean;

Line 57: valueToFind iem_route_rules.value%type;

53: y number := 1;
54:
55: keyToFind iem_route_rules.key_type_code%type;
56: operator iem_route_rules.operator_type_code%type;
57: valueToFind iem_route_rules.value%type;
58:
59: foundKey Boolean;
60: foundKeyValue Boolean;
61:

Line 130: keyToFind iem_route_rules.key_type_code%type;

126:
127: x number := 1;
128: y number := 1;
129:
130: keyToFind iem_route_rules.key_type_code%type;
131: operator iem_route_rules.operator_type_code%type;
132: valueToFind iem_route_rules.value%type;
133:
134: foundKeyValue Boolean;

Line 131: operator iem_route_rules.operator_type_code%type;

127: x number := 1;
128: y number := 1;
129:
130: keyToFind iem_route_rules.key_type_code%type;
131: operator iem_route_rules.operator_type_code%type;
132: valueToFind iem_route_rules.value%type;
133:
134: foundKeyValue Boolean;
135:

Line 132: valueToFind iem_route_rules.value%type;

128: y number := 1;
129:
130: keyToFind iem_route_rules.key_type_code%type;
131: operator iem_route_rules.operator_type_code%type;
132: valueToFind iem_route_rules.value%type;
133:
134: foundKeyValue Boolean;
135:
136: numberOfKeys Number;

Line 359: iem_route_rules

355: key_type_code,
356: operator_type_code,
357: value
358: from
359: iem_route_rules
360: where
361: route_id = p_route_id;
362:
363:

Line 371: returnParamType iem_route_rules.key_type_code%type;

367: routeSatisfied Boolean := false;
368: enabledFlag varchar(1):= 'Y';
369: booleanTypeCode iem_routes.boolean_type_code%type;
370: procedureName iem_routes.procedure_name%type;
371: returnParamType iem_route_rules.key_type_code%type;
372: runTimeSuccess Boolean := true;
373: l_agent_id VARCHAR2(256);
374: all_email VARCHAR2(1);
375: l_msg_id VARCHAR2(15);