APPS.PO_VAL_HEADERS2 dependencies on PO_LOOKUP_CODES

Line 1143: -- validate fob_lookup_code against PO_LOOKUP_CODES

1139: RAISE;
1140: END ship_via_lookup_code;
1141:
1142: -------------------------------------------------------------------------
1143: -- validate fob_lookup_code against PO_LOOKUP_CODES
1144: -------------------------------------------------------------------------
1145: PROCEDURE fob_lookup_code(
1146: p_id_tbl IN po_tbl_number,
1147: p_fob_lookup_code_tbl IN po_tbl_varchar30,

Line 1190: FROM po_lookup_codes plc

1186: FROM DUAL
1187: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1188: AND NOT EXISTS(
1189: SELECT 1
1190: FROM po_lookup_codes plc
1191: WHERE p_fob_lookup_code_tbl(i) = plc.lookup_code
1192: AND plc.lookup_type = 'FOB'
1193: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1194:

Line 1214: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES

1210: RAISE;
1211: END fob_lookup_code;
1212:
1213: -------------------------------------------------------------------------
1214: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES
1215: -------------------------------------------------------------------------
1216: PROCEDURE freight_terms_lookup_code(
1217: p_id_tbl IN po_tbl_number,
1218: p_freight_terms_lookup_tbl IN po_tbl_varchar30,

Line 1261: FROM po_lookup_codes plc

1257: FROM DUAL
1258: WHERE p_freight_terms_lookup_tbl(i) IS NOT NULL
1259: AND NOT EXISTS(
1260: SELECT 1
1261: FROM po_lookup_codes plc
1262: WHERE p_freight_terms_lookup_tbl(i) = plc.lookup_code
1263: AND plc.lookup_type = 'FREIGHT TERMS'
1264: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1265:

Line 1285: -- validate shipping_control against PO_LOOKUP_CODES

1281: RAISE;
1282: END freight_terms_lookup_code;
1283:
1284: -------------------------------------------------------------------------
1285: -- validate shipping_control against PO_LOOKUP_CODES
1286: -------------------------------------------------------------------------
1287: PROCEDURE shipping_control(
1288: p_id_tbl IN po_tbl_number,
1289: p_shipping_control_tbl IN po_tbl_varchar30,

Line 1332: FROM po_lookup_codes plc

1328: FROM DUAL
1329: WHERE p_shipping_control_tbl(i) IS NOT NULL
1330: AND NOT EXISTS(
1331: SELECT 1
1332: FROM po_lookup_codes plc
1333: WHERE p_shipping_control_tbl(i) = plc.lookup_code
1334: AND plc.lookup_type = 'SHIPPING CONTROL'
1335: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1336: