[Home] [Help]
65: c_program_PDOI CONSTANT VARCHAR2(10) := 'PDOI';
66:
67: -------------------------------------------------------------------------
68: -- The lookup code specified in over_tolerance_error_flag with the lookup type
69: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
70: -- This method is called only for Standard PO and quotation documents
71: -------------------------------------------------------------------------
72: PROCEDURE over_tolerance_err_flag(
73: p_id_tbl IN po_tbl_number,
112: FROM DUAL
113: WHERE p_over_tolerance_err_flag_tbl(i) IS NOT NULL AND
114: NOT EXISTS(
115: SELECT 1
116: FROM po_lookup_codes plc
117: WHERE plc.lookup_type = 'RECEIVING CONTROL LEVEL'
118: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1)
119: AND plc.lookup_code = p_over_tolerance_err_flag_tbl(i));
120:
2659:
2660: END style_related_info;
2661:
2662: -------------------------------------------------------------------------
2663: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
2664: -------------------------------------------------------------------------
2665: PROCEDURE price_type_lookup_code(
2666: p_id_tbl IN po_tbl_number,
2667: p_price_type_lookup_code_tbl IN po_tbl_varchar30,
2706: FROM DUAL
2707: WHERE p_price_type_lookup_code_tbl(i) IS NOT NULL
2708: AND NOT EXISTS(
2709: SELECT 'Y'
2710: FROM po_lookup_codes plc
2711: WHERE plc.lookup_type = 'PRICE TYPE'
2712: AND SYSDATE < NVL(plc.inactive_date, SYSDATE + 1)
2713: AND plc.lookup_code = p_price_type_lookup_code_tbl(i));
2714:
3069: FROM DUAL
3070: WHERE p_price_break_lookup_code_tbl(i) IS NOT NULL
3071: AND p_price_break_lookup_code_tbl(i) NOT IN
3072: ( SELECT lookup_code
3073: FROM po_lookup_codes PLC
3074: WHERE PLC.lookup_type = 'PRICE BREAK TYPE');
3075:
3076: IF (SQL%ROWCOUNT > 0) THEN
3077: x_result_type := po_validations.c_result_type_failure;