[Home] [Help]
PACKAGE: APPS.LNS_BILLING_BATCH_PUB_W
Source
1 package lns_billing_batch_pub_w AUTHID CURRENT_USER as
2 /* $Header: LNS_BILL_PUBJ_S.pls 120.5.12020000.2 2012/07/19 20:53:11 scherkas ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_300
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_VARCHAR2_TABLE_100
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_VARCHAR2_TABLE_100
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_NUMBER_TABLE
40 );
41 procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
42 , a1 out nocopy JTF_NUMBER_TABLE
43 , a2 out nocopy JTF_VARCHAR2_TABLE_100
44 , a3 out nocopy JTF_VARCHAR2_TABLE_300
45 , a4 out nocopy JTF_NUMBER_TABLE
46 , a5 out nocopy JTF_DATE_TABLE
47 , a6 out nocopy JTF_DATE_TABLE
48 , a7 out nocopy JTF_DATE_TABLE
49 , a8 out nocopy JTF_VARCHAR2_TABLE_100
50 , a9 out nocopy JTF_VARCHAR2_TABLE_100
51 , a10 out nocopy JTF_NUMBER_TABLE
52 , a11 out nocopy JTF_NUMBER_TABLE
53 , a12 out nocopy JTF_VARCHAR2_TABLE_100
54 , a13 out nocopy JTF_NUMBER_TABLE
55 , a14 out nocopy JTF_VARCHAR2_TABLE_100
56 , a15 out nocopy JTF_VARCHAR2_TABLE_100
57 , a16 out nocopy JTF_NUMBER_TABLE
58 , a17 out nocopy JTF_NUMBER_TABLE
59 , a18 out nocopy JTF_NUMBER_TABLE
60 , a19 out nocopy JTF_NUMBER_TABLE
61 , a20 out nocopy JTF_NUMBER_TABLE
62 , a21 out nocopy JTF_NUMBER_TABLE
63 , a22 out nocopy JTF_NUMBER_TABLE
64 , a23 out nocopy JTF_NUMBER_TABLE
65 , a24 out nocopy JTF_VARCHAR2_TABLE_100
66 , a25 out nocopy JTF_DATE_TABLE
67 , a26 out nocopy JTF_NUMBER_TABLE
68 , a27 out nocopy JTF_NUMBER_TABLE
69 , a28 out nocopy JTF_NUMBER_TABLE
70 , a29 out nocopy JTF_VARCHAR2_TABLE_100
71 , a30 out nocopy JTF_VARCHAR2_TABLE_100
72 , a31 out nocopy JTF_NUMBER_TABLE
73 , a32 out nocopy JTF_VARCHAR2_TABLE_100
74 , a33 out nocopy JTF_NUMBER_TABLE
75 , a34 out nocopy JTF_NUMBER_TABLE
76 , a35 out nocopy JTF_NUMBER_TABLE
77 , a36 out nocopy JTF_NUMBER_TABLE
78 );
79
80 procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
81 , a1 JTF_NUMBER_TABLE
82 , a2 JTF_NUMBER_TABLE
83 , a3 JTF_NUMBER_TABLE
84 , a4 JTF_VARCHAR2_TABLE_100
85 , a5 JTF_NUMBER_TABLE
86 , a6 JTF_NUMBER_TABLE
87 , a7 JTF_NUMBER_TABLE
88 );
89 procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
90 , a1 out nocopy JTF_NUMBER_TABLE
91 , a2 out nocopy JTF_NUMBER_TABLE
92 , a3 out nocopy JTF_NUMBER_TABLE
93 , a4 out nocopy JTF_VARCHAR2_TABLE_100
94 , a5 out nocopy JTF_NUMBER_TABLE
95 , a6 out nocopy JTF_NUMBER_TABLE
96 , a7 out nocopy JTF_NUMBER_TABLE
97 );
98
99 procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
100 , a1 JTF_NUMBER_TABLE
101 , a2 JTF_NUMBER_TABLE
102 , a3 JTF_DATE_TABLE
103 , a4 JTF_NUMBER_TABLE
104 , a5 JTF_NUMBER_TABLE
105 );
106 procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
107 , a1 out nocopy JTF_NUMBER_TABLE
108 , a2 out nocopy JTF_NUMBER_TABLE
109 , a3 out nocopy JTF_DATE_TABLE
110 , a4 out nocopy JTF_NUMBER_TABLE
111 , a5 out nocopy JTF_NUMBER_TABLE
112 );
113
114 procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
115 , a1 JTF_NUMBER_TABLE
116 , a2 JTF_NUMBER_TABLE
117 , a3 JTF_NUMBER_TABLE
118 , a4 JTF_NUMBER_TABLE
119 , a5 JTF_NUMBER_TABLE
120 , a6 JTF_NUMBER_TABLE
121 , a7 JTF_VARCHAR2_TABLE_100
122 , a8 JTF_VARCHAR2_TABLE_300
123 , a9 JTF_NUMBER_TABLE
124 , a10 JTF_NUMBER_TABLE
125 , a11 JTF_NUMBER_TABLE
126 , a12 JTF_NUMBER_TABLE
127 , a13 JTF_VARCHAR2_TABLE_2000
128 );
129 procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
130 , a1 out nocopy JTF_NUMBER_TABLE
131 , a2 out nocopy JTF_NUMBER_TABLE
132 , a3 out nocopy JTF_NUMBER_TABLE
133 , a4 out nocopy JTF_NUMBER_TABLE
134 , a5 out nocopy JTF_NUMBER_TABLE
135 , a6 out nocopy JTF_NUMBER_TABLE
136 , a7 out nocopy JTF_VARCHAR2_TABLE_100
137 , a8 out nocopy JTF_VARCHAR2_TABLE_300
138 , a9 out nocopy JTF_NUMBER_TABLE
139 , a10 out nocopy JTF_NUMBER_TABLE
140 , a11 out nocopy JTF_NUMBER_TABLE
141 , a12 out nocopy JTF_NUMBER_TABLE
142 , a13 out nocopy JTF_VARCHAR2_TABLE_2000
143 );
144
145 procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
146 , a1 JTF_NUMBER_TABLE
147 , a2 JTF_VARCHAR2_TABLE_100
148 , a3 JTF_NUMBER_TABLE
149 , a4 JTF_VARCHAR2_TABLE_100
150 , a5 JTF_NUMBER_TABLE
151 , a6 JTF_NUMBER_TABLE
152 , a7 JTF_NUMBER_TABLE
153 , a8 JTF_DATE_TABLE
154 , a9 JTF_DATE_TABLE
155 , a10 JTF_DATE_TABLE
156 , a11 JTF_VARCHAR2_TABLE_100
157 , a12 JTF_VARCHAR2_TABLE_100
158 , a13 JTF_VARCHAR2_TABLE_100
159 , a14 JTF_NUMBER_TABLE
160 );
161 procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
162 , a1 out nocopy JTF_NUMBER_TABLE
163 , a2 out nocopy JTF_VARCHAR2_TABLE_100
164 , a3 out nocopy JTF_NUMBER_TABLE
165 , a4 out nocopy JTF_VARCHAR2_TABLE_100
166 , a5 out nocopy JTF_NUMBER_TABLE
167 , a6 out nocopy JTF_NUMBER_TABLE
168 , a7 out nocopy JTF_NUMBER_TABLE
169 , a8 out nocopy JTF_DATE_TABLE
170 , a9 out nocopy JTF_DATE_TABLE
171 , a10 out nocopy JTF_DATE_TABLE
172 , a11 out nocopy JTF_VARCHAR2_TABLE_100
173 , a12 out nocopy JTF_VARCHAR2_TABLE_100
174 , a13 out nocopy JTF_VARCHAR2_TABLE_100
175 , a14 out nocopy JTF_NUMBER_TABLE
176 );
177
178 procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
179 , a1 JTF_NUMBER_TABLE
180 , a2 JTF_VARCHAR2_TABLE_100
181 , a3 JTF_NUMBER_TABLE
182 , a4 JTF_DATE_TABLE
183 , a5 JTF_VARCHAR2_TABLE_100
184 , a6 JTF_VARCHAR2_TABLE_100
185 , a7 JTF_VARCHAR2_TABLE_100
186 , a8 JTF_DATE_TABLE
187 , a9 JTF_DATE_TABLE
188 );
189 procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
190 , a1 out nocopy JTF_NUMBER_TABLE
191 , a2 out nocopy JTF_VARCHAR2_TABLE_100
192 , a3 out nocopy JTF_NUMBER_TABLE
193 , a4 out nocopy JTF_DATE_TABLE
194 , a5 out nocopy JTF_VARCHAR2_TABLE_100
195 , a6 out nocopy JTF_VARCHAR2_TABLE_100
196 , a7 out nocopy JTF_VARCHAR2_TABLE_100
197 , a8 out nocopy JTF_DATE_TABLE
198 , a9 out nocopy JTF_DATE_TABLE
199 );
200
201 procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE);
202 procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE);
203
204 procedure create_single_offcycle_bill(p_api_version NUMBER
205 , p_init_msg_list VARCHAR2
206 , p_commit VARCHAR2
207 , p_validation_level NUMBER
208 , p4_a0 NUMBER
209 , p4_a1 NUMBER
210 , p4_a2 NUMBER
211 , p4_a3 DATE
212 , p4_a4 NUMBER
213 , p4_a5 NUMBER
214 , p5_a0 JTF_NUMBER_TABLE
215 , p5_a1 JTF_NUMBER_TABLE
216 , p5_a2 JTF_NUMBER_TABLE
217 , p5_a3 JTF_NUMBER_TABLE
218 , p5_a4 JTF_NUMBER_TABLE
219 , p5_a5 JTF_NUMBER_TABLE
220 , p5_a6 JTF_NUMBER_TABLE
221 , p5_a7 JTF_VARCHAR2_TABLE_100
222 , p5_a8 JTF_VARCHAR2_TABLE_300
223 , p5_a9 JTF_NUMBER_TABLE
224 , p5_a10 JTF_NUMBER_TABLE
225 , p5_a11 JTF_NUMBER_TABLE
226 , p5_a12 JTF_NUMBER_TABLE
227 , p5_a13 JTF_VARCHAR2_TABLE_2000
228 , x_return_status out nocopy VARCHAR2
229 , x_msg_count out nocopy NUMBER
230 , x_msg_data out nocopy VARCHAR2
231 );
232 procedure create_offcycle_bills(p_api_version NUMBER
233 , p_init_msg_list VARCHAR2
234 , p_commit VARCHAR2
235 , p_validation_level NUMBER
236 , p4_a0 JTF_NUMBER_TABLE
237 , p4_a1 JTF_NUMBER_TABLE
238 , p4_a2 JTF_NUMBER_TABLE
239 , p4_a3 JTF_DATE_TABLE
240 , p4_a4 JTF_NUMBER_TABLE
241 , p4_a5 JTF_NUMBER_TABLE
242 , p5_a0 JTF_NUMBER_TABLE
243 , p5_a1 JTF_NUMBER_TABLE
244 , p5_a2 JTF_NUMBER_TABLE
245 , p5_a3 JTF_NUMBER_TABLE
246 , p5_a4 JTF_NUMBER_TABLE
247 , p5_a5 JTF_NUMBER_TABLE
248 , p5_a6 JTF_NUMBER_TABLE
249 , p5_a7 JTF_VARCHAR2_TABLE_100
250 , p5_a8 JTF_VARCHAR2_TABLE_300
251 , p5_a9 JTF_NUMBER_TABLE
252 , p5_a10 JTF_NUMBER_TABLE
253 , p5_a11 JTF_NUMBER_TABLE
254 , p5_a12 JTF_NUMBER_TABLE
255 , p5_a13 JTF_VARCHAR2_TABLE_2000
256 , x_return_status out nocopy VARCHAR2
257 , x_msg_count out nocopy NUMBER
258 , x_msg_data out nocopy VARCHAR2
259 );
260 procedure get_next_instal_to_bill(p_api_version NUMBER
261 , p_init_msg_list VARCHAR2
262 , p_commit VARCHAR2
263 , p_validation_level NUMBER
264 , p_loan_id NUMBER
265 , p5_a0 out nocopy JTF_NUMBER_TABLE
266 , p5_a1 out nocopy JTF_NUMBER_TABLE
267 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
268 , p5_a3 out nocopy JTF_NUMBER_TABLE
269 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
270 , p5_a5 out nocopy JTF_NUMBER_TABLE
271 , p5_a6 out nocopy JTF_NUMBER_TABLE
272 , p5_a7 out nocopy JTF_NUMBER_TABLE
273 , p5_a8 out nocopy JTF_DATE_TABLE
274 , p5_a9 out nocopy JTF_DATE_TABLE
275 , p5_a10 out nocopy JTF_DATE_TABLE
276 , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
277 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
278 , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
279 , p5_a14 out nocopy JTF_NUMBER_TABLE
280 , x_return_status out nocopy VARCHAR2
281 , x_msg_count out nocopy NUMBER
282 , x_msg_data out nocopy VARCHAR2
283 );
284 procedure bill_and_pay_next_instal(p_api_version NUMBER
285 , p_init_msg_list VARCHAR2
286 , p_commit VARCHAR2
287 , p_validation_level NUMBER
288 , p_loan_id NUMBER
289 , p5_a0 JTF_NUMBER_TABLE
290 , p5_a1 JTF_NUMBER_TABLE
291 , p5_a2 JTF_VARCHAR2_TABLE_100
292 , p5_a3 JTF_NUMBER_TABLE
293 , p5_a4 JTF_DATE_TABLE
294 , p5_a5 JTF_VARCHAR2_TABLE_100
295 , p5_a6 JTF_VARCHAR2_TABLE_100
296 , p5_a7 JTF_VARCHAR2_TABLE_100
297 , p5_a8 JTF_DATE_TABLE
298 , p5_a9 JTF_DATE_TABLE
299 , x_return_status out nocopy VARCHAR2
300 , x_msg_count out nocopy NUMBER
301 , x_msg_data out nocopy VARCHAR2
302 );
303 procedure pay_installments(p_api_version NUMBER
304 , p_init_msg_list VARCHAR2
305 , p_commit VARCHAR2
306 , p_validation_level NUMBER
307 , p_loan_id NUMBER
308 , p_am_sched_tbl JTF_NUMBER_TABLE
309 , p6_a0 JTF_NUMBER_TABLE
310 , p6_a1 JTF_NUMBER_TABLE
311 , p6_a2 JTF_VARCHAR2_TABLE_100
312 , p6_a3 JTF_NUMBER_TABLE
313 , p6_a4 JTF_DATE_TABLE
314 , p6_a5 JTF_VARCHAR2_TABLE_100
315 , p6_a6 JTF_VARCHAR2_TABLE_100
316 , p6_a7 JTF_VARCHAR2_TABLE_100
317 , p6_a8 JTF_DATE_TABLE
318 , p6_a9 JTF_DATE_TABLE
319 , x_return_status out nocopy VARCHAR2
320 , x_msg_count out nocopy NUMBER
321 , x_msg_data out nocopy VARCHAR2
322 );
323 procedure can_bill_next_instal(p_loan_id NUMBER
324 , ddrosetta_retval_bool OUT NOCOPY NUMBER
325 );
326 procedure get_billed_installment(p_api_version NUMBER
327 , p_init_msg_list VARCHAR2
328 , p_commit VARCHAR2
329 , p_validation_level NUMBER
330 , p_loan_id NUMBER
331 , p_am_sched_id NUMBER
332 , p6_a0 out nocopy JTF_NUMBER_TABLE
333 , p6_a1 out nocopy JTF_NUMBER_TABLE
334 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
335 , p6_a3 out nocopy JTF_NUMBER_TABLE
336 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
337 , p6_a5 out nocopy JTF_NUMBER_TABLE
338 , p6_a6 out nocopy JTF_NUMBER_TABLE
339 , p6_a7 out nocopy JTF_NUMBER_TABLE
340 , p6_a8 out nocopy JTF_DATE_TABLE
341 , p6_a9 out nocopy JTF_DATE_TABLE
342 , p6_a10 out nocopy JTF_DATE_TABLE
343 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
344 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
345 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
346 , p6_a14 out nocopy JTF_NUMBER_TABLE
347 , x_return_status out nocopy VARCHAR2
348 , x_msg_count out nocopy NUMBER
349 , x_msg_data out nocopy VARCHAR2
350 );
351 procedure bill_and_pay_offcycle_bills(p_api_version NUMBER
352 , p_init_msg_list VARCHAR2
353 , p_commit VARCHAR2
354 , p_validation_level NUMBER
355 , p_loan_id NUMBER
356 , p5_a0 JTF_NUMBER_TABLE
357 , p5_a1 JTF_NUMBER_TABLE
358 , p5_a2 JTF_NUMBER_TABLE
359 , p5_a3 JTF_DATE_TABLE
360 , p5_a4 JTF_NUMBER_TABLE
361 , p5_a5 JTF_NUMBER_TABLE
362 , p6_a0 JTF_NUMBER_TABLE
363 , p6_a1 JTF_NUMBER_TABLE
364 , p6_a2 JTF_NUMBER_TABLE
365 , p6_a3 JTF_NUMBER_TABLE
366 , p6_a4 JTF_NUMBER_TABLE
367 , p6_a5 JTF_NUMBER_TABLE
368 , p6_a6 JTF_NUMBER_TABLE
369 , p6_a7 JTF_VARCHAR2_TABLE_100
370 , p6_a8 JTF_VARCHAR2_TABLE_300
371 , p6_a9 JTF_NUMBER_TABLE
372 , p6_a10 JTF_NUMBER_TABLE
373 , p6_a11 JTF_NUMBER_TABLE
374 , p6_a12 JTF_NUMBER_TABLE
375 , p6_a13 JTF_VARCHAR2_TABLE_2000
376 , p7_a0 JTF_NUMBER_TABLE
377 , p7_a1 JTF_NUMBER_TABLE
378 , p7_a2 JTF_VARCHAR2_TABLE_100
379 , p7_a3 JTF_NUMBER_TABLE
380 , p7_a4 JTF_DATE_TABLE
381 , p7_a5 JTF_VARCHAR2_TABLE_100
382 , p7_a6 JTF_VARCHAR2_TABLE_100
383 , p7_a7 JTF_VARCHAR2_TABLE_100
384 , p7_a8 JTF_DATE_TABLE
385 , p7_a9 JTF_DATE_TABLE
386 , x_return_status out nocopy VARCHAR2
387 , x_msg_count out nocopy NUMBER
388 , x_msg_data out nocopy VARCHAR2
389 );
390 end lns_billing_batch_pub_w;