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

Line 831: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

827: IF (ActionOriginatedFrom = 'CANCEL') THEN
828:
829: -- If approval workflow is being called from a Cancel action, then
830: -- do not insert into action history.
831: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
832: , itemkey => l_itemkey
833: , aname => 'INSERT_ACTION_HIST_FLAG'
834: , avalue => 'N'
835: );

Line 836: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

832: , itemkey => l_itemkey
833: , aname => 'INSERT_ACTION_HIST_FLAG'
834: , avalue => 'N'
835: );
836: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
837: , itemkey => l_itemkey
838: , aname => 'INTERFACE_SOURCE_CODE'
839: , avalue => ActionOriginatedFrom
840: );

Line 844: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

840: );
841: -- Bug 5701051 We should always bypass the approval hierarchy
842: -- for a Cancel action, since the approval workflow is only being
843: -- invoked for communication and archival purposes.
844: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
845: , itemkey => l_itemkey
846: , aname =>
847: 'BYPASS_APPROVAL_HIERARCHY_FLAG'
848: , avalue => 'Y'

Line 853: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

849: );
850: ELSE
851:
852: -- All other cases, we need to insert into action history.
853: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
854: , itemkey => l_itemkey
855: , aname => 'INSERT_ACTION_HIST_FLAG'
856: , avalue => 'Y'
857: );

Line 858: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

854: , itemkey => l_itemkey
855: , aname => 'INSERT_ACTION_HIST_FLAG'
856: , avalue => 'Y'
857: );
858: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
859: , itemkey => l_itemkey
860: , aname => 'INTERFACE_SOURCE_CODE'
861: , avalue => ActionOriginatedFrom
862: );

Line 865: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

861: , avalue => ActionOriginatedFrom
862: );
863: -- Bug 5701051 We do not need to bypass the approval hierarchy
864: -- for other actions.
865: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
866: , itemkey => l_itemkey
867: , aname =>
868: 'BYPASS_APPROVAL_HIERARCHY_FLAG'
869: , avalue => 'N'

Line 876: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype

872: --< Bug 3631960 End >
873:
874: IF (p_Initiator IS NOT NULL) THEN
875:
876: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype
877: , itemkey => l_itemkey
878: , aname => 'INITIATOR'
879: , avalue => p_Initiator
880: );

Line 954: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

950: itemkey => l_itemkey,
951: aname => 'PRINT_DOCUMENT',
952: avalue => PrintFlag);
953:
954: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
955: itemkey => l_itemkey,
956: aname => 'JUSTIFICATION',
957: avalue => Note);
958:

Line 1030: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1026: into l_ga_flag
1027: from po_headers_all
1028: where po_header_id = DocumentID;
1029:
1030: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1031: itemkey => l_itemkey,
1032: aname => 'GLOBAL_AGREEMENT_FLAG',
1033: avalue => l_ga_flag);
1034: END IF;

Line 1058: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype,

1054:
1055: l_doc_num_rel := l_document_number;
1056:
1057: --
1058: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype,
1059: itemkey => l_itemkey,
1060: aname => 'CONTERMS_EXIST_FLAG',
1061: avalue => l_conterms_exist_flag);
1062: --

Line 1243: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1239: aname => 'RELEASE_GENERATION_METHOD',
1240: avalue => ReleaseGenMethod);
1241:
1242: /* RETROACTIVE FPI START */
1243: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1244: itemkey => l_itemkey,
1245: aname => 'MASSUPDATE_RELEASES',
1246: avalue => MassUpdateReleases);
1247:

Line 1248: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1244: itemkey => l_itemkey,
1245: aname => 'MASSUPDATE_RELEASES',
1246: avalue => MassUpdateReleases);
1247:
1248: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1249: itemkey => l_itemkey,
1250: aname => 'CO_R_RETRO_CHANGE',
1251: avalue => RetroactivePriceChange);
1252: /* RETROACTIVE FPI END */

Line 1255: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1251: avalue => RetroactivePriceChange);
1252: /* RETROACTIVE FPI END */
1253:
1254: /* GA FPI start */
1255: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1256: itemkey => l_itemkey,
1257: aname => 'GA_ORG_ASSIGN_CHANGE',
1258: avalue => OrgAssignChange);
1259: /* GA FPI End */

Line 1262: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1258: avalue => OrgAssignChange);
1259: /* GA FPI End */
1260:
1261: --
1262: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1263: itemkey => l_itemkey,
1264: aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM',
1265: avalue => l_communicatePriceChange); -- bug4176111
1266: --

Line 1269: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1265: avalue => l_communicatePriceChange); -- bug4176111
1266: --
1267:
1268: --
1269: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1270: itemkey => l_itemkey,
1271: aname => 'BACKGROUND_FLAG',
1272: avalue => p_background_flag);
1273:

Line 1306: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1302: END;
1303:
1304: -- Workflow Attribute DROP_SHIP_FLAG added for any customizations to refer to it.
1305: -- Base Purchasing code does NOT refer to DROP_SHIP_FLAG attribute
1306: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1307: itemkey => l_itemkey,
1308: aname => 'DROP_SHIP_FLAG',
1309: avalue => l_drop_ship_flag);
1310: --

Line 1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

1335:
1336: IF l_consigned_flag = 'Y' THEN
1337: l_autoapprove_retro := 'Y';
1338:
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1340: itemkey => l_itemkey,
1341: aname => 'CO_H_RETROACTIVE_AUTOAPPROVAL',
1342: avalue => l_autoapprove_retro);
1343: END IF;

Line 1426: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1422: --In case of any exception, the supplier will show up as null
1423: null;
1424: END;
1425:
1426: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1427: itemkey => l_itemkey,
1428: aname => 'SUPPLIER',
1429: avalue => l_vendor);
1430:

Line 1431: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1427: itemkey => l_itemkey,
1428: aname => 'SUPPLIER',
1429: avalue => l_vendor);
1430:
1431: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1432: itemkey => l_itemkey,
1433: aname => 'SUPPLIER_SITE',
1434: avalue => l_vendor_site_code);
1435:

Line 1456: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1452: END;
1453: END IF;
1454:
1455: --bug#3682458 replaced legal_entity_name with operating_unit_name
1456: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1457: itemkey => l_itemkey,
1458: aname => 'OPERATING_UNIT_NAME',
1459: avalue=>l_operating_unit);
1460: --

Line 1468: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1464: --PO output format option instead of checking for the installation of
1465: --XDO product
1466: IF PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T' THEN
1467:
1468: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1469: itemkey => l_itemkey,
1470: aname => 'WITH_TERMS',
1471: avalue =>l_conterms_exist_flag);
1472:

Line 1473: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1469: itemkey => l_itemkey,
1470: aname => 'WITH_TERMS',
1471: avalue =>l_conterms_exist_flag);
1472:
1473: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1474: itemkey => l_itemkey,
1475: aname => 'LANGUAGE_CODE',
1476: avalue =>userenv('LANG'));
1477:

Line 1478: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1474: itemkey => l_itemkey,
1475: aname => 'LANGUAGE_CODE',
1476: avalue =>userenv('LANG'));
1477:
1478: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1479: itemkey => l_itemkey,
1480: aname => 'EMAIL_TEXT_WITH_PDF',
1481: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1482:

Line 1483: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1479: itemkey => l_itemkey,
1480: aname => 'EMAIL_TEXT_WITH_PDF',
1481: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1482:
1483: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1484: itemkey => l_itemkey,
1485: aname => 'PO_PDF_ERROR',
1486: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1487:

Line 1488: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1484: itemkey => l_itemkey,
1485: aname => 'PO_PDF_ERROR',
1486: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1487:
1488: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1489: itemkey => l_itemkey,
1490: aname => 'PDF_ATTACHMENT_BUYER',
1491: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1492:

Line 1496: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1492:
1493: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1494: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1495: -- supplier notifications
1496: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1497: itemkey => l_itemkey,
1498: aname => 'PDF_ATTACHMENT_SUPP',
1499: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'|| l_itemtype||':'||l_itemkey);
1500:

Line 1501: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1497: itemkey => l_itemkey,
1498: aname => 'PDF_ATTACHMENT_SUPP',
1499: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'|| l_itemtype||':'||l_itemkey);
1500:
1501: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1502: itemkey => l_itemkey,
1503: aname => 'PDF_ATTACHMENT',
1504: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'||l_itemtype||':'||l_itemkey);
1505:

Line 1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

1518: , p_document_id => DocumentID))
1519: )
1520: THEN
1521:
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1523: itemkey => l_itemkey,
1524: aname => 'OKC_DOC_ATTACHMENT',
1525: avalue =>
1526: 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'||

Line 1533: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

1529: END IF; -- not structured and not mergeable
1530:
1531: -- : Set up attachments links region.
1532: -- create attchment with actual l revision number instead of -99
1533: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
1534: itemkey => l_itemkey,
1535: aname => 'PO_OKC_ATTACHMENTS',
1536: avalue =>
1537: 'FND:entity=OKC_CONTRACT_DOCS'

