[Home] [Help]
60: c_program_PDOI CONSTANT VARCHAR2(10) := 'PDOI';
61:
62: -------------------------------------------------------------------------
63: -- The lookup code specified in over_tolerance_error_flag with the lookup type
64: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
65: -- This method is called only for Standard PO and quotation documents
66: -------------------------------------------------------------------------
67: PROCEDURE over_tolerance_err_flag(
68: p_id_tbl IN po_tbl_number,
107: FROM DUAL
108: WHERE p_over_tolerance_err_flag_tbl(i) IS NOT NULL AND
109: NOT EXISTS(
110: SELECT 1
111: FROM po_lookup_codes plc
112: WHERE plc.lookup_type = 'RECEIVING CONTROL LEVEL'
113: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1)
114: AND plc.lookup_code = p_over_tolerance_err_flag_tbl(i));
115:
2598:
2599: END style_related_info;
2600:
2601: -------------------------------------------------------------------------
2602: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
2603: -------------------------------------------------------------------------
2604: PROCEDURE price_type_lookup_code(
2605: p_id_tbl IN po_tbl_number,
2606: p_price_type_lookup_code_tbl IN po_tbl_varchar30,
2645: FROM DUAL
2646: WHERE p_price_type_lookup_code_tbl(i) IS NOT NULL
2647: AND NOT EXISTS(
2648: SELECT 'Y'
2649: FROM po_lookup_codes plc
2650: WHERE plc.lookup_type = 'PRICE TYPE'
2651: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1)
2652: AND plc.lookup_code = p_price_type_lookup_code_tbl(i));
2653:
3008: FROM DUAL
3009: WHERE p_price_break_lookup_code_tbl(i) IS NOT NULL
3010: AND p_price_break_lookup_code_tbl(i) NOT IN
3011: ( SELECT lookup_code
3012: FROM po_lookup_codes PLC
3013: WHERE PLC.lookup_type = 'PRICE BREAK TYPE');
3014:
3015: IF (SQL%ROWCOUNT > 0) THEN
3016: x_result_type := po_validations.c_result_type_failure;