DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV7 dependencies on PO_LINES

Line 29: l_line_num po_lines_interface.line_num%TYPE := NULL;

25: IS
26: X_progress varchar2(3) := NULL;
27: X_count binary_integer;
28: X_order_type varchar2(25) := NULL;
29: l_line_num po_lines_interface.line_num%TYPE := NULL;
30:
31: BEGIN
32: X_progress := '010';
33: /* if the create_po_line_loc_flag is Y and the order_type

Line 63: 'PO_LINES_INTERFACE',

59: null,
60: x_interface_header_id,
61: x_interface_line_id,
62: 'PO_PDOI_PRICE_BRK_AMT_BASED_LN',
63: 'PO_LINES_INTERFACE',
64: null,
65: null,null,null,null,null,null,
66: null,null,null,null,null,null,
67: x_header_processable_flag);

Line 70: /* check to see if we can find the match in po_lines table

66: null,null,null,null,null,null,
67: x_header_processable_flag);
68: END IF;
69:
70: /* check to see if we can find the match in po_lines table
71: based on the information that we had . Note we do not match
72: unit_of_measure ... because for quotes we can specify UOM different from
73: what is specified in po_lines, as long as it is a valid UOM.
74: */

Line 73: what is specified in po_lines, as long as it is a valid UOM.

69:
70: /* check to see if we can find the match in po_lines table
71: based on the information that we had . Note we do not match
72: unit_of_measure ... because for quotes we can specify UOM different from
73: what is specified in po_lines, as long as it is a valid UOM.
74: */
75: --
76: --Search po_lines table based on job_id
77: X_progress := '030';

Line 76: --Search po_lines table based on job_id

72: unit_of_measure ... because for quotes we can specify UOM different from
73: what is specified in po_lines, as long as it is a valid UOM.
74: */
75: --
76: --Search po_lines table based on job_id
77: X_progress := '030';
78: IF (X_item_id is NOT NULL) THEN
79:
80: SELECT count(*)

Line 82: FROM po_lines

78: IF (X_item_id is NOT NULL) THEN
79:
80: SELECT count(*)
81: INTO X_count
82: FROM po_lines
83: WHERE po_header_id = X_po_header_id
84: AND po_line_id = X_po_line_id
85: AND item_id = X_item_id
86: AND (item_revision = X_item_revision

Line 101: 'PO_LINES_INTERFACE',

97: null,
98: x_interface_header_id,
99: x_interface_line_id,
100: 'PO_PDOI_INVALID_LOCATION_REC',
101: 'PO_LINES_INTERFACE',
102: null,
103: null,null,null,null,null,null,
104: null,null,null,null,null,null,
105: x_header_processable_flag);

Line 117: FROM po_lines

113: X_progress := '040';
114:
115: SELECT count(*)
116: INTO X_count
117: FROM po_lines
118: WHERE po_header_id = X_po_header_id
119: AND po_line_id = X_po_line_id
120: AND item_description = X_item_description
121: AND line_type_id = X_line_type_id

Line 132: 'PO_LINES_INTERFACE',

128: null,
129: x_interface_header_id,
130: x_interface_line_id,
131: 'PO_PDOI_INVALID_LOCATION_REC',
132: 'PO_LINES_INTERFACE',
133: null,
134: null,null,null,null,null,null,
135: null,null,null,null,null,null,
136: x_header_processable_flag);

Line 144: FROM PO_LINES

140: ELSIF (p_job_id IS NOT NULL) THEN
141:
142: SELECT count(*)
143: INTO X_count
144: FROM PO_LINES
145: WHERE po_header_id = X_po_header_id
146: AND po_line_id = X_po_line_id
147: AND job_id = p_job_id
148: AND line_type_id = X_line_type_id

Line 159: X_Table_name => 'PO_LINES_INTERFACE',

155: X_Batch_id => NULL,
156: X_Interface_Header_Id => x_interface_header_id,
157: X_Interface_Line_id => x_interface_line_id,
158: X_Error_message_name => 'PO_PDOI_INVALID_LOCATION_REC',
159: X_Table_name => 'PO_LINES_INTERFACE',
160: X_Column_name => 'NULL',
161: X_TokenName1 => NULL,
162: X_TokenName2 => NULL,
163: X_TokenName3 => NULL,

Line 188: FROM po_lines

184: X_progress := '050';
185:
186: SELECT count(*)
187: INTO X_count
188: FROM po_lines
189: WHERE po_header_id = X_po_header_id
190: AND po_line_id = X_po_line_id
191: AND line_num = p_line_num;
192:

Line 201: 'PO_LINES_INTERFACE',

197: null,
198: x_interface_header_id,
199: x_interface_line_id,
200: 'PO_PDOI_INVALID_LOCATION_REC',
201: 'PO_LINES_INTERFACE',
202: null,
203: null,null,null,null,null,null,
204: null,null,null,null,null,null,
205: x_header_processable_flag);

Line 342: l_pb_lookup_code po_lines_all.price_break_lookup_code%TYPE := null; /* */

338: l_header_start_date date := null; /* */
339: l_header_end_date date := null; /* */
340: l_exp_date date := null; /* */
341: l_errormsg varchar2(80) := null; /* */
342: l_pb_lookup_code po_lines_all.price_break_lookup_code%TYPE := null; /* */
343: l_is_ship_to_org_valid BOOLEAN; --< Shared Proc FPJ >
344: l_in_current_sob BOOLEAN; --< Shared Proc FPJ >
345: l_check_txn_flow BOOLEAN; --< Shared Proc FPJ >
346: l_return_status VARCHAR2(1); --< Shared Proc FPJ >

Line 347: l_line_price PO_LINES_ALL.unit_price%TYPE; -- Bug 3348047

343: l_is_ship_to_org_valid BOOLEAN; --< Shared Proc FPJ >
344: l_in_current_sob BOOLEAN; --< Shared Proc FPJ >
345: l_check_txn_flow BOOLEAN; --< Shared Proc FPJ >
346: l_return_status VARCHAR2(1); --< Shared Proc FPJ >
347: l_line_price PO_LINES_ALL.unit_price%TYPE; -- Bug 3348047
348:
349: BEGIN
350:
351: /*** first need to make sure all the required columns are populated ***/

Line 361: 'PO_LINES_INTERFACE',

357: null,
358: x_interface_header_id,
359: x_interface_line_id,
360: 'PO_PDOI_COLUMN_NOT_NULL',
361: 'PO_LINES_INTERFACE',
362: 'SHIPMENT_TYPE',
363: 'COLUMN_NAME',
364: null,null,null,null,null,
365: 'SHIPMENT_TYPE',

Line 379: 'PO_LINES_INTERFACE',

375: null,
376: x_interface_header_id,
377: x_interface_line_id,
378: 'PO_PDOI_COLUMN_NOT_NULL',
379: 'PO_LINES_INTERFACE',
380: 'SHIPMENT_NUM',
381: 'COLUMN_NAME',
382: null,null,null,null,null,
383: 'SHIPMENT_NUM',

Line 399: 'PO_LINES_INTERFACE',

395: null,
396: x_interface_header_id,
397: x_interface_line_id,
398: 'PO_PDOI_COLUMN_NOT_NULL',
399: 'PO_LINES_INTERFACE',
400: 'PO_LINE_LOCATION_ID',
401: 'COLUMN_NAME',
402: null,null,null,null,null,
403: 'PO_LINE_LOCATION_ID',

Line 419: 'PO_LINES_INTERFACE',

415: null,
416: x_interface_header_id,
417: x_interface_line_id,
418: 'PO_PDOI_COLUMN_NOT_NULL',
419: 'PO_LINES_INTERFACE',
420: 'PO_LINE_ID',
421: 'COLUMN_NAME',
422: null,null,null,null,null,
423: 'PO_LINE_ID',

Line 439: 'PO_LINES_INTERFACE',

435: null,
436: x_interface_header_id,
437: x_interface_line_id,
438: 'PO_PDOI_COLUMN_NOT_NULL',
439: 'PO_LINES_INTERFACE',
440: 'PO_HEADER_ID',
441: 'COLUMN_NAME',
442: null,null,null,null,null,
443: 'PO_HEADER_ID',

Line 471: X_Table_name => 'PO_LINES_INTERFACE',

467: X_Batch_id => NULL,
468: X_Interface_Header_Id => x_interface_header_id,
469: X_Interface_Line_id => x_interface_line_id,
470: X_Error_message_name => 'PO_PDOI_SVC_NO_MULTI_SHIP',
471: X_Table_name => 'PO_LINES_INTERFACE',
472: X_Column_name => 'NULL',
473: X_TokenName1 => NULL,
474: X_TokenName2 => NULL,
475: X_TokenName3 => NULL,

Line 501: X_Table_name => 'PO_LINES_INTERFACE',

497: X_Batch_id => NULL,
498: X_Interface_Header_Id => x_interface_header_id,
499: X_Interface_Line_id => x_interface_line_id,
500: X_Error_message_name => 'PO_PDOI_SVC_PB_NO_QTY',
501: X_Table_name => 'PO_LINES_INTERFACE',
502: X_Column_name => 'QUANTITY',
503: X_TokenName1 => NULL,
504: X_TokenName2 => NULL,
505: X_TokenName3 => NULL,

Line 530: 'PO_LINES_INTERFACE',

526: null,
527: x_interface_header_id,
528: x_interface_line_id,
529: 'PO_PDOI_COLUMN_NOT_NULL',
530: 'PO_LINES_INTERFACE',
531: 'QUANTITY',
532: 'COLUMN_NAME',
533: null,null,null,null,null,
534: 'QUANTITY',

Line 555: 'PO_LINES_INTERFACE',

551: null,
552: x_interface_header_id,
553: x_interface_line_id,
554: 'PO_PDOI_COLUMN_NOT_NULL',
555: 'PO_LINES_INTERFACE',
556: 'PRICE_OVERRIDE',
557: 'COLUMN_NAME',
558: null,null,null,null,null,
559: 'PRICE_OVERRIDE',

Line 574: po_lines pol

570: BEGIN
571: select poh.start_date, poh.end_date, pol.expiration_date
572: into l_header_start_date, l_header_end_date, l_exp_date
573: from po_headers poh,
574: po_lines pol
575: where poh.po_header_id = x_po_header_id
576: and pol.po_line_id = x_po_line_id;
577: EXCEPTION
578: when others then

Line 598: 'PO_LINES_INTERFACE',

594: null,
595: x_interface_header_id,
596: x_interface_line_id,
597: l_errormsg,
598: 'PO_LINES_INTERFACE',
599: 'null',
600: 'null',
601: null,null,null,null,null,
602: 'null',

Line 623: 'PO_LINES_INTERFACE',

619: null,
620: x_interface_header_id,
621: x_interface_line_id,
622: l_errormsg,
623: 'PO_LINES_INTERFACE',
624: 'null',
625: 'null',
626: null,null,null,null,null,
627: 'null',

Line 638: from po_lines

634: if (x_start_date is not null OR x_end_date is not null) then
635: BEGIN
636: select price_break_lookup_code
637: into l_pb_lookup_code
638: from po_lines
639: where po_header_id = x_po_header_id
640: and po_line_id = x_po_line_id;
641: EXCEPTION
642: when others then

Line 653: 'PO_LINES_INTERFACE',

649: null,
650: x_interface_header_id,
651: x_interface_line_id,
652: 'PO_PDOI_CUMULATIVE_FAILED',
653: 'PO_LINES_INTERFACE',
654: 'null',
655: 'null',
656: null,null,null,null,null,
657: 'null',

Line 692: 'PO_LINES_INTERFACE',

688: null,
689: x_interface_header_id,
690: x_interface_line_id,
691: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
692: 'PO_LINES_INTERFACE',
693: 'SHIP_TO_ORGANIZATION_ID',
694: 'VALUE',
695: null,null,null,null,null,
696: x_ship_to_organization_id,

Line 720: 'PO_LINES_INTERFACE',

716: null,
717: x_interface_header_id,
718: x_interface_line_id,
719: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
720: 'PO_LINES_INTERFACE',
721: 'SHIP_TO_ORGANIZATION_ID',
722: 'VALUE',
723: null,null,null,null,null,
724: x_ship_to_organization_id,

Line 744: 'PO_LINES_INTERFACE',

740: null,
741: x_interface_header_id,
742: x_interface_line_id,
743: 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
744: 'PO_LINES_INTERFACE',
745: 'SHIP_TO_ORGANIZATION_ID',
746: 'VALUE',
747: null,null,null,null,null,
748: x_ship_to_organization_id,

Line 788: x_table_name => 'PO_LINES_INTERFACE',

784: x_batch_id => NULL,
785: x_interface_header_id => x_interface_header_id,
786: x_interface_line_id => x_interface_line_id,
787: x_error_message_name => 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
788: x_table_name => 'PO_LINES_INTERFACE',
789: x_column_name => 'SHIP_TO_ORGANIZATION_ID',
790: x_tokenname1 => 'VALUE',
791: x_tokenname2 => NULL,
792: x_tokenname3 => NULL,

Line 837: x_table_name => 'PO_LINES_INTERFACE',

833: x_batch_id => NULL,
834: x_interface_header_id => x_interface_header_id,
835: x_interface_line_id => x_interface_line_id,
836: x_error_message_name => 'PO_PDOI_INVALID_SHIP_TO_ORG_ID',
837: x_table_name => 'PO_LINES_INTERFACE',
838: x_column_name => 'SHIP_TO_ORGANIZATION_ID',
839: x_tokenname1 => 'VALUE',
840: x_tokenname2 => NULL,
841: x_tokenname3 => NULL,

Line 887: 'PO_LINES_INTERFACE',

883: null,
884: x_interface_header_id,
885: x_interface_line_id,
886: 'PO_PDOI_INVALID_SHIP_TO_LOC_ID',
887: 'PO_LINES_INTERFACE',
888: 'SHIP_TO_LOCATION_ID',
889: 'VALUE',
890: null,null,null,null,null,
891: x_ship_to_location_id,

Line 909: 'PO_LINES_INTERFACE',

905: null,
906: x_interface_header_id,
907: x_interface_line_id,
908: 'PO_PDOI_INVALID_PAY_TERMS',
909: 'PO_LINES_INTERFACE',
910: 'TERMS_ID',
911: 'VALUE',
912: null,null,null,null,null,
913: x_terms_id,

Line 931: 'PO_LINES_INTERFACE',

927: null,
928: x_interface_header_id,
929: x_interface_line_id,
930: 'PO_PDOI_LT_ZERO',
931: 'PO_LINES_INTERFACE',
932: 'QTY_RCV_TOLERANCE',
933: 'COLUMN_NAME',
934: 'VALUE',
935: null,null,null,null,

Line 955: 'PO_LINES_INTERFACE',

951: null,
952: x_interface_header_id,
953: x_interface_line_id,
954: 'PO_PDOI_INVALID_RCV_EXCEP_CD',
955: 'PO_LINES_INTERFACE',
956: 'QTY_RCV_EXCEPTION_CODE',
957: 'VALUE',
958: null,null,null,null,null,
959: x_qty_rcv_exception_code,

Line 980: 'PO_LINES_INTERFACE',

976: null,
977: x_interface_header_id,
978: x_interface_line_id,
979: 'PO_PDOI_INVALID_FREIGHT_CARR',
980: 'PO_LINES_INTERFACE',
981: 'SHIP_VIA_LOOKUP_CODE',
982: 'VALUE',
983: null,null,null,null,null,
984: x_ship_via_lookup_code,

Line 1001: 'PO_LINES_INTERFACE',

997: null,
998: x_interface_header_id,
999: x_interface_line_id,
1000: 'PO_PDOI_INVALID_FOB',
1001: 'PO_LINES_INTERFACE',
1002: 'FOB_LOOKUP_CODE',
1003: 'VALUE',
1004: null,null,null,null,null,
1005: x_fob_lookup_code,

Line 1024: 'PO_LINES_INTERFACE',

1020: null,
1021: x_interface_header_id,
1022: x_interface_line_id,
1023: 'PO_PDOI_INVALID_FREIGHT_TERMS',
1024: 'PO_LINES_INTERFACE',
1025: 'FREIGHT_TERMS_LOOKUP_CODE',
1026: 'VALUE',
1027: null,null,null,null,null,
1028: x_freight_terms_lookup_code,

Line 1044: 'PO_LINES_INTERFACE',

1040: null,
1041: x_interface_header_id,
1042: x_interface_line_id,
1043: 'PO_PDOI_LT_ZERO',
1044: 'PO_LINES_INTERFACE',
1045: 'PRICE_OVERRIDE',
1046: 'COLUMN_NAME',
1047: 'VALUE',
1048: null,null,null,null,

Line 1068: 'PO_LINES_INTERFACE',

1064: null,
1065: x_interface_header_id,
1066: x_interface_line_id,
1067: 'PO_PDOI_INVALID_LEAD_TIME',
1068: 'PO_LINES_INTERFACE',
1069: 'LEAD_TIME_UNIT',
1070: 'VALUE',
1071: null,null,null,null,null,
1072: x_lead_time_unit,

Line 1090: 'PO_LINES_INTERFACE',

1086: null,
1087: x_interface_header_id,
1088: x_interface_line_id,
1089: 'PO_PDOI_INVALID_DISCOUNT',
1090: 'PO_LINES_INTERFACE',
1091: 'PRICE_DISCOUNT',
1092: 'VALUE',
1093: null,null,null,null,null,
1094: x_price_discount,

Line 1112: 'PO_LINES_INTERFACE',

1108: null,
1109: x_interface_header_id,
1110: x_interface_line_id,
1111: 'PO_PDOI_INVALID_START_DATE',
1112: 'PO_LINES_INTERFACE',
1113: 'START_DATE',
1114: 'VALUE',
1115: null,null,null,null,null,
1116: fnd_date.date_to_chardate(x_start_date),

Line 1139: 'PO_LINES_INTERFACE',

1135: null,
1136: x_interface_header_id,
1137: x_interface_line_id,
1138: 'PO_PDOI_EFF_DATE_GT_HEADER',
1139: 'PO_LINES_INTERFACE',
1140: 'EFFECTIVE_DATE',
1141: 'VALUE',
1142: null,null,null,null,null,
1143: fnd_date.date_to_chardate(x_start_date),

Line 1161: 'PO_LINES_INTERFACE',

1157: null,
1158: x_interface_header_id,
1159: x_interface_line_id,
1160: 'PO_PDOI_EFF_DATE_GT_HEADER',
1161: 'PO_LINES_INTERFACE',
1162: 'EXPIRATION_DATE',
1163: 'VALUE',
1164: null,null,null,null,null,
1165: fnd_date.date_to_chardate(x_end_date),

Line 1187: 'PO_LINES_INTERFACE',

1183: null,
1184: x_interface_header_id,
1185: x_interface_line_id,
1186: 'PO_PDOI_INVALID_SHIPMENT_TYPE',
1187: 'PO_LINES_INTERFACE',
1188: 'SHIPMENT_TYPE',
1189: 'TYPE',
1190: 'VALUE',
1191: null,null,null,null,

Line 1217: 'PO_LINES_INTERFACE',

1213: null,
1214: x_interface_header_id,
1215: x_interface_line_id,
1216: 'PO_PDOI_SHIPMENT_NUM_UNIQUE',
1217: 'PO_LINES_INTERFACE',
1218: 'SHIPMENT_NUM',
1219: 'VALUE',
1220: null,null,null,null,null,
1221: x_shipment_num,

Line 1236: 'PO_LINES_INTERFACE',

1232: null,
1233: x_interface_header_id,
1234: x_interface_line_id,
1235: 'PO_PDOI_LT_ZERO',
1236: 'PO_LINES_INTERFACE',
1237: 'SHIPMENT_NUM',
1238: 'COLUMN_NAME',
1239: 'VALUE',
1240: null,null,null,null,

Line 1261: 'PO_LINES_INTERFACE',

1257: null,
1258: x_interface_header_id,
1259: x_interface_line_id,
1260: 'PO_PDOI_LINE_LOC_ID_UNIQUE',
1261: 'PO_LINES_INTERFACE',
1262: 'LINE_LOCATION_ID',
1263: 'VALUE',
1264: null,null,null,null,null,
1265: x_line_location_id,

Line 1287: 'PO_LINES_INTERFACE',

1283: null,
1284: x_interface_header_id,
1285: x_interface_line_id,
1286: 'PO_PDOI_INVALID_EN_SH_LOC_CODE',
1287: 'PO_LINES_INTERFACE',
1288: 'ENFORCE_SHIP_TO_LOCATION_CODE',
1289: 'VALUE',
1290: null,null,null,null,null,
1291: x_enforce_ship_to_loc_code,

Line 1309: 'PO_LINES_INTERFACE',

1305: null,
1306: x_interface_header_id,
1307: x_interface_line_id,
1308: 'PO_PDOI_ALLOW_SUB_REC_FLAG',
1309: 'PO_LINES_INTERFACE',
1310: 'ALLOW_SUBSTITUE_RECEIPTS_FLAG',
1311: 'VALUE',
1312: null,null,null,null,null,
1313: x_allow_sub_receipts_flag,

Line 1330: 'PO_LINES_INTERFACE',

1326: null,
1327: x_interface_header_id,
1328: x_interface_line_id,
1329: 'PO_PDOI_DAYS_EARLY_REC_ALLOWED',
1330: 'PO_LINES_INTERFACE',
1331: 'DAYS_EARLY_RECEIPT_ALLOWED',
1332: 'VALUE',
1333: null,null,null,null,null,
1334: x_days_early_receipt_allowed,

Line 1354: 'PO_LINES_INTERFACE',

1350: null,
1351: x_interface_header_id,
1352: x_interface_line_id,
1353: 'PO_PDOI_INV_REC_DAYS_EX_CODE',
1354: 'PO_LINES_INTERFACE',
1355: 'RECEIPT_DAYS_EXCEPTION_CODE',
1356: 'VALUE',
1357: null,null,null,null,null,
1358: x_receipt_days_exception_code,

Line 1382: 'PO_LINES_INTERFACE',

1378: null,
1379: x_interface_header_id,
1380: x_interface_line_id,
1381: 'PO_PDOI_INV_CLOSE_TOLERANCE',
1382: 'PO_LINES_INTERFACE',
1383: 'INVOICE_CLOSE_TOLERANCE',
1384: --PBWC Message Change Impact:
1385: --Removing a token.
1386: null,null,null,null,null,null,

Line 1410: 'PO_LINES_INTERFACE',

1406: null,
1407: x_interface_header_id,
1408: x_interface_line_id,
1409: 'PO_PDOI_RCT_CLOSE_TOLERANCE',
1410: 'PO_LINES_INTERFACE',
1411: 'RECEIPT_CLOSE_TOLERANCE',
1412: 'VALUE',
1413: null,null,null,null,null,
1414: x_receive_close_tolerance,

Line 1435: 'PO_LINES_INTERFACE',

1431: null,
1432: x_interface_header_id,
1433: x_interface_line_id,
1434: 'PO_PDOI_INVALID_ROUTING_ID',
1435: 'PO_LINES_INTERFACE',
1436: 'RECEIVING_ROUTING_ID',
1437: 'VALUE',
1438: null,null,null,null,null,
1439: x_receiving_routing_id,

Line 1457: 'PO_LINES_INTERFACE',

1453: null,
1454: x_interface_header_id,
1455: x_interface_line_id,
1456: 'PO_PDOI_ACCRUE_ON_RCT',
1457: 'PO_LINES_INTERFACE',
1458: 'ACCRUE_ON_RECEIPT_FLAG',
1459: 'VALUE',
1460: null,null,null,null,null,
1461: x_accrue_on_receipt_flag,

Line 1479: 'PO_LINES_INTERFACE',

1475: null,
1476: x_interface_header_id,
1477: x_interface_line_id,
1478: 'PO_PDOI_INVALID_FIRM_FLAG',
1479: 'PO_LINES_INTERFACE',
1480: 'FIRM_FLAG',
1481: 'VALUE',
1482: null,null,null,null,null,
1483: x_firm_status_lookup_code,

Line 1499: FROM po_lines

1495:
1496: BEGIN
1497: SELECT unit_price
1498: INTO l_line_price
1499: FROM po_lines
1500: WHERE po_header_id = x_po_header_id
1501: AND po_line_id = x_po_line_id;
1502:
1503: IF (x_price_override <> NVL(l_line_price,-1)) THEN

Line 1511: x_table_name => 'PO_LINES_INTERFACE',

1507: x_batch_id => NULL,
1508: x_interface_header_id => x_interface_header_id,
1509: x_interface_line_id => x_interface_line_id,
1510: x_error_message_name => 'PO_PDOI_SHIP_PRICE_NE_LINE',
1511: x_table_name => 'PO_LINES_INTERFACE',
1512: x_column_name => 'UNIT_PRICE',
1513: x_tokenname1 => 'SHIP_PRICE',
1514: x_tokenname2 => 'LINE_PRICE',
1515: x_tokenname3 => NULL,