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,
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,
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
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,
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
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,
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(
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,
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,
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,
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,
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'
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: );
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:
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:
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,
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,
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,
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,
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,
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,
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
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: );
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:
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,
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,
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,
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
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:
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:
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(
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,
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,
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: );
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:
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(
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,