23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
98: , a1 out nocopy JTF_VARCHAR2_TABLE_200
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a9 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as
127: ddindx binary_integer; indx binary_integer;
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
131: a1 := JTF_VARCHAR2_TABLE_200();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_NUMBER_TABLE();
138: a8 := JTF_VARCHAR2_TABLE_500();
139: a9 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_500();
169: a9 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
191: a1.extend(t.count);
262: , a1 JTF_VARCHAR2_TABLE_200
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_NUMBER_TABLE
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_VARCHAR2_TABLE_500
270: , a9 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_NUMBER_TABLE
287: , a26 JTF_DATE_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
337: , a1 out nocopy JTF_VARCHAR2_TABLE_200
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_NUMBER_TABLE
343: , a7 out nocopy JTF_NUMBER_TABLE
344: , a8 out nocopy JTF_VARCHAR2_TABLE_500
345: , a9 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as
366: ddindx binary_integer; indx binary_integer;
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_NUMBER_TABLE
362: , a26 out nocopy JTF_DATE_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
370: a1 := JTF_VARCHAR2_TABLE_200();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_NUMBER_TABLE();
376: a7 := JTF_NUMBER_TABLE();
377: a8 := JTF_VARCHAR2_TABLE_500();
378: a9 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_NUMBER_TABLE();
395: a26 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_NUMBER_TABLE();
406: a7 := JTF_NUMBER_TABLE();
407: a8 := JTF_VARCHAR2_TABLE_500();
408: a9 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_NUMBER_TABLE();
425: a26 := JTF_DATE_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
430: a1.extend(t.count);
661: , p5_a1 JTF_VARCHAR2_TABLE_200
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_NUMBER_TABLE
667: , p5_a7 JTF_NUMBER_TABLE
668: , p5_a8 JTF_VARCHAR2_TABLE_500
669: , p5_a9 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_NUMBER_TABLE
686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_NUMBER_TABLE
696: , p6_a7 out nocopy JTF_NUMBER_TABLE
697: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_NUMBER_TABLE
715: , p6_a26 out nocopy JTF_DATE_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
720: as
911: , p5_a1 JTF_VARCHAR2_TABLE_200
912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE
916: , p5_a6 JTF_NUMBER_TABLE
917: , p5_a7 JTF_NUMBER_TABLE
918: , p5_a8 JTF_VARCHAR2_TABLE_500
919: , p5_a9 JTF_VARCHAR2_TABLE_500
932: , p5_a22 JTF_VARCHAR2_TABLE_500
933: , p5_a23 JTF_NUMBER_TABLE
934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE
938: , p5_a28 JTF_NUMBER_TABLE
939: )
940:
933: , p5_a23 JTF_NUMBER_TABLE
934: , p5_a24 JTF_NUMBER_TABLE
935: , p5_a25 JTF_NUMBER_TABLE
936: , p5_a26 JTF_DATE_TABLE
937: , p5_a27 JTF_DATE_TABLE
938: , p5_a28 JTF_NUMBER_TABLE
939: )
940:
941: as
1160: , p5_a1 JTF_VARCHAR2_TABLE_200
1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE
1165: , p5_a6 JTF_NUMBER_TABLE
1166: , p5_a7 JTF_NUMBER_TABLE
1167: , p5_a8 JTF_VARCHAR2_TABLE_500
1168: , p5_a9 JTF_VARCHAR2_TABLE_500
1181: , p5_a22 JTF_VARCHAR2_TABLE_500
1182: , p5_a23 JTF_NUMBER_TABLE
1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1182: , p5_a23 JTF_NUMBER_TABLE
1183: , p5_a24 JTF_NUMBER_TABLE
1184: , p5_a25 JTF_NUMBER_TABLE
1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE
1194: , p6_a6 out nocopy JTF_NUMBER_TABLE
1195: , p6_a7 out nocopy JTF_NUMBER_TABLE
1196: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1197: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1210: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1211: , p6_a23 out nocopy JTF_NUMBER_TABLE
1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE
1216: , p6_a28 out nocopy JTF_NUMBER_TABLE
1217: )
1218:
1211: , p6_a23 out nocopy JTF_NUMBER_TABLE
1212: , p6_a24 out nocopy JTF_NUMBER_TABLE
1213: , p6_a25 out nocopy JTF_NUMBER_TABLE
1214: , p6_a26 out nocopy JTF_DATE_TABLE
1215: , p6_a27 out nocopy JTF_DATE_TABLE
1216: , p6_a28 out nocopy JTF_NUMBER_TABLE
1217: )
1218:
1219: as
1410: , p5_a1 JTF_VARCHAR2_TABLE_200
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_NUMBER_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_VARCHAR2_TABLE_500
1418: , p5_a9 JTF_VARCHAR2_TABLE_500
1431: , p5_a22 JTF_VARCHAR2_TABLE_500
1432: , p5_a23 JTF_NUMBER_TABLE
1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE
1437: , p5_a28 JTF_NUMBER_TABLE
1438: )
1439:
1432: , p5_a23 JTF_NUMBER_TABLE
1433: , p5_a24 JTF_NUMBER_TABLE
1434: , p5_a25 JTF_NUMBER_TABLE
1435: , p5_a26 JTF_DATE_TABLE
1436: , p5_a27 JTF_DATE_TABLE
1437: , p5_a28 JTF_NUMBER_TABLE
1438: )
1439:
1440: as
1597: , p5_a1 JTF_VARCHAR2_TABLE_200
1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE
1602: , p5_a6 JTF_NUMBER_TABLE
1603: , p5_a7 JTF_NUMBER_TABLE
1604: , p5_a8 JTF_VARCHAR2_TABLE_500
1605: , p5_a9 JTF_VARCHAR2_TABLE_500
1618: , p5_a22 JTF_VARCHAR2_TABLE_500
1619: , p5_a23 JTF_NUMBER_TABLE
1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE
1624: , p5_a28 JTF_NUMBER_TABLE
1625: )
1626:
1619: , p5_a23 JTF_NUMBER_TABLE
1620: , p5_a24 JTF_NUMBER_TABLE
1621: , p5_a25 JTF_NUMBER_TABLE
1622: , p5_a26 JTF_DATE_TABLE
1623: , p5_a27 JTF_DATE_TABLE
1624: , p5_a28 JTF_NUMBER_TABLE
1625: )
1626:
1627: as
1686: , p0_a1 JTF_VARCHAR2_TABLE_200
1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE
1691: , p0_a6 JTF_NUMBER_TABLE
1692: , p0_a7 JTF_NUMBER_TABLE
1693: , p0_a8 JTF_VARCHAR2_TABLE_500
1694: , p0_a9 JTF_VARCHAR2_TABLE_500
1707: , p0_a22 JTF_VARCHAR2_TABLE_500
1708: , p0_a23 JTF_NUMBER_TABLE
1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE
1713: , p0_a28 JTF_NUMBER_TABLE
1714: )
1715:
1708: , p0_a23 JTF_NUMBER_TABLE
1709: , p0_a24 JTF_NUMBER_TABLE
1710: , p0_a25 JTF_NUMBER_TABLE
1711: , p0_a26 JTF_DATE_TABLE
1712: , p0_a27 JTF_DATE_TABLE
1713: , p0_a28 JTF_NUMBER_TABLE
1714: )
1715:
1716: as