DBA Data[Home] [Help]

APPS.PO_CHORD_WF3 dependencies on PO_WF_UTIL_PKG

Line 1115: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1111: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1112: '*** In procedure: set_wf_shipments_control ***');
1113: END IF;
1114:
1115: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1116: itemkey,
1117: 'CO_S_SHIPMENT_NUMBER',
1118: x_shipments_control.shipment_num);
1119:

Line 1121: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1117: 'CO_S_SHIPMENT_NUMBER',
1118: x_shipments_control.shipment_num);
1119:
1120:
1121: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1122: itemkey,
1123: 'CO_S_SHIP_TO_ORGANIZATION',
1124: x_shipments_control.ship_to_organization_id);
1125:

Line 1127: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1123: 'CO_S_SHIP_TO_ORGANIZATION',
1124: x_shipments_control.ship_to_organization_id);
1125:
1126:
1127: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1128: itemkey,
1129: 'CO_S_SHIP_TO_LOCATION',
1130: x_shipments_control.ship_to_location_id);
1131:

Line 1132: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1128: itemkey,
1129: 'CO_S_SHIP_TO_LOCATION',
1130: x_shipments_control.ship_to_location_id);
1131:
1132: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1133: itemkey,
1134: 'CO_S_PROMISED_DATE',
1135: x_shipments_control.promised_date);
1136:

Line 1138: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1134: 'CO_S_PROMISED_DATE',
1135: x_shipments_control.promised_date);
1136:
1137:
1138: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1139: itemkey,
1140: 'CO_S_NEED_BY_DATE',
1141: x_shipments_control.need_by_date);
1142:

Line 1144: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1140: 'CO_S_NEED_BY_DATE',
1141: x_shipments_control.need_by_date);
1142:
1143:
1144: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1145: itemkey,
1146: 'CO_S_LAST_ACCEPT_DATE',
1147: x_shipments_control.last_accept_date);
1148:

Line 1150: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1146: 'CO_S_LAST_ACCEPT_DATE',
1147: x_shipments_control.last_accept_date);
1148:
1149: -- ECO 5080252
1150: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1151: itemkey,
1152: 'CO_S_DAYS_LATE_RCPT_ALLOWED',
1153: x_shipments_control.days_late_rcpt_allowed);
1154:

Line 1155: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1151: itemkey,
1152: 'CO_S_DAYS_LATE_RCPT_ALLOWED',
1153: x_shipments_control.days_late_rcpt_allowed);
1154:
1155: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1156: itemkey,
1157: 'CO_S_TAXABLE_FLAG',
1158: x_shipments_control.taxable_flag);
1159:

Line 1161: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1157: 'CO_S_TAXABLE_FLAG',
1158: x_shipments_control.taxable_flag);
1159:
1160:
1161: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1162: itemkey,
1163: 'CO_S_PRICE_DISCOUNT',
1164: x_shipments_control.price_discount);
1165:

Line 1167: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1163: 'CO_S_PRICE_DISCOUNT',
1164: x_shipments_control.price_discount);
1165:
1166:
1167: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1168: itemkey,
1169: 'CO_S_CANCEL_FLAG',
1170: x_shipments_control.cancel_flag);
1171:

Line 1173: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1169: 'CO_S_CANCEL_FLAG',
1170: x_shipments_control.cancel_flag);
1171:
1172:
1173: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1174: itemkey,
1175: 'CO_S_CLOSED_CODE',
1176: x_shipments_control.closed_code);
1177:

Line 1181: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1177:
1178:
1179: --
1180:
1181: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1182: itemkey,
1183: 'CO_S_PAYMENT_TYPE',
1184: x_shipments_control.payment_type);
1185:

Line 1186: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1182: itemkey,
1183: 'CO_S_PAYMENT_TYPE',
1184: x_shipments_control.payment_type);
1185:
1186: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1187: itemkey,
1188: 'CO_S_WORK_APPROVER_ID',
1189: x_shipments_control.work_approver_id);
1190:

Line 1191: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1187: itemkey,
1188: 'CO_S_WORK_APPROVER_ID',
1189: x_shipments_control.work_approver_id);
1190:
1191: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1192: itemkey,
1193: 'CO_S_DESCRIPTION',
1194: x_shipments_control.description);
1195:

Line 1198: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,

1194: x_shipments_control.description);
1195:
1196: --
1197:
1198: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,
1199: itemkey,
1200: 'CO_S_QUANTITY_CHANGE',
1201: x_shipments_control.quantity_change);
1202:

Line 1203: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,

1199: itemkey,
1200: 'CO_S_QUANTITY_CHANGE',
1201: x_shipments_control.quantity_change);
1202:
1203: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,
1204: itemkey,
1205: 'CO_S_PRICE_OVERRIDE_CHANGE',
1206: x_shipments_control.price_override_change);
1207:

Line 1209: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1205: 'CO_S_PRICE_OVERRIDE_CHANGE',
1206: x_shipments_control.price_override_change);
1207:
1208: /* */
1209: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1210: itemkey,
1211: 'CO_S_START_DATE',
1212: x_shipments_control.start_date);
1213:

Line 1214: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1210: itemkey,
1211: 'CO_S_START_DATE',
1212: x_shipments_control.start_date);
1213:
1214: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1215: itemkey,
1216: 'CO_S_END_DATE',
1217: x_shipments_control.end_date);
1218: /* */

Line 1221: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1217: x_shipments_control.end_date);
1218: /* */
1219:
1220: /* Bug 2808011 START */
1221: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1222: itemkey,
1223: 'CO_S_PRICE_OVERRIDE',
1224: x_shipments_control.price_override);
1225: /* Bug 2808011 END */

Line 1229: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1225: /* Bug 2808011 END */
1226:
1227: --
1228:
1229: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1230: itemkey,
1231: 'CO_S_AMOUNT_CHANGE',
1232: x_shipments_control.amount_change);
1233:

Line 1234: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1230: itemkey,
1231: 'CO_S_AMOUNT_CHANGE',
1232: x_shipments_control.amount_change);
1233:
1234: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1235: itemkey,
1236: 'CO_S_START_DATE_CHANGE',
1237: x_shipments_control.start_date_change);
1238:

Line 1239: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1235: itemkey,
1236: 'CO_S_START_DATE_CHANGE',
1237: x_shipments_control.start_date_change);
1238:
1239: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1240: itemkey,
1241: 'CO_S_END_DATE_CHANGE',
1242: x_shipments_control.end_date_change);
1243:

Line 1244: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1240: itemkey,
1241: 'CO_S_END_DATE_CHANGE',
1242: x_shipments_control.end_date_change);
1243:
1244: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1245: itemkey,
1246: 'CO_S_NEED_BY_DATE_DATE_CHANGE',
1247: x_shipments_control.need_by_date_change);
1248:

Line 1249: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1245: itemkey,
1246: 'CO_S_NEED_BY_DATE_DATE_CHANGE',
1247: x_shipments_control.need_by_date_change);
1248:
1249: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1250: itemkey,
1251: 'CO_S_PROMISED_DATE_DATE_CHANGE',
1252: x_shipments_control.promised_date_change);
1253:

Line 1275: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1271: '*** In procedure: get_wf_shipments_control ***');
1272: END IF;
1273:
1274: x_shipments_control.shipment_num :=
1275: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1276: itemkey,
1277: 'CO_S_SHIPMENT_NUMBER');
1278:
1279: x_shipments_control.ship_to_organization_id :=

Line 1280: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1276: itemkey,
1277: 'CO_S_SHIPMENT_NUMBER');
1278:
1279: x_shipments_control.ship_to_organization_id :=
1280: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1281: itemkey,
1282: 'CO_S_SHIP_TO_ORGANIZATION');
1283:
1284: x_shipments_control.ship_to_location_id :=

Line 1285: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1281: itemkey,
1282: 'CO_S_SHIP_TO_ORGANIZATION');
1283:
1284: x_shipments_control.ship_to_location_id :=
1285: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1286: itemkey,
1287: 'CO_S_SHIP_TO_LOCATION');
1288:
1289: x_shipments_control.promised_date :=

Line 1290: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1286: itemkey,
1287: 'CO_S_SHIP_TO_LOCATION');
1288:
1289: x_shipments_control.promised_date :=
1290: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1291: itemkey,
1292: 'CO_S_PROMISED_DATE');
1293:
1294: x_shipments_control.need_by_date :=

Line 1295: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1291: itemkey,
1292: 'CO_S_PROMISED_DATE');
1293:
1294: x_shipments_control.need_by_date :=
1295: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1296: itemkey,
1297: 'CO_S_NEED_BY_DATE');
1298:
1299: x_shipments_control.last_accept_date:=

Line 1300: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1296: itemkey,
1297: 'CO_S_NEED_BY_DATE');
1298:
1299: x_shipments_control.last_accept_date:=
1300: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1301: itemkey,
1302: 'CO_S_LAST_ACCEPT_DATE');
1303:
1304: -- ECO 5080252

Line 1306: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1302: 'CO_S_LAST_ACCEPT_DATE');
1303:
1304: -- ECO 5080252
1305: x_shipments_control.days_late_rcpt_allowed :=
1306: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1307: itemkey,
1308: 'CO_S_DAYS_LATE_RCPT_ALLOWED');
1309:
1310: x_shipments_control.taxable_flag :=

Line 1311: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1307: itemkey,
1308: 'CO_S_DAYS_LATE_RCPT_ALLOWED');
1309:
1310: x_shipments_control.taxable_flag :=
1311: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1312: itemkey,
1313: 'CO_S_TAXABLE_FLAG');
1314:
1315: x_shipments_control.price_discount :=

Line 1316: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1312: itemkey,
1313: 'CO_S_TAXABLE_FLAG');
1314:
1315: x_shipments_control.price_discount :=
1316: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1317: itemkey,
1318: 'CO_S_PRICE_DISCOUNT');
1319:
1320: x_shipments_control.cancel_flag :=

Line 1321: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1317: itemkey,
1318: 'CO_S_PRICE_DISCOUNT');
1319:
1320: x_shipments_control.cancel_flag :=
1321: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1322: itemkey,
1323: 'CO_S_CANCEL_FLAG');
1324:
1325: x_shipments_control.closed_code :=

Line 1326: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1322: itemkey,
1323: 'CO_S_CANCEL_FLAG');
1324:
1325: x_shipments_control.closed_code :=
1326: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1327: itemkey,
1328: 'CO_S_CLOSED_CODE');
1329:
1330: x_shipments_control.quantity_change :=

Line 1331: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1327: itemkey,
1328: 'CO_S_CLOSED_CODE');
1329:
1330: x_shipments_control.quantity_change :=
1331: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1332: itemkey,
1333: 'CO_S_QUANTITY_CHANGE');
1334:
1335: x_shipments_control.price_override_change :=

Line 1336: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1332: itemkey,
1333: 'CO_S_QUANTITY_CHANGE');
1334:
1335: x_shipments_control.price_override_change :=
1336: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1337: itemkey,
1338: 'CO_S_PRICE_OVERRIDE_CHANGE');
1339:
1340: /* */

Line 1342: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1338: 'CO_S_PRICE_OVERRIDE_CHANGE');
1339:
1340: /* */
1341: x_shipments_control.start_date :=
1342: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1343: itemkey,
1344: 'CO_S_START_DATE');
1345:
1346: x_shipments_control.end_date :=

Line 1347: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1343: itemkey,
1344: 'CO_S_START_DATE');
1345:
1346: x_shipments_control.end_date :=
1347: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1348: itemkey,
1349: 'CO_S_END_DATE');
1350: /* */
1351:

Line 1354: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1350: /* */
1351:
1352: /* Bug 2808011 START */
1353: x_shipments_control.price_override :=
1354: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1355: itemkey,
1356: 'CO_S_PRICE_OVERRIDE');
1357: /* Bug 2808011 END */
1358:

Line 1363: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_PAYMENT_TYPE');

1359:
1360: --
1361:
1362: x_shipments_control.payment_type :=
1363: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_PAYMENT_TYPE');
1364:
1365: x_shipments_control.work_approver_id :=
1366: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_WORK_APPROVER_ID');
1367:

Line 1366: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_WORK_APPROVER_ID');

1362: x_shipments_control.payment_type :=
1363: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_PAYMENT_TYPE');
1364:
1365: x_shipments_control.work_approver_id :=
1366: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_WORK_APPROVER_ID');
1367:
1368: x_shipments_control.description :=
1369: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_DESCRIPTION');
1370:

Line 1369: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_DESCRIPTION');

1365: x_shipments_control.work_approver_id :=
1366: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_WORK_APPROVER_ID');
1367:
1368: x_shipments_control.description :=
1369: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_DESCRIPTION');
1370:
1371: --
1372:
1373:

Line 1377: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1373:
1374: --
1375:
1376: x_shipments_control.amount_change :=
1377: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1378: itemkey,
1379: 'CO_S_AMOUNT_CHANGE');
1380:
1381: x_shipments_control.start_date_change :=

Line 1382: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1378: itemkey,
1379: 'CO_S_AMOUNT_CHANGE');
1380:
1381: x_shipments_control.start_date_change :=
1382: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1383: itemkey,
1384: 'CO_S_START_DATE_CHANGE');
1385:
1386: x_shipments_control.end_date_change :=

Line 1387: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1383: itemkey,
1384: 'CO_S_START_DATE_CHANGE');
1385:
1386: x_shipments_control.end_date_change :=
1387: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1388: itemkey,
1389: 'CO_S_END_DATE_CHANGE');
1390:
1391: x_shipments_control.need_by_date_change :=

Line 1392: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1388: itemkey,
1389: 'CO_S_END_DATE_CHANGE');
1390:
1391: x_shipments_control.need_by_date_change :=
1392: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1393: itemkey,
1394: 'CO_S_NEED_BY_DATE_DATE_CHANGE');
1395:
1396: x_shipments_control.promised_date_change :=

Line 1397: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1393: itemkey,
1394: 'CO_S_NEED_BY_DATE_DATE_CHANGE');
1395:
1396: x_shipments_control.promised_date_change :=
1397: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1398: itemkey,
1399: 'CO_S_PROMISED_DATE_DATE_CHANGE');
1400:
1401: --

Line 1424: x_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype,

1420: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1421: '*** In procedure get_wf_shipments_parameters ***');
1422: END IF;
1423:
1424: x_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype,
1425: itemkey,
1426: 'DOCUMENT_TYPE');
1427:
1428: IF x_doc_type IN ('PO', 'PA') THEN

Line 1431: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1427:
1428: IF x_doc_type IN ('PO', 'PA') THEN
1429:
1430: x_shipments_parameters.po_header_id :=
1431: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1432: itemkey,
1433: 'DOCUMENT_ID');
1434:
1435: x_shipments_parameters.po_release_id:=NULL;

Line 1440: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1436:
1437: ELSIF x_doc_type = 'RELEASE' THEN
1438:
1439: x_shipments_parameters.po_release_id :=
1440: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1441: itemkey,
1442: 'DOCUMENT_ID');
1443:
1444: x_shipments_parameters.po_header_id:=NULL;