APPS.AP_PREPAY_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 4291: FROM ap_payment_schedules

4287: SELECT payment_num,
4288: DECODE(p_appl_type,
4289: 'UNAPPLICATION', gross_amount - amount_remaining,
4290: amount_remaining)
4291: FROM ap_payment_schedules
4292: WHERE invoice_id = p_invoice_id
4293: AND (payment_status_flag||'' = 'P'
4294: OR payment_status_flag||'' = DECODE(p_appl_type, 'UNAPPLICATION', 'Y', 'N'))
4295: ORDER BY DECODE(p_appl_type,

Line 4374: UPDATE ap_payment_schedules

4370: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4371: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4372: END IF;
4373:
4374: UPDATE ap_payment_schedules
4375: SET amount_remaining = (amount_remaining -
4376: ap_utilities_pkg.ap_round_currency(
4377: l_apply_amount_remaining,
4378: p_payment_currency_code)),

Line 4409: UPDATE ap_payment_schedules

4405: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4406: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4407: END IF;
4408:
4409: UPDATE ap_payment_schedules
4410: SET amount_remaining = DECODE(p_appl_type,
4411: 'APPLICATION',0,
4412: gross_amount),
4413: payment_status_flag = DECODE(p_appl_type,

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

4436: CLOSE SCHEDULES;
4437:
4438: --------------------------------------------------------------------------
4439: -- After update the payment schedules, the payment status flag should
4440: -- be updated according to the payment_status_flag of ap_payment_schedules
4441: -- to reflect the prepayment application
4442: --------------------------------------------------------------------------
4443: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;
4444: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN