APPS.OKL_CAT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE

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_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100

Line 51: , a29 JTF_NUMBER_TABLE

47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_VARCHAR2_TABLE_500
50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE

Line 52: , a30 JTF_NUMBER_TABLE

48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_VARCHAR2_TABLE_500
50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE

Line 54: , a32 JTF_NUMBER_TABLE

50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE

Line 56: , a34 JTF_NUMBER_TABLE

52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: ) as
60: ddindx binary_integer; indx binary_integer;

Line 57: , a35 JTF_NUMBER_TABLE

53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: ) as
60: ddindx binary_integer; indx binary_integer;
61: begin

Line 58: , a36 JTF_NUMBER_TABLE

54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: ) as
60: ddindx binary_integer; indx binary_integer;
61: begin
62: if a0 is not null and a0.count > 0 then

Line 113: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

109: end loop;
110: end if;
111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_VARCHAR2_TABLE_200
115: , a2 out nocopy JTF_NUMBER_TABLE
116: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117: , a4 out nocopy JTF_DATE_TABLE

Line 115: , a2 out nocopy JTF_NUMBER_TABLE

111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_VARCHAR2_TABLE_200
115: , a2 out nocopy JTF_NUMBER_TABLE
116: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117: , a4 out nocopy JTF_DATE_TABLE
118: , a5 out nocopy JTF_DATE_TABLE
119: , a6 out nocopy JTF_NUMBER_TABLE

Line 119: , a6 out nocopy JTF_NUMBER_TABLE

115: , a2 out nocopy JTF_NUMBER_TABLE
116: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117: , a4 out nocopy JTF_DATE_TABLE
118: , a5 out nocopy JTF_DATE_TABLE
119: , a6 out nocopy JTF_NUMBER_TABLE
120: , a7 out nocopy JTF_NUMBER_TABLE
121: , a8 out nocopy JTF_NUMBER_TABLE
122: , a9 out nocopy JTF_VARCHAR2_TABLE_100
123: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , a7 out nocopy JTF_NUMBER_TABLE

116: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117: , a4 out nocopy JTF_DATE_TABLE
118: , a5 out nocopy JTF_DATE_TABLE
119: , a6 out nocopy JTF_NUMBER_TABLE
120: , a7 out nocopy JTF_NUMBER_TABLE
121: , a8 out nocopy JTF_NUMBER_TABLE
122: , a9 out nocopy JTF_VARCHAR2_TABLE_100
123: , a10 out nocopy JTF_VARCHAR2_TABLE_100
124: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a8 out nocopy JTF_NUMBER_TABLE

117: , a4 out nocopy JTF_DATE_TABLE
118: , a5 out nocopy JTF_DATE_TABLE
119: , a6 out nocopy JTF_NUMBER_TABLE
120: , a7 out nocopy JTF_NUMBER_TABLE
121: , a8 out nocopy JTF_NUMBER_TABLE
122: , a9 out nocopy JTF_VARCHAR2_TABLE_100
123: , a10 out nocopy JTF_VARCHAR2_TABLE_100
124: , a11 out nocopy JTF_VARCHAR2_TABLE_100
125: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , a29 out nocopy JTF_NUMBER_TABLE

138: , a25 out nocopy JTF_VARCHAR2_TABLE_500
139: , a26 out nocopy JTF_VARCHAR2_TABLE_500
140: , a27 out nocopy JTF_VARCHAR2_TABLE_500
141: , a28 out nocopy JTF_VARCHAR2_TABLE_500
142: , a29 out nocopy JTF_NUMBER_TABLE
143: , a30 out nocopy JTF_NUMBER_TABLE
144: , a31 out nocopy JTF_DATE_TABLE
145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE

Line 143: , a30 out nocopy JTF_NUMBER_TABLE

139: , a26 out nocopy JTF_VARCHAR2_TABLE_500
140: , a27 out nocopy JTF_VARCHAR2_TABLE_500
141: , a28 out nocopy JTF_VARCHAR2_TABLE_500
142: , a29 out nocopy JTF_NUMBER_TABLE
143: , a30 out nocopy JTF_NUMBER_TABLE
144: , a31 out nocopy JTF_DATE_TABLE
145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE
147: , a34 out nocopy JTF_NUMBER_TABLE

Line 145: , a32 out nocopy JTF_NUMBER_TABLE

141: , a28 out nocopy JTF_VARCHAR2_TABLE_500
142: , a29 out nocopy JTF_NUMBER_TABLE
143: , a30 out nocopy JTF_NUMBER_TABLE
144: , a31 out nocopy JTF_DATE_TABLE
145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE
147: , a34 out nocopy JTF_NUMBER_TABLE
148: , a35 out nocopy JTF_NUMBER_TABLE
149: , a36 out nocopy JTF_NUMBER_TABLE

Line 147: , a34 out nocopy JTF_NUMBER_TABLE

143: , a30 out nocopy JTF_NUMBER_TABLE
144: , a31 out nocopy JTF_DATE_TABLE
145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE
147: , a34 out nocopy JTF_NUMBER_TABLE
148: , a35 out nocopy JTF_NUMBER_TABLE
149: , a36 out nocopy JTF_NUMBER_TABLE
150: ) as
151: ddindx binary_integer; indx binary_integer;

Line 148: , a35 out nocopy JTF_NUMBER_TABLE

144: , a31 out nocopy JTF_DATE_TABLE
145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE
147: , a34 out nocopy JTF_NUMBER_TABLE
148: , a35 out nocopy JTF_NUMBER_TABLE
149: , a36 out nocopy JTF_NUMBER_TABLE
150: ) as
151: ddindx binary_integer; indx binary_integer;
152: begin

Line 149: , a36 out nocopy JTF_NUMBER_TABLE

145: , a32 out nocopy JTF_NUMBER_TABLE
146: , a33 out nocopy JTF_DATE_TABLE
147: , a34 out nocopy JTF_NUMBER_TABLE
148: , a35 out nocopy JTF_NUMBER_TABLE
149: , a36 out nocopy JTF_NUMBER_TABLE
150: ) as
151: ddindx binary_integer; indx binary_integer;
152: begin
153: if t is null or t.count = 0 then

Line 154: a0 := JTF_NUMBER_TABLE();

150: ) as
151: ddindx binary_integer; indx binary_integer;
152: begin
153: if t is null or t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_VARCHAR2_TABLE_200();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_2000();
158: a4 := JTF_DATE_TABLE();

Line 156: a2 := JTF_NUMBER_TABLE();

152: begin
153: if t is null or t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_VARCHAR2_TABLE_200();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_2000();
158: a4 := JTF_DATE_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();

Line 160: a6 := JTF_NUMBER_TABLE();

156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_2000();
158: a4 := JTF_DATE_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_VARCHAR2_TABLE_100();
164: a10 := JTF_VARCHAR2_TABLE_100();

Line 161: a7 := JTF_NUMBER_TABLE();

157: a3 := JTF_VARCHAR2_TABLE_2000();
158: a4 := JTF_DATE_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_VARCHAR2_TABLE_100();
164: a10 := JTF_VARCHAR2_TABLE_100();
165: a11 := JTF_VARCHAR2_TABLE_100();

Line 162: a8 := JTF_NUMBER_TABLE();

158: a4 := JTF_DATE_TABLE();
159: a5 := JTF_DATE_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_NUMBER_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_VARCHAR2_TABLE_100();
164: a10 := JTF_VARCHAR2_TABLE_100();
165: a11 := JTF_VARCHAR2_TABLE_100();
166: a12 := JTF_VARCHAR2_TABLE_100();

Line 183: a29 := JTF_NUMBER_TABLE();

179: a25 := JTF_VARCHAR2_TABLE_500();
180: a26 := JTF_VARCHAR2_TABLE_500();
181: a27 := JTF_VARCHAR2_TABLE_500();
182: a28 := JTF_VARCHAR2_TABLE_500();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_DATE_TABLE();
186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();

Line 184: a30 := JTF_NUMBER_TABLE();

180: a26 := JTF_VARCHAR2_TABLE_500();
181: a27 := JTF_VARCHAR2_TABLE_500();
182: a28 := JTF_VARCHAR2_TABLE_500();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_DATE_TABLE();
186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();
188: a34 := JTF_NUMBER_TABLE();

Line 186: a32 := JTF_NUMBER_TABLE();

182: a28 := JTF_VARCHAR2_TABLE_500();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_DATE_TABLE();
186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_NUMBER_TABLE();
190: a36 := JTF_NUMBER_TABLE();

Line 188: a34 := JTF_NUMBER_TABLE();

184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_DATE_TABLE();
186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_NUMBER_TABLE();
190: a36 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();

Line 189: a35 := JTF_NUMBER_TABLE();

185: a31 := JTF_DATE_TABLE();
186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_NUMBER_TABLE();
190: a36 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_VARCHAR2_TABLE_200();

Line 190: a36 := JTF_NUMBER_TABLE();

186: a32 := JTF_NUMBER_TABLE();
187: a33 := JTF_DATE_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_NUMBER_TABLE();
190: a36 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_VARCHAR2_TABLE_200();
194: a2 := JTF_NUMBER_TABLE();

Line 192: a0 := JTF_NUMBER_TABLE();

188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_NUMBER_TABLE();
190: a36 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_VARCHAR2_TABLE_200();
194: a2 := JTF_NUMBER_TABLE();
195: a3 := JTF_VARCHAR2_TABLE_2000();
196: a4 := JTF_DATE_TABLE();

Line 194: a2 := JTF_NUMBER_TABLE();

190: a36 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_VARCHAR2_TABLE_200();
194: a2 := JTF_NUMBER_TABLE();
195: a3 := JTF_VARCHAR2_TABLE_2000();
196: a4 := JTF_DATE_TABLE();
197: a5 := JTF_DATE_TABLE();
198: a6 := JTF_NUMBER_TABLE();

Line 198: a6 := JTF_NUMBER_TABLE();

194: a2 := JTF_NUMBER_TABLE();
195: a3 := JTF_VARCHAR2_TABLE_2000();
196: a4 := JTF_DATE_TABLE();
197: a5 := JTF_DATE_TABLE();
198: a6 := JTF_NUMBER_TABLE();
199: a7 := JTF_NUMBER_TABLE();
200: a8 := JTF_NUMBER_TABLE();
201: a9 := JTF_VARCHAR2_TABLE_100();
202: a10 := JTF_VARCHAR2_TABLE_100();

Line 199: a7 := JTF_NUMBER_TABLE();

195: a3 := JTF_VARCHAR2_TABLE_2000();
196: a4 := JTF_DATE_TABLE();
197: a5 := JTF_DATE_TABLE();
198: a6 := JTF_NUMBER_TABLE();
199: a7 := JTF_NUMBER_TABLE();
200: a8 := JTF_NUMBER_TABLE();
201: a9 := JTF_VARCHAR2_TABLE_100();
202: a10 := JTF_VARCHAR2_TABLE_100();
203: a11 := JTF_VARCHAR2_TABLE_100();

Line 200: a8 := JTF_NUMBER_TABLE();

196: a4 := JTF_DATE_TABLE();
197: a5 := JTF_DATE_TABLE();
198: a6 := JTF_NUMBER_TABLE();
199: a7 := JTF_NUMBER_TABLE();
200: a8 := JTF_NUMBER_TABLE();
201: a9 := JTF_VARCHAR2_TABLE_100();
202: a10 := JTF_VARCHAR2_TABLE_100();
203: a11 := JTF_VARCHAR2_TABLE_100();
204: a12 := JTF_VARCHAR2_TABLE_100();

Line 221: a29 := JTF_NUMBER_TABLE();

217: a25 := JTF_VARCHAR2_TABLE_500();
218: a26 := JTF_VARCHAR2_TABLE_500();
219: a27 := JTF_VARCHAR2_TABLE_500();
220: a28 := JTF_VARCHAR2_TABLE_500();
221: a29 := JTF_NUMBER_TABLE();
222: a30 := JTF_NUMBER_TABLE();
223: a31 := JTF_DATE_TABLE();
224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();

Line 222: a30 := JTF_NUMBER_TABLE();

218: a26 := JTF_VARCHAR2_TABLE_500();
219: a27 := JTF_VARCHAR2_TABLE_500();
220: a28 := JTF_VARCHAR2_TABLE_500();
221: a29 := JTF_NUMBER_TABLE();
222: a30 := JTF_NUMBER_TABLE();
223: a31 := JTF_DATE_TABLE();
224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();
226: a34 := JTF_NUMBER_TABLE();

Line 224: a32 := JTF_NUMBER_TABLE();

220: a28 := JTF_VARCHAR2_TABLE_500();
221: a29 := JTF_NUMBER_TABLE();
222: a30 := JTF_NUMBER_TABLE();
223: a31 := JTF_DATE_TABLE();
224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();
226: a34 := JTF_NUMBER_TABLE();
227: a35 := JTF_NUMBER_TABLE();
228: a36 := JTF_NUMBER_TABLE();

Line 226: a34 := JTF_NUMBER_TABLE();

222: a30 := JTF_NUMBER_TABLE();
223: a31 := JTF_DATE_TABLE();
224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();
226: a34 := JTF_NUMBER_TABLE();
227: a35 := JTF_NUMBER_TABLE();
228: a36 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);

Line 227: a35 := JTF_NUMBER_TABLE();

223: a31 := JTF_DATE_TABLE();
224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();
226: a34 := JTF_NUMBER_TABLE();
227: a35 := JTF_NUMBER_TABLE();
228: a36 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);

Line 228: a36 := JTF_NUMBER_TABLE();

224: a32 := JTF_NUMBER_TABLE();
225: a33 := JTF_DATE_TABLE();
226: a34 := JTF_NUMBER_TABLE();
227: a35 := JTF_NUMBER_TABLE();
228: a36 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);
232: a2.extend(t.count);

Line 317: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE

313: end if;
314: end if;
315: end rosetta_table_copy_out_p2;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_VARCHAR2_TABLE_200
320: , a3 JTF_VARCHAR2_TABLE_2000
321: , a4 JTF_DATE_TABLE

Line 318: , a1 JTF_NUMBER_TABLE

314: end if;
315: end rosetta_table_copy_out_p2;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_VARCHAR2_TABLE_200
320: , a3 JTF_VARCHAR2_TABLE_2000
321: , a4 JTF_DATE_TABLE
322: , a5 JTF_DATE_TABLE

Line 323: , a6 JTF_NUMBER_TABLE

319: , a2 JTF_VARCHAR2_TABLE_200
320: , a3 JTF_VARCHAR2_TABLE_2000
321: , a4 JTF_DATE_TABLE
322: , a5 JTF_DATE_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_NUMBER_TABLE
325: , a8 JTF_NUMBER_TABLE
326: , a9 JTF_VARCHAR2_TABLE_100
327: , a10 JTF_VARCHAR2_TABLE_100

Line 324: , a7 JTF_NUMBER_TABLE

320: , a3 JTF_VARCHAR2_TABLE_2000
321: , a4 JTF_DATE_TABLE
322: , a5 JTF_DATE_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_NUMBER_TABLE
325: , a8 JTF_NUMBER_TABLE
326: , a9 JTF_VARCHAR2_TABLE_100
327: , a10 JTF_VARCHAR2_TABLE_100
328: , a11 JTF_VARCHAR2_TABLE_100

Line 325: , a8 JTF_NUMBER_TABLE

321: , a4 JTF_DATE_TABLE
322: , a5 JTF_DATE_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_NUMBER_TABLE
325: , a8 JTF_NUMBER_TABLE
326: , a9 JTF_VARCHAR2_TABLE_100
327: , a10 JTF_VARCHAR2_TABLE_100
328: , a11 JTF_VARCHAR2_TABLE_100
329: , a12 JTF_VARCHAR2_TABLE_100

Line 346: , a29 JTF_NUMBER_TABLE

342: , a25 JTF_VARCHAR2_TABLE_500
343: , a26 JTF_VARCHAR2_TABLE_500
344: , a27 JTF_VARCHAR2_TABLE_500
345: , a28 JTF_VARCHAR2_TABLE_500
346: , a29 JTF_NUMBER_TABLE
347: , a30 JTF_NUMBER_TABLE
348: , a31 JTF_DATE_TABLE
349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE

Line 347: , a30 JTF_NUMBER_TABLE

343: , a26 JTF_VARCHAR2_TABLE_500
344: , a27 JTF_VARCHAR2_TABLE_500
345: , a28 JTF_VARCHAR2_TABLE_500
346: , a29 JTF_NUMBER_TABLE
347: , a30 JTF_NUMBER_TABLE
348: , a31 JTF_DATE_TABLE
349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE
351: , a34 JTF_NUMBER_TABLE

Line 349: , a32 JTF_NUMBER_TABLE

