DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LOOKUP_CODES

Line 1341: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES

1337: RAISE;
1338: END effective_dates;
1339:
1340: -------------------------------------------------------------------------
1341: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
1342: -------------------------------------------------------------------------
1343: PROCEDURE qty_rcv_exception_code(
1344: p_id_tbl IN po_tbl_number,
1345: p_qty_rcv_exception_code_tbl IN po_tbl_varchar30,

Line 1389: FROM po_lookup_codes plc

1385: FROM DUAL
1386: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1387: AND NOT EXISTS(
1388: SELECT 1
1389: FROM po_lookup_codes plc
1390: WHERE p_qty_rcv_exception_code_tbl(i) = plc.lookup_code
1391: AND plc.lookup_type = 'RECEIVING CONTROL LEVEL'
1392: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1393:

Line 2121: -- fob_lookup_code must be valid in PO_LOOKUP_CODES

2117: RAISE;
2118: END tax_name;
2119:
2120: -------------------------------------------------------------------------
2121: -- fob_lookup_code must be valid in PO_LOOKUP_CODES
2122: -------------------------------------------------------------------------
2123: PROCEDURE fob_lookup_code(p_id_tbl IN po_tbl_number,
2124: p_fob_lookup_code_tbl IN po_tbl_varchar30,
2125: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2168: FROM PO_LOOKUP_CODES

2164: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
2165: FROM DUAL
2166: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
2167: AND NOT EXISTS(SELECT 1
2168: FROM PO_LOOKUP_CODES
2169: WHERE lookup_type = 'FOB' AND
2170: sysdate < nvl(inactive_date, sysdate + 1) AND
2171: lookup_code = p_fob_lookup_code_tbl(i));
2172:

Line 2192: -- freight_terms must be valid in PO_LOOKUP_CODES

2188:
2189: END fob_lookup_code;
2190:
2191: -------------------------------------------------------------------------
2192: -- freight_terms must be valid in PO_LOOKUP_CODES
2193: -------------------------------------------------------------------------
2194: PROCEDURE freight_terms(p_id_tbl IN po_tbl_number,
2195: p_freight_terms_tbl IN po_tbl_varchar30,
2196: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2239: FROM PO_LOOKUP_CODES

2235: PO_VAL_CONSTANTS.c_loc_freight_terms
2236: FROM DUAL
2237: WHERE p_freight_terms_tbl(i) IS NOT NULL
2238: AND NOT EXISTS(SELECT 1
2239: FROM PO_LOOKUP_CODES
2240: WHERE lookup_type = 'FREIGHT TERMS' AND
2241: sysdate < nvl(inactive_date, sysdate + 1) AND
2242: lookup_code = p_freight_terms_tbl(i));
2243: