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_als_pvt.als_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_als_pvt.als_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_als_pvt.als_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then
59: end loop;
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t okl_als_pvt.als_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t okl_als_pvt.als_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t okl_als_pvt.als_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: ) as
76: ddindx binary_integer; indx binary_integer;
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_NUMBER_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_NUMBER_TABLE();
95: a3 := JTF_VARCHAR2_TABLE_100();
96: a4 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_NUMBER_TABLE();
95: a3 := JTF_VARCHAR2_TABLE_100();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_NUMBER_TABLE();
95: a3 := JTF_VARCHAR2_TABLE_100();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_VARCHAR2_TABLE_100();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_VARCHAR2_TABLE_100();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_DATE_TABLE();
103: a11 := JTF_NUMBER_TABLE();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_VARCHAR2_TABLE_100();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_DATE_TABLE();
103: a11 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_DATE_TABLE();
103: a11 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);
106: a1.extend(t.count);
107: a2.extend(t.count);
138: end if;
139: end if;
140: end rosetta_table_copy_out_p2;
141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_als_pvt.alsv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_VARCHAR2_TABLE_100
145: , a3 JTF_VARCHAR2_TABLE_100
146: , a4 JTF_VARCHAR2_TABLE_100
139: end if;
140: end rosetta_table_copy_out_p2;
141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_als_pvt.alsv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_VARCHAR2_TABLE_100
145: , a3 JTF_VARCHAR2_TABLE_100
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_VARCHAR2_TABLE_100
144: , a2 JTF_VARCHAR2_TABLE_100
145: , a3 JTF_VARCHAR2_TABLE_100
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_VARCHAR2_TABLE_100
148: , a6 JTF_NUMBER_TABLE
149: , a7 JTF_NUMBER_TABLE
150: , a8 JTF_DATE_TABLE
151: , a9 JTF_NUMBER_TABLE
152: , a10 JTF_DATE_TABLE
145: , a3 JTF_VARCHAR2_TABLE_100
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_VARCHAR2_TABLE_100
148: , a6 JTF_NUMBER_TABLE
149: , a7 JTF_NUMBER_TABLE
150: , a8 JTF_DATE_TABLE
151: , a9 JTF_NUMBER_TABLE
152: , a10 JTF_DATE_TABLE
153: , a11 JTF_NUMBER_TABLE
147: , a5 JTF_VARCHAR2_TABLE_100
148: , a6 JTF_NUMBER_TABLE
149: , a7 JTF_NUMBER_TABLE
150: , a8 JTF_DATE_TABLE
151: , a9 JTF_NUMBER_TABLE
152: , a10 JTF_DATE_TABLE
153: , a11 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
149: , a7 JTF_NUMBER_TABLE
150: , a8 JTF_DATE_TABLE
151: , a9 JTF_NUMBER_TABLE
152: , a10 JTF_DATE_TABLE
153: , a11 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if a0 is not null and a0.count > 0 then
179: end loop;
180: end if;
181: end if;
182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_als_pvt.alsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
180: end if;
181: end if;
182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_als_pvt.alsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_VARCHAR2_TABLE_100
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_NUMBER_TABLE
191: , a8 out nocopy JTF_DATE_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_DATE_TABLE
186: , a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_VARCHAR2_TABLE_100
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_NUMBER_TABLE
191: , a8 out nocopy JTF_DATE_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_DATE_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
188: , a5 out nocopy JTF_VARCHAR2_TABLE_100
189: , a6 out nocopy JTF_NUMBER_TABLE
190: , a7 out nocopy JTF_NUMBER_TABLE
191: , a8 out nocopy JTF_DATE_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_DATE_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
190: , a7 out nocopy JTF_NUMBER_TABLE
191: , a8 out nocopy JTF_DATE_TABLE
192: , a9 out nocopy JTF_NUMBER_TABLE
193: , a10 out nocopy JTF_DATE_TABLE
194: , a11 out nocopy JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_VARCHAR2_TABLE_100();
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_DATE_TABLE();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_DATE_TABLE();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_DATE_TABLE();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_DATE_TABLE();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_DATE_TABLE();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_NUMBER_TABLE();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_100();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_100();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_VARCHAR2_TABLE_100();
214: a2 := JTF_VARCHAR2_TABLE_100();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_VARCHAR2_TABLE_100();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_NUMBER_TABLE();
220: a8 := JTF_DATE_TABLE();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_DATE_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_VARCHAR2_TABLE_100();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_NUMBER_TABLE();
220: a8 := JTF_DATE_TABLE();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_DATE_TABLE();
223: a11 := JTF_NUMBER_TABLE();
217: a5 := JTF_VARCHAR2_TABLE_100();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_NUMBER_TABLE();
220: a8 := JTF_DATE_TABLE();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_DATE_TABLE();
223: a11 := JTF_NUMBER_TABLE();
224: if t.count > 0 then
225: a0.extend(t.count);
219: a7 := JTF_NUMBER_TABLE();
220: a8 := JTF_DATE_TABLE();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_DATE_TABLE();
223: a11 := JTF_NUMBER_TABLE();
224: if t.count > 0 then
225: a0.extend(t.count);
226: a1.extend(t.count);
227: a2.extend(t.count);
350: , p_init_msg_list VARCHAR2
351: , x_return_status out nocopy VARCHAR2
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_100
351: , x_return_status out nocopy VARCHAR2
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_VARCHAR2_TABLE_100
356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_VARCHAR2_TABLE_100
360: , p5_a6 JTF_NUMBER_TABLE
361: , p5_a7 JTF_NUMBER_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_VARCHAR2_TABLE_100
360: , p5_a6 JTF_NUMBER_TABLE
361: , p5_a7 JTF_NUMBER_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
359: , p5_a5 JTF_VARCHAR2_TABLE_100
360: , p5_a6 JTF_NUMBER_TABLE
361: , p5_a7 JTF_NUMBER_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
361: , p5_a7 JTF_NUMBER_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_NUMBER_TABLE
373: , p6_a7 out nocopy JTF_NUMBER_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_NUMBER_TABLE
376: , p6_a10 out nocopy JTF_DATE_TABLE
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_NUMBER_TABLE
373: , p6_a7 out nocopy JTF_NUMBER_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_NUMBER_TABLE
376: , p6_a10 out nocopy JTF_DATE_TABLE
377: , p6_a11 out nocopy JTF_NUMBER_TABLE
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_NUMBER_TABLE
373: , p6_a7 out nocopy JTF_NUMBER_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_NUMBER_TABLE
376: , p6_a10 out nocopy JTF_DATE_TABLE
377: , p6_a11 out nocopy JTF_NUMBER_TABLE
378: )
379:
373: , p6_a7 out nocopy JTF_NUMBER_TABLE
374: , p6_a8 out nocopy JTF_DATE_TABLE
375: , p6_a9 out nocopy JTF_NUMBER_TABLE
376: , p6_a10 out nocopy JTF_DATE_TABLE
377: , p6_a11 out nocopy JTF_NUMBER_TABLE
378: )
379:
380: as
381: ddp_alsv_tbl okl_als_pvt.alsv_tbl_type;
498: , p_init_msg_list VARCHAR2
499: , x_return_status out nocopy VARCHAR2
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_VARCHAR2_TABLE_100
505: , p5_a3 JTF_VARCHAR2_TABLE_100
506: , p5_a4 JTF_VARCHAR2_TABLE_100
499: , x_return_status out nocopy VARCHAR2
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_VARCHAR2_TABLE_100
505: , p5_a3 JTF_VARCHAR2_TABLE_100
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
504: , p5_a2 JTF_VARCHAR2_TABLE_100
505: , p5_a3 JTF_VARCHAR2_TABLE_100
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_NUMBER_TABLE
509: , p5_a7 JTF_NUMBER_TABLE
510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_NUMBER_TABLE
512: , p5_a10 JTF_DATE_TABLE
505: , p5_a3 JTF_VARCHAR2_TABLE_100
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_NUMBER_TABLE
509: , p5_a7 JTF_NUMBER_TABLE
510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_NUMBER_TABLE
512: , p5_a10 JTF_DATE_TABLE
513: , p5_a11 JTF_NUMBER_TABLE
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_NUMBER_TABLE
509: , p5_a7 JTF_NUMBER_TABLE
510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_NUMBER_TABLE
512: , p5_a10 JTF_DATE_TABLE
513: , p5_a11 JTF_NUMBER_TABLE
514: )
515:
509: , p5_a7 JTF_NUMBER_TABLE
510: , p5_a8 JTF_DATE_TABLE
511: , p5_a9 JTF_NUMBER_TABLE
512: , p5_a10 JTF_DATE_TABLE
513: , p5_a11 JTF_NUMBER_TABLE
514: )
515:
516: as
517: ddp_alsv_tbl okl_als_pvt.alsv_tbl_type;
645: , p_init_msg_list VARCHAR2
646: , x_return_status out nocopy VARCHAR2
647: , x_msg_count out nocopy NUMBER
648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
646: , x_return_status out nocopy VARCHAR2
647: , x_msg_count out nocopy NUMBER
648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_VARCHAR2_TABLE_100
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_VARCHAR2_TABLE_100
655: , p5_a6 JTF_NUMBER_TABLE
656: , p5_a7 JTF_NUMBER_TABLE
657: , p5_a8 JTF_DATE_TABLE
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_VARCHAR2_TABLE_100
655: , p5_a6 JTF_NUMBER_TABLE
656: , p5_a7 JTF_NUMBER_TABLE
657: , p5_a8 JTF_DATE_TABLE
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
654: , p5_a5 JTF_VARCHAR2_TABLE_100
655: , p5_a6 JTF_NUMBER_TABLE
656: , p5_a7 JTF_NUMBER_TABLE
657: , p5_a8 JTF_DATE_TABLE
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
656: , p5_a7 JTF_NUMBER_TABLE
657: , p5_a8 JTF_DATE_TABLE
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
657: , p5_a8 JTF_DATE_TABLE
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
658: , p5_a9 JTF_NUMBER_TABLE
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a6 out nocopy JTF_NUMBER_TABLE
668: , p6_a7 out nocopy JTF_NUMBER_TABLE
669: , p6_a8 out nocopy JTF_DATE_TABLE
670: , p6_a9 out nocopy JTF_NUMBER_TABLE
671: , p6_a10 out nocopy JTF_DATE_TABLE
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a6 out nocopy JTF_NUMBER_TABLE
668: , p6_a7 out nocopy JTF_NUMBER_TABLE
669: , p6_a8 out nocopy JTF_DATE_TABLE
670: , p6_a9 out nocopy JTF_NUMBER_TABLE
671: , p6_a10 out nocopy JTF_DATE_TABLE
672: , p6_a11 out nocopy JTF_NUMBER_TABLE
666: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a6 out nocopy JTF_NUMBER_TABLE
668: , p6_a7 out nocopy JTF_NUMBER_TABLE
669: , p6_a8 out nocopy JTF_DATE_TABLE
670: , p6_a9 out nocopy JTF_NUMBER_TABLE
671: , p6_a10 out nocopy JTF_DATE_TABLE
672: , p6_a11 out nocopy JTF_NUMBER_TABLE
673: )
674:
668: , p6_a7 out nocopy JTF_NUMBER_TABLE
669: , p6_a8 out nocopy JTF_DATE_TABLE
670: , p6_a9 out nocopy JTF_NUMBER_TABLE
671: , p6_a10 out nocopy JTF_DATE_TABLE
672: , p6_a11 out nocopy JTF_NUMBER_TABLE
673: )
674:
675: as
676: ddp_alsv_tbl okl_als_pvt.alsv_tbl_type;
793: , p_init_msg_list VARCHAR2
794: , x_return_status out nocopy VARCHAR2
795: , x_msg_count out nocopy NUMBER
796: , x_msg_data out nocopy VARCHAR2
797: , p5_a0 JTF_NUMBER_TABLE
798: , p5_a1 JTF_NUMBER_TABLE
799: , p5_a2 JTF_VARCHAR2_TABLE_100
800: , p5_a3 JTF_VARCHAR2_TABLE_100
801: , p5_a4 JTF_VARCHAR2_TABLE_100
794: , x_return_status out nocopy VARCHAR2
795: , x_msg_count out nocopy NUMBER
796: , x_msg_data out nocopy VARCHAR2
797: , p5_a0 JTF_NUMBER_TABLE
798: , p5_a1 JTF_NUMBER_TABLE
799: , p5_a2 JTF_VARCHAR2_TABLE_100
800: , p5_a3 JTF_VARCHAR2_TABLE_100
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_VARCHAR2_TABLE_100
799: , p5_a2 JTF_VARCHAR2_TABLE_100
800: , p5_a3 JTF_VARCHAR2_TABLE_100
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_VARCHAR2_TABLE_100
803: , p5_a6 JTF_NUMBER_TABLE
804: , p5_a7 JTF_NUMBER_TABLE
805: , p5_a8 JTF_DATE_TABLE
806: , p5_a9 JTF_NUMBER_TABLE
807: , p5_a10 JTF_DATE_TABLE
800: , p5_a3 JTF_VARCHAR2_TABLE_100
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_VARCHAR2_TABLE_100
803: , p5_a6 JTF_NUMBER_TABLE
804: , p5_a7 JTF_NUMBER_TABLE
805: , p5_a8 JTF_DATE_TABLE
806: , p5_a9 JTF_NUMBER_TABLE
807: , p5_a10 JTF_DATE_TABLE
808: , p5_a11 JTF_NUMBER_TABLE
802: , p5_a5 JTF_VARCHAR2_TABLE_100
803: , p5_a6 JTF_NUMBER_TABLE
804: , p5_a7 JTF_NUMBER_TABLE
805: , p5_a8 JTF_DATE_TABLE
806: , p5_a9 JTF_NUMBER_TABLE
807: , p5_a10 JTF_DATE_TABLE
808: , p5_a11 JTF_NUMBER_TABLE
809: )
810:
804: , p5_a7 JTF_NUMBER_TABLE
805: , p5_a8 JTF_DATE_TABLE
806: , p5_a9 JTF_NUMBER_TABLE
807: , p5_a10 JTF_DATE_TABLE
808: , p5_a11 JTF_NUMBER_TABLE
809: )
810:
811: as
812: ddp_alsv_tbl okl_als_pvt.alsv_tbl_type;
912: , p_init_msg_list VARCHAR2
913: , x_return_status out nocopy VARCHAR2
914: , x_msg_count out nocopy NUMBER
915: , x_msg_data out nocopy VARCHAR2
916: , p5_a0 JTF_NUMBER_TABLE
917: , p5_a1 JTF_NUMBER_TABLE
918: , p5_a2 JTF_VARCHAR2_TABLE_100
919: , p5_a3 JTF_VARCHAR2_TABLE_100
920: , p5_a4 JTF_VARCHAR2_TABLE_100
913: , x_return_status out nocopy VARCHAR2
914: , x_msg_count out nocopy NUMBER
915: , x_msg_data out nocopy VARCHAR2
916: , p5_a0 JTF_NUMBER_TABLE
917: , p5_a1 JTF_NUMBER_TABLE
918: , p5_a2 JTF_VARCHAR2_TABLE_100
919: , p5_a3 JTF_VARCHAR2_TABLE_100
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_VARCHAR2_TABLE_100
918: , p5_a2 JTF_VARCHAR2_TABLE_100
919: , p5_a3 JTF_VARCHAR2_TABLE_100
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_VARCHAR2_TABLE_100
922: , p5_a6 JTF_NUMBER_TABLE
923: , p5_a7 JTF_NUMBER_TABLE
924: , p5_a8 JTF_DATE_TABLE
925: , p5_a9 JTF_NUMBER_TABLE
926: , p5_a10 JTF_DATE_TABLE
919: , p5_a3 JTF_VARCHAR2_TABLE_100
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_VARCHAR2_TABLE_100
922: , p5_a6 JTF_NUMBER_TABLE
923: , p5_a7 JTF_NUMBER_TABLE
924: , p5_a8 JTF_DATE_TABLE
925: , p5_a9 JTF_NUMBER_TABLE
926: , p5_a10 JTF_DATE_TABLE
927: , p5_a11 JTF_NUMBER_TABLE
921: , p5_a5 JTF_VARCHAR2_TABLE_100
922: , p5_a6 JTF_NUMBER_TABLE
923: , p5_a7 JTF_NUMBER_TABLE
924: , p5_a8 JTF_DATE_TABLE
925: , p5_a9 JTF_NUMBER_TABLE
926: , p5_a10 JTF_DATE_TABLE
927: , p5_a11 JTF_NUMBER_TABLE
928: )
929:
923: , p5_a7 JTF_NUMBER_TABLE
924: , p5_a8 JTF_DATE_TABLE
925: , p5_a9 JTF_NUMBER_TABLE
926: , p5_a10 JTF_DATE_TABLE
927: , p5_a11 JTF_NUMBER_TABLE
928: )
929:
930: as
931: ddp_alsv_tbl okl_als_pvt.alsv_tbl_type;