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.ARP_PROC_RECEIPTS1 dependencies on AR_CASH_RECEIPT_HISTORY

Line 268: l_crh_rec ar_cash_receipt_history%ROWTYPE;

264: p_payment_trxn_extension_id IN NUMBER default NULL /* PAYMENT_UPTAKE */
265: ) IS
266:
267: l_cr_rec ar_cash_receipts%ROWTYPE;
268: l_crh_rec ar_cash_receipt_history%ROWTYPE;
269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

265: ) IS
266:
267: l_cr_rec ar_cash_receipts%ROWTYPE;
268: l_crh_rec ar_cash_receipt_history%ROWTYPE;
269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;

Line 272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;

268: l_crh_rec ar_cash_receipt_history%ROWTYPE;
269: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
270: l_ps_rec ar_payment_schedules%ROWTYPE;
271: l_dist_rec ar_distributions%ROWTYPE;
272: l_crh_id_new ar_cash_receipt_history.cash_receipt_history_id%TYPE;
273: l_ra_id_unapp ar_receivable_applications.receivable_application_id%TYPE;
274: l_ra_id_unid ar_receivable_applications.receivable_application_id%TYPE;
275: l_ae_doc_rec ae_doc_rec_type;
276:

Line 316: l_creation_status ar_cash_receipt_history.status%TYPE;

312:
313: -- other stuff:
314:
315: l_source_type ar_distributions.source_type%TYPE;
316: l_creation_status ar_cash_receipt_history.status%TYPE;
317: l_rev_crh_id ar_cash_receipt_history.reversal_cash_receipt_hist_id%TYPE;
318:
319: -- dummy variables:
320:

Line 317: l_rev_crh_id ar_cash_receipt_history.reversal_cash_receipt_hist_id%TYPE;

313: -- other stuff:
314:
315: l_source_type ar_distributions.source_type%TYPE;
316: l_creation_status ar_cash_receipt_history.status%TYPE;
317: l_rev_crh_id ar_cash_receipt_history.reversal_cash_receipt_hist_id%TYPE;
318:
319: -- dummy variables:
320:
321: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;

Line 338: l_creation_status_old ar_cash_receipt_history.status%TYPE;

334:
335: -- old stuff:
336: /*
337: l_source_type_old ar_distributions.source_type%TYPE;
338: l_creation_status_old ar_cash_receipt_history.status%TYPE;
339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;
340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;

Line 339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;

335: -- old stuff:
336: /*
337: l_source_type_old ar_distributions.source_type%TYPE;
338: l_creation_status_old ar_cash_receipt_history.status%TYPE;
339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;
340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;

Line 340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;

336: /*
337: l_source_type_old ar_distributions.source_type%TYPE;
338: l_creation_status_old ar_cash_receipt_history.status%TYPE;
339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;
340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;
344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;

Line 342: l_creation_status_new ar_cash_receipt_history.status%TYPE;

338: l_creation_status_old ar_cash_receipt_history.status%TYPE;
339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;
340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;
344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;
345: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
346: l_id_dummy NUMBER;

Line 343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;

339: l_acctd_amount_old ar_cash_receipt_history.acctd_amount%TYPE;
340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;
344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;
345: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
346: l_id_dummy NUMBER;
347: l_amount_changed BOOLEAN := FALSE;

Line 344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;

340: l_ccid_old ar_cash_receipt_history.account_code_combination_id%TYPE;
341: l_source_type_new ar_distributions.source_type%TYPE;
342: l_creation_status_new ar_cash_receipt_history.status%TYPE;
343: l_acctd_amount_new ar_cash_receipt_history.acctd_amount%TYPE;
344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;
345: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
346: l_id_dummy NUMBER;
347: l_amount_changed BOOLEAN := FALSE;
348: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 348: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

344: l_ccid_new ar_cash_receipt_history.account_code_combination_id%TYPE;
345: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
346: l_id_dummy NUMBER;
347: l_amount_changed BOOLEAN := FALSE;
348: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
349: l_ra_unapp_ccid NUMBER;
350: l_ra_unid_ccid NUMBER;
351: l_ra_unapp_ccid_old NUMBER;
352: l_ra_unid_ccid_old NUMBER;

Line 850: -- ar_cash_receipts, ar_cash_receipt_history, and ar_payment_schedules,

846: -- deal with amount changes
847: -- -------------------------------------------------------------
848:
849: -- if the receipt status is APPROVED, we only update the amounts in
850: -- ar_cash_receipts, ar_cash_receipt_history, and ar_payment_schedules,
851: -- but not ar_receivable_applications, since this is being taken
852: -- care of by the applications form and its server-side code:
853:
854:

Line 999: from ar_cash_receipt_history crh, ar_distributions dis

995: select 'Y'
996: into l_bank_charges_row_exists
997: from dual
998: where exists (select crh.cash_receipt_history_id
999: from ar_cash_receipt_history crh, ar_distributions dis
1000: where crh.cash_receipt_id = l_crh_rec.cash_receipt_id
1001: and dis.source_id = crh.cash_receipt_history_id
1002: and dis.source_table = 'CRH'
1003: and dis.source_type ='BANK_CHARGES');

Line 1067: from ar_cash_receipt_history crh

1063: l_sum_acctd_fda_credits
1064: from ar_distributions dis
1065: where dis.source_id in
1066: (select crh.cash_receipt_history_id
1067: from ar_cash_receipt_history crh
1068: where crh.cash_receipt_id = p_cash_receipt_id ) /* Bug2855253 removed and crh.current_record_flag ='N' */
1069:
1070: and dis.source_table = 'CRH'
1071: and dis.source_type = 'BANK_CHARGES';

Line 1662: ar_cash_receipt_history crh_current,

1658: p_new_status_dsp,
1659: p_new_state,
1660: p_new_state_dsp
1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE