DBA Data[Home] [Help]

APPS.PO_CHORD_WF3 dependencies on PO_WF_UTIL_PKG

Line 1119: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1115: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1116: '*** In procedure: set_wf_shipments_control ***');
1117: END IF;
1118:
1119: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1120: itemkey,
1121: 'CO_S_SHIPMENT_NUMBER',
1122: x_shipments_control.shipment_num);
1123:

Line 1125: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1121: 'CO_S_SHIPMENT_NUMBER',
1122: x_shipments_control.shipment_num);
1123:
1124:
1125: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1126: itemkey,
1127: 'CO_S_SHIP_TO_ORGANIZATION',
1128: x_shipments_control.ship_to_organization_id);
1129:

Line 1131: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1127: 'CO_S_SHIP_TO_ORGANIZATION',
1128: x_shipments_control.ship_to_organization_id);
1129:
1130:
1131: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1132: itemkey,
1133: 'CO_S_SHIP_TO_LOCATION',
1134: x_shipments_control.ship_to_location_id);
1135:

Line 1136: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1132: itemkey,
1133: 'CO_S_SHIP_TO_LOCATION',
1134: x_shipments_control.ship_to_location_id);
1135:
1136: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1137: itemkey,
1138: 'CO_S_PROMISED_DATE',
1139: x_shipments_control.promised_date);
1140:

Line 1142: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1138: 'CO_S_PROMISED_DATE',
1139: x_shipments_control.promised_date);
1140:
1141:
1142: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1143: itemkey,
1144: 'CO_S_NEED_BY_DATE',
1145: x_shipments_control.need_by_date);
1146:

Line 1148: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1144: 'CO_S_NEED_BY_DATE',
1145: x_shipments_control.need_by_date);
1146:
1147:
1148: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1149: itemkey,
1150: 'CO_S_LAST_ACCEPT_DATE',
1151: x_shipments_control.last_accept_date);
1152:

Line 1154: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1150: 'CO_S_LAST_ACCEPT_DATE',
1151: x_shipments_control.last_accept_date);
1152:
1153: -- ECO 5080252
1154: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1155: itemkey,
1156: 'CO_S_DAYS_LATE_RCPT_ALLOWED',
1157: x_shipments_control.days_late_rcpt_allowed);
1158:

Line 1159: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1155: itemkey,
1156: 'CO_S_DAYS_LATE_RCPT_ALLOWED',
1157: x_shipments_control.days_late_rcpt_allowed);
1158:
1159: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1160: itemkey,
1161: 'CO_S_TAXABLE_FLAG',
1162: x_shipments_control.taxable_flag);
1163:

Line 1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1161: 'CO_S_TAXABLE_FLAG',
1162: x_shipments_control.taxable_flag);
1163:
1164:
1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1166: itemkey,
1167: 'CO_S_PRICE_DISCOUNT',
1168: x_shipments_control.price_discount);
1169:

Line 1171: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1167: 'CO_S_PRICE_DISCOUNT',
1168: x_shipments_control.price_discount);
1169:
1170:
1171: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1172: itemkey,
1173: 'CO_S_CANCEL_FLAG',
1174: x_shipments_control.cancel_flag);
1175:

Line 1177: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1173: 'CO_S_CANCEL_FLAG',
1174: x_shipments_control.cancel_flag);
1175:
1176:
1177: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1178: itemkey,
1179: 'CO_S_CLOSED_CODE',
1180: x_shipments_control.closed_code);
1181:

Line 1185: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

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

Line 1190: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1186: itemkey,
1187: 'CO_S_PAYMENT_TYPE',
1188: x_shipments_control.payment_type);
1189:
1190: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1191: itemkey,
1192: 'CO_S_WORK_APPROVER_ID',
1193: x_shipments_control.work_approver_id);
1194:

Line 1195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1191: itemkey,
1192: 'CO_S_WORK_APPROVER_ID',
1193: x_shipments_control.work_approver_id);
1194:
1195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1196: itemkey,
1197: 'CO_S_DESCRIPTION',
1198: x_shipments_control.description);
1199:

Line 1202: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,

1198: x_shipments_control.description);
1199:
1200: --
1201:
1202: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,
1203: itemkey,
1204: 'CO_S_QUANTITY_CHANGE',
1205: x_shipments_control.quantity_change);
1206:

Line 1207: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,

1203: itemkey,
1204: 'CO_S_QUANTITY_CHANGE',
1205: x_shipments_control.quantity_change);
1206:
1207: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype,
1208: itemkey,
1209: 'CO_S_PRICE_OVERRIDE_CHANGE',
1210: x_shipments_control.price_override_change);
1211:

