18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if a0 is not null and a0.count > 0 then
93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_DATE_TABLE
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_DATE_TABLE
103: , a6 out nocopy JTF_VARCHAR2_TABLE_100
116: , a19 out nocopy JTF_VARCHAR2_TABLE_500
117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_DATE_TABLE
123: , a26 out nocopy JTF_NUMBER_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_VARCHAR2_TABLE_500
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_DATE_TABLE
123: , a26 out nocopy JTF_NUMBER_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
119: , a22 out nocopy JTF_VARCHAR2_TABLE_500
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_DATE_TABLE
123: , a26 out nocopy JTF_NUMBER_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as
127: ddindx binary_integer; indx binary_integer;
121: , a24 out nocopy JTF_NUMBER_TABLE
122: , a25 out nocopy JTF_DATE_TABLE
123: , a26 out nocopy JTF_NUMBER_TABLE
124: , a27 out nocopy JTF_DATE_TABLE
125: , a28 out nocopy JTF_NUMBER_TABLE
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_DATE_TABLE();
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_DATE_TABLE();
135: a5 := JTF_DATE_TABLE();
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_DATE_TABLE();
135: a5 := JTF_DATE_TABLE();
136: a6 := JTF_VARCHAR2_TABLE_100();
149: a19 := JTF_VARCHAR2_TABLE_500();
150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_DATE_TABLE();
156: a26 := JTF_NUMBER_TABLE();
157: a27 := JTF_DATE_TABLE();
150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_VARCHAR2_TABLE_500();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_DATE_TABLE();
156: a26 := JTF_NUMBER_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
152: a22 := JTF_VARCHAR2_TABLE_500();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_DATE_TABLE();
156: a26 := JTF_NUMBER_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
154: a24 := JTF_NUMBER_TABLE();
155: a25 := JTF_DATE_TABLE();
156: a26 := JTF_NUMBER_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
156: a26 := JTF_NUMBER_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_DATE_TABLE();
157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_DATE_TABLE();
166: a6 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_VARCHAR2_TABLE_500();
180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_DATE_TABLE();
186: a26 := JTF_NUMBER_TABLE();
187: a27 := JTF_DATE_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_VARCHAR2_TABLE_500();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_DATE_TABLE();
186: a26 := JTF_NUMBER_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
182: a22 := JTF_VARCHAR2_TABLE_500();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_DATE_TABLE();
186: a26 := JTF_NUMBER_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_DATE_TABLE();
186: a26 := JTF_NUMBER_TABLE();
187: a27 := JTF_DATE_TABLE();
188: a28 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
191: a1.extend(t.count);
192: a2.extend(t.count);
257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_DATE_TABLE
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_DATE_TABLE
266: , a5 JTF_DATE_TABLE
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_DATE_TABLE
266: , a5 JTF_DATE_TABLE
267: , a6 JTF_VARCHAR2_TABLE_100
280: , a19 JTF_VARCHAR2_TABLE_500
281: , a20 JTF_VARCHAR2_TABLE_500
282: , a21 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_DATE_TABLE
287: , a26 JTF_NUMBER_TABLE
288: , a27 JTF_DATE_TABLE
281: , a20 JTF_VARCHAR2_TABLE_500
282: , a21 JTF_VARCHAR2_TABLE_500
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_DATE_TABLE
287: , a26 JTF_NUMBER_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
283: , a22 JTF_VARCHAR2_TABLE_500
284: , a23 JTF_NUMBER_TABLE
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_DATE_TABLE
287: , a26 JTF_NUMBER_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
285: , a24 JTF_NUMBER_TABLE
286: , a25 JTF_DATE_TABLE
287: , a26 JTF_NUMBER_TABLE
288: , a27 JTF_DATE_TABLE
289: , a28 JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if a0 is not null and a0.count > 0 then
332: end loop;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_NUMBER_TABLE
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_DATE_TABLE
333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_NUMBER_TABLE
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_DATE_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_NUMBER_TABLE
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_DATE_TABLE
341: , a5 out nocopy JTF_DATE_TABLE
342: , a6 out nocopy JTF_VARCHAR2_TABLE_100
355: , a19 out nocopy JTF_VARCHAR2_TABLE_500
356: , a20 out nocopy JTF_VARCHAR2_TABLE_500
357: , a21 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_DATE_TABLE
362: , a26 out nocopy JTF_NUMBER_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
356: , a20 out nocopy JTF_VARCHAR2_TABLE_500
357: , a21 out nocopy JTF_VARCHAR2_TABLE_500
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_DATE_TABLE
362: , a26 out nocopy JTF_NUMBER_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
358: , a22 out nocopy JTF_VARCHAR2_TABLE_500
359: , a23 out nocopy JTF_NUMBER_TABLE
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_DATE_TABLE
362: , a26 out nocopy JTF_NUMBER_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as
366: ddindx binary_integer; indx binary_integer;
360: , a24 out nocopy JTF_NUMBER_TABLE
361: , a25 out nocopy JTF_DATE_TABLE
362: , a26 out nocopy JTF_NUMBER_TABLE
363: , a27 out nocopy JTF_DATE_TABLE
364: , a28 out nocopy JTF_NUMBER_TABLE
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_DATE_TABLE();
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_DATE_TABLE();
374: a5 := JTF_DATE_TABLE();
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_NUMBER_TABLE();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_DATE_TABLE();
374: a5 := JTF_DATE_TABLE();
375: a6 := JTF_VARCHAR2_TABLE_100();
388: a19 := JTF_VARCHAR2_TABLE_500();
389: a20 := JTF_VARCHAR2_TABLE_500();
390: a21 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_DATE_TABLE();
395: a26 := JTF_NUMBER_TABLE();
396: a27 := JTF_DATE_TABLE();
389: a20 := JTF_VARCHAR2_TABLE_500();
390: a21 := JTF_VARCHAR2_TABLE_500();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_DATE_TABLE();
395: a26 := JTF_NUMBER_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
391: a22 := JTF_VARCHAR2_TABLE_500();
392: a23 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_DATE_TABLE();
395: a26 := JTF_NUMBER_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
393: a24 := JTF_NUMBER_TABLE();
394: a25 := JTF_DATE_TABLE();
395: a26 := JTF_NUMBER_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_NUMBER_TABLE();
401: a2 := JTF_NUMBER_TABLE();
395: a26 := JTF_NUMBER_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_NUMBER_TABLE();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_DATE_TABLE();
396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_NUMBER_TABLE();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_DATE_TABLE();
404: a5 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_NUMBER_TABLE();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_DATE_TABLE();
404: a5 := JTF_DATE_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_100();
418: a19 := JTF_VARCHAR2_TABLE_500();
419: a20 := JTF_VARCHAR2_TABLE_500();
420: a21 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_DATE_TABLE();
425: a26 := JTF_NUMBER_TABLE();
426: a27 := JTF_DATE_TABLE();
419: a20 := JTF_VARCHAR2_TABLE_500();
420: a21 := JTF_VARCHAR2_TABLE_500();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_DATE_TABLE();
425: a26 := JTF_NUMBER_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
421: a22 := JTF_VARCHAR2_TABLE_500();
422: a23 := JTF_NUMBER_TABLE();
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_DATE_TABLE();
425: a26 := JTF_NUMBER_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
423: a24 := JTF_NUMBER_TABLE();
424: a25 := JTF_DATE_TABLE();
425: a26 := JTF_NUMBER_TABLE();
426: a27 := JTF_DATE_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
430: a1.extend(t.count);
431: a2.extend(t.count);
656: , p_init_msg_list VARCHAR2
657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_NUMBER_TABLE
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_DATE_TABLE
657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_NUMBER_TABLE
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_DATE_TABLE
665: , p5_a5 JTF_DATE_TABLE
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_NUMBER_TABLE
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_DATE_TABLE
665: , p5_a5 JTF_DATE_TABLE
666: , p5_a6 JTF_VARCHAR2_TABLE_100
679: , p5_a19 JTF_VARCHAR2_TABLE_500
680: , p5_a20 JTF_VARCHAR2_TABLE_500
681: , p5_a21 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
680: , p5_a20 JTF_VARCHAR2_TABLE_500
681: , p5_a21 JTF_VARCHAR2_TABLE_500
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
682: , p5_a22 JTF_VARCHAR2_TABLE_500
683: , p5_a23 JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
684: , p5_a24 JTF_NUMBER_TABLE
685: , p5_a25 JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
685: , p5_a25 JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_DATE_TABLE
686: , p5_a26 JTF_NUMBER_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_DATE_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_NUMBER_TABLE
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_DATE_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE
695: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
708: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
709: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
710: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_DATE_TABLE
715: , p6_a26 out nocopy JTF_NUMBER_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
709: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
710: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_DATE_TABLE
715: , p6_a26 out nocopy JTF_NUMBER_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
711: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
712: , p6_a23 out nocopy JTF_NUMBER_TABLE
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_DATE_TABLE
715: , p6_a26 out nocopy JTF_NUMBER_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
713: , p6_a24 out nocopy JTF_NUMBER_TABLE
714: , p6_a25 out nocopy JTF_DATE_TABLE
715: , p6_a26 out nocopy JTF_NUMBER_TABLE
716: , p6_a27 out nocopy JTF_DATE_TABLE
717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
720: as
721: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
968: , p_init_msg_list VARCHAR2
969: , x_return_status out nocopy VARCHAR2
970: , x_msg_count out nocopy NUMBER
971: , x_msg_data out nocopy VARCHAR2
972: , p5_a0 JTF_NUMBER_TABLE
973: , p5_a1 JTF_NUMBER_TABLE
974: , p5_a2 JTF_NUMBER_TABLE
975: , p5_a3 JTF_VARCHAR2_TABLE_100
976: , p5_a4 JTF_DATE_TABLE
969: , x_return_status out nocopy VARCHAR2
970: , x_msg_count out nocopy NUMBER
971: , x_msg_data out nocopy VARCHAR2
972: , p5_a0 JTF_NUMBER_TABLE
973: , p5_a1 JTF_NUMBER_TABLE
974: , p5_a2 JTF_NUMBER_TABLE
975: , p5_a3 JTF_VARCHAR2_TABLE_100
976: , p5_a4 JTF_DATE_TABLE
977: , p5_a5 JTF_DATE_TABLE
970: , x_msg_count out nocopy NUMBER
971: , x_msg_data out nocopy VARCHAR2
972: , p5_a0 JTF_NUMBER_TABLE
973: , p5_a1 JTF_NUMBER_TABLE
974: , p5_a2 JTF_NUMBER_TABLE
975: , p5_a3 JTF_VARCHAR2_TABLE_100
976: , p5_a4 JTF_DATE_TABLE
977: , p5_a5 JTF_DATE_TABLE
978: , p5_a6 JTF_VARCHAR2_TABLE_100
991: , p5_a19 JTF_VARCHAR2_TABLE_500
992: , p5_a20 JTF_VARCHAR2_TABLE_500
993: , p5_a21 JTF_VARCHAR2_TABLE_500
994: , p5_a22 JTF_VARCHAR2_TABLE_500
995: , p5_a23 JTF_NUMBER_TABLE
996: , p5_a24 JTF_NUMBER_TABLE
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
992: , p5_a20 JTF_VARCHAR2_TABLE_500
993: , p5_a21 JTF_VARCHAR2_TABLE_500
994: , p5_a22 JTF_VARCHAR2_TABLE_500
995: , p5_a23 JTF_NUMBER_TABLE
996: , p5_a24 JTF_NUMBER_TABLE
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
994: , p5_a22 JTF_VARCHAR2_TABLE_500
995: , p5_a23 JTF_NUMBER_TABLE
996: , p5_a24 JTF_NUMBER_TABLE
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
1001: , p6_a0 out nocopy JTF_NUMBER_TABLE
1002: , p6_a1 out nocopy JTF_NUMBER_TABLE
996: , p5_a24 JTF_NUMBER_TABLE
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
1001: , p6_a0 out nocopy JTF_NUMBER_TABLE
1002: , p6_a1 out nocopy JTF_NUMBER_TABLE
1003: , p6_a2 out nocopy JTF_NUMBER_TABLE
1004: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
1001: , p6_a0 out nocopy JTF_NUMBER_TABLE
1002: , p6_a1 out nocopy JTF_NUMBER_TABLE
1003: , p6_a2 out nocopy JTF_NUMBER_TABLE
1004: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p6_a4 out nocopy JTF_DATE_TABLE
998: , p5_a26 JTF_NUMBER_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
1001: , p6_a0 out nocopy JTF_NUMBER_TABLE
1002: , p6_a1 out nocopy JTF_NUMBER_TABLE
1003: , p6_a2 out nocopy JTF_NUMBER_TABLE
1004: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p6_a4 out nocopy JTF_DATE_TABLE
1006: , p6_a5 out nocopy JTF_DATE_TABLE
999: , p5_a27 JTF_DATE_TABLE
1000: , p5_a28 JTF_NUMBER_TABLE
1001: , p6_a0 out nocopy JTF_NUMBER_TABLE
1002: , p6_a1 out nocopy JTF_NUMBER_TABLE
1003: , p6_a2 out nocopy JTF_NUMBER_TABLE
1004: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p6_a4 out nocopy JTF_DATE_TABLE
1006: , p6_a5 out nocopy JTF_DATE_TABLE
1007: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1021: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1022: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1023: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1024: , p6_a23 out nocopy JTF_NUMBER_TABLE
1025: , p6_a24 out nocopy JTF_NUMBER_TABLE
1026: , p6_a25 out nocopy JTF_DATE_TABLE
1027: , p6_a26 out nocopy JTF_NUMBER_TABLE
1028: , p6_a27 out nocopy JTF_DATE_TABLE
1021: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1022: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1023: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1024: , p6_a23 out nocopy JTF_NUMBER_TABLE
1025: , p6_a24 out nocopy JTF_NUMBER_TABLE
1026: , p6_a25 out nocopy JTF_DATE_TABLE
1027: , p6_a26 out nocopy JTF_NUMBER_TABLE
1028: , p6_a27 out nocopy JTF_DATE_TABLE
1029: , p6_a28 out nocopy JTF_NUMBER_TABLE
1023: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1024: , p6_a23 out nocopy JTF_NUMBER_TABLE
1025: , p6_a24 out nocopy JTF_NUMBER_TABLE
1026: , p6_a25 out nocopy JTF_DATE_TABLE
1027: , p6_a26 out nocopy JTF_NUMBER_TABLE
1028: , p6_a27 out nocopy JTF_DATE_TABLE
1029: , p6_a28 out nocopy JTF_NUMBER_TABLE
1030: )
1031:
1025: , p6_a24 out nocopy JTF_NUMBER_TABLE
1026: , p6_a25 out nocopy JTF_DATE_TABLE
1027: , p6_a26 out nocopy JTF_NUMBER_TABLE
1028: , p6_a27 out nocopy JTF_DATE_TABLE
1029: , p6_a28 out nocopy JTF_NUMBER_TABLE
1030: )
1031:
1032: as
1033: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1218: , p_init_msg_list VARCHAR2
1219: , x_return_status out nocopy VARCHAR2
1220: , x_msg_count out nocopy NUMBER
1221: , x_msg_data out nocopy VARCHAR2
1222: , p5_a0 JTF_NUMBER_TABLE
1223: , p5_a1 JTF_NUMBER_TABLE
1224: , p5_a2 JTF_NUMBER_TABLE
1225: , p5_a3 JTF_VARCHAR2_TABLE_100
1226: , p5_a4 JTF_DATE_TABLE
1219: , x_return_status out nocopy VARCHAR2
1220: , x_msg_count out nocopy NUMBER
1221: , x_msg_data out nocopy VARCHAR2
1222: , p5_a0 JTF_NUMBER_TABLE
1223: , p5_a1 JTF_NUMBER_TABLE
1224: , p5_a2 JTF_NUMBER_TABLE
1225: , p5_a3 JTF_VARCHAR2_TABLE_100
1226: , p5_a4 JTF_DATE_TABLE
1227: , p5_a5 JTF_DATE_TABLE
1220: , x_msg_count out nocopy NUMBER
1221: , x_msg_data out nocopy VARCHAR2
1222: , p5_a0 JTF_NUMBER_TABLE
1223: , p5_a1 JTF_NUMBER_TABLE
1224: , p5_a2 JTF_NUMBER_TABLE
1225: , p5_a3 JTF_VARCHAR2_TABLE_100
1226: , p5_a4 JTF_DATE_TABLE
1227: , p5_a5 JTF_DATE_TABLE
1228: , p5_a6 JTF_VARCHAR2_TABLE_100
1241: , p5_a19 JTF_VARCHAR2_TABLE_500
1242: , p5_a20 JTF_VARCHAR2_TABLE_500
1243: , p5_a21 JTF_VARCHAR2_TABLE_500
1244: , p5_a22 JTF_VARCHAR2_TABLE_500
1245: , p5_a23 JTF_NUMBER_TABLE
1246: , p5_a24 JTF_NUMBER_TABLE
1247: , p5_a25 JTF_DATE_TABLE
1248: , p5_a26 JTF_NUMBER_TABLE
1249: , p5_a27 JTF_DATE_TABLE
1242: , p5_a20 JTF_VARCHAR2_TABLE_500
1243: , p5_a21 JTF_VARCHAR2_TABLE_500
1244: , p5_a22 JTF_VARCHAR2_TABLE_500
1245: , p5_a23 JTF_NUMBER_TABLE
1246: , p5_a24 JTF_NUMBER_TABLE
1247: , p5_a25 JTF_DATE_TABLE
1248: , p5_a26 JTF_NUMBER_TABLE
1249: , p5_a27 JTF_DATE_TABLE
1250: , p5_a28 JTF_NUMBER_TABLE
1244: , p5_a22 JTF_VARCHAR2_TABLE_500
1245: , p5_a23 JTF_NUMBER_TABLE
1246: , p5_a24 JTF_NUMBER_TABLE
1247: , p5_a25 JTF_DATE_TABLE
1248: , p5_a26 JTF_NUMBER_TABLE
1249: , p5_a27 JTF_DATE_TABLE
1250: , p5_a28 JTF_NUMBER_TABLE
1251: )
1252:
1246: , p5_a24 JTF_NUMBER_TABLE
1247: , p5_a25 JTF_DATE_TABLE
1248: , p5_a26 JTF_NUMBER_TABLE
1249: , p5_a27 JTF_DATE_TABLE
1250: , p5_a28 JTF_NUMBER_TABLE
1251: )
1252:
1253: as
1254: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;