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 101: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,

97:
98:
99: /* Initialize workflow item attributes */
100:
101: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
102: itemkey => itemkey,
103: aname => 'REQ_HEADER_ID',
104: avalue => req_header_id);
105:

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

102: itemkey => itemkey,
103: aname => 'REQ_HEADER_ID',
104: avalue => req_header_id);
105:
106: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'PO_NUM_TO_CREATE',
109: avalue => po_number);
110:

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

113: * - ICX = Web Reqs
114: * - SRS = Conc. program.
115: */
116:
117: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
118: itemkey => itemkey,
119: aname => 'INTERFACE_SOURCE_CODE',
120: avalue => interface_source_code);
121:

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

143: where requisition_header_id = req_header_id;
144:
145: end if;
146:
147: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
148: itemkey => itemkey,
149: aname => 'ORG_ID',
150: avalue => x_org_id);
151:

Line 160: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

156: FND_PROFILE.get('RESP_ID', l_responsibility_id);
157: FND_PROFILE.get('RESP_APPL_ID', l_application_id);
158:
159: -- Populate the application context workflow attributes
160: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
161: , itemkey => itemkey
162: , aname => 'USER_ID'
163: , avalue => l_user_id
164: );

Line 165: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

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

Line 170: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

166: , itemkey => itemkey
167: , aname => 'APPLICATION_ID'
168: , avalue => l_application_id
169: );
170: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
171: , itemkey => itemkey
172: , aname => 'RESPONSIBILITY_ID'
173: , avalue => l_responsibility_id
174: );

Line 178: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype

174: );
175: --< Bug 3636669 End >
176: --< Bug14364343 - create Doc Workflow Project>
177: -- Setting the IS_CLM_FLOW to determine if it is clm flow
178: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype
179: , itemkey => itemkey
180: , aname => 'IS_CLM_FLOW'
181: , avalue => is_federal_flow
182: );

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

226: * which has a default value. All the user needs to do is change
227: * that attribute according to their needs.
228: */
229:
230: x_autocreate_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'AUTOCREATE_DOC');
233:
234: if (x_autocreate_doc = 'Y') then

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

439: --
440:
441: BEGIN
442: /* Set org context */
443: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'ORG_ID');
446:
447: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 450: l_consume_req_demand_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber

446:
447: po_moac_utils_pvt.set_org_context(x_org_id); --
448:
449: --
450: l_consume_req_demand_doc_id := PO_WF_UTIL_PKG.GetItemAttrNumber
451: (itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'CONSUME_REQ_DEMAND_DOC_ID');
454: IF l_consume_req_demand_doc_id is null then

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

460: * may or may not be a req_header_id passed in.
461: */
462:
463:
464: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'REQ_HEADER_ID');
467:
468: --

Line 469: l_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

465: itemkey => itemkey,
466: aname => 'REQ_HEADER_ID');
467:
468: --
469: l_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
470: itemkey => itemkey,
471: aname => 'IS_CLM_FLOW');
472:
473: /* Get the group_id for this set of requision lines. The

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

483: /* Store the group_id so grouping (later) only considers
484: * records with this group_id.
485: */
486:
487: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'GROUP_ID',
490: avalue => x_group_id);
491:

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

686: FROM sys.dual;
687:
688: -- Store the group_id so grouping (later) only considers
689: -- records with this group_id.
690: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
691: itemkey => itemkey,
692: aname => 'GROUP_ID',
693: avalue => x_group_id);
694:

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

821: END IF;
822:
823: /* Initialize workflow item attributes */
824:
825: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
826: itemkey => itemkey,
827: aname => 'GROUP_ID',
828: avalue => group_id);
829:

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

826: itemkey => itemkey,
827: aname => 'GROUP_ID',
828: avalue => group_id);
829:
830: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
831: itemkey => itemkey,
832: aname => 'REQ_LINE_ID',
833: avalue => req_line_id);
834:

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

831: itemkey => itemkey,
832: aname => 'REQ_LINE_ID',
833: avalue => req_line_id);
834:
835: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
836: itemkey => itemkey,
837: aname => 'REQ_HEADER_ID',
838: avalue => req_header_id);
839:

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

920: x_federal_flag VARCHAR2(1);
921:
922: begin
923:
924: x_req_line_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
925: itemkey => itemkey,
926: aname => 'REQ_LINE_ID');
927:
928: /* Get the necessary info from the req line */

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

992:
993:
994: /* Set the item attributes */
995:
996: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'ORG_ID',
999: avalue => x_org_id);
1000:

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

997: itemkey => itemkey,
998: aname => 'ORG_ID',
999: avalue => x_org_id);
1000:
1001: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1002: itemkey => itemkey,
1003: aname => 'SUGGESTED_BUYER_ID',
1004: avalue => x_suggested_buyer_id);
1005:

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

1002: itemkey => itemkey,
1003: aname => 'SUGGESTED_BUYER_ID',
1004: avalue => x_suggested_buyer_id);
1005:
1006: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1007: itemkey => itemkey,
1008: aname => 'SUGGESTED_VENDOR_NAME',
1009: avalue => x_suggested_vendor_name);
1010:

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

1007: itemkey => itemkey,
1008: aname => 'SUGGESTED_VENDOR_NAME',
1009: avalue => x_suggested_vendor_name);
1010:
1011: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1012: itemkey => itemkey,
1013: aname => 'SUGGESTED_VENDOR_LOCATION',
1014: avalue => x_suggested_vendor_location);
1015: /* Bug 2577940 */

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

1012: itemkey => itemkey,
1013: aname => 'SUGGESTED_VENDOR_LOCATION',
1014: avalue => x_suggested_vendor_location);
1015: /* Bug 2577940 */
1016: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'SUGGESTED_VENDOR_ID',
1019: avalue => x_suggested_vendor_id);
1020:

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

1017: itemkey => itemkey,
1018: aname => 'SUGGESTED_VENDOR_ID',
1019: avalue => x_suggested_vendor_id);
1020:
1021: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1022: itemkey => itemkey,
1023: aname => 'SUGGESTED_VENDOR_SITE_ID',
1024: avalue => x_suggested_vendor_site_id);
1025: /* Bug 2577940 */

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

1022: itemkey => itemkey,
1023: aname => 'SUGGESTED_VENDOR_SITE_ID',
1024: avalue => x_suggested_vendor_site_id);
1025: /* Bug 2577940 */
1026: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1027: itemkey => itemkey,
1028: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
1029: avalue => x_source_doc_type_code);
1030:

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

1027: itemkey => itemkey,
1028: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
1029: avalue => x_source_doc_type_code);
1030:
1031: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1032: itemkey => itemkey,
1033: aname => 'SOURCE_DOCUMENT_ID',
1034: avalue => x_source_doc_po_header_id);
1035:

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

1042: from po_headers_all
1043: where po_header_id = x_source_doc_po_header_id;
1044: end if;
1045:
1046: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => 'SOURCE_DOC_GA_FLAG',
1049: avalue => x_ga_flag);
1050:

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

1050:
1051:
1052: /* FPI GA End */
1053:
1054: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1055: itemkey => itemkey,
1056: aname => 'SOURCE_DOCUMENT_LINE_NUM',
1057: avalue => x_source_doc_line_num);
1058:

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

1055: itemkey => itemkey,
1056: aname => 'SOURCE_DOCUMENT_LINE_NUM',
1057: avalue => x_source_doc_line_num);
1058:
1059: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1060: itemkey => itemkey,
1061: aname => 'RFQ_REQUIRED_FLAG',
1062: avalue => x_rfq_required_flag);
1063:

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

1060: itemkey => itemkey,
1061: aname => 'RFQ_REQUIRED_FLAG',
1062: avalue => x_rfq_required_flag);
1063:
1064: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'ON_RFQ_FLAG',
1067: avalue => x_on_rfq_flag);
1068:

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

1065: itemkey => itemkey,
1066: aname => 'ON_RFQ_FLAG',
1067: avalue => x_on_rfq_flag);
1068:
1069: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1070: itemkey => itemkey,
1071: aname => 'ITEM_ID',
1072: avalue => x_item_id);
1073:

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

1070: itemkey => itemkey,
1071: aname => 'ITEM_ID',
1072: avalue => x_item_id);
1073:
1074: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'CATEGORY_ID',
1077: avalue => x_category_id);
1078:

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

1075: itemkey => itemkey,
1076: aname => 'CATEGORY_ID',
1077: avalue => x_category_id);
1078:
1079: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'ORGANIZATION_ID',
1082: avalue => x_organization_id);
1083:

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

1082: avalue => x_organization_id);
1083:
1084: -- Bug 587589, lpo, 12/11/97
1085: -- Added the follow 4 lines to populate the currency_code, rate_type, rate_date and rate.
1086: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'CURRENCY_CODE',
1089: avalue => x_currency_code);
1090:

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

1087: itemkey => itemkey,
1088: aname => 'CURRENCY_CODE',
1089: avalue => x_currency_code);
1090:
1091: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'RATE_TYPE',
1094: avalue => x_rate_type);
1095:

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

1092: itemkey => itemkey,
1093: aname => 'RATE_TYPE',
1094: avalue => x_rate_type);
1095:
1096: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,
1097: itemkey => itemkey,
1098: aname => 'RATE_DATE',
1099: avalue => x_rate_date);
1100:

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

1097: itemkey => itemkey,
1098: aname => 'RATE_DATE',
1099: avalue => x_rate_date);
1100:
1101: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1102: itemkey => itemkey,
1103: aname => 'RATE',
1104: avalue => x_rate);
1105:

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

1102: itemkey => itemkey,
1103: aname => 'RATE',
1104: avalue => x_rate);
1105:
1106: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1107: itemkey => itemkey,
1108: aname => 'PCARD_ID',
1109: avalue => x_pcard_id);
1110:

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

1107: itemkey => itemkey,
1108: aname => 'PCARD_ID',
1109: avalue => x_pcard_id);
1110:
1111: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1112: itemkey => itemkey,
1113: aname => 'CATALOG_TYPE',
1114: avalue => x_catalog_type);
1115: -- Bug 587589, lpo, 12/11/97

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

1122: x_suggested_vendor_site_id);
1123: --
1124:
1125: --
1126: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'JOB_ID',
1129: avalue => l_job_id);
1130:

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

1127: itemkey => itemkey,
1128: aname => 'JOB_ID',
1129: avalue => l_job_id);
1130:
1131: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'LABOR_REQ_LINE_ID',
1134: avalue => l_labor_req_line_id);
1135: --

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

1134: avalue => l_labor_req_line_id);
1135: --
1136:
1137: --
1138: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
1139: itemkey => itemkey,
1140: aname => 'IS_CLM_FLOW',
1141: avalue => x_federal_flag);
1142:

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

1178:
1179: begin
1180:
1181: /* Set org context */
1182: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
1183: itemkey => itemkey,
1184: aname => 'ORG_ID');
1185: po_moac_utils_pvt.set_org_context(x_org_id); --
1186:

Line 1189: x_rfq_required_flag := po_wf_util_pkg.GetItemAttrText

1185: po_moac_utils_pvt.set_org_context(x_org_id); --
1186:
1187: /* Get rfq check flags */
1188:
1189: x_rfq_required_flag := po_wf_util_pkg.GetItemAttrText
1190: (itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'RFQ_REQUIRED_FLAG');
1193:

Line 1194: x_on_rfq_flag := po_wf_util_pkg.GetItemAttrText

1190: (itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'RFQ_REQUIRED_FLAG');
1193:
1194: x_on_rfq_flag := po_wf_util_pkg.GetItemAttrText
1195: (itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'ON_RFQ_FLAG');
1198:

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

1266: begin
1267:
1268: /* Set the org context. */
1269:
1270: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
1271: itemkey => itemkey,
1272: aname => 'ORG_ID');
1273:
1274: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 1276: x_suggested_vendor_name := po_wf_util_pkg.GetItemAttrText

1272: aname => 'ORG_ID');
1273:
1274: po_moac_utils_pvt.set_org_context(x_org_id); --
1275:
1276: x_suggested_vendor_name := po_wf_util_pkg.GetItemAttrText
1277: (itemtype => itemtype,
1278: itemkey => itemkey,
1279: aname => 'SUGGESTED_VENDOR_NAME');
1280:

Line 1281: x_suggested_vendor_site := po_wf_util_pkg.GetItemAttrText

1277: (itemtype => itemtype,
1278: itemkey => itemkey,
1279: aname => 'SUGGESTED_VENDOR_NAME');
1280:
1281: x_suggested_vendor_site := po_wf_util_pkg.GetItemAttrText
1282: (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'SUGGESTED_VENDOR_LOCATION');
1285: /* Bug 2577940 */

Line 1286: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

1282: (itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'SUGGESTED_VENDOR_LOCATION');
1285: /* Bug 2577940 */
1286: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
1287: (itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'SUGGESTED_VENDOR_ID');
1290:

Line 1291: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

1287: (itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'SUGGESTED_VENDOR_ID');
1290:
1291: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
1292: (itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'SUGGESTED_VENDOR_SITE_ID');
1295: /* Bug 2577940 */

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

1457: end if; /* Bug 2577940 */
1458:
1459: /* If we get here then both the vendor and vendor site are valid. */
1460:
1461: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1462: itemkey => itemkey,
1463: aname => 'SUGGESTED_VENDOR_ID',
1464: avalue => x_vendor_id);
1465:

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

1462: itemkey => itemkey,
1463: aname => 'SUGGESTED_VENDOR_ID',
1464: avalue => x_vendor_id);
1465:
1466: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1467: itemkey => itemkey,
1468: aname => 'SUGGESTED_VENDOR_SITE_ID',
1469: avalue => x_vendor_site_id);
1470:

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

1468: aname => 'SUGGESTED_VENDOR_SITE_ID',
1469: avalue => x_vendor_site_id);
1470:
1471: /* Bug 2577940 The correct names also should be set */
1472: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1473: itemkey => itemkey,
1474: aname => 'SUGGESTED_VENDOR_NAME',
1475: avalue => x_vendor);
1476:

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

1473: itemkey => itemkey,
1474: aname => 'SUGGESTED_VENDOR_NAME',
1475: avalue => x_vendor);
1476:
1477: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1478: itemkey => itemkey,
1479: aname => 'SUGGESTED_VENDOR_LOCATION',
1480: avalue => x_vendor_site);
1481: /* Bug 2577940 */

Line 1531: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

1527: * We just need to make sure the source_doc_type, source_doc and
1528: * source_line have been populated.
1529: */
1530:
1531: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
1532: (itemtype => itemtype,
1533: itemkey => itemkey,
1534: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
1535:

Line 1536: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

1532: (itemtype => itemtype,
1533: itemkey => itemkey,
1534: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
1535:
1536: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
1537: (itemtype => itemtype,
1538: itemkey => itemkey,
1539: aname => 'SOURCE_DOCUMENT_ID');
1540:

Line 1541: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber

1537: (itemtype => itemtype,
1538: itemkey => itemkey,
1539: aname => 'SOURCE_DOCUMENT_ID');
1540:
1541: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
1542: (itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'SOURCE_DOCUMENT_LINE_NUM');
1545:

Line 1546: x_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

1542: (itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'SOURCE_DOCUMENT_LINE_NUM');
1545:
1546: x_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
1547: itemkey => itemkey,
1548: aname => 'IS_CLM_FLOW');
1549:
1550:

Line 1723: x_supplier_id := po_wf_util_pkg.GetItemAttrNumber

1719: --
1720:
1721: begin
1722:
1723: x_supplier_id := po_wf_util_pkg.GetItemAttrNumber
1724: (itemtype => itemtype,
1725: itemkey => itemkey,
1726: aname => 'SUGGESTED_VENDOR_ID');
1727:

Line 1728: x_supplier_site_id := po_wf_util_pkg.GetItemAttrNumber

1724: (itemtype => itemtype,
1725: itemkey => itemkey,
1726: aname => 'SUGGESTED_VENDOR_ID');
1727:
1728: x_supplier_site_id := po_wf_util_pkg.GetItemAttrNumber
1729: (itemtype => itemtype,
1730: itemkey => itemkey,
1731: aname => 'SUGGESTED_VENDOR_SITE_ID');
1732:

Line 1733: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText

1729: (itemtype => itemtype,
1730: itemkey => itemkey,
1731: aname => 'SUGGESTED_VENDOR_SITE_ID');
1732:
1733: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText
1734: (itemtype => itemtype,
1735: itemkey => itemkey,
1736: aname => 'USE_CONTRACT_FLAG');
1737:

Line 1738: x_item_currency := po_wf_util_pkg.GetItemAttrText

1734: (itemtype => itemtype,
1735: itemkey => itemkey,
1736: aname => 'USE_CONTRACT_FLAG');
1737:
1738: x_item_currency := po_wf_util_pkg.GetItemAttrText
1739: (itemtype => itemtype,
1740: itemkey => itemkey,
1741: aname => 'CURRENCY_CODE');
1742:

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

1811: IF (l_rate IS NULL) THEN
1812: x_contract_id := NULL;
1813: ELSE -- rate is defined
1814:
1815: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1816: itemkey => itemkey,
1817: aname => 'CURRENCY_CODE',
1818: avalue => l_currency);
1819:

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

