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

Line 95: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

91:
92:
93: /* Initialize workflow item attributes */
94:
95: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
96: itemkey => itemkey,
97: aname => 'REQ_HEADER_ID',
98: avalue => req_header_id);
99:

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

96: itemkey => itemkey,
97: aname => 'REQ_HEADER_ID',
98: avalue => req_header_id);
99:
100: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'PO_NUM_TO_CREATE',
103: avalue => po_number);
104:

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

107: * - ICX = Web Reqs
108: * - SRS = Conc. program.
109: */
110:
111: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'INTERFACE_SOURCE_CODE',
114: avalue => interface_source_code);
115:

Line 141: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

137: where requisition_header_id = req_header_id;
138:
139: end if;
140:
141: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
142: itemkey => itemkey,
143: aname => 'ORG_ID',
144: avalue => x_org_id);
145:

Line 154: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

150: FND_PROFILE.get('RESP_ID', l_responsibility_id);
151: FND_PROFILE.get('RESP_APPL_ID', l_application_id);
152:
153: -- Populate the application context workflow attributes
154: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
155: , itemkey => itemkey
156: , aname => 'USER_ID'
157: , avalue => l_user_id
158: );

Line 159: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

155: , itemkey => itemkey
156: , aname => 'USER_ID'
157: , avalue => l_user_id
158: );
159: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
160: , itemkey => itemkey
161: , aname => 'APPLICATION_ID'
162: , avalue => l_application_id
163: );

Line 164: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

160: , itemkey => itemkey
161: , aname => 'APPLICATION_ID'
162: , avalue => l_application_id
163: );
164: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
165: , itemkey => itemkey
166: , aname => 'RESPONSIBILITY_ID'
167: , avalue => l_responsibility_id
168: );

Line 214: x_autocreate_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

210: * which has a default value. All the user needs to do is change
211: * that attribute according to their needs.
212: */
213:
214: x_autocreate_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
215: itemkey => itemkey,
216: aname => 'AUTOCREATE_DOC');
217:
218: if (x_autocreate_doc = 'Y') then

Line 372: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

368: AND prh.requisition_header_id = prl.requisition_header_id;
369: --
370: BEGIN
371: /* Set org context */
372: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
373: itemkey => itemkey,
374: aname => 'ORG_ID');
375:
376: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 379: l_consume_req_demand_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber

375:
376: po_moac_utils_pvt.set_org_context(x_org_id); --
377:
378: --
379: l_consume_req_demand_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber
380: (itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'CONSUME_REQ_DEMAND_DOC_ID');
383: IF l_consume_req_demand_doc_id is null then

Line 393: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

389: * may or may not be a req_header_id passed in.
390: */
391:
392:
393: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
394: itemkey => itemkey,
395: aname => 'REQ_HEADER_ID');
396:
397: /* Get the group_id for this set of requision lines. The

Line 411: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

407: /* Store the group_id so grouping (later) only considers
408: * records with this group_id.
409: */
410:
411: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'GROUP_ID',
414: avalue => x_group_id);
415:

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

497: FROM sys.dual;
498:
499: -- Store the group_id so grouping (later) only considers
500: -- records with this group_id.
501: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
502: itemkey => itemkey,
503: aname => 'GROUP_ID',
504: avalue => x_group_id);
505:

Line 636: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

632: END IF;
633:
634: /* Initialize workflow item attributes */
635:
636: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
637: itemkey => itemkey,
638: aname => 'GROUP_ID',
639: avalue => group_id);
640:

Line 641: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

637: itemkey => itemkey,
638: aname => 'GROUP_ID',
639: avalue => group_id);
640:
641: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
642: itemkey => itemkey,
643: aname => 'REQ_LINE_ID',
644: avalue => req_line_id);
645:

Line 646: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

642: itemkey => itemkey,
643: aname => 'REQ_LINE_ID',
644: avalue => req_line_id);
645:
646: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'REQ_HEADER_ID',
649: avalue => req_header_id);
650:

Line 734: x_req_line_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

730: l_labor_req_line_id po_requisition_lines_all.labor_req_line_id%TYPE; --
731:
732: begin
733:
734: x_req_line_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
735: itemkey => itemkey,
736: aname => 'REQ_LINE_ID');
737:
738: /* Get the necessary info from the req line */

Line 802: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

798:
799:
800: /* Set the item attributes */
801:
802: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'ORG_ID',
805: avalue => x_org_id);
806:

Line 807: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

803: itemkey => itemkey,
804: aname => 'ORG_ID',
805: avalue => x_org_id);
806:
807: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'SUGGESTED_BUYER_ID',
810: avalue => x_suggested_buyer_id);
811:

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

808: itemkey => itemkey,
809: aname => 'SUGGESTED_BUYER_ID',
810: avalue => x_suggested_buyer_id);
811:
812: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'SUGGESTED_VENDOR_NAME',
815: avalue => x_suggested_vendor_name);
816:

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

813: itemkey => itemkey,
814: aname => 'SUGGESTED_VENDOR_NAME',
815: avalue => x_suggested_vendor_name);
816:
817: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
818: itemkey => itemkey,
819: aname => 'SUGGESTED_VENDOR_LOCATION',
820: avalue => x_suggested_vendor_location);
821: /* Bug 2577940 */

Line 822: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

818: itemkey => itemkey,
819: aname => 'SUGGESTED_VENDOR_LOCATION',
820: avalue => x_suggested_vendor_location);
821: /* Bug 2577940 */
822: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'SUGGESTED_VENDOR_ID',
825: avalue => x_suggested_vendor_id);
826:

Line 827: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

823: itemkey => itemkey,
824: aname => 'SUGGESTED_VENDOR_ID',
825: avalue => x_suggested_vendor_id);
826:
827: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
828: itemkey => itemkey,
829: aname => 'SUGGESTED_VENDOR_SITE_ID',
830: avalue => x_suggested_vendor_site_id);
831: /* Bug 2577940 */

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

828: itemkey => itemkey,
829: aname => 'SUGGESTED_VENDOR_SITE_ID',
830: avalue => x_suggested_vendor_site_id);
831: /* Bug 2577940 */
832: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
833: itemkey => itemkey,
834: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
835: avalue => x_source_doc_type_code);
836:

Line 837: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

833: itemkey => itemkey,
834: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
835: avalue => x_source_doc_type_code);
836:
837: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'SOURCE_DOCUMENT_ID',
840: avalue => x_source_doc_po_header_id);
841:

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

848: from po_headers_all
849: where po_header_id = x_source_doc_po_header_id;
850: end if;
851:
852: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'SOURCE_DOC_GA_FLAG',
855: avalue => x_ga_flag);
856:

Line 860: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

856:
857:
858: /* FPI GA End */
859:
860: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'SOURCE_DOCUMENT_LINE_NUM',
863: avalue => x_source_doc_line_num);
864:

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

861: itemkey => itemkey,
862: aname => 'SOURCE_DOCUMENT_LINE_NUM',
863: avalue => x_source_doc_line_num);
864:
865: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
866: itemkey => itemkey,
867: aname => 'RFQ_REQUIRED_FLAG',
868: avalue => x_rfq_required_flag);
869:

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

866: itemkey => itemkey,
867: aname => 'RFQ_REQUIRED_FLAG',
868: avalue => x_rfq_required_flag);
869:
870: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'ON_RFQ_FLAG',
873: avalue => x_on_rfq_flag);
874:

Line 875: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

871: itemkey => itemkey,
872: aname => 'ON_RFQ_FLAG',
873: avalue => x_on_rfq_flag);
874:
875: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
876: itemkey => itemkey,
877: aname => 'ITEM_ID',
878: avalue => x_item_id);
879:

Line 880: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

876: itemkey => itemkey,
877: aname => 'ITEM_ID',
878: avalue => x_item_id);
879:
880: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
881: itemkey => itemkey,
882: aname => 'CATEGORY_ID',
883: avalue => x_category_id);
884:

Line 885: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

881: itemkey => itemkey,
882: aname => 'CATEGORY_ID',
883: avalue => x_category_id);
884:
885: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'ORGANIZATION_ID',
888: avalue => x_organization_id);
889:

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

888: avalue => x_organization_id);
889:
890: -- Bug 587589, lpo, 12/11/97
891: -- Added the follow 4 lines to populate the currency_code, rate_type, rate_date and rate.
892: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
893: itemkey => itemkey,
894: aname => 'CURRENCY_CODE',
895: avalue => x_currency_code);
896:

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

893: itemkey => itemkey,
894: aname => 'CURRENCY_CODE',
895: avalue => x_currency_code);
896:
897: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'RATE_TYPE',
900: avalue => x_rate_type);
901:

Line 902: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,

898: itemkey => itemkey,
899: aname => 'RATE_TYPE',
900: avalue => x_rate_type);
901:
902: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,
903: itemkey => itemkey,
904: aname => 'RATE_DATE',
905: avalue => x_rate_date);
906:

Line 907: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

903: itemkey => itemkey,
904: aname => 'RATE_DATE',
905: avalue => x_rate_date);
906:
907: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
908: itemkey => itemkey,
909: aname => 'RATE',
910: avalue => x_rate);
911:

Line 912: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

908: itemkey => itemkey,
909: aname => 'RATE',
910: avalue => x_rate);
911:
912: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
913: itemkey => itemkey,
914: aname => 'PCARD_ID',
915: avalue => x_pcard_id);
916:

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

913: itemkey => itemkey,
914: aname => 'PCARD_ID',
915: avalue => x_pcard_id);
916:
917: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
918: itemkey => itemkey,
919: aname => 'CATALOG_TYPE',
920: avalue => x_catalog_type);
921: -- Bug 587589, lpo, 12/11/97

Line 932: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

928: x_suggested_vendor_site_id);
929: --
930:
931: --
932: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
933: itemkey => itemkey,
934: aname => 'JOB_ID',
935: avalue => l_job_id);
936:

Line 937: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

933: itemkey => itemkey,
934: aname => 'JOB_ID',
935: avalue => l_job_id);
936:
937: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
938: itemkey => itemkey,
939: aname => 'LABOR_REQ_LINE_ID',
940: avalue => l_labor_req_line_id);
941: --

Line 981: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

977:
978: begin
979:
980: /* Set org context */
981: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'ORG_ID');
984: po_moac_utils_pvt.set_org_context(x_org_id); --
985:

Line 988: x_rfq_required_flag := po_wf_util_pkg.GetItemAttrText

984: po_moac_utils_pvt.set_org_context(x_org_id); --
985:
986: /* Get rfq check flags */
987:
988: x_rfq_required_flag := po_wf_util_pkg.GetItemAttrText
989: (itemtype => itemtype,
990: itemkey => itemkey,
991: aname => 'RFQ_REQUIRED_FLAG');
992:

Line 993: x_on_rfq_flag := po_wf_util_pkg.GetItemAttrText

989: (itemtype => itemtype,
990: itemkey => itemkey,
991: aname => 'RFQ_REQUIRED_FLAG');
992:
993: x_on_rfq_flag := po_wf_util_pkg.GetItemAttrText
994: (itemtype => itemtype,
995: itemkey => itemkey,
996: aname => 'ON_RFQ_FLAG');
997:

Line 1069: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

1065: begin
1066:
1067: /* Set the org context. */
1068:
1069: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
1070: itemkey => itemkey,
1071: aname => 'ORG_ID');
1072:
1073: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 1075: x_suggested_vendor_name := po_wf_util_pkg.GetItemAttrText

1071: aname => 'ORG_ID');
1072:
1073: po_moac_utils_pvt.set_org_context(x_org_id); --
1074:
1075: x_suggested_vendor_name := po_wf_util_pkg.GetItemAttrText
1076: (itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'SUGGESTED_VENDOR_NAME');
1079:

Line 1080: x_suggested_vendor_site := po_wf_util_pkg.GetItemAttrText

1076: (itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'SUGGESTED_VENDOR_NAME');
1079:
1080: x_suggested_vendor_site := po_wf_util_pkg.GetItemAttrText
1081: (itemtype => itemtype,
1082: itemkey => itemkey,
1083: aname => 'SUGGESTED_VENDOR_LOCATION');
1084: /* Bug 2577940 */

Line 1085: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

1081: (itemtype => itemtype,
1082: itemkey => itemkey,
1083: aname => 'SUGGESTED_VENDOR_LOCATION');
1084: /* Bug 2577940 */
1085: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
1086: (itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'SUGGESTED_VENDOR_ID');
1089:

Line 1090: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

1086: (itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'SUGGESTED_VENDOR_ID');
1089:
1090: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
1091: (itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'SUGGESTED_VENDOR_SITE_ID');
1094: /* Bug 2577940 */

Line 1260: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1256: end if; /* Bug 2577940 */
1257:
1258: /* If we get here then both the vendor and vendor site are valid. */
1259:
1260: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1261: itemkey => itemkey,
1262: aname => 'SUGGESTED_VENDOR_ID',
1263: avalue => x_vendor_id);
1264:

Line 1265: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1261: itemkey => itemkey,
1262: aname => 'SUGGESTED_VENDOR_ID',
1263: avalue => x_vendor_id);
1264:
1265: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1266: itemkey => itemkey,
1267: aname => 'SUGGESTED_VENDOR_SITE_ID',
1268: avalue => x_vendor_site_id);
1269:

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

1267: aname => 'SUGGESTED_VENDOR_SITE_ID',
1268: avalue => x_vendor_site_id);
1269:
1270: /* Bug 2577940 The correct names also should be set */
1271: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1272: itemkey => itemkey,
1273: aname => 'SUGGESTED_VENDOR_NAME',
1274: avalue => x_vendor);
1275:

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

1272: itemkey => itemkey,
1273: aname => 'SUGGESTED_VENDOR_NAME',
1274: avalue => x_vendor);
1275:
1276: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1277: itemkey => itemkey,
1278: aname => 'SUGGESTED_VENDOR_LOCATION',
1279: avalue => x_vendor_site);
1280: /* Bug 2577940 */

Line 1329: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

1325: * We just need to make sure the source_doc_type, source_doc and
1326: * source_line have been populated.
1327: */
1328:
1329: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
1330: (itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
1333:

Line 1334: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

1330: (itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
1333:
1334: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
1335: (itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'SOURCE_DOCUMENT_ID');
1338:

Line 1339: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber

1335: (itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'SOURCE_DOCUMENT_ID');
1338:
1339: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
1340: (itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'SOURCE_DOCUMENT_LINE_NUM');
1343:

Line 1506: x_supplier_id := po_wf_util_pkg.GetItemAttrNumber

1502: --
1503:
1504: begin
1505:
1506: x_supplier_id := po_wf_util_pkg.GetItemAttrNumber
1507: (itemtype => itemtype,
1508: itemkey => itemkey,
1509: aname => 'SUGGESTED_VENDOR_ID');
1510:

Line 1511: x_supplier_site_id := po_wf_util_pkg.GetItemAttrNumber

1507: (itemtype => itemtype,
1508: itemkey => itemkey,
1509: aname => 'SUGGESTED_VENDOR_ID');
1510:
1511: x_supplier_site_id := po_wf_util_pkg.GetItemAttrNumber
1512: (itemtype => itemtype,
1513: itemkey => itemkey,
1514: aname => 'SUGGESTED_VENDOR_SITE_ID');
1515:

Line 1516: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText

1512: (itemtype => itemtype,
1513: itemkey => itemkey,
1514: aname => 'SUGGESTED_VENDOR_SITE_ID');
1515:
1516: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText
1517: (itemtype => itemtype,
1518: itemkey => itemkey,
1519: aname => 'USE_CONTRACT_FLAG');
1520:

Line 1521: x_item_currency := po_wf_util_pkg.GetItemAttrText

1517: (itemtype => itemtype,
1518: itemkey => itemkey,
1519: aname => 'USE_CONTRACT_FLAG');
1520:
1521: x_item_currency := po_wf_util_pkg.GetItemAttrText
1522: (itemtype => itemtype,
1523: itemkey => itemkey,
1524: aname => 'CURRENCY_CODE');
1525:

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

1594: IF (l_rate IS NULL) THEN
1595: x_contract_id := NULL;
1596: ELSE -- rate is defined
1597:
1598: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1599: itemkey => itemkey,
1600: aname => 'CURRENCY_CODE',
1601: avalue => l_currency);
1602:

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

1599: itemkey => itemkey,
1600: aname => 'CURRENCY_CODE',
1601: avalue => l_currency);
1602:
1603: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1604: itemkey => itemkey,
1605: aname => 'RATE_TYPE',
1606: avalue => l_rate_type);
1607:

Line 1608: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,

1604: itemkey => itemkey,
1605: aname => 'RATE_TYPE',
1606: avalue => l_rate_type);
1607:
1608: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,
1609: itemkey => itemkey,
1610: aname => 'RATE_DATE',
1611: avalue => l_rate_date);
1612:

Line 1613: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1609: itemkey => itemkey,
1610: aname => 'RATE_DATE',
1611: avalue => l_rate_date);
1612:
1613: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1614: itemkey => itemkey,
1615: aname => 'RATE',
1616: avalue => l_rate);
1617: END IF; -- l_rate is null

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

1617: END IF; -- l_rate is null
1618: END IF; -- l_currency <> l_base_currency
1619:
1620: IF (x_contract_id IS NOT NULL) THEN
1621: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1622: itemkey => itemkey,
1623: aname => 'SOURCE_DOC_GA_FLAG',
1624: avalue => l_gc_flag);
1625: END IF; -- x_contract_id is not null

Line 1632: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1628: --
1629:
1630: if x_contract_id is not null then
1631:
1632: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1633: itemkey => itemkey,
1634: aname => 'CONTRACT_ID',
1635: avalue => x_contract_id);
1636: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

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

1632: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1633: itemkey => itemkey,
1634: aname => 'CONTRACT_ID',
1635: avalue => x_contract_id);
1636: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1637: itemkey => itemkey,
1638: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
1639: avalue => 'CONTRACT');
1640:

Line 1645: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1641: --
1642: -- Since the ref is a contract and is stored in attr CONTRACT_ID,
1643: -- null out the reference in SOURCE_DOCUMENT_ID
1644:
1645: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'SOURCE_DOCUMENT_ID',
1648: avalue => NULL);
1649:

Line 1695: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber

1691: x_progress varchar2(300);
1692:
1693: begin
1694:
1695: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber
1696: (itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'PCARD_ID');
1699:

Line 1749: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

1745: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1746:
1747: begin
1748:
1749: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber
1750: (itemtype => itemtype,
1751: itemkey => itemkey,
1752: aname => 'SUGGESTED_BUYER_ID');
1753:

Line 1813: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

1809: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
1810:
1811: begin
1812:
1813: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
1814: itemkey => itemkey,
1815: aname => 'ORG_ID');
1816:
1817: --

Line 1818: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

1814: itemkey => itemkey,
1815: aname => 'ORG_ID');
1816:
1817: --
1818: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
1819: (itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'PURCHASING_ORG_ID');
1822: --

Line 1823: x_item_id := po_wf_util_pkg.GetItemAttrNumber

1819: (itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'PURCHASING_ORG_ID');
1822: --
1823: x_item_id := po_wf_util_pkg.GetItemAttrNumber
1824: (itemtype => itemtype,
1825: itemkey => itemkey,
1826: aname => 'ITEM_ID');
1827:

Line 1870: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

1866: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1867: END IF;
1868:
1869: else
1870: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'SUGGESTED_BUYER_ID',
1873: avalue => x_buyer_id);
1874:

Line 1914: x_category_id := po_wf_util_pkg.GetItemAttrNumber

1910: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1911:
1912: begin
1913:
1914: x_category_id := po_wf_util_pkg.GetItemAttrNumber
1915: (itemtype => itemtype,
1916: itemkey => itemkey,
1917: aname => 'CATEGORY_ID');
1918:

Line 2024: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

2020: END IF;
2021:
2022:
2023: else
2024: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2025: itemkey => itemkey,
2026: aname => 'SUGGESTED_BUYER_ID',
2027: avalue => x_agent_id);
2028:

Line 2070: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2066: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2067:
2068: begin
2069:
2070: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2071: (itemtype => itemtype,
2072: itemkey => itemkey,
2073: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2074:

Line 2075: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

2071: (itemtype => itemtype,
2072: itemkey => itemkey,
2073: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2074:
2075: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
2076: (itemtype => itemtype,
2077: itemkey => itemkey,
2078: aname => 'SOURCE_DOCUMENT_ID');
2079: if( x_source_doc_type_code = 'BLANKET' or

Line 2125: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

2121: END IF;
2122:
2123:
2124: else
2125: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => 'SUGGESTED_BUYER_ID',
2128: avalue => x_agent_id);
2129:

Line 2168: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

2164: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2165:
2166: begin
2167:
2168: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
2169: (itemtype => itemtype,
2170: itemkey => itemkey,
2171: aname => 'CONTRACT_ID');
2172:

Line 2212: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

2208:
2209: purge_expense_lines(itemtype, itemkey); --
2210:
2211: else
2212: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2213: itemkey => itemkey,
2214: aname => 'SUGGESTED_BUYER_ID',
2215: avalue => x_agent_id);
2216:

Line 2253: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2249: x_progress varchar2(300);
2250: x_ga_flag varchar2(1);
2251: begin
2252:
2253: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2254: (itemtype => itemtype,
2255: itemkey => itemkey,
2256: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2257:

Line 2264: x_ga_flag := po_wf_util_pkg.GetItemAttrText

2260: */
2261:
2262: /* FPI GA Start */
2263: /* Get the GA Flag */
2264: x_ga_flag := po_wf_util_pkg.GetItemAttrText
2265: (itemtype => itemtype,
2266: itemkey => itemkey,
2267: aname => 'SOURCE_DOC_GA_FLAG');
2268:

Line 2337: x_item_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

2333: x_progress varchar2(300);
2334:
2335: begin
2336:
2337: x_item_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
2338: itemkey => itemkey,
2339: aname => 'ITEM_ID');
2340:
2341: /* If item_id is null then this is a one-time item. */

Line 2402: x_org_id := po_wf_util_pkg.GetItemAttrNumber

2398: /* Set the org context. Backend create_po process assumes it is in
2399: * an org.
2400: */
2401:
2402: x_org_id := po_wf_util_pkg.GetItemAttrNumber
2403: (itemtype => itemtype,
2404: itemkey => itemkey,
2405: aname => 'ORG_ID');
2406:

Line 2411: x_item_id := po_wf_util_pkg.GetItemAttrNumber

2407: po_moac_utils_pvt.set_org_context(x_org_id); --
2408:
2409: /* Retrieve required info from item attributes */
2410:
2411: x_item_id := po_wf_util_pkg.GetItemAttrNumber
2412: (itemtype => itemtype,
2413: itemkey => itemkey,
2414: aname => 'ITEM_ID');
2415:

Line 2416: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

2412: (itemtype => itemtype,
2413: itemkey => itemkey,
2414: aname => 'ITEM_ID');
2415:
2416: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
2417: (itemtype => itemtype,
2418: itemkey => itemkey,
2419: aname => 'SUGGESTED_VENDOR_ID');
2420:

Line 2421: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

2417: (itemtype => itemtype,
2418: itemkey => itemkey,
2419: aname => 'SUGGESTED_VENDOR_ID');
2420:
2421: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
2422: (itemtype => itemtype,
2423: itemkey => itemkey,
2424: aname => 'SUGGESTED_VENDOR_SITE_ID');
2425:

Line 2426: x_organization_id := po_wf_util_pkg.GetItemAttrNumber

2422: (itemtype => itemtype,
2423: itemkey => itemkey,
2424: aname => 'SUGGESTED_VENDOR_SITE_ID');
2425:
2426: x_organization_id := po_wf_util_pkg.GetItemAttrNumber
2427: (itemtype => itemtype,
2428: itemkey => itemkey,
2429: aname => 'ORGANIZATION_ID');
2430: /* bug no:5943024*/

Line 2431: x_category_id := po_wf_util_pkg.GetItemAttrNumber

2427: (itemtype => itemtype,
2428: itemkey => itemkey,
2429: aname => 'ORGANIZATION_ID');
2430: /* bug no:5943024*/
2431: x_category_id := po_wf_util_pkg.GetItemAttrNumber
2432: (itemtype => itemtype,
2433: itemkey => itemkey,
2434: aname => 'CATEGORY_ID');
2435: /* end of Bug No 5943024*/

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

2497: end;
2498:
2499: /* Set item attribute so it can be used later */
2500:
2501: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
2502: itemkey => itemkey,
2503: aname => 'REL_GEN_METHOD',
2504: avalue => x_rel_gen_method);
2505:

Line 2557: x_cont_wf_for_ac_rel_gen:= po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

2553: x_progress varchar2(300);
2554:
2555: begin
2556:
2557: x_cont_wf_for_ac_rel_gen:= po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
2558: itemkey => itemkey,
2559: aname => 'CONT_WF_FOR_AC_REL_GEN');
2560:
2561: if (x_cont_wf_for_ac_rel_gen = 'Y') then

Line 2636: x_group_id:= po_wf_util_pkg.GetItemAttrNumber

2632: * processing (grouping) to work. But no harm having them there.
2633: * If in the future they are needed then they'll already be there.
2634: */
2635:
2636: x_group_id:= po_wf_util_pkg.GetItemAttrNumber
2637: (itemtype => itemtype,
2638: itemkey => itemkey,
2639: aname => 'GROUP_ID');
2640:

Line 2641: x_req_header_id:= po_wf_util_pkg.GetItemAttrNumber

2637: (itemtype => itemtype,
2638: itemkey => itemkey,
2639: aname => 'GROUP_ID');
2640:
2641: x_req_header_id:= po_wf_util_pkg.GetItemAttrNumber
2642: (itemtype => itemtype,
2643: itemkey => itemkey,
2644: aname => 'REQ_HEADER_ID');
2645:

Line 2646: x_req_line_id:= po_wf_util_pkg.GetItemAttrNumber

2642: (itemtype => itemtype,
2643: itemkey => itemkey,
2644: aname => 'REQ_HEADER_ID');
2645:
2646: x_req_line_id:= po_wf_util_pkg.GetItemAttrNumber
2647: (itemtype => itemtype,
2648: itemkey => itemkey,
2649: aname => 'REQ_LINE_ID');
2650:

Line 2651: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

2647: (itemtype => itemtype,
2648: itemkey => itemkey,
2649: aname => 'REQ_LINE_ID');
2650:
2651: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber
2652: (itemtype => itemtype,
2653: itemkey => itemkey,
2654: aname => 'SUGGESTED_BUYER_ID');
2655:

Line 2656: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2652: (itemtype => itemtype,
2653: itemkey => itemkey,
2654: aname => 'SUGGESTED_BUYER_ID');
2655:
2656: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2657: (itemtype => itemtype,
2658: itemkey => itemkey,
2659: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2660:

Line 2661: x_source_doc_id := po_wf_util_pkg.GetItemAttrNumber

2657: (itemtype => itemtype,
2658: itemkey => itemkey,
2659: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2660:
2661: x_source_doc_id := po_wf_util_pkg.GetItemAttrNumber
2662: (itemtype => itemtype,
2663: itemkey => itemkey,
2664: aname => 'SOURCE_DOCUMENT_ID');
2665:

Line 2666: x_source_doc_line := po_wf_util_pkg.GetItemAttrNumber

2662: (itemtype => itemtype,
2663: itemkey => itemkey,
2664: aname => 'SOURCE_DOCUMENT_ID');
2665:
2666: x_source_doc_line := po_wf_util_pkg.GetItemAttrNumber
2667: (itemtype => itemtype,
2668: itemkey => itemkey,
2669: aname => 'SOURCE_DOCUMENT_LINE_NUM');
2670:

Line 2672: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

2668: itemkey => itemkey,
2669: aname => 'SOURCE_DOCUMENT_LINE_NUM');
2670:
2671:
2672: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
2673: (itemtype => itemtype,
2674: itemkey => itemkey,
2675: aname => 'SUGGESTED_VENDOR_ID');
2676:

Line 2677: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

2673: (itemtype => itemtype,
2674: itemkey => itemkey,
2675: aname => 'SUGGESTED_VENDOR_ID');
2676:
2677: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
2678: (itemtype => itemtype,
2679: itemkey => itemkey,
2680: aname => 'SUGGESTED_VENDOR_SITE_ID');
2681:

Line 2683: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

2679: itemkey => itemkey,
2680: aname => 'SUGGESTED_VENDOR_SITE_ID');
2681:
2682:
2683: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
2684: (itemtype => itemtype,
2685: itemkey => itemkey,
2686: aname => 'CONTRACT_ID');
2687:

Line 2689: x_currency_code := po_wf_util_pkg.GetItemAttrText

2685: itemkey => itemkey,
2686: aname => 'CONTRACT_ID');
2687:
2688:
2689: x_currency_code := po_wf_util_pkg.GetItemAttrText
2690: (itemtype => itemtype,
2691: itemkey => itemkey,
2692: aname => 'CURRENCY_CODE');
2693:

Line 2694: x_rate_type := po_wf_util_pkg.GetItemAttrText

2690: (itemtype => itemtype,
2691: itemkey => itemkey,
2692: aname => 'CURRENCY_CODE');
2693:
2694: x_rate_type := po_wf_util_pkg.GetItemAttrText
2695: (itemtype => itemtype,
2696: itemkey => itemkey,
2697: aname => 'RATE_TYPE');
2698:

Line 2699: x_rate_date := po_wf_util_pkg.GetItemAttrDate

2695: (itemtype => itemtype,
2696: itemkey => itemkey,
2697: aname => 'RATE_TYPE');
2698:
2699: x_rate_date := po_wf_util_pkg.GetItemAttrDate
2700: (itemtype => itemtype,
2701: itemkey => itemkey,
2702: aname => 'RATE_DATE');
2703:

Line 2704: x_rate := po_wf_util_pkg.GetItemAttrNumber

2700: (itemtype => itemtype,
2701: itemkey => itemkey,
2702: aname => 'RATE_DATE');
2703:
2704: x_rate := po_wf_util_pkg.GetItemAttrNumber
2705: (itemtype => itemtype,
2706: itemkey => itemkey,
2707: aname => 'RATE');
2708:

Line 2709: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber

2705: (itemtype => itemtype,
2706: itemkey => itemkey,
2707: aname => 'RATE');
2708:
2709: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber
2710: (itemtype => itemtype,
2711: itemkey => itemkey,
2712: aname => 'PCARD_ID');
2713:

Line 2714: x_rel_gen_method := po_wf_util_pkg.GetItemAttrText

2710: (itemtype => itemtype,
2711: itemkey => itemkey,
2712: aname => 'PCARD_ID');
2713:
2714: x_rel_gen_method := po_wf_util_pkg.GetItemAttrText
2715: (itemtype => itemtype,
2716: itemkey => itemkey,
2717: aname => 'REL_GEN_METHOD');
2718:

Line 2719: x_item_id := po_wf_util_pkg.GetItemAttrText

2715: (itemtype => itemtype,
2716: itemkey => itemkey,
2717: aname => 'REL_GEN_METHOD');
2718:
2719: x_item_id := po_wf_util_pkg.GetItemAttrText
2720: (itemtype => itemtype,
2721: itemkey => itemkey,
2722: aname => 'ITEM_ID');
2723:

Line 2725: l_job_id := po_wf_util_pkg.GetItemAttrNumber

2721: itemkey => itemkey,
2722: aname => 'ITEM_ID');
2723:
2724: --
2725: l_job_id := po_wf_util_pkg.GetItemAttrNumber
2726: (itemtype => itemtype,
2727: itemkey => itemkey,
2728: aname => 'JOB_ID');
2729:

Line 3032: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

3028: * to the same group. We need to get the group_id before opening
3029: * the cursor since it is a parameter to the cursor.
3030: */
3031:
3032: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
3033: itemkey => itemkey,
3034: aname => 'GROUP_ID');
3035:
3036: /* Bug 2974129. This Grouping allowed flag should not decide the #of documents

Line 3039: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3035:
3036: /* Bug 2974129. This Grouping allowed flag should not decide the #of documents
3037: Instead this should be applied to group the lines.
3038:
3039: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3040: itemkey => itemkey,
3041: aname => 'GROUPING_ALLOWED_FLAG'); */
3042:
3043: x_group_one_time_address := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 3043: x_group_one_time_address := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3039: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3040: itemkey => itemkey,
3041: aname => 'GROUPING_ALLOWED_FLAG'); */
3042:
3043: x_group_one_time_address := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3044: itemkey => itemkey,
3045: aname => 'GROUP_ONE_ADDR_LINE_FLAG');
3046:
3047: /* if x_grouping_allowed is NULL then

Line 3763: x_org_id := po_wf_util_pkg.GetItemAttrNumber

3759: /* Set the org context. Backend create_po process assumes it is in
3760: * an org.
3761: */
3762:
3763: x_org_id := po_wf_util_pkg.GetItemAttrNumber
3764: (itemtype => itemtype,
3765: itemkey => itemkey,
3766: aname => 'ORG_ID');
3767:

Line 3778: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

3774: itemkey,
3775: x_org_id,
3776: x_suggested_vendor_site_id);
3777:
3778: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
3779: (itemtype => itemtype,
3780: itemkey => itemkey,
3781: aname => 'PURCHASING_ORG_ID');
3782:

Line 3795: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3791: This attribute should decide the grouping logic in Auto Create. If this is set Y,
3792: then the 'DEFAULT' will be populated as grope code else 'REQUISITION' will be
3793: populated as group code */
3794:
3795: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3796: itemkey => itemkey,
3797: aname => 'GROUPING_ALLOWED_FLAG');
3798:
3799: if x_grouping_allowed = 'N' then

Line 3880: x_document_num := po_wf_util_pkg.GetItemAttrText

3876: * that the doc number is unique here since the backend expects that
3877: * when using manual numbering.
3878: */
3879:
3880: x_document_num := po_wf_util_pkg.GetItemAttrText
3881: (itemtype => itemtype,
3882: itemkey => itemkey,
3883: aname => 'PO_NUM_TO_CREATE');
3884:

Line 4264: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4260: /* Set the org context. Backend create_po process assumes it is in
4261: * an org.
4262: */
4263:
4264: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4265: (itemtype => itemtype,
4266: itemkey => itemkey,
4267: aname => 'ORG_ID');
4268:

Line 4468: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4464: /* Set the org context. Backend create_po process assumes it is in
4465: * an org.
4466: */
4467:
4468: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4469: (itemtype => itemtype,
4470: itemkey => itemkey,
4471: aname => 'ORG_ID');
4472:

Line 4480: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

4476: /* Get the group id so we can launch doc creation and approval
4477: * for this group.
4478: */
4479:
4480: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
4481: itemkey => itemkey,
4482: aname => 'GROUP_ID');
4483:
4484: open c1; /* x_group_id is a parameter */

Line 4507: l_purchasing_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

4503: itemkey => itemkey,
4504: p_org_id => x_org_id,
4505: p_suggested_vendor_site_id => l_vendor_site_id);
4506:
4507: l_purchasing_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4508: itemkey => itemkey,
4509: aname => 'PURCHASING_ORG_ID');
4510:
4511: x_progress:= '6: launch_doc_creation_approval: after set_purchasing_org_id: ' ||

Line 4631: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

4627: END IF;
4628:
4629: /* Set the item attributes */
4630:
4631: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4632: itemkey => itemkey,
4633: aname => 'ORG_ID',
4634: avalue => org_id);
4635:

Line 4637: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

4633: aname => 'ORG_ID',
4634: avalue => org_id);
4635:
4636: --
4637: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4638: itemkey => itemkey,
4639: aname => 'PURCHASING_ORG_ID',
4640: avalue => purchasing_org_id);
4641: --

Line 4643: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

4639: aname => 'PURCHASING_ORG_ID',
4640: avalue => purchasing_org_id);
4641: --
4642:
4643: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4644: itemkey => itemkey,
4645: aname => 'INTERFACE_HEADER_ID',
4646: avalue => interface_header_id);
4647:

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

4645: aname => 'INTERFACE_HEADER_ID',
4646: avalue => interface_header_id);
4647:
4648:
4649: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
4650: itemkey => itemkey,
4651: aname => 'DOC_TYPE_TO_CREATE',
4652: avalue => doc_type_to_create);
4653:

Line 4655: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

4651: aname => 'DOC_TYPE_TO_CREATE',
4652: avalue => doc_type_to_create);
4653:
4654:
4655: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4656: itemkey => itemkey,
4657: aname => 'AGENT_ID',
4658: avalue => agent_id);
4659:

Line 4729: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4725: /* Set the org context. Backend create_po process assumes it is in
4726: * an org.
4727: */
4728:
4729: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4730: (itemtype => itemtype,
4731: itemkey => itemkey,
4732: aname => 'ORG_ID');
4733: --

Line 4734: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

4730: (itemtype => itemtype,
4731: itemkey => itemkey,
4732: aname => 'ORG_ID');
4733: --
4734: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
4735: (itemtype => itemtype,
4736: itemkey => itemkey,
4737: aname => 'PURCHASING_ORG_ID');
4738: --

Line 4741: x_interface_header_id := po_wf_util_pkg.GetItemAttrNumber

4737: aname => 'PURCHASING_ORG_ID');
4738: --
4739:
4740: PO_MOAC_UTILS_PVT.set_org_context(x_org_id); --
4741: x_interface_header_id := po_wf_util_pkg.GetItemAttrNumber
4742: (itemtype => itemtype,
4743: itemkey => itemkey,
4744: aname => 'INTERFACE_HEADER_ID');
4745:

Line 4800: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

4796: * creating the po or release
4797: */
4798:
4799: if (x_num_lines_processed > 0) then
4800: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4801: itemkey => itemkey,
4802: aname => 'AUTOCREATED_DOC_ID',
4803: avalue => x_autocreated_doc_id);
4804:

Line 4866: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText

4862: x_progress varchar2(300);
4863:
4864: begin
4865:
4866: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText
4867: (itemtype => itemtype,
4868: itemkey => itemkey,
4869: aname => 'DOC_TYPE_TO_CREATE');
4870:

Line 4871: x_autocreated_doc_id := po_wf_util_pkg.GetItemAttrNumber

4867: (itemtype => itemtype,
4868: itemkey => itemkey,
4869: aname => 'DOC_TYPE_TO_CREATE');
4870:
4871: x_autocreated_doc_id := po_wf_util_pkg.GetItemAttrNumber
4872: (itemtype => itemtype,
4873: itemkey => itemkey,
4874: aname => 'AUTOCREATED_DOC_ID');
4875:

Line 4877: x_agent_id := po_wf_util_pkg.GetItemAttrNumber

4873: itemkey => itemkey,
4874: aname => 'AUTOCREATED_DOC_ID');
4875:
4876:
4877: x_agent_id := po_wf_util_pkg.GetItemAttrNumber
4878: (itemtype => itemtype,
4879: itemkey => itemkey,
4880: aname => 'AGENT_ID');
4881:

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

4896: end if;
4897: --
4898:
4899:
4900: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
4901: itemkey => itemkey,
4902: aname => 'DOC_TYPE_CREATED_DISP',
4903: avalue => x_doc_type_created_disp);
4904:

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

4918: from po_headers_all
4919: where po_header_id = x_autocreated_doc_id;
4920:
4921:
4922: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
4923: itemkey => itemkey,
4924: aname => 'DOC_NUM_CREATED',
4925: avalue => x_segment1);
4926:

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

4961: and por.po_header_id = poh.po_header_id;
4962:
4963: /* Append the release num to blanket po num */
4964:
4965: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
4966: itemkey => itemkey,
4967: aname => 'DOC_NUM_CREATED',
4968: avalue => x_segment1 || ', ' ||
4969: to_char (x_release_num));

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

4977: ' ACCESS_LEVEL_CODE="MODIFY"' ||
4978: ' POXPOERL_CALLING_FORM="POXSTNOT"';
4979: end if;
4980:
4981: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
4982: itemkey => itemkey,
4983: aname => 'OPEN_FORM_COMMAND',
4984: avalue =>l_open_form );
4985:

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

4984: avalue =>l_open_form );
4985:
4986: -- HTML Orders R12
4987: -- Set the URL and form attributes
4988: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
4989: itemkey => itemkey,
4990: aname => 'VIEW_DOC_URL' ,
4991: avalue => l_view_po_url);
4992:

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

4989: itemkey => itemkey,
4990: aname => 'VIEW_DOC_URL' ,
4991: avalue => l_view_po_url);
4992:
4993: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
4994: itemkey => itemkey,
4995: aname => 'EDIT_DOC_URL' ,
4996: avalue => l_edit_po_url);
4997:

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

5013: END IF;
5014:
5015: po_reqapproval_init1.get_user_name(x_agent_id, x_username, x_user_display_name);
5016:
5017: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
5018: itemkey => itemkey,
5019: aname => 'BUYER_USERNAME',
5020: avalue => x_username);
5021:

Line 5076: x_auto_approve_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

5072: -- is set to Y then this function would return Y else it would
5073: -- return N. So Approval depends on tax calculation being successful
5074: --
5075: --
5076: x_auto_approve_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5077: itemkey => itemkey,
5078: aname => 'AUTO_APPROVE_DOC');
5079:
5080:

Line 5088: l_doc_type_to_create := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

5084: l_doc_type_to_create := null;
5085: l_doc_type := null;
5086: l_doc_subtype := null;
5087: l_return_status := null;
5088: l_doc_type_to_create := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5089: itemkey => itemkey,
5090: aname => 'DOC_TYPE_TO_CREATE');
5091:
5092: IF (l_doc_type_to_create = PO_CONSTANTS_SV.RELEASE) THEN

Line 5095: l_po_release_id := po_wf_util_pkg.GetItemAttrNumber

5091:
5092: IF (l_doc_type_to_create = PO_CONSTANTS_SV.RELEASE) THEN
5093: l_doc_type := PO_CONSTANTS_SV.RELEASE;
5094: l_doc_subtype := PO_CONSTANTS_SV.BLANKET;
5095: l_po_release_id := po_wf_util_pkg.GetItemAttrNumber
5096: (itemtype => itemtype,
5097: itemkey => itemkey,
5098: aname => 'AUTOCREATED_DOC_ID');
5099: ELSE

Line 5102: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber

5098: aname => 'AUTOCREATED_DOC_ID');
5099: ELSE
5100: l_doc_type := PO_CONSTANTS_SV.PO;
5101: l_doc_subtype := PO_CONSTANTS_SV.STANDARD;
5102: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber
5103: (itemtype => itemtype,
5104: itemkey => itemkey,
5105: aname => 'AUTOCREATED_DOC_ID');
5106: END IF;

Line 5208: x_org_id := po_wf_util_pkg.GetItemAttrNumber

5204:
5205:
5206: begin
5207:
5208: x_org_id := po_wf_util_pkg.GetItemAttrNumber
5209: (itemtype => itemtype,
5210: itemkey => itemkey,
5211: aname => 'ORG_ID');
5212:

Line 5214: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

5210: itemkey => itemkey,
5211: aname => 'ORG_ID');
5212:
5213: --
5214: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
5215: (itemtype => itemtype,
5216: itemkey => itemkey,
5217: aname => 'PURCHASING_ORG_ID');
5218: --

Line 5230: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

5226:
5227: --
5228: IF x_org_id <> l_purchasing_org_id THEN
5229: --Set the org_id to be the purchasing org for PO Approval Process
5230: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5231: itemkey => itemkey,
5232: aname => 'ORG_ID',
5233: avalue => l_purchasing_org_id);
5234: --Set the context to be that of purchasing org

Line 5241: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText

5237: END IF;
5238: --
5239: END IF;
5240:
5241: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText
5242: (itemtype => itemtype,
5243: itemkey => itemkey,
5244: aname => 'DOC_TYPE_TO_CREATE');
5245:

Line 5264: x_preparer_id:= po_wf_util_pkg.GetItemAttrNumber

5260: /* Get the doc_id, doc_num and preparer_id */
5261:
5262: /* The preparer is the same as the buyer */
5263:
5264: x_preparer_id:= po_wf_util_pkg.GetItemAttrNumber
5265: (itemtype => itemtype,
5266: itemkey => itemkey,
5267: aname => 'SUGGESTED_BUYER_ID');
5268:

Line 5269: x_doc_id:= po_wf_util_pkg.GetItemAttrNumber

5265: (itemtype => itemtype,
5266: itemkey => itemkey,
5267: aname => 'SUGGESTED_BUYER_ID');
5268:
5269: x_doc_id:= po_wf_util_pkg.GetItemAttrNumber
5270: (itemtype => itemtype,
5271: itemkey => itemkey,
5272: aname => 'AUTOCREATED_DOC_ID');
5273:

Line 5375: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

5371: x_emailflag := 'N';
5372: x_emailaddress:= null;
5373:
5374: --Bug4956479
5375: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5376: itemkey => itemkey,
5377: aname => 'SUGGESTED_BUYER_ID',
5378: avalue => x_preparer_id);
5379:

Line 5396: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

5392: x_document_num => x_doc_num );
5393:
5394: -- Bug 3152167 Get the document number and pass the same to start po approval.
5395:
5396: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5397: itemkey => itemkey,
5398: aname => 'SUGGESTED_BUYER_ID',
5399: avalue => x_preparer_id);
5400:

Line 5498: x_group_id:= po_wf_util_pkg.GetItemAttrNumber

5494: x_progress varchar2(300);
5495:
5496: begin
5497:
5498: x_group_id:= po_wf_util_pkg.GetItemAttrNumber
5499: (itemtype => itemtype,
5500: itemkey => itemkey,
5501: aname => 'GROUP_ID');
5502:

Line 5547: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

5543: x_progress varchar2(300);
5544:
5545: begin
5546:
5547: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5548: itemkey => itemkey,
5549: aname => 'REQ_HEADER_ID');
5550: BEGIN
5551: SELECT emergency_po_num

Line 5704: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

5700: * the cursor since it is a parameter to the cursor.
5701: */
5702: l_style_id := PO_DOC_STYLE_GRP.get_standard_doc_style; --
5703:
5704: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
5705: itemkey => itemkey,
5706: aname => 'GROUP_ID');
5707:
5708: x_progress := '10: put_on_one_po : group_id '||

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

6077: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6078: END IF;
6079:
6080: -- Set the attributes
6081: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6082: itemkey => itemkey,
6083: aname => 'DOCUMENT_NUMBER',
6084: avalue => l_req_num);
6085: --

Line 6086: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,

6082: itemkey => itemkey,
6083: aname => 'DOCUMENT_NUMBER',
6084: avalue => l_req_num);
6085: --
6086: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
6087: itemkey => itemkey,
6088: aname => 'DOCUMENT_ID',
6089: avalue => p_req_header_id);
6090: --

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

6087: itemkey => itemkey,
6088: aname => 'DOCUMENT_ID',
6089: avalue => p_req_header_id);
6090: --
6091: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6092: itemkey => itemkey,
6093: aname => 'DOCUMENT_TYPE_DISP',
6094: avalue => l_doc_type);
6095: --

Line 6098: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,

6094: avalue => l_doc_type);
6095: --
6096: -- Bug 2942228. The org id was getting changed from 458 to 204 when requisition was
6097: -- returned in Vision Services because it is not set as Workflow Attribute here.
6098: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
6099: itemkey => itemkey,
6100: aname => 'ORG_ID',
6101: avalue => l_org_id);
6102:

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

6104: ** Desc: We will only be using one display attribute for type and
6105: ** subtype - DOCUMENT_TYPE_DISP, hence commenting the code below
6106: */
6107: /*
6108: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6109: itemkey => itemkey,
6110: aname => 'DOCUMENT_SUBTYPE_DISP',
6111: avalue => l_doc_subtype);
6112: --

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

6119: ** document_type_code and document_subtype from po_document_types, because
6120: ** these are used in PO_REQAPPROVAL_INIT1.SetReqHdrAttributes to set the item
6121: ** attribute for DOCUMENT_TYPE_DISP.
6122: */
6123: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6124: itemkey => itemkey,
6125: aname => 'DOCUMENT_TYPE',
6126: avalue => l_doc_type_code);
6127: --

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

6124: itemkey => itemkey,
6125: aname => 'DOCUMENT_TYPE',
6126: avalue => l_doc_type_code);
6127: --
6128: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6129: itemkey => itemkey,
6130: aname => 'DOCUMENT_SUBTYPE',
6131: avalue => l_doc_subtype);
6132: --

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

6130: aname => 'DOCUMENT_SUBTYPE',
6131: avalue => l_doc_subtype);
6132: --
6133:
6134: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6135: itemkey => itemkey,
6136: aname => 'NOTE',
6137: avalue => p_reason);
6138: --

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

6135: itemkey => itemkey,
6136: aname => 'NOTE',
6137: avalue => p_reason);
6138: --
6139: po_wf_util_pkg.SetItemAttrText ( itemtype => itemType,
6140: itemkey => itemkey,
6141: aname => 'PREPARER_USER_NAME' ,
6142: avalue => l_preparer_user_name);
6143:

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

6140: itemkey => itemkey,
6141: aname => 'PREPARER_USER_NAME' ,
6142: avalue => l_preparer_user_name);
6143:
6144: po_wf_util_pkg.SetItemAttrText ( itemtype => itemType,
6145: itemkey => itemkey,
6146: aname => 'PREPARER_DISPLAY_NAME' ,
6147: avalue => l_preparer_disp_name);
6148:

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

6145: itemkey => itemkey,
6146: aname => 'PREPARER_DISPLAY_NAME' ,
6147: avalue => l_preparer_disp_name);
6148:
6149: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6150: itemkey => itemkey,
6151: aname => 'APPROVER_DISPLAY_NAME' ,
6152: avalue => l_agent_name);
6153:

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

6151: aname => 'APPROVER_DISPLAY_NAME' ,
6152: avalue => l_agent_name);
6153:
6154:
6155: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6156: itemkey => itemkey,
6157: aname => 'REQ_URL' ,
6158: avalue => l_open_req_url);
6159:

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

6156: itemkey => itemkey,
6157: aname => 'REQ_URL' ,
6158: avalue => l_open_req_url);
6159:
6160: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6161: itemkey => itemkey,
6162: aname => 'REQ_UPDATE_URL' ,
6163: avalue => l_update_req_url);
6164:

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

6161: itemkey => itemkey,
6162: aname => 'REQ_UPDATE_URL' ,
6163: avalue => l_update_req_url);
6164:
6165: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6166: itemkey => itemkey,
6167: aname => 'REQ_RESUBMIT_URL' ,
6168: avalue => l_resubmit_req_url);
6169:

Line 6283: x_contract_required_flag := po_wf_util_pkg.GetItemAttrText

6279: x_progress varchar2(300) := '000';
6280:
6281: begin
6282:
6283: x_contract_required_flag := po_wf_util_pkg.GetItemAttrText
6284: (itemtype => itemtype,
6285: itemkey => itemkey,
6286: aname => 'CONTRACT_REQUIRED_FLAG');
6287:

Line 6326: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText

6322: x_progress varchar2(300) := '000';
6323:
6324: begin
6325:
6326: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText
6327: (itemtype => itemtype,
6328: itemkey => itemkey,
6329: aname => 'USE_CONTRACT_FLAG');
6330:

Line 6372: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

6368: x_catalog_type varchar2(30);
6369:
6370: begin
6371:
6372: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6373: itemkey => itemkey,
6374: aname => 'CATALOG_TYPE');
6375:
6376: if nvl(x_catalog_type, 'CATALOG') <> 'NONCATALOG' then

Line 6432: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

6428: * source_line have been populated.
6429: * here it will just validate the contract docuement type.
6430: */
6431:
6432: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
6433: (itemtype => itemtype,
6434: itemkey => itemkey,
6435: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6436:

Line 6437: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

6433: (itemtype => itemtype,
6434: itemkey => itemkey,
6435: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6436:
6437: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
6438: (itemtype => itemtype,
6439: itemkey => itemkey,
6440: aname => 'SOURCE_DOCUMENT_ID');
6441:

Line 6442: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber

6438: (itemtype => itemtype,
6439: itemkey => itemkey,
6440: aname => 'SOURCE_DOCUMENT_ID');
6441:
6442: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
6443: (itemtype => itemtype,
6444: itemkey => itemkey,
6445: aname => 'SOURCE_DOCUMENT_LINE_NUM');
6446: x_source_currency_code := po_wf_util_pkg.GetItemAttrText

Line 6446: x_source_currency_code := po_wf_util_pkg.GetItemAttrText

6442: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
6443: (itemtype => itemtype,
6444: itemkey => itemkey,
6445: aname => 'SOURCE_DOCUMENT_LINE_NUM');
6446: x_source_currency_code := po_wf_util_pkg.GetItemAttrText
6447: (itemtype => itemtype,
6448: itemkey => itemkey,
6449: aname => 'CURRENCY_CODE');
6450:

Line 6452: l_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

6448: itemkey => itemkey,
6449: aname => 'CURRENCY_CODE');
6450:
6451: --
6452: l_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
6453: (itemtype => itemtype,
6454: itemkey => itemkey,
6455: aname => 'SUGGESTED_VENDOR_SITE_ID');
6456: --

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

6514: resultout := wf_engine.eng_completed || ':' || 'Y';
6515:
6516: else
6517: resultout := wf_engine.eng_completed || ':' || 'N';
6518: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
6519: itemkey => itemkey,
6520: aname => 'CONTRACT_REQUIRED_FLAG',
6521: avalue => 'Y');
6522: end if;

Line 6535: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

6531: IF (g_po_wf_debug = 'Y') THEN
6532: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
6533: END IF;
6534:
6535: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
6536: itemkey => itemkey,
6537: aname => 'CONTRACT_ID',
6538: avalue => x_source_doc_po_header_id);
6539:

Line 6544: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

6540: --
6541: -- Since the ref is a contract and is stored in attr CONTRACT_ID,
6542: -- null out the reference in SOURCE_DOCUMENT_ID
6543:
6544: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
6545: itemkey => itemkey,
6546: aname => 'SOURCE_DOCUMENT_ID',
6547: avalue => NULL);
6548:

Line 6590: x_incl_non_ctlg_req_flag := po_wf_util_pkg.GetItemAttrText

