DBA Data[Home] [Help]

APPS.IEM_RULES_ENGINE_PUB dependencies on IEM_ROUTE_PUB

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

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

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

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

Line 193: p_keyVals_tbl IN IEM_ROUTE_PUB.keyVals_tbl_type,

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

Line 367: l_subject := IEM_ROUTE_PUB.get_key_value

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

Line 405: l_service_request_id := IEM_ROUTE_PUB.get_key_value

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

Line 541: l_subject := IEM_ROUTE_PUB.get_key_value

537: --- PK
538: if l_action = 'AUTOCREATESR' then
539:
540: --Check if Tag exists
541: l_subject := IEM_ROUTE_PUB.get_key_value
542: ( p_keyVals_tbl=>p_keyVals_tbl,
543: p_key_name=>'IEMSSUBJECT');
544:
545: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

Line 581: l_service_request_id := IEM_ROUTE_PUB.get_key_value

577: -- end if; -- AUTOCREATESR commented by Ranjan
578:
579: --Check if SR id is null or not
580: elsif l_action = 'UPDSERVICEREQID' then -- convert if to elsif by ranjan
581: l_service_request_id := IEM_ROUTE_PUB.get_key_value
582: ( p_keyVals_tbl=>p_keyVals_tbl,
583: p_key_name=>'IEMNBZTSRVSRID');
584:
585: if is_valid( l_service_request_id )= FND_API.G_TRUE then

Line 689: l_subject := IEM_ROUTE_PUB.get_key_value

685: --- PK
686: if l_action = 'AUTOCREATESR' then
687:
688: --Check if Tag exists
689: l_subject := IEM_ROUTE_PUB.get_key_value
690: ( p_keyVals_tbl=>p_keyVals_tbl,
691: p_key_name=>'IEMSSUBJECT');
692:
693: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

Line 728: l_service_request_id := IEM_ROUTE_PUB.get_key_value

724: end if;
725:
726: --Check if SR id is null or not
727: elsif l_action = 'UPDSERVICEREQID' then
728: l_service_request_id := IEM_ROUTE_PUB.get_key_value
729: ( p_keyVals_tbl=>p_keyVals_tbl,
730: p_key_name=>'IEMNBZTSRVSRID');
731:
732: if is_valid( l_service_request_id )= FND_API.G_TRUE then