APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_INVOICES_PKG

Line 9: -- stored procedure call ap_invoices_pkg.invoice_pre_update()

5: -- PROCEDURE adjust_pay_schedule adjusts the payment schedule of
6: -- a paid or partially paid invoice
7: --
8: -- PRECONDITION: Called from the invoice block in PRE-UPDATE via
9: -- stored procedure call ap_invoices_pkg.invoice_pre_update()
10: -----------------------------------------------------------------------
11: PROCEDURE adjust_pay_schedule (X_invoice_id IN number,
12: X_invoice_amount IN number,
13: X_payment_status_flag IN OUT NOCOPY varchar2,

Line 142: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then

138: -- updates to the invoice (liability) amount in certain cases,
139: -- we want to ensure that these rules are enforced server-side
140: -- as well.
141:
142: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then
143: -- Cannot change the invoice_amount as it is encumbered
144: fnd_message.set_name('SQLAP','AP_INV_ALL_DISTS_ENCUMB');
145: app_exception.raise_exception;
146: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then

Line 146: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then

142: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then
143: -- Cannot change the invoice_amount as it is encumbered
144: fnd_message.set_name('SQLAP','AP_INV_ALL_DISTS_ENCUMB');
145: app_exception.raise_exception;
146: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then
147: -- Cannot change the invoice_amount as it is posted
148: fnd_message.set_name('SQLAP','AP_INV_ALL_DIST_POSTED');
149: app_exception.raise_exception;
150: elsif (ap_invoices_pkg.selected_for_payment_flag(

Line 150: elsif (ap_invoices_pkg.selected_for_payment_flag(

146: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then
147: -- Cannot change the invoice_amount as it is posted
148: fnd_message.set_name('SQLAP','AP_INV_ALL_DIST_POSTED');
149: app_exception.raise_exception;
150: elsif (ap_invoices_pkg.selected_for_payment_flag(
151: X_invoice_id) = 'Y') then
152: -- Cannot change the amount as it is selected for payment
153: fnd_message.set_name('SQLAP','AP_INV_SELECTED_INVOICE');
154: app_exception.raise_exception;

Line 480: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*

476: IS
477: l_wt_amt_to_subtract number :=0;
478: BEGIN
479: select nvl(ap_utilities_pkg.ap_round_currency(
480: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
481: ai.payment_cross_rate,X_currency_code),0)*
482: X_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
483: nvl(ai.pay_curr_invoice_amount, 1))
484: into l_wt_amt_to_subtract

Line 507: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*

503: BEGIN
504:
505: -- bug 3484292 Added the select stmt below.
506: select nvl(ap_utilities_pkg.ap_round_currency(
507: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
508: ai.payment_cross_rate,X_currency_code),0)*
509: aps.gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
510: nvl(ai.pay_curr_invoice_amount, 1)),
511: aps.gross_amount -- BUG 3741934