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_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
32: , a10 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_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_DATE_TABLE
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_DATE_TABLE
100: , a5 out nocopy JTF_DATE_TABLE
101: , a6 out nocopy JTF_NUMBER_TABLE
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_DATE_TABLE
100: , a5 out nocopy JTF_DATE_TABLE
101: , a6 out nocopy JTF_NUMBER_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_NUMBER_TABLE
99: , a4 out nocopy JTF_DATE_TABLE
100: , a5 out nocopy JTF_DATE_TABLE
101: , a6 out nocopy JTF_NUMBER_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , a8 out nocopy JTF_VARCHAR2_TABLE_500
104: , a9 out nocopy JTF_VARCHAR2_TABLE_500
105: , a10 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_NUMBER_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_DATE_TABLE();
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_NUMBER_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_DATE_TABLE();
132: a5 := JTF_DATE_TABLE();
133: a6 := 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_NUMBER_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_DATE_TABLE();
132: a5 := JTF_DATE_TABLE();
133: a6 := JTF_NUMBER_TABLE();
134: a7 := JTF_VARCHAR2_TABLE_100();
129: a2 := JTF_NUMBER_TABLE();
130: a3 := JTF_NUMBER_TABLE();
131: a4 := JTF_DATE_TABLE();
132: a5 := JTF_DATE_TABLE();
133: a6 := JTF_NUMBER_TABLE();
134: a7 := JTF_VARCHAR2_TABLE_100();
135: a8 := JTF_VARCHAR2_TABLE_500();
136: a9 := JTF_VARCHAR2_TABLE_500();
137: a10 := 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_NUMBER_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_NUMBER_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_DATE_TABLE();
162: a6 := JTF_NUMBER_TABLE();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_DATE_TABLE();
162: a6 := JTF_NUMBER_TABLE();
163: a7 := JTF_VARCHAR2_TABLE_100();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_DATE_TABLE();
162: a6 := JTF_NUMBER_TABLE();
163: a7 := JTF_VARCHAR2_TABLE_100();
164: a8 := JTF_VARCHAR2_TABLE_500();
165: a9 := JTF_VARCHAR2_TABLE_500();
166: a10 := 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_svf_pvt.okl_service_fees_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_200
256: , a2 JTF_VARCHAR2_TABLE_100
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_VARCHAR2_TABLE_200
259: , a5 JTF_VARCHAR2_TABLE_2000
260: , a6 JTF_NUMBER_TABLE
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
258: , a4 JTF_VARCHAR2_TABLE_200
259: , a5 JTF_VARCHAR2_TABLE_2000
260: , a6 JTF_NUMBER_TABLE
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;
260: , a6 JTF_NUMBER_TABLE
261: , a7 JTF_DATE_TABLE
262: , a8 JTF_NUMBER_TABLE
263: , a9 JTF_DATE_TABLE
264: , a10 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin
268: if a0 is not null and a0.count > 0 then
289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_VARCHAR2_TABLE_100
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_VARCHAR2_TABLE_100
297: , a4 out nocopy JTF_VARCHAR2_TABLE_200
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_VARCHAR2_TABLE_100
297: , a4 out nocopy JTF_VARCHAR2_TABLE_200
298: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
299: , a6 out nocopy JTF_NUMBER_TABLE
300: , a7 out nocopy JTF_DATE_TABLE
301: , a8 out nocopy JTF_NUMBER_TABLE
302: , a9 out nocopy JTF_DATE_TABLE
303: , a10 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_200
298: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
299: , a6 out nocopy JTF_NUMBER_TABLE
300: , a7 out nocopy JTF_DATE_TABLE
301: , a8 out nocopy JTF_NUMBER_TABLE
302: , a9 out nocopy JTF_DATE_TABLE
303: , a10 out nocopy JTF_NUMBER_TABLE
304: ) as
305: ddindx binary_integer; indx binary_integer;
299: , a6 out nocopy JTF_NUMBER_TABLE
300: , a7 out nocopy JTF_DATE_TABLE
301: , a8 out nocopy JTF_NUMBER_TABLE
302: , a9 out nocopy JTF_DATE_TABLE
303: , a10 out nocopy JTF_NUMBER_TABLE
304: ) as
305: ddindx binary_integer; indx binary_integer;
306: begin
307: if t is null or t.count = 0 then
304: ) as
305: ddindx binary_integer; indx binary_integer;
306: begin
307: if t is null or t.count = 0 then
308: a0 := JTF_NUMBER_TABLE();
309: a1 := JTF_VARCHAR2_TABLE_100();
310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_VARCHAR2_TABLE_100();
312: a4 := JTF_VARCHAR2_TABLE_200();
310: a2 := JTF_VARCHAR2_TABLE_100();
311: a3 := JTF_VARCHAR2_TABLE_100();
312: a4 := JTF_VARCHAR2_TABLE_200();
313: a5 := JTF_VARCHAR2_TABLE_2000();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_DATE_TABLE();
318: a10 := JTF_NUMBER_TABLE();
312: a4 := JTF_VARCHAR2_TABLE_200();
313: a5 := JTF_VARCHAR2_TABLE_2000();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_DATE_TABLE();
318: a10 := JTF_NUMBER_TABLE();
319: else
320: a0 := JTF_NUMBER_TABLE();
314: a6 := JTF_NUMBER_TABLE();
315: a7 := JTF_DATE_TABLE();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_DATE_TABLE();
318: a10 := JTF_NUMBER_TABLE();
319: else
320: a0 := JTF_NUMBER_TABLE();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: a2 := JTF_VARCHAR2_TABLE_100();
316: a8 := JTF_NUMBER_TABLE();
317: a9 := JTF_DATE_TABLE();
318: a10 := JTF_NUMBER_TABLE();
319: else
320: a0 := JTF_NUMBER_TABLE();
321: a1 := JTF_VARCHAR2_TABLE_100();
322: a2 := JTF_VARCHAR2_TABLE_100();
323: a3 := JTF_VARCHAR2_TABLE_100();
324: a4 := JTF_VARCHAR2_TABLE_200();
322: a2 := JTF_VARCHAR2_TABLE_100();
323: a3 := JTF_VARCHAR2_TABLE_100();
324: a4 := JTF_VARCHAR2_TABLE_200();
325: a5 := JTF_VARCHAR2_TABLE_2000();
326: a6 := JTF_NUMBER_TABLE();
327: a7 := JTF_DATE_TABLE();
328: a8 := JTF_NUMBER_TABLE();
329: a9 := JTF_DATE_TABLE();
330: a10 := JTF_NUMBER_TABLE();
324: a4 := JTF_VARCHAR2_TABLE_200();
325: a5 := JTF_VARCHAR2_TABLE_2000();
326: a6 := JTF_NUMBER_TABLE();
327: a7 := JTF_DATE_TABLE();
328: a8 := JTF_NUMBER_TABLE();
329: a9 := JTF_DATE_TABLE();
330: a10 := JTF_NUMBER_TABLE();
331: if t.count > 0 then
332: a0.extend(t.count);
326: a6 := JTF_NUMBER_TABLE();
327: a7 := JTF_DATE_TABLE();
328: a8 := JTF_NUMBER_TABLE();
329: a9 := JTF_DATE_TABLE();
330: a10 := JTF_NUMBER_TABLE();
331: if t.count > 0 then
332: a0.extend(t.count);
333: a1.extend(t.count);
334: a2.extend(t.count);
363: end if;
364: end if;
365: end rosetta_table_copy_out_p5;
366:
367: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
368: , a1 JTF_NUMBER_TABLE
369: , a2 JTF_VARCHAR2_TABLE_100
370: , a3 JTF_VARCHAR2_TABLE_100
371: , a4 JTF_VARCHAR2_TABLE_200
364: end if;
365: end rosetta_table_copy_out_p5;
366:
367: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
368: , a1 JTF_NUMBER_TABLE
369: , a2 JTF_VARCHAR2_TABLE_100
370: , a3 JTF_VARCHAR2_TABLE_100
371: , a4 JTF_VARCHAR2_TABLE_200
372: , a5 JTF_VARCHAR2_TABLE_2000
369: , a2 JTF_VARCHAR2_TABLE_100
370: , a3 JTF_VARCHAR2_TABLE_100
371: , a4 JTF_VARCHAR2_TABLE_200
372: , a5 JTF_VARCHAR2_TABLE_2000
373: , a6 JTF_NUMBER_TABLE
374: , a7 JTF_DATE_TABLE
375: , a8 JTF_DATE_TABLE
376: , a9 JTF_NUMBER_TABLE
377: , a10 JTF_VARCHAR2_TABLE_100
372: , a5 JTF_VARCHAR2_TABLE_2000
373: , a6 JTF_NUMBER_TABLE
374: , a7 JTF_DATE_TABLE
375: , a8 JTF_DATE_TABLE
376: , a9 JTF_NUMBER_TABLE
377: , a10 JTF_VARCHAR2_TABLE_100
378: , a11 JTF_VARCHAR2_TABLE_500
379: , a12 JTF_VARCHAR2_TABLE_500
380: , a13 JTF_VARCHAR2_TABLE_500
389: , a22 JTF_VARCHAR2_TABLE_500
390: , a23 JTF_VARCHAR2_TABLE_500
391: , a24 JTF_VARCHAR2_TABLE_500
392: , a25 JTF_VARCHAR2_TABLE_500
393: , a26 JTF_NUMBER_TABLE
394: , a27 JTF_DATE_TABLE
395: , a28 JTF_NUMBER_TABLE
396: , a29 JTF_DATE_TABLE
397: , a30 JTF_NUMBER_TABLE
391: , a24 JTF_VARCHAR2_TABLE_500
392: , a25 JTF_VARCHAR2_TABLE_500
393: , a26 JTF_NUMBER_TABLE
394: , a27 JTF_DATE_TABLE
395: , a28 JTF_NUMBER_TABLE
396: , a29 JTF_DATE_TABLE
397: , a30 JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
393: , a26 JTF_NUMBER_TABLE
394: , a27 JTF_DATE_TABLE
395: , a28 JTF_NUMBER_TABLE
396: , a29 JTF_DATE_TABLE
397: , a30 JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if a0 is not null and a0.count > 0 then
442: end loop;
443: end if;
444: end if;
445: end rosetta_table_copy_in_p8;
446: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
447: , a1 out nocopy JTF_NUMBER_TABLE
448: , a2 out nocopy JTF_VARCHAR2_TABLE_100
449: , a3 out nocopy JTF_VARCHAR2_TABLE_100
450: , a4 out nocopy JTF_VARCHAR2_TABLE_200
443: end if;
444: end if;
445: end rosetta_table_copy_in_p8;
446: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
447: , a1 out nocopy JTF_NUMBER_TABLE
448: , a2 out nocopy JTF_VARCHAR2_TABLE_100
449: , a3 out nocopy JTF_VARCHAR2_TABLE_100
450: , a4 out nocopy JTF_VARCHAR2_TABLE_200
451: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
448: , a2 out nocopy JTF_VARCHAR2_TABLE_100
449: , a3 out nocopy JTF_VARCHAR2_TABLE_100
450: , a4 out nocopy JTF_VARCHAR2_TABLE_200
451: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
452: , a6 out nocopy JTF_NUMBER_TABLE
453: , a7 out nocopy JTF_DATE_TABLE
454: , a8 out nocopy JTF_DATE_TABLE
455: , a9 out nocopy JTF_NUMBER_TABLE
456: , a10 out nocopy JTF_VARCHAR2_TABLE_100
451: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
452: , a6 out nocopy JTF_NUMBER_TABLE
453: , a7 out nocopy JTF_DATE_TABLE
454: , a8 out nocopy JTF_DATE_TABLE
455: , a9 out nocopy JTF_NUMBER_TABLE
456: , a10 out nocopy JTF_VARCHAR2_TABLE_100
457: , a11 out nocopy JTF_VARCHAR2_TABLE_500
458: , a12 out nocopy JTF_VARCHAR2_TABLE_500
459: , a13 out nocopy JTF_VARCHAR2_TABLE_500
468: , a22 out nocopy JTF_VARCHAR2_TABLE_500
469: , a23 out nocopy JTF_VARCHAR2_TABLE_500
470: , a24 out nocopy JTF_VARCHAR2_TABLE_500
471: , a25 out nocopy JTF_VARCHAR2_TABLE_500
472: , a26 out nocopy JTF_NUMBER_TABLE
473: , a27 out nocopy JTF_DATE_TABLE
474: , a28 out nocopy JTF_NUMBER_TABLE
475: , a29 out nocopy JTF_DATE_TABLE
476: , a30 out nocopy JTF_NUMBER_TABLE
470: , a24 out nocopy JTF_VARCHAR2_TABLE_500
471: , a25 out nocopy JTF_VARCHAR2_TABLE_500
472: , a26 out nocopy JTF_NUMBER_TABLE
473: , a27 out nocopy JTF_DATE_TABLE
474: , a28 out nocopy JTF_NUMBER_TABLE
475: , a29 out nocopy JTF_DATE_TABLE
476: , a30 out nocopy JTF_NUMBER_TABLE
477: ) as
478: ddindx binary_integer; indx binary_integer;
472: , a26 out nocopy JTF_NUMBER_TABLE
473: , a27 out nocopy JTF_DATE_TABLE
474: , a28 out nocopy JTF_NUMBER_TABLE
475: , a29 out nocopy JTF_DATE_TABLE
476: , a30 out nocopy JTF_NUMBER_TABLE
477: ) as
478: ddindx binary_integer; indx binary_integer;
479: begin
480: if t is null or t.count = 0 then
477: ) as
478: ddindx binary_integer; indx binary_integer;
479: begin
480: if t is null or t.count = 0 then
481: a0 := JTF_NUMBER_TABLE();
482: a1 := JTF_NUMBER_TABLE();
483: a2 := JTF_VARCHAR2_TABLE_100();
484: a3 := JTF_VARCHAR2_TABLE_100();
485: a4 := JTF_VARCHAR2_TABLE_200();
478: ddindx binary_integer; indx binary_integer;
479: begin
480: if t is null or t.count = 0 then
481: a0 := JTF_NUMBER_TABLE();
482: a1 := JTF_NUMBER_TABLE();
483: a2 := JTF_VARCHAR2_TABLE_100();
484: a3 := JTF_VARCHAR2_TABLE_100();
485: a4 := JTF_VARCHAR2_TABLE_200();
486: a5 := JTF_VARCHAR2_TABLE_2000();
483: a2 := JTF_VARCHAR2_TABLE_100();
484: a3 := JTF_VARCHAR2_TABLE_100();
485: a4 := JTF_VARCHAR2_TABLE_200();
486: a5 := JTF_VARCHAR2_TABLE_2000();
487: a6 := JTF_NUMBER_TABLE();
488: a7 := JTF_DATE_TABLE();
489: a8 := JTF_DATE_TABLE();
490: a9 := JTF_NUMBER_TABLE();
491: a10 := JTF_VARCHAR2_TABLE_100();
486: a5 := JTF_VARCHAR2_TABLE_2000();
487: a6 := JTF_NUMBER_TABLE();
488: a7 := JTF_DATE_TABLE();
489: a8 := JTF_DATE_TABLE();
490: a9 := JTF_NUMBER_TABLE();
491: a10 := JTF_VARCHAR2_TABLE_100();
492: a11 := JTF_VARCHAR2_TABLE_500();
493: a12 := JTF_VARCHAR2_TABLE_500();
494: a13 := JTF_VARCHAR2_TABLE_500();
503: a22 := JTF_VARCHAR2_TABLE_500();
504: a23 := JTF_VARCHAR2_TABLE_500();
505: a24 := JTF_VARCHAR2_TABLE_500();
506: a25 := JTF_VARCHAR2_TABLE_500();
507: a26 := JTF_NUMBER_TABLE();
508: a27 := JTF_DATE_TABLE();
509: a28 := JTF_NUMBER_TABLE();
510: a29 := JTF_DATE_TABLE();
511: a30 := JTF_NUMBER_TABLE();
505: a24 := JTF_VARCHAR2_TABLE_500();
506: a25 := JTF_VARCHAR2_TABLE_500();
507: a26 := JTF_NUMBER_TABLE();
508: a27 := JTF_DATE_TABLE();
509: a28 := JTF_NUMBER_TABLE();
510: a29 := JTF_DATE_TABLE();
511: a30 := JTF_NUMBER_TABLE();
512: else
513: a0 := JTF_NUMBER_TABLE();
507: a26 := JTF_NUMBER_TABLE();
508: a27 := JTF_DATE_TABLE();
509: a28 := JTF_NUMBER_TABLE();
510: a29 := JTF_DATE_TABLE();
511: a30 := JTF_NUMBER_TABLE();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_VARCHAR2_TABLE_100();
509: a28 := JTF_NUMBER_TABLE();
510: a29 := JTF_DATE_TABLE();
511: a30 := JTF_NUMBER_TABLE();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_VARCHAR2_TABLE_100();
516: a3 := JTF_VARCHAR2_TABLE_100();
517: a4 := JTF_VARCHAR2_TABLE_200();
510: a29 := JTF_DATE_TABLE();
511: a30 := JTF_NUMBER_TABLE();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_VARCHAR2_TABLE_100();
516: a3 := JTF_VARCHAR2_TABLE_100();
517: a4 := JTF_VARCHAR2_TABLE_200();
518: a5 := JTF_VARCHAR2_TABLE_2000();
515: a2 := JTF_VARCHAR2_TABLE_100();
516: a3 := JTF_VARCHAR2_TABLE_100();
517: a4 := JTF_VARCHAR2_TABLE_200();
518: a5 := JTF_VARCHAR2_TABLE_2000();
519: a6 := JTF_NUMBER_TABLE();
520: a7 := JTF_DATE_TABLE();
521: a8 := JTF_DATE_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_VARCHAR2_TABLE_100();
518: a5 := JTF_VARCHAR2_TABLE_2000();
519: a6 := JTF_NUMBER_TABLE();
520: a7 := JTF_DATE_TABLE();
521: a8 := JTF_DATE_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_VARCHAR2_TABLE_100();
524: a11 := JTF_VARCHAR2_TABLE_500();
525: a12 := JTF_VARCHAR2_TABLE_500();
526: a13 := JTF_VARCHAR2_TABLE_500();
535: a22 := JTF_VARCHAR2_TABLE_500();
536: a23 := JTF_VARCHAR2_TABLE_500();
537: a24 := JTF_VARCHAR2_TABLE_500();
538: a25 := JTF_VARCHAR2_TABLE_500();
539: a26 := JTF_NUMBER_TABLE();
540: a27 := JTF_DATE_TABLE();
541: a28 := JTF_NUMBER_TABLE();
542: a29 := JTF_DATE_TABLE();
543: a30 := JTF_NUMBER_TABLE();
537: a24 := JTF_VARCHAR2_TABLE_500();
538: a25 := JTF_VARCHAR2_TABLE_500();
539: a26 := JTF_NUMBER_TABLE();
540: a27 := JTF_DATE_TABLE();
541: a28 := JTF_NUMBER_TABLE();
542: a29 := JTF_DATE_TABLE();
543: a30 := JTF_NUMBER_TABLE();
544: if t.count > 0 then
545: a0.extend(t.count);
539: a26 := JTF_NUMBER_TABLE();
540: a27 := JTF_DATE_TABLE();
541: a28 := JTF_NUMBER_TABLE();
542: a29 := JTF_DATE_TABLE();
543: a30 := JTF_NUMBER_TABLE();
544: if t.count > 0 then
545: a0.extend(t.count);
546: a1.extend(t.count);
547: a2.extend(t.count);
784: , p_init_msg_list VARCHAR2
785: , x_return_status out nocopy VARCHAR2
786: , x_msg_count out nocopy NUMBER
787: , x_msg_data out nocopy VARCHAR2
788: , p5_a0 JTF_NUMBER_TABLE
789: , p5_a1 JTF_NUMBER_TABLE
790: , p5_a2 JTF_VARCHAR2_TABLE_100
791: , p5_a3 JTF_VARCHAR2_TABLE_100
792: , p5_a4 JTF_VARCHAR2_TABLE_200
785: , x_return_status out nocopy VARCHAR2
786: , x_msg_count out nocopy NUMBER
787: , x_msg_data out nocopy VARCHAR2
788: , p5_a0 JTF_NUMBER_TABLE
789: , p5_a1 JTF_NUMBER_TABLE
790: , p5_a2 JTF_VARCHAR2_TABLE_100
791: , p5_a3 JTF_VARCHAR2_TABLE_100
792: , p5_a4 JTF_VARCHAR2_TABLE_200
793: , p5_a5 JTF_VARCHAR2_TABLE_2000
790: , p5_a2 JTF_VARCHAR2_TABLE_100
791: , p5_a3 JTF_VARCHAR2_TABLE_100
792: , p5_a4 JTF_VARCHAR2_TABLE_200
793: , p5_a5 JTF_VARCHAR2_TABLE_2000
794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_DATE_TABLE
796: , p5_a8 JTF_DATE_TABLE
797: , p5_a9 JTF_NUMBER_TABLE
798: , p5_a10 JTF_VARCHAR2_TABLE_100
793: , p5_a5 JTF_VARCHAR2_TABLE_2000
794: , p5_a6 JTF_NUMBER_TABLE
795: , p5_a7 JTF_DATE_TABLE
796: , p5_a8 JTF_DATE_TABLE
797: , p5_a9 JTF_NUMBER_TABLE
798: , p5_a10 JTF_VARCHAR2_TABLE_100
799: , p5_a11 JTF_VARCHAR2_TABLE_500
800: , p5_a12 JTF_VARCHAR2_TABLE_500
801: , p5_a13 JTF_VARCHAR2_TABLE_500
810: , p5_a22 JTF_VARCHAR2_TABLE_500
811: , p5_a23 JTF_VARCHAR2_TABLE_500
812: , p5_a24 JTF_VARCHAR2_TABLE_500
813: , p5_a25 JTF_VARCHAR2_TABLE_500
814: , p5_a26 JTF_NUMBER_TABLE
815: , p5_a27 JTF_DATE_TABLE
816: , p5_a28 JTF_NUMBER_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_NUMBER_TABLE
812: , p5_a24 JTF_VARCHAR2_TABLE_500
813: , p5_a25 JTF_VARCHAR2_TABLE_500
814: , p5_a26 JTF_NUMBER_TABLE
815: , p5_a27 JTF_DATE_TABLE
816: , p5_a28 JTF_NUMBER_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_NUMBER_TABLE
819: , p6_a0 out nocopy JTF_NUMBER_TABLE
820: , p6_a1 out nocopy JTF_NUMBER_TABLE
814: , p5_a26 JTF_NUMBER_TABLE
815: , p5_a27 JTF_DATE_TABLE
816: , p5_a28 JTF_NUMBER_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_NUMBER_TABLE
819: , p6_a0 out nocopy JTF_NUMBER_TABLE
820: , p6_a1 out nocopy JTF_NUMBER_TABLE
821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
822: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
815: , p5_a27 JTF_DATE_TABLE
816: , p5_a28 JTF_NUMBER_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_NUMBER_TABLE
819: , p6_a0 out nocopy JTF_NUMBER_TABLE
820: , p6_a1 out nocopy JTF_NUMBER_TABLE
821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
822: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
823: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
816: , p5_a28 JTF_NUMBER_TABLE
817: , p5_a29 JTF_DATE_TABLE
818: , p5_a30 JTF_NUMBER_TABLE
819: , p6_a0 out nocopy JTF_NUMBER_TABLE
820: , p6_a1 out nocopy JTF_NUMBER_TABLE
821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
822: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
823: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
824: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
822: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
823: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
824: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
825: , p6_a6 out nocopy JTF_NUMBER_TABLE
826: , p6_a7 out nocopy JTF_DATE_TABLE
827: , p6_a8 out nocopy JTF_DATE_TABLE
828: , p6_a9 out nocopy JTF_NUMBER_TABLE
829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
824: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
825: , p6_a6 out nocopy JTF_NUMBER_TABLE
826: , p6_a7 out nocopy JTF_DATE_TABLE
827: , p6_a8 out nocopy JTF_DATE_TABLE
828: , p6_a9 out nocopy JTF_NUMBER_TABLE
829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
831: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
832: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
841: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
842: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
843: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
844: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
845: , p6_a26 out nocopy JTF_NUMBER_TABLE
846: , p6_a27 out nocopy JTF_DATE_TABLE
847: , p6_a28 out nocopy JTF_NUMBER_TABLE
848: , p6_a29 out nocopy JTF_DATE_TABLE
849: , p6_a30 out nocopy JTF_NUMBER_TABLE
843: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
844: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
845: , p6_a26 out nocopy JTF_NUMBER_TABLE
846: , p6_a27 out nocopy JTF_DATE_TABLE
847: , p6_a28 out nocopy JTF_NUMBER_TABLE
848: , p6_a29 out nocopy JTF_DATE_TABLE
849: , p6_a30 out nocopy JTF_NUMBER_TABLE
850: )
851:
845: , p6_a26 out nocopy JTF_NUMBER_TABLE
846: , p6_a27 out nocopy JTF_DATE_TABLE
847: , p6_a28 out nocopy JTF_NUMBER_TABLE
848: , p6_a29 out nocopy JTF_DATE_TABLE
849: , p6_a30 out nocopy JTF_NUMBER_TABLE
850: )
851:
852: as
853: ddp_svfv_tbl okl_svf_pvt.svfv_tbl_type;
1046: , p_init_msg_list VARCHAR2
1047: , x_return_status out nocopy VARCHAR2
1048: , x_msg_count out nocopy NUMBER
1049: , x_msg_data out nocopy VARCHAR2
1050: , p5_a0 JTF_NUMBER_TABLE
1051: , p5_a1 JTF_NUMBER_TABLE
1052: , p5_a2 JTF_VARCHAR2_TABLE_100
1053: , p5_a3 JTF_VARCHAR2_TABLE_100
1054: , p5_a4 JTF_VARCHAR2_TABLE_200
1047: , x_return_status out nocopy VARCHAR2
1048: , x_msg_count out nocopy NUMBER
1049: , x_msg_data out nocopy VARCHAR2
1050: , p5_a0 JTF_NUMBER_TABLE
1051: , p5_a1 JTF_NUMBER_TABLE
1052: , p5_a2 JTF_VARCHAR2_TABLE_100
1053: , p5_a3 JTF_VARCHAR2_TABLE_100
1054: , p5_a4 JTF_VARCHAR2_TABLE_200
1055: , p5_a5 JTF_VARCHAR2_TABLE_2000
1052: , p5_a2 JTF_VARCHAR2_TABLE_100
1053: , p5_a3 JTF_VARCHAR2_TABLE_100
1054: , p5_a4 JTF_VARCHAR2_TABLE_200
1055: , p5_a5 JTF_VARCHAR2_TABLE_2000
1056: , p5_a6 JTF_NUMBER_TABLE
1057: , p5_a7 JTF_DATE_TABLE
1058: , p5_a8 JTF_DATE_TABLE
1059: , p5_a9 JTF_NUMBER_TABLE
1060: , p5_a10 JTF_VARCHAR2_TABLE_100
1055: , p5_a5 JTF_VARCHAR2_TABLE_2000
1056: , p5_a6 JTF_NUMBER_TABLE
1057: , p5_a7 JTF_DATE_TABLE
1058: , p5_a8 JTF_DATE_TABLE
1059: , p5_a9 JTF_NUMBER_TABLE
1060: , p5_a10 JTF_VARCHAR2_TABLE_100
1061: , p5_a11 JTF_VARCHAR2_TABLE_500
1062: , p5_a12 JTF_VARCHAR2_TABLE_500
1063: , p5_a13 JTF_VARCHAR2_TABLE_500
1072: , p5_a22 JTF_VARCHAR2_TABLE_500
1073: , p5_a23 JTF_VARCHAR2_TABLE_500
1074: , p5_a24 JTF_VARCHAR2_TABLE_500
1075: , p5_a25 JTF_VARCHAR2_TABLE_500
1076: , p5_a26 JTF_NUMBER_TABLE
1077: , p5_a27 JTF_DATE_TABLE
1078: , p5_a28 JTF_NUMBER_TABLE
1079: , p5_a29 JTF_DATE_TABLE
1080: , p5_a30 JTF_NUMBER_TABLE
1074: , p5_a24 JTF_VARCHAR2_TABLE_500
1075: , p5_a25 JTF_VARCHAR2_TABLE_500
1076: , p5_a26 JTF_NUMBER_TABLE
1077: , p5_a27 JTF_DATE_TABLE
1078: , p5_a28 JTF_NUMBER_TABLE
1079: , p5_a29 JTF_DATE_TABLE
1080: , p5_a30 JTF_NUMBER_TABLE
1081: )
1082:
1076: , p5_a26 JTF_NUMBER_TABLE
1077: , p5_a27 JTF_DATE_TABLE
1078: , p5_a28 JTF_NUMBER_TABLE
1079: , p5_a29 JTF_DATE_TABLE
1080: , p5_a30 JTF_NUMBER_TABLE
1081: )
1082:
1083: as
1084: ddp_svfv_tbl okl_svf_pvt.svfv_tbl_type;
1307: , p_init_msg_list VARCHAR2
1308: , x_return_status out nocopy VARCHAR2
1309: , x_msg_count out nocopy NUMBER
1310: , x_msg_data out nocopy VARCHAR2
1311: , p5_a0 JTF_NUMBER_TABLE
1312: , p5_a1 JTF_NUMBER_TABLE
1313: , p5_a2 JTF_VARCHAR2_TABLE_100
1314: , p5_a3 JTF_VARCHAR2_TABLE_100
1315: , p5_a4 JTF_VARCHAR2_TABLE_200
1308: , x_return_status out nocopy VARCHAR2
1309: , x_msg_count out nocopy NUMBER
1310: , x_msg_data out nocopy VARCHAR2
1311: , p5_a0 JTF_NUMBER_TABLE
1312: , p5_a1 JTF_NUMBER_TABLE
1313: , p5_a2 JTF_VARCHAR2_TABLE_100
1314: , p5_a3 JTF_VARCHAR2_TABLE_100
1315: , p5_a4 JTF_VARCHAR2_TABLE_200
1316: , p5_a5 JTF_VARCHAR2_TABLE_2000
1313: , p5_a2 JTF_VARCHAR2_TABLE_100
1314: , p5_a3 JTF_VARCHAR2_TABLE_100
1315: , p5_a4 JTF_VARCHAR2_TABLE_200
1316: , p5_a5 JTF_VARCHAR2_TABLE_2000
1317: , p5_a6 JTF_NUMBER_TABLE
1318: , p5_a7 JTF_DATE_TABLE
1319: , p5_a8 JTF_DATE_TABLE
1320: , p5_a9 JTF_NUMBER_TABLE
1321: , p5_a10 JTF_VARCHAR2_TABLE_100
1316: , p5_a5 JTF_VARCHAR2_TABLE_2000
1317: , p5_a6 JTF_NUMBER_TABLE
1318: , p5_a7 JTF_DATE_TABLE
1319: , p5_a8 JTF_DATE_TABLE
1320: , p5_a9 JTF_NUMBER_TABLE
1321: , p5_a10 JTF_VARCHAR2_TABLE_100
1322: , p5_a11 JTF_VARCHAR2_TABLE_500
1323: , p5_a12 JTF_VARCHAR2_TABLE_500
1324: , p5_a13 JTF_VARCHAR2_TABLE_500
1333: , p5_a22 JTF_VARCHAR2_TABLE_500
1334: , p5_a23 JTF_VARCHAR2_TABLE_500
1335: , p5_a24 JTF_VARCHAR2_TABLE_500
1336: , p5_a25 JTF_VARCHAR2_TABLE_500
1337: , p5_a26 JTF_NUMBER_TABLE
1338: , p5_a27 JTF_DATE_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1335: , p5_a24 JTF_VARCHAR2_TABLE_500
1336: , p5_a25 JTF_VARCHAR2_TABLE_500
1337: , p5_a26 JTF_NUMBER_TABLE
1338: , p5_a27 JTF_DATE_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p6_a0 out nocopy JTF_NUMBER_TABLE
1343: , p6_a1 out nocopy JTF_NUMBER_TABLE
1337: , p5_a26 JTF_NUMBER_TABLE
1338: , p5_a27 JTF_DATE_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p6_a0 out nocopy JTF_NUMBER_TABLE
1343: , p6_a1 out nocopy JTF_NUMBER_TABLE
1344: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1345: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1338: , p5_a27 JTF_DATE_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p6_a0 out nocopy JTF_NUMBER_TABLE
1343: , p6_a1 out nocopy JTF_NUMBER_TABLE
1344: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1345: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p6_a0 out nocopy JTF_NUMBER_TABLE
1343: , p6_a1 out nocopy JTF_NUMBER_TABLE
1344: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1345: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1347: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1344: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1345: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1347: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1348: , p6_a6 out nocopy JTF_NUMBER_TABLE
1349: , p6_a7 out nocopy JTF_DATE_TABLE
1350: , p6_a8 out nocopy JTF_DATE_TABLE
1351: , p6_a9 out nocopy JTF_NUMBER_TABLE
1352: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1347: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1348: , p6_a6 out nocopy JTF_NUMBER_TABLE
1349: , p6_a7 out nocopy JTF_DATE_TABLE
1350: , p6_a8 out nocopy JTF_DATE_TABLE
1351: , p6_a9 out nocopy JTF_NUMBER_TABLE
1352: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1353: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1354: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1355: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1364: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1365: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1366: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1367: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1368: , p6_a26 out nocopy JTF_NUMBER_TABLE
1369: , p6_a27 out nocopy JTF_DATE_TABLE
1370: , p6_a28 out nocopy JTF_NUMBER_TABLE
1371: , p6_a29 out nocopy JTF_DATE_TABLE
1372: , p6_a30 out nocopy JTF_NUMBER_TABLE
1366: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1367: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1368: , p6_a26 out nocopy JTF_NUMBER_TABLE
1369: , p6_a27 out nocopy JTF_DATE_TABLE
1370: , p6_a28 out nocopy JTF_NUMBER_TABLE
1371: , p6_a29 out nocopy JTF_DATE_TABLE
1372: , p6_a30 out nocopy JTF_NUMBER_TABLE
1373: )
1374:
1368: , p6_a26 out nocopy JTF_NUMBER_TABLE
1369: , p6_a27 out nocopy JTF_DATE_TABLE
1370: , p6_a28 out nocopy JTF_NUMBER_TABLE
1371: , p6_a29 out nocopy JTF_DATE_TABLE
1372: , p6_a30 out nocopy JTF_NUMBER_TABLE
1373: )
1374:
1375: as
1376: ddp_svfv_tbl okl_svf_pvt.svfv_tbl_type;
1569: , p_init_msg_list VARCHAR2
1570: , x_return_status out nocopy VARCHAR2
1571: , x_msg_count out nocopy NUMBER
1572: , x_msg_data out nocopy VARCHAR2
1573: , p5_a0 JTF_NUMBER_TABLE
1574: , p5_a1 JTF_NUMBER_TABLE
1575: , p5_a2 JTF_VARCHAR2_TABLE_100
1576: , p5_a3 JTF_VARCHAR2_TABLE_100
1577: , p5_a4 JTF_VARCHAR2_TABLE_200
1570: , x_return_status out nocopy VARCHAR2
1571: , x_msg_count out nocopy NUMBER
1572: , x_msg_data out nocopy VARCHAR2
1573: , p5_a0 JTF_NUMBER_TABLE
1574: , p5_a1 JTF_NUMBER_TABLE
1575: , p5_a2 JTF_VARCHAR2_TABLE_100
1576: , p5_a3 JTF_VARCHAR2_TABLE_100
1577: , p5_a4 JTF_VARCHAR2_TABLE_200
1578: , p5_a5 JTF_VARCHAR2_TABLE_2000
1575: , p5_a2 JTF_VARCHAR2_TABLE_100
1576: , p5_a3 JTF_VARCHAR2_TABLE_100
1577: , p5_a4 JTF_VARCHAR2_TABLE_200
1578: , p5_a5 JTF_VARCHAR2_TABLE_2000
1579: , p5_a6 JTF_NUMBER_TABLE
1580: , p5_a7 JTF_DATE_TABLE
1581: , p5_a8 JTF_DATE_TABLE
1582: , p5_a9 JTF_NUMBER_TABLE
1583: , p5_a10 JTF_VARCHAR2_TABLE_100
1578: , p5_a5 JTF_VARCHAR2_TABLE_2000
1579: , p5_a6 JTF_NUMBER_TABLE
1580: , p5_a7 JTF_DATE_TABLE
1581: , p5_a8 JTF_DATE_TABLE
1582: , p5_a9 JTF_NUMBER_TABLE
1583: , p5_a10 JTF_VARCHAR2_TABLE_100
1584: , p5_a11 JTF_VARCHAR2_TABLE_500
1585: , p5_a12 JTF_VARCHAR2_TABLE_500
1586: , p5_a13 JTF_VARCHAR2_TABLE_500
1595: , p5_a22 JTF_VARCHAR2_TABLE_500
1596: , p5_a23 JTF_VARCHAR2_TABLE_500
1597: , p5_a24 JTF_VARCHAR2_TABLE_500
1598: , p5_a25 JTF_VARCHAR2_TABLE_500
1599: , p5_a26 JTF_NUMBER_TABLE
1600: , p5_a27 JTF_DATE_TABLE
1601: , p5_a28 JTF_NUMBER_TABLE
1602: , p5_a29 JTF_DATE_TABLE
1603: , p5_a30 JTF_NUMBER_TABLE
1597: , p5_a24 JTF_VARCHAR2_TABLE_500
1598: , p5_a25 JTF_VARCHAR2_TABLE_500
1599: , p5_a26 JTF_NUMBER_TABLE
1600: , p5_a27 JTF_DATE_TABLE
1601: , p5_a28 JTF_NUMBER_TABLE
1602: , p5_a29 JTF_DATE_TABLE
1603: , p5_a30 JTF_NUMBER_TABLE
1604: )
1605:
1599: , p5_a26 JTF_NUMBER_TABLE
1600: , p5_a27 JTF_DATE_TABLE
1601: , p5_a28 JTF_NUMBER_TABLE
1602: , p5_a29 JTF_DATE_TABLE
1603: , p5_a30 JTF_NUMBER_TABLE
1604: )
1605:
1606: as
1607: ddp_svfv_tbl okl_svf_pvt.svfv_tbl_type;
1764: , p_init_msg_list VARCHAR2
1765: , x_return_status out nocopy VARCHAR2
1766: , x_msg_count out nocopy NUMBER
1767: , x_msg_data out nocopy VARCHAR2
1768: , p5_a0 JTF_NUMBER_TABLE
1769: , p5_a1 JTF_NUMBER_TABLE
1770: , p5_a2 JTF_VARCHAR2_TABLE_100
1771: , p5_a3 JTF_VARCHAR2_TABLE_100
1772: , p5_a4 JTF_VARCHAR2_TABLE_200
1765: , x_return_status out nocopy VARCHAR2
1766: , x_msg_count out nocopy NUMBER
1767: , x_msg_data out nocopy VARCHAR2
1768: , p5_a0 JTF_NUMBER_TABLE
1769: , p5_a1 JTF_NUMBER_TABLE
1770: , p5_a2 JTF_VARCHAR2_TABLE_100
1771: , p5_a3 JTF_VARCHAR2_TABLE_100
1772: , p5_a4 JTF_VARCHAR2_TABLE_200
1773: , p5_a5 JTF_VARCHAR2_TABLE_2000
1770: , p5_a2 JTF_VARCHAR2_TABLE_100
1771: , p5_a3 JTF_VARCHAR2_TABLE_100
1772: , p5_a4 JTF_VARCHAR2_TABLE_200
1773: , p5_a5 JTF_VARCHAR2_TABLE_2000
1774: , p5_a6 JTF_NUMBER_TABLE
1775: , p5_a7 JTF_DATE_TABLE
1776: , p5_a8 JTF_DATE_TABLE
1777: , p5_a9 JTF_NUMBER_TABLE
1778: , p5_a10 JTF_VARCHAR2_TABLE_100
1773: , p5_a5 JTF_VARCHAR2_TABLE_2000
1774: , p5_a6 JTF_NUMBER_TABLE
1775: , p5_a7 JTF_DATE_TABLE
1776: , p5_a8 JTF_DATE_TABLE
1777: , p5_a9 JTF_NUMBER_TABLE
1778: , p5_a10 JTF_VARCHAR2_TABLE_100
1779: , p5_a11 JTF_VARCHAR2_TABLE_500
1780: , p5_a12 JTF_VARCHAR2_TABLE_500
1781: , p5_a13 JTF_VARCHAR2_TABLE_500
1790: , p5_a22 JTF_VARCHAR2_TABLE_500
1791: , p5_a23 JTF_VARCHAR2_TABLE_500
1792: , p5_a24 JTF_VARCHAR2_TABLE_500
1793: , p5_a25 JTF_VARCHAR2_TABLE_500
1794: , p5_a26 JTF_NUMBER_TABLE
1795: , p5_a27 JTF_DATE_TABLE
1796: , p5_a28 JTF_NUMBER_TABLE
1797: , p5_a29 JTF_DATE_TABLE
1798: , p5_a30 JTF_NUMBER_TABLE
1792: , p5_a24 JTF_VARCHAR2_TABLE_500
1793: , p5_a25 JTF_VARCHAR2_TABLE_500
1794: , p5_a26 JTF_NUMBER_TABLE
1795: , p5_a27 JTF_DATE_TABLE
1796: , p5_a28 JTF_NUMBER_TABLE
1797: , p5_a29 JTF_DATE_TABLE
1798: , p5_a30 JTF_NUMBER_TABLE
1799: )
1800:
1794: , p5_a26 JTF_NUMBER_TABLE
1795: , p5_a27 JTF_DATE_TABLE
1796: , p5_a28 JTF_NUMBER_TABLE
1797: , p5_a29 JTF_DATE_TABLE
1798: , p5_a30 JTF_NUMBER_TABLE
1799: )
1800:
1801: as
1802: ddp_svfv_tbl okl_svf_pvt.svfv_tbl_type;