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 194: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

190: begin
191:
192: -- check if web suppliers is installed - return FALSE if not.
193:
194: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
195: itemkey => itemkey,
196: aname => 'DOCUMENT_ID');
197:
198: x_Document_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

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

194: Document_Id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
195: itemkey => itemkey,
196: aname => 'DOCUMENT_ID');
197:
198: x_Document_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
199: itemkey => itemkey,
200: aname => 'DOCUMENT_TYPE');
201:
202: select vendor_contact_id, nvl(acceptance_required_flag, 'N'), acceptance_due_date, nvl(revision_num, 0)

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

232:
233: if nvl(x_item_exists, 0) <> 0 then
234: begin
235: -- abort if process still active.
236: wf_engine.abortprocess ('POSPOACK', l_itemkey);
237: exception
238: when others then
239: null;
240: end;

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

242: -- purge the workflow
243: wf_purge.items( 'POSPOACK', l_itemkey);
244: end if;
245:
246: wf_engine.createProcess ( ItemType => l_ItemType,
247: ItemKey => l_ItemKey,
248: Process => 'MAIN_PROCESS');
249:
250: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

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

246: wf_engine.createProcess ( ItemType => l_ItemType,
247: ItemKey => l_ItemKey,
248: Process => 'MAIN_PROCESS');
249:
250: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
251: itemkey => l_itemkey,
252: aname => 'DOCUMENT_ID',
253: avalue => document_id);
254:

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

251: itemkey => l_itemkey,
252: aname => 'DOCUMENT_ID',
253: avalue => document_id);
254:
255: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
256: itemkey => l_itemkey,
257: aname => 'DOCUMENT_TYPE_CODE',
258: avalue => x_document_type);
259:

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

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

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

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

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

267: aname => 'ACCEPTANCE_DUE_DATE',
268: avalue => x_acceptance_due_date);
269:
270: -- set item owner.
271: wf_engine.setitemowner ( l_itemtype, l_itemkey, x_contact_user_name);
272:
273: begin
274: select (trunc(nvl(x_acceptance_due_date, sysdate)) - trunc(sysdate)) * 60
275: into x_minutes_to_acceptance

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

276: from sys.dual;
277:
278: if x_minutes_to_acceptance is not null then
279:
280: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
281: itemkey => l_itemkey,
282: aname => 'NUM_MINUTES_TO_ACCEPTANCE',
283: avalue => x_minutes_to_acceptance);
284: end if;

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

286: when others then
287: null;
288: end;
289:
290: wf_engine.StartProcess ( ItemType => l_ItemType,
291: ItemKey => l_ItemKey );
292: end if;
293: end if;
294:

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

330:
331:
332: -- Do nothing in cancel or timeout mode
333: --
334: if (funcmode <> wf_engine.eng_run) then
335:
336: resultout := wf_engine.eng_null;
337: return;
338:

Line 336: resultout := wf_engine.eng_null;

332: -- Do nothing in cancel or timeout mode
333: --
334: if (funcmode <> wf_engine.eng_run) then
335:
336: resultout := wf_engine.eng_null;
337: return;
338:
339: end if;
340:

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

346: code has been changed from doc mgr call to pl/sql call
347: apps_initialize internally calls set_org_context to org_id
348: that is not necessarily same as the org_id on the document */
349:
350: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'ORG_ID');
353:
354: IF l_orgid is NOT NULL THEN

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

356: END IF;
357:
358: /* begin code to branch to check document in plsql */
359:
360: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'DOCUMENT_TYPE');
363: if(l_doc_type = 'PA' or l_doc_type = 'PO' or l_doc_type = 'RELEASE') then
364: x_resultout := PO_APPROVAL_ACTION.po_state_check_approve(itemtype, itemkey, l_doc_type);

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

361: itemkey => itemkey,
362: aname => 'DOCUMENT_TYPE');
363: if(l_doc_type = 'PA' or l_doc_type = 'PO' or l_doc_type = 'RELEASE') then
364: x_resultout := PO_APPROVAL_ACTION.po_state_check_approve(itemtype, itemkey, l_doc_type);
365: resultout := wf_engine.eng_completed || ':' || x_resultout;
366: return;
367: elsif (l_doc_type = 'REQUISITION') then
368: x_resultout := PO_APPROVAL_ACTION.req_state_check_approve(itemtype, itemkey);
369: resultout := wf_engine.eng_completed || ':' || x_resultout;

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

365: resultout := wf_engine.eng_completed || ':' || x_resultout;
366: return;
367: elsif (l_doc_type = 'REQUISITION') then
368: x_resultout := PO_APPROVAL_ACTION.req_state_check_approve(itemtype, itemkey);
369: resultout := wf_engine.eng_completed || ':' || x_resultout;
370: return;
371: end if;
372:
373: /* end code to branch to check document in plsql */

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

375: l_doc_mgr_return_val := StateCheckApprove(itemtype, itemkey);
376:
377: IF l_doc_mgr_return_val = 'Y' THEN
378:
379: resultout := wf_engine.eng_completed || ':' || 'Y';
380: x_resultout := 'Y';
381:
382: ELSIF l_doc_mgr_return_val = 'N' THEN
383:

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

380: x_resultout := 'Y';
381:
382: ELSIF l_doc_mgr_return_val = 'N' THEN
383:
384: resultout := wf_engine.eng_completed || ':' || 'N';
385: x_resultout := 'N';
386:
387: ELSIF l_doc_mgr_return_val = 'F' THEN
388:

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

439:
440:
441: -- Do nothing in cancel or timeout mode
442: --
443: if (funcmode <> wf_engine.eng_run) then
444:
445: resultout := wf_engine.eng_null;
446: return;
447:

Line 445: resultout := wf_engine.eng_null;

441: -- Do nothing in cancel or timeout mode
442: --
443: if (funcmode <> wf_engine.eng_run) then
444:
445: resultout := wf_engine.eng_null;
446: return;
447:
448: end if;
449:

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

454: l_doc_mgr_return_val := StateCheckReject(itemtype, itemkey);
455:
456: IF l_doc_mgr_return_val = 'Y' THEN
457:
458: resultout := wf_engine.eng_completed || ':' || 'Y';
459: x_resultout := 'Y';
460:
461: ELSIF l_doc_mgr_return_val = 'N' THEN
462:

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

459: x_resultout := 'Y';
460:
461: ELSIF l_doc_mgr_return_val = 'N' THEN
462:
463: resultout := wf_engine.eng_completed || ':' || 'N';
464: x_resultout := 'N';
465:
466: ELSIF l_doc_mgr_return_val = 'F' THEN
467:

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

524:
525:
526: -- Do nothing in cancel or timeout mode
527: --
528: if (funcmode <> wf_engine.eng_run) then
529:
530: resultout := wf_engine.eng_null;
531: return;
532:

Line 530: resultout := wf_engine.eng_null;

526: -- Do nothing in cancel or timeout mode
527: --
528: if (funcmode <> wf_engine.eng_run) then
529:
530: resultout := wf_engine.eng_null;
531: return;
532:
533: end if;
534:

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

541: code has been changed from doc mgr call to pl/sql call
542: apps_initialize internally calls set_org_context to org_id
543: that is not necessarily same as the org_id on the document */
544:
545: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
546: itemkey => itemkey,
547: aname => 'ORG_ID');
548:
549: IF l_orgid is NOT NULL THEN

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

552: --
553:
554:
555: /* begin code to branch to check document in plsql */
556: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
557: itemkey => itemkey,
558: aname => 'DOCUMENT_TYPE');
559: if(l_doc_type = 'REQUISITION') then
560: x_resultout := PO_APPROVAL_ACTION.req_complete_check(itemtype, itemkey);

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

557: itemkey => itemkey,
558: aname => 'DOCUMENT_TYPE');
559: if(l_doc_type = 'REQUISITION') then
560: x_resultout := PO_APPROVAL_ACTION.req_complete_check(itemtype, itemkey);
561: resultout := wf_engine.eng_completed || ':' || x_resultout;
562: return;
563: end if;
564: /* end code to branch to check document in plsql */
565:

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

572: l_doc_mgr_return_val := DocCompleteCheck(itemtype, itemkey);
573:
574: IF l_doc_mgr_return_val = 'Y' THEN
575:
576: resultout := wf_engine.eng_completed || ':' || 'Y';
577: x_resultout := 'Y';
578:
579: ELSIF l_doc_mgr_return_val = 'N' THEN
580:

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

577: x_resultout := 'Y';
578:
579: ELSIF l_doc_mgr_return_val = 'N' THEN
580:
581: resultout := wf_engine.eng_completed || ':' || 'N';
582: x_resultout := 'N';
583:
584: ELSIF l_doc_mgr_return_val = 'F' THEN
585:

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

593: l_sub_check_status := DocCompleteCheck(itemtype, itemkey);
594:
595: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
596:
597: resultout := wf_engine.eng_completed || ':' || 'Y';
598: x_resultout := 'Y';
599:
600: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
601:

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

598: x_resultout := 'Y';
599:
600: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
601:
602: resultout := wf_engine.eng_completed || ':' || 'N';
603: x_resultout := 'N';
604:
605: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606:

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

668:
669:
670: -- Do nothing in cancel or timeout mode
671: --
672: if (funcmode <> wf_engine.eng_run) then
673:
674: resultout := wf_engine.eng_null;
675: return;
676:

Line 674: resultout := wf_engine.eng_null;

670: -- Do nothing in cancel or timeout mode
671: --
672: if (funcmode <> wf_engine.eng_run) then
673:
674: resultout := wf_engine.eng_null;
675: return;
676:
677: end if;
678:

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

706: l_doc_mgr_return_val := ApproveDoc(itemtype, itemkey);
707:
708: IF l_doc_mgr_return_val = 'Y' THEN
709:
710: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
711: x_resultout := 'ACTIVITY_PERFORMED';
712:
713: -- check if web suppliers is installed.
714:

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

781:
782:
783: -- Do nothing in cancel or timeout mode
784: --
785: if (funcmode <> wf_engine.eng_run) then
786:
787: resultout := wf_engine.eng_null;
788: return;
789:

Line 787: resultout := wf_engine.eng_null;

783: -- Do nothing in cancel or timeout mode
784: --
785: if (funcmode <> wf_engine.eng_run) then
786:
787: resultout := wf_engine.eng_null;
788: return;
789:
790: end if;
791:

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

796: l_doc_mgr_return_val := ApproveAndForward(itemtype, itemkey);
797:
798: IF l_doc_mgr_return_val = 'Y' THEN
799:
800: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
801: x_resultout := 'ACTIVITY_PERFORMED';
802:
803: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
804: ** this he/she is going to be the new approver.

Line 806: l_approver_user_name := wf_engine.GetItemAttrText

802:
803: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
804: ** this he/she is going to be the new approver.
805: */
806: l_approver_user_name := wf_engine.GetItemAttrText
807: ( itemtype => itemType,
808: itemkey => itemkey,
809: aname => 'FORWARD_TO_USERNAME');
810:

Line 811: l_approver_empid := wf_engine.GetItemAttrNumber

807: ( itemtype => itemType,
808: itemkey => itemkey,
809: aname => 'FORWARD_TO_USERNAME');
810:
811: l_approver_empid := wf_engine.GetItemAttrNumber
812: ( itemtype => itemType,
813: itemkey => itemkey,
814: aname => 'FORWARD_TO_ID');
815:

Line 816: l_approver_disp_name := wf_engine.GetItemAttrText

812: ( itemtype => itemType,
813: itemkey => itemkey,
814: aname => 'FORWARD_TO_ID');
815:
816: l_approver_disp_name := wf_engine.GetItemAttrText
817: ( itemtype => itemType,
818: itemkey => itemkey,
819: aname => 'FORWARD_TO_DISPLAY_NAME');
820:

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

817: ( itemtype => itemType,
818: itemkey => itemkey,
819: aname => 'FORWARD_TO_DISPLAY_NAME');
820:
821: wf_engine.SetItemAttrText ( itemtype => itemType,
822: itemkey => itemkey,
823: aname => 'APPROVER_USER_NAME' ,
824: avalue => l_approver_user_name);
825:

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

822: itemkey => itemkey,
823: aname => 'APPROVER_USER_NAME' ,
824: avalue => l_approver_user_name);
825:
826: wf_engine.SetItemAttrNumber (itemtype => itemtype,
827: itemkey => itemkey,
828: aname => 'APPROVER_EMPID',
829: avalue => l_approver_empid);
830:

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

827: itemkey => itemkey,
828: aname => 'APPROVER_EMPID',
829: avalue => l_approver_empid);
830:
831: wf_engine.SetItemAttrText (itemtype => itemtype,
832: itemkey => itemkey,
833: aname => 'APPROVER_DISPLAY_NAME',
834: avalue => l_approver_disp_name);
835:

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

893:
894:
895: -- Do nothing in cancel or timeout mode
896: --
897: if (funcmode <> wf_engine.eng_run) then
898:
899: resultout := wf_engine.eng_null;
900: return;
901:

Line 899: resultout := wf_engine.eng_null;

895: -- Do nothing in cancel or timeout mode
896: --
897: if (funcmode <> wf_engine.eng_run) then
898:
899: resultout := wf_engine.eng_null;
900: return;
901:
902: end if;
903:

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

909: l_doc_mgr_return_val := ForwardDocInProcess(itemtype, itemkey);
910:
911: IF l_doc_mgr_return_val = 'Y' THEN
912:
913: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
914: x_resultout := 'ACTIVITY_PERFORMED';
915:
916: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
917: ** this he/she is going to be the new approver.

Line 920: l_approver_user_name := wf_engine.GetItemAttrText

916: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
917: ** this he/she is going to be the new approver.
918: */
919:
920: l_approver_user_name := wf_engine.GetItemAttrText
921: ( itemtype => itemType,
922: itemkey => itemkey,
923: aname => 'FORWARD_TO_USERNAME');
924:

Line 925: l_approver_empid := wf_engine.GetItemAttrNumber

921: ( itemtype => itemType,
922: itemkey => itemkey,
923: aname => 'FORWARD_TO_USERNAME');
924:
925: l_approver_empid := wf_engine.GetItemAttrNumber
926: ( itemtype => itemType,
927: itemkey => itemkey,
928: aname => 'FORWARD_TO_ID');
929:

Line 930: l_approver_disp_name := wf_engine.GetItemAttrText

926: ( itemtype => itemType,
927: itemkey => itemkey,
928: aname => 'FORWARD_TO_ID');
929:
930: l_approver_disp_name := wf_engine.GetItemAttrText
931: ( itemtype => itemType,
932: itemkey => itemkey,
933: aname => 'FORWARD_TO_DISPLAY_NAME');
934:

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

931: ( itemtype => itemType,
932: itemkey => itemkey,
933: aname => 'FORWARD_TO_DISPLAY_NAME');
934:
935: wf_engine.SetItemAttrText ( itemtype => itemType,
936: itemkey => itemkey,
937: aname => 'APPROVER_USER_NAME' ,
938: avalue => l_approver_user_name);
939:

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

936: itemkey => itemkey,
937: aname => 'APPROVER_USER_NAME' ,
938: avalue => l_approver_user_name);
939:
940: wf_engine.SetItemAttrNumber (itemtype => itemtype,
941: itemkey => itemkey,
942: aname => 'APPROVER_EMPID',
943: avalue => l_approver_empid);
944:

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

941: itemkey => itemkey,
942: aname => 'APPROVER_EMPID',
943: avalue => l_approver_empid);
944:
945: wf_engine.SetItemAttrText (itemtype => itemtype,
946: itemkey => itemkey,
947: aname => 'APPROVER_DISPLAY_NAME',
948: avalue => l_approver_disp_name);
949:

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

1004:
1005:
1006: -- Do nothing in cancel or timeout mode
1007: --
1008: if (funcmode <> wf_engine.eng_run) then
1009:
1010: resultout := wf_engine.eng_null;
1011: return;
1012:

Line 1010: resultout := wf_engine.eng_null;

1006: -- Do nothing in cancel or timeout mode
1007: --
1008: if (funcmode <> wf_engine.eng_run) then
1009:
1010: resultout := wf_engine.eng_null;
1011: return;
1012:
1013: end if;
1014:

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

1019: l_doc_mgr_return_val := ForwardDocPreapproved(itemtype, itemkey);
1020:
1021: IF l_doc_mgr_return_val = 'Y' THEN
1022:
1023: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1024: x_resultout := 'ACTIVITY_PERFORMED';
1025:
1026: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
1027: ** this he/she is going to be the new approver.

Line 1029: l_approver_user_name := wf_engine.GetItemAttrText

1025:
1026: /* Set the value of APPROVER_USER_NAME to the Forward-to person, since
1027: ** this he/she is going to be the new approver.
1028: */
1029: l_approver_user_name := wf_engine.GetItemAttrText
1030: ( itemtype => itemType,
1031: itemkey => itemkey,
1032: aname => 'FORWARD_TO_USERNAME');
1033:

Line 1034: l_approver_empid := wf_engine.GetItemAttrNumber

1030: ( itemtype => itemType,
1031: itemkey => itemkey,
1032: aname => 'FORWARD_TO_USERNAME');
1033:
1034: l_approver_empid := wf_engine.GetItemAttrNumber
1035: ( itemtype => itemType,
1036: itemkey => itemkey,
1037: aname => 'FORWARD_TO_ID');
1038:

Line 1039: l_approver_disp_name := wf_engine.GetItemAttrText

1035: ( itemtype => itemType,
1036: itemkey => itemkey,
1037: aname => 'FORWARD_TO_ID');
1038:
1039: l_approver_disp_name := wf_engine.GetItemAttrText
1040: ( itemtype => itemType,
1041: itemkey => itemkey,
1042: aname => 'FORWARD_TO_DISPLAY_NAME');
1043:

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

1040: ( itemtype => itemType,
1041: itemkey => itemkey,
1042: aname => 'FORWARD_TO_DISPLAY_NAME');
1043:
1044: wf_engine.SetItemAttrText ( itemtype => itemType,
1045: itemkey => itemkey,
1046: aname => 'APPROVER_USER_NAME' ,
1047: avalue => l_approver_user_name);
1048:

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

1045: itemkey => itemkey,
1046: aname => 'APPROVER_USER_NAME' ,
1047: avalue => l_approver_user_name);
1048:
1049: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'APPROVER_EMPID',
1052: avalue => l_approver_empid);
1053:

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

1050: itemkey => itemkey,
1051: aname => 'APPROVER_EMPID',
1052: avalue => l_approver_empid);
1053:
1054: wf_engine.SetItemAttrText (itemtype => itemtype,
1055: itemkey => itemkey,
1056: aname => 'APPROVER_DISPLAY_NAME',
1057: avalue => l_approver_disp_name);
1058:

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

1104:
1105:
1106: -- Do nothing in cancel or timeout mode
1107: --
1108: if (funcmode <> wf_engine.eng_run) then
1109:
1110: resultout := wf_engine.eng_null;
1111: return;
1112:

Line 1110: resultout := wf_engine.eng_null;

1106: -- Do nothing in cancel or timeout mode
1107: --
1108: if (funcmode <> wf_engine.eng_run) then
1109:
1110: resultout := wf_engine.eng_null;
1111: return;
1112:
1113: end if;
1114:

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

1121: IF l_doc_mgr_return_val = 'F' THEN
1122: raise doc_manager_exception;
1123:
1124: END IF;
1125: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1126:
1127: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 02. RESULT= ' || l_doc_mgr_return_val;
1128: IF (g_po_wf_debug = 'Y') THEN
1129: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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

1171:
1172:
1173: -- Do nothing in cancel or timeout mode
1174: --
1175: if (funcmode <> wf_engine.eng_run) then
1176:
1177: resultout := wf_engine.eng_null;
1178: return;
1179:

Line 1177: resultout := wf_engine.eng_null;

1173: -- Do nothing in cancel or timeout mode
1174: --
1175: if (funcmode <> wf_engine.eng_run) then
1176:
1177: resultout := wf_engine.eng_null;
1178: return;
1179:
1180: end if;
1181:

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

1191: If l_doc_mgr_return_val = 'F' then
1192: raise doc_manager_exception;
1193: End if;
1194:
1195: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1196: x_resultout := l_doc_mgr_return_val;
1197:
1198:
1199: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 02. RESULT= ' || x_resultout;

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

1242:
1243:
1244: -- Do nothing in cancel or timeout mode
1245: --
1246: if (funcmode <> wf_engine.eng_run) then
1247:
1248: resultout := wf_engine.eng_null;
1249: return;
1250:

Line 1248: resultout := wf_engine.eng_null;

1244: -- Do nothing in cancel or timeout mode
1245: --
1246: if (funcmode <> wf_engine.eng_run) then
1247:
1248: resultout := wf_engine.eng_null;
1249: return;
1250:
1251: end if;
1252:

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

1260: ** be "Default"
1261: */
1262: IF l_doc_mgr_return_val <> 'F' THEN
1263:
1264: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1265: x_resultout := 'ACTIVITY_PERFORMED';
1266: ELSE
1267: raise doc_manager_exception;
1268:

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

1318:
1319:
1320: -- Do nothing in cancel or timeout mode
1321: --
1322: if (funcmode <> wf_engine.eng_run) then
1323:
1324: resultout := wf_engine.eng_null;
1325: return;
1326:

Line 1324: resultout := wf_engine.eng_null;

1320: -- Do nothing in cancel or timeout mode
1321: --
1322: if (funcmode <> wf_engine.eng_run) then
1323:
1324: resultout := wf_engine.eng_null;
1325: return;
1326:
1327: end if;
1328:

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

1325: return;
1326:
1327: end if;
1328:
1329: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1330: itemkey => itemkey,
1331: aname => 'DOCUMENT_TYPE');
1332:
1333:

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

1389: -- End if;
1390:
1391: --
1392:
1393: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1394: x_resultout := l_doc_mgr_return_val;
1395:
1396: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc 02. RESULT= ' || x_resultout;
1397: IF (g_po_wf_debug = 'Y') THEN

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

1439: BEGIN
1440:
1441: --
1442:
1443: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1444: itemkey => itemkey,
1445: aname => 'DOCUMENT_TYPE');
1446:
1447: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1443: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1444: itemkey => itemkey,
1445: aname => 'DOCUMENT_TYPE');
1446:
1447: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1448: itemkey => itemkey,
1449: aname => 'DOCUMENT_SUBTYPE');
1450:
1451: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1447: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1448: itemkey => itemkey,
1449: aname => 'DOCUMENT_SUBTYPE');
1450:
1451: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1452: itemkey => itemkey,
1453: aname => 'DOCUMENT_ID');
1454:
1455: x_progress := 'StateCheckApprove: calling action with: ' || 'Doc_type= ' ||

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

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

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

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

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

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

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

1755: END IF;-- l_conterms_yn
1756:
1757: --
1758: /* Get the online_report_id (to be used to populate the notification */
1759: wf_engine.SetItemAttrNumber ( itemtype => itemType,
1760: itemkey => itemkey,
1761: aname => 'ONLINE_REPORT_ID',
1762: avalue => x_online_report_id);
1763:

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

1961: BEGIN
1962:
1963: --
1964:
1965: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1966: itemkey => itemkey,
1967: aname => 'DOCUMENT_TYPE');
1968:
1969: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

1965: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1966: itemkey => itemkey,
1967: aname => 'DOCUMENT_TYPE');
1968:
1969: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1970: itemkey => itemkey,
1971: aname => 'DOCUMENT_SUBTYPE');
1972:
1973: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1969: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1970: itemkey => itemkey,
1971: aname => 'DOCUMENT_SUBTYPE');
1972:
1973: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => 'DOCUMENT_ID');
1976:
1977:

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

1974: itemkey => itemkey,
1975: aname => 'DOCUMENT_ID');
1976:
1977:
1978: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'NOTE');
1981:
1982: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1978: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'NOTE');
1981:
1982: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1983: itemkey => itemkey,
1984: aname => 'APPROVAL_PATH_ID');
1985:
1986:

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

2007: IF (l_ret_sts = 'S')
2008: THEN
2009:
2010: /* Keep the AUTHORIZATION_STATUS in sync with database */
2011: wf_engine.SetItemAttrText ( itemtype => itemType,
2012: itemkey => itemkey,
2013: aname => 'AUTHORIZATION_STATUS',
2014: avalue => 'APPROVED');
2015:

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

2080: ** with an action_code that is NULL and it sets the status on the
2081: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2082: */
2083:
2084: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2085: itemkey => itemkey,
2086: aname => 'DOCUMENT_TYPE');
2087:
2088: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2084: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2085: itemkey => itemkey,
2086: aname => 'DOCUMENT_TYPE');
2087:
2088: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2089: itemkey => itemkey,
2090: aname => 'DOCUMENT_SUBTYPE');
2091:
2092: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2088: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2089: itemkey => itemkey,
2090: aname => 'DOCUMENT_SUBTYPE');
2091:
2092: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2093: itemkey => itemkey,
2094: aname => 'DOCUMENT_ID');
2095:
2096:

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

2093: itemkey => itemkey,
2094: aname => 'DOCUMENT_ID');
2095:
2096:
2097: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2098: itemkey => itemkey,
2099: aname => 'NOTE');
2100:
2101: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2097: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2098: itemkey => itemkey,
2099: aname => 'NOTE');
2100:
2101: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2102: itemkey => itemkey,
2103: aname => 'APPROVAL_PATH_ID');
2104:
2105: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2101: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2102: itemkey => itemkey,
2103: aname => 'APPROVAL_PATH_ID');
2104:
2105: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2106: itemkey => itemkey,
2107: aname => 'FORWARD_TO_ID');
2108:
2109:

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

2131: -- Forward returns with only 'S' or 'U'
2132: IF (l_ret_sts = 'S') THEN
2133:
2134: /* Keep the AUTHORIZATION_STATUS in sync with database */
2135: wf_engine.SetItemAttrText ( itemtype => itemType,
2136: itemkey => itemkey,
2137: aname => 'AUTHORIZATION_STATUS',
2138: avalue => 'PRE-APPROVED');
2139:

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

2191: ** with an action_code that is NULL and it sets the status on the
2192: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).
2193: */
2194:
2195: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2196: itemkey => itemkey,
2197: aname => 'DOCUMENT_TYPE');
2198:
2199: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2195: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2196: itemkey => itemkey,
2197: aname => 'DOCUMENT_TYPE');
2198:
2199: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2200: itemkey => itemkey,
2201: aname => 'DOCUMENT_SUBTYPE');
2202:
2203: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2199: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2200: itemkey => itemkey,
2201: aname => 'DOCUMENT_SUBTYPE');
2202:
2203: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2204: itemkey => itemkey,
2205: aname => 'DOCUMENT_ID');
2206:
2207:

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

2204: itemkey => itemkey,
2205: aname => 'DOCUMENT_ID');
2206:
2207:
2208: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2209: itemkey => itemkey,
2210: aname => 'NOTE');
2211:
2212: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2208: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2209: itemkey => itemkey,
2210: aname => 'NOTE');
2211:
2212: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2213: itemkey => itemkey,
2214: aname => 'APPROVAL_PATH_ID');
2215:
2216: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2212: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2213: itemkey => itemkey,
2214: aname => 'APPROVAL_PATH_ID');
2215:
2216: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2217: itemkey => itemkey,
2218: aname => 'FORWARD_TO_ID');
2219:
2220:

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

2241: -- Forward returns with only 'S' or 'U'
2242: IF (l_ret_sts = 'S') THEN
2243:
2244: /* Keep the AUTHORIZATION_STATUS in sync with database */
2245: wf_engine.SetItemAttrText ( itemtype => itemType,
2246: itemkey => itemkey,
2247: aname => 'AUTHORIZATION_STATUS',
2248: avalue => 'IN PROCESS');
2249:

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

2302: ** with an action_code that is NULL and it sets the status on the
2303: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2304: */
2305:
2306: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2307: itemkey => itemkey,
2308: aname => 'DOCUMENT_TYPE');
2309:
2310: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2306: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2307: itemkey => itemkey,
2308: aname => 'DOCUMENT_TYPE');
2309:
2310: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2311: itemkey => itemkey,
2312: aname => 'DOCUMENT_SUBTYPE');
2313:
2314: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2310: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2311: itemkey => itemkey,
2312: aname => 'DOCUMENT_SUBTYPE');
2313:
2314: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2315: itemkey => itemkey,
2316: aname => 'DOCUMENT_ID');
2317:
2318:

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

2315: itemkey => itemkey,
2316: aname => 'DOCUMENT_ID');
2317:
2318:
2319: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2320: itemkey => itemkey,
2321: aname => 'NOTE');
2322:
2323: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2319: l_note := wf_engine.GetItemAttrText (itemtype => itemtype,
2320: itemkey => itemkey,
2321: aname => 'NOTE');
2322:
2323: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2324: itemkey => itemkey,
2325: aname => 'APPROVAL_PATH_ID');
2326:
2327: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2323: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2324: itemkey => itemkey,
2325: aname => 'APPROVAL_PATH_ID');
2326:
2327: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2328: itemkey => itemkey,
2329: aname => 'FORWARD_TO_ID');
2330:
2331:

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

2352: -- Forward returns with only 'S' or 'U'
2353: IF (l_ret_sts = 'S') THEN
2354:
2355: /* Keep the AUTHORIZATION_STATUS in sync with database */
2356: wf_engine.SetItemAttrText ( itemtype => itemType,
2357: itemkey => itemkey,
2358: aname => 'AUTHORIZATION_STATUS',
2359: avalue => 'PRE-APPROVED');
2360:

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

2410: BEGIN
2411:
2412: --
2413:
2414: l_caller := wf_engine.GetItemAttrText (itemtype => itemtype,
2415: itemkey => itemkey,
2416: aname => 'INTERFACE_SOURCE_CODE');
2417:
2418:

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

2415: itemkey => itemkey,
2416: aname => 'INTERFACE_SOURCE_CODE');
2417:
2418:
2419: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2420: itemkey => itemkey,
2421: aname => 'DOCUMENT_TYPE');
2422:
2423: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2419: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2420: itemkey => itemkey,
2421: aname => 'DOCUMENT_TYPE');
2422:
2423: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2424: itemkey => itemkey,
2425: aname => 'DOCUMENT_SUBTYPE');
2426:
2427: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2423: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2424: itemkey => itemkey,
2425: aname => 'DOCUMENT_SUBTYPE');
2426:
2427: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2428: itemkey => itemkey,
2429: aname => 'DOCUMENT_ID');
2430:
2431:

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

2428: itemkey => itemkey,
2429: aname => 'DOCUMENT_ID');
2430:
2431:
2432: l_note :=wf_engine.GetItemAttrText (itemtype => itemtype,
2433: itemkey => itemkey,
2434: aname => 'NOTE');
2435:
2436: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2432: l_note :=wf_engine.GetItemAttrText (itemtype => itemtype,
2433: itemkey => itemkey,
2434: aname => 'NOTE');
2435:
2436: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2437: itemkey => itemkey,
2438: aname => 'APPROVAL_PATH_ID');
2439:
2440:

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

2488:
2489: -- Reject Succeeded
2490:
2491: /* Keep the AUTHORIZATION_STATUS in sync with database */
2492: wf_engine.SetItemAttrText ( itemtype => itemType,
2493: itemkey => itemkey,
2494: aname => 'AUTHORIZATION_STATUS',
2495: avalue => 'REJECTED');
2496:

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

2559: BEGIN
2560:
2561: --
2562:
2563: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2564: itemkey => itemkey,
2565: aname => 'DOCUMENT_TYPE');
2566:
2567: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2563: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2564: itemkey => itemkey,
2565: aname => 'DOCUMENT_TYPE');
2566:
2567: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2568: itemkey => itemkey,
2569: aname => 'DOCUMENT_SUBTYPE');
2570:
2571: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2567: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2568: itemkey => itemkey,
2569: aname => 'DOCUMENT_SUBTYPE');
2570:
2571: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2572: itemkey => itemkey,
2573: aname => 'DOCUMENT_ID');
2574:
2575: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2571: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2572: itemkey => itemkey,
2573: aname => 'DOCUMENT_ID');
2574:
2575: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2576: itemkey => itemkey,
2577: aname => 'APPROVER_EMPID');
2578:
2579: x_progress := 'VerifyAuthority: calling verify_authority with: ' || 'Doc_type= ' ||

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

2655: BEGIN
2656:
2657: --
2658:
2659: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2660: itemkey => itemkey,
2661: aname => 'DOCUMENT_TYPE');
2662:
2663: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

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

2659: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2660: itemkey => itemkey,
2661: aname => 'DOCUMENT_TYPE');
2662:
2663: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2664: itemkey => itemkey,
2665: aname => 'DOCUMENT_SUBTYPE');
2666:
2667: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

2663: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2664: itemkey => itemkey,
2665: aname => 'DOCUMENT_SUBTYPE');
2666:
2667: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2668: itemkey => itemkey,
2669: aname => 'DOCUMENT_ID');
2670:
2671: x_progress := 'OpenDocumentState: calling autoupdatecloseautonomous with: ' || 'Doc_type= ' ||

Line 2770: l_doc_type := wf_engine.GetItemAttrText(

2766: IF (g_po_wf_debug = 'Y') THEN
2767: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2768: END IF;
2769:
2770: l_doc_type := wf_engine.GetItemAttrText(
2771: itemtype => itemtype,
2772: itemkey => itemkey,
2773: aname => 'DOCUMENT_TYPE');
2774:

Line 2775: l_doc_subtype := wf_engine.GetItemAttrText(

2771: itemtype => itemtype,
2772: itemkey => itemkey,
2773: aname => 'DOCUMENT_TYPE');
2774:
2775: l_doc_subtype := wf_engine.GetItemAttrText(
2776: itemtype => itemtype,
2777: itemkey => itemkey,
2778: aname => 'DOCUMENT_SUBTYPE');
2779:

Line 2794: l_doc_id := wf_engine.GetItemAttrNumber(

2790: return('Y');
2791:
2792: END IF;
2793:
2794: l_doc_id := wf_engine.GetItemAttrNumber(
2795: itemtype => itemtype,
2796: itemkey => itemkey,
2797: aname => 'DOCUMENT_ID');
2798:

Line 2805: l_employee_id := wf_engine.GetItemAttrNumber(

2801: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2802: END IF;
2803:
2804: IF (l_doc_type = 'REQUISITION') THEN
2805: l_employee_id := wf_engine.GetItemAttrNumber(
2806: itemtype => itemtype,
2807: itemkey => itemkey,
2808: aname => 'RESPONDER_ID');
2809: END IF;

Line 2812: l_employee_id := wf_engine.GetItemAttrNumber(

2808: aname => 'RESPONDER_ID');
2809: END IF;
2810:
2811: IF (l_employee_id IS NULL) THEN
2812: l_employee_id := wf_engine.GetItemAttrNumber(
2813: itemtype => itemtype,
2814: itemkey => itemkey,
2815: aname => 'APPROVER_EMPID');
2816: END IF;

Line 2842: wf_engine.SetItemAttrNumber(

2838:
2839: ELSIF (l_po_return_code = PO_DOCUMENT_FUNDS_PVT.g_return_WARNING) THEN
2840:
2841: -- Also set the online report id for warnings
2842: wf_engine.SetItemAttrNumber(
2843: itemtype => itemType,
2844: itemkey => itemkey,
2845: aname => 'ONLINE_REPORT_ID',
2846: avalue => l_online_report_id);

Line 2880: wf_engine.SetItemAttrNumber(

2876:
2877: ELSE
2878:
2879: -- Get the online_report_id (to be used to populate the notification
2880: wf_engine.SetItemAttrNumber(
2881: itemtype => itemType,
2882: itemkey => itemkey,
2883: aname => 'ONLINE_REPORT_ID',
2884: avalue => l_online_report_id);

Line 3094: wf_engine.SetItemAttrText (

3090: i := l_report_text_lines.NEXT(i);
3091: END LOOP;
3092:
3093: -- Set the workflow attribute to the derived attribute string.
3094: wf_engine.SetItemAttrText (
3095: itemtype => itemType,
3096: itemkey => itemkey,
3097: aname => p_attribute,
3098: avalue => substr(l_attribute_text, 1, 2000)

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

3267: END IF;
3268:
3269: -- Do nothing in cancel or timeout mode
3270: --
3271: if (funcmode <> wf_engine.eng_run) then
3272:
3273: resultout := wf_engine.eng_null;
3274: return;
3275:

Line 3273: resultout := wf_engine.eng_null;

3269: -- Do nothing in cancel or timeout mode
3270: --
3271: if (funcmode <> wf_engine.eng_run) then
3272:
3273: resultout := wf_engine.eng_null;
3274: return;
3275:
3276: end if;
3277:

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

3274: return;
3275:
3276: end if;
3277:
3278: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
3279: itemkey => itemkey,
3280: aname => 'DOCUMENT_TYPE');
3281:
3282:

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

3316: -- End if;
3317:
3318: --
3319:
3320: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
3321: x_resultout := l_doc_mgr_return_val;
3322:
3323: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 99';
3324: IF (g_po_wf_debug = 'Y') THEN