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: ) as
14: ddindx binary_integer; indx binary_integer;
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: ) as
14: ddindx binary_integer; indx binary_integer;
15: begin
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: ) as
14: ddindx binary_integer; indx binary_integer;
15: begin
16: if a0 is not null and a0.count > 0 then
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
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
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();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
75: if t.count > 0 then
76: a0.extend(t.count);
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
75: if t.count > 0 then
76: a0.extend(t.count);
77: a1.extend(t.count);
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
75: if t.count > 0 then
76: a0.extend(t.count);
77: a1.extend(t.count);
78: a2.extend(t.count);
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: ) as
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
206: , a26 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
206: , a26 out nocopy JTF_NUMBER_TABLE
207: ) as
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
265: a26 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
265: a26 := JTF_NUMBER_TABLE();
266: if t.count > 0 then
436: end if;
437: end if;
438: end rosetta_table_copy_out_p6;
439:
440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
441: , a1 JTF_NUMBER_TABLE
442: , a2 JTF_NUMBER_TABLE
443: , a3 JTF_NUMBER_TABLE
444: ) as
461: end loop;
462: end if;
463: end if;
464: end rosetta_table_copy_in_p8;
465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
466: , a1 out nocopy JTF_NUMBER_TABLE
467: , a2 out nocopy JTF_NUMBER_TABLE
468: , a3 out nocopy JTF_NUMBER_TABLE
469: ) as
469: ) as
470: ddindx binary_integer; indx binary_integer;
471: begin
472: if t is null or t.count = 0 then
473: a0 := JTF_VARCHAR2_TABLE_100();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
480: a2 := JTF_NUMBER_TABLE();
481: a3 := JTF_NUMBER_TABLE();
482: if t.count > 0 then
696: end if;
697: end if;
698: end rosetta_table_copy_out_p14;
699:
700: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100) as
701: ddindx binary_integer; indx binary_integer;
702: begin
703: if a0 is not null and a0.count > 0 then
704: if a0.count > 0 then
714: end loop;
715: end if;
716: end if;
717: end rosetta_table_copy_in_p15;
718: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
719: ddindx binary_integer; indx binary_integer;
720: begin
721: if t is null or t.count = 0 then
722: a0 := JTF_VARCHAR2_TABLE_100();
718: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
719: ddindx binary_integer; indx binary_integer;
720: begin
721: if t is null or t.count = 0 then
722: a0 := JTF_VARCHAR2_TABLE_100();
723: else
724: a0 := JTF_VARCHAR2_TABLE_100();
725: if t.count > 0 then
726: a0.extend(t.count);
720: begin
721: if t is null or t.count = 0 then
722: a0 := JTF_VARCHAR2_TABLE_100();
723: else
724: a0 := JTF_VARCHAR2_TABLE_100();
725: if t.count > 0 then
726: a0.extend(t.count);
727: ddindx := t.first;
728: indx := 1;
738: end if;
739: end rosetta_table_copy_out_p15;
740:
741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
749: , a8 JTF_VARCHAR2_TABLE_100
750: , a9 JTF_VARCHAR2_TABLE_100
751: ) as
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
749: , a8 JTF_VARCHAR2_TABLE_100
750: , a9 JTF_VARCHAR2_TABLE_100
751: ) as
752: ddindx binary_integer; indx binary_integer;
753: begin
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
749: , a8 JTF_VARCHAR2_TABLE_100
750: , a9 JTF_VARCHAR2_TABLE_100
751: ) as
752: ddindx binary_integer; indx binary_integer;
753: begin
754: if a0 is not null and a0.count > 0 then
775: end if;
776: end if;
777: end rosetta_table_copy_in_p17;
778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
786: , a8 out nocopy JTF_VARCHAR2_TABLE_100
787: , a9 out nocopy JTF_VARCHAR2_TABLE_100
788: ) as
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
786: , a8 out nocopy JTF_VARCHAR2_TABLE_100
787: , a9 out nocopy JTF_VARCHAR2_TABLE_100
788: ) as
789: ddindx binary_integer; indx binary_integer;
790: begin
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
786: , a8 out nocopy JTF_VARCHAR2_TABLE_100
787: , a9 out nocopy JTF_VARCHAR2_TABLE_100
788: ) as
789: ddindx binary_integer; indx binary_integer;
790: begin
791: if t is null or t.count = 0 then
789: ddindx binary_integer; indx binary_integer;
790: begin
791: if t is null or t.count = 0 then
792: a0 := JTF_NUMBER_TABLE();
793: a1 := JTF_VARCHAR2_TABLE_100();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
811: a8 := JTF_VARCHAR2_TABLE_100();
812: a9 := JTF_VARCHAR2_TABLE_100();
813: if t.count > 0 then
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
811: a8 := JTF_VARCHAR2_TABLE_100();
812: a9 := JTF_VARCHAR2_TABLE_100();
813: if t.count > 0 then
814: a0.extend(t.count);
815: a1.extend(t.count);
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
811: a8 := JTF_VARCHAR2_TABLE_100();
812: a9 := JTF_VARCHAR2_TABLE_100();
813: if t.count > 0 then
814: a0.extend(t.count);
815: a1.extend(t.count);
816: a2.extend(t.count);
1297: procedure calculatepayoff(p_api_version NUMBER
1298: , p_init_msg_list VARCHAR2
1299: , p_loan_id NUMBER
1300: , p_payoff_date DATE
1301: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1302: , p4_a1 out nocopy JTF_NUMBER_TABLE
1303: , p4_a2 out nocopy JTF_NUMBER_TABLE
1304: , p4_a3 out nocopy JTF_NUMBER_TABLE
1305: , x_return_status out nocopy VARCHAR2
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1450: ) return number
1451:
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1450: ) return number
1451:
1452: as
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1450: ) return number
1451:
1452: as
1453: ddp_loan_details lns_financials.loan_details_rec;
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
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
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
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
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1716: )
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
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
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
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
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2011: )
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2208: )
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
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
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
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2386: )
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2576: , p3_a26 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2576: , p3_a26 out nocopy JTF_NUMBER_TABLE
2577: , x_return_status out nocopy VARCHAR2
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2672: , p5_a26 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2672: , p5_a26 out nocopy JTF_NUMBER_TABLE
2673: , x_return_status out nocopy VARCHAR2
2772: , p5_a24 out nocopy NUMBER
2773: , p5_a25 out nocopy NUMBER
2774: , p5_a26 out nocopy NUMBER
2775: , p6_a0 out nocopy JTF_NUMBER_TABLE
2776: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2783: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2784: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2785: , x_return_status out nocopy VARCHAR2
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2783: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2784: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2785: , x_return_status out nocopy VARCHAR2
2786: , x_msg_count out nocopy NUMBER
2787: , x_msg_data out nocopy VARCHAR2
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2783: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2784: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2785: , x_return_status out nocopy VARCHAR2
2786: , x_msg_count out nocopy NUMBER
2787: , x_msg_data out nocopy VARCHAR2
2788: )
2896: , p3_a24 out nocopy NUMBER
2897: , p3_a25 out nocopy NUMBER
2898: , p3_a26 out nocopy NUMBER
2899: , p4_a0 out nocopy JTF_NUMBER_TABLE
2900: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2907: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
2908: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
2909: , x_return_status out nocopy VARCHAR2
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2907: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
2908: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
2909: , x_return_status out nocopy VARCHAR2
2910: , x_msg_count out nocopy NUMBER
2911: , x_msg_data out nocopy VARCHAR2
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2907: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
2908: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
2909: , x_return_status out nocopy VARCHAR2
2910: , x_msg_count out nocopy NUMBER
2911: , x_msg_data out nocopy VARCHAR2
2912: )