10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_template_pvt.ozf_task_template_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_4000
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
13: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_template_pvt.ozf_task_template_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_4000
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_4000
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_NUMBER_TABLE
28: , a15 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_NUMBER_TABLE
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_200
30: , a17 JTF_VARCHAR2_TABLE_200
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_NUMBER_TABLE
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_200
30: , a17 JTF_VARCHAR2_TABLE_200
31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_VARCHAR2_TABLE_200
93: end if;
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t ozf_task_template_pvt.ozf_task_template_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
96: procedure rosetta_table_copy_out_p1(t ozf_task_template_pvt.ozf_task_template_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_VARCHAR2_TABLE_200
113: , a17 out nocopy JTF_VARCHAR2_TABLE_200
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_VARCHAR2_TABLE_200
113: , a17 out nocopy JTF_VARCHAR2_TABLE_200
114: , a18 out nocopy JTF_VARCHAR2_TABLE_200
115: , a19 out nocopy JTF_VARCHAR2_TABLE_200
160: a29 := null;
161: a30 := null;
162: elsif t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_VARCHAR2_TABLE_4000();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_100();
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_VARCHAR2_TABLE_4000();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_NUMBER_TABLE();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_VARCHAR2_TABLE_4000();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_NUMBER_TABLE();
172: a9 := JTF_VARCHAR2_TABLE_100();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_NUMBER_TABLE();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_NUMBER_TABLE();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_NUMBER_TABLE();
176: a13 := JTF_VARCHAR2_TABLE_100();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_NUMBER_TABLE();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_NUMBER_TABLE();
176: a13 := JTF_VARCHAR2_TABLE_100();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_NUMBER_TABLE();
176: a13 := JTF_VARCHAR2_TABLE_100();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_VARCHAR2_TABLE_100();
179: a16 := JTF_VARCHAR2_TABLE_200();
180: a17 := JTF_VARCHAR2_TABLE_200();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_NUMBER_TABLE();
176: a13 := JTF_VARCHAR2_TABLE_100();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_VARCHAR2_TABLE_100();
179: a16 := JTF_VARCHAR2_TABLE_200();
180: a17 := JTF_VARCHAR2_TABLE_200();
181: a18 := JTF_VARCHAR2_TABLE_200();
182: a19 := JTF_VARCHAR2_TABLE_200();
192: a29 := JTF_VARCHAR2_TABLE_200();
193: a30 := JTF_VARCHAR2_TABLE_200();
194: else
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_VARCHAR2_TABLE_100();
197: a2 := JTF_VARCHAR2_TABLE_4000();
198: a3 := JTF_NUMBER_TABLE();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_VARCHAR2_TABLE_100();
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_VARCHAR2_TABLE_100();
197: a2 := JTF_VARCHAR2_TABLE_4000();
198: a3 := JTF_NUMBER_TABLE();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_VARCHAR2_TABLE_100();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_NUMBER_TABLE();
196: a1 := JTF_VARCHAR2_TABLE_100();
197: a2 := JTF_VARCHAR2_TABLE_4000();
198: a3 := JTF_NUMBER_TABLE();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_VARCHAR2_TABLE_100();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_NUMBER_TABLE();
204: a9 := JTF_VARCHAR2_TABLE_100();
198: a3 := JTF_NUMBER_TABLE();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_VARCHAR2_TABLE_100();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_NUMBER_TABLE();
204: a9 := JTF_VARCHAR2_TABLE_100();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_VARCHAR2_TABLE_100();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_NUMBER_TABLE();
204: a9 := JTF_VARCHAR2_TABLE_100();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_VARCHAR2_TABLE_100();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_NUMBER_TABLE();
204: a9 := JTF_VARCHAR2_TABLE_100();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_NUMBER_TABLE();
210: a15 := JTF_VARCHAR2_TABLE_100();
204: a9 := JTF_VARCHAR2_TABLE_100();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_NUMBER_TABLE();
210: a15 := JTF_VARCHAR2_TABLE_100();
211: a16 := JTF_VARCHAR2_TABLE_200();
212: a17 := JTF_VARCHAR2_TABLE_200();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_NUMBER_TABLE();
210: a15 := JTF_VARCHAR2_TABLE_100();
211: a16 := JTF_VARCHAR2_TABLE_200();
212: a17 := JTF_VARCHAR2_TABLE_200();
213: a18 := JTF_VARCHAR2_TABLE_200();
214: a19 := JTF_VARCHAR2_TABLE_200();
355: , x_return_status out nocopy VARCHAR2
356: , x_msg_data out nocopy VARCHAR2
357: , x_msg_count out nocopy NUMBER
358: , p7_a0 JTF_NUMBER_TABLE
359: , p7_a1 JTF_VARCHAR2_TABLE_100
360: , p7_a2 JTF_VARCHAR2_TABLE_4000
361: , p7_a3 JTF_NUMBER_TABLE
362: , p7_a4 JTF_VARCHAR2_TABLE_100
363: , p7_a5 JTF_VARCHAR2_TABLE_100
358: , p7_a0 JTF_NUMBER_TABLE
359: , p7_a1 JTF_VARCHAR2_TABLE_100
360: , p7_a2 JTF_VARCHAR2_TABLE_4000
361: , p7_a3 JTF_NUMBER_TABLE
362: , p7_a4 JTF_VARCHAR2_TABLE_100
363: , p7_a5 JTF_VARCHAR2_TABLE_100
364: , p7_a6 JTF_NUMBER_TABLE
365: , p7_a7 JTF_VARCHAR2_TABLE_100
366: , p7_a8 JTF_NUMBER_TABLE
359: , p7_a1 JTF_VARCHAR2_TABLE_100
360: , p7_a2 JTF_VARCHAR2_TABLE_4000
361: , p7_a3 JTF_NUMBER_TABLE
362: , p7_a4 JTF_VARCHAR2_TABLE_100
363: , p7_a5 JTF_VARCHAR2_TABLE_100
364: , p7_a6 JTF_NUMBER_TABLE
365: , p7_a7 JTF_VARCHAR2_TABLE_100
366: , p7_a8 JTF_NUMBER_TABLE
367: , p7_a9 JTF_VARCHAR2_TABLE_100
361: , p7_a3 JTF_NUMBER_TABLE
362: , p7_a4 JTF_VARCHAR2_TABLE_100
363: , p7_a5 JTF_VARCHAR2_TABLE_100
364: , p7_a6 JTF_NUMBER_TABLE
365: , p7_a7 JTF_VARCHAR2_TABLE_100
366: , p7_a8 JTF_NUMBER_TABLE
367: , p7_a9 JTF_VARCHAR2_TABLE_100
368: , p7_a10 JTF_NUMBER_TABLE
369: , p7_a11 JTF_VARCHAR2_TABLE_100
363: , p7_a5 JTF_VARCHAR2_TABLE_100
364: , p7_a6 JTF_NUMBER_TABLE
365: , p7_a7 JTF_VARCHAR2_TABLE_100
366: , p7_a8 JTF_NUMBER_TABLE
367: , p7_a9 JTF_VARCHAR2_TABLE_100
368: , p7_a10 JTF_NUMBER_TABLE
369: , p7_a11 JTF_VARCHAR2_TABLE_100
370: , p7_a12 JTF_NUMBER_TABLE
371: , p7_a13 JTF_VARCHAR2_TABLE_100
365: , p7_a7 JTF_VARCHAR2_TABLE_100
366: , p7_a8 JTF_NUMBER_TABLE
367: , p7_a9 JTF_VARCHAR2_TABLE_100
368: , p7_a10 JTF_NUMBER_TABLE
369: , p7_a11 JTF_VARCHAR2_TABLE_100
370: , p7_a12 JTF_NUMBER_TABLE
371: , p7_a13 JTF_VARCHAR2_TABLE_100
372: , p7_a14 JTF_NUMBER_TABLE
373: , p7_a15 JTF_VARCHAR2_TABLE_100
367: , p7_a9 JTF_VARCHAR2_TABLE_100
368: , p7_a10 JTF_NUMBER_TABLE
369: , p7_a11 JTF_VARCHAR2_TABLE_100
370: , p7_a12 JTF_NUMBER_TABLE
371: , p7_a13 JTF_VARCHAR2_TABLE_100
372: , p7_a14 JTF_NUMBER_TABLE
373: , p7_a15 JTF_VARCHAR2_TABLE_100
374: , p7_a16 JTF_VARCHAR2_TABLE_200
375: , p7_a17 JTF_VARCHAR2_TABLE_200
369: , p7_a11 JTF_VARCHAR2_TABLE_100
370: , p7_a12 JTF_NUMBER_TABLE
371: , p7_a13 JTF_VARCHAR2_TABLE_100
372: , p7_a14 JTF_NUMBER_TABLE
373: , p7_a15 JTF_VARCHAR2_TABLE_100
374: , p7_a16 JTF_VARCHAR2_TABLE_200
375: , p7_a17 JTF_VARCHAR2_TABLE_200
376: , p7_a18 JTF_VARCHAR2_TABLE_200
377: , p7_a19 JTF_VARCHAR2_TABLE_200
467: , x_return_status out nocopy VARCHAR2
468: , x_msg_data out nocopy VARCHAR2
469: , x_msg_count out nocopy NUMBER
470: , p7_a0 JTF_NUMBER_TABLE
471: , p7_a1 JTF_VARCHAR2_TABLE_100
472: , p7_a2 JTF_VARCHAR2_TABLE_4000
473: , p7_a3 JTF_NUMBER_TABLE
474: , p7_a4 JTF_VARCHAR2_TABLE_100
475: , p7_a5 JTF_VARCHAR2_TABLE_100
470: , p7_a0 JTF_NUMBER_TABLE
471: , p7_a1 JTF_VARCHAR2_TABLE_100
472: , p7_a2 JTF_VARCHAR2_TABLE_4000
473: , p7_a3 JTF_NUMBER_TABLE
474: , p7_a4 JTF_VARCHAR2_TABLE_100
475: , p7_a5 JTF_VARCHAR2_TABLE_100
476: , p7_a6 JTF_NUMBER_TABLE
477: , p7_a7 JTF_VARCHAR2_TABLE_100
478: , p7_a8 JTF_NUMBER_TABLE
471: , p7_a1 JTF_VARCHAR2_TABLE_100
472: , p7_a2 JTF_VARCHAR2_TABLE_4000
473: , p7_a3 JTF_NUMBER_TABLE
474: , p7_a4 JTF_VARCHAR2_TABLE_100
475: , p7_a5 JTF_VARCHAR2_TABLE_100
476: , p7_a6 JTF_NUMBER_TABLE
477: , p7_a7 JTF_VARCHAR2_TABLE_100
478: , p7_a8 JTF_NUMBER_TABLE
479: , p7_a9 JTF_VARCHAR2_TABLE_100
473: , p7_a3 JTF_NUMBER_TABLE
474: , p7_a4 JTF_VARCHAR2_TABLE_100
475: , p7_a5 JTF_VARCHAR2_TABLE_100
476: , p7_a6 JTF_NUMBER_TABLE
477: , p7_a7 JTF_VARCHAR2_TABLE_100
478: , p7_a8 JTF_NUMBER_TABLE
479: , p7_a9 JTF_VARCHAR2_TABLE_100
480: , p7_a10 JTF_NUMBER_TABLE
481: , p7_a11 JTF_VARCHAR2_TABLE_100
475: , p7_a5 JTF_VARCHAR2_TABLE_100
476: , p7_a6 JTF_NUMBER_TABLE
477: , p7_a7 JTF_VARCHAR2_TABLE_100
478: , p7_a8 JTF_NUMBER_TABLE
479: , p7_a9 JTF_VARCHAR2_TABLE_100
480: , p7_a10 JTF_NUMBER_TABLE
481: , p7_a11 JTF_VARCHAR2_TABLE_100
482: , p7_a12 JTF_NUMBER_TABLE
483: , p7_a13 JTF_VARCHAR2_TABLE_100
477: , p7_a7 JTF_VARCHAR2_TABLE_100
478: , p7_a8 JTF_NUMBER_TABLE
479: , p7_a9 JTF_VARCHAR2_TABLE_100
480: , p7_a10 JTF_NUMBER_TABLE
481: , p7_a11 JTF_VARCHAR2_TABLE_100
482: , p7_a12 JTF_NUMBER_TABLE
483: , p7_a13 JTF_VARCHAR2_TABLE_100
484: , p7_a14 JTF_NUMBER_TABLE
485: , p7_a15 JTF_VARCHAR2_TABLE_100
479: , p7_a9 JTF_VARCHAR2_TABLE_100
480: , p7_a10 JTF_NUMBER_TABLE
481: , p7_a11 JTF_VARCHAR2_TABLE_100
482: , p7_a12 JTF_NUMBER_TABLE
483: , p7_a13 JTF_VARCHAR2_TABLE_100
484: , p7_a14 JTF_NUMBER_TABLE
485: , p7_a15 JTF_VARCHAR2_TABLE_100
486: , p7_a16 JTF_VARCHAR2_TABLE_200
487: , p7_a17 JTF_VARCHAR2_TABLE_200
481: , p7_a11 JTF_VARCHAR2_TABLE_100
482: , p7_a12 JTF_NUMBER_TABLE
483: , p7_a13 JTF_VARCHAR2_TABLE_100
484: , p7_a14 JTF_NUMBER_TABLE
485: , p7_a15 JTF_VARCHAR2_TABLE_100
486: , p7_a16 JTF_VARCHAR2_TABLE_200
487: , p7_a17 JTF_VARCHAR2_TABLE_200
488: , p7_a18 JTF_VARCHAR2_TABLE_200
489: , p7_a19 JTF_VARCHAR2_TABLE_200
631: , x_msg_data out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , p_reason_code_id NUMBER
634: , p8_a0 out nocopy JTF_NUMBER_TABLE
635: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
637: , p8_a3 out nocopy JTF_NUMBER_TABLE
638: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
639: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
634: , p8_a0 out nocopy JTF_NUMBER_TABLE
635: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
637: , p8_a3 out nocopy JTF_NUMBER_TABLE
638: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
639: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
640: , p8_a6 out nocopy JTF_NUMBER_TABLE
641: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
642: , p8_a8 out nocopy JTF_NUMBER_TABLE
635: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
637: , p8_a3 out nocopy JTF_NUMBER_TABLE
638: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
639: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
640: , p8_a6 out nocopy JTF_NUMBER_TABLE
641: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
642: , p8_a8 out nocopy JTF_NUMBER_TABLE
643: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
637: , p8_a3 out nocopy JTF_NUMBER_TABLE
638: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
639: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
640: , p8_a6 out nocopy JTF_NUMBER_TABLE
641: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
642: , p8_a8 out nocopy JTF_NUMBER_TABLE
643: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
644: , p8_a10 out nocopy JTF_NUMBER_TABLE
645: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
639: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
640: , p8_a6 out nocopy JTF_NUMBER_TABLE
641: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
642: , p8_a8 out nocopy JTF_NUMBER_TABLE
643: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
644: , p8_a10 out nocopy JTF_NUMBER_TABLE
645: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
646: , p8_a12 out nocopy JTF_NUMBER_TABLE
647: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
641: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
642: , p8_a8 out nocopy JTF_NUMBER_TABLE
643: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
644: , p8_a10 out nocopy JTF_NUMBER_TABLE
645: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
646: , p8_a12 out nocopy JTF_NUMBER_TABLE
647: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
648: , p8_a14 out nocopy JTF_NUMBER_TABLE
649: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
643: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
644: , p8_a10 out nocopy JTF_NUMBER_TABLE
645: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
646: , p8_a12 out nocopy JTF_NUMBER_TABLE
647: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
648: , p8_a14 out nocopy JTF_NUMBER_TABLE
649: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
650: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
651: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
645: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
646: , p8_a12 out nocopy JTF_NUMBER_TABLE
647: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
648: , p8_a14 out nocopy JTF_NUMBER_TABLE
649: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
650: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
651: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
652: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
653: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200