APPS.AP_PAY_INVOICE_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 674: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id ),

670: UPDATE ap_invoices
671: SET amount_paid = NVL(amount_paid, 0) + NVL(P_amount, 0),
672: discount_amount_taken = NVL(discount_amount_taken, 0) +
673: NVL(P_discount_taken, 0),
674: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id ),
675: last_update_date = P_last_update_date,
676: last_updated_by = P_last_updated_by
677: WHERE invoice_id = P_invoice_id;
678:

Line 712: , AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id )

708: , last_updated_by)
709: = (SELECT AI.amount_paid - SUM(AIP.amount)
710: , NVL(AI.discount_amount_taken,0) -
711: SUM(NVL(AIP.discount_taken,0))
712: , AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id )
713: , P_last_update_date
714: , P_last_updated_by
715: FROM ap_invoice_payments AIP
716: WHERE AIP.invoice_id = P_invoice_id

Line 1353: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id ),

1349: UPDATE ap_invoices
1350: SET amount_paid = nvl(amount_paid,0) - P_amount ,
1351: discount_amount_taken =
1352: nvl(discount_amount_taken,0) - nvl(P_discount,0) ,
1353: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id ),
1354: last_update_date = P_last_update_date,
1355: last_updated_by = P_last_updated_by
1356: WHERE invoice_id = P_invoice_id;
1357: