16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_200
28: , a15 JTF_VARCHAR2_TABLE_200
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_200
28: , a15 JTF_VARCHAR2_TABLE_200
29: , a16 JTF_VARCHAR2_TABLE_200
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_200
28: , a15 JTF_VARCHAR2_TABLE_200
29: , a16 JTF_VARCHAR2_TABLE_200
30: , a17 JTF_VARCHAR2_TABLE_200
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_VARCHAR2_TABLE_200
40: , a27 JTF_VARCHAR2_TABLE_200
41: , a28 JTF_VARCHAR2_TABLE_200
42: , a29 JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if a0 is not null and a0.count > 0 then
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
104: , a14 out nocopy JTF_VARCHAR2_TABLE_200
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
104: , a14 out nocopy JTF_VARCHAR2_TABLE_200
105: , a15 out nocopy JTF_VARCHAR2_TABLE_200
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
104: , a14 out nocopy JTF_VARCHAR2_TABLE_200
105: , a15 out nocopy JTF_VARCHAR2_TABLE_200
106: , a16 out nocopy JTF_VARCHAR2_TABLE_200
99: , a9 out nocopy JTF_VARCHAR2_TABLE_100
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
104: , a14 out nocopy JTF_VARCHAR2_TABLE_200
105: , a15 out nocopy JTF_VARCHAR2_TABLE_200
106: , a16 out nocopy JTF_VARCHAR2_TABLE_200
107: , a17 out nocopy JTF_VARCHAR2_TABLE_200
115: , a25 out nocopy JTF_VARCHAR2_TABLE_200
116: , a26 out nocopy JTF_VARCHAR2_TABLE_200
117: , a27 out nocopy JTF_VARCHAR2_TABLE_200
118: , a28 out nocopy JTF_VARCHAR2_TABLE_200
119: , a29 out nocopy JTF_VARCHAR2_TABLE_100
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_200();
131: a7 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_200();
139: a15 := JTF_VARCHAR2_TABLE_200();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_200();
139: a15 := JTF_VARCHAR2_TABLE_200();
140: a16 := JTF_VARCHAR2_TABLE_200();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_200();
139: a15 := JTF_VARCHAR2_TABLE_200();
140: a16 := JTF_VARCHAR2_TABLE_200();
141: a17 := JTF_VARCHAR2_TABLE_200();
149: a25 := JTF_VARCHAR2_TABLE_200();
150: a26 := JTF_VARCHAR2_TABLE_200();
151: a27 := JTF_VARCHAR2_TABLE_200();
152: a28 := JTF_VARCHAR2_TABLE_200();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_VARCHAR2_TABLE_100();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_VARCHAR2_TABLE_100();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_VARCHAR2_TABLE_100();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_VARCHAR2_TABLE_100();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
169: a14 := JTF_VARCHAR2_TABLE_200();
162: a7 := JTF_VARCHAR2_TABLE_100();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
169: a14 := JTF_VARCHAR2_TABLE_200();
170: a15 := JTF_VARCHAR2_TABLE_200();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
169: a14 := JTF_VARCHAR2_TABLE_200();
170: a15 := JTF_VARCHAR2_TABLE_200();
171: a16 := JTF_VARCHAR2_TABLE_200();
164: a9 := JTF_VARCHAR2_TABLE_100();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
169: a14 := JTF_VARCHAR2_TABLE_200();
170: a15 := JTF_VARCHAR2_TABLE_200();
171: a16 := JTF_VARCHAR2_TABLE_200();
172: a17 := JTF_VARCHAR2_TABLE_200();
180: a25 := JTF_VARCHAR2_TABLE_200();
181: a26 := JTF_VARCHAR2_TABLE_200();
182: a27 := JTF_VARCHAR2_TABLE_200();
183: a28 := JTF_VARCHAR2_TABLE_200();
184: a29 := JTF_VARCHAR2_TABLE_100();
185: if t.count > 0 then
186: a0.extend(t.count);
187: a1.extend(t.count);
188: a2.extend(t.count);
272: , p10_a3 in out nocopy JTF_NUMBER_TABLE
273: , p10_a4 in out nocopy JTF_DATE_TABLE
274: , p10_a5 in out nocopy JTF_NUMBER_TABLE
275: , p10_a6 in out nocopy JTF_NUMBER_TABLE
276: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p10_a4 in out nocopy JTF_DATE_TABLE
274: , p10_a5 in out nocopy JTF_NUMBER_TABLE
275: , p10_a6 in out nocopy JTF_NUMBER_TABLE
276: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p10_a5 in out nocopy JTF_NUMBER_TABLE
275: , p10_a6 in out nocopy JTF_NUMBER_TABLE
276: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p10_a6 in out nocopy JTF_NUMBER_TABLE
276: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
276: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
284: , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
277: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
284: , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
285: , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
278: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
284: , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
285: , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
286: , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
294: , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
295: , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
296: , p10_a27 in out nocopy JTF_VARCHAR2_TABLE_200
297: , p10_a28 in out nocopy JTF_VARCHAR2_TABLE_200
298: , p10_a29 in out nocopy JTF_VARCHAR2_TABLE_100
299: )
300:
301: as
302: ddp_x_prod_zone_as_tbl ahl_rm_prod_zone_as_pvt.prod_zone_as_tbl_type;