1 PACKAGE JL_AR_RECEIVABLE_APPLICATIONS AUTHID CURRENT_USER as
2 /* $Header: jlbrrras.pls 120.7 2005/10/30 02:05:13 appldev ship $ */
3
4
5 /*----------------------------------------------------------------------------*
6 | PRIVATE FUNCTIONS/PROCEDURES |
7 *----------------------------------------------------------------------------*/
8
9 PROCEDURE adjustment_generation ( x_user_id IN NUMBER,
10 x_rectrx_id IN NUMBER,
11 x_acc_id IN NUMBER,
12 x_amount IN NUMBER,
13 x_receipt_date IN DATE,
14 x_payment_schedule_id IN NUMBER,
15 x_cash_receipt_id IN NUMBER,
16 x_customer_trx_id IN NUMBER);
17
18 PROCEDURE get_accounts (x_rcpt_method_id IN NUMBER,
19 x_bank_acct_id IN NUMBER,
20 x_writeoff_tolerance IN OUT NOCOPY NUMBER,
21 x_writeoff_amount IN OUT NOCOPY NUMBER,
22 x_writeoff_ccid IN OUT NOCOPY NUMBER,
23 x_writeoff_rectrx_id IN OUT NOCOPY NUMBER,
24 x_calc_interest_ccid IN OUT NOCOPY NUMBER,
25 x_calc_interest_rectrx_id IN OUT NOCOPY NUMBER,
26 x_int_revenue_ccid IN OUT NOCOPY NUMBER,
27 x_int_revenue_rectrx_id IN OUT NOCOPY NUMBER,
28 x_return IN OUT NOCOPY NUMBER);
29
30 PROCEDURE get_ps_parameters(x_payment_schedule_id IN NUMBER,
31 x_amount_due_original IN OUT NOCOPY NUMBER,
32 x_amount_due_remaining IN OUT NOCOPY NUMBER,
33 x_return IN OUT NOCOPY NUMBER);
34
35 PROCEDURE calc_greaterthan_rec( x_writeoff_tolerance IN NUMBER,
36 x_writeoff_amount IN NUMBER,
37 x_calculated_interest IN NUMBER,
38 x_received_interest IN NUMBER,
39 x_payment_amount IN NUMBER,
40 x_rcpt_date IN DATE,
41 x_invoice_amount IN NUMBER,
42 x_payment_schedule_id IN NUMBER,
43 x_writeoff_ccid IN NUMBER,
44 x_writeoff_rectrx_id IN NUMBER,
45 x_calc_interest_ccid IN NUMBER,
46 x_calc_interest_rectrx_id IN NUMBER,
47 x_cash_receipt_id IN NUMBER,
48 x_trx_type_idm IN NUMBER,
49 x_batch_source_idm IN NUMBER,
50 x_receipt_method_idm IN NUMBER,
51 x_user_id IN NUMBER,
52 x_customer_trx_id IN NUMBER,
53 x_interest_difference_action IN VARCHAR2,
54 x_writeoff_date OUT NOCOPY VARCHAR2,
55 x_int_revenue_ccid IN NUMBER);
56
57 PROCEDURE calc_greaterthan_rec_tol( x_writeoff_tolerance IN NUMBER,
58 x_writeoff_amount IN NUMBER,
59 x_calculated_interest IN NUMBER,
60 x_received_interest IN NUMBER,
61 x_payment_amount IN NUMBER,
62 x_rcpt_date IN DATE,
63 x_invoice_amount IN NUMBER,
64 x_payment_schedule_id IN NUMBER,
65 x_writeoff_ccid IN NUMBER,
66 x_writeoff_rectrx_id IN NUMBER,
67 x_calc_interest_ccid IN NUMBER,
68 x_calc_interest_rectrx_id IN NUMBER,
69 x_cash_receipt_id IN NUMBER,
70 x_trx_type_idm IN NUMBER,
71 x_batch_source_idm IN NUMBER,
72 x_receipt_method_idm IN NUMBER,
73 x_user_id IN NUMBER,
74 x_customer_trx_id IN NUMBER,
75 x_writeoff_date OUT NOCOPY VARCHAR2,
76 x_int_revenue_ccid IN NUMBER);
77
78 PROCEDURE calc_lessthan_rec( x_writeoff_tolerance IN NUMBER,
79 x_writeoff_amount IN NUMBER,
80 x_calculated_interest IN NUMBER,
81 x_received_interest IN NUMBER,
82 x_payment_amount IN NUMBER,
83 x_rcpt_date IN DATE,
84 x_payment_schedule_id IN NUMBER,
85 x_int_revenue_ccid IN NUMBER,
86 x_int_revenue_rectrx_id IN NUMBER,
87 x_calc_interest_ccid IN NUMBER,
88 x_calc_interest_rectrx_id IN NUMBER,
89 x_cash_receipt_id IN NUMBER,
90 x_user_id IN NUMBER,
91 x_customer_trx_id IN NUMBER);
92
93 PROCEDURE calc_equal_rec( x_writeoff_tolerance IN NUMBER,
94 x_writeoff_amount IN NUMBER,
95 x_calculated_interest IN NUMBER,
96 x_received_interest IN NUMBER,
97 x_payment_amount IN NUMBER,
98 x_rcpt_date IN DATE,
99 x_payment_schedule_id IN NUMBER,
100 x_int_revenue_ccid IN NUMBER,
101 x_int_revenue_rectrx_id IN NUMBER,
102 x_calc_interest_ccid IN NUMBER,
103 x_calc_interest_rectrx_id IN NUMBER,
104 x_cash_receipt_id IN NUMBER,
105 x_user_id IN NUMBER,
106 x_customer_trx_id IN NUMBER);
107
108 PROCEDURE interest_treatment (
109 x_payment_schedule_id IN NUMBER,
110 x_customer_trx_id IN NUMBER,
111 x_payment_amount IN NUMBER,
112 x_due_date IN DATE,
113 x_calc_interest IN VARCHAR2,
114 x_rec_interest IN VARCHAR2,
115 x_main_amount_received IN VARCHAR2,
116 x_base_interest_calc IN VARCHAR2,
117 x_interest_payment_date IN VARCHAR2,
118 x_interest_diff_action VARCHAR2,
119 x_cash_receipt_id IN NUMBER,
120 x_rcpt_date IN DATE,
121 x_rcpt_method_id IN NUMBER,
122 x_trx_type_idm IN NUMBER,
123 x_batch_source_idm IN NUMBER,
124 x_receipt_method_idm IN NUMBER,
125 x_user_id IN NUMBER,
126 x_remit_bank_acct_id IN NUMBER,
127 x_writeoff_date OUT NOCOPY VARCHAR2);
128
129 PROCEDURE Apply_br(p_apply_before_after IN VARCHAR2 ,
130 p_global_attribute_category IN VARCHAR2 ,
131 p_set_of_books_id IN NUMBER ,
132 p_cash_receipt_id IN VARCHAR2 ,
133 p_receipt_date IN DATE ,
134 p_applied_payment_schedule_id IN NUMBER ,
135 p_amount_applied IN NUMBER ,
136 p_unapplied_amount IN NUMBER ,
137 p_due_date IN DATE ,
138 p_receipt_method_id IN NUMBER ,
139 p_remittance_bank_account_id IN NUMBER ,
140 p_global_attribute1 IN OUT NOCOPY VARCHAR2 ,
141 p_global_attribute2 IN OUT NOCOPY VARCHAR2 ,
142 p_global_attribute3 IN OUT NOCOPY VARCHAR2 ,
143 p_global_attribute4 IN OUT NOCOPY VARCHAR2 ,
144 p_global_attribute5 IN OUT NOCOPY VARCHAR2 ,
145 p_global_attribute6 IN OUT NOCOPY VARCHAR2 ,
146 p_global_attribute7 IN OUT NOCOPY VARCHAR2 ,
147 p_global_attribute8 IN OUT NOCOPY VARCHAR2 ,
148 p_global_attribute9 IN OUT NOCOPY VARCHAR2 ,
149 p_global_attribute10 IN OUT NOCOPY VARCHAR2 ,
150 p_global_attribute11 IN OUT NOCOPY VARCHAR2 ,
151 p_global_attribute12 IN OUT NOCOPY VARCHAR2 ,
152 p_global_attribute13 IN OUT NOCOPY VARCHAR2 ,
153 p_global_attribute14 IN OUT NOCOPY VARCHAR2 ,
154 p_global_attribute15 IN OUT NOCOPY VARCHAR2 ,
155 p_global_attribute16 IN OUT NOCOPY VARCHAR2 ,
156 p_global_attribute17 IN OUT NOCOPY VARCHAR2 ,
157 p_global_attribute18 IN OUT NOCOPY VARCHAR2 ,
158 p_global_attribute19 IN OUT NOCOPY VARCHAR2 ,
159 p_global_attribute20 IN OUT NOCOPY VARCHAR2 ,
160 p_return_status OUT NOCOPY VARCHAR2);
161
162 PROCEDURE Unapply_br(
163 p_cash_receipt_id IN VARCHAR2 ,
164 p_applied_payment_schedule_id IN NUMBER ,
165 p_return_status OUT NOCOPY VARCHAR2);
166
167 PROCEDURE Reverse_br(
168 p_cash_receipt_id IN NUMBER,
169 p_return_status OUT NOCOPY VARCHAR2);
170
171 /*----------------------------------------------------------------------------*
172 | PUBLIC FUNCTIONS/PROCEDURES |
173 *----------------------------------------------------------------------------*/
174
175 PROCEDURE Apply(p_apply_before_after IN VARCHAR2 ,
176 p_global_attribute_category IN VARCHAR2 ,
177 p_set_of_books_id IN NUMBER ,
178 p_cash_receipt_id IN VARCHAR2 ,
179 p_receipt_date IN DATE ,
180 p_applied_payment_schedule_id IN NUMBER ,
181 p_amount_applied IN NUMBER ,
182 p_unapplied_amount IN NUMBER ,
183 p_due_date IN DATE ,
184 p_receipt_method_id IN NUMBER ,
185 p_remittance_bank_account_id IN NUMBER ,
186 p_global_attribute1 IN OUT NOCOPY VARCHAR2 ,
187 p_global_attribute2 IN OUT NOCOPY VARCHAR2 ,
188 p_global_attribute3 IN OUT NOCOPY VARCHAR2 ,
189 p_global_attribute4 IN OUT NOCOPY VARCHAR2 ,
190 p_global_attribute5 IN OUT NOCOPY VARCHAR2 ,
191 p_global_attribute6 IN OUT NOCOPY VARCHAR2 ,
192 p_global_attribute7 IN OUT NOCOPY VARCHAR2 ,
193 p_global_attribute8 IN OUT NOCOPY VARCHAR2 ,
194 p_global_attribute9 IN OUT NOCOPY VARCHAR2 ,
195 p_global_attribute10 IN OUT NOCOPY VARCHAR2 ,
196 p_global_attribute11 IN OUT NOCOPY VARCHAR2 ,
197 p_global_attribute12 IN OUT NOCOPY VARCHAR2 ,
198 p_global_attribute13 IN OUT NOCOPY VARCHAR2 ,
199 p_global_attribute14 IN OUT NOCOPY VARCHAR2 ,
200 p_global_attribute15 IN OUT NOCOPY VARCHAR2 ,
201 p_global_attribute16 IN OUT NOCOPY VARCHAR2 ,
205 p_global_attribute20 IN OUT NOCOPY VARCHAR2 ,
202 p_global_attribute17 IN OUT NOCOPY VARCHAR2 ,
203 p_global_attribute18 IN OUT NOCOPY VARCHAR2 ,
204 p_global_attribute19 IN OUT NOCOPY VARCHAR2 ,
206 p_return_status OUT NOCOPY VARCHAR2);
207
208 PROCEDURE Unapply(
209 p_cash_receipt_id IN VARCHAR2 ,
210 p_applied_payment_schedule_id IN NUMBER ,
211 p_return_status OUT NOCOPY VARCHAR2);
212
213 PROCEDURE Reverse(
214 p_cash_receipt_id IN NUMBER,
215 p_return_status OUT NOCOPY VARCHAR2);
216
217
218 PROCEDURE create_interest_adjustment(
219 p_post_quickcash_req_id IN NUMBER,
220 x_return_status OUT NOCOPY VARCHAR2);
221
222 PROCEDURE delete_interest_adjustment(
223 p_cash_receipt_id IN NUMBER,
224 x_return_status OUT NOCOPY VARCHAR2);
225
226 END JL_AR_RECEIVABLE_APPLICATIONS;