Line 1213: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

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

Line 1218: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1214: itemkey,
1215: 'CO_S_START_DATE',
1216: x_shipments_control.start_date);
1217:
1218: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1219: itemkey,
1220: 'CO_S_END_DATE',
1221: x_shipments_control.end_date);
1222: /* */

Line 1225: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1221: x_shipments_control.end_date);
1222: /* */
1223:
1224: /* Bug 2808011 START */
1225: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1226: itemkey,
1227: 'CO_S_PRICE_OVERRIDE',
1228: x_shipments_control.price_override);
1229: /* Bug 2808011 END */

Line 1233: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1229: /* Bug 2808011 END */
1230:
1231: --
1232:
1233: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1234: itemkey,
1235: 'CO_S_AMOUNT_CHANGE',
1236: x_shipments_control.amount_change);
1237:

Line 1238: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1234: itemkey,
1235: 'CO_S_AMOUNT_CHANGE',
1236: x_shipments_control.amount_change);
1237:
1238: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1239: itemkey,
1240: 'CO_S_START_DATE_CHANGE',
1241: x_shipments_control.start_date_change);
1242:

Line 1243: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1239: itemkey,
1240: 'CO_S_START_DATE_CHANGE',
1241: x_shipments_control.start_date_change);
1242:
1243: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1244: itemkey,
1245: 'CO_S_END_DATE_CHANGE',
1246: x_shipments_control.end_date_change);
1247:

Line 1248: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1244: itemkey,
1245: 'CO_S_END_DATE_CHANGE',
1246: x_shipments_control.end_date_change);
1247:
1248: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1249: itemkey,
1250: 'CO_S_NEED_BY_DATE_DATE_CHANGE',
1251: x_shipments_control.need_by_date_change);
1252:

Line 1253: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1249: itemkey,
1250: 'CO_S_NEED_BY_DATE_DATE_CHANGE',
1251: x_shipments_control.need_by_date_change);
1252:
1253: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1254: itemkey,
1255: 'CO_S_PROMISED_DATE_DATE_CHANGE',
1256: x_shipments_control.promised_date_change);
1257:

Line 1279: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1275: '*** In procedure: get_wf_shipments_control ***');
1276: END IF;
1277:
1278: x_shipments_control.shipment_num :=
1279: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1280: itemkey,
1281: 'CO_S_SHIPMENT_NUMBER');
1282:
1283: x_shipments_control.ship_to_organization_id :=

Line 1284: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1280: itemkey,
1281: 'CO_S_SHIPMENT_NUMBER');
1282:
1283: x_shipments_control.ship_to_organization_id :=
1284: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1285: itemkey,
1286: 'CO_S_SHIP_TO_ORGANIZATION');
1287:
1288: x_shipments_control.ship_to_location_id :=

Line 1289: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1285: itemkey,
1286: 'CO_S_SHIP_TO_ORGANIZATION');
1287:
1288: x_shipments_control.ship_to_location_id :=
1289: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1290: itemkey,
1291: 'CO_S_SHIP_TO_LOCATION');
1292:
1293: x_shipments_control.promised_date :=

Line 1294: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1290: itemkey,
1291: 'CO_S_SHIP_TO_LOCATION');
1292:
1293: x_shipments_control.promised_date :=
1294: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1295: itemkey,
1296: 'CO_S_PROMISED_DATE');
1297:
1298: x_shipments_control.need_by_date :=

Line 1299: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1295: itemkey,
1296: 'CO_S_PROMISED_DATE');
1297:
1298: x_shipments_control.need_by_date :=
1299: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1300: itemkey,
1301: 'CO_S_NEED_BY_DATE');
1302:
1303: x_shipments_control.last_accept_date:=

Line 1304: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1300: itemkey,
1301: 'CO_S_NEED_BY_DATE');
1302:
1303: x_shipments_control.last_accept_date:=
1304: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1305: itemkey,
1306: 'CO_S_LAST_ACCEPT_DATE');
1307:
1308: -- ECO 5080252

Line 1310: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1306: 'CO_S_LAST_ACCEPT_DATE');
1307:
1308: -- ECO 5080252
1309: x_shipments_control.days_late_rcpt_allowed :=
1310: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1311: itemkey,
1312: 'CO_S_DAYS_LATE_RCPT_ALLOWED');
1313:
1314: x_shipments_control.taxable_flag :=

Line 1315: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1311: itemkey,
1312: 'CO_S_DAYS_LATE_RCPT_ALLOWED');
1313:
1314: x_shipments_control.taxable_flag :=
1315: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1316: itemkey,
1317: 'CO_S_TAXABLE_FLAG');
1318:
1319: x_shipments_control.price_discount :=

Line 1320: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1316: itemkey,
1317: 'CO_S_TAXABLE_FLAG');
1318:
1319: x_shipments_control.price_discount :=
1320: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1321: itemkey,
1322: 'CO_S_PRICE_DISCOUNT');
1323:
1324: x_shipments_control.cancel_flag :=

Line 1325: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1321: itemkey,
1322: 'CO_S_PRICE_DISCOUNT');
1323:
1324: x_shipments_control.cancel_flag :=
1325: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1326: itemkey,
1327: 'CO_S_CANCEL_FLAG');
1328:
1329: x_shipments_control.closed_code :=

Line 1330: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1326: itemkey,
1327: 'CO_S_CANCEL_FLAG');
1328:
1329: x_shipments_control.closed_code :=
1330: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1331: itemkey,
1332: 'CO_S_CLOSED_CODE');
1333:
1334: x_shipments_control.quantity_change :=

Line 1335: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1331: itemkey,
1332: 'CO_S_CLOSED_CODE');
1333:
1334: x_shipments_control.quantity_change :=
1335: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1336: itemkey,
1337: 'CO_S_QUANTITY_CHANGE');
1338:
1339: x_shipments_control.price_override_change :=

Line 1340: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1336: itemkey,
1337: 'CO_S_QUANTITY_CHANGE');
1338:
1339: x_shipments_control.price_override_change :=
1340: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1341: itemkey,
1342: 'CO_S_PRICE_OVERRIDE_CHANGE');
1343:
1344: /* */

Line 1346: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

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

Line 1351: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1347: itemkey,
1348: 'CO_S_START_DATE');
1349:
1350: x_shipments_control.end_date :=
1351: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1352: itemkey,
1353: 'CO_S_END_DATE');
1354: /* */
1355:

Line 1358: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1354: /* */
1355:
1356: /* Bug 2808011 START */
1357: x_shipments_control.price_override :=
1358: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1359: itemkey,
1360: 'CO_S_PRICE_OVERRIDE');
1361: /* Bug 2808011 END */
1362:

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

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

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

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

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

1369: x_shipments_control.work_approver_id :=
1370: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_WORK_APPROVER_ID');
1371:
1372: x_shipments_control.description :=
1373: PO_WF_UTIL_PKG.GetItemAttrText(itemtype, itemkey, 'CO_S_DESCRIPTION');
1374:
1375: --
1376:
1377:

Line 1381: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1377:
1378: --
1379:
1380: x_shipments_control.amount_change :=
1381: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1382: itemkey,
1383: 'CO_S_AMOUNT_CHANGE');
1384:
1385: x_shipments_control.start_date_change :=

Line 1386: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1382: itemkey,
1383: 'CO_S_AMOUNT_CHANGE');
1384:
1385: x_shipments_control.start_date_change :=
1386: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1387: itemkey,
1388: 'CO_S_START_DATE_CHANGE');
1389:
1390: x_shipments_control.end_date_change :=

Line 1391: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1387: itemkey,
1388: 'CO_S_START_DATE_CHANGE');
1389:
1390: x_shipments_control.end_date_change :=
1391: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1392: itemkey,
1393: 'CO_S_END_DATE_CHANGE');
1394:
1395: x_shipments_control.need_by_date_change :=

Line 1396: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1392: itemkey,
1393: 'CO_S_END_DATE_CHANGE');
1394:
1395: x_shipments_control.need_by_date_change :=
1396: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1397: itemkey,
1398: 'CO_S_NEED_BY_DATE_DATE_CHANGE');
1399:
1400: x_shipments_control.promised_date_change :=

Line 1401: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1397: itemkey,
1398: 'CO_S_NEED_BY_DATE_DATE_CHANGE');
1399:
1400: x_shipments_control.promised_date_change :=
1401: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1402: itemkey,
1403: 'CO_S_PROMISED_DATE_DATE_CHANGE');
1404:
1405: --

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

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

Line 1435: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1431:
1432: IF x_doc_type IN ('PO', 'PA') THEN
1433:
1434: x_shipments_parameters.po_header_id :=
1435: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1436: itemkey,
1437: 'DOCUMENT_ID');
1438:
1439: x_shipments_parameters.po_release_id:=NULL;

Line 1444: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,

1440:
1441: ELSIF x_doc_type = 'RELEASE' THEN
1442:
1443: x_shipments_parameters.po_release_id :=
1444: PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype,
1445: itemkey,
1446: 'DOCUMENT_ID');
1447:
1448: x_shipments_parameters.po_header_id:=NULL;