APPS.IEM_ROUTE_CLASS_PUB dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 206: iem_route_classifications a,

202: a.route_classification_id,
203: a.procedure_name,
204: a.boolean_type_code
205: from
206: iem_route_classifications a,
207: iem_account_route_class b
208: where
209: a.route_classification_id = b.route_classification_id
210: and

Line 219: cursor c_rules (p_route_classification_id iem_route_classifications.route_classification_id%type)

215: a.route_classification_id <> 0
216: order by b.priority;
217:
218: --All the rules for a classification
219: cursor c_rules (p_route_classification_id iem_route_classifications.route_classification_id%type)
220: is
221: select
222: key_type_code,
223: operator_type_code,

Line 235: booleanTypeCode iem_route_classifications.boolean_type_code%type;

231: x number:= 1;
232: ruleHold Rules_tbl_type;
233: classSatisfied Boolean := false;
234: enabledFlag varchar(1):= 'Y';
235: booleanTypeCode iem_route_classifications.boolean_type_code%type;
236:
237: runTimekeyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
238: procedureName iem_route_classifications.procedure_name%type;
239: returnParamType iem_route_class_rules.key_type_code%type;

Line 238: procedureName iem_route_classifications.procedure_name%type;

234: enabledFlag varchar(1):= 'Y';
235: booleanTypeCode iem_route_classifications.boolean_type_code%type;
236:
237: runTimekeyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
238: procedureName iem_route_classifications.procedure_name%type;
239: returnParamType iem_route_class_rules.key_type_code%type;
240: runTimeSuccess Boolean := true;
241:
242: l_result VARCHAR2(256);