DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LOOKUP_CODES

Line 977: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES

973: RAISE;
974: END effective_dates;
975:
976: -------------------------------------------------------------------------
977: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
978: -------------------------------------------------------------------------
979: PROCEDURE qty_rcv_exception_code(
980: p_id_tbl IN po_tbl_number,
981: p_qty_rcv_exception_code_tbl IN po_tbl_varchar30,

Line 1025: FROM po_lookup_codes plc

1021: FROM DUAL
1022: WHERE p_qty_rcv_exception_code_tbl(i) IS NOT NULL
1023: AND NOT EXISTS(
1024: SELECT 1
1025: FROM po_lookup_codes plc
1026: WHERE p_qty_rcv_exception_code_tbl(i) = plc.lookup_code
1027: AND plc.lookup_type = 'RECEIVING CONTROL LEVEL'
1028: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1));
1029:

Line 1698: -- fob_lookup_code must be valid in PO_LOOKUP_CODES

1694: RAISE;
1695: END tax_name;
1696:
1697: -------------------------------------------------------------------------
1698: -- fob_lookup_code must be valid in PO_LOOKUP_CODES
1699: -------------------------------------------------------------------------
1700: PROCEDURE fob_lookup_code(p_id_tbl IN po_tbl_number,
1701: p_fob_lookup_code_tbl IN po_tbl_varchar30,
1702: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1745: FROM PO_LOOKUP_CODES

1741: PO_VAL_CONSTANTS.c_loc_fob_lookup_code
1742: FROM DUAL
1743: WHERE p_fob_lookup_code_tbl(i) IS NOT NULL
1744: AND NOT EXISTS(SELECT 1
1745: FROM PO_LOOKUP_CODES
1746: WHERE lookup_type = 'FOB' AND
1747: sysdate < nvl(inactive_date, sysdate + 1) AND
1748: lookup_code = p_fob_lookup_code_tbl(i));
1749:

Line 1769: -- freight_terms must be valid in PO_LOOKUP_CODES

1765:
1766: END fob_lookup_code;
1767:
1768: -------------------------------------------------------------------------
1769: -- freight_terms must be valid in PO_LOOKUP_CODES
1770: -------------------------------------------------------------------------
1771: PROCEDURE freight_terms(p_id_tbl IN po_tbl_number,
1772: p_freight_terms_tbl IN po_tbl_varchar30,
1773: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1816: FROM PO_LOOKUP_CODES

1812: PO_VAL_CONSTANTS.c_loc_freight_terms
1813: FROM DUAL
1814: WHERE p_freight_terms_tbl(i) IS NOT NULL
1815: AND NOT EXISTS(SELECT 1
1816: FROM PO_LOOKUP_CODES
1817: WHERE lookup_type = 'FREIGHT TERMS' AND
1818: sysdate < nvl(inactive_date, sysdate + 1) AND
1819: lookup_code = p_freight_terms_tbl(i));
1820: