7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: ) as
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
105: , a27 out nocopy JTF_DATE_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
105: , a27 out nocopy JTF_DATE_TABLE
106: , a28 out nocopy JTF_DATE_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
105: , a27 out nocopy JTF_DATE_TABLE
106: , a28 out nocopy JTF_DATE_TABLE
107: ) as
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
168: a27 := JTF_DATE_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: if t.count > 0 then
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
253: , a11 JTF_VARCHAR2_TABLE_100
254: ) as
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
253: , a11 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;
256: begin
257: if a0 is not null and a0.count > 0 then
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
294: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: ) as
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
294: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: ) as
296: ddindx binary_integer; indx binary_integer;
297: begin
298: if t is null or t.count = 0 then
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
323: a11 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
323: a11 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);
327: a2.extend(t.count);
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
398: , p9_a27 in out nocopy JTF_DATE_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
398: , p9_a27 in out nocopy JTF_DATE_TABLE
399: , p9_a28 in out nocopy JTF_DATE_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
398: , p9_a27 in out nocopy JTF_DATE_TABLE
399: , p9_a28 in out nocopy JTF_DATE_TABLE
400: )
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
522: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
523: )
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
522: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
523: )
524:
525: as
526: ddp_x_prd_myworkorder_txn_tbl ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl;
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
628: , p10_a27 out nocopy JTF_DATE_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
628: , p10_a27 out nocopy JTF_DATE_TABLE
629: , p10_a28 out nocopy JTF_DATE_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
628: , p10_a27 out nocopy JTF_DATE_TABLE
629: , p10_a28 out nocopy JTF_DATE_TABLE
630: )