943:
944: ------------------------------------------------------------------------
945: -- Update final_match_flag to 'N' if try to release 'CANT CLOSE PO' hold
946: ------------------------------------------------------------------------
947: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';
948:
949: UPDATE ap_invoice_distributions D
950: SET final_match_flag = 'N'
951: WHERE D.invoice_id = X_invoice_id
945: -- Update final_match_flag to 'N' if try to release 'CANT CLOSE PO' hold
946: ------------------------------------------------------------------------
947: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';
948:
949: UPDATE ap_invoice_distributions D
950: SET final_match_flag = 'N'
951: WHERE D.invoice_id = X_invoice_id
952: AND ((X_hold_lookup_code = 'CANT CLOSE PO') OR
953: ((X_hold_lookup_code = 'ALL')