DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_A_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_2000
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_300

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_2000
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_2000
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE

Line 97: , a5 out nocopy JTF_VARCHAR2_TABLE_100

93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_200
100: , a8 out nocopy JTF_VARCHAR2_TABLE_100
101: , a9 out nocopy JTF_NUMBER_TABLE

Line 100: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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_VARCHAR2_TABLE_200
100: , a8 out nocopy JTF_VARCHAR2_TABLE_100
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a11 out nocopy JTF_VARCHAR2_TABLE_100
104: , a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 103: , a11 out nocopy JTF_VARCHAR2_TABLE_100

99: , a7 out nocopy JTF_VARCHAR2_TABLE_200
100: , a8 out nocopy JTF_VARCHAR2_TABLE_100
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a11 out nocopy JTF_VARCHAR2_TABLE_100
104: , a12 out nocopy JTF_VARCHAR2_TABLE_300
105: , a13 out nocopy JTF_VARCHAR2_TABLE_200
106: , a14 out nocopy JTF_VARCHAR2_TABLE_100
107: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 106: , a14 out nocopy JTF_VARCHAR2_TABLE_100

102: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a11 out nocopy JTF_VARCHAR2_TABLE_100
104: , a12 out nocopy JTF_VARCHAR2_TABLE_300
105: , a13 out nocopy JTF_VARCHAR2_TABLE_200
106: , a14 out nocopy JTF_VARCHAR2_TABLE_100
107: , a15 out nocopy JTF_VARCHAR2_TABLE_500
108: , a16 out nocopy JTF_VARCHAR2_TABLE_500
109: , a17 out nocopy JTF_VARCHAR2_TABLE_500
110: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 122: , a30 out nocopy JTF_VARCHAR2_TABLE_100

118: , a26 out nocopy JTF_VARCHAR2_TABLE_500
119: , a27 out nocopy JTF_VARCHAR2_TABLE_500
120: , a28 out nocopy JTF_VARCHAR2_TABLE_500
121: , a29 out nocopy JTF_VARCHAR2_TABLE_500
122: , a30 out nocopy JTF_VARCHAR2_TABLE_100
123: , a31 out nocopy JTF_NUMBER_TABLE
124: , a32 out nocopy JTF_DATE_TABLE
125: , a33 out nocopy JTF_NUMBER_TABLE
126: , a34 out nocopy JTF_DATE_TABLE

Line 137: a5 := JTF_VARCHAR2_TABLE_100();

133: a1 := JTF_NUMBER_TABLE();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_VARCHAR2_TABLE_200();
140: a8 := JTF_VARCHAR2_TABLE_100();
141: a9 := JTF_NUMBER_TABLE();

Line 140: a8 := JTF_VARCHAR2_TABLE_100();

136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_VARCHAR2_TABLE_200();
140: a8 := JTF_VARCHAR2_TABLE_100();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_2000();
143: a11 := JTF_VARCHAR2_TABLE_100();
144: a12 := JTF_VARCHAR2_TABLE_300();

Line 143: a11 := JTF_VARCHAR2_TABLE_100();

139: a7 := JTF_VARCHAR2_TABLE_200();
140: a8 := JTF_VARCHAR2_TABLE_100();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_2000();
143: a11 := JTF_VARCHAR2_TABLE_100();
144: a12 := JTF_VARCHAR2_TABLE_300();
145: a13 := JTF_VARCHAR2_TABLE_200();
146: a14 := JTF_VARCHAR2_TABLE_100();
147: a15 := JTF_VARCHAR2_TABLE_500();

Line 146: a14 := JTF_VARCHAR2_TABLE_100();

142: a10 := JTF_VARCHAR2_TABLE_2000();
143: a11 := JTF_VARCHAR2_TABLE_100();
144: a12 := JTF_VARCHAR2_TABLE_300();
145: a13 := JTF_VARCHAR2_TABLE_200();
146: a14 := JTF_VARCHAR2_TABLE_100();
147: a15 := JTF_VARCHAR2_TABLE_500();
148: a16 := JTF_VARCHAR2_TABLE_500();
149: a17 := JTF_VARCHAR2_TABLE_500();
150: a18 := JTF_VARCHAR2_TABLE_500();

Line 162: a30 := JTF_VARCHAR2_TABLE_100();

158: a26 := JTF_VARCHAR2_TABLE_500();
159: a27 := JTF_VARCHAR2_TABLE_500();
160: a28 := JTF_VARCHAR2_TABLE_500();
161: a29 := JTF_VARCHAR2_TABLE_500();
162: a30 := JTF_VARCHAR2_TABLE_100();
163: a31 := JTF_NUMBER_TABLE();
164: a32 := JTF_DATE_TABLE();
165: a33 := JTF_NUMBER_TABLE();
166: a34 := JTF_DATE_TABLE();

Line 174: a5 := JTF_VARCHAR2_TABLE_100();

170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_NUMBER_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_VARCHAR2_TABLE_100();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_200();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_NUMBER_TABLE();

Line 177: a8 := JTF_VARCHAR2_TABLE_100();

173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_VARCHAR2_TABLE_100();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_200();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_2000();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_300();

Line 180: a11 := JTF_VARCHAR2_TABLE_100();

176: a7 := JTF_VARCHAR2_TABLE_200();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_2000();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_300();
182: a13 := JTF_VARCHAR2_TABLE_200();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_500();

Line 183: a14 := JTF_VARCHAR2_TABLE_100();

179: a10 := JTF_VARCHAR2_TABLE_2000();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_300();
182: a13 := JTF_VARCHAR2_TABLE_200();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_500();
185: a16 := JTF_VARCHAR2_TABLE_500();
186: a17 := JTF_VARCHAR2_TABLE_500();
187: a18 := JTF_VARCHAR2_TABLE_500();

Line 199: a30 := JTF_VARCHAR2_TABLE_100();

195: a26 := JTF_VARCHAR2_TABLE_500();
196: a27 := JTF_VARCHAR2_TABLE_500();
197: a28 := JTF_VARCHAR2_TABLE_500();
198: a29 := JTF_VARCHAR2_TABLE_500();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_NUMBER_TABLE();
201: a32 := JTF_DATE_TABLE();
202: a33 := JTF_NUMBER_TABLE();
203: a34 := JTF_DATE_TABLE();

Line 293: , a2 JTF_VARCHAR2_TABLE_100

289: end rosetta_table_copy_out_p3;
290:
291: procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_a_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE
292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_100
294: , a3 JTF_VARCHAR2_TABLE_100
295: , a4 JTF_VARCHAR2_TABLE_100
296: , a5 JTF_VARCHAR2_TABLE_100
297: , a6 JTF_NUMBER_TABLE

Line 294: , a3 JTF_VARCHAR2_TABLE_100

290:
291: procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_a_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE
292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_100
294: , a3 JTF_VARCHAR2_TABLE_100
295: , a4 JTF_VARCHAR2_TABLE_100
296: , a5 JTF_VARCHAR2_TABLE_100
297: , a6 JTF_NUMBER_TABLE
298: , a7 JTF_NUMBER_TABLE

Line 295: , a4 JTF_VARCHAR2_TABLE_100

291: procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_a_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE
292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_100
294: , a3 JTF_VARCHAR2_TABLE_100
295: , a4 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

Line 296: , a5 JTF_VARCHAR2_TABLE_100

292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_100
294: , a3 JTF_VARCHAR2_TABLE_100
295: , a4 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_NUMBER_TABLE

Line 302: , a11 JTF_VARCHAR2_TABLE_100

298: , a7 JTF_NUMBER_TABLE
299: , a8 JTF_NUMBER_TABLE
300: , a9 JTF_NUMBER_TABLE
301: , a10 JTF_VARCHAR2_TABLE_2000
302: , a11 JTF_VARCHAR2_TABLE_100
303: , a12 JTF_VARCHAR2_TABLE_500
304: , a13 JTF_VARCHAR2_TABLE_500
305: , a14 JTF_VARCHAR2_TABLE_500
306: , a15 JTF_VARCHAR2_TABLE_500

Line 374: , a2 out nocopy JTF_VARCHAR2_TABLE_100

370: end if;
371: end rosetta_table_copy_in_p5;
372: procedure rosetta_table_copy_out_p5(t okl_okc_migration_a_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_VARCHAR2_TABLE_100
375: , a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , a5 out nocopy JTF_VARCHAR2_TABLE_100
378: , a6 out nocopy JTF_NUMBER_TABLE

Line 375: , a3 out nocopy JTF_VARCHAR2_TABLE_100

371: end rosetta_table_copy_in_p5;
372: procedure rosetta_table_copy_out_p5(t okl_okc_migration_a_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_VARCHAR2_TABLE_100
375: , a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , a5 out nocopy JTF_VARCHAR2_TABLE_100
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_NUMBER_TABLE

Line 376: , a4 out nocopy JTF_VARCHAR2_TABLE_100

372: procedure rosetta_table_copy_out_p5(t okl_okc_migration_a_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_VARCHAR2_TABLE_100
375: , a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , a5 out nocopy JTF_VARCHAR2_TABLE_100
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_NUMBER_TABLE
380: , a8 out nocopy JTF_NUMBER_TABLE

Line 377: , a5 out nocopy JTF_VARCHAR2_TABLE_100

373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_VARCHAR2_TABLE_100
375: , a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , a5 out nocopy JTF_VARCHAR2_TABLE_100
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_NUMBER_TABLE
380: , a8 out nocopy JTF_NUMBER_TABLE
381: , a9 out nocopy JTF_NUMBER_TABLE

Line 383: , a11 out nocopy JTF_VARCHAR2_TABLE_100

379: , a7 out nocopy JTF_NUMBER_TABLE
380: , a8 out nocopy JTF_NUMBER_TABLE
381: , a9 out nocopy JTF_NUMBER_TABLE
382: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a11 out nocopy JTF_VARCHAR2_TABLE_100
384: , a12 out nocopy JTF_VARCHAR2_TABLE_500
385: , a13 out nocopy JTF_VARCHAR2_TABLE_500
386: , a14 out nocopy JTF_VARCHAR2_TABLE_500
387: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 410: a2 := JTF_VARCHAR2_TABLE_100();

406: begin
407: if t is null or t.count = 0 then
408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_NUMBER_TABLE();
410: a2 := JTF_VARCHAR2_TABLE_100();
411: a3 := JTF_VARCHAR2_TABLE_100();
412: a4 := JTF_VARCHAR2_TABLE_100();
413: a5 := JTF_VARCHAR2_TABLE_100();
414: a6 := JTF_NUMBER_TABLE();

Line 411: a3 := JTF_VARCHAR2_TABLE_100();

407: if t is null or t.count = 0 then
408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_NUMBER_TABLE();
410: a2 := JTF_VARCHAR2_TABLE_100();
411: a3 := JTF_VARCHAR2_TABLE_100();
412: a4 := JTF_VARCHAR2_TABLE_100();
413: a5 := JTF_VARCHAR2_TABLE_100();
414: a6 := JTF_NUMBER_TABLE();
415: a7 := JTF_NUMBER_TABLE();

Line 412: a4 := JTF_VARCHAR2_TABLE_100();

408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_NUMBER_TABLE();
410: a2 := JTF_VARCHAR2_TABLE_100();
411: a3 := JTF_VARCHAR2_TABLE_100();
412: a4 := JTF_VARCHAR2_TABLE_100();
413: a5 := JTF_VARCHAR2_TABLE_100();
414: a6 := JTF_NUMBER_TABLE();
415: a7 := JTF_NUMBER_TABLE();
416: a8 := JTF_NUMBER_TABLE();

Line 413: a5 := JTF_VARCHAR2_TABLE_100();

409: a1 := JTF_NUMBER_TABLE();
410: a2 := JTF_VARCHAR2_TABLE_100();
411: a3 := JTF_VARCHAR2_TABLE_100();
412: a4 := JTF_VARCHAR2_TABLE_100();
413: a5 := JTF_VARCHAR2_TABLE_100();
414: a6 := JTF_NUMBER_TABLE();
415: a7 := JTF_NUMBER_TABLE();
416: a8 := JTF_NUMBER_TABLE();
417: a9 := JTF_NUMBER_TABLE();

Line 419: a11 := JTF_VARCHAR2_TABLE_100();

415: a7 := JTF_NUMBER_TABLE();
416: a8 := JTF_NUMBER_TABLE();
417: a9 := JTF_NUMBER_TABLE();
418: a10 := JTF_VARCHAR2_TABLE_2000();
419: a11 := JTF_VARCHAR2_TABLE_100();
420: a12 := JTF_VARCHAR2_TABLE_500();
421: a13 := JTF_VARCHAR2_TABLE_500();
422: a14 := JTF_VARCHAR2_TABLE_500();
423: a15 := JTF_VARCHAR2_TABLE_500();

Line 443: a2 := JTF_VARCHAR2_TABLE_100();

439: a31 := JTF_NUMBER_TABLE();
440: else
441: a0 := JTF_NUMBER_TABLE();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_VARCHAR2_TABLE_100();
444: a3 := JTF_VARCHAR2_TABLE_100();
445: a4 := JTF_VARCHAR2_TABLE_100();
446: a5 := JTF_VARCHAR2_TABLE_100();
447: a6 := JTF_NUMBER_TABLE();

Line 444: a3 := JTF_VARCHAR2_TABLE_100();

440: else
441: a0 := JTF_NUMBER_TABLE();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_VARCHAR2_TABLE_100();
444: a3 := JTF_VARCHAR2_TABLE_100();
445: a4 := JTF_VARCHAR2_TABLE_100();
446: a5 := JTF_VARCHAR2_TABLE_100();
447: a6 := JTF_NUMBER_TABLE();
448: a7 := JTF_NUMBER_TABLE();

Line 445: a4 := JTF_VARCHAR2_TABLE_100();

441: a0 := JTF_NUMBER_TABLE();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_VARCHAR2_TABLE_100();
444: a3 := JTF_VARCHAR2_TABLE_100();
445: a4 := JTF_VARCHAR2_TABLE_100();
446: a5 := JTF_VARCHAR2_TABLE_100();
447: a6 := JTF_NUMBER_TABLE();
448: a7 := JTF_NUMBER_TABLE();
449: a8 := JTF_NUMBER_TABLE();

Line 446: a5 := JTF_VARCHAR2_TABLE_100();

442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_VARCHAR2_TABLE_100();
444: a3 := JTF_VARCHAR2_TABLE_100();
445: a4 := JTF_VARCHAR2_TABLE_100();
446: a5 := JTF_VARCHAR2_TABLE_100();
447: a6 := JTF_NUMBER_TABLE();
448: a7 := JTF_NUMBER_TABLE();
449: a8 := JTF_NUMBER_TABLE();
450: a9 := JTF_NUMBER_TABLE();

Line 452: a11 := JTF_VARCHAR2_TABLE_100();

448: a7 := JTF_NUMBER_TABLE();
449: a8 := JTF_NUMBER_TABLE();
450: a9 := JTF_NUMBER_TABLE();
451: a10 := JTF_VARCHAR2_TABLE_2000();
452: a11 := JTF_VARCHAR2_TABLE_100();
453: a12 := JTF_VARCHAR2_TABLE_500();
454: a13 := JTF_VARCHAR2_TABLE_500();
455: a14 := JTF_VARCHAR2_TABLE_500();
456: a15 := JTF_VARCHAR2_TABLE_500();

Line 551: procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

547: end if;
548: end if;
549: end rosetta_table_copy_out_p5;
550:
551: procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
552: , a1 JTF_VARCHAR2_TABLE_200
553: , a2 JTF_VARCHAR2_TABLE_2000
554: , a3 JTF_VARCHAR2_TABLE_100
555: , a4 JTF_VARCHAR2_TABLE_100

Line 554: , a3 JTF_VARCHAR2_TABLE_100

550:
551: procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
552: , a1 JTF_VARCHAR2_TABLE_200
553: , a2 JTF_VARCHAR2_TABLE_2000
554: , a3 JTF_VARCHAR2_TABLE_100
555: , a4 JTF_VARCHAR2_TABLE_100
556: , a5 JTF_VARCHAR2_TABLE_100
557: , a6 JTF_VARCHAR2_TABLE_2000
558: ) as

Line 555: , a4 JTF_VARCHAR2_TABLE_100

551: procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
552: , a1 JTF_VARCHAR2_TABLE_200
553: , a2 JTF_VARCHAR2_TABLE_2000
554: , a3 JTF_VARCHAR2_TABLE_100
555: , a4 JTF_VARCHAR2_TABLE_100
556: , a5 JTF_VARCHAR2_TABLE_100
557: , a6 JTF_VARCHAR2_TABLE_2000
558: ) as
559: ddindx binary_integer; indx binary_integer;

Line 556: , a5 JTF_VARCHAR2_TABLE_100

552: , a1 JTF_VARCHAR2_TABLE_200
553: , a2 JTF_VARCHAR2_TABLE_2000
554: , a3 JTF_VARCHAR2_TABLE_100
555: , a4 JTF_VARCHAR2_TABLE_100
556: , a5 JTF_VARCHAR2_TABLE_100
557: , a6 JTF_VARCHAR2_TABLE_2000
558: ) as
559: ddindx binary_integer; indx binary_integer;
560: begin

