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_clg_pvt.clg_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clg_pvt.clg_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clg_pvt.clg_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clg_pvt.clg_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_500
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_500
33: , a11 JTF_VARCHAR2_TABLE_500
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_500
33: , a11 JTF_VARCHAR2_TABLE_500
34: , a12 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if a0 is not null and a0.count > 0 then
103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_clg_pvt.clg_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_clg_pvt.clg_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_clg_pvt.clg_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
107: procedure rosetta_table_copy_out_p2(t okl_clg_pvt.clg_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
117: , a10 out nocopy JTF_VARCHAR2_TABLE_500
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
117: , a10 out nocopy JTF_VARCHAR2_TABLE_500
118: , a11 out nocopy JTF_VARCHAR2_TABLE_500
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE
115: , a8 out nocopy JTF_NUMBER_TABLE
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
117: , a10 out nocopy JTF_VARCHAR2_TABLE_500
118: , a11 out nocopy JTF_VARCHAR2_TABLE_500
119: , a12 out nocopy JTF_VARCHAR2_TABLE_500
128: , a21 out nocopy JTF_VARCHAR2_TABLE_500
129: , a22 out nocopy JTF_VARCHAR2_TABLE_500
130: , a23 out nocopy JTF_VARCHAR2_TABLE_500
131: , a24 out nocopy JTF_VARCHAR2_TABLE_500
132: , a25 out nocopy JTF_NUMBER_TABLE
133: , a26 out nocopy JTF_DATE_TABLE
134: , a27 out nocopy JTF_NUMBER_TABLE
135: , a28 out nocopy JTF_DATE_TABLE
136: , a29 out nocopy JTF_NUMBER_TABLE
130: , a23 out nocopy JTF_VARCHAR2_TABLE_500
131: , a24 out nocopy JTF_VARCHAR2_TABLE_500
132: , a25 out nocopy JTF_NUMBER_TABLE
133: , a26 out nocopy JTF_DATE_TABLE
134: , a27 out nocopy JTF_NUMBER_TABLE
135: , a28 out nocopy JTF_DATE_TABLE
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_DATE_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
132: , a25 out nocopy JTF_NUMBER_TABLE
133: , a26 out nocopy JTF_DATE_TABLE
134: , a27 out nocopy JTF_NUMBER_TABLE
135: , a28 out nocopy JTF_DATE_TABLE
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_DATE_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
135: , a28 out nocopy JTF_DATE_TABLE
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_DATE_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_DATE_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_500();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_500();
156: a11 := JTF_VARCHAR2_TABLE_500();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_NUMBER_TABLE();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_500();
156: a11 := JTF_VARCHAR2_TABLE_500();
157: a12 := JTF_VARCHAR2_TABLE_500();
166: a21 := JTF_VARCHAR2_TABLE_500();
167: a22 := JTF_VARCHAR2_TABLE_500();
168: a23 := JTF_VARCHAR2_TABLE_500();
169: a24 := JTF_VARCHAR2_TABLE_500();
170: a25 := JTF_NUMBER_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_DATE_TABLE();
174: a29 := JTF_NUMBER_TABLE();
168: a23 := JTF_VARCHAR2_TABLE_500();
169: a24 := JTF_VARCHAR2_TABLE_500();
170: a25 := JTF_NUMBER_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_DATE_TABLE();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_DATE_TABLE();
176: a31 := JTF_DATE_TABLE();
170: a25 := JTF_NUMBER_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_DATE_TABLE();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_DATE_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_NUMBER_TABLE();
178: a33 := JTF_NUMBER_TABLE();
173: a28 := JTF_DATE_TABLE();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_DATE_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_NUMBER_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_DATE_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_NUMBER_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_NUMBER_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
177: a32 := JTF_NUMBER_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: a9 := JTF_VARCHAR2_TABLE_100();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: a9 := JTF_VARCHAR2_TABLE_100();
190: a10 := JTF_VARCHAR2_TABLE_500();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: a9 := JTF_VARCHAR2_TABLE_100();
190: a10 := JTF_VARCHAR2_TABLE_500();
191: a11 := JTF_VARCHAR2_TABLE_500();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: a9 := JTF_VARCHAR2_TABLE_100();
190: a10 := JTF_VARCHAR2_TABLE_500();
191: a11 := JTF_VARCHAR2_TABLE_500();
192: a12 := JTF_VARCHAR2_TABLE_500();
201: a21 := JTF_VARCHAR2_TABLE_500();
202: a22 := JTF_VARCHAR2_TABLE_500();
203: a23 := JTF_VARCHAR2_TABLE_500();
204: a24 := JTF_VARCHAR2_TABLE_500();
205: a25 := JTF_NUMBER_TABLE();
206: a26 := JTF_DATE_TABLE();
207: a27 := JTF_NUMBER_TABLE();
208: a28 := JTF_DATE_TABLE();
209: a29 := JTF_NUMBER_TABLE();
203: a23 := JTF_VARCHAR2_TABLE_500();
204: a24 := JTF_VARCHAR2_TABLE_500();
205: a25 := JTF_NUMBER_TABLE();
206: a26 := JTF_DATE_TABLE();
207: a27 := JTF_NUMBER_TABLE();
208: a28 := JTF_DATE_TABLE();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_DATE_TABLE();
211: a31 := JTF_DATE_TABLE();
205: a25 := JTF_NUMBER_TABLE();
206: a26 := JTF_DATE_TABLE();
207: a27 := JTF_NUMBER_TABLE();
208: a28 := JTF_DATE_TABLE();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_DATE_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_NUMBER_TABLE();
213: a33 := JTF_NUMBER_TABLE();
208: a28 := JTF_DATE_TABLE();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_DATE_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_NUMBER_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then
215: a0.extend(t.count);
216: a1.extend(t.count);
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_DATE_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_NUMBER_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then
215: a0.extend(t.count);
216: a1.extend(t.count);
217: a2.extend(t.count);
292: end if;
293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_clg_pvt.oklcntrlvlnggrpstltbltype, a0 JTF_NUMBER_TABLE
297: , a1 JTF_VARCHAR2_TABLE_100
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_VARCHAR2_TABLE_100
300: , a4 JTF_VARCHAR2_TABLE_200
299: , a3 JTF_VARCHAR2_TABLE_100
300: , a4 JTF_VARCHAR2_TABLE_200
301: , a5 JTF_VARCHAR2_TABLE_2000
302: , a6 JTF_VARCHAR2_TABLE_2000
303: , a7 JTF_NUMBER_TABLE
304: , a8 JTF_DATE_TABLE
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_DATE_TABLE
307: , a11 JTF_NUMBER_TABLE
301: , a5 JTF_VARCHAR2_TABLE_2000
302: , a6 JTF_VARCHAR2_TABLE_2000
303: , a7 JTF_NUMBER_TABLE
304: , a8 JTF_DATE_TABLE
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_DATE_TABLE
307: , a11 JTF_NUMBER_TABLE
308: ) as
309: ddindx binary_integer; indx binary_integer;
303: , a7 JTF_NUMBER_TABLE
304: , a8 JTF_DATE_TABLE
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_DATE_TABLE
307: , a11 JTF_NUMBER_TABLE
308: ) as
309: ddindx binary_integer; indx binary_integer;
310: begin
311: if a0 is not null and a0.count > 0 then
333: end loop;
334: end if;
335: end if;
336: end rosetta_table_copy_in_p5;
337: procedure rosetta_table_copy_out_p5(t okl_clg_pvt.oklcntrlvlnggrpstltbltype, a0 out nocopy JTF_NUMBER_TABLE
338: , a1 out nocopy JTF_VARCHAR2_TABLE_100
339: , a2 out nocopy JTF_VARCHAR2_TABLE_100
340: , a3 out nocopy JTF_VARCHAR2_TABLE_100
341: , a4 out nocopy JTF_VARCHAR2_TABLE_200
340: , a3 out nocopy JTF_VARCHAR2_TABLE_100
341: , a4 out nocopy JTF_VARCHAR2_TABLE_200
342: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
343: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
344: , a7 out nocopy JTF_NUMBER_TABLE
345: , a8 out nocopy JTF_DATE_TABLE
346: , a9 out nocopy JTF_NUMBER_TABLE
347: , a10 out nocopy JTF_DATE_TABLE
348: , a11 out nocopy JTF_NUMBER_TABLE
342: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
343: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
344: , a7 out nocopy JTF_NUMBER_TABLE
345: , a8 out nocopy JTF_DATE_TABLE
346: , a9 out nocopy JTF_NUMBER_TABLE
347: , a10 out nocopy JTF_DATE_TABLE
348: , a11 out nocopy JTF_NUMBER_TABLE
349: ) as
350: ddindx binary_integer; indx binary_integer;
344: , a7 out nocopy JTF_NUMBER_TABLE
345: , a8 out nocopy JTF_DATE_TABLE
346: , a9 out nocopy JTF_NUMBER_TABLE
347: , a10 out nocopy JTF_DATE_TABLE
348: , a11 out nocopy JTF_NUMBER_TABLE
349: ) as
350: ddindx binary_integer; indx binary_integer;
351: begin
352: if t is null or t.count = 0 then
349: ) as
350: ddindx binary_integer; indx binary_integer;
351: begin
352: if t is null or t.count = 0 then
353: a0 := JTF_NUMBER_TABLE();
354: a1 := JTF_VARCHAR2_TABLE_100();
355: a2 := JTF_VARCHAR2_TABLE_100();
356: a3 := JTF_VARCHAR2_TABLE_100();
357: a4 := JTF_VARCHAR2_TABLE_200();
356: a3 := JTF_VARCHAR2_TABLE_100();
357: a4 := JTF_VARCHAR2_TABLE_200();
358: a5 := JTF_VARCHAR2_TABLE_2000();
359: a6 := JTF_VARCHAR2_TABLE_2000();
360: a7 := JTF_NUMBER_TABLE();
361: a8 := JTF_DATE_TABLE();
362: a9 := JTF_NUMBER_TABLE();
363: a10 := JTF_DATE_TABLE();
364: a11 := JTF_NUMBER_TABLE();
358: a5 := JTF_VARCHAR2_TABLE_2000();
359: a6 := JTF_VARCHAR2_TABLE_2000();
360: a7 := JTF_NUMBER_TABLE();
361: a8 := JTF_DATE_TABLE();
362: a9 := JTF_NUMBER_TABLE();
363: a10 := JTF_DATE_TABLE();
364: a11 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
360: a7 := JTF_NUMBER_TABLE();
361: a8 := JTF_DATE_TABLE();
362: a9 := JTF_NUMBER_TABLE();
363: a10 := JTF_DATE_TABLE();
364: a11 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_VARCHAR2_TABLE_100();
368: a2 := JTF_VARCHAR2_TABLE_100();
362: a9 := JTF_NUMBER_TABLE();
363: a10 := JTF_DATE_TABLE();
364: a11 := JTF_NUMBER_TABLE();
365: else
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_VARCHAR2_TABLE_100();
368: a2 := JTF_VARCHAR2_TABLE_100();
369: a3 := JTF_VARCHAR2_TABLE_100();
370: a4 := JTF_VARCHAR2_TABLE_200();
369: a3 := JTF_VARCHAR2_TABLE_100();
370: a4 := JTF_VARCHAR2_TABLE_200();
371: a5 := JTF_VARCHAR2_TABLE_2000();
372: a6 := JTF_VARCHAR2_TABLE_2000();
373: a7 := JTF_NUMBER_TABLE();
374: a8 := JTF_DATE_TABLE();
375: a9 := JTF_NUMBER_TABLE();
376: a10 := JTF_DATE_TABLE();
377: a11 := JTF_NUMBER_TABLE();
371: a5 := JTF_VARCHAR2_TABLE_2000();
372: a6 := JTF_VARCHAR2_TABLE_2000();
373: a7 := JTF_NUMBER_TABLE();
374: a8 := JTF_DATE_TABLE();
375: a9 := JTF_NUMBER_TABLE();
376: a10 := JTF_DATE_TABLE();
377: a11 := JTF_NUMBER_TABLE();
378: if t.count > 0 then
379: a0.extend(t.count);
373: a7 := JTF_NUMBER_TABLE();
374: a8 := JTF_DATE_TABLE();
375: a9 := JTF_NUMBER_TABLE();
376: a10 := JTF_DATE_TABLE();
377: a11 := JTF_NUMBER_TABLE();
378: if t.count > 0 then
379: a0.extend(t.count);
380: a1.extend(t.count);
381: a2.extend(t.count);
412: end if;
413: end if;
414: end rosetta_table_copy_out_p5;
415:
416: procedure rosetta_table_copy_in_p8(t out nocopy okl_clg_pvt.clgv_tbl_type, a0 JTF_NUMBER_TABLE
417: , a1 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
413: end if;
414: end rosetta_table_copy_out_p5;
415:
416: procedure rosetta_table_copy_in_p8(t out nocopy okl_clg_pvt.clgv_tbl_type, a0 JTF_NUMBER_TABLE
417: , a1 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
414: end rosetta_table_copy_out_p5;
415:
416: procedure rosetta_table_copy_in_p8(t out nocopy okl_clg_pvt.clgv_tbl_type, a0 JTF_NUMBER_TABLE
417: , a1 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
416: procedure rosetta_table_copy_in_p8(t out nocopy okl_clg_pvt.clgv_tbl_type, a0 JTF_NUMBER_TABLE
417: , a1 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
423: , a7 JTF_VARCHAR2_TABLE_100
424: , a8 JTF_NUMBER_TABLE
417: , a1 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
423: , a7 JTF_VARCHAR2_TABLE_100
424: , a8 JTF_NUMBER_TABLE
425: , a9 JTF_NUMBER_TABLE
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_VARCHAR2_TABLE_100
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
423: , a7 JTF_VARCHAR2_TABLE_100
424: , a8 JTF_NUMBER_TABLE
425: , a9 JTF_NUMBER_TABLE
426: , a10 JTF_VARCHAR2_TABLE_200
420: , a4 JTF_NUMBER_TABLE
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
423: , a7 JTF_VARCHAR2_TABLE_100
424: , a8 JTF_NUMBER_TABLE
425: , a9 JTF_NUMBER_TABLE
426: , a10 JTF_VARCHAR2_TABLE_200
427: , a11 JTF_VARCHAR2_TABLE_2000
428: , a12 JTF_VARCHAR2_TABLE_2000
421: , a5 JTF_NUMBER_TABLE
422: , a6 JTF_NUMBER_TABLE
423: , a7 JTF_VARCHAR2_TABLE_100
424: , a8 JTF_NUMBER_TABLE
425: , a9 JTF_NUMBER_TABLE
426: , a10 JTF_VARCHAR2_TABLE_200
427: , a11 JTF_VARCHAR2_TABLE_2000
428: , a12 JTF_VARCHAR2_TABLE_2000
429: , a13 JTF_VARCHAR2_TABLE_100
441: , a25 JTF_VARCHAR2_TABLE_500
442: , a26 JTF_VARCHAR2_TABLE_500
443: , a27 JTF_VARCHAR2_TABLE_500
444: , a28 JTF_VARCHAR2_TABLE_500
445: , a29 JTF_NUMBER_TABLE
446: , a30 JTF_DATE_TABLE
447: , a31 JTF_NUMBER_TABLE
448: , a32 JTF_DATE_TABLE
449: , a33 JTF_NUMBER_TABLE
443: , a27 JTF_VARCHAR2_TABLE_500
444: , a28 JTF_VARCHAR2_TABLE_500
445: , a29 JTF_NUMBER_TABLE
446: , a30 JTF_DATE_TABLE
447: , a31 JTF_NUMBER_TABLE
448: , a32 JTF_DATE_TABLE
449: , a33 JTF_NUMBER_TABLE
450: , a34 JTF_DATE_TABLE
451: , a35 JTF_DATE_TABLE
445: , a29 JTF_NUMBER_TABLE
446: , a30 JTF_DATE_TABLE
447: , a31 JTF_NUMBER_TABLE
448: , a32 JTF_DATE_TABLE
449: , a33 JTF_NUMBER_TABLE
450: , a34 JTF_DATE_TABLE
451: , a35 JTF_DATE_TABLE
452: , a36 JTF_NUMBER_TABLE
453: , a37 JTF_NUMBER_TABLE
448: , a32 JTF_DATE_TABLE
449: , a33 JTF_NUMBER_TABLE
450: , a34 JTF_DATE_TABLE
451: , a35 JTF_DATE_TABLE
452: , a36 JTF_NUMBER_TABLE
453: , a37 JTF_NUMBER_TABLE
454: ) as
455: ddindx binary_integer; indx binary_integer;
456: begin
449: , a33 JTF_NUMBER_TABLE
450: , a34 JTF_DATE_TABLE
451: , a35 JTF_DATE_TABLE
452: , a36 JTF_NUMBER_TABLE
453: , a37 JTF_NUMBER_TABLE
454: ) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if a0 is not null and a0.count > 0 then
505: end loop;
506: end if;
507: end if;
508: end rosetta_table_copy_in_p8;
509: procedure rosetta_table_copy_out_p8(t okl_clg_pvt.clgv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
506: end if;
507: end if;
508: end rosetta_table_copy_in_p8;
509: procedure rosetta_table_copy_out_p8(t okl_clg_pvt.clgv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
507: end if;
508: end rosetta_table_copy_in_p8;
509: procedure rosetta_table_copy_out_p8(t okl_clg_pvt.clgv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
509: procedure rosetta_table_copy_out_p8(t okl_clg_pvt.clgv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
516: , a7 out nocopy JTF_VARCHAR2_TABLE_100
517: , a8 out nocopy JTF_NUMBER_TABLE
510: , a1 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
516: , a7 out nocopy JTF_VARCHAR2_TABLE_100
517: , a8 out nocopy JTF_NUMBER_TABLE
518: , a9 out nocopy JTF_NUMBER_TABLE
511: , a2 out nocopy JTF_NUMBER_TABLE
512: , a3 out nocopy JTF_VARCHAR2_TABLE_100
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
516: , a7 out nocopy JTF_VARCHAR2_TABLE_100
517: , a8 out nocopy JTF_NUMBER_TABLE
518: , a9 out nocopy JTF_NUMBER_TABLE
519: , a10 out nocopy JTF_VARCHAR2_TABLE_200
513: , a4 out nocopy JTF_NUMBER_TABLE
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
516: , a7 out nocopy JTF_VARCHAR2_TABLE_100
517: , a8 out nocopy JTF_NUMBER_TABLE
518: , a9 out nocopy JTF_NUMBER_TABLE
519: , a10 out nocopy JTF_VARCHAR2_TABLE_200
520: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
521: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
514: , a5 out nocopy JTF_NUMBER_TABLE
515: , a6 out nocopy JTF_NUMBER_TABLE
516: , a7 out nocopy JTF_VARCHAR2_TABLE_100
517: , a8 out nocopy JTF_NUMBER_TABLE
518: , a9 out nocopy JTF_NUMBER_TABLE
519: , a10 out nocopy JTF_VARCHAR2_TABLE_200
520: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
521: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
522: , a13 out nocopy JTF_VARCHAR2_TABLE_100
534: , a25 out nocopy JTF_VARCHAR2_TABLE_500
535: , a26 out nocopy JTF_VARCHAR2_TABLE_500
536: , a27 out nocopy JTF_VARCHAR2_TABLE_500
537: , a28 out nocopy JTF_VARCHAR2_TABLE_500
538: , a29 out nocopy JTF_NUMBER_TABLE
539: , a30 out nocopy JTF_DATE_TABLE
540: , a31 out nocopy JTF_NUMBER_TABLE
541: , a32 out nocopy JTF_DATE_TABLE
542: , a33 out nocopy JTF_NUMBER_TABLE
536: , a27 out nocopy JTF_VARCHAR2_TABLE_500
537: , a28 out nocopy JTF_VARCHAR2_TABLE_500
538: , a29 out nocopy JTF_NUMBER_TABLE
539: , a30 out nocopy JTF_DATE_TABLE
540: , a31 out nocopy JTF_NUMBER_TABLE
541: , a32 out nocopy JTF_DATE_TABLE
542: , a33 out nocopy JTF_NUMBER_TABLE
543: , a34 out nocopy JTF_DATE_TABLE
544: , a35 out nocopy JTF_DATE_TABLE
538: , a29 out nocopy JTF_NUMBER_TABLE
539: , a30 out nocopy JTF_DATE_TABLE
540: , a31 out nocopy JTF_NUMBER_TABLE
541: , a32 out nocopy JTF_DATE_TABLE
542: , a33 out nocopy JTF_NUMBER_TABLE
543: , a34 out nocopy JTF_DATE_TABLE
544: , a35 out nocopy JTF_DATE_TABLE
545: , a36 out nocopy JTF_NUMBER_TABLE
546: , a37 out nocopy JTF_NUMBER_TABLE
541: , a32 out nocopy JTF_DATE_TABLE
542: , a33 out nocopy JTF_NUMBER_TABLE
543: , a34 out nocopy JTF_DATE_TABLE
544: , a35 out nocopy JTF_DATE_TABLE
545: , a36 out nocopy JTF_NUMBER_TABLE
546: , a37 out nocopy JTF_NUMBER_TABLE
547: ) as
548: ddindx binary_integer; indx binary_integer;
549: begin
542: , a33 out nocopy JTF_NUMBER_TABLE
543: , a34 out nocopy JTF_DATE_TABLE
544: , a35 out nocopy JTF_DATE_TABLE
545: , a36 out nocopy JTF_NUMBER_TABLE
546: , a37 out nocopy JTF_NUMBER_TABLE
547: ) as
548: ddindx binary_integer; indx binary_integer;
549: begin
550: if t is null or t.count = 0 then
547: ) as
548: ddindx binary_integer; indx binary_integer;
549: begin
550: if t is null or t.count = 0 then
551: a0 := JTF_NUMBER_TABLE();
552: a1 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
548: ddindx binary_integer; indx binary_integer;
549: begin
550: if t is null or t.count = 0 then
551: a0 := JTF_NUMBER_TABLE();
552: a1 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
549: begin
550: if t is null or t.count = 0 then
551: a0 := JTF_NUMBER_TABLE();
552: a1 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
551: a0 := JTF_NUMBER_TABLE();
552: a1 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
558: a7 := JTF_VARCHAR2_TABLE_100();
559: a8 := JTF_NUMBER_TABLE();
552: a1 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
558: a7 := JTF_VARCHAR2_TABLE_100();
559: a8 := JTF_NUMBER_TABLE();
560: a9 := JTF_NUMBER_TABLE();
553: a2 := JTF_NUMBER_TABLE();
554: a3 := JTF_VARCHAR2_TABLE_100();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
558: a7 := JTF_VARCHAR2_TABLE_100();
559: a8 := JTF_NUMBER_TABLE();
560: a9 := JTF_NUMBER_TABLE();
561: a10 := JTF_VARCHAR2_TABLE_200();
555: a4 := JTF_NUMBER_TABLE();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
558: a7 := JTF_VARCHAR2_TABLE_100();
559: a8 := JTF_NUMBER_TABLE();
560: a9 := JTF_NUMBER_TABLE();
561: a10 := JTF_VARCHAR2_TABLE_200();
562: a11 := JTF_VARCHAR2_TABLE_2000();
563: a12 := JTF_VARCHAR2_TABLE_2000();
556: a5 := JTF_NUMBER_TABLE();
557: a6 := JTF_NUMBER_TABLE();
558: a7 := JTF_VARCHAR2_TABLE_100();
559: a8 := JTF_NUMBER_TABLE();
560: a9 := JTF_NUMBER_TABLE();
561: a10 := JTF_VARCHAR2_TABLE_200();
562: a11 := JTF_VARCHAR2_TABLE_2000();
563: a12 := JTF_VARCHAR2_TABLE_2000();
564: a13 := JTF_VARCHAR2_TABLE_100();
576: a25 := JTF_VARCHAR2_TABLE_500();
577: a26 := JTF_VARCHAR2_TABLE_500();
578: a27 := JTF_VARCHAR2_TABLE_500();
579: a28 := JTF_VARCHAR2_TABLE_500();
580: a29 := JTF_NUMBER_TABLE();
581: a30 := JTF_DATE_TABLE();
582: a31 := JTF_NUMBER_TABLE();
583: a32 := JTF_DATE_TABLE();
584: a33 := JTF_NUMBER_TABLE();
578: a27 := JTF_VARCHAR2_TABLE_500();
579: a28 := JTF_VARCHAR2_TABLE_500();
580: a29 := JTF_NUMBER_TABLE();
581: a30 := JTF_DATE_TABLE();
582: a31 := JTF_NUMBER_TABLE();
583: a32 := JTF_DATE_TABLE();
584: a33 := JTF_NUMBER_TABLE();
585: a34 := JTF_DATE_TABLE();
586: a35 := JTF_DATE_TABLE();
580: a29 := JTF_NUMBER_TABLE();
581: a30 := JTF_DATE_TABLE();
582: a31 := JTF_NUMBER_TABLE();
583: a32 := JTF_DATE_TABLE();
584: a33 := JTF_NUMBER_TABLE();
585: a34 := JTF_DATE_TABLE();
586: a35 := JTF_DATE_TABLE();
587: a36 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
583: a32 := JTF_DATE_TABLE();
584: a33 := JTF_NUMBER_TABLE();
585: a34 := JTF_DATE_TABLE();
586: a35 := JTF_DATE_TABLE();
587: a36 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
584: a33 := JTF_NUMBER_TABLE();
585: a34 := JTF_DATE_TABLE();
586: a35 := JTF_DATE_TABLE();
587: a36 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
586: a35 := JTF_DATE_TABLE();
587: a36 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
587: a36 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
588: a37 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
597: a7 := JTF_VARCHAR2_TABLE_100();
598: a8 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
597: a7 := JTF_VARCHAR2_TABLE_100();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_VARCHAR2_TABLE_100();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
597: a7 := JTF_VARCHAR2_TABLE_100();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_VARCHAR2_TABLE_200();
594: a4 := JTF_NUMBER_TABLE();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
597: a7 := JTF_VARCHAR2_TABLE_100();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_VARCHAR2_TABLE_200();
601: a11 := JTF_VARCHAR2_TABLE_2000();
602: a12 := JTF_VARCHAR2_TABLE_2000();
595: a5 := JTF_NUMBER_TABLE();
596: a6 := JTF_NUMBER_TABLE();
597: a7 := JTF_VARCHAR2_TABLE_100();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_VARCHAR2_TABLE_200();
601: a11 := JTF_VARCHAR2_TABLE_2000();
602: a12 := JTF_VARCHAR2_TABLE_2000();
603: a13 := JTF_VARCHAR2_TABLE_100();
615: a25 := JTF_VARCHAR2_TABLE_500();
616: a26 := JTF_VARCHAR2_TABLE_500();
617: a27 := JTF_VARCHAR2_TABLE_500();
618: a28 := JTF_VARCHAR2_TABLE_500();
619: a29 := JTF_NUMBER_TABLE();
620: a30 := JTF_DATE_TABLE();
621: a31 := JTF_NUMBER_TABLE();
622: a32 := JTF_DATE_TABLE();
623: a33 := JTF_NUMBER_TABLE();
617: a27 := JTF_VARCHAR2_TABLE_500();
618: a28 := JTF_VARCHAR2_TABLE_500();
619: a29 := JTF_NUMBER_TABLE();
620: a30 := JTF_DATE_TABLE();
621: a31 := JTF_NUMBER_TABLE();
622: a32 := JTF_DATE_TABLE();
623: a33 := JTF_NUMBER_TABLE();
624: a34 := JTF_DATE_TABLE();
625: a35 := JTF_DATE_TABLE();
619: a29 := JTF_NUMBER_TABLE();
620: a30 := JTF_DATE_TABLE();
621: a31 := JTF_NUMBER_TABLE();
622: a32 := JTF_DATE_TABLE();
623: a33 := JTF_NUMBER_TABLE();
624: a34 := JTF_DATE_TABLE();
625: a35 := JTF_DATE_TABLE();
626: a36 := JTF_NUMBER_TABLE();
627: a37 := JTF_NUMBER_TABLE();
622: a32 := JTF_DATE_TABLE();
623: a33 := JTF_NUMBER_TABLE();
624: a34 := JTF_DATE_TABLE();
625: a35 := JTF_DATE_TABLE();
626: a36 := JTF_NUMBER_TABLE();
627: a37 := JTF_NUMBER_TABLE();
628: if t.count > 0 then
629: a0.extend(t.count);
630: a1.extend(t.count);
623: a33 := JTF_NUMBER_TABLE();
624: a34 := JTF_DATE_TABLE();
625: a35 := JTF_DATE_TABLE();
626: a36 := JTF_NUMBER_TABLE();
627: a37 := JTF_NUMBER_TABLE();
628: if t.count > 0 then
629: a0.extend(t.count);
630: a1.extend(t.count);
631: a2.extend(t.count);
910: , p_init_msg_list VARCHAR2
911: , x_return_status out nocopy VARCHAR2
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
911: , x_return_status out nocopy VARCHAR2
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
921: , p5_a7 JTF_VARCHAR2_TABLE_100
922: , p5_a8 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
921: , p5_a7 JTF_VARCHAR2_TABLE_100
922: , p5_a8 JTF_NUMBER_TABLE
923: , p5_a9 JTF_NUMBER_TABLE
916: , p5_a2 JTF_NUMBER_TABLE
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
921: , p5_a7 JTF_VARCHAR2_TABLE_100
922: , p5_a8 JTF_NUMBER_TABLE
923: , p5_a9 JTF_NUMBER_TABLE
924: , p5_a10 JTF_VARCHAR2_TABLE_200
918: , p5_a4 JTF_NUMBER_TABLE
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
921: , p5_a7 JTF_VARCHAR2_TABLE_100
922: , p5_a8 JTF_NUMBER_TABLE
923: , p5_a9 JTF_NUMBER_TABLE
924: , p5_a10 JTF_VARCHAR2_TABLE_200
925: , p5_a11 JTF_VARCHAR2_TABLE_2000
926: , p5_a12 JTF_VARCHAR2_TABLE_2000
919: , p5_a5 JTF_NUMBER_TABLE
920: , p5_a6 JTF_NUMBER_TABLE
921: , p5_a7 JTF_VARCHAR2_TABLE_100
922: , p5_a8 JTF_NUMBER_TABLE
923: , p5_a9 JTF_NUMBER_TABLE
924: , p5_a10 JTF_VARCHAR2_TABLE_200
925: , p5_a11 JTF_VARCHAR2_TABLE_2000
926: , p5_a12 JTF_VARCHAR2_TABLE_2000
927: , p5_a13 JTF_VARCHAR2_TABLE_100
939: , p5_a25 JTF_VARCHAR2_TABLE_500
940: , p5_a26 JTF_VARCHAR2_TABLE_500
941: , p5_a27 JTF_VARCHAR2_TABLE_500
942: , p5_a28 JTF_VARCHAR2_TABLE_500
943: , p5_a29 JTF_NUMBER_TABLE
944: , p5_a30 JTF_DATE_TABLE
945: , p5_a31 JTF_NUMBER_TABLE
946: , p5_a32 JTF_DATE_TABLE
947: , p5_a33 JTF_NUMBER_TABLE
941: , p5_a27 JTF_VARCHAR2_TABLE_500
942: , p5_a28 JTF_VARCHAR2_TABLE_500
943: , p5_a29 JTF_NUMBER_TABLE
944: , p5_a30 JTF_DATE_TABLE
945: , p5_a31 JTF_NUMBER_TABLE
946: , p5_a32 JTF_DATE_TABLE
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_DATE_TABLE
943: , p5_a29 JTF_NUMBER_TABLE
944: , p5_a30 JTF_DATE_TABLE
945: , p5_a31 JTF_NUMBER_TABLE
946: , p5_a32 JTF_DATE_TABLE
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_DATE_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
946: , p5_a32 JTF_DATE_TABLE
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_DATE_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
947: , p5_a33 JTF_NUMBER_TABLE
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_DATE_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a34 JTF_DATE_TABLE
949: , p5_a35 JTF_DATE_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
949: , p5_a35 JTF_DATE_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
950: , p5_a36 JTF_NUMBER_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a8 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a8 out nocopy JTF_NUMBER_TABLE
961: , p6_a9 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_NUMBER_TABLE
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a8 out nocopy JTF_NUMBER_TABLE
961: , p6_a9 out nocopy JTF_NUMBER_TABLE
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
956: , p6_a4 out nocopy JTF_NUMBER_TABLE
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a8 out nocopy JTF_NUMBER_TABLE
961: , p6_a9 out nocopy JTF_NUMBER_TABLE
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
964: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
957: , p6_a5 out nocopy JTF_NUMBER_TABLE
958: , p6_a6 out nocopy JTF_NUMBER_TABLE
959: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a8 out nocopy JTF_NUMBER_TABLE
961: , p6_a9 out nocopy JTF_NUMBER_TABLE
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
964: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
965: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
977: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
978: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
979: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
980: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
981: , p6_a29 out nocopy JTF_NUMBER_TABLE
982: , p6_a30 out nocopy JTF_DATE_TABLE
983: , p6_a31 out nocopy JTF_NUMBER_TABLE
984: , p6_a32 out nocopy JTF_DATE_TABLE
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
979: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
980: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
981: , p6_a29 out nocopy JTF_NUMBER_TABLE
982: , p6_a30 out nocopy JTF_DATE_TABLE
983: , p6_a31 out nocopy JTF_NUMBER_TABLE
984: , p6_a32 out nocopy JTF_DATE_TABLE
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_DATE_TABLE
981: , p6_a29 out nocopy JTF_NUMBER_TABLE
982: , p6_a30 out nocopy JTF_DATE_TABLE
983: , p6_a31 out nocopy JTF_NUMBER_TABLE
984: , p6_a32 out nocopy JTF_DATE_TABLE
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_DATE_TABLE
988: , p6_a36 out nocopy JTF_NUMBER_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE
984: , p6_a32 out nocopy JTF_DATE_TABLE
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_DATE_TABLE
988: , p6_a36 out nocopy JTF_NUMBER_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE
990: )
991:
992: as
985: , p6_a33 out nocopy JTF_NUMBER_TABLE
986: , p6_a34 out nocopy JTF_DATE_TABLE
987: , p6_a35 out nocopy JTF_DATE_TABLE
988: , p6_a36 out nocopy JTF_NUMBER_TABLE
989: , p6_a37 out nocopy JTF_NUMBER_TABLE
990: )
991:
992: as
993: ddp_clgv_tbl okl_clg_pvt.clgv_tbl_type;
1214: , p_init_msg_list VARCHAR2
1215: , x_return_status out nocopy VARCHAR2
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1215: , x_return_status out nocopy VARCHAR2
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_VARCHAR2_TABLE_100
1226: , p5_a8 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_VARCHAR2_TABLE_100
1226: , p5_a8 JTF_NUMBER_TABLE
1227: , p5_a9 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_VARCHAR2_TABLE_100
1226: , p5_a8 JTF_NUMBER_TABLE
1227: , p5_a9 JTF_NUMBER_TABLE
1228: , p5_a10 JTF_VARCHAR2_TABLE_200
1222: , p5_a4 JTF_NUMBER_TABLE
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_VARCHAR2_TABLE_100
1226: , p5_a8 JTF_NUMBER_TABLE
1227: , p5_a9 JTF_NUMBER_TABLE
1228: , p5_a10 JTF_VARCHAR2_TABLE_200
1229: , p5_a11 JTF_VARCHAR2_TABLE_2000
1230: , p5_a12 JTF_VARCHAR2_TABLE_2000
1223: , p5_a5 JTF_NUMBER_TABLE
1224: , p5_a6 JTF_NUMBER_TABLE
1225: , p5_a7 JTF_VARCHAR2_TABLE_100
1226: , p5_a8 JTF_NUMBER_TABLE
1227: , p5_a9 JTF_NUMBER_TABLE
1228: , p5_a10 JTF_VARCHAR2_TABLE_200
1229: , p5_a11 JTF_VARCHAR2_TABLE_2000
1230: , p5_a12 JTF_VARCHAR2_TABLE_2000
1231: , p5_a13 JTF_VARCHAR2_TABLE_100
1243: , p5_a25 JTF_VARCHAR2_TABLE_500
1244: , p5_a26 JTF_VARCHAR2_TABLE_500
1245: , p5_a27 JTF_VARCHAR2_TABLE_500
1246: , p5_a28 JTF_VARCHAR2_TABLE_500
1247: , p5_a29 JTF_NUMBER_TABLE
1248: , p5_a30 JTF_DATE_TABLE
1249: , p5_a31 JTF_NUMBER_TABLE
1250: , p5_a32 JTF_DATE_TABLE
1251: , p5_a33 JTF_NUMBER_TABLE
1245: , p5_a27 JTF_VARCHAR2_TABLE_500
1246: , p5_a28 JTF_VARCHAR2_TABLE_500
1247: , p5_a29 JTF_NUMBER_TABLE
1248: , p5_a30 JTF_DATE_TABLE
1249: , p5_a31 JTF_NUMBER_TABLE
1250: , p5_a32 JTF_DATE_TABLE
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_DATE_TABLE
1247: , p5_a29 JTF_NUMBER_TABLE
1248: , p5_a30 JTF_DATE_TABLE
1249: , p5_a31 JTF_NUMBER_TABLE
1250: , p5_a32 JTF_DATE_TABLE
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_DATE_TABLE
1254: , p5_a36 JTF_NUMBER_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE
1250: , p5_a32 JTF_DATE_TABLE
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_DATE_TABLE
1254: , p5_a36 JTF_NUMBER_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE
1256: )
1257:
1258: as
1251: , p5_a33 JTF_NUMBER_TABLE
1252: , p5_a34 JTF_DATE_TABLE
1253: , p5_a35 JTF_DATE_TABLE
1254: , p5_a36 JTF_NUMBER_TABLE
1255: , p5_a37 JTF_NUMBER_TABLE
1256: )
1257:
1258: as
1259: ddp_clgv_tbl okl_clg_pvt.clgv_tbl_type;
1517: , p_init_msg_list VARCHAR2
1518: , x_return_status out nocopy VARCHAR2
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1518: , x_return_status out nocopy VARCHAR2
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_VARCHAR2_TABLE_100
1529: , p5_a8 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_VARCHAR2_TABLE_100
1529: , p5_a8 JTF_NUMBER_TABLE
1530: , p5_a9 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_NUMBER_TABLE
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_VARCHAR2_TABLE_100
1529: , p5_a8 JTF_NUMBER_TABLE
1530: , p5_a9 JTF_NUMBER_TABLE
1531: , p5_a10 JTF_VARCHAR2_TABLE_200
1525: , p5_a4 JTF_NUMBER_TABLE
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_VARCHAR2_TABLE_100
1529: , p5_a8 JTF_NUMBER_TABLE
1530: , p5_a9 JTF_NUMBER_TABLE
1531: , p5_a10 JTF_VARCHAR2_TABLE_200
1532: , p5_a11 JTF_VARCHAR2_TABLE_2000
1533: , p5_a12 JTF_VARCHAR2_TABLE_2000
1526: , p5_a5 JTF_NUMBER_TABLE
1527: , p5_a6 JTF_NUMBER_TABLE
1528: , p5_a7 JTF_VARCHAR2_TABLE_100
1529: , p5_a8 JTF_NUMBER_TABLE
1530: , p5_a9 JTF_NUMBER_TABLE
1531: , p5_a10 JTF_VARCHAR2_TABLE_200
1532: , p5_a11 JTF_VARCHAR2_TABLE_2000
1533: , p5_a12 JTF_VARCHAR2_TABLE_2000
1534: , p5_a13 JTF_VARCHAR2_TABLE_100
1546: , p5_a25 JTF_VARCHAR2_TABLE_500
1547: , p5_a26 JTF_VARCHAR2_TABLE_500
1548: , p5_a27 JTF_VARCHAR2_TABLE_500
1549: , p5_a28 JTF_VARCHAR2_TABLE_500
1550: , p5_a29 JTF_NUMBER_TABLE
1551: , p5_a30 JTF_DATE_TABLE
1552: , p5_a31 JTF_NUMBER_TABLE
1553: , p5_a32 JTF_DATE_TABLE
1554: , p5_a33 JTF_NUMBER_TABLE
1548: , p5_a27 JTF_VARCHAR2_TABLE_500
1549: , p5_a28 JTF_VARCHAR2_TABLE_500
1550: , p5_a29 JTF_NUMBER_TABLE
1551: , p5_a30 JTF_DATE_TABLE
1552: , p5_a31 JTF_NUMBER_TABLE
1553: , p5_a32 JTF_DATE_TABLE
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1550: , p5_a29 JTF_NUMBER_TABLE
1551: , p5_a30 JTF_DATE_TABLE
1552: , p5_a31 JTF_NUMBER_TABLE
1553: , p5_a32 JTF_DATE_TABLE
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1553: , p5_a32 JTF_DATE_TABLE
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1554: , p5_a33 JTF_NUMBER_TABLE
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a34 JTF_DATE_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1556: , p5_a35 JTF_DATE_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1557: , p5_a36 JTF_NUMBER_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p6_a8 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p6_a8 out nocopy JTF_NUMBER_TABLE
1568: , p6_a9 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_NUMBER_TABLE
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p6_a8 out nocopy JTF_NUMBER_TABLE
1568: , p6_a9 out nocopy JTF_NUMBER_TABLE
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
1563: , p6_a4 out nocopy JTF_NUMBER_TABLE
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p6_a8 out nocopy JTF_NUMBER_TABLE
1568: , p6_a9 out nocopy JTF_NUMBER_TABLE
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
1571: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1564: , p6_a5 out nocopy JTF_NUMBER_TABLE
1565: , p6_a6 out nocopy JTF_NUMBER_TABLE
1566: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p6_a8 out nocopy JTF_NUMBER_TABLE
1568: , p6_a9 out nocopy JTF_NUMBER_TABLE
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
1571: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1572: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1584: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1585: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1586: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1587: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1588: , p6_a29 out nocopy JTF_NUMBER_TABLE
1589: , p6_a30 out nocopy JTF_DATE_TABLE
1590: , p6_a31 out nocopy JTF_NUMBER_TABLE
1591: , p6_a32 out nocopy JTF_DATE_TABLE
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1586: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1587: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1588: , p6_a29 out nocopy JTF_NUMBER_TABLE
1589: , p6_a30 out nocopy JTF_DATE_TABLE
1590: , p6_a31 out nocopy JTF_NUMBER_TABLE
1591: , p6_a32 out nocopy JTF_DATE_TABLE
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_DATE_TABLE
1588: , p6_a29 out nocopy JTF_NUMBER_TABLE
1589: , p6_a30 out nocopy JTF_DATE_TABLE
1590: , p6_a31 out nocopy JTF_NUMBER_TABLE
1591: , p6_a32 out nocopy JTF_DATE_TABLE
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_DATE_TABLE
1595: , p6_a36 out nocopy JTF_NUMBER_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1591: , p6_a32 out nocopy JTF_DATE_TABLE
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_DATE_TABLE
1595: , p6_a36 out nocopy JTF_NUMBER_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1597: )
1598:
1599: as
1592: , p6_a33 out nocopy JTF_NUMBER_TABLE
1593: , p6_a34 out nocopy JTF_DATE_TABLE
1594: , p6_a35 out nocopy JTF_DATE_TABLE
1595: , p6_a36 out nocopy JTF_NUMBER_TABLE
1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1597: )
1598:
1599: as
1600: ddp_clgv_tbl okl_clg_pvt.clgv_tbl_type;
1821: , p_init_msg_list VARCHAR2
1822: , x_return_status out nocopy VARCHAR2
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1822: , x_return_status out nocopy VARCHAR2
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_VARCHAR2_TABLE_100
1833: , p5_a8 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_VARCHAR2_TABLE_100
1833: , p5_a8 JTF_NUMBER_TABLE
1834: , p5_a9 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_NUMBER_TABLE
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_VARCHAR2_TABLE_100
1833: , p5_a8 JTF_NUMBER_TABLE
1834: , p5_a9 JTF_NUMBER_TABLE
1835: , p5_a10 JTF_VARCHAR2_TABLE_200
1829: , p5_a4 JTF_NUMBER_TABLE
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_VARCHAR2_TABLE_100
1833: , p5_a8 JTF_NUMBER_TABLE
1834: , p5_a9 JTF_NUMBER_TABLE
1835: , p5_a10 JTF_VARCHAR2_TABLE_200
1836: , p5_a11 JTF_VARCHAR2_TABLE_2000
1837: , p5_a12 JTF_VARCHAR2_TABLE_2000
1830: , p5_a5 JTF_NUMBER_TABLE
1831: , p5_a6 JTF_NUMBER_TABLE
1832: , p5_a7 JTF_VARCHAR2_TABLE_100
1833: , p5_a8 JTF_NUMBER_TABLE
1834: , p5_a9 JTF_NUMBER_TABLE
1835: , p5_a10 JTF_VARCHAR2_TABLE_200
1836: , p5_a11 JTF_VARCHAR2_TABLE_2000
1837: , p5_a12 JTF_VARCHAR2_TABLE_2000
1838: , p5_a13 JTF_VARCHAR2_TABLE_100
1850: , p5_a25 JTF_VARCHAR2_TABLE_500
1851: , p5_a26 JTF_VARCHAR2_TABLE_500
1852: , p5_a27 JTF_VARCHAR2_TABLE_500
1853: , p5_a28 JTF_VARCHAR2_TABLE_500
1854: , p5_a29 JTF_NUMBER_TABLE
1855: , p5_a30 JTF_DATE_TABLE
1856: , p5_a31 JTF_NUMBER_TABLE
1857: , p5_a32 JTF_DATE_TABLE
1858: , p5_a33 JTF_NUMBER_TABLE
1852: , p5_a27 JTF_VARCHAR2_TABLE_500
1853: , p5_a28 JTF_VARCHAR2_TABLE_500
1854: , p5_a29 JTF_NUMBER_TABLE
1855: , p5_a30 JTF_DATE_TABLE
1856: , p5_a31 JTF_NUMBER_TABLE
1857: , p5_a32 JTF_DATE_TABLE
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_DATE_TABLE
1854: , p5_a29 JTF_NUMBER_TABLE
1855: , p5_a30 JTF_DATE_TABLE
1856: , p5_a31 JTF_NUMBER_TABLE
1857: , p5_a32 JTF_DATE_TABLE
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_DATE_TABLE
1861: , p5_a36 JTF_NUMBER_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE
1857: , p5_a32 JTF_DATE_TABLE
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_DATE_TABLE
1861: , p5_a36 JTF_NUMBER_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE
1863: )
1864:
1865: as
1858: , p5_a33 JTF_NUMBER_TABLE
1859: , p5_a34 JTF_DATE_TABLE
1860: , p5_a35 JTF_DATE_TABLE
1861: , p5_a36 JTF_NUMBER_TABLE
1862: , p5_a37 JTF_NUMBER_TABLE
1863: )
1864:
1865: as
1866: ddp_clgv_tbl okl_clg_pvt.clgv_tbl_type;
2044: , p_init_msg_list VARCHAR2
2045: , x_return_status out nocopy VARCHAR2
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2045: , x_return_status out nocopy VARCHAR2
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_VARCHAR2_TABLE_100
2056: , p5_a8 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_VARCHAR2_TABLE_100
2056: , p5_a8 JTF_NUMBER_TABLE
2057: , p5_a9 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_NUMBER_TABLE
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_VARCHAR2_TABLE_100
2056: , p5_a8 JTF_NUMBER_TABLE
2057: , p5_a9 JTF_NUMBER_TABLE
2058: , p5_a10 JTF_VARCHAR2_TABLE_200
2052: , p5_a4 JTF_NUMBER_TABLE
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_VARCHAR2_TABLE_100
2056: , p5_a8 JTF_NUMBER_TABLE
2057: , p5_a9 JTF_NUMBER_TABLE
2058: , p5_a10 JTF_VARCHAR2_TABLE_200
2059: , p5_a11 JTF_VARCHAR2_TABLE_2000
2060: , p5_a12 JTF_VARCHAR2_TABLE_2000
2053: , p5_a5 JTF_NUMBER_TABLE
2054: , p5_a6 JTF_NUMBER_TABLE
2055: , p5_a7 JTF_VARCHAR2_TABLE_100
2056: , p5_a8 JTF_NUMBER_TABLE
2057: , p5_a9 JTF_NUMBER_TABLE
2058: , p5_a10 JTF_VARCHAR2_TABLE_200
2059: , p5_a11 JTF_VARCHAR2_TABLE_2000
2060: , p5_a12 JTF_VARCHAR2_TABLE_2000
2061: , p5_a13 JTF_VARCHAR2_TABLE_100
2073: , p5_a25 JTF_VARCHAR2_TABLE_500
2074: , p5_a26 JTF_VARCHAR2_TABLE_500
2075: , p5_a27 JTF_VARCHAR2_TABLE_500
2076: , p5_a28 JTF_VARCHAR2_TABLE_500
2077: , p5_a29 JTF_NUMBER_TABLE
2078: , p5_a30 JTF_DATE_TABLE
2079: , p5_a31 JTF_NUMBER_TABLE
2080: , p5_a32 JTF_DATE_TABLE
2081: , p5_a33 JTF_NUMBER_TABLE
2075: , p5_a27 JTF_VARCHAR2_TABLE_500
2076: , p5_a28 JTF_VARCHAR2_TABLE_500
2077: , p5_a29 JTF_NUMBER_TABLE
2078: , p5_a30 JTF_DATE_TABLE
2079: , p5_a31 JTF_NUMBER_TABLE
2080: , p5_a32 JTF_DATE_TABLE
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_DATE_TABLE
2077: , p5_a29 JTF_NUMBER_TABLE
2078: , p5_a30 JTF_DATE_TABLE
2079: , p5_a31 JTF_NUMBER_TABLE
2080: , p5_a32 JTF_DATE_TABLE
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_DATE_TABLE
2084: , p5_a36 JTF_NUMBER_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE
2080: , p5_a32 JTF_DATE_TABLE
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_DATE_TABLE
2084: , p5_a36 JTF_NUMBER_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE
2086: )
2087:
2088: as
2081: , p5_a33 JTF_NUMBER_TABLE
2082: , p5_a34 JTF_DATE_TABLE
2083: , p5_a35 JTF_DATE_TABLE
2084: , p5_a36 JTF_NUMBER_TABLE
2085: , p5_a37 JTF_NUMBER_TABLE
2086: )
2087:
2088: as
2089: ddp_clgv_tbl okl_clg_pvt.clgv_tbl_type;