DBA Data[Home] [Help]

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 4658: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

4654: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4655: nvl(amount_paid, 0) +
4656: (l_withhold_amount *
4657: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4658: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
4659: WHERE invoice_id = l_invoice_id;
4660:
4661: --------------------------------------------------------------
4662: -- Updates the payment amount

Line 5820: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

5816: UPDATE ap_invoices
5817: SET amount_paid = nvl(amount_paid, 0) -
5818: (l_withhold_amount *
5819: nvl(l_payment_cross_rate, 1)),
5820: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
5821: WHERE invoice_id = l_invoice_id;
5822:
5823: --------------------------------------------------------------
5824: -- Updates the payment amount