40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
109: , a18 out nocopy JTF_VARCHAR2_TABLE_500
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
139: a18 := JTF_VARCHAR2_TABLE_500();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
166: a18 := JTF_VARCHAR2_TABLE_500();
167: a19 := JTF_VARCHAR2_TABLE_500();
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
176: a1.extend(t.count);
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_VARCHAR2_TABLE_200
245: , a5 JTF_VARCHAR2_TABLE_2000
246: , a6 JTF_NUMBER_TABLE
247: , a7 JTF_DATE_TABLE
248: , a8 JTF_NUMBER_TABLE
249: , a9 JTF_DATE_TABLE
250: , a10 JTF_NUMBER_TABLE
251: ) as
245: , a5 JTF_VARCHAR2_TABLE_2000
246: , a6 JTF_NUMBER_TABLE
247: , a7 JTF_DATE_TABLE
248: , a8 JTF_NUMBER_TABLE
249: , a9 JTF_DATE_TABLE
250: , a10 JTF_NUMBER_TABLE
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , a4 out nocopy JTF_VARCHAR2_TABLE_200
284: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
285: , a6 out nocopy JTF_NUMBER_TABLE
286: , a7 out nocopy JTF_DATE_TABLE
287: , a8 out nocopy JTF_NUMBER_TABLE
288: , a9 out nocopy JTF_DATE_TABLE
289: , a10 out nocopy JTF_NUMBER_TABLE
290: ) as
284: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
285: , a6 out nocopy JTF_NUMBER_TABLE
286: , a7 out nocopy JTF_DATE_TABLE
287: , a8 out nocopy JTF_NUMBER_TABLE
288: , a9 out nocopy JTF_DATE_TABLE
289: , a10 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
297: a3 := JTF_VARCHAR2_TABLE_100();
298: a4 := JTF_VARCHAR2_TABLE_200();
299: a5 := JTF_VARCHAR2_TABLE_2000();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_DATE_TABLE();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
305: else
299: a5 := JTF_VARCHAR2_TABLE_2000();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_DATE_TABLE();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_200();
311: a5 := JTF_VARCHAR2_TABLE_2000();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_DATE_TABLE();
316: a10 := JTF_NUMBER_TABLE();
317: if t.count > 0 then
311: a5 := JTF_VARCHAR2_TABLE_2000();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_DATE_TABLE();
316: a10 := JTF_NUMBER_TABLE();
317: if t.count > 0 then
318: a0.extend(t.count);
319: a1.extend(t.count);
374: , a21 JTF_VARCHAR2_TABLE_500
375: , a22 JTF_VARCHAR2_TABLE_500
376: , a23 JTF_VARCHAR2_TABLE_500
377: , a24 JTF_NUMBER_TABLE
378: , a25 JTF_DATE_TABLE
379: , a26 JTF_NUMBER_TABLE
380: , a27 JTF_DATE_TABLE
381: , a28 JTF_NUMBER_TABLE
382: ) as
376: , a23 JTF_VARCHAR2_TABLE_500
377: , a24 JTF_NUMBER_TABLE
378: , a25 JTF_DATE_TABLE
379: , a26 JTF_NUMBER_TABLE
380: , a27 JTF_DATE_TABLE
381: , a28 JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
449: , a21 out nocopy JTF_VARCHAR2_TABLE_500
450: , a22 out nocopy JTF_VARCHAR2_TABLE_500
451: , a23 out nocopy JTF_VARCHAR2_TABLE_500
452: , a24 out nocopy JTF_NUMBER_TABLE
453: , a25 out nocopy JTF_DATE_TABLE
454: , a26 out nocopy JTF_NUMBER_TABLE
455: , a27 out nocopy JTF_DATE_TABLE
456: , a28 out nocopy JTF_NUMBER_TABLE
457: ) as
451: , a23 out nocopy JTF_VARCHAR2_TABLE_500
452: , a24 out nocopy JTF_NUMBER_TABLE
453: , a25 out nocopy JTF_DATE_TABLE
454: , a26 out nocopy JTF_NUMBER_TABLE
455: , a27 out nocopy JTF_DATE_TABLE
456: , a28 out nocopy JTF_NUMBER_TABLE
457: ) as
458: ddindx binary_integer; indx binary_integer;
459: begin
482: a21 := JTF_VARCHAR2_TABLE_500();
483: a22 := JTF_VARCHAR2_TABLE_500();
484: a23 := JTF_VARCHAR2_TABLE_500();
485: a24 := JTF_NUMBER_TABLE();
486: a25 := JTF_DATE_TABLE();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
484: a23 := JTF_VARCHAR2_TABLE_500();
485: a24 := JTF_NUMBER_TABLE();
486: a25 := JTF_DATE_TABLE();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
512: a21 := JTF_VARCHAR2_TABLE_500();
513: a22 := JTF_VARCHAR2_TABLE_500();
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_NUMBER_TABLE();
516: a25 := JTF_DATE_TABLE();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_DATE_TABLE();
519: a28 := JTF_NUMBER_TABLE();
520: if t.count > 0 then
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_NUMBER_TABLE();
516: a25 := JTF_DATE_TABLE();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_DATE_TABLE();
519: a28 := JTF_NUMBER_TABLE();
520: if t.count > 0 then
521: a0.extend(t.count);
522: a1.extend(t.count);
773: , p5_a21 JTF_VARCHAR2_TABLE_500
774: , p5_a22 JTF_VARCHAR2_TABLE_500
775: , p5_a23 JTF_VARCHAR2_TABLE_500
776: , p5_a24 JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
775: , p5_a23 JTF_VARCHAR2_TABLE_500
776: , p5_a24 JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
783: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
802: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
803: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
804: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
805: , p6_a24 out nocopy JTF_NUMBER_TABLE
806: , p6_a25 out nocopy JTF_DATE_TABLE
807: , p6_a26 out nocopy JTF_NUMBER_TABLE
808: , p6_a27 out nocopy JTF_DATE_TABLE
809: , p6_a28 out nocopy JTF_NUMBER_TABLE
810: )
804: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
805: , p6_a24 out nocopy JTF_NUMBER_TABLE
806: , p6_a25 out nocopy JTF_DATE_TABLE
807: , p6_a26 out nocopy JTF_NUMBER_TABLE
808: , p6_a27 out nocopy JTF_DATE_TABLE
809: , p6_a28 out nocopy JTF_NUMBER_TABLE
810: )
811:
812: as
1023: , p5_a21 JTF_VARCHAR2_TABLE_500
1024: , p5_a22 JTF_VARCHAR2_TABLE_500
1025: , p5_a23 JTF_VARCHAR2_TABLE_500
1026: , p5_a24 JTF_NUMBER_TABLE
1027: , p5_a25 JTF_DATE_TABLE
1028: , p5_a26 JTF_NUMBER_TABLE
1029: , p5_a27 JTF_DATE_TABLE
1030: , p5_a28 JTF_NUMBER_TABLE
1031: )
1025: , p5_a23 JTF_VARCHAR2_TABLE_500
1026: , p5_a24 JTF_NUMBER_TABLE
1027: , p5_a25 JTF_DATE_TABLE
1028: , p5_a26 JTF_NUMBER_TABLE
1029: , p5_a27 JTF_DATE_TABLE
1030: , p5_a28 JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1272: , p5_a21 JTF_VARCHAR2_TABLE_500
1273: , p5_a22 JTF_VARCHAR2_TABLE_500
1274: , p5_a23 JTF_VARCHAR2_TABLE_500
1275: , p5_a24 JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1274: , p5_a23 JTF_VARCHAR2_TABLE_500
1275: , p5_a24 JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1282: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1301: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1302: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1303: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1304: , p6_a24 out nocopy JTF_NUMBER_TABLE
1305: , p6_a25 out nocopy JTF_DATE_TABLE
1306: , p6_a26 out nocopy JTF_NUMBER_TABLE
1307: , p6_a27 out nocopy JTF_DATE_TABLE
1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1309: )
1303: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1304: , p6_a24 out nocopy JTF_NUMBER_TABLE
1305: , p6_a25 out nocopy JTF_DATE_TABLE
1306: , p6_a26 out nocopy JTF_NUMBER_TABLE
1307: , p6_a27 out nocopy JTF_DATE_TABLE
1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1309: )
1310:
1311: as
1522: , p5_a21 JTF_VARCHAR2_TABLE_500
1523: , p5_a22 JTF_VARCHAR2_TABLE_500
1524: , p5_a23 JTF_VARCHAR2_TABLE_500
1525: , p5_a24 JTF_NUMBER_TABLE
1526: , p5_a25 JTF_DATE_TABLE
1527: , p5_a26 JTF_NUMBER_TABLE
1528: , p5_a27 JTF_DATE_TABLE
1529: , p5_a28 JTF_NUMBER_TABLE
1530: )
1524: , p5_a23 JTF_VARCHAR2_TABLE_500
1525: , p5_a24 JTF_NUMBER_TABLE
1526: , p5_a25 JTF_DATE_TABLE
1527: , p5_a26 JTF_NUMBER_TABLE
1528: , p5_a27 JTF_DATE_TABLE
1529: , p5_a28 JTF_NUMBER_TABLE
1530: )
1531:
1532: as
1709: , p5_a21 JTF_VARCHAR2_TABLE_500
1710: , p5_a22 JTF_VARCHAR2_TABLE_500
1711: , p5_a23 JTF_VARCHAR2_TABLE_500
1712: , p5_a24 JTF_NUMBER_TABLE
1713: , p5_a25 JTF_DATE_TABLE
1714: , p5_a26 JTF_NUMBER_TABLE
1715: , p5_a27 JTF_DATE_TABLE
1716: , p5_a28 JTF_NUMBER_TABLE
1717: )
1711: , p5_a23 JTF_VARCHAR2_TABLE_500
1712: , p5_a24 JTF_NUMBER_TABLE
1713: , p5_a25 JTF_DATE_TABLE
1714: , p5_a26 JTF_NUMBER_TABLE
1715: , p5_a27 JTF_DATE_TABLE
1716: , p5_a28 JTF_NUMBER_TABLE
1717: )
1718:
1719: as