Line 1851: po_wf_util_pkg.setitemattrtext because the later handles

1847: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1848:
1849:
1850: /* changed the call from wf_engine.setiteattrtext to
1851: po_wf_util_pkg.setitemattrtext because the later handles
1852: attrbute not found exception. req change order wf also
1853: uses these procedures and does not have the preparer_printer
1854: attribute, hence this was required */
1855:

Line 1857: po_wf_util_pkg.SetItemAttrText (itemtype => itemType,

1853: uses these procedures and does not have the preparer_printer
1854: attribute, hence this was required */
1855:
1856:
1857: po_wf_util_pkg.SetItemAttrText (itemtype => itemType,
1858: itemkey => itemkey,
1859: aname => 'PREPARER_PRINTER',
1860: avalue => l_printer);
1861:

Line 1862: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType,

1858: itemkey => itemkey,
1859: aname => 'PREPARER_PRINTER',
1860: avalue => l_printer);
1861:
1862: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType,
1863: itemkey => itemkey,
1864: aname => 'PREPARER_CONC_COPIES',
1865: avalue => l_conc_copies);
1866:

Line 1867: po_wf_util_pkg.SetItemAttrText (itemtype => itemType,

1863: itemkey => itemkey,
1864: aname => 'PREPARER_CONC_COPIES',
1865: avalue => l_conc_copies);
1866:
1867: po_wf_util_pkg.SetItemAttrText (itemtype => itemType,
1868: itemkey => itemkey,
1869: aname => 'PREPARER_CONC_SAVE_OUTPUT',
1870: avalue => l_conc_save_output);
1871:

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

1992:
1993: /* Bug 3800933
1994: ** Need to set the preparer's language as worflow attribute for info template attachment of req approval
1995: */
1996: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1997: itemkey => itemkey,
1998: aname => 'PREPARER_LANGUAGE',
1999: avalue => userenv('LANG'));
2000:

Line 2011: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

2007: IF l_document_type IN ('PO', 'PA') THEN
2008: --
2009: -- Set the URL and form link attributes based on doc style and type
2010: IF l_doc_subtype in ('BLANKET', 'CONTRACT') THEN
2011: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2012: itemkey => itemkey,
2013: aname => 'GLOBAL_AGREEMENT_FLAG');
2014: END IF;
2015:

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

2095:
2096: IF (l_document_type <> 'REQUISITION') then
2097: -- HTML Orders R12
2098: -- Set the URL and form attributes
2099: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2100: itemkey => itemkey,
2101: aname => 'OPEN_FORM_COMMAND' ,
2102: avalue => l_open_form);
2103:

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

2100: itemkey => itemkey,
2101: aname => 'OPEN_FORM_COMMAND' ,
2102: avalue => l_open_form);
2103:
2104: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2105: itemkey => itemkey,
2106: aname => 'VIEW_DOC_URL' ,
2107: avalue => l_view_po_url);
2108:

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

2105: itemkey => itemkey,
2106: aname => 'VIEW_DOC_URL' ,
2107: avalue => l_view_po_url);
2108:
2109: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2110: itemkey => itemkey,
2111: aname => 'EDIT_DOC_URL' ,
2112: avalue => l_edit_po_url);
2113:

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

2141: 'porMode=resubmitReq' || '&' ||
2142: 'porReqHeaderId=' || to_char(l_document_id) || '&' ||
2143: '_OrgId=' || to_char(x_orgid);
2144:
2145: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2146: itemkey => itemkey,
2147: aname => 'VIEW_REQ_DTLS_URL',
2148: avalue => l_view_req_dtls_url);
2149:

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

2146: itemkey => itemkey,
2147: aname => 'VIEW_REQ_DTLS_URL',
2148: avalue => l_view_req_dtls_url);
2149:
2150: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2151: itemkey => itemkey,
2152: aname => 'EDIT_REQ_URL',
2153: avalue => l_edit_req_url);
2154:

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

2151: itemkey => itemkey,
2152: aname => 'EDIT_REQ_URL',
2153: avalue => l_edit_req_url);
2154:
2155: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2156: itemkey => itemkey,
2157: aname => 'RESUBMIT_REQ_URL',
2158: avalue => l_resubmit_url);
2159:

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

2390:
2391: --Bug 6164753
2392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
2393:
2394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2395: itemkey => itemkey,
2396: aname => '#WFM_HTMLAGENT',
2397: avalue => l_external_url);
2398: --Bug 6164753

Line 3277: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,

3273: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3274: itemkey => itemkey,
3275: aname => 'APPROVER_EMPID');
3276:
3277: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
3278: itemkey => itemkey,
3279: aname => 'SUBMITTER_ID',
3280: avalue => l_employee_id);
3281:

