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_atl_pvt.atl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
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_atl_pvt.atl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_2000
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_500
35: , a13 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_500
35: , a13 JTF_VARCHAR2_TABLE_500
36: , a14 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if a0 is not null and a0.count > 0 then
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_NUMBER_TABLE
114: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_NUMBER_TABLE
114: , a11 out nocopy JTF_VARCHAR2_TABLE_100
115: , a12 out nocopy JTF_VARCHAR2_TABLE_500
116: , a13 out nocopy JTF_VARCHAR2_TABLE_500
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_NUMBER_TABLE
114: , a11 out nocopy JTF_VARCHAR2_TABLE_100
115: , a12 out nocopy JTF_VARCHAR2_TABLE_500
116: , a13 out nocopy JTF_VARCHAR2_TABLE_500
117: , a14 out nocopy JTF_VARCHAR2_TABLE_500
126: , a23 out nocopy JTF_VARCHAR2_TABLE_500
127: , a24 out nocopy JTF_VARCHAR2_TABLE_500
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_NUMBER_TABLE();
143: a4 := JTF_VARCHAR2_TABLE_100();
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_NUMBER_TABLE();
143: a4 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_100();
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_NUMBER_TABLE();
143: a4 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_NUMBER_TABLE();
143: a4 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_NUMBER_TABLE();
142: a3 := JTF_NUMBER_TABLE();
143: a4 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_VARCHAR2_TABLE_2000();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_NUMBER_TABLE();
150: a11 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_VARCHAR2_TABLE_2000();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_NUMBER_TABLE();
150: a11 := JTF_VARCHAR2_TABLE_100();
151: a12 := JTF_VARCHAR2_TABLE_500();
152: a13 := JTF_VARCHAR2_TABLE_500();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_VARCHAR2_TABLE_2000();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_NUMBER_TABLE();
150: a11 := JTF_VARCHAR2_TABLE_100();
151: a12 := JTF_VARCHAR2_TABLE_500();
152: a13 := JTF_VARCHAR2_TABLE_500();
153: a14 := JTF_VARCHAR2_TABLE_500();
162: a23 := JTF_VARCHAR2_TABLE_500();
163: a24 := JTF_VARCHAR2_TABLE_500();
164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_NUMBER_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_VARCHAR2_TABLE_100();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_VARCHAR2_TABLE_100();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_NUMBER_TABLE();
175: a3 := JTF_NUMBER_TABLE();
176: a4 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_VARCHAR2_TABLE_2000();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_NUMBER_TABLE();
183: a11 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_VARCHAR2_TABLE_2000();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_NUMBER_TABLE();
183: a11 := JTF_VARCHAR2_TABLE_100();
184: a12 := JTF_VARCHAR2_TABLE_500();
185: a13 := JTF_VARCHAR2_TABLE_500();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_VARCHAR2_TABLE_2000();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_NUMBER_TABLE();
183: a11 := JTF_VARCHAR2_TABLE_100();
184: a12 := JTF_VARCHAR2_TABLE_500();
185: a13 := JTF_VARCHAR2_TABLE_500();
186: a14 := JTF_VARCHAR2_TABLE_500();
195: a23 := JTF_VARCHAR2_TABLE_500();
196: a24 := JTF_VARCHAR2_TABLE_500();
197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: a1.extend(t.count);
207: a2.extend(t.count);
278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_100
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_100
288: , a6 JTF_NUMBER_TABLE
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_100
288: , a6 JTF_NUMBER_TABLE
289: , a7 JTF_VARCHAR2_TABLE_2000
290: , a8 JTF_NUMBER_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_100
288: , a6 JTF_NUMBER_TABLE
289: , a7 JTF_VARCHAR2_TABLE_2000
290: , a8 JTF_NUMBER_TABLE
291: , a9 JTF_VARCHAR2_TABLE_100
292: , a10 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_100
288: , a6 JTF_NUMBER_TABLE
289: , a7 JTF_VARCHAR2_TABLE_2000
290: , a8 JTF_NUMBER_TABLE
291: , a9 JTF_VARCHAR2_TABLE_100
292: , a10 JTF_VARCHAR2_TABLE_100
293: , a11 JTF_VARCHAR2_TABLE_500
294: , a12 JTF_VARCHAR2_TABLE_500
304: , a22 JTF_VARCHAR2_TABLE_500
305: , a23 JTF_VARCHAR2_TABLE_500
306: , a24 JTF_VARCHAR2_TABLE_500
307: , a25 JTF_VARCHAR2_TABLE_500
308: , a26 JTF_NUMBER_TABLE
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_NUMBER_TABLE
305: , a23 JTF_VARCHAR2_TABLE_500
306: , a24 JTF_VARCHAR2_TABLE_500
307: , a25 JTF_VARCHAR2_TABLE_500
308: , a26 JTF_NUMBER_TABLE
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_NUMBER_TABLE
313: , a31 JTF_DATE_TABLE
306: , a24 JTF_VARCHAR2_TABLE_500
307: , a25 JTF_VARCHAR2_TABLE_500
308: , a26 JTF_NUMBER_TABLE
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_NUMBER_TABLE
313: , a31 JTF_DATE_TABLE
314: , a32 JTF_NUMBER_TABLE
308: , a26 JTF_NUMBER_TABLE
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_NUMBER_TABLE
313: , a31 JTF_DATE_TABLE
314: , a32 JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_NUMBER_TABLE
313: , a31 JTF_DATE_TABLE
314: , a32 JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if a0 is not null and a0.count > 0 then
361: end loop;
362: end if;
363: end if;
364: end rosetta_table_copy_in_p5;
365: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_NUMBER_TABLE
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
362: end if;
363: end if;
364: end rosetta_table_copy_in_p5;
365: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_NUMBER_TABLE
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
370: , a5 out nocopy JTF_VARCHAR2_TABLE_100
363: end if;
364: end rosetta_table_copy_in_p5;
365: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_NUMBER_TABLE
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
370: , a5 out nocopy JTF_VARCHAR2_TABLE_100
371: , a6 out nocopy JTF_NUMBER_TABLE
365: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_NUMBER_TABLE
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
370: , a5 out nocopy JTF_VARCHAR2_TABLE_100
371: , a6 out nocopy JTF_NUMBER_TABLE
372: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
373: , a8 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_NUMBER_TABLE
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
370: , a5 out nocopy JTF_VARCHAR2_TABLE_100
371: , a6 out nocopy JTF_NUMBER_TABLE
372: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
373: , a8 out nocopy JTF_NUMBER_TABLE
374: , a9 out nocopy JTF_VARCHAR2_TABLE_100
375: , a10 out nocopy JTF_VARCHAR2_TABLE_100
369: , a4 out nocopy JTF_NUMBER_TABLE
370: , a5 out nocopy JTF_VARCHAR2_TABLE_100
371: , a6 out nocopy JTF_NUMBER_TABLE
372: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
373: , a8 out nocopy JTF_NUMBER_TABLE
374: , a9 out nocopy JTF_VARCHAR2_TABLE_100
375: , a10 out nocopy JTF_VARCHAR2_TABLE_100
376: , a11 out nocopy JTF_VARCHAR2_TABLE_500
377: , a12 out nocopy JTF_VARCHAR2_TABLE_500
387: , a22 out nocopy JTF_VARCHAR2_TABLE_500
388: , a23 out nocopy JTF_VARCHAR2_TABLE_500
389: , a24 out nocopy JTF_VARCHAR2_TABLE_500
390: , a25 out nocopy JTF_VARCHAR2_TABLE_500
391: , a26 out nocopy JTF_NUMBER_TABLE
392: , a27 out nocopy JTF_NUMBER_TABLE
393: , a28 out nocopy JTF_NUMBER_TABLE
394: , a29 out nocopy JTF_DATE_TABLE
395: , a30 out nocopy JTF_NUMBER_TABLE
388: , a23 out nocopy JTF_VARCHAR2_TABLE_500
389: , a24 out nocopy JTF_VARCHAR2_TABLE_500
390: , a25 out nocopy JTF_VARCHAR2_TABLE_500
391: , a26 out nocopy JTF_NUMBER_TABLE
392: , a27 out nocopy JTF_NUMBER_TABLE
393: , a28 out nocopy JTF_NUMBER_TABLE
394: , a29 out nocopy JTF_DATE_TABLE
395: , a30 out nocopy JTF_NUMBER_TABLE
396: , a31 out nocopy JTF_DATE_TABLE
389: , a24 out nocopy JTF_VARCHAR2_TABLE_500
390: , a25 out nocopy JTF_VARCHAR2_TABLE_500
391: , a26 out nocopy JTF_NUMBER_TABLE
392: , a27 out nocopy JTF_NUMBER_TABLE
393: , a28 out nocopy JTF_NUMBER_TABLE
394: , a29 out nocopy JTF_DATE_TABLE
395: , a30 out nocopy JTF_NUMBER_TABLE
396: , a31 out nocopy JTF_DATE_TABLE
397: , a32 out nocopy JTF_NUMBER_TABLE
391: , a26 out nocopy JTF_NUMBER_TABLE
392: , a27 out nocopy JTF_NUMBER_TABLE
393: , a28 out nocopy JTF_NUMBER_TABLE
394: , a29 out nocopy JTF_DATE_TABLE
395: , a30 out nocopy JTF_NUMBER_TABLE
396: , a31 out nocopy JTF_DATE_TABLE
397: , a32 out nocopy JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
393: , a28 out nocopy JTF_NUMBER_TABLE
394: , a29 out nocopy JTF_DATE_TABLE
395: , a30 out nocopy JTF_NUMBER_TABLE
396: , a31 out nocopy JTF_DATE_TABLE
397: , a32 out nocopy JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
407: a5 := JTF_VARCHAR2_TABLE_100();
400: begin
401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
407: a5 := JTF_VARCHAR2_TABLE_100();
408: a6 := JTF_NUMBER_TABLE();
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
407: a5 := JTF_VARCHAR2_TABLE_100();
408: a6 := JTF_NUMBER_TABLE();
409: a7 := JTF_VARCHAR2_TABLE_2000();
410: a8 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
407: a5 := JTF_VARCHAR2_TABLE_100();
408: a6 := JTF_NUMBER_TABLE();
409: a7 := JTF_VARCHAR2_TABLE_2000();
410: a8 := JTF_NUMBER_TABLE();
411: a9 := JTF_VARCHAR2_TABLE_100();
412: a10 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_NUMBER_TABLE();
407: a5 := JTF_VARCHAR2_TABLE_100();
408: a6 := JTF_NUMBER_TABLE();
409: a7 := JTF_VARCHAR2_TABLE_2000();
410: a8 := JTF_NUMBER_TABLE();
411: a9 := JTF_VARCHAR2_TABLE_100();
412: a10 := JTF_VARCHAR2_TABLE_100();
413: a11 := JTF_VARCHAR2_TABLE_500();
414: a12 := JTF_VARCHAR2_TABLE_500();
424: a22 := JTF_VARCHAR2_TABLE_500();
425: a23 := JTF_VARCHAR2_TABLE_500();
426: a24 := JTF_VARCHAR2_TABLE_500();
427: a25 := JTF_VARCHAR2_TABLE_500();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_NUMBER_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
425: a23 := JTF_VARCHAR2_TABLE_500();
426: a24 := JTF_VARCHAR2_TABLE_500();
427: a25 := JTF_VARCHAR2_TABLE_500();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_NUMBER_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
426: a24 := JTF_VARCHAR2_TABLE_500();
427: a25 := JTF_VARCHAR2_TABLE_500();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_NUMBER_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
434: a32 := JTF_NUMBER_TABLE();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_NUMBER_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
434: a32 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
434: a32 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
434: a32 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
433: a31 := JTF_DATE_TABLE();
434: a32 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_VARCHAR2_TABLE_100();
434: a32 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_VARCHAR2_TABLE_100();
442: a6 := JTF_NUMBER_TABLE();
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_VARCHAR2_TABLE_100();
442: a6 := JTF_NUMBER_TABLE();
443: a7 := JTF_VARCHAR2_TABLE_2000();
444: a8 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_VARCHAR2_TABLE_100();
442: a6 := JTF_NUMBER_TABLE();
443: a7 := JTF_VARCHAR2_TABLE_2000();
444: a8 := JTF_NUMBER_TABLE();
445: a9 := JTF_VARCHAR2_TABLE_100();
446: a10 := JTF_VARCHAR2_TABLE_100();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_VARCHAR2_TABLE_100();
442: a6 := JTF_NUMBER_TABLE();
443: a7 := JTF_VARCHAR2_TABLE_2000();
444: a8 := JTF_NUMBER_TABLE();
445: a9 := JTF_VARCHAR2_TABLE_100();
446: a10 := JTF_VARCHAR2_TABLE_100();
447: a11 := JTF_VARCHAR2_TABLE_500();
448: a12 := JTF_VARCHAR2_TABLE_500();
458: a22 := JTF_VARCHAR2_TABLE_500();
459: a23 := JTF_VARCHAR2_TABLE_500();
460: a24 := JTF_VARCHAR2_TABLE_500();
461: a25 := JTF_VARCHAR2_TABLE_500();
462: a26 := JTF_NUMBER_TABLE();
463: a27 := JTF_NUMBER_TABLE();
464: a28 := JTF_NUMBER_TABLE();
465: a29 := JTF_DATE_TABLE();
466: a30 := JTF_NUMBER_TABLE();
459: a23 := JTF_VARCHAR2_TABLE_500();
460: a24 := JTF_VARCHAR2_TABLE_500();
461: a25 := JTF_VARCHAR2_TABLE_500();
462: a26 := JTF_NUMBER_TABLE();
463: a27 := JTF_NUMBER_TABLE();
464: a28 := JTF_NUMBER_TABLE();
465: a29 := JTF_DATE_TABLE();
466: a30 := JTF_NUMBER_TABLE();
467: a31 := JTF_DATE_TABLE();
460: a24 := JTF_VARCHAR2_TABLE_500();
461: a25 := JTF_VARCHAR2_TABLE_500();
462: a26 := JTF_NUMBER_TABLE();
463: a27 := JTF_NUMBER_TABLE();
464: a28 := JTF_NUMBER_TABLE();
465: a29 := JTF_DATE_TABLE();
466: a30 := JTF_NUMBER_TABLE();
467: a31 := JTF_DATE_TABLE();
468: a32 := JTF_NUMBER_TABLE();
462: a26 := JTF_NUMBER_TABLE();
463: a27 := JTF_NUMBER_TABLE();
464: a28 := JTF_NUMBER_TABLE();
465: a29 := JTF_DATE_TABLE();
466: a30 := JTF_NUMBER_TABLE();
467: a31 := JTF_DATE_TABLE();
468: a32 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);
464: a28 := JTF_NUMBER_TABLE();
465: a29 := JTF_DATE_TABLE();
466: a30 := JTF_NUMBER_TABLE();
467: a31 := JTF_DATE_TABLE();
468: a32 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);
471: a1.extend(t.count);
472: a2.extend(t.count);
721: , p_init_msg_list VARCHAR2
722: , x_return_status out nocopy VARCHAR2
723: , x_msg_count out nocopy NUMBER
724: , x_msg_data out nocopy VARCHAR2
725: , p5_a0 JTF_NUMBER_TABLE
726: , p5_a1 JTF_NUMBER_TABLE
727: , p5_a2 JTF_NUMBER_TABLE
728: , p5_a3 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
722: , x_return_status out nocopy VARCHAR2
723: , x_msg_count out nocopy NUMBER
724: , x_msg_data out nocopy VARCHAR2
725: , p5_a0 JTF_NUMBER_TABLE
726: , p5_a1 JTF_NUMBER_TABLE
727: , p5_a2 JTF_NUMBER_TABLE
728: , p5_a3 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
730: , p5_a5 JTF_VARCHAR2_TABLE_100
723: , x_msg_count out nocopy NUMBER
724: , x_msg_data out nocopy VARCHAR2
725: , p5_a0 JTF_NUMBER_TABLE
726: , p5_a1 JTF_NUMBER_TABLE
727: , p5_a2 JTF_NUMBER_TABLE
728: , p5_a3 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
730: , p5_a5 JTF_VARCHAR2_TABLE_100
731: , p5_a6 JTF_NUMBER_TABLE
725: , p5_a0 JTF_NUMBER_TABLE
726: , p5_a1 JTF_NUMBER_TABLE
727: , p5_a2 JTF_NUMBER_TABLE
728: , p5_a3 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
730: , p5_a5 JTF_VARCHAR2_TABLE_100
731: , p5_a6 JTF_NUMBER_TABLE
732: , p5_a7 JTF_VARCHAR2_TABLE_2000
733: , p5_a8 JTF_NUMBER_TABLE
727: , p5_a2 JTF_NUMBER_TABLE
728: , p5_a3 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
730: , p5_a5 JTF_VARCHAR2_TABLE_100
731: , p5_a6 JTF_NUMBER_TABLE
732: , p5_a7 JTF_VARCHAR2_TABLE_2000
733: , p5_a8 JTF_NUMBER_TABLE
734: , p5_a9 JTF_VARCHAR2_TABLE_100
735: , p5_a10 JTF_VARCHAR2_TABLE_100
729: , p5_a4 JTF_NUMBER_TABLE
730: , p5_a5 JTF_VARCHAR2_TABLE_100
731: , p5_a6 JTF_NUMBER_TABLE
732: , p5_a7 JTF_VARCHAR2_TABLE_2000
733: , p5_a8 JTF_NUMBER_TABLE
734: , p5_a9 JTF_VARCHAR2_TABLE_100
735: , p5_a10 JTF_VARCHAR2_TABLE_100
736: , p5_a11 JTF_VARCHAR2_TABLE_500
737: , p5_a12 JTF_VARCHAR2_TABLE_500
747: , p5_a22 JTF_VARCHAR2_TABLE_500
748: , p5_a23 JTF_VARCHAR2_TABLE_500
749: , p5_a24 JTF_VARCHAR2_TABLE_500
750: , p5_a25 JTF_VARCHAR2_TABLE_500
751: , p5_a26 JTF_NUMBER_TABLE
752: , p5_a27 JTF_NUMBER_TABLE
753: , p5_a28 JTF_NUMBER_TABLE
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
748: , p5_a23 JTF_VARCHAR2_TABLE_500
749: , p5_a24 JTF_VARCHAR2_TABLE_500
750: , p5_a25 JTF_VARCHAR2_TABLE_500
751: , p5_a26 JTF_NUMBER_TABLE
752: , p5_a27 JTF_NUMBER_TABLE
753: , p5_a28 JTF_NUMBER_TABLE
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
749: , p5_a24 JTF_VARCHAR2_TABLE_500
750: , p5_a25 JTF_VARCHAR2_TABLE_500
751: , p5_a26 JTF_NUMBER_TABLE
752: , p5_a27 JTF_NUMBER_TABLE
753: , p5_a28 JTF_NUMBER_TABLE
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
751: , p5_a26 JTF_NUMBER_TABLE
752: , p5_a27 JTF_NUMBER_TABLE
753: , p5_a28 JTF_NUMBER_TABLE
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
753: , p5_a28 JTF_NUMBER_TABLE
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
754: , p5_a29 JTF_DATE_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
755: , p5_a30 JTF_NUMBER_TABLE
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
763: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
756: , p5_a31 JTF_DATE_TABLE
757: , p5_a32 JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
763: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a6 out nocopy JTF_NUMBER_TABLE
758: , p6_a0 out nocopy JTF_NUMBER_TABLE
759: , p6_a1 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
763: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a6 out nocopy JTF_NUMBER_TABLE
765: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
766: , p6_a8 out nocopy JTF_NUMBER_TABLE
760: , p6_a2 out nocopy JTF_NUMBER_TABLE
761: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
763: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a6 out nocopy JTF_NUMBER_TABLE
765: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
766: , p6_a8 out nocopy JTF_NUMBER_TABLE
767: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
762: , p6_a4 out nocopy JTF_NUMBER_TABLE
763: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a6 out nocopy JTF_NUMBER_TABLE
765: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
766: , p6_a8 out nocopy JTF_NUMBER_TABLE
767: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
769: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
770: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
780: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
781: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
782: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
783: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a26 out nocopy JTF_NUMBER_TABLE
785: , p6_a27 out nocopy JTF_NUMBER_TABLE
786: , p6_a28 out nocopy JTF_NUMBER_TABLE
787: , p6_a29 out nocopy JTF_DATE_TABLE
788: , p6_a30 out nocopy JTF_NUMBER_TABLE
781: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
782: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
783: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a26 out nocopy JTF_NUMBER_TABLE
785: , p6_a27 out nocopy JTF_NUMBER_TABLE
786: , p6_a28 out nocopy JTF_NUMBER_TABLE
787: , p6_a29 out nocopy JTF_DATE_TABLE
788: , p6_a30 out nocopy JTF_NUMBER_TABLE
789: , p6_a31 out nocopy JTF_DATE_TABLE
782: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
783: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
784: , p6_a26 out nocopy JTF_NUMBER_TABLE
785: , p6_a27 out nocopy JTF_NUMBER_TABLE
786: , p6_a28 out nocopy JTF_NUMBER_TABLE
787: , p6_a29 out nocopy JTF_DATE_TABLE
788: , p6_a30 out nocopy JTF_NUMBER_TABLE
789: , p6_a31 out nocopy JTF_DATE_TABLE
790: , p6_a32 out nocopy JTF_NUMBER_TABLE
784: , p6_a26 out nocopy JTF_NUMBER_TABLE
785: , p6_a27 out nocopy JTF_NUMBER_TABLE
786: , p6_a28 out nocopy JTF_NUMBER_TABLE
787: , p6_a29 out nocopy JTF_DATE_TABLE
788: , p6_a30 out nocopy JTF_NUMBER_TABLE
789: , p6_a31 out nocopy JTF_DATE_TABLE
790: , p6_a32 out nocopy JTF_NUMBER_TABLE
791: )
792:
786: , p6_a28 out nocopy JTF_NUMBER_TABLE
787: , p6_a29 out nocopy JTF_DATE_TABLE
788: , p6_a30 out nocopy JTF_NUMBER_TABLE
789: , p6_a31 out nocopy JTF_DATE_TABLE
790: , p6_a32 out nocopy JTF_NUMBER_TABLE
791: )
792:
793: as
794: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
995: , p_init_msg_list VARCHAR2
996: , x_return_status out nocopy VARCHAR2
997: , x_msg_count out nocopy NUMBER
998: , x_msg_data out nocopy VARCHAR2
999: , p5_a0 JTF_NUMBER_TABLE
1000: , p5_a1 JTF_NUMBER_TABLE
1001: , p5_a2 JTF_NUMBER_TABLE
1002: , p5_a3 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
996: , x_return_status out nocopy VARCHAR2
997: , x_msg_count out nocopy NUMBER
998: , x_msg_data out nocopy VARCHAR2
999: , p5_a0 JTF_NUMBER_TABLE
1000: , p5_a1 JTF_NUMBER_TABLE
1001: , p5_a2 JTF_NUMBER_TABLE
1002: , p5_a3 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
1004: , p5_a5 JTF_VARCHAR2_TABLE_100
997: , x_msg_count out nocopy NUMBER
998: , x_msg_data out nocopy VARCHAR2
999: , p5_a0 JTF_NUMBER_TABLE
1000: , p5_a1 JTF_NUMBER_TABLE
1001: , p5_a2 JTF_NUMBER_TABLE
1002: , p5_a3 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
1004: , p5_a5 JTF_VARCHAR2_TABLE_100
1005: , p5_a6 JTF_NUMBER_TABLE
999: , p5_a0 JTF_NUMBER_TABLE
1000: , p5_a1 JTF_NUMBER_TABLE
1001: , p5_a2 JTF_NUMBER_TABLE
1002: , p5_a3 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
1004: , p5_a5 JTF_VARCHAR2_TABLE_100
1005: , p5_a6 JTF_NUMBER_TABLE
1006: , p5_a7 JTF_VARCHAR2_TABLE_2000
1007: , p5_a8 JTF_NUMBER_TABLE
1001: , p5_a2 JTF_NUMBER_TABLE
1002: , p5_a3 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
1004: , p5_a5 JTF_VARCHAR2_TABLE_100
1005: , p5_a6 JTF_NUMBER_TABLE
1006: , p5_a7 JTF_VARCHAR2_TABLE_2000
1007: , p5_a8 JTF_NUMBER_TABLE
1008: , p5_a9 JTF_VARCHAR2_TABLE_100
1009: , p5_a10 JTF_VARCHAR2_TABLE_100
1003: , p5_a4 JTF_NUMBER_TABLE
1004: , p5_a5 JTF_VARCHAR2_TABLE_100
1005: , p5_a6 JTF_NUMBER_TABLE
1006: , p5_a7 JTF_VARCHAR2_TABLE_2000
1007: , p5_a8 JTF_NUMBER_TABLE
1008: , p5_a9 JTF_VARCHAR2_TABLE_100
1009: , p5_a10 JTF_VARCHAR2_TABLE_100
1010: , p5_a11 JTF_VARCHAR2_TABLE_500
1011: , p5_a12 JTF_VARCHAR2_TABLE_500
1021: , p5_a22 JTF_VARCHAR2_TABLE_500
1022: , p5_a23 JTF_VARCHAR2_TABLE_500
1023: , p5_a24 JTF_VARCHAR2_TABLE_500
1024: , p5_a25 JTF_VARCHAR2_TABLE_500
1025: , p5_a26 JTF_NUMBER_TABLE
1026: , p5_a27 JTF_NUMBER_TABLE
1027: , p5_a28 JTF_NUMBER_TABLE
1028: , p5_a29 JTF_DATE_TABLE
1029: , p5_a30 JTF_NUMBER_TABLE
1022: , p5_a23 JTF_VARCHAR2_TABLE_500
1023: , p5_a24 JTF_VARCHAR2_TABLE_500
1024: , p5_a25 JTF_VARCHAR2_TABLE_500
1025: , p5_a26 JTF_NUMBER_TABLE
1026: , p5_a27 JTF_NUMBER_TABLE
1027: , p5_a28 JTF_NUMBER_TABLE
1028: , p5_a29 JTF_DATE_TABLE
1029: , p5_a30 JTF_NUMBER_TABLE
1030: , p5_a31 JTF_DATE_TABLE
1023: , p5_a24 JTF_VARCHAR2_TABLE_500
1024: , p5_a25 JTF_VARCHAR2_TABLE_500
1025: , p5_a26 JTF_NUMBER_TABLE
1026: , p5_a27 JTF_NUMBER_TABLE
1027: , p5_a28 JTF_NUMBER_TABLE
1028: , p5_a29 JTF_DATE_TABLE
1029: , p5_a30 JTF_NUMBER_TABLE
1030: , p5_a31 JTF_DATE_TABLE
1031: , p5_a32 JTF_NUMBER_TABLE
1025: , p5_a26 JTF_NUMBER_TABLE
1026: , p5_a27 JTF_NUMBER_TABLE
1027: , p5_a28 JTF_NUMBER_TABLE
1028: , p5_a29 JTF_DATE_TABLE
1029: , p5_a30 JTF_NUMBER_TABLE
1030: , p5_a31 JTF_DATE_TABLE
1031: , p5_a32 JTF_NUMBER_TABLE
1032: )
1033:
1027: , p5_a28 JTF_NUMBER_TABLE
1028: , p5_a29 JTF_DATE_TABLE
1029: , p5_a30 JTF_NUMBER_TABLE
1030: , p5_a31 JTF_DATE_TABLE
1031: , p5_a32 JTF_NUMBER_TABLE
1032: )
1033:
1034: as
1035: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1268: , p_init_msg_list VARCHAR2
1269: , x_return_status out nocopy VARCHAR2
1270: , x_msg_count out nocopy NUMBER
1271: , x_msg_data out nocopy VARCHAR2
1272: , p5_a0 JTF_NUMBER_TABLE
1273: , p5_a1 JTF_NUMBER_TABLE
1274: , p5_a2 JTF_NUMBER_TABLE
1275: , p5_a3 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1269: , x_return_status out nocopy VARCHAR2
1270: , x_msg_count out nocopy NUMBER
1271: , x_msg_data out nocopy VARCHAR2
1272: , p5_a0 JTF_NUMBER_TABLE
1273: , p5_a1 JTF_NUMBER_TABLE
1274: , p5_a2 JTF_NUMBER_TABLE
1275: , p5_a3 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1277: , p5_a5 JTF_VARCHAR2_TABLE_100
1270: , x_msg_count out nocopy NUMBER
1271: , x_msg_data out nocopy VARCHAR2
1272: , p5_a0 JTF_NUMBER_TABLE
1273: , p5_a1 JTF_NUMBER_TABLE
1274: , p5_a2 JTF_NUMBER_TABLE
1275: , p5_a3 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1277: , p5_a5 JTF_VARCHAR2_TABLE_100
1278: , p5_a6 JTF_NUMBER_TABLE
1272: , p5_a0 JTF_NUMBER_TABLE
1273: , p5_a1 JTF_NUMBER_TABLE
1274: , p5_a2 JTF_NUMBER_TABLE
1275: , p5_a3 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1277: , p5_a5 JTF_VARCHAR2_TABLE_100
1278: , p5_a6 JTF_NUMBER_TABLE
1279: , p5_a7 JTF_VARCHAR2_TABLE_2000
1280: , p5_a8 JTF_NUMBER_TABLE
1274: , p5_a2 JTF_NUMBER_TABLE
1275: , p5_a3 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1277: , p5_a5 JTF_VARCHAR2_TABLE_100
1278: , p5_a6 JTF_NUMBER_TABLE
1279: , p5_a7 JTF_VARCHAR2_TABLE_2000
1280: , p5_a8 JTF_NUMBER_TABLE
1281: , p5_a9 JTF_VARCHAR2_TABLE_100
1282: , p5_a10 JTF_VARCHAR2_TABLE_100
1276: , p5_a4 JTF_NUMBER_TABLE
1277: , p5_a5 JTF_VARCHAR2_TABLE_100
1278: , p5_a6 JTF_NUMBER_TABLE
1279: , p5_a7 JTF_VARCHAR2_TABLE_2000
1280: , p5_a8 JTF_NUMBER_TABLE
1281: , p5_a9 JTF_VARCHAR2_TABLE_100
1282: , p5_a10 JTF_VARCHAR2_TABLE_100
1283: , p5_a11 JTF_VARCHAR2_TABLE_500
1284: , p5_a12 JTF_VARCHAR2_TABLE_500
1294: , p5_a22 JTF_VARCHAR2_TABLE_500
1295: , p5_a23 JTF_VARCHAR2_TABLE_500
1296: , p5_a24 JTF_VARCHAR2_TABLE_500
1297: , p5_a25 JTF_VARCHAR2_TABLE_500
1298: , p5_a26 JTF_NUMBER_TABLE
1299: , p5_a27 JTF_NUMBER_TABLE
1300: , p5_a28 JTF_NUMBER_TABLE
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1295: , p5_a23 JTF_VARCHAR2_TABLE_500
1296: , p5_a24 JTF_VARCHAR2_TABLE_500
1297: , p5_a25 JTF_VARCHAR2_TABLE_500
1298: , p5_a26 JTF_NUMBER_TABLE
1299: , p5_a27 JTF_NUMBER_TABLE
1300: , p5_a28 JTF_NUMBER_TABLE
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1296: , p5_a24 JTF_VARCHAR2_TABLE_500
1297: , p5_a25 JTF_VARCHAR2_TABLE_500
1298: , p5_a26 JTF_NUMBER_TABLE
1299: , p5_a27 JTF_NUMBER_TABLE
1300: , p5_a28 JTF_NUMBER_TABLE
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1298: , p5_a26 JTF_NUMBER_TABLE
1299: , p5_a27 JTF_NUMBER_TABLE
1300: , p5_a28 JTF_NUMBER_TABLE
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1300: , p5_a28 JTF_NUMBER_TABLE
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1301: , p5_a29 JTF_DATE_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1302: , p5_a30 JTF_NUMBER_TABLE
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1303: , p5_a31 JTF_DATE_TABLE
1304: , p5_a32 JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1311: , p6_a6 out nocopy JTF_NUMBER_TABLE
1305: , p6_a0 out nocopy JTF_NUMBER_TABLE
1306: , p6_a1 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1311: , p6_a6 out nocopy JTF_NUMBER_TABLE
1312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1313: , p6_a8 out nocopy JTF_NUMBER_TABLE
1307: , p6_a2 out nocopy JTF_NUMBER_TABLE
1308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1311: , p6_a6 out nocopy JTF_NUMBER_TABLE
1312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1313: , p6_a8 out nocopy JTF_NUMBER_TABLE
1314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p6_a4 out nocopy JTF_NUMBER_TABLE
1310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1311: , p6_a6 out nocopy JTF_NUMBER_TABLE
1312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1313: , p6_a8 out nocopy JTF_NUMBER_TABLE
1314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1317: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1327: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1328: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1329: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1330: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1331: , p6_a26 out nocopy JTF_NUMBER_TABLE
1332: , p6_a27 out nocopy JTF_NUMBER_TABLE
1333: , p6_a28 out nocopy JTF_NUMBER_TABLE
1334: , p6_a29 out nocopy JTF_DATE_TABLE
1335: , p6_a30 out nocopy JTF_NUMBER_TABLE
1328: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1329: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1330: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1331: , p6_a26 out nocopy JTF_NUMBER_TABLE
1332: , p6_a27 out nocopy JTF_NUMBER_TABLE
1333: , p6_a28 out nocopy JTF_NUMBER_TABLE
1334: , p6_a29 out nocopy JTF_DATE_TABLE
1335: , p6_a30 out nocopy JTF_NUMBER_TABLE
1336: , p6_a31 out nocopy JTF_DATE_TABLE
1329: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1330: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1331: , p6_a26 out nocopy JTF_NUMBER_TABLE
1332: , p6_a27 out nocopy JTF_NUMBER_TABLE
1333: , p6_a28 out nocopy JTF_NUMBER_TABLE
1334: , p6_a29 out nocopy JTF_DATE_TABLE
1335: , p6_a30 out nocopy JTF_NUMBER_TABLE
1336: , p6_a31 out nocopy JTF_DATE_TABLE
1337: , p6_a32 out nocopy JTF_NUMBER_TABLE
1331: , p6_a26 out nocopy JTF_NUMBER_TABLE
1332: , p6_a27 out nocopy JTF_NUMBER_TABLE
1333: , p6_a28 out nocopy JTF_NUMBER_TABLE
1334: , p6_a29 out nocopy JTF_DATE_TABLE
1335: , p6_a30 out nocopy JTF_NUMBER_TABLE
1336: , p6_a31 out nocopy JTF_DATE_TABLE
1337: , p6_a32 out nocopy JTF_NUMBER_TABLE
1338: )
1339:
1333: , p6_a28 out nocopy JTF_NUMBER_TABLE
1334: , p6_a29 out nocopy JTF_DATE_TABLE
1335: , p6_a30 out nocopy JTF_NUMBER_TABLE
1336: , p6_a31 out nocopy JTF_DATE_TABLE
1337: , p6_a32 out nocopy JTF_NUMBER_TABLE
1338: )
1339:
1340: as
1341: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1542: , p_init_msg_list VARCHAR2
1543: , x_return_status out nocopy VARCHAR2
1544: , x_msg_count out nocopy NUMBER
1545: , x_msg_data out nocopy VARCHAR2
1546: , p5_a0 JTF_NUMBER_TABLE
1547: , p5_a1 JTF_NUMBER_TABLE
1548: , p5_a2 JTF_NUMBER_TABLE
1549: , p5_a3 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1543: , x_return_status out nocopy VARCHAR2
1544: , x_msg_count out nocopy NUMBER
1545: , x_msg_data out nocopy VARCHAR2
1546: , p5_a0 JTF_NUMBER_TABLE
1547: , p5_a1 JTF_NUMBER_TABLE
1548: , p5_a2 JTF_NUMBER_TABLE
1549: , p5_a3 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1551: , p5_a5 JTF_VARCHAR2_TABLE_100
1544: , x_msg_count out nocopy NUMBER
1545: , x_msg_data out nocopy VARCHAR2
1546: , p5_a0 JTF_NUMBER_TABLE
1547: , p5_a1 JTF_NUMBER_TABLE
1548: , p5_a2 JTF_NUMBER_TABLE
1549: , p5_a3 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1551: , p5_a5 JTF_VARCHAR2_TABLE_100
1552: , p5_a6 JTF_NUMBER_TABLE
1546: , p5_a0 JTF_NUMBER_TABLE
1547: , p5_a1 JTF_NUMBER_TABLE
1548: , p5_a2 JTF_NUMBER_TABLE
1549: , p5_a3 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1551: , p5_a5 JTF_VARCHAR2_TABLE_100
1552: , p5_a6 JTF_NUMBER_TABLE
1553: , p5_a7 JTF_VARCHAR2_TABLE_2000
1554: , p5_a8 JTF_NUMBER_TABLE
1548: , p5_a2 JTF_NUMBER_TABLE
1549: , p5_a3 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1551: , p5_a5 JTF_VARCHAR2_TABLE_100
1552: , p5_a6 JTF_NUMBER_TABLE
1553: , p5_a7 JTF_VARCHAR2_TABLE_2000
1554: , p5_a8 JTF_NUMBER_TABLE
1555: , p5_a9 JTF_VARCHAR2_TABLE_100
1556: , p5_a10 JTF_VARCHAR2_TABLE_100
1550: , p5_a4 JTF_NUMBER_TABLE
1551: , p5_a5 JTF_VARCHAR2_TABLE_100
1552: , p5_a6 JTF_NUMBER_TABLE
1553: , p5_a7 JTF_VARCHAR2_TABLE_2000
1554: , p5_a8 JTF_NUMBER_TABLE
1555: , p5_a9 JTF_VARCHAR2_TABLE_100
1556: , p5_a10 JTF_VARCHAR2_TABLE_100
1557: , p5_a11 JTF_VARCHAR2_TABLE_500
1558: , p5_a12 JTF_VARCHAR2_TABLE_500
1568: , p5_a22 JTF_VARCHAR2_TABLE_500
1569: , p5_a23 JTF_VARCHAR2_TABLE_500
1570: , p5_a24 JTF_VARCHAR2_TABLE_500
1571: , p5_a25 JTF_VARCHAR2_TABLE_500
1572: , p5_a26 JTF_NUMBER_TABLE
1573: , p5_a27 JTF_NUMBER_TABLE
1574: , p5_a28 JTF_NUMBER_TABLE
1575: , p5_a29 JTF_DATE_TABLE
1576: , p5_a30 JTF_NUMBER_TABLE
1569: , p5_a23 JTF_VARCHAR2_TABLE_500
1570: , p5_a24 JTF_VARCHAR2_TABLE_500
1571: , p5_a25 JTF_VARCHAR2_TABLE_500
1572: , p5_a26 JTF_NUMBER_TABLE
1573: , p5_a27 JTF_NUMBER_TABLE
1574: , p5_a28 JTF_NUMBER_TABLE
1575: , p5_a29 JTF_DATE_TABLE
1576: , p5_a30 JTF_NUMBER_TABLE
1577: , p5_a31 JTF_DATE_TABLE
1570: , p5_a24 JTF_VARCHAR2_TABLE_500
1571: , p5_a25 JTF_VARCHAR2_TABLE_500
1572: , p5_a26 JTF_NUMBER_TABLE
1573: , p5_a27 JTF_NUMBER_TABLE
1574: , p5_a28 JTF_NUMBER_TABLE
1575: , p5_a29 JTF_DATE_TABLE
1576: , p5_a30 JTF_NUMBER_TABLE
1577: , p5_a31 JTF_DATE_TABLE
1578: , p5_a32 JTF_NUMBER_TABLE
1572: , p5_a26 JTF_NUMBER_TABLE
1573: , p5_a27 JTF_NUMBER_TABLE
1574: , p5_a28 JTF_NUMBER_TABLE
1575: , p5_a29 JTF_DATE_TABLE
1576: , p5_a30 JTF_NUMBER_TABLE
1577: , p5_a31 JTF_DATE_TABLE
1578: , p5_a32 JTF_NUMBER_TABLE
1579: )
1580:
1574: , p5_a28 JTF_NUMBER_TABLE
1575: , p5_a29 JTF_DATE_TABLE
1576: , p5_a30 JTF_NUMBER_TABLE
1577: , p5_a31 JTF_DATE_TABLE
1578: , p5_a32 JTF_NUMBER_TABLE
1579: )
1580:
1581: as
1582: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;
1745: , p_init_msg_list VARCHAR2
1746: , x_return_status out nocopy VARCHAR2
1747: , x_msg_count out nocopy NUMBER
1748: , x_msg_data out nocopy VARCHAR2
1749: , p5_a0 JTF_NUMBER_TABLE
1750: , p5_a1 JTF_NUMBER_TABLE
1751: , p5_a2 JTF_NUMBER_TABLE
1752: , p5_a3 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1746: , x_return_status out nocopy VARCHAR2
1747: , x_msg_count out nocopy NUMBER
1748: , x_msg_data out nocopy VARCHAR2
1749: , p5_a0 JTF_NUMBER_TABLE
1750: , p5_a1 JTF_NUMBER_TABLE
1751: , p5_a2 JTF_NUMBER_TABLE
1752: , p5_a3 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1754: , p5_a5 JTF_VARCHAR2_TABLE_100
1747: , x_msg_count out nocopy NUMBER
1748: , x_msg_data out nocopy VARCHAR2
1749: , p5_a0 JTF_NUMBER_TABLE
1750: , p5_a1 JTF_NUMBER_TABLE
1751: , p5_a2 JTF_NUMBER_TABLE
1752: , p5_a3 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1754: , p5_a5 JTF_VARCHAR2_TABLE_100
1755: , p5_a6 JTF_NUMBER_TABLE
1749: , p5_a0 JTF_NUMBER_TABLE
1750: , p5_a1 JTF_NUMBER_TABLE
1751: , p5_a2 JTF_NUMBER_TABLE
1752: , p5_a3 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1754: , p5_a5 JTF_VARCHAR2_TABLE_100
1755: , p5_a6 JTF_NUMBER_TABLE
1756: , p5_a7 JTF_VARCHAR2_TABLE_2000
1757: , p5_a8 JTF_NUMBER_TABLE
1751: , p5_a2 JTF_NUMBER_TABLE
1752: , p5_a3 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1754: , p5_a5 JTF_VARCHAR2_TABLE_100
1755: , p5_a6 JTF_NUMBER_TABLE
1756: , p5_a7 JTF_VARCHAR2_TABLE_2000
1757: , p5_a8 JTF_NUMBER_TABLE
1758: , p5_a9 JTF_VARCHAR2_TABLE_100
1759: , p5_a10 JTF_VARCHAR2_TABLE_100
1753: , p5_a4 JTF_NUMBER_TABLE
1754: , p5_a5 JTF_VARCHAR2_TABLE_100
1755: , p5_a6 JTF_NUMBER_TABLE
1756: , p5_a7 JTF_VARCHAR2_TABLE_2000
1757: , p5_a8 JTF_NUMBER_TABLE
1758: , p5_a9 JTF_VARCHAR2_TABLE_100
1759: , p5_a10 JTF_VARCHAR2_TABLE_100
1760: , p5_a11 JTF_VARCHAR2_TABLE_500
1761: , p5_a12 JTF_VARCHAR2_TABLE_500
1771: , p5_a22 JTF_VARCHAR2_TABLE_500
1772: , p5_a23 JTF_VARCHAR2_TABLE_500
1773: , p5_a24 JTF_VARCHAR2_TABLE_500
1774: , p5_a25 JTF_VARCHAR2_TABLE_500
1775: , p5_a26 JTF_NUMBER_TABLE
1776: , p5_a27 JTF_NUMBER_TABLE
1777: , p5_a28 JTF_NUMBER_TABLE
1778: , p5_a29 JTF_DATE_TABLE
1779: , p5_a30 JTF_NUMBER_TABLE
1772: , p5_a23 JTF_VARCHAR2_TABLE_500
1773: , p5_a24 JTF_VARCHAR2_TABLE_500
1774: , p5_a25 JTF_VARCHAR2_TABLE_500
1775: , p5_a26 JTF_NUMBER_TABLE
1776: , p5_a27 JTF_NUMBER_TABLE
1777: , p5_a28 JTF_NUMBER_TABLE
1778: , p5_a29 JTF_DATE_TABLE
1779: , p5_a30 JTF_NUMBER_TABLE
1780: , p5_a31 JTF_DATE_TABLE
1773: , p5_a24 JTF_VARCHAR2_TABLE_500
1774: , p5_a25 JTF_VARCHAR2_TABLE_500
1775: , p5_a26 JTF_NUMBER_TABLE
1776: , p5_a27 JTF_NUMBER_TABLE
1777: , p5_a28 JTF_NUMBER_TABLE
1778: , p5_a29 JTF_DATE_TABLE
1779: , p5_a30 JTF_NUMBER_TABLE
1780: , p5_a31 JTF_DATE_TABLE
1781: , p5_a32 JTF_NUMBER_TABLE
1775: , p5_a26 JTF_NUMBER_TABLE
1776: , p5_a27 JTF_NUMBER_TABLE
1777: , p5_a28 JTF_NUMBER_TABLE
1778: , p5_a29 JTF_DATE_TABLE
1779: , p5_a30 JTF_NUMBER_TABLE
1780: , p5_a31 JTF_DATE_TABLE
1781: , p5_a32 JTF_NUMBER_TABLE
1782: )
1783:
1777: , p5_a28 JTF_NUMBER_TABLE
1778: , p5_a29 JTF_DATE_TABLE
1779: , p5_a30 JTF_NUMBER_TABLE
1780: , p5_a31 JTF_DATE_TABLE
1781: , p5_a32 JTF_NUMBER_TABLE
1782: )
1783:
1784: as
1785: ddp_atlv_tbl okl_atl_pvt.atlv_tbl_type;