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_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then
57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
61: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);
102: a2.extend(t.count);
131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
146: ) as
147: ddindx binary_integer; indx binary_integer;
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE
143: , a8 JTF_NUMBER_TABLE
144: , a9 JTF_DATE_TABLE
145: , a10 JTF_NUMBER_TABLE
146: ) as
147: ddindx binary_integer; indx binary_integer;
148: begin
149: if a0 is not null and a0.count > 0 then
170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
174: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
185: ) as
186: ddindx binary_integer; indx binary_integer;
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_DATE_TABLE
184: , a10 out nocopy JTF_NUMBER_TABLE
185: ) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
185: ) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
197: a8 := JTF_NUMBER_TABLE();
198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
212: if t.count > 0 then
213: a0.extend(t.count);
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();
209: a8 := JTF_NUMBER_TABLE();
210: a9 := JTF_DATE_TABLE();
211: a10 := JTF_NUMBER_TABLE();
212: if t.count > 0 then
213: a0.extend(t.count);
214: a1.extend(t.count);
215: a2.extend(t.count);
332: , p_init_msg_list VARCHAR2
333: , x_return_status out nocopy VARCHAR2
334: , x_msg_count out nocopy NUMBER
335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
334: , x_msg_count out nocopy NUMBER
335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
343: , p5_a7 JTF_DATE_TABLE
344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
354: , p6_a7 out nocopy JTF_DATE_TABLE
355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
364: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
364: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
365: )
366:
444: , p_init_msg_list VARCHAR2
445: , x_return_status out nocopy VARCHAR2
446: , x_msg_count out nocopy NUMBER
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
446: , x_msg_count out nocopy NUMBER
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
455: , p5_a7 JTF_DATE_TABLE
456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE
467: , p6_a8 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE
467: , p6_a8 out nocopy JTF_NUMBER_TABLE
468: , p6_a9 out nocopy JTF_DATE_TABLE
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE
467: , p6_a8 out nocopy JTF_NUMBER_TABLE
468: , p6_a9 out nocopy JTF_DATE_TABLE
469: , p6_a10 out nocopy JTF_NUMBER_TABLE
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE
467: , p6_a8 out nocopy JTF_NUMBER_TABLE
468: , p6_a9 out nocopy JTF_DATE_TABLE
469: , p6_a10 out nocopy JTF_NUMBER_TABLE
470: )
471:
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE
467: , p6_a8 out nocopy JTF_NUMBER_TABLE
468: , p6_a9 out nocopy JTF_DATE_TABLE
469: , p6_a10 out nocopy JTF_NUMBER_TABLE
470: )
471:
472: as
473: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;
586: , p_init_msg_list VARCHAR2
587: , x_return_status out nocopy VARCHAR2
588: , x_msg_count out nocopy NUMBER
589: , x_msg_data out nocopy VARCHAR2
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
588: , x_msg_count out nocopy NUMBER
589: , x_msg_data out nocopy VARCHAR2
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
597: , p5_a7 JTF_DATE_TABLE
598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
608: )
609:
671: , p_init_msg_list VARCHAR2
672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE
683: , p5_a8 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: )
687:
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: )
687:
688: as
689: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;
812: , p_init_msg_list VARCHAR2
813: , x_return_status out nocopy VARCHAR2
814: , x_msg_count out nocopy NUMBER
815: , x_msg_data out nocopy VARCHAR2
816: , p5_a0 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
814: , x_msg_count out nocopy NUMBER
815: , x_msg_data out nocopy VARCHAR2
816: , p5_a0 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
816: , p5_a0 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_DATE_TABLE
824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
834: , p6_a7 out nocopy JTF_DATE_TABLE
835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
845: )
846:
924: , p_init_msg_list VARCHAR2
925: , x_return_status out nocopy VARCHAR2
926: , x_msg_count out nocopy NUMBER
927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
926: , x_msg_count out nocopy NUMBER
927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a7 JTF_DATE_TABLE
936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: )
951:
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: )
951:
952: as
953: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;
1066: , p_init_msg_list VARCHAR2
1067: , x_return_status out nocopy VARCHAR2
1068: , x_msg_count out nocopy NUMBER
1069: , x_msg_data out nocopy VARCHAR2
1070: , p5_a0 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1068: , x_msg_count out nocopy NUMBER
1069: , x_msg_data out nocopy VARCHAR2
1070: , p5_a0 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1070: , p5_a0 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1077: , p5_a7 JTF_DATE_TABLE
1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1151: , p_init_msg_list VARCHAR2
1152: , x_return_status out nocopy VARCHAR2
1153: , x_msg_count out nocopy NUMBER
1154: , x_msg_data out nocopy VARCHAR2
1155: , p5_a0 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1153: , x_msg_count out nocopy NUMBER
1154: , x_msg_data out nocopy VARCHAR2
1155: , p5_a0 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1155: , p5_a0 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE
1163: , p5_a8 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE
1163: , p5_a8 JTF_NUMBER_TABLE
1164: , p5_a9 JTF_DATE_TABLE
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE
1163: , p5_a8 JTF_NUMBER_TABLE
1164: , p5_a9 JTF_DATE_TABLE
1165: , p5_a10 JTF_NUMBER_TABLE
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE
1163: , p5_a8 JTF_NUMBER_TABLE
1164: , p5_a9 JTF_DATE_TABLE
1165: , p5_a10 JTF_NUMBER_TABLE
1166: )
1167:
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE
1163: , p5_a8 JTF_NUMBER_TABLE
1164: , p5_a9 JTF_DATE_TABLE
1165: , p5_a10 JTF_NUMBER_TABLE
1166: )
1167:
1168: as
1169: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;
1266: , p_init_msg_list VARCHAR2
1267: , x_return_status out nocopy VARCHAR2
1268: , x_msg_count out nocopy NUMBER
1269: , x_msg_data out nocopy VARCHAR2
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1268: , x_msg_count out nocopy NUMBER
1269: , x_msg_data out nocopy VARCHAR2
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1277: , p5_a7 JTF_DATE_TABLE
1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1287: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1287: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1288: )
1289:
1351: , p_init_msg_list VARCHAR2
1352: , x_return_status out nocopy VARCHAR2
1353: , x_msg_count out nocopy NUMBER
1354: , x_msg_data out nocopy VARCHAR2
1355: , p5_a0 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1353: , x_msg_count out nocopy NUMBER
1354: , x_msg_data out nocopy VARCHAR2
1355: , p5_a0 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1355: , p5_a0 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE
1363: , p5_a8 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE
1363: , p5_a8 JTF_NUMBER_TABLE
1364: , p5_a9 JTF_DATE_TABLE
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE
1363: , p5_a8 JTF_NUMBER_TABLE
1364: , p5_a9 JTF_DATE_TABLE
1365: , p5_a10 JTF_NUMBER_TABLE
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE
1363: , p5_a8 JTF_NUMBER_TABLE
1364: , p5_a9 JTF_DATE_TABLE
1365: , p5_a10 JTF_NUMBER_TABLE
1366: )
1367:
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE
1363: , p5_a8 JTF_NUMBER_TABLE
1364: , p5_a9 JTF_DATE_TABLE
1365: , p5_a10 JTF_NUMBER_TABLE
1366: )
1367:
1368: as
1369: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;