20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_VARCHAR2_TABLE_100
133: , a18 out nocopy JTF_VARCHAR2_TABLE_500
134: , a19 out nocopy JTF_VARCHAR2_TABLE_500
135: , a20 out nocopy JTF_VARCHAR2_TABLE_500
136: , a21 out nocopy JTF_VARCHAR2_TABLE_500
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_500();
176: a19 := JTF_VARCHAR2_TABLE_500();
177: a20 := JTF_VARCHAR2_TABLE_500();
178: a21 := JTF_VARCHAR2_TABLE_500();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();
213: a17 := JTF_VARCHAR2_TABLE_100();
214: a18 := JTF_VARCHAR2_TABLE_500();
215: a19 := JTF_VARCHAR2_TABLE_500();
216: a20 := JTF_VARCHAR2_TABLE_500();
217: a21 := JTF_VARCHAR2_TABLE_500();
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
333: , a9 JTF_DATE_TABLE
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
372: , a9 out nocopy JTF_DATE_TABLE
377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
399: a9 := JTF_DATE_TABLE();
435: end rosetta_table_copy_out_p5;
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE
451: , a14 JTF_VARCHAR2_TABLE_100
452: , a15 JTF_VARCHAR2_TABLE_500
453: , a16 JTF_VARCHAR2_TABLE_500
454: , a17 JTF_VARCHAR2_TABLE_500
455: , a18 JTF_VARCHAR2_TABLE_500
522: end if;
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE
538: , a14 out nocopy JTF_VARCHAR2_TABLE_100
539: , a15 out nocopy JTF_VARCHAR2_TABLE_500
540: , a16 out nocopy JTF_VARCHAR2_TABLE_500
541: , a17 out nocopy JTF_VARCHAR2_TABLE_500
542: , a18 out nocopy JTF_VARCHAR2_TABLE_500
561: begin
562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();
577: a14 := JTF_VARCHAR2_TABLE_100();
578: a15 := JTF_VARCHAR2_TABLE_500();
579: a16 := JTF_VARCHAR2_TABLE_500();
580: a17 := JTF_VARCHAR2_TABLE_500();
581: a18 := JTF_VARCHAR2_TABLE_500();
597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();
613: a14 := JTF_VARCHAR2_TABLE_100();
614: a15 := JTF_VARCHAR2_TABLE_500();
615: a16 := JTF_VARCHAR2_TABLE_500();
616: a17 := JTF_VARCHAR2_TABLE_500();
617: a18 := JTF_VARCHAR2_TABLE_500();
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE
931: , p5_a17 JTF_VARCHAR2_TABLE_100
932: , p5_a18 JTF_VARCHAR2_TABLE_500
933: , p5_a19 JTF_VARCHAR2_TABLE_500
934: , p5_a20 JTF_VARCHAR2_TABLE_500
935: , p5_a21 JTF_VARCHAR2_TABLE_500
950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE
969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
971: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
972: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
973: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE
1235: , p5_a17 JTF_VARCHAR2_TABLE_100
1236: , p5_a18 JTF_VARCHAR2_TABLE_500
1237: , p5_a19 JTF_VARCHAR2_TABLE_500
1238: , p5_a20 JTF_VARCHAR2_TABLE_500
1239: , p5_a21 JTF_VARCHAR2_TABLE_500
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE
1538: , p5_a17 JTF_VARCHAR2_TABLE_100
1539: , p5_a18 JTF_VARCHAR2_TABLE_500
1540: , p5_a19 JTF_VARCHAR2_TABLE_500
1541: , p5_a20 JTF_VARCHAR2_TABLE_500
1542: , p5_a21 JTF_VARCHAR2_TABLE_500
1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE
1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1578: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1579: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1580: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE
1842: , p5_a17 JTF_VARCHAR2_TABLE_100
1843: , p5_a18 JTF_VARCHAR2_TABLE_500
1844: , p5_a19 JTF_VARCHAR2_TABLE_500
1845: , p5_a20 JTF_VARCHAR2_TABLE_500
1846: , p5_a21 JTF_VARCHAR2_TABLE_500
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE
2065: , p5_a17 JTF_VARCHAR2_TABLE_100
2066: , p5_a18 JTF_VARCHAR2_TABLE_500
2067: , p5_a19 JTF_VARCHAR2_TABLE_500
2068: , p5_a20 JTF_VARCHAR2_TABLE_500
2069: , p5_a21 JTF_VARCHAR2_TABLE_500