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_ien_pvt.ien_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ien_pvt.ien_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ien_pvt.ien_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if a0 is not null and a0.count > 0 then
91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_ien_pvt.ien_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_NUMBER_TABLE
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_ien_pvt.ien_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , a6 out nocopy JTF_DATE_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
95: procedure rosetta_table_copy_out_p2(t okl_ien_pvt.ien_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , a6 out nocopy JTF_DATE_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , a8 out nocopy JTF_VARCHAR2_TABLE_500
114: , a19 out nocopy JTF_VARCHAR2_TABLE_500
115: , a20 out nocopy JTF_VARCHAR2_TABLE_500
116: , a21 out nocopy JTF_VARCHAR2_TABLE_500
117: , a22 out nocopy JTF_VARCHAR2_TABLE_500
118: , a23 out nocopy JTF_NUMBER_TABLE
119: , a24 out nocopy JTF_DATE_TABLE
120: , a25 out nocopy JTF_NUMBER_TABLE
121: , a26 out nocopy JTF_DATE_TABLE
122: , a27 out nocopy JTF_NUMBER_TABLE
116: , a21 out nocopy JTF_VARCHAR2_TABLE_500
117: , a22 out nocopy JTF_VARCHAR2_TABLE_500
118: , a23 out nocopy JTF_NUMBER_TABLE
119: , a24 out nocopy JTF_DATE_TABLE
120: , a25 out nocopy JTF_NUMBER_TABLE
121: , a26 out nocopy JTF_DATE_TABLE
122: , a27 out nocopy JTF_NUMBER_TABLE
123: ) as
124: ddindx binary_integer; indx binary_integer;
118: , a23 out nocopy JTF_NUMBER_TABLE
119: , a24 out nocopy JTF_DATE_TABLE
120: , a25 out nocopy JTF_NUMBER_TABLE
121: , a26 out nocopy JTF_DATE_TABLE
122: , a27 out nocopy JTF_NUMBER_TABLE
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: a2 := JTF_DATE_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: a2 := JTF_DATE_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_100();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_VARCHAR2_TABLE_100();
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: a2 := JTF_DATE_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_100();
133: a6 := JTF_DATE_TABLE();
134: a7 := JTF_VARCHAR2_TABLE_100();
135: a8 := JTF_VARCHAR2_TABLE_500();
146: a19 := JTF_VARCHAR2_TABLE_500();
147: a20 := JTF_VARCHAR2_TABLE_500();
148: a21 := JTF_VARCHAR2_TABLE_500();
149: a22 := JTF_VARCHAR2_TABLE_500();
150: a23 := JTF_NUMBER_TABLE();
151: a24 := JTF_DATE_TABLE();
152: a25 := JTF_NUMBER_TABLE();
153: a26 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
148: a21 := JTF_VARCHAR2_TABLE_500();
149: a22 := JTF_VARCHAR2_TABLE_500();
150: a23 := JTF_NUMBER_TABLE();
151: a24 := JTF_DATE_TABLE();
152: a25 := JTF_NUMBER_TABLE();
153: a26 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
150: a23 := JTF_NUMBER_TABLE();
151: a24 := JTF_DATE_TABLE();
152: a25 := JTF_NUMBER_TABLE();
153: a26 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_DATE_TABLE();
152: a25 := JTF_NUMBER_TABLE();
153: a26 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_DATE_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_DATE_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_VARCHAR2_TABLE_100();
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_DATE_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();
162: a6 := JTF_DATE_TABLE();
163: a7 := JTF_VARCHAR2_TABLE_100();
164: a8 := JTF_VARCHAR2_TABLE_500();
175: a19 := JTF_VARCHAR2_TABLE_500();
176: a20 := JTF_VARCHAR2_TABLE_500();
177: a21 := JTF_VARCHAR2_TABLE_500();
178: a22 := JTF_VARCHAR2_TABLE_500();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_DATE_TABLE();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_DATE_TABLE();
183: a27 := JTF_NUMBER_TABLE();
177: a21 := JTF_VARCHAR2_TABLE_500();
178: a22 := JTF_VARCHAR2_TABLE_500();
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_DATE_TABLE();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_DATE_TABLE();
183: a27 := JTF_NUMBER_TABLE();
184: if t.count > 0 then
185: a0.extend(t.count);
179: a23 := JTF_NUMBER_TABLE();
180: a24 := JTF_DATE_TABLE();
181: a25 := JTF_NUMBER_TABLE();
182: a26 := JTF_DATE_TABLE();
183: a27 := JTF_NUMBER_TABLE();
184: if t.count > 0 then
185: a0.extend(t.count);
186: a1.extend(t.count);
187: a2.extend(t.count);
250: end if;
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p5(t out nocopy okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_VARCHAR2_TABLE_100
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_VARCHAR2_TABLE_2000
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_VARCHAR2_TABLE_100
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_VARCHAR2_TABLE_2000
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_DATE_TABLE
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_DATE_TABLE
263: , a9 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_VARCHAR2_TABLE_2000
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_DATE_TABLE
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_DATE_TABLE
263: , a9 JTF_NUMBER_TABLE
264: ) as
265: ddindx binary_integer; indx binary_integer;
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_DATE_TABLE
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_DATE_TABLE
263: , a9 JTF_NUMBER_TABLE
264: ) as
265: ddindx binary_integer; indx binary_integer;
266: begin
267: if a0 is not null and a0.count > 0 then
287: end loop;
288: end if;
289: end if;
290: end rosetta_table_copy_in_p5;
291: procedure rosetta_table_copy_out_p5(t okl_ien_pvt.okl_ins_exclusions_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
296: , a5 out nocopy JTF_NUMBER_TABLE
297: , a6 out nocopy JTF_DATE_TABLE
298: , a7 out nocopy JTF_NUMBER_TABLE
299: , a8 out nocopy JTF_DATE_TABLE
300: , a9 out nocopy JTF_NUMBER_TABLE
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
296: , a5 out nocopy JTF_NUMBER_TABLE
297: , a6 out nocopy JTF_DATE_TABLE
298: , a7 out nocopy JTF_NUMBER_TABLE
299: , a8 out nocopy JTF_DATE_TABLE
300: , a9 out nocopy JTF_NUMBER_TABLE
301: ) as
302: ddindx binary_integer; indx binary_integer;
296: , a5 out nocopy JTF_NUMBER_TABLE
297: , a6 out nocopy JTF_DATE_TABLE
298: , a7 out nocopy JTF_NUMBER_TABLE
299: , a8 out nocopy JTF_DATE_TABLE
300: , a9 out nocopy JTF_NUMBER_TABLE
301: ) as
302: ddindx binary_integer; indx binary_integer;
303: begin
304: if t is null or t.count = 0 then
301: ) as
302: ddindx binary_integer; indx binary_integer;
303: begin
304: if t is null or t.count = 0 then
305: a0 := JTF_NUMBER_TABLE();
306: a1 := JTF_VARCHAR2_TABLE_100();
307: a2 := JTF_VARCHAR2_TABLE_100();
308: a3 := JTF_VARCHAR2_TABLE_100();
309: a4 := JTF_VARCHAR2_TABLE_2000();
306: a1 := JTF_VARCHAR2_TABLE_100();
307: a2 := JTF_VARCHAR2_TABLE_100();
308: a3 := JTF_VARCHAR2_TABLE_100();
309: a4 := JTF_VARCHAR2_TABLE_2000();
310: a5 := JTF_NUMBER_TABLE();
311: a6 := JTF_DATE_TABLE();
312: a7 := JTF_NUMBER_TABLE();
313: a8 := JTF_DATE_TABLE();
314: a9 := JTF_NUMBER_TABLE();
308: a3 := JTF_VARCHAR2_TABLE_100();
309: a4 := JTF_VARCHAR2_TABLE_2000();
310: a5 := JTF_NUMBER_TABLE();
311: a6 := JTF_DATE_TABLE();
312: a7 := JTF_NUMBER_TABLE();
313: a8 := JTF_DATE_TABLE();
314: a9 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
310: a5 := JTF_NUMBER_TABLE();
311: a6 := JTF_DATE_TABLE();
312: a7 := JTF_NUMBER_TABLE();
313: a8 := JTF_DATE_TABLE();
314: a9 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
312: a7 := JTF_NUMBER_TABLE();
313: a8 := JTF_DATE_TABLE();
314: a9 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_VARCHAR2_TABLE_2000();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_VARCHAR2_TABLE_2000();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_DATE_TABLE();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_DATE_TABLE();
325: a9 := JTF_NUMBER_TABLE();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_VARCHAR2_TABLE_2000();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_DATE_TABLE();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_DATE_TABLE();
325: a9 := JTF_NUMBER_TABLE();
326: if t.count > 0 then
327: a0.extend(t.count);
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_DATE_TABLE();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_DATE_TABLE();
325: a9 := JTF_NUMBER_TABLE();
326: if t.count > 0 then
327: a0.extend(t.count);
328: a1.extend(t.count);
329: a2.extend(t.count);
356: end if;
357: end if;
358: end rosetta_table_copy_out_p5;
359:
360: procedure rosetta_table_copy_in_p8(t out nocopy okl_ien_pvt.ienv_tbl_type, a0 JTF_NUMBER_TABLE
361: , a1 JTF_NUMBER_TABLE
362: , a2 JTF_VARCHAR2_TABLE_100
363: , a3 JTF_VARCHAR2_TABLE_100
364: , a4 JTF_NUMBER_TABLE
357: end if;
358: end rosetta_table_copy_out_p5;
359:
360: procedure rosetta_table_copy_in_p8(t out nocopy okl_ien_pvt.ienv_tbl_type, a0 JTF_NUMBER_TABLE
361: , a1 JTF_NUMBER_TABLE
362: , a2 JTF_VARCHAR2_TABLE_100
363: , a3 JTF_VARCHAR2_TABLE_100
364: , a4 JTF_NUMBER_TABLE
365: , a5 JTF_VARCHAR2_TABLE_100
360: procedure rosetta_table_copy_in_p8(t out nocopy okl_ien_pvt.ienv_tbl_type, a0 JTF_NUMBER_TABLE
361: , a1 JTF_NUMBER_TABLE
362: , a2 JTF_VARCHAR2_TABLE_100
363: , a3 JTF_VARCHAR2_TABLE_100
364: , a4 JTF_NUMBER_TABLE
365: , a5 JTF_VARCHAR2_TABLE_100
366: , a6 JTF_VARCHAR2_TABLE_500
367: , a7 JTF_VARCHAR2_TABLE_500
368: , a8 JTF_VARCHAR2_TABLE_500
381: , a21 JTF_DATE_TABLE
382: , a22 JTF_VARCHAR2_TABLE_100
383: , a23 JTF_DATE_TABLE
384: , a24 JTF_VARCHAR2_TABLE_2000
385: , a25 JTF_NUMBER_TABLE
386: , a26 JTF_DATE_TABLE
387: , a27 JTF_NUMBER_TABLE
388: , a28 JTF_DATE_TABLE
389: , a29 JTF_NUMBER_TABLE
383: , a23 JTF_DATE_TABLE
384: , a24 JTF_VARCHAR2_TABLE_2000
385: , a25 JTF_NUMBER_TABLE
386: , a26 JTF_DATE_TABLE
387: , a27 JTF_NUMBER_TABLE
388: , a28 JTF_DATE_TABLE
389: , a29 JTF_NUMBER_TABLE
390: ) as
391: ddindx binary_integer; indx binary_integer;
385: , a25 JTF_NUMBER_TABLE
386: , a26 JTF_DATE_TABLE
387: , a27 JTF_NUMBER_TABLE
388: , a28 JTF_DATE_TABLE
389: , a29 JTF_NUMBER_TABLE
390: ) as
391: ddindx binary_integer; indx binary_integer;
392: begin
393: if a0 is not null and a0.count > 0 then
433: end loop;
434: end if;
435: end if;
436: end rosetta_table_copy_in_p8;
437: procedure rosetta_table_copy_out_p8(t okl_ien_pvt.ienv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_VARCHAR2_TABLE_100
440: , a3 out nocopy JTF_VARCHAR2_TABLE_100
441: , a4 out nocopy JTF_NUMBER_TABLE
434: end if;
435: end if;
436: end rosetta_table_copy_in_p8;
437: procedure rosetta_table_copy_out_p8(t okl_ien_pvt.ienv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_VARCHAR2_TABLE_100
440: , a3 out nocopy JTF_VARCHAR2_TABLE_100
441: , a4 out nocopy JTF_NUMBER_TABLE
442: , a5 out nocopy JTF_VARCHAR2_TABLE_100
437: procedure rosetta_table_copy_out_p8(t okl_ien_pvt.ienv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_VARCHAR2_TABLE_100
440: , a3 out nocopy JTF_VARCHAR2_TABLE_100
441: , a4 out nocopy JTF_NUMBER_TABLE
442: , a5 out nocopy JTF_VARCHAR2_TABLE_100
443: , a6 out nocopy JTF_VARCHAR2_TABLE_500
444: , a7 out nocopy JTF_VARCHAR2_TABLE_500
445: , a8 out nocopy JTF_VARCHAR2_TABLE_500
458: , a21 out nocopy JTF_DATE_TABLE
459: , a22 out nocopy JTF_VARCHAR2_TABLE_100
460: , a23 out nocopy JTF_DATE_TABLE
461: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
462: , a25 out nocopy JTF_NUMBER_TABLE
463: , a26 out nocopy JTF_DATE_TABLE
464: , a27 out nocopy JTF_NUMBER_TABLE
465: , a28 out nocopy JTF_DATE_TABLE
466: , a29 out nocopy JTF_NUMBER_TABLE
460: , a23 out nocopy JTF_DATE_TABLE
461: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
462: , a25 out nocopy JTF_NUMBER_TABLE
463: , a26 out nocopy JTF_DATE_TABLE
464: , a27 out nocopy JTF_NUMBER_TABLE
465: , a28 out nocopy JTF_DATE_TABLE
466: , a29 out nocopy JTF_NUMBER_TABLE
467: ) as
468: ddindx binary_integer; indx binary_integer;
462: , a25 out nocopy JTF_NUMBER_TABLE
463: , a26 out nocopy JTF_DATE_TABLE
464: , a27 out nocopy JTF_NUMBER_TABLE
465: , a28 out nocopy JTF_DATE_TABLE
466: , a29 out nocopy JTF_NUMBER_TABLE
467: ) as
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if t is null or t.count = 0 then
467: ) as
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if t is null or t.count = 0 then
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_VARCHAR2_TABLE_100();
474: a3 := JTF_VARCHAR2_TABLE_100();
475: a4 := JTF_NUMBER_TABLE();
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if t is null or t.count = 0 then
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_VARCHAR2_TABLE_100();
474: a3 := JTF_VARCHAR2_TABLE_100();
475: a4 := JTF_NUMBER_TABLE();
476: a5 := JTF_VARCHAR2_TABLE_100();
471: a0 := JTF_NUMBER_TABLE();
472: a1 := JTF_NUMBER_TABLE();
473: a2 := JTF_VARCHAR2_TABLE_100();
474: a3 := JTF_VARCHAR2_TABLE_100();
475: a4 := JTF_NUMBER_TABLE();
476: a5 := JTF_VARCHAR2_TABLE_100();
477: a6 := JTF_VARCHAR2_TABLE_500();
478: a7 := JTF_VARCHAR2_TABLE_500();
479: a8 := JTF_VARCHAR2_TABLE_500();
492: a21 := JTF_DATE_TABLE();
493: a22 := JTF_VARCHAR2_TABLE_100();
494: a23 := JTF_DATE_TABLE();
495: a24 := JTF_VARCHAR2_TABLE_2000();
496: a25 := JTF_NUMBER_TABLE();
497: a26 := JTF_DATE_TABLE();
498: a27 := JTF_NUMBER_TABLE();
499: a28 := JTF_DATE_TABLE();
500: a29 := JTF_NUMBER_TABLE();
494: a23 := JTF_DATE_TABLE();
495: a24 := JTF_VARCHAR2_TABLE_2000();
496: a25 := JTF_NUMBER_TABLE();
497: a26 := JTF_DATE_TABLE();
498: a27 := JTF_NUMBER_TABLE();
499: a28 := JTF_DATE_TABLE();
500: a29 := JTF_NUMBER_TABLE();
501: else
502: a0 := JTF_NUMBER_TABLE();
496: a25 := JTF_NUMBER_TABLE();
497: a26 := JTF_DATE_TABLE();
498: a27 := JTF_NUMBER_TABLE();
499: a28 := JTF_DATE_TABLE();
500: a29 := JTF_NUMBER_TABLE();
501: else
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_100();
498: a27 := JTF_NUMBER_TABLE();
499: a28 := JTF_DATE_TABLE();
500: a29 := JTF_NUMBER_TABLE();
501: else
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_100();
505: a3 := JTF_VARCHAR2_TABLE_100();
506: a4 := JTF_NUMBER_TABLE();
499: a28 := JTF_DATE_TABLE();
500: a29 := JTF_NUMBER_TABLE();
501: else
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_100();
505: a3 := JTF_VARCHAR2_TABLE_100();
506: a4 := JTF_NUMBER_TABLE();
507: a5 := JTF_VARCHAR2_TABLE_100();
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_100();
505: a3 := JTF_VARCHAR2_TABLE_100();
506: a4 := JTF_NUMBER_TABLE();
507: a5 := JTF_VARCHAR2_TABLE_100();
508: a6 := JTF_VARCHAR2_TABLE_500();
509: a7 := JTF_VARCHAR2_TABLE_500();
510: a8 := JTF_VARCHAR2_TABLE_500();
523: a21 := JTF_DATE_TABLE();
524: a22 := JTF_VARCHAR2_TABLE_100();
525: a23 := JTF_DATE_TABLE();
526: a24 := JTF_VARCHAR2_TABLE_2000();
527: a25 := JTF_NUMBER_TABLE();
528: a26 := JTF_DATE_TABLE();
529: a27 := JTF_NUMBER_TABLE();
530: a28 := JTF_DATE_TABLE();
531: a29 := JTF_NUMBER_TABLE();
525: a23 := JTF_DATE_TABLE();
526: a24 := JTF_VARCHAR2_TABLE_2000();
527: a25 := JTF_NUMBER_TABLE();
528: a26 := JTF_DATE_TABLE();
529: a27 := JTF_NUMBER_TABLE();
530: a28 := JTF_DATE_TABLE();
531: a29 := JTF_NUMBER_TABLE();
532: if t.count > 0 then
533: a0.extend(t.count);
527: a25 := JTF_NUMBER_TABLE();
528: a26 := JTF_DATE_TABLE();
529: a27 := JTF_NUMBER_TABLE();
530: a28 := JTF_DATE_TABLE();
531: a29 := JTF_NUMBER_TABLE();
532: if t.count > 0 then
533: a0.extend(t.count);
534: a1.extend(t.count);
535: a2.extend(t.count);
766: , p_init_msg_list VARCHAR2
767: , x_return_status out nocopy VARCHAR2
768: , x_msg_count out nocopy NUMBER
769: , x_msg_data out nocopy VARCHAR2
770: , p5_a0 JTF_NUMBER_TABLE
771: , p5_a1 JTF_NUMBER_TABLE
772: , p5_a2 JTF_VARCHAR2_TABLE_100
773: , p5_a3 JTF_VARCHAR2_TABLE_100
774: , p5_a4 JTF_NUMBER_TABLE
767: , x_return_status out nocopy VARCHAR2
768: , x_msg_count out nocopy NUMBER
769: , x_msg_data out nocopy VARCHAR2
770: , p5_a0 JTF_NUMBER_TABLE
771: , p5_a1 JTF_NUMBER_TABLE
772: , p5_a2 JTF_VARCHAR2_TABLE_100
773: , p5_a3 JTF_VARCHAR2_TABLE_100
774: , p5_a4 JTF_NUMBER_TABLE
775: , p5_a5 JTF_VARCHAR2_TABLE_100
770: , p5_a0 JTF_NUMBER_TABLE
771: , p5_a1 JTF_NUMBER_TABLE
772: , p5_a2 JTF_VARCHAR2_TABLE_100
773: , p5_a3 JTF_VARCHAR2_TABLE_100
774: , p5_a4 JTF_NUMBER_TABLE
775: , p5_a5 JTF_VARCHAR2_TABLE_100
776: , p5_a6 JTF_VARCHAR2_TABLE_500
777: , p5_a7 JTF_VARCHAR2_TABLE_500
778: , p5_a8 JTF_VARCHAR2_TABLE_500
791: , p5_a21 JTF_DATE_TABLE
792: , p5_a22 JTF_VARCHAR2_TABLE_100
793: , p5_a23 JTF_DATE_TABLE
794: , p5_a24 JTF_VARCHAR2_TABLE_2000
795: , p5_a25 JTF_NUMBER_TABLE
796: , p5_a26 JTF_DATE_TABLE
797: , p5_a27 JTF_NUMBER_TABLE
798: , p5_a28 JTF_DATE_TABLE
799: , p5_a29 JTF_NUMBER_TABLE
793: , p5_a23 JTF_DATE_TABLE
794: , p5_a24 JTF_VARCHAR2_TABLE_2000
795: , p5_a25 JTF_NUMBER_TABLE
796: , p5_a26 JTF_DATE_TABLE
797: , p5_a27 JTF_NUMBER_TABLE
798: , p5_a28 JTF_DATE_TABLE
799: , p5_a29 JTF_NUMBER_TABLE
800: , p6_a0 out nocopy JTF_NUMBER_TABLE
801: , p6_a1 out nocopy JTF_NUMBER_TABLE
795: , p5_a25 JTF_NUMBER_TABLE
796: , p5_a26 JTF_DATE_TABLE
797: , p5_a27 JTF_NUMBER_TABLE
798: , p5_a28 JTF_DATE_TABLE
799: , p5_a29 JTF_NUMBER_TABLE
800: , p6_a0 out nocopy JTF_NUMBER_TABLE
801: , p6_a1 out nocopy JTF_NUMBER_TABLE
802: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
796: , p5_a26 JTF_DATE_TABLE
797: , p5_a27 JTF_NUMBER_TABLE
798: , p5_a28 JTF_DATE_TABLE
799: , p5_a29 JTF_NUMBER_TABLE
800: , p6_a0 out nocopy JTF_NUMBER_TABLE
801: , p6_a1 out nocopy JTF_NUMBER_TABLE
802: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a4 out nocopy JTF_NUMBER_TABLE
797: , p5_a27 JTF_NUMBER_TABLE
798: , p5_a28 JTF_DATE_TABLE
799: , p5_a29 JTF_NUMBER_TABLE
800: , p6_a0 out nocopy JTF_NUMBER_TABLE
801: , p6_a1 out nocopy JTF_NUMBER_TABLE
802: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a4 out nocopy JTF_NUMBER_TABLE
805: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a0 out nocopy JTF_NUMBER_TABLE
801: , p6_a1 out nocopy JTF_NUMBER_TABLE
802: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a4 out nocopy JTF_NUMBER_TABLE
805: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
806: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
807: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
821: , p6_a21 out nocopy JTF_DATE_TABLE
822: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
823: , p6_a23 out nocopy JTF_DATE_TABLE
824: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
825: , p6_a25 out nocopy JTF_NUMBER_TABLE
826: , p6_a26 out nocopy JTF_DATE_TABLE
827: , p6_a27 out nocopy JTF_NUMBER_TABLE
828: , p6_a28 out nocopy JTF_DATE_TABLE
829: , p6_a29 out nocopy JTF_NUMBER_TABLE
823: , p6_a23 out nocopy JTF_DATE_TABLE
824: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
825: , p6_a25 out nocopy JTF_NUMBER_TABLE
826: , p6_a26 out nocopy JTF_DATE_TABLE
827: , p6_a27 out nocopy JTF_NUMBER_TABLE
828: , p6_a28 out nocopy JTF_DATE_TABLE
829: , p6_a29 out nocopy JTF_NUMBER_TABLE
830: )
831:
825: , p6_a25 out nocopy JTF_NUMBER_TABLE
826: , p6_a26 out nocopy JTF_DATE_TABLE
827: , p6_a27 out nocopy JTF_NUMBER_TABLE
828: , p6_a28 out nocopy JTF_DATE_TABLE
829: , p6_a29 out nocopy JTF_NUMBER_TABLE
830: )
831:
832: as
833: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1022: , p_init_msg_list VARCHAR2
1023: , x_return_status out nocopy VARCHAR2
1024: , x_msg_count out nocopy NUMBER
1025: , x_msg_data out nocopy VARCHAR2
1026: , p5_a0 JTF_NUMBER_TABLE
1027: , p5_a1 JTF_NUMBER_TABLE
1028: , p5_a2 JTF_VARCHAR2_TABLE_100
1029: , p5_a3 JTF_VARCHAR2_TABLE_100
1030: , p5_a4 JTF_NUMBER_TABLE
1023: , x_return_status out nocopy VARCHAR2
1024: , x_msg_count out nocopy NUMBER
1025: , x_msg_data out nocopy VARCHAR2
1026: , p5_a0 JTF_NUMBER_TABLE
1027: , p5_a1 JTF_NUMBER_TABLE
1028: , p5_a2 JTF_VARCHAR2_TABLE_100
1029: , p5_a3 JTF_VARCHAR2_TABLE_100
1030: , p5_a4 JTF_NUMBER_TABLE
1031: , p5_a5 JTF_VARCHAR2_TABLE_100
1026: , p5_a0 JTF_NUMBER_TABLE
1027: , p5_a1 JTF_NUMBER_TABLE
1028: , p5_a2 JTF_VARCHAR2_TABLE_100
1029: , p5_a3 JTF_VARCHAR2_TABLE_100
1030: , p5_a4 JTF_NUMBER_TABLE
1031: , p5_a5 JTF_VARCHAR2_TABLE_100
1032: , p5_a6 JTF_VARCHAR2_TABLE_500
1033: , p5_a7 JTF_VARCHAR2_TABLE_500
1034: , p5_a8 JTF_VARCHAR2_TABLE_500
1047: , p5_a21 JTF_DATE_TABLE
1048: , p5_a22 JTF_VARCHAR2_TABLE_100
1049: , p5_a23 JTF_DATE_TABLE
1050: , p5_a24 JTF_VARCHAR2_TABLE_2000
1051: , p5_a25 JTF_NUMBER_TABLE
1052: , p5_a26 JTF_DATE_TABLE
1053: , p5_a27 JTF_NUMBER_TABLE
1054: , p5_a28 JTF_DATE_TABLE
1055: , p5_a29 JTF_NUMBER_TABLE
1049: , p5_a23 JTF_DATE_TABLE
1050: , p5_a24 JTF_VARCHAR2_TABLE_2000
1051: , p5_a25 JTF_NUMBER_TABLE
1052: , p5_a26 JTF_DATE_TABLE
1053: , p5_a27 JTF_NUMBER_TABLE
1054: , p5_a28 JTF_DATE_TABLE
1055: , p5_a29 JTF_NUMBER_TABLE
1056: )
1057:
1051: , p5_a25 JTF_NUMBER_TABLE
1052: , p5_a26 JTF_DATE_TABLE
1053: , p5_a27 JTF_NUMBER_TABLE
1054: , p5_a28 JTF_DATE_TABLE
1055: , p5_a29 JTF_NUMBER_TABLE
1056: )
1057:
1058: as
1059: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1277: , p_init_msg_list VARCHAR2
1278: , x_return_status out nocopy VARCHAR2
1279: , x_msg_count out nocopy NUMBER
1280: , x_msg_data out nocopy VARCHAR2
1281: , p5_a0 JTF_NUMBER_TABLE
1282: , p5_a1 JTF_NUMBER_TABLE
1283: , p5_a2 JTF_VARCHAR2_TABLE_100
1284: , p5_a3 JTF_VARCHAR2_TABLE_100
1285: , p5_a4 JTF_NUMBER_TABLE
1278: , x_return_status out nocopy VARCHAR2
1279: , x_msg_count out nocopy NUMBER
1280: , x_msg_data out nocopy VARCHAR2
1281: , p5_a0 JTF_NUMBER_TABLE
1282: , p5_a1 JTF_NUMBER_TABLE
1283: , p5_a2 JTF_VARCHAR2_TABLE_100
1284: , p5_a3 JTF_VARCHAR2_TABLE_100
1285: , p5_a4 JTF_NUMBER_TABLE
1286: , p5_a5 JTF_VARCHAR2_TABLE_100
1281: , p5_a0 JTF_NUMBER_TABLE
1282: , p5_a1 JTF_NUMBER_TABLE
1283: , p5_a2 JTF_VARCHAR2_TABLE_100
1284: , p5_a3 JTF_VARCHAR2_TABLE_100
1285: , p5_a4 JTF_NUMBER_TABLE
1286: , p5_a5 JTF_VARCHAR2_TABLE_100
1287: , p5_a6 JTF_VARCHAR2_TABLE_500
1288: , p5_a7 JTF_VARCHAR2_TABLE_500
1289: , p5_a8 JTF_VARCHAR2_TABLE_500
1302: , p5_a21 JTF_DATE_TABLE
1303: , p5_a22 JTF_VARCHAR2_TABLE_100
1304: , p5_a23 JTF_DATE_TABLE
1305: , p5_a24 JTF_VARCHAR2_TABLE_2000
1306: , p5_a25 JTF_NUMBER_TABLE
1307: , p5_a26 JTF_DATE_TABLE
1308: , p5_a27 JTF_NUMBER_TABLE
1309: , p5_a28 JTF_DATE_TABLE
1310: , p5_a29 JTF_NUMBER_TABLE
1304: , p5_a23 JTF_DATE_TABLE
1305: , p5_a24 JTF_VARCHAR2_TABLE_2000
1306: , p5_a25 JTF_NUMBER_TABLE
1307: , p5_a26 JTF_DATE_TABLE
1308: , p5_a27 JTF_NUMBER_TABLE
1309: , p5_a28 JTF_DATE_TABLE
1310: , p5_a29 JTF_NUMBER_TABLE
1311: , p6_a0 out nocopy JTF_NUMBER_TABLE
1312: , p6_a1 out nocopy JTF_NUMBER_TABLE
1306: , p5_a25 JTF_NUMBER_TABLE
1307: , p5_a26 JTF_DATE_TABLE
1308: , p5_a27 JTF_NUMBER_TABLE
1309: , p5_a28 JTF_DATE_TABLE
1310: , p5_a29 JTF_NUMBER_TABLE
1311: , p6_a0 out nocopy JTF_NUMBER_TABLE
1312: , p6_a1 out nocopy JTF_NUMBER_TABLE
1313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1314: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1307: , p5_a26 JTF_DATE_TABLE
1308: , p5_a27 JTF_NUMBER_TABLE
1309: , p5_a28 JTF_DATE_TABLE
1310: , p5_a29 JTF_NUMBER_TABLE
1311: , p6_a0 out nocopy JTF_NUMBER_TABLE
1312: , p6_a1 out nocopy JTF_NUMBER_TABLE
1313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1314: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1315: , p6_a4 out nocopy JTF_NUMBER_TABLE
1308: , p5_a27 JTF_NUMBER_TABLE
1309: , p5_a28 JTF_DATE_TABLE
1310: , p5_a29 JTF_NUMBER_TABLE
1311: , p6_a0 out nocopy JTF_NUMBER_TABLE
1312: , p6_a1 out nocopy JTF_NUMBER_TABLE
1313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1314: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1315: , p6_a4 out nocopy JTF_NUMBER_TABLE
1316: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1311: , p6_a0 out nocopy JTF_NUMBER_TABLE
1312: , p6_a1 out nocopy JTF_NUMBER_TABLE
1313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1314: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1315: , p6_a4 out nocopy JTF_NUMBER_TABLE
1316: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1317: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1318: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1319: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1332: , p6_a21 out nocopy JTF_DATE_TABLE
1333: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1334: , p6_a23 out nocopy JTF_DATE_TABLE
1335: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
1336: , p6_a25 out nocopy JTF_NUMBER_TABLE
1337: , p6_a26 out nocopy JTF_DATE_TABLE
1338: , p6_a27 out nocopy JTF_NUMBER_TABLE
1339: , p6_a28 out nocopy JTF_DATE_TABLE
1340: , p6_a29 out nocopy JTF_NUMBER_TABLE
1334: , p6_a23 out nocopy JTF_DATE_TABLE
1335: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
1336: , p6_a25 out nocopy JTF_NUMBER_TABLE
1337: , p6_a26 out nocopy JTF_DATE_TABLE
1338: , p6_a27 out nocopy JTF_NUMBER_TABLE
1339: , p6_a28 out nocopy JTF_DATE_TABLE
1340: , p6_a29 out nocopy JTF_NUMBER_TABLE
1341: )
1342:
1336: , p6_a25 out nocopy JTF_NUMBER_TABLE
1337: , p6_a26 out nocopy JTF_DATE_TABLE
1338: , p6_a27 out nocopy JTF_NUMBER_TABLE
1339: , p6_a28 out nocopy JTF_DATE_TABLE
1340: , p6_a29 out nocopy JTF_NUMBER_TABLE
1341: )
1342:
1343: as
1344: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1533: , p_init_msg_list VARCHAR2
1534: , x_return_status out nocopy VARCHAR2
1535: , x_msg_count out nocopy NUMBER
1536: , x_msg_data out nocopy VARCHAR2
1537: , p5_a0 JTF_NUMBER_TABLE
1538: , p5_a1 JTF_NUMBER_TABLE
1539: , p5_a2 JTF_VARCHAR2_TABLE_100
1540: , p5_a3 JTF_VARCHAR2_TABLE_100
1541: , p5_a4 JTF_NUMBER_TABLE
1534: , x_return_status out nocopy VARCHAR2
1535: , x_msg_count out nocopy NUMBER
1536: , x_msg_data out nocopy VARCHAR2
1537: , p5_a0 JTF_NUMBER_TABLE
1538: , p5_a1 JTF_NUMBER_TABLE
1539: , p5_a2 JTF_VARCHAR2_TABLE_100
1540: , p5_a3 JTF_VARCHAR2_TABLE_100
1541: , p5_a4 JTF_NUMBER_TABLE
1542: , p5_a5 JTF_VARCHAR2_TABLE_100
1537: , p5_a0 JTF_NUMBER_TABLE
1538: , p5_a1 JTF_NUMBER_TABLE
1539: , p5_a2 JTF_VARCHAR2_TABLE_100
1540: , p5_a3 JTF_VARCHAR2_TABLE_100
1541: , p5_a4 JTF_NUMBER_TABLE
1542: , p5_a5 JTF_VARCHAR2_TABLE_100
1543: , p5_a6 JTF_VARCHAR2_TABLE_500
1544: , p5_a7 JTF_VARCHAR2_TABLE_500
1545: , p5_a8 JTF_VARCHAR2_TABLE_500
1558: , p5_a21 JTF_DATE_TABLE
1559: , p5_a22 JTF_VARCHAR2_TABLE_100
1560: , p5_a23 JTF_DATE_TABLE
1561: , p5_a24 JTF_VARCHAR2_TABLE_2000
1562: , p5_a25 JTF_NUMBER_TABLE
1563: , p5_a26 JTF_DATE_TABLE
1564: , p5_a27 JTF_NUMBER_TABLE
1565: , p5_a28 JTF_DATE_TABLE
1566: , p5_a29 JTF_NUMBER_TABLE
1560: , p5_a23 JTF_DATE_TABLE
1561: , p5_a24 JTF_VARCHAR2_TABLE_2000
1562: , p5_a25 JTF_NUMBER_TABLE
1563: , p5_a26 JTF_DATE_TABLE
1564: , p5_a27 JTF_NUMBER_TABLE
1565: , p5_a28 JTF_DATE_TABLE
1566: , p5_a29 JTF_NUMBER_TABLE
1567: )
1568:
1562: , p5_a25 JTF_NUMBER_TABLE
1563: , p5_a26 JTF_DATE_TABLE
1564: , p5_a27 JTF_NUMBER_TABLE
1565: , p5_a28 JTF_DATE_TABLE
1566: , p5_a29 JTF_NUMBER_TABLE
1567: )
1568:
1569: as
1570: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;
1724: , p_init_msg_list VARCHAR2
1725: , x_return_status out nocopy VARCHAR2
1726: , x_msg_count out nocopy NUMBER
1727: , x_msg_data out nocopy VARCHAR2
1728: , p5_a0 JTF_NUMBER_TABLE
1729: , p5_a1 JTF_NUMBER_TABLE
1730: , p5_a2 JTF_VARCHAR2_TABLE_100
1731: , p5_a3 JTF_VARCHAR2_TABLE_100
1732: , p5_a4 JTF_NUMBER_TABLE
1725: , x_return_status out nocopy VARCHAR2
1726: , x_msg_count out nocopy NUMBER
1727: , x_msg_data out nocopy VARCHAR2
1728: , p5_a0 JTF_NUMBER_TABLE
1729: , p5_a1 JTF_NUMBER_TABLE
1730: , p5_a2 JTF_VARCHAR2_TABLE_100
1731: , p5_a3 JTF_VARCHAR2_TABLE_100
1732: , p5_a4 JTF_NUMBER_TABLE
1733: , p5_a5 JTF_VARCHAR2_TABLE_100
1728: , p5_a0 JTF_NUMBER_TABLE
1729: , p5_a1 JTF_NUMBER_TABLE
1730: , p5_a2 JTF_VARCHAR2_TABLE_100
1731: , p5_a3 JTF_VARCHAR2_TABLE_100
1732: , p5_a4 JTF_NUMBER_TABLE
1733: , p5_a5 JTF_VARCHAR2_TABLE_100
1734: , p5_a6 JTF_VARCHAR2_TABLE_500
1735: , p5_a7 JTF_VARCHAR2_TABLE_500
1736: , p5_a8 JTF_VARCHAR2_TABLE_500
1749: , p5_a21 JTF_DATE_TABLE
1750: , p5_a22 JTF_VARCHAR2_TABLE_100
1751: , p5_a23 JTF_DATE_TABLE
1752: , p5_a24 JTF_VARCHAR2_TABLE_2000
1753: , p5_a25 JTF_NUMBER_TABLE
1754: , p5_a26 JTF_DATE_TABLE
1755: , p5_a27 JTF_NUMBER_TABLE
1756: , p5_a28 JTF_DATE_TABLE
1757: , p5_a29 JTF_NUMBER_TABLE
1751: , p5_a23 JTF_DATE_TABLE
1752: , p5_a24 JTF_VARCHAR2_TABLE_2000
1753: , p5_a25 JTF_NUMBER_TABLE
1754: , p5_a26 JTF_DATE_TABLE
1755: , p5_a27 JTF_NUMBER_TABLE
1756: , p5_a28 JTF_DATE_TABLE
1757: , p5_a29 JTF_NUMBER_TABLE
1758: )
1759:
1753: , p5_a25 JTF_NUMBER_TABLE
1754: , p5_a26 JTF_DATE_TABLE
1755: , p5_a27 JTF_NUMBER_TABLE
1756: , p5_a28 JTF_DATE_TABLE
1757: , p5_a29 JTF_NUMBER_TABLE
1758: )
1759:
1760: as
1761: ddp_ienv_tbl okl_ien_pvt.ienv_tbl_type;