1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.7.12010000.3 2009/01/07 13:35:38 gparuchu 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
1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.7.12010000.3 2009/01/07 13:35:38 gparuchu 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
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
106: end if;
107: end rosetta_table_copy_out_p1;
108:
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
107: end rosetta_table_copy_out_p1;
108:
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
108:
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
177: end if;
178: end if;
179: end rosetta_table_copy_in_p3;
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
178: end if;
179: end rosetta_table_copy_in_p3;
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
179: end rosetta_table_copy_in_p3;
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
208: ddindx binary_integer; indx binary_integer;
209: begin
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
209: begin
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
347: if a0 is not null and a0.count > 0 then
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
406: if t.count > 0 then
407: a0.extend(t.count);
408: a1.extend(t.count);
409: a2.extend(t.count);
500: end if;
501: end if;
502: end rosetta_table_copy_out_p8;
503:
504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
505: , a1 JTF_NUMBER_TABLE
506: , a2 JTF_NUMBER_TABLE
507: , a3 JTF_NUMBER_TABLE
508: ) as
525: end loop;
526: end if;
527: end if;
528: end rosetta_table_copy_in_p10;
529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
530: , a1 out nocopy JTF_NUMBER_TABLE
531: , a2 out nocopy JTF_NUMBER_TABLE
532: , a3 out nocopy JTF_NUMBER_TABLE
533: ) as
533: ) as
534: ddindx binary_integer; indx binary_integer;
535: begin
536: if t is null or t.count = 0 then
537: a0 := JTF_DATE_TABLE();
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: if t.count > 0 then
564: end if;
565: end if;
566: end rosetta_table_copy_out_p10;
567:
568: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
569: , a1 JTF_DATE_TABLE
570: ) as
571: ddindx binary_integer; indx binary_integer;
572: begin
565: end if;
566: end rosetta_table_copy_out_p10;
567:
568: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
569: , a1 JTF_DATE_TABLE
570: ) as
571: ddindx binary_integer; indx binary_integer;
572: begin
573: if a0 is not null and a0.count > 0 then
585: end loop;
586: end if;
587: end if;
588: end rosetta_table_copy_in_p12;
589: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
590: , a1 out nocopy JTF_DATE_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
586: end if;
587: end if;
588: end rosetta_table_copy_in_p12;
589: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
590: , a1 out nocopy JTF_DATE_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then
594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then
601: a0.extend(t.count);
602: a1.extend(t.count);
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then
601: a0.extend(t.count);
602: a1.extend(t.count);
603: ddindx := t.first;
614: end if;
615: end if;
616: end rosetta_table_copy_out_p12;
617:
618: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE) as
619: ddindx binary_integer; indx binary_integer;
620: begin
621: if a0 is not null and a0.count > 0 then
622: if a0.count > 0 then
632: end loop;
633: end if;
634: end if;
635: end rosetta_table_copy_in_p13;
636: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
637: ddindx binary_integer; indx binary_integer;
638: begin
639: if t is null or t.count = 0 then
640: a0 := JTF_DATE_TABLE();
636: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
637: ddindx binary_integer; indx binary_integer;
638: begin
639: if t is null or t.count = 0 then
640: a0 := JTF_DATE_TABLE();
641: else
642: a0 := JTF_DATE_TABLE();
643: if t.count > 0 then
644: a0.extend(t.count);
638: begin
639: if t is null or t.count = 0 then
640: a0 := JTF_DATE_TABLE();
641: else
642: a0 := JTF_DATE_TABLE();
643: if t.count > 0 then
644: a0.extend(t.count);
645: ddindx := t.first;
646: indx := 1;
1437: , p0_a88 NUMBER
1438: , p_start_date DATE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1438: , p_start_date DATE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1674: , p0_a86 NUMBER
1675: , p0_a87 NUMBER
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1675: , p0_a87 NUMBER
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1969: , p0_a86 NUMBER
1970: , p0_a87 NUMBER
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1970: , p0_a87 NUMBER
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
2178: procedure amortizeloan(p_loan_id NUMBER
2179: , p_based_on_terms VARCHAR2
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2179: , p_based_on_terms VARCHAR2
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2346: , p0_a86 NUMBER
2347: , p0_a87 NUMBER
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2347: , p0_a87 NUMBER
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2547: procedure runopenprojection(p_init_msg_list VARCHAR2
2548: , p_loan_id NUMBER
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2548: , p_loan_id NUMBER
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2643: , p_commit VARCHAR2
2644: , p_loan_id NUMBER
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2644: , p_loan_id NUMBER
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE