1: package body okl_vcr_pvt_w as
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body okl_vcr_pvt_w as
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body okl_vcr_pvt_w as
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
2: /* $Header: OKLIVCRB.pls 120.0 2005/08/03 07:56:15 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_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_NUMBER_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: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_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: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then
90: end loop;
91: end if;
92: end if;
93: end rosetta_table_copy_in_p2;
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: end if;
92: end if;
93: end rosetta_table_copy_in_p2;
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
92: end if;
93: end rosetta_table_copy_in_p2;
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_DATE_TABLE
93: end rosetta_table_copy_in_p2;
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_500
119: , a25 out nocopy JTF_VARCHAR2_TABLE_500
120: , a26 out nocopy JTF_VARCHAR2_TABLE_500
121: , a27 out nocopy JTF_VARCHAR2_TABLE_500
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_NUMBER_TABLE
124: , a30 out nocopy JTF_NUMBER_TABLE
125: , a31 out nocopy JTF_DATE_TABLE
126: , a32 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_VARCHAR2_TABLE_500
120: , a26 out nocopy JTF_VARCHAR2_TABLE_500
121: , a27 out nocopy JTF_VARCHAR2_TABLE_500
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_NUMBER_TABLE
124: , a30 out nocopy JTF_NUMBER_TABLE
125: , a31 out nocopy JTF_DATE_TABLE
126: , a32 out nocopy JTF_NUMBER_TABLE
127: , a33 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_VARCHAR2_TABLE_500
121: , a27 out nocopy JTF_VARCHAR2_TABLE_500
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_NUMBER_TABLE
124: , a30 out nocopy JTF_NUMBER_TABLE
125: , a31 out nocopy JTF_DATE_TABLE
126: , a32 out nocopy JTF_NUMBER_TABLE
127: , a33 out nocopy JTF_DATE_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_NUMBER_TABLE
124: , a30 out nocopy JTF_NUMBER_TABLE
125: , a31 out nocopy JTF_DATE_TABLE
126: , a32 out nocopy JTF_NUMBER_TABLE
127: , a33 out nocopy JTF_DATE_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_DATE_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
124: , a30 out nocopy JTF_NUMBER_TABLE
125: , a31 out nocopy JTF_DATE_TABLE
126: , a32 out nocopy JTF_NUMBER_TABLE
127: , a33 out nocopy JTF_DATE_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_DATE_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
126: , a32 out nocopy JTF_NUMBER_TABLE
127: , a33 out nocopy JTF_DATE_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_DATE_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
140: a5 := JTF_VARCHAR2_TABLE_100();
133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
140: a5 := JTF_VARCHAR2_TABLE_100();
141: a6 := JTF_DATE_TABLE();
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
140: a5 := JTF_VARCHAR2_TABLE_100();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_500();
160: a25 := JTF_VARCHAR2_TABLE_500();
161: a26 := JTF_VARCHAR2_TABLE_500();
162: a27 := JTF_VARCHAR2_TABLE_500();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_NUMBER_TABLE();
165: a30 := JTF_NUMBER_TABLE();
166: a31 := JTF_DATE_TABLE();
167: a32 := JTF_NUMBER_TABLE();
160: a25 := JTF_VARCHAR2_TABLE_500();
161: a26 := JTF_VARCHAR2_TABLE_500();
162: a27 := JTF_VARCHAR2_TABLE_500();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_NUMBER_TABLE();
165: a30 := JTF_NUMBER_TABLE();
166: a31 := JTF_DATE_TABLE();
167: a32 := JTF_NUMBER_TABLE();
168: a33 := JTF_DATE_TABLE();
161: a26 := JTF_VARCHAR2_TABLE_500();
162: a27 := JTF_VARCHAR2_TABLE_500();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_NUMBER_TABLE();
165: a30 := JTF_NUMBER_TABLE();
166: a31 := JTF_DATE_TABLE();
167: a32 := JTF_NUMBER_TABLE();
168: a33 := JTF_DATE_TABLE();
169: a34 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_NUMBER_TABLE();
165: a30 := JTF_NUMBER_TABLE();
166: a31 := JTF_DATE_TABLE();
167: a32 := JTF_NUMBER_TABLE();
168: a33 := JTF_DATE_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_DATE_TABLE();
171: a36 := JTF_NUMBER_TABLE();
165: a30 := JTF_NUMBER_TABLE();
166: a31 := JTF_DATE_TABLE();
167: a32 := JTF_NUMBER_TABLE();
168: a33 := JTF_DATE_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_DATE_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
167: a32 := JTF_NUMBER_TABLE();
168: a33 := JTF_DATE_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_DATE_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_DATE_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
170: a35 := JTF_DATE_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
178: a5 := JTF_VARCHAR2_TABLE_100();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
178: a5 := JTF_VARCHAR2_TABLE_100();
179: a6 := JTF_DATE_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
178: a5 := JTF_VARCHAR2_TABLE_100();
179: a6 := JTF_DATE_TABLE();
180: a7 := JTF_DATE_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_500();
198: a25 := JTF_VARCHAR2_TABLE_500();
199: a26 := JTF_VARCHAR2_TABLE_500();
200: a27 := JTF_VARCHAR2_TABLE_500();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_NUMBER_TABLE();
203: a30 := JTF_NUMBER_TABLE();
204: a31 := JTF_DATE_TABLE();
205: a32 := JTF_NUMBER_TABLE();
198: a25 := JTF_VARCHAR2_TABLE_500();
199: a26 := JTF_VARCHAR2_TABLE_500();
200: a27 := JTF_VARCHAR2_TABLE_500();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_NUMBER_TABLE();
203: a30 := JTF_NUMBER_TABLE();
204: a31 := JTF_DATE_TABLE();
205: a32 := JTF_NUMBER_TABLE();
206: a33 := JTF_DATE_TABLE();
199: a26 := JTF_VARCHAR2_TABLE_500();
200: a27 := JTF_VARCHAR2_TABLE_500();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_NUMBER_TABLE();
203: a30 := JTF_NUMBER_TABLE();
204: a31 := JTF_DATE_TABLE();
205: a32 := JTF_NUMBER_TABLE();
206: a33 := JTF_DATE_TABLE();
207: a34 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_NUMBER_TABLE();
203: a30 := JTF_NUMBER_TABLE();
204: a31 := JTF_DATE_TABLE();
205: a32 := JTF_NUMBER_TABLE();
206: a33 := JTF_DATE_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_DATE_TABLE();
209: a36 := JTF_NUMBER_TABLE();
203: a30 := JTF_NUMBER_TABLE();
204: a31 := JTF_DATE_TABLE();
205: a32 := JTF_NUMBER_TABLE();
206: a33 := JTF_DATE_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_DATE_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
211: a0.extend(t.count);
205: a32 := JTF_NUMBER_TABLE();
206: a33 := JTF_DATE_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_DATE_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
211: a0.extend(t.count);
212: a1.extend(t.count);
213: a2.extend(t.count);
294: end if;
295: end if;
296: end rosetta_table_copy_out_p2;
297:
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
295: end if;
296: end rosetta_table_copy_out_p2;
297:
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_VARCHAR2_TABLE_100
296: end rosetta_table_copy_out_p2;
297:
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
297:
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
305: , a7 JTF_DATE_TABLE
322: , a24 JTF_VARCHAR2_TABLE_500
323: , a25 JTF_VARCHAR2_TABLE_500
324: , a26 JTF_VARCHAR2_TABLE_500
325: , a27 JTF_VARCHAR2_TABLE_500
326: , a28 JTF_NUMBER_TABLE
327: , a29 JTF_NUMBER_TABLE
328: , a30 JTF_NUMBER_TABLE
329: , a31 JTF_DATE_TABLE
330: , a32 JTF_NUMBER_TABLE
323: , a25 JTF_VARCHAR2_TABLE_500
324: , a26 JTF_VARCHAR2_TABLE_500
325: , a27 JTF_VARCHAR2_TABLE_500
326: , a28 JTF_NUMBER_TABLE
327: , a29 JTF_NUMBER_TABLE
328: , a30 JTF_NUMBER_TABLE
329: , a31 JTF_DATE_TABLE
330: , a32 JTF_NUMBER_TABLE
331: , a33 JTF_DATE_TABLE
324: , a26 JTF_VARCHAR2_TABLE_500
325: , a27 JTF_VARCHAR2_TABLE_500
326: , a28 JTF_NUMBER_TABLE
327: , a29 JTF_NUMBER_TABLE
328: , a30 JTF_NUMBER_TABLE
329: , a31 JTF_DATE_TABLE
330: , a32 JTF_NUMBER_TABLE
331: , a33 JTF_DATE_TABLE
332: , a34 JTF_NUMBER_TABLE
326: , a28 JTF_NUMBER_TABLE
327: , a29 JTF_NUMBER_TABLE
328: , a30 JTF_NUMBER_TABLE
329: , a31 JTF_DATE_TABLE
330: , a32 JTF_NUMBER_TABLE
331: , a33 JTF_DATE_TABLE
332: , a34 JTF_NUMBER_TABLE
333: , a35 JTF_DATE_TABLE
334: , a36 JTF_NUMBER_TABLE
328: , a30 JTF_NUMBER_TABLE
329: , a31 JTF_DATE_TABLE
330: , a32 JTF_NUMBER_TABLE
331: , a33 JTF_DATE_TABLE
332: , a34 JTF_NUMBER_TABLE
333: , a35 JTF_DATE_TABLE
334: , a36 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
330: , a32 JTF_NUMBER_TABLE
331: , a33 JTF_DATE_TABLE
332: , a34 JTF_NUMBER_TABLE
333: , a35 JTF_DATE_TABLE
334: , a36 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if a0 is not null and a0.count > 0 then
385: end loop;
386: end if;
387: end if;
388: end rosetta_table_copy_in_p5;
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
386: end if;
387: end if;
388: end rosetta_table_copy_in_p5;
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
394: , a5 out nocopy JTF_VARCHAR2_TABLE_100
387: end if;
388: end rosetta_table_copy_in_p5;
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
394: , a5 out nocopy JTF_VARCHAR2_TABLE_100
395: , a6 out nocopy JTF_DATE_TABLE
388: end rosetta_table_copy_in_p5;
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
394: , a5 out nocopy JTF_VARCHAR2_TABLE_100
395: , a6 out nocopy JTF_DATE_TABLE
396: , a7 out nocopy JTF_DATE_TABLE
413: , a24 out nocopy JTF_VARCHAR2_TABLE_500
414: , a25 out nocopy JTF_VARCHAR2_TABLE_500
415: , a26 out nocopy JTF_VARCHAR2_TABLE_500
416: , a27 out nocopy JTF_VARCHAR2_TABLE_500
417: , a28 out nocopy JTF_NUMBER_TABLE
418: , a29 out nocopy JTF_NUMBER_TABLE
419: , a30 out nocopy JTF_NUMBER_TABLE
420: , a31 out nocopy JTF_DATE_TABLE
421: , a32 out nocopy JTF_NUMBER_TABLE
414: , a25 out nocopy JTF_VARCHAR2_TABLE_500
415: , a26 out nocopy JTF_VARCHAR2_TABLE_500
416: , a27 out nocopy JTF_VARCHAR2_TABLE_500
417: , a28 out nocopy JTF_NUMBER_TABLE
418: , a29 out nocopy JTF_NUMBER_TABLE
419: , a30 out nocopy JTF_NUMBER_TABLE
420: , a31 out nocopy JTF_DATE_TABLE
421: , a32 out nocopy JTF_NUMBER_TABLE
422: , a33 out nocopy JTF_DATE_TABLE
415: , a26 out nocopy JTF_VARCHAR2_TABLE_500
416: , a27 out nocopy JTF_VARCHAR2_TABLE_500
417: , a28 out nocopy JTF_NUMBER_TABLE
418: , a29 out nocopy JTF_NUMBER_TABLE
419: , a30 out nocopy JTF_NUMBER_TABLE
420: , a31 out nocopy JTF_DATE_TABLE
421: , a32 out nocopy JTF_NUMBER_TABLE
422: , a33 out nocopy JTF_DATE_TABLE
423: , a34 out nocopy JTF_NUMBER_TABLE
417: , a28 out nocopy JTF_NUMBER_TABLE
418: , a29 out nocopy JTF_NUMBER_TABLE
419: , a30 out nocopy JTF_NUMBER_TABLE
420: , a31 out nocopy JTF_DATE_TABLE
421: , a32 out nocopy JTF_NUMBER_TABLE
422: , a33 out nocopy JTF_DATE_TABLE
423: , a34 out nocopy JTF_NUMBER_TABLE
424: , a35 out nocopy JTF_DATE_TABLE
425: , a36 out nocopy JTF_NUMBER_TABLE
419: , a30 out nocopy JTF_NUMBER_TABLE
420: , a31 out nocopy JTF_DATE_TABLE
421: , a32 out nocopy JTF_NUMBER_TABLE
422: , a33 out nocopy JTF_DATE_TABLE
423: , a34 out nocopy JTF_NUMBER_TABLE
424: , a35 out nocopy JTF_DATE_TABLE
425: , a36 out nocopy JTF_NUMBER_TABLE
426: ) as
427: ddindx binary_integer; indx binary_integer;
421: , a32 out nocopy JTF_NUMBER_TABLE
422: , a33 out nocopy JTF_DATE_TABLE
423: , a34 out nocopy JTF_NUMBER_TABLE
424: , a35 out nocopy JTF_DATE_TABLE
425: , a36 out nocopy JTF_NUMBER_TABLE
426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
435: a5 := JTF_VARCHAR2_TABLE_100();
428: begin
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
435: a5 := JTF_VARCHAR2_TABLE_100();
436: a6 := JTF_DATE_TABLE();
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
435: a5 := JTF_VARCHAR2_TABLE_100();
436: a6 := JTF_DATE_TABLE();
437: a7 := JTF_DATE_TABLE();
454: a24 := JTF_VARCHAR2_TABLE_500();
455: a25 := JTF_VARCHAR2_TABLE_500();
456: a26 := JTF_VARCHAR2_TABLE_500();
457: a27 := JTF_VARCHAR2_TABLE_500();
458: a28 := JTF_NUMBER_TABLE();
459: a29 := JTF_NUMBER_TABLE();
460: a30 := JTF_NUMBER_TABLE();
461: a31 := JTF_DATE_TABLE();
462: a32 := JTF_NUMBER_TABLE();
455: a25 := JTF_VARCHAR2_TABLE_500();
456: a26 := JTF_VARCHAR2_TABLE_500();
457: a27 := JTF_VARCHAR2_TABLE_500();
458: a28 := JTF_NUMBER_TABLE();
459: a29 := JTF_NUMBER_TABLE();
460: a30 := JTF_NUMBER_TABLE();
461: a31 := JTF_DATE_TABLE();
462: a32 := JTF_NUMBER_TABLE();
463: a33 := JTF_DATE_TABLE();
456: a26 := JTF_VARCHAR2_TABLE_500();
457: a27 := JTF_VARCHAR2_TABLE_500();
458: a28 := JTF_NUMBER_TABLE();
459: a29 := JTF_NUMBER_TABLE();
460: a30 := JTF_NUMBER_TABLE();
461: a31 := JTF_DATE_TABLE();
462: a32 := JTF_NUMBER_TABLE();
463: a33 := JTF_DATE_TABLE();
464: a34 := JTF_NUMBER_TABLE();
458: a28 := JTF_NUMBER_TABLE();
459: a29 := JTF_NUMBER_TABLE();
460: a30 := JTF_NUMBER_TABLE();
461: a31 := JTF_DATE_TABLE();
462: a32 := JTF_NUMBER_TABLE();
463: a33 := JTF_DATE_TABLE();
464: a34 := JTF_NUMBER_TABLE();
465: a35 := JTF_DATE_TABLE();
466: a36 := JTF_NUMBER_TABLE();
460: a30 := JTF_NUMBER_TABLE();
461: a31 := JTF_DATE_TABLE();
462: a32 := JTF_NUMBER_TABLE();
463: a33 := JTF_DATE_TABLE();
464: a34 := JTF_NUMBER_TABLE();
465: a35 := JTF_DATE_TABLE();
466: a36 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
462: a32 := JTF_NUMBER_TABLE();
463: a33 := JTF_DATE_TABLE();
464: a34 := JTF_NUMBER_TABLE();
465: a35 := JTF_DATE_TABLE();
466: a36 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
464: a34 := JTF_NUMBER_TABLE();
465: a35 := JTF_DATE_TABLE();
466: a36 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
465: a35 := JTF_DATE_TABLE();
466: a36 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
473: a5 := JTF_VARCHAR2_TABLE_100();
466: a36 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
473: a5 := JTF_VARCHAR2_TABLE_100();
474: a6 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
473: a5 := JTF_VARCHAR2_TABLE_100();
474: a6 := JTF_DATE_TABLE();
475: a7 := JTF_DATE_TABLE();
492: a24 := JTF_VARCHAR2_TABLE_500();
493: a25 := JTF_VARCHAR2_TABLE_500();
494: a26 := JTF_VARCHAR2_TABLE_500();
495: a27 := JTF_VARCHAR2_TABLE_500();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_NUMBER_TABLE();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_DATE_TABLE();
500: a32 := JTF_NUMBER_TABLE();
493: a25 := JTF_VARCHAR2_TABLE_500();
494: a26 := JTF_VARCHAR2_TABLE_500();
495: a27 := JTF_VARCHAR2_TABLE_500();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_NUMBER_TABLE();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_DATE_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_DATE_TABLE();
494: a26 := JTF_VARCHAR2_TABLE_500();
495: a27 := JTF_VARCHAR2_TABLE_500();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_NUMBER_TABLE();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_DATE_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_DATE_TABLE();
502: a34 := JTF_NUMBER_TABLE();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_NUMBER_TABLE();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_DATE_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_DATE_TABLE();
502: a34 := JTF_NUMBER_TABLE();
503: a35 := JTF_DATE_TABLE();
504: a36 := JTF_NUMBER_TABLE();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_DATE_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_DATE_TABLE();
502: a34 := JTF_NUMBER_TABLE();
503: a35 := JTF_DATE_TABLE();
504: a36 := JTF_NUMBER_TABLE();
505: if t.count > 0 then
506: a0.extend(t.count);
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_DATE_TABLE();
502: a34 := JTF_NUMBER_TABLE();
503: a35 := JTF_DATE_TABLE();
504: a36 := JTF_NUMBER_TABLE();
505: if t.count > 0 then
506: a0.extend(t.count);
507: a1.extend(t.count);
508: a2.extend(t.count);
781: , p_init_msg_list VARCHAR2
782: , x_return_status out nocopy VARCHAR2
783: , x_msg_count out nocopy NUMBER
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
782: , x_return_status out nocopy VARCHAR2
783: , x_msg_count out nocopy NUMBER
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
790: , p5_a5 JTF_VARCHAR2_TABLE_100
783: , x_msg_count out nocopy NUMBER
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
790: , p5_a5 JTF_VARCHAR2_TABLE_100
791: , p5_a6 JTF_DATE_TABLE
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
790: , p5_a5 JTF_VARCHAR2_TABLE_100
791: , p5_a6 JTF_DATE_TABLE
792: , p5_a7 JTF_DATE_TABLE
809: , p5_a24 JTF_VARCHAR2_TABLE_500
810: , p5_a25 JTF_VARCHAR2_TABLE_500
811: , p5_a26 JTF_VARCHAR2_TABLE_500
812: , p5_a27 JTF_VARCHAR2_TABLE_500
813: , p5_a28 JTF_NUMBER_TABLE
814: , p5_a29 JTF_NUMBER_TABLE
815: , p5_a30 JTF_NUMBER_TABLE
816: , p5_a31 JTF_DATE_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
810: , p5_a25 JTF_VARCHAR2_TABLE_500
811: , p5_a26 JTF_VARCHAR2_TABLE_500
812: , p5_a27 JTF_VARCHAR2_TABLE_500
813: , p5_a28 JTF_NUMBER_TABLE
814: , p5_a29 JTF_NUMBER_TABLE
815: , p5_a30 JTF_NUMBER_TABLE
816: , p5_a31 JTF_DATE_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
811: , p5_a26 JTF_VARCHAR2_TABLE_500
812: , p5_a27 JTF_VARCHAR2_TABLE_500
813: , p5_a28 JTF_NUMBER_TABLE
814: , p5_a29 JTF_NUMBER_TABLE
815: , p5_a30 JTF_NUMBER_TABLE
816: , p5_a31 JTF_DATE_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
819: , p5_a34 JTF_NUMBER_TABLE
813: , p5_a28 JTF_NUMBER_TABLE
814: , p5_a29 JTF_NUMBER_TABLE
815: , p5_a30 JTF_NUMBER_TABLE
816: , p5_a31 JTF_DATE_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
819: , p5_a34 JTF_NUMBER_TABLE
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
815: , p5_a30 JTF_NUMBER_TABLE
816: , p5_a31 JTF_DATE_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
819: , p5_a34 JTF_NUMBER_TABLE
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p5_a32 JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
819: , p5_a34 JTF_NUMBER_TABLE
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
818: , p5_a33 JTF_DATE_TABLE
819: , p5_a34 JTF_NUMBER_TABLE
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
819: , p5_a34 JTF_NUMBER_TABLE
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
820: , p5_a35 JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
828: , p6_a6 out nocopy JTF_DATE_TABLE
821: , p5_a36 JTF_NUMBER_TABLE
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
828: , p6_a6 out nocopy JTF_DATE_TABLE
829: , p6_a7 out nocopy JTF_DATE_TABLE
846: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
847: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
848: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
849: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a28 out nocopy JTF_NUMBER_TABLE
851: , p6_a29 out nocopy JTF_NUMBER_TABLE
852: , p6_a30 out nocopy JTF_NUMBER_TABLE
853: , p6_a31 out nocopy JTF_DATE_TABLE
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
847: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
848: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
849: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a28 out nocopy JTF_NUMBER_TABLE
851: , p6_a29 out nocopy JTF_NUMBER_TABLE
852: , p6_a30 out nocopy JTF_NUMBER_TABLE
853: , p6_a31 out nocopy JTF_DATE_TABLE
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
855: , p6_a33 out nocopy JTF_DATE_TABLE
848: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
849: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a28 out nocopy JTF_NUMBER_TABLE
851: , p6_a29 out nocopy JTF_NUMBER_TABLE
852: , p6_a30 out nocopy JTF_NUMBER_TABLE
853: , p6_a31 out nocopy JTF_DATE_TABLE
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
855: , p6_a33 out nocopy JTF_DATE_TABLE
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
850: , p6_a28 out nocopy JTF_NUMBER_TABLE
851: , p6_a29 out nocopy JTF_NUMBER_TABLE
852: , p6_a30 out nocopy JTF_NUMBER_TABLE
853: , p6_a31 out nocopy JTF_DATE_TABLE
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
855: , p6_a33 out nocopy JTF_DATE_TABLE
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
852: , p6_a30 out nocopy JTF_NUMBER_TABLE
853: , p6_a31 out nocopy JTF_DATE_TABLE
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
855: , p6_a33 out nocopy JTF_DATE_TABLE
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a32 out nocopy JTF_NUMBER_TABLE
855: , p6_a33 out nocopy JTF_DATE_TABLE
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
855: , p6_a33 out nocopy JTF_DATE_TABLE
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
864: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
864: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
866: )
867:
997: , p_init_msg_list VARCHAR2
998: , x_return_status out nocopy VARCHAR2
999: , x_msg_count out nocopy NUMBER
1000: , x_msg_data out nocopy VARCHAR2
1001: , p5_a0 JTF_NUMBER_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
998: , x_return_status out nocopy VARCHAR2
999: , x_msg_count out nocopy NUMBER
1000: , x_msg_data out nocopy VARCHAR2
1001: , p5_a0 JTF_NUMBER_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
1006: , p5_a5 JTF_VARCHAR2_TABLE_100
999: , x_msg_count out nocopy NUMBER
1000: , x_msg_data out nocopy VARCHAR2
1001: , p5_a0 JTF_NUMBER_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
1006: , p5_a5 JTF_VARCHAR2_TABLE_100
1007: , p5_a6 JTF_DATE_TABLE
1000: , x_msg_data out nocopy VARCHAR2
1001: , p5_a0 JTF_NUMBER_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
1006: , p5_a5 JTF_VARCHAR2_TABLE_100
1007: , p5_a6 JTF_DATE_TABLE
1008: , p5_a7 JTF_DATE_TABLE
1025: , p5_a24 JTF_VARCHAR2_TABLE_500
1026: , p5_a25 JTF_VARCHAR2_TABLE_500
1027: , p5_a26 JTF_VARCHAR2_TABLE_500
1028: , p5_a27 JTF_VARCHAR2_TABLE_500
1029: , p5_a28 JTF_NUMBER_TABLE
1030: , p5_a29 JTF_NUMBER_TABLE
1031: , p5_a30 JTF_NUMBER_TABLE
1032: , p5_a31 JTF_DATE_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1026: , p5_a25 JTF_VARCHAR2_TABLE_500
1027: , p5_a26 JTF_VARCHAR2_TABLE_500
1028: , p5_a27 JTF_VARCHAR2_TABLE_500
1029: , p5_a28 JTF_NUMBER_TABLE
1030: , p5_a29 JTF_NUMBER_TABLE
1031: , p5_a30 JTF_NUMBER_TABLE
1032: , p5_a31 JTF_DATE_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1027: , p5_a26 JTF_VARCHAR2_TABLE_500
1028: , p5_a27 JTF_VARCHAR2_TABLE_500
1029: , p5_a28 JTF_NUMBER_TABLE
1030: , p5_a29 JTF_NUMBER_TABLE
1031: , p5_a30 JTF_NUMBER_TABLE
1032: , p5_a31 JTF_DATE_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1035: , p5_a34 JTF_NUMBER_TABLE
1029: , p5_a28 JTF_NUMBER_TABLE
1030: , p5_a29 JTF_NUMBER_TABLE
1031: , p5_a30 JTF_NUMBER_TABLE
1032: , p5_a31 JTF_DATE_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1035: , p5_a34 JTF_NUMBER_TABLE
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1031: , p5_a30 JTF_NUMBER_TABLE
1032: , p5_a31 JTF_DATE_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1035: , p5_a34 JTF_NUMBER_TABLE
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1033: , p5_a32 JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1035: , p5_a34 JTF_NUMBER_TABLE
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1034: , p5_a33 JTF_DATE_TABLE
1035: , p5_a34 JTF_NUMBER_TABLE
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1035: , p5_a34 JTF_NUMBER_TABLE
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p5_a35 JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1044: , p6_a6 out nocopy JTF_DATE_TABLE
1037: , p5_a36 JTF_NUMBER_TABLE
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1044: , p6_a6 out nocopy JTF_DATE_TABLE
1045: , p6_a7 out nocopy JTF_DATE_TABLE
1062: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1063: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1064: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1065: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1066: , p6_a28 out nocopy JTF_NUMBER_TABLE
1067: , p6_a29 out nocopy JTF_NUMBER_TABLE
1068: , p6_a30 out nocopy JTF_NUMBER_TABLE
1069: , p6_a31 out nocopy JTF_DATE_TABLE
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1063: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1064: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1065: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1066: , p6_a28 out nocopy JTF_NUMBER_TABLE
1067: , p6_a29 out nocopy JTF_NUMBER_TABLE
1068: , p6_a30 out nocopy JTF_NUMBER_TABLE
1069: , p6_a31 out nocopy JTF_DATE_TABLE
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1071: , p6_a33 out nocopy JTF_DATE_TABLE
1064: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1065: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1066: , p6_a28 out nocopy JTF_NUMBER_TABLE
1067: , p6_a29 out nocopy JTF_NUMBER_TABLE
1068: , p6_a30 out nocopy JTF_NUMBER_TABLE
1069: , p6_a31 out nocopy JTF_DATE_TABLE
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1071: , p6_a33 out nocopy JTF_DATE_TABLE
1072: , p6_a34 out nocopy JTF_NUMBER_TABLE
1066: , p6_a28 out nocopy JTF_NUMBER_TABLE
1067: , p6_a29 out nocopy JTF_NUMBER_TABLE
1068: , p6_a30 out nocopy JTF_NUMBER_TABLE
1069: , p6_a31 out nocopy JTF_DATE_TABLE
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1071: , p6_a33 out nocopy JTF_DATE_TABLE
1072: , p6_a34 out nocopy JTF_NUMBER_TABLE
1073: , p6_a35 out nocopy JTF_DATE_TABLE
1074: , p6_a36 out nocopy JTF_NUMBER_TABLE
1068: , p6_a30 out nocopy JTF_NUMBER_TABLE
1069: , p6_a31 out nocopy JTF_DATE_TABLE
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1071: , p6_a33 out nocopy JTF_DATE_TABLE
1072: , p6_a34 out nocopy JTF_NUMBER_TABLE
1073: , p6_a35 out nocopy JTF_DATE_TABLE
1074: , p6_a36 out nocopy JTF_NUMBER_TABLE
1075: )
1076:
1070: , p6_a32 out nocopy JTF_NUMBER_TABLE
1071: , p6_a33 out nocopy JTF_DATE_TABLE
1072: , p6_a34 out nocopy JTF_NUMBER_TABLE
1073: , p6_a35 out nocopy JTF_DATE_TABLE
1074: , p6_a36 out nocopy JTF_NUMBER_TABLE
1075: )
1076:
1077: as
1078: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1295: , p_init_msg_list VARCHAR2
1296: , x_return_status out nocopy VARCHAR2
1297: , x_msg_count out nocopy NUMBER
1298: , x_msg_data out nocopy VARCHAR2
1299: , p5_a0 JTF_NUMBER_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1296: , x_return_status out nocopy VARCHAR2
1297: , x_msg_count out nocopy NUMBER
1298: , x_msg_data out nocopy VARCHAR2
1299: , p5_a0 JTF_NUMBER_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1304: , p5_a5 JTF_VARCHAR2_TABLE_100
1297: , x_msg_count out nocopy NUMBER
1298: , x_msg_data out nocopy VARCHAR2
1299: , p5_a0 JTF_NUMBER_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1304: , p5_a5 JTF_VARCHAR2_TABLE_100
1305: , p5_a6 JTF_DATE_TABLE
1298: , x_msg_data out nocopy VARCHAR2
1299: , p5_a0 JTF_NUMBER_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1304: , p5_a5 JTF_VARCHAR2_TABLE_100
1305: , p5_a6 JTF_DATE_TABLE
1306: , p5_a7 JTF_DATE_TABLE
1323: , p5_a24 JTF_VARCHAR2_TABLE_500
1324: , p5_a25 JTF_VARCHAR2_TABLE_500
1325: , p5_a26 JTF_VARCHAR2_TABLE_500
1326: , p5_a27 JTF_VARCHAR2_TABLE_500
1327: , p5_a28 JTF_NUMBER_TABLE
1328: , p5_a29 JTF_NUMBER_TABLE
1329: , p5_a30 JTF_NUMBER_TABLE
1330: , p5_a31 JTF_DATE_TABLE
1331: , p5_a32 JTF_NUMBER_TABLE
1324: , p5_a25 JTF_VARCHAR2_TABLE_500
1325: , p5_a26 JTF_VARCHAR2_TABLE_500
1326: , p5_a27 JTF_VARCHAR2_TABLE_500
1327: , p5_a28 JTF_NUMBER_TABLE
1328: , p5_a29 JTF_NUMBER_TABLE
1329: , p5_a30 JTF_NUMBER_TABLE
1330: , p5_a31 JTF_DATE_TABLE
1331: , p5_a32 JTF_NUMBER_TABLE
1332: , p5_a33 JTF_DATE_TABLE
1325: , p5_a26 JTF_VARCHAR2_TABLE_500
1326: , p5_a27 JTF_VARCHAR2_TABLE_500
1327: , p5_a28 JTF_NUMBER_TABLE
1328: , p5_a29 JTF_NUMBER_TABLE
1329: , p5_a30 JTF_NUMBER_TABLE
1330: , p5_a31 JTF_DATE_TABLE
1331: , p5_a32 JTF_NUMBER_TABLE
1332: , p5_a33 JTF_DATE_TABLE
1333: , p5_a34 JTF_NUMBER_TABLE
1327: , p5_a28 JTF_NUMBER_TABLE
1328: , p5_a29 JTF_NUMBER_TABLE
1329: , p5_a30 JTF_NUMBER_TABLE
1330: , p5_a31 JTF_DATE_TABLE
1331: , p5_a32 JTF_NUMBER_TABLE
1332: , p5_a33 JTF_DATE_TABLE
1333: , p5_a34 JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1329: , p5_a30 JTF_NUMBER_TABLE
1330: , p5_a31 JTF_DATE_TABLE
1331: , p5_a32 JTF_NUMBER_TABLE
1332: , p5_a33 JTF_DATE_TABLE
1333: , p5_a34 JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1331: , p5_a32 JTF_NUMBER_TABLE
1332: , p5_a33 JTF_DATE_TABLE
1333: , p5_a34 JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1332: , p5_a33 JTF_DATE_TABLE
1333: , p5_a34 JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1341: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1342: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1341: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1342: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1343: )
1344:
1432: , p_init_msg_list VARCHAR2
1433: , x_return_status out nocopy VARCHAR2
1434: , x_msg_count out nocopy NUMBER
1435: , x_msg_data out nocopy VARCHAR2
1436: , p5_a0 JTF_NUMBER_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1433: , x_return_status out nocopy VARCHAR2
1434: , x_msg_count out nocopy NUMBER
1435: , x_msg_data out nocopy VARCHAR2
1436: , p5_a0 JTF_NUMBER_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1441: , p5_a5 JTF_VARCHAR2_TABLE_100
1434: , x_msg_count out nocopy NUMBER
1435: , x_msg_data out nocopy VARCHAR2
1436: , p5_a0 JTF_NUMBER_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1441: , p5_a5 JTF_VARCHAR2_TABLE_100
1442: , p5_a6 JTF_DATE_TABLE
1435: , x_msg_data out nocopy VARCHAR2
1436: , p5_a0 JTF_NUMBER_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1441: , p5_a5 JTF_VARCHAR2_TABLE_100
1442: , p5_a6 JTF_DATE_TABLE
1443: , p5_a7 JTF_DATE_TABLE
1460: , p5_a24 JTF_VARCHAR2_TABLE_500
1461: , p5_a25 JTF_VARCHAR2_TABLE_500
1462: , p5_a26 JTF_VARCHAR2_TABLE_500
1463: , p5_a27 JTF_VARCHAR2_TABLE_500
1464: , p5_a28 JTF_NUMBER_TABLE
1465: , p5_a29 JTF_NUMBER_TABLE
1466: , p5_a30 JTF_NUMBER_TABLE
1467: , p5_a31 JTF_DATE_TABLE
1468: , p5_a32 JTF_NUMBER_TABLE
1461: , p5_a25 JTF_VARCHAR2_TABLE_500
1462: , p5_a26 JTF_VARCHAR2_TABLE_500
1463: , p5_a27 JTF_VARCHAR2_TABLE_500
1464: , p5_a28 JTF_NUMBER_TABLE
1465: , p5_a29 JTF_NUMBER_TABLE
1466: , p5_a30 JTF_NUMBER_TABLE
1467: , p5_a31 JTF_DATE_TABLE
1468: , p5_a32 JTF_NUMBER_TABLE
1469: , p5_a33 JTF_DATE_TABLE
1462: , p5_a26 JTF_VARCHAR2_TABLE_500
1463: , p5_a27 JTF_VARCHAR2_TABLE_500
1464: , p5_a28 JTF_NUMBER_TABLE
1465: , p5_a29 JTF_NUMBER_TABLE
1466: , p5_a30 JTF_NUMBER_TABLE
1467: , p5_a31 JTF_DATE_TABLE
1468: , p5_a32 JTF_NUMBER_TABLE
1469: , p5_a33 JTF_DATE_TABLE
1470: , p5_a34 JTF_NUMBER_TABLE
1464: , p5_a28 JTF_NUMBER_TABLE
1465: , p5_a29 JTF_NUMBER_TABLE
1466: , p5_a30 JTF_NUMBER_TABLE
1467: , p5_a31 JTF_DATE_TABLE
1468: , p5_a32 JTF_NUMBER_TABLE
1469: , p5_a33 JTF_DATE_TABLE
1470: , p5_a34 JTF_NUMBER_TABLE
1471: , p5_a35 JTF_DATE_TABLE
1472: , p5_a36 JTF_NUMBER_TABLE
1466: , p5_a30 JTF_NUMBER_TABLE
1467: , p5_a31 JTF_DATE_TABLE
1468: , p5_a32 JTF_NUMBER_TABLE
1469: , p5_a33 JTF_DATE_TABLE
1470: , p5_a34 JTF_NUMBER_TABLE
1471: , p5_a35 JTF_DATE_TABLE
1472: , p5_a36 JTF_NUMBER_TABLE
1473: )
1474:
1468: , p5_a32 JTF_NUMBER_TABLE
1469: , p5_a33 JTF_DATE_TABLE
1470: , p5_a34 JTF_NUMBER_TABLE
1471: , p5_a35 JTF_DATE_TABLE
1472: , p5_a36 JTF_NUMBER_TABLE
1473: )
1474:
1475: as
1476: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1729: , p_init_msg_list VARCHAR2
1730: , x_return_status out nocopy VARCHAR2
1731: , x_msg_count out nocopy NUMBER
1732: , x_msg_data out nocopy VARCHAR2
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1730: , x_return_status out nocopy VARCHAR2
1731: , x_msg_count out nocopy NUMBER
1732: , x_msg_data out nocopy VARCHAR2
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , p5_a5 JTF_VARCHAR2_TABLE_100
1731: , x_msg_count out nocopy NUMBER
1732: , x_msg_data out nocopy VARCHAR2
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , p5_a5 JTF_VARCHAR2_TABLE_100
1739: , p5_a6 JTF_DATE_TABLE
1732: , x_msg_data out nocopy VARCHAR2
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , p5_a5 JTF_VARCHAR2_TABLE_100
1739: , p5_a6 JTF_DATE_TABLE
1740: , p5_a7 JTF_DATE_TABLE
1757: , p5_a24 JTF_VARCHAR2_TABLE_500
1758: , p5_a25 JTF_VARCHAR2_TABLE_500
1759: , p5_a26 JTF_VARCHAR2_TABLE_500
1760: , p5_a27 JTF_VARCHAR2_TABLE_500
1761: , p5_a28 JTF_NUMBER_TABLE
1762: , p5_a29 JTF_NUMBER_TABLE
1763: , p5_a30 JTF_NUMBER_TABLE
1764: , p5_a31 JTF_DATE_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1758: , p5_a25 JTF_VARCHAR2_TABLE_500
1759: , p5_a26 JTF_VARCHAR2_TABLE_500
1760: , p5_a27 JTF_VARCHAR2_TABLE_500
1761: , p5_a28 JTF_NUMBER_TABLE
1762: , p5_a29 JTF_NUMBER_TABLE
1763: , p5_a30 JTF_NUMBER_TABLE
1764: , p5_a31 JTF_DATE_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1759: , p5_a26 JTF_VARCHAR2_TABLE_500
1760: , p5_a27 JTF_VARCHAR2_TABLE_500
1761: , p5_a28 JTF_NUMBER_TABLE
1762: , p5_a29 JTF_NUMBER_TABLE
1763: , p5_a30 JTF_NUMBER_TABLE
1764: , p5_a31 JTF_DATE_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1767: , p5_a34 JTF_NUMBER_TABLE
1761: , p5_a28 JTF_NUMBER_TABLE
1762: , p5_a29 JTF_NUMBER_TABLE
1763: , p5_a30 JTF_NUMBER_TABLE
1764: , p5_a31 JTF_DATE_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1767: , p5_a34 JTF_NUMBER_TABLE
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1763: , p5_a30 JTF_NUMBER_TABLE
1764: , p5_a31 JTF_DATE_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1767: , p5_a34 JTF_NUMBER_TABLE
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1765: , p5_a32 JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1767: , p5_a34 JTF_NUMBER_TABLE
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1766: , p5_a33 JTF_DATE_TABLE
1767: , p5_a34 JTF_NUMBER_TABLE
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p5_a34 JTF_NUMBER_TABLE
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1775: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1768: , p5_a35 JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1775: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a6 out nocopy JTF_DATE_TABLE
1769: , p5_a36 JTF_NUMBER_TABLE
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1775: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a6 out nocopy JTF_DATE_TABLE
1777: , p6_a7 out nocopy JTF_DATE_TABLE
1794: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1795: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1796: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1797: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1798: , p6_a28 out nocopy JTF_NUMBER_TABLE
1799: , p6_a29 out nocopy JTF_NUMBER_TABLE
1800: , p6_a30 out nocopy JTF_NUMBER_TABLE
1801: , p6_a31 out nocopy JTF_DATE_TABLE
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1795: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1796: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1797: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1798: , p6_a28 out nocopy JTF_NUMBER_TABLE
1799: , p6_a29 out nocopy JTF_NUMBER_TABLE
1800: , p6_a30 out nocopy JTF_NUMBER_TABLE
1801: , p6_a31 out nocopy JTF_DATE_TABLE
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1796: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1797: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1798: , p6_a28 out nocopy JTF_NUMBER_TABLE
1799: , p6_a29 out nocopy JTF_NUMBER_TABLE
1800: , p6_a30 out nocopy JTF_NUMBER_TABLE
1801: , p6_a31 out nocopy JTF_DATE_TABLE
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1798: , p6_a28 out nocopy JTF_NUMBER_TABLE
1799: , p6_a29 out nocopy JTF_NUMBER_TABLE
1800: , p6_a30 out nocopy JTF_NUMBER_TABLE
1801: , p6_a31 out nocopy JTF_DATE_TABLE
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1800: , p6_a30 out nocopy JTF_NUMBER_TABLE
1801: , p6_a31 out nocopy JTF_DATE_TABLE
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1802: , p6_a32 out nocopy JTF_NUMBER_TABLE
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1803: , p6_a33 out nocopy JTF_DATE_TABLE
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1812: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1813: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1812: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1813: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1814: )
1815:
1945: , p_init_msg_list VARCHAR2
1946: , x_return_status out nocopy VARCHAR2
1947: , x_msg_count out nocopy NUMBER
1948: , x_msg_data out nocopy VARCHAR2
1949: , p5_a0 JTF_NUMBER_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1946: , x_return_status out nocopy VARCHAR2
1947: , x_msg_count out nocopy NUMBER
1948: , x_msg_data out nocopy VARCHAR2
1949: , p5_a0 JTF_NUMBER_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1954: , p5_a5 JTF_VARCHAR2_TABLE_100
1947: , x_msg_count out nocopy NUMBER
1948: , x_msg_data out nocopy VARCHAR2
1949: , p5_a0 JTF_NUMBER_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1954: , p5_a5 JTF_VARCHAR2_TABLE_100
1955: , p5_a6 JTF_DATE_TABLE
1948: , x_msg_data out nocopy VARCHAR2
1949: , p5_a0 JTF_NUMBER_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1954: , p5_a5 JTF_VARCHAR2_TABLE_100
1955: , p5_a6 JTF_DATE_TABLE
1956: , p5_a7 JTF_DATE_TABLE
1973: , p5_a24 JTF_VARCHAR2_TABLE_500
1974: , p5_a25 JTF_VARCHAR2_TABLE_500
1975: , p5_a26 JTF_VARCHAR2_TABLE_500
1976: , p5_a27 JTF_VARCHAR2_TABLE_500
1977: , p5_a28 JTF_NUMBER_TABLE
1978: , p5_a29 JTF_NUMBER_TABLE
1979: , p5_a30 JTF_NUMBER_TABLE
1980: , p5_a31 JTF_DATE_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1974: , p5_a25 JTF_VARCHAR2_TABLE_500
1975: , p5_a26 JTF_VARCHAR2_TABLE_500
1976: , p5_a27 JTF_VARCHAR2_TABLE_500
1977: , p5_a28 JTF_NUMBER_TABLE
1978: , p5_a29 JTF_NUMBER_TABLE
1979: , p5_a30 JTF_NUMBER_TABLE
1980: , p5_a31 JTF_DATE_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1975: , p5_a26 JTF_VARCHAR2_TABLE_500
1976: , p5_a27 JTF_VARCHAR2_TABLE_500
1977: , p5_a28 JTF_NUMBER_TABLE
1978: , p5_a29 JTF_NUMBER_TABLE
1979: , p5_a30 JTF_NUMBER_TABLE
1980: , p5_a31 JTF_DATE_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1983: , p5_a34 JTF_NUMBER_TABLE
1977: , p5_a28 JTF_NUMBER_TABLE
1978: , p5_a29 JTF_NUMBER_TABLE
1979: , p5_a30 JTF_NUMBER_TABLE
1980: , p5_a31 JTF_DATE_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1983: , p5_a34 JTF_NUMBER_TABLE
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1979: , p5_a30 JTF_NUMBER_TABLE
1980: , p5_a31 JTF_DATE_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1983: , p5_a34 JTF_NUMBER_TABLE
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1981: , p5_a32 JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1983: , p5_a34 JTF_NUMBER_TABLE
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1982: , p5_a33 JTF_DATE_TABLE
1983: , p5_a34 JTF_NUMBER_TABLE
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1983: , p5_a34 JTF_NUMBER_TABLE
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1991: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1984: , p5_a35 JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1991: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1992: , p6_a6 out nocopy JTF_DATE_TABLE
1985: , p5_a36 JTF_NUMBER_TABLE
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1991: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1992: , p6_a6 out nocopy JTF_DATE_TABLE
1993: , p6_a7 out nocopy JTF_DATE_TABLE
2010: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2011: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2012: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2013: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2014: , p6_a28 out nocopy JTF_NUMBER_TABLE
2015: , p6_a29 out nocopy JTF_NUMBER_TABLE
2016: , p6_a30 out nocopy JTF_NUMBER_TABLE
2017: , p6_a31 out nocopy JTF_DATE_TABLE
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2011: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2012: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2013: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2014: , p6_a28 out nocopy JTF_NUMBER_TABLE
2015: , p6_a29 out nocopy JTF_NUMBER_TABLE
2016: , p6_a30 out nocopy JTF_NUMBER_TABLE
2017: , p6_a31 out nocopy JTF_DATE_TABLE
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2019: , p6_a33 out nocopy JTF_DATE_TABLE
2012: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2013: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2014: , p6_a28 out nocopy JTF_NUMBER_TABLE
2015: , p6_a29 out nocopy JTF_NUMBER_TABLE
2016: , p6_a30 out nocopy JTF_NUMBER_TABLE
2017: , p6_a31 out nocopy JTF_DATE_TABLE
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2019: , p6_a33 out nocopy JTF_DATE_TABLE
2020: , p6_a34 out nocopy JTF_NUMBER_TABLE
2014: , p6_a28 out nocopy JTF_NUMBER_TABLE
2015: , p6_a29 out nocopy JTF_NUMBER_TABLE
2016: , p6_a30 out nocopy JTF_NUMBER_TABLE
2017: , p6_a31 out nocopy JTF_DATE_TABLE
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2019: , p6_a33 out nocopy JTF_DATE_TABLE
2020: , p6_a34 out nocopy JTF_NUMBER_TABLE
2021: , p6_a35 out nocopy JTF_DATE_TABLE
2022: , p6_a36 out nocopy JTF_NUMBER_TABLE
2016: , p6_a30 out nocopy JTF_NUMBER_TABLE
2017: , p6_a31 out nocopy JTF_DATE_TABLE
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2019: , p6_a33 out nocopy JTF_DATE_TABLE
2020: , p6_a34 out nocopy JTF_NUMBER_TABLE
2021: , p6_a35 out nocopy JTF_DATE_TABLE
2022: , p6_a36 out nocopy JTF_NUMBER_TABLE
2023: )
2024:
2018: , p6_a32 out nocopy JTF_NUMBER_TABLE
2019: , p6_a33 out nocopy JTF_DATE_TABLE
2020: , p6_a34 out nocopy JTF_NUMBER_TABLE
2021: , p6_a35 out nocopy JTF_DATE_TABLE
2022: , p6_a36 out nocopy JTF_NUMBER_TABLE
2023: )
2024:
2025: as
2026: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2243: , p_init_msg_list VARCHAR2
2244: , x_return_status out nocopy VARCHAR2
2245: , x_msg_count out nocopy NUMBER
2246: , x_msg_data out nocopy VARCHAR2
2247: , p5_a0 JTF_NUMBER_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2244: , x_return_status out nocopy VARCHAR2
2245: , x_msg_count out nocopy NUMBER
2246: , x_msg_data out nocopy VARCHAR2
2247: , p5_a0 JTF_NUMBER_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2252: , p5_a5 JTF_VARCHAR2_TABLE_100
2245: , x_msg_count out nocopy NUMBER
2246: , x_msg_data out nocopy VARCHAR2
2247: , p5_a0 JTF_NUMBER_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2252: , p5_a5 JTF_VARCHAR2_TABLE_100
2253: , p5_a6 JTF_DATE_TABLE
2246: , x_msg_data out nocopy VARCHAR2
2247: , p5_a0 JTF_NUMBER_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2252: , p5_a5 JTF_VARCHAR2_TABLE_100
2253: , p5_a6 JTF_DATE_TABLE
2254: , p5_a7 JTF_DATE_TABLE
2271: , p5_a24 JTF_VARCHAR2_TABLE_500
2272: , p5_a25 JTF_VARCHAR2_TABLE_500
2273: , p5_a26 JTF_VARCHAR2_TABLE_500
2274: , p5_a27 JTF_VARCHAR2_TABLE_500
2275: , p5_a28 JTF_NUMBER_TABLE
2276: , p5_a29 JTF_NUMBER_TABLE
2277: , p5_a30 JTF_NUMBER_TABLE
2278: , p5_a31 JTF_DATE_TABLE
2279: , p5_a32 JTF_NUMBER_TABLE
2272: , p5_a25 JTF_VARCHAR2_TABLE_500
2273: , p5_a26 JTF_VARCHAR2_TABLE_500
2274: , p5_a27 JTF_VARCHAR2_TABLE_500
2275: , p5_a28 JTF_NUMBER_TABLE
2276: , p5_a29 JTF_NUMBER_TABLE
2277: , p5_a30 JTF_NUMBER_TABLE
2278: , p5_a31 JTF_DATE_TABLE
2279: , p5_a32 JTF_NUMBER_TABLE
2280: , p5_a33 JTF_DATE_TABLE
2273: , p5_a26 JTF_VARCHAR2_TABLE_500
2274: , p5_a27 JTF_VARCHAR2_TABLE_500
2275: , p5_a28 JTF_NUMBER_TABLE
2276: , p5_a29 JTF_NUMBER_TABLE
2277: , p5_a30 JTF_NUMBER_TABLE
2278: , p5_a31 JTF_DATE_TABLE
2279: , p5_a32 JTF_NUMBER_TABLE
2280: , p5_a33 JTF_DATE_TABLE
2281: , p5_a34 JTF_NUMBER_TABLE
2275: , p5_a28 JTF_NUMBER_TABLE
2276: , p5_a29 JTF_NUMBER_TABLE
2277: , p5_a30 JTF_NUMBER_TABLE
2278: , p5_a31 JTF_DATE_TABLE
2279: , p5_a32 JTF_NUMBER_TABLE
2280: , p5_a33 JTF_DATE_TABLE
2281: , p5_a34 JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2277: , p5_a30 JTF_NUMBER_TABLE
2278: , p5_a31 JTF_DATE_TABLE
2279: , p5_a32 JTF_NUMBER_TABLE
2280: , p5_a33 JTF_DATE_TABLE
2281: , p5_a34 JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2279: , p5_a32 JTF_NUMBER_TABLE
2280: , p5_a33 JTF_DATE_TABLE
2281: , p5_a34 JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2280: , p5_a33 JTF_DATE_TABLE
2281: , p5_a34 JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2289: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2290: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2289: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2290: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2291: )
2292:
2380: , p_init_msg_list VARCHAR2
2381: , x_return_status out nocopy VARCHAR2
2382: , x_msg_count out nocopy NUMBER
2383: , x_msg_data out nocopy VARCHAR2
2384: , p5_a0 JTF_NUMBER_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2381: , x_return_status out nocopy VARCHAR2
2382: , x_msg_count out nocopy NUMBER
2383: , x_msg_data out nocopy VARCHAR2
2384: , p5_a0 JTF_NUMBER_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2389: , p5_a5 JTF_VARCHAR2_TABLE_100
2382: , x_msg_count out nocopy NUMBER
2383: , x_msg_data out nocopy VARCHAR2
2384: , p5_a0 JTF_NUMBER_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2389: , p5_a5 JTF_VARCHAR2_TABLE_100
2390: , p5_a6 JTF_DATE_TABLE
2383: , x_msg_data out nocopy VARCHAR2
2384: , p5_a0 JTF_NUMBER_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2389: , p5_a5 JTF_VARCHAR2_TABLE_100
2390: , p5_a6 JTF_DATE_TABLE
2391: , p5_a7 JTF_DATE_TABLE
2408: , p5_a24 JTF_VARCHAR2_TABLE_500
2409: , p5_a25 JTF_VARCHAR2_TABLE_500
2410: , p5_a26 JTF_VARCHAR2_TABLE_500
2411: , p5_a27 JTF_VARCHAR2_TABLE_500
2412: , p5_a28 JTF_NUMBER_TABLE
2413: , p5_a29 JTF_NUMBER_TABLE
2414: , p5_a30 JTF_NUMBER_TABLE
2415: , p5_a31 JTF_DATE_TABLE
2416: , p5_a32 JTF_NUMBER_TABLE
2409: , p5_a25 JTF_VARCHAR2_TABLE_500
2410: , p5_a26 JTF_VARCHAR2_TABLE_500
2411: , p5_a27 JTF_VARCHAR2_TABLE_500
2412: , p5_a28 JTF_NUMBER_TABLE
2413: , p5_a29 JTF_NUMBER_TABLE
2414: , p5_a30 JTF_NUMBER_TABLE
2415: , p5_a31 JTF_DATE_TABLE
2416: , p5_a32 JTF_NUMBER_TABLE
2417: , p5_a33 JTF_DATE_TABLE
2410: , p5_a26 JTF_VARCHAR2_TABLE_500
2411: , p5_a27 JTF_VARCHAR2_TABLE_500
2412: , p5_a28 JTF_NUMBER_TABLE
2413: , p5_a29 JTF_NUMBER_TABLE
2414: , p5_a30 JTF_NUMBER_TABLE
2415: , p5_a31 JTF_DATE_TABLE
2416: , p5_a32 JTF_NUMBER_TABLE
2417: , p5_a33 JTF_DATE_TABLE
2418: , p5_a34 JTF_NUMBER_TABLE
2412: , p5_a28 JTF_NUMBER_TABLE
2413: , p5_a29 JTF_NUMBER_TABLE
2414: , p5_a30 JTF_NUMBER_TABLE
2415: , p5_a31 JTF_DATE_TABLE
2416: , p5_a32 JTF_NUMBER_TABLE
2417: , p5_a33 JTF_DATE_TABLE
2418: , p5_a34 JTF_NUMBER_TABLE
2419: , p5_a35 JTF_DATE_TABLE
2420: , p5_a36 JTF_NUMBER_TABLE
2414: , p5_a30 JTF_NUMBER_TABLE
2415: , p5_a31 JTF_DATE_TABLE
2416: , p5_a32 JTF_NUMBER_TABLE
2417: , p5_a33 JTF_DATE_TABLE
2418: , p5_a34 JTF_NUMBER_TABLE
2419: , p5_a35 JTF_DATE_TABLE
2420: , p5_a36 JTF_NUMBER_TABLE
2421: )
2422:
2416: , p5_a32 JTF_NUMBER_TABLE
2417: , p5_a33 JTF_DATE_TABLE
2418: , p5_a34 JTF_NUMBER_TABLE
2419: , p5_a35 JTF_DATE_TABLE
2420: , p5_a36 JTF_NUMBER_TABLE
2421: )
2422:
2423: as
2424: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2599: , p_init_msg_list VARCHAR2
2600: , x_return_status out nocopy VARCHAR2
2601: , x_msg_count out nocopy NUMBER
2602: , x_msg_data out nocopy VARCHAR2
2603: , p5_a0 JTF_NUMBER_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2600: , x_return_status out nocopy VARCHAR2
2601: , x_msg_count out nocopy NUMBER
2602: , x_msg_data out nocopy VARCHAR2
2603: , p5_a0 JTF_NUMBER_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2608: , p5_a5 JTF_VARCHAR2_TABLE_100
2601: , x_msg_count out nocopy NUMBER
2602: , x_msg_data out nocopy VARCHAR2
2603: , p5_a0 JTF_NUMBER_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2608: , p5_a5 JTF_VARCHAR2_TABLE_100
2609: , p5_a6 JTF_DATE_TABLE
2602: , x_msg_data out nocopy VARCHAR2
2603: , p5_a0 JTF_NUMBER_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2608: , p5_a5 JTF_VARCHAR2_TABLE_100
2609: , p5_a6 JTF_DATE_TABLE
2610: , p5_a7 JTF_DATE_TABLE
2627: , p5_a24 JTF_VARCHAR2_TABLE_500
2628: , p5_a25 JTF_VARCHAR2_TABLE_500
2629: , p5_a26 JTF_VARCHAR2_TABLE_500
2630: , p5_a27 JTF_VARCHAR2_TABLE_500
2631: , p5_a28 JTF_NUMBER_TABLE
2632: , p5_a29 JTF_NUMBER_TABLE
2633: , p5_a30 JTF_NUMBER_TABLE
2634: , p5_a31 JTF_DATE_TABLE
2635: , p5_a32 JTF_NUMBER_TABLE
2628: , p5_a25 JTF_VARCHAR2_TABLE_500
2629: , p5_a26 JTF_VARCHAR2_TABLE_500
2630: , p5_a27 JTF_VARCHAR2_TABLE_500
2631: , p5_a28 JTF_NUMBER_TABLE
2632: , p5_a29 JTF_NUMBER_TABLE
2633: , p5_a30 JTF_NUMBER_TABLE
2634: , p5_a31 JTF_DATE_TABLE
2635: , p5_a32 JTF_NUMBER_TABLE
2636: , p5_a33 JTF_DATE_TABLE
2629: , p5_a26 JTF_VARCHAR2_TABLE_500
2630: , p5_a27 JTF_VARCHAR2_TABLE_500
2631: , p5_a28 JTF_NUMBER_TABLE
2632: , p5_a29 JTF_NUMBER_TABLE
2633: , p5_a30 JTF_NUMBER_TABLE
2634: , p5_a31 JTF_DATE_TABLE
2635: , p5_a32 JTF_NUMBER_TABLE
2636: , p5_a33 JTF_DATE_TABLE
2637: , p5_a34 JTF_NUMBER_TABLE
2631: , p5_a28 JTF_NUMBER_TABLE
2632: , p5_a29 JTF_NUMBER_TABLE
2633: , p5_a30 JTF_NUMBER_TABLE
2634: , p5_a31 JTF_DATE_TABLE
2635: , p5_a32 JTF_NUMBER_TABLE
2636: , p5_a33 JTF_DATE_TABLE
2637: , p5_a34 JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2633: , p5_a30 JTF_NUMBER_TABLE
2634: , p5_a31 JTF_DATE_TABLE
2635: , p5_a32 JTF_NUMBER_TABLE
2636: , p5_a33 JTF_DATE_TABLE
2637: , p5_a34 JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2635: , p5_a32 JTF_NUMBER_TABLE
2636: , p5_a33 JTF_DATE_TABLE
2637: , p5_a34 JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2636: , p5_a33 JTF_DATE_TABLE
2637: , p5_a34 JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2645: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2646: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2645: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2646: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2647: )
2648:
2736: , p_init_msg_list VARCHAR2
2737: , x_return_status out nocopy VARCHAR2
2738: , x_msg_count out nocopy NUMBER
2739: , x_msg_data out nocopy VARCHAR2
2740: , p5_a0 JTF_NUMBER_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2737: , x_return_status out nocopy VARCHAR2
2738: , x_msg_count out nocopy NUMBER
2739: , x_msg_data out nocopy VARCHAR2
2740: , p5_a0 JTF_NUMBER_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2745: , p5_a5 JTF_VARCHAR2_TABLE_100
2738: , x_msg_count out nocopy NUMBER
2739: , x_msg_data out nocopy VARCHAR2
2740: , p5_a0 JTF_NUMBER_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2745: , p5_a5 JTF_VARCHAR2_TABLE_100
2746: , p5_a6 JTF_DATE_TABLE
2739: , x_msg_data out nocopy VARCHAR2
2740: , p5_a0 JTF_NUMBER_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2745: , p5_a5 JTF_VARCHAR2_TABLE_100
2746: , p5_a6 JTF_DATE_TABLE
2747: , p5_a7 JTF_DATE_TABLE
2764: , p5_a24 JTF_VARCHAR2_TABLE_500
2765: , p5_a25 JTF_VARCHAR2_TABLE_500
2766: , p5_a26 JTF_VARCHAR2_TABLE_500
2767: , p5_a27 JTF_VARCHAR2_TABLE_500
2768: , p5_a28 JTF_NUMBER_TABLE
2769: , p5_a29 JTF_NUMBER_TABLE
2770: , p5_a30 JTF_NUMBER_TABLE
2771: , p5_a31 JTF_DATE_TABLE
2772: , p5_a32 JTF_NUMBER_TABLE
2765: , p5_a25 JTF_VARCHAR2_TABLE_500
2766: , p5_a26 JTF_VARCHAR2_TABLE_500
2767: , p5_a27 JTF_VARCHAR2_TABLE_500
2768: , p5_a28 JTF_NUMBER_TABLE
2769: , p5_a29 JTF_NUMBER_TABLE
2770: , p5_a30 JTF_NUMBER_TABLE
2771: , p5_a31 JTF_DATE_TABLE
2772: , p5_a32 JTF_NUMBER_TABLE
2773: , p5_a33 JTF_DATE_TABLE
2766: , p5_a26 JTF_VARCHAR2_TABLE_500
2767: , p5_a27 JTF_VARCHAR2_TABLE_500
2768: , p5_a28 JTF_NUMBER_TABLE
2769: , p5_a29 JTF_NUMBER_TABLE
2770: , p5_a30 JTF_NUMBER_TABLE
2771: , p5_a31 JTF_DATE_TABLE
2772: , p5_a32 JTF_NUMBER_TABLE
2773: , p5_a33 JTF_DATE_TABLE
2774: , p5_a34 JTF_NUMBER_TABLE
2768: , p5_a28 JTF_NUMBER_TABLE
2769: , p5_a29 JTF_NUMBER_TABLE
2770: , p5_a30 JTF_NUMBER_TABLE
2771: , p5_a31 JTF_DATE_TABLE
2772: , p5_a32 JTF_NUMBER_TABLE
2773: , p5_a33 JTF_DATE_TABLE
2774: , p5_a34 JTF_NUMBER_TABLE
2775: , p5_a35 JTF_DATE_TABLE
2776: , p5_a36 JTF_NUMBER_TABLE
2770: , p5_a30 JTF_NUMBER_TABLE
2771: , p5_a31 JTF_DATE_TABLE
2772: , p5_a32 JTF_NUMBER_TABLE
2773: , p5_a33 JTF_DATE_TABLE
2774: , p5_a34 JTF_NUMBER_TABLE
2775: , p5_a35 JTF_DATE_TABLE
2776: , p5_a36 JTF_NUMBER_TABLE
2777: )
2778:
2772: , p5_a32 JTF_NUMBER_TABLE
2773: , p5_a33 JTF_DATE_TABLE
2774: , p5_a34 JTF_NUMBER_TABLE
2775: , p5_a35 JTF_DATE_TABLE
2776: , p5_a36 JTF_NUMBER_TABLE
2777: )
2778:
2779: as
2780: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;