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_RCT_UTIL dependencies on AR_CASH_RECEIPT_HISTORY

Line 63: l_status ar_cash_receipt_history.status%TYPE;

59:
60: l_ps_rec ar_payment_schedules%ROWTYPE;
61: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
62:
63: l_status ar_cash_receipt_history.status%TYPE;
64: BEGIN
65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_standard.debug('arp_process_rct_util.insert_ps_rec_cash()+');

Line 98: from ar_cash_receipt_history

94:
95: /* bug 5569488, set confirmed flag to N if the status is APPROVED */
96: select status
97: into l_status
98: from ar_cash_receipt_history
99: where cash_receipt_id = p_cr_rec.cash_receipt_id
100: and current_record_flag = 'Y' ;
101:
102: IF l_status = 'APPROVED' THEN

Line 131: | Creates a new record in AR_CASH_RECEIPT_HISTORY for a new cash or |

127: | PROCEDURE |
128: | insert_crh_rec |
129: | |
130: | DESCRIPTION |
131: | Creates a new record in AR_CASH_RECEIPT_HISTORY for a new cash or |
132: | misc receipt. |
133: | |
134: | SCOPE - PRIVATE |
135: | |

Line 148: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,

144: +===========================================================================*/
145:
146: PROCEDURE insert_crh_rec(
147: p_cr_rec IN ar_cash_receipts%ROWTYPE,
148: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
150: p_factor_discount_amount IN
151: ar_cash_receipt_history.factor_discount_amount%TYPE,
152: p_acctd_factor_discount_amount IN

Line 149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

145:
146: PROCEDURE insert_crh_rec(
147: p_cr_rec IN ar_cash_receipts%ROWTYPE,
148: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
150: p_factor_discount_amount IN
151: ar_cash_receipt_history.factor_discount_amount%TYPE,
152: p_acctd_factor_discount_amount IN
153: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,

Line 151: ar_cash_receipt_history.factor_discount_amount%TYPE,

147: p_cr_rec IN ar_cash_receipts%ROWTYPE,
148: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
150: p_factor_discount_amount IN
151: ar_cash_receipt_history.factor_discount_amount%TYPE,
152: p_acctd_factor_discount_amount IN
153: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
154: p_gl_date IN DATE,
155: p_creation_status IN VARCHAR2,

Line 153: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,

149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
150: p_factor_discount_amount IN
151: ar_cash_receipt_history.factor_discount_amount%TYPE,
152: p_acctd_factor_discount_amount IN
153: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
154: p_gl_date IN DATE,
155: p_creation_status IN VARCHAR2,
156: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
157: p_ccid IN

Line 156: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,

152: p_acctd_factor_discount_amount IN
153: ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
154: p_gl_date IN DATE,
155: p_creation_status IN VARCHAR2,
156: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
157: p_ccid IN
158: ar_cash_receipt_history.account_code_combination_id%TYPE,
159: p_bank_charges_ccid IN
160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,

Line 158: ar_cash_receipt_history.account_code_combination_id%TYPE,

154: p_gl_date IN DATE,
155: p_creation_status IN VARCHAR2,
156: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
157: p_ccid IN
158: ar_cash_receipt_history.account_code_combination_id%TYPE,
159: p_bank_charges_ccid IN
160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
162: ) IS

Line 160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,

156: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
157: p_ccid IN
158: ar_cash_receipt_history.account_code_combination_id%TYPE,
159: p_bank_charges_ccid IN
160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
162: ) IS
163:
164: l_crh_rec ar_cash_receipt_history%ROWTYPE;

Line 161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE

157: p_ccid IN
158: ar_cash_receipt_history.account_code_combination_id%TYPE,
159: p_bank_charges_ccid IN
160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
162: ) IS
163:
164: l_crh_rec ar_cash_receipt_history%ROWTYPE;
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 164: l_crh_rec ar_cash_receipt_history%ROWTYPE;

160: ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
162: ) IS
163:
164: l_crh_rec ar_cash_receipt_history%ROWTYPE;
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_dummy NUMBER;
167: --Bug#2750340
168: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

161: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
162: ) IS
163:
164: l_crh_rec ar_cash_receipt_history%ROWTYPE;
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_dummy NUMBER;
167: --Bug#2750340
168: l_xla_ev_rec arp_xla_events.xla_events_type;
169:

Line 425: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

421: +===========================================================================*/
422:
423: PROCEDURE insert_dist_rec(
424: p_amount IN ar_cash_receipts.amount%TYPE,
425: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
426: p_crh_id IN
427: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
428: p_source_type IN ar_distributions.source_type%TYPE,
429: p_ccid IN ar_distributions.code_combination_id%TYPE

Line 427: ar_cash_receipt_history.cash_receipt_history_id%TYPE,

423: PROCEDURE insert_dist_rec(
424: p_amount IN ar_cash_receipts.amount%TYPE,
425: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
426: p_crh_id IN
427: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
428: p_source_type IN ar_distributions.source_type%TYPE,
429: p_ccid IN ar_distributions.code_combination_id%TYPE
430: ) IS
431:

Line 437: l_crh_rec ar_cash_receipt_history%ROWTYPE;

433: l_source_type ar_distributions.source_type%TYPE;
434: l_ccid ar_distributions.code_combination_id%TYPE;
435: l_dummy ar_distributions.line_id%TYPE;
436: l_cr_rec ar_cash_receipts%ROWTYPE;
437: l_crh_rec ar_cash_receipt_history%ROWTYPE;
438: --bug#2750340
439: l_xla_ev_rec arp_xla_events.xla_events_type;
440:
441: BEGIN

Line 657: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

653:
654:
655: PROCEDURE insert_misc_dist(
656: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
657: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
658: p_amount IN ar_cash_receipts.amount%TYPE,
659: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
660: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
661: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

Line 661: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

657: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
658: p_amount IN ar_cash_receipts.amount%TYPE,
659: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
660: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
661: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
662: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
663: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
664: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
665: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,

Line 674: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /Bug fix 4025652 /

670: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;
671: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
672: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
673: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
674: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /*Bug fix 4025652 */
675: l_type ar_receivables_trx.type%TYPE; /*4726219 */
676:
677: l_xla_ev_rec arp_xla_events.xla_events_type;
678:

Line 681: FROM ar_cash_receipt_history

677: l_xla_ev_rec arp_xla_events.xla_events_type;
678:
679: CURSOR c_hist IS
680: SELECT cash_receipt_history_id
681: FROM ar_cash_receipt_history
682: WHERE current_record_flag = 'Y'
683: AND cash_receipt_id = p_cash_receipt_id;
684:
685: l_crh_id NUMBER;

Line 762: from ar_cash_receipt_history

758:
759: /* bug fix 4025652 */
760: select account_code_combination_id
761: into l_crh_ccid
762: from ar_cash_receipt_history
763: where cash_receipt_id = p_cash_receipt_id
764: and current_record_flag = 'Y';
765:
766: /* -------------------------------------------------------------------+

Line 906: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

902:
903: PROCEDURE update_misc_dist(
904: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
905: p_amount IN ar_cash_receipts.amount%TYPE,
906: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
907: p_amount_changed_flag IN BOOLEAN,
908: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
909: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
910: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

Line 912: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

908: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
909: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
910: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
911: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
912: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
913: p_gl_date_changed_flag IN BOOLEAN,
914: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
915: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
916: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

Line 928: l_posted ar_cash_receipt_history.posting_control_id%TYPE;

924: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
925: l_old_recs_auto_flag BOOLEAN;
926: l_new_recs_auto_flag BOOLEAN;
927: l_count NUMBER;
928: l_posted ar_cash_receipt_history.posting_control_id%TYPE;
929: l_ae_doc_rec l_ae_doc_rec_type;
930: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr;
931: l_old_default_distribution_set NUMBER; --Bug 6416611
932: l_default_distribution_set NUMBER; --Bug 6416611

Line 1047: FROM ar_cash_receipt_history

1043:
1044: IF (l_count > 0) THEN
1045: SELECT distinct posting_control_id
1046: INTO l_posted
1047: FROM ar_cash_receipt_history
1048: WHERE cash_receipt_id = p_cash_receipt_id
1049: AND current_record_flag = 'Y';
1050: END IF;
1051: l_ae_doc_rec.document_type := 'RECEIPT';

Line 1291: FROM ar_cash_receipt_history

1287:
1288: IF (l_count > 0) then
1289: SELECT distinct posting_control_id
1290: INTO l_posted
1291: FROM ar_cash_receipt_history
1292: WHERE cash_receipt_id = p_cash_receipt_id
1293: AND current_record_flag = 'Y';
1294:
1295: IF (l_posted = -3) THEN

Line 1318: FROM ar_cash_receipt_history

1314: p_receipt_date );
1315:
1316: SELECT distinct posting_control_id
1317: INTO l_posted
1318: FROM ar_cash_receipt_history
1319: WHERE cash_receipt_id = p_cash_receipt_id
1320: AND current_record_flag = 'Y';
1321: IF (l_posted = -3) then
1322: IF PG_DEBUG in ('Y', 'C') THEN

Line 1430: FROM ar_cash_receipt_history

1426: IF (l_count > 0) then
1427:
1428: SELECT distinct posting_control_id
1429: INTO l_posted
1430: FROM ar_cash_receipt_history
1431: WHERE cash_receipt_id = p_cash_receipt_id
1432: AND current_record_flag = 'Y';
1433:
1434: IF (l_posted = -3) THEN

Line 1461: FROM ar_cash_receipt_history

1457: p_distribution_set_id);
1458:
1459: SELECT distinct posting_control_id
1460: INTO l_posted
1461: FROM ar_cash_receipt_history
1462: WHERE cash_receipt_id = p_cash_receipt_id
1463: AND current_record_flag = 'Y';
1464: IF (l_posted = -3) then
1465: IF PG_DEBUG in ('Y', 'C') THEN

Line 1518: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

1514:
1515: PROCEDURE create_mcd_recs(
1516: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1517: p_amount IN ar_cash_receipts.amount%TYPE,
1518: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1519: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1520: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1521: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1522: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

Line 1521: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1517: p_amount IN ar_cash_receipts.amount%TYPE,
1518: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1519: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1520: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1521: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1522: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1523: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1524: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1525: ) IS

Line 1572: FROM ar_cash_receipt_history

1568: distribution_set_id = p_distribution_set_id;
1569:
1570: CURSOR c_hist IS
1571: SELECT cash_receipt_history_id
1572: FROM ar_cash_receipt_history
1573: WHERE current_record_flag = 'Y'
1574: AND cash_receipt_id = p_cash_receipt_id;
1575:
1576: l_crh_id NUMBER;

Line 1800: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,

1796:
1797: PROCEDURE update_manual_dist(
1798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1799: p_amount IN ar_cash_receipts.amount%TYPE,
1800: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1801: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1802: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1803: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1804: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE

Line 1803: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1799: p_amount IN ar_cash_receipts.amount%TYPE,
1800: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1801: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1802: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1803: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1804: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
1805: ) IS
1806:
1807: l_min_unit NUMBER;

Line 2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2003: p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE) IS
2004:
2005: l_radj_rec ar_rate_adjustments%ROWTYPE;
2006: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
2007: l_crh_id_out ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2008:
2009: BEGIN
2010: IF PG_DEBUG in ('Y', 'C') THEN
2011: arp_standard.debug('arp_process_rct_util.rate_adjust()+');