APPS.ARP_PROCESS_RCTS dependencies on AR_PAYMENT_SCHEDULES

Line 284: | ar_payment_schedules |

280: | 28-Dec-98 DJANCIS added call to set posted flag to deterime if |
281: | receipt was posted before deleting it |
282: | 08-Nov-01 DJANCIS Modified for mrc trigger elimination project |
283: | added call to ar_mrc_engine for deletes to |
284: | ar_payment_schedules |
285: +===========================================================================*/
286:
287: PROCEDURE delete_cash_receipt(
288: p_cash_receipt_id IN NUMBER,

Line 332: FROM ar_payment_schedules

328: cash_receipt_id,
329: customer_id,
330: customer_site_use_id,
331: trx_date
332: FROM ar_payment_schedules
333: WHERE cash_receipt_id = p_cash_receipt_id;
334:
335: CURSOR cReceiptDtls IS
336: SELECT receipt_number,

Line 516: DELETE AR_PAYMENT_SCHEDULES

512: CLOSE get_existing_ps;
513:
514: -- delete AR_PAYMENT_SCHEDULE record created for this receipt:
515:
516: DELETE AR_PAYMENT_SCHEDULES
517: WHERE cash_receipt_id = p_cash_receipt_id;
518: --Commented for bug 12989298
519: --RETURNING payment_schedule_id
520: --BULK COLLECT INTO l_ar_ps_key_value_list;

Line 529: p_table_name => 'AR_PAYMENT_SCHEDULES',

525: +---------------------------------*/
526:
527: ar_mrc_engine.maintain_mrc_data(
528: p_event_mode => 'DELETE',
529: p_table_name => 'AR_PAYMENT_SCHEDULES',
530: p_mode => 'BATCH',
531: p_key_value_list => l_ar_ps_key_value_list);
532: --
533:

Line 930: ar_payment_schedules ps

926: WHERE cr.cash_receipt_id = p_cr_id
927: AND exists
928: (select 1
929: from ar_receivable_applications ra,
930: ar_payment_schedules ps
931: where ra.cash_receipt_id = cr.cash_receipt_id
932: and ra.applied_payment_schedule_id = ps.payment_schedule_id
933: and ps.invoice_currency_code <> cr.currency_code
934: and ra.reversal_gl_date is NULL

Line 952: * in AR_PAYMENT_SCHEDULES table. Also check to see if the CB has

948:
949: /* --------------------------------------------------------------------
950: * Check if a 'CB' was created against this PMT to be reversed.
951: * Check if there are any PMT, ADJ, or CM or CB against this 'CB' records
952: * in AR_PAYMENT_SCHEDULES table. Also check to see if the CB has
953: * already been posted. If any of these 2 conditions is TRUE, then
954: * PMT can only be reversed using DM Reversal.
955: *
956: * Make sure that the adj which is automatically created against the CB

Line 964: FROM ar_payment_schedules ps,

960:
961:
962: SELECT COUNT(payment_schedule_id)
963: INTO l_dummy
964: FROM ar_payment_schedules ps,
965: ra_cust_trx_line_gl_dist rctlg
966: WHERE ps.associated_cash_receipt_id = p_cr_id
967: AND ps.class = 'CB'
968: AND ps.customer_trx_id = rctlg.customer_trx_id