1816: itemkey => itemkey,
1817: aname => 'CURRENCY_CODE',
1818: avalue => l_currency);
1819:
1820: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1821: itemkey => itemkey,
1822: aname => 'RATE_TYPE',
1823: avalue => l_rate_type);
1824:

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

1821: itemkey => itemkey,
1822: aname => 'RATE_TYPE',
1823: avalue => l_rate_type);
1824:
1825: po_wf_util_pkg.SetItemAttrDate (itemtype => itemtype,
1826: itemkey => itemkey,
1827: aname => 'RATE_DATE',
1828: avalue => l_rate_date);
1829:

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

1826: itemkey => itemkey,
1827: aname => 'RATE_DATE',
1828: avalue => l_rate_date);
1829:
1830: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1831: itemkey => itemkey,
1832: aname => 'RATE',
1833: avalue => l_rate);
1834: END IF; -- l_rate is null

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

1834: END IF; -- l_rate is null
1835: /* END IF; -- l_currency <> l_base_currency */
1836:
1837: IF (x_contract_id IS NOT NULL) THEN
1838: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
1839: itemkey => itemkey,
1840: aname => 'SOURCE_DOC_GA_FLAG',
1841: avalue => l_gc_flag);
1842: END IF; -- x_contract_id is not null

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

1845: --
1846:
1847: if x_contract_id is not null then
1848:
1849: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'CONTRACT_ID',
1852: avalue => x_contract_id);
1853: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

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

1849: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'CONTRACT_ID',
1852: avalue => x_contract_id);
1853: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
1856: avalue => 'CONTRACT');
1857:

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

1858: --
1859: -- Since the ref is a contract and is stored in attr CONTRACT_ID,
1860: -- null out the reference in SOURCE_DOCUMENT_ID
1861:
1862: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
1863: itemkey => itemkey,
1864: aname => 'SOURCE_DOCUMENT_ID',
1865: avalue => NULL);
1866:

Line 1912: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber

1908: x_progress varchar2(300);
1909:
1910: begin
1911:
1912: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber
1913: (itemtype => itemtype,
1914: itemkey => itemkey,
1915: aname => 'PCARD_ID');
1916:

Line 1966: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

1962: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1963:
1964: begin
1965:
1966: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber
1967: (itemtype => itemtype,
1968: itemkey => itemkey,
1969: aname => 'SUGGESTED_BUYER_ID');
1970:

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

2026: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
2027:
2028: begin
2029:
2030: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
2031: itemkey => itemkey,
2032: aname => 'ORG_ID');
2033:
2034: --

Line 2035: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

2031: itemkey => itemkey,
2032: aname => 'ORG_ID');
2033:
2034: --
2035: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
2036: (itemtype => itemtype,
2037: itemkey => itemkey,
2038: aname => 'PURCHASING_ORG_ID');
2039: --

Line 2040: x_item_id := po_wf_util_pkg.GetItemAttrNumber

2036: (itemtype => itemtype,
2037: itemkey => itemkey,
2038: aname => 'PURCHASING_ORG_ID');
2039: --
2040: x_item_id := po_wf_util_pkg.GetItemAttrNumber
2041: (itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'ITEM_ID');
2044:

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

2083: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2084: END IF;
2085:
2086: else
2087: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'SUGGESTED_BUYER_ID',
2090: avalue => x_buyer_id);
2091:

Line 2131: x_category_id := po_wf_util_pkg.GetItemAttrNumber

2127: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2128:
2129: begin
2130:
2131: x_category_id := po_wf_util_pkg.GetItemAttrNumber
2132: (itemtype => itemtype,
2133: itemkey => itemkey,
2134: aname => 'CATEGORY_ID');
2135:

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

2239: END IF;
2240:
2241:
2242: else
2243: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2244: itemkey => itemkey,
2245: aname => 'SUGGESTED_BUYER_ID',
2246: avalue => x_agent_id);
2247:

Line 2289: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2285: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2286:
2287: begin
2288:
2289: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2290: (itemtype => itemtype,
2291: itemkey => itemkey,
2292: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2293:

Line 2294: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

2290: (itemtype => itemtype,
2291: itemkey => itemkey,
2292: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2293:
2294: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
2295: (itemtype => itemtype,
2296: itemkey => itemkey,
2297: aname => 'SOURCE_DOCUMENT_ID');
2298: if( x_source_doc_type_code = 'BLANKET' or

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

2340: END IF;
2341:
2342:
2343: else
2344: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2345: itemkey => itemkey,
2346: aname => 'SUGGESTED_BUYER_ID',
2347: avalue => x_agent_id);
2348:

Line 2387: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

2383: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
2384:
2385: begin
2386:
2387: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
2388: (itemtype => itemtype,
2389: itemkey => itemkey,
2390: aname => 'CONTRACT_ID');
2391:

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

2427:
2428: purge_expense_lines(itemtype, itemkey); --
2429:
2430: else
2431: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
2432: itemkey => itemkey,
2433: aname => 'SUGGESTED_BUYER_ID',
2434: avalue => x_agent_id);
2435:

Line 2472: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2468: x_progress varchar2(300);
2469: x_ga_flag varchar2(1);
2470: begin
2471:
2472: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2473: (itemtype => itemtype,
2474: itemkey => itemkey,
2475: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2476:

Line 2483: x_ga_flag := po_wf_util_pkg.GetItemAttrText

2479: */
2480:
2481: /* FPI GA Start */
2482: /* Get the GA Flag */
2483: x_ga_flag := po_wf_util_pkg.GetItemAttrText
2484: (itemtype => itemtype,
2485: itemkey => itemkey,
2486: aname => 'SOURCE_DOC_GA_FLAG');
2487:

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

2552: x_progress varchar2(300);
2553:
2554: begin
2555:
2556: x_item_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
2557: itemkey => itemkey,
2558: aname => 'ITEM_ID');
2559:
2560: /* If item_id is null then this is a one-time item. */

Line 2621: x_org_id := po_wf_util_pkg.GetItemAttrNumber

2617: /* Set the org context. Backend create_po process assumes it is in
2618: * an org.
2619: */
2620:
2621: x_org_id := po_wf_util_pkg.GetItemAttrNumber
2622: (itemtype => itemtype,
2623: itemkey => itemkey,
2624: aname => 'ORG_ID');
2625:

Line 2630: x_item_id := po_wf_util_pkg.GetItemAttrNumber

2626: po_moac_utils_pvt.set_org_context(x_org_id); --
2627:
2628: /* Retrieve required info from item attributes */
2629:
2630: x_item_id := po_wf_util_pkg.GetItemAttrNumber
2631: (itemtype => itemtype,
2632: itemkey => itemkey,
2633: aname => 'ITEM_ID');
2634:

Line 2635: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

2631: (itemtype => itemtype,
2632: itemkey => itemkey,
2633: aname => 'ITEM_ID');
2634:
2635: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
2636: (itemtype => itemtype,
2637: itemkey => itemkey,
2638: aname => 'SUGGESTED_VENDOR_ID');
2639:

Line 2640: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

2636: (itemtype => itemtype,
2637: itemkey => itemkey,
2638: aname => 'SUGGESTED_VENDOR_ID');
2639:
2640: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
2641: (itemtype => itemtype,
2642: itemkey => itemkey,
2643: aname => 'SUGGESTED_VENDOR_SITE_ID');
2644:

Line 2645: x_organization_id := po_wf_util_pkg.GetItemAttrNumber

2641: (itemtype => itemtype,
2642: itemkey => itemkey,
2643: aname => 'SUGGESTED_VENDOR_SITE_ID');
2644:
2645: x_organization_id := po_wf_util_pkg.GetItemAttrNumber
2646: (itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'ORGANIZATION_ID');
2649: /* bug no:5943024*/

Line 2650: x_category_id := po_wf_util_pkg.GetItemAttrNumber

2646: (itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'ORGANIZATION_ID');
2649: /* bug no:5943024*/
2650: x_category_id := po_wf_util_pkg.GetItemAttrNumber
2651: (itemtype => itemtype,
2652: itemkey => itemkey,
2653: aname => 'CATEGORY_ID');
2654: /* end of Bug No 5943024*/

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

2740: end;
2741:
2742: /* Set item attribute so it can be used later */
2743:
2744: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
2745: itemkey => itemkey,
2746: aname => 'REL_GEN_METHOD',
2747: avalue => x_rel_gen_method);
2748:

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

2796: x_progress varchar2(300);
2797:
2798: begin
2799:
2800: x_cont_wf_for_ac_rel_gen:= po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
2801: itemkey => itemkey,
2802: aname => 'CONT_WF_FOR_AC_REL_GEN');
2803:
2804: if (x_cont_wf_for_ac_rel_gen = 'Y') then

Line 2879: x_group_id:= po_wf_util_pkg.GetItemAttrNumber

2875: * processing (grouping) to work. But no harm having them there.
2876: * If in the future they are needed then they'll already be there.
2877: */
2878:
2879: x_group_id:= po_wf_util_pkg.GetItemAttrNumber
2880: (itemtype => itemtype,
2881: itemkey => itemkey,
2882: aname => 'GROUP_ID');
2883:

Line 2884: x_req_header_id:= po_wf_util_pkg.GetItemAttrNumber

2880: (itemtype => itemtype,
2881: itemkey => itemkey,
2882: aname => 'GROUP_ID');
2883:
2884: x_req_header_id:= po_wf_util_pkg.GetItemAttrNumber
2885: (itemtype => itemtype,
2886: itemkey => itemkey,
2887: aname => 'REQ_HEADER_ID');
2888:

Line 2889: x_req_line_id:= po_wf_util_pkg.GetItemAttrNumber

2885: (itemtype => itemtype,
2886: itemkey => itemkey,
2887: aname => 'REQ_HEADER_ID');
2888:
2889: x_req_line_id:= po_wf_util_pkg.GetItemAttrNumber
2890: (itemtype => itemtype,
2891: itemkey => itemkey,
2892: aname => 'REQ_LINE_ID');
2893:

Line 2894: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber

2890: (itemtype => itemtype,
2891: itemkey => itemkey,
2892: aname => 'REQ_LINE_ID');
2893:
2894: x_suggested_buyer_id := po_wf_util_pkg.GetItemAttrNumber
2895: (itemtype => itemtype,
2896: itemkey => itemkey,
2897: aname => 'SUGGESTED_BUYER_ID');
2898:

Line 2899: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

2895: (itemtype => itemtype,
2896: itemkey => itemkey,
2897: aname => 'SUGGESTED_BUYER_ID');
2898:
2899: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
2900: (itemtype => itemtype,
2901: itemkey => itemkey,
2902: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2903:

Line 2904: x_source_doc_id := po_wf_util_pkg.GetItemAttrNumber

2900: (itemtype => itemtype,
2901: itemkey => itemkey,
2902: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
2903:
2904: x_source_doc_id := po_wf_util_pkg.GetItemAttrNumber
2905: (itemtype => itemtype,
2906: itemkey => itemkey,
2907: aname => 'SOURCE_DOCUMENT_ID');
2908:

Line 2909: x_source_doc_line := po_wf_util_pkg.GetItemAttrNumber

2905: (itemtype => itemtype,
2906: itemkey => itemkey,
2907: aname => 'SOURCE_DOCUMENT_ID');
2908:
2909: x_source_doc_line := po_wf_util_pkg.GetItemAttrNumber
2910: (itemtype => itemtype,
2911: itemkey => itemkey,
2912: aname => 'SOURCE_DOCUMENT_LINE_NUM');
2913:

Line 2915: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber

2911: itemkey => itemkey,
2912: aname => 'SOURCE_DOCUMENT_LINE_NUM');
2913:
2914:
2915: x_suggested_vendor_id := po_wf_util_pkg.GetItemAttrNumber
2916: (itemtype => itemtype,
2917: itemkey => itemkey,
2918: aname => 'SUGGESTED_VENDOR_ID');
2919:

Line 2920: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

2916: (itemtype => itemtype,
2917: itemkey => itemkey,
2918: aname => 'SUGGESTED_VENDOR_ID');
2919:
2920: x_suggested_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
2921: (itemtype => itemtype,
2922: itemkey => itemkey,
2923: aname => 'SUGGESTED_VENDOR_SITE_ID');
2924:

Line 2926: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

2922: itemkey => itemkey,
2923: aname => 'SUGGESTED_VENDOR_SITE_ID');
2924:
2925:
2926: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
2927: (itemtype => itemtype,
2928: itemkey => itemkey,
2929: aname => 'CONTRACT_ID');
2930:

Line 2932: x_currency_code := po_wf_util_pkg.GetItemAttrText

2928: itemkey => itemkey,
2929: aname => 'CONTRACT_ID');
2930:
2931:
2932: x_currency_code := po_wf_util_pkg.GetItemAttrText
2933: (itemtype => itemtype,
2934: itemkey => itemkey,
2935: aname => 'CURRENCY_CODE');
2936:

Line 2937: x_rate_type := po_wf_util_pkg.GetItemAttrText

2933: (itemtype => itemtype,
2934: itemkey => itemkey,
2935: aname => 'CURRENCY_CODE');
2936:
2937: x_rate_type := po_wf_util_pkg.GetItemAttrText
2938: (itemtype => itemtype,
2939: itemkey => itemkey,
2940: aname => 'RATE_TYPE');
2941:

Line 2942: x_rate_date := po_wf_util_pkg.GetItemAttrDate

2938: (itemtype => itemtype,
2939: itemkey => itemkey,
2940: aname => 'RATE_TYPE');
2941:
2942: x_rate_date := po_wf_util_pkg.GetItemAttrDate
2943: (itemtype => itemtype,
2944: itemkey => itemkey,
2945: aname => 'RATE_DATE');
2946:

Line 2947: x_rate := po_wf_util_pkg.GetItemAttrNumber

2943: (itemtype => itemtype,
2944: itemkey => itemkey,
2945: aname => 'RATE_DATE');
2946:
2947: x_rate := po_wf_util_pkg.GetItemAttrNumber
2948: (itemtype => itemtype,
2949: itemkey => itemkey,
2950: aname => 'RATE');
2951:

Line 2952: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber

2948: (itemtype => itemtype,
2949: itemkey => itemkey,
2950: aname => 'RATE');
2951:
2952: x_pcard_id := po_wf_util_pkg.GetItemAttrNumber
2953: (itemtype => itemtype,
2954: itemkey => itemkey,
2955: aname => 'PCARD_ID');
2956:

Line 2957: x_rel_gen_method := po_wf_util_pkg.GetItemAttrText

2953: (itemtype => itemtype,
2954: itemkey => itemkey,
2955: aname => 'PCARD_ID');
2956:
2957: x_rel_gen_method := po_wf_util_pkg.GetItemAttrText
2958: (itemtype => itemtype,
2959: itemkey => itemkey,
2960: aname => 'REL_GEN_METHOD');
2961:

Line 2962: x_item_id := po_wf_util_pkg.GetItemAttrText

2958: (itemtype => itemtype,
2959: itemkey => itemkey,
2960: aname => 'REL_GEN_METHOD');
2961:
2962: x_item_id := po_wf_util_pkg.GetItemAttrText
2963: (itemtype => itemtype,
2964: itemkey => itemkey,
2965: aname => 'ITEM_ID');
2966:

Line 2968: l_job_id := po_wf_util_pkg.GetItemAttrNumber

2964: itemkey => itemkey,
2965: aname => 'ITEM_ID');
2966:
2967: --
2968: l_job_id := po_wf_util_pkg.GetItemAttrNumber
2969: (itemtype => itemtype,
2970: itemkey => itemkey,
2971: aname => 'JOB_ID');
2972:

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

3278: * to the same group. We need to get the group_id before opening
3279: * the cursor since it is a parameter to the cursor.
3280: */
3281:
3282: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
3283: itemkey => itemkey,
3284: aname => 'GROUP_ID');
3285:
3286: /* Bug 2974129. This Grouping allowed flag should not decide the #of documents

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

3285:
3286: /* Bug 2974129. This Grouping allowed flag should not decide the #of documents
3287: Instead this should be applied to group the lines.
3288:
3289: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3290: itemkey => itemkey,
3291: aname => 'GROUPING_ALLOWED_FLAG'); */
3292:
3293: x_group_one_time_address := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

3289: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3290: itemkey => itemkey,
3291: aname => 'GROUPING_ALLOWED_FLAG'); */
3292:
3293: x_group_one_time_address := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3294: itemkey => itemkey,
3295: aname => 'GROUP_ONE_ADDR_LINE_FLAG');
3296:
3297: /* if x_grouping_allowed is NULL then

Line 3765: l_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

3761: END IF;
3762:
3763: -- bug 14314684, When the Req has multiple lines with same suggested supplier
3764: -- but with different sourcing document, create doc wf should create different Awards
3765: l_is_clm_flow := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
3766: itemkey => itemkey,
3767: aname => 'IS_CLM_FLOW');
3768:
3769: if (x_first_time_for_this_comb = 'TRUE' or (Nvl(l_is_clm_flow,'N')= 'Y' AND nvl(c1_source_doc_id,-1) <> nvl(c2_source_doc_id,-1))) then

Line 4088: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4084: /* Set the org context. Backend create_po process assumes it is in
4085: * an org.
4086: */
4087:
4088: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4089: (itemtype => itemtype,
4090: itemkey => itemkey,
4091: aname => 'ORG_ID');
4092:

Line 4103: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

4099: itemkey,
4100: x_org_id,
4101: x_suggested_vendor_site_id);
4102:
4103: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
4104: (itemtype => itemtype,
4105: itemkey => itemkey,
4106: aname => 'PURCHASING_ORG_ID');
4107:

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

4116: This attribute should decide the grouping logic in Auto Create. If this is set Y,
4117: then the 'DEFAULT' will be populated as grope code else 'REQUISITION' will be
4118: populated as group code */
4119:
4120: x_grouping_allowed := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
4121: itemkey => itemkey,
4122: aname => 'GROUPING_ALLOWED_FLAG');
4123:
4124: if x_grouping_allowed = 'N' then

Line 4205: x_document_num := po_wf_util_pkg.GetItemAttrText

4201: * that the doc number is unique here since the backend expects that
4202: * when using manual numbering.
4203: */
4204:
4205: x_document_num := po_wf_util_pkg.GetItemAttrText
4206: (itemtype => itemtype,
4207: itemkey => itemkey,
4208: aname => 'PO_NUM_TO_CREATE');
4209:

Line 4589: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4585: /* Set the org context. Backend create_po process assumes it is in
4586: * an org.
4587: */
4588:
4589: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4590: (itemtype => itemtype,
4591: itemkey => itemkey,
4592: aname => 'ORG_ID');
4593:

Line 4793: x_org_id := po_wf_util_pkg.GetItemAttrNumber

4789: /* Set the org context. Backend create_po process assumes it is in
4790: * an org.
4791: */
4792:
4793: x_org_id := po_wf_util_pkg.GetItemAttrNumber
4794: (itemtype => itemtype,
4795: itemkey => itemkey,
4796: aname => 'ORG_ID');
4797:

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

4801: /* Get the group id so we can launch doc creation and approval
4802: * for this group.
4803: */
4804:
4805: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
4806: itemkey => itemkey,
4807: aname => 'GROUP_ID');
4808:
4809: open c1; /* x_group_id is a parameter */

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

4828: itemkey => itemkey,
4829: p_org_id => x_org_id,
4830: p_suggested_vendor_site_id => l_vendor_site_id);
4831:
4832: l_purchasing_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
4833: itemkey => itemkey,
4834: aname => 'PURCHASING_ORG_ID');
4835:
4836: x_progress:= '6: launch_doc_creation_approval: after set_purchasing_org_id: ' ||

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

4952: END IF;
4953:
4954: /* Set the item attributes */
4955:
4956: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4957: itemkey => itemkey,
4958: aname => 'ORG_ID',
4959: avalue => org_id);
4960:

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

4958: aname => 'ORG_ID',
4959: avalue => org_id);
4960:
4961: --
4962: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4963: itemkey => itemkey,
4964: aname => 'PURCHASING_ORG_ID',
4965: avalue => purchasing_org_id);
4966: --

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

4964: aname => 'PURCHASING_ORG_ID',
4965: avalue => purchasing_org_id);
4966: --
4967:
4968: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4969: itemkey => itemkey,
4970: aname => 'INTERFACE_HEADER_ID',
4971: avalue => interface_header_id);
4972:

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

4970: aname => 'INTERFACE_HEADER_ID',
4971: avalue => interface_header_id);
4972:
4973:
4974: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
4975: itemkey => itemkey,
4976: aname => 'DOC_TYPE_TO_CREATE',
4977: avalue => doc_type_to_create);
4978:

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

4976: aname => 'DOC_TYPE_TO_CREATE',
4977: avalue => doc_type_to_create);
4978:
4979:
4980: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
4981: itemkey => itemkey,
4982: aname => 'AGENT_ID',
4983: avalue => agent_id);
4984:

Line 5056: x_org_id := po_wf_util_pkg.GetItemAttrNumber

5052: /* Set the org context. Backend create_po process assumes it is in
5053: * an org.
5054: */
5055:
5056: x_org_id := po_wf_util_pkg.GetItemAttrNumber
5057: (itemtype => itemtype,
5058: itemkey => itemkey,
5059: aname => 'ORG_ID');
5060: --

Line 5061: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

5057: (itemtype => itemtype,
5058: itemkey => itemkey,
5059: aname => 'ORG_ID');
5060: --
5061: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
5062: (itemtype => itemtype,
5063: itemkey => itemkey,
5064: aname => 'PURCHASING_ORG_ID');
5065: --

Line 5068: x_interface_header_id := po_wf_util_pkg.GetItemAttrNumber

5064: aname => 'PURCHASING_ORG_ID');
5065: --
5066:
5067: PO_MOAC_UTILS_PVT.set_org_context(x_org_id); --
5068: x_interface_header_id := po_wf_util_pkg.GetItemAttrNumber
5069: (itemtype => itemtype,
5070: itemkey => itemkey,
5071: aname => 'INTERFACE_HEADER_ID');
5072:

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

5134: * creating the po or release
5135: */
5136:
5137: if (x_num_lines_processed > 0) then
5138: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
5139: itemkey => itemkey,
5140: aname => 'AUTOCREATED_DOC_ID',
5141: avalue => x_autocreated_doc_id);
5142:

Line 5204: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText

5200: x_progress varchar2(300);
5201:
5202: begin
5203:
5204: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText
5205: (itemtype => itemtype,
5206: itemkey => itemkey,
5207: aname => 'DOC_TYPE_TO_CREATE');
5208:

Line 5209: x_autocreated_doc_id := po_wf_util_pkg.GetItemAttrNumber

5205: (itemtype => itemtype,
5206: itemkey => itemkey,
5207: aname => 'DOC_TYPE_TO_CREATE');
5208:
5209: x_autocreated_doc_id := po_wf_util_pkg.GetItemAttrNumber
5210: (itemtype => itemtype,
5211: itemkey => itemkey,
5212: aname => 'AUTOCREATED_DOC_ID');
5213:

Line 5215: x_agent_id := po_wf_util_pkg.GetItemAttrNumber

5211: itemkey => itemkey,
5212: aname => 'AUTOCREATED_DOC_ID');
5213:
5214:
5215: x_agent_id := po_wf_util_pkg.GetItemAttrNumber
5216: (itemtype => itemtype,
5217: itemkey => itemkey,
5218: aname => 'AGENT_ID');
5219:

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

5234: end if;
5235: --
5236:
5237:
5238: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
5239: itemkey => itemkey,
5240: aname => 'DOC_TYPE_CREATED_DISP',
5241: avalue => x_doc_type_created_disp);
5242:

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

5256: from po_headers_all
5257: where po_header_id = x_autocreated_doc_id;
5258:
5259:
5260: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
5261: itemkey => itemkey,
5262: aname => 'DOC_NUM_CREATED',
5263: avalue => x_segment1);
5264:

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

5299: and por.po_header_id = poh.po_header_id;
5300:
5301: /* Append the release num to blanket po num */
5302:
5303: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
5304: itemkey => itemkey,
5305: aname => 'DOC_NUM_CREATED',
5306: avalue => x_segment1 || ', ' ||
5307: to_char (x_release_num));

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

5315: ' ACCESS_LEVEL_CODE="MODIFY"' ||
5316: ' POXPOERL_CALLING_FORM="POXSTNOT"';
5317: end if;
5318:
5319: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
5320: itemkey => itemkey,
5321: aname => 'OPEN_FORM_COMMAND',
5322: avalue =>l_open_form );
5323:

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

5322: avalue =>l_open_form );
5323:
5324: -- HTML Orders R12
5325: -- Set the URL and form attributes
5326: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5327: itemkey => itemkey,
5328: aname => 'VIEW_DOC_URL' ,
5329: avalue => l_view_po_url);
5330:

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

5327: itemkey => itemkey,
5328: aname => 'VIEW_DOC_URL' ,
5329: avalue => l_view_po_url);
5330:
5331: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5332: itemkey => itemkey,
5333: aname => 'EDIT_DOC_URL' ,
5334: avalue => l_edit_po_url);
5335:

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

5351: END IF;
5352:
5353: po_reqapproval_init1.get_user_name(x_agent_id, x_username, x_user_display_name);
5354:
5355: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
5356: itemkey => itemkey,
5357: aname => 'BUYER_USERNAME',
5358: avalue => x_username);
5359:

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

5419: -- is set to Y then this function would return Y else it would
5420: -- return N. So Approval depends on tax calculation being successful
5421: --
5422: --
5423: x_auto_approve_doc := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5424: itemkey => itemkey,
5425: aname => 'AUTO_APPROVE_DOC');
5426:
5427:

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

5431: l_doc_type_to_create := null;
5432: l_doc_type := null;
5433: l_doc_subtype := null;
5434: l_return_status := null;
5435: l_doc_type_to_create := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5436: itemkey => itemkey,
5437: aname => 'DOC_TYPE_TO_CREATE');
5438:
5439: IF (l_doc_type_to_create = PO_CONSTANTS_SV.RELEASE) THEN

Line 5442: l_po_release_id := po_wf_util_pkg.GetItemAttrNumber

5438:
5439: IF (l_doc_type_to_create = PO_CONSTANTS_SV.RELEASE) THEN
5440: l_doc_type := PO_CONSTANTS_SV.RELEASE;
5441: l_doc_subtype := PO_CONSTANTS_SV.BLANKET;
5442: l_po_release_id := po_wf_util_pkg.GetItemAttrNumber
5443: (itemtype => itemtype,
5444: itemkey => itemkey,
5445: aname => 'AUTOCREATED_DOC_ID');
5446: l_document_id := l_po_release_id; --bug 14243104 fix

Line 5450: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber

5446: l_document_id := l_po_release_id; --bug 14243104 fix
5447: ELSE
5448: l_doc_type := PO_CONSTANTS_SV.PO;
5449: l_doc_subtype := PO_CONSTANTS_SV.STANDARD;
5450: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber
5451: (itemtype => itemtype,
5452: itemkey => itemkey,
5453: aname => 'AUTOCREATED_DOC_ID');
5454: l_document_id := l_po_header_id; --bug 14243104 fix

Line 5589: x_org_id := po_wf_util_pkg.GetItemAttrNumber

5585:
5586:
5587: begin
5588:
5589: x_org_id := po_wf_util_pkg.GetItemAttrNumber
5590: (itemtype => itemtype,
5591: itemkey => itemkey,
5592: aname => 'ORG_ID');
5593:

Line 5595: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

5591: itemkey => itemkey,
5592: aname => 'ORG_ID');
5593:
5594: --
5595: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
5596: (itemtype => itemtype,
5597: itemkey => itemkey,
5598: aname => 'PURCHASING_ORG_ID');
5599: --

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

5607:
5608: --
5609: IF x_org_id <> l_purchasing_org_id THEN
5610: --Set the org_id to be the purchasing org for PO Approval Process
5611: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5612: itemkey => itemkey,
5613: aname => 'ORG_ID',
5614: avalue => l_purchasing_org_id);
5615: --Set the context to be that of purchasing org

Line 5622: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText

5618: END IF;
5619: --
5620: END IF;
5621:
5622: x_doc_type_to_create := po_wf_util_pkg.GetItemAttrText
5623: (itemtype => itemtype,
5624: itemkey => itemkey,
5625: aname => 'DOC_TYPE_TO_CREATE');
5626:

Line 5645: x_preparer_id:= po_wf_util_pkg.GetItemAttrNumber

5641: /* Get the doc_id, doc_num and preparer_id */
5642:
5643: /* The preparer is the same as the buyer */
5644:
5645: x_preparer_id:= po_wf_util_pkg.GetItemAttrNumber
5646: (itemtype => itemtype,
5647: itemkey => itemkey,
5648: aname => 'SUGGESTED_BUYER_ID');
5649:

Line 5650: x_doc_id:= po_wf_util_pkg.GetItemAttrNumber

5646: (itemtype => itemtype,
5647: itemkey => itemkey,
5648: aname => 'SUGGESTED_BUYER_ID');
5649:
5650: x_doc_id:= po_wf_util_pkg.GetItemAttrNumber
5651: (itemtype => itemtype,
5652: itemkey => itemkey,
5653: aname => 'AUTOCREATED_DOC_ID');
5654:

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

5752: x_emailflag := 'N';
5753: x_emailaddress:= null;
5754:
5755: --Bug4956479
5756: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5757: itemkey => itemkey,
5758: aname => 'SUGGESTED_BUYER_ID',
5759: avalue => x_preparer_id);
5760:

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

5773: x_document_num => x_doc_num );
5774:
5775: -- Bug 3152167 Get the document number and pass the same to start po approval.
5776:
5777: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
5778: itemkey => itemkey,
5779: aname => 'SUGGESTED_BUYER_ID',
5780: avalue => x_preparer_id);
5781:

Line 5879: x_group_id:= po_wf_util_pkg.GetItemAttrNumber

5875: x_progress varchar2(300);
5876:
5877: begin
5878:
5879: x_group_id:= po_wf_util_pkg.GetItemAttrNumber
5880: (itemtype => itemtype,
5881: itemkey => itemkey,
5882: aname => 'GROUP_ID');
5883:

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

5924: x_progress varchar2(300);
5925:
5926: begin
5927:
5928: x_req_header_id := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
5929: itemkey => itemkey,
5930: aname => 'REQ_HEADER_ID');
5931: BEGIN
5932: SELECT emergency_po_num

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

6082: * the cursor since it is a parameter to the cursor.
6083: */
6084: l_style_id := PO_DOC_STYLE_GRP.get_standard_doc_style; --
6085:
6086: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
6087: itemkey => itemkey,
6088: aname => 'GROUP_ID');
6089:
6090: x_progress := '10: put_on_one_po : group_id '||

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

6504: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6505: END IF;
6506:
6507: -- Set the attributes
6508: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6509: itemkey => itemkey,
6510: aname => 'DOCUMENT_NUMBER',
6511: avalue => l_req_num);
6512: --

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

6509: itemkey => itemkey,
6510: aname => 'DOCUMENT_NUMBER',
6511: avalue => l_req_num);
6512: --
6513: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
6514: itemkey => itemkey,
6515: aname => 'DOCUMENT_ID',
6516: avalue => p_req_header_id);
6517: --

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

6514: itemkey => itemkey,
6515: aname => 'DOCUMENT_ID',
6516: avalue => p_req_header_id);
6517: --
6518: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6519: itemkey => itemkey,
6520: aname => 'DOCUMENT_TYPE_DISP',
6521: avalue => l_doc_type);
6522: --

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

