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 11: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

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

Line 12: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

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

Line 14: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

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

Line 15: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

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

Line 16: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

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

Line 18: p_amount_cleared IN ar_cash_receipt_history.amount%TYPE,

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

Line 19: p_amount_factored IN ar_cash_receipt_history.factor_discount_amount%TYPE,

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

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

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

Line 48: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

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

Line 49: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

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

Line 52: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;

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

Line 53: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;

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

Line 54: l_cash_amt ar_cash_receipt_history.amount%TYPE;

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

Line 55: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;

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

Line 56: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;

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

Line 57: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

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

Line 69: l_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

65: l_status BOOLEAN := FALSE;
66: l_settle_error_message varchar2(2000);
67: settlement_pending_raise exception;
68:
69: l_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
70: l_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;
72:
73: /* 9363502 - define tables used by refresh_at_risk_value */

Line 70: l_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

66: l_settle_error_message varchar2(2000);
67: settlement_pending_raise exception;
68:
69: l_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
70: l_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;
72:
73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;

Line 71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;

67: settlement_pending_raise exception;
68:
69: l_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
70: l_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
71: l_exchange_rate_type ar_cash_receipt_history.exchange_rate_type%TYPE;
72:
73: /* 9363502 - define tables used by refresh_at_risk_value */
74: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;
75: l_site_use_id_tab ar_bus_event_sub_pvt.generic_id_type;

Line 509: -- populating batch_id in ar_cash_receipt_history table

505: l_crh_rec_new.current_record_flag := 'Y';
506:
507: l_crh_rec_new.batch_id := l_crh_rec_old.batch_id;
508: -- fix for bug # 766382
509: -- populating batch_id in ar_cash_receipt_history table
510: -- with the batch_id of the remittance record.
511: -- l_crh_rec_new.batch_id := NULL;
512:
513: l_crh_rec_new.account_code_combination_id := l_rma_rec.cash_ccid;

Line 1056: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

1052: END clear;
1053:
1054: PROCEDURE unclear(
1055: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1056: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
1059: p_module_name IN VARCHAR2,
1060: p_module_version IN VARCHAR2,

Line 1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1053:
1054: PROCEDURE unclear(
1055: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1056: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
1059: p_module_name IN VARCHAR2,
1060: p_module_version IN VARCHAR2,
1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

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

1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
1059: p_module_name IN VARCHAR2,
1060: p_module_version IN VARCHAR2,
1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1062: --
1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;

Line 1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;

1060: p_module_version IN VARCHAR2,
1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1062: --
1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

Line 1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;

1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1062: --
1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;

Line 1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;

1062: --
1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
1070: l_radj_rec ar_rate_adjustments%ROWTYPE;

Line 1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
1070: l_radj_rec ar_rate_adjustments%ROWTYPE;
1071: l_dist_rec ar_distributions%ROWTYPE;

Line 1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
1070: l_radj_rec ar_rate_adjustments%ROWTYPE;
1071: l_dist_rec ar_distributions%ROWTYPE;
1072: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

Line 1072: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

1068: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
1070: l_radj_rec ar_rate_adjustments%ROWTYPE;
1071: l_dist_rec ar_distributions%ROWTYPE;
1072: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1073: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1074: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1075:
1076: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 1073: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

1069: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
1070: l_radj_rec ar_rate_adjustments%ROWTYPE;
1071: l_dist_rec ar_distributions%ROWTYPE;
1072: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1073: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1074: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1075:
1076: l_xla_ev_rec arp_xla_events.xla_events_type;
1077:

Line 1074: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1070: l_radj_rec ar_rate_adjustments%ROWTYPE;
1071: l_dist_rec ar_distributions%ROWTYPE;
1072: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1073: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1074: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1075:
1076: l_xla_ev_rec arp_xla_events.xla_events_type;
1077:
1078: l_rate_Adj_reverted varchar2(1);

Line 1512: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

1508: END unclear;
1509:
1510: PROCEDURE risk_eliminate(
1511: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1512: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1513: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1514: p_module_name IN VARCHAR2,
1515: p_module_version IN VARCHAR2,
1516: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 1513: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1509:
1510: PROCEDURE risk_eliminate(
1511: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1512: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1513: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1514: p_module_name IN VARCHAR2,
1515: p_module_version IN VARCHAR2,
1516: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1517: --

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

1512: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1513: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1514: p_module_name IN VARCHAR2,
1515: p_module_version IN VARCHAR2,
1516: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1517: --
1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1520: l_dist_rec ar_distributions%ROWTYPE;

Line 1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1514: p_module_name IN VARCHAR2,
1515: p_module_version IN VARCHAR2,
1516: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1517: --
1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1520: l_dist_rec ar_distributions%ROWTYPE;
1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

Line 1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1515: p_module_version IN VARCHAR2,
1516: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1517: --
1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1520: l_dist_rec ar_distributions%ROWTYPE;
1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1523: NULL_VAR ar_receipt_method_accounts%ROWTYPE;

Line 1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

1517: --
1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1520: l_dist_rec ar_distributions%ROWTYPE;
1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1523: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1524: l_cr_rec ar_cash_receipts%ROWTYPE;
1525: l_risk_event_rec arp_xla_events.xla_events_type;

Line 1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

1518: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1519: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1520: l_dist_rec ar_distributions%ROWTYPE;
1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1523: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1524: l_cr_rec ar_cash_receipts%ROWTYPE;
1525: l_risk_event_rec arp_xla_events.xla_events_type;
1526:

Line 1790: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,

1786: END risk_eliminate;
1787:
1788: PROCEDURE undo_risk_eliminate(
1789: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1790: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1791: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1792: p_module_name IN VARCHAR2,
1793: p_module_version IN VARCHAR2,
1794: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

Line 1791: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

1787:
1788: PROCEDURE undo_risk_eliminate(
1789: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1790: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1791: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1792: p_module_name IN VARCHAR2,
1793: p_module_version IN VARCHAR2,
1794: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1795: --

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

1790: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1791: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1792: p_module_name IN VARCHAR2,
1793: p_module_version IN VARCHAR2,
1794: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1795: --
1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1798: l_dist_rec ar_distributions%ROWTYPE;

Line 1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

1792: p_module_name IN VARCHAR2,
1793: p_module_version IN VARCHAR2,
1794: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1795: --
1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1798: l_dist_rec ar_distributions%ROWTYPE;
1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

Line 1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

1793: p_module_version IN VARCHAR2,
1794: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1795: --
1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1798: l_dist_rec ar_distributions%ROWTYPE;
1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1801: NULL_VAR ar_receipt_method_accounts%ROWTYPE;

Line 1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;

1795: --
1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1798: l_dist_rec ar_distributions%ROWTYPE;
1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1801: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1802: l_cr_rec ar_cash_receipts%ROWTYPE;
1803: BEGIN

Line 1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;

1796: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1797: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1798: l_dist_rec ar_distributions%ROWTYPE;
1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1801: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1802: l_cr_rec ar_cash_receipts%ROWTYPE;
1803: BEGIN
1804:

Line 2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

2046: PROCEDURE ins_misc_txn(
2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

Line 2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,

Line 2078: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2074: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
2075: /* Bug fix 2300268 */
2076: l_tax_account_id ar_distributions.code_combination_id%TYPE;
2077: /* Bug fix 2742388 */
2078: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2079: l_org_id NUMBER; --added by Jixun for bug#14726865
2080: BEGIN
2081:
2082: IF PG_DEBUG in ('Y', 'C') THEN

Line 2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

2221: END ins_misc_txn;
2222:
2223: PROCEDURE reverse(
2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

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

2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2230: p_module_name IN VARCHAR2,
2231: p_module_version IN VARCHAR2,
2232: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
2233:
2234: CURSOR current_crh_cur IS
2235: SELECT crh.cash_receipt_history_id
2236: FROM ar_cash_receipt_history crh

Line 2236: FROM ar_cash_receipt_history crh

2232: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
2233:
2234: CURSOR current_crh_cur IS
2235: SELECT crh.cash_receipt_history_id
2236: FROM ar_cash_receipt_history crh
2237: WHERE crh.cash_receipt_id = p_cr_id
2238: AND crh.current_record_flag = 'Y'
2239: AND crh.status = 'REVERSED';
2240:

Line 2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

2416: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2417: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2418: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2419: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

Line 2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,

2521:
2522:
2523: PROCEDURE Lock_Row(
2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,

Line 2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,

2522:
2523: PROCEDURE Lock_Row(
2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,

Line 2580: FROM ar_cash_receipt_history crh, ar_cash_receipts acr

2576: IS
2577:
2578: CURSOR C IS
2579: SELECT crh.cash_receipt_history_id
2580: FROM ar_cash_receipt_history crh, ar_cash_receipts acr
2581: WHERE crh.batch_id = P_BATCH_ID
2582: AND crh.status not in ('REVERSED')
2583: AND crh.cash_receipt_id = acr.cash_receipt_id
2584: FOR UPDATE NOWAIT;

Line 2595: c_amount ar_cash_receipt_history.amount%TYPE;

2591:
2592: Recinfo C%ROWTYPE;
2593: Batchinfo BATCH%ROWTYPE;
2594: c_batch_id ar_batches.batch_id%TYPE;
2595: c_amount ar_cash_receipt_history.amount%TYPE;
2596: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2597:
2598: BEGIN
2599:

Line 2596: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

2592: Recinfo C%ROWTYPE;
2593: Batchinfo BATCH%ROWTYPE;
2594: c_batch_id ar_batches.batch_id%TYPE;
2595: c_amount ar_cash_receipt_history.amount%TYPE;
2596: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2597:
2598: BEGIN
2599:
2600: OPEN C;

Line 2614: FROM ar_cash_receipt_history

2610: CLOSE BATCH;
2611:
2612: SELECT sum(amount) , sum(acctd_amount)
2613: INTO c_amount, c_acctd_amount
2614: FROM ar_cash_receipt_history
2615: WHERE batch_id = P_BATCH_ID
2616: AND status not in ('REVERSED');
2617:
2618: