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 475: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(

471: -- has been made.
472:
473: if (X_payment_status_flag <> 'N' AND nvl(l_recouped_amount,0) = 0) then
474:
475: AP_PAYMENT_SCHEDULES_PKG.adjust_pay_schedule(
476: X_invoice_id,
477: X_invoice_amount,
478: X_payment_status_flag,
479: X_invoice_type_lookup_code,

Line 656: FROM ap_payment_schedules

652: AND line_type_lookup_code = 'AWT';
653:
654: SELECT sum(nvl(amount_remaining,0)), sum(nvl(gross_amount,0))
655: INTO l_inv_amt_remaining, l_gross_amount
656: FROM ap_payment_schedules
657: WHERE invoice_id = X_invoice_id;
658:
659: --bug 5334577
660: Select count(*)

Line 662: from ap_payment_schedules_all

658:
659: --bug 5334577
660: Select count(*)
661: into X_Sched_Hold_count
662: from ap_payment_schedules_all
663: where invoice_id = X_invoice_id
664: and hold_flag = 'Y';
665:
666: debug_info := ' Total Awt Amount: '||l_awt_amount||', '||'Invoice Amount Remaining: '||

Line 674: UPDATE ap_payment_schedules

670: --Prorate the manual AWT against the invoice amount remaining
671: --===================================================================
672: if ((l_inv_amt_remaining <> 0) and (l_awt_amount is not null)) then
673:
674: UPDATE ap_payment_schedules
675: SET amount_remaining = (amount_remaining +
676: ap_utilities_pkg.ap_round_currency(
677: (amount_remaining * (l_awt_amount/l_inv_amt_remaining)
678: * l_payment_cross_rate), l_payment_currency_code ) )

Line 683: UPDATE ap_payment_schedules

679: WHERE invoice_id = X_invoice_id;
680: elsif ((l_inv_amt_remaining = 0) and (l_awt_amount is not null)
681: and (l_gross_amount <> 0)) then /* Bug 5382525 */
682:
683: UPDATE ap_payment_schedules
684: SET amount_remaining = (amount_remaining +
685: ap_utilities_pkg.ap_round_currency(
686: (gross_amount * (l_awt_amount/l_gross_amount)
687: * l_payment_cross_rate), l_payment_currency_code) ),

Line 711: UPDATE ap_payment_schedules

707: l_po_number ;
708:
709: if( l_po_number <> 'UNMATCHED' ) then
710: if( nvl(l_recouped_amount,0) <> 0) THEN
711: UPDATE ap_payment_schedules
712: SET amount_remaining = (amount_remaining +
713: ap_utilities_pkg.ap_round_currency(l_recouped_amount,
714: l_payment_currency_code) ),
715: payment_status_flag = DECODE(amount_remaining +