DBA Data[Home] [Help]

APPS.OKL_SIY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_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_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 31: , a9 JTF_NUMBER_TABLE

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

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_500

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_DATE_TABLE
55: , a33 JTF_NUMBER_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_DATE_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as

Line 55: , a33 JTF_NUMBER_TABLE

51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_DATE_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if a0 is not null and a0.count > 0 then

Line 107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a1 out nocopy JTF_NUMBER_TABLE

104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , a3 out nocopy JTF_NUMBER_TABLE

106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_VARCHAR2_TABLE_100
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , a9 out nocopy JTF_NUMBER_TABLE

112: , a5 out nocopy JTF_VARCHAR2_TABLE_100
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_VARCHAR2_TABLE_100
119: , a12 out nocopy JTF_VARCHAR2_TABLE_100
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a10 out nocopy JTF_NUMBER_TABLE

113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_VARCHAR2_TABLE_100
119: , a12 out nocopy JTF_VARCHAR2_TABLE_100
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
121: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 136: , a29 out nocopy JTF_NUMBER_TABLE

132: , a25 out nocopy JTF_VARCHAR2_TABLE_500
133: , a26 out nocopy JTF_VARCHAR2_TABLE_500
134: , a27 out nocopy JTF_VARCHAR2_TABLE_500
135: , a28 out nocopy JTF_VARCHAR2_TABLE_500
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE

Line 137: , a30 out nocopy JTF_NUMBER_TABLE

133: , a26 out nocopy JTF_VARCHAR2_TABLE_500
134: , a27 out nocopy JTF_VARCHAR2_TABLE_500
135: , a28 out nocopy JTF_VARCHAR2_TABLE_500
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as

Line 140: , a33 out nocopy JTF_NUMBER_TABLE

136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then

Line 145: a0 := JTF_NUMBER_TABLE();

141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();

Line 146: a1 := JTF_NUMBER_TABLE();

142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_VARCHAR2_TABLE_100();

Line 148: a3 := JTF_NUMBER_TABLE();

144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();

Line 154: a9 := JTF_NUMBER_TABLE();

150: a5 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();

Line 155: a10 := JTF_NUMBER_TABLE();

151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_500();

Line 174: a29 := JTF_NUMBER_TABLE();

170: a25 := JTF_VARCHAR2_TABLE_500();
171: a26 := JTF_VARCHAR2_TABLE_500();
172: a27 := JTF_VARCHAR2_TABLE_500();
173: a28 := JTF_VARCHAR2_TABLE_500();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();

Line 175: a30 := JTF_NUMBER_TABLE();

171: a26 := JTF_VARCHAR2_TABLE_500();
172: a27 := JTF_VARCHAR2_TABLE_500();
173: a28 := JTF_VARCHAR2_TABLE_500();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else

Line 178: a33 := JTF_NUMBER_TABLE();

174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();

Line 180: a0 := JTF_NUMBER_TABLE();

176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();

Line 181: a1 := JTF_NUMBER_TABLE();

177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();

Line 183: a3 := JTF_NUMBER_TABLE();

179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();

Line 189: a9 := JTF_NUMBER_TABLE();

185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();
188: a8 := JTF_VARCHAR2_TABLE_100();
189: a9 := JTF_NUMBER_TABLE();
190: a10 := JTF_NUMBER_TABLE();
191: a11 := JTF_VARCHAR2_TABLE_100();
192: a12 := JTF_VARCHAR2_TABLE_100();
193: a13 := JTF_VARCHAR2_TABLE_100();

Line 190: a10 := JTF_NUMBER_TABLE();

186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();
188: a8 := JTF_VARCHAR2_TABLE_100();
189: a9 := JTF_NUMBER_TABLE();
190: a10 := JTF_NUMBER_TABLE();
191: a11 := JTF_VARCHAR2_TABLE_100();
192: a12 := JTF_VARCHAR2_TABLE_100();
193: a13 := JTF_VARCHAR2_TABLE_100();
194: a14 := JTF_VARCHAR2_TABLE_500();

Line 209: a29 := JTF_NUMBER_TABLE();

205: a25 := JTF_VARCHAR2_TABLE_500();
206: a26 := JTF_VARCHAR2_TABLE_500();
207: a27 := JTF_VARCHAR2_TABLE_500();
208: a28 := JTF_VARCHAR2_TABLE_500();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();

Line 210: a30 := JTF_NUMBER_TABLE();

206: a26 := JTF_VARCHAR2_TABLE_500();
207: a27 := JTF_VARCHAR2_TABLE_500();
208: a28 := JTF_VARCHAR2_TABLE_500();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then

Line 213: a33 := JTF_NUMBER_TABLE();

209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then
215: a0.extend(t.count);
216: a1.extend(t.count);
217: a2.extend(t.count);

Line 296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE

292: end if;
293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100

Line 297: , a1 JTF_NUMBER_TABLE

293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100
301: , a5 JTF_VARCHAR2_TABLE_100

Line 299: , a3 JTF_NUMBER_TABLE

295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100
301: , a5 JTF_VARCHAR2_TABLE_100
302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100

Line 305: , a9 JTF_NUMBER_TABLE

301: , a5 JTF_VARCHAR2_TABLE_100
302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100
304: , a8 JTF_VARCHAR2_TABLE_100
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_NUMBER_TABLE
307: , a11 JTF_VARCHAR2_TABLE_100
308: , a12 JTF_VARCHAR2_TABLE_100
309: , a13 JTF_VARCHAR2_TABLE_100

Line 306: , a10 JTF_NUMBER_TABLE

302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100
304: , a8 JTF_VARCHAR2_TABLE_100
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_NUMBER_TABLE
307: , a11 JTF_VARCHAR2_TABLE_100
308: , a12 JTF_VARCHAR2_TABLE_100
309: , a13 JTF_VARCHAR2_TABLE_100
310: , a14 JTF_VARCHAR2_TABLE_500

Line 325: , a29 JTF_NUMBER_TABLE

321: , a25 JTF_VARCHAR2_TABLE_500
322: , a26 JTF_VARCHAR2_TABLE_500
323: , a27 JTF_VARCHAR2_TABLE_500
324: , a28 JTF_VARCHAR2_TABLE_500
325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE

Line 326: , a30 JTF_NUMBER_TABLE

322: , a26 JTF_VARCHAR2_TABLE_500
323: , a27 JTF_VARCHAR2_TABLE_500
324: , a28 JTF_VARCHAR2_TABLE_500
325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE
330: ) as

Line 329: , a33 JTF_NUMBER_TABLE

325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE
330: ) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if a0 is not null and a0.count > 0 then

Line 381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

377: end loop;
378: end if;
379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 382: , a1 out nocopy JTF_NUMBER_TABLE

378: end if;
379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100
386: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 384: , a3 out nocopy JTF_NUMBER_TABLE

380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100
386: , a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 390: , a9 out nocopy JTF_NUMBER_TABLE

386: , a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100
389: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a9 out nocopy JTF_NUMBER_TABLE
391: , a10 out nocopy JTF_NUMBER_TABLE
392: , a11 out nocopy JTF_VARCHAR2_TABLE_100
393: , a12 out nocopy JTF_VARCHAR2_TABLE_100
394: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 391: , a10 out nocopy JTF_NUMBER_TABLE

387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100
389: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a9 out nocopy JTF_NUMBER_TABLE
391: , a10 out nocopy JTF_NUMBER_TABLE
392: , a11 out nocopy JTF_VARCHAR2_TABLE_100
393: , a12 out nocopy JTF_VARCHAR2_TABLE_100
394: , a13 out nocopy JTF_VARCHAR2_TABLE_100
395: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 410: , a29 out nocopy JTF_NUMBER_TABLE

406: , a25 out nocopy JTF_VARCHAR2_TABLE_500
407: , a26 out nocopy JTF_VARCHAR2_TABLE_500
408: , a27 out nocopy JTF_VARCHAR2_TABLE_500
409: , a28 out nocopy JTF_VARCHAR2_TABLE_500
410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE

Line 411: , a30 out nocopy JTF_NUMBER_TABLE

407: , a26 out nocopy JTF_VARCHAR2_TABLE_500
408: , a27 out nocopy JTF_VARCHAR2_TABLE_500
409: , a28 out nocopy JTF_VARCHAR2_TABLE_500
410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE
415: ) as

Line 414: , a33 out nocopy JTF_NUMBER_TABLE

410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE
415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then

Line 419: a0 := JTF_NUMBER_TABLE();

415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();

Line 420: a1 := JTF_NUMBER_TABLE();

416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();

Line 422: a3 := JTF_NUMBER_TABLE();

418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();

Line 428: a9 := JTF_NUMBER_TABLE();

424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_VARCHAR2_TABLE_100();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_VARCHAR2_TABLE_100();

Line 429: a10 := JTF_NUMBER_TABLE();

425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_VARCHAR2_TABLE_100();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_VARCHAR2_TABLE_100();
433: a14 := JTF_VARCHAR2_TABLE_500();

Line 448: a29 := JTF_NUMBER_TABLE();

444: a25 := JTF_VARCHAR2_TABLE_500();
445: a26 := JTF_VARCHAR2_TABLE_500();
446: a27 := JTF_VARCHAR2_TABLE_500();
447: a28 := JTF_VARCHAR2_TABLE_500();
448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();

Line 449: a30 := JTF_NUMBER_TABLE();

445: a26 := JTF_VARCHAR2_TABLE_500();
446: a27 := JTF_VARCHAR2_TABLE_500();
447: a28 := JTF_VARCHAR2_TABLE_500();
448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else

Line 452: a33 := JTF_NUMBER_TABLE();

448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();

Line 454: a0 := JTF_NUMBER_TABLE();

450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();

Line 455: a1 := JTF_NUMBER_TABLE();

451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();
459: a5 := JTF_VARCHAR2_TABLE_100();

Line 457: a3 := JTF_NUMBER_TABLE();

453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();
459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();

Line 463: a9 := JTF_NUMBER_TABLE();

459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();
462: a8 := JTF_VARCHAR2_TABLE_100();
463: a9 := JTF_NUMBER_TABLE();
464: a10 := JTF_NUMBER_TABLE();
465: a11 := JTF_VARCHAR2_TABLE_100();
466: a12 := JTF_VARCHAR2_TABLE_100();
467: a13 := JTF_VARCHAR2_TABLE_100();

Line 464: a10 := JTF_NUMBER_TABLE();

460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();
462: a8 := JTF_VARCHAR2_TABLE_100();
463: a9 := JTF_NUMBER_TABLE();
464: a10 := JTF_NUMBER_TABLE();
465: a11 := JTF_VARCHAR2_TABLE_100();
466: a12 := JTF_VARCHAR2_TABLE_100();
467: a13 := JTF_VARCHAR2_TABLE_100();
468: a14 := JTF_VARCHAR2_TABLE_500();

Line 483: a29 := JTF_NUMBER_TABLE();

479: a25 := JTF_VARCHAR2_TABLE_500();
480: a26 := JTF_VARCHAR2_TABLE_500();
481: a27 := JTF_VARCHAR2_TABLE_500();
482: a28 := JTF_VARCHAR2_TABLE_500();
483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();

Line 484: a30 := JTF_NUMBER_TABLE();

480: a26 := JTF_VARCHAR2_TABLE_500();
481: a27 := JTF_VARCHAR2_TABLE_500();
482: a28 := JTF_VARCHAR2_TABLE_500();
483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();
488: if t.count > 0 then

Line 487: a33 := JTF_NUMBER_TABLE();

483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();
488: if t.count > 0 then
489: a0.extend(t.count);
490: a1.extend(t.count);
491: a2.extend(t.count);

Line 750: , p5_a0 JTF_NUMBER_TABLE

746: , p_init_msg_list VARCHAR2
747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 751: , p5_a1 JTF_NUMBER_TABLE

747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100
755: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 753: , p5_a3 JTF_NUMBER_TABLE

749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 759: , p5_a9 JTF_NUMBER_TABLE

755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100
758: , p5_a8 JTF_VARCHAR2_TABLE_100
759: , p5_a9 JTF_NUMBER_TABLE
760: , p5_a10 JTF_NUMBER_TABLE
761: , p5_a11 JTF_VARCHAR2_TABLE_100
762: , p5_a12 JTF_VARCHAR2_TABLE_100
763: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 760: , p5_a10 JTF_NUMBER_TABLE

