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

APPS.PO_REQAPPROVAL_ACTION dependencies on PO_WF_UTIL_PKG

Line 375: l_draft_id := po_wf_util_pkg. GetItemAttrNumber(itemtype => itemtype,

371: aname => 'DOCUMENT_TYPE');
372:
373: -- Mod Project
374: if l_doc_type = 'PA' or l_doc_type = 'PO' then
375: l_draft_id := po_wf_util_pkg. GetItemAttrNumber(itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'DRAFT_ID');
378: If l_draft_id is Null Then
379: l_draft_id := -1;

Line 614: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

610: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
611:
612: /*Bug 11727653: BYPASSING MULTIPLE SUBMISSION CHECKS IN WORKFLOW
613: - setting the bypass flag to Y once submission checks are successful*/
614: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
615: itemkey => itemkey,
616: aname => 'BYPASS_CHECKS_FLAG',
617: avalue => 'Y');
618:

Line 705: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

701: return;
702:
703: end if;
704:
705: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'DOCUMENT_TYPE');
708:
709: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

Line 709: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

705: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'DOCUMENT_TYPE');
708:
709: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
710: itemkey => itemkey,
711: aname => 'DOCUMENT_SUBTYPE');
712:
713: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 713: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

709: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
710: itemkey => itemkey,
711: aname => 'DOCUMENT_SUBTYPE');
712:
713: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
714: itemkey => itemkey,
715: aname => 'DOCUMENT_ID');
716: -- Bug8795687: When AME is present with First responder win then
717: -- if the last approver is not the first responder then a NO ACTION

Line 721: l_is_ame_used := po_wf_util_pkg.GetItemAttrText(

717: -- if the last approver is not the first responder then a NO ACTION
718: -- is recorded in his action_code. Hence Approve action
719: -- for owner should not be captured in this case.
720:
721: l_is_ame_used := po_wf_util_pkg.GetItemAttrText(
722: itemtype => itemtype,
723: itemkey => itemkey,
724: aname => 'IS_AME_APPROVAL');
725:

Line 726: l_approver_id := po_wf_util_pkg.GetItemAttrNumber(

722: itemtype => itemtype,
723: itemkey => itemkey,
724: aname => 'IS_AME_APPROVAL');
725:
726: l_approver_id := po_wf_util_pkg.GetItemAttrNumber(
727: itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'APPROVER_EMPID');
730:

Line 731: l_preparer_id := po_wf_util_pkg.GetItemAttrNumber(

727: itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'APPROVER_EMPID');
730:
731: l_preparer_id := po_wf_util_pkg.GetItemAttrNumber(
732: itemtype => itemtype,
733: itemkey => itemkey,
734: aname => 'PREPARER_ID');
735:

Line 744: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

740: -- Bug8795687: end;
741:
742: if (l_document_type = 'REQUISITION' and l_insert_owner_app) then
743:
744: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
745: itemkey => itemkey,
746: aname => 'NOTE',
747: avalue => '');
748:

Line 849: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

845: -- Context Setting revamp
846: -- set_doc_mgr_context(itemtype, itemkey);
847:
848: /* AME Project - setting the bypass flag to N if document is getting forwarded.*/
849: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
850: itemkey => itemkey,
851: aname => 'BYPASS_CHECKS_FLAG',
852: avalue => 'N');
853:

Line 968: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

964: -- Context Setting revamp
965: -- set_doc_mgr_context(itemtype, itemkey);
966:
967: /* AME Project - setting the bypass flag to N if document is getting forwarded.*/
968: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'BYPASS_CHECKS_FLAG',
971: avalue => 'N');
972:

Line 1084: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

1080: -- Context Setting revamp
1081: -- set_doc_mgr_context(itemtype, itemkey);
1082:
1083: /* AME Project - setting the bypass flag to N if document is getting forwarded.*/
1084: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
1085: itemkey => itemkey,
1086: aname => 'BYPASS_CHECKS_FLAG',
1087: avalue => 'N');
1088: l_doc_mgr_return_val := ForwardDocPreapproved(itemtype, itemkey);

Line 1199: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

1195: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'DOCUMENT_TYPE');
1198: IF (l_document_type='PO' OR l_document_type='PA' OR l_document_type='RELEASE' ) THEN
1199: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
1200: itemkey => itemkey,
1201: aname => 'NOTE_R');
1202: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
1203: itemkey => itemkey,

Line 1202: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

1198: IF (l_document_type='PO' OR l_document_type='PA' OR l_document_type='RELEASE' ) THEN
1199: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
1200: itemkey => itemkey,
1201: aname => 'NOTE_R');
1202: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
1203: itemkey => itemkey,
1204: aname => 'NOTE',
1205: avalue => l_note);
1206: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

Line 1206: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

1202: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
1203: itemkey => itemkey,
1204: aname => 'NOTE',
1205: avalue => l_note);
1206: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
1207: itemkey => itemkey,
1208: aname => 'NOTE_R',
1209: avalue => null);
1210: END IF;

Line 1429: l_responder_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

1425: itemkey => itemkey,
1426: aname => 'DOCUMENT_TYPE');
1427:
1428:
1429: l_responder_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
1430: itemkey => itemkey,
1431: aname => 'RESPONDER_USER_ID');
1432: -- Context Setting revamp
1433: -- if (l_responder_id is null) then

Line 1458: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1454: * attribute 'ORG_ID'.
1455: *
1456: */
1457:
1458: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'ORG_ID');
1461:
1462: IF l_org_id is NOT NULL

Line 1742: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

1738:
1739: -- New call to pl/sql package PO_DOCUMENT_CHECKS_GRP.po_submission_check()
1740: -- in file POXGDCKB.pls as part of FPI project SUBMISSION CHECK REWRITE
1741:
1742: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText
1743: ( itemtype => itemtype,
1744: itemkey => itemkey,
1745: aname => 'DOCUMENT_TYPE'
1746: );

Line 1747: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText

1743: ( itemtype => itemtype,
1744: itemkey => itemkey,
1745: aname => 'DOCUMENT_TYPE'
1746: );
1747: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText
1748: ( itemtype => itemtype,
1749: itemkey => itemkey,
1750: aname => 'DOCUMENT_SUBTYPE'
1751: );

Line 1752: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1748: ( itemtype => itemtype,
1749: itemkey => itemkey,
1750: aname => 'DOCUMENT_SUBTYPE'
1751: );
1752: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1753: ( itemtype => itemtype,
1754: itemkey => itemkey,
1755: aname => 'DOCUMENT_ID'
1756: );

Line 1757: l_create_sourcing_rule := PO_WF_UTIL_PKG.GetItemAttrText -- <2757450>

1753: ( itemtype => itemtype,
1754: itemkey => itemkey,
1755: aname => 'DOCUMENT_ID'
1756: );
1757: l_create_sourcing_rule := PO_WF_UTIL_PKG.GetItemAttrText -- <2757450>
1758: ( itemtype => itemtype,
1759: itemkey => itemkey,
1760: aname => 'CREATE_SOURCING_RULE'
1761: );

Line 1764: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1760: aname => 'CREATE_SOURCING_RULE'
1761: );
1762:
1763: -- CLM Aprvl
1764: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1765: ( itemtype => itemtype,
1766: itemkey => itemkey,
1767: aname => 'DRAFT_ID'
1768: );

Line 1775: application_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1771: End If;
1772: -- CLM Aprvl
1773:
1774: -- Start of code changes for the bug 16021525
1775: application_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1776: ( itemtype => itemtype,
1777: itemkey => itemkey,
1778: aname => 'APPLICATION_ID'
1779: );

Line 1780: responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1776: ( itemtype => itemtype,
1777: itemkey => itemkey,
1778: aname => 'APPLICATION_ID'
1779: );
1780: responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1781: ( itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => 'RESPONSIBILITY_ID'
1784: );

Line 1785: user_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1781: ( itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => 'RESPONSIBILITY_ID'
1784: );
1785: user_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1786: ( itemtype => itemtype,
1787: itemkey => itemkey,
1788: aname => 'USER_ID'
1789: );

Line 1859: l_conterms_yn:= PO_wf_Util_Pkg.GetItemAttrText(

1855: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1856: END IF;
1857:
1858: --
1859: l_conterms_yn:= PO_wf_Util_Pkg.GetItemAttrText(
1860: itemtype => itemtype,
1861: itemkey => itemkey,
1862: aname => 'CONTERMS_EXIST_FLAG');
1863:

Line 1892: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,

1888: END IF;-- l_conterms_yn
1889:
1890: --
1891: /* Get the online_report_id (to be used to populate the notification */
1892: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
1893: itemkey => itemkey,
1894: aname => 'ONLINE_REPORT_ID',
1895: avalue => x_online_report_id);
1896:

Line 2624: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

2620: itemkey => itemkey,
2621: aname => 'APPROVAL_PATH_ID');
2622:
2623: -- CLM Apprvl
2624: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2625: itemkey => itemkey,
2626: aname => 'DRAFT_ID');
2627: If l_draft_id is Null Then
2628: l_draft_id := -1;

Line 3233: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemType,

3229:
3230:
3231: IF (l_document_type = 'REQUISITION') THEN --
3232: -- Set the workflow attribute Advisory Warning Check to 'Y'
3233: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemType,
3234: itemkey => itemkey,
3235: aname => 'ADVISORY_WARNING_CHECK',
3236: avalue => 'Y');
3237: END IF;

Line 3425: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,

3421: IF (X_APPLICATION_ID = -1) THEN
3422: X_APPLICATION_ID := NULL;
3423: END IF;
3424:
3425: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
3426: itemkey => itemkey,
3427: aname => 'RESPONDER_USER_ID');
3428: --
3429: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,

Line 3429: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,

3425: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
3426: itemkey => itemkey,
3427: aname => 'RESPONDER_USER_ID');
3428: --
3429: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
3430: itemkey => itemkey,
3431: aname => 'RESPONDER_APPL_ID');
3432: --
3433: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,

Line 3433: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,

3429: l_application_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
3430: itemkey => itemkey,
3431: aname => 'RESPONDER_APPL_ID');
3432: --
3433: l_responsibility_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype,
3434: itemkey => itemkey,
3435: aname => 'RESPONDER_RESP_ID');
3436:
3437: /* Bug# 2626935: kagarwal

Line 3518: l_responder_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

3514: itemkey => itemkey,
3515: aname => 'DOCUMENT_TYPE');
3516:
3517:
3518: l_responder_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
3519: itemkey => itemkey,
3520: aname => 'RESPONDER_USER_ID');
3521:
3522: -- Context Setting revamp