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_sub_pvt.subv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sub_pvt.subv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sub_pvt.subv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_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_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_100
44: , a22 JTF_VARCHAR2_TABLE_100
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_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_500
54: , a32 JTF_VARCHAR2_TABLE_500
64: , a42 JTF_VARCHAR2_TABLE_500
65: , a43 JTF_VARCHAR2_TABLE_100
66: , a44 JTF_VARCHAR2_TABLE_500
67: , a45 JTF_VARCHAR2_TABLE_500
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_DATE_TABLE
70: , a48 JTF_NUMBER_TABLE
71: , a49 JTF_DATE_TABLE
72: , a50 JTF_NUMBER_TABLE
66: , a44 JTF_VARCHAR2_TABLE_500
67: , a45 JTF_VARCHAR2_TABLE_500
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_DATE_TABLE
70: , a48 JTF_NUMBER_TABLE
71: , a49 JTF_DATE_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_NUMBER_TABLE
74: ) as
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_DATE_TABLE
70: , a48 JTF_NUMBER_TABLE
71: , a49 JTF_DATE_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_NUMBER_TABLE
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
69: , a47 JTF_DATE_TABLE
70: , a48 JTF_NUMBER_TABLE
71: , a49 JTF_DATE_TABLE
72: , a50 JTF_NUMBER_TABLE
73: , a51 JTF_NUMBER_TABLE
74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if a0 is not null and a0.count > 0 then
139: end loop;
140: end if;
141: end if;
142: end rosetta_table_copy_in_p2;
143: procedure rosetta_table_copy_out_p2(t okl_sub_pvt.subv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_VARCHAR2_TABLE_100
140: end if;
141: end if;
142: end rosetta_table_copy_in_p2;
143: procedure rosetta_table_copy_out_p2(t okl_sub_pvt.subv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_VARCHAR2_TABLE_100
148: , a5 out nocopy JTF_VARCHAR2_TABLE_200
142: end rosetta_table_copy_in_p2;
143: procedure rosetta_table_copy_out_p2(t okl_sub_pvt.subv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_VARCHAR2_TABLE_100
148: , a5 out nocopy JTF_VARCHAR2_TABLE_200
149: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
150: , a7 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_VARCHAR2_TABLE_200
149: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
150: , a7 out nocopy JTF_DATE_TABLE
151: , a8 out nocopy JTF_DATE_TABLE
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_VARCHAR2_TABLE_100
154: , a11 out nocopy JTF_VARCHAR2_TABLE_100
155: , a12 out nocopy JTF_VARCHAR2_TABLE_100
156: , a13 out nocopy JTF_VARCHAR2_TABLE_100
153: , a10 out nocopy JTF_VARCHAR2_TABLE_100
154: , a11 out nocopy JTF_VARCHAR2_TABLE_100
155: , a12 out nocopy JTF_VARCHAR2_TABLE_100
156: , a13 out nocopy JTF_VARCHAR2_TABLE_100
157: , a14 out nocopy JTF_NUMBER_TABLE
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_VARCHAR2_TABLE_100
155: , a12 out nocopy JTF_VARCHAR2_TABLE_100
156: , a13 out nocopy JTF_VARCHAR2_TABLE_100
157: , a14 out nocopy JTF_NUMBER_TABLE
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_VARCHAR2_TABLE_100
156: , a13 out nocopy JTF_VARCHAR2_TABLE_100
157: , a14 out nocopy JTF_NUMBER_TABLE
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
156: , a13 out nocopy JTF_VARCHAR2_TABLE_100
157: , a14 out nocopy JTF_NUMBER_TABLE
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
157: , a14 out nocopy JTF_NUMBER_TABLE
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_100
158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_NUMBER_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_100
166: , a23 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_100
166: , a23 out nocopy JTF_NUMBER_TABLE
167: , a24 out nocopy JTF_NUMBER_TABLE
168: , a25 out nocopy JTF_VARCHAR2_TABLE_100
169: , a26 out nocopy JTF_VARCHAR2_TABLE_100
170: , a27 out nocopy JTF_NUMBER_TABLE
163: , a20 out nocopy JTF_VARCHAR2_TABLE_100
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_100
166: , a23 out nocopy JTF_NUMBER_TABLE
167: , a24 out nocopy JTF_NUMBER_TABLE
168: , a25 out nocopy JTF_VARCHAR2_TABLE_100
169: , a26 out nocopy JTF_VARCHAR2_TABLE_100
170: , a27 out nocopy JTF_NUMBER_TABLE
171: , a28 out nocopy JTF_NUMBER_TABLE
166: , a23 out nocopy JTF_NUMBER_TABLE
167: , a24 out nocopy JTF_NUMBER_TABLE
168: , a25 out nocopy JTF_VARCHAR2_TABLE_100
169: , a26 out nocopy JTF_VARCHAR2_TABLE_100
170: , a27 out nocopy JTF_NUMBER_TABLE
171: , a28 out nocopy JTF_NUMBER_TABLE
172: , a29 out nocopy JTF_VARCHAR2_TABLE_100
173: , a30 out nocopy JTF_VARCHAR2_TABLE_100
174: , a31 out nocopy JTF_VARCHAR2_TABLE_500
167: , a24 out nocopy JTF_NUMBER_TABLE
168: , a25 out nocopy JTF_VARCHAR2_TABLE_100
169: , a26 out nocopy JTF_VARCHAR2_TABLE_100
170: , a27 out nocopy JTF_NUMBER_TABLE
171: , a28 out nocopy JTF_NUMBER_TABLE
172: , a29 out nocopy JTF_VARCHAR2_TABLE_100
173: , a30 out nocopy JTF_VARCHAR2_TABLE_100
174: , a31 out nocopy JTF_VARCHAR2_TABLE_500
175: , a32 out nocopy JTF_VARCHAR2_TABLE_500
185: , a42 out nocopy JTF_VARCHAR2_TABLE_500
186: , a43 out nocopy JTF_VARCHAR2_TABLE_100
187: , a44 out nocopy JTF_VARCHAR2_TABLE_500
188: , a45 out nocopy JTF_VARCHAR2_TABLE_500
189: , a46 out nocopy JTF_NUMBER_TABLE
190: , a47 out nocopy JTF_DATE_TABLE
191: , a48 out nocopy JTF_NUMBER_TABLE
192: , a49 out nocopy JTF_DATE_TABLE
193: , a50 out nocopy JTF_NUMBER_TABLE
187: , a44 out nocopy JTF_VARCHAR2_TABLE_500
188: , a45 out nocopy JTF_VARCHAR2_TABLE_500
189: , a46 out nocopy JTF_NUMBER_TABLE
190: , a47 out nocopy JTF_DATE_TABLE
191: , a48 out nocopy JTF_NUMBER_TABLE
192: , a49 out nocopy JTF_DATE_TABLE
193: , a50 out nocopy JTF_NUMBER_TABLE
194: , a51 out nocopy JTF_NUMBER_TABLE
195: ) as
189: , a46 out nocopy JTF_NUMBER_TABLE
190: , a47 out nocopy JTF_DATE_TABLE
191: , a48 out nocopy JTF_NUMBER_TABLE
192: , a49 out nocopy JTF_DATE_TABLE
193: , a50 out nocopy JTF_NUMBER_TABLE
194: , a51 out nocopy JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
190: , a47 out nocopy JTF_DATE_TABLE
191: , a48 out nocopy JTF_NUMBER_TABLE
192: , a49 out nocopy JTF_DATE_TABLE
193: , a50 out nocopy JTF_NUMBER_TABLE
194: , a51 out nocopy JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_200();
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_200();
205: a6 := JTF_VARCHAR2_TABLE_2000();
206: a7 := JTF_DATE_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_200();
205: a6 := JTF_VARCHAR2_TABLE_2000();
206: a7 := JTF_DATE_TABLE();
207: a8 := JTF_DATE_TABLE();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_VARCHAR2_TABLE_100();
210: a11 := JTF_VARCHAR2_TABLE_100();
211: a12 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_VARCHAR2_TABLE_100();
210: a11 := JTF_VARCHAR2_TABLE_100();
211: a12 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_VARCHAR2_TABLE_100();
213: a14 := JTF_NUMBER_TABLE();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
210: a11 := JTF_VARCHAR2_TABLE_100();
211: a12 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_VARCHAR2_TABLE_100();
213: a14 := JTF_NUMBER_TABLE();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
211: a12 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_VARCHAR2_TABLE_100();
213: a14 := JTF_NUMBER_TABLE();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_VARCHAR2_TABLE_100();
213: a14 := JTF_NUMBER_TABLE();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
220: a21 := JTF_VARCHAR2_TABLE_100();
213: a14 := JTF_NUMBER_TABLE();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
220: a21 := JTF_VARCHAR2_TABLE_100();
221: a22 := JTF_VARCHAR2_TABLE_100();
214: a15 := JTF_NUMBER_TABLE();
215: a16 := JTF_NUMBER_TABLE();
216: a17 := JTF_NUMBER_TABLE();
217: a18 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
220: a21 := JTF_VARCHAR2_TABLE_100();
221: a22 := JTF_VARCHAR2_TABLE_100();
222: a23 := JTF_NUMBER_TABLE();
218: a19 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
220: a21 := JTF_VARCHAR2_TABLE_100();
221: a22 := JTF_VARCHAR2_TABLE_100();
222: a23 := JTF_NUMBER_TABLE();
223: a24 := JTF_NUMBER_TABLE();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_100();
226: a27 := JTF_NUMBER_TABLE();
219: a20 := JTF_VARCHAR2_TABLE_100();
220: a21 := JTF_VARCHAR2_TABLE_100();
221: a22 := JTF_VARCHAR2_TABLE_100();
222: a23 := JTF_NUMBER_TABLE();
223: a24 := JTF_NUMBER_TABLE();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_100();
226: a27 := JTF_NUMBER_TABLE();
227: a28 := JTF_NUMBER_TABLE();
222: a23 := JTF_NUMBER_TABLE();
223: a24 := JTF_NUMBER_TABLE();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_100();
226: a27 := JTF_NUMBER_TABLE();
227: a28 := JTF_NUMBER_TABLE();
228: a29 := JTF_VARCHAR2_TABLE_100();
229: a30 := JTF_VARCHAR2_TABLE_100();
230: a31 := JTF_VARCHAR2_TABLE_500();
223: a24 := JTF_NUMBER_TABLE();
224: a25 := JTF_VARCHAR2_TABLE_100();
225: a26 := JTF_VARCHAR2_TABLE_100();
226: a27 := JTF_NUMBER_TABLE();
227: a28 := JTF_NUMBER_TABLE();
228: a29 := JTF_VARCHAR2_TABLE_100();
229: a30 := JTF_VARCHAR2_TABLE_100();
230: a31 := JTF_VARCHAR2_TABLE_500();
231: a32 := JTF_VARCHAR2_TABLE_500();
241: a42 := JTF_VARCHAR2_TABLE_500();
242: a43 := JTF_VARCHAR2_TABLE_100();
243: a44 := JTF_VARCHAR2_TABLE_500();
244: a45 := JTF_VARCHAR2_TABLE_500();
245: a46 := JTF_NUMBER_TABLE();
246: a47 := JTF_DATE_TABLE();
247: a48 := JTF_NUMBER_TABLE();
248: a49 := JTF_DATE_TABLE();
249: a50 := JTF_NUMBER_TABLE();
243: a44 := JTF_VARCHAR2_TABLE_500();
244: a45 := JTF_VARCHAR2_TABLE_500();
245: a46 := JTF_NUMBER_TABLE();
246: a47 := JTF_DATE_TABLE();
247: a48 := JTF_NUMBER_TABLE();
248: a49 := JTF_DATE_TABLE();
249: a50 := JTF_NUMBER_TABLE();
250: a51 := JTF_NUMBER_TABLE();
251: else
245: a46 := JTF_NUMBER_TABLE();
246: a47 := JTF_DATE_TABLE();
247: a48 := JTF_NUMBER_TABLE();
248: a49 := JTF_DATE_TABLE();
249: a50 := JTF_NUMBER_TABLE();
250: a51 := JTF_NUMBER_TABLE();
251: else
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_NUMBER_TABLE();
246: a47 := JTF_DATE_TABLE();
247: a48 := JTF_NUMBER_TABLE();
248: a49 := JTF_DATE_TABLE();
249: a50 := JTF_NUMBER_TABLE();
250: a51 := JTF_NUMBER_TABLE();
251: else
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_NUMBER_TABLE();
254: a2 := JTF_VARCHAR2_TABLE_100();
248: a49 := JTF_DATE_TABLE();
249: a50 := JTF_NUMBER_TABLE();
250: a51 := JTF_NUMBER_TABLE();
251: else
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_NUMBER_TABLE();
254: a2 := JTF_VARCHAR2_TABLE_100();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
249: a50 := JTF_NUMBER_TABLE();
250: a51 := JTF_NUMBER_TABLE();
251: else
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_NUMBER_TABLE();
254: a2 := JTF_VARCHAR2_TABLE_100();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_200();
251: else
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_NUMBER_TABLE();
254: a2 := JTF_VARCHAR2_TABLE_100();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_200();
258: a6 := JTF_VARCHAR2_TABLE_2000();
259: a7 := JTF_DATE_TABLE();
257: a5 := JTF_VARCHAR2_TABLE_200();
258: a6 := JTF_VARCHAR2_TABLE_2000();
259: a7 := JTF_DATE_TABLE();
260: a8 := JTF_DATE_TABLE();
261: a9 := JTF_NUMBER_TABLE();
262: a10 := JTF_VARCHAR2_TABLE_100();
263: a11 := JTF_VARCHAR2_TABLE_100();
264: a12 := JTF_VARCHAR2_TABLE_100();
265: a13 := JTF_VARCHAR2_TABLE_100();
262: a10 := JTF_VARCHAR2_TABLE_100();
263: a11 := JTF_VARCHAR2_TABLE_100();
264: a12 := JTF_VARCHAR2_TABLE_100();
265: a13 := JTF_VARCHAR2_TABLE_100();
266: a14 := JTF_NUMBER_TABLE();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
263: a11 := JTF_VARCHAR2_TABLE_100();
264: a12 := JTF_VARCHAR2_TABLE_100();
265: a13 := JTF_VARCHAR2_TABLE_100();
266: a14 := JTF_NUMBER_TABLE();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
264: a12 := JTF_VARCHAR2_TABLE_100();
265: a13 := JTF_VARCHAR2_TABLE_100();
266: a14 := JTF_NUMBER_TABLE();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
265: a13 := JTF_VARCHAR2_TABLE_100();
266: a14 := JTF_NUMBER_TABLE();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
273: a21 := JTF_VARCHAR2_TABLE_100();
266: a14 := JTF_NUMBER_TABLE();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
273: a21 := JTF_VARCHAR2_TABLE_100();
274: a22 := JTF_VARCHAR2_TABLE_100();
267: a15 := JTF_NUMBER_TABLE();
268: a16 := JTF_NUMBER_TABLE();
269: a17 := JTF_NUMBER_TABLE();
270: a18 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
273: a21 := JTF_VARCHAR2_TABLE_100();
274: a22 := JTF_VARCHAR2_TABLE_100();
275: a23 := JTF_NUMBER_TABLE();
271: a19 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
273: a21 := JTF_VARCHAR2_TABLE_100();
274: a22 := JTF_VARCHAR2_TABLE_100();
275: a23 := JTF_NUMBER_TABLE();
276: a24 := JTF_NUMBER_TABLE();
277: a25 := JTF_VARCHAR2_TABLE_100();
278: a26 := JTF_VARCHAR2_TABLE_100();
279: a27 := JTF_NUMBER_TABLE();
272: a20 := JTF_VARCHAR2_TABLE_100();
273: a21 := JTF_VARCHAR2_TABLE_100();
274: a22 := JTF_VARCHAR2_TABLE_100();
275: a23 := JTF_NUMBER_TABLE();
276: a24 := JTF_NUMBER_TABLE();
277: a25 := JTF_VARCHAR2_TABLE_100();
278: a26 := JTF_VARCHAR2_TABLE_100();
279: a27 := JTF_NUMBER_TABLE();
280: a28 := JTF_NUMBER_TABLE();
275: a23 := JTF_NUMBER_TABLE();
276: a24 := JTF_NUMBER_TABLE();
277: a25 := JTF_VARCHAR2_TABLE_100();
278: a26 := JTF_VARCHAR2_TABLE_100();
279: a27 := JTF_NUMBER_TABLE();
280: a28 := JTF_NUMBER_TABLE();
281: a29 := JTF_VARCHAR2_TABLE_100();
282: a30 := JTF_VARCHAR2_TABLE_100();
283: a31 := JTF_VARCHAR2_TABLE_500();
276: a24 := JTF_NUMBER_TABLE();
277: a25 := JTF_VARCHAR2_TABLE_100();
278: a26 := JTF_VARCHAR2_TABLE_100();
279: a27 := JTF_NUMBER_TABLE();
280: a28 := JTF_NUMBER_TABLE();
281: a29 := JTF_VARCHAR2_TABLE_100();
282: a30 := JTF_VARCHAR2_TABLE_100();
283: a31 := JTF_VARCHAR2_TABLE_500();
284: a32 := JTF_VARCHAR2_TABLE_500();
294: a42 := JTF_VARCHAR2_TABLE_500();
295: a43 := JTF_VARCHAR2_TABLE_100();
296: a44 := JTF_VARCHAR2_TABLE_500();
297: a45 := JTF_VARCHAR2_TABLE_500();
298: a46 := JTF_NUMBER_TABLE();
299: a47 := JTF_DATE_TABLE();
300: a48 := JTF_NUMBER_TABLE();
301: a49 := JTF_DATE_TABLE();
302: a50 := JTF_NUMBER_TABLE();
296: a44 := JTF_VARCHAR2_TABLE_500();
297: a45 := JTF_VARCHAR2_TABLE_500();
298: a46 := JTF_NUMBER_TABLE();
299: a47 := JTF_DATE_TABLE();
300: a48 := JTF_NUMBER_TABLE();
301: a49 := JTF_DATE_TABLE();
302: a50 := JTF_NUMBER_TABLE();
303: a51 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
298: a46 := JTF_NUMBER_TABLE();
299: a47 := JTF_DATE_TABLE();
300: a48 := JTF_NUMBER_TABLE();
301: a49 := JTF_DATE_TABLE();
302: a50 := JTF_NUMBER_TABLE();
303: a51 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
305: a0.extend(t.count);
306: a1.extend(t.count);
299: a47 := JTF_DATE_TABLE();
300: a48 := JTF_NUMBER_TABLE();
301: a49 := JTF_DATE_TABLE();
302: a50 := JTF_NUMBER_TABLE();
303: a51 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
305: a0.extend(t.count);
306: a1.extend(t.count);
307: a2.extend(t.count);
418: end if;
419: end if;
420: end rosetta_table_copy_out_p2;
421:
422: procedure rosetta_table_copy_in_p5(t out nocopy okl_sub_pvt.subt_tbl_type, a0 JTF_NUMBER_TABLE
423: , a1 JTF_VARCHAR2_TABLE_200
424: , a2 JTF_VARCHAR2_TABLE_2000
425: , a3 JTF_VARCHAR2_TABLE_100
426: , a4 JTF_VARCHAR2_TABLE_100
424: , a2 JTF_VARCHAR2_TABLE_2000
425: , a3 JTF_VARCHAR2_TABLE_100
426: , a4 JTF_VARCHAR2_TABLE_100
427: , a5 JTF_VARCHAR2_TABLE_100
428: , a6 JTF_NUMBER_TABLE
429: , a7 JTF_DATE_TABLE
430: , a8 JTF_NUMBER_TABLE
431: , a9 JTF_DATE_TABLE
432: , a10 JTF_NUMBER_TABLE
426: , a4 JTF_VARCHAR2_TABLE_100
427: , a5 JTF_VARCHAR2_TABLE_100
428: , a6 JTF_NUMBER_TABLE
429: , a7 JTF_DATE_TABLE
430: , a8 JTF_NUMBER_TABLE
431: , a9 JTF_DATE_TABLE
432: , a10 JTF_NUMBER_TABLE
433: ) as
434: ddindx binary_integer; indx binary_integer;
428: , a6 JTF_NUMBER_TABLE
429: , a7 JTF_DATE_TABLE
430: , a8 JTF_NUMBER_TABLE
431: , a9 JTF_DATE_TABLE
432: , a10 JTF_NUMBER_TABLE
433: ) as
434: ddindx binary_integer; indx binary_integer;
435: begin
436: if a0 is not null and a0.count > 0 then
457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p5;
461: procedure rosetta_table_copy_out_p5(t okl_sub_pvt.subt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_VARCHAR2_TABLE_200
463: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_VARCHAR2_TABLE_100
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_NUMBER_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_NUMBER_TABLE
470: , a9 out nocopy JTF_DATE_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
465: , a4 out nocopy JTF_VARCHAR2_TABLE_100
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_NUMBER_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_NUMBER_TABLE
470: , a9 out nocopy JTF_DATE_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: ) as
473: ddindx binary_integer; indx binary_integer;
467: , a6 out nocopy JTF_NUMBER_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_NUMBER_TABLE
470: , a9 out nocopy JTF_DATE_TABLE
471: , a10 out nocopy JTF_NUMBER_TABLE
472: ) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if t is null or t.count = 0 then
472: ) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if t is null or t.count = 0 then
476: a0 := JTF_NUMBER_TABLE();
477: a1 := JTF_VARCHAR2_TABLE_200();
478: a2 := JTF_VARCHAR2_TABLE_2000();
479: a3 := JTF_VARCHAR2_TABLE_100();
480: a4 := JTF_VARCHAR2_TABLE_100();
478: a2 := JTF_VARCHAR2_TABLE_2000();
479: a3 := JTF_VARCHAR2_TABLE_100();
480: a4 := JTF_VARCHAR2_TABLE_100();
481: a5 := JTF_VARCHAR2_TABLE_100();
482: a6 := JTF_NUMBER_TABLE();
483: a7 := JTF_DATE_TABLE();
484: a8 := JTF_NUMBER_TABLE();
485: a9 := JTF_DATE_TABLE();
486: a10 := JTF_NUMBER_TABLE();
480: a4 := JTF_VARCHAR2_TABLE_100();
481: a5 := JTF_VARCHAR2_TABLE_100();
482: a6 := JTF_NUMBER_TABLE();
483: a7 := JTF_DATE_TABLE();
484: a8 := JTF_NUMBER_TABLE();
485: a9 := JTF_DATE_TABLE();
486: a10 := JTF_NUMBER_TABLE();
487: else
488: a0 := JTF_NUMBER_TABLE();
482: a6 := JTF_NUMBER_TABLE();
483: a7 := JTF_DATE_TABLE();
484: a8 := JTF_NUMBER_TABLE();
485: a9 := JTF_DATE_TABLE();
486: a10 := JTF_NUMBER_TABLE();
487: else
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_VARCHAR2_TABLE_200();
490: a2 := JTF_VARCHAR2_TABLE_2000();
484: a8 := JTF_NUMBER_TABLE();
485: a9 := JTF_DATE_TABLE();
486: a10 := JTF_NUMBER_TABLE();
487: else
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_VARCHAR2_TABLE_200();
490: a2 := JTF_VARCHAR2_TABLE_2000();
491: a3 := JTF_VARCHAR2_TABLE_100();
492: a4 := JTF_VARCHAR2_TABLE_100();
490: a2 := JTF_VARCHAR2_TABLE_2000();
491: a3 := JTF_VARCHAR2_TABLE_100();
492: a4 := JTF_VARCHAR2_TABLE_100();
493: a5 := JTF_VARCHAR2_TABLE_100();
494: a6 := JTF_NUMBER_TABLE();
495: a7 := JTF_DATE_TABLE();
496: a8 := JTF_NUMBER_TABLE();
497: a9 := JTF_DATE_TABLE();
498: a10 := JTF_NUMBER_TABLE();
492: a4 := JTF_VARCHAR2_TABLE_100();
493: a5 := JTF_VARCHAR2_TABLE_100();
494: a6 := JTF_NUMBER_TABLE();
495: a7 := JTF_DATE_TABLE();
496: a8 := JTF_NUMBER_TABLE();
497: a9 := JTF_DATE_TABLE();
498: a10 := JTF_NUMBER_TABLE();
499: if t.count > 0 then
500: a0.extend(t.count);
494: a6 := JTF_NUMBER_TABLE();
495: a7 := JTF_DATE_TABLE();
496: a8 := JTF_NUMBER_TABLE();
497: a9 := JTF_DATE_TABLE();
498: a10 := JTF_NUMBER_TABLE();
499: if t.count > 0 then
500: a0.extend(t.count);
501: a1.extend(t.count);
502: a2.extend(t.count);
531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p8(t out nocopy okl_sub_pvt.subb_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_DATE_TABLE
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p8(t out nocopy okl_sub_pvt.subb_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_DATE_TABLE
540: , a5 JTF_DATE_TABLE
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p8(t out nocopy okl_sub_pvt.subb_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_DATE_TABLE
540: , a5 JTF_DATE_TABLE
541: , a6 JTF_NUMBER_TABLE
537: , a2 JTF_NUMBER_TABLE
538: , a3 JTF_VARCHAR2_TABLE_100
539: , a4 JTF_DATE_TABLE
540: , a5 JTF_DATE_TABLE
541: , a6 JTF_NUMBER_TABLE
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_100
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_100
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
543: , a8 JTF_VARCHAR2_TABLE_100
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
553: , a18 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
553: , a18 JTF_VARCHAR2_TABLE_100
554: , a19 JTF_VARCHAR2_TABLE_100
547: , a12 JTF_NUMBER_TABLE
548: , a13 JTF_NUMBER_TABLE
549: , a14 JTF_NUMBER_TABLE
550: , a15 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
553: , a18 JTF_VARCHAR2_TABLE_100
554: , a19 JTF_VARCHAR2_TABLE_100
555: , a20 JTF_NUMBER_TABLE
551: , a16 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
553: , a18 JTF_VARCHAR2_TABLE_100
554: , a19 JTF_VARCHAR2_TABLE_100
555: , a20 JTF_NUMBER_TABLE
556: , a21 JTF_NUMBER_TABLE
557: , a22 JTF_VARCHAR2_TABLE_100
558: , a23 JTF_VARCHAR2_TABLE_100
559: , a24 JTF_NUMBER_TABLE
552: , a17 JTF_VARCHAR2_TABLE_100
553: , a18 JTF_VARCHAR2_TABLE_100
554: , a19 JTF_VARCHAR2_TABLE_100
555: , a20 JTF_NUMBER_TABLE
556: , a21 JTF_NUMBER_TABLE
557: , a22 JTF_VARCHAR2_TABLE_100
558: , a23 JTF_VARCHAR2_TABLE_100
559: , a24 JTF_NUMBER_TABLE
560: , a25 JTF_NUMBER_TABLE
555: , a20 JTF_NUMBER_TABLE
556: , a21 JTF_NUMBER_TABLE
557: , a22 JTF_VARCHAR2_TABLE_100
558: , a23 JTF_VARCHAR2_TABLE_100
559: , a24 JTF_NUMBER_TABLE
560: , a25 JTF_NUMBER_TABLE
561: , a26 JTF_VARCHAR2_TABLE_100
562: , a27 JTF_VARCHAR2_TABLE_100
563: , a28 JTF_VARCHAR2_TABLE_500
556: , a21 JTF_NUMBER_TABLE
557: , a22 JTF_VARCHAR2_TABLE_100
558: , a23 JTF_VARCHAR2_TABLE_100
559: , a24 JTF_NUMBER_TABLE
560: , a25 JTF_NUMBER_TABLE
561: , a26 JTF_VARCHAR2_TABLE_100
562: , a27 JTF_VARCHAR2_TABLE_100
563: , a28 JTF_VARCHAR2_TABLE_500
564: , a29 JTF_VARCHAR2_TABLE_500
574: , a39 JTF_VARCHAR2_TABLE_500
575: , a40 JTF_VARCHAR2_TABLE_100
576: , a41 JTF_VARCHAR2_TABLE_500
577: , a42 JTF_VARCHAR2_TABLE_500
578: , a43 JTF_NUMBER_TABLE
579: , a44 JTF_DATE_TABLE
580: , a45 JTF_NUMBER_TABLE
581: , a46 JTF_DATE_TABLE
582: , a47 JTF_NUMBER_TABLE
576: , a41 JTF_VARCHAR2_TABLE_500
577: , a42 JTF_VARCHAR2_TABLE_500
578: , a43 JTF_NUMBER_TABLE
579: , a44 JTF_DATE_TABLE
580: , a45 JTF_NUMBER_TABLE
581: , a46 JTF_DATE_TABLE
582: , a47 JTF_NUMBER_TABLE
583: , a48 JTF_NUMBER_TABLE
584: ) as
578: , a43 JTF_NUMBER_TABLE
579: , a44 JTF_DATE_TABLE
580: , a45 JTF_NUMBER_TABLE
581: , a46 JTF_DATE_TABLE
582: , a47 JTF_NUMBER_TABLE
583: , a48 JTF_NUMBER_TABLE
584: ) as
585: ddindx binary_integer; indx binary_integer;
586: begin
579: , a44 JTF_DATE_TABLE
580: , a45 JTF_NUMBER_TABLE
581: , a46 JTF_DATE_TABLE
582: , a47 JTF_NUMBER_TABLE
583: , a48 JTF_NUMBER_TABLE
584: ) as
585: ddindx binary_integer; indx binary_integer;
586: begin
587: if a0 is not null and a0.count > 0 then
646: end loop;
647: end if;
648: end if;
649: end rosetta_table_copy_in_p8;
650: procedure rosetta_table_copy_out_p8(t okl_sub_pvt.subb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
651: , a1 out nocopy JTF_NUMBER_TABLE
652: , a2 out nocopy JTF_NUMBER_TABLE
653: , a3 out nocopy JTF_VARCHAR2_TABLE_100
654: , a4 out nocopy JTF_DATE_TABLE
647: end if;
648: end if;
649: end rosetta_table_copy_in_p8;
650: procedure rosetta_table_copy_out_p8(t okl_sub_pvt.subb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
651: , a1 out nocopy JTF_NUMBER_TABLE
652: , a2 out nocopy JTF_NUMBER_TABLE
653: , a3 out nocopy JTF_VARCHAR2_TABLE_100
654: , a4 out nocopy JTF_DATE_TABLE
655: , a5 out nocopy JTF_DATE_TABLE
648: end if;
649: end rosetta_table_copy_in_p8;
650: procedure rosetta_table_copy_out_p8(t okl_sub_pvt.subb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
651: , a1 out nocopy JTF_NUMBER_TABLE
652: , a2 out nocopy JTF_NUMBER_TABLE
653: , a3 out nocopy JTF_VARCHAR2_TABLE_100
654: , a4 out nocopy JTF_DATE_TABLE
655: , a5 out nocopy JTF_DATE_TABLE
656: , a6 out nocopy JTF_NUMBER_TABLE
652: , a2 out nocopy JTF_NUMBER_TABLE
653: , a3 out nocopy JTF_VARCHAR2_TABLE_100
654: , a4 out nocopy JTF_DATE_TABLE
655: , a5 out nocopy JTF_DATE_TABLE
656: , a6 out nocopy JTF_NUMBER_TABLE
657: , a7 out nocopy JTF_VARCHAR2_TABLE_100
658: , a8 out nocopy JTF_VARCHAR2_TABLE_100
659: , a9 out nocopy JTF_VARCHAR2_TABLE_100
660: , a10 out nocopy JTF_VARCHAR2_TABLE_100
657: , a7 out nocopy JTF_VARCHAR2_TABLE_100
658: , a8 out nocopy JTF_VARCHAR2_TABLE_100
659: , a9 out nocopy JTF_VARCHAR2_TABLE_100
660: , a10 out nocopy JTF_VARCHAR2_TABLE_100
661: , a11 out nocopy JTF_NUMBER_TABLE
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
658: , a8 out nocopy JTF_VARCHAR2_TABLE_100
659: , a9 out nocopy JTF_VARCHAR2_TABLE_100
660: , a10 out nocopy JTF_VARCHAR2_TABLE_100
661: , a11 out nocopy JTF_NUMBER_TABLE
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
659: , a9 out nocopy JTF_VARCHAR2_TABLE_100
660: , a10 out nocopy JTF_VARCHAR2_TABLE_100
661: , a11 out nocopy JTF_NUMBER_TABLE
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
660: , a10 out nocopy JTF_VARCHAR2_TABLE_100
661: , a11 out nocopy JTF_NUMBER_TABLE
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
668: , a18 out nocopy JTF_VARCHAR2_TABLE_100
661: , a11 out nocopy JTF_NUMBER_TABLE
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
668: , a18 out nocopy JTF_VARCHAR2_TABLE_100
669: , a19 out nocopy JTF_VARCHAR2_TABLE_100
662: , a12 out nocopy JTF_NUMBER_TABLE
663: , a13 out nocopy JTF_NUMBER_TABLE
664: , a14 out nocopy JTF_NUMBER_TABLE
665: , a15 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
668: , a18 out nocopy JTF_VARCHAR2_TABLE_100
669: , a19 out nocopy JTF_VARCHAR2_TABLE_100
670: , a20 out nocopy JTF_NUMBER_TABLE
666: , a16 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
668: , a18 out nocopy JTF_VARCHAR2_TABLE_100
669: , a19 out nocopy JTF_VARCHAR2_TABLE_100
670: , a20 out nocopy JTF_NUMBER_TABLE
671: , a21 out nocopy JTF_NUMBER_TABLE
672: , a22 out nocopy JTF_VARCHAR2_TABLE_100
673: , a23 out nocopy JTF_VARCHAR2_TABLE_100
674: , a24 out nocopy JTF_NUMBER_TABLE
667: , a17 out nocopy JTF_VARCHAR2_TABLE_100
668: , a18 out nocopy JTF_VARCHAR2_TABLE_100
669: , a19 out nocopy JTF_VARCHAR2_TABLE_100
670: , a20 out nocopy JTF_NUMBER_TABLE
671: , a21 out nocopy JTF_NUMBER_TABLE
672: , a22 out nocopy JTF_VARCHAR2_TABLE_100
673: , a23 out nocopy JTF_VARCHAR2_TABLE_100
674: , a24 out nocopy JTF_NUMBER_TABLE
675: , a25 out nocopy JTF_NUMBER_TABLE
670: , a20 out nocopy JTF_NUMBER_TABLE
671: , a21 out nocopy JTF_NUMBER_TABLE
672: , a22 out nocopy JTF_VARCHAR2_TABLE_100
673: , a23 out nocopy JTF_VARCHAR2_TABLE_100
674: , a24 out nocopy JTF_NUMBER_TABLE
675: , a25 out nocopy JTF_NUMBER_TABLE
676: , a26 out nocopy JTF_VARCHAR2_TABLE_100
677: , a27 out nocopy JTF_VARCHAR2_TABLE_100
678: , a28 out nocopy JTF_VARCHAR2_TABLE_500
671: , a21 out nocopy JTF_NUMBER_TABLE
672: , a22 out nocopy JTF_VARCHAR2_TABLE_100
673: , a23 out nocopy JTF_VARCHAR2_TABLE_100
674: , a24 out nocopy JTF_NUMBER_TABLE
675: , a25 out nocopy JTF_NUMBER_TABLE
676: , a26 out nocopy JTF_VARCHAR2_TABLE_100
677: , a27 out nocopy JTF_VARCHAR2_TABLE_100
678: , a28 out nocopy JTF_VARCHAR2_TABLE_500
679: , a29 out nocopy JTF_VARCHAR2_TABLE_500
689: , a39 out nocopy JTF_VARCHAR2_TABLE_500
690: , a40 out nocopy JTF_VARCHAR2_TABLE_100
691: , a41 out nocopy JTF_VARCHAR2_TABLE_500
692: , a42 out nocopy JTF_VARCHAR2_TABLE_500
693: , a43 out nocopy JTF_NUMBER_TABLE
694: , a44 out nocopy JTF_DATE_TABLE
695: , a45 out nocopy JTF_NUMBER_TABLE
696: , a46 out nocopy JTF_DATE_TABLE
697: , a47 out nocopy JTF_NUMBER_TABLE
691: , a41 out nocopy JTF_VARCHAR2_TABLE_500
692: , a42 out nocopy JTF_VARCHAR2_TABLE_500
693: , a43 out nocopy JTF_NUMBER_TABLE
694: , a44 out nocopy JTF_DATE_TABLE
695: , a45 out nocopy JTF_NUMBER_TABLE
696: , a46 out nocopy JTF_DATE_TABLE
697: , a47 out nocopy JTF_NUMBER_TABLE
698: , a48 out nocopy JTF_NUMBER_TABLE
699: ) as
693: , a43 out nocopy JTF_NUMBER_TABLE
694: , a44 out nocopy JTF_DATE_TABLE
695: , a45 out nocopy JTF_NUMBER_TABLE
696: , a46 out nocopy JTF_DATE_TABLE
697: , a47 out nocopy JTF_NUMBER_TABLE
698: , a48 out nocopy JTF_NUMBER_TABLE
699: ) as
700: ddindx binary_integer; indx binary_integer;
701: begin
694: , a44 out nocopy JTF_DATE_TABLE
695: , a45 out nocopy JTF_NUMBER_TABLE
696: , a46 out nocopy JTF_DATE_TABLE
697: , a47 out nocopy JTF_NUMBER_TABLE
698: , a48 out nocopy JTF_NUMBER_TABLE
699: ) as
700: ddindx binary_integer; indx binary_integer;
701: begin
702: if t is null or t.count = 0 then
699: ) as
700: ddindx binary_integer; indx binary_integer;
701: begin
702: if t is null or t.count = 0 then
703: a0 := JTF_NUMBER_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_VARCHAR2_TABLE_100();
707: a4 := JTF_DATE_TABLE();
700: ddindx binary_integer; indx binary_integer;
701: begin
702: if t is null or t.count = 0 then
703: a0 := JTF_NUMBER_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_VARCHAR2_TABLE_100();
707: a4 := JTF_DATE_TABLE();
708: a5 := JTF_DATE_TABLE();
701: begin
702: if t is null or t.count = 0 then
703: a0 := JTF_NUMBER_TABLE();
704: a1 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_VARCHAR2_TABLE_100();
707: a4 := JTF_DATE_TABLE();
708: a5 := JTF_DATE_TABLE();
709: a6 := JTF_NUMBER_TABLE();
705: a2 := JTF_NUMBER_TABLE();
706: a3 := JTF_VARCHAR2_TABLE_100();
707: a4 := JTF_DATE_TABLE();
708: a5 := JTF_DATE_TABLE();
709: a6 := JTF_NUMBER_TABLE();
710: a7 := JTF_VARCHAR2_TABLE_100();
711: a8 := JTF_VARCHAR2_TABLE_100();
712: a9 := JTF_VARCHAR2_TABLE_100();
713: a10 := JTF_VARCHAR2_TABLE_100();
710: a7 := JTF_VARCHAR2_TABLE_100();
711: a8 := JTF_VARCHAR2_TABLE_100();
712: a9 := JTF_VARCHAR2_TABLE_100();
713: a10 := JTF_VARCHAR2_TABLE_100();
714: a11 := JTF_NUMBER_TABLE();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
711: a8 := JTF_VARCHAR2_TABLE_100();
712: a9 := JTF_VARCHAR2_TABLE_100();
713: a10 := JTF_VARCHAR2_TABLE_100();
714: a11 := JTF_NUMBER_TABLE();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
712: a9 := JTF_VARCHAR2_TABLE_100();
713: a10 := JTF_VARCHAR2_TABLE_100();
714: a11 := JTF_NUMBER_TABLE();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
713: a10 := JTF_VARCHAR2_TABLE_100();
714: a11 := JTF_NUMBER_TABLE();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
721: a18 := JTF_VARCHAR2_TABLE_100();
714: a11 := JTF_NUMBER_TABLE();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
721: a18 := JTF_VARCHAR2_TABLE_100();
722: a19 := JTF_VARCHAR2_TABLE_100();
715: a12 := JTF_NUMBER_TABLE();
716: a13 := JTF_NUMBER_TABLE();
717: a14 := JTF_NUMBER_TABLE();
718: a15 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
721: a18 := JTF_VARCHAR2_TABLE_100();
722: a19 := JTF_VARCHAR2_TABLE_100();
723: a20 := JTF_NUMBER_TABLE();
719: a16 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
721: a18 := JTF_VARCHAR2_TABLE_100();
722: a19 := JTF_VARCHAR2_TABLE_100();
723: a20 := JTF_NUMBER_TABLE();
724: a21 := JTF_NUMBER_TABLE();
725: a22 := JTF_VARCHAR2_TABLE_100();
726: a23 := JTF_VARCHAR2_TABLE_100();
727: a24 := JTF_NUMBER_TABLE();
720: a17 := JTF_VARCHAR2_TABLE_100();
721: a18 := JTF_VARCHAR2_TABLE_100();
722: a19 := JTF_VARCHAR2_TABLE_100();
723: a20 := JTF_NUMBER_TABLE();
724: a21 := JTF_NUMBER_TABLE();
725: a22 := JTF_VARCHAR2_TABLE_100();
726: a23 := JTF_VARCHAR2_TABLE_100();
727: a24 := JTF_NUMBER_TABLE();
728: a25 := JTF_NUMBER_TABLE();
723: a20 := JTF_NUMBER_TABLE();
724: a21 := JTF_NUMBER_TABLE();
725: a22 := JTF_VARCHAR2_TABLE_100();
726: a23 := JTF_VARCHAR2_TABLE_100();
727: a24 := JTF_NUMBER_TABLE();
728: a25 := JTF_NUMBER_TABLE();
729: a26 := JTF_VARCHAR2_TABLE_100();
730: a27 := JTF_VARCHAR2_TABLE_100();
731: a28 := JTF_VARCHAR2_TABLE_500();
724: a21 := JTF_NUMBER_TABLE();
725: a22 := JTF_VARCHAR2_TABLE_100();
726: a23 := JTF_VARCHAR2_TABLE_100();
727: a24 := JTF_NUMBER_TABLE();
728: a25 := JTF_NUMBER_TABLE();
729: a26 := JTF_VARCHAR2_TABLE_100();
730: a27 := JTF_VARCHAR2_TABLE_100();
731: a28 := JTF_VARCHAR2_TABLE_500();
732: a29 := JTF_VARCHAR2_TABLE_500();
742: a39 := JTF_VARCHAR2_TABLE_500();
743: a40 := JTF_VARCHAR2_TABLE_100();
744: a41 := JTF_VARCHAR2_TABLE_500();
745: a42 := JTF_VARCHAR2_TABLE_500();
746: a43 := JTF_NUMBER_TABLE();
747: a44 := JTF_DATE_TABLE();
748: a45 := JTF_NUMBER_TABLE();
749: a46 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
744: a41 := JTF_VARCHAR2_TABLE_500();
745: a42 := JTF_VARCHAR2_TABLE_500();
746: a43 := JTF_NUMBER_TABLE();
747: a44 := JTF_DATE_TABLE();
748: a45 := JTF_NUMBER_TABLE();
749: a46 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
746: a43 := JTF_NUMBER_TABLE();
747: a44 := JTF_DATE_TABLE();
748: a45 := JTF_NUMBER_TABLE();
749: a46 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
753: a0 := JTF_NUMBER_TABLE();
754: a1 := JTF_NUMBER_TABLE();
747: a44 := JTF_DATE_TABLE();
748: a45 := JTF_NUMBER_TABLE();
749: a46 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
753: a0 := JTF_NUMBER_TABLE();
754: a1 := JTF_NUMBER_TABLE();
755: a2 := JTF_NUMBER_TABLE();
749: a46 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
753: a0 := JTF_NUMBER_TABLE();
754: a1 := JTF_NUMBER_TABLE();
755: a2 := JTF_NUMBER_TABLE();
756: a3 := JTF_VARCHAR2_TABLE_100();
757: a4 := JTF_DATE_TABLE();
750: a47 := JTF_NUMBER_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
753: a0 := JTF_NUMBER_TABLE();
754: a1 := JTF_NUMBER_TABLE();
755: a2 := JTF_NUMBER_TABLE();
756: a3 := JTF_VARCHAR2_TABLE_100();
757: a4 := JTF_DATE_TABLE();
758: a5 := JTF_DATE_TABLE();
751: a48 := JTF_NUMBER_TABLE();
752: else
753: a0 := JTF_NUMBER_TABLE();
754: a1 := JTF_NUMBER_TABLE();
755: a2 := JTF_NUMBER_TABLE();
756: a3 := JTF_VARCHAR2_TABLE_100();
757: a4 := JTF_DATE_TABLE();
758: a5 := JTF_DATE_TABLE();
759: a6 := JTF_NUMBER_TABLE();
755: a2 := JTF_NUMBER_TABLE();
756: a3 := JTF_VARCHAR2_TABLE_100();
757: a4 := JTF_DATE_TABLE();
758: a5 := JTF_DATE_TABLE();
759: a6 := JTF_NUMBER_TABLE();
760: a7 := JTF_VARCHAR2_TABLE_100();
761: a8 := JTF_VARCHAR2_TABLE_100();
762: a9 := JTF_VARCHAR2_TABLE_100();
763: a10 := JTF_VARCHAR2_TABLE_100();
760: a7 := JTF_VARCHAR2_TABLE_100();
761: a8 := JTF_VARCHAR2_TABLE_100();
762: a9 := JTF_VARCHAR2_TABLE_100();
763: a10 := JTF_VARCHAR2_TABLE_100();
764: a11 := JTF_NUMBER_TABLE();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
761: a8 := JTF_VARCHAR2_TABLE_100();
762: a9 := JTF_VARCHAR2_TABLE_100();
763: a10 := JTF_VARCHAR2_TABLE_100();
764: a11 := JTF_NUMBER_TABLE();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
762: a9 := JTF_VARCHAR2_TABLE_100();
763: a10 := JTF_VARCHAR2_TABLE_100();
764: a11 := JTF_NUMBER_TABLE();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
763: a10 := JTF_VARCHAR2_TABLE_100();
764: a11 := JTF_NUMBER_TABLE();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
771: a18 := JTF_VARCHAR2_TABLE_100();
764: a11 := JTF_NUMBER_TABLE();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
771: a18 := JTF_VARCHAR2_TABLE_100();
772: a19 := JTF_VARCHAR2_TABLE_100();
765: a12 := JTF_NUMBER_TABLE();
766: a13 := JTF_NUMBER_TABLE();
767: a14 := JTF_NUMBER_TABLE();
768: a15 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
771: a18 := JTF_VARCHAR2_TABLE_100();
772: a19 := JTF_VARCHAR2_TABLE_100();
773: a20 := JTF_NUMBER_TABLE();
769: a16 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
771: a18 := JTF_VARCHAR2_TABLE_100();
772: a19 := JTF_VARCHAR2_TABLE_100();
773: a20 := JTF_NUMBER_TABLE();
774: a21 := JTF_NUMBER_TABLE();
775: a22 := JTF_VARCHAR2_TABLE_100();
776: a23 := JTF_VARCHAR2_TABLE_100();
777: a24 := JTF_NUMBER_TABLE();
770: a17 := JTF_VARCHAR2_TABLE_100();
771: a18 := JTF_VARCHAR2_TABLE_100();
772: a19 := JTF_VARCHAR2_TABLE_100();
773: a20 := JTF_NUMBER_TABLE();
774: a21 := JTF_NUMBER_TABLE();
775: a22 := JTF_VARCHAR2_TABLE_100();
776: a23 := JTF_VARCHAR2_TABLE_100();
777: a24 := JTF_NUMBER_TABLE();
778: a25 := JTF_NUMBER_TABLE();
773: a20 := JTF_NUMBER_TABLE();
774: a21 := JTF_NUMBER_TABLE();
775: a22 := JTF_VARCHAR2_TABLE_100();
776: a23 := JTF_VARCHAR2_TABLE_100();
777: a24 := JTF_NUMBER_TABLE();
778: a25 := JTF_NUMBER_TABLE();
779: a26 := JTF_VARCHAR2_TABLE_100();
780: a27 := JTF_VARCHAR2_TABLE_100();
781: a28 := JTF_VARCHAR2_TABLE_500();
774: a21 := JTF_NUMBER_TABLE();
775: a22 := JTF_VARCHAR2_TABLE_100();
776: a23 := JTF_VARCHAR2_TABLE_100();
777: a24 := JTF_NUMBER_TABLE();
778: a25 := JTF_NUMBER_TABLE();
779: a26 := JTF_VARCHAR2_TABLE_100();
780: a27 := JTF_VARCHAR2_TABLE_100();
781: a28 := JTF_VARCHAR2_TABLE_500();
782: a29 := JTF_VARCHAR2_TABLE_500();
792: a39 := JTF_VARCHAR2_TABLE_500();
793: a40 := JTF_VARCHAR2_TABLE_100();
794: a41 := JTF_VARCHAR2_TABLE_500();
795: a42 := JTF_VARCHAR2_TABLE_500();
796: a43 := JTF_NUMBER_TABLE();
797: a44 := JTF_DATE_TABLE();
798: a45 := JTF_NUMBER_TABLE();
799: a46 := JTF_DATE_TABLE();
800: a47 := JTF_NUMBER_TABLE();
794: a41 := JTF_VARCHAR2_TABLE_500();
795: a42 := JTF_VARCHAR2_TABLE_500();
796: a43 := JTF_NUMBER_TABLE();
797: a44 := JTF_DATE_TABLE();
798: a45 := JTF_NUMBER_TABLE();
799: a46 := JTF_DATE_TABLE();
800: a47 := JTF_NUMBER_TABLE();
801: a48 := JTF_NUMBER_TABLE();
802: if t.count > 0 then
796: a43 := JTF_NUMBER_TABLE();
797: a44 := JTF_DATE_TABLE();
798: a45 := JTF_NUMBER_TABLE();
799: a46 := JTF_DATE_TABLE();
800: a47 := JTF_NUMBER_TABLE();
801: a48 := JTF_NUMBER_TABLE();
802: if t.count > 0 then
803: a0.extend(t.count);
804: a1.extend(t.count);
797: a44 := JTF_DATE_TABLE();
798: a45 := JTF_NUMBER_TABLE();
799: a46 := JTF_DATE_TABLE();
800: a47 := JTF_NUMBER_TABLE();
801: a48 := JTF_NUMBER_TABLE();
802: if t.count > 0 then
803: a0.extend(t.count);
804: a1.extend(t.count);
805: a2.extend(t.count);
1162: , p_init_msg_list VARCHAR2
1163: , x_return_status out nocopy VARCHAR2
1164: , x_msg_count out nocopy NUMBER
1165: , x_msg_data out nocopy VARCHAR2
1166: , p5_a0 JTF_NUMBER_TABLE
1167: , p5_a1 JTF_NUMBER_TABLE
1168: , p5_a2 JTF_VARCHAR2_TABLE_100
1169: , p5_a3 JTF_NUMBER_TABLE
1170: , p5_a4 JTF_VARCHAR2_TABLE_100
1163: , x_return_status out nocopy VARCHAR2
1164: , x_msg_count out nocopy NUMBER
1165: , x_msg_data out nocopy VARCHAR2
1166: , p5_a0 JTF_NUMBER_TABLE
1167: , p5_a1 JTF_NUMBER_TABLE
1168: , p5_a2 JTF_VARCHAR2_TABLE_100
1169: , p5_a3 JTF_NUMBER_TABLE
1170: , p5_a4 JTF_VARCHAR2_TABLE_100
1171: , p5_a5 JTF_VARCHAR2_TABLE_200
1165: , x_msg_data out nocopy VARCHAR2
1166: , p5_a0 JTF_NUMBER_TABLE
1167: , p5_a1 JTF_NUMBER_TABLE
1168: , p5_a2 JTF_VARCHAR2_TABLE_100
1169: , p5_a3 JTF_NUMBER_TABLE
1170: , p5_a4 JTF_VARCHAR2_TABLE_100
1171: , p5_a5 JTF_VARCHAR2_TABLE_200
1172: , p5_a6 JTF_VARCHAR2_TABLE_2000
1173: , p5_a7 JTF_DATE_TABLE
1171: , p5_a5 JTF_VARCHAR2_TABLE_200
1172: , p5_a6 JTF_VARCHAR2_TABLE_2000
1173: , p5_a7 JTF_DATE_TABLE
1174: , p5_a8 JTF_DATE_TABLE
1175: , p5_a9 JTF_NUMBER_TABLE
1176: , p5_a10 JTF_VARCHAR2_TABLE_100
1177: , p5_a11 JTF_VARCHAR2_TABLE_100
1178: , p5_a12 JTF_VARCHAR2_TABLE_100
1179: , p5_a13 JTF_VARCHAR2_TABLE_100
1176: , p5_a10 JTF_VARCHAR2_TABLE_100
1177: , p5_a11 JTF_VARCHAR2_TABLE_100
1178: , p5_a12 JTF_VARCHAR2_TABLE_100
1179: , p5_a13 JTF_VARCHAR2_TABLE_100
1180: , p5_a14 JTF_NUMBER_TABLE
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1177: , p5_a11 JTF_VARCHAR2_TABLE_100
1178: , p5_a12 JTF_VARCHAR2_TABLE_100
1179: , p5_a13 JTF_VARCHAR2_TABLE_100
1180: , p5_a14 JTF_NUMBER_TABLE
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1178: , p5_a12 JTF_VARCHAR2_TABLE_100
1179: , p5_a13 JTF_VARCHAR2_TABLE_100
1180: , p5_a14 JTF_NUMBER_TABLE
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1179: , p5_a13 JTF_VARCHAR2_TABLE_100
1180: , p5_a14 JTF_NUMBER_TABLE
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1187: , p5_a21 JTF_VARCHAR2_TABLE_100
1180: , p5_a14 JTF_NUMBER_TABLE
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1187: , p5_a21 JTF_VARCHAR2_TABLE_100
1188: , p5_a22 JTF_VARCHAR2_TABLE_100
1181: , p5_a15 JTF_NUMBER_TABLE
1182: , p5_a16 JTF_NUMBER_TABLE
1183: , p5_a17 JTF_NUMBER_TABLE
1184: , p5_a18 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1187: , p5_a21 JTF_VARCHAR2_TABLE_100
1188: , p5_a22 JTF_VARCHAR2_TABLE_100
1189: , p5_a23 JTF_NUMBER_TABLE
1185: , p5_a19 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1187: , p5_a21 JTF_VARCHAR2_TABLE_100
1188: , p5_a22 JTF_VARCHAR2_TABLE_100
1189: , p5_a23 JTF_NUMBER_TABLE
1190: , p5_a24 JTF_NUMBER_TABLE
1191: , p5_a25 JTF_VARCHAR2_TABLE_100
1192: , p5_a26 JTF_VARCHAR2_TABLE_100
1193: , p5_a27 JTF_NUMBER_TABLE
1186: , p5_a20 JTF_VARCHAR2_TABLE_100
1187: , p5_a21 JTF_VARCHAR2_TABLE_100
1188: , p5_a22 JTF_VARCHAR2_TABLE_100
1189: , p5_a23 JTF_NUMBER_TABLE
1190: , p5_a24 JTF_NUMBER_TABLE
1191: , p5_a25 JTF_VARCHAR2_TABLE_100
1192: , p5_a26 JTF_VARCHAR2_TABLE_100
1193: , p5_a27 JTF_NUMBER_TABLE
1194: , p5_a28 JTF_NUMBER_TABLE
1189: , p5_a23 JTF_NUMBER_TABLE
1190: , p5_a24 JTF_NUMBER_TABLE
1191: , p5_a25 JTF_VARCHAR2_TABLE_100
1192: , p5_a26 JTF_VARCHAR2_TABLE_100
1193: , p5_a27 JTF_NUMBER_TABLE
1194: , p5_a28 JTF_NUMBER_TABLE
1195: , p5_a29 JTF_VARCHAR2_TABLE_100
1196: , p5_a30 JTF_VARCHAR2_TABLE_100
1197: , p5_a31 JTF_VARCHAR2_TABLE_500
1190: , p5_a24 JTF_NUMBER_TABLE
1191: , p5_a25 JTF_VARCHAR2_TABLE_100
1192: , p5_a26 JTF_VARCHAR2_TABLE_100
1193: , p5_a27 JTF_NUMBER_TABLE
1194: , p5_a28 JTF_NUMBER_TABLE
1195: , p5_a29 JTF_VARCHAR2_TABLE_100
1196: , p5_a30 JTF_VARCHAR2_TABLE_100
1197: , p5_a31 JTF_VARCHAR2_TABLE_500
1198: , p5_a32 JTF_VARCHAR2_TABLE_500
1208: , p5_a42 JTF_VARCHAR2_TABLE_500
1209: , p5_a43 JTF_VARCHAR2_TABLE_100
1210: , p5_a44 JTF_VARCHAR2_TABLE_500
1211: , p5_a45 JTF_VARCHAR2_TABLE_500
1212: , p5_a46 JTF_NUMBER_TABLE
1213: , p5_a47 JTF_DATE_TABLE
1214: , p5_a48 JTF_NUMBER_TABLE
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1210: , p5_a44 JTF_VARCHAR2_TABLE_500
1211: , p5_a45 JTF_VARCHAR2_TABLE_500
1212: , p5_a46 JTF_NUMBER_TABLE
1213: , p5_a47 JTF_DATE_TABLE
1214: , p5_a48 JTF_NUMBER_TABLE
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1212: , p5_a46 JTF_NUMBER_TABLE
1213: , p5_a47 JTF_DATE_TABLE
1214: , p5_a48 JTF_NUMBER_TABLE
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1219: , p6_a1 out nocopy JTF_NUMBER_TABLE
1220: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1213: , p5_a47 JTF_DATE_TABLE
1214: , p5_a48 JTF_NUMBER_TABLE
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1219: , p6_a1 out nocopy JTF_NUMBER_TABLE
1220: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1221: , p6_a3 out nocopy JTF_NUMBER_TABLE
1214: , p5_a48 JTF_NUMBER_TABLE
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1219: , p6_a1 out nocopy JTF_NUMBER_TABLE
1220: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1221: , p6_a3 out nocopy JTF_NUMBER_TABLE
1222: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1215: , p5_a49 JTF_DATE_TABLE
1216: , p5_a50 JTF_NUMBER_TABLE
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1219: , p6_a1 out nocopy JTF_NUMBER_TABLE
1220: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1221: , p6_a3 out nocopy JTF_NUMBER_TABLE
1222: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1217: , p5_a51 JTF_NUMBER_TABLE
1218: , p6_a0 out nocopy JTF_NUMBER_TABLE
1219: , p6_a1 out nocopy JTF_NUMBER_TABLE
1220: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1221: , p6_a3 out nocopy JTF_NUMBER_TABLE
1222: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1224: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1225: , p6_a7 out nocopy JTF_DATE_TABLE
1223: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1224: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1225: , p6_a7 out nocopy JTF_DATE_TABLE
1226: , p6_a8 out nocopy JTF_DATE_TABLE
1227: , p6_a9 out nocopy JTF_NUMBER_TABLE
1228: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1231: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1229: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1231: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a14 out nocopy JTF_NUMBER_TABLE
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1229: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1231: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a14 out nocopy JTF_NUMBER_TABLE
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1230: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1231: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a14 out nocopy JTF_NUMBER_TABLE
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1231: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a14 out nocopy JTF_NUMBER_TABLE
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a14 out nocopy JTF_NUMBER_TABLE
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1233: , p6_a15 out nocopy JTF_NUMBER_TABLE
1234: , p6_a16 out nocopy JTF_NUMBER_TABLE
1235: , p6_a17 out nocopy JTF_NUMBER_TABLE
1236: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a23 out nocopy JTF_NUMBER_TABLE
1237: , p6_a19 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a23 out nocopy JTF_NUMBER_TABLE
1242: , p6_a24 out nocopy JTF_NUMBER_TABLE
1243: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a27 out nocopy JTF_NUMBER_TABLE
1238: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a23 out nocopy JTF_NUMBER_TABLE
1242: , p6_a24 out nocopy JTF_NUMBER_TABLE
1243: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a27 out nocopy JTF_NUMBER_TABLE
1246: , p6_a28 out nocopy JTF_NUMBER_TABLE
1241: , p6_a23 out nocopy JTF_NUMBER_TABLE
1242: , p6_a24 out nocopy JTF_NUMBER_TABLE
1243: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a27 out nocopy JTF_NUMBER_TABLE
1246: , p6_a28 out nocopy JTF_NUMBER_TABLE
1247: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
1248: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1242: , p6_a24 out nocopy JTF_NUMBER_TABLE
1243: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a27 out nocopy JTF_NUMBER_TABLE
1246: , p6_a28 out nocopy JTF_NUMBER_TABLE
1247: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
1248: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1250: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1260: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1261: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1262: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1263: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1264: , p6_a46 out nocopy JTF_NUMBER_TABLE
1265: , p6_a47 out nocopy JTF_DATE_TABLE
1266: , p6_a48 out nocopy JTF_NUMBER_TABLE
1267: , p6_a49 out nocopy JTF_DATE_TABLE
1268: , p6_a50 out nocopy JTF_NUMBER_TABLE
1262: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1263: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1264: , p6_a46 out nocopy JTF_NUMBER_TABLE
1265: , p6_a47 out nocopy JTF_DATE_TABLE
1266: , p6_a48 out nocopy JTF_NUMBER_TABLE
1267: , p6_a49 out nocopy JTF_DATE_TABLE
1268: , p6_a50 out nocopy JTF_NUMBER_TABLE
1269: , p6_a51 out nocopy JTF_NUMBER_TABLE
1270: )
1264: , p6_a46 out nocopy JTF_NUMBER_TABLE
1265: , p6_a47 out nocopy JTF_DATE_TABLE
1266: , p6_a48 out nocopy JTF_NUMBER_TABLE
1267: , p6_a49 out nocopy JTF_DATE_TABLE
1268: , p6_a50 out nocopy JTF_NUMBER_TABLE
1269: , p6_a51 out nocopy JTF_NUMBER_TABLE
1270: )
1271:
1272: as
1265: , p6_a47 out nocopy JTF_DATE_TABLE
1266: , p6_a48 out nocopy JTF_NUMBER_TABLE
1267: , p6_a49 out nocopy JTF_DATE_TABLE
1268: , p6_a50 out nocopy JTF_NUMBER_TABLE
1269: , p6_a51 out nocopy JTF_NUMBER_TABLE
1270: )
1271:
1272: as
1273: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
1550: , p_init_msg_list VARCHAR2
1551: , x_return_status out nocopy VARCHAR2
1552: , x_msg_count out nocopy NUMBER
1553: , x_msg_data out nocopy VARCHAR2
1554: , p5_a0 JTF_NUMBER_TABLE
1555: , p5_a1 JTF_NUMBER_TABLE
1556: , p5_a2 JTF_VARCHAR2_TABLE_100
1557: , p5_a3 JTF_NUMBER_TABLE
1558: , p5_a4 JTF_VARCHAR2_TABLE_100
1551: , x_return_status out nocopy VARCHAR2
1552: , x_msg_count out nocopy NUMBER
1553: , x_msg_data out nocopy VARCHAR2
1554: , p5_a0 JTF_NUMBER_TABLE
1555: , p5_a1 JTF_NUMBER_TABLE
1556: , p5_a2 JTF_VARCHAR2_TABLE_100
1557: , p5_a3 JTF_NUMBER_TABLE
1558: , p5_a4 JTF_VARCHAR2_TABLE_100
1559: , p5_a5 JTF_VARCHAR2_TABLE_200
1553: , x_msg_data out nocopy VARCHAR2
1554: , p5_a0 JTF_NUMBER_TABLE
1555: , p5_a1 JTF_NUMBER_TABLE
1556: , p5_a2 JTF_VARCHAR2_TABLE_100
1557: , p5_a3 JTF_NUMBER_TABLE
1558: , p5_a4 JTF_VARCHAR2_TABLE_100
1559: , p5_a5 JTF_VARCHAR2_TABLE_200
1560: , p5_a6 JTF_VARCHAR2_TABLE_2000
1561: , p5_a7 JTF_DATE_TABLE
1559: , p5_a5 JTF_VARCHAR2_TABLE_200
1560: , p5_a6 JTF_VARCHAR2_TABLE_2000
1561: , p5_a7 JTF_DATE_TABLE
1562: , p5_a8 JTF_DATE_TABLE
1563: , p5_a9 JTF_NUMBER_TABLE
1564: , p5_a10 JTF_VARCHAR2_TABLE_100
1565: , p5_a11 JTF_VARCHAR2_TABLE_100
1566: , p5_a12 JTF_VARCHAR2_TABLE_100
1567: , p5_a13 JTF_VARCHAR2_TABLE_100
1564: , p5_a10 JTF_VARCHAR2_TABLE_100
1565: , p5_a11 JTF_VARCHAR2_TABLE_100
1566: , p5_a12 JTF_VARCHAR2_TABLE_100
1567: , p5_a13 JTF_VARCHAR2_TABLE_100
1568: , p5_a14 JTF_NUMBER_TABLE
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1565: , p5_a11 JTF_VARCHAR2_TABLE_100
1566: , p5_a12 JTF_VARCHAR2_TABLE_100
1567: , p5_a13 JTF_VARCHAR2_TABLE_100
1568: , p5_a14 JTF_NUMBER_TABLE
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1566: , p5_a12 JTF_VARCHAR2_TABLE_100
1567: , p5_a13 JTF_VARCHAR2_TABLE_100
1568: , p5_a14 JTF_NUMBER_TABLE
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1567: , p5_a13 JTF_VARCHAR2_TABLE_100
1568: , p5_a14 JTF_NUMBER_TABLE
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1575: , p5_a21 JTF_VARCHAR2_TABLE_100
1568: , p5_a14 JTF_NUMBER_TABLE
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1575: , p5_a21 JTF_VARCHAR2_TABLE_100
1576: , p5_a22 JTF_VARCHAR2_TABLE_100
1569: , p5_a15 JTF_NUMBER_TABLE
1570: , p5_a16 JTF_NUMBER_TABLE
1571: , p5_a17 JTF_NUMBER_TABLE
1572: , p5_a18 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1575: , p5_a21 JTF_VARCHAR2_TABLE_100
1576: , p5_a22 JTF_VARCHAR2_TABLE_100
1577: , p5_a23 JTF_NUMBER_TABLE
1573: , p5_a19 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1575: , p5_a21 JTF_VARCHAR2_TABLE_100
1576: , p5_a22 JTF_VARCHAR2_TABLE_100
1577: , p5_a23 JTF_NUMBER_TABLE
1578: , p5_a24 JTF_NUMBER_TABLE
1579: , p5_a25 JTF_VARCHAR2_TABLE_100
1580: , p5_a26 JTF_VARCHAR2_TABLE_100
1581: , p5_a27 JTF_NUMBER_TABLE
1574: , p5_a20 JTF_VARCHAR2_TABLE_100
1575: , p5_a21 JTF_VARCHAR2_TABLE_100
1576: , p5_a22 JTF_VARCHAR2_TABLE_100
1577: , p5_a23 JTF_NUMBER_TABLE
1578: , p5_a24 JTF_NUMBER_TABLE
1579: , p5_a25 JTF_VARCHAR2_TABLE_100
1580: , p5_a26 JTF_VARCHAR2_TABLE_100
1581: , p5_a27 JTF_NUMBER_TABLE
1582: , p5_a28 JTF_NUMBER_TABLE
1577: , p5_a23 JTF_NUMBER_TABLE
1578: , p5_a24 JTF_NUMBER_TABLE
1579: , p5_a25 JTF_VARCHAR2_TABLE_100
1580: , p5_a26 JTF_VARCHAR2_TABLE_100
1581: , p5_a27 JTF_NUMBER_TABLE
1582: , p5_a28 JTF_NUMBER_TABLE
1583: , p5_a29 JTF_VARCHAR2_TABLE_100
1584: , p5_a30 JTF_VARCHAR2_TABLE_100
1585: , p5_a31 JTF_VARCHAR2_TABLE_500
1578: , p5_a24 JTF_NUMBER_TABLE
1579: , p5_a25 JTF_VARCHAR2_TABLE_100
1580: , p5_a26 JTF_VARCHAR2_TABLE_100
1581: , p5_a27 JTF_NUMBER_TABLE
1582: , p5_a28 JTF_NUMBER_TABLE
1583: , p5_a29 JTF_VARCHAR2_TABLE_100
1584: , p5_a30 JTF_VARCHAR2_TABLE_100
1585: , p5_a31 JTF_VARCHAR2_TABLE_500
1586: , p5_a32 JTF_VARCHAR2_TABLE_500
1596: , p5_a42 JTF_VARCHAR2_TABLE_500
1597: , p5_a43 JTF_VARCHAR2_TABLE_100
1598: , p5_a44 JTF_VARCHAR2_TABLE_500
1599: , p5_a45 JTF_VARCHAR2_TABLE_500
1600: , p5_a46 JTF_NUMBER_TABLE
1601: , p5_a47 JTF_DATE_TABLE
1602: , p5_a48 JTF_NUMBER_TABLE
1603: , p5_a49 JTF_DATE_TABLE
1604: , p5_a50 JTF_NUMBER_TABLE
1598: , p5_a44 JTF_VARCHAR2_TABLE_500
1599: , p5_a45 JTF_VARCHAR2_TABLE_500
1600: , p5_a46 JTF_NUMBER_TABLE
1601: , p5_a47 JTF_DATE_TABLE
1602: , p5_a48 JTF_NUMBER_TABLE
1603: , p5_a49 JTF_DATE_TABLE
1604: , p5_a50 JTF_NUMBER_TABLE
1605: , p5_a51 JTF_NUMBER_TABLE
1606: )
1600: , p5_a46 JTF_NUMBER_TABLE
1601: , p5_a47 JTF_DATE_TABLE
1602: , p5_a48 JTF_NUMBER_TABLE
1603: , p5_a49 JTF_DATE_TABLE
1604: , p5_a50 JTF_NUMBER_TABLE
1605: , p5_a51 JTF_NUMBER_TABLE
1606: )
1607:
1608: as
1601: , p5_a47 JTF_DATE_TABLE
1602: , p5_a48 JTF_NUMBER_TABLE
1603: , p5_a49 JTF_DATE_TABLE
1604: , p5_a50 JTF_NUMBER_TABLE
1605: , p5_a51 JTF_NUMBER_TABLE
1606: )
1607:
1608: as
1609: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
1937: , p_init_msg_list VARCHAR2
1938: , x_return_status out nocopy VARCHAR2
1939: , x_msg_count out nocopy NUMBER
1940: , x_msg_data out nocopy VARCHAR2
1941: , p5_a0 JTF_NUMBER_TABLE
1942: , p5_a1 JTF_NUMBER_TABLE
1943: , p5_a2 JTF_VARCHAR2_TABLE_100
1944: , p5_a3 JTF_NUMBER_TABLE
1945: , p5_a4 JTF_VARCHAR2_TABLE_100
1938: , x_return_status out nocopy VARCHAR2
1939: , x_msg_count out nocopy NUMBER
1940: , x_msg_data out nocopy VARCHAR2
1941: , p5_a0 JTF_NUMBER_TABLE
1942: , p5_a1 JTF_NUMBER_TABLE
1943: , p5_a2 JTF_VARCHAR2_TABLE_100
1944: , p5_a3 JTF_NUMBER_TABLE
1945: , p5_a4 JTF_VARCHAR2_TABLE_100
1946: , p5_a5 JTF_VARCHAR2_TABLE_200
1940: , x_msg_data out nocopy VARCHAR2
1941: , p5_a0 JTF_NUMBER_TABLE
1942: , p5_a1 JTF_NUMBER_TABLE
1943: , p5_a2 JTF_VARCHAR2_TABLE_100
1944: , p5_a3 JTF_NUMBER_TABLE
1945: , p5_a4 JTF_VARCHAR2_TABLE_100
1946: , p5_a5 JTF_VARCHAR2_TABLE_200
1947: , p5_a6 JTF_VARCHAR2_TABLE_2000
1948: , p5_a7 JTF_DATE_TABLE
1946: , p5_a5 JTF_VARCHAR2_TABLE_200
1947: , p5_a6 JTF_VARCHAR2_TABLE_2000
1948: , p5_a7 JTF_DATE_TABLE
1949: , p5_a8 JTF_DATE_TABLE
1950: , p5_a9 JTF_NUMBER_TABLE
1951: , p5_a10 JTF_VARCHAR2_TABLE_100
1952: , p5_a11 JTF_VARCHAR2_TABLE_100
1953: , p5_a12 JTF_VARCHAR2_TABLE_100
1954: , p5_a13 JTF_VARCHAR2_TABLE_100
1951: , p5_a10 JTF_VARCHAR2_TABLE_100
1952: , p5_a11 JTF_VARCHAR2_TABLE_100
1953: , p5_a12 JTF_VARCHAR2_TABLE_100
1954: , p5_a13 JTF_VARCHAR2_TABLE_100
1955: , p5_a14 JTF_NUMBER_TABLE
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1952: , p5_a11 JTF_VARCHAR2_TABLE_100
1953: , p5_a12 JTF_VARCHAR2_TABLE_100
1954: , p5_a13 JTF_VARCHAR2_TABLE_100
1955: , p5_a14 JTF_NUMBER_TABLE
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1953: , p5_a12 JTF_VARCHAR2_TABLE_100
1954: , p5_a13 JTF_VARCHAR2_TABLE_100
1955: , p5_a14 JTF_NUMBER_TABLE
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1954: , p5_a13 JTF_VARCHAR2_TABLE_100
1955: , p5_a14 JTF_NUMBER_TABLE
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1962: , p5_a21 JTF_VARCHAR2_TABLE_100
1955: , p5_a14 JTF_NUMBER_TABLE
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1962: , p5_a21 JTF_VARCHAR2_TABLE_100
1963: , p5_a22 JTF_VARCHAR2_TABLE_100
1956: , p5_a15 JTF_NUMBER_TABLE
1957: , p5_a16 JTF_NUMBER_TABLE
1958: , p5_a17 JTF_NUMBER_TABLE
1959: , p5_a18 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1962: , p5_a21 JTF_VARCHAR2_TABLE_100
1963: , p5_a22 JTF_VARCHAR2_TABLE_100
1964: , p5_a23 JTF_NUMBER_TABLE
1960: , p5_a19 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1962: , p5_a21 JTF_VARCHAR2_TABLE_100
1963: , p5_a22 JTF_VARCHAR2_TABLE_100
1964: , p5_a23 JTF_NUMBER_TABLE
1965: , p5_a24 JTF_NUMBER_TABLE
1966: , p5_a25 JTF_VARCHAR2_TABLE_100
1967: , p5_a26 JTF_VARCHAR2_TABLE_100
1968: , p5_a27 JTF_NUMBER_TABLE
1961: , p5_a20 JTF_VARCHAR2_TABLE_100
1962: , p5_a21 JTF_VARCHAR2_TABLE_100
1963: , p5_a22 JTF_VARCHAR2_TABLE_100
1964: , p5_a23 JTF_NUMBER_TABLE
1965: , p5_a24 JTF_NUMBER_TABLE
1966: , p5_a25 JTF_VARCHAR2_TABLE_100
1967: , p5_a26 JTF_VARCHAR2_TABLE_100
1968: , p5_a27 JTF_NUMBER_TABLE
1969: , p5_a28 JTF_NUMBER_TABLE
1964: , p5_a23 JTF_NUMBER_TABLE
1965: , p5_a24 JTF_NUMBER_TABLE
1966: , p5_a25 JTF_VARCHAR2_TABLE_100
1967: , p5_a26 JTF_VARCHAR2_TABLE_100
1968: , p5_a27 JTF_NUMBER_TABLE
1969: , p5_a28 JTF_NUMBER_TABLE
1970: , p5_a29 JTF_VARCHAR2_TABLE_100
1971: , p5_a30 JTF_VARCHAR2_TABLE_100
1972: , p5_a31 JTF_VARCHAR2_TABLE_500
1965: , p5_a24 JTF_NUMBER_TABLE
1966: , p5_a25 JTF_VARCHAR2_TABLE_100
1967: , p5_a26 JTF_VARCHAR2_TABLE_100
1968: , p5_a27 JTF_NUMBER_TABLE
1969: , p5_a28 JTF_NUMBER_TABLE
1970: , p5_a29 JTF_VARCHAR2_TABLE_100
1971: , p5_a30 JTF_VARCHAR2_TABLE_100
1972: , p5_a31 JTF_VARCHAR2_TABLE_500
1973: , p5_a32 JTF_VARCHAR2_TABLE_500
1983: , p5_a42 JTF_VARCHAR2_TABLE_500
1984: , p5_a43 JTF_VARCHAR2_TABLE_100
1985: , p5_a44 JTF_VARCHAR2_TABLE_500
1986: , p5_a45 JTF_VARCHAR2_TABLE_500
1987: , p5_a46 JTF_NUMBER_TABLE
1988: , p5_a47 JTF_DATE_TABLE
1989: , p5_a48 JTF_NUMBER_TABLE
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1985: , p5_a44 JTF_VARCHAR2_TABLE_500
1986: , p5_a45 JTF_VARCHAR2_TABLE_500
1987: , p5_a46 JTF_NUMBER_TABLE
1988: , p5_a47 JTF_DATE_TABLE
1989: , p5_a48 JTF_NUMBER_TABLE
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p5_a46 JTF_NUMBER_TABLE
1988: , p5_a47 JTF_DATE_TABLE
1989: , p5_a48 JTF_NUMBER_TABLE
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1994: , p6_a1 out nocopy JTF_NUMBER_TABLE
1995: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1988: , p5_a47 JTF_DATE_TABLE
1989: , p5_a48 JTF_NUMBER_TABLE
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1994: , p6_a1 out nocopy JTF_NUMBER_TABLE
1995: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a3 out nocopy JTF_NUMBER_TABLE
1989: , p5_a48 JTF_NUMBER_TABLE
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1994: , p6_a1 out nocopy JTF_NUMBER_TABLE
1995: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a3 out nocopy JTF_NUMBER_TABLE
1997: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1990: , p5_a49 JTF_DATE_TABLE
1991: , p5_a50 JTF_NUMBER_TABLE
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1994: , p6_a1 out nocopy JTF_NUMBER_TABLE
1995: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a3 out nocopy JTF_NUMBER_TABLE
1997: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1998: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1992: , p5_a51 JTF_NUMBER_TABLE
1993: , p6_a0 out nocopy JTF_NUMBER_TABLE
1994: , p6_a1 out nocopy JTF_NUMBER_TABLE
1995: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1996: , p6_a3 out nocopy JTF_NUMBER_TABLE
1997: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1998: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
2000: , p6_a7 out nocopy JTF_DATE_TABLE
1998: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
2000: , p6_a7 out nocopy JTF_DATE_TABLE
2001: , p6_a8 out nocopy JTF_DATE_TABLE
2002: , p6_a9 out nocopy JTF_NUMBER_TABLE
2003: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a14 out nocopy JTF_NUMBER_TABLE
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2004: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2005: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a14 out nocopy JTF_NUMBER_TABLE
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2005: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a14 out nocopy JTF_NUMBER_TABLE
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a14 out nocopy JTF_NUMBER_TABLE
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p6_a14 out nocopy JTF_NUMBER_TABLE
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a15 out nocopy JTF_NUMBER_TABLE
2009: , p6_a16 out nocopy JTF_NUMBER_TABLE
2010: , p6_a17 out nocopy JTF_NUMBER_TABLE
2011: , p6_a18 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2016: , p6_a23 out nocopy JTF_NUMBER_TABLE
2012: , p6_a19 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2016: , p6_a23 out nocopy JTF_NUMBER_TABLE
2017: , p6_a24 out nocopy JTF_NUMBER_TABLE
2018: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a27 out nocopy JTF_NUMBER_TABLE
2013: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2015: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2016: , p6_a23 out nocopy JTF_NUMBER_TABLE
2017: , p6_a24 out nocopy JTF_NUMBER_TABLE
2018: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a27 out nocopy JTF_NUMBER_TABLE
2021: , p6_a28 out nocopy JTF_NUMBER_TABLE
2016: , p6_a23 out nocopy JTF_NUMBER_TABLE
2017: , p6_a24 out nocopy JTF_NUMBER_TABLE
2018: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a27 out nocopy JTF_NUMBER_TABLE
2021: , p6_a28 out nocopy JTF_NUMBER_TABLE
2022: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2023: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2024: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2017: , p6_a24 out nocopy JTF_NUMBER_TABLE
2018: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2019: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2020: , p6_a27 out nocopy JTF_NUMBER_TABLE
2021: , p6_a28 out nocopy JTF_NUMBER_TABLE
2022: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2023: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2024: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2025: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2035: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2036: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
2037: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2038: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2039: , p6_a46 out nocopy JTF_NUMBER_TABLE
2040: , p6_a47 out nocopy JTF_DATE_TABLE
2041: , p6_a48 out nocopy JTF_NUMBER_TABLE
2042: , p6_a49 out nocopy JTF_DATE_TABLE
2043: , p6_a50 out nocopy JTF_NUMBER_TABLE
2037: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2038: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2039: , p6_a46 out nocopy JTF_NUMBER_TABLE
2040: , p6_a47 out nocopy JTF_DATE_TABLE
2041: , p6_a48 out nocopy JTF_NUMBER_TABLE
2042: , p6_a49 out nocopy JTF_DATE_TABLE
2043: , p6_a50 out nocopy JTF_NUMBER_TABLE
2044: , p6_a51 out nocopy JTF_NUMBER_TABLE
2045: )
2039: , p6_a46 out nocopy JTF_NUMBER_TABLE
2040: , p6_a47 out nocopy JTF_DATE_TABLE
2041: , p6_a48 out nocopy JTF_NUMBER_TABLE
2042: , p6_a49 out nocopy JTF_DATE_TABLE
2043: , p6_a50 out nocopy JTF_NUMBER_TABLE
2044: , p6_a51 out nocopy JTF_NUMBER_TABLE
2045: )
2046:
2047: as
2040: , p6_a47 out nocopy JTF_DATE_TABLE
2041: , p6_a48 out nocopy JTF_NUMBER_TABLE
2042: , p6_a49 out nocopy JTF_DATE_TABLE
2043: , p6_a50 out nocopy JTF_NUMBER_TABLE
2044: , p6_a51 out nocopy JTF_NUMBER_TABLE
2045: )
2046:
2047: as
2048: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2325: , p_init_msg_list VARCHAR2
2326: , x_return_status out nocopy VARCHAR2
2327: , x_msg_count out nocopy NUMBER
2328: , x_msg_data out nocopy VARCHAR2
2329: , p5_a0 JTF_NUMBER_TABLE
2330: , p5_a1 JTF_NUMBER_TABLE
2331: , p5_a2 JTF_VARCHAR2_TABLE_100
2332: , p5_a3 JTF_NUMBER_TABLE
2333: , p5_a4 JTF_VARCHAR2_TABLE_100
2326: , x_return_status out nocopy VARCHAR2
2327: , x_msg_count out nocopy NUMBER
2328: , x_msg_data out nocopy VARCHAR2
2329: , p5_a0 JTF_NUMBER_TABLE
2330: , p5_a1 JTF_NUMBER_TABLE
2331: , p5_a2 JTF_VARCHAR2_TABLE_100
2332: , p5_a3 JTF_NUMBER_TABLE
2333: , p5_a4 JTF_VARCHAR2_TABLE_100
2334: , p5_a5 JTF_VARCHAR2_TABLE_200
2328: , x_msg_data out nocopy VARCHAR2
2329: , p5_a0 JTF_NUMBER_TABLE
2330: , p5_a1 JTF_NUMBER_TABLE
2331: , p5_a2 JTF_VARCHAR2_TABLE_100
2332: , p5_a3 JTF_NUMBER_TABLE
2333: , p5_a4 JTF_VARCHAR2_TABLE_100
2334: , p5_a5 JTF_VARCHAR2_TABLE_200
2335: , p5_a6 JTF_VARCHAR2_TABLE_2000
2336: , p5_a7 JTF_DATE_TABLE
2334: , p5_a5 JTF_VARCHAR2_TABLE_200
2335: , p5_a6 JTF_VARCHAR2_TABLE_2000
2336: , p5_a7 JTF_DATE_TABLE
2337: , p5_a8 JTF_DATE_TABLE
2338: , p5_a9 JTF_NUMBER_TABLE
2339: , p5_a10 JTF_VARCHAR2_TABLE_100
2340: , p5_a11 JTF_VARCHAR2_TABLE_100
2341: , p5_a12 JTF_VARCHAR2_TABLE_100
2342: , p5_a13 JTF_VARCHAR2_TABLE_100
2339: , p5_a10 JTF_VARCHAR2_TABLE_100
2340: , p5_a11 JTF_VARCHAR2_TABLE_100
2341: , p5_a12 JTF_VARCHAR2_TABLE_100
2342: , p5_a13 JTF_VARCHAR2_TABLE_100
2343: , p5_a14 JTF_NUMBER_TABLE
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2340: , p5_a11 JTF_VARCHAR2_TABLE_100
2341: , p5_a12 JTF_VARCHAR2_TABLE_100
2342: , p5_a13 JTF_VARCHAR2_TABLE_100
2343: , p5_a14 JTF_NUMBER_TABLE
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2341: , p5_a12 JTF_VARCHAR2_TABLE_100
2342: , p5_a13 JTF_VARCHAR2_TABLE_100
2343: , p5_a14 JTF_NUMBER_TABLE
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2342: , p5_a13 JTF_VARCHAR2_TABLE_100
2343: , p5_a14 JTF_NUMBER_TABLE
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2350: , p5_a21 JTF_VARCHAR2_TABLE_100
2343: , p5_a14 JTF_NUMBER_TABLE
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2350: , p5_a21 JTF_VARCHAR2_TABLE_100
2351: , p5_a22 JTF_VARCHAR2_TABLE_100
2344: , p5_a15 JTF_NUMBER_TABLE
2345: , p5_a16 JTF_NUMBER_TABLE
2346: , p5_a17 JTF_NUMBER_TABLE
2347: , p5_a18 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2350: , p5_a21 JTF_VARCHAR2_TABLE_100
2351: , p5_a22 JTF_VARCHAR2_TABLE_100
2352: , p5_a23 JTF_NUMBER_TABLE
2348: , p5_a19 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2350: , p5_a21 JTF_VARCHAR2_TABLE_100
2351: , p5_a22 JTF_VARCHAR2_TABLE_100
2352: , p5_a23 JTF_NUMBER_TABLE
2353: , p5_a24 JTF_NUMBER_TABLE
2354: , p5_a25 JTF_VARCHAR2_TABLE_100
2355: , p5_a26 JTF_VARCHAR2_TABLE_100
2356: , p5_a27 JTF_NUMBER_TABLE
2349: , p5_a20 JTF_VARCHAR2_TABLE_100
2350: , p5_a21 JTF_VARCHAR2_TABLE_100
2351: , p5_a22 JTF_VARCHAR2_TABLE_100
2352: , p5_a23 JTF_NUMBER_TABLE
2353: , p5_a24 JTF_NUMBER_TABLE
2354: , p5_a25 JTF_VARCHAR2_TABLE_100
2355: , p5_a26 JTF_VARCHAR2_TABLE_100
2356: , p5_a27 JTF_NUMBER_TABLE
2357: , p5_a28 JTF_NUMBER_TABLE
2352: , p5_a23 JTF_NUMBER_TABLE
2353: , p5_a24 JTF_NUMBER_TABLE
2354: , p5_a25 JTF_VARCHAR2_TABLE_100
2355: , p5_a26 JTF_VARCHAR2_TABLE_100
2356: , p5_a27 JTF_NUMBER_TABLE
2357: , p5_a28 JTF_NUMBER_TABLE
2358: , p5_a29 JTF_VARCHAR2_TABLE_100
2359: , p5_a30 JTF_VARCHAR2_TABLE_100
2360: , p5_a31 JTF_VARCHAR2_TABLE_500
2353: , p5_a24 JTF_NUMBER_TABLE
2354: , p5_a25 JTF_VARCHAR2_TABLE_100
2355: , p5_a26 JTF_VARCHAR2_TABLE_100
2356: , p5_a27 JTF_NUMBER_TABLE
2357: , p5_a28 JTF_NUMBER_TABLE
2358: , p5_a29 JTF_VARCHAR2_TABLE_100
2359: , p5_a30 JTF_VARCHAR2_TABLE_100
2360: , p5_a31 JTF_VARCHAR2_TABLE_500
2361: , p5_a32 JTF_VARCHAR2_TABLE_500
2371: , p5_a42 JTF_VARCHAR2_TABLE_500
2372: , p5_a43 JTF_VARCHAR2_TABLE_100
2373: , p5_a44 JTF_VARCHAR2_TABLE_500
2374: , p5_a45 JTF_VARCHAR2_TABLE_500
2375: , p5_a46 JTF_NUMBER_TABLE
2376: , p5_a47 JTF_DATE_TABLE
2377: , p5_a48 JTF_NUMBER_TABLE
2378: , p5_a49 JTF_DATE_TABLE
2379: , p5_a50 JTF_NUMBER_TABLE
2373: , p5_a44 JTF_VARCHAR2_TABLE_500
2374: , p5_a45 JTF_VARCHAR2_TABLE_500
2375: , p5_a46 JTF_NUMBER_TABLE
2376: , p5_a47 JTF_DATE_TABLE
2377: , p5_a48 JTF_NUMBER_TABLE
2378: , p5_a49 JTF_DATE_TABLE
2379: , p5_a50 JTF_NUMBER_TABLE
2380: , p5_a51 JTF_NUMBER_TABLE
2381: )
2375: , p5_a46 JTF_NUMBER_TABLE
2376: , p5_a47 JTF_DATE_TABLE
2377: , p5_a48 JTF_NUMBER_TABLE
2378: , p5_a49 JTF_DATE_TABLE
2379: , p5_a50 JTF_NUMBER_TABLE
2380: , p5_a51 JTF_NUMBER_TABLE
2381: )
2382:
2383: as
2376: , p5_a47 JTF_DATE_TABLE
2377: , p5_a48 JTF_NUMBER_TABLE
2378: , p5_a49 JTF_DATE_TABLE
2379: , p5_a50 JTF_NUMBER_TABLE
2380: , p5_a51 JTF_NUMBER_TABLE
2381: )
2382:
2383: as
2384: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;
2604: , p_init_msg_list VARCHAR2
2605: , x_return_status out nocopy VARCHAR2
2606: , x_msg_count out nocopy NUMBER
2607: , x_msg_data out nocopy VARCHAR2
2608: , p5_a0 JTF_NUMBER_TABLE
2609: , p5_a1 JTF_NUMBER_TABLE
2610: , p5_a2 JTF_VARCHAR2_TABLE_100
2611: , p5_a3 JTF_NUMBER_TABLE
2612: , p5_a4 JTF_VARCHAR2_TABLE_100
2605: , x_return_status out nocopy VARCHAR2
2606: , x_msg_count out nocopy NUMBER
2607: , x_msg_data out nocopy VARCHAR2
2608: , p5_a0 JTF_NUMBER_TABLE
2609: , p5_a1 JTF_NUMBER_TABLE
2610: , p5_a2 JTF_VARCHAR2_TABLE_100
2611: , p5_a3 JTF_NUMBER_TABLE
2612: , p5_a4 JTF_VARCHAR2_TABLE_100
2613: , p5_a5 JTF_VARCHAR2_TABLE_200
2607: , x_msg_data out nocopy VARCHAR2
2608: , p5_a0 JTF_NUMBER_TABLE
2609: , p5_a1 JTF_NUMBER_TABLE
2610: , p5_a2 JTF_VARCHAR2_TABLE_100
2611: , p5_a3 JTF_NUMBER_TABLE
2612: , p5_a4 JTF_VARCHAR2_TABLE_100
2613: , p5_a5 JTF_VARCHAR2_TABLE_200
2614: , p5_a6 JTF_VARCHAR2_TABLE_2000
2615: , p5_a7 JTF_DATE_TABLE
2613: , p5_a5 JTF_VARCHAR2_TABLE_200
2614: , p5_a6 JTF_VARCHAR2_TABLE_2000
2615: , p5_a7 JTF_DATE_TABLE
2616: , p5_a8 JTF_DATE_TABLE
2617: , p5_a9 JTF_NUMBER_TABLE
2618: , p5_a10 JTF_VARCHAR2_TABLE_100
2619: , p5_a11 JTF_VARCHAR2_TABLE_100
2620: , p5_a12 JTF_VARCHAR2_TABLE_100
2621: , p5_a13 JTF_VARCHAR2_TABLE_100
2618: , p5_a10 JTF_VARCHAR2_TABLE_100
2619: , p5_a11 JTF_VARCHAR2_TABLE_100
2620: , p5_a12 JTF_VARCHAR2_TABLE_100
2621: , p5_a13 JTF_VARCHAR2_TABLE_100
2622: , p5_a14 JTF_NUMBER_TABLE
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2619: , p5_a11 JTF_VARCHAR2_TABLE_100
2620: , p5_a12 JTF_VARCHAR2_TABLE_100
2621: , p5_a13 JTF_VARCHAR2_TABLE_100
2622: , p5_a14 JTF_NUMBER_TABLE
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2620: , p5_a12 JTF_VARCHAR2_TABLE_100
2621: , p5_a13 JTF_VARCHAR2_TABLE_100
2622: , p5_a14 JTF_NUMBER_TABLE
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2621: , p5_a13 JTF_VARCHAR2_TABLE_100
2622: , p5_a14 JTF_NUMBER_TABLE
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2629: , p5_a21 JTF_VARCHAR2_TABLE_100
2622: , p5_a14 JTF_NUMBER_TABLE
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2629: , p5_a21 JTF_VARCHAR2_TABLE_100
2630: , p5_a22 JTF_VARCHAR2_TABLE_100
2623: , p5_a15 JTF_NUMBER_TABLE
2624: , p5_a16 JTF_NUMBER_TABLE
2625: , p5_a17 JTF_NUMBER_TABLE
2626: , p5_a18 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2629: , p5_a21 JTF_VARCHAR2_TABLE_100
2630: , p5_a22 JTF_VARCHAR2_TABLE_100
2631: , p5_a23 JTF_NUMBER_TABLE
2627: , p5_a19 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2629: , p5_a21 JTF_VARCHAR2_TABLE_100
2630: , p5_a22 JTF_VARCHAR2_TABLE_100
2631: , p5_a23 JTF_NUMBER_TABLE
2632: , p5_a24 JTF_NUMBER_TABLE
2633: , p5_a25 JTF_VARCHAR2_TABLE_100
2634: , p5_a26 JTF_VARCHAR2_TABLE_100
2635: , p5_a27 JTF_NUMBER_TABLE
2628: , p5_a20 JTF_VARCHAR2_TABLE_100
2629: , p5_a21 JTF_VARCHAR2_TABLE_100
2630: , p5_a22 JTF_VARCHAR2_TABLE_100
2631: , p5_a23 JTF_NUMBER_TABLE
2632: , p5_a24 JTF_NUMBER_TABLE
2633: , p5_a25 JTF_VARCHAR2_TABLE_100
2634: , p5_a26 JTF_VARCHAR2_TABLE_100
2635: , p5_a27 JTF_NUMBER_TABLE
2636: , p5_a28 JTF_NUMBER_TABLE
2631: , p5_a23 JTF_NUMBER_TABLE
2632: , p5_a24 JTF_NUMBER_TABLE
2633: , p5_a25 JTF_VARCHAR2_TABLE_100
2634: , p5_a26 JTF_VARCHAR2_TABLE_100
2635: , p5_a27 JTF_NUMBER_TABLE
2636: , p5_a28 JTF_NUMBER_TABLE
2637: , p5_a29 JTF_VARCHAR2_TABLE_100
2638: , p5_a30 JTF_VARCHAR2_TABLE_100
2639: , p5_a31 JTF_VARCHAR2_TABLE_500
2632: , p5_a24 JTF_NUMBER_TABLE
2633: , p5_a25 JTF_VARCHAR2_TABLE_100
2634: , p5_a26 JTF_VARCHAR2_TABLE_100
2635: , p5_a27 JTF_NUMBER_TABLE
2636: , p5_a28 JTF_NUMBER_TABLE
2637: , p5_a29 JTF_VARCHAR2_TABLE_100
2638: , p5_a30 JTF_VARCHAR2_TABLE_100
2639: , p5_a31 JTF_VARCHAR2_TABLE_500
2640: , p5_a32 JTF_VARCHAR2_TABLE_500
2650: , p5_a42 JTF_VARCHAR2_TABLE_500
2651: , p5_a43 JTF_VARCHAR2_TABLE_100
2652: , p5_a44 JTF_VARCHAR2_TABLE_500
2653: , p5_a45 JTF_VARCHAR2_TABLE_500
2654: , p5_a46 JTF_NUMBER_TABLE
2655: , p5_a47 JTF_DATE_TABLE
2656: , p5_a48 JTF_NUMBER_TABLE
2657: , p5_a49 JTF_DATE_TABLE
2658: , p5_a50 JTF_NUMBER_TABLE
2652: , p5_a44 JTF_VARCHAR2_TABLE_500
2653: , p5_a45 JTF_VARCHAR2_TABLE_500
2654: , p5_a46 JTF_NUMBER_TABLE
2655: , p5_a47 JTF_DATE_TABLE
2656: , p5_a48 JTF_NUMBER_TABLE
2657: , p5_a49 JTF_DATE_TABLE
2658: , p5_a50 JTF_NUMBER_TABLE
2659: , p5_a51 JTF_NUMBER_TABLE
2660: )
2654: , p5_a46 JTF_NUMBER_TABLE
2655: , p5_a47 JTF_DATE_TABLE
2656: , p5_a48 JTF_NUMBER_TABLE
2657: , p5_a49 JTF_DATE_TABLE
2658: , p5_a50 JTF_NUMBER_TABLE
2659: , p5_a51 JTF_NUMBER_TABLE
2660: )
2661:
2662: as
2655: , p5_a47 JTF_DATE_TABLE
2656: , p5_a48 JTF_NUMBER_TABLE
2657: , p5_a49 JTF_DATE_TABLE
2658: , p5_a50 JTF_NUMBER_TABLE
2659: , p5_a51 JTF_NUMBER_TABLE
2660: )
2661:
2662: as
2663: ddp_subv_tbl okl_sub_pvt.subv_tbl_type;