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 153: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then

149: l_recouped_amount := AP_MATCHING_UTILS_PKG.Get_Inv_Line_Recouped_Amount
150: (P_Invoice_Id => X_invoice_id,
151: P_Invoice_Line_Number => Null);
152:
153: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then
154: -- Cannot change the invoice_amount as it is encumbered
155: fnd_message.set_name('SQLAP','AP_INV_ALL_DISTS_ENCUMB');
156: app_exception.raise_exception;
157: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then

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

153: if (ap_invoices_pkg.get_encumbered_flag(X_invoice_id) = 'Y') then
154: -- Cannot change the invoice_amount as it is encumbered
155: fnd_message.set_name('SQLAP','AP_INV_ALL_DISTS_ENCUMB');
156: app_exception.raise_exception;
157: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then
158: -- Cannot change the invoice_amount as it is posted
159: fnd_message.set_name('SQLAP','AP_INV_ALL_DIST_POSTED');
160: app_exception.raise_exception;
161: elsif (ap_invoices_pkg.selected_for_payment_flag(

Line 161: elsif (ap_invoices_pkg.selected_for_payment_flag(

157: elsif (ap_invoices_pkg.get_posting_status(X_invoice_id) = 'Y') then
158: -- Cannot change the invoice_amount as it is posted
159: fnd_message.set_name('SQLAP','AP_INV_ALL_DIST_POSTED');
160: app_exception.raise_exception;
161: elsif (ap_invoices_pkg.selected_for_payment_flag(
162: X_invoice_id) = 'Y') then
163: -- Cannot change the amount as it is selected for payment
164: fnd_message.set_name('SQLAP','AP_INV_SELECTED_INVOICE');
165: app_exception.raise_exception;

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

489: IS
490: l_wt_amt_to_subtract number :=0;
491: BEGIN
492: select nvl(ap_utilities_pkg.ap_round_currency(
493: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
494: ai.payment_cross_rate,X_currency_code),0)*
495: X_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
496: nvl(ai.pay_curr_invoice_amount, 1))
497: into l_wt_amt_to_subtract

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

516: BEGIN
517:
518: -- bug 3484292 Added the select stmt below.
519: select nvl(ap_utilities_pkg.ap_round_currency(
520: ap_invoices_pkg.get_amount_withheld(ai.invoice_id)*
521: ai.payment_cross_rate,X_currency_code),0)*
522: aps.gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
523: nvl(ai.pay_curr_invoice_amount, 1)),
524: aps.gross_amount -- BUG 3741934