APPS.AR_AUTOREC_API dependencies on AR_CASH_RECEIPT_HISTORY

Line 86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

82: ) IS
83:
84:
85: l_request_id ar_cash_receipts.request_id%TYPE;
86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 851: update ar_cash_receipt_history SET

847: rec_reset( p_apply_fail => l_apply_fail,
848: p_pay_process_fail => 'Y' );
849: END IF;
850:
851: update ar_cash_receipt_history SET
852: batch_id = o_batch_id,
853: created_by = l_created_by,
854: last_update_date = sysdate,
855: last_updated_by = l_created_by,

Line 995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

991: *=========================================================================*/
992:
993:
994: PROCEDURE insert_batch(
995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

Line 4388: ar_cash_receipt_history crh,

4384: WHERE customer_trx_id in (
4385: SELECT r.customer_trx_id
4386: FROM ar_cash_receipts cr,
4387: ar_receipts_gt r,
4388: ar_cash_receipt_history crh,
4389: iby_trxn_extensions_v trxn_ext
4390: WHERE cr.request_id = l_request_id
4391: AND r.cash_receipt_id = cr.cash_receipt_id
4392: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 4438: ar_cash_receipt_history crh,

4434: l_program_application_id,
4435: l_program_id,
4436: sysdate
4437: FROM ar_cash_receipts cr,
4438: ar_cash_receipt_history crh,
4439: iby_trxn_extensions_v trxn_ext
4440: WHERE cr.request_id = l_request_id
4441: AND crh.cash_receipt_id = cr.cash_receipt_id
4442: AND crh.status = 'CONFIRMED'

Line 4497: ar_cash_receipt_history crh,

4493: WHERE customer_trx_id in (
4494: SELECT r.customer_trx_id
4495: FROM ar_cash_receipts cr,
4496: ar_receipts_gt r,
4497: ar_cash_receipt_history crh,
4498: iby_trxn_extensions_v trxn_ext
4499: WHERE cr.request_id = l_request_id
4500: AND r.cash_receipt_id = cr.cash_receipt_id
4501: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 4521: ar_cash_receipt_history crh,

4517: where cash_receipt_id in (
4518: SELECT
4519: cr.cash_receipt_id
4520: FROM ar_cash_receipts cr,
4521: ar_cash_receipt_history crh,
4522: iby_trxn_extensions_v trxn_ext
4523: WHERE cr.request_id = l_request_id
4524: AND crh.cash_receipt_id = cr.cash_receipt_id
4525: AND crh.status = 'CONFIRMED'

Line 4775: from ar_cash_receipt_history

4771:
4772: delete from ar_distributions
4773: where source_table = 'CRH'
4774: and source_id in ( select cash_receipt_history_id
4775: from ar_cash_receipt_history
4776: where cash_receipt_id in ( select distinct cash_receipt_id
4777: from ar_autorec_exceptions
4778: where request_id = l_request_id));
4779:

Line 4804: delete from ar_cash_receipt_history

4800:
4801: IF PG_DEBUG in ('Y','C') THEN
4802: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
4803: END IF;
4804: delete from ar_cash_receipt_history
4805: where cash_receipt_id in ( select distinct cash_receipt_id
4806: from ar_autorec_exceptions
4807: where request_id = l_request_id);
4808: