18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sfe_pvt.sfe_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sfe_pvt.sfe_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_200
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_200
44: , a22 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_200
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_200
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_200
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
67: , a45 JTF_VARCHAR2_TABLE_500
68: , a46 JTF_VARCHAR2_TABLE_500
69: , a47 JTF_VARCHAR2_TABLE_500
70: , a48 JTF_VARCHAR2_TABLE_500
71: , a49 JTF_NUMBER_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_DATE_TABLE
74: , a52 JTF_DATE_TABLE
75: , a53 JTF_NUMBER_TABLE
68: , a46 JTF_VARCHAR2_TABLE_500
69: , a47 JTF_VARCHAR2_TABLE_500
70: , a48 JTF_VARCHAR2_TABLE_500
71: , a49 JTF_NUMBER_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_DATE_TABLE
74: , a52 JTF_DATE_TABLE
75: , a53 JTF_NUMBER_TABLE
76: , a54 JTF_NUMBER_TABLE
71: , a49 JTF_NUMBER_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_DATE_TABLE
74: , a52 JTF_DATE_TABLE
75: , a53 JTF_NUMBER_TABLE
76: , a54 JTF_NUMBER_TABLE
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_DATE_TABLE
74: , a52 JTF_DATE_TABLE
75: , a53 JTF_NUMBER_TABLE
76: , a54 JTF_NUMBER_TABLE
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if a0 is not null and a0.count > 0 then
145: end loop;
146: end if;
147: end if;
148: end rosetta_table_copy_in_p2;
149: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_VARCHAR2_TABLE_100
151: , a2 out nocopy JTF_DATE_TABLE
152: , a3 out nocopy JTF_DATE_TABLE
153: , a4 out nocopy JTF_NUMBER_TABLE
149: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_VARCHAR2_TABLE_100
151: , a2 out nocopy JTF_DATE_TABLE
152: , a3 out nocopy JTF_DATE_TABLE
153: , a4 out nocopy JTF_NUMBER_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a8 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_NUMBER_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a8 out nocopy JTF_NUMBER_TABLE
158: , a9 out nocopy JTF_NUMBER_TABLE
159: , a10 out nocopy JTF_VARCHAR2_TABLE_100
160: , a11 out nocopy JTF_VARCHAR2_TABLE_100
161: , a12 out nocopy JTF_VARCHAR2_TABLE_100
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a8 out nocopy JTF_NUMBER_TABLE
158: , a9 out nocopy JTF_NUMBER_TABLE
159: , a10 out nocopy JTF_VARCHAR2_TABLE_100
160: , a11 out nocopy JTF_VARCHAR2_TABLE_100
161: , a12 out nocopy JTF_VARCHAR2_TABLE_100
162: , a13 out nocopy JTF_VARCHAR2_TABLE_100
159: , a10 out nocopy JTF_VARCHAR2_TABLE_100
160: , a11 out nocopy JTF_VARCHAR2_TABLE_100
161: , a12 out nocopy JTF_VARCHAR2_TABLE_100
162: , a13 out nocopy JTF_VARCHAR2_TABLE_100
163: , a14 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
160: , a11 out nocopy JTF_VARCHAR2_TABLE_100
161: , a12 out nocopy JTF_VARCHAR2_TABLE_100
162: , a13 out nocopy JTF_VARCHAR2_TABLE_100
163: , a14 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
161: , a12 out nocopy JTF_VARCHAR2_TABLE_100
162: , a13 out nocopy JTF_VARCHAR2_TABLE_100
163: , a14 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
162: , a13 out nocopy JTF_VARCHAR2_TABLE_100
163: , a14 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
170: , a21 out nocopy JTF_VARCHAR2_TABLE_200
163: , a14 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
170: , a21 out nocopy JTF_VARCHAR2_TABLE_200
171: , a22 out nocopy JTF_NUMBER_TABLE
164: , a15 out nocopy JTF_NUMBER_TABLE
165: , a16 out nocopy JTF_NUMBER_TABLE
166: , a17 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
170: , a21 out nocopy JTF_VARCHAR2_TABLE_200
171: , a22 out nocopy JTF_NUMBER_TABLE
172: , a23 out nocopy JTF_NUMBER_TABLE
167: , a18 out nocopy JTF_NUMBER_TABLE
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
170: , a21 out nocopy JTF_VARCHAR2_TABLE_200
171: , a22 out nocopy JTF_NUMBER_TABLE
172: , a23 out nocopy JTF_NUMBER_TABLE
173: , a24 out nocopy JTF_VARCHAR2_TABLE_100
174: , a25 out nocopy JTF_VARCHAR2_TABLE_100
175: , a26 out nocopy JTF_VARCHAR2_TABLE_100
168: , a19 out nocopy JTF_NUMBER_TABLE
169: , a20 out nocopy JTF_VARCHAR2_TABLE_100
170: , a21 out nocopy JTF_VARCHAR2_TABLE_200
171: , a22 out nocopy JTF_NUMBER_TABLE
172: , a23 out nocopy JTF_NUMBER_TABLE
173: , a24 out nocopy JTF_VARCHAR2_TABLE_100
174: , a25 out nocopy JTF_VARCHAR2_TABLE_100
175: , a26 out nocopy JTF_VARCHAR2_TABLE_100
176: , a27 out nocopy JTF_VARCHAR2_TABLE_100
194: , a45 out nocopy JTF_VARCHAR2_TABLE_500
195: , a46 out nocopy JTF_VARCHAR2_TABLE_500
196: , a47 out nocopy JTF_VARCHAR2_TABLE_500
197: , a48 out nocopy JTF_VARCHAR2_TABLE_500
198: , a49 out nocopy JTF_NUMBER_TABLE
199: , a50 out nocopy JTF_NUMBER_TABLE
200: , a51 out nocopy JTF_DATE_TABLE
201: , a52 out nocopy JTF_DATE_TABLE
202: , a53 out nocopy JTF_NUMBER_TABLE
195: , a46 out nocopy JTF_VARCHAR2_TABLE_500
196: , a47 out nocopy JTF_VARCHAR2_TABLE_500
197: , a48 out nocopy JTF_VARCHAR2_TABLE_500
198: , a49 out nocopy JTF_NUMBER_TABLE
199: , a50 out nocopy JTF_NUMBER_TABLE
200: , a51 out nocopy JTF_DATE_TABLE
201: , a52 out nocopy JTF_DATE_TABLE
202: , a53 out nocopy JTF_NUMBER_TABLE
203: , a54 out nocopy JTF_NUMBER_TABLE
198: , a49 out nocopy JTF_NUMBER_TABLE
199: , a50 out nocopy JTF_NUMBER_TABLE
200: , a51 out nocopy JTF_DATE_TABLE
201: , a52 out nocopy JTF_DATE_TABLE
202: , a53 out nocopy JTF_NUMBER_TABLE
203: , a54 out nocopy JTF_NUMBER_TABLE
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
199: , a50 out nocopy JTF_NUMBER_TABLE
200: , a51 out nocopy JTF_DATE_TABLE
201: , a52 out nocopy JTF_DATE_TABLE
202: , a53 out nocopy JTF_NUMBER_TABLE
203: , a54 out nocopy JTF_NUMBER_TABLE
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_VARCHAR2_TABLE_100();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_DATE_TABLE();
212: a4 := JTF_NUMBER_TABLE();
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_VARCHAR2_TABLE_100();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_DATE_TABLE();
212: a4 := JTF_NUMBER_TABLE();
213: a5 := JTF_VARCHAR2_TABLE_100();
214: a6 := JTF_VARCHAR2_TABLE_100();
215: a7 := JTF_VARCHAR2_TABLE_2000();
216: a8 := JTF_NUMBER_TABLE();
212: a4 := JTF_NUMBER_TABLE();
213: a5 := JTF_VARCHAR2_TABLE_100();
214: a6 := JTF_VARCHAR2_TABLE_100();
215: a7 := JTF_VARCHAR2_TABLE_2000();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_VARCHAR2_TABLE_100();
213: a5 := JTF_VARCHAR2_TABLE_100();
214: a6 := JTF_VARCHAR2_TABLE_100();
215: a7 := JTF_VARCHAR2_TABLE_2000();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_VARCHAR2_TABLE_100();
221: a13 := JTF_VARCHAR2_TABLE_100();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_VARCHAR2_TABLE_100();
221: a13 := JTF_VARCHAR2_TABLE_100();
222: a14 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_VARCHAR2_TABLE_100();
221: a13 := JTF_VARCHAR2_TABLE_100();
222: a14 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
220: a12 := JTF_VARCHAR2_TABLE_100();
221: a13 := JTF_VARCHAR2_TABLE_100();
222: a14 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
221: a13 := JTF_VARCHAR2_TABLE_100();
222: a14 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_200();
222: a14 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_200();
230: a22 := JTF_NUMBER_TABLE();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_NUMBER_TABLE();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_200();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();
226: a18 := JTF_NUMBER_TABLE();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_200();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();
232: a24 := JTF_VARCHAR2_TABLE_100();
233: a25 := JTF_VARCHAR2_TABLE_100();
234: a26 := JTF_VARCHAR2_TABLE_100();
227: a19 := JTF_NUMBER_TABLE();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_200();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();
232: a24 := JTF_VARCHAR2_TABLE_100();
233: a25 := JTF_VARCHAR2_TABLE_100();
234: a26 := JTF_VARCHAR2_TABLE_100();
235: a27 := JTF_VARCHAR2_TABLE_100();
253: a45 := JTF_VARCHAR2_TABLE_500();
254: a46 := JTF_VARCHAR2_TABLE_500();
255: a47 := JTF_VARCHAR2_TABLE_500();
256: a48 := JTF_VARCHAR2_TABLE_500();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_NUMBER_TABLE();
259: a51 := JTF_DATE_TABLE();
260: a52 := JTF_DATE_TABLE();
261: a53 := JTF_NUMBER_TABLE();
254: a46 := JTF_VARCHAR2_TABLE_500();
255: a47 := JTF_VARCHAR2_TABLE_500();
256: a48 := JTF_VARCHAR2_TABLE_500();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_NUMBER_TABLE();
259: a51 := JTF_DATE_TABLE();
260: a52 := JTF_DATE_TABLE();
261: a53 := JTF_NUMBER_TABLE();
262: a54 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_NUMBER_TABLE();
259: a51 := JTF_DATE_TABLE();
260: a52 := JTF_DATE_TABLE();
261: a53 := JTF_NUMBER_TABLE();
262: a54 := JTF_NUMBER_TABLE();
263: else
264: a0 := JTF_NUMBER_TABLE();
265: a1 := JTF_VARCHAR2_TABLE_100();
258: a50 := JTF_NUMBER_TABLE();
259: a51 := JTF_DATE_TABLE();
260: a52 := JTF_DATE_TABLE();
261: a53 := JTF_NUMBER_TABLE();
262: a54 := JTF_NUMBER_TABLE();
263: else
264: a0 := JTF_NUMBER_TABLE();
265: a1 := JTF_VARCHAR2_TABLE_100();
266: a2 := JTF_DATE_TABLE();
260: a52 := JTF_DATE_TABLE();
261: a53 := JTF_NUMBER_TABLE();
262: a54 := JTF_NUMBER_TABLE();
263: else
264: a0 := JTF_NUMBER_TABLE();
265: a1 := JTF_VARCHAR2_TABLE_100();
266: a2 := JTF_DATE_TABLE();
267: a3 := JTF_DATE_TABLE();
268: a4 := JTF_NUMBER_TABLE();
264: a0 := JTF_NUMBER_TABLE();
265: a1 := JTF_VARCHAR2_TABLE_100();
266: a2 := JTF_DATE_TABLE();
267: a3 := JTF_DATE_TABLE();
268: a4 := JTF_NUMBER_TABLE();
269: a5 := JTF_VARCHAR2_TABLE_100();
270: a6 := JTF_VARCHAR2_TABLE_100();
271: a7 := JTF_VARCHAR2_TABLE_2000();
272: a8 := JTF_NUMBER_TABLE();
268: a4 := JTF_NUMBER_TABLE();
269: a5 := JTF_VARCHAR2_TABLE_100();
270: a6 := JTF_VARCHAR2_TABLE_100();
271: a7 := JTF_VARCHAR2_TABLE_2000();
272: a8 := JTF_NUMBER_TABLE();
273: a9 := JTF_NUMBER_TABLE();
274: a10 := JTF_VARCHAR2_TABLE_100();
275: a11 := JTF_VARCHAR2_TABLE_100();
276: a12 := JTF_VARCHAR2_TABLE_100();
269: a5 := JTF_VARCHAR2_TABLE_100();
270: a6 := JTF_VARCHAR2_TABLE_100();
271: a7 := JTF_VARCHAR2_TABLE_2000();
272: a8 := JTF_NUMBER_TABLE();
273: a9 := JTF_NUMBER_TABLE();
274: a10 := JTF_VARCHAR2_TABLE_100();
275: a11 := JTF_VARCHAR2_TABLE_100();
276: a12 := JTF_VARCHAR2_TABLE_100();
277: a13 := JTF_VARCHAR2_TABLE_100();
274: a10 := JTF_VARCHAR2_TABLE_100();
275: a11 := JTF_VARCHAR2_TABLE_100();
276: a12 := JTF_VARCHAR2_TABLE_100();
277: a13 := JTF_VARCHAR2_TABLE_100();
278: a14 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
275: a11 := JTF_VARCHAR2_TABLE_100();
276: a12 := JTF_VARCHAR2_TABLE_100();
277: a13 := JTF_VARCHAR2_TABLE_100();
278: a14 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
276: a12 := JTF_VARCHAR2_TABLE_100();
277: a13 := JTF_VARCHAR2_TABLE_100();
278: a14 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
277: a13 := JTF_VARCHAR2_TABLE_100();
278: a14 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
285: a21 := JTF_VARCHAR2_TABLE_200();
278: a14 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
285: a21 := JTF_VARCHAR2_TABLE_200();
286: a22 := JTF_NUMBER_TABLE();
279: a15 := JTF_NUMBER_TABLE();
280: a16 := JTF_NUMBER_TABLE();
281: a17 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
285: a21 := JTF_VARCHAR2_TABLE_200();
286: a22 := JTF_NUMBER_TABLE();
287: a23 := JTF_NUMBER_TABLE();
282: a18 := JTF_NUMBER_TABLE();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
285: a21 := JTF_VARCHAR2_TABLE_200();
286: a22 := JTF_NUMBER_TABLE();
287: a23 := JTF_NUMBER_TABLE();
288: a24 := JTF_VARCHAR2_TABLE_100();
289: a25 := JTF_VARCHAR2_TABLE_100();
290: a26 := JTF_VARCHAR2_TABLE_100();
283: a19 := JTF_NUMBER_TABLE();
284: a20 := JTF_VARCHAR2_TABLE_100();
285: a21 := JTF_VARCHAR2_TABLE_200();
286: a22 := JTF_NUMBER_TABLE();
287: a23 := JTF_NUMBER_TABLE();
288: a24 := JTF_VARCHAR2_TABLE_100();
289: a25 := JTF_VARCHAR2_TABLE_100();
290: a26 := JTF_VARCHAR2_TABLE_100();
291: a27 := JTF_VARCHAR2_TABLE_100();
309: a45 := JTF_VARCHAR2_TABLE_500();
310: a46 := JTF_VARCHAR2_TABLE_500();
311: a47 := JTF_VARCHAR2_TABLE_500();
312: a48 := JTF_VARCHAR2_TABLE_500();
313: a49 := JTF_NUMBER_TABLE();
314: a50 := JTF_NUMBER_TABLE();
315: a51 := JTF_DATE_TABLE();
316: a52 := JTF_DATE_TABLE();
317: a53 := JTF_NUMBER_TABLE();
310: a46 := JTF_VARCHAR2_TABLE_500();
311: a47 := JTF_VARCHAR2_TABLE_500();
312: a48 := JTF_VARCHAR2_TABLE_500();
313: a49 := JTF_NUMBER_TABLE();
314: a50 := JTF_NUMBER_TABLE();
315: a51 := JTF_DATE_TABLE();
316: a52 := JTF_DATE_TABLE();
317: a53 := JTF_NUMBER_TABLE();
318: a54 := JTF_NUMBER_TABLE();
313: a49 := JTF_NUMBER_TABLE();
314: a50 := JTF_NUMBER_TABLE();
315: a51 := JTF_DATE_TABLE();
316: a52 := JTF_DATE_TABLE();
317: a53 := JTF_NUMBER_TABLE();
318: a54 := JTF_NUMBER_TABLE();
319: if t.count > 0 then
320: a0.extend(t.count);
321: a1.extend(t.count);
314: a50 := JTF_NUMBER_TABLE();
315: a51 := JTF_DATE_TABLE();
316: a52 := JTF_DATE_TABLE();
317: a53 := JTF_NUMBER_TABLE();
318: a54 := JTF_NUMBER_TABLE();
319: if t.count > 0 then
320: a0.extend(t.count);
321: a1.extend(t.count);
322: a2.extend(t.count);
439: end if;
440: end if;
441: end rosetta_table_copy_out_p2;
442:
443: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE
444: , a1 JTF_VARCHAR2_TABLE_100
445: , a2 JTF_DATE_TABLE
446: , a3 JTF_DATE_TABLE
447: , a4 JTF_NUMBER_TABLE
443: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE
444: , a1 JTF_VARCHAR2_TABLE_100
445: , a2 JTF_DATE_TABLE
446: , a3 JTF_DATE_TABLE
447: , a4 JTF_NUMBER_TABLE
448: , a5 JTF_VARCHAR2_TABLE_100
449: , a6 JTF_VARCHAR2_TABLE_100
450: , a7 JTF_VARCHAR2_TABLE_2000
451: , a8 JTF_NUMBER_TABLE
447: , a4 JTF_NUMBER_TABLE
448: , a5 JTF_VARCHAR2_TABLE_100
449: , a6 JTF_VARCHAR2_TABLE_100
450: , a7 JTF_VARCHAR2_TABLE_2000
451: , a8 JTF_NUMBER_TABLE
452: , a9 JTF_NUMBER_TABLE
453: , a10 JTF_VARCHAR2_TABLE_100
454: , a11 JTF_VARCHAR2_TABLE_100
455: , a12 JTF_VARCHAR2_TABLE_100
448: , a5 JTF_VARCHAR2_TABLE_100
449: , a6 JTF_VARCHAR2_TABLE_100
450: , a7 JTF_VARCHAR2_TABLE_2000
451: , a8 JTF_NUMBER_TABLE
452: , a9 JTF_NUMBER_TABLE
453: , a10 JTF_VARCHAR2_TABLE_100
454: , a11 JTF_VARCHAR2_TABLE_100
455: , a12 JTF_VARCHAR2_TABLE_100
456: , a13 JTF_VARCHAR2_TABLE_100
453: , a10 JTF_VARCHAR2_TABLE_100
454: , a11 JTF_VARCHAR2_TABLE_100
455: , a12 JTF_VARCHAR2_TABLE_100
456: , a13 JTF_VARCHAR2_TABLE_100
457: , a14 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
454: , a11 JTF_VARCHAR2_TABLE_100
455: , a12 JTF_VARCHAR2_TABLE_100
456: , a13 JTF_VARCHAR2_TABLE_100
457: , a14 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
455: , a12 JTF_VARCHAR2_TABLE_100
456: , a13 JTF_VARCHAR2_TABLE_100
457: , a14 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
456: , a13 JTF_VARCHAR2_TABLE_100
457: , a14 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
464: , a21 JTF_VARCHAR2_TABLE_200
457: , a14 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
464: , a21 JTF_VARCHAR2_TABLE_200
465: , a22 JTF_NUMBER_TABLE
458: , a15 JTF_NUMBER_TABLE
459: , a16 JTF_NUMBER_TABLE
460: , a17 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
464: , a21 JTF_VARCHAR2_TABLE_200
465: , a22 JTF_NUMBER_TABLE
466: , a23 JTF_NUMBER_TABLE
461: , a18 JTF_NUMBER_TABLE
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
464: , a21 JTF_VARCHAR2_TABLE_200
465: , a22 JTF_NUMBER_TABLE
466: , a23 JTF_NUMBER_TABLE
467: , a24 JTF_VARCHAR2_TABLE_100
468: , a25 JTF_VARCHAR2_TABLE_100
469: , a26 JTF_VARCHAR2_TABLE_100
462: , a19 JTF_NUMBER_TABLE
463: , a20 JTF_VARCHAR2_TABLE_100
464: , a21 JTF_VARCHAR2_TABLE_200
465: , a22 JTF_NUMBER_TABLE
466: , a23 JTF_NUMBER_TABLE
467: , a24 JTF_VARCHAR2_TABLE_100
468: , a25 JTF_VARCHAR2_TABLE_100
469: , a26 JTF_VARCHAR2_TABLE_100
470: , a27 JTF_VARCHAR2_TABLE_100
488: , a45 JTF_VARCHAR2_TABLE_500
489: , a46 JTF_VARCHAR2_TABLE_500
490: , a47 JTF_VARCHAR2_TABLE_500
491: , a48 JTF_VARCHAR2_TABLE_500
492: , a49 JTF_NUMBER_TABLE
493: , a50 JTF_NUMBER_TABLE
494: , a51 JTF_DATE_TABLE
495: , a52 JTF_DATE_TABLE
496: , a53 JTF_NUMBER_TABLE
489: , a46 JTF_VARCHAR2_TABLE_500
490: , a47 JTF_VARCHAR2_TABLE_500
491: , a48 JTF_VARCHAR2_TABLE_500
492: , a49 JTF_NUMBER_TABLE
493: , a50 JTF_NUMBER_TABLE
494: , a51 JTF_DATE_TABLE
495: , a52 JTF_DATE_TABLE
496: , a53 JTF_NUMBER_TABLE
497: , a54 JTF_NUMBER_TABLE
492: , a49 JTF_NUMBER_TABLE
493: , a50 JTF_NUMBER_TABLE
494: , a51 JTF_DATE_TABLE
495: , a52 JTF_DATE_TABLE
496: , a53 JTF_NUMBER_TABLE
497: , a54 JTF_NUMBER_TABLE
498: ) as
499: ddindx binary_integer; indx binary_integer;
500: begin
493: , a50 JTF_NUMBER_TABLE
494: , a51 JTF_DATE_TABLE
495: , a52 JTF_DATE_TABLE
496: , a53 JTF_NUMBER_TABLE
497: , a54 JTF_NUMBER_TABLE
498: ) as
499: ddindx binary_integer; indx binary_integer;
500: begin
501: if a0 is not null and a0.count > 0 then
566: end loop;
567: end if;
568: end if;
569: end rosetta_table_copy_in_p5;
570: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_DATE_TABLE
573: , a3 out nocopy JTF_DATE_TABLE
574: , a4 out nocopy JTF_NUMBER_TABLE
570: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_DATE_TABLE
573: , a3 out nocopy JTF_DATE_TABLE
574: , a4 out nocopy JTF_NUMBER_TABLE
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
578: , a8 out nocopy JTF_NUMBER_TABLE
574: , a4 out nocopy JTF_NUMBER_TABLE
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
578: , a8 out nocopy JTF_NUMBER_TABLE
579: , a9 out nocopy JTF_NUMBER_TABLE
580: , a10 out nocopy JTF_VARCHAR2_TABLE_100
581: , a11 out nocopy JTF_VARCHAR2_TABLE_100
582: , a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
578: , a8 out nocopy JTF_NUMBER_TABLE
579: , a9 out nocopy JTF_NUMBER_TABLE
580: , a10 out nocopy JTF_VARCHAR2_TABLE_100
581: , a11 out nocopy JTF_VARCHAR2_TABLE_100
582: , a12 out nocopy JTF_VARCHAR2_TABLE_100
583: , a13 out nocopy JTF_VARCHAR2_TABLE_100
580: , a10 out nocopy JTF_VARCHAR2_TABLE_100
581: , a11 out nocopy JTF_VARCHAR2_TABLE_100
582: , a12 out nocopy JTF_VARCHAR2_TABLE_100
583: , a13 out nocopy JTF_VARCHAR2_TABLE_100
584: , a14 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
581: , a11 out nocopy JTF_VARCHAR2_TABLE_100
582: , a12 out nocopy JTF_VARCHAR2_TABLE_100
583: , a13 out nocopy JTF_VARCHAR2_TABLE_100
584: , a14 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
582: , a12 out nocopy JTF_VARCHAR2_TABLE_100
583: , a13 out nocopy JTF_VARCHAR2_TABLE_100
584: , a14 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
583: , a13 out nocopy JTF_VARCHAR2_TABLE_100
584: , a14 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
591: , a21 out nocopy JTF_VARCHAR2_TABLE_200
584: , a14 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
591: , a21 out nocopy JTF_VARCHAR2_TABLE_200
592: , a22 out nocopy JTF_NUMBER_TABLE
585: , a15 out nocopy JTF_NUMBER_TABLE
586: , a16 out nocopy JTF_NUMBER_TABLE
587: , a17 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
591: , a21 out nocopy JTF_VARCHAR2_TABLE_200
592: , a22 out nocopy JTF_NUMBER_TABLE
593: , a23 out nocopy JTF_NUMBER_TABLE
588: , a18 out nocopy JTF_NUMBER_TABLE
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
591: , a21 out nocopy JTF_VARCHAR2_TABLE_200
592: , a22 out nocopy JTF_NUMBER_TABLE
593: , a23 out nocopy JTF_NUMBER_TABLE
594: , a24 out nocopy JTF_VARCHAR2_TABLE_100
595: , a25 out nocopy JTF_VARCHAR2_TABLE_100
596: , a26 out nocopy JTF_VARCHAR2_TABLE_100
589: , a19 out nocopy JTF_NUMBER_TABLE
590: , a20 out nocopy JTF_VARCHAR2_TABLE_100
591: , a21 out nocopy JTF_VARCHAR2_TABLE_200
592: , a22 out nocopy JTF_NUMBER_TABLE
593: , a23 out nocopy JTF_NUMBER_TABLE
594: , a24 out nocopy JTF_VARCHAR2_TABLE_100
595: , a25 out nocopy JTF_VARCHAR2_TABLE_100
596: , a26 out nocopy JTF_VARCHAR2_TABLE_100
597: , a27 out nocopy JTF_VARCHAR2_TABLE_100
615: , a45 out nocopy JTF_VARCHAR2_TABLE_500
616: , a46 out nocopy JTF_VARCHAR2_TABLE_500
617: , a47 out nocopy JTF_VARCHAR2_TABLE_500
618: , a48 out nocopy JTF_VARCHAR2_TABLE_500
619: , a49 out nocopy JTF_NUMBER_TABLE
620: , a50 out nocopy JTF_NUMBER_TABLE
621: , a51 out nocopy JTF_DATE_TABLE
622: , a52 out nocopy JTF_DATE_TABLE
623: , a53 out nocopy JTF_NUMBER_TABLE
616: , a46 out nocopy JTF_VARCHAR2_TABLE_500
617: , a47 out nocopy JTF_VARCHAR2_TABLE_500
618: , a48 out nocopy JTF_VARCHAR2_TABLE_500
619: , a49 out nocopy JTF_NUMBER_TABLE
620: , a50 out nocopy JTF_NUMBER_TABLE
621: , a51 out nocopy JTF_DATE_TABLE
622: , a52 out nocopy JTF_DATE_TABLE
623: , a53 out nocopy JTF_NUMBER_TABLE
624: , a54 out nocopy JTF_NUMBER_TABLE
619: , a49 out nocopy JTF_NUMBER_TABLE
620: , a50 out nocopy JTF_NUMBER_TABLE
621: , a51 out nocopy JTF_DATE_TABLE
622: , a52 out nocopy JTF_DATE_TABLE
623: , a53 out nocopy JTF_NUMBER_TABLE
624: , a54 out nocopy JTF_NUMBER_TABLE
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
620: , a50 out nocopy JTF_NUMBER_TABLE
621: , a51 out nocopy JTF_DATE_TABLE
622: , a52 out nocopy JTF_DATE_TABLE
623: , a53 out nocopy JTF_NUMBER_TABLE
624: , a54 out nocopy JTF_NUMBER_TABLE
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if t is null or t.count = 0 then
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_DATE_TABLE();
632: a3 := JTF_DATE_TABLE();
633: a4 := JTF_NUMBER_TABLE();
629: a0 := JTF_NUMBER_TABLE();
630: a1 := JTF_VARCHAR2_TABLE_100();
631: a2 := JTF_DATE_TABLE();
632: a3 := JTF_DATE_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: a6 := JTF_VARCHAR2_TABLE_100();
636: a7 := JTF_VARCHAR2_TABLE_2000();
637: a8 := JTF_NUMBER_TABLE();
633: a4 := JTF_NUMBER_TABLE();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: a6 := JTF_VARCHAR2_TABLE_100();
636: a7 := JTF_VARCHAR2_TABLE_2000();
637: a8 := JTF_NUMBER_TABLE();
638: a9 := JTF_NUMBER_TABLE();
639: a10 := JTF_VARCHAR2_TABLE_100();
640: a11 := JTF_VARCHAR2_TABLE_100();
641: a12 := JTF_VARCHAR2_TABLE_100();
634: a5 := JTF_VARCHAR2_TABLE_100();
635: a6 := JTF_VARCHAR2_TABLE_100();
636: a7 := JTF_VARCHAR2_TABLE_2000();
637: a8 := JTF_NUMBER_TABLE();
638: a9 := JTF_NUMBER_TABLE();
639: a10 := JTF_VARCHAR2_TABLE_100();
640: a11 := JTF_VARCHAR2_TABLE_100();
641: a12 := JTF_VARCHAR2_TABLE_100();
642: a13 := JTF_VARCHAR2_TABLE_100();
639: a10 := JTF_VARCHAR2_TABLE_100();
640: a11 := JTF_VARCHAR2_TABLE_100();
641: a12 := JTF_VARCHAR2_TABLE_100();
642: a13 := JTF_VARCHAR2_TABLE_100();
643: a14 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
640: a11 := JTF_VARCHAR2_TABLE_100();
641: a12 := JTF_VARCHAR2_TABLE_100();
642: a13 := JTF_VARCHAR2_TABLE_100();
643: a14 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
641: a12 := JTF_VARCHAR2_TABLE_100();
642: a13 := JTF_VARCHAR2_TABLE_100();
643: a14 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
642: a13 := JTF_VARCHAR2_TABLE_100();
643: a14 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
650: a21 := JTF_VARCHAR2_TABLE_200();
643: a14 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
650: a21 := JTF_VARCHAR2_TABLE_200();
651: a22 := JTF_NUMBER_TABLE();
644: a15 := JTF_NUMBER_TABLE();
645: a16 := JTF_NUMBER_TABLE();
646: a17 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
650: a21 := JTF_VARCHAR2_TABLE_200();
651: a22 := JTF_NUMBER_TABLE();
652: a23 := JTF_NUMBER_TABLE();
647: a18 := JTF_NUMBER_TABLE();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
650: a21 := JTF_VARCHAR2_TABLE_200();
651: a22 := JTF_NUMBER_TABLE();
652: a23 := JTF_NUMBER_TABLE();
653: a24 := JTF_VARCHAR2_TABLE_100();
654: a25 := JTF_VARCHAR2_TABLE_100();
655: a26 := JTF_VARCHAR2_TABLE_100();
648: a19 := JTF_NUMBER_TABLE();
649: a20 := JTF_VARCHAR2_TABLE_100();
650: a21 := JTF_VARCHAR2_TABLE_200();
651: a22 := JTF_NUMBER_TABLE();
652: a23 := JTF_NUMBER_TABLE();
653: a24 := JTF_VARCHAR2_TABLE_100();
654: a25 := JTF_VARCHAR2_TABLE_100();
655: a26 := JTF_VARCHAR2_TABLE_100();
656: a27 := JTF_VARCHAR2_TABLE_100();
674: a45 := JTF_VARCHAR2_TABLE_500();
675: a46 := JTF_VARCHAR2_TABLE_500();
676: a47 := JTF_VARCHAR2_TABLE_500();
677: a48 := JTF_VARCHAR2_TABLE_500();
678: a49 := JTF_NUMBER_TABLE();
679: a50 := JTF_NUMBER_TABLE();
680: a51 := JTF_DATE_TABLE();
681: a52 := JTF_DATE_TABLE();
682: a53 := JTF_NUMBER_TABLE();
675: a46 := JTF_VARCHAR2_TABLE_500();
676: a47 := JTF_VARCHAR2_TABLE_500();
677: a48 := JTF_VARCHAR2_TABLE_500();
678: a49 := JTF_NUMBER_TABLE();
679: a50 := JTF_NUMBER_TABLE();
680: a51 := JTF_DATE_TABLE();
681: a52 := JTF_DATE_TABLE();
682: a53 := JTF_NUMBER_TABLE();
683: a54 := JTF_NUMBER_TABLE();
678: a49 := JTF_NUMBER_TABLE();
679: a50 := JTF_NUMBER_TABLE();
680: a51 := JTF_DATE_TABLE();
681: a52 := JTF_DATE_TABLE();
682: a53 := JTF_NUMBER_TABLE();
683: a54 := JTF_NUMBER_TABLE();
684: else
685: a0 := JTF_NUMBER_TABLE();
686: a1 := JTF_VARCHAR2_TABLE_100();
679: a50 := JTF_NUMBER_TABLE();
680: a51 := JTF_DATE_TABLE();
681: a52 := JTF_DATE_TABLE();
682: a53 := JTF_NUMBER_TABLE();
683: a54 := JTF_NUMBER_TABLE();
684: else
685: a0 := JTF_NUMBER_TABLE();
686: a1 := JTF_VARCHAR2_TABLE_100();
687: a2 := JTF_DATE_TABLE();
681: a52 := JTF_DATE_TABLE();
682: a53 := JTF_NUMBER_TABLE();
683: a54 := JTF_NUMBER_TABLE();
684: else
685: a0 := JTF_NUMBER_TABLE();
686: a1 := JTF_VARCHAR2_TABLE_100();
687: a2 := JTF_DATE_TABLE();
688: a3 := JTF_DATE_TABLE();
689: a4 := JTF_NUMBER_TABLE();
685: a0 := JTF_NUMBER_TABLE();
686: a1 := JTF_VARCHAR2_TABLE_100();
687: a2 := JTF_DATE_TABLE();
688: a3 := JTF_DATE_TABLE();
689: a4 := JTF_NUMBER_TABLE();
690: a5 := JTF_VARCHAR2_TABLE_100();
691: a6 := JTF_VARCHAR2_TABLE_100();
692: a7 := JTF_VARCHAR2_TABLE_2000();
693: a8 := JTF_NUMBER_TABLE();
689: a4 := JTF_NUMBER_TABLE();
690: a5 := JTF_VARCHAR2_TABLE_100();
691: a6 := JTF_VARCHAR2_TABLE_100();
692: a7 := JTF_VARCHAR2_TABLE_2000();
693: a8 := JTF_NUMBER_TABLE();
694: a9 := JTF_NUMBER_TABLE();
695: a10 := JTF_VARCHAR2_TABLE_100();
696: a11 := JTF_VARCHAR2_TABLE_100();
697: a12 := JTF_VARCHAR2_TABLE_100();
690: a5 := JTF_VARCHAR2_TABLE_100();
691: a6 := JTF_VARCHAR2_TABLE_100();
692: a7 := JTF_VARCHAR2_TABLE_2000();
693: a8 := JTF_NUMBER_TABLE();
694: a9 := JTF_NUMBER_TABLE();
695: a10 := JTF_VARCHAR2_TABLE_100();
696: a11 := JTF_VARCHAR2_TABLE_100();
697: a12 := JTF_VARCHAR2_TABLE_100();
698: a13 := JTF_VARCHAR2_TABLE_100();
695: a10 := JTF_VARCHAR2_TABLE_100();
696: a11 := JTF_VARCHAR2_TABLE_100();
697: a12 := JTF_VARCHAR2_TABLE_100();
698: a13 := JTF_VARCHAR2_TABLE_100();
699: a14 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
696: a11 := JTF_VARCHAR2_TABLE_100();
697: a12 := JTF_VARCHAR2_TABLE_100();
698: a13 := JTF_VARCHAR2_TABLE_100();
699: a14 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
697: a12 := JTF_VARCHAR2_TABLE_100();
698: a13 := JTF_VARCHAR2_TABLE_100();
699: a14 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
698: a13 := JTF_VARCHAR2_TABLE_100();
699: a14 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
706: a21 := JTF_VARCHAR2_TABLE_200();
699: a14 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
706: a21 := JTF_VARCHAR2_TABLE_200();
707: a22 := JTF_NUMBER_TABLE();
700: a15 := JTF_NUMBER_TABLE();
701: a16 := JTF_NUMBER_TABLE();
702: a17 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
706: a21 := JTF_VARCHAR2_TABLE_200();
707: a22 := JTF_NUMBER_TABLE();
708: a23 := JTF_NUMBER_TABLE();
703: a18 := JTF_NUMBER_TABLE();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
706: a21 := JTF_VARCHAR2_TABLE_200();
707: a22 := JTF_NUMBER_TABLE();
708: a23 := JTF_NUMBER_TABLE();
709: a24 := JTF_VARCHAR2_TABLE_100();
710: a25 := JTF_VARCHAR2_TABLE_100();
711: a26 := JTF_VARCHAR2_TABLE_100();
704: a19 := JTF_NUMBER_TABLE();
705: a20 := JTF_VARCHAR2_TABLE_100();
706: a21 := JTF_VARCHAR2_TABLE_200();
707: a22 := JTF_NUMBER_TABLE();
708: a23 := JTF_NUMBER_TABLE();
709: a24 := JTF_VARCHAR2_TABLE_100();
710: a25 := JTF_VARCHAR2_TABLE_100();
711: a26 := JTF_VARCHAR2_TABLE_100();
712: a27 := JTF_VARCHAR2_TABLE_100();
730: a45 := JTF_VARCHAR2_TABLE_500();
731: a46 := JTF_VARCHAR2_TABLE_500();
732: a47 := JTF_VARCHAR2_TABLE_500();
733: a48 := JTF_VARCHAR2_TABLE_500();
734: a49 := JTF_NUMBER_TABLE();
735: a50 := JTF_NUMBER_TABLE();
736: a51 := JTF_DATE_TABLE();
737: a52 := JTF_DATE_TABLE();
738: a53 := JTF_NUMBER_TABLE();
731: a46 := JTF_VARCHAR2_TABLE_500();
732: a47 := JTF_VARCHAR2_TABLE_500();
733: a48 := JTF_VARCHAR2_TABLE_500();
734: a49 := JTF_NUMBER_TABLE();
735: a50 := JTF_NUMBER_TABLE();
736: a51 := JTF_DATE_TABLE();
737: a52 := JTF_DATE_TABLE();
738: a53 := JTF_NUMBER_TABLE();
739: a54 := JTF_NUMBER_TABLE();
734: a49 := JTF_NUMBER_TABLE();
735: a50 := JTF_NUMBER_TABLE();
736: a51 := JTF_DATE_TABLE();
737: a52 := JTF_DATE_TABLE();
738: a53 := JTF_NUMBER_TABLE();
739: a54 := JTF_NUMBER_TABLE();
740: if t.count > 0 then
741: a0.extend(t.count);
742: a1.extend(t.count);
735: a50 := JTF_NUMBER_TABLE();
736: a51 := JTF_DATE_TABLE();
737: a52 := JTF_DATE_TABLE();
738: a53 := JTF_NUMBER_TABLE();
739: a54 := JTF_NUMBER_TABLE();
740: if t.count > 0 then
741: a0.extend(t.count);
742: a1.extend(t.count);
743: a2.extend(t.count);
1124: , p_init_msg_list VARCHAR2
1125: , x_return_status out nocopy VARCHAR2
1126: , x_msg_count out nocopy NUMBER
1127: , x_msg_data out nocopy VARCHAR2
1128: , p5_a0 JTF_NUMBER_TABLE
1129: , p5_a1 JTF_VARCHAR2_TABLE_100
1130: , p5_a2 JTF_DATE_TABLE
1131: , p5_a3 JTF_DATE_TABLE
1132: , p5_a4 JTF_NUMBER_TABLE
1128: , p5_a0 JTF_NUMBER_TABLE
1129: , p5_a1 JTF_VARCHAR2_TABLE_100
1130: , p5_a2 JTF_DATE_TABLE
1131: , p5_a3 JTF_DATE_TABLE
1132: , p5_a4 JTF_NUMBER_TABLE
1133: , p5_a5 JTF_VARCHAR2_TABLE_100
1134: , p5_a6 JTF_VARCHAR2_TABLE_100
1135: , p5_a7 JTF_VARCHAR2_TABLE_2000
1136: , p5_a8 JTF_NUMBER_TABLE
1132: , p5_a4 JTF_NUMBER_TABLE
1133: , p5_a5 JTF_VARCHAR2_TABLE_100
1134: , p5_a6 JTF_VARCHAR2_TABLE_100
1135: , p5_a7 JTF_VARCHAR2_TABLE_2000
1136: , p5_a8 JTF_NUMBER_TABLE
1137: , p5_a9 JTF_NUMBER_TABLE
1138: , p5_a10 JTF_VARCHAR2_TABLE_100
1139: , p5_a11 JTF_VARCHAR2_TABLE_100
1140: , p5_a12 JTF_VARCHAR2_TABLE_100
1133: , p5_a5 JTF_VARCHAR2_TABLE_100
1134: , p5_a6 JTF_VARCHAR2_TABLE_100
1135: , p5_a7 JTF_VARCHAR2_TABLE_2000
1136: , p5_a8 JTF_NUMBER_TABLE
1137: , p5_a9 JTF_NUMBER_TABLE
1138: , p5_a10 JTF_VARCHAR2_TABLE_100
1139: , p5_a11 JTF_VARCHAR2_TABLE_100
1140: , p5_a12 JTF_VARCHAR2_TABLE_100
1141: , p5_a13 JTF_VARCHAR2_TABLE_100
1138: , p5_a10 JTF_VARCHAR2_TABLE_100
1139: , p5_a11 JTF_VARCHAR2_TABLE_100
1140: , p5_a12 JTF_VARCHAR2_TABLE_100
1141: , p5_a13 JTF_VARCHAR2_TABLE_100
1142: , p5_a14 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1139: , p5_a11 JTF_VARCHAR2_TABLE_100
1140: , p5_a12 JTF_VARCHAR2_TABLE_100
1141: , p5_a13 JTF_VARCHAR2_TABLE_100
1142: , p5_a14 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1140: , p5_a12 JTF_VARCHAR2_TABLE_100
1141: , p5_a13 JTF_VARCHAR2_TABLE_100
1142: , p5_a14 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1141: , p5_a13 JTF_VARCHAR2_TABLE_100
1142: , p5_a14 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1149: , p5_a21 JTF_VARCHAR2_TABLE_200
1142: , p5_a14 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1149: , p5_a21 JTF_VARCHAR2_TABLE_200
1150: , p5_a22 JTF_NUMBER_TABLE
1143: , p5_a15 JTF_NUMBER_TABLE
1144: , p5_a16 JTF_NUMBER_TABLE
1145: , p5_a17 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1149: , p5_a21 JTF_VARCHAR2_TABLE_200
1150: , p5_a22 JTF_NUMBER_TABLE
1151: , p5_a23 JTF_NUMBER_TABLE
1146: , p5_a18 JTF_NUMBER_TABLE
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1149: , p5_a21 JTF_VARCHAR2_TABLE_200
1150: , p5_a22 JTF_NUMBER_TABLE
1151: , p5_a23 JTF_NUMBER_TABLE
1152: , p5_a24 JTF_VARCHAR2_TABLE_100
1153: , p5_a25 JTF_VARCHAR2_TABLE_100
1154: , p5_a26 JTF_VARCHAR2_TABLE_100
1147: , p5_a19 JTF_NUMBER_TABLE
1148: , p5_a20 JTF_VARCHAR2_TABLE_100
1149: , p5_a21 JTF_VARCHAR2_TABLE_200
1150: , p5_a22 JTF_NUMBER_TABLE
1151: , p5_a23 JTF_NUMBER_TABLE
1152: , p5_a24 JTF_VARCHAR2_TABLE_100
1153: , p5_a25 JTF_VARCHAR2_TABLE_100
1154: , p5_a26 JTF_VARCHAR2_TABLE_100
1155: , p5_a27 JTF_VARCHAR2_TABLE_100
1173: , p5_a45 JTF_VARCHAR2_TABLE_500
1174: , p5_a46 JTF_VARCHAR2_TABLE_500
1175: , p5_a47 JTF_VARCHAR2_TABLE_500
1176: , p5_a48 JTF_VARCHAR2_TABLE_500
1177: , p5_a49 JTF_NUMBER_TABLE
1178: , p5_a50 JTF_NUMBER_TABLE
1179: , p5_a51 JTF_DATE_TABLE
1180: , p5_a52 JTF_DATE_TABLE
1181: , p5_a53 JTF_NUMBER_TABLE
1174: , p5_a46 JTF_VARCHAR2_TABLE_500
1175: , p5_a47 JTF_VARCHAR2_TABLE_500
1176: , p5_a48 JTF_VARCHAR2_TABLE_500
1177: , p5_a49 JTF_NUMBER_TABLE
1178: , p5_a50 JTF_NUMBER_TABLE
1179: , p5_a51 JTF_DATE_TABLE
1180: , p5_a52 JTF_DATE_TABLE
1181: , p5_a53 JTF_NUMBER_TABLE
1182: , p5_a54 JTF_NUMBER_TABLE
1177: , p5_a49 JTF_NUMBER_TABLE
1178: , p5_a50 JTF_NUMBER_TABLE
1179: , p5_a51 JTF_DATE_TABLE
1180: , p5_a52 JTF_DATE_TABLE
1181: , p5_a53 JTF_NUMBER_TABLE
1182: , p5_a54 JTF_NUMBER_TABLE
1183: , p6_a0 out nocopy JTF_NUMBER_TABLE
1184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1185: , p6_a2 out nocopy JTF_DATE_TABLE
1178: , p5_a50 JTF_NUMBER_TABLE
1179: , p5_a51 JTF_DATE_TABLE
1180: , p5_a52 JTF_DATE_TABLE
1181: , p5_a53 JTF_NUMBER_TABLE
1182: , p5_a54 JTF_NUMBER_TABLE
1183: , p6_a0 out nocopy JTF_NUMBER_TABLE
1184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1185: , p6_a2 out nocopy JTF_DATE_TABLE
1186: , p6_a3 out nocopy JTF_DATE_TABLE
1179: , p5_a51 JTF_DATE_TABLE
1180: , p5_a52 JTF_DATE_TABLE
1181: , p5_a53 JTF_NUMBER_TABLE
1182: , p5_a54 JTF_NUMBER_TABLE
1183: , p6_a0 out nocopy JTF_NUMBER_TABLE
1184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1185: , p6_a2 out nocopy JTF_DATE_TABLE
1186: , p6_a3 out nocopy JTF_DATE_TABLE
1187: , p6_a4 out nocopy JTF_NUMBER_TABLE
1183: , p6_a0 out nocopy JTF_NUMBER_TABLE
1184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1185: , p6_a2 out nocopy JTF_DATE_TABLE
1186: , p6_a3 out nocopy JTF_DATE_TABLE
1187: , p6_a4 out nocopy JTF_NUMBER_TABLE
1188: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1191: , p6_a8 out nocopy JTF_NUMBER_TABLE
1187: , p6_a4 out nocopy JTF_NUMBER_TABLE
1188: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1191: , p6_a8 out nocopy JTF_NUMBER_TABLE
1192: , p6_a9 out nocopy JTF_NUMBER_TABLE
1193: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1194: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1195: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1188: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1191: , p6_a8 out nocopy JTF_NUMBER_TABLE
1192: , p6_a9 out nocopy JTF_NUMBER_TABLE
1193: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1194: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1195: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1193: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1194: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1195: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a14 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1194: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1195: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a14 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1195: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a14 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1196: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a14 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1204: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1197: , p6_a14 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1204: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1205: , p6_a22 out nocopy JTF_NUMBER_TABLE
1198: , p6_a15 out nocopy JTF_NUMBER_TABLE
1199: , p6_a16 out nocopy JTF_NUMBER_TABLE
1200: , p6_a17 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1204: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1205: , p6_a22 out nocopy JTF_NUMBER_TABLE
1206: , p6_a23 out nocopy JTF_NUMBER_TABLE
1201: , p6_a18 out nocopy JTF_NUMBER_TABLE
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1204: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1205: , p6_a22 out nocopy JTF_NUMBER_TABLE
1206: , p6_a23 out nocopy JTF_NUMBER_TABLE
1207: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1209: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1202: , p6_a19 out nocopy JTF_NUMBER_TABLE
1203: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1204: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1205: , p6_a22 out nocopy JTF_NUMBER_TABLE
1206: , p6_a23 out nocopy JTF_NUMBER_TABLE
1207: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1209: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1210: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1229: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1231: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1232: , p6_a49 out nocopy JTF_NUMBER_TABLE
1233: , p6_a50 out nocopy JTF_NUMBER_TABLE
1234: , p6_a51 out nocopy JTF_DATE_TABLE
1235: , p6_a52 out nocopy JTF_DATE_TABLE
1236: , p6_a53 out nocopy JTF_NUMBER_TABLE
1229: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1231: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1232: , p6_a49 out nocopy JTF_NUMBER_TABLE
1233: , p6_a50 out nocopy JTF_NUMBER_TABLE
1234: , p6_a51 out nocopy JTF_DATE_TABLE
1235: , p6_a52 out nocopy JTF_DATE_TABLE
1236: , p6_a53 out nocopy JTF_NUMBER_TABLE
1237: , p6_a54 out nocopy JTF_NUMBER_TABLE
1232: , p6_a49 out nocopy JTF_NUMBER_TABLE
1233: , p6_a50 out nocopy JTF_NUMBER_TABLE
1234: , p6_a51 out nocopy JTF_DATE_TABLE
1235: , p6_a52 out nocopy JTF_DATE_TABLE
1236: , p6_a53 out nocopy JTF_NUMBER_TABLE
1237: , p6_a54 out nocopy JTF_NUMBER_TABLE
1238: )
1239:
1240: as
1233: , p6_a50 out nocopy JTF_NUMBER_TABLE
1234: , p6_a51 out nocopy JTF_DATE_TABLE
1235: , p6_a52 out nocopy JTF_DATE_TABLE
1236: , p6_a53 out nocopy JTF_NUMBER_TABLE
1237: , p6_a54 out nocopy JTF_NUMBER_TABLE
1238: )
1239:
1240: as
1241: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1530: , p_init_msg_list VARCHAR2
1531: , x_return_status out nocopy VARCHAR2
1532: , x_msg_count out nocopy NUMBER
1533: , x_msg_data out nocopy VARCHAR2
1534: , p5_a0 JTF_NUMBER_TABLE
1535: , p5_a1 JTF_VARCHAR2_TABLE_100
1536: , p5_a2 JTF_DATE_TABLE
1537: , p5_a3 JTF_DATE_TABLE
1538: , p5_a4 JTF_NUMBER_TABLE
1534: , p5_a0 JTF_NUMBER_TABLE
1535: , p5_a1 JTF_VARCHAR2_TABLE_100
1536: , p5_a2 JTF_DATE_TABLE
1537: , p5_a3 JTF_DATE_TABLE
1538: , p5_a4 JTF_NUMBER_TABLE
1539: , p5_a5 JTF_VARCHAR2_TABLE_100
1540: , p5_a6 JTF_VARCHAR2_TABLE_100
1541: , p5_a7 JTF_VARCHAR2_TABLE_2000
1542: , p5_a8 JTF_NUMBER_TABLE
1538: , p5_a4 JTF_NUMBER_TABLE
1539: , p5_a5 JTF_VARCHAR2_TABLE_100
1540: , p5_a6 JTF_VARCHAR2_TABLE_100
1541: , p5_a7 JTF_VARCHAR2_TABLE_2000
1542: , p5_a8 JTF_NUMBER_TABLE
1543: , p5_a9 JTF_NUMBER_TABLE
1544: , p5_a10 JTF_VARCHAR2_TABLE_100
1545: , p5_a11 JTF_VARCHAR2_TABLE_100
1546: , p5_a12 JTF_VARCHAR2_TABLE_100
1539: , p5_a5 JTF_VARCHAR2_TABLE_100
1540: , p5_a6 JTF_VARCHAR2_TABLE_100
1541: , p5_a7 JTF_VARCHAR2_TABLE_2000
1542: , p5_a8 JTF_NUMBER_TABLE
1543: , p5_a9 JTF_NUMBER_TABLE
1544: , p5_a10 JTF_VARCHAR2_TABLE_100
1545: , p5_a11 JTF_VARCHAR2_TABLE_100
1546: , p5_a12 JTF_VARCHAR2_TABLE_100
1547: , p5_a13 JTF_VARCHAR2_TABLE_100
1544: , p5_a10 JTF_VARCHAR2_TABLE_100
1545: , p5_a11 JTF_VARCHAR2_TABLE_100
1546: , p5_a12 JTF_VARCHAR2_TABLE_100
1547: , p5_a13 JTF_VARCHAR2_TABLE_100
1548: , p5_a14 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1545: , p5_a11 JTF_VARCHAR2_TABLE_100
1546: , p5_a12 JTF_VARCHAR2_TABLE_100
1547: , p5_a13 JTF_VARCHAR2_TABLE_100
1548: , p5_a14 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1546: , p5_a12 JTF_VARCHAR2_TABLE_100
1547: , p5_a13 JTF_VARCHAR2_TABLE_100
1548: , p5_a14 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1547: , p5_a13 JTF_VARCHAR2_TABLE_100
1548: , p5_a14 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1555: , p5_a21 JTF_VARCHAR2_TABLE_200
1548: , p5_a14 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1555: , p5_a21 JTF_VARCHAR2_TABLE_200
1556: , p5_a22 JTF_NUMBER_TABLE
1549: , p5_a15 JTF_NUMBER_TABLE
1550: , p5_a16 JTF_NUMBER_TABLE
1551: , p5_a17 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1555: , p5_a21 JTF_VARCHAR2_TABLE_200
1556: , p5_a22 JTF_NUMBER_TABLE
1557: , p5_a23 JTF_NUMBER_TABLE
1552: , p5_a18 JTF_NUMBER_TABLE
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1555: , p5_a21 JTF_VARCHAR2_TABLE_200
1556: , p5_a22 JTF_NUMBER_TABLE
1557: , p5_a23 JTF_NUMBER_TABLE
1558: , p5_a24 JTF_VARCHAR2_TABLE_100
1559: , p5_a25 JTF_VARCHAR2_TABLE_100
1560: , p5_a26 JTF_VARCHAR2_TABLE_100
1553: , p5_a19 JTF_NUMBER_TABLE
1554: , p5_a20 JTF_VARCHAR2_TABLE_100
1555: , p5_a21 JTF_VARCHAR2_TABLE_200
1556: , p5_a22 JTF_NUMBER_TABLE
1557: , p5_a23 JTF_NUMBER_TABLE
1558: , p5_a24 JTF_VARCHAR2_TABLE_100
1559: , p5_a25 JTF_VARCHAR2_TABLE_100
1560: , p5_a26 JTF_VARCHAR2_TABLE_100
1561: , p5_a27 JTF_VARCHAR2_TABLE_100
1579: , p5_a45 JTF_VARCHAR2_TABLE_500
1580: , p5_a46 JTF_VARCHAR2_TABLE_500
1581: , p5_a47 JTF_VARCHAR2_TABLE_500
1582: , p5_a48 JTF_VARCHAR2_TABLE_500
1583: , p5_a49 JTF_NUMBER_TABLE
1584: , p5_a50 JTF_NUMBER_TABLE
1585: , p5_a51 JTF_DATE_TABLE
1586: , p5_a52 JTF_DATE_TABLE
1587: , p5_a53 JTF_NUMBER_TABLE
1580: , p5_a46 JTF_VARCHAR2_TABLE_500
1581: , p5_a47 JTF_VARCHAR2_TABLE_500
1582: , p5_a48 JTF_VARCHAR2_TABLE_500
1583: , p5_a49 JTF_NUMBER_TABLE
1584: , p5_a50 JTF_NUMBER_TABLE
1585: , p5_a51 JTF_DATE_TABLE
1586: , p5_a52 JTF_DATE_TABLE
1587: , p5_a53 JTF_NUMBER_TABLE
1588: , p5_a54 JTF_NUMBER_TABLE
1583: , p5_a49 JTF_NUMBER_TABLE
1584: , p5_a50 JTF_NUMBER_TABLE
1585: , p5_a51 JTF_DATE_TABLE
1586: , p5_a52 JTF_DATE_TABLE
1587: , p5_a53 JTF_NUMBER_TABLE
1588: , p5_a54 JTF_NUMBER_TABLE
1589: )
1590:
1591: as
1584: , p5_a50 JTF_NUMBER_TABLE
1585: , p5_a51 JTF_DATE_TABLE
1586: , p5_a52 JTF_DATE_TABLE
1587: , p5_a53 JTF_NUMBER_TABLE
1588: , p5_a54 JTF_NUMBER_TABLE
1589: )
1590:
1591: as
1592: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
1935: , p_init_msg_list VARCHAR2
1936: , x_return_status out nocopy VARCHAR2
1937: , x_msg_count out nocopy NUMBER
1938: , x_msg_data out nocopy VARCHAR2
1939: , p5_a0 JTF_NUMBER_TABLE
1940: , p5_a1 JTF_VARCHAR2_TABLE_100
1941: , p5_a2 JTF_DATE_TABLE
1942: , p5_a3 JTF_DATE_TABLE
1943: , p5_a4 JTF_NUMBER_TABLE
1939: , p5_a0 JTF_NUMBER_TABLE
1940: , p5_a1 JTF_VARCHAR2_TABLE_100
1941: , p5_a2 JTF_DATE_TABLE
1942: , p5_a3 JTF_DATE_TABLE
1943: , p5_a4 JTF_NUMBER_TABLE
1944: , p5_a5 JTF_VARCHAR2_TABLE_100
1945: , p5_a6 JTF_VARCHAR2_TABLE_100
1946: , p5_a7 JTF_VARCHAR2_TABLE_2000
1947: , p5_a8 JTF_NUMBER_TABLE
1943: , p5_a4 JTF_NUMBER_TABLE
1944: , p5_a5 JTF_VARCHAR2_TABLE_100
1945: , p5_a6 JTF_VARCHAR2_TABLE_100
1946: , p5_a7 JTF_VARCHAR2_TABLE_2000
1947: , p5_a8 JTF_NUMBER_TABLE
1948: , p5_a9 JTF_NUMBER_TABLE
1949: , p5_a10 JTF_VARCHAR2_TABLE_100
1950: , p5_a11 JTF_VARCHAR2_TABLE_100
1951: , p5_a12 JTF_VARCHAR2_TABLE_100
1944: , p5_a5 JTF_VARCHAR2_TABLE_100
1945: , p5_a6 JTF_VARCHAR2_TABLE_100
1946: , p5_a7 JTF_VARCHAR2_TABLE_2000
1947: , p5_a8 JTF_NUMBER_TABLE
1948: , p5_a9 JTF_NUMBER_TABLE
1949: , p5_a10 JTF_VARCHAR2_TABLE_100
1950: , p5_a11 JTF_VARCHAR2_TABLE_100
1951: , p5_a12 JTF_VARCHAR2_TABLE_100
1952: , p5_a13 JTF_VARCHAR2_TABLE_100
1949: , p5_a10 JTF_VARCHAR2_TABLE_100
1950: , p5_a11 JTF_VARCHAR2_TABLE_100
1951: , p5_a12 JTF_VARCHAR2_TABLE_100
1952: , p5_a13 JTF_VARCHAR2_TABLE_100
1953: , p5_a14 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1950: , p5_a11 JTF_VARCHAR2_TABLE_100
1951: , p5_a12 JTF_VARCHAR2_TABLE_100
1952: , p5_a13 JTF_VARCHAR2_TABLE_100
1953: , p5_a14 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1951: , p5_a12 JTF_VARCHAR2_TABLE_100
1952: , p5_a13 JTF_VARCHAR2_TABLE_100
1953: , p5_a14 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1952: , p5_a13 JTF_VARCHAR2_TABLE_100
1953: , p5_a14 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1960: , p5_a21 JTF_VARCHAR2_TABLE_200
1953: , p5_a14 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1960: , p5_a21 JTF_VARCHAR2_TABLE_200
1961: , p5_a22 JTF_NUMBER_TABLE
1954: , p5_a15 JTF_NUMBER_TABLE
1955: , p5_a16 JTF_NUMBER_TABLE
1956: , p5_a17 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1960: , p5_a21 JTF_VARCHAR2_TABLE_200
1961: , p5_a22 JTF_NUMBER_TABLE
1962: , p5_a23 JTF_NUMBER_TABLE
1957: , p5_a18 JTF_NUMBER_TABLE
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1960: , p5_a21 JTF_VARCHAR2_TABLE_200
1961: , p5_a22 JTF_NUMBER_TABLE
1962: , p5_a23 JTF_NUMBER_TABLE
1963: , p5_a24 JTF_VARCHAR2_TABLE_100
1964: , p5_a25 JTF_VARCHAR2_TABLE_100
1965: , p5_a26 JTF_VARCHAR2_TABLE_100
1958: , p5_a19 JTF_NUMBER_TABLE
1959: , p5_a20 JTF_VARCHAR2_TABLE_100
1960: , p5_a21 JTF_VARCHAR2_TABLE_200
1961: , p5_a22 JTF_NUMBER_TABLE
1962: , p5_a23 JTF_NUMBER_TABLE
1963: , p5_a24 JTF_VARCHAR2_TABLE_100
1964: , p5_a25 JTF_VARCHAR2_TABLE_100
1965: , p5_a26 JTF_VARCHAR2_TABLE_100
1966: , p5_a27 JTF_VARCHAR2_TABLE_100
1984: , p5_a45 JTF_VARCHAR2_TABLE_500
1985: , p5_a46 JTF_VARCHAR2_TABLE_500
1986: , p5_a47 JTF_VARCHAR2_TABLE_500
1987: , p5_a48 JTF_VARCHAR2_TABLE_500
1988: , p5_a49 JTF_NUMBER_TABLE
1989: , p5_a50 JTF_NUMBER_TABLE
1990: , p5_a51 JTF_DATE_TABLE
1991: , p5_a52 JTF_DATE_TABLE
1992: , p5_a53 JTF_NUMBER_TABLE
1985: , p5_a46 JTF_VARCHAR2_TABLE_500
1986: , p5_a47 JTF_VARCHAR2_TABLE_500
1987: , p5_a48 JTF_VARCHAR2_TABLE_500
1988: , p5_a49 JTF_NUMBER_TABLE
1989: , p5_a50 JTF_NUMBER_TABLE
1990: , p5_a51 JTF_DATE_TABLE
1991: , p5_a52 JTF_DATE_TABLE
1992: , p5_a53 JTF_NUMBER_TABLE
1993: , p5_a54 JTF_NUMBER_TABLE
1988: , p5_a49 JTF_NUMBER_TABLE
1989: , p5_a50 JTF_NUMBER_TABLE
1990: , p5_a51 JTF_DATE_TABLE
1991: , p5_a52 JTF_DATE_TABLE
1992: , p5_a53 JTF_NUMBER_TABLE
1993: , p5_a54 JTF_NUMBER_TABLE
1994: , p6_a0 out nocopy JTF_NUMBER_TABLE
1995: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a2 out nocopy JTF_DATE_TABLE
1989: , p5_a50 JTF_NUMBER_TABLE
1990: , p5_a51 JTF_DATE_TABLE
1991: , p5_a52 JTF_DATE_TABLE
1992: , p5_a53 JTF_NUMBER_TABLE
1993: , p5_a54 JTF_NUMBER_TABLE
1994: , p6_a0 out nocopy JTF_NUMBER_TABLE
1995: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a2 out nocopy JTF_DATE_TABLE
1997: , p6_a3 out nocopy JTF_DATE_TABLE
1990: , p5_a51 JTF_DATE_TABLE
1991: , p5_a52 JTF_DATE_TABLE
1992: , p5_a53 JTF_NUMBER_TABLE
1993: , p5_a54 JTF_NUMBER_TABLE
1994: , p6_a0 out nocopy JTF_NUMBER_TABLE
1995: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a2 out nocopy JTF_DATE_TABLE
1997: , p6_a3 out nocopy JTF_DATE_TABLE
1998: , p6_a4 out nocopy JTF_NUMBER_TABLE
1994: , p6_a0 out nocopy JTF_NUMBER_TABLE
1995: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a2 out nocopy JTF_DATE_TABLE
1997: , p6_a3 out nocopy JTF_DATE_TABLE
1998: , p6_a4 out nocopy JTF_NUMBER_TABLE
1999: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2000: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2002: , p6_a8 out nocopy JTF_NUMBER_TABLE
1998: , p6_a4 out nocopy JTF_NUMBER_TABLE
1999: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2000: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2002: , p6_a8 out nocopy JTF_NUMBER_TABLE
2003: , p6_a9 out nocopy JTF_NUMBER_TABLE
2004: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1999: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2000: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2002: , p6_a8 out nocopy JTF_NUMBER_TABLE
2003: , p6_a9 out nocopy JTF_NUMBER_TABLE
2004: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a14 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2005: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a14 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2006: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a14 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a14 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2008: , p6_a14 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2016: , p6_a22 out nocopy JTF_NUMBER_TABLE
2009: , p6_a15 out nocopy JTF_NUMBER_TABLE
2010: , p6_a16 out nocopy JTF_NUMBER_TABLE
2011: , p6_a17 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2016: , p6_a22 out nocopy JTF_NUMBER_TABLE
2017: , p6_a23 out nocopy JTF_NUMBER_TABLE
2012: , p6_a18 out nocopy JTF_NUMBER_TABLE
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2016: , p6_a22 out nocopy JTF_NUMBER_TABLE
2017: , p6_a23 out nocopy JTF_NUMBER_TABLE
2018: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2013: , p6_a19 out nocopy JTF_NUMBER_TABLE
2014: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2016: , p6_a22 out nocopy JTF_NUMBER_TABLE
2017: , p6_a23 out nocopy JTF_NUMBER_TABLE
2018: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2021: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2039: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2040: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
2041: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
2042: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
2043: , p6_a49 out nocopy JTF_NUMBER_TABLE
2044: , p6_a50 out nocopy JTF_NUMBER_TABLE
2045: , p6_a51 out nocopy JTF_DATE_TABLE
2046: , p6_a52 out nocopy JTF_DATE_TABLE
2047: , p6_a53 out nocopy JTF_NUMBER_TABLE
2040: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
2041: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
2042: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
2043: , p6_a49 out nocopy JTF_NUMBER_TABLE
2044: , p6_a50 out nocopy JTF_NUMBER_TABLE
2045: , p6_a51 out nocopy JTF_DATE_TABLE
2046: , p6_a52 out nocopy JTF_DATE_TABLE
2047: , p6_a53 out nocopy JTF_NUMBER_TABLE
2048: , p6_a54 out nocopy JTF_NUMBER_TABLE
2043: , p6_a49 out nocopy JTF_NUMBER_TABLE
2044: , p6_a50 out nocopy JTF_NUMBER_TABLE
2045: , p6_a51 out nocopy JTF_DATE_TABLE
2046: , p6_a52 out nocopy JTF_DATE_TABLE
2047: , p6_a53 out nocopy JTF_NUMBER_TABLE
2048: , p6_a54 out nocopy JTF_NUMBER_TABLE
2049: )
2050:
2051: as
2044: , p6_a50 out nocopy JTF_NUMBER_TABLE
2045: , p6_a51 out nocopy JTF_DATE_TABLE
2046: , p6_a52 out nocopy JTF_DATE_TABLE
2047: , p6_a53 out nocopy JTF_NUMBER_TABLE
2048: , p6_a54 out nocopy JTF_NUMBER_TABLE
2049: )
2050:
2051: as
2052: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2341: , p_init_msg_list VARCHAR2
2342: , x_return_status out nocopy VARCHAR2
2343: , x_msg_count out nocopy NUMBER
2344: , x_msg_data out nocopy VARCHAR2
2345: , p5_a0 JTF_NUMBER_TABLE
2346: , p5_a1 JTF_VARCHAR2_TABLE_100
2347: , p5_a2 JTF_DATE_TABLE
2348: , p5_a3 JTF_DATE_TABLE
2349: , p5_a4 JTF_NUMBER_TABLE
2345: , p5_a0 JTF_NUMBER_TABLE
2346: , p5_a1 JTF_VARCHAR2_TABLE_100
2347: , p5_a2 JTF_DATE_TABLE
2348: , p5_a3 JTF_DATE_TABLE
2349: , p5_a4 JTF_NUMBER_TABLE
2350: , p5_a5 JTF_VARCHAR2_TABLE_100
2351: , p5_a6 JTF_VARCHAR2_TABLE_100
2352: , p5_a7 JTF_VARCHAR2_TABLE_2000
2353: , p5_a8 JTF_NUMBER_TABLE
2349: , p5_a4 JTF_NUMBER_TABLE
2350: , p5_a5 JTF_VARCHAR2_TABLE_100
2351: , p5_a6 JTF_VARCHAR2_TABLE_100
2352: , p5_a7 JTF_VARCHAR2_TABLE_2000
2353: , p5_a8 JTF_NUMBER_TABLE
2354: , p5_a9 JTF_NUMBER_TABLE
2355: , p5_a10 JTF_VARCHAR2_TABLE_100
2356: , p5_a11 JTF_VARCHAR2_TABLE_100
2357: , p5_a12 JTF_VARCHAR2_TABLE_100
2350: , p5_a5 JTF_VARCHAR2_TABLE_100
2351: , p5_a6 JTF_VARCHAR2_TABLE_100
2352: , p5_a7 JTF_VARCHAR2_TABLE_2000
2353: , p5_a8 JTF_NUMBER_TABLE
2354: , p5_a9 JTF_NUMBER_TABLE
2355: , p5_a10 JTF_VARCHAR2_TABLE_100
2356: , p5_a11 JTF_VARCHAR2_TABLE_100
2357: , p5_a12 JTF_VARCHAR2_TABLE_100
2358: , p5_a13 JTF_VARCHAR2_TABLE_100
2355: , p5_a10 JTF_VARCHAR2_TABLE_100
2356: , p5_a11 JTF_VARCHAR2_TABLE_100
2357: , p5_a12 JTF_VARCHAR2_TABLE_100
2358: , p5_a13 JTF_VARCHAR2_TABLE_100
2359: , p5_a14 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2356: , p5_a11 JTF_VARCHAR2_TABLE_100
2357: , p5_a12 JTF_VARCHAR2_TABLE_100
2358: , p5_a13 JTF_VARCHAR2_TABLE_100
2359: , p5_a14 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2357: , p5_a12 JTF_VARCHAR2_TABLE_100
2358: , p5_a13 JTF_VARCHAR2_TABLE_100
2359: , p5_a14 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2358: , p5_a13 JTF_VARCHAR2_TABLE_100
2359: , p5_a14 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2366: , p5_a21 JTF_VARCHAR2_TABLE_200
2359: , p5_a14 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2366: , p5_a21 JTF_VARCHAR2_TABLE_200
2367: , p5_a22 JTF_NUMBER_TABLE
2360: , p5_a15 JTF_NUMBER_TABLE
2361: , p5_a16 JTF_NUMBER_TABLE
2362: , p5_a17 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2366: , p5_a21 JTF_VARCHAR2_TABLE_200
2367: , p5_a22 JTF_NUMBER_TABLE
2368: , p5_a23 JTF_NUMBER_TABLE
2363: , p5_a18 JTF_NUMBER_TABLE
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2366: , p5_a21 JTF_VARCHAR2_TABLE_200
2367: , p5_a22 JTF_NUMBER_TABLE
2368: , p5_a23 JTF_NUMBER_TABLE
2369: , p5_a24 JTF_VARCHAR2_TABLE_100
2370: , p5_a25 JTF_VARCHAR2_TABLE_100
2371: , p5_a26 JTF_VARCHAR2_TABLE_100
2364: , p5_a19 JTF_NUMBER_TABLE
2365: , p5_a20 JTF_VARCHAR2_TABLE_100
2366: , p5_a21 JTF_VARCHAR2_TABLE_200
2367: , p5_a22 JTF_NUMBER_TABLE
2368: , p5_a23 JTF_NUMBER_TABLE
2369: , p5_a24 JTF_VARCHAR2_TABLE_100
2370: , p5_a25 JTF_VARCHAR2_TABLE_100
2371: , p5_a26 JTF_VARCHAR2_TABLE_100
2372: , p5_a27 JTF_VARCHAR2_TABLE_100
2390: , p5_a45 JTF_VARCHAR2_TABLE_500
2391: , p5_a46 JTF_VARCHAR2_TABLE_500
2392: , p5_a47 JTF_VARCHAR2_TABLE_500
2393: , p5_a48 JTF_VARCHAR2_TABLE_500
2394: , p5_a49 JTF_NUMBER_TABLE
2395: , p5_a50 JTF_NUMBER_TABLE
2396: , p5_a51 JTF_DATE_TABLE
2397: , p5_a52 JTF_DATE_TABLE
2398: , p5_a53 JTF_NUMBER_TABLE
2391: , p5_a46 JTF_VARCHAR2_TABLE_500
2392: , p5_a47 JTF_VARCHAR2_TABLE_500
2393: , p5_a48 JTF_VARCHAR2_TABLE_500
2394: , p5_a49 JTF_NUMBER_TABLE
2395: , p5_a50 JTF_NUMBER_TABLE
2396: , p5_a51 JTF_DATE_TABLE
2397: , p5_a52 JTF_DATE_TABLE
2398: , p5_a53 JTF_NUMBER_TABLE
2399: , p5_a54 JTF_NUMBER_TABLE
2394: , p5_a49 JTF_NUMBER_TABLE
2395: , p5_a50 JTF_NUMBER_TABLE
2396: , p5_a51 JTF_DATE_TABLE
2397: , p5_a52 JTF_DATE_TABLE
2398: , p5_a53 JTF_NUMBER_TABLE
2399: , p5_a54 JTF_NUMBER_TABLE
2400: )
2401:
2402: as
2395: , p5_a50 JTF_NUMBER_TABLE
2396: , p5_a51 JTF_DATE_TABLE
2397: , p5_a52 JTF_DATE_TABLE
2398: , p5_a53 JTF_NUMBER_TABLE
2399: , p5_a54 JTF_NUMBER_TABLE
2400: )
2401:
2402: as
2403: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;
2632: , p_init_msg_list VARCHAR2
2633: , x_return_status out nocopy VARCHAR2
2634: , x_msg_count out nocopy NUMBER
2635: , x_msg_data out nocopy VARCHAR2
2636: , p5_a0 JTF_NUMBER_TABLE
2637: , p5_a1 JTF_VARCHAR2_TABLE_100
2638: , p5_a2 JTF_DATE_TABLE
2639: , p5_a3 JTF_DATE_TABLE
2640: , p5_a4 JTF_NUMBER_TABLE
2636: , p5_a0 JTF_NUMBER_TABLE
2637: , p5_a1 JTF_VARCHAR2_TABLE_100
2638: , p5_a2 JTF_DATE_TABLE
2639: , p5_a3 JTF_DATE_TABLE
2640: , p5_a4 JTF_NUMBER_TABLE
2641: , p5_a5 JTF_VARCHAR2_TABLE_100
2642: , p5_a6 JTF_VARCHAR2_TABLE_100
2643: , p5_a7 JTF_VARCHAR2_TABLE_2000
2644: , p5_a8 JTF_NUMBER_TABLE
2640: , p5_a4 JTF_NUMBER_TABLE
2641: , p5_a5 JTF_VARCHAR2_TABLE_100
2642: , p5_a6 JTF_VARCHAR2_TABLE_100
2643: , p5_a7 JTF_VARCHAR2_TABLE_2000
2644: , p5_a8 JTF_NUMBER_TABLE
2645: , p5_a9 JTF_NUMBER_TABLE
2646: , p5_a10 JTF_VARCHAR2_TABLE_100
2647: , p5_a11 JTF_VARCHAR2_TABLE_100
2648: , p5_a12 JTF_VARCHAR2_TABLE_100
2641: , p5_a5 JTF_VARCHAR2_TABLE_100
2642: , p5_a6 JTF_VARCHAR2_TABLE_100
2643: , p5_a7 JTF_VARCHAR2_TABLE_2000
2644: , p5_a8 JTF_NUMBER_TABLE
2645: , p5_a9 JTF_NUMBER_TABLE
2646: , p5_a10 JTF_VARCHAR2_TABLE_100
2647: , p5_a11 JTF_VARCHAR2_TABLE_100
2648: , p5_a12 JTF_VARCHAR2_TABLE_100
2649: , p5_a13 JTF_VARCHAR2_TABLE_100
2646: , p5_a10 JTF_VARCHAR2_TABLE_100
2647: , p5_a11 JTF_VARCHAR2_TABLE_100
2648: , p5_a12 JTF_VARCHAR2_TABLE_100
2649: , p5_a13 JTF_VARCHAR2_TABLE_100
2650: , p5_a14 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2647: , p5_a11 JTF_VARCHAR2_TABLE_100
2648: , p5_a12 JTF_VARCHAR2_TABLE_100
2649: , p5_a13 JTF_VARCHAR2_TABLE_100
2650: , p5_a14 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2648: , p5_a12 JTF_VARCHAR2_TABLE_100
2649: , p5_a13 JTF_VARCHAR2_TABLE_100
2650: , p5_a14 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2649: , p5_a13 JTF_VARCHAR2_TABLE_100
2650: , p5_a14 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2657: , p5_a21 JTF_VARCHAR2_TABLE_200
2650: , p5_a14 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2657: , p5_a21 JTF_VARCHAR2_TABLE_200
2658: , p5_a22 JTF_NUMBER_TABLE
2651: , p5_a15 JTF_NUMBER_TABLE
2652: , p5_a16 JTF_NUMBER_TABLE
2653: , p5_a17 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2657: , p5_a21 JTF_VARCHAR2_TABLE_200
2658: , p5_a22 JTF_NUMBER_TABLE
2659: , p5_a23 JTF_NUMBER_TABLE
2654: , p5_a18 JTF_NUMBER_TABLE
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2657: , p5_a21 JTF_VARCHAR2_TABLE_200
2658: , p5_a22 JTF_NUMBER_TABLE
2659: , p5_a23 JTF_NUMBER_TABLE
2660: , p5_a24 JTF_VARCHAR2_TABLE_100
2661: , p5_a25 JTF_VARCHAR2_TABLE_100
2662: , p5_a26 JTF_VARCHAR2_TABLE_100
2655: , p5_a19 JTF_NUMBER_TABLE
2656: , p5_a20 JTF_VARCHAR2_TABLE_100
2657: , p5_a21 JTF_VARCHAR2_TABLE_200
2658: , p5_a22 JTF_NUMBER_TABLE
2659: , p5_a23 JTF_NUMBER_TABLE
2660: , p5_a24 JTF_VARCHAR2_TABLE_100
2661: , p5_a25 JTF_VARCHAR2_TABLE_100
2662: , p5_a26 JTF_VARCHAR2_TABLE_100
2663: , p5_a27 JTF_VARCHAR2_TABLE_100
2681: , p5_a45 JTF_VARCHAR2_TABLE_500
2682: , p5_a46 JTF_VARCHAR2_TABLE_500
2683: , p5_a47 JTF_VARCHAR2_TABLE_500
2684: , p5_a48 JTF_VARCHAR2_TABLE_500
2685: , p5_a49 JTF_NUMBER_TABLE
2686: , p5_a50 JTF_NUMBER_TABLE
2687: , p5_a51 JTF_DATE_TABLE
2688: , p5_a52 JTF_DATE_TABLE
2689: , p5_a53 JTF_NUMBER_TABLE
2682: , p5_a46 JTF_VARCHAR2_TABLE_500
2683: , p5_a47 JTF_VARCHAR2_TABLE_500
2684: , p5_a48 JTF_VARCHAR2_TABLE_500
2685: , p5_a49 JTF_NUMBER_TABLE
2686: , p5_a50 JTF_NUMBER_TABLE
2687: , p5_a51 JTF_DATE_TABLE
2688: , p5_a52 JTF_DATE_TABLE
2689: , p5_a53 JTF_NUMBER_TABLE
2690: , p5_a54 JTF_NUMBER_TABLE
2685: , p5_a49 JTF_NUMBER_TABLE
2686: , p5_a50 JTF_NUMBER_TABLE
2687: , p5_a51 JTF_DATE_TABLE
2688: , p5_a52 JTF_DATE_TABLE
2689: , p5_a53 JTF_NUMBER_TABLE
2690: , p5_a54 JTF_NUMBER_TABLE
2691: )
2692:
2693: as
2686: , p5_a50 JTF_NUMBER_TABLE
2687: , p5_a51 JTF_DATE_TABLE
2688: , p5_a52 JTF_DATE_TABLE
2689: , p5_a53 JTF_NUMBER_TABLE
2690: , p5_a54 JTF_NUMBER_TABLE
2691: )
2692:
2693: as
2694: ddp_sfev_tbl okl_sfe_pvt.sfev_tbl_type;