DBA Data[Home] [Help]

APPS.AP_HOLDS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 947: debug_info := 'Update AP_INVOICE_DISTRIBUTIONS';

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

Line 949: UPDATE ap_invoice_distributions D

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')