Line 582: procedure rosetta_table_copy_out_p7(t okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

578: end loop;
579: end if;
580: end if;
581: end rosetta_table_copy_in_p7;
582: procedure rosetta_table_copy_out_p7(t okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
583: , a1 out nocopy JTF_VARCHAR2_TABLE_200
584: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
585: , a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 585: , a3 out nocopy JTF_VARCHAR2_TABLE_100

581: end rosetta_table_copy_in_p7;
582: procedure rosetta_table_copy_out_p7(t okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
583: , a1 out nocopy JTF_VARCHAR2_TABLE_200
584: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
585: , a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , a4 out nocopy JTF_VARCHAR2_TABLE_100
587: , a5 out nocopy JTF_VARCHAR2_TABLE_100
588: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
589: ) as

Line 586: , a4 out nocopy JTF_VARCHAR2_TABLE_100

582: procedure rosetta_table_copy_out_p7(t okl_okc_migration_a_pvt.qa_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
583: , a1 out nocopy JTF_VARCHAR2_TABLE_200
584: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
585: , a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , a4 out nocopy JTF_VARCHAR2_TABLE_100
587: , a5 out nocopy JTF_VARCHAR2_TABLE_100
588: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
589: ) as
590: ddindx binary_integer; indx binary_integer;

Line 587: , a5 out nocopy JTF_VARCHAR2_TABLE_100

583: , a1 out nocopy JTF_VARCHAR2_TABLE_200
584: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
585: , a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , a4 out nocopy JTF_VARCHAR2_TABLE_100
587: , a5 out nocopy JTF_VARCHAR2_TABLE_100
588: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
589: ) as
590: ddindx binary_integer; indx binary_integer;
591: begin

Line 593: a0 := JTF_VARCHAR2_TABLE_100();

589: ) as
590: ddindx binary_integer; indx binary_integer;
591: begin
592: if t is null or t.count = 0 then
593: a0 := JTF_VARCHAR2_TABLE_100();
594: a1 := JTF_VARCHAR2_TABLE_200();
595: a2 := JTF_VARCHAR2_TABLE_2000();
596: a3 := JTF_VARCHAR2_TABLE_100();
597: a4 := JTF_VARCHAR2_TABLE_100();

Line 596: a3 := JTF_VARCHAR2_TABLE_100();

592: if t is null or t.count = 0 then
593: a0 := JTF_VARCHAR2_TABLE_100();
594: a1 := JTF_VARCHAR2_TABLE_200();
595: a2 := JTF_VARCHAR2_TABLE_2000();
596: a3 := JTF_VARCHAR2_TABLE_100();
597: a4 := JTF_VARCHAR2_TABLE_100();
598: a5 := JTF_VARCHAR2_TABLE_100();
599: a6 := JTF_VARCHAR2_TABLE_2000();
600: else

Line 597: a4 := JTF_VARCHAR2_TABLE_100();

593: a0 := JTF_VARCHAR2_TABLE_100();
594: a1 := JTF_VARCHAR2_TABLE_200();
595: a2 := JTF_VARCHAR2_TABLE_2000();
596: a3 := JTF_VARCHAR2_TABLE_100();
597: a4 := JTF_VARCHAR2_TABLE_100();
598: a5 := JTF_VARCHAR2_TABLE_100();
599: a6 := JTF_VARCHAR2_TABLE_2000();
600: else
601: a0 := JTF_VARCHAR2_TABLE_100();

Line 598: a5 := JTF_VARCHAR2_TABLE_100();

594: a1 := JTF_VARCHAR2_TABLE_200();
595: a2 := JTF_VARCHAR2_TABLE_2000();
596: a3 := JTF_VARCHAR2_TABLE_100();
597: a4 := JTF_VARCHAR2_TABLE_100();
598: a5 := JTF_VARCHAR2_TABLE_100();
599: a6 := JTF_VARCHAR2_TABLE_2000();
600: else
601: a0 := JTF_VARCHAR2_TABLE_100();
602: a1 := JTF_VARCHAR2_TABLE_200();

Line 601: a0 := JTF_VARCHAR2_TABLE_100();

597: a4 := JTF_VARCHAR2_TABLE_100();
598: a5 := JTF_VARCHAR2_TABLE_100();
599: a6 := JTF_VARCHAR2_TABLE_2000();
600: else
601: a0 := JTF_VARCHAR2_TABLE_100();
602: a1 := JTF_VARCHAR2_TABLE_200();
603: a2 := JTF_VARCHAR2_TABLE_2000();
604: a3 := JTF_VARCHAR2_TABLE_100();
605: a4 := JTF_VARCHAR2_TABLE_100();

Line 604: a3 := JTF_VARCHAR2_TABLE_100();

600: else
601: a0 := JTF_VARCHAR2_TABLE_100();
602: a1 := JTF_VARCHAR2_TABLE_200();
603: a2 := JTF_VARCHAR2_TABLE_2000();
604: a3 := JTF_VARCHAR2_TABLE_100();
605: a4 := JTF_VARCHAR2_TABLE_100();
606: a5 := JTF_VARCHAR2_TABLE_100();
607: a6 := JTF_VARCHAR2_TABLE_2000();
608: if t.count > 0 then

Line 605: a4 := JTF_VARCHAR2_TABLE_100();

601: a0 := JTF_VARCHAR2_TABLE_100();
602: a1 := JTF_VARCHAR2_TABLE_200();
603: a2 := JTF_VARCHAR2_TABLE_2000();
604: a3 := JTF_VARCHAR2_TABLE_100();
605: a4 := JTF_VARCHAR2_TABLE_100();
606: a5 := JTF_VARCHAR2_TABLE_100();
607: a6 := JTF_VARCHAR2_TABLE_2000();
608: if t.count > 0 then
609: a0.extend(t.count);

Line 606: a5 := JTF_VARCHAR2_TABLE_100();

602: a1 := JTF_VARCHAR2_TABLE_200();
603: a2 := JTF_VARCHAR2_TABLE_2000();
604: a3 := JTF_VARCHAR2_TABLE_100();
605: a4 := JTF_VARCHAR2_TABLE_100();
606: a5 := JTF_VARCHAR2_TABLE_100();
607: a6 := JTF_VARCHAR2_TABLE_2000();
608: if t.count > 0 then
609: a0.extend(t.count);
610: a1.extend(t.count);

Line 1549: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

1545: , x_msg_count out nocopy NUMBER
1546: , x_msg_data out nocopy VARCHAR2
1547: , p_qcl_id NUMBER
1548: , p_chr_id NUMBER
1549: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
1551: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1552: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1552: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

1548: , p_chr_id NUMBER
1549: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
1551: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1552: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1556: )

Line 1553: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

1549: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
1551: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1552: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1556: )
1557:

Line 1554: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

1550: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
1551: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1552: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1556: )
1557:
1558: as