1 PACKAGE ARP_PROC_RCT_UTIL AS
2 /* $Header: ARRURGWS.pls 120.9 2006/10/13 19:44:30 susivara ship $ */
3
4 /* ------------ Private procedures used by the package --------------------- */
5 /* ------------ ARP_PROCESS_RECEIPTS (ARRERGW?.pls) --------------------- */
6
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,
16 p_ps_id OUT NOCOPY
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,
26 p_acctd_factor_discount_amount IN
27 ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
28 p_gl_date IN DATE,
29 p_creation_status IN VARCHAR2,
30 p_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
31 p_ccid IN
32 ar_cash_receipt_history.account_code_combination_id%TYPE,
33 p_bank_charges_ccid IN
34 ar_cash_receipt_history.bank_charge_account_ccid%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
44 ar_receivable_applications.acctd_amount_applied_from%TYPE,
45 p_gl_date IN DATE,
46 p_ccid IN
47 ar_receivable_applications.code_combination_id%TYPE,
48 p_payment_schedule_id IN
49 ar_payment_schedules.payment_schedule_id%TYPE,
50 p_application_rule IN ar_receivable_applications.application_rule%TYPE,
51 p_reversal_gl_date IN DATE default null,
52 p_ra_id OUT NOCOPY ar_receivable_applications.receivable_application_id%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,
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(
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,
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
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,
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
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,
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(
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
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,
133 p_old_exchange_date IN DATE,
134 p_old_exchange_rate IN ar_rate_adjustments.old_exchange_rate%TYPE,
135 p_old_exchange_rate_type IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
136 p_gain_loss IN ar_rate_adjustments.gain_loss%TYPE,
137 p_exchange_rate_attr_cat IN ar_rate_adjustments.attribute_category%TYPE,
138 p_exchange_rate_attr1 IN ar_rate_adjustments.attribute1%TYPE,
139 p_exchange_rate_attr2 IN ar_rate_adjustments.attribute2%TYPE,
140 p_exchange_rate_attr3 IN ar_rate_adjustments.attribute3%TYPE,
141 p_exchange_rate_attr4 IN ar_rate_adjustments.attribute4%TYPE,
142 p_exchange_rate_attr5 IN ar_rate_adjustments.attribute5%TYPE,
143 p_exchange_rate_attr6 IN ar_rate_adjustments.attribute6%TYPE,
144 p_exchange_rate_attr7 IN ar_rate_adjustments.attribute7%TYPE,
145 p_exchange_rate_attr8 IN ar_rate_adjustments.attribute8%TYPE,
146 p_exchange_rate_attr9 IN ar_rate_adjustments.attribute9%TYPE,
147 p_exchange_rate_attr10 IN ar_rate_adjustments.attribute10%TYPE,
148 p_exchange_rate_attr11 IN ar_rate_adjustments.attribute11%TYPE,
149 p_exchange_rate_attr12 IN ar_rate_adjustments.attribute12%TYPE,
150 p_exchange_rate_attr13 IN ar_rate_adjustments.attribute13%TYPE,
151 p_exchange_rate_attr14 IN ar_rate_adjustments.attribute14%TYPE,
152 p_exchange_rate_attr15 IN ar_rate_adjustments.attribute15%TYPE);
153
154 PROCEDURE get_ccids(
155 p_receipt_method_id IN NUMBER,
156 p_remittance_bank_account_id IN NUMBER,
157 p_unidentified_ccid OUT NOCOPY NUMBER,
158 p_unapplied_ccid OUT NOCOPY NUMBER,
159 p_on_account_ccid OUT NOCOPY NUMBER,
160 p_earned_ccid OUT NOCOPY NUMBER,
161 p_unearned_ccid OUT NOCOPY NUMBER,
162 p_bank_charges_ccid OUT NOCOPY NUMBER,
163 p_factor_ccid OUT NOCOPY NUMBER,
164 p_confirmation_ccid OUT NOCOPY NUMBER,
165 p_remittance_ccid OUT NOCOPY NUMBER,
166 p_cash_ccid OUT NOCOPY NUMBER
167 );
168
169 PROCEDURE get_ps_rec( p_cash_receipt_id IN NUMBER,
170 p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE);
171
172 PROCEDURE update_dist_rec( p_crh_id IN NUMBER,
173 p_source_type IN ar_distributions.source_type%TYPE,
174 p_amount IN NUMBER,
175 p_acctd_amount IN NUMBER);
176
177 END ARP_PROC_RCT_UTIL;
[Home] [Help]