eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_PUB dependencies on AR_CASH_RECEIPT_HISTORY

Line 159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
162: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
163: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;

Line 1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

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

4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4781: p_maturity_date IN DATE DEFAULT NULL,
4782: p_postmark_date IN DATE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4784: /* tca uptake */

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

5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5103: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
5104: p_maturity_date IN DATE DEFAULT NULL,
5105: p_postmark_date IN DATE DEFAULT NULL,
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5107: /* tca uptake */

Line 5476: l_crh_rec ar_cash_receipt_history%ROWTYPE;

5472: p_return_status OUT NOCOPY VARCHAR2
5473:
5474: ) IS
5475: l_rev_crh_id NUMBER;
5476: l_crh_rec ar_cash_receipt_history%ROWTYPE;
5477: l_cr_rec ar_cash_receipts%ROWTYPE;
5478: l_ps_rec ar_payment_schedules%ROWTYPE;
5479: BEGIN
5480: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,

5591: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5592: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5597: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5598: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5599: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,

Line 5795: from ar_Cash_receipts cr, ar_cash_receipt_history crh

5791: Settlement is not run for remitted receipts*/
5792: BEGIN
5793:
5794: select cr.payment_trxn_extension_id into l_trxn_extn_id
5795: from ar_Cash_receipts cr, ar_cash_receipt_history crh
5796: where cr.cash_receipt_id=crh.cash_receipt_id
5797: and crh.current_record_flag= 'Y'
5798: and crh.status = 'REMITTED'
5799: and cr.cash_receipt_id = p_cash_receipt_id;

Line 6079: from AR_MISC_CASH_DISTRIBUTIONS_ALL mcd, ar_cash_receipt_history_all rh

6075: arp_util.debug('Check if the receipts MCD exists with out eventids');
6076: end if;
6077:
6078: select count(*) into l_exist_flag
6079: from AR_MISC_CASH_DISTRIBUTIONS_ALL mcd, ar_cash_receipt_history_all rh
6080: where rh.cash_receipt_id = l_cash_receipt_id
6081: and mcd.cash_receipt_id = rh.cash_receipt_id
6082: and mcd.cash_receipt_history_id = rh.cash_receipt_history_id
6083: and mcd.request_id = arp_global.request_id

Line 8940: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

8936: l_creation_method_code ar_receipt_classes.creation_method_code%TYPE;
8937: /* Bug fix 2300268 */
8938: l_tax_account_id ar_distributions.code_combination_id%TYPE;
8939: /* Bug fix 2742388 */
8940: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
8941: l_org_return_status VARCHAR2(1);
8942: l_org_id NUMBER;
8943: l_legal_entity_id NUMBER; /* R12 LE uptake */
8944: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

Line 10659: l_request_id ar_cash_receipt_history.request_id%TYPE;

10655: l_created_by NUMBER;
10656: l_last_update_login NUMBER;
10657: l_program_application_id NUMBER;
10658: l_program_id NUMBER;
10659: l_request_id ar_cash_receipt_history.request_id%TYPE;
10660: l_request_id_bulk ar_cash_receipt_history.request_id%TYPE;
10661: l_request_id_set VARCHAR2(1);
10662:
10663: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;

Line 10660: l_request_id_bulk ar_cash_receipt_history.request_id%TYPE;

10656: l_last_update_login NUMBER;
10657: l_program_application_id NUMBER;
10658: l_program_id NUMBER;
10659: l_request_id ar_cash_receipt_history.request_id%TYPE;
10660: l_request_id_bulk ar_cash_receipt_history.request_id%TYPE;
10661: l_request_id_set VARCHAR2(1);
10662:
10663: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
10664:

Line 10672: ar_cash_receipt_history_s.nextval,

10668: select cash_receipt_history_id,
10669: cash_receipt_id,
10670: reversal_gl_date,
10671: gl_date,
10672: ar_cash_receipt_history_s.nextval,
10673: batch_id,
10674: amount,
10675: cc_error_code,
10676: cc_error_text,

Line 10688: from ar_cash_receipt_history crh

10684: where crhgt.cash_receipt_id
10685: not in
10686: (
10687: select crh.cash_receipt_id
10688: from ar_cash_receipt_history crh
10689: where crh.cash_receipt_id= crhgt.cash_receipt_id
10690: and crh.status = 'CONFIRMED'
10691: and crh.current_record_flag='Y'
10692: and crh.request_id =p_req_id

Line 10744: /Insert into ar_rr_crh_gt select from ar_cash_receipt_history*/

10740: END IF;
10741:
10742:
10743: /* Collecting CRH data of passsed receipts*/
10744: /*Insert into ar_rr_crh_gt select * from ar_cash_receipt_history*/
10745: FORALL i IN p_cash_receipts_id.cash_receipt_id.first..p_cash_receipts_id.cash_receipt_id.last
10746: INSERT INTO AR_RR_CRH_GT
10747: (
10748: CASH_RECEIPT_HISTORY_ID,

Line 10866: FROM ar_Cash_receipt_history

10862: EVENT_ID,
10863: p_cash_receipts_id.CC_ERROR_CODE(i),
10864: p_cash_receipts_id.CC_ERROR_TEXT(i),
10865: p_cash_receipts_id.CC_INSTRTYPE(i)
10866: FROM ar_Cash_receipt_history
10867: where cash_receipt_id=p_cash_receipts_id.cash_receipt_id(i)
10868: and current_record_flag = 'Y'
10869: and status = 'REMITTED'
10870: and NOT EXISTS (SELECT * FROM AR_RR_CRH_GT WHERE cash_receipt_id = p_cash_receipts_id.cash_receipt_id(i)); -- Bug 13549918

Line 10956: update ar_cash_receipt_history set

10952:
10953:
10954: /*Update existing CRH record of remittance*/
10955: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
10956: update ar_cash_receipt_history set
10957: reversal_cash_receipt_hist_id = l_crh_upd.reversal_cash_receipt_hist_id(i),
10958: reversal_gl_date = l_crh_upd.reversal_gl_date(i),
10959: reversal_created_from = 'ARREVREM',
10960: current_record_flag = NULL,

Line 10976: Insert into ar_cash_receipt_history

10972:
10973:
10974: /*Inserting new CRH record for CONFIRM State*/
10975: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
10976: Insert into ar_cash_receipt_history
10977: (
10978: CASH_RECEIPT_HISTORY_ID,
10979: CASH_RECEIPT_ID,
10980: STATUS,

Line 11090: FROM AR_CASH_RECEIPT_HISTORY

11086: ATTRIBUTE15,
11087: ATTRIBUTE_CATEGORY,
11088: ORG_ID,
11089: NULL
11090: FROM AR_CASH_RECEIPT_HISTORY
11091: WHERE reversal_cash_receipt_hist_id=l_crh_upd.cash_receipt_history_id(i)
11092: AND l_crh_upd.rec_status(i)='VALID';
11093:
11094: IF PG_DEBUG in ('Y', 'C') THEN

Line 11109: update ar_cash_receipt_history set

11105:
11106: IF l_request_id_bulk = -999 THEN
11107:
11108: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
11109: update ar_cash_receipt_history set
11110: request_id = l_request_id
11111: WHERE cash_receipt_history_id = l_crh_upd.reversal_cash_receipt_hist_id(i)
11112: AND current_record_flag = 'Y'
11113: AND status = 'CONFIRMED'

Line 11258: ar_Cash_receipt_history crh

11254: ard.activity_bucket,
11255: ard.ref_dist_ccid,
11256: ard.ref_mf_dist_flag
11257: FROM ar_distributions ard,
11258: ar_Cash_receipt_history crh
11259: WHERE ard.source_id=crh.cash_receipt_history_id
11260: and ard.source_table = 'CRH'
11261: and cash_receipt_history_id=l_crh_upd.cash_receipt_history_id(i)
11262: AND l_crh_upd.rec_status(i)='VALID';

Line 11346: update ar_cash_receipt_history SET

11342: IF PG_DEBUG in ('Y','C') THEN
11343: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
11344: END IF;
11345:
11346: update ar_cash_receipt_history SET
11347: last_update_date = sysdate,
11348: request_id = p_request_id
11349: WHERE cash_receipt_id in
11350: ( select cash_receipt_id