1: package body okl_lrv_pvt_w as
2: /* $Header: OKLILRVB.pls 120.1 2005/09/30 11:00:31 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
1: package body okl_lrv_pvt_w as
2: /* $Header: OKLILRVB.pls 120.1 2005/09/30 11:00:31 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_500
39: , a36 JTF_VARCHAR2_TABLE_500
40: , a37 JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if a0 is not null and a0.count > 0 then
92: end loop;
93: end if;
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
93: end if;
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_DATE_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_NUMBER_TABLE
113: , a17 out nocopy JTF_DATE_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_NUMBER_TABLE
113: , a17 out nocopy JTF_DATE_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_NUMBER_TABLE
113: , a17 out nocopy JTF_DATE_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_NUMBER_TABLE
113: , a17 out nocopy JTF_DATE_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_VARCHAR2_TABLE_100
118: , a22 out nocopy JTF_VARCHAR2_TABLE_500
112: , a16 out nocopy JTF_NUMBER_TABLE
113: , a17 out nocopy JTF_DATE_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_VARCHAR2_TABLE_100
118: , a22 out nocopy JTF_VARCHAR2_TABLE_500
119: , a23 out nocopy JTF_VARCHAR2_TABLE_500
120: , a24 out nocopy JTF_VARCHAR2_TABLE_500
129: , a33 out nocopy JTF_VARCHAR2_TABLE_500
130: , a34 out nocopy JTF_VARCHAR2_TABLE_500
131: , a35 out nocopy JTF_VARCHAR2_TABLE_500
132: , a36 out nocopy JTF_VARCHAR2_TABLE_500
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_DATE_TABLE();
142: a4 := JTF_DATE_TABLE();
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_DATE_TABLE();
142: a4 := JTF_DATE_TABLE();
143: a5 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_DATE_TABLE();
142: a4 := JTF_DATE_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_DATE_TABLE();
142: a4 := JTF_DATE_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
141: a3 := JTF_DATE_TABLE();
142: a4 := JTF_DATE_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
142: a4 := JTF_DATE_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_NUMBER_TABLE();
155: a17 := JTF_DATE_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_NUMBER_TABLE();
155: a17 := JTF_DATE_TABLE();
156: a18 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_NUMBER_TABLE();
155: a17 := JTF_DATE_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_NUMBER_TABLE();
155: a17 := JTF_DATE_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_VARCHAR2_TABLE_100();
160: a22 := JTF_VARCHAR2_TABLE_500();
154: a16 := JTF_NUMBER_TABLE();
155: a17 := JTF_DATE_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_VARCHAR2_TABLE_100();
160: a22 := JTF_VARCHAR2_TABLE_500();
161: a23 := JTF_VARCHAR2_TABLE_500();
162: a24 := JTF_VARCHAR2_TABLE_500();
171: a33 := JTF_VARCHAR2_TABLE_500();
172: a34 := JTF_VARCHAR2_TABLE_500();
173: a35 := JTF_VARCHAR2_TABLE_500();
174: a36 := JTF_VARCHAR2_TABLE_500();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_100();
173: a35 := JTF_VARCHAR2_TABLE_500();
174: a36 := JTF_VARCHAR2_TABLE_500();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
174: a36 := JTF_VARCHAR2_TABLE_500();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_NUMBER_TABLE();
194: a17 := JTF_DATE_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_NUMBER_TABLE();
194: a17 := JTF_DATE_TABLE();
195: a18 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_NUMBER_TABLE();
194: a17 := JTF_DATE_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_NUMBER_TABLE();
194: a17 := JTF_DATE_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_500();
193: a16 := JTF_NUMBER_TABLE();
194: a17 := JTF_DATE_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_VARCHAR2_TABLE_500();
200: a23 := JTF_VARCHAR2_TABLE_500();
201: a24 := JTF_VARCHAR2_TABLE_500();
210: a33 := JTF_VARCHAR2_TABLE_500();
211: a34 := JTF_VARCHAR2_TABLE_500();
212: a35 := JTF_VARCHAR2_TABLE_500();
213: a36 := JTF_VARCHAR2_TABLE_500();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
218: a2.extend(t.count);
301: end if;
302: end if;
303: end rosetta_table_copy_out_p1;
304:
305: procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_DATE_TABLE
309: , a4 JTF_DATE_TABLE
302: end if;
303: end rosetta_table_copy_out_p1;
304:
305: procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_DATE_TABLE
309: , a4 JTF_DATE_TABLE
310: , a5 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_DATE_TABLE
309: , a4 JTF_DATE_TABLE
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_DATE_TABLE
309: , a4 JTF_DATE_TABLE
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
308: , a3 JTF_DATE_TABLE
309: , a4 JTF_DATE_TABLE
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
309: , a4 JTF_DATE_TABLE
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_NUMBER_TABLE
322: , a17 JTF_DATE_TABLE
315: , a10 JTF_NUMBER_TABLE
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_NUMBER_TABLE
322: , a17 JTF_DATE_TABLE
323: , a18 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_NUMBER_TABLE
322: , a17 JTF_DATE_TABLE
323: , a18 JTF_NUMBER_TABLE
324: , a19 JTF_DATE_TABLE
325: , a20 JTF_NUMBER_TABLE
319: , a14 JTF_NUMBER_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_NUMBER_TABLE
322: , a17 JTF_DATE_TABLE
323: , a18 JTF_NUMBER_TABLE
324: , a19 JTF_DATE_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_VARCHAR2_TABLE_100
327: , a22 JTF_VARCHAR2_TABLE_500
321: , a16 JTF_NUMBER_TABLE
322: , a17 JTF_DATE_TABLE
323: , a18 JTF_NUMBER_TABLE
324: , a19 JTF_DATE_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_VARCHAR2_TABLE_100
327: , a22 JTF_VARCHAR2_TABLE_500
328: , a23 JTF_VARCHAR2_TABLE_500
329: , a24 JTF_VARCHAR2_TABLE_500
338: , a33 JTF_VARCHAR2_TABLE_500
339: , a34 JTF_VARCHAR2_TABLE_500
340: , a35 JTF_VARCHAR2_TABLE_500
341: , a36 JTF_VARCHAR2_TABLE_500
342: , a37 JTF_NUMBER_TABLE
343: ) as
344: ddindx binary_integer; indx binary_integer;
345: begin
346: if a0 is not null and a0.count > 0 then
394: end loop;
395: end if;
396: end if;
397: end rosetta_table_copy_in_p3;
398: procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_VARCHAR2_TABLE_100
401: , a3 out nocopy JTF_DATE_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
395: end if;
396: end if;
397: end rosetta_table_copy_in_p3;
398: procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_VARCHAR2_TABLE_100
401: , a3 out nocopy JTF_DATE_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
403: , a5 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_NUMBER_TABLE
400: , a2 out nocopy JTF_VARCHAR2_TABLE_100
401: , a3 out nocopy JTF_DATE_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a2 out nocopy JTF_VARCHAR2_TABLE_100
401: , a3 out nocopy JTF_DATE_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_DATE_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
402: , a4 out nocopy JTF_DATE_TABLE
403: , a5 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
404: , a6 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
405: , a7 out nocopy JTF_NUMBER_TABLE
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a8 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a16 out nocopy JTF_NUMBER_TABLE
407: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a16 out nocopy JTF_NUMBER_TABLE
415: , a17 out nocopy JTF_DATE_TABLE
408: , a10 out nocopy JTF_NUMBER_TABLE
409: , a11 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a16 out nocopy JTF_NUMBER_TABLE
415: , a17 out nocopy JTF_DATE_TABLE
416: , a18 out nocopy JTF_NUMBER_TABLE
410: , a12 out nocopy JTF_NUMBER_TABLE
411: , a13 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a16 out nocopy JTF_NUMBER_TABLE
415: , a17 out nocopy JTF_DATE_TABLE
416: , a18 out nocopy JTF_NUMBER_TABLE
417: , a19 out nocopy JTF_DATE_TABLE
418: , a20 out nocopy JTF_NUMBER_TABLE
412: , a14 out nocopy JTF_NUMBER_TABLE
413: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a16 out nocopy JTF_NUMBER_TABLE
415: , a17 out nocopy JTF_DATE_TABLE
416: , a18 out nocopy JTF_NUMBER_TABLE
417: , a19 out nocopy JTF_DATE_TABLE
418: , a20 out nocopy JTF_NUMBER_TABLE
419: , a21 out nocopy JTF_VARCHAR2_TABLE_100
420: , a22 out nocopy JTF_VARCHAR2_TABLE_500
414: , a16 out nocopy JTF_NUMBER_TABLE
415: , a17 out nocopy JTF_DATE_TABLE
416: , a18 out nocopy JTF_NUMBER_TABLE
417: , a19 out nocopy JTF_DATE_TABLE
418: , a20 out nocopy JTF_NUMBER_TABLE
419: , a21 out nocopy JTF_VARCHAR2_TABLE_100
420: , a22 out nocopy JTF_VARCHAR2_TABLE_500
421: , a23 out nocopy JTF_VARCHAR2_TABLE_500
422: , a24 out nocopy JTF_VARCHAR2_TABLE_500
431: , a33 out nocopy JTF_VARCHAR2_TABLE_500
432: , a34 out nocopy JTF_VARCHAR2_TABLE_500
433: , a35 out nocopy JTF_VARCHAR2_TABLE_500
434: , a36 out nocopy JTF_VARCHAR2_TABLE_500
435: , a37 out nocopy JTF_NUMBER_TABLE
436: ) as
437: ddindx binary_integer; indx binary_integer;
438: begin
439: if t is null or t.count = 0 then
436: ) as
437: ddindx binary_integer; indx binary_integer;
438: begin
439: if t is null or t.count = 0 then
440: a0 := JTF_NUMBER_TABLE();
441: a1 := JTF_NUMBER_TABLE();
442: a2 := JTF_VARCHAR2_TABLE_100();
443: a3 := JTF_DATE_TABLE();
444: a4 := JTF_DATE_TABLE();
437: ddindx binary_integer; indx binary_integer;
438: begin
439: if t is null or t.count = 0 then
440: a0 := JTF_NUMBER_TABLE();
441: a1 := JTF_NUMBER_TABLE();
442: a2 := JTF_VARCHAR2_TABLE_100();
443: a3 := JTF_DATE_TABLE();
444: a4 := JTF_DATE_TABLE();
445: a5 := JTF_NUMBER_TABLE();
441: a1 := JTF_NUMBER_TABLE();
442: a2 := JTF_VARCHAR2_TABLE_100();
443: a3 := JTF_DATE_TABLE();
444: a4 := JTF_DATE_TABLE();
445: a5 := JTF_NUMBER_TABLE();
446: a6 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
442: a2 := JTF_VARCHAR2_TABLE_100();
443: a3 := JTF_DATE_TABLE();
444: a4 := JTF_DATE_TABLE();
445: a5 := JTF_NUMBER_TABLE();
446: a6 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
443: a3 := JTF_DATE_TABLE();
444: a4 := JTF_DATE_TABLE();
445: a5 := JTF_NUMBER_TABLE();
446: a6 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
444: a4 := JTF_DATE_TABLE();
445: a5 := JTF_NUMBER_TABLE();
446: a6 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
446: a6 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
447: a7 := JTF_NUMBER_TABLE();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
448: a8 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
456: a16 := JTF_NUMBER_TABLE();
449: a9 := JTF_VARCHAR2_TABLE_100();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
456: a16 := JTF_NUMBER_TABLE();
457: a17 := JTF_DATE_TABLE();
450: a10 := JTF_NUMBER_TABLE();
451: a11 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
456: a16 := JTF_NUMBER_TABLE();
457: a17 := JTF_DATE_TABLE();
458: a18 := JTF_NUMBER_TABLE();
452: a12 := JTF_NUMBER_TABLE();
453: a13 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
456: a16 := JTF_NUMBER_TABLE();
457: a17 := JTF_DATE_TABLE();
458: a18 := JTF_NUMBER_TABLE();
459: a19 := JTF_DATE_TABLE();
460: a20 := JTF_NUMBER_TABLE();
454: a14 := JTF_NUMBER_TABLE();
455: a15 := JTF_VARCHAR2_TABLE_100();
456: a16 := JTF_NUMBER_TABLE();
457: a17 := JTF_DATE_TABLE();
458: a18 := JTF_NUMBER_TABLE();
459: a19 := JTF_DATE_TABLE();
460: a20 := JTF_NUMBER_TABLE();
461: a21 := JTF_VARCHAR2_TABLE_100();
462: a22 := JTF_VARCHAR2_TABLE_500();
456: a16 := JTF_NUMBER_TABLE();
457: a17 := JTF_DATE_TABLE();
458: a18 := JTF_NUMBER_TABLE();
459: a19 := JTF_DATE_TABLE();
460: a20 := JTF_NUMBER_TABLE();
461: a21 := JTF_VARCHAR2_TABLE_100();
462: a22 := JTF_VARCHAR2_TABLE_500();
463: a23 := JTF_VARCHAR2_TABLE_500();
464: a24 := JTF_VARCHAR2_TABLE_500();
473: a33 := JTF_VARCHAR2_TABLE_500();
474: a34 := JTF_VARCHAR2_TABLE_500();
475: a35 := JTF_VARCHAR2_TABLE_500();
476: a36 := JTF_VARCHAR2_TABLE_500();
477: a37 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_100();
475: a35 := JTF_VARCHAR2_TABLE_500();
476: a36 := JTF_VARCHAR2_TABLE_500();
477: a37 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_100();
482: a3 := JTF_DATE_TABLE();
483: a4 := JTF_DATE_TABLE();
476: a36 := JTF_VARCHAR2_TABLE_500();
477: a37 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_100();
482: a3 := JTF_DATE_TABLE();
483: a4 := JTF_DATE_TABLE();
484: a5 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_100();
482: a3 := JTF_DATE_TABLE();
483: a4 := JTF_DATE_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
481: a2 := JTF_VARCHAR2_TABLE_100();
482: a3 := JTF_DATE_TABLE();
483: a4 := JTF_DATE_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
482: a3 := JTF_DATE_TABLE();
483: a4 := JTF_DATE_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
483: a4 := JTF_DATE_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
486: a7 := JTF_NUMBER_TABLE();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
495: a16 := JTF_NUMBER_TABLE();
488: a9 := JTF_VARCHAR2_TABLE_100();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
495: a16 := JTF_NUMBER_TABLE();
496: a17 := JTF_DATE_TABLE();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
495: a16 := JTF_NUMBER_TABLE();
496: a17 := JTF_DATE_TABLE();
497: a18 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: a13 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
495: a16 := JTF_NUMBER_TABLE();
496: a17 := JTF_DATE_TABLE();
497: a18 := JTF_NUMBER_TABLE();
498: a19 := JTF_DATE_TABLE();
499: a20 := JTF_NUMBER_TABLE();
493: a14 := JTF_NUMBER_TABLE();
494: a15 := JTF_VARCHAR2_TABLE_100();
495: a16 := JTF_NUMBER_TABLE();
496: a17 := JTF_DATE_TABLE();
497: a18 := JTF_NUMBER_TABLE();
498: a19 := JTF_DATE_TABLE();
499: a20 := JTF_NUMBER_TABLE();
500: a21 := JTF_VARCHAR2_TABLE_100();
501: a22 := JTF_VARCHAR2_TABLE_500();
495: a16 := JTF_NUMBER_TABLE();
496: a17 := JTF_DATE_TABLE();
497: a18 := JTF_NUMBER_TABLE();
498: a19 := JTF_DATE_TABLE();
499: a20 := JTF_NUMBER_TABLE();
500: a21 := JTF_VARCHAR2_TABLE_100();
501: a22 := JTF_VARCHAR2_TABLE_500();
502: a23 := JTF_VARCHAR2_TABLE_500();
503: a24 := JTF_VARCHAR2_TABLE_500();
512: a33 := JTF_VARCHAR2_TABLE_500();
513: a34 := JTF_VARCHAR2_TABLE_500();
514: a35 := JTF_VARCHAR2_TABLE_500();
515: a36 := JTF_VARCHAR2_TABLE_500();
516: a37 := JTF_NUMBER_TABLE();
517: if t.count > 0 then
518: a0.extend(t.count);
519: a1.extend(t.count);
520: a2.extend(t.count);
799: , p_init_msg_list VARCHAR2
800: , x_return_status out nocopy VARCHAR2
801: , x_msg_count out nocopy NUMBER
802: , x_msg_data out nocopy VARCHAR2
803: , p5_a0 JTF_NUMBER_TABLE
804: , p5_a1 JTF_NUMBER_TABLE
805: , p5_a2 JTF_VARCHAR2_TABLE_100
806: , p5_a3 JTF_DATE_TABLE
807: , p5_a4 JTF_DATE_TABLE
800: , x_return_status out nocopy VARCHAR2
801: , x_msg_count out nocopy NUMBER
802: , x_msg_data out nocopy VARCHAR2
803: , p5_a0 JTF_NUMBER_TABLE
804: , p5_a1 JTF_NUMBER_TABLE
805: , p5_a2 JTF_VARCHAR2_TABLE_100
806: , p5_a3 JTF_DATE_TABLE
807: , p5_a4 JTF_DATE_TABLE
808: , p5_a5 JTF_NUMBER_TABLE
804: , p5_a1 JTF_NUMBER_TABLE
805: , p5_a2 JTF_VARCHAR2_TABLE_100
806: , p5_a3 JTF_DATE_TABLE
807: , p5_a4 JTF_DATE_TABLE
808: , p5_a5 JTF_NUMBER_TABLE
809: , p5_a6 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
805: , p5_a2 JTF_VARCHAR2_TABLE_100
806: , p5_a3 JTF_DATE_TABLE
807: , p5_a4 JTF_DATE_TABLE
808: , p5_a5 JTF_NUMBER_TABLE
809: , p5_a6 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
806: , p5_a3 JTF_DATE_TABLE
807: , p5_a4 JTF_DATE_TABLE
808: , p5_a5 JTF_NUMBER_TABLE
809: , p5_a6 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
807: , p5_a4 JTF_DATE_TABLE
808: , p5_a5 JTF_NUMBER_TABLE
809: , p5_a6 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
809: , p5_a6 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
810: , p5_a7 JTF_NUMBER_TABLE
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
811: , p5_a8 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
819: , p5_a16 JTF_NUMBER_TABLE
812: , p5_a9 JTF_VARCHAR2_TABLE_100
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
819: , p5_a16 JTF_NUMBER_TABLE
820: , p5_a17 JTF_DATE_TABLE
813: , p5_a10 JTF_NUMBER_TABLE
814: , p5_a11 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
819: , p5_a16 JTF_NUMBER_TABLE
820: , p5_a17 JTF_DATE_TABLE
821: , p5_a18 JTF_NUMBER_TABLE
815: , p5_a12 JTF_NUMBER_TABLE
816: , p5_a13 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
819: , p5_a16 JTF_NUMBER_TABLE
820: , p5_a17 JTF_DATE_TABLE
821: , p5_a18 JTF_NUMBER_TABLE
822: , p5_a19 JTF_DATE_TABLE
823: , p5_a20 JTF_NUMBER_TABLE
817: , p5_a14 JTF_NUMBER_TABLE
818: , p5_a15 JTF_VARCHAR2_TABLE_100
819: , p5_a16 JTF_NUMBER_TABLE
820: , p5_a17 JTF_DATE_TABLE
821: , p5_a18 JTF_NUMBER_TABLE
822: , p5_a19 JTF_DATE_TABLE
823: , p5_a20 JTF_NUMBER_TABLE
824: , p5_a21 JTF_VARCHAR2_TABLE_100
825: , p5_a22 JTF_VARCHAR2_TABLE_500
819: , p5_a16 JTF_NUMBER_TABLE
820: , p5_a17 JTF_DATE_TABLE
821: , p5_a18 JTF_NUMBER_TABLE
822: , p5_a19 JTF_DATE_TABLE
823: , p5_a20 JTF_NUMBER_TABLE
824: , p5_a21 JTF_VARCHAR2_TABLE_100
825: , p5_a22 JTF_VARCHAR2_TABLE_500
826: , p5_a23 JTF_VARCHAR2_TABLE_500
827: , p5_a24 JTF_VARCHAR2_TABLE_500
836: , p5_a33 JTF_VARCHAR2_TABLE_500
837: , p5_a34 JTF_VARCHAR2_TABLE_500
838: , p5_a35 JTF_VARCHAR2_TABLE_500
839: , p5_a36 JTF_VARCHAR2_TABLE_500
840: , p5_a37 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_DATE_TABLE
837: , p5_a34 JTF_VARCHAR2_TABLE_500
838: , p5_a35 JTF_VARCHAR2_TABLE_500
839: , p5_a36 JTF_VARCHAR2_TABLE_500
840: , p5_a37 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
838: , p5_a35 JTF_VARCHAR2_TABLE_500
839: , p5_a36 JTF_VARCHAR2_TABLE_500
840: , p5_a37 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_NUMBER_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_NUMBER_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
844: , p6_a3 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_NUMBER_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_DATE_TABLE
846: , p6_a5 out nocopy JTF_NUMBER_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
858: , p6_a17 out nocopy JTF_DATE_TABLE
851: , p6_a10 out nocopy JTF_NUMBER_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
858: , p6_a17 out nocopy JTF_DATE_TABLE
859: , p6_a18 out nocopy JTF_NUMBER_TABLE
853: , p6_a12 out nocopy JTF_NUMBER_TABLE
854: , p6_a13 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
858: , p6_a17 out nocopy JTF_DATE_TABLE
859: , p6_a18 out nocopy JTF_NUMBER_TABLE
860: , p6_a19 out nocopy JTF_DATE_TABLE
861: , p6_a20 out nocopy JTF_NUMBER_TABLE
855: , p6_a14 out nocopy JTF_NUMBER_TABLE
856: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
858: , p6_a17 out nocopy JTF_DATE_TABLE
859: , p6_a18 out nocopy JTF_NUMBER_TABLE
860: , p6_a19 out nocopy JTF_DATE_TABLE
861: , p6_a20 out nocopy JTF_NUMBER_TABLE
862: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
863: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
857: , p6_a16 out nocopy JTF_NUMBER_TABLE
858: , p6_a17 out nocopy JTF_DATE_TABLE
859: , p6_a18 out nocopy JTF_NUMBER_TABLE
860: , p6_a19 out nocopy JTF_DATE_TABLE
861: , p6_a20 out nocopy JTF_NUMBER_TABLE
862: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
863: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
865: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
874: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
875: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
876: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
877: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
878: , p6_a37 out nocopy JTF_NUMBER_TABLE
879: )
880:
881: as
882: ddp_lrvv_tbl okl_lrv_pvt.okl_lrvv_tbl;
1183: , p_init_msg_list VARCHAR2
1184: , x_return_status out nocopy VARCHAR2
1185: , x_msg_count out nocopy NUMBER
1186: , x_msg_data out nocopy VARCHAR2
1187: , p5_a0 JTF_NUMBER_TABLE
1188: , p5_a1 JTF_NUMBER_TABLE
1189: , p5_a2 JTF_VARCHAR2_TABLE_100
1190: , p5_a3 JTF_DATE_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1184: , x_return_status out nocopy VARCHAR2
1185: , x_msg_count out nocopy NUMBER
1186: , x_msg_data out nocopy VARCHAR2
1187: , p5_a0 JTF_NUMBER_TABLE
1188: , p5_a1 JTF_NUMBER_TABLE
1189: , p5_a2 JTF_VARCHAR2_TABLE_100
1190: , p5_a3 JTF_DATE_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1192: , p5_a5 JTF_NUMBER_TABLE
1188: , p5_a1 JTF_NUMBER_TABLE
1189: , p5_a2 JTF_VARCHAR2_TABLE_100
1190: , p5_a3 JTF_DATE_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1192: , p5_a5 JTF_NUMBER_TABLE
1193: , p5_a6 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1189: , p5_a2 JTF_VARCHAR2_TABLE_100
1190: , p5_a3 JTF_DATE_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1192: , p5_a5 JTF_NUMBER_TABLE
1193: , p5_a6 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1190: , p5_a3 JTF_DATE_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1192: , p5_a5 JTF_NUMBER_TABLE
1193: , p5_a6 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1191: , p5_a4 JTF_DATE_TABLE
1192: , p5_a5 JTF_NUMBER_TABLE
1193: , p5_a6 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1193: , p5_a6 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1194: , p5_a7 JTF_NUMBER_TABLE
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1195: , p5_a8 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1203: , p5_a16 JTF_NUMBER_TABLE
1196: , p5_a9 JTF_VARCHAR2_TABLE_100
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1203: , p5_a16 JTF_NUMBER_TABLE
1204: , p5_a17 JTF_DATE_TABLE
1197: , p5_a10 JTF_NUMBER_TABLE
1198: , p5_a11 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1203: , p5_a16 JTF_NUMBER_TABLE
1204: , p5_a17 JTF_DATE_TABLE
1205: , p5_a18 JTF_NUMBER_TABLE
1199: , p5_a12 JTF_NUMBER_TABLE
1200: , p5_a13 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1203: , p5_a16 JTF_NUMBER_TABLE
1204: , p5_a17 JTF_DATE_TABLE
1205: , p5_a18 JTF_NUMBER_TABLE
1206: , p5_a19 JTF_DATE_TABLE
1207: , p5_a20 JTF_NUMBER_TABLE
1201: , p5_a14 JTF_NUMBER_TABLE
1202: , p5_a15 JTF_VARCHAR2_TABLE_100
1203: , p5_a16 JTF_NUMBER_TABLE
1204: , p5_a17 JTF_DATE_TABLE
1205: , p5_a18 JTF_NUMBER_TABLE
1206: , p5_a19 JTF_DATE_TABLE
1207: , p5_a20 JTF_NUMBER_TABLE
1208: , p5_a21 JTF_VARCHAR2_TABLE_100
1209: , p5_a22 JTF_VARCHAR2_TABLE_500
1203: , p5_a16 JTF_NUMBER_TABLE
1204: , p5_a17 JTF_DATE_TABLE
1205: , p5_a18 JTF_NUMBER_TABLE
1206: , p5_a19 JTF_DATE_TABLE
1207: , p5_a20 JTF_NUMBER_TABLE
1208: , p5_a21 JTF_VARCHAR2_TABLE_100
1209: , p5_a22 JTF_VARCHAR2_TABLE_500
1210: , p5_a23 JTF_VARCHAR2_TABLE_500
1211: , p5_a24 JTF_VARCHAR2_TABLE_500
1220: , p5_a33 JTF_VARCHAR2_TABLE_500
1221: , p5_a34 JTF_VARCHAR2_TABLE_500
1222: , p5_a35 JTF_VARCHAR2_TABLE_500
1223: , p5_a36 JTF_VARCHAR2_TABLE_500
1224: , p5_a37 JTF_NUMBER_TABLE
1225: , p6_a0 out nocopy JTF_NUMBER_TABLE
1226: , p6_a1 out nocopy JTF_NUMBER_TABLE
1227: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1221: , p5_a34 JTF_VARCHAR2_TABLE_500
1222: , p5_a35 JTF_VARCHAR2_TABLE_500
1223: , p5_a36 JTF_VARCHAR2_TABLE_500
1224: , p5_a37 JTF_NUMBER_TABLE
1225: , p6_a0 out nocopy JTF_NUMBER_TABLE
1226: , p6_a1 out nocopy JTF_NUMBER_TABLE
1227: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1222: , p5_a35 JTF_VARCHAR2_TABLE_500
1223: , p5_a36 JTF_VARCHAR2_TABLE_500
1224: , p5_a37 JTF_NUMBER_TABLE
1225: , p6_a0 out nocopy JTF_NUMBER_TABLE
1226: , p6_a1 out nocopy JTF_NUMBER_TABLE
1227: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1230: , p6_a5 out nocopy JTF_NUMBER_TABLE
1226: , p6_a1 out nocopy JTF_NUMBER_TABLE
1227: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1230: , p6_a5 out nocopy JTF_NUMBER_TABLE
1231: , p6_a6 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1230: , p6_a5 out nocopy JTF_NUMBER_TABLE
1231: , p6_a6 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1228: , p6_a3 out nocopy JTF_DATE_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1230: , p6_a5 out nocopy JTF_NUMBER_TABLE
1231: , p6_a6 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1229: , p6_a4 out nocopy JTF_DATE_TABLE
1230: , p6_a5 out nocopy JTF_NUMBER_TABLE
1231: , p6_a6 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1231: , p6_a6 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1232: , p6_a7 out nocopy JTF_NUMBER_TABLE
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1233: , p6_a8 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1234: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1242: , p6_a17 out nocopy JTF_DATE_TABLE
1235: , p6_a10 out nocopy JTF_NUMBER_TABLE
1236: , p6_a11 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1242: , p6_a17 out nocopy JTF_DATE_TABLE
1243: , p6_a18 out nocopy JTF_NUMBER_TABLE
1237: , p6_a12 out nocopy JTF_NUMBER_TABLE
1238: , p6_a13 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1242: , p6_a17 out nocopy JTF_DATE_TABLE
1243: , p6_a18 out nocopy JTF_NUMBER_TABLE
1244: , p6_a19 out nocopy JTF_DATE_TABLE
1245: , p6_a20 out nocopy JTF_NUMBER_TABLE
1239: , p6_a14 out nocopy JTF_NUMBER_TABLE
1240: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1242: , p6_a17 out nocopy JTF_DATE_TABLE
1243: , p6_a18 out nocopy JTF_NUMBER_TABLE
1244: , p6_a19 out nocopy JTF_DATE_TABLE
1245: , p6_a20 out nocopy JTF_NUMBER_TABLE
1246: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1247: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1241: , p6_a16 out nocopy JTF_NUMBER_TABLE
1242: , p6_a17 out nocopy JTF_DATE_TABLE
1243: , p6_a18 out nocopy JTF_NUMBER_TABLE
1244: , p6_a19 out nocopy JTF_DATE_TABLE
1245: , p6_a20 out nocopy JTF_NUMBER_TABLE
1246: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1247: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1248: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1249: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1258: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1259: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1260: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1261: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
1262: , p6_a37 out nocopy JTF_NUMBER_TABLE
1263: )
1264:
1265: as
1266: ddp_lrvv_tbl okl_lrv_pvt.okl_lrvv_tbl;
1487: , p_init_msg_list VARCHAR2
1488: , x_return_status out nocopy VARCHAR2
1489: , x_msg_count out nocopy NUMBER
1490: , x_msg_data out nocopy VARCHAR2
1491: , p5_a0 JTF_NUMBER_TABLE
1492: , p5_a1 JTF_NUMBER_TABLE
1493: , p5_a2 JTF_VARCHAR2_TABLE_100
1494: , p5_a3 JTF_DATE_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1488: , x_return_status out nocopy VARCHAR2
1489: , x_msg_count out nocopy NUMBER
1490: , x_msg_data out nocopy VARCHAR2
1491: , p5_a0 JTF_NUMBER_TABLE
1492: , p5_a1 JTF_NUMBER_TABLE
1493: , p5_a2 JTF_VARCHAR2_TABLE_100
1494: , p5_a3 JTF_DATE_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1496: , p5_a5 JTF_NUMBER_TABLE
1492: , p5_a1 JTF_NUMBER_TABLE
1493: , p5_a2 JTF_VARCHAR2_TABLE_100
1494: , p5_a3 JTF_DATE_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1496: , p5_a5 JTF_NUMBER_TABLE
1497: , p5_a6 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1493: , p5_a2 JTF_VARCHAR2_TABLE_100
1494: , p5_a3 JTF_DATE_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1496: , p5_a5 JTF_NUMBER_TABLE
1497: , p5_a6 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1494: , p5_a3 JTF_DATE_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1496: , p5_a5 JTF_NUMBER_TABLE
1497: , p5_a6 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1495: , p5_a4 JTF_DATE_TABLE
1496: , p5_a5 JTF_NUMBER_TABLE
1497: , p5_a6 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1497: , p5_a6 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1498: , p5_a7 JTF_NUMBER_TABLE
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1499: , p5_a8 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1507: , p5_a16 JTF_NUMBER_TABLE
1500: , p5_a9 JTF_VARCHAR2_TABLE_100
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1507: , p5_a16 JTF_NUMBER_TABLE
1508: , p5_a17 JTF_DATE_TABLE
1501: , p5_a10 JTF_NUMBER_TABLE
1502: , p5_a11 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1507: , p5_a16 JTF_NUMBER_TABLE
1508: , p5_a17 JTF_DATE_TABLE
1509: , p5_a18 JTF_NUMBER_TABLE
1503: , p5_a12 JTF_NUMBER_TABLE
1504: , p5_a13 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1507: , p5_a16 JTF_NUMBER_TABLE
1508: , p5_a17 JTF_DATE_TABLE
1509: , p5_a18 JTF_NUMBER_TABLE
1510: , p5_a19 JTF_DATE_TABLE
1511: , p5_a20 JTF_NUMBER_TABLE
1505: , p5_a14 JTF_NUMBER_TABLE
1506: , p5_a15 JTF_VARCHAR2_TABLE_100
1507: , p5_a16 JTF_NUMBER_TABLE
1508: , p5_a17 JTF_DATE_TABLE
1509: , p5_a18 JTF_NUMBER_TABLE
1510: , p5_a19 JTF_DATE_TABLE
1511: , p5_a20 JTF_NUMBER_TABLE
1512: , p5_a21 JTF_VARCHAR2_TABLE_100
1513: , p5_a22 JTF_VARCHAR2_TABLE_500
1507: , p5_a16 JTF_NUMBER_TABLE
1508: , p5_a17 JTF_DATE_TABLE
1509: , p5_a18 JTF_NUMBER_TABLE
1510: , p5_a19 JTF_DATE_TABLE
1511: , p5_a20 JTF_NUMBER_TABLE
1512: , p5_a21 JTF_VARCHAR2_TABLE_100
1513: , p5_a22 JTF_VARCHAR2_TABLE_500
1514: , p5_a23 JTF_VARCHAR2_TABLE_500
1515: , p5_a24 JTF_VARCHAR2_TABLE_500
1524: , p5_a33 JTF_VARCHAR2_TABLE_500
1525: , p5_a34 JTF_VARCHAR2_TABLE_500
1526: , p5_a35 JTF_VARCHAR2_TABLE_500
1527: , p5_a36 JTF_VARCHAR2_TABLE_500
1528: , p5_a37 JTF_NUMBER_TABLE
1529: )
1530:
1531: as
1532: ddp_lrvv_tbl okl_lrv_pvt.okl_lrvv_tbl;