APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 154: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES,

150:
151:
152: -----------------------------------------------------------------------
153: -- Procedure insert_children
154: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES,
155: -- and AP_INVOICE_DISTRIBUTIONS
156: -- PRECONDITION: Called from PRE-UPDATE, POST-INSERT of INV_SUM_FOLDER
157: -----------------------------------------------------------------------
158: procedure insert_children (

Line 304: from ap_payment_schedules_all

300:
301: --bug 5334577
302: Select count(*)
303: into X_Sched_Hold_count
304: from ap_payment_schedules_all
305: where invoice_id = X_invoice_id
306: and hold_flag = 'Y';
307:
308: select count(*)

Line 454: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(

450: -- If the invoice is paid or partially paid then we made need
451: -- to alter the payment schedules if a liability adjustment
452: -- has been made.
453: if (X_payment_status_flag <> 'N') then
454: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(
455: X_invoice_id,
456: X_invoice_amount,
457: X_payment_status_flag,
458: X_invoice_type_lookup_code,

Line 628: FROM ap_payment_schedules

624: AND line_type_lookup_code = 'AWT';
625:
626: SELECT sum(nvl(amount_remaining,0)), sum(nvl(gross_amount,0))
627: INTO l_inv_amt_remaining, l_gross_amount
628: FROM ap_payment_schedules
629: WHERE invoice_id = X_invoice_id;
630:
631: --bug 5334577
632: Select count(*)

Line 634: from ap_payment_schedules_all

630:
631: --bug 5334577
632: Select count(*)
633: into X_Sched_Hold_count
634: from ap_payment_schedules_all
635: where invoice_id = X_invoice_id
636: and hold_flag = 'Y';
637:
638: debug_info := ' Total Awt Amount: '||l_awt_amount||', '||'Invoice Amount Remaining: '||

Line 646: UPDATE ap_payment_schedules

642: --Prorate the manual AWT against the invoice amount remaining
643: --===================================================================
644: if ((l_inv_amt_remaining <> 0) and (l_awt_amount is not null)) then
645:
646: UPDATE ap_payment_schedules
647: SET amount_remaining = (amount_remaining +
648: ap_utilities_pkg.ap_round_currency(
649: (amount_remaining * (l_awt_amount/l_inv_amt_remaining)
650: * l_payment_cross_rate), l_payment_currency_code ) )

Line 655: UPDATE ap_payment_schedules

651: WHERE invoice_id = X_invoice_id;
652: elsif ((l_inv_amt_remaining = 0) and (l_awt_amount is not null)
653: and (l_gross_amount <> 0)) then /* Bug 5382525 */
654:
655: UPDATE ap_payment_schedules
656: SET amount_remaining = (amount_remaining +
657: ap_utilities_pkg.ap_round_currency(
658: (gross_amount * (l_awt_amount/l_gross_amount)
659: * l_payment_cross_rate), l_payment_currency_code) ),