eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_ENGINE

Line 43: wf_engine.GetItemAttrNumber ( itemtype => itemType,

39: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
40: END IF;
41:
42: l_error_number:=
43: wf_engine.GetItemAttrNumber ( itemtype => itemType,
44: itemkey => itemkey,
45: aname => 'DOC_MGR_ERROR_NUM');
46:
47: l_progress := 'Is_Document_Manager_Error_1_2: 002 - '||

Line 103: wf_engine.GetItemAttrNumber ( itemtype => itemType,

99: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
100: END IF;
101:
102: l_approval_list_header_id:=
103: wf_engine.GetItemAttrNumber ( itemtype => itemType,
104: itemkey => itemkey,
105: aname => 'APPROVAL_LIST_HEADER_ID');
106:
107: l_progress := 'Does_Approval_List_Exist: 002 - '||

Line 174: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

170: IF (g_po_wf_debug = 'Y') THEN
171: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
172: END IF;
173:
174: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'DOCUMENT_ID');
177:
178: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 178: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

174: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'DOCUMENT_ID');
177:
178: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'DOCUMENT_TYPE');
181:
182: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 182: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

178: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'DOCUMENT_TYPE');
181:
182: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
183: itemkey => itemkey,
184: aname => 'DOCUMENT_SUBTYPE');
185:
186: -- Set the multi-org context

Line 188: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

184: aname => 'DOCUMENT_SUBTYPE');
185:
186: -- Set the multi-org context
187:
188: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'ORG_ID');
191:
192: IF l_org_id is NOT NULL THEN

Line 225: wf_engine.SetItemAttrNumber ( itemtype => itemType,

221: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
222: END IF;
223:
224: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
225: wf_engine.SetItemAttrNumber ( itemtype => itemType,
226: itemkey => itemkey,
227: aname => 'APPROVAL_LIST_HEADER_ID',
228: avalue => l_approval_list_header_id);
229:

Line 326: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

322: IF (g_po_wf_debug = 'Y') THEN
323: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
324: END IF;
325:
326: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'DOCUMENT_ID');
329:
330: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 330: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

326: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'DOCUMENT_ID');
329:
330: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'DOCUMENT_TYPE');
333:
334: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 334: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

330: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'DOCUMENT_TYPE');
333:
334: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'DOCUMENT_SUBTYPE');
337:
338: l_progress := 'Build_Default_Approval_list: 002-'||

Line 345: l_preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

341: IF (g_po_wf_debug = 'Y') THEN
342: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
343: END IF;
344:
345: l_preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'PREPARER_ID');
348:
349: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 349: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

345: l_preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'PREPARER_ID');
348:
349: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'APPROVAL_PATH_ID');
352:
353: l_first_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 353: l_first_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

349: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'APPROVAL_PATH_ID');
352:
353: l_first_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'FORWARD_TO_ID');
356:
357: --Bug 3246530. The approval Authority should be verified for Approver not Preparer.

Line 363: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

359: ItemKey => itemkey,
360: aname => 'APPROVER_EMPID');
361: -- Set the multi-org context
362:
363: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'ORG_ID');
366:
367: IF l_org_id is NOT NULL THEN

Line 447: wf_engine.SetItemAttrNumber(itemtype => itemType,

443: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
444: END IF;
445:
446: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
447: wf_engine.SetItemAttrNumber(itemtype => itemType,
448: itemkey => itemkey,
449: aname => 'APPROVAL_LIST_HEADER_ID',
450: avalue => l_approval_list_header_id);
451: ELSE

Line 563: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

559: IF (g_po_wf_debug = 'Y') THEN
560: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
561: END IF;
562:
563: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
564: itemkey => itemkey,
565: aname => 'DOCUMENT_ID');
566:
567: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 567: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

563: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
564: itemkey => itemkey,
565: aname => 'DOCUMENT_ID');
566:
567: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'DOCUMENT_TYPE');
570:
571: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 571: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

567: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'DOCUMENT_TYPE');
570:
571: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'DOCUMENT_SUBTYPE');
574:
575: -- Set the multi-org context

Line 577: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

573: aname => 'DOCUMENT_SUBTYPE');
574:
575: -- Set the multi-org context
576:
577: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'ORG_ID');
580:
581: IF l_org_id is NOT NULL THEN

Line 610: wf_engine.SetItemAttrNumber ( itemtype => itemType,

606: END IF;
607:
608:
609: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN
610: wf_engine.SetItemAttrNumber ( itemtype => itemType,
611: itemkey => itemkey,
612: aname => 'APPROVAL_LIST_HEADER_ID',
613: avalue => l_approval_list_header_id);
614:

Line 679: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

675: IF (g_po_wf_debug = 'Y') THEN
676: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
677: END IF;
678:
679: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
680: itemkey => itemkey,
681: aname => 'DOCUMENT_ID');
682:
683: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 683: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

679: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
680: itemkey => itemkey,
681: aname => 'DOCUMENT_ID');
682:
683: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'DOCUMENT_TYPE');
686:
687: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 687: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

683: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'DOCUMENT_TYPE');
686:
687: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'DOCUMENT_SUBTYPE');
690:
691: -- Set the multi-org context

Line 693: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

689: aname => 'DOCUMENT_SUBTYPE');
690:
691: -- Set the multi-org context
692:
693: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
694: itemkey => itemkey,
695: aname => 'ORG_ID');
696:
697: IF l_org_id is NOT NULL THEN

Line 725: wf_engine.SetItemAttrNumber ( itemtype => itemType,

721: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
722: END IF;
723:
724: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN
725: wf_engine.SetItemAttrNumber ( itemtype => itemType,
726: itemkey => itemkey,
727: aname => 'APPROVAL_LIST_HEADER_ID',
728: avalue => l_approval_list_header_id);
729:

Line 795: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

791: IF (g_po_wf_debug = 'Y') THEN
792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
793: END IF;
794:
795: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'DOCUMENT_ID');
798:
799: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 799: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

795: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'DOCUMENT_ID');
798:
799: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'DOCUMENT_TYPE');
802:
803: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 803: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

799: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'DOCUMENT_TYPE');
802:
803: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
804: itemkey => itemkey,
805: aname => 'DOCUMENT_SUBTYPE');
806:
807: -- Set the multi-org context

Line 809: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

805: aname => 'DOCUMENT_SUBTYPE');
806:
807: -- Set the multi-org context
808:
809: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
810: itemkey => itemkey,
811: aname => 'ORG_ID');
812:
813: IF l_org_id is NOT NULL THEN

Line 842: wf_engine.SetItemAttrNumber ( itemtype => itemType,

838: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
839: END IF;
840:
841: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN
842: wf_engine.SetItemAttrNumber ( itemtype => itemType,
843: itemkey => itemkey,
844: aname => 'APPROVAL_LIST_HEADER_ID',
845: avalue => l_approval_list_header_id);
846:

Line 916: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

912: IF (g_po_wf_debug = 'Y') THEN
913: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
914: END IF;
915:
916: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
917: itemkey => itemkey,
918: aname => 'DOCUMENT_ID');
919:
920: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 920: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

916: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
917: itemkey => itemkey,
918: aname => 'DOCUMENT_ID');
919:
920: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
921: itemkey => itemkey,
922: aname => 'DOCUMENT_TYPE');
923:
924: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 924: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

920: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
921: itemkey => itemkey,
922: aname => 'DOCUMENT_TYPE');
923:
924: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
925: itemkey => itemkey,
926: aname => 'DOCUMENT_SUBTYPE');
927:
928: -- Set the multi-org context

Line 930: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

926: aname => 'DOCUMENT_SUBTYPE');
927:
928: -- Set the multi-org context
929:
930: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
931: itemkey => itemkey,
932: aname => 'ORG_ID');
933:
934: IF l_org_id is NOT NULL THEN

Line 965: wf_engine.SetItemAttrNumber ( itemtype => itemType,

961:
962: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
963:
964:
965: wf_engine.SetItemAttrNumber ( itemtype => itemType,
966: itemkey => itemkey,
967: aname => 'APPROVER_EMPID',
968: avalue => l_next_approver_id);
969:

Line 970: wf_engine.SetItemAttrNumber ( itemtype => itemType,

966: itemkey => itemkey,
967: aname => 'APPROVER_EMPID',
968: avalue => l_next_approver_id);
969:
970: wf_engine.SetItemAttrNumber ( itemtype => itemType,
971: itemkey => itemkey,
972: aname => 'FORWARD_TO_ID',
973: avalue => l_next_approver_id);
974:

Line 988: wf_engine.SetItemAttrText( itemtype => itemType,

984: IF (g_po_wf_debug = 'Y') THEN
985: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
986: END IF;
987:
988: wf_engine.SetItemAttrText( itemtype => itemType,
989: itemkey => itemkey,
990: aname => 'APPROVER_USER_NAME' ,
991: avalue => l_next_approver_user_name);
992:

Line 993: wf_engine.SetItemAttrText( itemtype => itemType,

989: itemkey => itemkey,
990: aname => 'APPROVER_USER_NAME' ,
991: avalue => l_next_approver_user_name);
992:
993: wf_engine.SetItemAttrText( itemtype => itemType,
994: itemkey => itemkey,
995: aname => 'APPROVER_DISPLAY_NAME' ,
996: avalue => l_next_approver_disp_name);
997:

Line 998: wf_engine.SetItemAttrText( itemtype => itemType,

994: itemkey => itemkey,
995: aname => 'APPROVER_DISPLAY_NAME' ,
996: avalue => l_next_approver_disp_name);
997:
998: wf_engine.SetItemAttrText( itemtype => itemType,
999: itemkey => itemkey,
1000: aname => 'FORWARD_TO_USERNAME' ,
1001: avalue => l_next_approver_user_name);
1002:

Line 1003: wf_engine.SetItemAttrText( itemtype => itemType,

999: itemkey => itemkey,
1000: aname => 'FORWARD_TO_USERNAME' ,
1001: avalue => l_next_approver_user_name);
1002:
1003: wf_engine.SetItemAttrText( itemtype => itemType,
1004: itemkey => itemkey,
1005: aname => 'FORWARD_TO_DISPLAY_NAME' ,
1006: avalue => l_next_approver_disp_name);
1007:

Line 1075: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1071:
1072: IF (funcmode='RUN') THEN
1073:
1074:
1075: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1076: itemkey => itemkey,
1077: aname => 'DOCUMENT_ID');
1078:
1079: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1079: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1075: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1076: itemkey => itemkey,
1077: aname => 'DOCUMENT_ID');
1078:
1079: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'DOCUMENT_TYPE');
1082:
1083: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1083: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1079: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'DOCUMENT_TYPE');
1082:
1083: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'DOCUMENT_SUBTYPE');
1086:
1087: -- Set the multi-org context

Line 1089: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1085: aname => 'DOCUMENT_SUBTYPE');
1086:
1087: -- Set the multi-org context
1088:
1089: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1090: itemkey => itemkey,
1091: aname => 'ORG_ID');
1092:
1093: IF l_org_id is NOT NULL THEN

Line 1176: l_next_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

1172: END IF;
1173:
1174: IF (funcmode='RUN') THEN
1175:
1176: l_next_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
1177: itemkey=>itemkey,
1178: aname=>'APPROVER_EMPID');
1179:
1180: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1180: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1176: l_next_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
1177: itemkey=>itemkey,
1178: aname=>'APPROVER_EMPID');
1179:
1180: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'APPROVAL_PATH_ID');
1183:
1184: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1184: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1180: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'APPROVAL_PATH_ID');
1183:
1184: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1185: itemkey => itemkey,
1186: aname => 'DOCUMENT_ID');
1187:
1188: -- Set the multi-org context

Line 1190: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1186: aname => 'DOCUMENT_ID');
1187:
1188: -- Set the multi-org context
1189:
1190: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'ORG_ID');
1193:
1194: IF l_org_id is NOT NULL THEN

Line 1213: wf_engine.SetItemAttrText (itemtype => itemtype,

1209: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1210: END IF;
1211:
1212: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1213: wf_engine.SetItemAttrText (itemtype => itemtype,
1214: itemkey => itemkey,
1215: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1216: avalue => NULL);
1217:

Line 1219: wf_engine.SetItemAttrText (itemtype => itemtype,

1215: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1216: avalue => NULL);
1217:
1218: /* Reset the NOTE attribute */
1219: wf_engine.SetItemAttrText (itemtype => itemtype,
1220: itemkey => itemkey,
1221: aname => 'NOTE',
1222: avalue => NULL);
1223:

Line 1274: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1270: END IF;
1271:
1272: IF (funcmode='RUN') THEN
1273:
1274: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1275: itemkey => itemkey,
1276: aname => 'DOCUMENT_ID');
1277:
1278: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1278: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1274: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1275: itemkey => itemkey,
1276: aname => 'DOCUMENT_ID');
1277:
1278: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1279: itemkey => itemkey,
1280: aname => 'DOCUMENT_TYPE');
1281:
1282: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1282: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1278: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1279: itemkey => itemkey,
1280: aname => 'DOCUMENT_TYPE');
1281:
1282: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'DOCUMENT_SUBTYPE');
1285:
1286: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1286: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

1282: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'DOCUMENT_SUBTYPE');
1285:
1286: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1287: itemkey => itemkey,
1288: aname => 'NOTE');
1289:
1290: -- Set the multi-org context

Line 1292: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1288: aname => 'NOTE');
1289:
1290: -- Set the multi-org context
1291:
1292: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'ORG_ID');
1295:
1296: IF l_org_id is NOT NULL THEN

Line 1381: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1377: END IF;
1378:
1379: IF (funcmode='RUN') THEN
1380:
1381: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1382: itemkey => itemkey,
1383: aname => 'DOCUMENT_ID');
1384:
1385: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1385: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1381: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1382: itemkey => itemkey,
1383: aname => 'DOCUMENT_ID');
1384:
1385: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1386: itemkey => itemkey,
1387: aname => 'DOCUMENT_TYPE');
1388:
1389: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1389: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1385: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1386: itemkey => itemkey,
1387: aname => 'DOCUMENT_TYPE');
1388:
1389: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1390: itemkey => itemkey,
1391: aname => 'DOCUMENT_SUBTYPE');
1392:
1393: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');

Line 1397: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1393: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1394:
1395: -- Set the multi-org context
1396:
1397: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1398: itemkey => itemkey,
1399: aname => 'ORG_ID');
1400:
1401: IF l_org_id is NOT NULL THEN

Line 1483: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1479: END IF;
1480:
1481: IF (funcmode='RUN') THEN
1482:
1483: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1484: itemkey => itemkey,
1485: aname => 'DOCUMENT_ID');
1486:
1487: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1487: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1483: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1484: itemkey => itemkey,
1485: aname => 'DOCUMENT_ID');
1486:
1487: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1488: itemkey => itemkey,
1489: aname => 'DOCUMENT_TYPE');
1490:
1491: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1491: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1487: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1488: itemkey => itemkey,
1489: aname => 'DOCUMENT_TYPE');
1490:
1491: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1492: itemkey => itemkey,
1493: aname => 'DOCUMENT_SUBTYPE');
1494:
1495: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1495: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

1491: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1492: itemkey => itemkey,
1493: aname => 'DOCUMENT_SUBTYPE');
1494:
1495: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1496: itemkey => itemkey,
1497: aname => 'NOTE');
1498:
1499: -- Set the multi-org context

Line 1501: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1497: aname => 'NOTE');
1498:
1499: -- Set the multi-org context
1500:
1501: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => 'ORG_ID');
1504:
1505: IF l_org_id is NOT NULL THEN

Line 1588: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1584: END IF;
1585:
1586: IF (funcmode='RUN') THEN
1587:
1588: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1589: itemkey => itemkey,
1590: aname => 'DOCUMENT_ID');
1591:
1592: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1592: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1588: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1589: itemkey => itemkey,
1590: aname => 'DOCUMENT_ID');
1591:
1592: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1593: itemkey => itemkey,
1594: aname => 'DOCUMENT_TYPE');
1595:
1596: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1596: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1592: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1593: itemkey => itemkey,
1594: aname => 'DOCUMENT_TYPE');
1595:
1596: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1597: itemkey => itemkey,
1598: aname => 'DOCUMENT_SUBTYPE');
1599:
1600: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1600: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

1596: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1597: itemkey => itemkey,
1598: aname => 'DOCUMENT_SUBTYPE');
1599:
1600: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1601: itemkey => itemkey,
1602: aname => 'NOTE');
1603:
1604: -- Set the multi-org context

Line 1606: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1602: aname => 'NOTE');
1603:
1604: -- Set the multi-org context
1605:
1606: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'ORG_ID');
1609:
1610: IF l_org_id is NOT NULL THEN

Line 1692: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1688: END IF;
1689:
1690: IF (funcmode='RUN') THEN
1691:
1692: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1693: itemkey => itemkey,
1694: aname => 'DOCUMENT_ID');
1695:
1696: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1696: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1692: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1693: itemkey => itemkey,
1694: aname => 'DOCUMENT_ID');
1695:
1696: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'DOCUMENT_TYPE');
1699:
1700: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1700: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1696: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'DOCUMENT_TYPE');
1699:
1700: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1701: itemkey => itemkey,
1702: aname => 'DOCUMENT_SUBTYPE');
1703:
1704: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1704: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

1700: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1701: itemkey => itemkey,
1702: aname => 'DOCUMENT_SUBTYPE');
1703:
1704: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
1705: itemkey => itemkey,
1706: aname => 'NOTE');
1707:
1708: -- Set the multi-org context

Line 1710: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1706: aname => 'NOTE');
1707:
1708: -- Set the multi-org context
1709:
1710: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'ORG_ID');
1713:
1714: IF l_org_id is NOT NULL THEN

Line 1930: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1926: if exp_result = 'PO_SUCCESS_FAILURE' then
1927: retnew := TRUE;
1928: end if;
1929:
1930: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1931: itemkey => itemkey,
1932: aname => 'ORG_ID');
1933:
1934:

Line 2091: wf_engine.SetItemAttrNumber(itemtype => itemType,

2087: IF (g_po_wf_debug = 'Y') THEN
2088: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2089: END IF;
2090:
2091: wf_engine.SetItemAttrNumber(itemtype => itemType,
2092: itemkey => itemkey,
2093: aname => 'RESPONDER_ID',
2094: avalue => l_responder_id);
2095:

Line 2108: wf_engine.SetItemAttrText( itemtype => itemType,

2104: IF (g_po_wf_debug = 'Y') THEN
2105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2106: END IF;
2107:
2108: wf_engine.SetItemAttrText( itemtype => itemType,
2109: itemkey => itemkey,
2110: aname => 'RESPONDER_USER_NAME' ,
2111: avalue => l_responder_user_name);
2112:

Line 2113: wf_engine.SetItemAttrText( itemtype => itemType,

2109: itemkey => itemkey,
2110: aname => 'RESPONDER_USER_NAME' ,
2111: avalue => l_responder_user_name);
2112:
2113: wf_engine.SetItemAttrText( itemtype => itemType,
2114: itemkey => itemkey,
2115: aname => 'RESPONDER_DISPLAY_NAME' ,
2116: avalue => l_responder_disp_name);
2117:

Line 2124: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2120: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2121: END IF;
2122:
2123: IF (INSTR(l_value, 'FORWARD') > 0) THEN
2124: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2125: itemkey => itemkey,
2126: aname => 'FORWARD_TO_ID');
2127: END IF;
2128:

Line 2134: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2130: IF (g_po_wf_debug = 'Y') THEN
2131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2132: END IF;
2133:
2134: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2135: itemkey => itemkey,
2136: aname => 'DOCUMENT_ID');
2137:
2138: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2138: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2134: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2135: itemkey => itemkey,
2136: aname => 'DOCUMENT_ID');
2137:
2138: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2139: itemkey => itemkey,
2140: aname => 'DOCUMENT_TYPE');
2141:
2142: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2142: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

2138: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2139: itemkey => itemkey,
2140: aname => 'DOCUMENT_TYPE');
2141:
2142: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2143: itemkey => itemkey,
2144: aname => 'DOCUMENT_SUBTYPE');
2145:
2146: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

Line 2146: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

2142: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2143: itemkey => itemkey,
2144: aname => 'DOCUMENT_SUBTYPE');
2145:
2146: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
2147: itemkey=>itemkey,
2148: aname=>'APPROVER_EMPID');
2149:
2150: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2150: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

2146: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
2147: itemkey=>itemkey,
2148: aname=>'APPROVER_EMPID');
2149:
2150: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
2151: itemkey => itemkey,
2152: aname => 'NOTE');
2153:
2154: l_progress := 'Update_Approval_List_Response: 010 APP'||

Line 2206: wf_engine.SetItemAttrNumber(itemtype => itemType,

2202: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2203: END IF;
2204:
2205: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2206: wf_engine.SetItemAttrNumber(itemtype => itemType,
2207: itemkey => itemkey,
2208: aname => 'APPROVAL_LIST_HEADER_ID',
2209: avalue => l_approval_list_header_id);
2210:

Line 2573: wf_engine.SetItemAttrNumber(itemtype => itemType,

2569: IF (g_po_wf_debug = 'Y') THEN
2570: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2571: END IF;
2572:
2573: wf_engine.SetItemAttrNumber(itemtype => itemType,
2574: itemkey => itemkey,
2575: aname => 'RESPONDER_ID',
2576: avalue => responderId);
2577:

Line 2590: wf_engine.SetItemAttrText( itemtype => itemType,

2586: IF (g_po_wf_debug = 'Y') THEN
2587: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2588: END IF;
2589:
2590: wf_engine.SetItemAttrText( itemtype => itemType,
2591: itemkey => itemkey,
2592: aname => 'RESPONDER_USER_NAME' ,
2593: avalue => l_responder_user_name);
2594:

Line 2595: wf_engine.SetItemAttrText( itemtype => itemType,

2591: itemkey => itemkey,
2592: aname => 'RESPONDER_USER_NAME' ,
2593: avalue => l_responder_user_name);
2594:
2595: wf_engine.SetItemAttrText( itemtype => itemType,
2596: itemkey => itemkey,
2597: aname => 'RESPONDER_DISPLAY_NAME' ,
2598: avalue => l_responder_disp_name);
2599:

Line 2606: forwardToId := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2602: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2603: END IF;
2604:
2605: IF (INSTR(response, 'FORWARD') > 0) THEN
2606: forwardToId := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2607: itemkey => itemkey,
2608: aname => 'FORWARD_TO_ID');
2609: END IF;
2610:

Line 2715: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2711:
2712: -- Context Setting revamp
2713: -- set_doc_mgr_context(itemtype, itemkey);
2714:
2715: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2716: itemkey => itemkey,
2717: aname => 'ORG_ID');
2718:
2719: IF l_orgid is NOT NULL THEN

Line 2725: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2721: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2722:
2723: END IF;
2724:
2725: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2726: itemkey => itemkey,
2727: aname => 'DOCUMENT_ID');
2728:
2729: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2729: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2725: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2726: itemkey => itemkey,
2727: aname => 'DOCUMENT_ID');
2728:
2729: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2730: itemkey => itemkey,
2731: aname => 'DOCUMENT_TYPE');
2732:
2733: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2733: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

2729: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2730: itemkey => itemkey,
2731: aname => 'DOCUMENT_TYPE');
2732:
2733: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2734: itemkey => itemkey,
2735: aname => 'DOCUMENT_SUBTYPE');
2736:
2737: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

Line 2737: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

2733: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2734: itemkey => itemkey,
2735: aname => 'DOCUMENT_SUBTYPE');
2736:
2737: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
2738: itemkey=>itemkey,
2739: aname=>'APPROVER_EMPID');
2740:
2741: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2741: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,

2737: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
2738: itemkey=>itemkey,
2739: aname=>'APPROVER_EMPID');
2740:
2741: l_note := wf_engine.GetItemAttrText(itemtype => itemtype,
2742: itemkey => itemkey,
2743: aname => 'NOTE');
2744:
2745: l_progress := 'Update_App_List_Resp_Success: 010 APP'||

Line 2796: wf_engine.SetItemAttrNumber(itemtype => itemType,

2792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2793: END IF;
2794:
2795: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2796: wf_engine.SetItemAttrNumber(itemtype => itemType,
2797: itemkey => itemkey,
2798: aname => 'APPROVAL_LIST_HEADER_ID',
2799: avalue => l_approval_list_header_id);
2800:

Line 2909: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2905: IF (funcmode='RUN') THEN
2906:
2907: -- Set the multi-org context
2908:
2909: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2910: itemkey => itemkey,
2911: aname => 'ORG_ID');
2912:
2913: IF l_org_id is NOT NULL THEN

Line 2919: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2915: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
2916:
2917: END IF;
2918:
2919: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2920: itemkey => itemkey,
2921: aname => 'DOCUMENT_ID');
2922:
2923:

Line 2962: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2958: l_progress varchar2(200);
2959:
2960: BEGIN
2961:
2962: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2963: itemkey => itemkey,
2964: aname => 'USER_ID');
2965: --
2966: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2966: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2962: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2963: itemkey => itemkey,
2964: aname => 'USER_ID');
2965: --
2966: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2967: itemkey => itemkey,
2968: aname => 'APPLICATION_ID');
2969: --
2970: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2970: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2966: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2967: itemkey => itemkey,
2968: aname => 'APPLICATION_ID');
2969: --
2970: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2971: itemkey => itemkey,
2972: aname => 'RESPONSIBILITY_ID');
2973:
2974: /* Set the context for the doc manager */

Line 3091: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,

3087: END IF;
3088:
3089: IF (funcmode='RUN') THEN
3090:
3091: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
3092: itemkey=>itemkey,
3093: aname=>'APPROVER_EMPID');
3094:
3095: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 3095: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3091: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>itemtype,
3092: itemkey=>itemkey,
3093: aname=>'APPROVER_EMPID');
3094:
3095: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3096: itemkey => itemkey,
3097: aname => 'APPROVAL_PATH_ID');
3098:
3099: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 3099: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3095: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3096: itemkey => itemkey,
3097: aname => 'APPROVAL_PATH_ID');
3098:
3099: l_req_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3100: itemkey => itemkey,
3101: aname => 'DOCUMENT_ID');
3102:
3103: -- Set the multi-org context

Line 3105: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3101: aname => 'DOCUMENT_ID');
3102:
3103: -- Set the multi-org context
3104:
3105: l_org_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3106: itemkey => itemkey,
3107: aname => 'ORG_ID');
3108:
3109: IF l_org_id is NOT NULL THEN