756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100
758: , p5_a8 JTF_VARCHAR2_TABLE_100
759: , p5_a9 JTF_NUMBER_TABLE
760: , p5_a10 JTF_NUMBER_TABLE
761: , p5_a11 JTF_VARCHAR2_TABLE_100
762: , p5_a12 JTF_VARCHAR2_TABLE_100
763: , p5_a13 JTF_VARCHAR2_TABLE_100
764: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 779: , p5_a29 JTF_NUMBER_TABLE

775: , p5_a25 JTF_VARCHAR2_TABLE_500
776: , p5_a26 JTF_VARCHAR2_TABLE_500
777: , p5_a27 JTF_VARCHAR2_TABLE_500
778: , p5_a28 JTF_VARCHAR2_TABLE_500
779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE

Line 780: , p5_a30 JTF_NUMBER_TABLE

776: , p5_a26 JTF_VARCHAR2_TABLE_500
777: , p5_a27 JTF_VARCHAR2_TABLE_500
778: , p5_a28 JTF_VARCHAR2_TABLE_500
779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 783: , p5_a33 JTF_NUMBER_TABLE

779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 784: , p6_a0 out nocopy JTF_NUMBER_TABLE

780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 785: , p6_a1 out nocopy JTF_NUMBER_TABLE

781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 787: , p6_a3 out nocopy JTF_NUMBER_TABLE

783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 793: , p6_a9 out nocopy JTF_NUMBER_TABLE

789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_NUMBER_TABLE
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 794: , p6_a10 out nocopy JTF_NUMBER_TABLE

790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_NUMBER_TABLE
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
798: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 813: , p6_a29 out nocopy JTF_NUMBER_TABLE

809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
812: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 814: , p6_a30 out nocopy JTF_NUMBER_TABLE

810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
812: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE
818: )

Line 817: , p6_a33 out nocopy JTF_NUMBER_TABLE

813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE
818: )
819:
820: as
821: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;

Line 1030: , p5_a0 JTF_NUMBER_TABLE

1026: , p_init_msg_list VARCHAR2
1027: , x_return_status out nocopy VARCHAR2
1028: , x_msg_count out nocopy NUMBER
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1031: , p5_a1 JTF_NUMBER_TABLE

1027: , x_return_status out nocopy VARCHAR2
1028: , x_msg_count out nocopy NUMBER
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100
1035: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1033: , p5_a3 JTF_NUMBER_TABLE

1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100
1035: , p5_a5 JTF_VARCHAR2_TABLE_100
1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1039: , p5_a9 JTF_NUMBER_TABLE

1035: , p5_a5 JTF_VARCHAR2_TABLE_100
1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100
1038: , p5_a8 JTF_VARCHAR2_TABLE_100
1039: , p5_a9 JTF_NUMBER_TABLE
1040: , p5_a10 JTF_NUMBER_TABLE
1041: , p5_a11 JTF_VARCHAR2_TABLE_100
1042: , p5_a12 JTF_VARCHAR2_TABLE_100
1043: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1040: , p5_a10 JTF_NUMBER_TABLE

1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100
1038: , p5_a8 JTF_VARCHAR2_TABLE_100
1039: , p5_a9 JTF_NUMBER_TABLE
1040: , p5_a10 JTF_NUMBER_TABLE
1041: , p5_a11 JTF_VARCHAR2_TABLE_100
1042: , p5_a12 JTF_VARCHAR2_TABLE_100
1043: , p5_a13 JTF_VARCHAR2_TABLE_100
1044: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 1059: , p5_a29 JTF_NUMBER_TABLE

1055: , p5_a25 JTF_VARCHAR2_TABLE_500
1056: , p5_a26 JTF_VARCHAR2_TABLE_500
1057: , p5_a27 JTF_VARCHAR2_TABLE_500
1058: , p5_a28 JTF_VARCHAR2_TABLE_500
1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE

Line 1060: , p5_a30 JTF_NUMBER_TABLE

1056: , p5_a26 JTF_VARCHAR2_TABLE_500
1057: , p5_a27 JTF_VARCHAR2_TABLE_500
1058: , p5_a28 JTF_VARCHAR2_TABLE_500
1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE
1064: )

