17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_DATE_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200
19: , a6 JTF_DATE_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200
26: , a13 JTF_VARCHAR2_TABLE_200
27: , a14 JTF_VARCHAR2_TABLE_200
35: , a22 JTF_VARCHAR2_TABLE_200
36: , a23 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_VARCHAR2_TABLE_200
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_VARCHAR2_TABLE_100
40: , a27 JTF_VARCHAR2_TABLE_100
41: , a28 JTF_VARCHAR2_TABLE_4000
42: ) as
43: ddindx binary_integer; indx binary_integer;
36: , a23 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_VARCHAR2_TABLE_200
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_VARCHAR2_TABLE_100
40: , a27 JTF_VARCHAR2_TABLE_100
41: , a28 JTF_VARCHAR2_TABLE_4000
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_NUMBER_TABLE
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_VARCHAR2_TABLE_100
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_VARCHAR2_TABLE_200
104: , a12 out nocopy JTF_VARCHAR2_TABLE_200
98: , a6 out nocopy JTF_DATE_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_VARCHAR2_TABLE_100
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_VARCHAR2_TABLE_200
104: , a12 out nocopy JTF_VARCHAR2_TABLE_200
105: , a13 out nocopy JTF_VARCHAR2_TABLE_200
106: , a14 out nocopy JTF_VARCHAR2_TABLE_200
114: , a22 out nocopy JTF_VARCHAR2_TABLE_200
115: , a23 out nocopy JTF_VARCHAR2_TABLE_200
116: , a24 out nocopy JTF_VARCHAR2_TABLE_200
117: , a25 out nocopy JTF_VARCHAR2_TABLE_200
118: , a26 out nocopy JTF_VARCHAR2_TABLE_100
119: , a27 out nocopy JTF_VARCHAR2_TABLE_100
120: , a28 out nocopy JTF_VARCHAR2_TABLE_4000
121: ) as
122: ddindx binary_integer; indx binary_integer;
115: , a23 out nocopy JTF_VARCHAR2_TABLE_200
116: , a24 out nocopy JTF_VARCHAR2_TABLE_200
117: , a25 out nocopy JTF_VARCHAR2_TABLE_200
118: , a26 out nocopy JTF_VARCHAR2_TABLE_100
119: , a27 out nocopy JTF_VARCHAR2_TABLE_100
120: , a28 out nocopy JTF_VARCHAR2_TABLE_4000
121: ) as
122: ddindx binary_integer; indx binary_integer;
123: begin
159: a4 := JTF_NUMBER_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_DATE_TABLE();
162: a7 := JTF_DATE_TABLE();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_200();
167: a12 := JTF_VARCHAR2_TABLE_200();
161: a6 := JTF_DATE_TABLE();
162: a7 := JTF_DATE_TABLE();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_200();
167: a12 := JTF_VARCHAR2_TABLE_200();
168: a13 := JTF_VARCHAR2_TABLE_200();
169: a14 := JTF_VARCHAR2_TABLE_200();
177: a22 := JTF_VARCHAR2_TABLE_200();
178: a23 := JTF_VARCHAR2_TABLE_200();
179: a24 := JTF_VARCHAR2_TABLE_200();
180: a25 := JTF_VARCHAR2_TABLE_200();
181: a26 := JTF_VARCHAR2_TABLE_100();
182: a27 := JTF_VARCHAR2_TABLE_100();
183: a28 := JTF_VARCHAR2_TABLE_4000();
184: else
185: a0 := JTF_NUMBER_TABLE();
178: a23 := JTF_VARCHAR2_TABLE_200();
179: a24 := JTF_VARCHAR2_TABLE_200();
180: a25 := JTF_VARCHAR2_TABLE_200();
181: a26 := JTF_VARCHAR2_TABLE_100();
182: a27 := JTF_VARCHAR2_TABLE_100();
183: a28 := JTF_VARCHAR2_TABLE_4000();
184: else
185: a0 := JTF_NUMBER_TABLE();
186: a1 := JTF_DATE_TABLE();
189: a4 := JTF_NUMBER_TABLE();
190: a5 := JTF_NUMBER_TABLE();
191: a6 := JTF_DATE_TABLE();
192: a7 := JTF_DATE_TABLE();
193: a8 := JTF_VARCHAR2_TABLE_100();
194: a9 := JTF_NUMBER_TABLE();
195: a10 := JTF_VARCHAR2_TABLE_100();
196: a11 := JTF_VARCHAR2_TABLE_200();
197: a12 := JTF_VARCHAR2_TABLE_200();
191: a6 := JTF_DATE_TABLE();
192: a7 := JTF_DATE_TABLE();
193: a8 := JTF_VARCHAR2_TABLE_100();
194: a9 := JTF_NUMBER_TABLE();
195: a10 := JTF_VARCHAR2_TABLE_100();
196: a11 := JTF_VARCHAR2_TABLE_200();
197: a12 := JTF_VARCHAR2_TABLE_200();
198: a13 := JTF_VARCHAR2_TABLE_200();
199: a14 := JTF_VARCHAR2_TABLE_200();
207: a22 := JTF_VARCHAR2_TABLE_200();
208: a23 := JTF_VARCHAR2_TABLE_200();
209: a24 := JTF_VARCHAR2_TABLE_200();
210: a25 := JTF_VARCHAR2_TABLE_200();
211: a26 := JTF_VARCHAR2_TABLE_100();
212: a27 := JTF_VARCHAR2_TABLE_100();
213: a28 := JTF_VARCHAR2_TABLE_4000();
214: if t.count > 0 then
215: a0.extend(t.count);
208: a23 := JTF_VARCHAR2_TABLE_200();
209: a24 := JTF_VARCHAR2_TABLE_200();
210: a25 := JTF_VARCHAR2_TABLE_200();
211: a26 := JTF_VARCHAR2_TABLE_100();
212: a27 := JTF_VARCHAR2_TABLE_100();
213: a28 := JTF_VARCHAR2_TABLE_4000();
214: if t.count > 0 then
215: a0.extend(t.count);
216: a1.extend(t.count);
282: end if;
283: end if;
284: end rosetta_table_copy_out_p1;
285:
286: procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100
287: , a1 JTF_VARCHAR2_TABLE_100
288: ) as
289: ddindx binary_integer; indx binary_integer;
290: begin
283: end if;
284: end rosetta_table_copy_out_p1;
285:
286: procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100
287: , a1 JTF_VARCHAR2_TABLE_100
288: ) as
289: ddindx binary_integer; indx binary_integer;
290: begin
291: if a0 is not null and a0.count=0 then
307: end loop;
308: end if;
309: end if;
310: end rosetta_table_copy_in_p5;
311: procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
312: , a1 out nocopy JTF_VARCHAR2_TABLE_100
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
308: end if;
309: end if;
310: end rosetta_table_copy_in_p5;
311: procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
312: , a1 out nocopy JTF_VARCHAR2_TABLE_100
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
316: if t is null then
316: if t is null then
317: a0 := null;
318: a1 := null;
319: elsif t.count = 0 then
320: a0 := JTF_VARCHAR2_TABLE_100();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: else
323: a0 := JTF_VARCHAR2_TABLE_100();
324: a1 := JTF_VARCHAR2_TABLE_100();
317: a0 := null;
318: a1 := null;
319: elsif t.count = 0 then
320: a0 := JTF_VARCHAR2_TABLE_100();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: else
323: a0 := JTF_VARCHAR2_TABLE_100();
324: a1 := JTF_VARCHAR2_TABLE_100();
325: if t.count > 0 then
319: elsif t.count = 0 then
320: a0 := JTF_VARCHAR2_TABLE_100();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: else
323: a0 := JTF_VARCHAR2_TABLE_100();
324: a1 := JTF_VARCHAR2_TABLE_100();
325: if t.count > 0 then
326: a0.extend(t.count);
327: a1.extend(t.count);
320: a0 := JTF_VARCHAR2_TABLE_100();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: else
323: a0 := JTF_VARCHAR2_TABLE_100();
324: a1 := JTF_VARCHAR2_TABLE_100();
325: if t.count > 0 then
326: a0.extend(t.count);
327: a1.extend(t.count);
328: ddindx := t.first;
560: , p_template_group_name VARCHAR2
561: , p_source_object_type_code VARCHAR2
562: , p_start_date_active date
563: , p_end_date_active date
564: , p11_a0 JTF_VARCHAR2_TABLE_100
565: , p11_a1 JTF_VARCHAR2_TABLE_100
566: , p12_a0 NUMBER
567: , p12_a1 NUMBER
568: , p12_a2 VARCHAR2
561: , p_source_object_type_code VARCHAR2
562: , p_start_date_active date
563: , p_end_date_active date
564: , p11_a0 JTF_VARCHAR2_TABLE_100
565: , p11_a1 JTF_VARCHAR2_TABLE_100
566: , p12_a0 NUMBER
567: , p12_a1 NUMBER
568: , p12_a2 VARCHAR2
569: , p13_a0 out nocopy NUMBER
576: , p14_a4 out nocopy JTF_NUMBER_TABLE
577: , p14_a5 out nocopy JTF_NUMBER_TABLE
578: , p14_a6 out nocopy JTF_DATE_TABLE
579: , p14_a7 out nocopy JTF_DATE_TABLE
580: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
581: , p14_a9 out nocopy JTF_NUMBER_TABLE
582: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
583: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_200
584: , p14_a12 out nocopy JTF_VARCHAR2_TABLE_200
578: , p14_a6 out nocopy JTF_DATE_TABLE
579: , p14_a7 out nocopy JTF_DATE_TABLE
580: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
581: , p14_a9 out nocopy JTF_NUMBER_TABLE
582: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
583: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_200
584: , p14_a12 out nocopy JTF_VARCHAR2_TABLE_200
585: , p14_a13 out nocopy JTF_VARCHAR2_TABLE_200
586: , p14_a14 out nocopy JTF_VARCHAR2_TABLE_200
594: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_200
595: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_200
596: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_200
597: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_200
598: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_100
599: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
600: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_4000
601: )
602:
595: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_200
596: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_200
597: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_200
598: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_100
599: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
600: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_4000
601: )
602:
603: as