Line 3524: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3520: -- Get the subtype for doc type other than requisition
3521:
3522: if l_document_type <> 'REQUISITION' THEN
3523:
3524: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3525: itemkey => itemkey,
3526: aname => 'DOCUMENT_SUBTYPE');
3527: end if;
3528:

Line 5344: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

5340: IF (g_po_wf_debug = 'Y') THEN
5341: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5342: END IF;
5343:
5344: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
5345: itemkey=>itemkey,
5346: aname=>'APPROVER_USER_NAME');
5347: if (l_approver_user_name is not null) then
5348: SELECT user_id

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

5610: END IF;
5611:
5612: -- Bug#3147435
5613: --Set the CONTRACTOR_REQUISITION_FLAG
5614: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
5615: itemkey => itemkey,
5616: aname => 'CONTRACTOR_REQUISITION_FLAG',
5617: avalue => ReqHdr_rec.contractor_requisition_flag);
5618: --

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

5618: --
5619:
5620: -- Bug#3147435
5621: --Set the CONTRACTOR_STATUS
5622: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
5623: itemkey => itemkey,
5624: aname => 'CONTRACTOR_STATUS',
5625: avalue => ReqHdr_rec.contractor_status);
5626: --

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

5775: x_amount_for_subject => l_amount_for_subject,
5776: x_amount_for_header => l_amount_for_header,
5777: x_amount_for_tax => l_amount_for_tax);
5778:
5779: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5780: itemkey => itemkey,
5781: aname => 'TOTAL_AMOUNT_DSP',
5782: avalue => l_amount_for_subject);
5783:

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

5782: avalue => l_amount_for_subject);
5783:
5784: /* begin bug 2480327 notification UI enhancement */
5785:
5786: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5787: itemkey => itemkey,
5788: aname => 'REQ_AMOUNT_CURRENCY_DSP',
5789: avalue => l_amount_for_header);
5790:

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

5787: itemkey => itemkey,
5788: aname => 'REQ_AMOUNT_CURRENCY_DSP',
5789: avalue => l_amount_for_header);
5790:
5791: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5792: itemkey => itemkey,
5793: aname => 'TAX_AMOUNT_CURRENCY_DSP',
5794: avalue => l_amount_for_tax);
5795:

Line 5811: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype,

5807: l_num_attachments := 0;
5808: end;
5809:
5810: if (l_num_attachments > 0 ) then
5811: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype,
5812: itemkey => itemkey,
5813: aname => 'ATTACHMENT',
5814: documentid =>
5815: 'FND:entity=REQ_HEADERS' || '&' || 'pk1name=REQUISITION_HEADER_ID' ||

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

5825: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5826: END IF;
5827:
5828: if (ReqHdr_rec.NOTE_TO_AUTHORIZER is not null) then
5829: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5830: itemkey => itemkey,
5831: aname => 'JUSTIFICATION',
5832: avalue => ReqHdr_rec.NOTE_TO_AUTHORIZER);
5833: end if;

Line 6707: po_wf_util_pkg.setitemattrtext because the later handles

6703:
6704:
6705: -- Context Setting Revamp.
6706: /* changed the call from wf_engine.setiteattrtext to
6707: po_wf_util_pkg.setitemattrtext because the later handles
6708: attribute not found exception. req change order wf also
6709: uses these procedures and does not have the preparer_printer
6710: attribute, hence this was required */
6711:

Line 6712: l_printer := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

6708: attribute not found exception. req change order wf also
6709: uses these procedures and does not have the preparer_printer
6710: attribute, hence this was required */
6711:
6712: l_printer := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6713: itemkey => itemkey,
6714: aname => 'PREPARER_PRINTER');
6715: -- Need to get the no of copies, and save output values for the
6716: -- preparer and pass it to the set_print_options procedure

Line 6717: l_conc_copies := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

6713: itemkey => itemkey,
6714: aname => 'PREPARER_PRINTER');
6715: -- Need to get the no of copies, and save output values for the
6716: -- preparer and pass it to the set_print_options procedure
6717: l_conc_copies := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6718: itemkey => itemkey,
6719: aname => 'PREPARER_CONC_COPIES');
6720: l_conc_save_output := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6721: itemkey => itemkey,

Line 6720: l_conc_save_output := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

6716: -- preparer and pass it to the set_print_options procedure
6717: l_conc_copies := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6718: itemkey => itemkey,
6719: aname => 'PREPARER_CONC_COPIES');
6720: l_conc_save_output := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6721: itemkey => itemkey,
6722: aname => 'PREPARER_CONC_SAVE_OUTPUT');
6723:
6724: if l_conc_save_output = 'Y' then

Line 6892: po_wf_util_pkg.setitemattrtext because the later handles

6888: -- Context Setting revamp : setting the printer to that of the preparer, so that
6889: -- irrespective of who submits the request, the printing should happen
6890: -- on preparer's printer
6891: /* changed the call from wf_engine.setiteattrtext to
6892: po_wf_util_pkg.setitemattrtext because the later handles
6893: attrbute not found exception. req change order wf also
6894: uses these procedures and does not have the preparer_printer
6895: attribute, hence this was required */
6896:

Line 6897: l_printer := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

6893: attrbute not found exception. req change order wf also
6894: uses these procedures and does not have the preparer_printer
6895: attribute, hence this was required */
6896:
6897: l_printer := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6898: itemkey => itemkey,
6899: aname => 'PREPARER_PRINTER');
6900:
6901: if (l_printer is not null) then

Line 7559: l_contractor_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

7555: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7556: END IF;
7557:
7558: IF (funcmode='RUN') THEN
7559: l_contractor_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
7560: itemkey => itemkey,
7561: aname => 'CONTRACTOR_STATUS');
7562:
7563: l_progress:='002-'||l_contractor_status;

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

7569: --Bug#3268971
7570: --Setting the item attribute value to Y, which will be used in
7571: --ReqLinesNOtificationsCO to determine whether to display the helptext
7572: --for contractor assignment
7573: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7574: itemkey => itemkey,
7575: aname => 'CONTRACTOR_ASSIGNMENT_REQD',
7576: avalue => 'Y' );
7577: resultout:='COMPLETE:'||'Y';

Line 8156: ** PO_WF_UTIL_PKG so that the missing attribute errors are ignored.

8152: aname => 'ERROR_ITEM_KEY');
8153:
8154: /* Bug# 2708702 kagarwal
8155: ** Fix Details: Make all the Set and Get calls for parent item type to use the PO wrapper
8156: ** PO_WF_UTIL_PKG so that the missing attribute errors are ignored.
8157: */
8158:
8159: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type,
8160: itemkey => l_item_key,

Line 8159: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type,

8155: ** Fix Details: Make all the Set and Get calls for parent item type to use the PO wrapper
8156: ** PO_WF_UTIL_PKG so that the missing attribute errors are ignored.
8157: */
8158:
8159: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type,
8160: itemkey => l_item_key,
8161: aname => 'PREPARER_ID');
8162:
8163: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_name, l_disp);

Line 8174: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

8170: **
8171: ** Also need to set the org context before calling the cursor
8172: */
8173:
8174: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
8175: itemkey => l_item_key,
8176: aname => 'DOCUMENT_SUBTYPE');
8177:
8178: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

Line 8178: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

8174: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
8175: itemkey => l_item_key,
8176: aname => 'DOCUMENT_SUBTYPE');
8177:
8178: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
8179: itemkey => l_item_key,
8180: aname => 'DOCUMENT_TYPE');
8181:
8182: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN

Line 8184: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

8180: aname => 'DOCUMENT_TYPE');
8181:
8182: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
8183:
8184: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
8185: itemkey => l_item_key,
8186: aname => 'GLOBAL_AGREEMENT_FLAG');
8187: END IF;
8188:

Line 8192: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8188:
8189:
8190: --
8191:
8192: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8193: (itemtype => l_item_type,
8194: itemkey => l_item_key,
8195: aname => 'DOCUMENT_ID');
8196:

Line 8200: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,

8196:
8197:
8198: if l_ga_flag = 'N' then
8199:
8200: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,
8201: itemkey => l_item_key,
8202: aname => 'ORG_ID');
8203:
8204: IF l_orgid is NOT NULL THEN

Line 8227: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

8223: end if;
8224: --
8225:
8226:
8227: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
8228: itemkey => l_item_key,
8229: aname => 'DOCUMENT_NUMBER');
8230:
8231:

Line 8232: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,

8228: itemkey => l_item_key,
8229: aname => 'DOCUMENT_NUMBER');
8230:
8231:
8232: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
8233: itemkey => l_item_key,
8234: aname => 'SYSADMIN_ERROR_MSG');
8235:
8236: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

Line 8236: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

8232: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type,
8233: itemkey => l_item_key,
8234: aname => 'SYSADMIN_ERROR_MSG');
8235:
8236: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
8237: itemkey => l_item_key,
8238: aname => 'RELEASE_NUM_DASH');
8239:
8240: l_release_num:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type,

Line 8240: l_release_num:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type,

8236: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
8237: itemkey => l_item_key,
8238: aname => 'RELEASE_NUM_DASH');
8239:
8240: l_release_num:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type,
8241: itemkey => l_item_key,
8242: aname => 'RELEASE_NUM');
8243:
8244: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

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

8240: l_release_num:= PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type,
8241: itemkey => l_item_key,
8242: aname => 'RELEASE_NUM');
8243:
8244: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
8245: itemkey => itemkey,
8246: aname => 'PREPARER_USER_NAME' ,
8247: avalue => l_name);
8248:

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

8255: itemkey => itemkey,
8256: aname => 'DOCUMENT_SUBTYPE_DISP' ,
8257: avalue => l_doc_subtype_disp);
8258: */
8259: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
8260: itemkey => itemkey,
8261: aname => 'DOCUMENT_TYPE_DISP' ,
8262: avalue => l_doc_type_disp);
8263:

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

8260: itemkey => itemkey,
8261: aname => 'DOCUMENT_TYPE_DISP' ,
8262: avalue => l_doc_type_disp);
8263:
8264: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
8265: itemkey => itemkey,
8266: aname => 'DOCUMENT_NUMBER' ,
8267: avalue => l_doc_num);
8268:

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

8265: itemkey => itemkey,
8266: aname => 'DOCUMENT_NUMBER' ,
8267: avalue => l_doc_num);
8268:
8269: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
8270: itemkey => itemkey,
8271: aname => 'RELEASE_NUM_DASH' ,
8272: avalue => l_release_num_dash);
8273:

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

8270: itemkey => itemkey,
8271: aname => 'RELEASE_NUM_DASH' ,
8272: avalue => l_release_num_dash);
8273:
8274: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
8275: itemkey => itemkey,
8276: aname => 'RELEASE_NUM' ,
8277: avalue => l_release_num);
8278:

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

8280: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
8281: /* bug 1942091. Set the Error attributes */
8282: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
8283:
8284: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
8285: itemkey => itemkey,
8286: aname => 'DOC_MGR_ERROR_NUM',
8287: avalue => l_error_number);
8288: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

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

8284: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
8285: itemkey => itemkey,
8286: aname => 'DOC_MGR_ERROR_NUM',
8287: avalue => l_error_number);
8288: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
8289: itemkey => itemkey,
8290: aname => 'SYSADMIN_ERROR_MSG' ,
8291: avalue => l_sys_error_msg);
8292: /* Set the parents doc manager error number and sysadmin error mesg*/

Line 8293: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type,

8289: itemkey => itemkey,
8290: aname => 'SYSADMIN_ERROR_MSG' ,
8291: avalue => l_sys_error_msg);
8292: /* Set the parents doc manager error number and sysadmin error mesg*/
8293: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type,
8294: itemkey => l_item_key,
8295: aname => 'DOC_MGR_ERROR_NUM',
8296: avalue => l_error_number);
8297: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type,

Line 8297: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type,

8293: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type,
8294: itemkey => l_item_key,
8295: aname => 'DOC_MGR_ERROR_NUM',
8296: avalue => l_error_number);
8297: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type,
8298: itemkey => l_item_key,
8299: aname => 'SYSADMIN_ERROR_MSG' ,
8300: avalue => l_sys_error_msg);
8301:

Line 8452: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8448: itemkey => itemkey,
8449: aname => 'DOCUMENT_TYPE');
8450:
8451: -- commented out the usage of accptance_type (FPI)
8452: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8453: itemkey => itemkey,
8454: aname => 'ACCEPTANCE_TYPE'); */
8455:
8456: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 8456: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8452: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8453: itemkey => itemkey,
8454: aname => 'ACCEPTANCE_TYPE'); */
8455:
8456: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8457: itemkey => itemkey,
8458: aname => 'ACCEPTANCE_RESULT');
8459:
8460: if x_document_type_code <> 'RELEASE' then

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

8515: x_supp_user_name := wf_notification.responder(l_nid);
8516: end if;
8517:
8518:
8519: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
8520: itemkey => itemkey,
8521: aname => 'SUPPLIER',
8522: avalue => x_vendor);
8523:

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

8522: avalue => x_vendor);
8523:
8524: -- commented out the usage of accptance_type (FPI)
8525: /* IF (x_accp_type is NULL) THEN
8526: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8527: itemkey => itemkey,
8528: aname => 'ACCEPTANCE_TYPE',
8529: avalue => 'Accepted' );
8530: END IF; */

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

8530: END IF; */
8531:
8532:
8533: IF (x_acceptance_result is NULL) THEN
8534: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8535: itemkey => itemkey,
8536: aname => 'ACCEPTANCE_RESULT',
8537: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED') );
8538: END IF;

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

8543: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName(x_supp_user_name, l_ntf_role_name);
8544: end if;
8545:
8546:
8547: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
8548: itemkey => itemkey,
8549: aname => 'SUPPLIER_USER_NAME',
8550: avalue => x_supp_user_name);
8551:

Line 8552: x_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, -- RDP

8548: itemkey => itemkey,
8549: aname => 'SUPPLIER_USER_NAME',
8550: avalue => x_supp_user_name);
8551:
8552: x_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, -- RDP
8553: itemkey => itemkey,
8554: aname => 'BUYER_USER_ID');
8555:
8556: -- Default only when the profile option is set

Line 8622: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8618: aname => 'DOCUMENT_TYPE');
8619:
8620:
8621: -- commented out the usage of accptance_type (FPI)
8622: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8623: itemkey => itemkey,
8624: aname => 'ACCEPTANCE_TYPE'); */
8625:
8626: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 8626: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

8622: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8623: itemkey => itemkey,
8624: aname => 'ACCEPTANCE_TYPE'); */
8625:
8626: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
8627: itemkey => itemkey,
8628: aname => 'ACCEPTANCE_RESULT');
8629:
8630: if x_document_type_code <> 'RELEASE' then

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

8710: x_supp_user_name := wf_notification.responder(l_nid);
8711: end if;
8712:
8713:
8714: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8715: itemkey => itemkey,
8716: aname => 'SUPPLIER',
8717: avalue => x_vendor);
8718:

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

8717: avalue => x_vendor);
8718:
8719: -- commented out the usage of accptance_type (FPI)
8720: /* IF (x_accp_type is NULL) THEN
8721: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8722: itemkey => itemkey,
8723: aname => 'ACCEPTANCE_TYPE',
8724: avalue => 'Rejected' );
8725: END IF; */

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

8725: END IF; */
8726:
8727:
8728: IF (x_acceptance_result is NULL) THEN
8729: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8730: itemkey => itemkey,
8731: aname => 'ACCEPTANCE_RESULT',
8732: avalue => 'Rejected' );
8733: END IF;

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

8737: --Get the username and store that in the supplier_user_name.
8738: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName(x_supp_user_name, l_ntf_role_name);
8739: end if;
8740:
8741: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8742: itemkey => itemkey,
8743: aname => 'SUPPLIER_USER_NAME',
8744: avalue => x_supp_user_name);
8745:

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

8762: null,
8763: null,
8764: 'ACTIVE',
8765: sysdate+1);
8766: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
8767: itemkey => itemkey,
8768: aname => 'BUYER_USER_NAME',
8769: avalue => l_role_name);
8770: end if;

Line 8826: x_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype,

8822: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
8823: itemkey => itemkey,
8824: aname => 'ACCEPTANCE_LOOKUP_CODE'); */
8825:
8826: x_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype,
8827: itemkey => itemkey,
8828: aname => 'ACCEPTANCE_COMMENTS');
8829:
8830: -- commented out the usage of accptance_type (FPI)

Line 9046: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9042: * If we had set the org context for a different operating unit, the above
9043: * fnd_global.APPS_INITIALIZE resets it back to the operating unit of
9044: * the responsibility. So set the org context explicitly again.
9045: */
9046: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9047: itemkey => itemkey,
9048: aname => 'ORG_ID');
9049:
9050: IF l_orgid is NOT NULL THEN

Line 9105: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9101: return;
9102:
9103: end if;
9104:
9105: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9106: itemkey => itemkey,
9107: aname => 'ORG_ID');
9108:
9109:

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

9106: itemkey => itemkey,
9107: aname => 'ORG_ID');
9108:
9109:
9110: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9111: itemkey => itemkey,
9112: aname => 'USER_ID');
9113:
9114: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 9114: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9110: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9111: itemkey => itemkey,
9112: aname => 'USER_ID');
9113:
9114: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9115: itemkey => itemkey,
9116: aname => 'RESPONSIBILITY_ID');
9117:
9118: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 9118: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9114: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9115: itemkey => itemkey,
9116: aname => 'RESPONSIBILITY_ID');
9117:
9118: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9119: itemkey => itemkey,
9120: aname => 'APPLICATION_ID');
9121:
9122: /* Since the call may be started from background engine (new seesion),

Line 9142: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9138: -- end if;
9139:
9140:
9141:
9142: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9143: itemkey => itemkey,
9144: aname => 'MASSUPDATE_RELEASES');
9145: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9146: itemkey => itemkey,

Line 9145: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9141:
9142: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9143: itemkey => itemkey,
9144: aname => 'MASSUPDATE_RELEASES');
9145: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9146: itemkey => itemkey,
9147: aname => 'DOCUMENT_TYPE');
9148: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
9149: itemkey => itemkey,

Line 9148: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

9144: aname => 'MASSUPDATE_RELEASES');
9145: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9146: itemkey => itemkey,
9147: aname => 'DOCUMENT_TYPE');
9148: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
9149: itemkey => itemkey,
9150: aname => 'DOCUMENT_SUBTYPE');
9151:
9152: /* the value of CREATE_SOURCING_RULE should be Y or N */

Line 9200: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

9196: */
9197:
9198: Set_doc_mgr_context(itemtype, itemkey);
9199:
9200: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
9201: itemkey => itemkey,
9202: aname => 'DOCUMENT_ID');
9203: select poh.vendor_id, poh.vendor_site_id
9204: into l_vendor_id, l_vendor_site_id

Line 9231: l_communicate_update := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9227: -- attribute CO_H_RETROACTIVE_SUPPLIER_COMM here from the
9228: -- Blanket Approval Workflow and pass it in the procedure
9229: -- call below so that it may be set correctly for Release/
9230: -- Standard PO Approval as well.
9231: l_communicate_update := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9232: itemkey => itemkey,
9233: aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM');
9234:
9235: PO_RETROACTIVE_PRICING_PVT. MassUpdate_Releases

Line 9284: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9280:
9281: BEGIN
9282: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
9283:
9284: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9285: itemkey => itemkey,
9286: aname => 'CO_R_RETRO_CHANGE');
9287:
9288: -- Bug 3694128 : get the document type and subtype

Line 9289: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9285: itemkey => itemkey,
9286: aname => 'CO_R_RETRO_CHANGE');
9287:
9288: -- Bug 3694128 : get the document type and subtype
9289: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9290: itemkey => itemkey,
9291: aname => 'DOCUMENT_TYPE');
9292:
9293: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 9293: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9289: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9290: itemkey => itemkey,
9291: aname => 'DOCUMENT_TYPE');
9292:
9293: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9294: itemkey => itemkey,
9295: aname => 'DOCUMENT_SUBTYPE');
9296:
9297: -- Bug 3694128 : The communication depends on the WF attribute only

Line 9303: l_supplier_comm := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9299: -- always communicate.
9300: If (l_retro_change = 'Y') and
9301: ((l_document_type = 'RELEASE' AND l_document_subtype = 'BLANKET') OR
9302: (l_document_type = 'PO' AND l_document_subtype = 'STANDARD')) then
9303: l_supplier_comm := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9304: itemkey => itemkey,
9305: aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM');
9306: else
9307: l_supplier_comm := 'Y';

Line 9412: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

9408: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
9409: itemkey => itemkey,
9410: aname => 'DOCUMENT_TYPE');
9411:
9412: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
9413: itemkey => itemkey,
9414: aname => 'CO_R_RETRO_CHANGE');
9415:
9416: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 02. ' ||

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

9473: END IF;
9474:
9475: -- Set 'CO_R_RETRO_CHANGE' attribute so that later Workflow process can
9476: -- use this attribute safely
9477: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
9478: itemkey => itemkey,
9479: aname => 'CO_R_RETRO_CHANGE',
9480: avalue => l_retro_change);
9481:

Line 9969: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

9965: IF (g_po_wf_debug = 'Y') THEN
9966: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
9967: END IF;
9968:
9969: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
9970: itemkey => p_item_key,
9971: aname => 'IS_SUPPLIER_CONTEXT',
9972: avalue => 'Y');
9973:

Line 10011: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

10007: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10008: END IF;
10009:
10010: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
10011: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
10012: itemkey => p_item_key,
10013: aname => 'IS_SUPPLIER_CONTEXT',
10014: avalue => 'N');
10015:

Line 10124: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

10120: IF (g_po_wf_debug = 'Y') THEN
10121: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10122: END IF;
10123:
10124: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
10125: itemkey => p_item_key,
10126: aname => 'IS_SUPPLIER_CONTEXT',
10127: avalue => 'Y');
10128:

Line 10166: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

10162: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10163: END IF;
10164:
10165: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
10166: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
10167: itemkey => p_item_key,
10168: aname => 'IS_SUPPLIER_CONTEXT',
10169: avalue => 'N');
10170: