4891: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4892: nvl(amount_paid, 0) +
4893: (l_withhold_amount *
4894: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4895: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
4896: WHERE invoice_id = l_invoice_id;
4897:
4898: --------------------------------------------------------------
4899: -- Updates the payment amount
6147: UPDATE ap_invoices
6148: SET amount_paid = nvl(amount_paid, 0) -
6149: (l_withhold_amount *
6150: nvl(l_payment_cross_rate, 1)),
6151: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
6152: WHERE invoice_id = l_invoice_id;
6153:
6154: --------------------------------------------------------------
6155: -- Updates the payment amount