345: , a28 JTF_VARCHAR2_TABLE_500
346: , a29 JTF_NUMBER_TABLE
347: , a30 JTF_NUMBER_TABLE
348: , a31 JTF_DATE_TABLE
349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE
351: , a34 JTF_NUMBER_TABLE
352: , a35 JTF_NUMBER_TABLE
353: , a36 JTF_NUMBER_TABLE

Line 351: , a34 JTF_NUMBER_TABLE

347: , a30 JTF_NUMBER_TABLE
348: , a31 JTF_DATE_TABLE
349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE
351: , a34 JTF_NUMBER_TABLE
352: , a35 JTF_NUMBER_TABLE
353: , a36 JTF_NUMBER_TABLE
354: ) as
355: ddindx binary_integer; indx binary_integer;

Line 352: , a35 JTF_NUMBER_TABLE

348: , a31 JTF_DATE_TABLE
349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE
351: , a34 JTF_NUMBER_TABLE
352: , a35 JTF_NUMBER_TABLE
353: , a36 JTF_NUMBER_TABLE
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin

Line 353: , a36 JTF_NUMBER_TABLE

349: , a32 JTF_NUMBER_TABLE
350: , a33 JTF_DATE_TABLE
351: , a34 JTF_NUMBER_TABLE
352: , a35 JTF_NUMBER_TABLE
353: , a36 JTF_NUMBER_TABLE
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin
357: if a0 is not null and a0.count > 0 then

Line 408: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

404: end loop;
405: end if;
406: end if;
407: end rosetta_table_copy_in_p5;
408: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
409: , a1 out nocopy JTF_NUMBER_TABLE
410: , a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a4 out nocopy JTF_DATE_TABLE

Line 409: , a1 out nocopy JTF_NUMBER_TABLE

405: end if;
406: end if;
407: end rosetta_table_copy_in_p5;
408: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
409: , a1 out nocopy JTF_NUMBER_TABLE
410: , a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a4 out nocopy JTF_DATE_TABLE
413: , a5 out nocopy JTF_DATE_TABLE

Line 414: , a6 out nocopy JTF_NUMBER_TABLE

410: , a2 out nocopy JTF_VARCHAR2_TABLE_200
411: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a4 out nocopy JTF_DATE_TABLE
413: , a5 out nocopy JTF_DATE_TABLE
414: , a6 out nocopy JTF_NUMBER_TABLE
415: , a7 out nocopy JTF_NUMBER_TABLE
416: , a8 out nocopy JTF_NUMBER_TABLE
417: , a9 out nocopy JTF_VARCHAR2_TABLE_100
418: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 415: , a7 out nocopy JTF_NUMBER_TABLE

411: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412: , a4 out nocopy JTF_DATE_TABLE
413: , a5 out nocopy JTF_DATE_TABLE
414: , a6 out nocopy JTF_NUMBER_TABLE
415: , a7 out nocopy JTF_NUMBER_TABLE
416: , a8 out nocopy JTF_NUMBER_TABLE
417: , a9 out nocopy JTF_VARCHAR2_TABLE_100
418: , a10 out nocopy JTF_VARCHAR2_TABLE_100
419: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 416: , a8 out nocopy JTF_NUMBER_TABLE

412: , a4 out nocopy JTF_DATE_TABLE
413: , a5 out nocopy JTF_DATE_TABLE
414: , a6 out nocopy JTF_NUMBER_TABLE
415: , a7 out nocopy JTF_NUMBER_TABLE
416: , a8 out nocopy JTF_NUMBER_TABLE
417: , a9 out nocopy JTF_VARCHAR2_TABLE_100
418: , a10 out nocopy JTF_VARCHAR2_TABLE_100
419: , a11 out nocopy JTF_VARCHAR2_TABLE_100
420: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 437: , a29 out nocopy JTF_NUMBER_TABLE

433: , a25 out nocopy JTF_VARCHAR2_TABLE_500
434: , a26 out nocopy JTF_VARCHAR2_TABLE_500
435: , a27 out nocopy JTF_VARCHAR2_TABLE_500
436: , a28 out nocopy JTF_VARCHAR2_TABLE_500
437: , a29 out nocopy JTF_NUMBER_TABLE
438: , a30 out nocopy JTF_NUMBER_TABLE
439: , a31 out nocopy JTF_DATE_TABLE
440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE

Line 438: , a30 out nocopy JTF_NUMBER_TABLE

434: , a26 out nocopy JTF_VARCHAR2_TABLE_500
435: , a27 out nocopy JTF_VARCHAR2_TABLE_500
436: , a28 out nocopy JTF_VARCHAR2_TABLE_500
437: , a29 out nocopy JTF_NUMBER_TABLE
438: , a30 out nocopy JTF_NUMBER_TABLE
439: , a31 out nocopy JTF_DATE_TABLE
440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE
442: , a34 out nocopy JTF_NUMBER_TABLE

Line 440: , a32 out nocopy JTF_NUMBER_TABLE

436: , a28 out nocopy JTF_VARCHAR2_TABLE_500
437: , a29 out nocopy JTF_NUMBER_TABLE
438: , a30 out nocopy JTF_NUMBER_TABLE
439: , a31 out nocopy JTF_DATE_TABLE
440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE
442: , a34 out nocopy JTF_NUMBER_TABLE
443: , a35 out nocopy JTF_NUMBER_TABLE
444: , a36 out nocopy JTF_NUMBER_TABLE

Line 442: , a34 out nocopy JTF_NUMBER_TABLE

438: , a30 out nocopy JTF_NUMBER_TABLE
439: , a31 out nocopy JTF_DATE_TABLE
440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE
442: , a34 out nocopy JTF_NUMBER_TABLE
443: , a35 out nocopy JTF_NUMBER_TABLE
444: , a36 out nocopy JTF_NUMBER_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;

Line 443: , a35 out nocopy JTF_NUMBER_TABLE

439: , a31 out nocopy JTF_DATE_TABLE
440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE
442: , a34 out nocopy JTF_NUMBER_TABLE
443: , a35 out nocopy JTF_NUMBER_TABLE
444: , a36 out nocopy JTF_NUMBER_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin

Line 444: , a36 out nocopy JTF_NUMBER_TABLE

440: , a32 out nocopy JTF_NUMBER_TABLE
441: , a33 out nocopy JTF_DATE_TABLE
442: , a34 out nocopy JTF_NUMBER_TABLE
443: , a35 out nocopy JTF_NUMBER_TABLE
444: , a36 out nocopy JTF_NUMBER_TABLE
445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin
448: if t is null or t.count = 0 then

Line 449: a0 := JTF_NUMBER_TABLE();

445: ) as
446: ddindx binary_integer; indx binary_integer;
447: begin
448: if t is null or t.count = 0 then
449: a0 := JTF_NUMBER_TABLE();
450: a1 := JTF_NUMBER_TABLE();
451: a2 := JTF_VARCHAR2_TABLE_200();
452: a3 := JTF_VARCHAR2_TABLE_2000();
453: a4 := JTF_DATE_TABLE();

Line 450: a1 := JTF_NUMBER_TABLE();

446: ddindx binary_integer; indx binary_integer;
447: begin
448: if t is null or t.count = 0 then
449: a0 := JTF_NUMBER_TABLE();
450: a1 := JTF_NUMBER_TABLE();
451: a2 := JTF_VARCHAR2_TABLE_200();
452: a3 := JTF_VARCHAR2_TABLE_2000();
453: a4 := JTF_DATE_TABLE();
454: a5 := JTF_DATE_TABLE();

Line 455: a6 := JTF_NUMBER_TABLE();

451: a2 := JTF_VARCHAR2_TABLE_200();
452: a3 := JTF_VARCHAR2_TABLE_2000();
453: a4 := JTF_DATE_TABLE();
454: a5 := JTF_DATE_TABLE();
455: a6 := JTF_NUMBER_TABLE();
456: a7 := JTF_NUMBER_TABLE();
457: a8 := JTF_NUMBER_TABLE();
458: a9 := JTF_VARCHAR2_TABLE_100();
459: a10 := JTF_VARCHAR2_TABLE_100();

Line 456: a7 := JTF_NUMBER_TABLE();

452: a3 := JTF_VARCHAR2_TABLE_2000();
453: a4 := JTF_DATE_TABLE();
454: a5 := JTF_DATE_TABLE();
455: a6 := JTF_NUMBER_TABLE();
456: a7 := JTF_NUMBER_TABLE();
457: a8 := JTF_NUMBER_TABLE();
458: a9 := JTF_VARCHAR2_TABLE_100();
459: a10 := JTF_VARCHAR2_TABLE_100();
460: a11 := JTF_VARCHAR2_TABLE_100();

