APPS.ARP_PROCESS_MISC_RECEIPTS2 dependencies on AR_CASH_RECEIPT_HISTORY

Line 114: l_crh_rec ar_cash_receipt_history%ROWTYPE;

110: p_posting_control_id IN NUMBER, /* Bug fix 2742388 */
111: p_rec_version_number IN NUMBER /* Bug fix 3032059 */
112: ) IS
113: l_cr_rec ar_cash_receipts%ROWTYPE;
114: l_crh_rec ar_cash_receipt_history%ROWTYPE;
115: l_ps_rec ar_payment_schedules%ROWTYPE;
116:
117: BEGIN
118:

Line 346: -- AR_CASH_RECEIPT_HISTORY record.

342:
343: arp_cash_receipts_pkg.delete_p(p_cash_receipt_id);
344:
345: -- delete AR_DISTRIBUTIONS records created for each
346: -- AR_CASH_RECEIPT_HISTORY record.
347:
348: -- only delete when there is a AR_MIS_CASH_DISTRIBUTION
349: -- and AR_DISTRIBUTION record.
350: -- ie. when receipt amount is 0, no records for MCD

Line 366: FROM ar_cash_receipt_history

362: DELETE AR_DISTRIBUTIONS
363: WHERE source_table = 'CRH'
364: AND source_id IN (
365: SELECT cash_receipt_history_id
366: FROM ar_cash_receipt_history
367: WHERE cash_receipt_id = p_cash_receipt_id)
368: RETURNING line_id
369: BULK COLLECT INTO l_ar_dist_key_value_list;
370:

Line 413: -- delete all AR_CASH_RECEIPT_HISTORY records created for this

409:
410:
411: END IF;
412:
413: -- delete all AR_CASH_RECEIPT_HISTORY records created for this
414: -- receipt:
415:
416: -- Bug 2021718: call the entity handler for ar_cash_receipt_history rather
417: -- then doing the delete in this package.

Line 416: -- Bug 2021718: call the entity handler for ar_cash_receipt_history rather

412:
413: -- delete all AR_CASH_RECEIPT_HISTORY records created for this
414: -- receipt:
415:
416: -- Bug 2021718: call the entity handler for ar_cash_receipt_history rather
417: -- then doing the delete in this package.
418: /*6879698*/
419: ARP_XLA_EVENTS.delete_event
420: ( p_document_id => p_cash_receipt_id,

Line 424: -- DELETE AR_CASH_RECEIPT_HISTORY

420: ( p_document_id => p_cash_receipt_id,
421: p_doc_table => 'CRH');
422:
423: arp_cr_history_pkg.delete_p_cr(p_cash_receipt_id);
424: -- DELETE AR_CASH_RECEIPT_HISTORY
425: -- WHERE cash_receipt_id = p_cash_receipt_id;
426: -- update batch status
427:
428: IF (p_batch_id IS NOT NULL) THEN