APPS.IEM_ROUTE_PUB dependencies on IEM_ROUTES

Line 341: iem_routes a,

337: a.all_email,
338: b.destination_group_id,
339: b.default_group_id
340: from
341: iem_routes a,
342: iem_account_routes b
343: where
344: a.route_id = b.route_id
345: and

Line 352: cursor c_rules (p_route_id iem_routes.route_id%type)

348: b.email_account_id = p_account_id
349: order by b.priority;
350:
351: --All the rules for a route
352: cursor c_rules (p_route_id iem_routes.route_id%type)
353: is
354: select
355: key_type_code,
356: operator_type_code,

Line 369: booleanTypeCode iem_routes.boolean_type_code%type;

365: ruleHold Rules_tbl_type;
366: runTimekeyVals_tbl keyVals_tbl_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);

Line 370: procedureName iem_routes.procedure_name%type;

366: runTimekeyVals_tbl keyVals_tbl_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);