DBA Data[Home] [Help]

APPS.AP_HOLDS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 865: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';

861:
862: ------------------------------------------------------------------------
863: -- Update final_match_flag to 'N' if try to release 'CANT CLOSE PO' hold
864: ------------------------------------------------------------------------
865: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';
866:
867: UPDATE ap_invoice_distributions D
868: SET final_match_flag = 'N'
869: WHERE D.invoice_id = X_invoice_id

Line 867: UPDATE ap_invoice_distributions D

863: -- Update final_match_flag to 'N' if try to release 'CANT CLOSE PO' hold
864: ------------------------------------------------------------------------
865: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';
866:
867: UPDATE ap_invoice_distributions D
868: SET final_match_flag = 'N'
869: WHERE D.invoice_id = X_invoice_id
870: AND ((X_hold_lookup_code = 'CANT CLOSE PO') OR
871: ((X_hold_lookup_code = 'ALL')