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_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_DATE_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_800
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_800
37: , a15 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_800
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_800
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_800
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_NUMBER_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
44: , a22 JTF_NUMBER_TABLE
45: , a23 JTF_DATE_TABLE
46: , a24 JTF_NUMBER_TABLE
47: , a25 JTF_DATE_TABLE
48: , a26 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then
89: end loop;
90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_NUMBER_TABLE
97: , a4 out nocopy JTF_NUMBER_TABLE
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_NUMBER_TABLE
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_NUMBER_TABLE
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_DATE_TABLE
93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_NUMBER_TABLE
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_DATE_TABLE
101: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_DATE_TABLE
101: , a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_NUMBER_TABLE
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_800
100: , a7 out nocopy JTF_DATE_TABLE
101: , a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_NUMBER_TABLE
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_800
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
101: , a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_NUMBER_TABLE
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_800
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
102: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_NUMBER_TABLE
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_800
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_VARCHAR2_TABLE_100
107: , a14 out nocopy JTF_VARCHAR2_TABLE_800
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_VARCHAR2_TABLE_100
111: , a18 out nocopy JTF_NUMBER_TABLE
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_DATE_TABLE
114: , a21 out nocopy JTF_NUMBER_TABLE
115: , a22 out nocopy JTF_NUMBER_TABLE
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_VARCHAR2_TABLE_100
111: , a18 out nocopy JTF_NUMBER_TABLE
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_DATE_TABLE
114: , a21 out nocopy JTF_NUMBER_TABLE
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
110: , a17 out nocopy JTF_VARCHAR2_TABLE_100
111: , a18 out nocopy JTF_NUMBER_TABLE
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_DATE_TABLE
114: , a21 out nocopy JTF_NUMBER_TABLE
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
111: , a18 out nocopy JTF_NUMBER_TABLE
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_DATE_TABLE
114: , a21 out nocopy JTF_NUMBER_TABLE
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_DATE_TABLE
114: , a21 out nocopy JTF_NUMBER_TABLE
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
115: , a22 out nocopy JTF_NUMBER_TABLE
116: , a23 out nocopy JTF_DATE_TABLE
117: , a24 out nocopy JTF_NUMBER_TABLE
118: , a25 out nocopy JTF_DATE_TABLE
119: , a26 out nocopy JTF_NUMBER_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_100();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_100();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_100();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_100();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_NUMBER_TABLE();
138: a14 := JTF_VARCHAR2_TABLE_800();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_NUMBER_TABLE();
138: a14 := JTF_VARCHAR2_TABLE_800();
139: a15 := JTF_VARCHAR2_TABLE_100();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_NUMBER_TABLE();
138: a14 := JTF_VARCHAR2_TABLE_800();
139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_100();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_NUMBER_TABLE();
138: a14 := JTF_VARCHAR2_TABLE_800();
139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_100();
141: a17 := JTF_VARCHAR2_TABLE_100();
138: a14 := JTF_VARCHAR2_TABLE_800();
139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_100();
141: a17 := JTF_VARCHAR2_TABLE_100();
142: a18 := JTF_NUMBER_TABLE();
143: a19 := JTF_NUMBER_TABLE();
144: a20 := JTF_DATE_TABLE();
145: a21 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_100();
141: a17 := JTF_VARCHAR2_TABLE_100();
142: a18 := JTF_NUMBER_TABLE();
143: a19 := JTF_NUMBER_TABLE();
144: a20 := JTF_DATE_TABLE();
145: a21 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
141: a17 := JTF_VARCHAR2_TABLE_100();
142: a18 := JTF_NUMBER_TABLE();
143: a19 := JTF_NUMBER_TABLE();
144: a20 := JTF_DATE_TABLE();
145: a21 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
142: a18 := JTF_NUMBER_TABLE();
143: a19 := JTF_NUMBER_TABLE();
144: a20 := JTF_DATE_TABLE();
145: a21 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
144: a20 := JTF_DATE_TABLE();
145: a21 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
146: a22 := JTF_NUMBER_TABLE();
147: a23 := JTF_DATE_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_100();
154: a2 := JTF_NUMBER_TABLE();
148: a24 := JTF_NUMBER_TABLE();
149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_100();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_NUMBER_TABLE();
156: a4 := JTF_NUMBER_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_100();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_NUMBER_TABLE();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_VARCHAR2_TABLE_100();
158: a6 := JTF_VARCHAR2_TABLE_100();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_100();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_NUMBER_TABLE();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_VARCHAR2_TABLE_100();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_DATE_TABLE();
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_100();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_NUMBER_TABLE();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_VARCHAR2_TABLE_100();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_DATE_TABLE();
160: a8 := JTF_VARCHAR2_TABLE_100();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_DATE_TABLE();
160: a8 := JTF_VARCHAR2_TABLE_100();
161: a9 := JTF_VARCHAR2_TABLE_100();
162: a10 := JTF_NUMBER_TABLE();
163: a11 := JTF_NUMBER_TABLE();
164: a12 := JTF_NUMBER_TABLE();
165: a13 := JTF_NUMBER_TABLE();
166: a14 := JTF_VARCHAR2_TABLE_800();
159: a7 := JTF_DATE_TABLE();
160: a8 := JTF_VARCHAR2_TABLE_100();
161: a9 := JTF_VARCHAR2_TABLE_100();
162: a10 := JTF_NUMBER_TABLE();
163: a11 := JTF_NUMBER_TABLE();
164: a12 := JTF_NUMBER_TABLE();
165: a13 := JTF_NUMBER_TABLE();
166: a14 := JTF_VARCHAR2_TABLE_800();
167: a15 := JTF_VARCHAR2_TABLE_100();
160: a8 := JTF_VARCHAR2_TABLE_100();
161: a9 := JTF_VARCHAR2_TABLE_100();
162: a10 := JTF_NUMBER_TABLE();
163: a11 := JTF_NUMBER_TABLE();
164: a12 := JTF_NUMBER_TABLE();
165: a13 := JTF_NUMBER_TABLE();
166: a14 := JTF_VARCHAR2_TABLE_800();
167: a15 := JTF_VARCHAR2_TABLE_100();
168: a16 := JTF_VARCHAR2_TABLE_100();
161: a9 := JTF_VARCHAR2_TABLE_100();
162: a10 := JTF_NUMBER_TABLE();
163: a11 := JTF_NUMBER_TABLE();
164: a12 := JTF_NUMBER_TABLE();
165: a13 := JTF_NUMBER_TABLE();
166: a14 := JTF_VARCHAR2_TABLE_800();
167: a15 := JTF_VARCHAR2_TABLE_100();
168: a16 := JTF_VARCHAR2_TABLE_100();
169: a17 := JTF_VARCHAR2_TABLE_100();
166: a14 := JTF_VARCHAR2_TABLE_800();
167: a15 := JTF_VARCHAR2_TABLE_100();
168: a16 := JTF_VARCHAR2_TABLE_100();
169: a17 := JTF_VARCHAR2_TABLE_100();
170: a18 := JTF_NUMBER_TABLE();
171: a19 := JTF_NUMBER_TABLE();
172: a20 := JTF_DATE_TABLE();
173: a21 := JTF_NUMBER_TABLE();
174: a22 := JTF_NUMBER_TABLE();
167: a15 := JTF_VARCHAR2_TABLE_100();
168: a16 := JTF_VARCHAR2_TABLE_100();
169: a17 := JTF_VARCHAR2_TABLE_100();
170: a18 := JTF_NUMBER_TABLE();
171: a19 := JTF_NUMBER_TABLE();
172: a20 := JTF_DATE_TABLE();
173: a21 := JTF_NUMBER_TABLE();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
169: a17 := JTF_VARCHAR2_TABLE_100();
170: a18 := JTF_NUMBER_TABLE();
171: a19 := JTF_NUMBER_TABLE();
172: a20 := JTF_DATE_TABLE();
173: a21 := JTF_NUMBER_TABLE();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
170: a18 := JTF_NUMBER_TABLE();
171: a19 := JTF_NUMBER_TABLE();
172: a20 := JTF_DATE_TABLE();
173: a21 := JTF_NUMBER_TABLE();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
172: a20 := JTF_DATE_TABLE();
173: a21 := JTF_NUMBER_TABLE();
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
174: a22 := JTF_NUMBER_TABLE();
175: a23 := JTF_DATE_TABLE();
176: a24 := JTF_NUMBER_TABLE();
177: a25 := JTF_DATE_TABLE();
178: a26 := JTF_NUMBER_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);
181: a1.extend(t.count);
182: a2.extend(t.count);
244: end if;
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_NUMBER_TABLE
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_NUMBER_TABLE
255: , a8 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_NUMBER_TABLE
255: , a8 JTF_NUMBER_TABLE
256: , a9 JTF_VARCHAR2_TABLE_100
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_NUMBER_TABLE
255: , a8 JTF_NUMBER_TABLE
256: , a9 JTF_VARCHAR2_TABLE_100
257: , a10 JTF_DATE_TABLE
258: , a11 JTF_VARCHAR2_TABLE_800
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_NUMBER_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_NUMBER_TABLE
255: , a8 JTF_NUMBER_TABLE
256: , a9 JTF_VARCHAR2_TABLE_100
257: , a10 JTF_DATE_TABLE
258: , a11 JTF_VARCHAR2_TABLE_800
259: , a12 JTF_VARCHAR2_TABLE_100
259: , a12 JTF_VARCHAR2_TABLE_100
260: , a13 JTF_VARCHAR2_TABLE_100
261: , a14 JTF_VARCHAR2_TABLE_100
262: , a15 JTF_VARCHAR2_TABLE_100
263: , a16 JTF_NUMBER_TABLE
264: , a17 JTF_VARCHAR2_TABLE_100
265: , a18 JTF_NUMBER_TABLE
266: , a19 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
261: , a14 JTF_VARCHAR2_TABLE_100
262: , a15 JTF_VARCHAR2_TABLE_100
263: , a16 JTF_NUMBER_TABLE
264: , a17 JTF_VARCHAR2_TABLE_100
265: , a18 JTF_NUMBER_TABLE
266: , a19 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
268: , a21 JTF_NUMBER_TABLE
269: , a22 JTF_NUMBER_TABLE
262: , a15 JTF_VARCHAR2_TABLE_100
263: , a16 JTF_NUMBER_TABLE
264: , a17 JTF_VARCHAR2_TABLE_100
265: , a18 JTF_NUMBER_TABLE
266: , a19 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
268: , a21 JTF_NUMBER_TABLE
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
264: , a17 JTF_VARCHAR2_TABLE_100
265: , a18 JTF_NUMBER_TABLE
266: , a19 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
268: , a21 JTF_NUMBER_TABLE
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
265: , a18 JTF_NUMBER_TABLE
266: , a19 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
268: , a21 JTF_NUMBER_TABLE
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
267: , a20 JTF_DATE_TABLE
268: , a21 JTF_NUMBER_TABLE
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
274: ) as
275: ddindx binary_integer; indx binary_integer;
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE
273: , a26 JTF_NUMBER_TABLE
274: ) as
275: ddindx binary_integer; indx binary_integer;
276: begin
277: if a0 is not null and a0.count > 0 then
315: end if;
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_NUMBER_TABLE
318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_NUMBER_TABLE
326: , a8 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_NUMBER_TABLE
326: , a8 out nocopy JTF_NUMBER_TABLE
327: , a9 out nocopy JTF_VARCHAR2_TABLE_100
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_NUMBER_TABLE
326: , a8 out nocopy JTF_NUMBER_TABLE
327: , a9 out nocopy JTF_VARCHAR2_TABLE_100
328: , a10 out nocopy JTF_DATE_TABLE
329: , a11 out nocopy JTF_VARCHAR2_TABLE_800
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_NUMBER_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_NUMBER_TABLE
326: , a8 out nocopy JTF_NUMBER_TABLE
327: , a9 out nocopy JTF_VARCHAR2_TABLE_100
328: , a10 out nocopy JTF_DATE_TABLE
329: , a11 out nocopy JTF_VARCHAR2_TABLE_800
330: , a12 out nocopy JTF_VARCHAR2_TABLE_100
330: , a12 out nocopy JTF_VARCHAR2_TABLE_100
331: , a13 out nocopy JTF_VARCHAR2_TABLE_100
332: , a14 out nocopy JTF_VARCHAR2_TABLE_100
333: , a15 out nocopy JTF_VARCHAR2_TABLE_100
334: , a16 out nocopy JTF_NUMBER_TABLE
335: , a17 out nocopy JTF_VARCHAR2_TABLE_100
336: , a18 out nocopy JTF_NUMBER_TABLE
337: , a19 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
332: , a14 out nocopy JTF_VARCHAR2_TABLE_100
333: , a15 out nocopy JTF_VARCHAR2_TABLE_100
334: , a16 out nocopy JTF_NUMBER_TABLE
335: , a17 out nocopy JTF_VARCHAR2_TABLE_100
336: , a18 out nocopy JTF_NUMBER_TABLE
337: , a19 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
339: , a21 out nocopy JTF_NUMBER_TABLE
340: , a22 out nocopy JTF_NUMBER_TABLE
333: , a15 out nocopy JTF_VARCHAR2_TABLE_100
334: , a16 out nocopy JTF_NUMBER_TABLE
335: , a17 out nocopy JTF_VARCHAR2_TABLE_100
336: , a18 out nocopy JTF_NUMBER_TABLE
337: , a19 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
339: , a21 out nocopy JTF_NUMBER_TABLE
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
335: , a17 out nocopy JTF_VARCHAR2_TABLE_100
336: , a18 out nocopy JTF_NUMBER_TABLE
337: , a19 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
339: , a21 out nocopy JTF_NUMBER_TABLE
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
336: , a18 out nocopy JTF_NUMBER_TABLE
337: , a19 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
339: , a21 out nocopy JTF_NUMBER_TABLE
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
338: , a20 out nocopy JTF_DATE_TABLE
339: , a21 out nocopy JTF_NUMBER_TABLE
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE
344: , a26 out nocopy JTF_NUMBER_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_VARCHAR2_TABLE_100();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_VARCHAR2_TABLE_100();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
348: if t is null or t.count = 0 then
349: a0 := JTF_VARCHAR2_TABLE_100();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_NUMBER_TABLE();
349: a0 := JTF_VARCHAR2_TABLE_100();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_NUMBER_TABLE();
357: a8 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_NUMBER_TABLE();
357: a8 := JTF_NUMBER_TABLE();
358: a9 := JTF_VARCHAR2_TABLE_100();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_NUMBER_TABLE();
357: a8 := JTF_NUMBER_TABLE();
358: a9 := JTF_VARCHAR2_TABLE_100();
359: a10 := JTF_DATE_TABLE();
360: a11 := JTF_VARCHAR2_TABLE_800();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_NUMBER_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_NUMBER_TABLE();
357: a8 := JTF_NUMBER_TABLE();
358: a9 := JTF_VARCHAR2_TABLE_100();
359: a10 := JTF_DATE_TABLE();
360: a11 := JTF_VARCHAR2_TABLE_800();
361: a12 := JTF_VARCHAR2_TABLE_100();
361: a12 := JTF_VARCHAR2_TABLE_100();
362: a13 := JTF_VARCHAR2_TABLE_100();
363: a14 := JTF_VARCHAR2_TABLE_100();
364: a15 := JTF_VARCHAR2_TABLE_100();
365: a16 := JTF_NUMBER_TABLE();
366: a17 := JTF_VARCHAR2_TABLE_100();
367: a18 := JTF_NUMBER_TABLE();
368: a19 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
363: a14 := JTF_VARCHAR2_TABLE_100();
364: a15 := JTF_VARCHAR2_TABLE_100();
365: a16 := JTF_NUMBER_TABLE();
366: a17 := JTF_VARCHAR2_TABLE_100();
367: a18 := JTF_NUMBER_TABLE();
368: a19 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
370: a21 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
364: a15 := JTF_VARCHAR2_TABLE_100();
365: a16 := JTF_NUMBER_TABLE();
366: a17 := JTF_VARCHAR2_TABLE_100();
367: a18 := JTF_NUMBER_TABLE();
368: a19 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
370: a21 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
366: a17 := JTF_VARCHAR2_TABLE_100();
367: a18 := JTF_NUMBER_TABLE();
368: a19 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
370: a21 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
367: a18 := JTF_NUMBER_TABLE();
368: a19 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
370: a21 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
369: a20 := JTF_DATE_TABLE();
370: a21 := JTF_NUMBER_TABLE();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_VARCHAR2_TABLE_100();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_VARCHAR2_TABLE_100();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_VARCHAR2_TABLE_100();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_VARCHAR2_TABLE_100();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
376: else
377: a0 := JTF_VARCHAR2_TABLE_100();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_NUMBER_TABLE();
377: a0 := JTF_VARCHAR2_TABLE_100();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_NUMBER_TABLE();
385: a8 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_NUMBER_TABLE();
385: a8 := JTF_NUMBER_TABLE();
386: a9 := JTF_VARCHAR2_TABLE_100();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_NUMBER_TABLE();
385: a8 := JTF_NUMBER_TABLE();
386: a9 := JTF_VARCHAR2_TABLE_100();
387: a10 := JTF_DATE_TABLE();
388: a11 := JTF_VARCHAR2_TABLE_800();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_NUMBER_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_NUMBER_TABLE();
385: a8 := JTF_NUMBER_TABLE();
386: a9 := JTF_VARCHAR2_TABLE_100();
387: a10 := JTF_DATE_TABLE();
388: a11 := JTF_VARCHAR2_TABLE_800();
389: a12 := JTF_VARCHAR2_TABLE_100();
389: a12 := JTF_VARCHAR2_TABLE_100();
390: a13 := JTF_VARCHAR2_TABLE_100();
391: a14 := JTF_VARCHAR2_TABLE_100();
392: a15 := JTF_VARCHAR2_TABLE_100();
393: a16 := JTF_NUMBER_TABLE();
394: a17 := JTF_VARCHAR2_TABLE_100();
395: a18 := JTF_NUMBER_TABLE();
396: a19 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
391: a14 := JTF_VARCHAR2_TABLE_100();
392: a15 := JTF_VARCHAR2_TABLE_100();
393: a16 := JTF_NUMBER_TABLE();
394: a17 := JTF_VARCHAR2_TABLE_100();
395: a18 := JTF_NUMBER_TABLE();
396: a19 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
398: a21 := JTF_NUMBER_TABLE();
399: a22 := JTF_NUMBER_TABLE();
392: a15 := JTF_VARCHAR2_TABLE_100();
393: a16 := JTF_NUMBER_TABLE();
394: a17 := JTF_VARCHAR2_TABLE_100();
395: a18 := JTF_NUMBER_TABLE();
396: a19 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
398: a21 := JTF_NUMBER_TABLE();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
394: a17 := JTF_VARCHAR2_TABLE_100();
395: a18 := JTF_NUMBER_TABLE();
396: a19 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
398: a21 := JTF_NUMBER_TABLE();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
395: a18 := JTF_NUMBER_TABLE();
396: a19 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
398: a21 := JTF_NUMBER_TABLE();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
397: a20 := JTF_DATE_TABLE();
398: a21 := JTF_NUMBER_TABLE();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();
403: a26 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
406: a1.extend(t.count);
407: a2.extend(t.count);
468: end if;
469: end if;
470: end rosetta_table_copy_out_p5;
471:
472: procedure rosetta_table_copy_in_p6(t out nocopy okl_aeh_pvt.ae_header_id_typ, a0 JTF_NUMBER_TABLE) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if a0 is not null and a0.count > 0 then
476: if a0.count > 0 then
486: end loop;
487: end if;
488: end if;
489: end rosetta_table_copy_in_p6;
490: procedure rosetta_table_copy_out_p6(t okl_aeh_pvt.ae_header_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
490: procedure rosetta_table_copy_out_p6(t okl_aeh_pvt.ae_header_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
495: else
496: a0 := JTF_NUMBER_TABLE();
497: if t.count > 0 then
498: a0.extend(t.count);
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
495: else
496: a0 := JTF_NUMBER_TABLE();
497: if t.count > 0 then
498: a0.extend(t.count);
499: ddindx := t.first;
500: indx := 1;
550: end if;
551: end if;
552: end rosetta_table_copy_out_p7;
553:
554: procedure rosetta_table_copy_in_p8(t out nocopy okl_aeh_pvt.set_of_books_id_typ, a0 JTF_NUMBER_TABLE) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if a0 is not null and a0.count > 0 then
558: if a0.count > 0 then
568: end loop;
569: end if;
570: end if;
571: end rosetta_table_copy_in_p8;
572: procedure rosetta_table_copy_out_p8(t okl_aeh_pvt.set_of_books_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
573: ddindx binary_integer; indx binary_integer;
574: begin
575: if t is null or t.count = 0 then
576: a0 := JTF_NUMBER_TABLE();
572: procedure rosetta_table_copy_out_p8(t okl_aeh_pvt.set_of_books_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
573: ddindx binary_integer; indx binary_integer;
574: begin
575: if t is null or t.count = 0 then
576: a0 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
579: if t.count > 0 then
580: a0.extend(t.count);
574: begin
575: if t is null or t.count = 0 then
576: a0 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
579: if t.count > 0 then
580: a0.extend(t.count);
581: ddindx := t.first;
582: indx := 1;
591: end if;
592: end if;
593: end rosetta_table_copy_out_p8;
594:
595: procedure rosetta_table_copy_in_p9(t out nocopy okl_aeh_pvt.accounting_event_id_typ, a0 JTF_NUMBER_TABLE) as
596: ddindx binary_integer; indx binary_integer;
597: begin
598: if a0 is not null and a0.count > 0 then
599: if a0.count > 0 then
609: end loop;
610: end if;
611: end if;
612: end rosetta_table_copy_in_p9;
613: procedure rosetta_table_copy_out_p9(t okl_aeh_pvt.accounting_event_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
614: ddindx binary_integer; indx binary_integer;
615: begin
616: if t is null or t.count = 0 then
617: a0 := JTF_NUMBER_TABLE();
613: procedure rosetta_table_copy_out_p9(t okl_aeh_pvt.accounting_event_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
614: ddindx binary_integer; indx binary_integer;
615: begin
616: if t is null or t.count = 0 then
617: a0 := JTF_NUMBER_TABLE();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: if t.count > 0 then
621: a0.extend(t.count);
615: begin
616: if t is null or t.count = 0 then
617: a0 := JTF_NUMBER_TABLE();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: if t.count > 0 then
621: a0.extend(t.count);
622: ddindx := t.first;
623: indx := 1;
632: end if;
633: end if;
634: end rosetta_table_copy_out_p9;
635:
636: procedure rosetta_table_copy_in_p10(t out nocopy okl_aeh_pvt.object_version_number_typ, a0 JTF_NUMBER_TABLE) as
637: ddindx binary_integer; indx binary_integer;
638: begin
639: if a0 is not null and a0.count > 0 then
640: if a0.count > 0 then
650: end loop;
651: end if;
652: end if;
653: end rosetta_table_copy_in_p10;
654: procedure rosetta_table_copy_out_p10(t okl_aeh_pvt.object_version_number_typ, a0 out nocopy JTF_NUMBER_TABLE) as
655: ddindx binary_integer; indx binary_integer;
656: begin
657: if t is null or t.count = 0 then
658: a0 := JTF_NUMBER_TABLE();
654: procedure rosetta_table_copy_out_p10(t okl_aeh_pvt.object_version_number_typ, a0 out nocopy JTF_NUMBER_TABLE) as
655: ddindx binary_integer; indx binary_integer;
656: begin
657: if t is null or t.count = 0 then
658: a0 := JTF_NUMBER_TABLE();
659: else
660: a0 := JTF_NUMBER_TABLE();
661: if t.count > 0 then
662: a0.extend(t.count);
656: begin
657: if t is null or t.count = 0 then
658: a0 := JTF_NUMBER_TABLE();
659: else
660: a0 := JTF_NUMBER_TABLE();
661: if t.count > 0 then
662: a0.extend(t.count);
663: ddindx := t.first;
664: indx := 1;
796: end if;
797: end if;
798: end rosetta_table_copy_out_p13;
799:
800: procedure rosetta_table_copy_in_p14(t out nocopy okl_aeh_pvt.gl_transfer_run_id_typ, a0 JTF_NUMBER_TABLE) as
801: ddindx binary_integer; indx binary_integer;
802: begin
803: if a0 is not null and a0.count > 0 then
804: if a0.count > 0 then
814: end loop;
815: end if;
816: end if;
817: end rosetta_table_copy_in_p14;
818: procedure rosetta_table_copy_out_p14(t okl_aeh_pvt.gl_transfer_run_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
819: ddindx binary_integer; indx binary_integer;
820: begin
821: if t is null or t.count = 0 then
822: a0 := JTF_NUMBER_TABLE();
818: procedure rosetta_table_copy_out_p14(t okl_aeh_pvt.gl_transfer_run_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
819: ddindx binary_integer; indx binary_integer;
820: begin
821: if t is null or t.count = 0 then
822: a0 := JTF_NUMBER_TABLE();
823: else
824: a0 := JTF_NUMBER_TABLE();
825: if t.count > 0 then
826: a0.extend(t.count);
820: begin
821: if t is null or t.count = 0 then
822: a0 := JTF_NUMBER_TABLE();
823: else
824: a0 := JTF_NUMBER_TABLE();
825: if t.count > 0 then
826: a0.extend(t.count);
827: ddindx := t.first;
828: indx := 1;
919: end if;
920: end if;
921: end rosetta_table_copy_out_p16;
922:
923: procedure rosetta_table_copy_in_p17(t out nocopy okl_aeh_pvt.sequence_id_typ, a0 JTF_NUMBER_TABLE) as
924: ddindx binary_integer; indx binary_integer;
925: begin
926: if a0 is not null and a0.count > 0 then
927: if a0.count > 0 then
937: end loop;
938: end if;
939: end if;
940: end rosetta_table_copy_in_p17;
941: procedure rosetta_table_copy_out_p17(t okl_aeh_pvt.sequence_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
942: ddindx binary_integer; indx binary_integer;
943: begin
944: if t is null or t.count = 0 then
945: a0 := JTF_NUMBER_TABLE();
941: procedure rosetta_table_copy_out_p17(t okl_aeh_pvt.sequence_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
942: ddindx binary_integer; indx binary_integer;
943: begin
944: if t is null or t.count = 0 then
945: a0 := JTF_NUMBER_TABLE();
946: else
947: a0 := JTF_NUMBER_TABLE();
948: if t.count > 0 then
949: a0.extend(t.count);
943: begin
944: if t is null or t.count = 0 then
945: a0 := JTF_NUMBER_TABLE();
946: else
947: a0 := JTF_NUMBER_TABLE();
948: if t.count > 0 then
949: a0.extend(t.count);
950: ddindx := t.first;
951: indx := 1;
960: end if;
961: end if;
962: end rosetta_table_copy_out_p17;
963:
964: procedure rosetta_table_copy_in_p18(t out nocopy okl_aeh_pvt.sequence_value_typ, a0 JTF_NUMBER_TABLE) as
965: ddindx binary_integer; indx binary_integer;
966: begin
967: if a0 is not null and a0.count > 0 then
968: if a0.count > 0 then
978: end loop;
979: end if;
980: end if;
981: end rosetta_table_copy_in_p18;
982: procedure rosetta_table_copy_out_p18(t okl_aeh_pvt.sequence_value_typ, a0 out nocopy JTF_NUMBER_TABLE) as
983: ddindx binary_integer; indx binary_integer;
984: begin
985: if t is null or t.count = 0 then
986: a0 := JTF_NUMBER_TABLE();
982: procedure rosetta_table_copy_out_p18(t okl_aeh_pvt.sequence_value_typ, a0 out nocopy JTF_NUMBER_TABLE) as
983: ddindx binary_integer; indx binary_integer;
984: begin
985: if t is null or t.count = 0 then
986: a0 := JTF_NUMBER_TABLE();
987: else
988: a0 := JTF_NUMBER_TABLE();
989: if t.count > 0 then
990: a0.extend(t.count);
984: begin
985: if t is null or t.count = 0 then
986: a0 := JTF_NUMBER_TABLE();
987: else
988: a0 := JTF_NUMBER_TABLE();
989: if t.count > 0 then
990: a0.extend(t.count);
991: ddindx := t.first;
992: indx := 1;
1165: end if;
1166: end if;
1167: end rosetta_table_copy_out_p22;
1168:
1169: procedure rosetta_table_copy_in_p23(t out nocopy okl_aeh_pvt.org_id_typ, a0 JTF_NUMBER_TABLE) as
1170: ddindx binary_integer; indx binary_integer;
1171: begin
1172: if a0 is not null and a0.count > 0 then
1173: if a0.count > 0 then
1183: end loop;
1184: end if;
1185: end if;
1186: end rosetta_table_copy_in_p23;
1187: procedure rosetta_table_copy_out_p23(t okl_aeh_pvt.org_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1188: ddindx binary_integer; indx binary_integer;
1189: begin
1190: if t is null or t.count = 0 then
1191: a0 := JTF_NUMBER_TABLE();
1187: procedure rosetta_table_copy_out_p23(t okl_aeh_pvt.org_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1188: ddindx binary_integer; indx binary_integer;
1189: begin
1190: if t is null or t.count = 0 then
1191: a0 := JTF_NUMBER_TABLE();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: if t.count > 0 then
1195: a0.extend(t.count);
1189: begin
1190: if t is null or t.count = 0 then
1191: a0 := JTF_NUMBER_TABLE();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: if t.count > 0 then
1195: a0.extend(t.count);
1196: ddindx := t.first;
1197: indx := 1;
1206: end if;
1207: end if;
1208: end rosetta_table_copy_out_p23;
1209:
1210: procedure rosetta_table_copy_in_p24(t out nocopy okl_aeh_pvt.program_id_typ, a0 JTF_NUMBER_TABLE) as
1211: ddindx binary_integer; indx binary_integer;
1212: begin
1213: if a0 is not null and a0.count > 0 then
1214: if a0.count > 0 then
1224: end loop;
1225: end if;
1226: end if;
1227: end rosetta_table_copy_in_p24;
1228: procedure rosetta_table_copy_out_p24(t okl_aeh_pvt.program_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1229: ddindx binary_integer; indx binary_integer;
1230: begin
1231: if t is null or t.count = 0 then
1232: a0 := JTF_NUMBER_TABLE();
1228: procedure rosetta_table_copy_out_p24(t okl_aeh_pvt.program_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1229: ddindx binary_integer; indx binary_integer;
1230: begin
1231: if t is null or t.count = 0 then
1232: a0 := JTF_NUMBER_TABLE();
1233: else
1234: a0 := JTF_NUMBER_TABLE();
1235: if t.count > 0 then
1236: a0.extend(t.count);
1230: begin
1231: if t is null or t.count = 0 then
1232: a0 := JTF_NUMBER_TABLE();
1233: else
1234: a0 := JTF_NUMBER_TABLE();
1235: if t.count > 0 then
1236: a0.extend(t.count);
1237: ddindx := t.first;
1238: indx := 1;
1247: end if;
1248: end if;
1249: end rosetta_table_copy_out_p24;
1250:
1251: procedure rosetta_table_copy_in_p25(t out nocopy okl_aeh_pvt.program_application_id_typ, a0 JTF_NUMBER_TABLE) as
1252: ddindx binary_integer; indx binary_integer;
1253: begin
1254: if a0 is not null and a0.count > 0 then
1255: if a0.count > 0 then
1265: end loop;
1266: end if;
1267: end if;
1268: end rosetta_table_copy_in_p25;
1269: procedure rosetta_table_copy_out_p25(t okl_aeh_pvt.program_application_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272: if t is null or t.count = 0 then
1273: a0 := JTF_NUMBER_TABLE();
1269: procedure rosetta_table_copy_out_p25(t okl_aeh_pvt.program_application_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272: if t is null or t.count = 0 then
1273: a0 := JTF_NUMBER_TABLE();
1274: else
1275: a0 := JTF_NUMBER_TABLE();
1276: if t.count > 0 then
1277: a0.extend(t.count);
1271: begin
1272: if t is null or t.count = 0 then
1273: a0 := JTF_NUMBER_TABLE();
1274: else
1275: a0 := JTF_NUMBER_TABLE();
1276: if t.count > 0 then
1277: a0.extend(t.count);
1278: ddindx := t.first;
1279: indx := 1;
1329: end if;
1330: end if;
1331: end rosetta_table_copy_out_p26;
1332:
1333: procedure rosetta_table_copy_in_p27(t out nocopy okl_aeh_pvt.request_id_typ, a0 JTF_NUMBER_TABLE) as
1334: ddindx binary_integer; indx binary_integer;
1335: begin
1336: if a0 is not null and a0.count > 0 then
1337: if a0.count > 0 then
1347: end loop;
1348: end if;
1349: end if;
1350: end rosetta_table_copy_in_p27;
1351: procedure rosetta_table_copy_out_p27(t okl_aeh_pvt.request_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1352: ddindx binary_integer; indx binary_integer;
1353: begin
1354: if t is null or t.count = 0 then
1355: a0 := JTF_NUMBER_TABLE();
1351: procedure rosetta_table_copy_out_p27(t okl_aeh_pvt.request_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1352: ddindx binary_integer; indx binary_integer;
1353: begin
1354: if t is null or t.count = 0 then
1355: a0 := JTF_NUMBER_TABLE();
1356: else
1357: a0 := JTF_NUMBER_TABLE();
1358: if t.count > 0 then
1359: a0.extend(t.count);
1353: begin
1354: if t is null or t.count = 0 then
1355: a0 := JTF_NUMBER_TABLE();
1356: else
1357: a0 := JTF_NUMBER_TABLE();
1358: if t.count > 0 then
1359: a0.extend(t.count);
1360: ddindx := t.first;
1361: indx := 1;
1370: end if;
1371: end if;
1372: end rosetta_table_copy_out_p27;
1373:
1374: procedure rosetta_table_copy_in_p28(t out nocopy okl_aeh_pvt.created_by_typ, a0 JTF_NUMBER_TABLE) as
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1377: if a0 is not null and a0.count > 0 then
1378: if a0.count > 0 then
1388: end loop;
1389: end if;
1390: end if;
1391: end rosetta_table_copy_in_p28;
1392: procedure rosetta_table_copy_out_p28(t okl_aeh_pvt.created_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1393: ddindx binary_integer; indx binary_integer;
1394: begin
1395: if t is null or t.count = 0 then
1396: a0 := JTF_NUMBER_TABLE();
1392: procedure rosetta_table_copy_out_p28(t okl_aeh_pvt.created_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1393: ddindx binary_integer; indx binary_integer;
1394: begin
1395: if t is null or t.count = 0 then
1396: a0 := JTF_NUMBER_TABLE();
1397: else
1398: a0 := JTF_NUMBER_TABLE();
1399: if t.count > 0 then
1400: a0.extend(t.count);
1394: begin
1395: if t is null or t.count = 0 then
1396: a0 := JTF_NUMBER_TABLE();
1397: else
1398: a0 := JTF_NUMBER_TABLE();
1399: if t.count > 0 then
1400: a0.extend(t.count);
1401: ddindx := t.first;
1402: indx := 1;
1452: end if;
1453: end if;
1454: end rosetta_table_copy_out_p29;
1455:
1456: procedure rosetta_table_copy_in_p30(t out nocopy okl_aeh_pvt.last_updated_by_typ, a0 JTF_NUMBER_TABLE) as
1457: ddindx binary_integer; indx binary_integer;
1458: begin
1459: if a0 is not null and a0.count > 0 then
1460: if a0.count > 0 then
1470: end loop;
1471: end if;
1472: end if;
1473: end rosetta_table_copy_in_p30;
1474: procedure rosetta_table_copy_out_p30(t okl_aeh_pvt.last_updated_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1475: ddindx binary_integer; indx binary_integer;
1476: begin
1477: if t is null or t.count = 0 then
1478: a0 := JTF_NUMBER_TABLE();
1474: procedure rosetta_table_copy_out_p30(t okl_aeh_pvt.last_updated_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1475: ddindx binary_integer; indx binary_integer;
1476: begin
1477: if t is null or t.count = 0 then
1478: a0 := JTF_NUMBER_TABLE();
1479: else
1480: a0 := JTF_NUMBER_TABLE();
1481: if t.count > 0 then
1482: a0.extend(t.count);
1476: begin
1477: if t is null or t.count = 0 then
1478: a0 := JTF_NUMBER_TABLE();
1479: else
1480: a0 := JTF_NUMBER_TABLE();
1481: if t.count > 0 then
1482: a0.extend(t.count);
1483: ddindx := t.first;
1484: indx := 1;
1534: end if;
1535: end if;
1536: end rosetta_table_copy_out_p31;
1537:
1538: procedure rosetta_table_copy_in_p32(t out nocopy okl_aeh_pvt.last_update_login_typ, a0 JTF_NUMBER_TABLE) as
1539: ddindx binary_integer; indx binary_integer;
1540: begin
1541: if a0 is not null and a0.count > 0 then
1542: if a0.count > 0 then
1552: end loop;
1553: end if;
1554: end if;
1555: end rosetta_table_copy_in_p32;
1556: procedure rosetta_table_copy_out_p32(t okl_aeh_pvt.last_update_login_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1557: ddindx binary_integer; indx binary_integer;
1558: begin
1559: if t is null or t.count = 0 then
1560: a0 := JTF_NUMBER_TABLE();
1556: procedure rosetta_table_copy_out_p32(t okl_aeh_pvt.last_update_login_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1557: ddindx binary_integer; indx binary_integer;
1558: begin
1559: if t is null or t.count = 0 then
1560: a0 := JTF_NUMBER_TABLE();
1561: else
1562: a0 := JTF_NUMBER_TABLE();
1563: if t.count > 0 then
1564: a0.extend(t.count);
1558: begin
1559: if t is null or t.count = 0 then
1560: a0 := JTF_NUMBER_TABLE();
1561: else
1562: a0 := JTF_NUMBER_TABLE();
1563: if t.count > 0 then
1564: a0.extend(t.count);
1565: ddindx := t.first;
1566: indx := 1;
1728: , x_return_status out nocopy VARCHAR2
1729: , x_msg_count out nocopy NUMBER
1730: , x_msg_data out nocopy VARCHAR2
1731: , p5_a0 JTF_VARCHAR2_TABLE_100
1732: , p5_a1 JTF_NUMBER_TABLE
1733: , p5_a2 JTF_NUMBER_TABLE
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1729: , x_msg_count out nocopy NUMBER
1730: , x_msg_data out nocopy VARCHAR2
1731: , p5_a0 JTF_VARCHAR2_TABLE_100
1732: , p5_a1 JTF_NUMBER_TABLE
1733: , p5_a2 JTF_NUMBER_TABLE
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1730: , x_msg_data out nocopy VARCHAR2
1731: , p5_a0 JTF_VARCHAR2_TABLE_100
1732: , p5_a1 JTF_NUMBER_TABLE
1733: , p5_a2 JTF_NUMBER_TABLE
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1738: , p5_a7 JTF_NUMBER_TABLE
1731: , p5_a0 JTF_VARCHAR2_TABLE_100
1732: , p5_a1 JTF_NUMBER_TABLE
1733: , p5_a2 JTF_NUMBER_TABLE
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1738: , p5_a7 JTF_NUMBER_TABLE
1739: , p5_a8 JTF_NUMBER_TABLE
1732: , p5_a1 JTF_NUMBER_TABLE
1733: , p5_a2 JTF_NUMBER_TABLE
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1738: , p5_a7 JTF_NUMBER_TABLE
1739: , p5_a8 JTF_NUMBER_TABLE
1740: , p5_a9 JTF_VARCHAR2_TABLE_100
1734: , p5_a3 JTF_NUMBER_TABLE
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1738: , p5_a7 JTF_NUMBER_TABLE
1739: , p5_a8 JTF_NUMBER_TABLE
1740: , p5_a9 JTF_VARCHAR2_TABLE_100
1741: , p5_a10 JTF_DATE_TABLE
1742: , p5_a11 JTF_VARCHAR2_TABLE_800
1735: , p5_a4 JTF_NUMBER_TABLE
1736: , p5_a5 JTF_NUMBER_TABLE
1737: , p5_a6 JTF_VARCHAR2_TABLE_100
1738: , p5_a7 JTF_NUMBER_TABLE
1739: , p5_a8 JTF_NUMBER_TABLE
1740: , p5_a9 JTF_VARCHAR2_TABLE_100
1741: , p5_a10 JTF_DATE_TABLE
1742: , p5_a11 JTF_VARCHAR2_TABLE_800
1743: , p5_a12 JTF_VARCHAR2_TABLE_100
1743: , p5_a12 JTF_VARCHAR2_TABLE_100
1744: , p5_a13 JTF_VARCHAR2_TABLE_100
1745: , p5_a14 JTF_VARCHAR2_TABLE_100
1746: , p5_a15 JTF_VARCHAR2_TABLE_100
1747: , p5_a16 JTF_NUMBER_TABLE
1748: , p5_a17 JTF_VARCHAR2_TABLE_100
1749: , p5_a18 JTF_NUMBER_TABLE
1750: , p5_a19 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1745: , p5_a14 JTF_VARCHAR2_TABLE_100
1746: , p5_a15 JTF_VARCHAR2_TABLE_100
1747: , p5_a16 JTF_NUMBER_TABLE
1748: , p5_a17 JTF_VARCHAR2_TABLE_100
1749: , p5_a18 JTF_NUMBER_TABLE
1750: , p5_a19 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1752: , p5_a21 JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1746: , p5_a15 JTF_VARCHAR2_TABLE_100
1747: , p5_a16 JTF_NUMBER_TABLE
1748: , p5_a17 JTF_VARCHAR2_TABLE_100
1749: , p5_a18 JTF_NUMBER_TABLE
1750: , p5_a19 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1752: , p5_a21 JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1754: , p5_a23 JTF_DATE_TABLE
1748: , p5_a17 JTF_VARCHAR2_TABLE_100
1749: , p5_a18 JTF_NUMBER_TABLE
1750: , p5_a19 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1752: , p5_a21 JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1754: , p5_a23 JTF_DATE_TABLE
1755: , p5_a24 JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1749: , p5_a18 JTF_NUMBER_TABLE
1750: , p5_a19 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1752: , p5_a21 JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1754: , p5_a23 JTF_DATE_TABLE
1755: , p5_a24 JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1757: , p5_a26 JTF_NUMBER_TABLE
1751: , p5_a20 JTF_DATE_TABLE
1752: , p5_a21 JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1754: , p5_a23 JTF_DATE_TABLE
1755: , p5_a24 JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1757: , p5_a26 JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1753: , p5_a22 JTF_NUMBER_TABLE
1754: , p5_a23 JTF_DATE_TABLE
1755: , p5_a24 JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1757: , p5_a26 JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1755: , p5_a24 JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1757: , p5_a26 JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1756: , p5_a25 JTF_DATE_TABLE
1757: , p5_a26 JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1757: , p5_a26 JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765: , p6_a7 out nocopy JTF_NUMBER_TABLE
1758: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765: , p6_a7 out nocopy JTF_NUMBER_TABLE
1766: , p6_a8 out nocopy JTF_NUMBER_TABLE
1759: , p6_a1 out nocopy JTF_NUMBER_TABLE
1760: , p6_a2 out nocopy JTF_NUMBER_TABLE
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765: , p6_a7 out nocopy JTF_NUMBER_TABLE
1766: , p6_a8 out nocopy JTF_NUMBER_TABLE
1767: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1761: , p6_a3 out nocopy JTF_NUMBER_TABLE
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765: , p6_a7 out nocopy JTF_NUMBER_TABLE
1766: , p6_a8 out nocopy JTF_NUMBER_TABLE
1767: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1768: , p6_a10 out nocopy JTF_DATE_TABLE
1769: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
1762: , p6_a4 out nocopy JTF_NUMBER_TABLE
1763: , p6_a5 out nocopy JTF_NUMBER_TABLE
1764: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765: , p6_a7 out nocopy JTF_NUMBER_TABLE
1766: , p6_a8 out nocopy JTF_NUMBER_TABLE
1767: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1768: , p6_a10 out nocopy JTF_DATE_TABLE
1769: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
1770: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1771: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1772: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1773: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1774: , p6_a16 out nocopy JTF_NUMBER_TABLE
1775: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a18 out nocopy JTF_NUMBER_TABLE
1777: , p6_a19 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1772: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1773: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1774: , p6_a16 out nocopy JTF_NUMBER_TABLE
1775: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a18 out nocopy JTF_NUMBER_TABLE
1777: , p6_a19 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1779: , p6_a21 out nocopy JTF_NUMBER_TABLE
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1773: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1774: , p6_a16 out nocopy JTF_NUMBER_TABLE
1775: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a18 out nocopy JTF_NUMBER_TABLE
1777: , p6_a19 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1779: , p6_a21 out nocopy JTF_NUMBER_TABLE
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1781: , p6_a23 out nocopy JTF_DATE_TABLE
1775: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a18 out nocopy JTF_NUMBER_TABLE
1777: , p6_a19 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1779: , p6_a21 out nocopy JTF_NUMBER_TABLE
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1781: , p6_a23 out nocopy JTF_DATE_TABLE
1782: , p6_a24 out nocopy JTF_NUMBER_TABLE
1783: , p6_a25 out nocopy JTF_DATE_TABLE
1776: , p6_a18 out nocopy JTF_NUMBER_TABLE
1777: , p6_a19 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1779: , p6_a21 out nocopy JTF_NUMBER_TABLE
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1781: , p6_a23 out nocopy JTF_DATE_TABLE
1782: , p6_a24 out nocopy JTF_NUMBER_TABLE
1783: , p6_a25 out nocopy JTF_DATE_TABLE
1784: , p6_a26 out nocopy JTF_NUMBER_TABLE
1778: , p6_a20 out nocopy JTF_DATE_TABLE
1779: , p6_a21 out nocopy JTF_NUMBER_TABLE
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1781: , p6_a23 out nocopy JTF_DATE_TABLE
1782: , p6_a24 out nocopy JTF_NUMBER_TABLE
1783: , p6_a25 out nocopy JTF_DATE_TABLE
1784: , p6_a26 out nocopy JTF_NUMBER_TABLE
1785: )
1786:
1780: , p6_a22 out nocopy JTF_NUMBER_TABLE
1781: , p6_a23 out nocopy JTF_DATE_TABLE
1782: , p6_a24 out nocopy JTF_NUMBER_TABLE
1783: , p6_a25 out nocopy JTF_DATE_TABLE
1784: , p6_a26 out nocopy JTF_NUMBER_TABLE
1785: )
1786:
1787: as
1788: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1877: , x_return_status out nocopy VARCHAR2
1878: , x_msg_count out nocopy NUMBER
1879: , x_msg_data out nocopy VARCHAR2
1880: , p5_a0 JTF_VARCHAR2_TABLE_100
1881: , p5_a1 JTF_NUMBER_TABLE
1882: , p5_a2 JTF_NUMBER_TABLE
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1878: , x_msg_count out nocopy NUMBER
1879: , x_msg_data out nocopy VARCHAR2
1880: , p5_a0 JTF_VARCHAR2_TABLE_100
1881: , p5_a1 JTF_NUMBER_TABLE
1882: , p5_a2 JTF_NUMBER_TABLE
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1879: , x_msg_data out nocopy VARCHAR2
1880: , p5_a0 JTF_VARCHAR2_TABLE_100
1881: , p5_a1 JTF_NUMBER_TABLE
1882: , p5_a2 JTF_NUMBER_TABLE
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1887: , p5_a7 JTF_NUMBER_TABLE
1880: , p5_a0 JTF_VARCHAR2_TABLE_100
1881: , p5_a1 JTF_NUMBER_TABLE
1882: , p5_a2 JTF_NUMBER_TABLE
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1887: , p5_a7 JTF_NUMBER_TABLE
1888: , p5_a8 JTF_NUMBER_TABLE
1881: , p5_a1 JTF_NUMBER_TABLE
1882: , p5_a2 JTF_NUMBER_TABLE
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1887: , p5_a7 JTF_NUMBER_TABLE
1888: , p5_a8 JTF_NUMBER_TABLE
1889: , p5_a9 JTF_VARCHAR2_TABLE_100
1883: , p5_a3 JTF_NUMBER_TABLE
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1887: , p5_a7 JTF_NUMBER_TABLE
1888: , p5_a8 JTF_NUMBER_TABLE
1889: , p5_a9 JTF_VARCHAR2_TABLE_100
1890: , p5_a10 JTF_DATE_TABLE
1891: , p5_a11 JTF_VARCHAR2_TABLE_800
1884: , p5_a4 JTF_NUMBER_TABLE
1885: , p5_a5 JTF_NUMBER_TABLE
1886: , p5_a6 JTF_VARCHAR2_TABLE_100
1887: , p5_a7 JTF_NUMBER_TABLE
1888: , p5_a8 JTF_NUMBER_TABLE
1889: , p5_a9 JTF_VARCHAR2_TABLE_100
1890: , p5_a10 JTF_DATE_TABLE
1891: , p5_a11 JTF_VARCHAR2_TABLE_800
1892: , p5_a12 JTF_VARCHAR2_TABLE_100
1892: , p5_a12 JTF_VARCHAR2_TABLE_100
1893: , p5_a13 JTF_VARCHAR2_TABLE_100
1894: , p5_a14 JTF_VARCHAR2_TABLE_100
1895: , p5_a15 JTF_VARCHAR2_TABLE_100
1896: , p5_a16 JTF_NUMBER_TABLE
1897: , p5_a17 JTF_VARCHAR2_TABLE_100
1898: , p5_a18 JTF_NUMBER_TABLE
1899: , p5_a19 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1894: , p5_a14 JTF_VARCHAR2_TABLE_100
1895: , p5_a15 JTF_VARCHAR2_TABLE_100
1896: , p5_a16 JTF_NUMBER_TABLE
1897: , p5_a17 JTF_VARCHAR2_TABLE_100
1898: , p5_a18 JTF_NUMBER_TABLE
1899: , p5_a19 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1901: , p5_a21 JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1895: , p5_a15 JTF_VARCHAR2_TABLE_100
1896: , p5_a16 JTF_NUMBER_TABLE
1897: , p5_a17 JTF_VARCHAR2_TABLE_100
1898: , p5_a18 JTF_NUMBER_TABLE
1899: , p5_a19 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1901: , p5_a21 JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1903: , p5_a23 JTF_DATE_TABLE
1897: , p5_a17 JTF_VARCHAR2_TABLE_100
1898: , p5_a18 JTF_NUMBER_TABLE
1899: , p5_a19 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1901: , p5_a21 JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1903: , p5_a23 JTF_DATE_TABLE
1904: , p5_a24 JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1898: , p5_a18 JTF_NUMBER_TABLE
1899: , p5_a19 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1901: , p5_a21 JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1903: , p5_a23 JTF_DATE_TABLE
1904: , p5_a24 JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1906: , p5_a26 JTF_NUMBER_TABLE
1900: , p5_a20 JTF_DATE_TABLE
1901: , p5_a21 JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1903: , p5_a23 JTF_DATE_TABLE
1904: , p5_a24 JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1906: , p5_a26 JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1902: , p5_a22 JTF_NUMBER_TABLE
1903: , p5_a23 JTF_DATE_TABLE
1904: , p5_a24 JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1906: , p5_a26 JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1904: , p5_a24 JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1906: , p5_a26 JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1905: , p5_a25 JTF_DATE_TABLE
1906: , p5_a26 JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1906: , p5_a26 JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1914: , p6_a7 out nocopy JTF_NUMBER_TABLE
1907: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1914: , p6_a7 out nocopy JTF_NUMBER_TABLE
1915: , p6_a8 out nocopy JTF_NUMBER_TABLE
1908: , p6_a1 out nocopy JTF_NUMBER_TABLE
1909: , p6_a2 out nocopy JTF_NUMBER_TABLE
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1914: , p6_a7 out nocopy JTF_NUMBER_TABLE
1915: , p6_a8 out nocopy JTF_NUMBER_TABLE
1916: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1910: , p6_a3 out nocopy JTF_NUMBER_TABLE
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1914: , p6_a7 out nocopy JTF_NUMBER_TABLE
1915: , p6_a8 out nocopy JTF_NUMBER_TABLE
1916: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1917: , p6_a10 out nocopy JTF_DATE_TABLE
1918: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
1911: , p6_a4 out nocopy JTF_NUMBER_TABLE
1912: , p6_a5 out nocopy JTF_NUMBER_TABLE
1913: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1914: , p6_a7 out nocopy JTF_NUMBER_TABLE
1915: , p6_a8 out nocopy JTF_NUMBER_TABLE
1916: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1917: , p6_a10 out nocopy JTF_DATE_TABLE
1918: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
1919: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1923: , p6_a16 out nocopy JTF_NUMBER_TABLE
1924: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1925: , p6_a18 out nocopy JTF_NUMBER_TABLE
1926: , p6_a19 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1921: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1923: , p6_a16 out nocopy JTF_NUMBER_TABLE
1924: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1925: , p6_a18 out nocopy JTF_NUMBER_TABLE
1926: , p6_a19 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1928: , p6_a21 out nocopy JTF_NUMBER_TABLE
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1922: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1923: , p6_a16 out nocopy JTF_NUMBER_TABLE
1924: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1925: , p6_a18 out nocopy JTF_NUMBER_TABLE
1926: , p6_a19 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1928: , p6_a21 out nocopy JTF_NUMBER_TABLE
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1930: , p6_a23 out nocopy JTF_DATE_TABLE
1924: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1925: , p6_a18 out nocopy JTF_NUMBER_TABLE
1926: , p6_a19 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1928: , p6_a21 out nocopy JTF_NUMBER_TABLE
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1930: , p6_a23 out nocopy JTF_DATE_TABLE
1931: , p6_a24 out nocopy JTF_NUMBER_TABLE
1932: , p6_a25 out nocopy JTF_DATE_TABLE
1925: , p6_a18 out nocopy JTF_NUMBER_TABLE
1926: , p6_a19 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1928: , p6_a21 out nocopy JTF_NUMBER_TABLE
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1930: , p6_a23 out nocopy JTF_DATE_TABLE
1931: , p6_a24 out nocopy JTF_NUMBER_TABLE
1932: , p6_a25 out nocopy JTF_DATE_TABLE
1933: , p6_a26 out nocopy JTF_NUMBER_TABLE
1927: , p6_a20 out nocopy JTF_DATE_TABLE
1928: , p6_a21 out nocopy JTF_NUMBER_TABLE
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1930: , p6_a23 out nocopy JTF_DATE_TABLE
1931: , p6_a24 out nocopy JTF_NUMBER_TABLE
1932: , p6_a25 out nocopy JTF_DATE_TABLE
1933: , p6_a26 out nocopy JTF_NUMBER_TABLE
1934: )
1935:
1929: , p6_a22 out nocopy JTF_NUMBER_TABLE
1930: , p6_a23 out nocopy JTF_DATE_TABLE
1931: , p6_a24 out nocopy JTF_NUMBER_TABLE
1932: , p6_a25 out nocopy JTF_DATE_TABLE
1933: , p6_a26 out nocopy JTF_NUMBER_TABLE
1934: )
1935:
1936: as
1937: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2115: , x_return_status out nocopy VARCHAR2
2116: , x_msg_count out nocopy NUMBER
2117: , x_msg_data out nocopy VARCHAR2
2118: , p5_a0 JTF_VARCHAR2_TABLE_100
2119: , p5_a1 JTF_NUMBER_TABLE
2120: , p5_a2 JTF_NUMBER_TABLE
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2116: , x_msg_count out nocopy NUMBER
2117: , x_msg_data out nocopy VARCHAR2
2118: , p5_a0 JTF_VARCHAR2_TABLE_100
2119: , p5_a1 JTF_NUMBER_TABLE
2120: , p5_a2 JTF_NUMBER_TABLE
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2117: , x_msg_data out nocopy VARCHAR2
2118: , p5_a0 JTF_VARCHAR2_TABLE_100
2119: , p5_a1 JTF_NUMBER_TABLE
2120: , p5_a2 JTF_NUMBER_TABLE
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2125: , p5_a7 JTF_NUMBER_TABLE
2118: , p5_a0 JTF_VARCHAR2_TABLE_100
2119: , p5_a1 JTF_NUMBER_TABLE
2120: , p5_a2 JTF_NUMBER_TABLE
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2125: , p5_a7 JTF_NUMBER_TABLE
2126: , p5_a8 JTF_NUMBER_TABLE
2119: , p5_a1 JTF_NUMBER_TABLE
2120: , p5_a2 JTF_NUMBER_TABLE
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2125: , p5_a7 JTF_NUMBER_TABLE
2126: , p5_a8 JTF_NUMBER_TABLE
2127: , p5_a9 JTF_VARCHAR2_TABLE_100
2121: , p5_a3 JTF_NUMBER_TABLE
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2125: , p5_a7 JTF_NUMBER_TABLE
2126: , p5_a8 JTF_NUMBER_TABLE
2127: , p5_a9 JTF_VARCHAR2_TABLE_100
2128: , p5_a10 JTF_DATE_TABLE
2129: , p5_a11 JTF_VARCHAR2_TABLE_800
2122: , p5_a4 JTF_NUMBER_TABLE
2123: , p5_a5 JTF_NUMBER_TABLE
2124: , p5_a6 JTF_VARCHAR2_TABLE_100
2125: , p5_a7 JTF_NUMBER_TABLE
2126: , p5_a8 JTF_NUMBER_TABLE
2127: , p5_a9 JTF_VARCHAR2_TABLE_100
2128: , p5_a10 JTF_DATE_TABLE
2129: , p5_a11 JTF_VARCHAR2_TABLE_800
2130: , p5_a12 JTF_VARCHAR2_TABLE_100
2130: , p5_a12 JTF_VARCHAR2_TABLE_100
2131: , p5_a13 JTF_VARCHAR2_TABLE_100
2132: , p5_a14 JTF_VARCHAR2_TABLE_100
2133: , p5_a15 JTF_VARCHAR2_TABLE_100
2134: , p5_a16 JTF_NUMBER_TABLE
2135: , p5_a17 JTF_VARCHAR2_TABLE_100
2136: , p5_a18 JTF_NUMBER_TABLE
2137: , p5_a19 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2132: , p5_a14 JTF_VARCHAR2_TABLE_100
2133: , p5_a15 JTF_VARCHAR2_TABLE_100
2134: , p5_a16 JTF_NUMBER_TABLE
2135: , p5_a17 JTF_VARCHAR2_TABLE_100
2136: , p5_a18 JTF_NUMBER_TABLE
2137: , p5_a19 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2139: , p5_a21 JTF_NUMBER_TABLE
2140: , p5_a22 JTF_NUMBER_TABLE
2133: , p5_a15 JTF_VARCHAR2_TABLE_100
2134: , p5_a16 JTF_NUMBER_TABLE
2135: , p5_a17 JTF_VARCHAR2_TABLE_100
2136: , p5_a18 JTF_NUMBER_TABLE
2137: , p5_a19 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2139: , p5_a21 JTF_NUMBER_TABLE
2140: , p5_a22 JTF_NUMBER_TABLE
2141: , p5_a23 JTF_DATE_TABLE
2135: , p5_a17 JTF_VARCHAR2_TABLE_100
2136: , p5_a18 JTF_NUMBER_TABLE
2137: , p5_a19 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2139: , p5_a21 JTF_NUMBER_TABLE
2140: , p5_a22 JTF_NUMBER_TABLE
2141: , p5_a23 JTF_DATE_TABLE
2142: , p5_a24 JTF_NUMBER_TABLE
2143: , p5_a25 JTF_DATE_TABLE
2136: , p5_a18 JTF_NUMBER_TABLE
2137: , p5_a19 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2139: , p5_a21 JTF_NUMBER_TABLE
2140: , p5_a22 JTF_NUMBER_TABLE
2141: , p5_a23 JTF_DATE_TABLE
2142: , p5_a24 JTF_NUMBER_TABLE
2143: , p5_a25 JTF_DATE_TABLE
2144: , p5_a26 JTF_NUMBER_TABLE
2138: , p5_a20 JTF_DATE_TABLE
2139: , p5_a21 JTF_NUMBER_TABLE
2140: , p5_a22 JTF_NUMBER_TABLE
2141: , p5_a23 JTF_DATE_TABLE
2142: , p5_a24 JTF_NUMBER_TABLE
2143: , p5_a25 JTF_DATE_TABLE
2144: , p5_a26 JTF_NUMBER_TABLE
2145: )
2146:
2140: , p5_a22 JTF_NUMBER_TABLE
2141: , p5_a23 JTF_DATE_TABLE
2142: , p5_a24 JTF_NUMBER_TABLE
2143: , p5_a25 JTF_DATE_TABLE
2144: , p5_a26 JTF_NUMBER_TABLE
2145: )
2146:
2147: as
2148: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2352: , x_return_status out nocopy VARCHAR2
2353: , x_msg_count out nocopy NUMBER
2354: , x_msg_data out nocopy VARCHAR2
2355: , p5_a0 JTF_VARCHAR2_TABLE_100
2356: , p5_a1 JTF_NUMBER_TABLE
2357: , p5_a2 JTF_NUMBER_TABLE
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2353: , x_msg_count out nocopy NUMBER
2354: , x_msg_data out nocopy VARCHAR2
2355: , p5_a0 JTF_VARCHAR2_TABLE_100
2356: , p5_a1 JTF_NUMBER_TABLE
2357: , p5_a2 JTF_NUMBER_TABLE
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2354: , x_msg_data out nocopy VARCHAR2
2355: , p5_a0 JTF_VARCHAR2_TABLE_100
2356: , p5_a1 JTF_NUMBER_TABLE
2357: , p5_a2 JTF_NUMBER_TABLE
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2362: , p5_a7 JTF_NUMBER_TABLE
2355: , p5_a0 JTF_VARCHAR2_TABLE_100
2356: , p5_a1 JTF_NUMBER_TABLE
2357: , p5_a2 JTF_NUMBER_TABLE
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2362: , p5_a7 JTF_NUMBER_TABLE
2363: , p5_a8 JTF_NUMBER_TABLE
2356: , p5_a1 JTF_NUMBER_TABLE
2357: , p5_a2 JTF_NUMBER_TABLE
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2362: , p5_a7 JTF_NUMBER_TABLE
2363: , p5_a8 JTF_NUMBER_TABLE
2364: , p5_a9 JTF_VARCHAR2_TABLE_100
2358: , p5_a3 JTF_NUMBER_TABLE
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2362: , p5_a7 JTF_NUMBER_TABLE
2363: , p5_a8 JTF_NUMBER_TABLE
2364: , p5_a9 JTF_VARCHAR2_TABLE_100
2365: , p5_a10 JTF_DATE_TABLE
2366: , p5_a11 JTF_VARCHAR2_TABLE_800
2359: , p5_a4 JTF_NUMBER_TABLE
2360: , p5_a5 JTF_NUMBER_TABLE
2361: , p5_a6 JTF_VARCHAR2_TABLE_100
2362: , p5_a7 JTF_NUMBER_TABLE
2363: , p5_a8 JTF_NUMBER_TABLE
2364: , p5_a9 JTF_VARCHAR2_TABLE_100
2365: , p5_a10 JTF_DATE_TABLE
2366: , p5_a11 JTF_VARCHAR2_TABLE_800
2367: , p5_a12 JTF_VARCHAR2_TABLE_100
2367: , p5_a12 JTF_VARCHAR2_TABLE_100
2368: , p5_a13 JTF_VARCHAR2_TABLE_100
2369: , p5_a14 JTF_VARCHAR2_TABLE_100
2370: , p5_a15 JTF_VARCHAR2_TABLE_100
2371: , p5_a16 JTF_NUMBER_TABLE
2372: , p5_a17 JTF_VARCHAR2_TABLE_100
2373: , p5_a18 JTF_NUMBER_TABLE
2374: , p5_a19 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2369: , p5_a14 JTF_VARCHAR2_TABLE_100
2370: , p5_a15 JTF_VARCHAR2_TABLE_100
2371: , p5_a16 JTF_NUMBER_TABLE
2372: , p5_a17 JTF_VARCHAR2_TABLE_100
2373: , p5_a18 JTF_NUMBER_TABLE
2374: , p5_a19 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2376: , p5_a21 JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2370: , p5_a15 JTF_VARCHAR2_TABLE_100
2371: , p5_a16 JTF_NUMBER_TABLE
2372: , p5_a17 JTF_VARCHAR2_TABLE_100
2373: , p5_a18 JTF_NUMBER_TABLE
2374: , p5_a19 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2376: , p5_a21 JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2378: , p5_a23 JTF_DATE_TABLE
2372: , p5_a17 JTF_VARCHAR2_TABLE_100
2373: , p5_a18 JTF_NUMBER_TABLE
2374: , p5_a19 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2376: , p5_a21 JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2378: , p5_a23 JTF_DATE_TABLE
2379: , p5_a24 JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2373: , p5_a18 JTF_NUMBER_TABLE
2374: , p5_a19 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2376: , p5_a21 JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2378: , p5_a23 JTF_DATE_TABLE
2379: , p5_a24 JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2381: , p5_a26 JTF_NUMBER_TABLE
2375: , p5_a20 JTF_DATE_TABLE
2376: , p5_a21 JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2378: , p5_a23 JTF_DATE_TABLE
2379: , p5_a24 JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2381: , p5_a26 JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2377: , p5_a22 JTF_NUMBER_TABLE
2378: , p5_a23 JTF_DATE_TABLE
2379: , p5_a24 JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2381: , p5_a26 JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2379: , p5_a24 JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2381: , p5_a26 JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2380: , p5_a25 JTF_DATE_TABLE
2381: , p5_a26 JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p5_a26 JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2389: , p6_a7 out nocopy JTF_NUMBER_TABLE
2382: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2389: , p6_a7 out nocopy JTF_NUMBER_TABLE
2390: , p6_a8 out nocopy JTF_NUMBER_TABLE
2383: , p6_a1 out nocopy JTF_NUMBER_TABLE
2384: , p6_a2 out nocopy JTF_NUMBER_TABLE
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2389: , p6_a7 out nocopy JTF_NUMBER_TABLE
2390: , p6_a8 out nocopy JTF_NUMBER_TABLE
2391: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2385: , p6_a3 out nocopy JTF_NUMBER_TABLE
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2389: , p6_a7 out nocopy JTF_NUMBER_TABLE
2390: , p6_a8 out nocopy JTF_NUMBER_TABLE
2391: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2392: , p6_a10 out nocopy JTF_DATE_TABLE
2393: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
2386: , p6_a4 out nocopy JTF_NUMBER_TABLE
2387: , p6_a5 out nocopy JTF_NUMBER_TABLE
2388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2389: , p6_a7 out nocopy JTF_NUMBER_TABLE
2390: , p6_a8 out nocopy JTF_NUMBER_TABLE
2391: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2392: , p6_a10 out nocopy JTF_DATE_TABLE
2393: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
2394: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2394: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2395: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2396: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2397: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2398: , p6_a16 out nocopy JTF_NUMBER_TABLE
2399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2400: , p6_a18 out nocopy JTF_NUMBER_TABLE
2401: , p6_a19 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2396: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2397: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2398: , p6_a16 out nocopy JTF_NUMBER_TABLE
2399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2400: , p6_a18 out nocopy JTF_NUMBER_TABLE
2401: , p6_a19 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2403: , p6_a21 out nocopy JTF_NUMBER_TABLE
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2397: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2398: , p6_a16 out nocopy JTF_NUMBER_TABLE
2399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2400: , p6_a18 out nocopy JTF_NUMBER_TABLE
2401: , p6_a19 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2403: , p6_a21 out nocopy JTF_NUMBER_TABLE
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2405: , p6_a23 out nocopy JTF_DATE_TABLE
2399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2400: , p6_a18 out nocopy JTF_NUMBER_TABLE
2401: , p6_a19 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2403: , p6_a21 out nocopy JTF_NUMBER_TABLE
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2405: , p6_a23 out nocopy JTF_DATE_TABLE
2406: , p6_a24 out nocopy JTF_NUMBER_TABLE
2407: , p6_a25 out nocopy JTF_DATE_TABLE
2400: , p6_a18 out nocopy JTF_NUMBER_TABLE
2401: , p6_a19 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2403: , p6_a21 out nocopy JTF_NUMBER_TABLE
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2405: , p6_a23 out nocopy JTF_DATE_TABLE
2406: , p6_a24 out nocopy JTF_NUMBER_TABLE
2407: , p6_a25 out nocopy JTF_DATE_TABLE
2408: , p6_a26 out nocopy JTF_NUMBER_TABLE
2402: , p6_a20 out nocopy JTF_DATE_TABLE
2403: , p6_a21 out nocopy JTF_NUMBER_TABLE
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2405: , p6_a23 out nocopy JTF_DATE_TABLE
2406: , p6_a24 out nocopy JTF_NUMBER_TABLE
2407: , p6_a25 out nocopy JTF_DATE_TABLE
2408: , p6_a26 out nocopy JTF_NUMBER_TABLE
2409: )
2410:
2404: , p6_a22 out nocopy JTF_NUMBER_TABLE
2405: , p6_a23 out nocopy JTF_DATE_TABLE
2406: , p6_a24 out nocopy JTF_NUMBER_TABLE
2407: , p6_a25 out nocopy JTF_DATE_TABLE
2408: , p6_a26 out nocopy JTF_NUMBER_TABLE
2409: )
2410:
2411: as
2412: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2590: , x_return_status out nocopy VARCHAR2
2591: , x_msg_count out nocopy NUMBER
2592: , x_msg_data out nocopy VARCHAR2
2593: , p5_a0 JTF_VARCHAR2_TABLE_100
2594: , p5_a1 JTF_NUMBER_TABLE
2595: , p5_a2 JTF_NUMBER_TABLE
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2591: , x_msg_count out nocopy NUMBER
2592: , x_msg_data out nocopy VARCHAR2
2593: , p5_a0 JTF_VARCHAR2_TABLE_100
2594: , p5_a1 JTF_NUMBER_TABLE
2595: , p5_a2 JTF_NUMBER_TABLE
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2592: , x_msg_data out nocopy VARCHAR2
2593: , p5_a0 JTF_VARCHAR2_TABLE_100
2594: , p5_a1 JTF_NUMBER_TABLE
2595: , p5_a2 JTF_NUMBER_TABLE
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2600: , p5_a7 JTF_NUMBER_TABLE
2593: , p5_a0 JTF_VARCHAR2_TABLE_100
2594: , p5_a1 JTF_NUMBER_TABLE
2595: , p5_a2 JTF_NUMBER_TABLE
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2600: , p5_a7 JTF_NUMBER_TABLE
2601: , p5_a8 JTF_NUMBER_TABLE
2594: , p5_a1 JTF_NUMBER_TABLE
2595: , p5_a2 JTF_NUMBER_TABLE
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2600: , p5_a7 JTF_NUMBER_TABLE
2601: , p5_a8 JTF_NUMBER_TABLE
2602: , p5_a9 JTF_VARCHAR2_TABLE_100
2596: , p5_a3 JTF_NUMBER_TABLE
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2600: , p5_a7 JTF_NUMBER_TABLE
2601: , p5_a8 JTF_NUMBER_TABLE
2602: , p5_a9 JTF_VARCHAR2_TABLE_100
2603: , p5_a10 JTF_DATE_TABLE
2604: , p5_a11 JTF_VARCHAR2_TABLE_800
2597: , p5_a4 JTF_NUMBER_TABLE
2598: , p5_a5 JTF_NUMBER_TABLE
2599: , p5_a6 JTF_VARCHAR2_TABLE_100
2600: , p5_a7 JTF_NUMBER_TABLE
2601: , p5_a8 JTF_NUMBER_TABLE
2602: , p5_a9 JTF_VARCHAR2_TABLE_100
2603: , p5_a10 JTF_DATE_TABLE
2604: , p5_a11 JTF_VARCHAR2_TABLE_800
2605: , p5_a12 JTF_VARCHAR2_TABLE_100
2605: , p5_a12 JTF_VARCHAR2_TABLE_100
2606: , p5_a13 JTF_VARCHAR2_TABLE_100
2607: , p5_a14 JTF_VARCHAR2_TABLE_100
2608: , p5_a15 JTF_VARCHAR2_TABLE_100
2609: , p5_a16 JTF_NUMBER_TABLE
2610: , p5_a17 JTF_VARCHAR2_TABLE_100
2611: , p5_a18 JTF_NUMBER_TABLE
2612: , p5_a19 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2607: , p5_a14 JTF_VARCHAR2_TABLE_100
2608: , p5_a15 JTF_VARCHAR2_TABLE_100
2609: , p5_a16 JTF_NUMBER_TABLE
2610: , p5_a17 JTF_VARCHAR2_TABLE_100
2611: , p5_a18 JTF_NUMBER_TABLE
2612: , p5_a19 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2614: , p5_a21 JTF_NUMBER_TABLE
2615: , p5_a22 JTF_NUMBER_TABLE
2608: , p5_a15 JTF_VARCHAR2_TABLE_100
2609: , p5_a16 JTF_NUMBER_TABLE
2610: , p5_a17 JTF_VARCHAR2_TABLE_100
2611: , p5_a18 JTF_NUMBER_TABLE
2612: , p5_a19 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2614: , p5_a21 JTF_NUMBER_TABLE
2615: , p5_a22 JTF_NUMBER_TABLE
2616: , p5_a23 JTF_DATE_TABLE
2610: , p5_a17 JTF_VARCHAR2_TABLE_100
2611: , p5_a18 JTF_NUMBER_TABLE
2612: , p5_a19 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2614: , p5_a21 JTF_NUMBER_TABLE
2615: , p5_a22 JTF_NUMBER_TABLE
2616: , p5_a23 JTF_DATE_TABLE
2617: , p5_a24 JTF_NUMBER_TABLE
2618: , p5_a25 JTF_DATE_TABLE
2611: , p5_a18 JTF_NUMBER_TABLE
2612: , p5_a19 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2614: , p5_a21 JTF_NUMBER_TABLE
2615: , p5_a22 JTF_NUMBER_TABLE
2616: , p5_a23 JTF_DATE_TABLE
2617: , p5_a24 JTF_NUMBER_TABLE
2618: , p5_a25 JTF_DATE_TABLE
2619: , p5_a26 JTF_NUMBER_TABLE
2613: , p5_a20 JTF_DATE_TABLE
2614: , p5_a21 JTF_NUMBER_TABLE
2615: , p5_a22 JTF_NUMBER_TABLE
2616: , p5_a23 JTF_DATE_TABLE
2617: , p5_a24 JTF_NUMBER_TABLE
2618: , p5_a25 JTF_DATE_TABLE
2619: , p5_a26 JTF_NUMBER_TABLE
2620: )
2621:
2615: , p5_a22 JTF_NUMBER_TABLE
2616: , p5_a23 JTF_DATE_TABLE
2617: , p5_a24 JTF_NUMBER_TABLE
2618: , p5_a25 JTF_DATE_TABLE
2619: , p5_a26 JTF_NUMBER_TABLE
2620: )
2621:
2622: as
2623: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2769: , x_return_status out nocopy VARCHAR2
2770: , x_msg_count out nocopy NUMBER
2771: , x_msg_data out nocopy VARCHAR2
2772: , p5_a0 JTF_VARCHAR2_TABLE_100
2773: , p5_a1 JTF_NUMBER_TABLE
2774: , p5_a2 JTF_NUMBER_TABLE
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2770: , x_msg_count out nocopy NUMBER
2771: , x_msg_data out nocopy VARCHAR2
2772: , p5_a0 JTF_VARCHAR2_TABLE_100
2773: , p5_a1 JTF_NUMBER_TABLE
2774: , p5_a2 JTF_NUMBER_TABLE
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2771: , x_msg_data out nocopy VARCHAR2
2772: , p5_a0 JTF_VARCHAR2_TABLE_100
2773: , p5_a1 JTF_NUMBER_TABLE
2774: , p5_a2 JTF_NUMBER_TABLE
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2779: , p5_a7 JTF_NUMBER_TABLE
2772: , p5_a0 JTF_VARCHAR2_TABLE_100
2773: , p5_a1 JTF_NUMBER_TABLE
2774: , p5_a2 JTF_NUMBER_TABLE
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2779: , p5_a7 JTF_NUMBER_TABLE
2780: , p5_a8 JTF_NUMBER_TABLE
2773: , p5_a1 JTF_NUMBER_TABLE
2774: , p5_a2 JTF_NUMBER_TABLE
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2779: , p5_a7 JTF_NUMBER_TABLE
2780: , p5_a8 JTF_NUMBER_TABLE
2781: , p5_a9 JTF_VARCHAR2_TABLE_100
2775: , p5_a3 JTF_NUMBER_TABLE
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2779: , p5_a7 JTF_NUMBER_TABLE
2780: , p5_a8 JTF_NUMBER_TABLE
2781: , p5_a9 JTF_VARCHAR2_TABLE_100
2782: , p5_a10 JTF_DATE_TABLE
2783: , p5_a11 JTF_VARCHAR2_TABLE_800
2776: , p5_a4 JTF_NUMBER_TABLE
2777: , p5_a5 JTF_NUMBER_TABLE
2778: , p5_a6 JTF_VARCHAR2_TABLE_100
2779: , p5_a7 JTF_NUMBER_TABLE
2780: , p5_a8 JTF_NUMBER_TABLE
2781: , p5_a9 JTF_VARCHAR2_TABLE_100
2782: , p5_a10 JTF_DATE_TABLE
2783: , p5_a11 JTF_VARCHAR2_TABLE_800
2784: , p5_a12 JTF_VARCHAR2_TABLE_100
2784: , p5_a12 JTF_VARCHAR2_TABLE_100
2785: , p5_a13 JTF_VARCHAR2_TABLE_100
2786: , p5_a14 JTF_VARCHAR2_TABLE_100
2787: , p5_a15 JTF_VARCHAR2_TABLE_100
2788: , p5_a16 JTF_NUMBER_TABLE
2789: , p5_a17 JTF_VARCHAR2_TABLE_100
2790: , p5_a18 JTF_NUMBER_TABLE
2791: , p5_a19 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2786: , p5_a14 JTF_VARCHAR2_TABLE_100
2787: , p5_a15 JTF_VARCHAR2_TABLE_100
2788: , p5_a16 JTF_NUMBER_TABLE
2789: , p5_a17 JTF_VARCHAR2_TABLE_100
2790: , p5_a18 JTF_NUMBER_TABLE
2791: , p5_a19 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2793: , p5_a21 JTF_NUMBER_TABLE
2794: , p5_a22 JTF_NUMBER_TABLE
2787: , p5_a15 JTF_VARCHAR2_TABLE_100
2788: , p5_a16 JTF_NUMBER_TABLE
2789: , p5_a17 JTF_VARCHAR2_TABLE_100
2790: , p5_a18 JTF_NUMBER_TABLE
2791: , p5_a19 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2793: , p5_a21 JTF_NUMBER_TABLE
2794: , p5_a22 JTF_NUMBER_TABLE
2795: , p5_a23 JTF_DATE_TABLE
2789: , p5_a17 JTF_VARCHAR2_TABLE_100
2790: , p5_a18 JTF_NUMBER_TABLE
2791: , p5_a19 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2793: , p5_a21 JTF_NUMBER_TABLE
2794: , p5_a22 JTF_NUMBER_TABLE
2795: , p5_a23 JTF_DATE_TABLE
2796: , p5_a24 JTF_NUMBER_TABLE
2797: , p5_a25 JTF_DATE_TABLE
2790: , p5_a18 JTF_NUMBER_TABLE
2791: , p5_a19 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2793: , p5_a21 JTF_NUMBER_TABLE
2794: , p5_a22 JTF_NUMBER_TABLE
2795: , p5_a23 JTF_DATE_TABLE
2796: , p5_a24 JTF_NUMBER_TABLE
2797: , p5_a25 JTF_DATE_TABLE
2798: , p5_a26 JTF_NUMBER_TABLE
2792: , p5_a20 JTF_DATE_TABLE
2793: , p5_a21 JTF_NUMBER_TABLE
2794: , p5_a22 JTF_NUMBER_TABLE
2795: , p5_a23 JTF_DATE_TABLE
2796: , p5_a24 JTF_NUMBER_TABLE
2797: , p5_a25 JTF_DATE_TABLE
2798: , p5_a26 JTF_NUMBER_TABLE
2799: )
2800:
2794: , p5_a22 JTF_NUMBER_TABLE
2795: , p5_a23 JTF_DATE_TABLE
2796: , p5_a24 JTF_NUMBER_TABLE
2797: , p5_a25 JTF_DATE_TABLE
2798: , p5_a26 JTF_NUMBER_TABLE
2799: )
2800:
2801: as
2802: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;