Line 457: a8 := JTF_NUMBER_TABLE();

453: a4 := JTF_DATE_TABLE();
454: a5 := JTF_DATE_TABLE();
455: a6 := JTF_NUMBER_TABLE();
456: a7 := JTF_NUMBER_TABLE();
457: a8 := JTF_NUMBER_TABLE();
458: a9 := JTF_VARCHAR2_TABLE_100();
459: a10 := JTF_VARCHAR2_TABLE_100();
460: a11 := JTF_VARCHAR2_TABLE_100();
461: a12 := JTF_VARCHAR2_TABLE_100();

Line 478: a29 := JTF_NUMBER_TABLE();

474: a25 := JTF_VARCHAR2_TABLE_500();
475: a26 := JTF_VARCHAR2_TABLE_500();
476: a27 := JTF_VARCHAR2_TABLE_500();
477: a28 := JTF_VARCHAR2_TABLE_500();
478: a29 := JTF_NUMBER_TABLE();
479: a30 := JTF_NUMBER_TABLE();
480: a31 := JTF_DATE_TABLE();
481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();

Line 479: a30 := JTF_NUMBER_TABLE();

475: a26 := JTF_VARCHAR2_TABLE_500();
476: a27 := JTF_VARCHAR2_TABLE_500();
477: a28 := JTF_VARCHAR2_TABLE_500();
478: a29 := JTF_NUMBER_TABLE();
479: a30 := JTF_NUMBER_TABLE();
480: a31 := JTF_DATE_TABLE();
481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();
483: a34 := JTF_NUMBER_TABLE();

Line 481: a32 := JTF_NUMBER_TABLE();

477: a28 := JTF_VARCHAR2_TABLE_500();
478: a29 := JTF_NUMBER_TABLE();
479: a30 := JTF_NUMBER_TABLE();
480: a31 := JTF_DATE_TABLE();
481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();
483: a34 := JTF_NUMBER_TABLE();
484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();

Line 483: a34 := JTF_NUMBER_TABLE();

479: a30 := JTF_NUMBER_TABLE();
480: a31 := JTF_DATE_TABLE();
481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();
483: a34 := JTF_NUMBER_TABLE();
484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();
486: else
487: a0 := JTF_NUMBER_TABLE();

Line 484: a35 := JTF_NUMBER_TABLE();

480: a31 := JTF_DATE_TABLE();
481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();
483: a34 := JTF_NUMBER_TABLE();
484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();
486: else
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();

Line 485: a36 := JTF_NUMBER_TABLE();

481: a32 := JTF_NUMBER_TABLE();
482: a33 := JTF_DATE_TABLE();
483: a34 := JTF_NUMBER_TABLE();
484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();
486: else
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_VARCHAR2_TABLE_200();

Line 487: a0 := JTF_NUMBER_TABLE();

483: a34 := JTF_NUMBER_TABLE();
484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();
486: else
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_VARCHAR2_TABLE_200();
490: a3 := JTF_VARCHAR2_TABLE_2000();
491: a4 := JTF_DATE_TABLE();

Line 488: a1 := JTF_NUMBER_TABLE();

484: a35 := JTF_NUMBER_TABLE();
485: a36 := JTF_NUMBER_TABLE();
486: else
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_VARCHAR2_TABLE_200();
490: a3 := JTF_VARCHAR2_TABLE_2000();
491: a4 := JTF_DATE_TABLE();
492: a5 := JTF_DATE_TABLE();

Line 493: a6 := JTF_NUMBER_TABLE();

489: a2 := JTF_VARCHAR2_TABLE_200();
490: a3 := JTF_VARCHAR2_TABLE_2000();
491: a4 := JTF_DATE_TABLE();
492: a5 := JTF_DATE_TABLE();
493: a6 := JTF_NUMBER_TABLE();
494: a7 := JTF_NUMBER_TABLE();
495: a8 := JTF_NUMBER_TABLE();
496: a9 := JTF_VARCHAR2_TABLE_100();
497: a10 := JTF_VARCHAR2_TABLE_100();

Line 494: a7 := JTF_NUMBER_TABLE();

490: a3 := JTF_VARCHAR2_TABLE_2000();
491: a4 := JTF_DATE_TABLE();
492: a5 := JTF_DATE_TABLE();
493: a6 := JTF_NUMBER_TABLE();
494: a7 := JTF_NUMBER_TABLE();
495: a8 := JTF_NUMBER_TABLE();
496: a9 := JTF_VARCHAR2_TABLE_100();
497: a10 := JTF_VARCHAR2_TABLE_100();
498: a11 := JTF_VARCHAR2_TABLE_100();

Line 495: a8 := JTF_NUMBER_TABLE();

491: a4 := JTF_DATE_TABLE();
492: a5 := JTF_DATE_TABLE();
493: a6 := JTF_NUMBER_TABLE();
494: a7 := JTF_NUMBER_TABLE();
495: a8 := JTF_NUMBER_TABLE();
496: a9 := JTF_VARCHAR2_TABLE_100();
497: a10 := JTF_VARCHAR2_TABLE_100();
498: a11 := JTF_VARCHAR2_TABLE_100();
499: a12 := JTF_VARCHAR2_TABLE_100();

Line 516: a29 := JTF_NUMBER_TABLE();

512: a25 := JTF_VARCHAR2_TABLE_500();
513: a26 := JTF_VARCHAR2_TABLE_500();
514: a27 := JTF_VARCHAR2_TABLE_500();
515: a28 := JTF_VARCHAR2_TABLE_500();
516: a29 := JTF_NUMBER_TABLE();
517: a30 := JTF_NUMBER_TABLE();
518: a31 := JTF_DATE_TABLE();
519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();

Line 517: a30 := JTF_NUMBER_TABLE();

513: a26 := JTF_VARCHAR2_TABLE_500();
514: a27 := JTF_VARCHAR2_TABLE_500();
515: a28 := JTF_VARCHAR2_TABLE_500();
516: a29 := JTF_NUMBER_TABLE();
517: a30 := JTF_NUMBER_TABLE();
518: a31 := JTF_DATE_TABLE();
519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();
521: a34 := JTF_NUMBER_TABLE();

Line 519: a32 := JTF_NUMBER_TABLE();

515: a28 := JTF_VARCHAR2_TABLE_500();
516: a29 := JTF_NUMBER_TABLE();
517: a30 := JTF_NUMBER_TABLE();
518: a31 := JTF_DATE_TABLE();
519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();
521: a34 := JTF_NUMBER_TABLE();
522: a35 := JTF_NUMBER_TABLE();
523: a36 := JTF_NUMBER_TABLE();

Line 521: a34 := JTF_NUMBER_TABLE();

517: a30 := JTF_NUMBER_TABLE();
518: a31 := JTF_DATE_TABLE();
519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();
521: a34 := JTF_NUMBER_TABLE();
522: a35 := JTF_NUMBER_TABLE();
523: a36 := JTF_NUMBER_TABLE();
524: if t.count > 0 then
525: a0.extend(t.count);

Line 522: a35 := JTF_NUMBER_TABLE();

518: a31 := JTF_DATE_TABLE();
519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();
521: a34 := JTF_NUMBER_TABLE();
522: a35 := JTF_NUMBER_TABLE();
523: a36 := JTF_NUMBER_TABLE();
524: if t.count > 0 then
525: a0.extend(t.count);
526: a1.extend(t.count);

Line 523: a36 := JTF_NUMBER_TABLE();

519: a32 := JTF_NUMBER_TABLE();
520: a33 := JTF_DATE_TABLE();
521: a34 := JTF_NUMBER_TABLE();
522: a35 := JTF_NUMBER_TABLE();
523: a36 := JTF_NUMBER_TABLE();
524: if t.count > 0 then
525: a0.extend(t.count);
526: a1.extend(t.count);
527: a2.extend(t.count);

Line 804: , p5_a0 JTF_NUMBER_TABLE

800: , p_init_msg_list VARCHAR2
801: , x_return_status out nocopy VARCHAR2
802: , x_msg_count out nocopy NUMBER
803: , x_msg_data out nocopy VARCHAR2
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_200
807: , p5_a3 JTF_VARCHAR2_TABLE_2000
808: , p5_a4 JTF_DATE_TABLE

Line 805: , p5_a1 JTF_NUMBER_TABLE

801: , x_return_status out nocopy VARCHAR2
802: , x_msg_count out nocopy NUMBER
803: , x_msg_data out nocopy VARCHAR2
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_200
807: , p5_a3 JTF_VARCHAR2_TABLE_2000
808: , p5_a4 JTF_DATE_TABLE
809: , p5_a5 JTF_DATE_TABLE

Line 810: , p5_a6 JTF_NUMBER_TABLE

806: , p5_a2 JTF_VARCHAR2_TABLE_200
807: , p5_a3 JTF_VARCHAR2_TABLE_2000
808: , p5_a4 JTF_DATE_TABLE
809: , p5_a5 JTF_DATE_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_NUMBER_TABLE
812: , p5_a8 JTF_NUMBER_TABLE
813: , p5_a9 JTF_VARCHAR2_TABLE_100
814: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 811: , p5_a7 JTF_NUMBER_TABLE

807: , p5_a3 JTF_VARCHAR2_TABLE_2000
808: , p5_a4 JTF_DATE_TABLE
809: , p5_a5 JTF_DATE_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_NUMBER_TABLE
812: , p5_a8 JTF_NUMBER_TABLE
813: , p5_a9 JTF_VARCHAR2_TABLE_100
814: , p5_a10 JTF_VARCHAR2_TABLE_100
815: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 812: , p5_a8 JTF_NUMBER_TABLE

808: , p5_a4 JTF_DATE_TABLE
809: , p5_a5 JTF_DATE_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_NUMBER_TABLE
812: , p5_a8 JTF_NUMBER_TABLE
813: , p5_a9 JTF_VARCHAR2_TABLE_100
814: , p5_a10 JTF_VARCHAR2_TABLE_100
815: , p5_a11 JTF_VARCHAR2_TABLE_100
816: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 833: , p5_a29 JTF_NUMBER_TABLE

829: , p5_a25 JTF_VARCHAR2_TABLE_500
830: , p5_a26 JTF_VARCHAR2_TABLE_500
831: , p5_a27 JTF_VARCHAR2_TABLE_500
832: , p5_a28 JTF_VARCHAR2_TABLE_500
833: , p5_a29 JTF_NUMBER_TABLE
834: , p5_a30 JTF_NUMBER_TABLE
835: , p5_a31 JTF_DATE_TABLE
836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE

Line 834: , p5_a30 JTF_NUMBER_TABLE

830: , p5_a26 JTF_VARCHAR2_TABLE_500
831: , p5_a27 JTF_VARCHAR2_TABLE_500
832: , p5_a28 JTF_VARCHAR2_TABLE_500
833: , p5_a29 JTF_NUMBER_TABLE
834: , p5_a30 JTF_NUMBER_TABLE
835: , p5_a31 JTF_DATE_TABLE
836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE

Line 836: , p5_a32 JTF_NUMBER_TABLE

832: , p5_a28 JTF_VARCHAR2_TABLE_500
833: , p5_a29 JTF_NUMBER_TABLE
834: , p5_a30 JTF_NUMBER_TABLE
835: , p5_a31 JTF_DATE_TABLE
836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE

Line 838: , p5_a34 JTF_NUMBER_TABLE

834: , p5_a30 JTF_NUMBER_TABLE
835: , p5_a31 JTF_DATE_TABLE
836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 839: , p5_a35 JTF_NUMBER_TABLE

835: , p5_a31 JTF_DATE_TABLE
836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 840: , p5_a36 JTF_NUMBER_TABLE

836: , p5_a32 JTF_NUMBER_TABLE
837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
844: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 841: , p6_a0 out nocopy JTF_NUMBER_TABLE

837: , p5_a33 JTF_DATE_TABLE
838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
844: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
845: , p6_a4 out nocopy JTF_DATE_TABLE

Line 842: , p6_a1 out nocopy JTF_NUMBER_TABLE

838: , p5_a34 JTF_NUMBER_TABLE
839: , p5_a35 JTF_NUMBER_TABLE
840: , p5_a36 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
844: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_DATE_TABLE

Line 847: , p6_a6 out nocopy JTF_NUMBER_TABLE

843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
844: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_DATE_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 848: , p6_a7 out nocopy JTF_NUMBER_TABLE

844: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_DATE_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , p6_a8 out nocopy JTF_NUMBER_TABLE

845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_DATE_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 870: , p6_a29 out nocopy JTF_NUMBER_TABLE

866: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
867: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
868: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
869: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
871: , p6_a30 out nocopy JTF_NUMBER_TABLE
872: , p6_a31 out nocopy JTF_DATE_TABLE
873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE

Line 871: , p6_a30 out nocopy JTF_NUMBER_TABLE

867: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
868: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
869: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
871: , p6_a30 out nocopy JTF_NUMBER_TABLE
872: , p6_a31 out nocopy JTF_DATE_TABLE
873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE
875: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 873: , p6_a32 out nocopy JTF_NUMBER_TABLE

869: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
871: , p6_a30 out nocopy JTF_NUMBER_TABLE
872: , p6_a31 out nocopy JTF_DATE_TABLE
873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE
875: , p6_a34 out nocopy JTF_NUMBER_TABLE
876: , p6_a35 out nocopy JTF_NUMBER_TABLE
877: , p6_a36 out nocopy JTF_NUMBER_TABLE

Line 875: , p6_a34 out nocopy JTF_NUMBER_TABLE

871: , p6_a30 out nocopy JTF_NUMBER_TABLE
872: , p6_a31 out nocopy JTF_DATE_TABLE
873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE
875: , p6_a34 out nocopy JTF_NUMBER_TABLE
876: , p6_a35 out nocopy JTF_NUMBER_TABLE
877: , p6_a36 out nocopy JTF_NUMBER_TABLE
878: )
879:

Line 876: , p6_a35 out nocopy JTF_NUMBER_TABLE

872: , p6_a31 out nocopy JTF_DATE_TABLE
873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE
875: , p6_a34 out nocopy JTF_NUMBER_TABLE
876: , p6_a35 out nocopy JTF_NUMBER_TABLE
877: , p6_a36 out nocopy JTF_NUMBER_TABLE
878: )
879:
880: as

Line 877: , p6_a36 out nocopy JTF_NUMBER_TABLE

873: , p6_a32 out nocopy JTF_NUMBER_TABLE
874: , p6_a33 out nocopy JTF_DATE_TABLE
875: , p6_a34 out nocopy JTF_NUMBER_TABLE
876: , p6_a35 out nocopy JTF_NUMBER_TABLE
877: , p6_a36 out nocopy JTF_NUMBER_TABLE
878: )
879:
880: as
881: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

Line 1102: , p5_a0 JTF_NUMBER_TABLE

1098: , p_init_msg_list VARCHAR2
1099: , x_return_status out nocopy VARCHAR2
1100: , x_msg_count out nocopy NUMBER
1101: , x_msg_data out nocopy VARCHAR2
1102: , p5_a0 JTF_NUMBER_TABLE
1103: , p5_a1 JTF_NUMBER_TABLE
1104: , p5_a2 JTF_VARCHAR2_TABLE_200
1105: , p5_a3 JTF_VARCHAR2_TABLE_2000
1106: , p5_a4 JTF_DATE_TABLE

Line 1103: , p5_a1 JTF_NUMBER_TABLE

1099: , x_return_status out nocopy VARCHAR2
1100: , x_msg_count out nocopy NUMBER
1101: , x_msg_data out nocopy VARCHAR2
1102: , p5_a0 JTF_NUMBER_TABLE
1103: , p5_a1 JTF_NUMBER_TABLE
1104: , p5_a2 JTF_VARCHAR2_TABLE_200
1105: , p5_a3 JTF_VARCHAR2_TABLE_2000
1106: , p5_a4 JTF_DATE_TABLE
1107: , p5_a5 JTF_DATE_TABLE

Line 1108: , p5_a6 JTF_NUMBER_TABLE

1104: , p5_a2 JTF_VARCHAR2_TABLE_200
1105: , p5_a3 JTF_VARCHAR2_TABLE_2000
1106: , p5_a4 JTF_DATE_TABLE
1107: , p5_a5 JTF_DATE_TABLE
1108: , p5_a6 JTF_NUMBER_TABLE
1109: , p5_a7 JTF_NUMBER_TABLE
1110: , p5_a8 JTF_NUMBER_TABLE
1111: , p5_a9 JTF_VARCHAR2_TABLE_100
1112: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1109: , p5_a7 JTF_NUMBER_TABLE

1105: , p5_a3 JTF_VARCHAR2_TABLE_2000
1106: , p5_a4 JTF_DATE_TABLE
1107: , p5_a5 JTF_DATE_TABLE
1108: , p5_a6 JTF_NUMBER_TABLE
1109: , p5_a7 JTF_NUMBER_TABLE
1110: , p5_a8 JTF_NUMBER_TABLE
1111: , p5_a9 JTF_VARCHAR2_TABLE_100
1112: , p5_a10 JTF_VARCHAR2_TABLE_100
1113: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 1110: , p5_a8 JTF_NUMBER_TABLE

1106: , p5_a4 JTF_DATE_TABLE
1107: , p5_a5 JTF_DATE_TABLE
1108: , p5_a6 JTF_NUMBER_TABLE
1109: , p5_a7 JTF_NUMBER_TABLE
1110: , p5_a8 JTF_NUMBER_TABLE
1111: , p5_a9 JTF_VARCHAR2_TABLE_100
1112: , p5_a10 JTF_VARCHAR2_TABLE_100
1113: , p5_a11 JTF_VARCHAR2_TABLE_100
1114: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 1131: , p5_a29 JTF_NUMBER_TABLE

1127: , p5_a25 JTF_VARCHAR2_TABLE_500
1128: , p5_a26 JTF_VARCHAR2_TABLE_500
1129: , p5_a27 JTF_VARCHAR2_TABLE_500
1130: , p5_a28 JTF_VARCHAR2_TABLE_500
1131: , p5_a29 JTF_NUMBER_TABLE
1132: , p5_a30 JTF_NUMBER_TABLE
1133: , p5_a31 JTF_DATE_TABLE
1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE

Line 1132: , p5_a30 JTF_NUMBER_TABLE

1128: , p5_a26 JTF_VARCHAR2_TABLE_500
1129: , p5_a27 JTF_VARCHAR2_TABLE_500
1130: , p5_a28 JTF_VARCHAR2_TABLE_500
1131: , p5_a29 JTF_NUMBER_TABLE
1132: , p5_a30 JTF_NUMBER_TABLE
1133: , p5_a31 JTF_DATE_TABLE
1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE
1136: , p5_a34 JTF_NUMBER_TABLE

Line 1134: , p5_a32 JTF_NUMBER_TABLE

1130: , p5_a28 JTF_VARCHAR2_TABLE_500
1131: , p5_a29 JTF_NUMBER_TABLE
1132: , p5_a30 JTF_NUMBER_TABLE
1133: , p5_a31 JTF_DATE_TABLE
1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE
1136: , p5_a34 JTF_NUMBER_TABLE
1137: , p5_a35 JTF_NUMBER_TABLE
1138: , p5_a36 JTF_NUMBER_TABLE

Line 1136: , p5_a34 JTF_NUMBER_TABLE

1132: , p5_a30 JTF_NUMBER_TABLE
1133: , p5_a31 JTF_DATE_TABLE
1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE
1136: , p5_a34 JTF_NUMBER_TABLE
1137: , p5_a35 JTF_NUMBER_TABLE
1138: , p5_a36 JTF_NUMBER_TABLE
1139: )
1140:

Line 1137: , p5_a35 JTF_NUMBER_TABLE

1133: , p5_a31 JTF_DATE_TABLE
1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE
1136: , p5_a34 JTF_NUMBER_TABLE
1137: , p5_a35 JTF_NUMBER_TABLE
1138: , p5_a36 JTF_NUMBER_TABLE
1139: )
1140:
1141: as

Line 1138: , p5_a36 JTF_NUMBER_TABLE

1134: , p5_a32 JTF_NUMBER_TABLE
1135: , p5_a33 JTF_DATE_TABLE
1136: , p5_a34 JTF_NUMBER_TABLE
1137: , p5_a35 JTF_NUMBER_TABLE
1138: , p5_a36 JTF_NUMBER_TABLE
1139: )
1140:
1141: as
1142: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

Line 1399: , p5_a0 JTF_NUMBER_TABLE

1395: , p_init_msg_list VARCHAR2
1396: , x_return_status out nocopy VARCHAR2
1397: , x_msg_count out nocopy NUMBER
1398: , x_msg_data out nocopy VARCHAR2
1399: , p5_a0 JTF_NUMBER_TABLE
1400: , p5_a1 JTF_NUMBER_TABLE
1401: , p5_a2 JTF_VARCHAR2_TABLE_200
1402: , p5_a3 JTF_VARCHAR2_TABLE_2000
1403: , p5_a4 JTF_DATE_TABLE

Line 1400: , p5_a1 JTF_NUMBER_TABLE

1396: , x_return_status out nocopy VARCHAR2
1397: , x_msg_count out nocopy NUMBER
1398: , x_msg_data out nocopy VARCHAR2
1399: , p5_a0 JTF_NUMBER_TABLE
1400: , p5_a1 JTF_NUMBER_TABLE
1401: , p5_a2 JTF_VARCHAR2_TABLE_200
1402: , p5_a3 JTF_VARCHAR2_TABLE_2000
1403: , p5_a4 JTF_DATE_TABLE
1404: , p5_a5 JTF_DATE_TABLE

Line 1405: , p5_a6 JTF_NUMBER_TABLE

1401: , p5_a2 JTF_VARCHAR2_TABLE_200
1402: , p5_a3 JTF_VARCHAR2_TABLE_2000
1403: , p5_a4 JTF_DATE_TABLE
1404: , p5_a5 JTF_DATE_TABLE
1405: , p5_a6 JTF_NUMBER_TABLE
1406: , p5_a7 JTF_NUMBER_TABLE
1407: , p5_a8 JTF_NUMBER_TABLE
1408: , p5_a9 JTF_VARCHAR2_TABLE_100
1409: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1406: , p5_a7 JTF_NUMBER_TABLE

1402: , p5_a3 JTF_VARCHAR2_TABLE_2000
1403: , p5_a4 JTF_DATE_TABLE
1404: , p5_a5 JTF_DATE_TABLE
1405: , p5_a6 JTF_NUMBER_TABLE
1406: , p5_a7 JTF_NUMBER_TABLE
1407: , p5_a8 JTF_NUMBER_TABLE
1408: , p5_a9 JTF_VARCHAR2_TABLE_100
1409: , p5_a10 JTF_VARCHAR2_TABLE_100
1410: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 1407: , p5_a8 JTF_NUMBER_TABLE

1403: , p5_a4 JTF_DATE_TABLE
1404: , p5_a5 JTF_DATE_TABLE
1405: , p5_a6 JTF_NUMBER_TABLE
1406: , p5_a7 JTF_NUMBER_TABLE
1407: , p5_a8 JTF_NUMBER_TABLE
1408: , p5_a9 JTF_VARCHAR2_TABLE_100
1409: , p5_a10 JTF_VARCHAR2_TABLE_100
1410: , p5_a11 JTF_VARCHAR2_TABLE_100
1411: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 1428: , p5_a29 JTF_NUMBER_TABLE

1424: , p5_a25 JTF_VARCHAR2_TABLE_500
1425: , p5_a26 JTF_VARCHAR2_TABLE_500
1426: , p5_a27 JTF_VARCHAR2_TABLE_500
1427: , p5_a28 JTF_VARCHAR2_TABLE_500
1428: , p5_a29 JTF_NUMBER_TABLE
1429: , p5_a30 JTF_NUMBER_TABLE
1430: , p5_a31 JTF_DATE_TABLE
1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE

Line 1429: , p5_a30 JTF_NUMBER_TABLE

1425: , p5_a26 JTF_VARCHAR2_TABLE_500
1426: , p5_a27 JTF_VARCHAR2_TABLE_500
1427: , p5_a28 JTF_VARCHAR2_TABLE_500
1428: , p5_a29 JTF_NUMBER_TABLE
1429: , p5_a30 JTF_NUMBER_TABLE
1430: , p5_a31 JTF_DATE_TABLE
1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE

Line 1431: , p5_a32 JTF_NUMBER_TABLE

1427: , p5_a28 JTF_VARCHAR2_TABLE_500
1428: , p5_a29 JTF_NUMBER_TABLE
1429: , p5_a30 JTF_NUMBER_TABLE
1430: , p5_a31 JTF_DATE_TABLE
1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE

Line 1433: , p5_a34 JTF_NUMBER_TABLE

1429: , p5_a30 JTF_NUMBER_TABLE
1430: , p5_a31 JTF_DATE_TABLE
1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE
1436: , p6_a0 out nocopy JTF_NUMBER_TABLE
1437: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1434: , p5_a35 JTF_NUMBER_TABLE

1430: , p5_a31 JTF_DATE_TABLE
1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE
1436: , p6_a0 out nocopy JTF_NUMBER_TABLE
1437: , p6_a1 out nocopy JTF_NUMBER_TABLE
1438: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 1435: , p5_a36 JTF_NUMBER_TABLE

1431: , p5_a32 JTF_NUMBER_TABLE
1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE
1436: , p6_a0 out nocopy JTF_NUMBER_TABLE
1437: , p6_a1 out nocopy JTF_NUMBER_TABLE
1438: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1439: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1436: , p6_a0 out nocopy JTF_NUMBER_TABLE

1432: , p5_a33 JTF_DATE_TABLE
1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE
1436: , p6_a0 out nocopy JTF_NUMBER_TABLE
1437: , p6_a1 out nocopy JTF_NUMBER_TABLE
1438: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1439: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1440: , p6_a4 out nocopy JTF_DATE_TABLE

Line 1437: , p6_a1 out nocopy JTF_NUMBER_TABLE

1433: , p5_a34 JTF_NUMBER_TABLE
1434: , p5_a35 JTF_NUMBER_TABLE
1435: , p5_a36 JTF_NUMBER_TABLE
1436: , p6_a0 out nocopy JTF_NUMBER_TABLE
1437: , p6_a1 out nocopy JTF_NUMBER_TABLE
1438: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1439: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1440: , p6_a4 out nocopy JTF_DATE_TABLE
1441: , p6_a5 out nocopy JTF_DATE_TABLE

Line 1442: , p6_a6 out nocopy JTF_NUMBER_TABLE

1438: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1439: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1440: , p6_a4 out nocopy JTF_DATE_TABLE
1441: , p6_a5 out nocopy JTF_DATE_TABLE
1442: , p6_a6 out nocopy JTF_NUMBER_TABLE
1443: , p6_a7 out nocopy JTF_NUMBER_TABLE
1444: , p6_a8 out nocopy JTF_NUMBER_TABLE
1445: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1446: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1443: , p6_a7 out nocopy JTF_NUMBER_TABLE

1439: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1440: , p6_a4 out nocopy JTF_DATE_TABLE
1441: , p6_a5 out nocopy JTF_DATE_TABLE
1442: , p6_a6 out nocopy JTF_NUMBER_TABLE
1443: , p6_a7 out nocopy JTF_NUMBER_TABLE
1444: , p6_a8 out nocopy JTF_NUMBER_TABLE
1445: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1446: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1447: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1444: , p6_a8 out nocopy JTF_NUMBER_TABLE

1440: , p6_a4 out nocopy JTF_DATE_TABLE
1441: , p6_a5 out nocopy JTF_DATE_TABLE
1442: , p6_a6 out nocopy JTF_NUMBER_TABLE
1443: , p6_a7 out nocopy JTF_NUMBER_TABLE
1444: , p6_a8 out nocopy JTF_NUMBER_TABLE
1445: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1446: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1447: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1448: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1465: , p6_a29 out nocopy JTF_NUMBER_TABLE

1461: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1462: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1463: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1464: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1465: , p6_a29 out nocopy JTF_NUMBER_TABLE
1466: , p6_a30 out nocopy JTF_NUMBER_TABLE
1467: , p6_a31 out nocopy JTF_DATE_TABLE
1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE

Line 1466: , p6_a30 out nocopy JTF_NUMBER_TABLE

1462: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1463: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1464: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1465: , p6_a29 out nocopy JTF_NUMBER_TABLE
1466: , p6_a30 out nocopy JTF_NUMBER_TABLE
1467: , p6_a31 out nocopy JTF_DATE_TABLE
1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE
1470: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 1468: , p6_a32 out nocopy JTF_NUMBER_TABLE

1464: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1465: , p6_a29 out nocopy JTF_NUMBER_TABLE
1466: , p6_a30 out nocopy JTF_NUMBER_TABLE
1467: , p6_a31 out nocopy JTF_DATE_TABLE
1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE
1470: , p6_a34 out nocopy JTF_NUMBER_TABLE
1471: , p6_a35 out nocopy JTF_NUMBER_TABLE
1472: , p6_a36 out nocopy JTF_NUMBER_TABLE

Line 1470: , p6_a34 out nocopy JTF_NUMBER_TABLE

1466: , p6_a30 out nocopy JTF_NUMBER_TABLE
1467: , p6_a31 out nocopy JTF_DATE_TABLE
1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE
1470: , p6_a34 out nocopy JTF_NUMBER_TABLE
1471: , p6_a35 out nocopy JTF_NUMBER_TABLE
1472: , p6_a36 out nocopy JTF_NUMBER_TABLE
1473: )
1474:

Line 1471: , p6_a35 out nocopy JTF_NUMBER_TABLE

1467: , p6_a31 out nocopy JTF_DATE_TABLE
1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE
1470: , p6_a34 out nocopy JTF_NUMBER_TABLE
1471: , p6_a35 out nocopy JTF_NUMBER_TABLE
1472: , p6_a36 out nocopy JTF_NUMBER_TABLE
1473: )
1474:
1475: as

Line 1472: , p6_a36 out nocopy JTF_NUMBER_TABLE

1468: , p6_a32 out nocopy JTF_NUMBER_TABLE
1469: , p6_a33 out nocopy JTF_DATE_TABLE
1470: , p6_a34 out nocopy JTF_NUMBER_TABLE
1471: , p6_a35 out nocopy JTF_NUMBER_TABLE
1472: , p6_a36 out nocopy JTF_NUMBER_TABLE
1473: )
1474:
1475: as
1476: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

Line 1697: , p5_a0 JTF_NUMBER_TABLE

1693: , p_init_msg_list VARCHAR2
1694: , x_return_status out nocopy VARCHAR2
1695: , x_msg_count out nocopy NUMBER
1696: , x_msg_data out nocopy VARCHAR2
1697: , p5_a0 JTF_NUMBER_TABLE
1698: , p5_a1 JTF_NUMBER_TABLE
1699: , p5_a2 JTF_VARCHAR2_TABLE_200
1700: , p5_a3 JTF_VARCHAR2_TABLE_2000
1701: , p5_a4 JTF_DATE_TABLE

Line 1698: , p5_a1 JTF_NUMBER_TABLE

1694: , x_return_status out nocopy VARCHAR2
1695: , x_msg_count out nocopy NUMBER
1696: , x_msg_data out nocopy VARCHAR2
1697: , p5_a0 JTF_NUMBER_TABLE
1698: , p5_a1 JTF_NUMBER_TABLE
1699: , p5_a2 JTF_VARCHAR2_TABLE_200
1700: , p5_a3 JTF_VARCHAR2_TABLE_2000
1701: , p5_a4 JTF_DATE_TABLE
1702: , p5_a5 JTF_DATE_TABLE

Line 1703: , p5_a6 JTF_NUMBER_TABLE

1699: , p5_a2 JTF_VARCHAR2_TABLE_200
1700: , p5_a3 JTF_VARCHAR2_TABLE_2000
1701: , p5_a4 JTF_DATE_TABLE
1702: , p5_a5 JTF_DATE_TABLE
1703: , p5_a6 JTF_NUMBER_TABLE
1704: , p5_a7 JTF_NUMBER_TABLE
1705: , p5_a8 JTF_NUMBER_TABLE
1706: , p5_a9 JTF_VARCHAR2_TABLE_100
1707: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1704: , p5_a7 JTF_NUMBER_TABLE

1700: , p5_a3 JTF_VARCHAR2_TABLE_2000
1701: , p5_a4 JTF_DATE_TABLE
1702: , p5_a5 JTF_DATE_TABLE
1703: , p5_a6 JTF_NUMBER_TABLE
1704: , p5_a7 JTF_NUMBER_TABLE
1705: , p5_a8 JTF_NUMBER_TABLE
1706: , p5_a9 JTF_VARCHAR2_TABLE_100
1707: , p5_a10 JTF_VARCHAR2_TABLE_100
1708: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 1705: , p5_a8 JTF_NUMBER_TABLE

1701: , p5_a4 JTF_DATE_TABLE
1702: , p5_a5 JTF_DATE_TABLE
1703: , p5_a6 JTF_NUMBER_TABLE
1704: , p5_a7 JTF_NUMBER_TABLE
1705: , p5_a8 JTF_NUMBER_TABLE
1706: , p5_a9 JTF_VARCHAR2_TABLE_100
1707: , p5_a10 JTF_VARCHAR2_TABLE_100
1708: , p5_a11 JTF_VARCHAR2_TABLE_100
1709: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 1726: , p5_a29 JTF_NUMBER_TABLE

1722: , p5_a25 JTF_VARCHAR2_TABLE_500
1723: , p5_a26 JTF_VARCHAR2_TABLE_500
1724: , p5_a27 JTF_VARCHAR2_TABLE_500
1725: , p5_a28 JTF_VARCHAR2_TABLE_500
1726: , p5_a29 JTF_NUMBER_TABLE
1727: , p5_a30 JTF_NUMBER_TABLE
1728: , p5_a31 JTF_DATE_TABLE
1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE

Line 1727: , p5_a30 JTF_NUMBER_TABLE

1723: , p5_a26 JTF_VARCHAR2_TABLE_500
1724: , p5_a27 JTF_VARCHAR2_TABLE_500
1725: , p5_a28 JTF_VARCHAR2_TABLE_500
1726: , p5_a29 JTF_NUMBER_TABLE
1727: , p5_a30 JTF_NUMBER_TABLE
1728: , p5_a31 JTF_DATE_TABLE
1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE
1731: , p5_a34 JTF_NUMBER_TABLE

Line 1729: , p5_a32 JTF_NUMBER_TABLE

1725: , p5_a28 JTF_VARCHAR2_TABLE_500
1726: , p5_a29 JTF_NUMBER_TABLE
1727: , p5_a30 JTF_NUMBER_TABLE
1728: , p5_a31 JTF_DATE_TABLE
1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE
1731: , p5_a34 JTF_NUMBER_TABLE
1732: , p5_a35 JTF_NUMBER_TABLE
1733: , p5_a36 JTF_NUMBER_TABLE

Line 1731: , p5_a34 JTF_NUMBER_TABLE

1727: , p5_a30 JTF_NUMBER_TABLE
1728: , p5_a31 JTF_DATE_TABLE
1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE
1731: , p5_a34 JTF_NUMBER_TABLE
1732: , p5_a35 JTF_NUMBER_TABLE
1733: , p5_a36 JTF_NUMBER_TABLE
1734: )
1735:

Line 1732: , p5_a35 JTF_NUMBER_TABLE

1728: , p5_a31 JTF_DATE_TABLE
1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE
1731: , p5_a34 JTF_NUMBER_TABLE
1732: , p5_a35 JTF_NUMBER_TABLE
1733: , p5_a36 JTF_NUMBER_TABLE
1734: )
1735:
1736: as

Line 1733: , p5_a36 JTF_NUMBER_TABLE

1729: , p5_a32 JTF_NUMBER_TABLE
1730: , p5_a33 JTF_DATE_TABLE
1731: , p5_a34 JTF_NUMBER_TABLE
1732: , p5_a35 JTF_NUMBER_TABLE
1733: , p5_a36 JTF_NUMBER_TABLE
1734: )
1735:
1736: as
1737: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;

Line 1916: , p5_a0 JTF_NUMBER_TABLE

1912: , p_init_msg_list VARCHAR2
1913: , x_return_status out nocopy VARCHAR2
1914: , x_msg_count out nocopy NUMBER
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 JTF_NUMBER_TABLE
1917: , p5_a1 JTF_NUMBER_TABLE
1918: , p5_a2 JTF_VARCHAR2_TABLE_200
1919: , p5_a3 JTF_VARCHAR2_TABLE_2000
1920: , p5_a4 JTF_DATE_TABLE

Line 1917: , p5_a1 JTF_NUMBER_TABLE

1913: , x_return_status out nocopy VARCHAR2
1914: , x_msg_count out nocopy NUMBER
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 JTF_NUMBER_TABLE
1917: , p5_a1 JTF_NUMBER_TABLE
1918: , p5_a2 JTF_VARCHAR2_TABLE_200
1919: , p5_a3 JTF_VARCHAR2_TABLE_2000
1920: , p5_a4 JTF_DATE_TABLE
1921: , p5_a5 JTF_DATE_TABLE

Line 1922: , p5_a6 JTF_NUMBER_TABLE

1918: , p5_a2 JTF_VARCHAR2_TABLE_200
1919: , p5_a3 JTF_VARCHAR2_TABLE_2000
1920: , p5_a4 JTF_DATE_TABLE
1921: , p5_a5 JTF_DATE_TABLE
1922: , p5_a6 JTF_NUMBER_TABLE
1923: , p5_a7 JTF_NUMBER_TABLE
1924: , p5_a8 JTF_NUMBER_TABLE
1925: , p5_a9 JTF_VARCHAR2_TABLE_100
1926: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1923: , p5_a7 JTF_NUMBER_TABLE

1919: , p5_a3 JTF_VARCHAR2_TABLE_2000
1920: , p5_a4 JTF_DATE_TABLE
1921: , p5_a5 JTF_DATE_TABLE
1922: , p5_a6 JTF_NUMBER_TABLE
1923: , p5_a7 JTF_NUMBER_TABLE
1924: , p5_a8 JTF_NUMBER_TABLE
1925: , p5_a9 JTF_VARCHAR2_TABLE_100
1926: , p5_a10 JTF_VARCHAR2_TABLE_100
1927: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 1924: , p5_a8 JTF_NUMBER_TABLE

1920: , p5_a4 JTF_DATE_TABLE
1921: , p5_a5 JTF_DATE_TABLE
1922: , p5_a6 JTF_NUMBER_TABLE
1923: , p5_a7 JTF_NUMBER_TABLE
1924: , p5_a8 JTF_NUMBER_TABLE
1925: , p5_a9 JTF_VARCHAR2_TABLE_100
1926: , p5_a10 JTF_VARCHAR2_TABLE_100
1927: , p5_a11 JTF_VARCHAR2_TABLE_100
1928: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 1945: , p5_a29 JTF_NUMBER_TABLE

1941: , p5_a25 JTF_VARCHAR2_TABLE_500
1942: , p5_a26 JTF_VARCHAR2_TABLE_500
1943: , p5_a27 JTF_VARCHAR2_TABLE_500
1944: , p5_a28 JTF_VARCHAR2_TABLE_500
1945: , p5_a29 JTF_NUMBER_TABLE
1946: , p5_a30 JTF_NUMBER_TABLE
1947: , p5_a31 JTF_DATE_TABLE
1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE

Line 1946: , p5_a30 JTF_NUMBER_TABLE

1942: , p5_a26 JTF_VARCHAR2_TABLE_500
1943: , p5_a27 JTF_VARCHAR2_TABLE_500
1944: , p5_a28 JTF_VARCHAR2_TABLE_500
1945: , p5_a29 JTF_NUMBER_TABLE
1946: , p5_a30 JTF_NUMBER_TABLE
1947: , p5_a31 JTF_DATE_TABLE
1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE
1950: , p5_a34 JTF_NUMBER_TABLE

Line 1948: , p5_a32 JTF_NUMBER_TABLE

1944: , p5_a28 JTF_VARCHAR2_TABLE_500
1945: , p5_a29 JTF_NUMBER_TABLE
1946: , p5_a30 JTF_NUMBER_TABLE
1947: , p5_a31 JTF_DATE_TABLE
1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE
1950: , p5_a34 JTF_NUMBER_TABLE
1951: , p5_a35 JTF_NUMBER_TABLE
1952: , p5_a36 JTF_NUMBER_TABLE

Line 1950: , p5_a34 JTF_NUMBER_TABLE

1946: , p5_a30 JTF_NUMBER_TABLE
1947: , p5_a31 JTF_DATE_TABLE
1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE
1950: , p5_a34 JTF_NUMBER_TABLE
1951: , p5_a35 JTF_NUMBER_TABLE
1952: , p5_a36 JTF_NUMBER_TABLE
1953: )
1954:

Line 1951: , p5_a35 JTF_NUMBER_TABLE

1947: , p5_a31 JTF_DATE_TABLE
1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE
1950: , p5_a34 JTF_NUMBER_TABLE
1951: , p5_a35 JTF_NUMBER_TABLE
1952: , p5_a36 JTF_NUMBER_TABLE
1953: )
1954:
1955: as

Line 1952: , p5_a36 JTF_NUMBER_TABLE

1948: , p5_a32 JTF_NUMBER_TABLE
1949: , p5_a33 JTF_DATE_TABLE
1950: , p5_a34 JTF_NUMBER_TABLE
1951: , p5_a35 JTF_NUMBER_TABLE
1952: , p5_a36 JTF_NUMBER_TABLE
1953: )
1954:
1955: as
1956: ddp_catv_tbl okl_cat_pvt.catv_tbl_type;