1: package body okl_vas_pvt_w as
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package body okl_vas_pvt_w as
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
1: package body okl_vas_pvt_w as
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
2: /* $Header: OKLIVASB.pls 120.0 2005/08/04 23:15:13 manumanu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vas_pvt.vasv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
41: if a0 is not null and a0.count > 0 then
86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_DATE_TABLE
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_DATE_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t okl_vas_pvt.vasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_DATE_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_DATE_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_500
102: , a12 out nocopy JTF_VARCHAR2_TABLE_500
95: , a5 out nocopy JTF_DATE_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a7 out nocopy JTF_VARCHAR2_TABLE_100
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_500
102: , a12 out nocopy JTF_VARCHAR2_TABLE_500
103: , a13 out nocopy JTF_VARCHAR2_TABLE_500
112: , a22 out nocopy JTF_VARCHAR2_TABLE_500
113: , a23 out nocopy JTF_VARCHAR2_TABLE_500
114: , a24 out nocopy JTF_VARCHAR2_TABLE_500
115: , a25 out nocopy JTF_VARCHAR2_TABLE_500
116: , a26 out nocopy JTF_NUMBER_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_DATE_TABLE
120: , a30 out nocopy JTF_NUMBER_TABLE
113: , a23 out nocopy JTF_VARCHAR2_TABLE_500
114: , a24 out nocopy JTF_VARCHAR2_TABLE_500
115: , a25 out nocopy JTF_VARCHAR2_TABLE_500
116: , a26 out nocopy JTF_NUMBER_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_DATE_TABLE
120: , a30 out nocopy JTF_NUMBER_TABLE
121: , a31 out nocopy JTF_DATE_TABLE
114: , a24 out nocopy JTF_VARCHAR2_TABLE_500
115: , a25 out nocopy JTF_VARCHAR2_TABLE_500
116: , a26 out nocopy JTF_NUMBER_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_DATE_TABLE
120: , a30 out nocopy JTF_NUMBER_TABLE
121: , a31 out nocopy JTF_DATE_TABLE
122: , a32 out nocopy JTF_NUMBER_TABLE
116: , a26 out nocopy JTF_NUMBER_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_DATE_TABLE
120: , a30 out nocopy JTF_NUMBER_TABLE
121: , a31 out nocopy JTF_DATE_TABLE
122: , a32 out nocopy JTF_NUMBER_TABLE
123: , a33 out nocopy JTF_DATE_TABLE
124: , a34 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_DATE_TABLE
120: , a30 out nocopy JTF_NUMBER_TABLE
121: , a31 out nocopy JTF_DATE_TABLE
122: , a32 out nocopy JTF_NUMBER_TABLE
123: , a33 out nocopy JTF_DATE_TABLE
124: , a34 out nocopy JTF_NUMBER_TABLE
125: ) as
126: ddindx binary_integer; indx binary_integer;
120: , a30 out nocopy JTF_NUMBER_TABLE
121: , a31 out nocopy JTF_DATE_TABLE
122: , a32 out nocopy JTF_NUMBER_TABLE
123: , a33 out nocopy JTF_DATE_TABLE
124: , a34 out nocopy JTF_NUMBER_TABLE
125: ) as
126: ddindx binary_integer; indx binary_integer;
127: begin
128: if t is null or t.count = 0 then
125: ) as
126: ddindx binary_integer; indx binary_integer;
127: begin
128: if t is null or t.count = 0 then
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_DATE_TABLE();
126: ddindx binary_integer; indx binary_integer;
127: begin
128: if t is null or t.count = 0 then
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_DATE_TABLE();
134: a5 := JTF_DATE_TABLE();
127: begin
128: if t is null or t.count = 0 then
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_DATE_TABLE();
134: a5 := JTF_DATE_TABLE();
135: a6 := JTF_VARCHAR2_TABLE_2000();
128: if t is null or t.count = 0 then
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_DATE_TABLE();
134: a5 := JTF_DATE_TABLE();
135: a6 := JTF_VARCHAR2_TABLE_2000();
136: a7 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_DATE_TABLE();
134: a5 := JTF_DATE_TABLE();
135: a6 := JTF_VARCHAR2_TABLE_2000();
136: a7 := JTF_VARCHAR2_TABLE_100();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_VARCHAR2_TABLE_100();
140: a11 := JTF_VARCHAR2_TABLE_500();
141: a12 := JTF_VARCHAR2_TABLE_500();
134: a5 := JTF_DATE_TABLE();
135: a6 := JTF_VARCHAR2_TABLE_2000();
136: a7 := JTF_VARCHAR2_TABLE_100();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_VARCHAR2_TABLE_100();
140: a11 := JTF_VARCHAR2_TABLE_500();
141: a12 := JTF_VARCHAR2_TABLE_500();
142: a13 := JTF_VARCHAR2_TABLE_500();
151: a22 := JTF_VARCHAR2_TABLE_500();
152: a23 := JTF_VARCHAR2_TABLE_500();
153: a24 := JTF_VARCHAR2_TABLE_500();
154: a25 := JTF_VARCHAR2_TABLE_500();
155: a26 := JTF_NUMBER_TABLE();
156: a27 := JTF_NUMBER_TABLE();
157: a28 := JTF_NUMBER_TABLE();
158: a29 := JTF_DATE_TABLE();
159: a30 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_500();
153: a24 := JTF_VARCHAR2_TABLE_500();
154: a25 := JTF_VARCHAR2_TABLE_500();
155: a26 := JTF_NUMBER_TABLE();
156: a27 := JTF_NUMBER_TABLE();
157: a28 := JTF_NUMBER_TABLE();
158: a29 := JTF_DATE_TABLE();
159: a30 := JTF_NUMBER_TABLE();
160: a31 := JTF_DATE_TABLE();
153: a24 := JTF_VARCHAR2_TABLE_500();
154: a25 := JTF_VARCHAR2_TABLE_500();
155: a26 := JTF_NUMBER_TABLE();
156: a27 := JTF_NUMBER_TABLE();
157: a28 := JTF_NUMBER_TABLE();
158: a29 := JTF_DATE_TABLE();
159: a30 := JTF_NUMBER_TABLE();
160: a31 := JTF_DATE_TABLE();
161: a32 := JTF_NUMBER_TABLE();
155: a26 := JTF_NUMBER_TABLE();
156: a27 := JTF_NUMBER_TABLE();
157: a28 := JTF_NUMBER_TABLE();
158: a29 := JTF_DATE_TABLE();
159: a30 := JTF_NUMBER_TABLE();
160: a31 := JTF_DATE_TABLE();
161: a32 := JTF_NUMBER_TABLE();
162: a33 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
157: a28 := JTF_NUMBER_TABLE();
158: a29 := JTF_DATE_TABLE();
159: a30 := JTF_NUMBER_TABLE();
160: a31 := JTF_DATE_TABLE();
161: a32 := JTF_NUMBER_TABLE();
162: a33 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
164: else
165: a0 := JTF_NUMBER_TABLE();
159: a30 := JTF_NUMBER_TABLE();
160: a31 := JTF_DATE_TABLE();
161: a32 := JTF_NUMBER_TABLE();
162: a33 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
164: else
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
161: a32 := JTF_NUMBER_TABLE();
162: a33 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
164: else
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_DATE_TABLE();
162: a33 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
164: else
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_DATE_TABLE();
170: a5 := JTF_DATE_TABLE();
163: a34 := JTF_NUMBER_TABLE();
164: else
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_DATE_TABLE();
170: a5 := JTF_DATE_TABLE();
171: a6 := JTF_VARCHAR2_TABLE_2000();
164: else
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_NUMBER_TABLE();
168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_DATE_TABLE();
170: a5 := JTF_DATE_TABLE();
171: a6 := JTF_VARCHAR2_TABLE_2000();
172: a7 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_DATE_TABLE();
170: a5 := JTF_DATE_TABLE();
171: a6 := JTF_VARCHAR2_TABLE_2000();
172: a7 := JTF_VARCHAR2_TABLE_100();
173: a8 := JTF_NUMBER_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: a10 := JTF_VARCHAR2_TABLE_100();
176: a11 := JTF_VARCHAR2_TABLE_500();
177: a12 := JTF_VARCHAR2_TABLE_500();
170: a5 := JTF_DATE_TABLE();
171: a6 := JTF_VARCHAR2_TABLE_2000();
172: a7 := JTF_VARCHAR2_TABLE_100();
173: a8 := JTF_NUMBER_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: a10 := JTF_VARCHAR2_TABLE_100();
176: a11 := JTF_VARCHAR2_TABLE_500();
177: a12 := JTF_VARCHAR2_TABLE_500();
178: a13 := JTF_VARCHAR2_TABLE_500();
187: a22 := JTF_VARCHAR2_TABLE_500();
188: a23 := JTF_VARCHAR2_TABLE_500();
189: a24 := JTF_VARCHAR2_TABLE_500();
190: a25 := JTF_VARCHAR2_TABLE_500();
191: a26 := JTF_NUMBER_TABLE();
192: a27 := JTF_NUMBER_TABLE();
193: a28 := JTF_NUMBER_TABLE();
194: a29 := JTF_DATE_TABLE();
195: a30 := JTF_NUMBER_TABLE();
188: a23 := JTF_VARCHAR2_TABLE_500();
189: a24 := JTF_VARCHAR2_TABLE_500();
190: a25 := JTF_VARCHAR2_TABLE_500();
191: a26 := JTF_NUMBER_TABLE();
192: a27 := JTF_NUMBER_TABLE();
193: a28 := JTF_NUMBER_TABLE();
194: a29 := JTF_DATE_TABLE();
195: a30 := JTF_NUMBER_TABLE();
196: a31 := JTF_DATE_TABLE();
189: a24 := JTF_VARCHAR2_TABLE_500();
190: a25 := JTF_VARCHAR2_TABLE_500();
191: a26 := JTF_NUMBER_TABLE();
192: a27 := JTF_NUMBER_TABLE();
193: a28 := JTF_NUMBER_TABLE();
194: a29 := JTF_DATE_TABLE();
195: a30 := JTF_NUMBER_TABLE();
196: a31 := JTF_DATE_TABLE();
197: a32 := JTF_NUMBER_TABLE();
191: a26 := JTF_NUMBER_TABLE();
192: a27 := JTF_NUMBER_TABLE();
193: a28 := JTF_NUMBER_TABLE();
194: a29 := JTF_DATE_TABLE();
195: a30 := JTF_NUMBER_TABLE();
196: a31 := JTF_DATE_TABLE();
197: a32 := JTF_NUMBER_TABLE();
198: a33 := JTF_DATE_TABLE();
199: a34 := JTF_NUMBER_TABLE();
193: a28 := JTF_NUMBER_TABLE();
194: a29 := JTF_DATE_TABLE();
195: a30 := JTF_NUMBER_TABLE();
196: a31 := JTF_DATE_TABLE();
197: a32 := JTF_NUMBER_TABLE();
198: a33 := JTF_DATE_TABLE();
199: a34 := JTF_NUMBER_TABLE();
200: if t.count > 0 then
201: a0.extend(t.count);
195: a30 := JTF_NUMBER_TABLE();
196: a31 := JTF_DATE_TABLE();
197: a32 := JTF_NUMBER_TABLE();
198: a33 := JTF_DATE_TABLE();
199: a34 := JTF_NUMBER_TABLE();
200: if t.count > 0 then
201: a0.extend(t.count);
202: a1.extend(t.count);
203: a2.extend(t.count);
280: end if;
281: end if;
282: end rosetta_table_copy_out_p2;
283:
284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE
285: , a1 JTF_NUMBER_TABLE
286: , a2 JTF_NUMBER_TABLE
287: , a3 JTF_NUMBER_TABLE
288: , a4 JTF_DATE_TABLE
281: end if;
282: end rosetta_table_copy_out_p2;
283:
284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE
285: , a1 JTF_NUMBER_TABLE
286: , a2 JTF_NUMBER_TABLE
287: , a3 JTF_NUMBER_TABLE
288: , a4 JTF_DATE_TABLE
289: , a5 JTF_DATE_TABLE
282: end rosetta_table_copy_out_p2;
283:
284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE
285: , a1 JTF_NUMBER_TABLE
286: , a2 JTF_NUMBER_TABLE
287: , a3 JTF_NUMBER_TABLE
288: , a4 JTF_DATE_TABLE
289: , a5 JTF_DATE_TABLE
290: , a6 JTF_VARCHAR2_TABLE_2000
283:
284: procedure rosetta_table_copy_in_p5(t out nocopy okl_vas_pvt.vas_tbl_type, a0 JTF_NUMBER_TABLE
285: , a1 JTF_NUMBER_TABLE
286: , a2 JTF_NUMBER_TABLE
287: , a3 JTF_NUMBER_TABLE
288: , a4 JTF_DATE_TABLE
289: , a5 JTF_DATE_TABLE
290: , a6 JTF_VARCHAR2_TABLE_2000
291: , a7 JTF_VARCHAR2_TABLE_100
288: , a4 JTF_DATE_TABLE
289: , a5 JTF_DATE_TABLE
290: , a6 JTF_VARCHAR2_TABLE_2000
291: , a7 JTF_VARCHAR2_TABLE_100
292: , a8 JTF_NUMBER_TABLE
293: , a9 JTF_NUMBER_TABLE
294: , a10 JTF_VARCHAR2_TABLE_100
295: , a11 JTF_VARCHAR2_TABLE_500
296: , a12 JTF_VARCHAR2_TABLE_500
289: , a5 JTF_DATE_TABLE
290: , a6 JTF_VARCHAR2_TABLE_2000
291: , a7 JTF_VARCHAR2_TABLE_100
292: , a8 JTF_NUMBER_TABLE
293: , a9 JTF_NUMBER_TABLE
294: , a10 JTF_VARCHAR2_TABLE_100
295: , a11 JTF_VARCHAR2_TABLE_500
296: , a12 JTF_VARCHAR2_TABLE_500
297: , a13 JTF_VARCHAR2_TABLE_500
306: , a22 JTF_VARCHAR2_TABLE_500
307: , a23 JTF_VARCHAR2_TABLE_500
308: , a24 JTF_VARCHAR2_TABLE_500
309: , a25 JTF_VARCHAR2_TABLE_500
310: , a26 JTF_NUMBER_TABLE
311: , a27 JTF_NUMBER_TABLE
312: , a28 JTF_NUMBER_TABLE
313: , a29 JTF_DATE_TABLE
314: , a30 JTF_NUMBER_TABLE
307: , a23 JTF_VARCHAR2_TABLE_500
308: , a24 JTF_VARCHAR2_TABLE_500
309: , a25 JTF_VARCHAR2_TABLE_500
310: , a26 JTF_NUMBER_TABLE
311: , a27 JTF_NUMBER_TABLE
312: , a28 JTF_NUMBER_TABLE
313: , a29 JTF_DATE_TABLE
314: , a30 JTF_NUMBER_TABLE
315: , a31 JTF_DATE_TABLE
308: , a24 JTF_VARCHAR2_TABLE_500
309: , a25 JTF_VARCHAR2_TABLE_500
310: , a26 JTF_NUMBER_TABLE
311: , a27 JTF_NUMBER_TABLE
312: , a28 JTF_NUMBER_TABLE
313: , a29 JTF_DATE_TABLE
314: , a30 JTF_NUMBER_TABLE
315: , a31 JTF_DATE_TABLE
316: , a32 JTF_NUMBER_TABLE
310: , a26 JTF_NUMBER_TABLE
311: , a27 JTF_NUMBER_TABLE
312: , a28 JTF_NUMBER_TABLE
313: , a29 JTF_DATE_TABLE
314: , a30 JTF_NUMBER_TABLE
315: , a31 JTF_DATE_TABLE
316: , a32 JTF_NUMBER_TABLE
317: , a33 JTF_DATE_TABLE
318: , a34 JTF_NUMBER_TABLE
312: , a28 JTF_NUMBER_TABLE
313: , a29 JTF_DATE_TABLE
314: , a30 JTF_NUMBER_TABLE
315: , a31 JTF_DATE_TABLE
316: , a32 JTF_NUMBER_TABLE
317: , a33 JTF_DATE_TABLE
318: , a34 JTF_NUMBER_TABLE
319: ) as
320: ddindx binary_integer; indx binary_integer;
314: , a30 JTF_NUMBER_TABLE
315: , a31 JTF_DATE_TABLE
316: , a32 JTF_NUMBER_TABLE
317: , a33 JTF_DATE_TABLE
318: , a34 JTF_NUMBER_TABLE
319: ) as
320: ddindx binary_integer; indx binary_integer;
321: begin
322: if a0 is not null and a0.count > 0 then
367: end loop;
368: end if;
369: end if;
370: end rosetta_table_copy_in_p5;
371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_DATE_TABLE
368: end if;
369: end if;
370: end rosetta_table_copy_in_p5;
371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_DATE_TABLE
376: , a5 out nocopy JTF_DATE_TABLE
369: end if;
370: end rosetta_table_copy_in_p5;
371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_DATE_TABLE
376: , a5 out nocopy JTF_DATE_TABLE
377: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
370: end rosetta_table_copy_in_p5;
371: procedure rosetta_table_copy_out_p5(t okl_vas_pvt.vas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_DATE_TABLE
376: , a5 out nocopy JTF_DATE_TABLE
377: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
378: , a7 out nocopy JTF_VARCHAR2_TABLE_100
375: , a4 out nocopy JTF_DATE_TABLE
376: , a5 out nocopy JTF_DATE_TABLE
377: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
378: , a7 out nocopy JTF_VARCHAR2_TABLE_100
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_NUMBER_TABLE
381: , a10 out nocopy JTF_VARCHAR2_TABLE_100
382: , a11 out nocopy JTF_VARCHAR2_TABLE_500
383: , a12 out nocopy JTF_VARCHAR2_TABLE_500
376: , a5 out nocopy JTF_DATE_TABLE
377: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
378: , a7 out nocopy JTF_VARCHAR2_TABLE_100
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_NUMBER_TABLE
381: , a10 out nocopy JTF_VARCHAR2_TABLE_100
382: , a11 out nocopy JTF_VARCHAR2_TABLE_500
383: , a12 out nocopy JTF_VARCHAR2_TABLE_500
384: , a13 out nocopy JTF_VARCHAR2_TABLE_500
393: , a22 out nocopy JTF_VARCHAR2_TABLE_500
394: , a23 out nocopy JTF_VARCHAR2_TABLE_500
395: , a24 out nocopy JTF_VARCHAR2_TABLE_500
396: , a25 out nocopy JTF_VARCHAR2_TABLE_500
397: , a26 out nocopy JTF_NUMBER_TABLE
398: , a27 out nocopy JTF_NUMBER_TABLE
399: , a28 out nocopy JTF_NUMBER_TABLE
400: , a29 out nocopy JTF_DATE_TABLE
401: , a30 out nocopy JTF_NUMBER_TABLE
394: , a23 out nocopy JTF_VARCHAR2_TABLE_500
395: , a24 out nocopy JTF_VARCHAR2_TABLE_500
396: , a25 out nocopy JTF_VARCHAR2_TABLE_500
397: , a26 out nocopy JTF_NUMBER_TABLE
398: , a27 out nocopy JTF_NUMBER_TABLE
399: , a28 out nocopy JTF_NUMBER_TABLE
400: , a29 out nocopy JTF_DATE_TABLE
401: , a30 out nocopy JTF_NUMBER_TABLE
402: , a31 out nocopy JTF_DATE_TABLE
395: , a24 out nocopy JTF_VARCHAR2_TABLE_500
396: , a25 out nocopy JTF_VARCHAR2_TABLE_500
397: , a26 out nocopy JTF_NUMBER_TABLE
398: , a27 out nocopy JTF_NUMBER_TABLE
399: , a28 out nocopy JTF_NUMBER_TABLE
400: , a29 out nocopy JTF_DATE_TABLE
401: , a30 out nocopy JTF_NUMBER_TABLE
402: , a31 out nocopy JTF_DATE_TABLE
403: , a32 out nocopy JTF_NUMBER_TABLE
397: , a26 out nocopy JTF_NUMBER_TABLE
398: , a27 out nocopy JTF_NUMBER_TABLE
399: , a28 out nocopy JTF_NUMBER_TABLE
400: , a29 out nocopy JTF_DATE_TABLE
401: , a30 out nocopy JTF_NUMBER_TABLE
402: , a31 out nocopy JTF_DATE_TABLE
403: , a32 out nocopy JTF_NUMBER_TABLE
404: , a33 out nocopy JTF_DATE_TABLE
405: , a34 out nocopy JTF_NUMBER_TABLE
399: , a28 out nocopy JTF_NUMBER_TABLE
400: , a29 out nocopy JTF_DATE_TABLE
401: , a30 out nocopy JTF_NUMBER_TABLE
402: , a31 out nocopy JTF_DATE_TABLE
403: , a32 out nocopy JTF_NUMBER_TABLE
404: , a33 out nocopy JTF_DATE_TABLE
405: , a34 out nocopy JTF_NUMBER_TABLE
406: ) as
407: ddindx binary_integer; indx binary_integer;
401: , a30 out nocopy JTF_NUMBER_TABLE
402: , a31 out nocopy JTF_DATE_TABLE
403: , a32 out nocopy JTF_NUMBER_TABLE
404: , a33 out nocopy JTF_DATE_TABLE
405: , a34 out nocopy JTF_NUMBER_TABLE
406: ) as
407: ddindx binary_integer; indx binary_integer;
408: begin
409: if t is null or t.count = 0 then
406: ) as
407: ddindx binary_integer; indx binary_integer;
408: begin
409: if t is null or t.count = 0 then
410: a0 := JTF_NUMBER_TABLE();
411: a1 := JTF_NUMBER_TABLE();
412: a2 := JTF_NUMBER_TABLE();
413: a3 := JTF_NUMBER_TABLE();
414: a4 := JTF_DATE_TABLE();
407: ddindx binary_integer; indx binary_integer;
408: begin
409: if t is null or t.count = 0 then
410: a0 := JTF_NUMBER_TABLE();
411: a1 := JTF_NUMBER_TABLE();
412: a2 := JTF_NUMBER_TABLE();
413: a3 := JTF_NUMBER_TABLE();
414: a4 := JTF_DATE_TABLE();
415: a5 := JTF_DATE_TABLE();
408: begin
409: if t is null or t.count = 0 then
410: a0 := JTF_NUMBER_TABLE();
411: a1 := JTF_NUMBER_TABLE();
412: a2 := JTF_NUMBER_TABLE();
413: a3 := JTF_NUMBER_TABLE();
414: a4 := JTF_DATE_TABLE();
415: a5 := JTF_DATE_TABLE();
416: a6 := JTF_VARCHAR2_TABLE_2000();
409: if t is null or t.count = 0 then
410: a0 := JTF_NUMBER_TABLE();
411: a1 := JTF_NUMBER_TABLE();
412: a2 := JTF_NUMBER_TABLE();
413: a3 := JTF_NUMBER_TABLE();
414: a4 := JTF_DATE_TABLE();
415: a5 := JTF_DATE_TABLE();
416: a6 := JTF_VARCHAR2_TABLE_2000();
417: a7 := JTF_VARCHAR2_TABLE_100();
414: a4 := JTF_DATE_TABLE();
415: a5 := JTF_DATE_TABLE();
416: a6 := JTF_VARCHAR2_TABLE_2000();
417: a7 := JTF_VARCHAR2_TABLE_100();
418: a8 := JTF_NUMBER_TABLE();
419: a9 := JTF_NUMBER_TABLE();
420: a10 := JTF_VARCHAR2_TABLE_100();
421: a11 := JTF_VARCHAR2_TABLE_500();
422: a12 := JTF_VARCHAR2_TABLE_500();
415: a5 := JTF_DATE_TABLE();
416: a6 := JTF_VARCHAR2_TABLE_2000();
417: a7 := JTF_VARCHAR2_TABLE_100();
418: a8 := JTF_NUMBER_TABLE();
419: a9 := JTF_NUMBER_TABLE();
420: a10 := JTF_VARCHAR2_TABLE_100();
421: a11 := JTF_VARCHAR2_TABLE_500();
422: a12 := JTF_VARCHAR2_TABLE_500();
423: a13 := JTF_VARCHAR2_TABLE_500();
432: a22 := JTF_VARCHAR2_TABLE_500();
433: a23 := JTF_VARCHAR2_TABLE_500();
434: a24 := JTF_VARCHAR2_TABLE_500();
435: a25 := JTF_VARCHAR2_TABLE_500();
436: a26 := JTF_NUMBER_TABLE();
437: a27 := JTF_NUMBER_TABLE();
438: a28 := JTF_NUMBER_TABLE();
439: a29 := JTF_DATE_TABLE();
440: a30 := JTF_NUMBER_TABLE();
433: a23 := JTF_VARCHAR2_TABLE_500();
434: a24 := JTF_VARCHAR2_TABLE_500();
435: a25 := JTF_VARCHAR2_TABLE_500();
436: a26 := JTF_NUMBER_TABLE();
437: a27 := JTF_NUMBER_TABLE();
438: a28 := JTF_NUMBER_TABLE();
439: a29 := JTF_DATE_TABLE();
440: a30 := JTF_NUMBER_TABLE();
441: a31 := JTF_DATE_TABLE();
434: a24 := JTF_VARCHAR2_TABLE_500();
435: a25 := JTF_VARCHAR2_TABLE_500();
436: a26 := JTF_NUMBER_TABLE();
437: a27 := JTF_NUMBER_TABLE();
438: a28 := JTF_NUMBER_TABLE();
439: a29 := JTF_DATE_TABLE();
440: a30 := JTF_NUMBER_TABLE();
441: a31 := JTF_DATE_TABLE();
442: a32 := JTF_NUMBER_TABLE();
436: a26 := JTF_NUMBER_TABLE();
437: a27 := JTF_NUMBER_TABLE();
438: a28 := JTF_NUMBER_TABLE();
439: a29 := JTF_DATE_TABLE();
440: a30 := JTF_NUMBER_TABLE();
441: a31 := JTF_DATE_TABLE();
442: a32 := JTF_NUMBER_TABLE();
443: a33 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
438: a28 := JTF_NUMBER_TABLE();
439: a29 := JTF_DATE_TABLE();
440: a30 := JTF_NUMBER_TABLE();
441: a31 := JTF_DATE_TABLE();
442: a32 := JTF_NUMBER_TABLE();
443: a33 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_NUMBER_TABLE();
440: a30 := JTF_NUMBER_TABLE();
441: a31 := JTF_DATE_TABLE();
442: a32 := JTF_NUMBER_TABLE();
443: a33 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_NUMBER_TABLE();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
442: a32 := JTF_NUMBER_TABLE();
443: a33 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_NUMBER_TABLE();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
449: a3 := JTF_NUMBER_TABLE();
450: a4 := JTF_DATE_TABLE();
443: a33 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_NUMBER_TABLE();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
449: a3 := JTF_NUMBER_TABLE();
450: a4 := JTF_DATE_TABLE();
451: a5 := JTF_DATE_TABLE();
444: a34 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_NUMBER_TABLE();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
449: a3 := JTF_NUMBER_TABLE();
450: a4 := JTF_DATE_TABLE();
451: a5 := JTF_DATE_TABLE();
452: a6 := JTF_VARCHAR2_TABLE_2000();
445: else
446: a0 := JTF_NUMBER_TABLE();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
449: a3 := JTF_NUMBER_TABLE();
450: a4 := JTF_DATE_TABLE();
451: a5 := JTF_DATE_TABLE();
452: a6 := JTF_VARCHAR2_TABLE_2000();
453: a7 := JTF_VARCHAR2_TABLE_100();
450: a4 := JTF_DATE_TABLE();
451: a5 := JTF_DATE_TABLE();
452: a6 := JTF_VARCHAR2_TABLE_2000();
453: a7 := JTF_VARCHAR2_TABLE_100();
454: a8 := JTF_NUMBER_TABLE();
455: a9 := JTF_NUMBER_TABLE();
456: a10 := JTF_VARCHAR2_TABLE_100();
457: a11 := JTF_VARCHAR2_TABLE_500();
458: a12 := JTF_VARCHAR2_TABLE_500();
451: a5 := JTF_DATE_TABLE();
452: a6 := JTF_VARCHAR2_TABLE_2000();
453: a7 := JTF_VARCHAR2_TABLE_100();
454: a8 := JTF_NUMBER_TABLE();
455: a9 := JTF_NUMBER_TABLE();
456: a10 := JTF_VARCHAR2_TABLE_100();
457: a11 := JTF_VARCHAR2_TABLE_500();
458: a12 := JTF_VARCHAR2_TABLE_500();
459: a13 := JTF_VARCHAR2_TABLE_500();
468: a22 := JTF_VARCHAR2_TABLE_500();
469: a23 := JTF_VARCHAR2_TABLE_500();
470: a24 := JTF_VARCHAR2_TABLE_500();
471: a25 := JTF_VARCHAR2_TABLE_500();
472: a26 := JTF_NUMBER_TABLE();
473: a27 := JTF_NUMBER_TABLE();
474: a28 := JTF_NUMBER_TABLE();
475: a29 := JTF_DATE_TABLE();
476: a30 := JTF_NUMBER_TABLE();
469: a23 := JTF_VARCHAR2_TABLE_500();
470: a24 := JTF_VARCHAR2_TABLE_500();
471: a25 := JTF_VARCHAR2_TABLE_500();
472: a26 := JTF_NUMBER_TABLE();
473: a27 := JTF_NUMBER_TABLE();
474: a28 := JTF_NUMBER_TABLE();
475: a29 := JTF_DATE_TABLE();
476: a30 := JTF_NUMBER_TABLE();
477: a31 := JTF_DATE_TABLE();
470: a24 := JTF_VARCHAR2_TABLE_500();
471: a25 := JTF_VARCHAR2_TABLE_500();
472: a26 := JTF_NUMBER_TABLE();
473: a27 := JTF_NUMBER_TABLE();
474: a28 := JTF_NUMBER_TABLE();
475: a29 := JTF_DATE_TABLE();
476: a30 := JTF_NUMBER_TABLE();
477: a31 := JTF_DATE_TABLE();
478: a32 := JTF_NUMBER_TABLE();
472: a26 := JTF_NUMBER_TABLE();
473: a27 := JTF_NUMBER_TABLE();
474: a28 := JTF_NUMBER_TABLE();
475: a29 := JTF_DATE_TABLE();
476: a30 := JTF_NUMBER_TABLE();
477: a31 := JTF_DATE_TABLE();
478: a32 := JTF_NUMBER_TABLE();
479: a33 := JTF_DATE_TABLE();
480: a34 := JTF_NUMBER_TABLE();
474: a28 := JTF_NUMBER_TABLE();
475: a29 := JTF_DATE_TABLE();
476: a30 := JTF_NUMBER_TABLE();
477: a31 := JTF_DATE_TABLE();
478: a32 := JTF_NUMBER_TABLE();
479: a33 := JTF_DATE_TABLE();
480: a34 := JTF_NUMBER_TABLE();
481: if t.count > 0 then
482: a0.extend(t.count);
476: a30 := JTF_NUMBER_TABLE();
477: a31 := JTF_DATE_TABLE();
478: a32 := JTF_NUMBER_TABLE();
479: a33 := JTF_DATE_TABLE();
480: a34 := JTF_NUMBER_TABLE();
481: if t.count > 0 then
482: a0.extend(t.count);
483: a1.extend(t.count);
484: a2.extend(t.count);
745: , p_init_msg_list VARCHAR2
746: , x_return_status out nocopy VARCHAR2
747: , x_msg_count out nocopy NUMBER
748: , x_msg_data out nocopy VARCHAR2
749: , p5_a0 JTF_NUMBER_TABLE
750: , p5_a1 JTF_NUMBER_TABLE
751: , p5_a2 JTF_NUMBER_TABLE
752: , p5_a3 JTF_NUMBER_TABLE
753: , p5_a4 JTF_DATE_TABLE
746: , x_return_status out nocopy VARCHAR2
747: , x_msg_count out nocopy NUMBER
748: , x_msg_data out nocopy VARCHAR2
749: , p5_a0 JTF_NUMBER_TABLE
750: , p5_a1 JTF_NUMBER_TABLE
751: , p5_a2 JTF_NUMBER_TABLE
752: , p5_a3 JTF_NUMBER_TABLE
753: , p5_a4 JTF_DATE_TABLE
754: , p5_a5 JTF_DATE_TABLE
747: , x_msg_count out nocopy NUMBER
748: , x_msg_data out nocopy VARCHAR2
749: , p5_a0 JTF_NUMBER_TABLE
750: , p5_a1 JTF_NUMBER_TABLE
751: , p5_a2 JTF_NUMBER_TABLE
752: , p5_a3 JTF_NUMBER_TABLE
753: , p5_a4 JTF_DATE_TABLE
754: , p5_a5 JTF_DATE_TABLE
755: , p5_a6 JTF_VARCHAR2_TABLE_2000
748: , x_msg_data out nocopy VARCHAR2
749: , p5_a0 JTF_NUMBER_TABLE
750: , p5_a1 JTF_NUMBER_TABLE
751: , p5_a2 JTF_NUMBER_TABLE
752: , p5_a3 JTF_NUMBER_TABLE
753: , p5_a4 JTF_DATE_TABLE
754: , p5_a5 JTF_DATE_TABLE
755: , p5_a6 JTF_VARCHAR2_TABLE_2000
756: , p5_a7 JTF_VARCHAR2_TABLE_100
753: , p5_a4 JTF_DATE_TABLE
754: , p5_a5 JTF_DATE_TABLE
755: , p5_a6 JTF_VARCHAR2_TABLE_2000
756: , p5_a7 JTF_VARCHAR2_TABLE_100
757: , p5_a8 JTF_NUMBER_TABLE
758: , p5_a9 JTF_NUMBER_TABLE
759: , p5_a10 JTF_VARCHAR2_TABLE_100
760: , p5_a11 JTF_VARCHAR2_TABLE_500
761: , p5_a12 JTF_VARCHAR2_TABLE_500
754: , p5_a5 JTF_DATE_TABLE
755: , p5_a6 JTF_VARCHAR2_TABLE_2000
756: , p5_a7 JTF_VARCHAR2_TABLE_100
757: , p5_a8 JTF_NUMBER_TABLE
758: , p5_a9 JTF_NUMBER_TABLE
759: , p5_a10 JTF_VARCHAR2_TABLE_100
760: , p5_a11 JTF_VARCHAR2_TABLE_500
761: , p5_a12 JTF_VARCHAR2_TABLE_500
762: , p5_a13 JTF_VARCHAR2_TABLE_500
771: , p5_a22 JTF_VARCHAR2_TABLE_500
772: , p5_a23 JTF_VARCHAR2_TABLE_500
773: , p5_a24 JTF_VARCHAR2_TABLE_500
774: , p5_a25 JTF_VARCHAR2_TABLE_500
775: , p5_a26 JTF_NUMBER_TABLE
776: , p5_a27 JTF_NUMBER_TABLE
777: , p5_a28 JTF_NUMBER_TABLE
778: , p5_a29 JTF_DATE_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
772: , p5_a23 JTF_VARCHAR2_TABLE_500
773: , p5_a24 JTF_VARCHAR2_TABLE_500
774: , p5_a25 JTF_VARCHAR2_TABLE_500
775: , p5_a26 JTF_NUMBER_TABLE
776: , p5_a27 JTF_NUMBER_TABLE
777: , p5_a28 JTF_NUMBER_TABLE
778: , p5_a29 JTF_DATE_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
773: , p5_a24 JTF_VARCHAR2_TABLE_500
774: , p5_a25 JTF_VARCHAR2_TABLE_500
775: , p5_a26 JTF_NUMBER_TABLE
776: , p5_a27 JTF_NUMBER_TABLE
777: , p5_a28 JTF_NUMBER_TABLE
778: , p5_a29 JTF_DATE_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
775: , p5_a26 JTF_NUMBER_TABLE
776: , p5_a27 JTF_NUMBER_TABLE
777: , p5_a28 JTF_NUMBER_TABLE
778: , p5_a29 JTF_DATE_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
777: , p5_a28 JTF_NUMBER_TABLE
778: , p5_a29 JTF_DATE_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
779: , p5_a30 JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_NUMBER_TABLE
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
780: , p5_a31 JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_NUMBER_TABLE
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_DATE_TABLE
781: , p5_a32 JTF_NUMBER_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_NUMBER_TABLE
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_DATE_TABLE
789: , p6_a5 out nocopy JTF_DATE_TABLE
782: , p5_a33 JTF_DATE_TABLE
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_NUMBER_TABLE
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_DATE_TABLE
789: , p6_a5 out nocopy JTF_DATE_TABLE
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
783: , p5_a34 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_NUMBER_TABLE
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_DATE_TABLE
789: , p6_a5 out nocopy JTF_DATE_TABLE
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
788: , p6_a4 out nocopy JTF_DATE_TABLE
789: , p6_a5 out nocopy JTF_DATE_TABLE
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_NUMBER_TABLE
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
789: , p6_a5 out nocopy JTF_DATE_TABLE
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_NUMBER_TABLE
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_NUMBER_TABLE
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: , p6_a28 out nocopy JTF_NUMBER_TABLE
813: , p6_a29 out nocopy JTF_DATE_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_NUMBER_TABLE
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: , p6_a28 out nocopy JTF_NUMBER_TABLE
813: , p6_a29 out nocopy JTF_DATE_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_NUMBER_TABLE
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: , p6_a28 out nocopy JTF_NUMBER_TABLE
813: , p6_a29 out nocopy JTF_DATE_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_NUMBER_TABLE
810: , p6_a26 out nocopy JTF_NUMBER_TABLE
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: , p6_a28 out nocopy JTF_NUMBER_TABLE
813: , p6_a29 out nocopy JTF_DATE_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_NUMBER_TABLE
817: , p6_a33 out nocopy JTF_DATE_TABLE
818: , p6_a34 out nocopy JTF_NUMBER_TABLE
812: , p6_a28 out nocopy JTF_NUMBER_TABLE
813: , p6_a29 out nocopy JTF_DATE_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_NUMBER_TABLE
817: , p6_a33 out nocopy JTF_DATE_TABLE
818: , p6_a34 out nocopy JTF_NUMBER_TABLE
819: , p7_a0 in out nocopy JTF_NUMBER_TABLE
820: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_NUMBER_TABLE
817: , p6_a33 out nocopy JTF_DATE_TABLE
818: , p6_a34 out nocopy JTF_NUMBER_TABLE
819: , p7_a0 in out nocopy JTF_NUMBER_TABLE
820: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a2 in out nocopy JTF_NUMBER_TABLE
822: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_NUMBER_TABLE
817: , p6_a33 out nocopy JTF_DATE_TABLE
818: , p6_a34 out nocopy JTF_NUMBER_TABLE
819: , p7_a0 in out nocopy JTF_NUMBER_TABLE
820: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a2 in out nocopy JTF_NUMBER_TABLE
822: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
823: , p7_a4 in out nocopy JTF_NUMBER_TABLE
817: , p6_a33 out nocopy JTF_DATE_TABLE
818: , p6_a34 out nocopy JTF_NUMBER_TABLE
819: , p7_a0 in out nocopy JTF_NUMBER_TABLE
820: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a2 in out nocopy JTF_NUMBER_TABLE
822: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
823: , p7_a4 in out nocopy JTF_NUMBER_TABLE
824: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
825: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
819: , p7_a0 in out nocopy JTF_NUMBER_TABLE
820: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
821: , p7_a2 in out nocopy JTF_NUMBER_TABLE
822: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
823: , p7_a4 in out nocopy JTF_NUMBER_TABLE
824: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
825: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
826: )
827:
953: , p_init_msg_list VARCHAR2
954: , x_return_status out nocopy VARCHAR2
955: , x_msg_count out nocopy NUMBER
956: , x_msg_data out nocopy VARCHAR2
957: , p5_a0 JTF_NUMBER_TABLE
958: , p5_a1 JTF_NUMBER_TABLE
959: , p5_a2 JTF_NUMBER_TABLE
960: , p5_a3 JTF_NUMBER_TABLE
961: , p5_a4 JTF_DATE_TABLE
954: , x_return_status out nocopy VARCHAR2
955: , x_msg_count out nocopy NUMBER
956: , x_msg_data out nocopy VARCHAR2
957: , p5_a0 JTF_NUMBER_TABLE
958: , p5_a1 JTF_NUMBER_TABLE
959: , p5_a2 JTF_NUMBER_TABLE
960: , p5_a3 JTF_NUMBER_TABLE
961: , p5_a4 JTF_DATE_TABLE
962: , p5_a5 JTF_DATE_TABLE
955: , x_msg_count out nocopy NUMBER
956: , x_msg_data out nocopy VARCHAR2
957: , p5_a0 JTF_NUMBER_TABLE
958: , p5_a1 JTF_NUMBER_TABLE
959: , p5_a2 JTF_NUMBER_TABLE
960: , p5_a3 JTF_NUMBER_TABLE
961: , p5_a4 JTF_DATE_TABLE
962: , p5_a5 JTF_DATE_TABLE
963: , p5_a6 JTF_VARCHAR2_TABLE_2000
956: , x_msg_data out nocopy VARCHAR2
957: , p5_a0 JTF_NUMBER_TABLE
958: , p5_a1 JTF_NUMBER_TABLE
959: , p5_a2 JTF_NUMBER_TABLE
960: , p5_a3 JTF_NUMBER_TABLE
961: , p5_a4 JTF_DATE_TABLE
962: , p5_a5 JTF_DATE_TABLE
963: , p5_a6 JTF_VARCHAR2_TABLE_2000
964: , p5_a7 JTF_VARCHAR2_TABLE_100
961: , p5_a4 JTF_DATE_TABLE
962: , p5_a5 JTF_DATE_TABLE
963: , p5_a6 JTF_VARCHAR2_TABLE_2000
964: , p5_a7 JTF_VARCHAR2_TABLE_100
965: , p5_a8 JTF_NUMBER_TABLE
966: , p5_a9 JTF_NUMBER_TABLE
967: , p5_a10 JTF_VARCHAR2_TABLE_100
968: , p5_a11 JTF_VARCHAR2_TABLE_500
969: , p5_a12 JTF_VARCHAR2_TABLE_500
962: , p5_a5 JTF_DATE_TABLE
963: , p5_a6 JTF_VARCHAR2_TABLE_2000
964: , p5_a7 JTF_VARCHAR2_TABLE_100
965: , p5_a8 JTF_NUMBER_TABLE
966: , p5_a9 JTF_NUMBER_TABLE
967: , p5_a10 JTF_VARCHAR2_TABLE_100
968: , p5_a11 JTF_VARCHAR2_TABLE_500
969: , p5_a12 JTF_VARCHAR2_TABLE_500
970: , p5_a13 JTF_VARCHAR2_TABLE_500
979: , p5_a22 JTF_VARCHAR2_TABLE_500
980: , p5_a23 JTF_VARCHAR2_TABLE_500
981: , p5_a24 JTF_VARCHAR2_TABLE_500
982: , p5_a25 JTF_VARCHAR2_TABLE_500
983: , p5_a26 JTF_NUMBER_TABLE
984: , p5_a27 JTF_NUMBER_TABLE
985: , p5_a28 JTF_NUMBER_TABLE
986: , p5_a29 JTF_DATE_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
980: , p5_a23 JTF_VARCHAR2_TABLE_500
981: , p5_a24 JTF_VARCHAR2_TABLE_500
982: , p5_a25 JTF_VARCHAR2_TABLE_500
983: , p5_a26 JTF_NUMBER_TABLE
984: , p5_a27 JTF_NUMBER_TABLE
985: , p5_a28 JTF_NUMBER_TABLE
986: , p5_a29 JTF_DATE_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
981: , p5_a24 JTF_VARCHAR2_TABLE_500
982: , p5_a25 JTF_VARCHAR2_TABLE_500
983: , p5_a26 JTF_NUMBER_TABLE
984: , p5_a27 JTF_NUMBER_TABLE
985: , p5_a28 JTF_NUMBER_TABLE
986: , p5_a29 JTF_DATE_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
983: , p5_a26 JTF_NUMBER_TABLE
984: , p5_a27 JTF_NUMBER_TABLE
985: , p5_a28 JTF_NUMBER_TABLE
986: , p5_a29 JTF_DATE_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
985: , p5_a28 JTF_NUMBER_TABLE
986: , p5_a29 JTF_DATE_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
987: , p5_a30 JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
994: , p6_a2 out nocopy JTF_NUMBER_TABLE
995: , p6_a3 out nocopy JTF_NUMBER_TABLE
988: , p5_a31 JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
994: , p6_a2 out nocopy JTF_NUMBER_TABLE
995: , p6_a3 out nocopy JTF_NUMBER_TABLE
996: , p6_a4 out nocopy JTF_DATE_TABLE
989: , p5_a32 JTF_NUMBER_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
994: , p6_a2 out nocopy JTF_NUMBER_TABLE
995: , p6_a3 out nocopy JTF_NUMBER_TABLE
996: , p6_a4 out nocopy JTF_DATE_TABLE
997: , p6_a5 out nocopy JTF_DATE_TABLE
990: , p5_a33 JTF_DATE_TABLE
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
994: , p6_a2 out nocopy JTF_NUMBER_TABLE
995: , p6_a3 out nocopy JTF_NUMBER_TABLE
996: , p6_a4 out nocopy JTF_DATE_TABLE
997: , p6_a5 out nocopy JTF_DATE_TABLE
998: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
991: , p5_a34 JTF_NUMBER_TABLE
992: , p6_a0 out nocopy JTF_NUMBER_TABLE
993: , p6_a1 out nocopy JTF_NUMBER_TABLE
994: , p6_a2 out nocopy JTF_NUMBER_TABLE
995: , p6_a3 out nocopy JTF_NUMBER_TABLE
996: , p6_a4 out nocopy JTF_DATE_TABLE
997: , p6_a5 out nocopy JTF_DATE_TABLE
998: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
999: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
996: , p6_a4 out nocopy JTF_DATE_TABLE
997: , p6_a5 out nocopy JTF_DATE_TABLE
998: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
999: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1000: , p6_a8 out nocopy JTF_NUMBER_TABLE
1001: , p6_a9 out nocopy JTF_NUMBER_TABLE
1002: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1003: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1004: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
997: , p6_a5 out nocopy JTF_DATE_TABLE
998: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
999: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1000: , p6_a8 out nocopy JTF_NUMBER_TABLE
1001: , p6_a9 out nocopy JTF_NUMBER_TABLE
1002: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1003: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1004: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1005: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1014: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1015: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1016: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1017: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1018: , p6_a26 out nocopy JTF_NUMBER_TABLE
1019: , p6_a27 out nocopy JTF_NUMBER_TABLE
1020: , p6_a28 out nocopy JTF_NUMBER_TABLE
1021: , p6_a29 out nocopy JTF_DATE_TABLE
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1015: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1016: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1017: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1018: , p6_a26 out nocopy JTF_NUMBER_TABLE
1019: , p6_a27 out nocopy JTF_NUMBER_TABLE
1020: , p6_a28 out nocopy JTF_NUMBER_TABLE
1021: , p6_a29 out nocopy JTF_DATE_TABLE
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1023: , p6_a31 out nocopy JTF_DATE_TABLE
1016: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1017: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1018: , p6_a26 out nocopy JTF_NUMBER_TABLE
1019: , p6_a27 out nocopy JTF_NUMBER_TABLE
1020: , p6_a28 out nocopy JTF_NUMBER_TABLE
1021: , p6_a29 out nocopy JTF_DATE_TABLE
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1023: , p6_a31 out nocopy JTF_DATE_TABLE
1024: , p6_a32 out nocopy JTF_NUMBER_TABLE
1018: , p6_a26 out nocopy JTF_NUMBER_TABLE
1019: , p6_a27 out nocopy JTF_NUMBER_TABLE
1020: , p6_a28 out nocopy JTF_NUMBER_TABLE
1021: , p6_a29 out nocopy JTF_DATE_TABLE
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1023: , p6_a31 out nocopy JTF_DATE_TABLE
1024: , p6_a32 out nocopy JTF_NUMBER_TABLE
1025: , p6_a33 out nocopy JTF_DATE_TABLE
1026: , p6_a34 out nocopy JTF_NUMBER_TABLE
1020: , p6_a28 out nocopy JTF_NUMBER_TABLE
1021: , p6_a29 out nocopy JTF_DATE_TABLE
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1023: , p6_a31 out nocopy JTF_DATE_TABLE
1024: , p6_a32 out nocopy JTF_NUMBER_TABLE
1025: , p6_a33 out nocopy JTF_DATE_TABLE
1026: , p6_a34 out nocopy JTF_NUMBER_TABLE
1027: )
1028:
1022: , p6_a30 out nocopy JTF_NUMBER_TABLE
1023: , p6_a31 out nocopy JTF_DATE_TABLE
1024: , p6_a32 out nocopy JTF_NUMBER_TABLE
1025: , p6_a33 out nocopy JTF_DATE_TABLE
1026: , p6_a34 out nocopy JTF_NUMBER_TABLE
1027: )
1028:
1029: as
1030: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1239: , p_init_msg_list VARCHAR2
1240: , x_return_status out nocopy VARCHAR2
1241: , x_msg_count out nocopy NUMBER
1242: , x_msg_data out nocopy VARCHAR2
1243: , p5_a0 JTF_NUMBER_TABLE
1244: , p5_a1 JTF_NUMBER_TABLE
1245: , p5_a2 JTF_NUMBER_TABLE
1246: , p5_a3 JTF_NUMBER_TABLE
1247: , p5_a4 JTF_DATE_TABLE
1240: , x_return_status out nocopy VARCHAR2
1241: , x_msg_count out nocopy NUMBER
1242: , x_msg_data out nocopy VARCHAR2
1243: , p5_a0 JTF_NUMBER_TABLE
1244: , p5_a1 JTF_NUMBER_TABLE
1245: , p5_a2 JTF_NUMBER_TABLE
1246: , p5_a3 JTF_NUMBER_TABLE
1247: , p5_a4 JTF_DATE_TABLE
1248: , p5_a5 JTF_DATE_TABLE
1241: , x_msg_count out nocopy NUMBER
1242: , x_msg_data out nocopy VARCHAR2
1243: , p5_a0 JTF_NUMBER_TABLE
1244: , p5_a1 JTF_NUMBER_TABLE
1245: , p5_a2 JTF_NUMBER_TABLE
1246: , p5_a3 JTF_NUMBER_TABLE
1247: , p5_a4 JTF_DATE_TABLE
1248: , p5_a5 JTF_DATE_TABLE
1249: , p5_a6 JTF_VARCHAR2_TABLE_2000
1242: , x_msg_data out nocopy VARCHAR2
1243: , p5_a0 JTF_NUMBER_TABLE
1244: , p5_a1 JTF_NUMBER_TABLE
1245: , p5_a2 JTF_NUMBER_TABLE
1246: , p5_a3 JTF_NUMBER_TABLE
1247: , p5_a4 JTF_DATE_TABLE
1248: , p5_a5 JTF_DATE_TABLE
1249: , p5_a6 JTF_VARCHAR2_TABLE_2000
1250: , p5_a7 JTF_VARCHAR2_TABLE_100
1247: , p5_a4 JTF_DATE_TABLE
1248: , p5_a5 JTF_DATE_TABLE
1249: , p5_a6 JTF_VARCHAR2_TABLE_2000
1250: , p5_a7 JTF_VARCHAR2_TABLE_100
1251: , p5_a8 JTF_NUMBER_TABLE
1252: , p5_a9 JTF_NUMBER_TABLE
1253: , p5_a10 JTF_VARCHAR2_TABLE_100
1254: , p5_a11 JTF_VARCHAR2_TABLE_500
1255: , p5_a12 JTF_VARCHAR2_TABLE_500
1248: , p5_a5 JTF_DATE_TABLE
1249: , p5_a6 JTF_VARCHAR2_TABLE_2000
1250: , p5_a7 JTF_VARCHAR2_TABLE_100
1251: , p5_a8 JTF_NUMBER_TABLE
1252: , p5_a9 JTF_NUMBER_TABLE
1253: , p5_a10 JTF_VARCHAR2_TABLE_100
1254: , p5_a11 JTF_VARCHAR2_TABLE_500
1255: , p5_a12 JTF_VARCHAR2_TABLE_500
1256: , p5_a13 JTF_VARCHAR2_TABLE_500
1265: , p5_a22 JTF_VARCHAR2_TABLE_500
1266: , p5_a23 JTF_VARCHAR2_TABLE_500
1267: , p5_a24 JTF_VARCHAR2_TABLE_500
1268: , p5_a25 JTF_VARCHAR2_TABLE_500
1269: , p5_a26 JTF_NUMBER_TABLE
1270: , p5_a27 JTF_NUMBER_TABLE
1271: , p5_a28 JTF_NUMBER_TABLE
1272: , p5_a29 JTF_DATE_TABLE
1273: , p5_a30 JTF_NUMBER_TABLE
1266: , p5_a23 JTF_VARCHAR2_TABLE_500
1267: , p5_a24 JTF_VARCHAR2_TABLE_500
1268: , p5_a25 JTF_VARCHAR2_TABLE_500
1269: , p5_a26 JTF_NUMBER_TABLE
1270: , p5_a27 JTF_NUMBER_TABLE
1271: , p5_a28 JTF_NUMBER_TABLE
1272: , p5_a29 JTF_DATE_TABLE
1273: , p5_a30 JTF_NUMBER_TABLE
1274: , p5_a31 JTF_DATE_TABLE
1267: , p5_a24 JTF_VARCHAR2_TABLE_500
1268: , p5_a25 JTF_VARCHAR2_TABLE_500
1269: , p5_a26 JTF_NUMBER_TABLE
1270: , p5_a27 JTF_NUMBER_TABLE
1271: , p5_a28 JTF_NUMBER_TABLE
1272: , p5_a29 JTF_DATE_TABLE
1273: , p5_a30 JTF_NUMBER_TABLE
1274: , p5_a31 JTF_DATE_TABLE
1275: , p5_a32 JTF_NUMBER_TABLE
1269: , p5_a26 JTF_NUMBER_TABLE
1270: , p5_a27 JTF_NUMBER_TABLE
1271: , p5_a28 JTF_NUMBER_TABLE
1272: , p5_a29 JTF_DATE_TABLE
1273: , p5_a30 JTF_NUMBER_TABLE
1274: , p5_a31 JTF_DATE_TABLE
1275: , p5_a32 JTF_NUMBER_TABLE
1276: , p5_a33 JTF_DATE_TABLE
1277: , p5_a34 JTF_NUMBER_TABLE
1271: , p5_a28 JTF_NUMBER_TABLE
1272: , p5_a29 JTF_DATE_TABLE
1273: , p5_a30 JTF_NUMBER_TABLE
1274: , p5_a31 JTF_DATE_TABLE
1275: , p5_a32 JTF_NUMBER_TABLE
1276: , p5_a33 JTF_DATE_TABLE
1277: , p5_a34 JTF_NUMBER_TABLE
1278: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1279: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1273: , p5_a30 JTF_NUMBER_TABLE
1274: , p5_a31 JTF_DATE_TABLE
1275: , p5_a32 JTF_NUMBER_TABLE
1276: , p5_a33 JTF_DATE_TABLE
1277: , p5_a34 JTF_NUMBER_TABLE
1278: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1279: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1280: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1281: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1274: , p5_a31 JTF_DATE_TABLE
1275: , p5_a32 JTF_NUMBER_TABLE
1276: , p5_a33 JTF_DATE_TABLE
1277: , p5_a34 JTF_NUMBER_TABLE
1278: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1279: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1280: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1281: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1282: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1276: , p5_a33 JTF_DATE_TABLE
1277: , p5_a34 JTF_NUMBER_TABLE
1278: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1279: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1280: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1281: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1282: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1283: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1284: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1278: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1279: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1280: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1281: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1282: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1283: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1284: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1285: )
1286:
1372: , p_init_msg_list VARCHAR2
1373: , x_return_status out nocopy VARCHAR2
1374: , x_msg_count out nocopy NUMBER
1375: , x_msg_data out nocopy VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_NUMBER_TABLE
1378: , p5_a2 JTF_NUMBER_TABLE
1379: , p5_a3 JTF_NUMBER_TABLE
1380: , p5_a4 JTF_DATE_TABLE
1373: , x_return_status out nocopy VARCHAR2
1374: , x_msg_count out nocopy NUMBER
1375: , x_msg_data out nocopy VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_NUMBER_TABLE
1378: , p5_a2 JTF_NUMBER_TABLE
1379: , p5_a3 JTF_NUMBER_TABLE
1380: , p5_a4 JTF_DATE_TABLE
1381: , p5_a5 JTF_DATE_TABLE
1374: , x_msg_count out nocopy NUMBER
1375: , x_msg_data out nocopy VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_NUMBER_TABLE
1378: , p5_a2 JTF_NUMBER_TABLE
1379: , p5_a3 JTF_NUMBER_TABLE
1380: , p5_a4 JTF_DATE_TABLE
1381: , p5_a5 JTF_DATE_TABLE
1382: , p5_a6 JTF_VARCHAR2_TABLE_2000
1375: , x_msg_data out nocopy VARCHAR2
1376: , p5_a0 JTF_NUMBER_TABLE
1377: , p5_a1 JTF_NUMBER_TABLE
1378: , p5_a2 JTF_NUMBER_TABLE
1379: , p5_a3 JTF_NUMBER_TABLE
1380: , p5_a4 JTF_DATE_TABLE
1381: , p5_a5 JTF_DATE_TABLE
1382: , p5_a6 JTF_VARCHAR2_TABLE_2000
1383: , p5_a7 JTF_VARCHAR2_TABLE_100
1380: , p5_a4 JTF_DATE_TABLE
1381: , p5_a5 JTF_DATE_TABLE
1382: , p5_a6 JTF_VARCHAR2_TABLE_2000
1383: , p5_a7 JTF_VARCHAR2_TABLE_100
1384: , p5_a8 JTF_NUMBER_TABLE
1385: , p5_a9 JTF_NUMBER_TABLE
1386: , p5_a10 JTF_VARCHAR2_TABLE_100
1387: , p5_a11 JTF_VARCHAR2_TABLE_500
1388: , p5_a12 JTF_VARCHAR2_TABLE_500
1381: , p5_a5 JTF_DATE_TABLE
1382: , p5_a6 JTF_VARCHAR2_TABLE_2000
1383: , p5_a7 JTF_VARCHAR2_TABLE_100
1384: , p5_a8 JTF_NUMBER_TABLE
1385: , p5_a9 JTF_NUMBER_TABLE
1386: , p5_a10 JTF_VARCHAR2_TABLE_100
1387: , p5_a11 JTF_VARCHAR2_TABLE_500
1388: , p5_a12 JTF_VARCHAR2_TABLE_500
1389: , p5_a13 JTF_VARCHAR2_TABLE_500
1398: , p5_a22 JTF_VARCHAR2_TABLE_500
1399: , p5_a23 JTF_VARCHAR2_TABLE_500
1400: , p5_a24 JTF_VARCHAR2_TABLE_500
1401: , p5_a25 JTF_VARCHAR2_TABLE_500
1402: , p5_a26 JTF_NUMBER_TABLE
1403: , p5_a27 JTF_NUMBER_TABLE
1404: , p5_a28 JTF_NUMBER_TABLE
1405: , p5_a29 JTF_DATE_TABLE
1406: , p5_a30 JTF_NUMBER_TABLE
1399: , p5_a23 JTF_VARCHAR2_TABLE_500
1400: , p5_a24 JTF_VARCHAR2_TABLE_500
1401: , p5_a25 JTF_VARCHAR2_TABLE_500
1402: , p5_a26 JTF_NUMBER_TABLE
1403: , p5_a27 JTF_NUMBER_TABLE
1404: , p5_a28 JTF_NUMBER_TABLE
1405: , p5_a29 JTF_DATE_TABLE
1406: , p5_a30 JTF_NUMBER_TABLE
1407: , p5_a31 JTF_DATE_TABLE
1400: , p5_a24 JTF_VARCHAR2_TABLE_500
1401: , p5_a25 JTF_VARCHAR2_TABLE_500
1402: , p5_a26 JTF_NUMBER_TABLE
1403: , p5_a27 JTF_NUMBER_TABLE
1404: , p5_a28 JTF_NUMBER_TABLE
1405: , p5_a29 JTF_DATE_TABLE
1406: , p5_a30 JTF_NUMBER_TABLE
1407: , p5_a31 JTF_DATE_TABLE
1408: , p5_a32 JTF_NUMBER_TABLE
1402: , p5_a26 JTF_NUMBER_TABLE
1403: , p5_a27 JTF_NUMBER_TABLE
1404: , p5_a28 JTF_NUMBER_TABLE
1405: , p5_a29 JTF_DATE_TABLE
1406: , p5_a30 JTF_NUMBER_TABLE
1407: , p5_a31 JTF_DATE_TABLE
1408: , p5_a32 JTF_NUMBER_TABLE
1409: , p5_a33 JTF_DATE_TABLE
1410: , p5_a34 JTF_NUMBER_TABLE
1404: , p5_a28 JTF_NUMBER_TABLE
1405: , p5_a29 JTF_DATE_TABLE
1406: , p5_a30 JTF_NUMBER_TABLE
1407: , p5_a31 JTF_DATE_TABLE
1408: , p5_a32 JTF_NUMBER_TABLE
1409: , p5_a33 JTF_DATE_TABLE
1410: , p5_a34 JTF_NUMBER_TABLE
1411: )
1412:
1406: , p5_a30 JTF_NUMBER_TABLE
1407: , p5_a31 JTF_DATE_TABLE
1408: , p5_a32 JTF_NUMBER_TABLE
1409: , p5_a33 JTF_DATE_TABLE
1410: , p5_a34 JTF_NUMBER_TABLE
1411: )
1412:
1413: as
1414: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
1657: , p_init_msg_list VARCHAR2
1658: , x_return_status out nocopy VARCHAR2
1659: , x_msg_count out nocopy NUMBER
1660: , x_msg_data out nocopy VARCHAR2
1661: , p5_a0 JTF_NUMBER_TABLE
1662: , p5_a1 JTF_NUMBER_TABLE
1663: , p5_a2 JTF_NUMBER_TABLE
1664: , p5_a3 JTF_NUMBER_TABLE
1665: , p5_a4 JTF_DATE_TABLE
1658: , x_return_status out nocopy VARCHAR2
1659: , x_msg_count out nocopy NUMBER
1660: , x_msg_data out nocopy VARCHAR2
1661: , p5_a0 JTF_NUMBER_TABLE
1662: , p5_a1 JTF_NUMBER_TABLE
1663: , p5_a2 JTF_NUMBER_TABLE
1664: , p5_a3 JTF_NUMBER_TABLE
1665: , p5_a4 JTF_DATE_TABLE
1666: , p5_a5 JTF_DATE_TABLE
1659: , x_msg_count out nocopy NUMBER
1660: , x_msg_data out nocopy VARCHAR2
1661: , p5_a0 JTF_NUMBER_TABLE
1662: , p5_a1 JTF_NUMBER_TABLE
1663: , p5_a2 JTF_NUMBER_TABLE
1664: , p5_a3 JTF_NUMBER_TABLE
1665: , p5_a4 JTF_DATE_TABLE
1666: , p5_a5 JTF_DATE_TABLE
1667: , p5_a6 JTF_VARCHAR2_TABLE_2000
1660: , x_msg_data out nocopy VARCHAR2
1661: , p5_a0 JTF_NUMBER_TABLE
1662: , p5_a1 JTF_NUMBER_TABLE
1663: , p5_a2 JTF_NUMBER_TABLE
1664: , p5_a3 JTF_NUMBER_TABLE
1665: , p5_a4 JTF_DATE_TABLE
1666: , p5_a5 JTF_DATE_TABLE
1667: , p5_a6 JTF_VARCHAR2_TABLE_2000
1668: , p5_a7 JTF_VARCHAR2_TABLE_100
1665: , p5_a4 JTF_DATE_TABLE
1666: , p5_a5 JTF_DATE_TABLE
1667: , p5_a6 JTF_VARCHAR2_TABLE_2000
1668: , p5_a7 JTF_VARCHAR2_TABLE_100
1669: , p5_a8 JTF_NUMBER_TABLE
1670: , p5_a9 JTF_NUMBER_TABLE
1671: , p5_a10 JTF_VARCHAR2_TABLE_100
1672: , p5_a11 JTF_VARCHAR2_TABLE_500
1673: , p5_a12 JTF_VARCHAR2_TABLE_500
1666: , p5_a5 JTF_DATE_TABLE
1667: , p5_a6 JTF_VARCHAR2_TABLE_2000
1668: , p5_a7 JTF_VARCHAR2_TABLE_100
1669: , p5_a8 JTF_NUMBER_TABLE
1670: , p5_a9 JTF_NUMBER_TABLE
1671: , p5_a10 JTF_VARCHAR2_TABLE_100
1672: , p5_a11 JTF_VARCHAR2_TABLE_500
1673: , p5_a12 JTF_VARCHAR2_TABLE_500
1674: , p5_a13 JTF_VARCHAR2_TABLE_500
1683: , p5_a22 JTF_VARCHAR2_TABLE_500
1684: , p5_a23 JTF_VARCHAR2_TABLE_500
1685: , p5_a24 JTF_VARCHAR2_TABLE_500
1686: , p5_a25 JTF_VARCHAR2_TABLE_500
1687: , p5_a26 JTF_NUMBER_TABLE
1688: , p5_a27 JTF_NUMBER_TABLE
1689: , p5_a28 JTF_NUMBER_TABLE
1690: , p5_a29 JTF_DATE_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1684: , p5_a23 JTF_VARCHAR2_TABLE_500
1685: , p5_a24 JTF_VARCHAR2_TABLE_500
1686: , p5_a25 JTF_VARCHAR2_TABLE_500
1687: , p5_a26 JTF_NUMBER_TABLE
1688: , p5_a27 JTF_NUMBER_TABLE
1689: , p5_a28 JTF_NUMBER_TABLE
1690: , p5_a29 JTF_DATE_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1685: , p5_a24 JTF_VARCHAR2_TABLE_500
1686: , p5_a25 JTF_VARCHAR2_TABLE_500
1687: , p5_a26 JTF_NUMBER_TABLE
1688: , p5_a27 JTF_NUMBER_TABLE
1689: , p5_a28 JTF_NUMBER_TABLE
1690: , p5_a29 JTF_DATE_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1687: , p5_a26 JTF_NUMBER_TABLE
1688: , p5_a27 JTF_NUMBER_TABLE
1689: , p5_a28 JTF_NUMBER_TABLE
1690: , p5_a29 JTF_DATE_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1689: , p5_a28 JTF_NUMBER_TABLE
1690: , p5_a29 JTF_DATE_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1691: , p5_a30 JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1698: , p6_a2 out nocopy JTF_NUMBER_TABLE
1699: , p6_a3 out nocopy JTF_NUMBER_TABLE
1692: , p5_a31 JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1698: , p6_a2 out nocopy JTF_NUMBER_TABLE
1699: , p6_a3 out nocopy JTF_NUMBER_TABLE
1700: , p6_a4 out nocopy JTF_DATE_TABLE
1693: , p5_a32 JTF_NUMBER_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1698: , p6_a2 out nocopy JTF_NUMBER_TABLE
1699: , p6_a3 out nocopy JTF_NUMBER_TABLE
1700: , p6_a4 out nocopy JTF_DATE_TABLE
1701: , p6_a5 out nocopy JTF_DATE_TABLE
1694: , p5_a33 JTF_DATE_TABLE
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1698: , p6_a2 out nocopy JTF_NUMBER_TABLE
1699: , p6_a3 out nocopy JTF_NUMBER_TABLE
1700: , p6_a4 out nocopy JTF_DATE_TABLE
1701: , p6_a5 out nocopy JTF_DATE_TABLE
1702: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1695: , p5_a34 JTF_NUMBER_TABLE
1696: , p6_a0 out nocopy JTF_NUMBER_TABLE
1697: , p6_a1 out nocopy JTF_NUMBER_TABLE
1698: , p6_a2 out nocopy JTF_NUMBER_TABLE
1699: , p6_a3 out nocopy JTF_NUMBER_TABLE
1700: , p6_a4 out nocopy JTF_DATE_TABLE
1701: , p6_a5 out nocopy JTF_DATE_TABLE
1702: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1703: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1700: , p6_a4 out nocopy JTF_DATE_TABLE
1701: , p6_a5 out nocopy JTF_DATE_TABLE
1702: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1703: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1704: , p6_a8 out nocopy JTF_NUMBER_TABLE
1705: , p6_a9 out nocopy JTF_NUMBER_TABLE
1706: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1708: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1701: , p6_a5 out nocopy JTF_DATE_TABLE
1702: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1703: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1704: , p6_a8 out nocopy JTF_NUMBER_TABLE
1705: , p6_a9 out nocopy JTF_NUMBER_TABLE
1706: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1708: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1709: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1718: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1719: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1720: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1721: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1722: , p6_a26 out nocopy JTF_NUMBER_TABLE
1723: , p6_a27 out nocopy JTF_NUMBER_TABLE
1724: , p6_a28 out nocopy JTF_NUMBER_TABLE
1725: , p6_a29 out nocopy JTF_DATE_TABLE
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1719: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1720: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1721: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1722: , p6_a26 out nocopy JTF_NUMBER_TABLE
1723: , p6_a27 out nocopy JTF_NUMBER_TABLE
1724: , p6_a28 out nocopy JTF_NUMBER_TABLE
1725: , p6_a29 out nocopy JTF_DATE_TABLE
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1720: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1721: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1722: , p6_a26 out nocopy JTF_NUMBER_TABLE
1723: , p6_a27 out nocopy JTF_NUMBER_TABLE
1724: , p6_a28 out nocopy JTF_NUMBER_TABLE
1725: , p6_a29 out nocopy JTF_DATE_TABLE
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1728: , p6_a32 out nocopy JTF_NUMBER_TABLE
1722: , p6_a26 out nocopy JTF_NUMBER_TABLE
1723: , p6_a27 out nocopy JTF_NUMBER_TABLE
1724: , p6_a28 out nocopy JTF_NUMBER_TABLE
1725: , p6_a29 out nocopy JTF_DATE_TABLE
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1728: , p6_a32 out nocopy JTF_NUMBER_TABLE
1729: , p6_a33 out nocopy JTF_DATE_TABLE
1730: , p6_a34 out nocopy JTF_NUMBER_TABLE
1724: , p6_a28 out nocopy JTF_NUMBER_TABLE
1725: , p6_a29 out nocopy JTF_DATE_TABLE
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1728: , p6_a32 out nocopy JTF_NUMBER_TABLE
1729: , p6_a33 out nocopy JTF_DATE_TABLE
1730: , p6_a34 out nocopy JTF_NUMBER_TABLE
1731: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1732: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1726: , p6_a30 out nocopy JTF_NUMBER_TABLE
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1728: , p6_a32 out nocopy JTF_NUMBER_TABLE
1729: , p6_a33 out nocopy JTF_DATE_TABLE
1730: , p6_a34 out nocopy JTF_NUMBER_TABLE
1731: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1732: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1733: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1734: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1727: , p6_a31 out nocopy JTF_DATE_TABLE
1728: , p6_a32 out nocopy JTF_NUMBER_TABLE
1729: , p6_a33 out nocopy JTF_DATE_TABLE
1730: , p6_a34 out nocopy JTF_NUMBER_TABLE
1731: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1732: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1733: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1734: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1735: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1729: , p6_a33 out nocopy JTF_DATE_TABLE
1730: , p6_a34 out nocopy JTF_NUMBER_TABLE
1731: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1732: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1733: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1734: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1735: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1736: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1737: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1731: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1732: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1733: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1734: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1735: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1736: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1737: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1738: )
1739:
1865: , p_init_msg_list VARCHAR2
1866: , x_return_status out nocopy VARCHAR2
1867: , x_msg_count out nocopy NUMBER
1868: , x_msg_data out nocopy VARCHAR2
1869: , p5_a0 JTF_NUMBER_TABLE
1870: , p5_a1 JTF_NUMBER_TABLE
1871: , p5_a2 JTF_NUMBER_TABLE
1872: , p5_a3 JTF_NUMBER_TABLE
1873: , p5_a4 JTF_DATE_TABLE
1866: , x_return_status out nocopy VARCHAR2
1867: , x_msg_count out nocopy NUMBER
1868: , x_msg_data out nocopy VARCHAR2
1869: , p5_a0 JTF_NUMBER_TABLE
1870: , p5_a1 JTF_NUMBER_TABLE
1871: , p5_a2 JTF_NUMBER_TABLE
1872: , p5_a3 JTF_NUMBER_TABLE
1873: , p5_a4 JTF_DATE_TABLE
1874: , p5_a5 JTF_DATE_TABLE
1867: , x_msg_count out nocopy NUMBER
1868: , x_msg_data out nocopy VARCHAR2
1869: , p5_a0 JTF_NUMBER_TABLE
1870: , p5_a1 JTF_NUMBER_TABLE
1871: , p5_a2 JTF_NUMBER_TABLE
1872: , p5_a3 JTF_NUMBER_TABLE
1873: , p5_a4 JTF_DATE_TABLE
1874: , p5_a5 JTF_DATE_TABLE
1875: , p5_a6 JTF_VARCHAR2_TABLE_2000
1868: , x_msg_data out nocopy VARCHAR2
1869: , p5_a0 JTF_NUMBER_TABLE
1870: , p5_a1 JTF_NUMBER_TABLE
1871: , p5_a2 JTF_NUMBER_TABLE
1872: , p5_a3 JTF_NUMBER_TABLE
1873: , p5_a4 JTF_DATE_TABLE
1874: , p5_a5 JTF_DATE_TABLE
1875: , p5_a6 JTF_VARCHAR2_TABLE_2000
1876: , p5_a7 JTF_VARCHAR2_TABLE_100
1873: , p5_a4 JTF_DATE_TABLE
1874: , p5_a5 JTF_DATE_TABLE
1875: , p5_a6 JTF_VARCHAR2_TABLE_2000
1876: , p5_a7 JTF_VARCHAR2_TABLE_100
1877: , p5_a8 JTF_NUMBER_TABLE
1878: , p5_a9 JTF_NUMBER_TABLE
1879: , p5_a10 JTF_VARCHAR2_TABLE_100
1880: , p5_a11 JTF_VARCHAR2_TABLE_500
1881: , p5_a12 JTF_VARCHAR2_TABLE_500
1874: , p5_a5 JTF_DATE_TABLE
1875: , p5_a6 JTF_VARCHAR2_TABLE_2000
1876: , p5_a7 JTF_VARCHAR2_TABLE_100
1877: , p5_a8 JTF_NUMBER_TABLE
1878: , p5_a9 JTF_NUMBER_TABLE
1879: , p5_a10 JTF_VARCHAR2_TABLE_100
1880: , p5_a11 JTF_VARCHAR2_TABLE_500
1881: , p5_a12 JTF_VARCHAR2_TABLE_500
1882: , p5_a13 JTF_VARCHAR2_TABLE_500
1891: , p5_a22 JTF_VARCHAR2_TABLE_500
1892: , p5_a23 JTF_VARCHAR2_TABLE_500
1893: , p5_a24 JTF_VARCHAR2_TABLE_500
1894: , p5_a25 JTF_VARCHAR2_TABLE_500
1895: , p5_a26 JTF_NUMBER_TABLE
1896: , p5_a27 JTF_NUMBER_TABLE
1897: , p5_a28 JTF_NUMBER_TABLE
1898: , p5_a29 JTF_DATE_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1892: , p5_a23 JTF_VARCHAR2_TABLE_500
1893: , p5_a24 JTF_VARCHAR2_TABLE_500
1894: , p5_a25 JTF_VARCHAR2_TABLE_500
1895: , p5_a26 JTF_NUMBER_TABLE
1896: , p5_a27 JTF_NUMBER_TABLE
1897: , p5_a28 JTF_NUMBER_TABLE
1898: , p5_a29 JTF_DATE_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1893: , p5_a24 JTF_VARCHAR2_TABLE_500
1894: , p5_a25 JTF_VARCHAR2_TABLE_500
1895: , p5_a26 JTF_NUMBER_TABLE
1896: , p5_a27 JTF_NUMBER_TABLE
1897: , p5_a28 JTF_NUMBER_TABLE
1898: , p5_a29 JTF_DATE_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1895: , p5_a26 JTF_NUMBER_TABLE
1896: , p5_a27 JTF_NUMBER_TABLE
1897: , p5_a28 JTF_NUMBER_TABLE
1898: , p5_a29 JTF_DATE_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1897: , p5_a28 JTF_NUMBER_TABLE
1898: , p5_a29 JTF_DATE_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1899: , p5_a30 JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1906: , p6_a2 out nocopy JTF_NUMBER_TABLE
1907: , p6_a3 out nocopy JTF_NUMBER_TABLE
1900: , p5_a31 JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1906: , p6_a2 out nocopy JTF_NUMBER_TABLE
1907: , p6_a3 out nocopy JTF_NUMBER_TABLE
1908: , p6_a4 out nocopy JTF_DATE_TABLE
1901: , p5_a32 JTF_NUMBER_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1906: , p6_a2 out nocopy JTF_NUMBER_TABLE
1907: , p6_a3 out nocopy JTF_NUMBER_TABLE
1908: , p6_a4 out nocopy JTF_DATE_TABLE
1909: , p6_a5 out nocopy JTF_DATE_TABLE
1902: , p5_a33 JTF_DATE_TABLE
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1906: , p6_a2 out nocopy JTF_NUMBER_TABLE
1907: , p6_a3 out nocopy JTF_NUMBER_TABLE
1908: , p6_a4 out nocopy JTF_DATE_TABLE
1909: , p6_a5 out nocopy JTF_DATE_TABLE
1910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1903: , p5_a34 JTF_NUMBER_TABLE
1904: , p6_a0 out nocopy JTF_NUMBER_TABLE
1905: , p6_a1 out nocopy JTF_NUMBER_TABLE
1906: , p6_a2 out nocopy JTF_NUMBER_TABLE
1907: , p6_a3 out nocopy JTF_NUMBER_TABLE
1908: , p6_a4 out nocopy JTF_DATE_TABLE
1909: , p6_a5 out nocopy JTF_DATE_TABLE
1910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a4 out nocopy JTF_DATE_TABLE
1909: , p6_a5 out nocopy JTF_DATE_TABLE
1910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1912: , p6_a8 out nocopy JTF_NUMBER_TABLE
1913: , p6_a9 out nocopy JTF_NUMBER_TABLE
1914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1915: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1916: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1909: , p6_a5 out nocopy JTF_DATE_TABLE
1910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1912: , p6_a8 out nocopy JTF_NUMBER_TABLE
1913: , p6_a9 out nocopy JTF_NUMBER_TABLE
1914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1915: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1916: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1917: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1926: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1927: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1928: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1929: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1930: , p6_a26 out nocopy JTF_NUMBER_TABLE
1931: , p6_a27 out nocopy JTF_NUMBER_TABLE
1932: , p6_a28 out nocopy JTF_NUMBER_TABLE
1933: , p6_a29 out nocopy JTF_DATE_TABLE
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1927: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1928: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1929: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1930: , p6_a26 out nocopy JTF_NUMBER_TABLE
1931: , p6_a27 out nocopy JTF_NUMBER_TABLE
1932: , p6_a28 out nocopy JTF_NUMBER_TABLE
1933: , p6_a29 out nocopy JTF_DATE_TABLE
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1935: , p6_a31 out nocopy JTF_DATE_TABLE
1928: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1929: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1930: , p6_a26 out nocopy JTF_NUMBER_TABLE
1931: , p6_a27 out nocopy JTF_NUMBER_TABLE
1932: , p6_a28 out nocopy JTF_NUMBER_TABLE
1933: , p6_a29 out nocopy JTF_DATE_TABLE
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1935: , p6_a31 out nocopy JTF_DATE_TABLE
1936: , p6_a32 out nocopy JTF_NUMBER_TABLE
1930: , p6_a26 out nocopy JTF_NUMBER_TABLE
1931: , p6_a27 out nocopy JTF_NUMBER_TABLE
1932: , p6_a28 out nocopy JTF_NUMBER_TABLE
1933: , p6_a29 out nocopy JTF_DATE_TABLE
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1935: , p6_a31 out nocopy JTF_DATE_TABLE
1936: , p6_a32 out nocopy JTF_NUMBER_TABLE
1937: , p6_a33 out nocopy JTF_DATE_TABLE
1938: , p6_a34 out nocopy JTF_NUMBER_TABLE
1932: , p6_a28 out nocopy JTF_NUMBER_TABLE
1933: , p6_a29 out nocopy JTF_DATE_TABLE
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1935: , p6_a31 out nocopy JTF_DATE_TABLE
1936: , p6_a32 out nocopy JTF_NUMBER_TABLE
1937: , p6_a33 out nocopy JTF_DATE_TABLE
1938: , p6_a34 out nocopy JTF_NUMBER_TABLE
1939: )
1940:
1934: , p6_a30 out nocopy JTF_NUMBER_TABLE
1935: , p6_a31 out nocopy JTF_DATE_TABLE
1936: , p6_a32 out nocopy JTF_NUMBER_TABLE
1937: , p6_a33 out nocopy JTF_DATE_TABLE
1938: , p6_a34 out nocopy JTF_NUMBER_TABLE
1939: )
1940:
1941: as
1942: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2151: , p_init_msg_list VARCHAR2
2152: , x_return_status out nocopy VARCHAR2
2153: , x_msg_count out nocopy NUMBER
2154: , x_msg_data out nocopy VARCHAR2
2155: , p5_a0 JTF_NUMBER_TABLE
2156: , p5_a1 JTF_NUMBER_TABLE
2157: , p5_a2 JTF_NUMBER_TABLE
2158: , p5_a3 JTF_NUMBER_TABLE
2159: , p5_a4 JTF_DATE_TABLE
2152: , x_return_status out nocopy VARCHAR2
2153: , x_msg_count out nocopy NUMBER
2154: , x_msg_data out nocopy VARCHAR2
2155: , p5_a0 JTF_NUMBER_TABLE
2156: , p5_a1 JTF_NUMBER_TABLE
2157: , p5_a2 JTF_NUMBER_TABLE
2158: , p5_a3 JTF_NUMBER_TABLE
2159: , p5_a4 JTF_DATE_TABLE
2160: , p5_a5 JTF_DATE_TABLE
2153: , x_msg_count out nocopy NUMBER
2154: , x_msg_data out nocopy VARCHAR2
2155: , p5_a0 JTF_NUMBER_TABLE
2156: , p5_a1 JTF_NUMBER_TABLE
2157: , p5_a2 JTF_NUMBER_TABLE
2158: , p5_a3 JTF_NUMBER_TABLE
2159: , p5_a4 JTF_DATE_TABLE
2160: , p5_a5 JTF_DATE_TABLE
2161: , p5_a6 JTF_VARCHAR2_TABLE_2000
2154: , x_msg_data out nocopy VARCHAR2
2155: , p5_a0 JTF_NUMBER_TABLE
2156: , p5_a1 JTF_NUMBER_TABLE
2157: , p5_a2 JTF_NUMBER_TABLE
2158: , p5_a3 JTF_NUMBER_TABLE
2159: , p5_a4 JTF_DATE_TABLE
2160: , p5_a5 JTF_DATE_TABLE
2161: , p5_a6 JTF_VARCHAR2_TABLE_2000
2162: , p5_a7 JTF_VARCHAR2_TABLE_100
2159: , p5_a4 JTF_DATE_TABLE
2160: , p5_a5 JTF_DATE_TABLE
2161: , p5_a6 JTF_VARCHAR2_TABLE_2000
2162: , p5_a7 JTF_VARCHAR2_TABLE_100
2163: , p5_a8 JTF_NUMBER_TABLE
2164: , p5_a9 JTF_NUMBER_TABLE
2165: , p5_a10 JTF_VARCHAR2_TABLE_100
2166: , p5_a11 JTF_VARCHAR2_TABLE_500
2167: , p5_a12 JTF_VARCHAR2_TABLE_500
2160: , p5_a5 JTF_DATE_TABLE
2161: , p5_a6 JTF_VARCHAR2_TABLE_2000
2162: , p5_a7 JTF_VARCHAR2_TABLE_100
2163: , p5_a8 JTF_NUMBER_TABLE
2164: , p5_a9 JTF_NUMBER_TABLE
2165: , p5_a10 JTF_VARCHAR2_TABLE_100
2166: , p5_a11 JTF_VARCHAR2_TABLE_500
2167: , p5_a12 JTF_VARCHAR2_TABLE_500
2168: , p5_a13 JTF_VARCHAR2_TABLE_500
2177: , p5_a22 JTF_VARCHAR2_TABLE_500
2178: , p5_a23 JTF_VARCHAR2_TABLE_500
2179: , p5_a24 JTF_VARCHAR2_TABLE_500
2180: , p5_a25 JTF_VARCHAR2_TABLE_500
2181: , p5_a26 JTF_NUMBER_TABLE
2182: , p5_a27 JTF_NUMBER_TABLE
2183: , p5_a28 JTF_NUMBER_TABLE
2184: , p5_a29 JTF_DATE_TABLE
2185: , p5_a30 JTF_NUMBER_TABLE
2178: , p5_a23 JTF_VARCHAR2_TABLE_500
2179: , p5_a24 JTF_VARCHAR2_TABLE_500
2180: , p5_a25 JTF_VARCHAR2_TABLE_500
2181: , p5_a26 JTF_NUMBER_TABLE
2182: , p5_a27 JTF_NUMBER_TABLE
2183: , p5_a28 JTF_NUMBER_TABLE
2184: , p5_a29 JTF_DATE_TABLE
2185: , p5_a30 JTF_NUMBER_TABLE
2186: , p5_a31 JTF_DATE_TABLE
2179: , p5_a24 JTF_VARCHAR2_TABLE_500
2180: , p5_a25 JTF_VARCHAR2_TABLE_500
2181: , p5_a26 JTF_NUMBER_TABLE
2182: , p5_a27 JTF_NUMBER_TABLE
2183: , p5_a28 JTF_NUMBER_TABLE
2184: , p5_a29 JTF_DATE_TABLE
2185: , p5_a30 JTF_NUMBER_TABLE
2186: , p5_a31 JTF_DATE_TABLE
2187: , p5_a32 JTF_NUMBER_TABLE
2181: , p5_a26 JTF_NUMBER_TABLE
2182: , p5_a27 JTF_NUMBER_TABLE
2183: , p5_a28 JTF_NUMBER_TABLE
2184: , p5_a29 JTF_DATE_TABLE
2185: , p5_a30 JTF_NUMBER_TABLE
2186: , p5_a31 JTF_DATE_TABLE
2187: , p5_a32 JTF_NUMBER_TABLE
2188: , p5_a33 JTF_DATE_TABLE
2189: , p5_a34 JTF_NUMBER_TABLE
2183: , p5_a28 JTF_NUMBER_TABLE
2184: , p5_a29 JTF_DATE_TABLE
2185: , p5_a30 JTF_NUMBER_TABLE
2186: , p5_a31 JTF_DATE_TABLE
2187: , p5_a32 JTF_NUMBER_TABLE
2188: , p5_a33 JTF_DATE_TABLE
2189: , p5_a34 JTF_NUMBER_TABLE
2190: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2191: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2185: , p5_a30 JTF_NUMBER_TABLE
2186: , p5_a31 JTF_DATE_TABLE
2187: , p5_a32 JTF_NUMBER_TABLE
2188: , p5_a33 JTF_DATE_TABLE
2189: , p5_a34 JTF_NUMBER_TABLE
2190: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2191: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2192: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2193: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2186: , p5_a31 JTF_DATE_TABLE
2187: , p5_a32 JTF_NUMBER_TABLE
2188: , p5_a33 JTF_DATE_TABLE
2189: , p5_a34 JTF_NUMBER_TABLE
2190: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2191: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2192: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2193: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2194: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2188: , p5_a33 JTF_DATE_TABLE
2189: , p5_a34 JTF_NUMBER_TABLE
2190: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2191: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2192: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2193: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2194: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2195: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2190: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2191: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2192: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2193: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2194: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2195: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2196: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2197: )
2198:
2284: , p_init_msg_list VARCHAR2
2285: , x_return_status out nocopy VARCHAR2
2286: , x_msg_count out nocopy NUMBER
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_NUMBER_TABLE
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_NUMBER_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2285: , x_return_status out nocopy VARCHAR2
2286: , x_msg_count out nocopy NUMBER
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_NUMBER_TABLE
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_NUMBER_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2286: , x_msg_count out nocopy NUMBER
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_NUMBER_TABLE
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_NUMBER_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_2000
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_NUMBER_TABLE
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_NUMBER_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_2000
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_2000
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_VARCHAR2_TABLE_100
2299: , p5_a11 JTF_VARCHAR2_TABLE_500
2300: , p5_a12 JTF_VARCHAR2_TABLE_500
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_2000
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_VARCHAR2_TABLE_100
2299: , p5_a11 JTF_VARCHAR2_TABLE_500
2300: , p5_a12 JTF_VARCHAR2_TABLE_500
2301: , p5_a13 JTF_VARCHAR2_TABLE_500
2310: , p5_a22 JTF_VARCHAR2_TABLE_500
2311: , p5_a23 JTF_VARCHAR2_TABLE_500
2312: , p5_a24 JTF_VARCHAR2_TABLE_500
2313: , p5_a25 JTF_VARCHAR2_TABLE_500
2314: , p5_a26 JTF_NUMBER_TABLE
2315: , p5_a27 JTF_NUMBER_TABLE
2316: , p5_a28 JTF_NUMBER_TABLE
2317: , p5_a29 JTF_DATE_TABLE
2318: , p5_a30 JTF_NUMBER_TABLE
2311: , p5_a23 JTF_VARCHAR2_TABLE_500
2312: , p5_a24 JTF_VARCHAR2_TABLE_500
2313: , p5_a25 JTF_VARCHAR2_TABLE_500
2314: , p5_a26 JTF_NUMBER_TABLE
2315: , p5_a27 JTF_NUMBER_TABLE
2316: , p5_a28 JTF_NUMBER_TABLE
2317: , p5_a29 JTF_DATE_TABLE
2318: , p5_a30 JTF_NUMBER_TABLE
2319: , p5_a31 JTF_DATE_TABLE
2312: , p5_a24 JTF_VARCHAR2_TABLE_500
2313: , p5_a25 JTF_VARCHAR2_TABLE_500
2314: , p5_a26 JTF_NUMBER_TABLE
2315: , p5_a27 JTF_NUMBER_TABLE
2316: , p5_a28 JTF_NUMBER_TABLE
2317: , p5_a29 JTF_DATE_TABLE
2318: , p5_a30 JTF_NUMBER_TABLE
2319: , p5_a31 JTF_DATE_TABLE
2320: , p5_a32 JTF_NUMBER_TABLE
2314: , p5_a26 JTF_NUMBER_TABLE
2315: , p5_a27 JTF_NUMBER_TABLE
2316: , p5_a28 JTF_NUMBER_TABLE
2317: , p5_a29 JTF_DATE_TABLE
2318: , p5_a30 JTF_NUMBER_TABLE
2319: , p5_a31 JTF_DATE_TABLE
2320: , p5_a32 JTF_NUMBER_TABLE
2321: , p5_a33 JTF_DATE_TABLE
2322: , p5_a34 JTF_NUMBER_TABLE
2316: , p5_a28 JTF_NUMBER_TABLE
2317: , p5_a29 JTF_DATE_TABLE
2318: , p5_a30 JTF_NUMBER_TABLE
2319: , p5_a31 JTF_DATE_TABLE
2320: , p5_a32 JTF_NUMBER_TABLE
2321: , p5_a33 JTF_DATE_TABLE
2322: , p5_a34 JTF_NUMBER_TABLE
2323: )
2324:
2318: , p5_a30 JTF_NUMBER_TABLE
2319: , p5_a31 JTF_DATE_TABLE
2320: , p5_a32 JTF_NUMBER_TABLE
2321: , p5_a33 JTF_DATE_TABLE
2322: , p5_a34 JTF_NUMBER_TABLE
2323: )
2324:
2325: as
2326: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;
2495: , p_init_msg_list VARCHAR2
2496: , x_return_status out nocopy VARCHAR2
2497: , x_msg_count out nocopy NUMBER
2498: , x_msg_data out nocopy VARCHAR2
2499: , p5_a0 JTF_NUMBER_TABLE
2500: , p5_a1 JTF_NUMBER_TABLE
2501: , p5_a2 JTF_NUMBER_TABLE
2502: , p5_a3 JTF_NUMBER_TABLE
2503: , p5_a4 JTF_DATE_TABLE
2496: , x_return_status out nocopy VARCHAR2
2497: , x_msg_count out nocopy NUMBER
2498: , x_msg_data out nocopy VARCHAR2
2499: , p5_a0 JTF_NUMBER_TABLE
2500: , p5_a1 JTF_NUMBER_TABLE
2501: , p5_a2 JTF_NUMBER_TABLE
2502: , p5_a3 JTF_NUMBER_TABLE
2503: , p5_a4 JTF_DATE_TABLE
2504: , p5_a5 JTF_DATE_TABLE
2497: , x_msg_count out nocopy NUMBER
2498: , x_msg_data out nocopy VARCHAR2
2499: , p5_a0 JTF_NUMBER_TABLE
2500: , p5_a1 JTF_NUMBER_TABLE
2501: , p5_a2 JTF_NUMBER_TABLE
2502: , p5_a3 JTF_NUMBER_TABLE
2503: , p5_a4 JTF_DATE_TABLE
2504: , p5_a5 JTF_DATE_TABLE
2505: , p5_a6 JTF_VARCHAR2_TABLE_2000
2498: , x_msg_data out nocopy VARCHAR2
2499: , p5_a0 JTF_NUMBER_TABLE
2500: , p5_a1 JTF_NUMBER_TABLE
2501: , p5_a2 JTF_NUMBER_TABLE
2502: , p5_a3 JTF_NUMBER_TABLE
2503: , p5_a4 JTF_DATE_TABLE
2504: , p5_a5 JTF_DATE_TABLE
2505: , p5_a6 JTF_VARCHAR2_TABLE_2000
2506: , p5_a7 JTF_VARCHAR2_TABLE_100
2503: , p5_a4 JTF_DATE_TABLE
2504: , p5_a5 JTF_DATE_TABLE
2505: , p5_a6 JTF_VARCHAR2_TABLE_2000
2506: , p5_a7 JTF_VARCHAR2_TABLE_100
2507: , p5_a8 JTF_NUMBER_TABLE
2508: , p5_a9 JTF_NUMBER_TABLE
2509: , p5_a10 JTF_VARCHAR2_TABLE_100
2510: , p5_a11 JTF_VARCHAR2_TABLE_500
2511: , p5_a12 JTF_VARCHAR2_TABLE_500
2504: , p5_a5 JTF_DATE_TABLE
2505: , p5_a6 JTF_VARCHAR2_TABLE_2000
2506: , p5_a7 JTF_VARCHAR2_TABLE_100
2507: , p5_a8 JTF_NUMBER_TABLE
2508: , p5_a9 JTF_NUMBER_TABLE
2509: , p5_a10 JTF_VARCHAR2_TABLE_100
2510: , p5_a11 JTF_VARCHAR2_TABLE_500
2511: , p5_a12 JTF_VARCHAR2_TABLE_500
2512: , p5_a13 JTF_VARCHAR2_TABLE_500
2521: , p5_a22 JTF_VARCHAR2_TABLE_500
2522: , p5_a23 JTF_VARCHAR2_TABLE_500
2523: , p5_a24 JTF_VARCHAR2_TABLE_500
2524: , p5_a25 JTF_VARCHAR2_TABLE_500
2525: , p5_a26 JTF_NUMBER_TABLE
2526: , p5_a27 JTF_NUMBER_TABLE
2527: , p5_a28 JTF_NUMBER_TABLE
2528: , p5_a29 JTF_DATE_TABLE
2529: , p5_a30 JTF_NUMBER_TABLE
2522: , p5_a23 JTF_VARCHAR2_TABLE_500
2523: , p5_a24 JTF_VARCHAR2_TABLE_500
2524: , p5_a25 JTF_VARCHAR2_TABLE_500
2525: , p5_a26 JTF_NUMBER_TABLE
2526: , p5_a27 JTF_NUMBER_TABLE
2527: , p5_a28 JTF_NUMBER_TABLE
2528: , p5_a29 JTF_DATE_TABLE
2529: , p5_a30 JTF_NUMBER_TABLE
2530: , p5_a31 JTF_DATE_TABLE
2523: , p5_a24 JTF_VARCHAR2_TABLE_500
2524: , p5_a25 JTF_VARCHAR2_TABLE_500
2525: , p5_a26 JTF_NUMBER_TABLE
2526: , p5_a27 JTF_NUMBER_TABLE
2527: , p5_a28 JTF_NUMBER_TABLE
2528: , p5_a29 JTF_DATE_TABLE
2529: , p5_a30 JTF_NUMBER_TABLE
2530: , p5_a31 JTF_DATE_TABLE
2531: , p5_a32 JTF_NUMBER_TABLE
2525: , p5_a26 JTF_NUMBER_TABLE
2526: , p5_a27 JTF_NUMBER_TABLE
2527: , p5_a28 JTF_NUMBER_TABLE
2528: , p5_a29 JTF_DATE_TABLE
2529: , p5_a30 JTF_NUMBER_TABLE
2530: , p5_a31 JTF_DATE_TABLE
2531: , p5_a32 JTF_NUMBER_TABLE
2532: , p5_a33 JTF_DATE_TABLE
2533: , p5_a34 JTF_NUMBER_TABLE
2527: , p5_a28 JTF_NUMBER_TABLE
2528: , p5_a29 JTF_DATE_TABLE
2529: , p5_a30 JTF_NUMBER_TABLE
2530: , p5_a31 JTF_DATE_TABLE
2531: , p5_a32 JTF_NUMBER_TABLE
2532: , p5_a33 JTF_DATE_TABLE
2533: , p5_a34 JTF_NUMBER_TABLE
2534: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2535: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2529: , p5_a30 JTF_NUMBER_TABLE
2530: , p5_a31 JTF_DATE_TABLE
2531: , p5_a32 JTF_NUMBER_TABLE
2532: , p5_a33 JTF_DATE_TABLE
2533: , p5_a34 JTF_NUMBER_TABLE
2534: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2535: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2536: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2537: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2530: , p5_a31 JTF_DATE_TABLE
2531: , p5_a32 JTF_NUMBER_TABLE
2532: , p5_a33 JTF_DATE_TABLE
2533: , p5_a34 JTF_NUMBER_TABLE
2534: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2535: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2536: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2537: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2538: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2532: , p5_a33 JTF_DATE_TABLE
2533: , p5_a34 JTF_NUMBER_TABLE
2534: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2535: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2536: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2537: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2538: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2539: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2540: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2534: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2535: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2536: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2537: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2538: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2539: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2540: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2541: )
2542:
2628: , p_init_msg_list VARCHAR2
2629: , x_return_status out nocopy VARCHAR2
2630: , x_msg_count out nocopy NUMBER
2631: , x_msg_data out nocopy VARCHAR2
2632: , p5_a0 JTF_NUMBER_TABLE
2633: , p5_a1 JTF_NUMBER_TABLE
2634: , p5_a2 JTF_NUMBER_TABLE
2635: , p5_a3 JTF_NUMBER_TABLE
2636: , p5_a4 JTF_DATE_TABLE
2629: , x_return_status out nocopy VARCHAR2
2630: , x_msg_count out nocopy NUMBER
2631: , x_msg_data out nocopy VARCHAR2
2632: , p5_a0 JTF_NUMBER_TABLE
2633: , p5_a1 JTF_NUMBER_TABLE
2634: , p5_a2 JTF_NUMBER_TABLE
2635: , p5_a3 JTF_NUMBER_TABLE
2636: , p5_a4 JTF_DATE_TABLE
2637: , p5_a5 JTF_DATE_TABLE
2630: , x_msg_count out nocopy NUMBER
2631: , x_msg_data out nocopy VARCHAR2
2632: , p5_a0 JTF_NUMBER_TABLE
2633: , p5_a1 JTF_NUMBER_TABLE
2634: , p5_a2 JTF_NUMBER_TABLE
2635: , p5_a3 JTF_NUMBER_TABLE
2636: , p5_a4 JTF_DATE_TABLE
2637: , p5_a5 JTF_DATE_TABLE
2638: , p5_a6 JTF_VARCHAR2_TABLE_2000
2631: , x_msg_data out nocopy VARCHAR2
2632: , p5_a0 JTF_NUMBER_TABLE
2633: , p5_a1 JTF_NUMBER_TABLE
2634: , p5_a2 JTF_NUMBER_TABLE
2635: , p5_a3 JTF_NUMBER_TABLE
2636: , p5_a4 JTF_DATE_TABLE
2637: , p5_a5 JTF_DATE_TABLE
2638: , p5_a6 JTF_VARCHAR2_TABLE_2000
2639: , p5_a7 JTF_VARCHAR2_TABLE_100
2636: , p5_a4 JTF_DATE_TABLE
2637: , p5_a5 JTF_DATE_TABLE
2638: , p5_a6 JTF_VARCHAR2_TABLE_2000
2639: , p5_a7 JTF_VARCHAR2_TABLE_100
2640: , p5_a8 JTF_NUMBER_TABLE
2641: , p5_a9 JTF_NUMBER_TABLE
2642: , p5_a10 JTF_VARCHAR2_TABLE_100
2643: , p5_a11 JTF_VARCHAR2_TABLE_500
2644: , p5_a12 JTF_VARCHAR2_TABLE_500
2637: , p5_a5 JTF_DATE_TABLE
2638: , p5_a6 JTF_VARCHAR2_TABLE_2000
2639: , p5_a7 JTF_VARCHAR2_TABLE_100
2640: , p5_a8 JTF_NUMBER_TABLE
2641: , p5_a9 JTF_NUMBER_TABLE
2642: , p5_a10 JTF_VARCHAR2_TABLE_100
2643: , p5_a11 JTF_VARCHAR2_TABLE_500
2644: , p5_a12 JTF_VARCHAR2_TABLE_500
2645: , p5_a13 JTF_VARCHAR2_TABLE_500
2654: , p5_a22 JTF_VARCHAR2_TABLE_500
2655: , p5_a23 JTF_VARCHAR2_TABLE_500
2656: , p5_a24 JTF_VARCHAR2_TABLE_500
2657: , p5_a25 JTF_VARCHAR2_TABLE_500
2658: , p5_a26 JTF_NUMBER_TABLE
2659: , p5_a27 JTF_NUMBER_TABLE
2660: , p5_a28 JTF_NUMBER_TABLE
2661: , p5_a29 JTF_DATE_TABLE
2662: , p5_a30 JTF_NUMBER_TABLE
2655: , p5_a23 JTF_VARCHAR2_TABLE_500
2656: , p5_a24 JTF_VARCHAR2_TABLE_500
2657: , p5_a25 JTF_VARCHAR2_TABLE_500
2658: , p5_a26 JTF_NUMBER_TABLE
2659: , p5_a27 JTF_NUMBER_TABLE
2660: , p5_a28 JTF_NUMBER_TABLE
2661: , p5_a29 JTF_DATE_TABLE
2662: , p5_a30 JTF_NUMBER_TABLE
2663: , p5_a31 JTF_DATE_TABLE
2656: , p5_a24 JTF_VARCHAR2_TABLE_500
2657: , p5_a25 JTF_VARCHAR2_TABLE_500
2658: , p5_a26 JTF_NUMBER_TABLE
2659: , p5_a27 JTF_NUMBER_TABLE
2660: , p5_a28 JTF_NUMBER_TABLE
2661: , p5_a29 JTF_DATE_TABLE
2662: , p5_a30 JTF_NUMBER_TABLE
2663: , p5_a31 JTF_DATE_TABLE
2664: , p5_a32 JTF_NUMBER_TABLE
2658: , p5_a26 JTF_NUMBER_TABLE
2659: , p5_a27 JTF_NUMBER_TABLE
2660: , p5_a28 JTF_NUMBER_TABLE
2661: , p5_a29 JTF_DATE_TABLE
2662: , p5_a30 JTF_NUMBER_TABLE
2663: , p5_a31 JTF_DATE_TABLE
2664: , p5_a32 JTF_NUMBER_TABLE
2665: , p5_a33 JTF_DATE_TABLE
2666: , p5_a34 JTF_NUMBER_TABLE
2660: , p5_a28 JTF_NUMBER_TABLE
2661: , p5_a29 JTF_DATE_TABLE
2662: , p5_a30 JTF_NUMBER_TABLE
2663: , p5_a31 JTF_DATE_TABLE
2664: , p5_a32 JTF_NUMBER_TABLE
2665: , p5_a33 JTF_DATE_TABLE
2666: , p5_a34 JTF_NUMBER_TABLE
2667: )
2668:
2662: , p5_a30 JTF_NUMBER_TABLE
2663: , p5_a31 JTF_DATE_TABLE
2664: , p5_a32 JTF_NUMBER_TABLE
2665: , p5_a33 JTF_DATE_TABLE
2666: , p5_a34 JTF_NUMBER_TABLE
2667: )
2668:
2669: as
2670: ddp_vasv_tbl okl_vas_pvt.vasv_tbl_type;