APPS.OKL_OKC_MIGRATION_A_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_okc_migration_a_pvt_w as
2: /* $Header: OKLEOMAB.pls 120.4 2005/08/04 03:17:32 manumanu noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_okc_migration_a_pvt_w as
2: /* $Header: OKLEOMAB.pls 120.4 2005/08/04 03:17:32 manumanu noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 5: , a2 JTF_NUMBER_TABLE

1: package body okl_okc_migration_a_pvt_w as
2: /* $Header: OKLEOMAB.pls 120.4 2005/08/04 03:17:32 manumanu noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLEOMAB.pls 120.4 2005/08/04 03:17:32 manumanu noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_a_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 9: , a6 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
13: , a10 JTF_VARCHAR2_TABLE_2000

Line 12: , a9 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
16: , a13 JTF_VARCHAR2_TABLE_200

Line 34: , a31 JTF_NUMBER_TABLE

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
38: , a35 JTF_NUMBER_TABLE

Line 36: , a33 JTF_NUMBER_TABLE

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
38: , a35 JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;

Line 38: , a35 JTF_NUMBER_TABLE

34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if a0 is not null and a0.count > 0 then

Line 92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p3;
92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 93: , a1 out nocopy JTF_NUMBER_TABLE

89: end if;
90: end if;
91: end rosetta_table_copy_in_p3;
92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 94: , a2 out nocopy JTF_NUMBER_TABLE

90: end if;
91: end rosetta_table_copy_in_p3;
92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 95: , a3 out nocopy JTF_NUMBER_TABLE

91: end rosetta_table_copy_in_p3;
92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 96: , a4 out nocopy JTF_NUMBER_TABLE

92: procedure rosetta_table_copy_out_p3(t okl_okc_migration_a_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 98: , a6 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
102: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 101: , a9 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
105: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 123: , a31 out nocopy JTF_NUMBER_TABLE

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
127: , a35 out nocopy JTF_NUMBER_TABLE

Line 125: , a33 out nocopy JTF_NUMBER_TABLE

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
127: , a35 out nocopy JTF_NUMBER_TABLE
128: ) as
129: ddindx binary_integer; indx binary_integer;

Line 127: , a35 out nocopy JTF_NUMBER_TABLE

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
127: , a35 out nocopy JTF_NUMBER_TABLE
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if t is null or t.count = 0 then

Line 132: a0 := JTF_NUMBER_TABLE();

128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_NUMBER_TABLE();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();

Line 133: a1 := JTF_NUMBER_TABLE();

129: ddindx binary_integer; indx binary_integer;
130: begin
131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
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();

Line 134: a2 := JTF_NUMBER_TABLE();

130: begin
131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
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();

Line 135: a3 := JTF_NUMBER_TABLE();

131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
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();

Line 136: a4 := JTF_NUMBER_TABLE();

132: a0 := JTF_NUMBER_TABLE();
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();

Line 138: a6 := 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();
142: a10 := JTF_VARCHAR2_TABLE_2000();

Line 141: a9 := 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();
145: a13 := JTF_VARCHAR2_TABLE_200();

Line 163: a31 := JTF_NUMBER_TABLE();

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();
167: a35 := JTF_NUMBER_TABLE();

Line 165: a33 := JTF_NUMBER_TABLE();

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();
167: a35 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();

Line 167: a35 := JTF_NUMBER_TABLE();

163: a31 := JTF_NUMBER_TABLE();
164: a32 := JTF_DATE_TABLE();
165: a33 := JTF_NUMBER_TABLE();
166: a34 := JTF_DATE_TABLE();
167: a35 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();

Line 169: a0 := JTF_NUMBER_TABLE();

165: a33 := JTF_NUMBER_TABLE();
166: a34 := JTF_DATE_TABLE();
167: a35 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_NUMBER_TABLE();
173: a4 := JTF_NUMBER_TABLE();

Line 170: a1 := JTF_NUMBER_TABLE();

166: a34 := JTF_DATE_TABLE();
167: a35 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
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();

Line 171: a2 := JTF_NUMBER_TABLE();

167: a35 := JTF_NUMBER_TABLE();
168: else
169: a0 := JTF_NUMBER_TABLE();
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();

Line 172: a3 := JTF_NUMBER_TABLE();

168: else
169: a0 := JTF_NUMBER_TABLE();
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();

Line 173: a4 := JTF_NUMBER_TABLE();

169: a0 := JTF_NUMBER_TABLE();
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();

Line 175: a6 := 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();
179: a10 := JTF_VARCHAR2_TABLE_2000();

Line 178: a9 := 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();
182: a13 := JTF_VARCHAR2_TABLE_200();

Line 200: a31 := JTF_NUMBER_TABLE();

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();
204: a35 := JTF_NUMBER_TABLE();

Line 202: a33 := JTF_NUMBER_TABLE();

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();
204: a35 := JTF_NUMBER_TABLE();
205: if t.count > 0 then
206: a0.extend(t.count);

Line 204: a35 := JTF_NUMBER_TABLE();

200: a31 := JTF_NUMBER_TABLE();
201: a32 := JTF_DATE_TABLE();
202: a33 := JTF_NUMBER_TABLE();
203: a34 := JTF_DATE_TABLE();
204: a35 := JTF_NUMBER_TABLE();
205: if t.count > 0 then
206: a0.extend(t.count);
207: a1.extend(t.count);
208: a2.extend(t.count);

Line 291: procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_a_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE

287: end if;
288: end if;
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

Line 292: , a1 JTF_NUMBER_TABLE

288: end if;
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

Line 297: , a6 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
301: , a10 JTF_VARCHAR2_TABLE_2000

Line 298: , a7 JTF_NUMBER_TABLE

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
301: , a10 JTF_VARCHAR2_TABLE_2000
302: , a11 JTF_VARCHAR2_TABLE_100

Line 299: , a8 JTF_NUMBER_TABLE

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
301: , a10 JTF_VARCHAR2_TABLE_2000
302: , a11 JTF_VARCHAR2_TABLE_100
303: , a12 JTF_VARCHAR2_TABLE_500

Line 300: , a9 JTF_NUMBER_TABLE

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
301: , a10 JTF_VARCHAR2_TABLE_2000
302: , a11 JTF_VARCHAR2_TABLE_100
303: , a12 JTF_VARCHAR2_TABLE_500
304: , a13 JTF_VARCHAR2_TABLE_500

Line 318: , a27 JTF_NUMBER_TABLE

314: , a23 JTF_VARCHAR2_TABLE_500
315: , a24 JTF_VARCHAR2_TABLE_500
316: , a25 JTF_VARCHAR2_TABLE_500
317: , a26 JTF_VARCHAR2_TABLE_500
318: , a27 JTF_NUMBER_TABLE
319: , a28 JTF_DATE_TABLE
320: , a29 JTF_NUMBER_TABLE
321: , a30 JTF_DATE_TABLE
322: , a31 JTF_NUMBER_TABLE

Line 320: , a29 JTF_NUMBER_TABLE

316: , a25 JTF_VARCHAR2_TABLE_500
317: , a26 JTF_VARCHAR2_TABLE_500
318: , a27 JTF_NUMBER_TABLE
319: , a28 JTF_DATE_TABLE
320: , a29 JTF_NUMBER_TABLE
321: , a30 JTF_DATE_TABLE
322: , a31 JTF_NUMBER_TABLE
323: ) as
324: ddindx binary_integer; indx binary_integer;

Line 322: , a31 JTF_NUMBER_TABLE

318: , a27 JTF_NUMBER_TABLE
319: , a28 JTF_DATE_TABLE
320: , a29 JTF_NUMBER_TABLE
321: , a30 JTF_DATE_TABLE
322: , a31 JTF_NUMBER_TABLE
323: ) as
324: ddindx binary_integer; indx binary_integer;
325: begin
326: if a0 is not null and a0.count > 0 then

Line 372: procedure rosetta_table_copy_out_p5(t okl_okc_migration_a_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

368: end loop;
369: end if;
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

Line 373: , a1 out nocopy JTF_NUMBER_TABLE

369: end if;
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

Line 378: , a6 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
382: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 379: , a7 out nocopy JTF_NUMBER_TABLE

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
382: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 380: , a8 out nocopy JTF_NUMBER_TABLE

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
382: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a11 out nocopy JTF_VARCHAR2_TABLE_100
384: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 381: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 399: , a27 out nocopy JTF_NUMBER_TABLE

395: , a23 out nocopy JTF_VARCHAR2_TABLE_500
396: , a24 out nocopy JTF_VARCHAR2_TABLE_500
397: , a25 out nocopy JTF_VARCHAR2_TABLE_500
398: , a26 out nocopy JTF_VARCHAR2_TABLE_500
399: , a27 out nocopy JTF_NUMBER_TABLE
400: , a28 out nocopy JTF_DATE_TABLE
401: , a29 out nocopy JTF_NUMBER_TABLE
402: , a30 out nocopy JTF_DATE_TABLE
403: , a31 out nocopy JTF_NUMBER_TABLE

Line 401: , a29 out nocopy JTF_NUMBER_TABLE

397: , a25 out nocopy JTF_VARCHAR2_TABLE_500
398: , a26 out nocopy JTF_VARCHAR2_TABLE_500
399: , a27 out nocopy JTF_NUMBER_TABLE
400: , a28 out nocopy JTF_DATE_TABLE
401: , a29 out nocopy JTF_NUMBER_TABLE
402: , a30 out nocopy JTF_DATE_TABLE
403: , a31 out nocopy JTF_NUMBER_TABLE
404: ) as
405: ddindx binary_integer; indx binary_integer;

Line 403: , a31 out nocopy JTF_NUMBER_TABLE

399: , a27 out nocopy JTF_NUMBER_TABLE
400: , a28 out nocopy JTF_DATE_TABLE
401: , a29 out nocopy JTF_NUMBER_TABLE
402: , a30 out nocopy JTF_DATE_TABLE
403: , a31 out nocopy JTF_NUMBER_TABLE
404: ) as
405: ddindx binary_integer; indx binary_integer;
406: begin
407: if t is null or t.count = 0 then

Line 408: a0 := JTF_NUMBER_TABLE();

404: ) as
405: ddindx binary_integer; indx binary_integer;
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();

Line 409: a1 := JTF_NUMBER_TABLE();

405: ddindx binary_integer; indx binary_integer;
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();

Line 414: a6 := 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();
418: a10 := JTF_VARCHAR2_TABLE_2000();

Line 415: a7 := JTF_NUMBER_TABLE();

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();
418: a10 := JTF_VARCHAR2_TABLE_2000();
419: a11 := JTF_VARCHAR2_TABLE_100();

Line 416: a8 := JTF_NUMBER_TABLE();

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();
418: a10 := JTF_VARCHAR2_TABLE_2000();
419: a11 := JTF_VARCHAR2_TABLE_100();
420: a12 := JTF_VARCHAR2_TABLE_500();

Line 417: a9 := JTF_NUMBER_TABLE();

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();
418: a10 := JTF_VARCHAR2_TABLE_2000();
419: a11 := JTF_VARCHAR2_TABLE_100();
420: a12 := JTF_VARCHAR2_TABLE_500();
421: a13 := JTF_VARCHAR2_TABLE_500();

Line 435: a27 := JTF_NUMBER_TABLE();

431: a23 := JTF_VARCHAR2_TABLE_500();
432: a24 := JTF_VARCHAR2_TABLE_500();
433: a25 := JTF_VARCHAR2_TABLE_500();
434: a26 := JTF_VARCHAR2_TABLE_500();
435: a27 := JTF_NUMBER_TABLE();
436: a28 := JTF_DATE_TABLE();
437: a29 := JTF_NUMBER_TABLE();
438: a30 := JTF_DATE_TABLE();
439: a31 := JTF_NUMBER_TABLE();

Line 437: a29 := JTF_NUMBER_TABLE();

433: a25 := JTF_VARCHAR2_TABLE_500();
434: a26 := JTF_VARCHAR2_TABLE_500();
435: a27 := JTF_NUMBER_TABLE();
436: a28 := JTF_DATE_TABLE();
437: a29 := JTF_NUMBER_TABLE();
438: a30 := JTF_DATE_TABLE();
439: a31 := JTF_NUMBER_TABLE();
440: else
441: a0 := JTF_NUMBER_TABLE();

Line 439: a31 := JTF_NUMBER_TABLE();

435: a27 := JTF_NUMBER_TABLE();
436: a28 := JTF_DATE_TABLE();
437: a29 := JTF_NUMBER_TABLE();
438: a30 := JTF_DATE_TABLE();
439: a31 := JTF_NUMBER_TABLE();
440: else
441: a0 := JTF_NUMBER_TABLE();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_VARCHAR2_TABLE_100();

Line 441: a0 := JTF_NUMBER_TABLE();

437: a29 := JTF_NUMBER_TABLE();
438: a30 := JTF_DATE_TABLE();
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();

Line 442: a1 := JTF_NUMBER_TABLE();

438: a30 := JTF_DATE_TABLE();
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();

Line 447: a6 := 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();
451: a10 := JTF_VARCHAR2_TABLE_2000();

Line 448: a7 := JTF_NUMBER_TABLE();

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();
451: a10 := JTF_VARCHAR2_TABLE_2000();
452: a11 := JTF_VARCHAR2_TABLE_100();

Line 449: a8 := JTF_NUMBER_TABLE();

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();
451: a10 := JTF_VARCHAR2_TABLE_2000();
452: a11 := JTF_VARCHAR2_TABLE_100();
453: a12 := JTF_VARCHAR2_TABLE_500();

Line 450: a9 := JTF_NUMBER_TABLE();

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();
451: a10 := JTF_VARCHAR2_TABLE_2000();
452: a11 := JTF_VARCHAR2_TABLE_100();
453: a12 := JTF_VARCHAR2_TABLE_500();
454: a13 := JTF_VARCHAR2_TABLE_500();

Line 468: a27 := JTF_NUMBER_TABLE();

464: a23 := JTF_VARCHAR2_TABLE_500();
465: a24 := JTF_VARCHAR2_TABLE_500();
466: a25 := JTF_VARCHAR2_TABLE_500();
467: a26 := JTF_VARCHAR2_TABLE_500();
468: a27 := JTF_NUMBER_TABLE();
469: a28 := JTF_DATE_TABLE();
470: a29 := JTF_NUMBER_TABLE();
471: a30 := JTF_DATE_TABLE();
472: a31 := JTF_NUMBER_TABLE();

Line 470: a29 := JTF_NUMBER_TABLE();

466: a25 := JTF_VARCHAR2_TABLE_500();
467: a26 := JTF_VARCHAR2_TABLE_500();
468: a27 := JTF_NUMBER_TABLE();
469: a28 := JTF_DATE_TABLE();
470: a29 := JTF_NUMBER_TABLE();
471: a30 := JTF_DATE_TABLE();
472: a31 := JTF_NUMBER_TABLE();
473: if t.count > 0 then
474: a0.extend(t.count);

Line 472: a31 := JTF_NUMBER_TABLE();

468: a27 := JTF_NUMBER_TABLE();
469: a28 := JTF_DATE_TABLE();
470: a29 := JTF_NUMBER_TABLE();
471: a30 := JTF_DATE_TABLE();
472: a31 := JTF_NUMBER_TABLE();
473: if t.count > 0 then
474: a0.extend(t.count);
475: a1.extend(t.count);
476: a2.extend(t.count);