DBA Data[Home] [Help]

APPS.OZF_TASK_GROUP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 21: , a8 JTF_VARCHAR2_TABLE_100

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

Line 23: , a10 JTF_VARCHAR2_TABLE_100

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

Line 39: , a26 JTF_VARCHAR2_TABLE_100

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;

Line 40: , a27 JTF_VARCHAR2_TABLE_100

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

Line 100: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 102: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 118: , a26 out nocopy JTF_VARCHAR2_TABLE_100

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;

Line 119: , a27 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 163: a8 := JTF_VARCHAR2_TABLE_100();

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();

Line 165: a10 := JTF_VARCHAR2_TABLE_100();

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();

Line 181: a26 := JTF_VARCHAR2_TABLE_100();

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();

Line 182: a27 := JTF_VARCHAR2_TABLE_100();

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();

Line 193: a8 := JTF_VARCHAR2_TABLE_100();

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();

Line 195: a10 := JTF_VARCHAR2_TABLE_100();

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();

Line 211: a26 := JTF_VARCHAR2_TABLE_100();

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);

Line 212: a27 := JTF_VARCHAR2_TABLE_100();

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);

Line 286: procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100

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

Line 287: , a1 JTF_VARCHAR2_TABLE_100

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

Line 311: procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 312: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 320: a0 := JTF_VARCHAR2_TABLE_100();

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();

Line 321: 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

Line 323: a0 := JTF_VARCHAR2_TABLE_100();

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);

Line 324: a1 := JTF_VARCHAR2_TABLE_100();

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;

Line 564: , p11_a0 JTF_VARCHAR2_TABLE_100

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

Line 565: , p11_a1 JTF_VARCHAR2_TABLE_100

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

Line 580: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 582: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 598: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_100

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:

Line 599: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100

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