4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: ) as
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: ) as
40: ddindx binary_integer; indx binary_integer;
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if a0 is not null and a0.count > 0 then
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_VARCHAR2_TABLE_300
95: , a3 out nocopy JTF_VARCHAR2_TABLE_300
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_VARCHAR2_TABLE_100
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_VARCHAR2_TABLE_100
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_VARCHAR2_TABLE_100
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_VARCHAR2_TABLE_100
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_VARCHAR2_TABLE_100
107: , a15 out nocopy JTF_VARCHAR2_TABLE_100
108: , a16 out nocopy JTF_DATE_TABLE
109: , a17 out nocopy JTF_NUMBER_TABLE
110: , a18 out nocopy JTF_NUMBER_TABLE
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_VARCHAR2_TABLE_100
107: , a15 out nocopy JTF_VARCHAR2_TABLE_100
108: , a16 out nocopy JTF_DATE_TABLE
109: , a17 out nocopy JTF_NUMBER_TABLE
110: , a18 out nocopy JTF_NUMBER_TABLE
111: , a19 out nocopy JTF_DATE_TABLE
113: , a21 out nocopy JTF_DATE_TABLE
114: , a22 out nocopy JTF_NUMBER_TABLE
115: , a23 out nocopy JTF_NUMBER_TABLE
116: , a24 out nocopy JTF_NUMBER_TABLE
117: , a25 out nocopy JTF_VARCHAR2_TABLE_100
118: , a26 out nocopy JTF_NUMBER_TABLE
119: , a27 out nocopy JTF_VARCHAR2_TABLE_300
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
116: , a24 out nocopy JTF_NUMBER_TABLE
117: , a25 out nocopy JTF_VARCHAR2_TABLE_100
118: , a26 out nocopy JTF_NUMBER_TABLE
119: , a27 out nocopy JTF_VARCHAR2_TABLE_300
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
117: , a25 out nocopy JTF_VARCHAR2_TABLE_100
118: , a26 out nocopy JTF_NUMBER_TABLE
119: , a27 out nocopy JTF_VARCHAR2_TABLE_300
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
118: , a26 out nocopy JTF_NUMBER_TABLE
119: , a27 out nocopy JTF_VARCHAR2_TABLE_300
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
126: , a34 out nocopy JTF_NUMBER_TABLE
119: , a27 out nocopy JTF_VARCHAR2_TABLE_300
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
126: , a34 out nocopy JTF_NUMBER_TABLE
127: , a35 out nocopy JTF_VARCHAR2_TABLE_100
120: , a28 out nocopy JTF_VARCHAR2_TABLE_100
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
126: , a34 out nocopy JTF_NUMBER_TABLE
127: , a35 out nocopy JTF_VARCHAR2_TABLE_100
128: ) as
121: , a29 out nocopy JTF_VARCHAR2_TABLE_100
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
126: , a34 out nocopy JTF_NUMBER_TABLE
127: , a35 out nocopy JTF_VARCHAR2_TABLE_100
128: ) as
129: ddindx binary_integer; indx binary_integer;
123: , a31 out nocopy JTF_VARCHAR2_TABLE_100
124: , a32 out nocopy JTF_VARCHAR2_TABLE_100
125: , a33 out nocopy JTF_VARCHAR2_TABLE_100
126: , a34 out nocopy JTF_NUMBER_TABLE
127: , a35 out nocopy JTF_VARCHAR2_TABLE_100
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if t is null or t.count = 0 then
133: a1 := JTF_NUMBER_TABLE();
134: a2 := JTF_VARCHAR2_TABLE_300();
135: a3 := JTF_VARCHAR2_TABLE_300();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_VARCHAR2_TABLE_100();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_VARCHAR2_TABLE_100();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_VARCHAR2_TABLE_100();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_VARCHAR2_TABLE_100();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_VARCHAR2_TABLE_100();
147: a15 := JTF_VARCHAR2_TABLE_100();
148: a16 := JTF_DATE_TABLE();
149: a17 := JTF_NUMBER_TABLE();
150: a18 := JTF_NUMBER_TABLE();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_VARCHAR2_TABLE_100();
147: a15 := JTF_VARCHAR2_TABLE_100();
148: a16 := JTF_DATE_TABLE();
149: a17 := JTF_NUMBER_TABLE();
150: a18 := JTF_NUMBER_TABLE();
151: a19 := JTF_DATE_TABLE();
153: a21 := JTF_DATE_TABLE();
154: a22 := JTF_NUMBER_TABLE();
155: a23 := JTF_NUMBER_TABLE();
156: a24 := JTF_NUMBER_TABLE();
157: a25 := JTF_VARCHAR2_TABLE_100();
158: a26 := JTF_NUMBER_TABLE();
159: a27 := JTF_VARCHAR2_TABLE_300();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
156: a24 := JTF_NUMBER_TABLE();
157: a25 := JTF_VARCHAR2_TABLE_100();
158: a26 := JTF_NUMBER_TABLE();
159: a27 := JTF_VARCHAR2_TABLE_300();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
157: a25 := JTF_VARCHAR2_TABLE_100();
158: a26 := JTF_NUMBER_TABLE();
159: a27 := JTF_VARCHAR2_TABLE_300();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
158: a26 := JTF_NUMBER_TABLE();
159: a27 := JTF_VARCHAR2_TABLE_300();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
166: a34 := JTF_NUMBER_TABLE();
159: a27 := JTF_VARCHAR2_TABLE_300();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
166: a34 := JTF_NUMBER_TABLE();
167: a35 := JTF_VARCHAR2_TABLE_100();
160: a28 := JTF_VARCHAR2_TABLE_100();
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
166: a34 := JTF_NUMBER_TABLE();
167: a35 := JTF_VARCHAR2_TABLE_100();
168: else
161: a29 := JTF_VARCHAR2_TABLE_100();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
166: a34 := JTF_NUMBER_TABLE();
167: a35 := JTF_VARCHAR2_TABLE_100();
168: else
169: a0 := JTF_NUMBER_TABLE();
163: a31 := JTF_VARCHAR2_TABLE_100();
164: a32 := JTF_VARCHAR2_TABLE_100();
165: a33 := JTF_VARCHAR2_TABLE_100();
166: a34 := JTF_NUMBER_TABLE();
167: a35 := JTF_VARCHAR2_TABLE_100();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_VARCHAR2_TABLE_300();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_VARCHAR2_TABLE_300();
172: a3 := JTF_VARCHAR2_TABLE_300();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_VARCHAR2_TABLE_100();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_VARCHAR2_TABLE_100();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_DATE_TABLE();
186: a17 := JTF_NUMBER_TABLE();
187: a18 := JTF_NUMBER_TABLE();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_DATE_TABLE();
186: a17 := JTF_NUMBER_TABLE();
187: a18 := JTF_NUMBER_TABLE();
188: a19 := JTF_DATE_TABLE();
190: a21 := JTF_DATE_TABLE();
191: a22 := JTF_NUMBER_TABLE();
192: a23 := JTF_NUMBER_TABLE();
193: a24 := JTF_NUMBER_TABLE();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_NUMBER_TABLE();
196: a27 := JTF_VARCHAR2_TABLE_300();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_NUMBER_TABLE();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_NUMBER_TABLE();
196: a27 := JTF_VARCHAR2_TABLE_300();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_NUMBER_TABLE();
196: a27 := JTF_VARCHAR2_TABLE_300();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_NUMBER_TABLE();
196: a27 := JTF_VARCHAR2_TABLE_300();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_NUMBER_TABLE();
196: a27 := JTF_VARCHAR2_TABLE_300();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_NUMBER_TABLE();
204: a35 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_NUMBER_TABLE();
204: a35 := JTF_VARCHAR2_TABLE_100();
205: if t.count > 0 then
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_NUMBER_TABLE();
204: a35 := JTF_VARCHAR2_TABLE_100();
205: if t.count > 0 then
206: a0.extend(t.count);
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_NUMBER_TABLE();
204: a35 := JTF_VARCHAR2_TABLE_100();
205: if t.count > 0 then
206: a0.extend(t.count);
207: a1.extend(t.count);
208: a2.extend(t.count);
292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_300
294: , a3 JTF_VARCHAR2_TABLE_300
295: , a4 JTF_NUMBER_TABLE
296: , a5 JTF_VARCHAR2_TABLE_100
297: , a6 JTF_NUMBER_TABLE
298: , a7 JTF_NUMBER_TABLE
299: , a8 JTF_NUMBER_TABLE
300: , a9 JTF_VARCHAR2_TABLE_100
296: , a5 JTF_VARCHAR2_TABLE_100
297: , a6 JTF_NUMBER_TABLE
298: , a7 JTF_NUMBER_TABLE
299: , a8 JTF_NUMBER_TABLE
300: , a9 JTF_VARCHAR2_TABLE_100
301: , a10 JTF_VARCHAR2_TABLE_100
302: , a11 JTF_NUMBER_TABLE
303: , a12 JTF_NUMBER_TABLE
304: , a13 JTF_NUMBER_TABLE
297: , a6 JTF_NUMBER_TABLE
298: , a7 JTF_NUMBER_TABLE
299: , a8 JTF_NUMBER_TABLE
300: , a9 JTF_VARCHAR2_TABLE_100
301: , a10 JTF_VARCHAR2_TABLE_100
302: , a11 JTF_NUMBER_TABLE
303: , a12 JTF_NUMBER_TABLE
304: , a13 JTF_NUMBER_TABLE
305: , a14 JTF_VARCHAR2_TABLE_100
301: , a10 JTF_VARCHAR2_TABLE_100
302: , a11 JTF_NUMBER_TABLE
303: , a12 JTF_NUMBER_TABLE
304: , a13 JTF_NUMBER_TABLE
305: , a14 JTF_VARCHAR2_TABLE_100
306: , a15 JTF_VARCHAR2_TABLE_100
307: , a16 JTF_DATE_TABLE
308: , a17 JTF_NUMBER_TABLE
309: , a18 JTF_DATE_TABLE
302: , a11 JTF_NUMBER_TABLE
303: , a12 JTF_NUMBER_TABLE
304: , a13 JTF_NUMBER_TABLE
305: , a14 JTF_VARCHAR2_TABLE_100
306: , a15 JTF_VARCHAR2_TABLE_100
307: , a16 JTF_DATE_TABLE
308: , a17 JTF_NUMBER_TABLE
309: , a18 JTF_DATE_TABLE
310: , a19 JTF_NUMBER_TABLE
312: , a21 JTF_DATE_TABLE
313: , a22 JTF_NUMBER_TABLE
314: , a23 JTF_NUMBER_TABLE
315: , a24 JTF_NUMBER_TABLE
316: , a25 JTF_VARCHAR2_TABLE_100
317: , a26 JTF_NUMBER_TABLE
318: , a27 JTF_VARCHAR2_TABLE_300
319: , a28 JTF_VARCHAR2_TABLE_100
320: , a29 JTF_VARCHAR2_TABLE_100
315: , a24 JTF_NUMBER_TABLE
316: , a25 JTF_VARCHAR2_TABLE_100
317: , a26 JTF_NUMBER_TABLE
318: , a27 JTF_VARCHAR2_TABLE_300
319: , a28 JTF_VARCHAR2_TABLE_100
320: , a29 JTF_VARCHAR2_TABLE_100
321: , a30 JTF_VARCHAR2_TABLE_100
322: , a31 JTF_NUMBER_TABLE
323: , a32 JTF_VARCHAR2_TABLE_100
316: , a25 JTF_VARCHAR2_TABLE_100
317: , a26 JTF_NUMBER_TABLE
318: , a27 JTF_VARCHAR2_TABLE_300
319: , a28 JTF_VARCHAR2_TABLE_100
320: , a29 JTF_VARCHAR2_TABLE_100
321: , a30 JTF_VARCHAR2_TABLE_100
322: , a31 JTF_NUMBER_TABLE
323: , a32 JTF_VARCHAR2_TABLE_100
324: , a33 JTF_NUMBER_TABLE
317: , a26 JTF_NUMBER_TABLE
318: , a27 JTF_VARCHAR2_TABLE_300
319: , a28 JTF_VARCHAR2_TABLE_100
320: , a29 JTF_VARCHAR2_TABLE_100
321: , a30 JTF_VARCHAR2_TABLE_100
322: , a31 JTF_NUMBER_TABLE
323: , a32 JTF_VARCHAR2_TABLE_100
324: , a33 JTF_NUMBER_TABLE
325: , a34 JTF_NUMBER_TABLE
319: , a28 JTF_VARCHAR2_TABLE_100
320: , a29 JTF_VARCHAR2_TABLE_100
321: , a30 JTF_VARCHAR2_TABLE_100
322: , a31 JTF_NUMBER_TABLE
323: , a32 JTF_VARCHAR2_TABLE_100
324: , a33 JTF_NUMBER_TABLE
325: , a34 JTF_NUMBER_TABLE
326: , a35 JTF_VARCHAR2_TABLE_100
327: , a36 JTF_VARCHAR2_TABLE_100
322: , a31 JTF_NUMBER_TABLE
323: , a32 JTF_VARCHAR2_TABLE_100
324: , a33 JTF_NUMBER_TABLE
325: , a34 JTF_NUMBER_TABLE
326: , a35 JTF_VARCHAR2_TABLE_100
327: , a36 JTF_VARCHAR2_TABLE_100
328: , a37 JTF_VARCHAR2_TABLE_100
329: , a38 JTF_NUMBER_TABLE
330: , a39 JTF_VARCHAR2_TABLE_100
323: , a32 JTF_VARCHAR2_TABLE_100
324: , a33 JTF_NUMBER_TABLE
325: , a34 JTF_NUMBER_TABLE
326: , a35 JTF_VARCHAR2_TABLE_100
327: , a36 JTF_VARCHAR2_TABLE_100
328: , a37 JTF_VARCHAR2_TABLE_100
329: , a38 JTF_NUMBER_TABLE
330: , a39 JTF_VARCHAR2_TABLE_100
331: ) as
324: , a33 JTF_NUMBER_TABLE
325: , a34 JTF_NUMBER_TABLE
326: , a35 JTF_VARCHAR2_TABLE_100
327: , a36 JTF_VARCHAR2_TABLE_100
328: , a37 JTF_VARCHAR2_TABLE_100
329: , a38 JTF_NUMBER_TABLE
330: , a39 JTF_VARCHAR2_TABLE_100
331: ) as
332: ddindx binary_integer; indx binary_integer;
326: , a35 JTF_VARCHAR2_TABLE_100
327: , a36 JTF_VARCHAR2_TABLE_100
328: , a37 JTF_VARCHAR2_TABLE_100
329: , a38 JTF_NUMBER_TABLE
330: , a39 JTF_VARCHAR2_TABLE_100
331: ) as
332: ddindx binary_integer; indx binary_integer;
333: begin
334: if a0 is not null and a0.count > 0 then
389: , a1 out nocopy JTF_NUMBER_TABLE
390: , a2 out nocopy JTF_VARCHAR2_TABLE_300
391: , a3 out nocopy JTF_VARCHAR2_TABLE_300
392: , a4 out nocopy JTF_NUMBER_TABLE
393: , a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , a6 out nocopy JTF_NUMBER_TABLE
395: , a7 out nocopy JTF_NUMBER_TABLE
396: , a8 out nocopy JTF_NUMBER_TABLE
397: , a9 out nocopy JTF_VARCHAR2_TABLE_100
393: , a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , a6 out nocopy JTF_NUMBER_TABLE
395: , a7 out nocopy JTF_NUMBER_TABLE
396: , a8 out nocopy JTF_NUMBER_TABLE
397: , a9 out nocopy JTF_VARCHAR2_TABLE_100
398: , a10 out nocopy JTF_VARCHAR2_TABLE_100
399: , a11 out nocopy JTF_NUMBER_TABLE
400: , a12 out nocopy JTF_NUMBER_TABLE
401: , a13 out nocopy JTF_NUMBER_TABLE
394: , a6 out nocopy JTF_NUMBER_TABLE
395: , a7 out nocopy JTF_NUMBER_TABLE
396: , a8 out nocopy JTF_NUMBER_TABLE
397: , a9 out nocopy JTF_VARCHAR2_TABLE_100
398: , a10 out nocopy JTF_VARCHAR2_TABLE_100
399: , a11 out nocopy JTF_NUMBER_TABLE
400: , a12 out nocopy JTF_NUMBER_TABLE
401: , a13 out nocopy JTF_NUMBER_TABLE
402: , a14 out nocopy JTF_VARCHAR2_TABLE_100
398: , a10 out nocopy JTF_VARCHAR2_TABLE_100
399: , a11 out nocopy JTF_NUMBER_TABLE
400: , a12 out nocopy JTF_NUMBER_TABLE
401: , a13 out nocopy JTF_NUMBER_TABLE
402: , a14 out nocopy JTF_VARCHAR2_TABLE_100
403: , a15 out nocopy JTF_VARCHAR2_TABLE_100
404: , a16 out nocopy JTF_DATE_TABLE
405: , a17 out nocopy JTF_NUMBER_TABLE
406: , a18 out nocopy JTF_DATE_TABLE
399: , a11 out nocopy JTF_NUMBER_TABLE
400: , a12 out nocopy JTF_NUMBER_TABLE
401: , a13 out nocopy JTF_NUMBER_TABLE
402: , a14 out nocopy JTF_VARCHAR2_TABLE_100
403: , a15 out nocopy JTF_VARCHAR2_TABLE_100
404: , a16 out nocopy JTF_DATE_TABLE
405: , a17 out nocopy JTF_NUMBER_TABLE
406: , a18 out nocopy JTF_DATE_TABLE
407: , a19 out nocopy JTF_NUMBER_TABLE
409: , a21 out nocopy JTF_DATE_TABLE
410: , a22 out nocopy JTF_NUMBER_TABLE
411: , a23 out nocopy JTF_NUMBER_TABLE
412: , a24 out nocopy JTF_NUMBER_TABLE
413: , a25 out nocopy JTF_VARCHAR2_TABLE_100
414: , a26 out nocopy JTF_NUMBER_TABLE
415: , a27 out nocopy JTF_VARCHAR2_TABLE_300
416: , a28 out nocopy JTF_VARCHAR2_TABLE_100
417: , a29 out nocopy JTF_VARCHAR2_TABLE_100
412: , a24 out nocopy JTF_NUMBER_TABLE
413: , a25 out nocopy JTF_VARCHAR2_TABLE_100
414: , a26 out nocopy JTF_NUMBER_TABLE
415: , a27 out nocopy JTF_VARCHAR2_TABLE_300
416: , a28 out nocopy JTF_VARCHAR2_TABLE_100
417: , a29 out nocopy JTF_VARCHAR2_TABLE_100
418: , a30 out nocopy JTF_VARCHAR2_TABLE_100
419: , a31 out nocopy JTF_NUMBER_TABLE
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
413: , a25 out nocopy JTF_VARCHAR2_TABLE_100
414: , a26 out nocopy JTF_NUMBER_TABLE
415: , a27 out nocopy JTF_VARCHAR2_TABLE_300
416: , a28 out nocopy JTF_VARCHAR2_TABLE_100
417: , a29 out nocopy JTF_VARCHAR2_TABLE_100
418: , a30 out nocopy JTF_VARCHAR2_TABLE_100
419: , a31 out nocopy JTF_NUMBER_TABLE
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
421: , a33 out nocopy JTF_NUMBER_TABLE
414: , a26 out nocopy JTF_NUMBER_TABLE
415: , a27 out nocopy JTF_VARCHAR2_TABLE_300
416: , a28 out nocopy JTF_VARCHAR2_TABLE_100
417: , a29 out nocopy JTF_VARCHAR2_TABLE_100
418: , a30 out nocopy JTF_VARCHAR2_TABLE_100
419: , a31 out nocopy JTF_NUMBER_TABLE
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
421: , a33 out nocopy JTF_NUMBER_TABLE
422: , a34 out nocopy JTF_NUMBER_TABLE
416: , a28 out nocopy JTF_VARCHAR2_TABLE_100
417: , a29 out nocopy JTF_VARCHAR2_TABLE_100
418: , a30 out nocopy JTF_VARCHAR2_TABLE_100
419: , a31 out nocopy JTF_NUMBER_TABLE
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
421: , a33 out nocopy JTF_NUMBER_TABLE
422: , a34 out nocopy JTF_NUMBER_TABLE
423: , a35 out nocopy JTF_VARCHAR2_TABLE_100
424: , a36 out nocopy JTF_VARCHAR2_TABLE_100
419: , a31 out nocopy JTF_NUMBER_TABLE
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
421: , a33 out nocopy JTF_NUMBER_TABLE
422: , a34 out nocopy JTF_NUMBER_TABLE
423: , a35 out nocopy JTF_VARCHAR2_TABLE_100
424: , a36 out nocopy JTF_VARCHAR2_TABLE_100
425: , a37 out nocopy JTF_VARCHAR2_TABLE_100
426: , a38 out nocopy JTF_NUMBER_TABLE
427: , a39 out nocopy JTF_VARCHAR2_TABLE_100
420: , a32 out nocopy JTF_VARCHAR2_TABLE_100
421: , a33 out nocopy JTF_NUMBER_TABLE
422: , a34 out nocopy JTF_NUMBER_TABLE
423: , a35 out nocopy JTF_VARCHAR2_TABLE_100
424: , a36 out nocopy JTF_VARCHAR2_TABLE_100
425: , a37 out nocopy JTF_VARCHAR2_TABLE_100
426: , a38 out nocopy JTF_NUMBER_TABLE
427: , a39 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
421: , a33 out nocopy JTF_NUMBER_TABLE
422: , a34 out nocopy JTF_NUMBER_TABLE
423: , a35 out nocopy JTF_VARCHAR2_TABLE_100
424: , a36 out nocopy JTF_VARCHAR2_TABLE_100
425: , a37 out nocopy JTF_VARCHAR2_TABLE_100
426: , a38 out nocopy JTF_NUMBER_TABLE
427: , a39 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
423: , a35 out nocopy JTF_VARCHAR2_TABLE_100
424: , a36 out nocopy JTF_VARCHAR2_TABLE_100
425: , a37 out nocopy JTF_VARCHAR2_TABLE_100
426: , a38 out nocopy JTF_NUMBER_TABLE
427: , a39 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_300();
435: a3 := JTF_VARCHAR2_TABLE_300();
436: a4 := JTF_NUMBER_TABLE();
437: a5 := JTF_VARCHAR2_TABLE_100();
438: a6 := JTF_NUMBER_TABLE();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_NUMBER_TABLE();
441: a9 := JTF_VARCHAR2_TABLE_100();
437: a5 := JTF_VARCHAR2_TABLE_100();
438: a6 := JTF_NUMBER_TABLE();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_NUMBER_TABLE();
441: a9 := JTF_VARCHAR2_TABLE_100();
442: a10 := JTF_VARCHAR2_TABLE_100();
443: a11 := JTF_NUMBER_TABLE();
444: a12 := JTF_NUMBER_TABLE();
445: a13 := JTF_NUMBER_TABLE();
438: a6 := JTF_NUMBER_TABLE();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_NUMBER_TABLE();
441: a9 := JTF_VARCHAR2_TABLE_100();
442: a10 := JTF_VARCHAR2_TABLE_100();
443: a11 := JTF_NUMBER_TABLE();
444: a12 := JTF_NUMBER_TABLE();
445: a13 := JTF_NUMBER_TABLE();
446: a14 := JTF_VARCHAR2_TABLE_100();
442: a10 := JTF_VARCHAR2_TABLE_100();
443: a11 := JTF_NUMBER_TABLE();
444: a12 := JTF_NUMBER_TABLE();
445: a13 := JTF_NUMBER_TABLE();
446: a14 := JTF_VARCHAR2_TABLE_100();
447: a15 := JTF_VARCHAR2_TABLE_100();
448: a16 := JTF_DATE_TABLE();
449: a17 := JTF_NUMBER_TABLE();
450: a18 := JTF_DATE_TABLE();
443: a11 := JTF_NUMBER_TABLE();
444: a12 := JTF_NUMBER_TABLE();
445: a13 := JTF_NUMBER_TABLE();
446: a14 := JTF_VARCHAR2_TABLE_100();
447: a15 := JTF_VARCHAR2_TABLE_100();
448: a16 := JTF_DATE_TABLE();
449: a17 := JTF_NUMBER_TABLE();
450: a18 := JTF_DATE_TABLE();
451: a19 := JTF_NUMBER_TABLE();
453: a21 := JTF_DATE_TABLE();
454: a22 := JTF_NUMBER_TABLE();
455: a23 := JTF_NUMBER_TABLE();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_VARCHAR2_TABLE_300();
460: a28 := JTF_VARCHAR2_TABLE_100();
461: a29 := JTF_VARCHAR2_TABLE_100();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_VARCHAR2_TABLE_300();
460: a28 := JTF_VARCHAR2_TABLE_100();
461: a29 := JTF_VARCHAR2_TABLE_100();
462: a30 := JTF_VARCHAR2_TABLE_100();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_VARCHAR2_TABLE_100();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_VARCHAR2_TABLE_300();
460: a28 := JTF_VARCHAR2_TABLE_100();
461: a29 := JTF_VARCHAR2_TABLE_100();
462: a30 := JTF_VARCHAR2_TABLE_100();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_VARCHAR2_TABLE_100();
465: a33 := JTF_NUMBER_TABLE();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_VARCHAR2_TABLE_300();
460: a28 := JTF_VARCHAR2_TABLE_100();
461: a29 := JTF_VARCHAR2_TABLE_100();
462: a30 := JTF_VARCHAR2_TABLE_100();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_VARCHAR2_TABLE_100();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_NUMBER_TABLE();
460: a28 := JTF_VARCHAR2_TABLE_100();
461: a29 := JTF_VARCHAR2_TABLE_100();
462: a30 := JTF_VARCHAR2_TABLE_100();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_VARCHAR2_TABLE_100();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_NUMBER_TABLE();
467: a35 := JTF_VARCHAR2_TABLE_100();
468: a36 := JTF_VARCHAR2_TABLE_100();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_VARCHAR2_TABLE_100();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_NUMBER_TABLE();
467: a35 := JTF_VARCHAR2_TABLE_100();
468: a36 := JTF_VARCHAR2_TABLE_100();
469: a37 := JTF_VARCHAR2_TABLE_100();
470: a38 := JTF_NUMBER_TABLE();
471: a39 := JTF_VARCHAR2_TABLE_100();
464: a32 := JTF_VARCHAR2_TABLE_100();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_NUMBER_TABLE();
467: a35 := JTF_VARCHAR2_TABLE_100();
468: a36 := JTF_VARCHAR2_TABLE_100();
469: a37 := JTF_VARCHAR2_TABLE_100();
470: a38 := JTF_NUMBER_TABLE();
471: a39 := JTF_VARCHAR2_TABLE_100();
472: else
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_NUMBER_TABLE();
467: a35 := JTF_VARCHAR2_TABLE_100();
468: a36 := JTF_VARCHAR2_TABLE_100();
469: a37 := JTF_VARCHAR2_TABLE_100();
470: a38 := JTF_NUMBER_TABLE();
471: a39 := JTF_VARCHAR2_TABLE_100();
472: else
473: a0 := JTF_NUMBER_TABLE();
467: a35 := JTF_VARCHAR2_TABLE_100();
468: a36 := JTF_VARCHAR2_TABLE_100();
469: a37 := JTF_VARCHAR2_TABLE_100();
470: a38 := JTF_NUMBER_TABLE();
471: a39 := JTF_VARCHAR2_TABLE_100();
472: else
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_VARCHAR2_TABLE_300();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_VARCHAR2_TABLE_300();
476: a3 := JTF_VARCHAR2_TABLE_300();
477: a4 := JTF_NUMBER_TABLE();
478: a5 := JTF_VARCHAR2_TABLE_100();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_NUMBER_TABLE();
482: a9 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_VARCHAR2_TABLE_100();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_NUMBER_TABLE();
482: a9 := JTF_VARCHAR2_TABLE_100();
483: a10 := JTF_VARCHAR2_TABLE_100();
484: a11 := JTF_NUMBER_TABLE();
485: a12 := JTF_NUMBER_TABLE();
486: a13 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_NUMBER_TABLE();
482: a9 := JTF_VARCHAR2_TABLE_100();
483: a10 := JTF_VARCHAR2_TABLE_100();
484: a11 := JTF_NUMBER_TABLE();
485: a12 := JTF_NUMBER_TABLE();
486: a13 := JTF_NUMBER_TABLE();
487: a14 := JTF_VARCHAR2_TABLE_100();
483: a10 := JTF_VARCHAR2_TABLE_100();
484: a11 := JTF_NUMBER_TABLE();
485: a12 := JTF_NUMBER_TABLE();
486: a13 := JTF_NUMBER_TABLE();
487: a14 := JTF_VARCHAR2_TABLE_100();
488: a15 := JTF_VARCHAR2_TABLE_100();
489: a16 := JTF_DATE_TABLE();
490: a17 := JTF_NUMBER_TABLE();
491: a18 := JTF_DATE_TABLE();
484: a11 := JTF_NUMBER_TABLE();
485: a12 := JTF_NUMBER_TABLE();
486: a13 := JTF_NUMBER_TABLE();
487: a14 := JTF_VARCHAR2_TABLE_100();
488: a15 := JTF_VARCHAR2_TABLE_100();
489: a16 := JTF_DATE_TABLE();
490: a17 := JTF_NUMBER_TABLE();
491: a18 := JTF_DATE_TABLE();
492: a19 := JTF_NUMBER_TABLE();
494: a21 := JTF_DATE_TABLE();
495: a22 := JTF_NUMBER_TABLE();
496: a23 := JTF_NUMBER_TABLE();
497: a24 := JTF_NUMBER_TABLE();
498: a25 := JTF_VARCHAR2_TABLE_100();
499: a26 := JTF_NUMBER_TABLE();
500: a27 := JTF_VARCHAR2_TABLE_300();
501: a28 := JTF_VARCHAR2_TABLE_100();
502: a29 := JTF_VARCHAR2_TABLE_100();
497: a24 := JTF_NUMBER_TABLE();
498: a25 := JTF_VARCHAR2_TABLE_100();
499: a26 := JTF_NUMBER_TABLE();
500: a27 := JTF_VARCHAR2_TABLE_300();
501: a28 := JTF_VARCHAR2_TABLE_100();
502: a29 := JTF_VARCHAR2_TABLE_100();
503: a30 := JTF_VARCHAR2_TABLE_100();
504: a31 := JTF_NUMBER_TABLE();
505: a32 := JTF_VARCHAR2_TABLE_100();
498: a25 := JTF_VARCHAR2_TABLE_100();
499: a26 := JTF_NUMBER_TABLE();
500: a27 := JTF_VARCHAR2_TABLE_300();
501: a28 := JTF_VARCHAR2_TABLE_100();
502: a29 := JTF_VARCHAR2_TABLE_100();
503: a30 := JTF_VARCHAR2_TABLE_100();
504: a31 := JTF_NUMBER_TABLE();
505: a32 := JTF_VARCHAR2_TABLE_100();
506: a33 := JTF_NUMBER_TABLE();
499: a26 := JTF_NUMBER_TABLE();
500: a27 := JTF_VARCHAR2_TABLE_300();
501: a28 := JTF_VARCHAR2_TABLE_100();
502: a29 := JTF_VARCHAR2_TABLE_100();
503: a30 := JTF_VARCHAR2_TABLE_100();
504: a31 := JTF_NUMBER_TABLE();
505: a32 := JTF_VARCHAR2_TABLE_100();
506: a33 := JTF_NUMBER_TABLE();
507: a34 := JTF_NUMBER_TABLE();
501: a28 := JTF_VARCHAR2_TABLE_100();
502: a29 := JTF_VARCHAR2_TABLE_100();
503: a30 := JTF_VARCHAR2_TABLE_100();
504: a31 := JTF_NUMBER_TABLE();
505: a32 := JTF_VARCHAR2_TABLE_100();
506: a33 := JTF_NUMBER_TABLE();
507: a34 := JTF_NUMBER_TABLE();
508: a35 := JTF_VARCHAR2_TABLE_100();
509: a36 := JTF_VARCHAR2_TABLE_100();
504: a31 := JTF_NUMBER_TABLE();
505: a32 := JTF_VARCHAR2_TABLE_100();
506: a33 := JTF_NUMBER_TABLE();
507: a34 := JTF_NUMBER_TABLE();
508: a35 := JTF_VARCHAR2_TABLE_100();
509: a36 := JTF_VARCHAR2_TABLE_100();
510: a37 := JTF_VARCHAR2_TABLE_100();
511: a38 := JTF_NUMBER_TABLE();
512: a39 := JTF_VARCHAR2_TABLE_100();
505: a32 := JTF_VARCHAR2_TABLE_100();
506: a33 := JTF_NUMBER_TABLE();
507: a34 := JTF_NUMBER_TABLE();
508: a35 := JTF_VARCHAR2_TABLE_100();
509: a36 := JTF_VARCHAR2_TABLE_100();
510: a37 := JTF_VARCHAR2_TABLE_100();
511: a38 := JTF_NUMBER_TABLE();
512: a39 := JTF_VARCHAR2_TABLE_100();
513: if t.count > 0 then
506: a33 := JTF_NUMBER_TABLE();
507: a34 := JTF_NUMBER_TABLE();
508: a35 := JTF_VARCHAR2_TABLE_100();
509: a36 := JTF_VARCHAR2_TABLE_100();
510: a37 := JTF_VARCHAR2_TABLE_100();
511: a38 := JTF_NUMBER_TABLE();
512: a39 := JTF_VARCHAR2_TABLE_100();
513: if t.count > 0 then
514: a0.extend(t.count);
508: a35 := JTF_VARCHAR2_TABLE_100();
509: a36 := JTF_VARCHAR2_TABLE_100();
510: a37 := JTF_VARCHAR2_TABLE_100();
511: a38 := JTF_NUMBER_TABLE();
512: a39 := JTF_VARCHAR2_TABLE_100();
513: if t.count > 0 then
514: a0.extend(t.count);
515: a1.extend(t.count);
516: a2.extend(t.count);
604: end if;
605: end rosetta_table_copy_out_p4;
606:
607: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
608: , a1 JTF_VARCHAR2_TABLE_100
609: , a2 JTF_NUMBER_TABLE
610: , a3 JTF_NUMBER_TABLE
611: , a4 JTF_NUMBER_TABLE
612: , a5 JTF_VARCHAR2_TABLE_300
609: , a2 JTF_NUMBER_TABLE
610: , a3 JTF_NUMBER_TABLE
611: , a4 JTF_NUMBER_TABLE
612: , a5 JTF_VARCHAR2_TABLE_300
613: , a6 JTF_VARCHAR2_TABLE_100
614: , a7 JTF_NUMBER_TABLE
615: , a8 JTF_NUMBER_TABLE
616: , a9 JTF_NUMBER_TABLE
617: , a10 JTF_NUMBER_TABLE
615: , a8 JTF_NUMBER_TABLE
616: , a9 JTF_NUMBER_TABLE
617: , a10 JTF_NUMBER_TABLE
618: , a11 JTF_VARCHAR2_TABLE_300
619: , a12 JTF_VARCHAR2_TABLE_100
620: , a13 JTF_NUMBER_TABLE
621: , a14 JTF_NUMBER_TABLE
622: , a15 JTF_NUMBER_TABLE
623: , a16 JTF_NUMBER_TABLE
673: end if;
674: end if;
675: end rosetta_table_copy_in_p6;
676: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
677: , a1 out nocopy JTF_VARCHAR2_TABLE_100
678: , a2 out nocopy JTF_NUMBER_TABLE
679: , a3 out nocopy JTF_NUMBER_TABLE
680: , a4 out nocopy JTF_NUMBER_TABLE
681: , a5 out nocopy JTF_VARCHAR2_TABLE_300
678: , a2 out nocopy JTF_NUMBER_TABLE
679: , a3 out nocopy JTF_NUMBER_TABLE
680: , a4 out nocopy JTF_NUMBER_TABLE
681: , a5 out nocopy JTF_VARCHAR2_TABLE_300
682: , a6 out nocopy JTF_VARCHAR2_TABLE_100
683: , a7 out nocopy JTF_NUMBER_TABLE
684: , a8 out nocopy JTF_NUMBER_TABLE
685: , a9 out nocopy JTF_NUMBER_TABLE
686: , a10 out nocopy JTF_NUMBER_TABLE
684: , a8 out nocopy JTF_NUMBER_TABLE
685: , a9 out nocopy JTF_NUMBER_TABLE
686: , a10 out nocopy JTF_NUMBER_TABLE
687: , a11 out nocopy JTF_VARCHAR2_TABLE_300
688: , a12 out nocopy JTF_VARCHAR2_TABLE_100
689: , a13 out nocopy JTF_NUMBER_TABLE
690: , a14 out nocopy JTF_NUMBER_TABLE
691: , a15 out nocopy JTF_NUMBER_TABLE
692: , a16 out nocopy JTF_NUMBER_TABLE
703: ddindx binary_integer; indx binary_integer;
704: begin
705: if t is null or t.count = 0 then
706: a0 := JTF_NUMBER_TABLE();
707: a1 := JTF_VARCHAR2_TABLE_100();
708: a2 := JTF_NUMBER_TABLE();
709: a3 := JTF_NUMBER_TABLE();
710: a4 := JTF_NUMBER_TABLE();
711: a5 := JTF_VARCHAR2_TABLE_300();
708: a2 := JTF_NUMBER_TABLE();
709: a3 := JTF_NUMBER_TABLE();
710: a4 := JTF_NUMBER_TABLE();
711: a5 := JTF_VARCHAR2_TABLE_300();
712: a6 := JTF_VARCHAR2_TABLE_100();
713: a7 := JTF_NUMBER_TABLE();
714: a8 := JTF_NUMBER_TABLE();
715: a9 := JTF_NUMBER_TABLE();
716: a10 := JTF_NUMBER_TABLE();
714: a8 := JTF_NUMBER_TABLE();
715: a9 := JTF_NUMBER_TABLE();
716: a10 := JTF_NUMBER_TABLE();
717: a11 := JTF_VARCHAR2_TABLE_300();
718: a12 := JTF_VARCHAR2_TABLE_100();
719: a13 := JTF_NUMBER_TABLE();
720: a14 := JTF_NUMBER_TABLE();
721: a15 := JTF_NUMBER_TABLE();
722: a16 := JTF_NUMBER_TABLE();
730: a24 := JTF_NUMBER_TABLE();
731: a25 := JTF_NUMBER_TABLE();
732: else
733: a0 := JTF_NUMBER_TABLE();
734: a1 := JTF_VARCHAR2_TABLE_100();
735: a2 := JTF_NUMBER_TABLE();
736: a3 := JTF_NUMBER_TABLE();
737: a4 := JTF_NUMBER_TABLE();
738: a5 := JTF_VARCHAR2_TABLE_300();
735: a2 := JTF_NUMBER_TABLE();
736: a3 := JTF_NUMBER_TABLE();
737: a4 := JTF_NUMBER_TABLE();
738: a5 := JTF_VARCHAR2_TABLE_300();
739: a6 := JTF_VARCHAR2_TABLE_100();
740: a7 := JTF_NUMBER_TABLE();
741: a8 := JTF_NUMBER_TABLE();
742: a9 := JTF_NUMBER_TABLE();
743: a10 := JTF_NUMBER_TABLE();
741: a8 := JTF_NUMBER_TABLE();
742: a9 := JTF_NUMBER_TABLE();
743: a10 := JTF_NUMBER_TABLE();
744: a11 := JTF_VARCHAR2_TABLE_300();
745: a12 := JTF_VARCHAR2_TABLE_100();
746: a13 := JTF_NUMBER_TABLE();
747: a14 := JTF_NUMBER_TABLE();
748: a15 := JTF_NUMBER_TABLE();
749: a16 := JTF_NUMBER_TABLE();
839: , p7_a1 out nocopy JTF_NUMBER_TABLE
840: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
841: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
842: , p7_a4 out nocopy JTF_NUMBER_TABLE
843: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 out nocopy JTF_NUMBER_TABLE
845: , p7_a7 out nocopy JTF_NUMBER_TABLE
846: , p7_a8 out nocopy JTF_NUMBER_TABLE
847: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
843: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 out nocopy JTF_NUMBER_TABLE
845: , p7_a7 out nocopy JTF_NUMBER_TABLE
846: , p7_a8 out nocopy JTF_NUMBER_TABLE
847: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
848: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
849: , p7_a11 out nocopy JTF_NUMBER_TABLE
850: , p7_a12 out nocopy JTF_NUMBER_TABLE
851: , p7_a13 out nocopy JTF_NUMBER_TABLE
844: , p7_a6 out nocopy JTF_NUMBER_TABLE
845: , p7_a7 out nocopy JTF_NUMBER_TABLE
846: , p7_a8 out nocopy JTF_NUMBER_TABLE
847: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
848: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
849: , p7_a11 out nocopy JTF_NUMBER_TABLE
850: , p7_a12 out nocopy JTF_NUMBER_TABLE
851: , p7_a13 out nocopy JTF_NUMBER_TABLE
852: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
848: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
849: , p7_a11 out nocopy JTF_NUMBER_TABLE
850: , p7_a12 out nocopy JTF_NUMBER_TABLE
851: , p7_a13 out nocopy JTF_NUMBER_TABLE
852: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
853: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
854: , p7_a16 out nocopy JTF_DATE_TABLE
855: , p7_a17 out nocopy JTF_NUMBER_TABLE
856: , p7_a18 out nocopy JTF_NUMBER_TABLE
849: , p7_a11 out nocopy JTF_NUMBER_TABLE
850: , p7_a12 out nocopy JTF_NUMBER_TABLE
851: , p7_a13 out nocopy JTF_NUMBER_TABLE
852: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
853: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
854: , p7_a16 out nocopy JTF_DATE_TABLE
855: , p7_a17 out nocopy JTF_NUMBER_TABLE
856: , p7_a18 out nocopy JTF_NUMBER_TABLE
857: , p7_a19 out nocopy JTF_DATE_TABLE
859: , p7_a21 out nocopy JTF_DATE_TABLE
860: , p7_a22 out nocopy JTF_NUMBER_TABLE
861: , p7_a23 out nocopy JTF_NUMBER_TABLE
862: , p7_a24 out nocopy JTF_NUMBER_TABLE
863: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
864: , p7_a26 out nocopy JTF_NUMBER_TABLE
865: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
862: , p7_a24 out nocopy JTF_NUMBER_TABLE
863: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
864: , p7_a26 out nocopy JTF_NUMBER_TABLE
865: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
863: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
864: , p7_a26 out nocopy JTF_NUMBER_TABLE
865: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
864: , p7_a26 out nocopy JTF_NUMBER_TABLE
865: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a34 out nocopy JTF_NUMBER_TABLE
865: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a34 out nocopy JTF_NUMBER_TABLE
873: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
866: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a34 out nocopy JTF_NUMBER_TABLE
873: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
874: , x_return_status out nocopy VARCHAR2
867: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
868: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a34 out nocopy JTF_NUMBER_TABLE
873: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
869: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
871: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a34 out nocopy JTF_NUMBER_TABLE
873: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: )
981: , p7_a1 out nocopy JTF_NUMBER_TABLE
982: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
983: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
984: , p7_a4 out nocopy JTF_NUMBER_TABLE
985: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
986: , p7_a6 out nocopy JTF_NUMBER_TABLE
987: , p7_a7 out nocopy JTF_NUMBER_TABLE
988: , p7_a8 out nocopy JTF_NUMBER_TABLE
989: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
985: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
986: , p7_a6 out nocopy JTF_NUMBER_TABLE
987: , p7_a7 out nocopy JTF_NUMBER_TABLE
988: , p7_a8 out nocopy JTF_NUMBER_TABLE
989: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
990: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
991: , p7_a11 out nocopy JTF_NUMBER_TABLE
992: , p7_a12 out nocopy JTF_NUMBER_TABLE
993: , p7_a13 out nocopy JTF_NUMBER_TABLE
986: , p7_a6 out nocopy JTF_NUMBER_TABLE
987: , p7_a7 out nocopy JTF_NUMBER_TABLE
988: , p7_a8 out nocopy JTF_NUMBER_TABLE
989: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
990: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
991: , p7_a11 out nocopy JTF_NUMBER_TABLE
992: , p7_a12 out nocopy JTF_NUMBER_TABLE
993: , p7_a13 out nocopy JTF_NUMBER_TABLE
994: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
990: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
991: , p7_a11 out nocopy JTF_NUMBER_TABLE
992: , p7_a12 out nocopy JTF_NUMBER_TABLE
993: , p7_a13 out nocopy JTF_NUMBER_TABLE
994: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
995: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
996: , p7_a16 out nocopy JTF_DATE_TABLE
997: , p7_a17 out nocopy JTF_NUMBER_TABLE
998: , p7_a18 out nocopy JTF_DATE_TABLE
991: , p7_a11 out nocopy JTF_NUMBER_TABLE
992: , p7_a12 out nocopy JTF_NUMBER_TABLE
993: , p7_a13 out nocopy JTF_NUMBER_TABLE
994: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
995: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
996: , p7_a16 out nocopy JTF_DATE_TABLE
997: , p7_a17 out nocopy JTF_NUMBER_TABLE
998: , p7_a18 out nocopy JTF_DATE_TABLE
999: , p7_a19 out nocopy JTF_NUMBER_TABLE
1001: , p7_a21 out nocopy JTF_DATE_TABLE
1002: , p7_a22 out nocopy JTF_NUMBER_TABLE
1003: , p7_a23 out nocopy JTF_NUMBER_TABLE
1004: , p7_a24 out nocopy JTF_NUMBER_TABLE
1005: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p7_a26 out nocopy JTF_NUMBER_TABLE
1007: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1008: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1004: , p7_a24 out nocopy JTF_NUMBER_TABLE
1005: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p7_a26 out nocopy JTF_NUMBER_TABLE
1007: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1008: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1010: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1011: , p7_a31 out nocopy JTF_NUMBER_TABLE
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p7_a26 out nocopy JTF_NUMBER_TABLE
1007: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1008: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1010: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1011: , p7_a31 out nocopy JTF_NUMBER_TABLE
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1006: , p7_a26 out nocopy JTF_NUMBER_TABLE
1007: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1008: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1010: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1011: , p7_a31 out nocopy JTF_NUMBER_TABLE
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1014: , p7_a34 out nocopy JTF_NUMBER_TABLE
1008: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1009: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1010: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1011: , p7_a31 out nocopy JTF_NUMBER_TABLE
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1014: , p7_a34 out nocopy JTF_NUMBER_TABLE
1015: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1011: , p7_a31 out nocopy JTF_NUMBER_TABLE
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1014: , p7_a34 out nocopy JTF_NUMBER_TABLE
1015: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a38 out nocopy JTF_NUMBER_TABLE
1019: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1012: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1014: , p7_a34 out nocopy JTF_NUMBER_TABLE
1015: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a38 out nocopy JTF_NUMBER_TABLE
1019: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1020: , x_return_status out nocopy VARCHAR2
1013: , p7_a33 out nocopy JTF_NUMBER_TABLE
1014: , p7_a34 out nocopy JTF_NUMBER_TABLE
1015: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a38 out nocopy JTF_NUMBER_TABLE
1019: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1020: , x_return_status out nocopy VARCHAR2
1021: , x_msg_count out nocopy NUMBER
1015: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a38 out nocopy JTF_NUMBER_TABLE
1019: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1020: , x_return_status out nocopy VARCHAR2
1021: , x_msg_count out nocopy NUMBER
1022: , x_msg_data out nocopy VARCHAR2
1023: )
1123: , p_unit_header_id NUMBER
1124: , p_item_instance_id NUMBER
1125: , p_visit_id NUMBER
1126: , p9_a0 out nocopy JTF_NUMBER_TABLE
1127: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p9_a2 out nocopy JTF_NUMBER_TABLE
1129: , p9_a3 out nocopy JTF_NUMBER_TABLE
1130: , p9_a4 out nocopy JTF_NUMBER_TABLE
1131: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1128: , p9_a2 out nocopy JTF_NUMBER_TABLE
1129: , p9_a3 out nocopy JTF_NUMBER_TABLE
1130: , p9_a4 out nocopy JTF_NUMBER_TABLE
1131: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1132: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1133: , p9_a7 out nocopy JTF_NUMBER_TABLE
1134: , p9_a8 out nocopy JTF_NUMBER_TABLE
1135: , p9_a9 out nocopy JTF_NUMBER_TABLE
1136: , p9_a10 out nocopy JTF_NUMBER_TABLE
1134: , p9_a8 out nocopy JTF_NUMBER_TABLE
1135: , p9_a9 out nocopy JTF_NUMBER_TABLE
1136: , p9_a10 out nocopy JTF_NUMBER_TABLE
1137: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1138: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1139: , p9_a13 out nocopy JTF_NUMBER_TABLE
1140: , p9_a14 out nocopy JTF_NUMBER_TABLE
1141: , p9_a15 out nocopy JTF_NUMBER_TABLE
1142: , p9_a16 out nocopy JTF_NUMBER_TABLE