6586:
6587: begin
6588:
6589:
6590: x_incl_non_ctlg_req_flag := po_wf_util_pkg.GetItemAttrText
6591: (itemtype => itemtype,
6592: itemkey => itemkey,
6593: aname => 'INCLUDE_NON_CATALOG_REQ_FLAG');
6594:

Line 6685: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

6681:
6682: begin
6683:
6684: /* Set org context */
6685: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6686: itemkey => itemkey,
6687: aname => 'ORG_ID');
6688:
6689: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 6691: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

6687: aname => 'ORG_ID');
6688:
6689: po_moac_utils_pvt.set_org_context(x_org_id); --
6690:
6691: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
6692: (itemtype => itemtype,
6693: itemkey => itemkey,
6694: aname => 'SOURCE_DOCUMENT_ID');
6695:

Line 6696: x_ga_flag := po_wf_util_pkg.GetItemAttrText

6692: (itemtype => itemtype,
6693: itemkey => itemkey,
6694: aname => 'SOURCE_DOCUMENT_ID');
6695:
6696: x_ga_flag := po_wf_util_pkg.GetItemAttrText
6697: (itemtype => itemtype,
6698: itemkey => itemkey,
6699: aname => 'SOURCE_DOC_GA_FLAG');
6700:

Line 6849: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

6845: l_return_status VARCHAR2(1) := 'N';
6846:
6847: BEGIN
6848: --Set org context
6849: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6850: itemkey => itemkey,
6851: aname => 'ORG_ID');
6852:
6853: IF x_org_id IS NOT NULL THEN

Line 6861: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

6857: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
6858: x_progress := '10: buyer_on_src_doc_ok: result = Y';
6859: resultout := wf_engine.eng_completed || ':' || 'Y';
6860: ELSE --cross business group profile is 'N'
6861: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
6862: (itemtype => itemtype,
6863: itemkey => itemkey,
6864: aname => 'SOURCE_DOCUMENT_ID');
6865:

Line 6866: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

6862: (itemtype => itemtype,
6863: itemkey => itemkey,
6864: aname => 'SOURCE_DOCUMENT_ID');
6865:
6866: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
6867: (itemtype => itemtype,
6868: itemkey => itemkey,
6869: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6870:

Line 6871: x_ga_flag := po_wf_util_pkg.GetItemAttrText

6867: (itemtype => itemtype,
6868: itemkey => itemkey,
6869: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6870:
6871: x_ga_flag := po_wf_util_pkg.GetItemAttrText
6872: (itemtype => itemtype,
6873: itemkey => itemkey,
6874: aname => 'SOURCE_DOC_GA_FLAG');
6875:

Line 6979: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

6975: l_return_status VARCHAR2(1) := 'N';
6976:
6977: BEGIN
6978: --Set org context
6979: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6980: itemkey => itemkey,
6981: aname => 'ORG_ID');
6982:
6983: IF x_org_id IS NOT NULL THEN

Line 6991: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

6987: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
6988: x_progress := '10: buyer_on_contract_ok: result = Y';
6989: resultout := wf_engine.eng_completed || ':' || 'Y';
6990: ELSE -- cross business group profile is 'N'
6991: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
6992: (itemtype => itemtype,
6993: itemkey => itemkey,
6994: aname => 'CONTRACT_ID');
6995:

Line 7094: l_org_id := po_wf_util_pkg.GetItemAttrNumber

7090: x_progress VARCHAR2(300);
7091:
7092: BEGIN
7093:
7094: l_org_id := po_wf_util_pkg.GetItemAttrNumber
7095: (itemtype => itemtype,
7096: itemkey => itemkey,
7097: aname => 'ORG_ID');
7098:

Line 7099: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

7095: (itemtype => itemtype,
7096: itemkey => itemkey,
7097: aname => 'ORG_ID');
7098:
7099: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
7100: (itemtype => itemtype,
7101: itemkey => itemkey,
7102: aname => 'PURCHASING_ORG_ID');
7103:

Line 7197: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7193: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7194: BEGIN
7195:
7196: l_req_line_id :=
7197: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7198: itemkey => itemkey,
7199: aname => 'REQ_LINE_ID'
7200: );
7201: l_item_id :=

Line 7202: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7198: itemkey => itemkey,
7199: aname => 'REQ_LINE_ID'
7200: );
7201: l_item_id :=
7202: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7203: itemkey => itemkey,
7204: aname => 'ITEM_ID'
7205: );
7206:

Line 7208: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7204: aname => 'ITEM_ID'
7205: );
7206:
7207: l_source_doc_id :=
7208: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7209: itemkey => itemkey,
7210: aname => 'SOURCE_DOCUMENT_ID'
7211: );
7212:

Line 7214: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7210: aname => 'SOURCE_DOCUMENT_ID'
7211: );
7212:
7213: l_requesting_org_id :=
7214: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7215: itemkey => itemkey,
7216: aname => 'ORG_ID'
7217: );
7218: l_purchasing_org_id :=

Line 7219: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7215: itemkey => itemkey,
7216: aname => 'ORG_ID'
7217: );
7218: l_purchasing_org_id :=
7219: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7220: itemkey => itemkey,
7221: aname => 'PURCHASING_ORG_ID'
7222: );
7223:

Line 7225: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7221: aname => 'PURCHASING_ORG_ID'
7222: );
7223:
7224: l_suggested_vendor_id :=
7225: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7226: itemkey => itemkey,
7227: aname => 'SUGGESTED_VENDOR_ID'
7228: );
7229:

Line 7231: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,

7227: aname => 'SUGGESTED_VENDOR_ID'
7228: );
7229:
7230: l_suggested_vendor_site_id :=
7231: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7232: itemkey => itemkey,
7233: aname => 'SUGGESTED_VENDOR_SITE_ID'
7234: );
7235:

Line 7367: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

7363: || ' purchasing_org_id = ' || to_char(l_purchasing_org_id);
7364:
7365:
7366: --Set purchasing_org_id workflow attribute
7367: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
7368: itemkey => itemkey,
7369: aname => 'PURCHASING_ORG_ID',
7370: avalue => l_purchasing_org_id);
7371:

Line 7434: l_org_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

7430: BEGIN
7431:
7432: /* Set org context */
7433: l_progress := '000';
7434: l_org_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
7435: itemkey => itemkey,
7436: aname => 'ORG_ID');
7437: po_moac_utils_pvt.set_org_context(l_org_id); --
7438:

Line 7440: l_labor_req_line_id := po_wf_util_pkg.GetItemAttrNumber(

7436: aname => 'ORG_ID');
7437: po_moac_utils_pvt.set_org_context(l_org_id); --
7438:
7439: /* Get the expense line grouping ID */
7440: l_labor_req_line_id := po_wf_util_pkg.GetItemAttrNumber(
7441: itemtype => itemtype,
7442: itemkey => itemkey,
7443: aname => 'LABOR_REQ_LINE_ID');
7444:

Line 7519: l_req_line_id := po_wf_util_pkg.GetItemAttrNumber(

7515: BEGIN
7516:
7517: l_progress := '000';
7518: -- Get the requisition line ID
7519: l_req_line_id := po_wf_util_pkg.GetItemAttrNumber(
7520: itemtype => itemtype,
7521: itemkey => itemkey,
7522: aname => 'REQ_LINE_ID');
7523:

Line 7559: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

7555: x_catalog_type varchar2(30);
7556:
7557: begin
7558:
7559: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
7560: itemkey => itemkey,
7561: aname => 'CATALOG_TYPE');
7562:
7563: if nvl(x_catalog_type, 'CATALOG') <> 'TEMP_LABOR' then

Line 7604: x_incl_temp_labor_flag := po_wf_util_pkg.GetItemAttrText

7600: x_progress varchar2(300) := '000';
7601:
7602: begin
7603:
7604: x_incl_temp_labor_flag := po_wf_util_pkg.GetItemAttrText
7605: (itemtype => itemtype,
7606: itemkey => itemkey,
7607: aname => 'INCLUDE_TEMP_LABOR_FLAG');
7608: