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,
36: p_called_from IN VARCHAR2 DEFAULT NULL -- Bug 66608534
37: );
38:
39: PROCEDURE insert_ra_rec_cash(
40: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
41: p_amount IN ar_cash_receipts.amount%TYPE,
42: p_apply_date IN DATE,
43: p_status IN ar_cash_receipts.status%TYPE,
44: p_acctd_amount IN
37: );
38:
39: PROCEDURE insert_ra_rec_cash(
40: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
41: p_amount IN ar_cash_receipts.amount%TYPE,
42: p_apply_date IN DATE,
43: p_status IN ar_cash_receipts.status%TYPE,
44: p_acctd_amount IN
45: ar_receivable_applications.acctd_amount_applied_from%TYPE,
39: PROCEDURE insert_ra_rec_cash(
40: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
41: p_amount IN ar_cash_receipts.amount%TYPE,
42: p_apply_date IN DATE,
43: p_status IN ar_cash_receipts.status%TYPE,
44: p_acctd_amount IN
45: ar_receivable_applications.acctd_amount_applied_from%TYPE,
46: p_gl_date IN DATE,
47: p_ccid IN
54: p_called_from IN VARCHAR2 DEFAULT NULL -- Bug 66608534
55: );
56:
57: PROCEDURE insert_dist_rec(
58: p_amount IN ar_cash_receipts.amount%TYPE,
59: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
60: p_crh_id IN
61: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
62: p_source_type IN ar_distributions.source_type%TYPE,
64: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
65: );
66:
67: PROCEDURE round_mcd_recs(
68: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
69: );
70:
71:
72: PROCEDURE insert_misc_dist(
69: );
70:
71:
72: PROCEDURE insert_misc_dist(
73: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
74: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
75: p_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
71:
72: PROCEDURE insert_misc_dist(
73: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
74: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
75: p_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
72: PROCEDURE insert_misc_dist(
73: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
74: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
75: p_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
73: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
74: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
75: p_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
81: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
75: p_amount IN ar_cash_receipts.amount%TYPE,
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
81: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
82: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
83: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
76: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
81: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
82: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
83: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
84: );
77: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
81: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
82: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
83: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
84: );
85:
78: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
79: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
80: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
81: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
82: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
83: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
84: );
85:
86:
84: );
85:
86:
87: PROCEDURE update_misc_dist(
88: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
89: p_amount IN ar_cash_receipts.amount%TYPE,
90: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
85:
86:
87: PROCEDURE update_misc_dist(
88: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
89: p_amount IN ar_cash_receipts.amount%TYPE,
90: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
88: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
89: p_amount IN ar_cash_receipts.amount%TYPE,
90: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
89: p_amount IN ar_cash_receipts.amount%TYPE,
90: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
90: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
91: p_amount_changed_flag IN BOOLEAN,
92: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
93: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
94: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
94: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
100: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
101: p_receipt_date_changed_flag IN BOOLEAN,
102: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
95: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
100: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
101: p_receipt_date_changed_flag IN BOOLEAN,
102: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
103: );
96: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
97: p_gl_date_changed_flag IN BOOLEAN,
98: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
99: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
100: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
101: p_receipt_date_changed_flag IN BOOLEAN,
102: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
103: );
104:
102: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
103: );
104:
105: PROCEDURE create_mcd_recs(
106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_amount IN ar_cash_receipts.amount%TYPE,
108: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
103: );
104:
105: PROCEDURE create_mcd_recs(
106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_amount IN ar_cash_receipts.amount%TYPE,
108: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
105: PROCEDURE create_mcd_recs(
106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_amount IN ar_cash_receipts.amount%TYPE,
108: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
112: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
113: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
106: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
107: p_amount IN ar_cash_receipts.amount%TYPE,
108: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
112: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
113: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
114: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
108: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
112: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
113: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
114: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
115: );
116:
109: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
112: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
113: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
114: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
115: );
116:
117:
110: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
111: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
112: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
113: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
114: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
115: );
116:
117:
118: PROCEDURE update_manual_dist(
115: );
116:
117:
118: PROCEDURE update_manual_dist(
119: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
120: p_amount IN ar_cash_receipts.amount%TYPE,
121: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
122: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
123: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
116:
117:
118: PROCEDURE update_manual_dist(
119: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
120: p_amount IN ar_cash_receipts.amount%TYPE,
121: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
122: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
123: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
124: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
118: PROCEDURE update_manual_dist(
119: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
120: p_amount IN ar_cash_receipts.amount%TYPE,
121: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
122: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
123: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
124: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
125: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
126: );
119: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
120: p_amount IN ar_cash_receipts.amount%TYPE,
121: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
122: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
123: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
124: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
125: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
126: );
127:
121: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
122: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
123: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
124: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
125: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
126: );
127:
128:
129: PROCEDURE rate_adjust(
126: );
127:
128:
129: PROCEDURE rate_adjust(
130: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
131: p_rate_adjust_gl_date IN DATE,
132: p_new_exchange_date IN DATE,
133: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
134: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,