2062:
2063: debug_info := 'Select check_date for thIS checkrun';
2064: SELECT AISC.check_date
2065: INTO l_awt_date
2066: FROM ap_inv_SELECTion_criteria_all AISC
2067: WHERE AISC.checkrun_name = P_Checkrun_Name
2068: and aisc.checkrun_id = p_checkrun_id;
2069:
2070:
2085: -- pass the rejection_level_code as 'REQUEST' to IBY.
2086: -- We will not update the rejection levels directly so that we can retrieve
2087: -- the initial values for these if the user removes awt invoices during
2088: -- the review stage from the selected invoices.
2089: update ap_inv_selection_criteria_all
2090: set /*document_rejection_level_code = 'REQUEST',
2091: payment_rejection_level_code = 'REQUEST'*/
2092: inv_awt_exists_flag = 'Y'
2093: where checkrun_id = p_checkrun_id;
2265: -- pass the rejection_level_code as 'REQUEST' to IBY.
2266: -- We will not update the rejection levels directly so that we can retrieve
2267: -- the initial values for these if the user removes awt invoices during
2268: -- the review stage from the selected invoices.
2269: update ap_inv_selection_criteria_all
2270: set /*document_rejection_level_code = 'REQUEST',
2271: payment_rejection_level_code = 'REQUEST'*/
2272: inv_awt_exists_flag = 'Y'
2273: where checkrun_id = p_checkrun_id;