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_REQAPPROVAL_ACTION dependencies on WF_ENGINE

Line 199: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

195: begin
196:
197: -- check if web suppliers is installed - return FALSE if not.
198:
199: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'DOCUMENT_ID');
202:
203: x_Document_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 203: x_Document_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

199: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'DOCUMENT_ID');
202:
203: x_Document_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'DOCUMENT_TYPE');
206:
207: select vendor_contact_id, nvl(acceptance_required_flag, 'N'), acceptance_due_date, nvl(revision_num, 0)

Line 241: wf_engine.abortprocess ('POSPOACK', l_itemkey);

237:
238: if nvl(x_item_exists, 0) <> 0 then
239: begin
240: -- abort if process still active.
241: wf_engine.abortprocess ('POSPOACK', l_itemkey);
242: exception
243: when others then
244: null;
245: end;

Line 251: wf_engine.createProcess ( ItemType => l_ItemType,

247: -- purge the workflow
248: wf_purge.items( 'POSPOACK', l_itemkey);
249: end if;
250:
251: wf_engine.createProcess ( ItemType => l_ItemType,
252: ItemKey => l_ItemKey,
253: Process => 'MAIN_PROCESS');
254:
255: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

Line 255: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

251: wf_engine.createProcess ( ItemType => l_ItemType,
252: ItemKey => l_ItemKey,
253: Process => 'MAIN_PROCESS');
254:
255: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
256: itemkey => l_itemkey,
257: aname => 'DOCUMENT_ID',
258: avalue => document_id);
259:

Line 260: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

256: itemkey => l_itemkey,
257: aname => 'DOCUMENT_ID',
258: avalue => document_id);
259:
260: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
261: itemkey => l_itemkey,
262: aname => 'DOCUMENT_TYPE_CODE',
263: avalue => x_document_type);
264:

Line 265: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

261: itemkey => l_itemkey,
262: aname => 'DOCUMENT_TYPE_CODE',
263: avalue => x_document_type);
264:
265: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
266: itemkey => l_itemkey,
267: aname => 'SUPPLIER_USER_NAME',
268: avalue => x_contact_user_name);
269:

Line 270: wf_engine.SetItemAttrDate ( itemtype => l_itemtype,

266: itemkey => l_itemkey,
267: aname => 'SUPPLIER_USER_NAME',
268: avalue => x_contact_user_name);
269:
270: wf_engine.SetItemAttrDate ( itemtype => l_itemtype,
271: itemkey => l_itemkey,
272: aname => 'ACCEPTANCE_DUE_DATE',
273: avalue => x_acceptance_due_date);
274:

Line 276: wf_engine.setitemowner ( l_itemtype, l_itemkey, x_contact_user_name);

272: aname => 'ACCEPTANCE_DUE_DATE',
273: avalue => x_acceptance_due_date);
274:
275: -- set item owner.
276: wf_engine.setitemowner ( l_itemtype, l_itemkey, x_contact_user_name);
277:
278: begin
279: select (trunc(nvl(x_acceptance_due_date, sysdate)) - trunc(sysdate)) * 60
280: into x_minutes_to_acceptance

Line 285: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

281: from sys.dual;
282:
283: if x_minutes_to_acceptance is not null then
284:
285: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
286: itemkey => l_itemkey,
287: aname => 'NUM_MINUTES_TO_ACCEPTANCE',
288: avalue => x_minutes_to_acceptance);
289: end if;

Line 295: wf_engine.StartProcess ( ItemType => l_ItemType,

291: when others then
292: null;
293: end;
294:
295: wf_engine.StartProcess ( ItemType => l_ItemType,
296: ItemKey => l_ItemKey );
297: end if;
298: end if;
299:

Line 343: if (funcmode <> wf_engine.eng_run) then

339:
340:
341: -- Do nothing in cancel or timeout mode
342: --
343: if (funcmode <> wf_engine.eng_run) then
344:
345: resultout := wf_engine.eng_null;
346: return;
347:

Line 345: resultout := wf_engine.eng_null;

341: -- Do nothing in cancel or timeout mode
342: --
343: if (funcmode <> wf_engine.eng_run) then
344:
345: resultout := wf_engine.eng_null;
346: return;
347:
348: end if;
349:

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

355: code has been changed from doc mgr call to pl/sql call
356: apps_initialize internally calls set_org_context to org_id
357: that is not necessarily same as the org_id on the document */
358:
359: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
360: itemkey => itemkey,
361: aname => 'ORG_ID');
362:
363: IF l_orgid is NOT NULL THEN

Line 369: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

365: END IF;
366:
367: /* begin code to branch to check document in plsql */
368:
369: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
370: itemkey => itemkey,
371: aname => 'DOCUMENT_TYPE');
372:
373: -- Mod Project

Line 389: resultout := wf_engine.eng_completed || ':' || 'N';

385: if (not (l_mod_status = 'DRAFT' or
386: l_mod_status = 'IN PROCESS' or
387: l_mod_status = 'REJECTED' or
388: l_mod_status = 'PRE-APPROVED')) then
389: resultout := wf_engine.eng_completed || ':' || 'N';
390: x_resultout := 'N';
391: else
392: resultout := wf_engine.eng_completed || ':' || 'Y';
393: x_resultout := 'Y';

Line 392: resultout := wf_engine.eng_completed || ':' || 'Y';

388: l_mod_status = 'PRE-APPROVED')) then
389: resultout := wf_engine.eng_completed || ':' || 'N';
390: x_resultout := 'N';
391: else
392: resultout := wf_engine.eng_completed || ':' || 'Y';
393: x_resultout := 'Y';
394: end if;
395: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: MOD flow. RESULT= ' || x_resultout;
396: IF (g_po_wf_debug = 'Y') THEN

Line 406: resultout := wf_engine.eng_completed || ':' || x_resultout;

402: -- Mod Project
403:
404: if(l_doc_type = 'PA' or l_doc_type = 'PO' or l_doc_type = 'RELEASE') then
405: x_resultout := PO_APPROVAL_ACTION.po_state_check_approve(itemtype, itemkey, l_doc_type);
406: resultout := wf_engine.eng_completed || ':' || x_resultout;
407: return;
408: elsif (l_doc_type = 'REQUISITION') then
409: x_resultout := PO_APPROVAL_ACTION.req_state_check_approve(itemtype, itemkey);
410: resultout := wf_engine.eng_completed || ':' || x_resultout;

Line 410: resultout := wf_engine.eng_completed || ':' || x_resultout;

406: resultout := wf_engine.eng_completed || ':' || x_resultout;
407: return;
408: elsif (l_doc_type = 'REQUISITION') then
409: x_resultout := PO_APPROVAL_ACTION.req_state_check_approve(itemtype, itemkey);
410: resultout := wf_engine.eng_completed || ':' || x_resultout;
411: return;
412: end if;
413:
414: /* end code to branch to check document in plsql */

Line 420: resultout := wf_engine.eng_completed || ':' || 'Y';

416: l_doc_mgr_return_val := StateCheckApprove(itemtype, itemkey);
417:
418: IF l_doc_mgr_return_val = 'Y' THEN
419:
420: resultout := wf_engine.eng_completed || ':' || 'Y';
421: x_resultout := 'Y';
422:
423: ELSIF l_doc_mgr_return_val = 'N' THEN
424:

Line 425: resultout := wf_engine.eng_completed || ':' || 'N';

421: x_resultout := 'Y';
422:
423: ELSIF l_doc_mgr_return_val = 'N' THEN
424:
425: resultout := wf_engine.eng_completed || ':' || 'N';
426: x_resultout := 'N';
427:
428: ELSIF l_doc_mgr_return_val = 'F' THEN
429:

Line 484: if (funcmode <> wf_engine.eng_run) then

480:
481:
482: -- Do nothing in cancel or timeout mode
483: --
484: if (funcmode <> wf_engine.eng_run) then
485:
486: resultout := wf_engine.eng_null;
487: return;
488:

Line 486: resultout := wf_engine.eng_null;

482: -- Do nothing in cancel or timeout mode
483: --
484: if (funcmode <> wf_engine.eng_run) then
485:
486: resultout := wf_engine.eng_null;
487: return;
488:
489: end if;
490:

Line 499: resultout := wf_engine.eng_completed || ':' || 'Y';

495: l_doc_mgr_return_val := StateCheckReject(itemtype, itemkey);
496:
497: IF l_doc_mgr_return_val = 'Y' THEN
498:
499: resultout := wf_engine.eng_completed || ':' || 'Y';
500: x_resultout := 'Y';
501:
502: ELSIF l_doc_mgr_return_val = 'N' THEN
503:

Line 504: resultout := wf_engine.eng_completed || ':' || 'N';

500: x_resultout := 'Y';
501:
502: ELSIF l_doc_mgr_return_val = 'N' THEN
503:
504: resultout := wf_engine.eng_completed || ':' || 'N';
505: x_resultout := 'N';
506:
507: ELSIF l_doc_mgr_return_val = 'F' THEN
508:

Line 569: if (funcmode <> wf_engine.eng_run) then

565:
566:
567: -- Do nothing in cancel or timeout mode
568: --
569: if (funcmode <> wf_engine.eng_run) then
570:
571: resultout := wf_engine.eng_null;
572: return;
573:

Line 571: resultout := wf_engine.eng_null;

567: -- Do nothing in cancel or timeout mode
568: --
569: if (funcmode <> wf_engine.eng_run) then
570:
571: resultout := wf_engine.eng_null;
572: return;
573:
574: end if;
575:

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

582: code has been changed from doc mgr call to pl/sql call
583: apps_initialize internally calls set_org_context to org_id
584: that is not necessarily same as the org_id on the document */
585:
586: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'ORG_ID');
589:
590: IF l_orgid is NOT NULL THEN

Line 597: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

593: --
594:
595:
596: /* begin code to branch to check document in plsql */
597: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
598: itemkey => itemkey,
599: aname => 'DOCUMENT_TYPE');
600: if(l_doc_type = 'REQUISITION') then
601: x_resultout := PO_APPROVAL_ACTION.req_complete_check(itemtype, itemkey);

Line 602: resultout := wf_engine.eng_completed || ':' || x_resultout;

598: itemkey => itemkey,
599: aname => 'DOCUMENT_TYPE');
600: if(l_doc_type = 'REQUISITION') then
601: x_resultout := PO_APPROVAL_ACTION.req_complete_check(itemtype, itemkey);
602: resultout := wf_engine.eng_completed || ':' || x_resultout;
603: return;
604: end if;
605: /* end code to branch to check document in plsql */
606:

Line 619: resultout := wf_engine.eng_completed || ':' || 'Y';

615: itemkey => itemkey,
616: aname => 'BYPASS_CHECKS_FLAG',
617: avalue => 'Y');
618:
619: resultout := wf_engine.eng_completed || ':' || 'Y';
620: x_resultout := 'Y';
621:
622: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
623:

Line 624: resultout := wf_engine.eng_completed || ':' || 'N';

620: x_resultout := 'Y';
621:
622: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
623:
624: resultout := wf_engine.eng_completed || ':' || 'N';
625: x_resultout := 'N';
626:
627: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628:

Line 698: if (funcmode <> wf_engine.eng_run) then

694:
695:
696: -- Do nothing in cancel or timeout mode
697: --
698: if (funcmode <> wf_engine.eng_run) then
699:
700: resultout := wf_engine.eng_null;
701: return;
702:

Line 700: resultout := wf_engine.eng_null;

696: -- Do nothing in cancel or timeout mode
697: --
698: if (funcmode <> wf_engine.eng_run) then
699:
700: resultout := wf_engine.eng_null;
701: return;
702:
703: end if;
704:

Line 762: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

758: l_doc_mgr_return_val := ApproveDoc(itemtype, itemkey);
759:
760: IF l_doc_mgr_return_val = 'Y' THEN
761:
762: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
763: x_resultout := 'ACTIVITY_PERFORMED';
764:
765: -- check if web suppliers is installed.
766:

Line 837: if (funcmode <> wf_engine.eng_run) then

833:
834:
835: -- Do nothing in cancel or timeout mode
836: --
837: if (funcmode <> wf_engine.eng_run) then
838:
839: resultout := wf_engine.eng_null;
840: return;
841:

Line 839: resultout := wf_engine.eng_null;

835: -- Do nothing in cancel or timeout mode
836: --
837: if (funcmode <> wf_engine.eng_run) then
838:
839: resultout := wf_engine.eng_null;
840: return;
841:
842: end if;
843:

Line 858: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

854: l_doc_mgr_return_val := ApproveAndForward(itemtype, itemkey);
855:
856: IF l_doc_mgr_return_val = 'Y' THEN
857:
858: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
859: x_resultout := 'ACTIVITY_PERFORMED';
860:
861: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
862: ** this he/she is going to be the new approver.

Line 864: l_approver_user_name := wf_engine.GetItemAttrText

860:
861: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
862: ** this he/she is going to be the new approver.
863: */
864: l_approver_user_name := wf_engine.GetItemAttrText
865: ( itemtype => itemType,
866: itemkey => itemkey,
867: aname => 'FORWARD_TO_USERNAME');
868:

Line 869: l_approver_empid := wf_engine.GetItemAttrNumber

865: ( itemtype => itemType,
866: itemkey => itemkey,
867: aname => 'FORWARD_TO_USERNAME');
868:
869: l_approver_empid := wf_engine.GetItemAttrNumber
870: ( itemtype => itemType,
871: itemkey => itemkey,
872: aname => 'FORWARD_TO_ID');
873:

Line 874: l_approver_disp_name := wf_engine.GetItemAttrText

870: ( itemtype => itemType,
871: itemkey => itemkey,
872: aname => 'FORWARD_TO_ID');
873:
874: l_approver_disp_name := wf_engine.GetItemAttrText
875: ( itemtype => itemType,
876: itemkey => itemkey,
877: aname => 'FORWARD_TO_DISPLAY_NAME');
878:

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

875: ( itemtype => itemType,
876: itemkey => itemkey,
877: aname => 'FORWARD_TO_DISPLAY_NAME');
878:
879: wf_engine.SetItemAttrText ( itemtype => itemType,
880: itemkey => itemkey,
881: aname => 'APPROVER_USER_NAME' ,
882: avalue => l_approver_user_name);
883:

Line 884: wf_engine.SetItemAttrNumber (itemtype => itemtype,

880: itemkey => itemkey,
881: aname => 'APPROVER_USER_NAME' ,
882: avalue => l_approver_user_name);
883:
884: wf_engine.SetItemAttrNumber (itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'APPROVER_EMPID',
887: avalue => l_approver_empid);
888:

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

885: itemkey => itemkey,
886: aname => 'APPROVER_EMPID',
887: avalue => l_approver_empid);
888:
889: wf_engine.SetItemAttrText (itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'APPROVER_DISPLAY_NAME',
892: avalue => l_approver_disp_name);
893:

Line 955: if (funcmode <> wf_engine.eng_run) then

951:
952:
953: -- Do nothing in cancel or timeout mode
954: --
955: if (funcmode <> wf_engine.eng_run) then
956:
957: resultout := wf_engine.eng_null;
958: return;
959:

Line 957: resultout := wf_engine.eng_null;

953: -- Do nothing in cancel or timeout mode
954: --
955: if (funcmode <> wf_engine.eng_run) then
956:
957: resultout := wf_engine.eng_null;
958: return;
959:
960: end if;
961:

Line 977: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

973: l_doc_mgr_return_val := ForwardDocInProcess(itemtype, itemkey);
974:
975: IF l_doc_mgr_return_val = 'Y' THEN
976:
977: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
978: x_resultout := 'ACTIVITY_PERFORMED';
979:
980: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
981: ** this he/she is going to be the new approver.

Line 984: l_approver_user_name := wf_engine.GetItemAttrText

980: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
981: ** this he/she is going to be the new approver.
982: */
983:
984: l_approver_user_name := wf_engine.GetItemAttrText
985: ( itemtype => itemType,
986: itemkey => itemkey,
987: aname => 'FORWARD_TO_USERNAME');
988:

Line 989: l_approver_empid := wf_engine.GetItemAttrNumber

985: ( itemtype => itemType,
986: itemkey => itemkey,
987: aname => 'FORWARD_TO_USERNAME');
988:
989: l_approver_empid := wf_engine.GetItemAttrNumber
990: ( itemtype => itemType,
991: itemkey => itemkey,
992: aname => 'FORWARD_TO_ID');
993:

Line 994: l_approver_disp_name := wf_engine.GetItemAttrText

990: ( itemtype => itemType,
991: itemkey => itemkey,
992: aname => 'FORWARD_TO_ID');
993:
994: l_approver_disp_name := wf_engine.GetItemAttrText
995: ( itemtype => itemType,
996: itemkey => itemkey,
997: aname => 'FORWARD_TO_DISPLAY_NAME');
998:

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

995: ( itemtype => itemType,
996: itemkey => itemkey,
997: aname => 'FORWARD_TO_DISPLAY_NAME');
998:
999: wf_engine.SetItemAttrText ( itemtype => itemType,
1000: itemkey => itemkey,
1001: aname => 'APPROVER_USER_NAME' ,
1002: avalue => l_approver_user_name);
1003:

Line 1004: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1000: itemkey => itemkey,
1001: aname => 'APPROVER_USER_NAME' ,
1002: avalue => l_approver_user_name);
1003:
1004: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1005: itemkey => itemkey,
1006: aname => 'APPROVER_EMPID',
1007: avalue => l_approver_empid);
1008:

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

1005: itemkey => itemkey,
1006: aname => 'APPROVER_EMPID',
1007: avalue => l_approver_empid);
1008:
1009: wf_engine.SetItemAttrText (itemtype => itemtype,
1010: itemkey => itemkey,
1011: aname => 'APPROVER_DISPLAY_NAME',
1012: avalue => l_approver_disp_name);
1013:

Line 1072: if (funcmode <> wf_engine.eng_run) then

1068:
1069:
1070: -- Do nothing in cancel or timeout mode
1071: --
1072: if (funcmode <> wf_engine.eng_run) then
1073:
1074: resultout := wf_engine.eng_null;
1075: return;
1076:

Line 1074: resultout := wf_engine.eng_null;

1070: -- Do nothing in cancel or timeout mode
1071: --
1072: if (funcmode <> wf_engine.eng_run) then
1073:
1074: resultout := wf_engine.eng_null;
1075: return;
1076:
1077: end if;
1078:

Line 1092: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1088: l_doc_mgr_return_val := ForwardDocPreapproved(itemtype, itemkey);
1089:
1090: IF l_doc_mgr_return_val = 'Y' THEN
1091:
1092: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1093: x_resultout := 'ACTIVITY_PERFORMED';
1094:
1095: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
1096: ** this he/she is going to be the new approver.

Line 1098: l_approver_user_name := wf_engine.GetItemAttrText

1094:
1095: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
1096: ** this he/she is going to be the new approver.
1097: */
1098: l_approver_user_name := wf_engine.GetItemAttrText
1099: ( itemtype => itemType,
1100: itemkey => itemkey,
1101: aname => 'FORWARD_TO_USERNAME');
1102:

Line 1103: l_approver_empid := wf_engine.GetItemAttrNumber

1099: ( itemtype => itemType,
1100: itemkey => itemkey,
1101: aname => 'FORWARD_TO_USERNAME');
1102:
1103: l_approver_empid := wf_engine.GetItemAttrNumber
1104: ( itemtype => itemType,
1105: itemkey => itemkey,
1106: aname => 'FORWARD_TO_ID');
1107:

Line 1108: l_approver_disp_name := wf_engine.GetItemAttrText

1104: ( itemtype => itemType,
1105: itemkey => itemkey,
1106: aname => 'FORWARD_TO_ID');
1107:
1108: l_approver_disp_name := wf_engine.GetItemAttrText
1109: ( itemtype => itemType,
1110: itemkey => itemkey,
1111: aname => 'FORWARD_TO_DISPLAY_NAME');
1112:

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

1109: ( itemtype => itemType,
1110: itemkey => itemkey,
1111: aname => 'FORWARD_TO_DISPLAY_NAME');
1112:
1113: wf_engine.SetItemAttrText ( itemtype => itemType,
1114: itemkey => itemkey,
1115: aname => 'APPROVER_USER_NAME' ,
1116: avalue => l_approver_user_name);
1117:

Line 1118: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1114: itemkey => itemkey,
1115: aname => 'APPROVER_USER_NAME' ,
1116: avalue => l_approver_user_name);
1117:
1118: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1119: itemkey => itemkey,
1120: aname => 'APPROVER_EMPID',
1121: avalue => l_approver_empid);
1122:

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

1119: itemkey => itemkey,
1120: aname => 'APPROVER_EMPID',
1121: avalue => l_approver_empid);
1122:
1123: wf_engine.SetItemAttrText (itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'APPROVER_DISPLAY_NAME',
1126: avalue => l_approver_disp_name);
1127:

Line 1183: if (funcmode <> wf_engine.eng_run) then

1179:
1180:
1181: -- Do nothing in cancel or timeout mode
1182: --
1183: if (funcmode <> wf_engine.eng_run) then
1184:
1185: resultout := wf_engine.eng_null;
1186: return;
1187:

Line 1185: resultout := wf_engine.eng_null;

1181: -- Do nothing in cancel or timeout mode
1182: --
1183: if (funcmode <> wf_engine.eng_run) then
1184:
1185: resultout := wf_engine.eng_null;
1186: return;
1187:
1188: end if;
1189:

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

1191: -- Context Setting revamp
1192: -- set_doc_mgr_context(itemtype, itemkey);
1193:
1194: /*Bug 12360278 Reset response note*/
1195: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'DOCUMENT_TYPE');
1198: IF (l_document_type='PO' OR l_document_type='PA' OR l_document_type='RELEASE' ) THEN
1199: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

Line 1220: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;

1216: IF l_doc_mgr_return_val = 'F' THEN
1217: raise doc_manager_exception;
1218:
1219: END IF;
1220: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1221:
1222: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 02. RESULT= ' || l_doc_mgr_return_val;
1223: IF (g_po_wf_debug = 'Y') THEN
1224: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 1270: if (funcmode <> wf_engine.eng_run) then

1266:
1267:
1268: -- Do nothing in cancel or timeout mode
1269: --
1270: if (funcmode <> wf_engine.eng_run) then
1271:
1272: resultout := wf_engine.eng_null;
1273: return;
1274:

Line 1272: resultout := wf_engine.eng_null;

1268: -- Do nothing in cancel or timeout mode
1269: --
1270: if (funcmode <> wf_engine.eng_run) then
1271:
1272: resultout := wf_engine.eng_null;
1273: return;
1274:
1275: end if;
1276:

Line 1290: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;

1286: If l_doc_mgr_return_val = 'F' then
1287: raise doc_manager_exception;
1288: End if;
1289:
1290: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1291: x_resultout := l_doc_mgr_return_val;
1292:
1293:
1294: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 02. RESULT= ' || x_resultout;

Line 1341: if (funcmode <> wf_engine.eng_run) then

1337:
1338:
1339: -- Do nothing in cancel or timeout mode
1340: --
1341: if (funcmode <> wf_engine.eng_run) then
1342:
1343: resultout := wf_engine.eng_null;
1344: return;
1345:

Line 1343: resultout := wf_engine.eng_null;

1339: -- Do nothing in cancel or timeout mode
1340: --
1341: if (funcmode <> wf_engine.eng_run) then
1342:
1343: resultout := wf_engine.eng_null;
1344: return;
1345:
1346: end if;
1347:

Line 1359: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1355: ** be "Default"
1356: */
1357: IF l_doc_mgr_return_val <> 'F' THEN
1358:
1359: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1360: x_resultout := 'ACTIVITY_PERFORMED';
1361: ELSE
1362: raise doc_manager_exception;
1363:

Line 1417: if (funcmode <> wf_engine.eng_run) then

1413:
1414:
1415: -- Do nothing in cancel or timeout mode
1416: --
1417: if (funcmode <> wf_engine.eng_run) then
1418:
1419: resultout := wf_engine.eng_null;
1420: return;
1421:

Line 1419: resultout := wf_engine.eng_null;

1415: -- Do nothing in cancel or timeout mode
1416: --
1417: if (funcmode <> wf_engine.eng_run) then
1418:
1419: resultout := wf_engine.eng_null;
1420: return;
1421:
1422: end if;
1423:

Line 1424: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1420: return;
1421:
1422: end if;
1423:
1424: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => 'DOCUMENT_TYPE');
1427:
1428:

Line 1488: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;

1484: -- End if;
1485:
1486: --
1487:
1488: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1489: x_resultout := l_doc_mgr_return_val;
1490:
1491: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc 02. RESULT= ' || x_resultout;
1492: IF (g_po_wf_debug = 'Y') THEN

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

1534: BEGIN
1535:
1536: --
1537:
1538: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1539: itemkey => itemkey,
1540: aname => 'DOCUMENT_TYPE');
1541:
1542: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1538: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1539: itemkey => itemkey,
1540: aname => 'DOCUMENT_TYPE');
1541:
1542: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'DOCUMENT_SUBTYPE');
1545:
1546: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1542: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'DOCUMENT_SUBTYPE');
1545:
1546: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1547: itemkey => itemkey,
1548: aname => 'DOCUMENT_ID');
1549:
1550: x_progress := 'StateCheckApprove: calling action with: ' || 'Doc_type= ' ||

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

1631: BEGIN
1632:
1633: --
1634:
1635: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1636: itemkey => itemkey,
1637: aname => 'DOCUMENT_TYPE');
1638:
1639: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1635: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1636: itemkey => itemkey,
1637: aname => 'DOCUMENT_TYPE');
1638:
1639: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'DOCUMENT_SUBTYPE');
1642:
1643: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1639: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1640: itemkey => itemkey,
1641: aname => 'DOCUMENT_SUBTYPE');
1642:
1643: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1644: itemkey => itemkey,
1645: aname => 'DOCUMENT_ID');
1646:
1647: x_progress := 'StateCheckReject: calling action with: ' || 'Doc_type= ' ||

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

2143: BEGIN
2144:
2145: --
2146:
2147: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'DOCUMENT_TYPE');
2150:
2151: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2147: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'DOCUMENT_TYPE');
2150:
2151: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2152: itemkey => itemkey,
2153: aname => 'DOCUMENT_SUBTYPE');
2154:
2155: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2151: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2152: itemkey => itemkey,
2153: aname => 'DOCUMENT_SUBTYPE');
2154:
2155: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2156: itemkey => itemkey,
2157: aname => 'DOCUMENT_ID');
2158:
2159:

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

2156: itemkey => itemkey,
2157: aname => 'DOCUMENT_ID');
2158:
2159:
2160: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2161: itemkey => itemkey,
2162: aname => 'NOTE');
2163:
2164: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2160: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2161: itemkey => itemkey,
2162: aname => 'NOTE');
2163:
2164: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2165: itemkey => itemkey,
2166: aname => 'APPROVAL_PATH_ID');
2167:
2168:

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

2189: IF (l_ret_sts = 'S')
2190: THEN
2191:
2192: /* Keep the AUTHORIZATION_STATUS in sync with database */
2193: wf_engine.SetItemAttrText ( itemtype => itemType,
2194: itemkey => itemkey,
2195: aname => 'AUTHORIZATION_STATUS',
2196: avalue => 'APPROVED');
2197:

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

2262: ** with an action_code that is NULL and it sets the status on the
2263: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2264: */
2265:
2266: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2267: itemkey => itemkey,
2268: aname => 'DOCUMENT_TYPE');
2269:
2270: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2266: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2267: itemkey => itemkey,
2268: aname => 'DOCUMENT_TYPE');
2269:
2270: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2271: itemkey => itemkey,
2272: aname => 'DOCUMENT_SUBTYPE');
2273:
2274: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2270: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2271: itemkey => itemkey,
2272: aname => 'DOCUMENT_SUBTYPE');
2273:
2274: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2275: itemkey => itemkey,
2276: aname => 'DOCUMENT_ID');
2277:
2278:

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

2275: itemkey => itemkey,
2276: aname => 'DOCUMENT_ID');
2277:
2278:
2279: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2280: itemkey => itemkey,
2281: aname => 'NOTE');
2282:
2283: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2279: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2280: itemkey => itemkey,
2281: aname => 'NOTE');
2282:
2283: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2284: itemkey => itemkey,
2285: aname => 'APPROVAL_PATH_ID');
2286:
2287: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2283: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2284: itemkey => itemkey,
2285: aname => 'APPROVAL_PATH_ID');
2286:
2287: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2288: itemkey => itemkey,
2289: aname => 'FORWARD_TO_ID');
2290:
2291:

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

2313: -- Forward returns with only 'S' or 'U'
2314: IF (l_ret_sts = 'S') THEN
2315:
2316: /* Keep the AUTHORIZATION_STATUS in sync with database */
2317: wf_engine.SetItemAttrText ( itemtype => itemType,
2318: itemkey => itemkey,
2319: aname => 'AUTHORIZATION_STATUS',
2320: avalue => 'PRE-APPROVED');
2321:

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

2373: ** with an action_code that is NULL and it sets the status on the
2374: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).
2375: */
2376:
2377: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2378: itemkey => itemkey,
2379: aname => 'DOCUMENT_TYPE');
2380:
2381: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2377: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2378: itemkey => itemkey,
2379: aname => 'DOCUMENT_TYPE');
2380:
2381: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2382: itemkey => itemkey,
2383: aname => 'DOCUMENT_SUBTYPE');
2384:
2385: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2381: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2382: itemkey => itemkey,
2383: aname => 'DOCUMENT_SUBTYPE');
2384:
2385: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2386: itemkey => itemkey,
2387: aname => 'DOCUMENT_ID');
2388:
2389:

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

2386: itemkey => itemkey,
2387: aname => 'DOCUMENT_ID');
2388:
2389:
2390: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2391: itemkey => itemkey,
2392: aname => 'NOTE');
2393:
2394: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2390: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2391: itemkey => itemkey,
2392: aname => 'NOTE');
2393:
2394: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2395: itemkey => itemkey,
2396: aname => 'APPROVAL_PATH_ID');
2397:
2398: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2394: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2395: itemkey => itemkey,
2396: aname => 'APPROVAL_PATH_ID');
2397:
2398: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2399: itemkey => itemkey,
2400: aname => 'FORWARD_TO_ID');
2401:
2402:

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

2423: -- Forward returns with only 'S' or 'U'
2424: IF (l_ret_sts = 'S') THEN
2425:
2426: /* Keep the AUTHORIZATION_STATUS in sync with database */
2427: wf_engine.SetItemAttrText ( itemtype => itemType,
2428: itemkey => itemkey,
2429: aname => 'AUTHORIZATION_STATUS',
2430: avalue => 'IN PROCESS');
2431:

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

2484: ** with an action_code that is NULL and it sets the status on the
2485: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2486: */
2487:
2488: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2489: itemkey => itemkey,
2490: aname => 'DOCUMENT_TYPE');
2491:
2492: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2488: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2489: itemkey => itemkey,
2490: aname => 'DOCUMENT_TYPE');
2491:
2492: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2493: itemkey => itemkey,
2494: aname => 'DOCUMENT_SUBTYPE');
2495:
2496: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2492: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2493: itemkey => itemkey,
2494: aname => 'DOCUMENT_SUBTYPE');
2495:
2496: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2497: itemkey => itemkey,
2498: aname => 'DOCUMENT_ID');
2499:
2500:

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

2497: itemkey => itemkey,
2498: aname => 'DOCUMENT_ID');
2499:
2500:
2501: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2502: itemkey => itemkey,
2503: aname => 'NOTE');
2504:
2505: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2501: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2502: itemkey => itemkey,
2503: aname => 'NOTE');
2504:
2505: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2506: itemkey => itemkey,
2507: aname => 'APPROVAL_PATH_ID');
2508:
2509: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2505: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2506: itemkey => itemkey,
2507: aname => 'APPROVAL_PATH_ID');
2508:
2509: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2510: itemkey => itemkey,
2511: aname => 'FORWARD_TO_ID');
2512:
2513:

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

2534: -- Forward returns with only 'S' or 'U'
2535: IF (l_ret_sts = 'S') THEN
2536:
2537: /* Keep the AUTHORIZATION_STATUS in sync with database */
2538: wf_engine.SetItemAttrText ( itemtype => itemType,
2539: itemkey => itemkey,
2540: aname => 'AUTHORIZATION_STATUS',
2541: avalue => 'PRE-APPROVED');
2542:

Line 2597: l_caller := wf_engine.GetItemAttrText (itemtype => itemtype,

2593: BEGIN
2594:
2595: --
2596:
2597: l_caller := wf_engine.GetItemAttrText (itemtype => itemtype,
2598: itemkey => itemkey,
2599: aname => 'INTERFACE_SOURCE_CODE');
2600:
2601:

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

2598: itemkey => itemkey,
2599: aname => 'INTERFACE_SOURCE_CODE');
2600:
2601:
2602: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2603: itemkey => itemkey,
2604: aname => 'DOCUMENT_TYPE');
2605:
2606: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2602: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2603: itemkey => itemkey,
2604: aname => 'DOCUMENT_TYPE');
2605:
2606: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2607: itemkey => itemkey,
2608: aname => 'DOCUMENT_SUBTYPE');
2609:
2610: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2606: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2607: itemkey => itemkey,
2608: aname => 'DOCUMENT_SUBTYPE');
2609:
2610: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'DOCUMENT_ID');
2613:
2614:

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

2611: itemkey => itemkey,
2612: aname => 'DOCUMENT_ID');
2613:
2614:
2615: l_note :=wf_engine.GetItemAttrText (itemtype => itemtype,
2616: itemkey => itemkey,
2617: aname => 'NOTE');
2618:
2619: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2615: l_note :=wf_engine.GetItemAttrText (itemtype => itemtype,
2616: itemkey => itemkey,
2617: aname => 'NOTE');
2618:
2619: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2620: itemkey => itemkey,
2621: aname => 'APPROVAL_PATH_ID');
2622:
2623: -- CLM Apprvl

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

2680:
2681: -- Reject Succeeded
2682:
2683: /* Keep the AUTHORIZATION_STATUS in sync with database */
2684: wf_engine.SetItemAttrText ( itemtype => itemType,
2685: itemkey => itemkey,
2686: aname => 'AUTHORIZATION_STATUS',
2687: avalue => 'REJECTED');
2688:

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

2751: BEGIN
2752:
2753: --
2754:
2755: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2756: itemkey => itemkey,
2757: aname => 'DOCUMENT_TYPE');
2758:
2759: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2755: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2756: itemkey => itemkey,
2757: aname => 'DOCUMENT_TYPE');
2758:
2759: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2760: itemkey => itemkey,
2761: aname => 'DOCUMENT_SUBTYPE');
2762:
2763: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2759: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2760: itemkey => itemkey,
2761: aname => 'DOCUMENT_SUBTYPE');
2762:
2763: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2764: itemkey => itemkey,
2765: aname => 'DOCUMENT_ID');
2766:
2767: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2767: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2763: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2764: itemkey => itemkey,
2765: aname => 'DOCUMENT_ID');
2766:
2767: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2768: itemkey => itemkey,
2769: aname => 'APPROVER_EMPID');
2770:
2771: x_progress := 'VerifyAuthority: calling verify_authority with: ' || 'Doc_type= ' ||

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

2847: BEGIN
2848:
2849: --
2850:
2851: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'DOCUMENT_TYPE');
2854:
2855: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2851: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'DOCUMENT_TYPE');
2854:
2855: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2856: itemkey => itemkey,
2857: aname => 'DOCUMENT_SUBTYPE');
2858:
2859: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2855: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2856: itemkey => itemkey,
2857: aname => 'DOCUMENT_SUBTYPE');
2858:
2859: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2860: itemkey => itemkey,
2861: aname => 'DOCUMENT_ID');
2862:
2863: x_progress := 'OpenDocumentState: calling autoupdatecloseautonomous with: ' || 'Doc_type= ' ||

Line 2963: l_doc_type := wf_engine.GetItemAttrText(

2959: IF (g_po_wf_debug = 'Y') THEN
2960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2961: END IF;
2962:
2963: l_doc_type := wf_engine.GetItemAttrText(
2964: itemtype => itemtype,
2965: itemkey => itemkey,
2966: aname => 'DOCUMENT_TYPE');
2967:

Line 2968: l_doc_subtype := wf_engine.GetItemAttrText(

2964: itemtype => itemtype,
2965: itemkey => itemkey,
2966: aname => 'DOCUMENT_TYPE');
2967:
2968: l_doc_subtype := wf_engine.GetItemAttrText(
2969: itemtype => itemtype,
2970: itemkey => itemkey,
2971: aname => 'DOCUMENT_SUBTYPE');
2972:

Line 2987: l_doc_id := wf_engine.GetItemAttrNumber(

2983: return('Y');
2984:
2985: END IF;
2986:
2987: l_doc_id := wf_engine.GetItemAttrNumber(
2988: itemtype => itemtype,
2989: itemkey => itemkey,
2990: aname => 'DOCUMENT_ID');
2991:

Line 2999: l_is_ame_used := wf_engine.GetItemAttrText(

2995: END IF;
2996:
2997: IF (l_doc_type = 'REQUISITION') THEN
2998:
2999: l_is_ame_used := wf_engine.GetItemAttrText(
3000: itemtype => itemtype,
3001: itemkey => itemkey,
3002: aname => 'IS_AME_APPROVAL');
3003:

Line 3008: l_employee_id := wf_engine.GetItemAttrNumber(

3004:
3005:
3006: IF(l_is_ame_used ='Y') THEN
3007:
3008: l_employee_id := wf_engine.GetItemAttrNumber(
3009: itemtype => itemtype,
3010: itemkey => itemkey,
3011: aname => 'APPROVER_EMPID');
3012:

Line 3015: l_employee_id := wf_engine.GetItemAttrNumber(

3011: aname => 'APPROVER_EMPID');
3012:
3013: ELSE
3014:
3015: l_employee_id := wf_engine.GetItemAttrNumber(
3016: itemtype => itemtype,
3017: itemkey => itemkey,
3018: aname => 'RESPONDER_ID');
3019:

Line 3025: l_employee_id := wf_engine.GetItemAttrNumber(

3021:
3022: END IF;
3023:
3024: IF (l_employee_id IS NULL) THEN
3025: l_employee_id := wf_engine.GetItemAttrNumber(
3026: itemtype => itemtype,
3027: itemkey => itemkey,
3028: aname => 'APPROVER_EMPID');
3029: END IF;

Line 3059: wf_engine.SetItemAttrNumber(

3055:
3056: ELSIF (l_po_return_code = PO_DOCUMENT_FUNDS_PVT.g_return_WARNING) THEN
3057:
3058: -- Also set the online report id for warnings
3059: wf_engine.SetItemAttrNumber(
3060: itemtype => itemType,
3061: itemkey => itemkey,
3062: aname => 'ONLINE_REPORT_ID',
3063: avalue => l_online_report_id);

Line 3097: wf_engine.SetItemAttrNumber(

3093:
3094: ELSE
3095:
3096: -- Get the online_report_id (to be used to populate the notification
3097: wf_engine.SetItemAttrNumber(
3098: itemtype => itemType,
3099: itemkey => itemkey,
3100: aname => 'ONLINE_REPORT_ID',
3101: avalue => l_online_report_id);

Line 3226: l_document_type := wf_engine.GetItemAttrText(itemtype => itemType,

3222: , p_header_text => p_warning_header_text
3223: );
3224:
3225: --
3226: l_document_type := wf_engine.GetItemAttrText(itemtype => itemType,
3227: itemkey => itemkey,
3228: aname => 'DOCUMENT_TYPE');
3229:
3230:

Line 3329: wf_engine.SetItemAttrText (

3325: i := l_report_text_lines.NEXT(i);
3326: END LOOP;
3327:
3328: -- Set the workflow attribute to the derived attribute string.
3329: wf_engine.SetItemAttrText (
3330: itemtype => itemType,
3331: itemkey => itemkey,
3332: aname => p_attribute,
3333: avalue => substr(l_attribute_text, 1, 2000)

Line 3506: if (funcmode <> wf_engine.eng_run) then

3502: END IF;
3503:
3504: -- Do nothing in cancel or timeout mode
3505: --
3506: if (funcmode <> wf_engine.eng_run) then
3507:
3508: resultout := wf_engine.eng_null;
3509: return;
3510:

Line 3508: resultout := wf_engine.eng_null;

3504: -- Do nothing in cancel or timeout mode
3505: --
3506: if (funcmode <> wf_engine.eng_run) then
3507:
3508: resultout := wf_engine.eng_null;
3509: return;
3510:
3511: end if;
3512:

Line 3513: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

3509: return;
3510:
3511: end if;
3512:
3513: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
3514: itemkey => itemkey,
3515: aname => 'DOCUMENT_TYPE');
3516:
3517:

Line 3555: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;

3551: -- End if;
3552:
3553: --
3554:
3555: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
3556: x_resultout := l_doc_mgr_return_val;
3557:
3558: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 99';
3559: IF (g_po_wf_debug = 'Y') THEN