APPS.PO_VAL_HEADERS2 dependencies on PO_LOOKUP_CODES

Line 1153: -- validate fob_lookup_code against PO_LOOKUP_CODES

1149: RAISE;
1150: END ship_via_lookup_code;
1151:
1152: -------------------------------------------------------------------------
1153: -- validate fob_lookup_code against PO_LOOKUP_CODES
1154: -------------------------------------------------------------------------
1155: PROCEDURE fob_lookup_code(
1156: p_id_tbl IN po_tbl_number,
1157: p_fob_lookup_code_tbl IN po_tbl_varchar30,

Line 1200: FROM po_lookup_codes plc

1196: FROM DUAL
1197: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1198: AND NOT EXISTS(
1199: SELECT 1
1200: FROM po_lookup_codes plc
1201: WHERE p_fob_lookup_code_tbl(i) = plc.lookup_code
1202: AND plc.lookup_type = 'FOB'
1203: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1204:

Line 1224: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES

1220: RAISE;
1221: END fob_lookup_code;
1222:
1223: -------------------------------------------------------------------------
1224: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES
1225: -------------------------------------------------------------------------
1226: PROCEDURE freight_terms_lookup_code(
1227: p_id_tbl IN po_tbl_number,
1228: p_freight_terms_lookup_tbl IN po_tbl_varchar30,

Line 1271: FROM po_lookup_codes plc

1267: FROM DUAL
1268: WHERE p_freight_terms_lookup_tbl(i) IS NOT NULL
1269: AND NOT EXISTS(
1270: SELECT 1
1271: FROM po_lookup_codes plc
1272: WHERE p_freight_terms_lookup_tbl(i) = plc.lookup_code
1273: AND plc.lookup_type = 'FREIGHT TERMS'
1274: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1275:

Line 1295: -- validate shipping_control against PO_LOOKUP_CODES

1291: RAISE;
1292: END freight_terms_lookup_code;
1293:
1294: -------------------------------------------------------------------------
1295: -- validate shipping_control against PO_LOOKUP_CODES
1296: -------------------------------------------------------------------------
1297: PROCEDURE shipping_control(
1298: p_id_tbl IN po_tbl_number,
1299: p_shipping_control_tbl IN po_tbl_varchar30,

Line 1342: FROM po_lookup_codes plc

1338: FROM DUAL
1339: WHERE p_shipping_control_tbl(i) IS NOT NULL
1340: AND NOT EXISTS(
1341: SELECT 1
1342: FROM po_lookup_codes plc
1343: WHERE p_shipping_control_tbl(i) = plc.lookup_code
1344: AND plc.lookup_type = 'SHIPPING CONTROL'
1345: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1346: