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_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
38: , a16 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: ) as
48: ddindx binary_integer; indx binary_integer;
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_DATE_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if a0 is not null and a0.count > 0 then
85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
86: end if;
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
87: end if;
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
95: , a6 out nocopy JTF_VARCHAR2_TABLE_500
88: end rosetta_table_copy_in_p2;
89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
95: , a6 out nocopy JTF_VARCHAR2_TABLE_500
96: , a7 out nocopy JTF_VARCHAR2_TABLE_500
105: , a16 out nocopy JTF_VARCHAR2_TABLE_500
106: , a17 out nocopy JTF_VARCHAR2_TABLE_500
107: , a18 out nocopy JTF_VARCHAR2_TABLE_500
108: , a19 out nocopy JTF_VARCHAR2_TABLE_500
109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE
107: , a18 out nocopy JTF_VARCHAR2_TABLE_500
108: , a19 out nocopy JTF_VARCHAR2_TABLE_500
109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;
109: , a20 out nocopy JTF_NUMBER_TABLE
110: , a21 out nocopy JTF_DATE_TABLE
111: , a22 out nocopy JTF_NUMBER_TABLE
112: , a23 out nocopy JTF_DATE_TABLE
113: , a24 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
124: a6 := JTF_VARCHAR2_TABLE_500();
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
124: a6 := JTF_VARCHAR2_TABLE_500();
125: a7 := JTF_VARCHAR2_TABLE_500();
134: a16 := JTF_VARCHAR2_TABLE_500();
135: a17 := JTF_VARCHAR2_TABLE_500();
136: a18 := JTF_VARCHAR2_TABLE_500();
137: a19 := JTF_VARCHAR2_TABLE_500();
138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
136: a18 := JTF_VARCHAR2_TABLE_500();
137: a19 := JTF_VARCHAR2_TABLE_500();
138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
138: a20 := JTF_NUMBER_TABLE();
139: a21 := JTF_DATE_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
140: a22 := JTF_NUMBER_TABLE();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
141: a23 := JTF_DATE_TABLE();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
142: a24 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
150: a6 := JTF_VARCHAR2_TABLE_500();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
150: a6 := JTF_VARCHAR2_TABLE_500();
151: a7 := JTF_VARCHAR2_TABLE_500();
160: a16 := JTF_VARCHAR2_TABLE_500();
161: a17 := JTF_VARCHAR2_TABLE_500();
162: a18 := JTF_VARCHAR2_TABLE_500();
163: a19 := JTF_VARCHAR2_TABLE_500();
164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();
162: a18 := JTF_VARCHAR2_TABLE_500();
163: a19 := JTF_VARCHAR2_TABLE_500();
164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();
169: if t.count > 0 then
170: a0.extend(t.count);
164: a20 := JTF_NUMBER_TABLE();
165: a21 := JTF_DATE_TABLE();
166: a22 := JTF_NUMBER_TABLE();
167: a23 := JTF_DATE_TABLE();
168: a24 := JTF_NUMBER_TABLE();
169: if t.count > 0 then
170: a0.extend(t.count);
171: a1.extend(t.count);
172: a2.extend(t.count);
229: end if;
230: end if;
231: end rosetta_table_copy_out_p2;
232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE
241: , a8 JTF_NUMBER_TABLE
242: , a9 JTF_DATE_TABLE
243: , a10 JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
247: if a0 is not null and a0.count > 0 then
268: end loop;
269: end if;
270: end if;
271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE
280: , a8 out nocopy JTF_NUMBER_TABLE
281: , a9 out nocopy JTF_DATE_TABLE
282: , a10 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_VARCHAR2_TABLE_100();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
295: a8 := JTF_NUMBER_TABLE();
296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: if t.count > 0 then
311: a0.extend(t.count);
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_NUMBER_TABLE();
308: a9 := JTF_DATE_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: if t.count > 0 then
311: a0.extend(t.count);
312: a1.extend(t.count);
313: a2.extend(t.count);
342: end if;
343: end if;
344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
343: end if;
344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000
353: , a7 JTF_VARCHAR2_TABLE_100
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000
353: , a7 JTF_VARCHAR2_TABLE_100
354: , a8 JTF_VARCHAR2_TABLE_500
365: , a19 JTF_VARCHAR2_TABLE_500
366: , a20 JTF_VARCHAR2_TABLE_500
367: , a21 JTF_VARCHAR2_TABLE_500
368: , a22 JTF_VARCHAR2_TABLE_500
369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE
367: , a21 JTF_VARCHAR2_TABLE_500
368: , a22 JTF_VARCHAR2_TABLE_500
369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
369: , a23 JTF_NUMBER_TABLE
370: , a24 JTF_DATE_TABLE
371: , a25 JTF_NUMBER_TABLE
372: , a26 JTF_DATE_TABLE
373: , a27 JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if a0 is not null and a0.count > 0 then
415: end loop;
416: end if;
417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
416: end if;
417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a7 out nocopy JTF_VARCHAR2_TABLE_100
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , a8 out nocopy JTF_VARCHAR2_TABLE_500
438: , a19 out nocopy JTF_VARCHAR2_TABLE_500
439: , a20 out nocopy JTF_VARCHAR2_TABLE_500
440: , a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE
440: , a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE
447: ) as
448: ddindx binary_integer; indx binary_integer;
442: , a23 out nocopy JTF_NUMBER_TABLE
443: , a24 out nocopy JTF_DATE_TABLE
444: , a25 out nocopy JTF_NUMBER_TABLE
445: , a26 out nocopy JTF_DATE_TABLE
446: , a27 out nocopy JTF_NUMBER_TABLE
447: ) as
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then
447: ) as
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();
458: a7 := JTF_VARCHAR2_TABLE_100();
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();
458: a7 := JTF_VARCHAR2_TABLE_100();
459: a8 := JTF_VARCHAR2_TABLE_500();
470: a19 := JTF_VARCHAR2_TABLE_500();
471: a20 := JTF_VARCHAR2_TABLE_500();
472: a21 := JTF_VARCHAR2_TABLE_500();
473: a22 := JTF_VARCHAR2_TABLE_500();
474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
472: a21 := JTF_VARCHAR2_TABLE_500();
473: a22 := JTF_VARCHAR2_TABLE_500();
474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
474: a23 := JTF_NUMBER_TABLE();
475: a24 := JTF_DATE_TABLE();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
476: a25 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
477: a26 := JTF_DATE_TABLE();
478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();
487: a7 := JTF_VARCHAR2_TABLE_100();
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();
487: a7 := JTF_VARCHAR2_TABLE_100();
488: a8 := JTF_VARCHAR2_TABLE_500();
499: a19 := JTF_VARCHAR2_TABLE_500();
500: a20 := JTF_VARCHAR2_TABLE_500();
501: a21 := JTF_VARCHAR2_TABLE_500();
502: a22 := JTF_VARCHAR2_TABLE_500();
503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();
501: a21 := JTF_VARCHAR2_TABLE_500();
502: a22 := JTF_VARCHAR2_TABLE_500();
503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();
508: if t.count > 0 then
509: a0.extend(t.count);
503: a23 := JTF_NUMBER_TABLE();
504: a24 := JTF_DATE_TABLE();
505: a25 := JTF_NUMBER_TABLE();
506: a26 := JTF_DATE_TABLE();
507: a27 := JTF_NUMBER_TABLE();
508: if t.count > 0 then
509: a0.extend(t.count);
510: a1.extend(t.count);
511: a2.extend(t.count);
730: , p_init_msg_list VARCHAR2
731: , x_return_status out nocopy VARCHAR2
732: , x_msg_count out nocopy NUMBER
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
731: , x_return_status out nocopy VARCHAR2
732: , x_msg_count out nocopy NUMBER
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
740: , p5_a6 JTF_VARCHAR2_TABLE_2000
741: , p5_a7 JTF_VARCHAR2_TABLE_100
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
740: , p5_a6 JTF_VARCHAR2_TABLE_2000
741: , p5_a7 JTF_VARCHAR2_TABLE_100
742: , p5_a8 JTF_VARCHAR2_TABLE_500
753: , p5_a19 JTF_VARCHAR2_TABLE_500
754: , p5_a20 JTF_VARCHAR2_TABLE_500
755: , p5_a21 JTF_VARCHAR2_TABLE_500
756: , p5_a22 JTF_VARCHAR2_TABLE_500
757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
755: , p5_a21 JTF_VARCHAR2_TABLE_500
756: , p5_a22 JTF_VARCHAR2_TABLE_500
757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
757: , p5_a23 JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p5_a24 JTF_DATE_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p5_a25 JTF_NUMBER_TABLE
760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
768: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
769: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
768: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
769: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
770: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
781: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
782: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
783: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE
783: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE
790: )
791:
785: , p6_a23 out nocopy JTF_NUMBER_TABLE
786: , p6_a24 out nocopy JTF_DATE_TABLE
787: , p6_a25 out nocopy JTF_NUMBER_TABLE
788: , p6_a26 out nocopy JTF_DATE_TABLE
789: , p6_a27 out nocopy JTF_NUMBER_TABLE
790: )
791:
792: as
793: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
974: , p_init_msg_list VARCHAR2
975: , x_return_status out nocopy VARCHAR2
976: , x_msg_count out nocopy NUMBER
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
975: , x_return_status out nocopy VARCHAR2
976: , x_msg_count out nocopy NUMBER
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000
985: , p5_a7 JTF_VARCHAR2_TABLE_100
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000
985: , p5_a7 JTF_VARCHAR2_TABLE_100
986: , p5_a8 JTF_VARCHAR2_TABLE_500
997: , p5_a19 JTF_VARCHAR2_TABLE_500
998: , p5_a20 JTF_VARCHAR2_TABLE_500
999: , p5_a21 JTF_VARCHAR2_TABLE_500
1000: , p5_a22 JTF_VARCHAR2_TABLE_500
1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE
999: , p5_a21 JTF_VARCHAR2_TABLE_500
1000: , p5_a22 JTF_VARCHAR2_TABLE_500
1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE
1006: )
1007:
1001: , p5_a23 JTF_NUMBER_TABLE
1002: , p5_a24 JTF_DATE_TABLE
1003: , p5_a25 JTF_NUMBER_TABLE
1004: , p5_a26 JTF_DATE_TABLE
1005: , p5_a27 JTF_NUMBER_TABLE
1006: )
1007:
1008: as
1009: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1217: , p_init_msg_list VARCHAR2
1218: , x_return_status out nocopy VARCHAR2
1219: , x_msg_count out nocopy NUMBER
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1218: , x_return_status out nocopy VARCHAR2
1219: , x_msg_count out nocopy NUMBER
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000
1228: , p5_a7 JTF_VARCHAR2_TABLE_100
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000
1228: , p5_a7 JTF_VARCHAR2_TABLE_100
1229: , p5_a8 JTF_VARCHAR2_TABLE_500
1240: , p5_a19 JTF_VARCHAR2_TABLE_500
1241: , p5_a20 JTF_VARCHAR2_TABLE_500
1242: , p5_a21 JTF_VARCHAR2_TABLE_500
1243: , p5_a22 JTF_VARCHAR2_TABLE_500
1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1242: , p5_a21 JTF_VARCHAR2_TABLE_500
1243: , p5_a22 JTF_VARCHAR2_TABLE_500
1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1244: , p5_a23 JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1245: , p5_a24 JTF_DATE_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1246: , p5_a25 JTF_NUMBER_TABLE
1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1268: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1269: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1270: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1270: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1272: , p6_a23 out nocopy JTF_NUMBER_TABLE
1273: , p6_a24 out nocopy JTF_DATE_TABLE
1274: , p6_a25 out nocopy JTF_NUMBER_TABLE
1275: , p6_a26 out nocopy JTF_DATE_TABLE
1276: , p6_a27 out nocopy JTF_NUMBER_TABLE
1277: )
1278:
1279: as
1280: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1461: , p_init_msg_list VARCHAR2
1462: , x_return_status out nocopy VARCHAR2
1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1462: , x_return_status out nocopy VARCHAR2
1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000
1472: , p5_a7 JTF_VARCHAR2_TABLE_100
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000
1472: , p5_a7 JTF_VARCHAR2_TABLE_100
1473: , p5_a8 JTF_VARCHAR2_TABLE_500
1484: , p5_a19 JTF_VARCHAR2_TABLE_500
1485: , p5_a20 JTF_VARCHAR2_TABLE_500
1486: , p5_a21 JTF_VARCHAR2_TABLE_500
1487: , p5_a22 JTF_VARCHAR2_TABLE_500
1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE
1486: , p5_a21 JTF_VARCHAR2_TABLE_500
1487: , p5_a22 JTF_VARCHAR2_TABLE_500
1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE
1493: )
1494:
1488: , p5_a23 JTF_NUMBER_TABLE
1489: , p5_a24 JTF_DATE_TABLE
1490: , p5_a25 JTF_NUMBER_TABLE
1491: , p5_a26 JTF_DATE_TABLE
1492: , p5_a27 JTF_NUMBER_TABLE
1493: )
1494:
1495: as
1496: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;
1644: , p_init_msg_list VARCHAR2
1645: , x_return_status out nocopy VARCHAR2
1646: , x_msg_count out nocopy NUMBER
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1645: , x_return_status out nocopy VARCHAR2
1646: , x_msg_count out nocopy NUMBER
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000
1655: , p5_a7 JTF_VARCHAR2_TABLE_100
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000
1655: , p5_a7 JTF_VARCHAR2_TABLE_100
1656: , p5_a8 JTF_VARCHAR2_TABLE_500
1667: , p5_a19 JTF_VARCHAR2_TABLE_500
1668: , p5_a20 JTF_VARCHAR2_TABLE_500
1669: , p5_a21 JTF_VARCHAR2_TABLE_500
1670: , p5_a22 JTF_VARCHAR2_TABLE_500
1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE
1669: , p5_a21 JTF_VARCHAR2_TABLE_500
1670: , p5_a22 JTF_VARCHAR2_TABLE_500
1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE
1676: )
1677:
1671: , p5_a23 JTF_NUMBER_TABLE
1672: , p5_a24 JTF_DATE_TABLE
1673: , p5_a25 JTF_NUMBER_TABLE
1674: , p5_a26 JTF_DATE_TABLE
1675: , p5_a27 JTF_NUMBER_TABLE
1676: )
1677:
1678: as
1679: ddp_iltv_tbl okl_ilt_pvt.iltv_tbl_type;