15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if a0 is not null and a0.count > 0 then
128: , a12 out nocopy JTF_NUMBER_TABLE
129: , a13 out nocopy JTF_NUMBER_TABLE
130: , a14 out nocopy JTF_NUMBER_TABLE
131: , a15 out nocopy JTF_NUMBER_TABLE
132: , a16 out nocopy JTF_VARCHAR2_TABLE_100
133: , a17 out nocopy JTF_VARCHAR2_TABLE_200
134: , a18 out nocopy JTF_VARCHAR2_TABLE_200
135: , a19 out nocopy JTF_VARCHAR2_TABLE_200
136: , a20 out nocopy JTF_VARCHAR2_TABLE_200
157: , a41 out nocopy JTF_NUMBER_TABLE
158: , a42 out nocopy JTF_NUMBER_TABLE
159: , a43 out nocopy JTF_NUMBER_TABLE
160: , a44 out nocopy JTF_NUMBER_TABLE
161: , a45 out nocopy JTF_VARCHAR2_TABLE_100
162: , a46 out nocopy JTF_VARCHAR2_TABLE_100
163: , a47 out nocopy JTF_VARCHAR2_TABLE_100
164: ) as
165: ddindx binary_integer; indx binary_integer;
158: , a42 out nocopy JTF_NUMBER_TABLE
159: , a43 out nocopy JTF_NUMBER_TABLE
160: , a44 out nocopy JTF_NUMBER_TABLE
161: , a45 out nocopy JTF_VARCHAR2_TABLE_100
162: , a46 out nocopy JTF_VARCHAR2_TABLE_100
163: , a47 out nocopy JTF_VARCHAR2_TABLE_100
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
159: , a43 out nocopy JTF_NUMBER_TABLE
160: , a44 out nocopy JTF_NUMBER_TABLE
161: , a45 out nocopy JTF_VARCHAR2_TABLE_100
162: , a46 out nocopy JTF_VARCHAR2_TABLE_100
163: , a47 out nocopy JTF_VARCHAR2_TABLE_100
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
167: if t is null or t.count = 0 then
180: a12 := JTF_NUMBER_TABLE();
181: a13 := JTF_NUMBER_TABLE();
182: a14 := JTF_NUMBER_TABLE();
183: a15 := JTF_NUMBER_TABLE();
184: a16 := JTF_VARCHAR2_TABLE_100();
185: a17 := JTF_VARCHAR2_TABLE_200();
186: a18 := JTF_VARCHAR2_TABLE_200();
187: a19 := JTF_VARCHAR2_TABLE_200();
188: a20 := JTF_VARCHAR2_TABLE_200();
209: a41 := JTF_NUMBER_TABLE();
210: a42 := JTF_NUMBER_TABLE();
211: a43 := JTF_NUMBER_TABLE();
212: a44 := JTF_NUMBER_TABLE();
213: a45 := JTF_VARCHAR2_TABLE_100();
214: a46 := JTF_VARCHAR2_TABLE_100();
215: a47 := JTF_VARCHAR2_TABLE_100();
216: else
217: a0 := JTF_NUMBER_TABLE();
210: a42 := JTF_NUMBER_TABLE();
211: a43 := JTF_NUMBER_TABLE();
212: a44 := JTF_NUMBER_TABLE();
213: a45 := JTF_VARCHAR2_TABLE_100();
214: a46 := JTF_VARCHAR2_TABLE_100();
215: a47 := JTF_VARCHAR2_TABLE_100();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
211: a43 := JTF_NUMBER_TABLE();
212: a44 := JTF_NUMBER_TABLE();
213: a45 := JTF_VARCHAR2_TABLE_100();
214: a46 := JTF_VARCHAR2_TABLE_100();
215: a47 := JTF_VARCHAR2_TABLE_100();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_NUMBER_TABLE();
229: a12 := JTF_NUMBER_TABLE();
230: a13 := JTF_NUMBER_TABLE();
231: a14 := JTF_NUMBER_TABLE();
232: a15 := JTF_NUMBER_TABLE();
233: a16 := JTF_VARCHAR2_TABLE_100();
234: a17 := JTF_VARCHAR2_TABLE_200();
235: a18 := JTF_VARCHAR2_TABLE_200();
236: a19 := JTF_VARCHAR2_TABLE_200();
237: a20 := JTF_VARCHAR2_TABLE_200();
258: a41 := JTF_NUMBER_TABLE();
259: a42 := JTF_NUMBER_TABLE();
260: a43 := JTF_NUMBER_TABLE();
261: a44 := JTF_NUMBER_TABLE();
262: a45 := JTF_VARCHAR2_TABLE_100();
263: a46 := JTF_VARCHAR2_TABLE_100();
264: a47 := JTF_VARCHAR2_TABLE_100();
265: if t.count > 0 then
266: a0.extend(t.count);
259: a42 := JTF_NUMBER_TABLE();
260: a43 := JTF_NUMBER_TABLE();
261: a44 := JTF_NUMBER_TABLE();
262: a45 := JTF_VARCHAR2_TABLE_100();
263: a46 := JTF_VARCHAR2_TABLE_100();
264: a47 := JTF_VARCHAR2_TABLE_100();
265: if t.count > 0 then
266: a0.extend(t.count);
267: a1.extend(t.count);
260: a43 := JTF_NUMBER_TABLE();
261: a44 := JTF_NUMBER_TABLE();
262: a45 := JTF_VARCHAR2_TABLE_100();
263: a46 := JTF_VARCHAR2_TABLE_100();
264: a47 := JTF_VARCHAR2_TABLE_100();
265: if t.count > 0 then
266: a0.extend(t.count);
267: a1.extend(t.count);
268: a2.extend(t.count);
433: , p0_a12 JTF_NUMBER_TABLE
434: , p0_a13 JTF_NUMBER_TABLE
435: , p0_a14 JTF_NUMBER_TABLE
436: , p0_a15 JTF_NUMBER_TABLE
437: , p0_a16 JTF_VARCHAR2_TABLE_100
438: , p0_a17 JTF_VARCHAR2_TABLE_200
439: , p0_a18 JTF_VARCHAR2_TABLE_200
440: , p0_a19 JTF_VARCHAR2_TABLE_200
441: , p0_a20 JTF_VARCHAR2_TABLE_200
462: , p0_a41 JTF_NUMBER_TABLE
463: , p0_a42 JTF_NUMBER_TABLE
464: , p0_a43 JTF_NUMBER_TABLE
465: , p0_a44 JTF_NUMBER_TABLE
466: , p0_a45 JTF_VARCHAR2_TABLE_100
467: , p0_a46 JTF_VARCHAR2_TABLE_100
468: , p0_a47 JTF_VARCHAR2_TABLE_100
469: , p_loan_id NUMBER
470: , p_init_msg_list VARCHAR2
463: , p0_a42 JTF_NUMBER_TABLE
464: , p0_a43 JTF_NUMBER_TABLE
465: , p0_a44 JTF_NUMBER_TABLE
466: , p0_a45 JTF_VARCHAR2_TABLE_100
467: , p0_a46 JTF_VARCHAR2_TABLE_100
468: , p0_a47 JTF_VARCHAR2_TABLE_100
469: , p_loan_id NUMBER
470: , p_init_msg_list VARCHAR2
471: , p_commit VARCHAR2
464: , p0_a43 JTF_NUMBER_TABLE
465: , p0_a44 JTF_NUMBER_TABLE
466: , p0_a45 JTF_VARCHAR2_TABLE_100
467: , p0_a46 JTF_VARCHAR2_TABLE_100
468: , p0_a47 JTF_VARCHAR2_TABLE_100
469: , p_loan_id NUMBER
470: , p_init_msg_list VARCHAR2
471: , p_commit VARCHAR2
472: , x_return_status out nocopy VARCHAR2
573: , p0_a12 JTF_NUMBER_TABLE
574: , p0_a13 JTF_NUMBER_TABLE
575: , p0_a14 JTF_NUMBER_TABLE
576: , p0_a15 JTF_NUMBER_TABLE
577: , p0_a16 JTF_VARCHAR2_TABLE_100
578: , p0_a17 JTF_VARCHAR2_TABLE_200
579: , p0_a18 JTF_VARCHAR2_TABLE_200
580: , p0_a19 JTF_VARCHAR2_TABLE_200
581: , p0_a20 JTF_VARCHAR2_TABLE_200
602: , p0_a41 JTF_NUMBER_TABLE
603: , p0_a42 JTF_NUMBER_TABLE
604: , p0_a43 JTF_NUMBER_TABLE
605: , p0_a44 JTF_NUMBER_TABLE
606: , p0_a45 JTF_VARCHAR2_TABLE_100
607: , p0_a46 JTF_VARCHAR2_TABLE_100
608: , p0_a47 JTF_VARCHAR2_TABLE_100
609: , p_loan_id NUMBER
610: , p_init_msg_list VARCHAR2
603: , p0_a42 JTF_NUMBER_TABLE
604: , p0_a43 JTF_NUMBER_TABLE
605: , p0_a44 JTF_NUMBER_TABLE
606: , p0_a45 JTF_VARCHAR2_TABLE_100
607: , p0_a46 JTF_VARCHAR2_TABLE_100
608: , p0_a47 JTF_VARCHAR2_TABLE_100
609: , p_loan_id NUMBER
610: , p_init_msg_list VARCHAR2
611: , p_commit VARCHAR2
604: , p0_a43 JTF_NUMBER_TABLE
605: , p0_a44 JTF_NUMBER_TABLE
606: , p0_a45 JTF_VARCHAR2_TABLE_100
607: , p0_a46 JTF_VARCHAR2_TABLE_100
608: , p0_a47 JTF_VARCHAR2_TABLE_100
609: , p_loan_id NUMBER
610: , p_init_msg_list VARCHAR2
611: , p_commit VARCHAR2
612: , x_return_status out nocopy VARCHAR2
963: , p0_a12 JTF_NUMBER_TABLE
964: , p0_a13 JTF_NUMBER_TABLE
965: , p0_a14 JTF_NUMBER_TABLE
966: , p0_a15 JTF_NUMBER_TABLE
967: , p0_a16 JTF_VARCHAR2_TABLE_100
968: , p0_a17 JTF_VARCHAR2_TABLE_200
969: , p0_a18 JTF_VARCHAR2_TABLE_200
970: , p0_a19 JTF_VARCHAR2_TABLE_200
971: , p0_a20 JTF_VARCHAR2_TABLE_200
992: , p0_a41 JTF_NUMBER_TABLE
993: , p0_a42 JTF_NUMBER_TABLE
994: , p0_a43 JTF_NUMBER_TABLE
995: , p0_a44 JTF_NUMBER_TABLE
996: , p0_a45 JTF_VARCHAR2_TABLE_100
997: , p0_a46 JTF_VARCHAR2_TABLE_100
998: , p0_a47 JTF_VARCHAR2_TABLE_100
999: , p_loan_id NUMBER
1000: , p_create_flag number
993: , p0_a42 JTF_NUMBER_TABLE
994: , p0_a43 JTF_NUMBER_TABLE
995: , p0_a44 JTF_NUMBER_TABLE
996: , p0_a45 JTF_VARCHAR2_TABLE_100
997: , p0_a46 JTF_VARCHAR2_TABLE_100
998: , p0_a47 JTF_VARCHAR2_TABLE_100
999: , p_loan_id NUMBER
1000: , p_create_flag number
1001: , x_installment out nocopy NUMBER
994: , p0_a43 JTF_NUMBER_TABLE
995: , p0_a44 JTF_NUMBER_TABLE
996: , p0_a45 JTF_VARCHAR2_TABLE_100
997: , p0_a46 JTF_VARCHAR2_TABLE_100
998: , p0_a47 JTF_VARCHAR2_TABLE_100
999: , p_loan_id NUMBER
1000: , p_create_flag number
1001: , x_installment out nocopy NUMBER
1002: , x_return_status out nocopy VARCHAR2
1236: , p7_a12 in out nocopy JTF_NUMBER_TABLE
1237: , p7_a13 in out nocopy JTF_NUMBER_TABLE
1238: , p7_a14 in out nocopy JTF_NUMBER_TABLE
1239: , p7_a15 in out nocopy JTF_NUMBER_TABLE
1240: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1241: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1242: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1243: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1244: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1265: , p7_a41 in out nocopy JTF_NUMBER_TABLE
1266: , p7_a42 in out nocopy JTF_NUMBER_TABLE
1267: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1268: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1269: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1270: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1271: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1272: , x_return_status out nocopy VARCHAR2
1273: , x_msg_count out nocopy NUMBER
1266: , p7_a42 in out nocopy JTF_NUMBER_TABLE
1267: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1268: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1269: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1270: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1271: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1272: , x_return_status out nocopy VARCHAR2
1273: , x_msg_count out nocopy NUMBER
1274: , x_msg_data out nocopy VARCHAR2
1267: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1268: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1269: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1270: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1271: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1272: , x_return_status out nocopy VARCHAR2
1273: , x_msg_count out nocopy NUMBER
1274: , x_msg_data out nocopy VARCHAR2
1275: )
1437: , p7_a12 out nocopy JTF_NUMBER_TABLE
1438: , p7_a13 out nocopy JTF_NUMBER_TABLE
1439: , p7_a14 out nocopy JTF_NUMBER_TABLE
1440: , p7_a15 out nocopy JTF_NUMBER_TABLE
1441: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
1442: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
1443: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
1444: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
1445: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
1466: , p7_a41 out nocopy JTF_NUMBER_TABLE
1467: , p7_a42 out nocopy JTF_NUMBER_TABLE
1468: , p7_a43 out nocopy JTF_NUMBER_TABLE
1469: , p7_a44 out nocopy JTF_NUMBER_TABLE
1470: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
1471: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1472: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
1473: , x_return_status out nocopy VARCHAR2
1474: , x_msg_count out nocopy NUMBER
1467: , p7_a42 out nocopy JTF_NUMBER_TABLE
1468: , p7_a43 out nocopy JTF_NUMBER_TABLE
1469: , p7_a44 out nocopy JTF_NUMBER_TABLE
1470: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
1471: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1472: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
1473: , x_return_status out nocopy VARCHAR2
1474: , x_msg_count out nocopy NUMBER
1475: , x_msg_data out nocopy VARCHAR2
1468: , p7_a43 out nocopy JTF_NUMBER_TABLE
1469: , p7_a44 out nocopy JTF_NUMBER_TABLE
1470: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
1471: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
1472: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
1473: , x_return_status out nocopy VARCHAR2
1474: , x_msg_count out nocopy NUMBER
1475: , x_msg_data out nocopy VARCHAR2
1476: )
1589: , p7_a12 in out nocopy JTF_NUMBER_TABLE
1590: , p7_a13 in out nocopy JTF_NUMBER_TABLE
1591: , p7_a14 in out nocopy JTF_NUMBER_TABLE
1592: , p7_a15 in out nocopy JTF_NUMBER_TABLE
1593: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1594: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1595: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1596: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1597: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1618: , p7_a41 in out nocopy JTF_NUMBER_TABLE
1619: , p7_a42 in out nocopy JTF_NUMBER_TABLE
1620: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1621: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1622: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1623: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1624: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1625: , x_return_status out nocopy VARCHAR2
1626: , x_msg_count out nocopy NUMBER
1619: , p7_a42 in out nocopy JTF_NUMBER_TABLE
1620: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1621: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1622: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1623: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1624: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1625: , x_return_status out nocopy VARCHAR2
1626: , x_msg_count out nocopy NUMBER
1627: , x_msg_data out nocopy VARCHAR2
1620: , p7_a43 in out nocopy JTF_NUMBER_TABLE
1621: , p7_a44 in out nocopy JTF_NUMBER_TABLE
1622: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1623: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1624: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1625: , x_return_status out nocopy VARCHAR2
1626: , x_msg_count out nocopy NUMBER
1627: , x_msg_data out nocopy VARCHAR2
1628: )
1792: , p9_a12 in out nocopy JTF_NUMBER_TABLE
1793: , p9_a13 in out nocopy JTF_NUMBER_TABLE
1794: , p9_a14 in out nocopy JTF_NUMBER_TABLE
1795: , p9_a15 in out nocopy JTF_NUMBER_TABLE
1796: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1797: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1798: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1799: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1800: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1821: , p9_a41 in out nocopy JTF_NUMBER_TABLE
1822: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1823: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1824: , p9_a44 in out nocopy JTF_NUMBER_TABLE
1825: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1827: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1828: , x_return_status out nocopy VARCHAR2
1829: , x_msg_count out nocopy NUMBER
1822: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1823: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1824: , p9_a44 in out nocopy JTF_NUMBER_TABLE
1825: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1827: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1828: , x_return_status out nocopy VARCHAR2
1829: , x_msg_count out nocopy NUMBER
1830: , x_msg_data out nocopy VARCHAR2
1823: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1824: , p9_a44 in out nocopy JTF_NUMBER_TABLE
1825: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
1827: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
1828: , x_return_status out nocopy VARCHAR2
1829: , x_msg_count out nocopy NUMBER
1830: , x_msg_data out nocopy VARCHAR2
1831: )