Line 1063: , p5_a33 JTF_NUMBER_TABLE

1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE
1064: )
1065:
1066: as
1067: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;

Line 1309: , p5_a0 JTF_NUMBER_TABLE

1305: , p_init_msg_list VARCHAR2
1306: , x_return_status out nocopy VARCHAR2
1307: , x_msg_count out nocopy NUMBER
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1310: , p5_a1 JTF_NUMBER_TABLE

1306: , x_return_status out nocopy VARCHAR2
1307: , x_msg_count out nocopy NUMBER
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100
1314: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1312: , p5_a3 JTF_NUMBER_TABLE

1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100
1314: , p5_a5 JTF_VARCHAR2_TABLE_100
1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1318: , p5_a9 JTF_NUMBER_TABLE

1314: , p5_a5 JTF_VARCHAR2_TABLE_100
1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100
1317: , p5_a8 JTF_VARCHAR2_TABLE_100
1318: , p5_a9 JTF_NUMBER_TABLE
1319: , p5_a10 JTF_NUMBER_TABLE
1320: , p5_a11 JTF_VARCHAR2_TABLE_100
1321: , p5_a12 JTF_VARCHAR2_TABLE_100
1322: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1319: , p5_a10 JTF_NUMBER_TABLE

1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100
1317: , p5_a8 JTF_VARCHAR2_TABLE_100
1318: , p5_a9 JTF_NUMBER_TABLE
1319: , p5_a10 JTF_NUMBER_TABLE
1320: , p5_a11 JTF_VARCHAR2_TABLE_100
1321: , p5_a12 JTF_VARCHAR2_TABLE_100
1322: , p5_a13 JTF_VARCHAR2_TABLE_100
1323: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 1338: , p5_a29 JTF_NUMBER_TABLE

1334: , p5_a25 JTF_VARCHAR2_TABLE_500
1335: , p5_a26 JTF_VARCHAR2_TABLE_500
1336: , p5_a27 JTF_VARCHAR2_TABLE_500
1337: , p5_a28 JTF_VARCHAR2_TABLE_500
1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE

Line 1339: , p5_a30 JTF_NUMBER_TABLE

1335: , p5_a26 JTF_VARCHAR2_TABLE_500
1336: , p5_a27 JTF_VARCHAR2_TABLE_500
1337: , p5_a28 JTF_VARCHAR2_TABLE_500
1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1342: , p5_a33 JTF_NUMBER_TABLE

1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1343: , p6_a0 out nocopy JTF_NUMBER_TABLE

1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1344: , p6_a1 out nocopy JTF_NUMBER_TABLE

1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1346: , p6_a3 out nocopy JTF_NUMBER_TABLE

1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1352: , p6_a9 out nocopy JTF_NUMBER_TABLE

1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a9 out nocopy JTF_NUMBER_TABLE
1353: , p6_a10 out nocopy JTF_NUMBER_TABLE
1354: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1355: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1353: , p6_a10 out nocopy JTF_NUMBER_TABLE

1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a9 out nocopy JTF_NUMBER_TABLE
1353: , p6_a10 out nocopy JTF_NUMBER_TABLE
1354: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1355: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1357: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 1372: , p6_a29 out nocopy JTF_NUMBER_TABLE

1368: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1369: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1370: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1371: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 1373: , p6_a30 out nocopy JTF_NUMBER_TABLE

1369: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1370: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1371: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1377: )

Line 1376: , p6_a33 out nocopy JTF_NUMBER_TABLE

1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1377: )
1378:
1379: as
1380: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;

Line 1589: , p5_a0 JTF_NUMBER_TABLE

1585: , p_init_msg_list VARCHAR2
1586: , x_return_status out nocopy VARCHAR2
1587: , x_msg_count out nocopy NUMBER
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1590: , p5_a1 JTF_NUMBER_TABLE

1586: , x_return_status out nocopy VARCHAR2
1587: , x_msg_count out nocopy NUMBER
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100
1594: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1592: , p5_a3 JTF_NUMBER_TABLE

1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100
1594: , p5_a5 JTF_VARCHAR2_TABLE_100
1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1598: , p5_a9 JTF_NUMBER_TABLE

1594: , p5_a5 JTF_VARCHAR2_TABLE_100
1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100
1597: , p5_a8 JTF_VARCHAR2_TABLE_100
1598: , p5_a9 JTF_NUMBER_TABLE
1599: , p5_a10 JTF_NUMBER_TABLE
1600: , p5_a11 JTF_VARCHAR2_TABLE_100
1601: , p5_a12 JTF_VARCHAR2_TABLE_100
1602: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1599: , p5_a10 JTF_NUMBER_TABLE

1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100
1597: , p5_a8 JTF_VARCHAR2_TABLE_100
1598: , p5_a9 JTF_NUMBER_TABLE
1599: , p5_a10 JTF_NUMBER_TABLE
1600: , p5_a11 JTF_VARCHAR2_TABLE_100
1601: , p5_a12 JTF_VARCHAR2_TABLE_100
1602: , p5_a13 JTF_VARCHAR2_TABLE_100
1603: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 1618: , p5_a29 JTF_NUMBER_TABLE

1614: , p5_a25 JTF_VARCHAR2_TABLE_500
1615: , p5_a26 JTF_VARCHAR2_TABLE_500
1616: , p5_a27 JTF_VARCHAR2_TABLE_500
1617: , p5_a28 JTF_VARCHAR2_TABLE_500
1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE

Line 1619: , p5_a30 JTF_NUMBER_TABLE

1615: , p5_a26 JTF_VARCHAR2_TABLE_500
1616: , p5_a27 JTF_VARCHAR2_TABLE_500
1617: , p5_a28 JTF_VARCHAR2_TABLE_500
1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE
1623: )

Line 1622: , p5_a33 JTF_NUMBER_TABLE

1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE
1623: )
1624:
1625: as
1626: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;

Line 1796: , p5_a0 JTF_NUMBER_TABLE

1792: , p_init_msg_list VARCHAR2
1793: , x_return_status out nocopy VARCHAR2
1794: , x_msg_count out nocopy NUMBER
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1797: , p5_a1 JTF_NUMBER_TABLE

1793: , x_return_status out nocopy VARCHAR2
1794: , x_msg_count out nocopy NUMBER
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100
1801: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1799: , p5_a3 JTF_NUMBER_TABLE

1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100
1801: , p5_a5 JTF_VARCHAR2_TABLE_100
1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1805: , p5_a9 JTF_NUMBER_TABLE

1801: , p5_a5 JTF_VARCHAR2_TABLE_100
1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100
1804: , p5_a8 JTF_VARCHAR2_TABLE_100
1805: , p5_a9 JTF_NUMBER_TABLE
1806: , p5_a10 JTF_NUMBER_TABLE
1807: , p5_a11 JTF_VARCHAR2_TABLE_100
1808: , p5_a12 JTF_VARCHAR2_TABLE_100
1809: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1806: , p5_a10 JTF_NUMBER_TABLE

1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100
1804: , p5_a8 JTF_VARCHAR2_TABLE_100
1805: , p5_a9 JTF_NUMBER_TABLE
1806: , p5_a10 JTF_NUMBER_TABLE
1807: , p5_a11 JTF_VARCHAR2_TABLE_100
1808: , p5_a12 JTF_VARCHAR2_TABLE_100
1809: , p5_a13 JTF_VARCHAR2_TABLE_100
1810: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 1825: , p5_a29 JTF_NUMBER_TABLE

1821: , p5_a25 JTF_VARCHAR2_TABLE_500
1822: , p5_a26 JTF_VARCHAR2_TABLE_500
1823: , p5_a27 JTF_VARCHAR2_TABLE_500
1824: , p5_a28 JTF_VARCHAR2_TABLE_500
1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE

Line 1826: , p5_a30 JTF_NUMBER_TABLE

1822: , p5_a26 JTF_VARCHAR2_TABLE_500
1823: , p5_a27 JTF_VARCHAR2_TABLE_500
1824: , p5_a28 JTF_VARCHAR2_TABLE_500
1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE
1830: )

Line 1829: , p5_a33 JTF_NUMBER_TABLE

1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE
1830: )
1831:
1832: as
1833: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;