6521: avalue => l_doc_type);
6522: --
6523: -- Bug 2942228. The org id was getting changed from 458 to 204 when requisition was
6524: -- returned in Vision Services because it is not set as Workflow Attribute here.
6525: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
6526: itemkey => itemkey,
6527: aname => 'ORG_ID',
6528: avalue => l_org_id);
6529:

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

6531: ** Desc: We will only be using one display attribute for type and
6532: ** subtype - DOCUMENT_TYPE_DISP, hence commenting the code below
6533: */
6534: /*
6535: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6536: itemkey => itemkey,
6537: aname => 'DOCUMENT_SUBTYPE_DISP',
6538: avalue => l_doc_subtype);
6539: --

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

6546: ** document_type_code and document_subtype from po_document_types, because
6547: ** these are used in PO_REQAPPROVAL_INIT1.SetReqHdrAttributes to set the item
6548: ** attribute for DOCUMENT_TYPE_DISP.
6549: */
6550: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6551: itemkey => itemkey,
6552: aname => 'DOCUMENT_TYPE',
6553: avalue => l_doc_type_code);
6554: --

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

6551: itemkey => itemkey,
6552: aname => 'DOCUMENT_TYPE',
6553: avalue => l_doc_type_code);
6554: --
6555: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6556: itemkey => itemkey,
6557: aname => 'DOCUMENT_SUBTYPE',
6558: avalue => l_doc_subtype);
6559: --

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

6557: aname => 'DOCUMENT_SUBTYPE',
6558: avalue => l_doc_subtype);
6559: --
6560:
6561: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6562: itemkey => itemkey,
6563: aname => 'NOTE',
6564: avalue => p_reason);
6565: --

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

6562: itemkey => itemkey,
6563: aname => 'NOTE',
6564: avalue => p_reason);
6565: --
6566: po_wf_util_pkg.SetItemAttrText ( itemtype => itemType,
6567: itemkey => itemkey,
6568: aname => 'PREPARER_USER_NAME' ,
6569: avalue => l_preparer_user_name);
6570:

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

6567: itemkey => itemkey,
6568: aname => 'PREPARER_USER_NAME' ,
6569: avalue => l_preparer_user_name);
6570:
6571: po_wf_util_pkg.SetItemAttrText ( itemtype => itemType,
6572: itemkey => itemkey,
6573: aname => 'PREPARER_DISPLAY_NAME' ,
6574: avalue => l_preparer_disp_name);
6575:

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

6577: -- setting the values in corresponding workflow attributes.
6578: PO_REQAPPROVAL_INIT1.get_user_name(p_agent_id, l_approver_user_name,
6579: l_approver_disp_name);
6580:
6581: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6582: itemkey => itemkey,
6583: aname => 'APPROVER_DISPLAY_NAME' ,
6584: avalue => l_approver_disp_name);
6585:

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

6582: itemkey => itemkey,
6583: aname => 'APPROVER_DISPLAY_NAME' ,
6584: avalue => l_approver_disp_name);
6585:
6586: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6587: itemkey => itemkey,
6588: aname => 'APPROVER_USER_NAME' ,
6589: avalue => l_approver_user_name);
6590:

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

6587: itemkey => itemkey,
6588: aname => 'APPROVER_USER_NAME' ,
6589: avalue => l_approver_user_name);
6590:
6591: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6592: itemkey => itemkey,
6593: aname => 'REQ_URL' ,
6594: avalue => l_open_req_url);
6595:

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

6592: itemkey => itemkey,
6593: aname => 'REQ_URL' ,
6594: avalue => l_open_req_url);
6595:
6596: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6597: itemkey => itemkey,
6598: aname => 'REQ_UPDATE_URL' ,
6599: avalue => l_update_req_url);
6600:

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

6597: itemkey => itemkey,
6598: aname => 'REQ_UPDATE_URL' ,
6599: avalue => l_update_req_url);
6600:
6601: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6602: itemkey => itemkey,
6603: aname => 'REQ_RESUBMIT_URL' ,
6604: avalue => l_resubmit_req_url);
6605:

Line 6719: x_contract_required_flag := po_wf_util_pkg.GetItemAttrText

6715: x_progress varchar2(300) := '000';
6716:
6717: begin
6718:
6719: x_contract_required_flag := po_wf_util_pkg.GetItemAttrText
6720: (itemtype => itemtype,
6721: itemkey => itemkey,
6722: aname => 'CONTRACT_REQUIRED_FLAG');
6723:

Line 6762: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText

6758: x_progress varchar2(300) := '000';
6759:
6760: begin
6761:
6762: x_use_contract_flag := po_wf_util_pkg.GetItemAttrText
6763: (itemtype => itemtype,
6764: itemkey => itemkey,
6765: aname => 'USE_CONTRACT_FLAG');
6766:

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

6804: x_catalog_type varchar2(30);
6805:
6806: begin
6807:
6808: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
6809: itemkey => itemkey,
6810: aname => 'CATALOG_TYPE');
6811:
6812: if nvl(x_catalog_type, 'CATALOG') <> 'NONCATALOG' then

Line 6869: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

6865: * source_line have been populated.
6866: * here it will just validate the contract docuement type.
6867: */
6868:
6869: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
6870: (itemtype => itemtype,
6871: itemkey => itemkey,
6872: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6873:

Line 6874: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

6870: (itemtype => itemtype,
6871: itemkey => itemkey,
6872: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
6873:
6874: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
6875: (itemtype => itemtype,
6876: itemkey => itemkey,
6877: aname => 'SOURCE_DOCUMENT_ID');
6878:

Line 6879: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber

6875: (itemtype => itemtype,
6876: itemkey => itemkey,
6877: aname => 'SOURCE_DOCUMENT_ID');
6878:
6879: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
6880: (itemtype => itemtype,
6881: itemkey => itemkey,
6882: aname => 'SOURCE_DOCUMENT_LINE_NUM');
6883: x_source_currency_code := po_wf_util_pkg.GetItemAttrText

Line 6883: x_source_currency_code := po_wf_util_pkg.GetItemAttrText

6879: x_source_doc_line_num := po_wf_util_pkg.GetItemAttrNumber
6880: (itemtype => itemtype,
6881: itemkey => itemkey,
6882: aname => 'SOURCE_DOCUMENT_LINE_NUM');
6883: x_source_currency_code := po_wf_util_pkg.GetItemAttrText
6884: (itemtype => itemtype,
6885: itemkey => itemkey,
6886: aname => 'CURRENCY_CODE');
6887:

Line 6889: l_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber

6885: itemkey => itemkey,
6886: aname => 'CURRENCY_CODE');
6887:
6888: --
6889: l_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber
6890: (itemtype => itemtype,
6891: itemkey => itemkey,
6892: aname => 'SUGGESTED_VENDOR_SITE_ID');
6893: --

Line 6895: x_is_clm_flow := po_wf_util_pkg.GetItemAttrText

6891: itemkey => itemkey,
6892: aname => 'SUGGESTED_VENDOR_SITE_ID');
6893: --
6894:
6895: x_is_clm_flow := po_wf_util_pkg.GetItemAttrText
6896: (itemtype => itemtype,
6897: itemkey => itemkey,
6898: aname => 'IS_CLM_FLOW');
6899:

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

6966: resultout := wf_engine.eng_completed || ':' || 'Y';
6967:
6968: else
6969: resultout := wf_engine.eng_completed || ':' || 'N';
6970: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
6971: itemkey => itemkey,
6972: aname => 'CONTRACT_REQUIRED_FLAG',
6973: avalue => 'Y');
6974: end if;

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

6983: IF (g_po_wf_debug = 'Y') THEN
6984: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
6985: END IF;
6986:
6987: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
6988: itemkey => itemkey,
6989: aname => 'CONTRACT_ID',
6990: avalue => x_source_doc_po_header_id);
6991:

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

6992: --
6993: -- Since the ref is a contract and is stored in attr CONTRACT_ID,
6994: -- null out the reference in SOURCE_DOCUMENT_ID
6995:
6996: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
6997: itemkey => itemkey,
6998: aname => 'SOURCE_DOCUMENT_ID',
6999: avalue => NULL);
7000:

Line 7042: x_incl_non_ctlg_req_flag := po_wf_util_pkg.GetItemAttrText

7038:
7039: begin
7040:
7041:
7042: x_incl_non_ctlg_req_flag := po_wf_util_pkg.GetItemAttrText
7043: (itemtype => itemtype,
7044: itemkey => itemkey,
7045: aname => 'INCLUDE_NON_CATALOG_REQ_FLAG');
7046:

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

7133:
7134: begin
7135:
7136: /* Set org context */
7137: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
7138: itemkey => itemkey,
7139: aname => 'ORG_ID');
7140:
7141: po_moac_utils_pvt.set_org_context(x_org_id); --

Line 7143: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

7139: aname => 'ORG_ID');
7140:
7141: po_moac_utils_pvt.set_org_context(x_org_id); --
7142:
7143: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
7144: (itemtype => itemtype,
7145: itemkey => itemkey,
7146: aname => 'SOURCE_DOCUMENT_ID');
7147:

Line 7148: x_ga_flag := po_wf_util_pkg.GetItemAttrText

7144: (itemtype => itemtype,
7145: itemkey => itemkey,
7146: aname => 'SOURCE_DOCUMENT_ID');
7147:
7148: x_ga_flag := po_wf_util_pkg.GetItemAttrText
7149: (itemtype => itemtype,
7150: itemkey => itemkey,
7151: aname => 'SOURCE_DOC_GA_FLAG');
7152:

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

7297: l_return_status VARCHAR2(1) := 'N';
7298:
7299: BEGIN
7300: --Set org context
7301: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
7302: itemkey => itemkey,
7303: aname => 'ORG_ID');
7304:
7305: IF x_org_id IS NOT NULL THEN

Line 7313: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber

7309: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
7310: x_progress := '10: buyer_on_src_doc_ok: result = Y';
7311: resultout := wf_engine.eng_completed || ':' || 'Y';
7312: ELSE --cross business group profile is 'N'
7313: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
7314: (itemtype => itemtype,
7315: itemkey => itemkey,
7316: aname => 'SOURCE_DOCUMENT_ID');
7317:

Line 7318: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText

7314: (itemtype => itemtype,
7315: itemkey => itemkey,
7316: aname => 'SOURCE_DOCUMENT_ID');
7317:
7318: x_source_doc_type_code := po_wf_util_pkg.GetItemAttrText
7319: (itemtype => itemtype,
7320: itemkey => itemkey,
7321: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
7322:

Line 7323: x_ga_flag := po_wf_util_pkg.GetItemAttrText

7319: (itemtype => itemtype,
7320: itemkey => itemkey,
7321: aname => 'SOURCE_DOCUMENT_TYPE_CODE');
7322:
7323: x_ga_flag := po_wf_util_pkg.GetItemAttrText
7324: (itemtype => itemtype,
7325: itemkey => itemkey,
7326: aname => 'SOURCE_DOC_GA_FLAG');
7327:

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

7427: l_return_status VARCHAR2(1) := 'N';
7428:
7429: BEGIN
7430: --Set org context
7431: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
7432: itemkey => itemkey,
7433: aname => 'ORG_ID');
7434:
7435: IF x_org_id IS NOT NULL THEN

Line 7443: x_contract_id := po_wf_util_pkg.GetItemAttrNumber

7439: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
7440: x_progress := '10: buyer_on_contract_ok: result = Y';
7441: resultout := wf_engine.eng_completed || ':' || 'Y';
7442: ELSE -- cross business group profile is 'N'
7443: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
7444: (itemtype => itemtype,
7445: itemkey => itemkey,
7446: aname => 'CONTRACT_ID');
7447:

Line 7547: l_org_id := po_wf_util_pkg.GetItemAttrNumber

7543: x_progress VARCHAR2(300);
7544:
7545: BEGIN
7546:
7547: l_org_id := po_wf_util_pkg.GetItemAttrNumber
7548: (itemtype => itemtype,
7549: itemkey => itemkey,
7550: aname => 'ORG_ID');
7551:

Line 7552: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber

7548: (itemtype => itemtype,
7549: itemkey => itemkey,
7550: aname => 'ORG_ID');
7551:
7552: l_purchasing_org_id := po_wf_util_pkg.GetItemAttrNumber
7553: (itemtype => itemtype,
7554: itemkey => itemkey,
7555: aname => 'PURCHASING_ORG_ID');
7556:

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

7646: l_cons_billing_cycle po_asl_attributes.consigned_billing_cycle%TYPE;
7647: BEGIN
7648:
7649: l_req_line_id :=
7650: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7651: itemkey => itemkey,
7652: aname => 'REQ_LINE_ID'
7653: );
7654: l_item_id :=

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

7651: itemkey => itemkey,
7652: aname => 'REQ_LINE_ID'
7653: );
7654: l_item_id :=
7655: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7656: itemkey => itemkey,
7657: aname => 'ITEM_ID'
7658: );
7659:

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

7657: aname => 'ITEM_ID'
7658: );
7659:
7660: l_source_doc_id :=
7661: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7662: itemkey => itemkey,
7663: aname => 'SOURCE_DOCUMENT_ID'
7664: );
7665:

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

7663: aname => 'SOURCE_DOCUMENT_ID'
7664: );
7665:
7666: l_requesting_org_id :=
7667: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7668: itemkey => itemkey,
7669: aname => 'ORG_ID'
7670: );
7671: l_purchasing_org_id :=

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

7668: itemkey => itemkey,
7669: aname => 'ORG_ID'
7670: );
7671: l_purchasing_org_id :=
7672: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7673: itemkey => itemkey,
7674: aname => 'PURCHASING_ORG_ID'
7675: );
7676:

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

7674: aname => 'PURCHASING_ORG_ID'
7675: );
7676:
7677: l_suggested_vendor_id :=
7678: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7679: itemkey => itemkey,
7680: aname => 'SUGGESTED_VENDOR_ID'
7681: );
7682:

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

7680: aname => 'SUGGESTED_VENDOR_ID'
7681: );
7682:
7683: l_suggested_vendor_site_id :=
7684: po_wf_util_pkg.getitemattrnumber (itemtype => itemtype,
7685: itemkey => itemkey,
7686: aname => 'SUGGESTED_VENDOR_SITE_ID'
7687: );
7688:

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

7816: || ' purchasing_org_id = ' || to_char(l_purchasing_org_id);
7817:
7818:
7819: --Set purchasing_org_id workflow attribute
7820: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
7821: itemkey => itemkey,
7822: aname => 'PURCHASING_ORG_ID',
7823: avalue => l_purchasing_org_id);
7824:

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

7883: BEGIN
7884:
7885: /* Set org context */
7886: l_progress := '000';
7887: l_org_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
7888: itemkey => itemkey,
7889: aname => 'ORG_ID');
7890: po_moac_utils_pvt.set_org_context(l_org_id); --
7891:

Line 7893: l_labor_req_line_id := po_wf_util_pkg.GetItemAttrNumber(

7889: aname => 'ORG_ID');
7890: po_moac_utils_pvt.set_org_context(l_org_id); --
7891:
7892: /* Get the expense line grouping ID */
7893: l_labor_req_line_id := po_wf_util_pkg.GetItemAttrNumber(
7894: itemtype => itemtype,
7895: itemkey => itemkey,
7896: aname => 'LABOR_REQ_LINE_ID');
7897:

Line 7972: l_req_line_id := po_wf_util_pkg.GetItemAttrNumber(

7968: BEGIN
7969:
7970: l_progress := '000';
7971: -- Get the requisition line ID
7972: l_req_line_id := po_wf_util_pkg.GetItemAttrNumber(
7973: itemtype => itemtype,
7974: itemkey => itemkey,
7975: aname => 'REQ_LINE_ID');
7976:

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

8008: x_catalog_type varchar2(30);
8009:
8010: begin
8011:
8012: x_catalog_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
8013: itemkey => itemkey,
8014: aname => 'CATALOG_TYPE');
8015:
8016: if nvl(x_catalog_type, 'CATALOG') <> 'TEMP_LABOR' then

Line 8057: x_incl_temp_labor_flag := po_wf_util_pkg.GetItemAttrText

8053: x_progress varchar2(300) := '000';
8054:
8055: begin
8056:
8057: x_incl_temp_labor_flag := po_wf_util_pkg.GetItemAttrText
8058: (itemtype => itemtype,
8059: itemkey => itemkey,
8060: aname => 'INCLUDE_TEMP_LABOR_FLAG');
8061: