APPS.AP_PREPAY_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 4458: FROM ap_payment_schedules aps,

4454: DECODE(p_appl_type, 'UNAPPLICATION', ((aps.gross_amount / ai.invoice_amount ) *
4455: (ai.invoice_amount - nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)) - aps.amount_remaining),/*Bug10012482*/
4456: aps.amount_remaining),
4457: ai.invoice_amount /*Bug10012482*/
4458: FROM ap_payment_schedules aps,
4459: ap_invoices_all ai
4460: WHERE ai.invoice_id = aps.invoice_id
4461: AND ai.invoice_id = p_invoice_id
4462: AND (aps.payment_status_flag||'' = 'P'

Line 4526: UPDATE ap_payment_schedules

4522: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4523: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4524: END IF;
4525:
4526: UPDATE ap_payment_schedules
4527: SET amount_remaining = amount_remaining -
4528: ap_utilities_pkg.ap_round_currency(
4529: l_apply_amount_remaining,
4530: p_payment_currency_code),

Line 4577: UPDATE ap_payment_schedules

4573: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4574: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4575: END IF;
4576:
4577: UPDATE ap_payment_schedules
4578: SET amount_remaining = (amount_remaining -
4579: ap_utilities_pkg.ap_round_currency(
4580: l_apply_amount_remaining,
4581: p_payment_currency_code)),

Line 4614: UPDATE ap_payment_schedules

4610: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4611: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4612: END IF;
4613:
4614: UPDATE ap_payment_schedules
4615: SET amount_remaining = DECODE(p_appl_type,
4616: 'APPLICATION',0,
4617: /*Bug10012482:Taking AWT amounts into account*/
4618: ((gross_amount / l_total_gross_amount )

Line 4648: -- be updated according to the payment_status_flag of ap_payment_schedules

4644: CLOSE SCHEDULES;
4645:
4646: --------------------------------------------------------------------------
4647: -- After update the payment schedules, the payment status flag should
4648: -- be updated according to the payment_status_flag of ap_payment_schedules
4649: -- to reflect the prepayment application
4650: --------------------------------------------------------------------------
4651: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;
4652: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN