DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_CASH_RECEIPTS

Line 11: p_cr_rec IN ar_cash_receipts%ROWTYPE,

7: FUNCTION revision RETURN VARCHAR2;
8:
9:
10: PROCEDURE insert_ps_rec_cash(
11: p_cr_rec IN ar_cash_receipts%ROWTYPE,
12: p_gl_date IN DATE,
13: p_maturity_date IN DATE,
14: p_acctd_amount IN
15: ar_payment_schedules.acctd_amount_due_remaining%TYPE,

Line 21: p_cr_rec IN ar_cash_receipts%ROWTYPE,

17: ar_payment_schedules.payment_schedule_id%TYPE
18: );
19:
20: PROCEDURE insert_crh_rec(
21: p_cr_rec IN ar_cash_receipts%ROWTYPE,
22: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
23: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
24: p_factor_discount_amount IN
25: ar_cash_receipt_history.factor_discount_amount%TYPE,

Line 39: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

35: p_crh_rec OUT NOCOPY ar_cash_receipt_history%ROWTYPE
36: );
37:
38: PROCEDURE insert_ra_rec_cash(
39: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
40: p_amount IN ar_cash_receipts.amount%TYPE,
41: p_apply_date IN DATE,
42: p_status IN ar_cash_receipts.status%TYPE,
43: p_acctd_amount IN

Line 40: p_amount IN ar_cash_receipts.amount%TYPE,

36: );
37:
38: PROCEDURE insert_ra_rec_cash(
39: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
40: p_amount IN ar_cash_receipts.amount%TYPE,
41: p_apply_date IN DATE,
42: p_status IN ar_cash_receipts.status%TYPE,
43: p_acctd_amount IN
44: ar_receivable_applications.acctd_amount_applied_from%TYPE,

Line 42: p_status IN ar_cash_receipts.status%TYPE,

38: PROCEDURE insert_ra_rec_cash(
39: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
40: p_amount IN ar_cash_receipts.amount%TYPE,
41: p_apply_date IN DATE,
42: p_status IN ar_cash_receipts.status%TYPE,
43: p_acctd_amount IN
44: ar_receivable_applications.acctd_amount_applied_from%TYPE,
45: p_gl_date IN DATE,
46: p_ccid IN

Line 57: p_amount IN ar_cash_receipts.amount%TYPE,

53: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
54: );
55:
56: PROCEDURE insert_dist_rec(
57: p_amount IN ar_cash_receipts.amount%TYPE,
58: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
59: p_crh_id IN
60: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
61: p_source_type IN ar_distributions.source_type%TYPE,

Line 66: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE

62: p_ccid IN ar_distributions.code_combination_id%TYPE
63: );
64:
65: PROCEDURE round_mcd_recs(
66: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
67: );
68:
69:
70: PROCEDURE insert_misc_dist(

Line 71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

67: );
68:
69:
70: PROCEDURE insert_misc_dist(
71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

Line 73: p_amount IN ar_cash_receipts.amount%TYPE,

69:
70: PROCEDURE insert_misc_dist(
71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

Line 74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

70: PROCEDURE insert_misc_dist(
71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

Line 75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

71: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
72: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,

Line 77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

73: p_amount IN ar_cash_receipts.amount%TYPE,
74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
81: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'

Line 78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

74: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
81: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
82: );

Line 79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,

75: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
81: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
82: );
83:

Line 80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,

76: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
77: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
78: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
79: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
80: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
81: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
82: );
83:
84:

Line 86: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

82: );
83:
84:
85: PROCEDURE update_misc_dist(
86: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

Line 87: p_amount IN ar_cash_receipts.amount%TYPE,

83:
84:
85: PROCEDURE update_misc_dist(
86: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

Line 90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

86: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

87: p_amount IN ar_cash_receipts.amount%TYPE,
88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,

Line 92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

88: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

89: p_amount_changed_flag IN BOOLEAN,
90: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
91: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

Line 96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

92: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
98: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
99: p_receipt_date_changed_flag IN BOOLEAN,
100: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE

Line 97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

93: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
98: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
99: p_receipt_date_changed_flag IN BOOLEAN,
100: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
101: );

Line 98: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

94: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
95: p_gl_date_changed_flag IN BOOLEAN,
96: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
97: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
98: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
99: p_receipt_date_changed_flag IN BOOLEAN,
100: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
101: );
102:

Line 104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

100: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
101: );
102:
103: PROCEDURE create_mcd_recs(
104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 105: p_amount IN ar_cash_receipts.amount%TYPE,

101: );
102:
103: PROCEDURE create_mcd_recs(
104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

103: PROCEDURE create_mcd_recs(
104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

Line 108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

104: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
105: p_amount IN ar_cash_receipts.amount%TYPE,
106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE

Line 110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

106: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
113: );
114:

Line 111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,

107: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
113: );
114:
115:

Line 112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE

108: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
109: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
110: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
111: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
112: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
113: );
114:
115:
116: PROCEDURE update_manual_dist(

Line 117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

113: );
114:
115:
116: PROCEDURE update_manual_dist(
117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 118: p_amount IN ar_cash_receipts.amount%TYPE,

114:
115:
116: PROCEDURE update_manual_dist(
117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

116: PROCEDURE update_manual_dist(
117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
124: );

Line 121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

117: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
118: p_amount IN ar_cash_receipts.amount%TYPE,
119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
124: );
125:

Line 123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE

119: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
120: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
121: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
122: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
123: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
124: );
125:
126:
127: PROCEDURE rate_adjust(

Line 128: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

124: );
125:
126:
127: PROCEDURE rate_adjust(
128: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
129: p_rate_adjust_gl_date IN DATE,
130: p_new_exchange_date IN DATE,
131: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
132: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,