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_AME_WF_PVT dependencies on PO_WF_UTIL_PKG

Line 270: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

266: RETURN;
267: END IF;
268:
269: --Set the global attributes in the po wrapper function
270: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
271: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
272:
273: l_progress := '010';
274: IF (g_po_wf_debug = 'Y') THEN

Line 271: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

267: END IF;
268:
269: --Set the global attributes in the po wrapper function
270: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
271: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
272:
273: l_progress := '010';
274: IF (g_po_wf_debug = 'Y') THEN
275: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 288: l_ame_exception := po_wf_util_pkg.GetItemAttrText( aname => 'AME_EXCEPTION');

284: -- + When count of approvers reach to zero, check whether worklfow routing process is completed or
285: -- not through OUT varaible l_completeYNO in AME_API2.getNextApprovers3(..) */
286:
287: -- Check if there is any AME exception. If yes, then return 'invalid approver'
288: l_ame_exception := po_wf_util_pkg.GetItemAttrText( aname => 'AME_EXCEPTION');
289:
290: IF l_ame_exception IS NOT NULL THEN
291: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';
292: RETURN;

Line 295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

291: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';
292: RETURN;
293: END IF;
294:
295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

Line 296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

292: RETURN;
293: END IF;
294:
295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');

Line 297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

293: END IF;
294:
295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');
301:

Line 298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');

294:
295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');
301:
302: l_progress := '020';

Line 299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');
301:
302: l_progress := '020';
303:

Line 300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');

296: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
297: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
298: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
299: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
300: l_esigner_exists := po_wf_util_pkg.GetItemAttrText( aname => 'E_SIGNER_EXISTS');
301:
302: l_progress := '020';
303:
304: -- Get the next approver from AME.

Line 459: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

455: RETURN;
456: END IF;
457:
458: --Set the global attributes in the po wrapper function
459: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
460: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
461:
462: l_progress := '010';
463: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (aname => 'AME_EXCEPTION');

Line 460: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

456: END IF;
457:
458: --Set the global attributes in the po wrapper function
459: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
460: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
461:
462: l_progress := '010';
463: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (aname => 'AME_EXCEPTION');
464:

Line 463: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (aname => 'AME_EXCEPTION');

459: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
460: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
461:
462: l_progress := '010';
463: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (aname => 'AME_EXCEPTION');
464:
465: IF l_ame_exception IS NOT NULL THEN
466: resultout := wf_engine.eng_completed || ':' ||'Y';
467: ELSE

Line 743: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

739: RETURN;
740: END IF;
741:
742: --Set the global attributes in the po wrapper function
743: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
744: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
745:
746: l_progress := '010';
747: IF (g_po_wf_debug = 'Y') THEN

Line 744: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

740: END IF;
741:
742: --Set the global attributes in the po wrapper function
743: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
744: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
745:
746: l_progress := '010';
747: IF (g_po_wf_debug = 'Y') THEN
748: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 752: po_wf_util_pkg.SetItemAttrText(aname => 'BYPASS_CHECKS_FLAG', avalue => 'N');

748: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
749: END IF;
750:
751: --setting the bypass flag to N if document is getting forwarded
752: po_wf_util_pkg.SetItemAttrText(aname => 'BYPASS_CHECKS_FLAG', avalue => 'N');
753:
754: --Fetch workflow attributes
755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');

Line 755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');

751: --setting the bypass flag to N if document is getting forwarded
752: po_wf_util_pkg.SetItemAttrText(aname => 'BYPASS_CHECKS_FLAG', avalue => 'N');
753:
754: --Fetch workflow attributes
755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');

Line 756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');

752: po_wf_util_pkg.SetItemAttrText(aname => 'BYPASS_CHECKS_FLAG', avalue => 'N');
753:
754: --Fetch workflow attributes
755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');
760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');

Line 757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');

753:
754: --Fetch workflow attributes
755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');
760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
761:

Line 758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');

754: --Fetch workflow attributes
755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');
760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
761:
762: l_start_block_activity := 'N';

Line 759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');

755: l_org_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'ORG_ID');
756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');
760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
761:
762: l_start_block_activity := 'N';
763: l_has_fyi_app := 'N';

Line 760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');

756: l_document_type := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
757: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
758: l_transaction_type := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
759: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'AME_TRANSACTION_ID');
760: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
761:
762: l_start_block_activity := 'N';
763: l_has_fyi_app := 'N';
764: l_approver_index := g_next_approvers.first;

Line 793: t_po_varval (1) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');

789: parent_context => NULL );
790:
791: --In array t_po_varname and t_po_varval, set all required workflow attributes
792: t_po_varname (1) := 'DOCUMENT_TYPE';
793: t_po_varval (1) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
794: t_po_varname (2) := 'DOCUMENT_SUBTYPE';
795: t_po_varval (2) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
796: t_po_varname (3) := 'PREPARER_USER_NAME';
797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');

Line 795: t_po_varval (2) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');

791: --In array t_po_varname and t_po_varval, set all required workflow attributes
792: t_po_varname (1) := 'DOCUMENT_TYPE';
793: t_po_varval (1) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
794: t_po_varname (2) := 'DOCUMENT_SUBTYPE';
795: t_po_varval (2) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
796: t_po_varname (3) := 'PREPARER_USER_NAME';
797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');
798: t_po_varname (4) := 'PREPARER_DISPLAY_NAME';
799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');

Line 797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');

793: t_po_varval (1) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE');
794: t_po_varname (2) := 'DOCUMENT_SUBTYPE';
795: t_po_varval (2) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
796: t_po_varname (3) := 'PREPARER_USER_NAME';
797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');
798: t_po_varname (4) := 'PREPARER_DISPLAY_NAME';
799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');
800: t_po_varname (5) := 'FUNCTIONAL_CURRENCY';
801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');

Line 799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');

795: t_po_varval (2) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
796: t_po_varname (3) := 'PREPARER_USER_NAME';
797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');
798: t_po_varname (4) := 'PREPARER_DISPLAY_NAME';
799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');
800: t_po_varname (5) := 'FUNCTIONAL_CURRENCY';
801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');
802: t_po_varname (6) := 'TOTAL_AMOUNT_DSP';
803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');

Line 801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');

797: t_po_varval (3) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_USER_NAME');
798: t_po_varname (4) := 'PREPARER_DISPLAY_NAME';
799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');
800: t_po_varname (5) := 'FUNCTIONAL_CURRENCY';
801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');
802: t_po_varname (6) := 'TOTAL_AMOUNT_DSP';
803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');
804: t_po_varname (7) := 'FORWARD_FROM_DISP_NAME';
805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');

Line 803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');

799: t_po_varval (4) := po_wf_util_pkg.GetItemAttrText (aname => 'PREPARER_DISPLAY_NAME');
800: t_po_varname (5) := 'FUNCTIONAL_CURRENCY';
801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');
802: t_po_varname (6) := 'TOTAL_AMOUNT_DSP';
803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');
804: t_po_varname (7) := 'FORWARD_FROM_DISP_NAME';
805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');
806: t_po_varname (8) := 'FORWARD_FROM_USER_NAME';
807: t_po_varval (8) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_USER_NAME');

Line 805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');

801: t_po_varval (5) := po_wf_util_pkg.GetItemAttrText (aname => 'FUNCTIONAL_CURRENCY');
802: t_po_varname (6) := 'TOTAL_AMOUNT_DSP';
803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');
804: t_po_varname (7) := 'FORWARD_FROM_DISP_NAME';
805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');
806: t_po_varname (8) := 'FORWARD_FROM_USER_NAME';
807: t_po_varval (8) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_USER_NAME');
808: t_po_varname (9) := 'DOCUMENT_NUMBER';
809: t_po_varval (9) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_NUMBER');

Line 807: t_po_varval (8) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_USER_NAME');

803: t_po_varval (6) := po_wf_util_pkg.GetItemAttrText (aname => 'TOTAL_AMOUNT_DSP');
804: t_po_varname (7) := 'FORWARD_FROM_DISP_NAME';
805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');
806: t_po_varname (8) := 'FORWARD_FROM_USER_NAME';
807: t_po_varval (8) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_USER_NAME');
808: t_po_varname (9) := 'DOCUMENT_NUMBER';
809: t_po_varval (9) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_NUMBER');
810: l_userkey := t_po_varval (9);
811: t_po_varname (10) := 'AME_TRANSACTION_TYPE';

Line 809: t_po_varval (9) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_NUMBER');

805: t_po_varval (7) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_DISP_NAME');
806: t_po_varname (8) := 'FORWARD_FROM_USER_NAME';
807: t_po_varval (8) := po_wf_util_pkg.GetItemAttrText (aname => 'FORWARD_FROM_USER_NAME');
808: t_po_varname (9) := 'DOCUMENT_NUMBER';
809: t_po_varval (9) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_NUMBER');
810: l_userkey := t_po_varval (9);
811: t_po_varname (10) := 'AME_TRANSACTION_TYPE';
812: t_po_varval (10) := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
813: t_po_varname (11) := 'OPEN_FORM_COMMAND';

Line 812: t_po_varval (10) := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');

808: t_po_varname (9) := 'DOCUMENT_NUMBER';
809: t_po_varval (9) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_NUMBER');
810: l_userkey := t_po_varval (9);
811: t_po_varname (10) := 'AME_TRANSACTION_TYPE';
812: t_po_varval (10) := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
813: t_po_varname (11) := 'OPEN_FORM_COMMAND';
814: t_po_varval (11) := po_wf_util_pkg.GetItemAttrText (aname => 'OPEN_FORM_COMMAND');
815: t_po_varname (12) := 'PO_DESCRIPTION';
816: t_po_varval (12) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_DESCRIPTION');

Line 814: t_po_varval (11) := po_wf_util_pkg.GetItemAttrText (aname => 'OPEN_FORM_COMMAND');

810: l_userkey := t_po_varval (9);
811: t_po_varname (10) := 'AME_TRANSACTION_TYPE';
812: t_po_varval (10) := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
813: t_po_varname (11) := 'OPEN_FORM_COMMAND';
814: t_po_varval (11) := po_wf_util_pkg.GetItemAttrText (aname => 'OPEN_FORM_COMMAND');
815: t_po_varname (12) := 'PO_DESCRIPTION';
816: t_po_varval (12) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_DESCRIPTION');
817: t_po_varname (13) := 'PO_AMOUNT_DSP';
818: t_po_varval (13) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_AMOUNT_DSP');

Line 816: t_po_varval (12) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_DESCRIPTION');

812: t_po_varval (10) := po_wf_util_pkg.GetItemAttrText (aname => 'AME_TRANSACTION_TYPE');
813: t_po_varname (11) := 'OPEN_FORM_COMMAND';
814: t_po_varval (11) := po_wf_util_pkg.GetItemAttrText (aname => 'OPEN_FORM_COMMAND');
815: t_po_varname (12) := 'PO_DESCRIPTION';
816: t_po_varval (12) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_DESCRIPTION');
817: t_po_varname (13) := 'PO_AMOUNT_DSP';
818: t_po_varval (13) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_AMOUNT_DSP');
819:
820: t_po_varname (14) := 'VIEW_DOC_URL';

Line 818: t_po_varval (13) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_AMOUNT_DSP');

814: t_po_varval (11) := po_wf_util_pkg.GetItemAttrText (aname => 'OPEN_FORM_COMMAND');
815: t_po_varname (12) := 'PO_DESCRIPTION';
816: t_po_varval (12) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_DESCRIPTION');
817: t_po_varname (13) := 'PO_AMOUNT_DSP';
818: t_po_varval (13) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_AMOUNT_DSP');
819:
820: t_po_varname (14) := 'VIEW_DOC_URL';
821: t_po_varval (14) := po_wf_util_pkg.GetItemAttrText (aname => 'VIEW_DOC_URL');
822: IF (t_po_varval (14) IS NOT NULL) THEN

Line 821: t_po_varval (14) := po_wf_util_pkg.GetItemAttrText (aname => 'VIEW_DOC_URL');

817: t_po_varname (13) := 'PO_AMOUNT_DSP';
818: t_po_varval (13) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_AMOUNT_DSP');
819:
820: t_po_varname (14) := 'VIEW_DOC_URL';
821: t_po_varval (14) := po_wf_util_pkg.GetItemAttrText (aname => 'VIEW_DOC_URL');
822: IF (t_po_varval (14) IS NOT NULL) THEN
823: t_po_varval (14) := t_po_varval (14) || '&' || 'item_key=' || l_item_key;
824: END IF;
825:

Line 827: t_po_varval (15) := po_wf_util_pkg.GetItemAttrText (aname => 'EDIT_DOC_URL');

823: t_po_varval (14) := t_po_varval (14) || '&' || 'item_key=' || l_item_key;
824: END IF;
825:
826: t_po_varname (15) := 'EDIT_DOC_URL';
827: t_po_varval (15) := po_wf_util_pkg.GetItemAttrText (aname => 'EDIT_DOC_URL');
828:
829: IF (t_po_varval (15) IS NOT NULL) THEN
830: t_po_varval (15) := t_po_varval (15) || '&' || 'item_key=' || l_item_key;
831: END IF;

Line 935: t_po_varval (20) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE_DISP');

931: END IF;
932: END IF;
933:
934: t_po_varname (20) := 'DOCUMENT_TYPE_DISP';
935: t_po_varval (20) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE_DISP');
936: t_po_varname (21) := 'REQUIRES_APPROVAL_MSG';
937: t_po_varval (21) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_APPROVAL_MSG');
938: t_po_varname (22) := 'WRONG_FORWARD_TO_MSG';
939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');

Line 937: t_po_varval (21) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_APPROVAL_MSG');

933:
934: t_po_varname (20) := 'DOCUMENT_TYPE_DISP';
935: t_po_varval (20) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE_DISP');
936: t_po_varname (21) := 'REQUIRES_APPROVAL_MSG';
937: t_po_varval (21) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_APPROVAL_MSG');
938: t_po_varname (22) := 'WRONG_FORWARD_TO_MSG';
939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');
940: t_po_varname (23) := 'OPERATING_UNIT_NAME';
941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');

Line 939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');

935: t_po_varval (20) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_TYPE_DISP');
936: t_po_varname (21) := 'REQUIRES_APPROVAL_MSG';
937: t_po_varval (21) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_APPROVAL_MSG');
938: t_po_varname (22) := 'WRONG_FORWARD_TO_MSG';
939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');
940: t_po_varname (23) := 'OPERATING_UNIT_NAME';
941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');
942: t_po_varname (24) := 'NOTE';
943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');

Line 941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');

937: t_po_varval (21) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_APPROVAL_MSG');
938: t_po_varname (22) := 'WRONG_FORWARD_TO_MSG';
939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');
940: t_po_varname (23) := 'OPERATING_UNIT_NAME';
941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');
942: t_po_varname (24) := 'NOTE';
943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');
944: t_po_varname (25) := 'PO_LINES_DETAILS';
945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');

Line 943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');

939: t_po_varval (22) := po_wf_util_pkg.GetItemAttrText (aname => 'WRONG_FORWARD_TO_MSG');
940: t_po_varname (23) := 'OPERATING_UNIT_NAME';
941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');
942: t_po_varname (24) := 'NOTE';
943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');
944: t_po_varname (25) := 'PO_LINES_DETAILS';
945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');
946: t_po_varname (26) := 'DOCUMENT_SUBTYPE_DISP';
947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');

Line 945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');

941: t_po_varval (23) := po_wf_util_pkg.GetItemAttrText (aname => 'OPERATING_UNIT_NAME');
942: t_po_varname (24) := 'NOTE';
943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');
944: t_po_varname (25) := 'PO_LINES_DETAILS';
945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');
946: t_po_varname (26) := 'DOCUMENT_SUBTYPE_DISP';
947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');
948: t_po_varname (27) := 'ACTION_HISTORY';
949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');

Line 947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');

943: t_po_varval (24) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTE');
944: t_po_varname (25) := 'PO_LINES_DETAILS';
945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');
946: t_po_varname (26) := 'DOCUMENT_SUBTYPE_DISP';
947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');
948: t_po_varname (27) := 'ACTION_HISTORY';
949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');
950: t_po_varname (28) := 'PO_APPROVE_MSG';
951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');

Line 949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');

945: t_po_varval (25) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_LINES_DETAILS');
946: t_po_varname (26) := 'DOCUMENT_SUBTYPE_DISP';
947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');
948: t_po_varname (27) := 'ACTION_HISTORY';
949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');
950: t_po_varname (28) := 'PO_APPROVE_MSG';
951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');
952: t_po_varname (29) := 'SUPPLIER';
953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');

Line 951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');

947: t_po_varval (26) := po_wf_util_pkg.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE_DISP');
948: t_po_varname (27) := 'ACTION_HISTORY';
949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');
950: t_po_varname (28) := 'PO_APPROVE_MSG';
951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');
952: t_po_varname (29) := 'SUPPLIER';
953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');
954: t_po_varname (30) := 'SUPPLIER_SITE';
955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');

Line 953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');

949: t_po_varval (27) := po_wf_util_pkg.GetItemAttrText (aname => 'ACTION_HISTORY');
950: t_po_varname (28) := 'PO_APPROVE_MSG';
951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');
952: t_po_varname (29) := 'SUPPLIER';
953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');
954: t_po_varname (30) := 'SUPPLIER_SITE';
955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');
956: t_po_varname (31) := 'AUTHORIZATION_STATUS';
957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');

Line 955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');

951: t_po_varval (28) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_APPROVE_MSG');
952: t_po_varname (29) := 'SUPPLIER';
953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');
954: t_po_varname (30) := 'SUPPLIER_SITE';
955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');
956: t_po_varname (31) := 'AUTHORIZATION_STATUS';
957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');
958: t_po_varname (32) := 'WITH_TERMS';
959: t_po_varval (32) := po_wf_util_pkg.GetItemAttrText (aname => 'WITH_TERMS');

Line 957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');

953: t_po_varval (29) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER');
954: t_po_varname (30) := 'SUPPLIER_SITE';
955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');
956: t_po_varname (31) := 'AUTHORIZATION_STATUS';
957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');
958: t_po_varname (32) := 'WITH_TERMS';
959: t_po_varval (32) := po_wf_util_pkg.GetItemAttrText (aname => 'WITH_TERMS');
960: t_po_varname (33) := 'LANGUAGE_CODE';
961: t_po_varval (33) := po_wf_util_pkg.GetItemAttrText (aname => 'LANGUAGE_CODE');

Line 959: t_po_varval (32) := po_wf_util_pkg.GetItemAttrText (aname => 'WITH_TERMS');

955: t_po_varval (30) := po_wf_util_pkg.GetItemAttrText (aname => 'SUPPLIER_SITE');
956: t_po_varname (31) := 'AUTHORIZATION_STATUS';
957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');
958: t_po_varname (32) := 'WITH_TERMS';
959: t_po_varval (32) := po_wf_util_pkg.GetItemAttrText (aname => 'WITH_TERMS');
960: t_po_varname (33) := 'LANGUAGE_CODE';
961: t_po_varval (33) := po_wf_util_pkg.GetItemAttrText (aname => 'LANGUAGE_CODE');
962:
963: l_progress := '060';

Line 961: t_po_varval (33) := po_wf_util_pkg.GetItemAttrText (aname => 'LANGUAGE_CODE');

957: t_po_varval (31) := po_wf_util_pkg.GetItemAttrText (aname => 'AUTHORIZATION_STATUS');
958: t_po_varname (32) := 'WITH_TERMS';
959: t_po_varval (32) := po_wf_util_pkg.GetItemAttrText (aname => 'WITH_TERMS');
960: t_po_varname (33) := 'LANGUAGE_CODE';
961: t_po_varval (33) := po_wf_util_pkg.GetItemAttrText (aname => 'LANGUAGE_CODE');
962:
963: l_progress := '060';
964: --Adding code for setting attribute approver_category for on the basis of production rule.
965: IF (g_po_wf_debug = 'Y') THEN

Line 998: t_po_varval (35) := po_wf_util_pkg.GetItemAttrText (aname => 'BUYER_USER_NAME');

994: END IF;
995:
996: l_progress := '070';
997: t_po_varname (35) := 'BUYER_USER_NAME';
998: t_po_varval (35) := po_wf_util_pkg.GetItemAttrText (aname => 'BUYER_USER_NAME');
999: t_po_varname (36) := 'NOTIFICATION_REGION';
1000: t_po_varval (36) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTIFICATION_REGION');
1001: t_po_varname (37) := 'REQUIRES_REVIEW_MSG';
1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');

Line 1000: t_po_varval (36) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTIFICATION_REGION');

996: l_progress := '070';
997: t_po_varname (35) := 'BUYER_USER_NAME';
998: t_po_varval (35) := po_wf_util_pkg.GetItemAttrText (aname => 'BUYER_USER_NAME');
999: t_po_varname (36) := 'NOTIFICATION_REGION';
1000: t_po_varval (36) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTIFICATION_REGION');
1001: t_po_varname (37) := 'REQUIRES_REVIEW_MSG';
1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');
1003: t_po_varname (38) := 'PDF_ATTACHMENT_BUYER';
1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');

Line 1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');

998: t_po_varval (35) := po_wf_util_pkg.GetItemAttrText (aname => 'BUYER_USER_NAME');
999: t_po_varname (36) := 'NOTIFICATION_REGION';
1000: t_po_varval (36) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTIFICATION_REGION');
1001: t_po_varname (37) := 'REQUIRES_REVIEW_MSG';
1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');
1003: t_po_varname (38) := 'PDF_ATTACHMENT_BUYER';
1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');
1005: t_po_varname (39) := 'PO_PDF_ERROR';
1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');

Line 1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');

1000: t_po_varval (36) := po_wf_util_pkg.GetItemAttrText (aname => 'NOTIFICATION_REGION');
1001: t_po_varname (37) := 'REQUIRES_REVIEW_MSG';
1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');
1003: t_po_varname (38) := 'PDF_ATTACHMENT_BUYER';
1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');
1005: t_po_varname (39) := 'PO_PDF_ERROR';
1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');
1007: t_po_varname (40) := '#HISTORY';
1008: t_po_varval (40) := po_wf_util_pkg.GetItemAttrText (aname => '#HISTORY');

Line 1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');

1002: t_po_varval (37) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_REVIEW_MSG');
1003: t_po_varname (38) := 'PDF_ATTACHMENT_BUYER';
1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');
1005: t_po_varname (39) := 'PO_PDF_ERROR';
1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');
1007: t_po_varname (40) := '#HISTORY';
1008: t_po_varval (40) := po_wf_util_pkg.GetItemAttrText (aname => '#HISTORY');
1009: t_po_varname (41) := 'REQUIRES_ESIGN_MSG';
1010: t_po_varval (41) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_ESIGN_MSG');

Line 1008: t_po_varval (40) := po_wf_util_pkg.GetItemAttrText (aname => '#HISTORY');

1004: t_po_varval (38) := po_wf_util_pkg.GetItemAttrText (aname => 'PDF_ATTACHMENT_BUYER');
1005: t_po_varname (39) := 'PO_PDF_ERROR';
1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');
1007: t_po_varname (40) := '#HISTORY';
1008: t_po_varval (40) := po_wf_util_pkg.GetItemAttrText (aname => '#HISTORY');
1009: t_po_varname (41) := 'REQUIRES_ESIGN_MSG';
1010: t_po_varval (41) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_ESIGN_MSG');
1011:
1012: --Set the item attributes from the array

Line 1010: t_po_varval (41) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_ESIGN_MSG');

1006: t_po_varval (39) := po_wf_util_pkg.GetItemAttrText (aname => 'PO_PDF_ERROR');
1007: t_po_varname (40) := '#HISTORY';
1008: t_po_varval (40) := po_wf_util_pkg.GetItemAttrText (aname => '#HISTORY');
1009: t_po_varname (41) := 'REQUIRES_ESIGN_MSG';
1010: t_po_varval (41) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_ESIGN_MSG');
1011:
1012: --Set the item attributes from the array
1013: l_progress := '080';
1014: wf_engine.SetItemAttrTextarray (itemtype, l_item_key, t_po_varname, t_po_varval);

Line 1040: n_varval (6) := po_wf_util_pkg.GetItemAttrNumber (aname => 'RESPONSIBILITY_ID');

1036: n_varval (5) := g_next_approvers (l_approver_index).group_or_chain_id;
1037: END IF;
1038:
1039: n_varname (6) := 'RESPONSIBILITY_ID';
1040: n_varval (6) := po_wf_util_pkg.GetItemAttrNumber (aname => 'RESPONSIBILITY_ID');
1041: n_varname (7) := 'APPLICATION_ID';
1042: n_varval (7) := po_wf_util_pkg.GetItemAttrNumber (aname => 'APPLICATION_ID');
1043:
1044: IF (g_po_wf_debug = 'Y') THEN

Line 1042: n_varval (7) := po_wf_util_pkg.GetItemAttrNumber (aname => 'APPLICATION_ID');

1038:
1039: n_varname (6) := 'RESPONSIBILITY_ID';
1040: n_varval (6) := po_wf_util_pkg.GetItemAttrNumber (aname => 'RESPONSIBILITY_ID');
1041: n_varname (7) := 'APPLICATION_ID';
1042: n_varval (7) := po_wf_util_pkg.GetItemAttrNumber (aname => 'APPLICATION_ID');
1043:
1044: IF (g_po_wf_debug = 'Y') THEN
1045: PO_WF_DEBUG_PKG.insert_debug (itemtype, itemkey, l_log_head||':'||l_progress
1046: ||' RESP:'||n_varval(6)

Line 1052: n_varval (9) := po_wf_util_pkg.GetItemAttrNumber (aname => 'DRAFT_ID');

1048: END IF;
1049: n_varname (8) := 'AME_TRANSACTION_ID';
1050: n_varval (8) := l_ame_transaction_id;
1051: n_varname (9) := 'DRAFT_ID';
1052: n_varval (9) := po_wf_util_pkg.GetItemAttrNumber (aname => 'DRAFT_ID');
1053: n_varname (10) := 'REVISION_NUMBER';
1054: n_varval (10) := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
1055:
1056: wf_engine.SetItemAttrNumberArray (itemtype, l_item_key, n_varname, n_varval);

Line 1054: n_varval (10) := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');

1050: n_varval (8) := l_ame_transaction_id;
1051: n_varname (9) := 'DRAFT_ID';
1052: n_varval (9) := po_wf_util_pkg.GetItemAttrNumber (aname => 'DRAFT_ID');
1053: n_varname (10) := 'REVISION_NUMBER';
1054: n_varval (10) := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
1055:
1056: wf_engine.SetItemAttrNumberArray (itemtype, l_item_key, n_varname, n_varval);
1057:
1058: l_progress := '100';

Line 1141: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1137: RETURN;
1138: END IF;
1139:
1140: --Set the global attributes in the po wrapper function
1141: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1142: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1143:
1144: --Logic is check for workflow attribute 'APPROVER_CATEGORY' and pass it ahead
1145: l_approver_category := po_wf_util_pkg.GetItemAttrText (aname => 'APPROVER_CATEGORY');

Line 1142: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1138: END IF;
1139:
1140: --Set the global attributes in the po wrapper function
1141: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1142: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1143:
1144: --Logic is check for workflow attribute 'APPROVER_CATEGORY' and pass it ahead
1145: l_approver_category := po_wf_util_pkg.GetItemAttrText (aname => 'APPROVER_CATEGORY');
1146: resultout := wf_engine.eng_completed || ':' || l_approver_category;

Line 1145: l_approver_category := po_wf_util_pkg.GetItemAttrText (aname => 'APPROVER_CATEGORY');

1141: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1142: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1143:
1144: --Logic is check for workflow attribute 'APPROVER_CATEGORY' and pass it ahead
1145: l_approver_category := po_wf_util_pkg.GetItemAttrText (aname => 'APPROVER_CATEGORY');
1146: resultout := wf_engine.eng_completed || ':' || l_approver_category;
1147:
1148: END determine_approver_category;
1149: --------------------------------------------------------------------------------

Line 1194: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1190: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1191: BEGIN
1192:
1193: --Set the global attributes in the po wrapper function
1194: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1195: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1196:
1197: -- Logic:
1198: -- Fetch all required workflow attributes

Line 1195: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1191: BEGIN
1192:
1193: --Set the global attributes in the po wrapper function
1194: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1195: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1196:
1197: -- Logic:
1198: -- Fetch all required workflow attributes
1199: -- Need l_forwardee approverRecord to be populated in case of FORWRAD and

Line 1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1207: IF (g_po_wf_debug = 'Y') THEN
1208: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1209: END IF;
1210:
1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');

Line 1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1208: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1209: END IF;
1210:
1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');
1216:

Line 1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');

1209: END IF;
1210:
1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');
1216:
1217: --Populate l_forwardee approverRecord on the basis of current approver_type

Line 1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

1210:
1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');
1216:
1217: --Populate l_forwardee approverRecord on the basis of current approver_type
1218: IF (l_approver_type = ame_util.posOrigSystem) THEN

Line 1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');

1211: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1212: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1213: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
1214: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
1215: l_approver_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_APPROVER_TYPE');
1216:
1217: --Populate l_forwardee approverRecord on the basis of current approver_type
1218: IF (l_approver_type = ame_util.posOrigSystem) THEN
1219: l_current_approver.orig_system := ame_util.posOrigSystem;

Line 1224: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

1220: ELSIF (l_approver_type = ame_util.fndUserOrigSystem) THEN
1221: l_current_approver.orig_system := ame_util.fndUserOrigSystem;
1222: ELSE
1223: l_current_approver.orig_system := ame_util.perOrigSystem;
1224: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
1225: END IF;
1226:
1227: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_APPROVER_ID');
1228: l_forwardee.orig_system := ame_util.perOrigSystem;

Line 1227: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_APPROVER_ID');

1223: l_current_approver.orig_system := ame_util.perOrigSystem;
1224: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
1225: END IF;
1226:
1227: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_APPROVER_ID');
1228: l_forwardee.orig_system := ame_util.perOrigSystem;
1229: l_forwardee.name := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');
1230:
1231: BEGIN

Line 1229: l_forwardee.name := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');

1225: END IF;
1226:
1227: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_APPROVER_ID');
1228: l_forwardee.orig_system := ame_util.perOrigSystem;
1229: l_forwardee.name := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');
1230:
1231: BEGIN
1232:
1233: SELECT employee_id

Line 1348: po_wf_util_pkg.SetItemAttrText(

1344: FROM wf_items
1345: WHERE item_type = itemtype
1346: AND item_key = itemkey;
1347:
1348: po_wf_util_pkg.SetItemAttrText(
1349: itemtype => l_parent_item_type,
1350: itemkey => l_parent_item_key,
1351: aname => 'AME_EXCEPTION',
1352: avalue => l_error_message );

Line 1403: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1399: RETURN;
1400: END IF;
1401:
1402: --Set the global attributes in the po wrapper function
1403: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1404: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1405:
1406: l_progress := '010';
1407: IF (g_po_wf_debug = 'Y') THEN

Line 1404: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1400: END IF;
1401:
1402: --Set the global attributes in the po wrapper function
1403: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1404: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1405:
1406: l_progress := '010';
1407: IF (g_po_wf_debug = 'Y') THEN
1408: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1419: po_wf_util_pkg.SetItemAttrText(aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'EXCEPTION');

1415: AND item_key = itemkey;
1416:
1417: -- Call process_response_internal with 'EXCEPTION'
1418: process_response_internal(itemtype, itemkey, 'EXCEPTION');
1419: po_wf_util_pkg.SetItemAttrText(aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'EXCEPTION');
1420: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1421: RETURN;
1422: END Process_Response_Exception;
1423:

Line 1475: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1471: RETURN;
1472: END IF;
1473:
1474: --Set the global attributes in the po wrapper function
1475: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1476: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1477:
1478: -- Logic:
1479: -- + Fetch worklfow attributes required for inserting NULL record into action history.

Line 1476: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1472: END IF;
1473:
1474: --Set the global attributes in the po wrapper function
1475: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1476: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1477:
1478: -- Logic:
1479: -- + Fetch worklfow attributes required for inserting NULL record into action history.
1480: -- against current approver.

Line 1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1484: IF (g_po_wf_debug = 'Y') THEN
1485: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_log_head||':'||l_progress);
1486: END IF;
1487:
1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');

Line 1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');

1485: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_log_head||':'||l_progress);
1486: END IF;
1487:
1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

Line 1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

1486: END IF;
1487:
1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1487:
1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

Line 1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');

1488: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
1496:

Line 1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

1489: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
1496:
1497: IF l_org_id IS NOT NULL THEN

Line 1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

1490: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
1496:
1497: IF l_org_id IS NOT NULL THEN
1498: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

1491: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1492: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
1493: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
1494: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1495: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
1496:
1497: IF l_org_id IS NOT NULL THEN
1498: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1499: END IF;

Line 1515: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE', avalue => NULL);

1511:
1512: l_progress := '030';
1513:
1514: --Reset the FORWARD_TO_USERNAME_RESPONSE and NOTE attributes
1515: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE', avalue => NULL);
1516: po_wf_util_pkg.SetItemAttrText( aname => 'NOTE', avalue => NULL);
1517: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1518:
1519: RETURN;

Line 1516: po_wf_util_pkg.SetItemAttrText( aname => 'NOTE', avalue => NULL);

1512: l_progress := '030';
1513:
1514: --Reset the FORWARD_TO_USERNAME_RESPONSE and NOTE attributes
1515: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE', avalue => NULL);
1516: po_wf_util_pkg.SetItemAttrText( aname => 'NOTE', avalue => NULL);
1517: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1518:
1519: RETURN;
1520:

Line 1587: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1583: RETURN;
1584: END IF;
1585:
1586: --Set the global attributes in the po wrapper function
1587: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1588: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1589:
1590: -- Logic :
1591: -- + Fetch worklfow attributes required for updating NULL action to FORWARD action in

Line 1588: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1584: END IF;
1585:
1586: --Set the global attributes in the po wrapper function
1587: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1588: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1589:
1590: -- Logic :
1591: -- + Fetch worklfow attributes required for updating NULL action to FORWARD action in
1592: -- action history against current approver.

Line 1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

1597: IF (g_po_wf_debug = 'Y') THEN
1598: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1599: END IF;
1600:
1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

Line 1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1598: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1599: END IF;
1600:
1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

Line 1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1599: END IF;
1600:
1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

1600:
1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1608:

Line 1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

1601: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1608:
1609: IF l_org_id IS NOT NULL THEN

Line 1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

1602: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1608:
1609: IF l_org_id IS NOT NULL THEN
1610: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

1603: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1604: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1605: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1606: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1607: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1608:
1609: IF l_org_id IS NOT NULL THEN
1610: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1611: END IF;

Line 1624: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'FORWARD' );

1620: p_note =>l_note,
1621: p_current_approver => l_current_approver);
1622:
1623: l_progress := '030';
1624: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'FORWARD' );
1625: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1626:
1627: EXCEPTION
1628: WHEN OTHERS THEN

Line 1693: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1689: RETURN;
1690: END IF;
1691:
1692: --Set the global attributes in the po wrapper function
1693: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1694: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1695:
1696: -- Logic :
1697: -- + Fetch worklfow attributes required for updating NULL action to APPROVE for approver,

Line 1694: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1690: END IF;
1691:
1692: --Set the global attributes in the po wrapper function
1693: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1694: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1695:
1696: -- Logic :
1697: -- + Fetch worklfow attributes required for updating NULL action to APPROVE for approver,
1698: -- REVIEW ACCEPTED for Reviewer into action history, SIGNED for ESIGNER

Line 1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

1704: IF (g_po_wf_debug = 'Y') THEN
1705: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1706: END IF;
1707:
1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

Line 1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1705: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1706: END IF;
1707:
1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

Line 1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1706: END IF;
1707:
1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

1707:
1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1715:

Line 1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

1708: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1715:
1716: IF l_org_id IS NOT NULL THEN

Line 1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

1709: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1715:
1716: IF l_org_id IS NOT NULL THEN
1717: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

1710: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1711: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1712: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1713: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1714: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1715:
1716: IF l_org_id IS NOT NULL THEN
1717: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1718: END IF;

Line 1721: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');

1717: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1718: END IF;
1719:
1720: --Change the l_action for REVIEWER
1721: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
1722: IF l_approver_category = 'REVIEWER' THEN
1723: l_action := 'REVIEW ACCEPTED';
1724: ELSIF l_approver_category = 'ESIGNER' THEN
1725: l_action := 'SIGNED';

Line 1747: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'APPROVED' );

1743: p_action => l_action,
1744: p_note =>l_note,
1745: p_current_approver => l_current_approver);
1746:
1747: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'APPROVED' );
1748: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1749: RETURN;
1750:
1751: EXCEPTION

Line 1816: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1812: RETURN;
1813: END IF;
1814:
1815: --Set the global attributes in the po wrapper function
1816: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1817: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1818:
1819: l_progress := '010';
1820: IF (g_po_wf_debug = 'Y') THEN

Line 1817: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1813: END IF;
1814:
1815: --Set the global attributes in the po wrapper function
1816: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1817: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1818:
1819: l_progress := '010';
1820: IF (g_po_wf_debug = 'Y') THEN
1821: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

1827: -- against current approver/reviewer/esigner.
1828: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1829: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'REJECTED'
1830:
1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

Line 1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1828: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1829: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'REJECTED'
1830:
1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

Line 1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1829: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'REJECTED'
1830:
1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

1830:
1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1838:

Line 1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1838:
1839: IF l_org_id IS NOT NULL THEN

Line 1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1838:
1839: IF l_org_id IS NOT NULL THEN
1840: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

1833: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1834: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1835: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
1836: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1837: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1838:
1839: IF l_org_id IS NOT NULL THEN
1840: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1841: END IF;

Line 1844: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');

1840: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1841: END IF;
1842:
1843: --Change the l_action for REVIEWER
1844: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
1845: IF l_approver_category = 'REVIEWER' THEN
1846: l_action := 'REVIEW REJECTED';
1847: ELSIF l_approver_category = 'ESIGNER' THEN
1848: l_action := 'SIGNER REJECTED';

Line 1870: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'REJECTED' );

1866: p_action => l_action,
1867: p_note =>l_note,
1868: p_current_approver => l_current_approver);
1869:
1870: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'REJECTED' );
1871: resultout := wf_engine.eng_completed||':'|| 'ACTIVITY_PERFORMED';
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN

Line 1937: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

1933: RETURN;
1934: END IF;
1935:
1936: --Set the global attributes in the po wrapper function
1937: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1938: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1939:
1940: l_progress := '010';
1941: IF (g_po_wf_debug = 'Y') THEN

Line 1938: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

1934: END IF;
1935:
1936: --Set the global attributes in the po wrapper function
1937: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
1938: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1939:
1940: l_progress := '010';
1941: IF (g_po_wf_debug = 'Y') THEN
1942: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

1946: -- + Fetch worklfow attributes required for updating NULL action to NO ACTION action into action history
1947: -- against current approver.
1948: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1949:
1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

1947: -- against current approver.
1948: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1949:
1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1955: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');

Line 1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

1948: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1949:
1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1955: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1956: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

1949:
1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1955: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1956: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1957: IF l_org_id IS NOT NULL THEN

Line 1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1955: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1956: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1957: IF l_org_id IS NOT NULL THEN
1958: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1956: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
1953: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
1954: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
1955: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1956: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
1957: IF l_org_id IS NOT NULL THEN
1958: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1959: END IF;
1960:

Line 2045: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2041: RETURN;
2042: END IF;
2043:
2044: --Set the global attributes in the po wrapper function
2045: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2046: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2047:
2048: l_progress := '010';
2049: IF (g_po_wf_debug = 'Y') THEN

Line 2046: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2042: END IF;
2043:
2044: --Set the global attributes in the po wrapper function
2045: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2046: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2047:
2048: l_progress := '010';
2049: IF (g_po_wf_debug = 'Y') THEN
2050: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

2054: -- + Fetch worklfow attributes required for updating NULL action to NO ACTION action into action history
2055: -- against current approver.
2056: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
2057:
2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

2055: -- against current approver.
2056: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
2057:
2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
2063: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');

Line 2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

2056: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
2057:
2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
2063: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
2064: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

2057:
2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
2063: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
2064: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2065: IF l_org_id IS NOT NULL THEN

Line 2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
2063: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
2064: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2065: IF l_org_id IS NOT NULL THEN
2066: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 2064: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
2061: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2062: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
2063: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
2064: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2065: IF l_org_id IS NOT NULL THEN
2066: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
2067: END IF;
2068:

Line 2147: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2143: RETURN;
2144: END IF;
2145:
2146: --Set the global attributes in the po wrapper function
2147: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2148: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2149:
2150: l_progress := '010';
2151: IF (g_po_wf_debug = 'Y') THEN

Line 2148: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2144: END IF;
2145:
2146: --Set the global attributes in the po wrapper function
2147: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2148: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2149:
2150: l_progress := '010';
2151: IF (g_po_wf_debug = 'Y') THEN
2152: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 2177: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');

2173: IF (g_po_wf_debug = 'Y') THEN
2174: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Returned from process_response_internal');
2175: END IF;
2176:
2177: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

Line 2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

2174: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Returned from process_response_internal');
2175: END IF;
2176:
2177: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

Line 2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');

2175: END IF;
2176:
2177: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');

Line 2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

2177: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

Line 2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

2178: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

Line 2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');

2179: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

Line 2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );

2180:
2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

Line 2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

2181: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

Line 2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

2182: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2190:

Line 2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

2183: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE_AND_FORWARD');
2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2190:
2191: IF (g_po_wf_debug = 'Y') THEN

Line 2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

2184: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2190:
2191: IF (g_po_wf_debug = 'Y') THEN
2192: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Process_Response_App_Forward completed');

Line 2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

2185: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2186: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2187: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2188: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2189: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2190:
2191: IF (g_po_wf_debug = 'Y') THEN
2192: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Process_Response_App_Forward completed');
2193: END IF;

Line 2245: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2241: RETURN;
2242: END IF;
2243:
2244: --Set the global attributes in the po wrapper function
2245: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2246: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2247:
2248: l_progress := '010';
2249: IF (g_po_wf_debug = 'Y') THEN

Line 2246: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2242: END IF;
2243:
2244: --Set the global attributes in the po wrapper function
2245: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2246: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2247:
2248: l_progress := '010';
2249: IF (g_po_wf_debug = 'Y') THEN
2250: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 2271: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');

2267: l_progress := '020';
2268: process_response_internal(itemtype, itemkey, 'APPROVE');
2269: l_progress := '030';
2270:
2271: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

Line 2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

2268: process_response_internal(itemtype, itemkey, 'APPROVE');
2269: l_progress := '030';
2270:
2271: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

Line 2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');

2269: l_progress := '030';
2270:
2271: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');

Line 2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

2271: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

Line 2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

2272: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

Line 2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');

2273: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

Line 2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );

2274:
2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

Line 2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

2275: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

Line 2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

2276: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2284:

Line 2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

2277: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'APPROVE');
2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2284:
2285: l_progress := '040';

Line 2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

2278: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2284:
2285: l_progress := '040';
2286: IF (g_po_wf_debug = 'Y') THEN

Line 2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

2279: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2280: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2281: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2282: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2283: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2284:
2285: l_progress := '040';
2286: IF (g_po_wf_debug = 'Y') THEN
2287: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');

Line 2340: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2336: RETURN;
2337: END IF;
2338:
2339: --Set the global attributes in the po wrapper function
2340: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2341: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2342:
2343: l_progress := '010';
2344: IF (g_po_wf_debug = 'Y') THEN

Line 2341: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2337: END IF;
2338:
2339: --Set the global attributes in the po wrapper function
2340: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2341: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2342:
2343: l_progress := '010';
2344: IF (g_po_wf_debug = 'Y') THEN
2345: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 2368: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');

2364: AND item_key = itemkey;
2365:
2366: l_progress := '040';
2367:
2368: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

Line 2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

2365:
2366: l_progress := '040';
2367:
2368: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

Line 2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');

2366: l_progress := '040';
2367:
2368: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');

Line 2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

2368: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

Line 2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

2369: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

Line 2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');

2370: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

Line 2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );

2371:
2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

Line 2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

2372: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

Line 2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

2373: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2381:

Line 2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

2374: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'REJECT');
2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2381:
2382: l_progress := '050';

Line 2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

2375: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2381:
2382: l_progress := '050';
2383: IF (g_po_wf_debug = 'Y') THEN

Line 2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

2376: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2377: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2378: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2379: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2380: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2381:
2382: l_progress := '050';
2383: IF (g_po_wf_debug = 'Y') THEN
2384: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');

Line 2436: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2432: RETURN;
2433: END IF;
2434:
2435: --Set the global attributes in the po wrapper function
2436: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2437: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2438:
2439: l_progress := '010';
2440: IF (g_po_wf_debug = 'Y') THEN

Line 2437: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2433: END IF;
2434:
2435: --Set the global attributes in the po wrapper function
2436: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2437: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2438:
2439: l_progress := '010';
2440: IF (g_po_wf_debug = 'Y') THEN
2441: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 2462: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');

2458: l_progress := '020';
2459: process_response_internal(itemtype, itemkey, 'FORWARD');
2460: l_progress := '030';
2461:
2462: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

Line 2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

2459: process_response_internal(itemtype, itemkey, 'FORWARD');
2460: l_progress := '030';
2461:
2462: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

Line 2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');

2460: l_progress := '030';
2461:
2462: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');

Line 2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

2462: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

Line 2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

2463: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

Line 2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');

2464: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

Line 2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );

2465:
2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

Line 2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

2466: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

Line 2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

2467: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2475:

Line 2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

2468: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'FORWARD');
2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2475:
2476: l_progress := '040';

Line 2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

2469: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2475:
2476: l_progress := '040';
2477: IF (g_po_wf_debug = 'Y') THEN

Line 2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

2470: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2471: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2472: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2473: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2474: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2475:
2476: l_progress := '040';
2477: IF (g_po_wf_debug = 'Y') THEN
2478: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');

Line 2531: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2527: RETURN;
2528: END IF;
2529:
2530: --Set the global attributes in the po wrapper function
2531: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2532: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2533:
2534: l_progress := '010';
2535: IF (g_po_wf_debug = 'Y') THEN

Line 2532: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2528: END IF;
2529:
2530: --Set the global attributes in the po wrapper function
2531: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2532: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2533:
2534: l_progress := '010';
2535: IF (g_po_wf_debug = 'Y') THEN
2536: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 2558: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');

2554: AND item_key = itemkey;
2555:
2556: l_progress := '030';
2557:
2558: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

Line 2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');

2555:
2556: l_progress := '030';
2557:
2558: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

Line 2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');

2556: l_progress := '030';
2557:
2558: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');

Line 2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;

2558: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVER_EMPID');
2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

Line 2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;

2559: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_USER_NAME');
2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

Line 2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');

2560: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_DISPLAY_NAME');
2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

Line 2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );

2561:
2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

Line 2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);

2562: PO_WF_UTIL_PKG.G_ITEM_TYPE := l_parent_item_type;
2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

Line 2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);

2563: PO_WF_UTIL_PKG.G_ITEM_KEY := l_parent_item_key;
2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2571:

Line 2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );

2564: po_wf_util_pkg.SetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'TIMEOUT');
2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2571:
2572: l_progress := '040';

Line 2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );

2565: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_ID', avalue => l_child_approver_empid );
2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2571:
2572: l_progress := '040';
2573:

Line 2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );

2566: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_USER_NAME', avalue => l_child_approver_user_name);
2567: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_FROM_DISP_NAME', avalue => l_child_approver_display_name);
2568: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_EMPID', avalue => l_child_approver_empid );
2569: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_USER_NAME', avalue => l_child_approver_user_name );
2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2571:
2572: l_progress := '040';
2573:
2574: wf_engine.CompleteActivity (itemtype => l_parent_item_type,

Line 2630: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2626: RETURN;
2627: END IF;
2628:
2629: --Set the global attributes in the po wrapper function
2630: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2631: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2632:
2633: l_progress := '010';
2634: IF (g_po_wf_debug = 'Y') THEN

Line 2631: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2627: END IF;
2628:
2629: --Set the global attributes in the po wrapper function
2630: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2631: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2632:
2633: l_progress := '010';
2634: IF (g_po_wf_debug = 'Y') THEN
2635: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 2638: l_no_reminder := po_wf_util_pkg.GetItemAttrNumber( aname => 'NO_REMINDER');

2634: IF (g_po_wf_debug = 'Y') THEN
2635: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
2636: END IF;
2637:
2638: l_no_reminder := po_wf_util_pkg.GetItemAttrNumber( aname => 'NO_REMINDER');
2639: IF (l_no_reminder < 2) THEN
2640: l_no_reminder := l_no_reminder + 1;
2641: END IF;
2642: po_wf_util_pkg.SetItemAttrNumber( aname => 'NO_REMINDER', avalue => l_no_reminder );

Line 2642: po_wf_util_pkg.SetItemAttrNumber( aname => 'NO_REMINDER', avalue => l_no_reminder );

2638: l_no_reminder := po_wf_util_pkg.GetItemAttrNumber( aname => 'NO_REMINDER');
2639: IF (l_no_reminder < 2) THEN
2640: l_no_reminder := l_no_reminder + 1;
2641: END IF;
2642: po_wf_util_pkg.SetItemAttrNumber( aname => 'NO_REMINDER', avalue => l_no_reminder );
2643:
2644: l_progress := '020';
2645:
2646: IF l_no_reminder = 1 THEN

Line 2647: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'First Reminder' );

2643:
2644: l_progress := '020';
2645:
2646: IF l_no_reminder = 1 THEN
2647: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'First Reminder' );
2648: ELSIF l_no_reminder = 2 THEN
2649: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'Second Reminder' );
2650: END IF;
2651:

Line 2649: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'Second Reminder' );

2645:
2646: IF l_no_reminder = 1 THEN
2647: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'First Reminder' );
2648: ELSIF l_no_reminder = 2 THEN
2649: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'Second Reminder' );
2650: END IF;
2651:
2652: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2653: RETURN;

Line 2714: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

2710:
2711: BEGIN
2712:
2713: --Set the global attributes in the po wrapper function
2714: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2715: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2716:
2717: l_nid := wf_engine.context_nid;
2718: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);

Line 2715: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

2711: BEGIN
2712:
2713: --Set the global attributes in the po wrapper function
2714: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2715: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2716:
2717: l_nid := wf_engine.context_nid;
2718: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2719:

Line 2718: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);

2714: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2715: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2716:
2717: l_nid := wf_engine.context_nid;
2718: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2719:
2720: l_progress := '010';
2721: IF (g_po_wf_debug = 'Y') THEN
2722: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

2741: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' l_action:'||l_action);
2742: END IF;
2743:
2744: IF(l_action IS NOT NULL) THEN
2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');

Line 2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

2742: END IF;
2743:
2744: IF(l_action IS NOT NULL) THEN
2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

Line 2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

2743:
2744: IF(l_action IS NOT NULL) THEN
2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

Line 2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');

2744: IF(l_action IS NOT NULL) THEN
2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
2752:

Line 2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');

2745: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
2752:
2753: --If function mode in 'FORWARD','QUESTION','ANSWER', then fetch l_new_recipient_id from wf_engine.context_new_role.

Line 2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

2746: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
2752:
2753: --If function mode in 'FORWARD','QUESTION','ANSWER', then fetch l_new_recipient_id from wf_engine.context_new_role.
2754: --Else fetch it from original_recipient.

Line 2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

2747: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
2748: l_draft_id := po_wf_util_pkg.GetItemAttrText( aname => 'DRAFT_ID');
2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
2752:
2753: --If function mode in 'FORWARD','QUESTION','ANSWER', then fetch l_new_recipient_id from wf_engine.context_new_role.
2754: --Else fetch it from original_recipient.
2755: IF (funcmode <> 'TIMEOUT') THEN

Line 2811: po_wf_util_pkg.SetItemAttrNumber( aname => 'APPROVER_EMPID', avalue => l_new_recipient_id);

2807: ||' l_current_recipient_id:'||l_current_recipient_id);
2808: END IF;
2809:
2810: IF (funcmode = 'FORWARD' ) THEN
2811: po_wf_util_pkg.SetItemAttrNumber( aname => 'APPROVER_EMPID', avalue => l_new_recipient_id);
2812: END IF;
2813:
2814: l_progress := '080';
2815:

Line 2853: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);

2849: IF (funcmode = 'RESPOND') THEN
2850:
2851: l_progress := '100';
2852: l_nid := wf_engine.context_nid;
2853: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2854:
2855: SELECT fu.user_id
2856: INTO l_responder_id
2857: FROM fnd_user fu,

Line 2897: l_preparer_resp_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'RESPONSIBILITY_ID');

2893: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' l_session_resp_id:'||l_session_resp_id);
2894: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' l_session_appl_id:'||l_session_appl_id);
2895: END IF;
2896:
2897: l_preparer_resp_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'RESPONSIBILITY_ID');
2898: l_preparer_appl_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPLICATION_ID');
2899:
2900: l_progress := '130';
2901: IF (g_po_wf_debug = 'Y') THEN

Line 2898: l_preparer_appl_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPLICATION_ID');

2894: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' l_session_appl_id:'||l_session_appl_id);
2895: END IF;
2896:
2897: l_preparer_resp_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'RESPONSIBILITY_ID');
2898: l_preparer_appl_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPLICATION_ID');
2899:
2900: l_progress := '130';
2901: IF (g_po_wf_debug = 'Y') THEN
2902: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' l_preparer_resp_id:'||l_preparer_resp_id);

Line 2914: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

2910: --Possible in 2 scenarios:
2911: -- 1. when the response is made from email using guest user feature
2912: -- 2. When the response is made from sysadmin login
2913: -- In this case capture the session user with preparer resp and appl id
2914: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2915: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2916: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2917: ELSE
2918: -- Possible when the response is made from the default worklist without choosing a valid responsibility

Line 2915: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);

2911: -- 1. when the response is made from email using guest user feature
2912: -- 2. When the response is made from sysadmin login
2913: -- In this case capture the session user with preparer resp and appl id
2914: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2915: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2916: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2917: ELSE
2918: -- Possible when the response is made from the default worklist without choosing a valid responsibility
2919: -- In this case also capture the session user with preparer resp and appl id

Line 2916: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);

2912: -- 2. When the response is made from sysadmin login
2913: -- In this case capture the session user with preparer resp and appl id
2914: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2915: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2916: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2917: ELSE
2918: -- Possible when the response is made from the default worklist without choosing a valid responsibility
2919: -- In this case also capture the session user with preparer resp and appl id
2920: IF (l_session_resp_id IS NULL) THEN

Line 2921: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

2917: ELSE
2918: -- Possible when the response is made from the default worklist without choosing a valid responsibility
2919: -- In this case also capture the session user with preparer resp and appl id
2920: IF (l_session_resp_id IS NULL) THEN
2921: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2922: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2923: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2924: ELSE
2925: -- All values available - Possible when the response is made after choosing a correct responsibility

Line 2922: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);

2918: -- Possible when the response is made from the default worklist without choosing a valid responsibility
2919: -- In this case also capture the session user with preparer resp and appl id
2920: IF (l_session_resp_id IS NULL) THEN
2921: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2922: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2923: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2924: ELSE
2925: -- All values available - Possible when the response is made after choosing a correct responsibility
2926: IF (l_preserved_ctx = 'TRUE') THEN

Line 2923: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);

2919: -- In this case also capture the session user with preparer resp and appl id
2920: IF (l_session_resp_id IS NULL) THEN
2921: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2922: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2923: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2924: ELSE
2925: -- All values available - Possible when the response is made after choosing a correct responsibility
2926: IF (l_preserved_ctx = 'TRUE') THEN
2927: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

Line 2927: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

2923: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2924: ELSE
2925: -- All values available - Possible when the response is made after choosing a correct responsibility
2926: IF (l_preserved_ctx = 'TRUE') THEN
2927: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2928: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_session_resp_id);
2929: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_session_appl_id);
2930: ELSE
2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.

Line 2928: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_session_resp_id);

2924: ELSE
2925: -- All values available - Possible when the response is made after choosing a correct responsibility
2926: IF (l_preserved_ctx = 'TRUE') THEN
2927: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2928: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_session_resp_id);
2929: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_session_appl_id);
2930: ELSE
2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.
2932: -- Need to depend on the preparer resp and appl ids

Line 2929: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_session_appl_id);

2925: -- All values available - Possible when the response is made after choosing a correct responsibility
2926: IF (l_preserved_ctx = 'TRUE') THEN
2927: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2928: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_session_resp_id);
2929: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_session_appl_id);
2930: ELSE
2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.
2932: -- Need to depend on the preparer resp and appl ids
2933: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

Line 2933: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);

2929: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_session_appl_id);
2930: ELSE
2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.
2932: -- Need to depend on the preparer resp and appl ids
2933: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2934: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2935: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2936: END IF; --IF (l_preserved_ctx = 'TRUE') THEN
2937:

Line 2934: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);

2930: ELSE
2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.
2932: -- Need to depend on the preparer resp and appl ids
2933: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2934: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2935: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2936: END IF; --IF (l_preserved_ctx = 'TRUE') THEN
2937:
2938: END IF; --IF (l_session_resp_id IS NULL) THEN

Line 2935: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);

2931: -- The current session is a background session. So cannot depend on the session resp and appl ids.
2932: -- Need to depend on the preparer resp and appl ids
2933: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_USER_ID' ,avalue => l_responder_id);
2934: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_RESP_ID' ,avalue => l_preparer_resp_id);
2935: po_wf_util_pkg.SetItemAttrNumber( aname => 'RESPONDER_APPL_ID' ,avalue => l_preparer_appl_id);
2936: END IF; --IF (l_preserved_ctx = 'TRUE') THEN
2937:
2938: END IF; --IF (l_session_resp_id IS NULL) THEN
2939: END IF; --IF (l_responder_id <> l_session_user_id) THEN

Line 3018: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

3014: RETURN;
3015: END IF;
3016:
3017: --Set the global attributes in the po wrapper function
3018: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3019: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3020:
3021: l_progress := '010';
3022: IF (g_po_wf_debug = 'Y') THEN

Line 3019: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

3015: END IF;
3016:
3017: --Set the global attributes in the po wrapper function
3018: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3019: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3020:
3021: l_progress := '010';
3022: IF (g_po_wf_debug = 'Y') THEN
3023: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');

3022: IF (g_po_wf_debug = 'Y') THEN
3023: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3024: END IF;
3025:
3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');

Line 3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');

3023: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3024: END IF;
3025:
3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');

Line 3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');

3024: END IF;
3025:
3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');

Line 3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');

3025:
3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');
3033:

Line 3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');

3026: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');
3033:
3034: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN

Line 3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');

3027: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');
3033:
3034: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN
3035: l_header_id := l_document_id;

Line 3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');

3028: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3029: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3030: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3031: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3032: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(aname=>'LANGUAGE_CODE');
3033:
3034: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN
3035: l_header_id := l_document_id;
3036: END IF;

Line 3112: po_wf_util_pkg.SetItemAttrNumber (aname => 'REQUEST_ID', avalue => l_request_id);

3108: IF (l_request_id <= 0 OR l_request_id IS NULL) THEN
3109: RAISE SUBMISSION_ERROR;
3110: END IF;
3111:
3112: po_wf_util_pkg.SetItemAttrNumber (aname => 'REQUEST_ID', avalue => l_request_id);
3113:
3114: EXCEPTION
3115: WHEN submission_error THEN
3116: l_msg := fnd_message.get;

Line 3236: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

3232: RETURN;
3233: END IF;
3234:
3235: --Set the global attributes in the po wrapper function
3236: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3237: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3238:
3239: l_progress := '010';
3240: IF (g_po_wf_debug = 'Y') THEN

Line 3237: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

3233: END IF;
3234:
3235: --Set the global attributes in the po wrapper function
3236: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3237: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3238:
3239: l_progress := '010';
3240: IF (g_po_wf_debug = 'Y') THEN
3241: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');

3240: IF (g_po_wf_debug = 'Y') THEN
3241: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3242: END IF;
3243:
3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');

Line 3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');

3241: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3242: END IF;
3243:
3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');

Line 3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');

3242: END IF;
3243:
3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');

Line 3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');

3243:
3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3251:

Line 3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');

3244: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_TYPE');
3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3251:
3252: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN

Line 3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');

3245: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'DOCUMENT_SUBTYPE');
3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3251:
3252: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN
3253: l_header_id := l_document_id;

Line 3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');

3246: l_document_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'DOCUMENT_ID');
3247: l_revision_num := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
3248: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'LANGUAGE_CODE');
3249: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'WITH_TERMS');
3250: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(aname => 'AUTHORIZATION_STATUS');
3251:
3252: IF l_document_type IN ('PO', 'PA') AND l_document_subtype IN ('STANDARD', 'BLANKET', 'CONTRACT') THEN
3253: l_header_id := l_document_id;
3254: END IF;

Line 3329: po_wf_util_pkg.SetItemAttrText (aname => 'ZIP_ATTACHMENT',

3325: END IF;
3326:
3327: IF l_attachments_exist = 'Y' THEN
3328: l_progress := '050';
3329: po_wf_util_pkg.SetItemAttrText (aname => 'ZIP_ATTACHMENT',
3330: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.ZIP_ATTACH/' || itemtype || ':' || itemkey);
3331:
3332: /*---------------------------------------------------------------------------------
3333: An error condition is when two or more file attachments have the same file name

Line 3535: po_wf_util_pkg.SetItemAttrNumber( aname => 'REQUEST_ID', avalue => l_request_id);

3531: IF (l_request_id <= 0 OR l_request_id IS NULL) THEN
3532: RAISE SUBMISSION_ERROR;
3533: END IF;
3534:
3535: po_wf_util_pkg.SetItemAttrNumber( aname => 'REQUEST_ID', avalue => l_request_id);
3536:
3537: END IF;
3538:
3539: EXCEPTION

Line 3609: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

3605: RETURN;
3606: END IF;
3607:
3608: --Set the global attributes in the po wrapper function
3609: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3610: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3611:
3612: l_progress := '010';
3613: IF (g_po_wf_debug = 'Y') THEN

Line 3610: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

3606: END IF;
3607:
3608: --Set the global attributes in the po wrapper function
3609: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3610: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3611:
3612: l_progress := '010';
3613: IF (g_po_wf_debug = 'Y') THEN
3614: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 3617: l_forward_to_username_response := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');

3613: IF (g_po_wf_debug = 'Y') THEN
3614: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3615: END IF;
3616:
3617: l_forward_to_username_response := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');
3618: po_wf_util_pkg.SetItemAttrText ( aname => 'APPROVER_USER_NAME', avalue => l_forward_to_username_response);
3619:
3620: IF (g_po_wf_debug = 'Y') THEN
3621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress

Line 3618: po_wf_util_pkg.SetItemAttrText ( aname => 'APPROVER_USER_NAME', avalue => l_forward_to_username_response);

3614: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
3615: END IF;
3616:
3617: l_forward_to_username_response := po_wf_util_pkg.GetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE');
3618: po_wf_util_pkg.SetItemAttrText ( aname => 'APPROVER_USER_NAME', avalue => l_forward_to_username_response);
3619:
3620: IF (g_po_wf_debug = 'Y') THEN
3621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress
3622: ||' l_forward_to_username_response:'||l_forward_to_username_response);

Line 3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

3621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress
3622: ||' l_forward_to_username_response:'||l_forward_to_username_response);
3623: END IF;
3624:
3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

3622: ||' l_forward_to_username_response:'||l_forward_to_username_response);
3623: END IF;
3624:
3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

Line 3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

3623: END IF;
3624:
3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

Line 3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

3624:
3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

Line 3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

3625: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
3633:

Line 3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');

3626: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
3633:
3634: IF l_org_id IS NOT NULL THEN

Line 3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

3627: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
3633:
3634: IF l_org_id IS NOT NULL THEN
3635: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

3628: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3629: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3630: l_note := po_wf_util_pkg.GetItemAttrText( aname => 'NOTE');
3631: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3632: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
3633:
3634: IF l_org_id IS NOT NULL THEN
3635: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
3636: END IF;

Line 3755: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

3751: RETURN;
3752: END IF;
3753:
3754: --Set the global attributes in the po wrapper function
3755: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3756: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3757:
3758: l_progress := '010';
3759: IF (g_po_wf_debug = 'Y') THEN

Line 3756: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

3752: END IF;
3753:
3754: --Set the global attributes in the po wrapper function
3755: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
3756: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
3757:
3758: l_progress := '010';
3759: IF (g_po_wf_debug = 'Y') THEN
3760: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

3769: --Check if there we have encountered any ame exception.
3770: --If the value of ame_exception is not null, then we have faced some exception.
3771: --So just comlete the block activity and return
3772:
3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

Line 3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

3770: --If the value of ame_exception is not null, then we have faced some exception.
3771: --So just comlete the block activity and return
3772:
3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

3771: --So just comlete the block activity and return
3772:
3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');

Line 3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');

3772:
3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

Line 3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

3773: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');

Line 3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

3774: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');

Line 3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');

3775: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');
3783:

Line 3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

3776: l_approver_response := po_wf_util_pkg.GetItemAttrText( aname => 'APPROVER_RESPONSE');
3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');
3783:
3784: l_progress := '020';

Line 3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');

3777: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');
3783:
3784: l_progress := '020';
3785:

Line 3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');

3778: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
3779: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
3780: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
3781: l_approver_category := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_CATEGORY');
3782: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( aname => 'APPROVER_DISPLAY_NAME');
3783:
3784: l_progress := '020';
3785:
3786: IF l_approver_response = 'APPROVED' THEN

Line 3905: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

3901:
3902: FETCH l_child_wf INTO l_child_wf_cur;
3903: EXIT WHEN l_child_wf%NOTFOUND;
3904:
3905: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3906: itemkey => l_child_wf_cur.item_key,
3907: aname => 'APPROVER_EMPID');
3908: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3909: itemkey => l_child_wf_cur.item_key,

Line 3908: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

3904:
3905: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3906: itemkey => l_child_wf_cur.item_key,
3907: aname => 'APPROVER_EMPID');
3908: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3909: itemkey => l_child_wf_cur.item_key,
3910: aname => 'APPROVAL_GROUP_ID');
3911: IF (g_po_wf_debug = 'Y') THEN
3912: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress

Line 3959: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

3955: FETCH l_child_wf INTO l_child_wf_cur;
3956: EXIT WHEN l_child_wf%NOTFOUND;
3957:
3958: -- Get the approver id as the person id to update the action history
3959: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3960: itemkey => l_child_wf_cur.item_key,
3961: aname => 'APPROVER_EMPID');
3962: IF (g_po_wf_debug = 'Y') THEN
3963: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' child item_key:'||l_child_wf_cur.item_key);

Line 4061: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

4057: RETURN;
4058: END IF;
4059:
4060: --Set the global attributes in the po wrapper function
4061: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4062: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4063:
4064: l_progress := '010';
4065: IF (g_po_wf_debug = 'Y') THEN

Line 4062: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

4058: END IF;
4059:
4060: --Set the global attributes in the po wrapper function
4061: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4062: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4063:
4064: l_progress := '010';
4065: IF (g_po_wf_debug = 'Y') THEN
4066: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 4077: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

4073: AND item_key = itemkey;
4074:
4075: l_progress := '020';
4076:
4077: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
4078: itemkey => l_parent_item_key,
4079: aname => 'AME_SUB_APPROVAL_RESPONSE',
4080: avalue => 'FAILED_VERIFICATION');
4081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 4126: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

4122: RETURN;
4123: END IF;
4124:
4125: --Set the global attributes in the po wrapper function
4126: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4127: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4128:
4129: l_progress := '010';
4130: IF (g_po_wf_debug = 'Y') THEN

Line 4127: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

4123: END IF;
4124:
4125: --Set the global attributes in the po wrapper function
4126: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4127: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4128:
4129: l_progress := '010';
4130: IF (g_po_wf_debug = 'Y') THEN
4131: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 4142: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

4138: AND item_key = itemkey;
4139:
4140: l_progress := '020';
4141:
4142: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
4143: itemkey => l_parent_item_key,
4144: aname => 'AME_SUB_APPROVAL_RESPONSE',
4145: avalue => 'FALIED_VERIFICATION_REJECT');
4146: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

Line 4191: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

4187: RETURN;
4188: END IF;
4189:
4190: --Set the global attributes in the po wrapper function
4191: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4192: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4193:
4194: l_progress := '010';
4195: IF (g_po_wf_debug = 'Y') THEN

Line 4192: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

4188: END IF;
4189:
4190: --Set the global attributes in the po wrapper function
4191: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4192: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4193:
4194: l_progress := '010';
4195: IF (g_po_wf_debug = 'Y') THEN
4196: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 4199: l_ame_sub_approval_response := po_wf_util_pkg.GetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE');

4195: IF (g_po_wf_debug = 'Y') THEN
4196: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
4197: END IF;
4198:
4199: l_ame_sub_approval_response := po_wf_util_pkg.GetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE');
4200:
4201: resultout := wf_engine.eng_completed || ':' || l_ame_sub_approval_response;
4202:
4203: END get_ame_sub_approval_response;

Line 4256: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

4252: RETURN;
4253: END IF;
4254:
4255: --Set the global attributes in the po wrapper function
4256: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4257: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4258:
4259: l_progress := '010';
4260: IF (g_po_wf_debug = 'Y') THEN

Line 4257: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

4253: END IF;
4254:
4255: --Set the global attributes in the po wrapper function
4256: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4257: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4258:
4259: l_progress := '010';
4260: IF (g_po_wf_debug = 'Y') THEN
4261: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 4264: l_no_of_reminder := po_wf_util_pkg.GetItemAttrNumber( aname => 'NO_REMINDER');

4260: IF (g_po_wf_debug = 'Y') THEN
4261: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
4262: END IF;
4263:
4264: l_no_of_reminder := po_wf_util_pkg.GetItemAttrNumber( aname => 'NO_REMINDER');
4265:
4266: IF(l_no_of_reminder = 1) THEN
4267: l_action := 'FIRST REMINDER';
4268: ELSIF (l_no_of_reminder = 2) THEN

Line 4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');

4268: ELSIF (l_no_of_reminder = 2) THEN
4269: l_action := 'SECOND REMINDER';
4270: END IF;
4271:
4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

4269: l_action := 'SECOND REMINDER';
4270: END IF;
4271:
4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

Line 4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

4270: END IF;
4271:
4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

Line 4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

4271:
4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
4279:

Line 4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

4272: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
4279:
4280: l_progress := '020';

Line 4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');

4273: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
4279:
4280: l_progress := '020';
4281: IF l_org_id IS NOT NULL THEN

Line 4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');

4274: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');
4275: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
4276: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
4277: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
4278: l_org_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'ORG_ID');
4279:
4280: l_progress := '020';
4281: IF l_org_id IS NOT NULL THEN
4282: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 4352: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

4348: RETURN;
4349: END IF;
4350:
4351: --Set the global attributes in the po wrapper function
4352: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4353: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4354:
4355: l_progress := '010';
4356: IF (g_po_wf_debug = 'Y') THEN

Line 4353: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

4349: END IF;
4350:
4351: --Set the global attributes in the po wrapper function
4352: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
4353: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
4354:
4355: l_progress := '010';
4356: IF (g_po_wf_debug = 'Y') THEN
4357: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');

Line 4360: l_orgid := po_wf_util_pkg.GetItemAttrNumber ( aname => 'ORG_ID');

4356: IF (g_po_wf_debug = 'Y') THEN
4357: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Start');
4358: END IF;
4359:
4360: l_orgid := po_wf_util_pkg.GetItemAttrNumber ( aname => 'ORG_ID');
4361:
4362: IF l_orgid IS NOT NULL THEN
4363: po_moac_utils_pvt.set_org_context(l_orgid);
4364: END IF;

Line 4369: l_forward_to_username_response := po_wf_util_pkg.GetItemAttrText ( aname => 'FORWARD_TO_USERNAME_RESPONSE');

4365:
4366: --Check that the value entered by responder as the FORWARD-TO user, is actually
4367: --a valid employee (has an employee id).
4368:
4369: l_forward_to_username_response := po_wf_util_pkg.GetItemAttrText ( aname => 'FORWARD_TO_USERNAME_RESPONSE');
4370: l_forward_to_username_response := UPPER(l_forward_to_username_response);
4371:
4372: BEGIN
4373: SELECT HR.PERSON_ID

Line 4382: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);

4378: AND ROWNUM = 1;
4379:
4380: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
4381: l_error_msg := fnd_message.get;
4382: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);
4383: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');
4384: resultout := wf_engine.eng_completed||':'||'Y';
4385: EXCEPTION
4386: WHEN NO_DATA_FOUND THEN

Line 4383: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');

4379:
4380: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
4381: l_error_msg := fnd_message.get;
4382: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);
4383: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');
4384: resultout := wf_engine.eng_completed||':'||'Y';
4385: EXCEPTION
4386: WHEN NO_DATA_FOUND THEN
4387: --+ Set the error message in WRONG_FORWARD_TO_MSG so that it will be shown to the user

Line 4393: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => '');

4389: -- since the user entered an invalid forward-to, then set the
4390: -- "requires your approval" message to NULL.
4391: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
4392: l_error_msg := fnd_message.get;
4393: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => '');
4394: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => l_error_msg);
4395: resultout := wf_engine.eng_completed || ':' || 'N';
4396: END;
4397: END ame_is_forward_to_valid;

Line 4394: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => l_error_msg);

4390: -- "requires your approval" message to NULL.
4391: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
4392: l_error_msg := fnd_message.get;
4393: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => '');
4394: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => l_error_msg);
4395: resultout := wf_engine.eng_completed || ':' || 'N';
4396: END;
4397: END ame_is_forward_to_valid;
4398:

Line 4925: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

4921: p_token => l_progress,
4922: p_message => 'Current user is ' || l_current_user_name);
4923: END IF;
4924:
4925: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
4926: itemkey => l_item_key,
4927: aname => 'VIEW_DOC_URL');
4928:
4929: l_edit_po_url:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

Line 4929: l_edit_po_url:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

4925: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
4926: itemkey => l_item_key,
4927: aname => 'VIEW_DOC_URL');
4928:
4929: l_edit_po_url:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
4930: itemkey => l_item_key,
4931: aname => 'EDIT_DOC_URL' );
4932: BEGIN
4933: supress_existing_approvers(

Line 5113: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5109: -- Also update ame for current set approver with approval status as NULL, so that
5110: -- they would be fetched next time in getNextApprovers(..) for E-Signer looping.
5111:
5112: --Set the global attributes in the po wrapper function
5113: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5114: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5115:
5116: IF (g_po_wf_debug = 'Y') THEN
5117: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');

Line 5114: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5110: -- they would be fetched next time in getNextApprovers(..) for E-Signer looping.
5111:
5112: --Set the global attributes in the po wrapper function
5113: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5114: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5115:
5116: IF (g_po_wf_debug = 'Y') THEN
5117: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5118: END IF;

Line 5120: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');

5116: IF (g_po_wf_debug = 'Y') THEN
5117: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5118: END IF;
5119:
5120: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
5121: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
5122:
5123: e_signer_flag := 'N';
5124: l_approver_index := g_next_approvers.first();

Line 5121: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

5117: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5118: END IF;
5119:
5120: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'AME_TRANSACTION_ID');
5121: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
5122:
5123: e_signer_flag := 'N';
5124: l_approver_index := g_next_approvers.first();
5125:

Line 5128: po_wf_util_pkg.SetItemAttrText (aname => 'E_SIGNER_EXISTS', avalue => 'Y');

5124: l_approver_index := g_next_approvers.first();
5125:
5126: WHILE ( l_approver_index IS NOT NULL ) LOOP
5127: IF (g_next_approvers(l_approver_index).authority = 'Z' AND e_signer_flag = 'N') THEN
5128: po_wf_util_pkg.SetItemAttrText (aname => 'E_SIGNER_EXISTS', avalue => 'Y');
5129: e_signer_flag :='Y';
5130: END IF;
5131:
5132: IF(e_signer_flag = 'Y') THEN

Line 5192: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5188: RETURN;
5189: END IF;
5190:
5191: --Set the global attributes in the po wrapper function
5192: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5193: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5194:
5195: --Logic is check first for workflow attribute 'IS_FYI_APPROVER', then attribute 'APPROVER_CATEGORY'
5196: --Fetch 'IS_FYI_APPROVER' value which is set in launch_parralel_approval

Line 5193: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5189: END IF;
5190:
5191: --Set the global attributes in the po wrapper function
5192: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5193: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5194:
5195: --Logic is check first for workflow attribute 'IS_FYI_APPROVER', then attribute 'APPROVER_CATEGORY'
5196: --Fetch 'IS_FYI_APPROVER' value which is set in launch_parralel_approval
5197: l_is_fyi_approver := po_wf_util_pkg.GetItemAttrText (aname => 'IS_FYI_APPROVER');

Line 5197: l_is_fyi_approver := po_wf_util_pkg.GetItemAttrText (aname => 'IS_FYI_APPROVER');

5193: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5194:
5195: --Logic is check first for workflow attribute 'IS_FYI_APPROVER', then attribute 'APPROVER_CATEGORY'
5196: --Fetch 'IS_FYI_APPROVER' value which is set in launch_parralel_approval
5197: l_is_fyi_approver := po_wf_util_pkg.GetItemAttrText (aname => 'IS_FYI_APPROVER');
5198:
5199: IF l_is_fyi_approver = 'Y' THEN
5200: resultout := wf_engine.eng_completed || ':' || 'Y';
5201: ELSE

Line 5516: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5512: RETURN;
5513: END IF;
5514:
5515: --Set the global attributes in the po wrapper function
5516: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5517: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5518:
5519: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'ACCEPTED');
5520: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 5517: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5513: END IF;
5514:
5515: --Set the global attributes in the po wrapper function
5516: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5517: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5518:
5519: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'ACCEPTED');
5520: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5521:

Line 5519: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'ACCEPTED');

5515: --Set the global attributes in the po wrapper function
5516: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5517: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5518:
5519: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'ACCEPTED');
5520: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5521:
5522: END set_esigner_response_accepted;
5523:

Line 5562: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5558: RETURN;
5559: END IF;
5560:
5561: --Set the global attributes in the po wrapper function
5562: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5563: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5564:
5565: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'REJECTED');
5566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 5563: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5559: END IF;
5560:
5561: --Set the global attributes in the po wrapper function
5562: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5563: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5564:
5565: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'REJECTED');
5566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5567:

Line 5565: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'REJECTED');

5561: --Set the global attributes in the po wrapper function
5562: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5563: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5564:
5565: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'REJECTED');
5566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5567:
5568: END set_esigner_response_rejected;
5569:

Line 5642: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5638: -- + Call PO_ERECORDS_PVT.send_ackn to send acknowledgement.
5639: -- + Set ERECORD_ID and SIG_ID workflow attributes.
5640:
5641: --Set the global attributes in the po wrapper function
5642: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5643: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5644:
5645: IF (g_po_wf_debug = 'Y') THEN
5646: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');

Line 5643: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5639: -- + Set ERECORD_ID and SIG_ID workflow attributes.
5640:
5641: --Set the global attributes in the po wrapper function
5642: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5643: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5644:
5645: IF (g_po_wf_debug = 'Y') THEN
5646: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5647: END IF;

Line 5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

5645: IF (g_po_wf_debug = 'Y') THEN
5646: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5647: END IF;
5648:
5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');

Line 5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');

5646: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head || ' 001 ');
5647: END IF;
5648:
5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');
5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');

Line 5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');

5647: END IF;
5648:
5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');
5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');
5655:

Line 5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');

5648:
5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');
5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');
5655:
5656: l_signer := 'BUYER';

Line 5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');

5649: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');
5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');
5655:
5656: l_signer := 'BUYER';
5657: l_event_name := 'oracle.apps.po.buyersignature';

Line 5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');

5650: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'SIGNATURE_COMMENTS');
5651: l_esigner_response := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'ESIGNER_RESPONSE');
5652: l_orgid := po_wf_util_pkg.GetItemAttrNumber (aname => 'ORG_ID');
5653: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'DOCUMENT_NUMBER');
5654: l_revision := PO_WF_UTIL_PKG.GetItemAttrText( aname => 'REVISION_NUMBER');
5655:
5656: l_signer := 'BUYER';
5657: l_event_name := 'oracle.apps.po.buyersignature';
5658:

Line 5660: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'BUYER_USER_NAME');

5656: l_signer := 'BUYER';
5657: l_event_name := 'oracle.apps.po.buyersignature';
5658:
5659: l_user_name := FND_GLOBAL.user_name;
5660: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'BUYER_USER_NAME');
5661: --Get the Notification Id of the recent Signature Notification into l_notif_id.
5662: l_notif_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'NOTIFICATION_ID');
5663:
5664:

Line 5662: l_notif_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'NOTIFICATION_ID');

5658:
5659: l_user_name := FND_GLOBAL.user_name;
5660: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (aname => 'BUYER_USER_NAME');
5661: --Get the Notification Id of the recent Signature Notification into l_notif_id.
5662: l_notif_id := po_wf_util_pkg.GetItemAttrNumber (aname => 'NOTIFICATION_ID');
5663:
5664:
5665: BEGIN
5666: SELECT displayed_field

Line 5784: po_wf_util_pkg.SetItemAttrNumber (aname => 'ERECORD_ID', avalue => l_erecord_id);

5780: IF l_return_status <> 'S' THEN
5781: RAISE l_erecords_exception;
5782: END IF;
5783:
5784: po_wf_util_pkg.SetItemAttrNumber (aname => 'ERECORD_ID', avalue => l_erecord_id);
5785: po_wf_util_pkg.SetItemAttrNumber(aname => 'SIG_ID', avalue => l_signature_id);
5786:
5787: EXCEPTION
5788: WHEN l_erecords_exception then

Line 5785: po_wf_util_pkg.SetItemAttrNumber(aname => 'SIG_ID', avalue => l_signature_id);

5781: RAISE l_erecords_exception;
5782: END IF;
5783:
5784: po_wf_util_pkg.SetItemAttrNumber (aname => 'ERECORD_ID', avalue => l_erecord_id);
5785: po_wf_util_pkg.SetItemAttrNumber(aname => 'SIG_ID', avalue => l_signature_id);
5786:
5787: EXCEPTION
5788: WHEN l_erecords_exception then
5789: IF (g_po_wf_debug = 'Y') THEN

Line 5842: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

5838: RETURN;
5839: END IF;
5840:
5841: --Set the global attributes in the po wrapper function
5842: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5843: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5844:
5845: --Logic is to check for workflow attribute 'E_SIGNER_EXISTS'
5846: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');

Line 5843: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

5839: END IF;
5840:
5841: --Set the global attributes in the po wrapper function
5842: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5843: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5844:
5845: --Logic is to check for workflow attribute 'E_SIGNER_EXISTS'
5846: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
5847: IF (g_po_wf_debug = 'Y') THEN

Line 5846: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');

5842: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5843: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5844:
5845: --Logic is to check for workflow attribute 'E_SIGNER_EXISTS'
5846: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
5847: IF (g_po_wf_debug = 'Y') THEN
5848: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'PO_AME_WF_PVT.check_for_esigner_exists: ' || l_esigner_exists);
5849: END IF;
5850: resultout := wf_engine.eng_completed || ':' || l_esigner_exists;

Line 5952: PO_WF_UTIL_PKG.G_ITEM_TYPE := p_item_type;

5948: IF (g_po_wf_debug = 'Y') THEN
5949: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 001');
5950: END IF;
5951:
5952: PO_WF_UTIL_PKG.G_ITEM_TYPE := p_item_type;
5953: PO_WF_UTIL_PKG.G_ITEM_KEY := p_item_key;
5954:
5955: l_user_id := fnd_global.user_id;
5956: l_login_id := fnd_global.login_id;

Line 5953: PO_WF_UTIL_PKG.G_ITEM_KEY := p_item_key;

5949: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 001');
5950: END IF;
5951:
5952: PO_WF_UTIL_PKG.G_ITEM_TYPE := p_item_type;
5953: PO_WF_UTIL_PKG.G_ITEM_KEY := p_item_key;
5954:
5955: l_user_id := fnd_global.user_id;
5956: l_login_id := fnd_global.login_id;
5957:

Line 6052: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

6048: IF (g_po_wf_debug = 'Y') THEN
6049: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
6050: END IF;
6051:
6052: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

Line 6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

6049: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
6050: END IF;
6051:
6052: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

Line 6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');

6051:
6052: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
6058: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
6059:

Line 6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

6052: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
6058: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
6059:
6060: l_progress := '001';

Line 6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');

6053: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
6058: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
6059:
6060: l_progress := '001';
6061: IF (g_po_wf_debug = 'Y') THEN

Line 6058: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');

6054:
6055: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6056: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');
6057: l_document_subtype := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_SUBTYPE');
6058: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
6059:
6060: l_progress := '001';
6061: IF (g_po_wf_debug = 'Y') THEN
6062: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 002 Updating status DocumentId' || l_document_id);

Line 6205: po_wf_util_pkg.g_item_type := itemtype;

6201: IF (g_po_wf_debug = 'Y') THEN
6202: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
6203: END IF;
6204:
6205: po_wf_util_pkg.g_item_type := itemtype;
6206: po_wf_util_pkg.g_item_key := itemkey;
6207:
6208: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
6209:

Line 6206: po_wf_util_pkg.g_item_key := itemkey;

6202: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
6203: END IF;
6204:
6205: po_wf_util_pkg.g_item_type := itemtype;
6206: po_wf_util_pkg.g_item_key := itemkey;
6207:
6208: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
6209:
6210: -- Fetch PO approval workflow item key from pbase table.

Line 6208: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

6204:
6205: po_wf_util_pkg.g_item_type := itemtype;
6206: po_wf_util_pkg.g_item_key := itemkey;
6207:
6208: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
6209:
6210: -- Fetch PO approval workflow item key from pbase table.
6211: SELECT wf_item_key
6212: INTO l_po_itemkey

Line 6278: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

6274: IF (g_po_wf_debug = 'Y') THEN
6275: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6276: END IF;
6277: --Set the global attributes in the po wrapper function
6278: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6279: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6280:
6281: l_esigner_exists := po_wf_util_pkg.GetItemAttrText(aname => 'E_SIGNER_EXISTS');
6282:

Line 6279: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

6275: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6276: END IF;
6277: --Set the global attributes in the po wrapper function
6278: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6279: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6280:
6281: l_esigner_exists := po_wf_util_pkg.GetItemAttrText(aname => 'E_SIGNER_EXISTS');
6282:
6283: IF (g_po_wf_debug = 'Y') THEN

Line 6281: l_esigner_exists := po_wf_util_pkg.GetItemAttrText(aname => 'E_SIGNER_EXISTS');

6277: --Set the global attributes in the po wrapper function
6278: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6279: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6280:
6281: l_esigner_exists := po_wf_util_pkg.GetItemAttrText(aname => 'E_SIGNER_EXISTS');
6282:
6283: IF (g_po_wf_debug = 'Y') THEN
6284: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' l_esigners_exists ' || l_esigner_exists);
6285: END IF;

Line 6359: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

6355: IF (g_po_wf_debug = 'Y') THEN
6356: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6357: END IF;
6358: --Set the global attributes in the po wrapper function
6359: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6360: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6361:
6362: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
6363: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');

Line 6360: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

6356: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6357: END IF;
6358: --Set the global attributes in the po wrapper function
6359: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6360: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6361:
6362: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
6363: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
6364:

Line 6362: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');

6358: --Set the global attributes in the po wrapper function
6359: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6360: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6361:
6362: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
6363: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
6364:
6365: IF l_transaction_id IS NOT NULL AND l_transaction_type IS NOT NULL THEN
6366: ame_api2.getAllApprovers7(applicationIdIn => applicationId,

Line 6363: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');

6359: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6360: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6361:
6362: l_transaction_type := po_wf_util_pkg.GetItemAttrText( aname => 'AME_TRANSACTION_TYPE');
6363: l_transaction_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'AME_TRANSACTION_ID');
6364:
6365: IF l_transaction_id IS NOT NULL AND l_transaction_type IS NOT NULL THEN
6366: ame_api2.getAllApprovers7(applicationIdIn => applicationId,
6367: transactionTypeIn => l_transaction_type,

Line 6439: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;

6435: IF (g_po_wf_debug = 'Y') THEN
6436: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6437: END IF;
6438: --Set the global attributes in the po wrapper function
6439: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6440: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6441:
6442: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6443:

Line 6440: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;

6436: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001 ');
6437: END IF;
6438: --Set the global attributes in the po wrapper function
6439: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6440: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6441:
6442: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6443:
6444: BEGIN

Line 6442: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');

6438: --Set the global attributes in the po wrapper function
6439: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
6440: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
6441:
6442: l_document_id := po_wf_util_pkg.GetItemAttrNumber(aname => 'DOCUMENT_ID');
6443:
6444: BEGIN
6445: supress_existing_approvers(
6446: itemtype => itemtype,