[Home] [Help]
PACKAGE: APPS.LNS_FINANCIALS_W
Source
1 package lns_financials_w AUTHID CURRENT_USER as
2 /* $Header: LNS_FINANCIALJ_S.pls 120.13.12020000.2 2012/07/19 20:56:23 scherkas ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 );
14 procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15 , a1 out nocopy JTF_DATE_TABLE
16 , a2 out nocopy JTF_DATE_TABLE
17 , a3 out nocopy JTF_NUMBER_TABLE
18 , a4 out nocopy JTF_NUMBER_TABLE
19 , a5 out nocopy JTF_NUMBER_TABLE
20 , a6 out nocopy JTF_NUMBER_TABLE
21 , a7 out nocopy JTF_VARCHAR2_TABLE_100
22 , a8 out nocopy JTF_VARCHAR2_TABLE_100
23 , a9 out nocopy JTF_VARCHAR2_TABLE_100
24 );
25
26 procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
27 , a1 JTF_DATE_TABLE
28 , a2 JTF_DATE_TABLE
29 , a3 JTF_DATE_TABLE
30 , a4 JTF_NUMBER_TABLE
31 , a5 JTF_NUMBER_TABLE
32 , a6 JTF_NUMBER_TABLE
33 , a7 JTF_NUMBER_TABLE
34 , a8 JTF_NUMBER_TABLE
35 , a9 JTF_NUMBER_TABLE
36 , a10 JTF_NUMBER_TABLE
37 , a11 JTF_NUMBER_TABLE
38 , a12 JTF_NUMBER_TABLE
39 , a13 JTF_NUMBER_TABLE
40 , a14 JTF_NUMBER_TABLE
41 , a15 JTF_NUMBER_TABLE
42 , a16 JTF_NUMBER_TABLE
43 , a17 JTF_NUMBER_TABLE
44 , a18 JTF_NUMBER_TABLE
45 , a19 JTF_NUMBER_TABLE
46 , a20 JTF_NUMBER_TABLE
47 , a21 JTF_VARCHAR2_TABLE_100
48 , a22 JTF_VARCHAR2_TABLE_100
49 , a23 JTF_VARCHAR2_TABLE_100
50 , a24 JTF_NUMBER_TABLE
51 , a25 JTF_NUMBER_TABLE
52 , a26 JTF_NUMBER_TABLE
53 , a27 JTF_NUMBER_TABLE
54 , a28 JTF_VARCHAR2_TABLE_2000
55 , a29 JTF_VARCHAR2_TABLE_2000
56 , a30 JTF_VARCHAR2_TABLE_2000
57 , a31 JTF_VARCHAR2_TABLE_2000
58 , a32 JTF_NUMBER_TABLE
59 , a33 JTF_VARCHAR2_TABLE_200
60 , a34 JTF_NUMBER_TABLE
61 , a35 JTF_NUMBER_TABLE
62 , a36 JTF_VARCHAR2_TABLE_2000
63 , a37 JTF_NUMBER_TABLE
64 , a38 JTF_NUMBER_TABLE
65 , a39 JTF_NUMBER_TABLE
66 , a40 JTF_VARCHAR2_TABLE_2000
67 , a41 JTF_NUMBER_TABLE
68 , a42 JTF_VARCHAR2_TABLE_2000
69 );
70 procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
71 , a1 out nocopy JTF_DATE_TABLE
72 , a2 out nocopy JTF_DATE_TABLE
73 , a3 out nocopy JTF_DATE_TABLE
74 , a4 out nocopy JTF_NUMBER_TABLE
75 , a5 out nocopy JTF_NUMBER_TABLE
76 , a6 out nocopy JTF_NUMBER_TABLE
77 , a7 out nocopy JTF_NUMBER_TABLE
78 , a8 out nocopy JTF_NUMBER_TABLE
79 , a9 out nocopy JTF_NUMBER_TABLE
80 , a10 out nocopy JTF_NUMBER_TABLE
81 , a11 out nocopy JTF_NUMBER_TABLE
82 , a12 out nocopy JTF_NUMBER_TABLE
83 , a13 out nocopy JTF_NUMBER_TABLE
84 , a14 out nocopy JTF_NUMBER_TABLE
85 , a15 out nocopy JTF_NUMBER_TABLE
86 , a16 out nocopy JTF_NUMBER_TABLE
87 , a17 out nocopy JTF_NUMBER_TABLE
88 , a18 out nocopy JTF_NUMBER_TABLE
89 , a19 out nocopy JTF_NUMBER_TABLE
90 , a20 out nocopy JTF_NUMBER_TABLE
91 , a21 out nocopy JTF_VARCHAR2_TABLE_100
92 , a22 out nocopy JTF_VARCHAR2_TABLE_100
93 , a23 out nocopy JTF_VARCHAR2_TABLE_100
94 , a24 out nocopy JTF_NUMBER_TABLE
95 , a25 out nocopy JTF_NUMBER_TABLE
96 , a26 out nocopy JTF_NUMBER_TABLE
97 , a27 out nocopy JTF_NUMBER_TABLE
98 , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99 , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100 , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101 , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102 , a32 out nocopy JTF_NUMBER_TABLE
103 , a33 out nocopy JTF_VARCHAR2_TABLE_200
104 , a34 out nocopy JTF_NUMBER_TABLE
105 , a35 out nocopy JTF_NUMBER_TABLE
106 , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107 , a37 out nocopy JTF_NUMBER_TABLE
108 , a38 out nocopy JTF_NUMBER_TABLE
109 , a39 out nocopy JTF_NUMBER_TABLE
110 , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111 , a41 out nocopy JTF_NUMBER_TABLE
112 , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113 );
114
115 procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116 , a1 JTF_NUMBER_TABLE
117 , a2 JTF_NUMBER_TABLE
118 , a3 JTF_NUMBER_TABLE
119 , a4 JTF_NUMBER_TABLE
120 , a5 JTF_NUMBER_TABLE
121 , a6 JTF_NUMBER_TABLE
122 , a7 JTF_NUMBER_TABLE
123 , a8 JTF_NUMBER_TABLE
124 , a9 JTF_DATE_TABLE
125 );
126 procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127 , a1 out nocopy JTF_NUMBER_TABLE
128 , a2 out nocopy JTF_NUMBER_TABLE
129 , a3 out nocopy JTF_NUMBER_TABLE
130 , a4 out nocopy JTF_NUMBER_TABLE
131 , a5 out nocopy JTF_NUMBER_TABLE
132 , a6 out nocopy JTF_NUMBER_TABLE
133 , a7 out nocopy JTF_NUMBER_TABLE
134 , a8 out nocopy JTF_NUMBER_TABLE
135 , a9 out nocopy JTF_DATE_TABLE
136 );
137
138 procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139 , a1 JTF_NUMBER_TABLE
140 , a2 JTF_NUMBER_TABLE
141 , a3 JTF_NUMBER_TABLE
142 );
143 procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144 , a1 out nocopy JTF_NUMBER_TABLE
145 , a2 out nocopy JTF_NUMBER_TABLE
146 , a3 out nocopy JTF_NUMBER_TABLE
147 );
148
149 procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
150 , a1 JTF_NUMBER_TABLE
151 , a2 JTF_NUMBER_TABLE
152 , a3 JTF_NUMBER_TABLE
153 );
154 procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155 , a1 out nocopy JTF_NUMBER_TABLE
156 , a2 out nocopy JTF_NUMBER_TABLE
157 , a3 out nocopy JTF_NUMBER_TABLE
158 );
159
160 procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
161 , a1 JTF_DATE_TABLE
162 );
163 procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
164 , a1 out nocopy JTF_DATE_TABLE
165 );
166
167 procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
168 procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
169
170 procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171 procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172
173 procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174 procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175
176 procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177 , a1 JTF_VARCHAR2_TABLE_100
178 , a2 JTF_NUMBER_TABLE
179 , a3 JTF_NUMBER_TABLE
180 , a4 JTF_VARCHAR2_TABLE_300
181 , a5 JTF_NUMBER_TABLE
182 , a6 JTF_VARCHAR2_TABLE_100
183 , a7 JTF_NUMBER_TABLE
184 , a8 JTF_VARCHAR2_TABLE_100
185 , a9 JTF_VARCHAR2_TABLE_100
186 );
187 procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188 , a1 out nocopy JTF_VARCHAR2_TABLE_100
189 , a2 out nocopy JTF_NUMBER_TABLE
190 , a3 out nocopy JTF_NUMBER_TABLE
191 , a4 out nocopy JTF_VARCHAR2_TABLE_300
192 , a5 out nocopy JTF_NUMBER_TABLE
193 , a6 out nocopy JTF_VARCHAR2_TABLE_100
194 , a7 out nocopy JTF_NUMBER_TABLE
195 , a8 out nocopy JTF_VARCHAR2_TABLE_100
196 , a9 out nocopy JTF_VARCHAR2_TABLE_100
197 );
198
199 procedure shiftloandates(p_loan_id NUMBER
200 , p_new_start_date DATE
201 , p_phase VARCHAR2
202 , p3_a0 out nocopy NUMBER
203 , p3_a1 out nocopy NUMBER
204 , p3_a2 out nocopy VARCHAR2
205 , p3_a3 out nocopy NUMBER
206 , p3_a4 out nocopy VARCHAR2
207 , p3_a5 out nocopy VARCHAR2
208 , p3_a6 out nocopy VARCHAR2
209 , p3_a7 out nocopy DATE
210 , p3_a8 out nocopy DATE
211 , p3_a9 out nocopy NUMBER
212 , p3_a10 out nocopy NUMBER
213 , p3_a11 out nocopy NUMBER
214 , p3_a12 out nocopy NUMBER
215 , p3_a13 out nocopy NUMBER
216 , p3_a14 out nocopy NUMBER
217 , p3_a15 out nocopy NUMBER
218 , p3_a16 out nocopy NUMBER
219 , p3_a17 out nocopy NUMBER
220 , p3_a18 out nocopy NUMBER
221 , p3_a19 out nocopy DATE
222 , p3_a20 out nocopy NUMBER
223 , p3_a21 out nocopy NUMBER
224 , p3_a22 out nocopy VARCHAR2
225 , p3_a23 out nocopy VARCHAR2
226 , p3_a24 out nocopy VARCHAR2
227 , p3_a25 out nocopy NUMBER
228 , p3_a26 out nocopy NUMBER
229 , p3_a27 out nocopy NUMBER
230 , p3_a28 out nocopy NUMBER
231 , p3_a29 out nocopy VARCHAR2
232 , p3_a30 out nocopy VARCHAR2
233 , p3_a31 out nocopy NUMBER
234 , p3_a32 out nocopy VARCHAR2
235 , p3_a33 out nocopy VARCHAR2
236 , p3_a34 out nocopy DATE
237 , p3_a35 out nocopy VARCHAR2
238 , p3_a36 out nocopy DATE
239 , p3_a37 out nocopy VARCHAR2
240 , p3_a38 out nocopy NUMBER
241 , p3_a39 out nocopy NUMBER
242 , p3_a40 out nocopy VARCHAR2
243 , p3_a41 out nocopy VARCHAR2
244 , p3_a42 out nocopy DATE
245 , p3_a43 out nocopy DATE
246 , p3_a44 out nocopy DATE
247 , p3_a45 out nocopy VARCHAR2
248 , p3_a46 out nocopy VARCHAR2
249 , p3_a47 out nocopy NUMBER
250 , p3_a48 out nocopy NUMBER
251 , p3_a49 out nocopy VARCHAR2
252 , p3_a50 out nocopy VARCHAR2
253 , p3_a51 out nocopy NUMBER
254 , p3_a52 out nocopy DATE
255 , p3_a53 out nocopy NUMBER
256 , p3_a54 out nocopy NUMBER
257 , p3_a55 out nocopy NUMBER
258 , p3_a56 out nocopy NUMBER
259 , p3_a57 out nocopy NUMBER
260 , p3_a58 out nocopy VARCHAR2
261 , p3_a59 out nocopy NUMBER
262 , p3_a60 out nocopy DATE
263 , p3_a61 out nocopy NUMBER
264 , p3_a62 out nocopy NUMBER
265 , p3_a63 out nocopy NUMBER
266 , p3_a64 out nocopy NUMBER
267 , p3_a65 out nocopy NUMBER
268 , p3_a66 out nocopy VARCHAR2
269 , p3_a67 out nocopy VARCHAR2
270 , p3_a68 out nocopy VARCHAR2
271 , p3_a69 out nocopy VARCHAR2
272 , p3_a70 out nocopy NUMBER
273 , p3_a71 out nocopy NUMBER
274 , p3_a72 out nocopy NUMBER
275 , p3_a73 out nocopy NUMBER
276 , p3_a74 out nocopy DATE
277 , p3_a75 out nocopy DATE
278 , p3_a76 out nocopy VARCHAR2
279 , p3_a77 out nocopy VARCHAR2
280 , p3_a78 out nocopy VARCHAR2
281 , p3_a79 out nocopy VARCHAR2
282 , p3_a80 out nocopy DATE
283 , p3_a81 out nocopy VARCHAR2
284 , p3_a82 out nocopy NUMBER
285 , p3_a83 out nocopy NUMBER
286 , p3_a84 out nocopy VARCHAR2
287 , p3_a85 out nocopy NUMBER
288 , p3_a86 out nocopy NUMBER
289 , p3_a87 out nocopy NUMBER
290 , p3_a88 out nocopy NUMBER
291 , p3_a89 out nocopy NUMBER
292 , p3_a90 out nocopy VARCHAR2
293 , p3_a91 out nocopy NUMBER
294 , p3_a92 out nocopy VARCHAR2
295 , p3_a93 out nocopy VARCHAR2
296 , p3_a94 out nocopy VARCHAR2
297 , p3_a95 out nocopy VARCHAR2
298 , x_dates_shifted_flag out nocopy VARCHAR2
299 , x_return_status out nocopy VARCHAR2
300 , x_msg_count out nocopy NUMBER
301 , x_msg_data out nocopy VARCHAR2
302 );
303 procedure validatepayoff(p0_a0 NUMBER
304 , p0_a1 NUMBER
305 , p0_a2 VARCHAR2
306 , p0_a3 NUMBER
307 , p0_a4 VARCHAR2
308 , p0_a5 VARCHAR2
309 , p0_a6 VARCHAR2
310 , p0_a7 DATE
311 , p0_a8 DATE
312 , p0_a9 NUMBER
313 , p0_a10 NUMBER
314 , p0_a11 NUMBER
315 , p0_a12 NUMBER
316 , p0_a13 NUMBER
317 , p0_a14 NUMBER
318 , p0_a15 NUMBER
319 , p0_a16 NUMBER
320 , p0_a17 NUMBER
321 , p0_a18 NUMBER
322 , p0_a19 DATE
323 , p0_a20 NUMBER
324 , p0_a21 NUMBER
325 , p0_a22 VARCHAR2
326 , p0_a23 VARCHAR2
327 , p0_a24 VARCHAR2
328 , p0_a25 NUMBER
329 , p0_a26 NUMBER
330 , p0_a27 NUMBER
331 , p0_a28 NUMBER
332 , p0_a29 VARCHAR2
333 , p0_a30 VARCHAR2
334 , p0_a31 NUMBER
335 , p0_a32 VARCHAR2
336 , p0_a33 VARCHAR2
337 , p0_a34 DATE
338 , p0_a35 VARCHAR2
339 , p0_a36 DATE
340 , p0_a37 VARCHAR2
341 , p0_a38 NUMBER
342 , p0_a39 NUMBER
343 , p0_a40 VARCHAR2
344 , p0_a41 VARCHAR2
345 , p0_a42 DATE
346 , p0_a43 DATE
347 , p0_a44 DATE
348 , p0_a45 VARCHAR2
349 , p0_a46 VARCHAR2
350 , p0_a47 NUMBER
351 , p0_a48 NUMBER
352 , p0_a49 VARCHAR2
353 , p0_a50 VARCHAR2
354 , p0_a51 NUMBER
355 , p0_a52 DATE
356 , p0_a53 NUMBER
357 , p0_a54 NUMBER
358 , p0_a55 NUMBER
359 , p0_a56 NUMBER
360 , p0_a57 NUMBER
361 , p0_a58 VARCHAR2
362 , p0_a59 NUMBER
363 , p0_a60 DATE
364 , p0_a61 NUMBER
365 , p0_a62 NUMBER
366 , p0_a63 NUMBER
367 , p0_a64 NUMBER
368 , p0_a65 NUMBER
369 , p0_a66 VARCHAR2
370 , p0_a67 VARCHAR2
371 , p0_a68 VARCHAR2
372 , p0_a69 VARCHAR2
373 , p0_a70 NUMBER
374 , p0_a71 NUMBER
375 , p0_a72 NUMBER
376 , p0_a73 NUMBER
377 , p0_a74 DATE
378 , p0_a75 DATE
379 , p0_a76 VARCHAR2
380 , p0_a77 VARCHAR2
381 , p0_a78 VARCHAR2
382 , p0_a79 VARCHAR2
383 , p0_a80 DATE
384 , p0_a81 VARCHAR2
385 , p0_a82 NUMBER
386 , p0_a83 NUMBER
387 , p0_a84 VARCHAR2
388 , p0_a85 NUMBER
389 , p0_a86 NUMBER
390 , p0_a87 NUMBER
391 , p0_a88 NUMBER
392 , p0_a89 NUMBER
393 , p0_a90 VARCHAR2
394 , p0_a91 NUMBER
395 , p0_a92 VARCHAR2
396 , p0_a93 VARCHAR2
397 , p0_a94 VARCHAR2
398 , p0_a95 VARCHAR2
399 , p_payoff_date DATE
400 , x_return_status out nocopy VARCHAR2
401 , x_msg_count out nocopy NUMBER
402 , x_msg_data out nocopy VARCHAR2
403 );
404 procedure calculatepayoff(p_api_version NUMBER
405 , p_init_msg_list VARCHAR2
406 , p_loan_id NUMBER
407 , p_payoff_date DATE
408 , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409 , p4_a1 out nocopy JTF_NUMBER_TABLE
410 , p4_a2 out nocopy JTF_NUMBER_TABLE
411 , p4_a3 out nocopy JTF_NUMBER_TABLE
412 , x_return_status out nocopy VARCHAR2
413 , x_msg_count out nocopy NUMBER
414 , x_msg_data out nocopy VARCHAR2
415 );
416 function getweightedrate(p0_a0 NUMBER
417 , p0_a1 NUMBER
418 , p0_a2 VARCHAR2
419 , p0_a3 NUMBER
420 , p0_a4 VARCHAR2
421 , p0_a5 VARCHAR2
422 , p0_a6 VARCHAR2
423 , p0_a7 DATE
424 , p0_a8 DATE
425 , p0_a9 NUMBER
426 , p0_a10 NUMBER
427 , p0_a11 NUMBER
428 , p0_a12 NUMBER
429 , p0_a13 NUMBER
430 , p0_a14 NUMBER
431 , p0_a15 NUMBER
432 , p0_a16 NUMBER
433 , p0_a17 NUMBER
434 , p0_a18 NUMBER
435 , p0_a19 DATE
436 , p0_a20 NUMBER
437 , p0_a21 NUMBER
438 , p0_a22 VARCHAR2
439 , p0_a23 VARCHAR2
440 , p0_a24 VARCHAR2
441 , p0_a25 NUMBER
442 , p0_a26 NUMBER
443 , p0_a27 NUMBER
444 , p0_a28 NUMBER
445 , p0_a29 VARCHAR2
446 , p0_a30 VARCHAR2
447 , p0_a31 NUMBER
448 , p0_a32 VARCHAR2
449 , p0_a33 VARCHAR2
450 , p0_a34 DATE
451 , p0_a35 VARCHAR2
452 , p0_a36 DATE
453 , p0_a37 VARCHAR2
454 , p0_a38 NUMBER
455 , p0_a39 NUMBER
456 , p0_a40 VARCHAR2
457 , p0_a41 VARCHAR2
458 , p0_a42 DATE
459 , p0_a43 DATE
460 , p0_a44 DATE
461 , p0_a45 VARCHAR2
462 , p0_a46 VARCHAR2
463 , p0_a47 NUMBER
464 , p0_a48 NUMBER
465 , p0_a49 VARCHAR2
466 , p0_a50 VARCHAR2
467 , p0_a51 NUMBER
468 , p0_a52 DATE
469 , p0_a53 NUMBER
470 , p0_a54 NUMBER
471 , p0_a55 NUMBER
472 , p0_a56 NUMBER
473 , p0_a57 NUMBER
474 , p0_a58 VARCHAR2
475 , p0_a59 NUMBER
476 , p0_a60 DATE
477 , p0_a61 NUMBER
478 , p0_a62 NUMBER
479 , p0_a63 NUMBER
480 , p0_a64 NUMBER
481 , p0_a65 NUMBER
482 , p0_a66 VARCHAR2
483 , p0_a67 VARCHAR2
484 , p0_a68 VARCHAR2
485 , p0_a69 VARCHAR2
486 , p0_a70 NUMBER
487 , p0_a71 NUMBER
488 , p0_a72 NUMBER
489 , p0_a73 NUMBER
490 , p0_a74 DATE
491 , p0_a75 DATE
492 , p0_a76 VARCHAR2
493 , p0_a77 VARCHAR2
494 , p0_a78 VARCHAR2
495 , p0_a79 VARCHAR2
496 , p0_a80 DATE
497 , p0_a81 VARCHAR2
498 , p0_a82 NUMBER
499 , p0_a83 NUMBER
500 , p0_a84 VARCHAR2
501 , p0_a85 NUMBER
502 , p0_a86 NUMBER
503 , p0_a87 NUMBER
504 , p0_a88 NUMBER
505 , p0_a89 NUMBER
506 , p0_a90 VARCHAR2
507 , p0_a91 NUMBER
508 , p0_a92 VARCHAR2
509 , p0_a93 VARCHAR2
510 , p0_a94 VARCHAR2
511 , p0_a95 VARCHAR2
512 , p_start_date DATE
513 , p_end_date DATE
514 , p3_a0 JTF_NUMBER_TABLE
515 , p3_a1 JTF_DATE_TABLE
516 , p3_a2 JTF_DATE_TABLE
517 , p3_a3 JTF_NUMBER_TABLE
518 , p3_a4 JTF_NUMBER_TABLE
519 , p3_a5 JTF_NUMBER_TABLE
520 , p3_a6 JTF_NUMBER_TABLE
521 , p3_a7 JTF_VARCHAR2_TABLE_100
522 , p3_a8 JTF_VARCHAR2_TABLE_100
523 , p3_a9 JTF_VARCHAR2_TABLE_100
524 ) return number;
525 procedure amortizeeploan(p0_a0 NUMBER
526 , p0_a1 NUMBER
527 , p0_a2 VARCHAR2
528 , p0_a3 NUMBER
529 , p0_a4 VARCHAR2
530 , p0_a5 VARCHAR2
531 , p0_a6 VARCHAR2
532 , p0_a7 DATE
533 , p0_a8 DATE
534 , p0_a9 NUMBER
535 , p0_a10 NUMBER
536 , p0_a11 NUMBER
537 , p0_a12 NUMBER
538 , p0_a13 NUMBER
539 , p0_a14 NUMBER
540 , p0_a15 NUMBER
541 , p0_a16 NUMBER
542 , p0_a17 NUMBER
543 , p0_a18 NUMBER
544 , p0_a19 DATE
545 , p0_a20 NUMBER
546 , p0_a21 NUMBER
547 , p0_a22 VARCHAR2
548 , p0_a23 VARCHAR2
549 , p0_a24 VARCHAR2
550 , p0_a25 NUMBER
551 , p0_a26 NUMBER
552 , p0_a27 NUMBER
553 , p0_a28 NUMBER
554 , p0_a29 VARCHAR2
555 , p0_a30 VARCHAR2
556 , p0_a31 NUMBER
557 , p0_a32 VARCHAR2
558 , p0_a33 VARCHAR2
559 , p0_a34 DATE
560 , p0_a35 VARCHAR2
561 , p0_a36 DATE
562 , p0_a37 VARCHAR2
563 , p0_a38 NUMBER
564 , p0_a39 NUMBER
565 , p0_a40 VARCHAR2
566 , p0_a41 VARCHAR2
567 , p0_a42 DATE
568 , p0_a43 DATE
569 , p0_a44 DATE
570 , p0_a45 VARCHAR2
571 , p0_a46 VARCHAR2
572 , p0_a47 NUMBER
573 , p0_a48 NUMBER
574 , p0_a49 VARCHAR2
575 , p0_a50 VARCHAR2
576 , p0_a51 NUMBER
577 , p0_a52 DATE
578 , p0_a53 NUMBER
579 , p0_a54 NUMBER
580 , p0_a55 NUMBER
581 , p0_a56 NUMBER
582 , p0_a57 NUMBER
583 , p0_a58 VARCHAR2
584 , p0_a59 NUMBER
585 , p0_a60 DATE
586 , p0_a61 NUMBER
587 , p0_a62 NUMBER
588 , p0_a63 NUMBER
589 , p0_a64 NUMBER
590 , p0_a65 NUMBER
591 , p0_a66 VARCHAR2
592 , p0_a67 VARCHAR2
593 , p0_a68 VARCHAR2
594 , p0_a69 VARCHAR2
595 , p0_a70 NUMBER
596 , p0_a71 NUMBER
597 , p0_a72 NUMBER
598 , p0_a73 NUMBER
599 , p0_a74 DATE
600 , p0_a75 DATE
601 , p0_a76 VARCHAR2
602 , p0_a77 VARCHAR2
603 , p0_a78 VARCHAR2
604 , p0_a79 VARCHAR2
605 , p0_a80 DATE
606 , p0_a81 VARCHAR2
607 , p0_a82 NUMBER
608 , p0_a83 NUMBER
609 , p0_a84 VARCHAR2
610 , p0_a85 NUMBER
611 , p0_a86 NUMBER
612 , p0_a87 NUMBER
613 , p0_a88 NUMBER
614 , p0_a89 NUMBER
615 , p0_a90 VARCHAR2
616 , p0_a91 NUMBER
617 , p0_a92 VARCHAR2
618 , p0_a93 VARCHAR2
619 , p0_a94 VARCHAR2
620 , p0_a95 VARCHAR2
621 , p1_a0 JTF_NUMBER_TABLE
622 , p1_a1 JTF_DATE_TABLE
623 , p1_a2 JTF_DATE_TABLE
624 , p1_a3 JTF_NUMBER_TABLE
625 , p1_a4 JTF_NUMBER_TABLE
626 , p1_a5 JTF_NUMBER_TABLE
627 , p1_a6 JTF_NUMBER_TABLE
628 , p1_a7 JTF_VARCHAR2_TABLE_100
629 , p1_a8 JTF_VARCHAR2_TABLE_100
630 , p1_a9 JTF_VARCHAR2_TABLE_100
631 , p_based_on_terms VARCHAR2
632 , p_installment_number NUMBER
633 , p4_a0 out nocopy JTF_NUMBER_TABLE
634 , p4_a1 out nocopy JTF_DATE_TABLE
635 , p4_a2 out nocopy JTF_DATE_TABLE
636 , p4_a3 out nocopy JTF_DATE_TABLE
637 , p4_a4 out nocopy JTF_NUMBER_TABLE
638 , p4_a5 out nocopy JTF_NUMBER_TABLE
639 , p4_a6 out nocopy JTF_NUMBER_TABLE
640 , p4_a7 out nocopy JTF_NUMBER_TABLE
641 , p4_a8 out nocopy JTF_NUMBER_TABLE
642 , p4_a9 out nocopy JTF_NUMBER_TABLE
643 , p4_a10 out nocopy JTF_NUMBER_TABLE
644 , p4_a11 out nocopy JTF_NUMBER_TABLE
645 , p4_a12 out nocopy JTF_NUMBER_TABLE
646 , p4_a13 out nocopy JTF_NUMBER_TABLE
647 , p4_a14 out nocopy JTF_NUMBER_TABLE
648 , p4_a15 out nocopy JTF_NUMBER_TABLE
649 , p4_a16 out nocopy JTF_NUMBER_TABLE
650 , p4_a17 out nocopy JTF_NUMBER_TABLE
651 , p4_a18 out nocopy JTF_NUMBER_TABLE
652 , p4_a19 out nocopy JTF_NUMBER_TABLE
653 , p4_a20 out nocopy JTF_NUMBER_TABLE
654 , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655 , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656 , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657 , p4_a24 out nocopy JTF_NUMBER_TABLE
658 , p4_a25 out nocopy JTF_NUMBER_TABLE
659 , p4_a26 out nocopy JTF_NUMBER_TABLE
660 , p4_a27 out nocopy JTF_NUMBER_TABLE
661 , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662 , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663 , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664 , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665 , p4_a32 out nocopy JTF_NUMBER_TABLE
666 , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667 , p4_a34 out nocopy JTF_NUMBER_TABLE
668 , p4_a35 out nocopy JTF_NUMBER_TABLE
669 , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670 , p4_a37 out nocopy JTF_NUMBER_TABLE
671 , p4_a38 out nocopy JTF_NUMBER_TABLE
672 , p4_a39 out nocopy JTF_NUMBER_TABLE
673 , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674 , p4_a41 out nocopy JTF_NUMBER_TABLE
675 , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
676 );
677 procedure amortizeloan(p0_a0 NUMBER
678 , p0_a1 NUMBER
679 , p0_a2 VARCHAR2
680 , p0_a3 NUMBER
681 , p0_a4 VARCHAR2
682 , p0_a5 VARCHAR2
683 , p0_a6 VARCHAR2
684 , p0_a7 DATE
685 , p0_a8 DATE
686 , p0_a9 NUMBER
687 , p0_a10 NUMBER
688 , p0_a11 NUMBER
689 , p0_a12 NUMBER
690 , p0_a13 NUMBER
691 , p0_a14 NUMBER
692 , p0_a15 NUMBER
693 , p0_a16 NUMBER
694 , p0_a17 NUMBER
695 , p0_a18 NUMBER
696 , p0_a19 DATE
697 , p0_a20 NUMBER
698 , p0_a21 NUMBER
699 , p0_a22 VARCHAR2
700 , p0_a23 VARCHAR2
701 , p0_a24 VARCHAR2
702 , p0_a25 NUMBER
703 , p0_a26 NUMBER
704 , p0_a27 NUMBER
705 , p0_a28 NUMBER
706 , p0_a29 VARCHAR2
707 , p0_a30 VARCHAR2
708 , p0_a31 NUMBER
709 , p0_a32 VARCHAR2
710 , p0_a33 VARCHAR2
711 , p0_a34 DATE
712 , p0_a35 VARCHAR2
713 , p0_a36 DATE
714 , p0_a37 VARCHAR2
715 , p0_a38 NUMBER
716 , p0_a39 NUMBER
717 , p0_a40 VARCHAR2
718 , p0_a41 VARCHAR2
719 , p0_a42 DATE
720 , p0_a43 DATE
721 , p0_a44 DATE
722 , p0_a45 VARCHAR2
723 , p0_a46 VARCHAR2
724 , p0_a47 NUMBER
725 , p0_a48 NUMBER
726 , p0_a49 VARCHAR2
727 , p0_a50 VARCHAR2
728 , p0_a51 NUMBER
729 , p0_a52 DATE
730 , p0_a53 NUMBER
731 , p0_a54 NUMBER
732 , p0_a55 NUMBER
733 , p0_a56 NUMBER
734 , p0_a57 NUMBER
735 , p0_a58 VARCHAR2
736 , p0_a59 NUMBER
737 , p0_a60 DATE
738 , p0_a61 NUMBER
739 , p0_a62 NUMBER
740 , p0_a63 NUMBER
741 , p0_a64 NUMBER
742 , p0_a65 NUMBER
743 , p0_a66 VARCHAR2
744 , p0_a67 VARCHAR2
745 , p0_a68 VARCHAR2
746 , p0_a69 VARCHAR2
747 , p0_a70 NUMBER
748 , p0_a71 NUMBER
749 , p0_a72 NUMBER
750 , p0_a73 NUMBER
751 , p0_a74 DATE
752 , p0_a75 DATE
753 , p0_a76 VARCHAR2
754 , p0_a77 VARCHAR2
755 , p0_a78 VARCHAR2
756 , p0_a79 VARCHAR2
757 , p0_a80 DATE
758 , p0_a81 VARCHAR2
759 , p0_a82 NUMBER
760 , p0_a83 NUMBER
761 , p0_a84 VARCHAR2
762 , p0_a85 NUMBER
763 , p0_a86 NUMBER
764 , p0_a87 NUMBER
765 , p0_a88 NUMBER
766 , p0_a89 NUMBER
767 , p0_a90 VARCHAR2
768 , p0_a91 NUMBER
769 , p0_a92 VARCHAR2
770 , p0_a93 VARCHAR2
771 , p0_a94 VARCHAR2
772 , p0_a95 VARCHAR2
773 , p1_a0 JTF_NUMBER_TABLE
774 , p1_a1 JTF_DATE_TABLE
775 , p1_a2 JTF_DATE_TABLE
776 , p1_a3 JTF_NUMBER_TABLE
777 , p1_a4 JTF_NUMBER_TABLE
778 , p1_a5 JTF_NUMBER_TABLE
779 , p1_a6 JTF_NUMBER_TABLE
780 , p1_a7 JTF_VARCHAR2_TABLE_100
781 , p1_a8 JTF_VARCHAR2_TABLE_100
782 , p1_a9 JTF_VARCHAR2_TABLE_100
783 , p_based_on_terms VARCHAR2
784 , p_installment_number NUMBER
785 , p4_a0 out nocopy JTF_NUMBER_TABLE
786 , p4_a1 out nocopy JTF_DATE_TABLE
787 , p4_a2 out nocopy JTF_DATE_TABLE
788 , p4_a3 out nocopy JTF_DATE_TABLE
789 , p4_a4 out nocopy JTF_NUMBER_TABLE
790 , p4_a5 out nocopy JTF_NUMBER_TABLE
791 , p4_a6 out nocopy JTF_NUMBER_TABLE
792 , p4_a7 out nocopy JTF_NUMBER_TABLE
793 , p4_a8 out nocopy JTF_NUMBER_TABLE
794 , p4_a9 out nocopy JTF_NUMBER_TABLE
795 , p4_a10 out nocopy JTF_NUMBER_TABLE
796 , p4_a11 out nocopy JTF_NUMBER_TABLE
797 , p4_a12 out nocopy JTF_NUMBER_TABLE
798 , p4_a13 out nocopy JTF_NUMBER_TABLE
799 , p4_a14 out nocopy JTF_NUMBER_TABLE
800 , p4_a15 out nocopy JTF_NUMBER_TABLE
801 , p4_a16 out nocopy JTF_NUMBER_TABLE
802 , p4_a17 out nocopy JTF_NUMBER_TABLE
803 , p4_a18 out nocopy JTF_NUMBER_TABLE
804 , p4_a19 out nocopy JTF_NUMBER_TABLE
805 , p4_a20 out nocopy JTF_NUMBER_TABLE
806 , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807 , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808 , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809 , p4_a24 out nocopy JTF_NUMBER_TABLE
810 , p4_a25 out nocopy JTF_NUMBER_TABLE
811 , p4_a26 out nocopy JTF_NUMBER_TABLE
812 , p4_a27 out nocopy JTF_NUMBER_TABLE
813 , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814 , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815 , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816 , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817 , p4_a32 out nocopy JTF_NUMBER_TABLE
818 , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819 , p4_a34 out nocopy JTF_NUMBER_TABLE
820 , p4_a35 out nocopy JTF_NUMBER_TABLE
821 , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822 , p4_a37 out nocopy JTF_NUMBER_TABLE
823 , p4_a38 out nocopy JTF_NUMBER_TABLE
824 , p4_a39 out nocopy JTF_NUMBER_TABLE
825 , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826 , p4_a41 out nocopy JTF_NUMBER_TABLE
827 , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
828 );
829 procedure amortizeloan(p_loan_id NUMBER
830 , p_based_on_terms VARCHAR2
831 , p_installment_number NUMBER
832 , p3_a0 out nocopy JTF_NUMBER_TABLE
833 , p3_a1 out nocopy JTF_DATE_TABLE
834 , p3_a2 out nocopy JTF_DATE_TABLE
835 , p3_a3 out nocopy JTF_DATE_TABLE
836 , p3_a4 out nocopy JTF_NUMBER_TABLE
837 , p3_a5 out nocopy JTF_NUMBER_TABLE
838 , p3_a6 out nocopy JTF_NUMBER_TABLE
839 , p3_a7 out nocopy JTF_NUMBER_TABLE
840 , p3_a8 out nocopy JTF_NUMBER_TABLE
841 , p3_a9 out nocopy JTF_NUMBER_TABLE
842 , p3_a10 out nocopy JTF_NUMBER_TABLE
843 , p3_a11 out nocopy JTF_NUMBER_TABLE
844 , p3_a12 out nocopy JTF_NUMBER_TABLE
845 , p3_a13 out nocopy JTF_NUMBER_TABLE
846 , p3_a14 out nocopy JTF_NUMBER_TABLE
847 , p3_a15 out nocopy JTF_NUMBER_TABLE
848 , p3_a16 out nocopy JTF_NUMBER_TABLE
849 , p3_a17 out nocopy JTF_NUMBER_TABLE
850 , p3_a18 out nocopy JTF_NUMBER_TABLE
851 , p3_a19 out nocopy JTF_NUMBER_TABLE
852 , p3_a20 out nocopy JTF_NUMBER_TABLE
853 , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854 , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856 , p3_a24 out nocopy JTF_NUMBER_TABLE
857 , p3_a25 out nocopy JTF_NUMBER_TABLE
858 , p3_a26 out nocopy JTF_NUMBER_TABLE
859 , p3_a27 out nocopy JTF_NUMBER_TABLE
860 , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861 , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862 , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863 , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864 , p3_a32 out nocopy JTF_NUMBER_TABLE
865 , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866 , p3_a34 out nocopy JTF_NUMBER_TABLE
867 , p3_a35 out nocopy JTF_NUMBER_TABLE
868 , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869 , p3_a37 out nocopy JTF_NUMBER_TABLE
870 , p3_a38 out nocopy JTF_NUMBER_TABLE
871 , p3_a39 out nocopy JTF_NUMBER_TABLE
872 , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873 , p3_a41 out nocopy JTF_NUMBER_TABLE
874 , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
875 );
876 procedure loanprojection(p0_a0 NUMBER
877 , p0_a1 NUMBER
878 , p0_a2 VARCHAR2
879 , p0_a3 NUMBER
880 , p0_a4 VARCHAR2
881 , p0_a5 VARCHAR2
882 , p0_a6 VARCHAR2
883 , p0_a7 DATE
884 , p0_a8 DATE
885 , p0_a9 NUMBER
886 , p0_a10 NUMBER
887 , p0_a11 NUMBER
888 , p0_a12 NUMBER
889 , p0_a13 NUMBER
890 , p0_a14 NUMBER
891 , p0_a15 NUMBER
892 , p0_a16 NUMBER
893 , p0_a17 NUMBER
894 , p0_a18 NUMBER
895 , p0_a19 DATE
896 , p0_a20 NUMBER
897 , p0_a21 NUMBER
898 , p0_a22 VARCHAR2
899 , p0_a23 VARCHAR2
900 , p0_a24 VARCHAR2
901 , p0_a25 NUMBER
902 , p0_a26 NUMBER
903 , p0_a27 NUMBER
904 , p0_a28 NUMBER
905 , p0_a29 VARCHAR2
906 , p0_a30 VARCHAR2
907 , p0_a31 NUMBER
908 , p0_a32 VARCHAR2
909 , p0_a33 VARCHAR2
910 , p0_a34 DATE
911 , p0_a35 VARCHAR2
912 , p0_a36 DATE
913 , p0_a37 VARCHAR2
914 , p0_a38 NUMBER
915 , p0_a39 NUMBER
916 , p0_a40 VARCHAR2
917 , p0_a41 VARCHAR2
918 , p0_a42 DATE
919 , p0_a43 DATE
920 , p0_a44 DATE
921 , p0_a45 VARCHAR2
922 , p0_a46 VARCHAR2
923 , p0_a47 NUMBER
924 , p0_a48 NUMBER
925 , p0_a49 VARCHAR2
926 , p0_a50 VARCHAR2
927 , p0_a51 NUMBER
928 , p0_a52 DATE
929 , p0_a53 NUMBER
930 , p0_a54 NUMBER
931 , p0_a55 NUMBER
932 , p0_a56 NUMBER
933 , p0_a57 NUMBER
934 , p0_a58 VARCHAR2
935 , p0_a59 NUMBER
936 , p0_a60 DATE
937 , p0_a61 NUMBER
938 , p0_a62 NUMBER
939 , p0_a63 NUMBER
940 , p0_a64 NUMBER
941 , p0_a65 NUMBER
942 , p0_a66 VARCHAR2
943 , p0_a67 VARCHAR2
944 , p0_a68 VARCHAR2
945 , p0_a69 VARCHAR2
946 , p0_a70 NUMBER
947 , p0_a71 NUMBER
948 , p0_a72 NUMBER
949 , p0_a73 NUMBER
950 , p0_a74 DATE
951 , p0_a75 DATE
952 , p0_a76 VARCHAR2
953 , p0_a77 VARCHAR2
954 , p0_a78 VARCHAR2
955 , p0_a79 VARCHAR2
956 , p0_a80 DATE
957 , p0_a81 VARCHAR2
958 , p0_a82 NUMBER
959 , p0_a83 NUMBER
960 , p0_a84 VARCHAR2
961 , p0_a85 NUMBER
962 , p0_a86 NUMBER
963 , p0_a87 NUMBER
964 , p0_a88 NUMBER
965 , p0_a89 NUMBER
966 , p0_a90 VARCHAR2
967 , p0_a91 NUMBER
968 , p0_a92 VARCHAR2
969 , p0_a93 VARCHAR2
970 , p0_a94 VARCHAR2
971 , p0_a95 VARCHAR2
972 , p_based_on_terms VARCHAR2
973 , p2_a0 JTF_NUMBER_TABLE
974 , p2_a1 JTF_DATE_TABLE
975 , p2_a2 JTF_DATE_TABLE
976 , p2_a3 JTF_NUMBER_TABLE
977 , p2_a4 JTF_NUMBER_TABLE
978 , p2_a5 JTF_NUMBER_TABLE
979 , p2_a6 JTF_NUMBER_TABLE
980 , p2_a7 JTF_VARCHAR2_TABLE_100
981 , p2_a8 JTF_VARCHAR2_TABLE_100
982 , p2_a9 JTF_VARCHAR2_TABLE_100
983 , p3_a0 out nocopy JTF_NUMBER_TABLE
984 , p3_a1 out nocopy JTF_DATE_TABLE
985 , p3_a2 out nocopy JTF_DATE_TABLE
986 , p3_a3 out nocopy JTF_DATE_TABLE
987 , p3_a4 out nocopy JTF_NUMBER_TABLE
988 , p3_a5 out nocopy JTF_NUMBER_TABLE
989 , p3_a6 out nocopy JTF_NUMBER_TABLE
990 , p3_a7 out nocopy JTF_NUMBER_TABLE
991 , p3_a8 out nocopy JTF_NUMBER_TABLE
992 , p3_a9 out nocopy JTF_NUMBER_TABLE
993 , p3_a10 out nocopy JTF_NUMBER_TABLE
994 , p3_a11 out nocopy JTF_NUMBER_TABLE
995 , p3_a12 out nocopy JTF_NUMBER_TABLE
996 , p3_a13 out nocopy JTF_NUMBER_TABLE
997 , p3_a14 out nocopy JTF_NUMBER_TABLE
998 , p3_a15 out nocopy JTF_NUMBER_TABLE
999 , p3_a16 out nocopy JTF_NUMBER_TABLE
1000 , p3_a17 out nocopy JTF_NUMBER_TABLE
1001 , p3_a18 out nocopy JTF_NUMBER_TABLE
1002 , p3_a19 out nocopy JTF_NUMBER_TABLE
1003 , p3_a20 out nocopy JTF_NUMBER_TABLE
1004 , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005 , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007 , p3_a24 out nocopy JTF_NUMBER_TABLE
1008 , p3_a25 out nocopy JTF_NUMBER_TABLE
1009 , p3_a26 out nocopy JTF_NUMBER_TABLE
1010 , p3_a27 out nocopy JTF_NUMBER_TABLE
1011 , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012 , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013 , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014 , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015 , p3_a32 out nocopy JTF_NUMBER_TABLE
1016 , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017 , p3_a34 out nocopy JTF_NUMBER_TABLE
1018 , p3_a35 out nocopy JTF_NUMBER_TABLE
1019 , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020 , p3_a37 out nocopy JTF_NUMBER_TABLE
1021 , p3_a38 out nocopy JTF_NUMBER_TABLE
1022 , p3_a39 out nocopy JTF_NUMBER_TABLE
1023 , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024 , p3_a41 out nocopy JTF_NUMBER_TABLE
1025 , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1026 );
1027 procedure runopenprojection(p_init_msg_list VARCHAR2
1028 , p_loan_id NUMBER
1029 , p_based_on_terms VARCHAR2
1030 , p3_a0 out nocopy JTF_NUMBER_TABLE
1031 , p3_a1 out nocopy JTF_DATE_TABLE
1032 , p3_a2 out nocopy JTF_DATE_TABLE
1033 , p3_a3 out nocopy JTF_DATE_TABLE
1034 , p3_a4 out nocopy JTF_NUMBER_TABLE
1035 , p3_a5 out nocopy JTF_NUMBER_TABLE
1036 , p3_a6 out nocopy JTF_NUMBER_TABLE
1037 , p3_a7 out nocopy JTF_NUMBER_TABLE
1038 , p3_a8 out nocopy JTF_NUMBER_TABLE
1039 , p3_a9 out nocopy JTF_NUMBER_TABLE
1040 , p3_a10 out nocopy JTF_NUMBER_TABLE
1041 , p3_a11 out nocopy JTF_NUMBER_TABLE
1042 , p3_a12 out nocopy JTF_NUMBER_TABLE
1043 , p3_a13 out nocopy JTF_NUMBER_TABLE
1044 , p3_a14 out nocopy JTF_NUMBER_TABLE
1045 , p3_a15 out nocopy JTF_NUMBER_TABLE
1046 , p3_a16 out nocopy JTF_NUMBER_TABLE
1047 , p3_a17 out nocopy JTF_NUMBER_TABLE
1048 , p3_a18 out nocopy JTF_NUMBER_TABLE
1049 , p3_a19 out nocopy JTF_NUMBER_TABLE
1050 , p3_a20 out nocopy JTF_NUMBER_TABLE
1051 , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052 , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054 , p3_a24 out nocopy JTF_NUMBER_TABLE
1055 , p3_a25 out nocopy JTF_NUMBER_TABLE
1056 , p3_a26 out nocopy JTF_NUMBER_TABLE
1057 , p3_a27 out nocopy JTF_NUMBER_TABLE
1058 , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059 , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060 , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061 , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062 , p3_a32 out nocopy JTF_NUMBER_TABLE
1063 , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064 , p3_a34 out nocopy JTF_NUMBER_TABLE
1065 , p3_a35 out nocopy JTF_NUMBER_TABLE
1066 , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067 , p3_a37 out nocopy JTF_NUMBER_TABLE
1068 , p3_a38 out nocopy JTF_NUMBER_TABLE
1069 , p3_a39 out nocopy JTF_NUMBER_TABLE
1070 , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071 , p3_a41 out nocopy JTF_NUMBER_TABLE
1072 , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1073 , x_return_status out nocopy VARCHAR2
1074 , x_msg_count out nocopy NUMBER
1075 , x_msg_data out nocopy VARCHAR2
1076 );
1077 procedure runamortization(p_api_version NUMBER
1078 , p_init_msg_list VARCHAR2
1079 , p_commit VARCHAR2
1080 , p_loan_id NUMBER
1081 , p_based_on_terms VARCHAR2
1082 , p5_a0 out nocopy JTF_NUMBER_TABLE
1083 , p5_a1 out nocopy JTF_DATE_TABLE
1084 , p5_a2 out nocopy JTF_DATE_TABLE
1085 , p5_a3 out nocopy JTF_DATE_TABLE
1086 , p5_a4 out nocopy JTF_NUMBER_TABLE
1087 , p5_a5 out nocopy JTF_NUMBER_TABLE
1088 , p5_a6 out nocopy JTF_NUMBER_TABLE
1089 , p5_a7 out nocopy JTF_NUMBER_TABLE
1090 , p5_a8 out nocopy JTF_NUMBER_TABLE
1091 , p5_a9 out nocopy JTF_NUMBER_TABLE
1092 , p5_a10 out nocopy JTF_NUMBER_TABLE
1093 , p5_a11 out nocopy JTF_NUMBER_TABLE
1094 , p5_a12 out nocopy JTF_NUMBER_TABLE
1095 , p5_a13 out nocopy JTF_NUMBER_TABLE
1096 , p5_a14 out nocopy JTF_NUMBER_TABLE
1097 , p5_a15 out nocopy JTF_NUMBER_TABLE
1098 , p5_a16 out nocopy JTF_NUMBER_TABLE
1099 , p5_a17 out nocopy JTF_NUMBER_TABLE
1100 , p5_a18 out nocopy JTF_NUMBER_TABLE
1101 , p5_a19 out nocopy JTF_NUMBER_TABLE
1102 , p5_a20 out nocopy JTF_NUMBER_TABLE
1103 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106 , p5_a24 out nocopy JTF_NUMBER_TABLE
1107 , p5_a25 out nocopy JTF_NUMBER_TABLE
1108 , p5_a26 out nocopy JTF_NUMBER_TABLE
1109 , p5_a27 out nocopy JTF_NUMBER_TABLE
1110 , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111 , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112 , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113 , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114 , p5_a32 out nocopy JTF_NUMBER_TABLE
1115 , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116 , p5_a34 out nocopy JTF_NUMBER_TABLE
1117 , p5_a35 out nocopy JTF_NUMBER_TABLE
1118 , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119 , p5_a37 out nocopy JTF_NUMBER_TABLE
1120 , p5_a38 out nocopy JTF_NUMBER_TABLE
1121 , p5_a39 out nocopy JTF_NUMBER_TABLE
1122 , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123 , p5_a41 out nocopy JTF_NUMBER_TABLE
1124 , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1125 , x_return_status out nocopy VARCHAR2
1126 , x_msg_count out nocopy NUMBER
1127 , x_msg_data out nocopy VARCHAR2
1128 );
1129 procedure getinstallment(p_api_version NUMBER
1130 , p_init_msg_list VARCHAR2
1131 , p_commit VARCHAR2
1132 , p_loan_id NUMBER
1133 , p_installment_number NUMBER
1134 , p5_a0 out nocopy NUMBER
1135 , p5_a1 out nocopy DATE
1136 , p5_a2 out nocopy DATE
1137 , p5_a3 out nocopy DATE
1138 , p5_a4 out nocopy NUMBER
1139 , p5_a5 out nocopy NUMBER
1140 , p5_a6 out nocopy NUMBER
1141 , p5_a7 out nocopy NUMBER
1142 , p5_a8 out nocopy NUMBER
1143 , p5_a9 out nocopy NUMBER
1144 , p5_a10 out nocopy NUMBER
1145 , p5_a11 out nocopy NUMBER
1146 , p5_a12 out nocopy NUMBER
1147 , p5_a13 out nocopy NUMBER
1148 , p5_a14 out nocopy NUMBER
1149 , p5_a15 out nocopy NUMBER
1150 , p5_a16 out nocopy NUMBER
1151 , p5_a17 out nocopy NUMBER
1152 , p5_a18 out nocopy NUMBER
1153 , p5_a19 out nocopy NUMBER
1154 , p5_a20 out nocopy NUMBER
1155 , p5_a21 out nocopy VARCHAR2
1156 , p5_a22 out nocopy VARCHAR2
1157 , p5_a23 out nocopy VARCHAR2
1158 , p5_a24 out nocopy NUMBER
1159 , p5_a25 out nocopy NUMBER
1160 , p5_a26 out nocopy NUMBER
1161 , p5_a27 out nocopy NUMBER
1162 , p5_a28 out nocopy VARCHAR2
1163 , p5_a29 out nocopy VARCHAR2
1164 , p5_a30 out nocopy VARCHAR2
1165 , p5_a31 out nocopy VARCHAR2
1166 , p5_a32 out nocopy NUMBER
1167 , p5_a33 out nocopy VARCHAR2
1168 , p5_a34 out nocopy NUMBER
1169 , p5_a35 out nocopy NUMBER
1170 , p5_a36 out nocopy VARCHAR2
1171 , p5_a37 out nocopy NUMBER
1172 , p5_a38 out nocopy NUMBER
1173 , p5_a39 out nocopy NUMBER
1174 , p5_a40 out nocopy VARCHAR2
1175 , p5_a41 out nocopy NUMBER
1176 , p5_a42 out nocopy VARCHAR2
1177 , p6_a0 out nocopy JTF_NUMBER_TABLE
1178 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179 , p6_a2 out nocopy JTF_NUMBER_TABLE
1180 , p6_a3 out nocopy JTF_NUMBER_TABLE
1181 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182 , p6_a5 out nocopy JTF_NUMBER_TABLE
1183 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184 , p6_a7 out nocopy JTF_NUMBER_TABLE
1185 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187 , x_return_status out nocopy VARCHAR2
1188 , x_msg_count out nocopy NUMBER
1189 , x_msg_data out nocopy VARCHAR2
1190 );
1191 procedure getopeninstallment(p_init_msg_list VARCHAR2
1192 , p_loan_id NUMBER
1193 , p_installment_number NUMBER
1194 , p3_a0 out nocopy NUMBER
1195 , p3_a1 out nocopy DATE
1196 , p3_a2 out nocopy DATE
1197 , p3_a3 out nocopy DATE
1198 , p3_a4 out nocopy NUMBER
1199 , p3_a5 out nocopy NUMBER
1200 , p3_a6 out nocopy NUMBER
1201 , p3_a7 out nocopy NUMBER
1202 , p3_a8 out nocopy NUMBER
1203 , p3_a9 out nocopy NUMBER
1204 , p3_a10 out nocopy NUMBER
1205 , p3_a11 out nocopy NUMBER
1206 , p3_a12 out nocopy NUMBER
1207 , p3_a13 out nocopy NUMBER
1208 , p3_a14 out nocopy NUMBER
1209 , p3_a15 out nocopy NUMBER
1210 , p3_a16 out nocopy NUMBER
1211 , p3_a17 out nocopy NUMBER
1212 , p3_a18 out nocopy NUMBER
1213 , p3_a19 out nocopy NUMBER
1214 , p3_a20 out nocopy NUMBER
1215 , p3_a21 out nocopy VARCHAR2
1216 , p3_a22 out nocopy VARCHAR2
1217 , p3_a23 out nocopy VARCHAR2
1218 , p3_a24 out nocopy NUMBER
1219 , p3_a25 out nocopy NUMBER
1220 , p3_a26 out nocopy NUMBER
1221 , p3_a27 out nocopy NUMBER
1222 , p3_a28 out nocopy VARCHAR2
1223 , p3_a29 out nocopy VARCHAR2
1224 , p3_a30 out nocopy VARCHAR2
1225 , p3_a31 out nocopy VARCHAR2
1226 , p3_a32 out nocopy NUMBER
1227 , p3_a33 out nocopy VARCHAR2
1228 , p3_a34 out nocopy NUMBER
1229 , p3_a35 out nocopy NUMBER
1230 , p3_a36 out nocopy VARCHAR2
1231 , p3_a37 out nocopy NUMBER
1232 , p3_a38 out nocopy NUMBER
1233 , p3_a39 out nocopy NUMBER
1234 , p3_a40 out nocopy VARCHAR2
1235 , p3_a41 out nocopy NUMBER
1236 , p3_a42 out nocopy VARCHAR2
1237 , p4_a0 out nocopy JTF_NUMBER_TABLE
1238 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239 , p4_a2 out nocopy JTF_NUMBER_TABLE
1240 , p4_a3 out nocopy JTF_NUMBER_TABLE
1241 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242 , p4_a5 out nocopy JTF_NUMBER_TABLE
1243 , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244 , p4_a7 out nocopy JTF_NUMBER_TABLE
1245 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247 , x_return_status out nocopy VARCHAR2
1248 , x_msg_count out nocopy NUMBER
1249 , x_msg_data out nocopy VARCHAR2
1250 );
1251 procedure preprocessinstallment(p_api_version NUMBER
1252 , p_init_msg_list VARCHAR2
1253 , p_commit VARCHAR2
1254 , p_loan_id NUMBER
1255 , p_installment_number NUMBER
1256 , p5_a0 out nocopy NUMBER
1257 , p5_a1 out nocopy DATE
1258 , p5_a2 out nocopy DATE
1259 , p5_a3 out nocopy DATE
1260 , p5_a4 out nocopy NUMBER
1261 , p5_a5 out nocopy NUMBER
1262 , p5_a6 out nocopy NUMBER
1263 , p5_a7 out nocopy NUMBER
1264 , p5_a8 out nocopy NUMBER
1265 , p5_a9 out nocopy NUMBER
1266 , p5_a10 out nocopy NUMBER
1267 , p5_a11 out nocopy NUMBER
1268 , p5_a12 out nocopy NUMBER
1269 , p5_a13 out nocopy NUMBER
1270 , p5_a14 out nocopy NUMBER
1271 , p5_a15 out nocopy NUMBER
1272 , p5_a16 out nocopy NUMBER
1273 , p5_a17 out nocopy NUMBER
1274 , p5_a18 out nocopy NUMBER
1275 , p5_a19 out nocopy NUMBER
1276 , p5_a20 out nocopy NUMBER
1277 , p5_a21 out nocopy VARCHAR2
1278 , p5_a22 out nocopy VARCHAR2
1279 , p5_a23 out nocopy VARCHAR2
1280 , p5_a24 out nocopy NUMBER
1281 , p5_a25 out nocopy NUMBER
1282 , p5_a26 out nocopy NUMBER
1283 , p5_a27 out nocopy NUMBER
1284 , p5_a28 out nocopy VARCHAR2
1285 , p5_a29 out nocopy VARCHAR2
1286 , p5_a30 out nocopy VARCHAR2
1287 , p5_a31 out nocopy VARCHAR2
1288 , p5_a32 out nocopy NUMBER
1289 , p5_a33 out nocopy VARCHAR2
1290 , p5_a34 out nocopy NUMBER
1291 , p5_a35 out nocopy NUMBER
1292 , p5_a36 out nocopy VARCHAR2
1293 , p5_a37 out nocopy NUMBER
1294 , p5_a38 out nocopy NUMBER
1295 , p5_a39 out nocopy NUMBER
1296 , p5_a40 out nocopy VARCHAR2
1297 , p5_a41 out nocopy NUMBER
1298 , p5_a42 out nocopy VARCHAR2
1299 , x_return_status out nocopy VARCHAR2
1300 , x_msg_count out nocopy NUMBER
1301 , x_msg_data out nocopy VARCHAR2
1302 );
1303 procedure preprocessopeninstallment(p_init_msg_list VARCHAR2
1304 , p_commit VARCHAR2
1305 , p_loan_id NUMBER
1306 , p_installment_number NUMBER
1307 , p4_a0 out nocopy NUMBER
1308 , p4_a1 out nocopy DATE
1309 , p4_a2 out nocopy DATE
1310 , p4_a3 out nocopy DATE
1311 , p4_a4 out nocopy NUMBER
1312 , p4_a5 out nocopy NUMBER
1313 , p4_a6 out nocopy NUMBER
1314 , p4_a7 out nocopy NUMBER
1315 , p4_a8 out nocopy NUMBER
1316 , p4_a9 out nocopy NUMBER
1317 , p4_a10 out nocopy NUMBER
1318 , p4_a11 out nocopy NUMBER
1319 , p4_a12 out nocopy NUMBER
1320 , p4_a13 out nocopy NUMBER
1321 , p4_a14 out nocopy NUMBER
1322 , p4_a15 out nocopy NUMBER
1323 , p4_a16 out nocopy NUMBER
1324 , p4_a17 out nocopy NUMBER
1325 , p4_a18 out nocopy NUMBER
1326 , p4_a19 out nocopy NUMBER
1327 , p4_a20 out nocopy NUMBER
1328 , p4_a21 out nocopy VARCHAR2
1329 , p4_a22 out nocopy VARCHAR2
1330 , p4_a23 out nocopy VARCHAR2
1331 , p4_a24 out nocopy NUMBER
1332 , p4_a25 out nocopy NUMBER
1333 , p4_a26 out nocopy NUMBER
1334 , p4_a27 out nocopy NUMBER
1335 , p4_a28 out nocopy VARCHAR2
1336 , p4_a29 out nocopy VARCHAR2
1337 , p4_a30 out nocopy VARCHAR2
1338 , p4_a31 out nocopy VARCHAR2
1339 , p4_a32 out nocopy NUMBER
1340 , p4_a33 out nocopy VARCHAR2
1341 , p4_a34 out nocopy NUMBER
1342 , p4_a35 out nocopy NUMBER
1343 , p4_a36 out nocopy VARCHAR2
1344 , p4_a37 out nocopy NUMBER
1345 , p4_a38 out nocopy NUMBER
1346 , p4_a39 out nocopy NUMBER
1347 , p4_a40 out nocopy VARCHAR2
1348 , p4_a41 out nocopy NUMBER
1349 , p4_a42 out nocopy VARCHAR2
1350 , x_return_status out nocopy VARCHAR2
1351 , x_msg_count out nocopy NUMBER
1352 , x_msg_data out nocopy VARCHAR2
1353 );
1354 function calculateeppayment(p_loan_amount NUMBER
1355 , p_num_intervals NUMBER
1356 , p_ending_balance NUMBER
1357 , p_pay_in_arrears number
1358 ) return number;
1359 function calculatepayment(p_loan_amount NUMBER
1360 , p_periodic_rate NUMBER
1361 , p_num_intervals NUMBER
1362 , p_ending_balance NUMBER
1363 , p_pay_in_arrears number
1364 ) return number;
1365 procedure calcloanremainingamounts(p_api_version NUMBER
1366 , p_init_msg_list VARCHAR2
1367 , p_loan_id NUMBER
1368 , p_date DATE
1369 , p_reason VARCHAR2
1370 , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371 , p5_a1 out nocopy JTF_NUMBER_TABLE
1372 , p5_a2 out nocopy JTF_NUMBER_TABLE
1373 , p5_a3 out nocopy JTF_NUMBER_TABLE
1374 , x_return_status out nocopy VARCHAR2
1375 , x_msg_count out nocopy NUMBER
1376 , x_msg_data out nocopy VARCHAR2
1377 );
1378 end lns_financials_w;