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_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then
71: end loop;
72: end if;
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
72: end if;
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
133: a17 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
133: a17 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
133: a17 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
136: a1.extend(t.count);
137: a2.extend(t.count);
180: end if;
181: end if;
182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
181: end if;
182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin
205: if a0 is not null and a0.count > 0 then
233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE
255: ) as
256: ddindx binary_integer; indx binary_integer;
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();
296: if t.count > 0 then
297: a0.extend(t.count);
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();
296: if t.count > 0 then
297: a0.extend(t.count);
298: a1.extend(t.count);
299: a2.extend(t.count);
458: , p_init_msg_list VARCHAR2
459: , x_return_status out nocopy VARCHAR2
460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
459: , x_return_status out nocopy VARCHAR2
460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE
498: )
499:
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE
498: )
499:
500: as
501: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;
642: , p_init_msg_list VARCHAR2
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE
664: )
665:
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE
664: )
665:
666: as
667: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;
825: , p_init_msg_list VARCHAR2
826: , x_return_status out nocopy VARCHAR2
827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
826: , x_return_status out nocopy VARCHAR2
827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE
865: )
866:
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE
865: )
866:
867: as
868: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;
1009: , p_init_msg_list VARCHAR2
1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE
1031: )
1032:
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1034: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;
1152: , p_init_msg_list VARCHAR2
1153: , x_return_status out nocopy VARCHAR2
1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1153: , x_return_status out nocopy VARCHAR2
1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE
1174: )
1175:
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE
1174: )
1175:
1176: as
1177: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;