APPS.IEM_RULES_ENGINE_PUB dependencies on IEM_ROUTE_PUB

Line 40: PROCEDURE evaluateAnd(keyVals IN iem_route_pub.keyVals_tbl_type, rules IN Rules_tbl_type, fireClass OUT NOCOPY Boolean)

36: /* PRIVATE PROCEDURES NOT AVAILABLE TO THE PUBLIC
37: ================================================*/
38:
39: /* Evaluate And conditions */
40: PROCEDURE evaluateAnd(keyVals IN iem_route_pub.keyVals_tbl_type, rules IN Rules_tbl_type, fireClass OUT NOCOPY Boolean)
41: IS
42:
43: x number := 1;
44: y number := 1;

Line 115: PROCEDURE evaluateOr(keyVals IN iem_route_pub.keyVals_tbl_type, rules IN Rules_tbl_type, fireClass OUT NOCOPY Boolean)

111: End evaluateAnd;
112:
113:
114: /* Evaluate OR conditions */
115: PROCEDURE evaluateOr(keyVals IN iem_route_pub.keyVals_tbl_type, rules IN Rules_tbl_type, fireClass OUT NOCOPY Boolean)
116: IS
117:
118: x number := 1;
119: y number := 1;

Line 191: p_keyVals_tbl IN IEM_ROUTE_PUB.keyVals_tbl_type,

187: p_api_version_number IN Number,
188: p_init_msg_list IN VARCHAR2 := null,
189: p_commit IN VARCHAR2 := null,
190: p_rule_type IN VARCHAR2,
191: p_keyVals_tbl IN IEM_ROUTE_PUB.keyVals_tbl_type,
192: p_accountId IN Number,
193: x_result OUT NOCOPY VARCHAR2,
194: x_action OUT NOCOPY Varchar2,
195: x_parameters OUT NOCOPY IEM_RULES_ENGINE_PUB.parameter_tbl_type,

Line 365: l_subject := IEM_ROUTE_PUB.get_key_value

361: --- PK
362: if l_action = 'AUTOCREATESR' then
363:
364: --Check if Tag exists
365: l_subject := IEM_ROUTE_PUB.get_key_value
366: ( p_keyVals_tbl=>p_keyVals_tbl,
367: p_key_name=>'IEMSSUBJECT');
368:
369: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

Line 402: l_service_request_id := IEM_ROUTE_PUB.get_key_value

398: end if;
399: end if;
400: --Check if SR id is null or not
401: elsif l_action = 'UPDSERVICEREQID' then
402: l_service_request_id := IEM_ROUTE_PUB.get_key_value
403: ( p_keyVals_tbl=>p_keyVals_tbl,
404: p_key_name=>'IEMNBZTSRVSRID');
405:
406: if is_valid( l_service_request_id )= FND_API.G_TRUE then

Line 536: l_subject := IEM_ROUTE_PUB.get_key_value

532: --- PK
533: if l_action = 'AUTOCREATESR' then
534:
535: --Check if Tag exists
536: l_subject := IEM_ROUTE_PUB.get_key_value
537: ( p_keyVals_tbl=>p_keyVals_tbl,
538: p_key_name=>'IEMSSUBJECT');
539:
540: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

Line 575: l_service_request_id := IEM_ROUTE_PUB.get_key_value

571: -- end if; -- AUTOCREATESR commented by Ranjan
572:
573: --Check if SR id is null or not
574: elsif l_action = 'UPDSERVICEREQID' then -- convert if to elsif by ranjan
575: l_service_request_id := IEM_ROUTE_PUB.get_key_value
576: ( p_keyVals_tbl=>p_keyVals_tbl,
577: p_key_name=>'IEMNBZTSRVSRID');
578:
579: if is_valid( l_service_request_id )= FND_API.G_TRUE then

Line 681: l_subject := IEM_ROUTE_PUB.get_key_value

677: --- PK
678: if l_action = 'AUTOCREATESR' then
679:
680: --Check if Tag exists
681: l_subject := IEM_ROUTE_PUB.get_key_value
682: ( p_keyVals_tbl=>p_keyVals_tbl,
683: p_key_name=>'IEMSSUBJECT');
684:
685: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

Line 719: l_service_request_id := IEM_ROUTE_PUB.get_key_value

715: end if;
716:
717: --Check if SR id is null or not
718: elsif l_action = 'UPDSERVICEREQID' then
719: l_service_request_id := IEM_ROUTE_PUB.get_key_value
720: ( p_keyVals_tbl=>p_keyVals_tbl,
721: p_key_name=>'IEMNBZTSRVSRID');
722:
723: if is_valid( l_service_request_id )= FND_API.G_TRUE then