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

Line 10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

6: -- Public Procedures
7: --
8: PROCEDURE clear(
9: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

Line 11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

7: --
8: PROCEDURE clear(
9: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

Line 13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

9: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
16: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,

Line 14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
16: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,

Line 15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
16: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
19: p_module_name IN VARCHAR2,

Line 17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,

13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
16: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
19: p_module_name IN VARCHAR2,
20: p_module_version IN VARCHAR2,
21: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,

14: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
15: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
16: p_bank_currency IN ce_bank_accounts.currency_code%TYPE,
17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
19: p_module_name IN VARCHAR2,
20: p_module_version IN VARCHAR2,
21: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
22: --

Line 21: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

17: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,
18: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,
19: p_module_name IN VARCHAR2,
20: p_module_version IN VARCHAR2,
21: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
22: --
23: /*----------------------------------
24: Some notes to use this clear procedure:
25:

Line 47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

43:
44: ------------------------------------*/
45: l_cr_rec ar_cash_receipts%ROWTYPE;
46: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;

Line 48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

44: ------------------------------------*/
45: l_cr_rec ar_cash_receipts%ROWTYPE;
46: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;

Line 51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;

47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;

Line 52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;

48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

Line 53: l_cash_amt ar_cash_receipt_history.amount%TYPE;

49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;

Line 54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;

50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;
58: --Bug#2750340

Line 55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;

51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;
58: --Bug#2750340
59: l_event_rec arp_xla_events.xla_events_type;

Line 56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;
58: --Bug#2750340
59: l_event_rec arp_xla_events.xla_events_type;
60:

Line 310: -- populating batch_id in ar_cash_receipt_history table

306: l_crh_rec_new.current_record_flag := 'Y';
307:
308: l_crh_rec_new.batch_id := l_crh_rec_old.batch_id;
309: -- fix for bug # 766382
310: -- populating batch_id in ar_cash_receipt_history table
311: -- with the batch_id of the remittance record.
312: -- l_crh_rec_new.batch_id := NULL;
313:
314: l_crh_rec_new.account_code_combination_id := l_rma_rec.cash_ccid;

Line 783: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

779: END clear;
780:
781: PROCEDURE unclear(
782: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
783: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
786: p_module_name IN VARCHAR2,
787: p_module_version IN VARCHAR2,

Line 784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

780:
781: PROCEDURE unclear(
782: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
783: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
786: p_module_name IN VARCHAR2,
787: p_module_version IN VARCHAR2,
788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
786: p_module_name IN VARCHAR2,
787: p_module_version IN VARCHAR2,
788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
789: --
790: l_cr_rec ar_cash_receipts%ROWTYPE;
791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

Line 791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;

787: p_module_version IN VARCHAR2,
788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
789: --
790: l_cr_rec ar_cash_receipts%ROWTYPE;
791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;

Line 792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
789: --
790: l_cr_rec ar_cash_receipts%ROWTYPE;
791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;

Line 793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

789: --
790: l_cr_rec ar_cash_receipts%ROWTYPE;
791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;
797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

Line 797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;
797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
798: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
799: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
800:
801: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 798: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;
797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
798: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
799: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
800:
801: l_xla_ev_rec arp_xla_events.xla_events_type;
802:

Line 799: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;

795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;
797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
798: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
799: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
800:
801: l_xla_ev_rec arp_xla_events.xla_events_type;
802:
803: BEGIN

Line 1165: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

1161: END unclear;
1162:
1163: PROCEDURE risk_eliminate(
1164: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1165: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1166: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1167: p_module_name IN VARCHAR2,
1168: p_module_version IN VARCHAR2,
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 1166: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1162:
1163: PROCEDURE risk_eliminate(
1164: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1165: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1166: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1167: p_module_name IN VARCHAR2,
1168: p_module_version IN VARCHAR2,
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1170: --

Line 1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

1165: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1166: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1167: p_module_name IN VARCHAR2,
1168: p_module_version IN VARCHAR2,
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1170: --
1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;

Line 1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1167: p_module_name IN VARCHAR2,
1168: p_module_version IN VARCHAR2,
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1170: --
1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

Line 1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1168: p_module_version IN VARCHAR2,
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1170: --
1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1176: NULL_VAR ar_receipt_method_accounts%ROWTYPE;

Line 1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

1170: --
1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1176: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1177: l_cr_rec ar_cash_receipts%ROWTYPE;
1178: l_risk_event_rec arp_xla_events.xla_events_type;

Line 1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1176: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1177: l_cr_rec ar_cash_receipts%ROWTYPE;
1178: l_risk_event_rec arp_xla_events.xla_events_type;
1179: BEGIN

Line 1381: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

1377: END risk_eliminate;
1378:
1379: PROCEDURE undo_risk_eliminate(
1380: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1381: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1382: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1383: p_module_name IN VARCHAR2,
1384: p_module_version IN VARCHAR2,
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 1382: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1378:
1379: PROCEDURE undo_risk_eliminate(
1380: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1381: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1382: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1383: p_module_name IN VARCHAR2,
1384: p_module_version IN VARCHAR2,
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1386: --

Line 1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

1381: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1382: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1383: p_module_name IN VARCHAR2,
1384: p_module_version IN VARCHAR2,
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1386: --
1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;

Line 1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1383: p_module_name IN VARCHAR2,
1384: p_module_version IN VARCHAR2,
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1386: --
1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

Line 1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1384: p_module_version IN VARCHAR2,
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1386: --
1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1392: NULL_VAR ar_receipt_method_accounts%ROWTYPE;

Line 1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

1386: --
1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1392: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1393: l_cr_rec ar_cash_receipts%ROWTYPE;
1394: BEGIN

Line 1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1392: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1393: l_cr_rec ar_cash_receipts%ROWTYPE;
1394: BEGIN
1395:

Line 1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1634: PROCEDURE ins_misc_txn(
1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

Line 1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,

Line 1666: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1662: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
1663: /* Bug fix 2300268 */
1664: l_tax_account_id ar_distributions.code_combination_id%TYPE;
1665: /* Bug fix 2742388 */
1666: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1667: BEGIN
1668:
1669: IF PG_DEBUG in ('Y', 'C') THEN
1670: arp_util.debug( '>>>>>>> arp_cashbook.ins_misc_txn' );

Line 1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

1788: END ins_misc_txn;
1789:
1790: PROCEDURE reverse(
1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

Line 1799: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS

1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1797: p_module_name IN VARCHAR2,
1798: p_module_version IN VARCHAR2,
1799: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
1800:
1801: CURSOR current_crh_cur IS
1802: SELECT crh.cash_receipt_history_id
1803: FROM ar_cash_receipt_history crh

Line 1803: FROM ar_cash_receipt_history crh

1799: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
1800:
1801: CURSOR current_crh_cur IS
1802: SELECT crh.cash_receipt_history_id
1803: FROM ar_cash_receipt_history crh
1804: WHERE crh.cash_receipt_id = p_cr_id
1805: AND crh.current_record_flag = 'Y'
1806: AND crh.status = 'REVERSED';
1807:

Line 1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

1983: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1984: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1985: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1986: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,

2088:
2089:
2090: PROCEDURE Lock_Row(
2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,

Line 2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,

2089:
2090: PROCEDURE Lock_Row(
2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,

Line 2147: FROM ar_cash_receipt_history crh, ar_cash_receipts acr

2143: IS
2144:
2145: CURSOR C IS
2146: SELECT crh.cash_receipt_history_id
2147: FROM ar_cash_receipt_history crh, ar_cash_receipts acr
2148: WHERE crh.batch_id = P_BATCH_ID
2149: AND crh.status not in ('REVERSED')
2150: AND crh.cash_receipt_id = acr.cash_receipt_id
2151: FOR UPDATE NOWAIT;

Line 2162: c_amount ar_cash_receipt_history.amount%TYPE;

2158:
2159: Recinfo C%ROWTYPE;
2160: Batchinfo BATCH%ROWTYPE;
2161: c_batch_id ar_batches.batch_id%TYPE;
2162: c_amount ar_cash_receipt_history.amount%TYPE;
2163: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2164:
2165: BEGIN
2166:

Line 2163: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

2159: Recinfo C%ROWTYPE;
2160: Batchinfo BATCH%ROWTYPE;
2161: c_batch_id ar_batches.batch_id%TYPE;
2162: c_amount ar_cash_receipt_history.amount%TYPE;
2163: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2164:
2165: BEGIN
2166:
2167: OPEN C;

Line 2181: FROM ar_cash_receipt_history

2177: CLOSE BATCH;
2178:
2179: SELECT sum(amount) , sum(acctd_amount)
2180: INTO c_amount, c_acctd_amount
2181: FROM ar_cash_receipt_history
2182: WHERE batch_id = P_BATCH_ID
2183: AND status not in ('REVERSED');
2184:
2185: