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_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
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_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 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_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_VARCHAR2_TABLE_500
50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_VARCHAR2_TABLE_500
52: , a30 JTF_VARCHAR2_TABLE_500
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if a0 is not null and a0.count > 0 then
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
103: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_DATE_TABLE
116: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_DATE_TABLE
116: , a13 out nocopy JTF_VARCHAR2_TABLE_100
117: , a14 out nocopy JTF_NUMBER_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_DATE_TABLE
116: , a13 out nocopy JTF_VARCHAR2_TABLE_100
117: , a14 out nocopy JTF_NUMBER_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_500
120: , a17 out nocopy JTF_VARCHAR2_TABLE_500
121: , a18 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_VARCHAR2_TABLE_500
131: , a28 out nocopy JTF_VARCHAR2_TABLE_500
132: , a29 out nocopy JTF_VARCHAR2_TABLE_500
133: , a30 out nocopy JTF_VARCHAR2_TABLE_500
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_100();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_100();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_100();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_100();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_100();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_DATE_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_DATE_TABLE();
152: a13 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_NUMBER_TABLE();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_NUMBER_TABLE();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_DATE_TABLE();
152: a13 := JTF_VARCHAR2_TABLE_100();
153: a14 := JTF_NUMBER_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_DATE_TABLE();
152: a13 := JTF_VARCHAR2_TABLE_100();
153: a14 := JTF_NUMBER_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_500();
156: a17 := JTF_VARCHAR2_TABLE_500();
157: a18 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_VARCHAR2_TABLE_500();
167: a28 := JTF_VARCHAR2_TABLE_500();
168: a29 := JTF_VARCHAR2_TABLE_500();
169: a30 := JTF_VARCHAR2_TABLE_500();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
168: a29 := JTF_VARCHAR2_TABLE_500();
169: a30 := JTF_VARCHAR2_TABLE_500();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
169: a30 := JTF_VARCHAR2_TABLE_500();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_DATE_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_DATE_TABLE();
185: a13 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_NUMBER_TABLE();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_NUMBER_TABLE();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_DATE_TABLE();
185: a13 := JTF_VARCHAR2_TABLE_100();
186: a14 := JTF_NUMBER_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_DATE_TABLE();
185: a13 := JTF_VARCHAR2_TABLE_100();
186: a14 := JTF_NUMBER_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_500();
189: a17 := JTF_VARCHAR2_TABLE_500();
190: a18 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_VARCHAR2_TABLE_500();
200: a28 := JTF_VARCHAR2_TABLE_500();
201: a29 := JTF_VARCHAR2_TABLE_500();
202: a30 := JTF_VARCHAR2_TABLE_500();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: a1.extend(t.count);
207: a2.extend(t.count);
278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_2000
288: , a6 JTF_VARCHAR2_TABLE_300
289: , a7 JTF_VARCHAR2_TABLE_200
290: , a8 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_VARCHAR2_TABLE_2000
288: , a6 JTF_VARCHAR2_TABLE_300
289: , a7 JTF_VARCHAR2_TABLE_200
290: , a8 JTF_NUMBER_TABLE
291: , a9 JTF_DATE_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_DATE_TABLE
294: , a12 JTF_NUMBER_TABLE
288: , a6 JTF_VARCHAR2_TABLE_300
289: , a7 JTF_VARCHAR2_TABLE_200
290: , a8 JTF_NUMBER_TABLE
291: , a9 JTF_DATE_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_DATE_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_NUMBER_TABLE
296: , a14 JTF_VARCHAR2_TABLE_200
290: , a8 JTF_NUMBER_TABLE
291: , a9 JTF_DATE_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_DATE_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_NUMBER_TABLE
296: , a14 JTF_VARCHAR2_TABLE_200
297: ) as
298: ddindx binary_integer; indx binary_integer;
291: , a9 JTF_DATE_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_DATE_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_NUMBER_TABLE
296: , a14 JTF_VARCHAR2_TABLE_200
297: ) as
298: ddindx binary_integer; indx binary_integer;
299: begin
325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p5;
329: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_VARCHAR2_TABLE_100
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
329: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_VARCHAR2_TABLE_100
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a6 out nocopy JTF_VARCHAR2_TABLE_300
336: , a7 out nocopy JTF_VARCHAR2_TABLE_200
337: , a8 out nocopy JTF_NUMBER_TABLE
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a6 out nocopy JTF_VARCHAR2_TABLE_300
336: , a7 out nocopy JTF_VARCHAR2_TABLE_200
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
335: , a6 out nocopy JTF_VARCHAR2_TABLE_300
336: , a7 out nocopy JTF_VARCHAR2_TABLE_200
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_NUMBER_TABLE
343: , a14 out nocopy JTF_VARCHAR2_TABLE_200
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_NUMBER_TABLE
343: , a14 out nocopy JTF_VARCHAR2_TABLE_200
344: ) as
345: ddindx binary_integer; indx binary_integer;
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_NUMBER_TABLE
343: , a14 out nocopy JTF_VARCHAR2_TABLE_200
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
347: if t is null or t.count = 0 then
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_100();
351: a3 := JTF_VARCHAR2_TABLE_100();
352: a4 := JTF_NUMBER_TABLE();
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_100();
351: a3 := JTF_VARCHAR2_TABLE_100();
352: a4 := JTF_NUMBER_TABLE();
353: a5 := JTF_VARCHAR2_TABLE_2000();
354: a6 := JTF_VARCHAR2_TABLE_300();
355: a7 := JTF_VARCHAR2_TABLE_200();
356: a8 := JTF_NUMBER_TABLE();
352: a4 := JTF_NUMBER_TABLE();
353: a5 := JTF_VARCHAR2_TABLE_2000();
354: a6 := JTF_VARCHAR2_TABLE_300();
355: a7 := JTF_VARCHAR2_TABLE_200();
356: a8 := JTF_NUMBER_TABLE();
357: a9 := JTF_DATE_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_DATE_TABLE();
360: a12 := JTF_NUMBER_TABLE();
354: a6 := JTF_VARCHAR2_TABLE_300();
355: a7 := JTF_VARCHAR2_TABLE_200();
356: a8 := JTF_NUMBER_TABLE();
357: a9 := JTF_DATE_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_DATE_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_200();
356: a8 := JTF_NUMBER_TABLE();
357: a9 := JTF_DATE_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_DATE_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_200();
363: else
364: a0 := JTF_NUMBER_TABLE();
357: a9 := JTF_DATE_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_DATE_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_200();
363: else
364: a0 := JTF_NUMBER_TABLE();
365: a1 := JTF_VARCHAR2_TABLE_100();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_200();
363: else
364: a0 := JTF_NUMBER_TABLE();
365: a1 := JTF_VARCHAR2_TABLE_100();
366: a2 := JTF_VARCHAR2_TABLE_100();
367: a3 := JTF_VARCHAR2_TABLE_100();
368: a4 := JTF_NUMBER_TABLE();
364: a0 := JTF_NUMBER_TABLE();
365: a1 := JTF_VARCHAR2_TABLE_100();
366: a2 := JTF_VARCHAR2_TABLE_100();
367: a3 := JTF_VARCHAR2_TABLE_100();
368: a4 := JTF_NUMBER_TABLE();
369: a5 := JTF_VARCHAR2_TABLE_2000();
370: a6 := JTF_VARCHAR2_TABLE_300();
371: a7 := JTF_VARCHAR2_TABLE_200();
372: a8 := JTF_NUMBER_TABLE();
368: a4 := JTF_NUMBER_TABLE();
369: a5 := JTF_VARCHAR2_TABLE_2000();
370: a6 := JTF_VARCHAR2_TABLE_300();
371: a7 := JTF_VARCHAR2_TABLE_200();
372: a8 := JTF_NUMBER_TABLE();
373: a9 := JTF_DATE_TABLE();
374: a10 := JTF_NUMBER_TABLE();
375: a11 := JTF_DATE_TABLE();
376: a12 := JTF_NUMBER_TABLE();
370: a6 := JTF_VARCHAR2_TABLE_300();
371: a7 := JTF_VARCHAR2_TABLE_200();
372: a8 := JTF_NUMBER_TABLE();
373: a9 := JTF_DATE_TABLE();
374: a10 := JTF_NUMBER_TABLE();
375: a11 := JTF_DATE_TABLE();
376: a12 := JTF_NUMBER_TABLE();
377: a13 := JTF_NUMBER_TABLE();
378: a14 := JTF_VARCHAR2_TABLE_200();
372: a8 := JTF_NUMBER_TABLE();
373: a9 := JTF_DATE_TABLE();
374: a10 := JTF_NUMBER_TABLE();
375: a11 := JTF_DATE_TABLE();
376: a12 := JTF_NUMBER_TABLE();
377: a13 := JTF_NUMBER_TABLE();
378: a14 := JTF_VARCHAR2_TABLE_200();
379: if t.count > 0 then
380: a0.extend(t.count);
373: a9 := JTF_DATE_TABLE();
374: a10 := JTF_NUMBER_TABLE();
375: a11 := JTF_DATE_TABLE();
376: a12 := JTF_NUMBER_TABLE();
377: a13 := JTF_NUMBER_TABLE();
378: a14 := JTF_VARCHAR2_TABLE_200();
379: if t.count > 0 then
380: a0.extend(t.count);
381: a1.extend(t.count);
419: end if;
420: end if;
421: end rosetta_table_copy_out_p5;
422:
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
420: end if;
421: end rosetta_table_copy_out_p5;
422:
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
428: , a5 JTF_VARCHAR2_TABLE_100
421: end rosetta_table_copy_out_p5;
422:
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
428: , a5 JTF_VARCHAR2_TABLE_100
429: , a6 JTF_NUMBER_TABLE
422:
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
428: , a5 JTF_VARCHAR2_TABLE_100
429: , a6 JTF_NUMBER_TABLE
430: , a7 JTF_VARCHAR2_TABLE_100
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
428: , a5 JTF_VARCHAR2_TABLE_100
429: , a6 JTF_NUMBER_TABLE
430: , a7 JTF_VARCHAR2_TABLE_100
431: , a8 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE
428: , a5 JTF_VARCHAR2_TABLE_100
429: , a6 JTF_NUMBER_TABLE
430: , a7 JTF_VARCHAR2_TABLE_100
431: , a8 JTF_VARCHAR2_TABLE_100
432: , a9 JTF_NUMBER_TABLE
433: , a10 JTF_VARCHAR2_TABLE_2000
428: , a5 JTF_VARCHAR2_TABLE_100
429: , a6 JTF_NUMBER_TABLE
430: , a7 JTF_VARCHAR2_TABLE_100
431: , a8 JTF_VARCHAR2_TABLE_100
432: , a9 JTF_NUMBER_TABLE
433: , a10 JTF_VARCHAR2_TABLE_2000
434: , a11 JTF_VARCHAR2_TABLE_100
435: , a12 JTF_VARCHAR2_TABLE_300
436: , a13 JTF_VARCHAR2_TABLE_500
450: , a27 JTF_VARCHAR2_TABLE_500
451: , a28 JTF_VARCHAR2_TABLE_500
452: , a29 JTF_VARCHAR2_TABLE_500
453: , a30 JTF_VARCHAR2_TABLE_100
454: , a31 JTF_NUMBER_TABLE
455: , a32 JTF_DATE_TABLE
456: , a33 JTF_NUMBER_TABLE
457: , a34 JTF_DATE_TABLE
458: , a35 JTF_NUMBER_TABLE
452: , a29 JTF_VARCHAR2_TABLE_500
453: , a30 JTF_VARCHAR2_TABLE_100
454: , a31 JTF_NUMBER_TABLE
455: , a32 JTF_DATE_TABLE
456: , a33 JTF_NUMBER_TABLE
457: , a34 JTF_DATE_TABLE
458: , a35 JTF_NUMBER_TABLE
459: ) as
460: ddindx binary_integer; indx binary_integer;
454: , a31 JTF_NUMBER_TABLE
455: , a32 JTF_DATE_TABLE
456: , a33 JTF_NUMBER_TABLE
457: , a34 JTF_DATE_TABLE
458: , a35 JTF_NUMBER_TABLE
459: ) as
460: ddindx binary_integer; indx binary_integer;
461: begin
462: if a0 is not null and a0.count > 0 then
508: end loop;
509: end if;
510: end if;
511: end rosetta_table_copy_in_p8;
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
509: end if;
510: end if;
511: end rosetta_table_copy_in_p8;
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
510: end if;
511: end rosetta_table_copy_in_p8;
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , a6 out nocopy JTF_NUMBER_TABLE
511: end rosetta_table_copy_in_p8;
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , a6 out nocopy JTF_NUMBER_TABLE
519: , a7 out nocopy JTF_VARCHAR2_TABLE_100
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , a6 out nocopy JTF_NUMBER_TABLE
519: , a7 out nocopy JTF_VARCHAR2_TABLE_100
520: , a8 out nocopy JTF_VARCHAR2_TABLE_100
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , a6 out nocopy JTF_NUMBER_TABLE
519: , a7 out nocopy JTF_VARCHAR2_TABLE_100
520: , a8 out nocopy JTF_VARCHAR2_TABLE_100
521: , a9 out nocopy JTF_NUMBER_TABLE
522: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
517: , a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , a6 out nocopy JTF_NUMBER_TABLE
519: , a7 out nocopy JTF_VARCHAR2_TABLE_100
520: , a8 out nocopy JTF_VARCHAR2_TABLE_100
521: , a9 out nocopy JTF_NUMBER_TABLE
522: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
523: , a11 out nocopy JTF_VARCHAR2_TABLE_100
524: , a12 out nocopy JTF_VARCHAR2_TABLE_300
525: , a13 out nocopy JTF_VARCHAR2_TABLE_500
539: , a27 out nocopy JTF_VARCHAR2_TABLE_500
540: , a28 out nocopy JTF_VARCHAR2_TABLE_500
541: , a29 out nocopy JTF_VARCHAR2_TABLE_500
542: , a30 out nocopy JTF_VARCHAR2_TABLE_100
543: , a31 out nocopy JTF_NUMBER_TABLE
544: , a32 out nocopy JTF_DATE_TABLE
545: , a33 out nocopy JTF_NUMBER_TABLE
546: , a34 out nocopy JTF_DATE_TABLE
547: , a35 out nocopy JTF_NUMBER_TABLE
541: , a29 out nocopy JTF_VARCHAR2_TABLE_500
542: , a30 out nocopy JTF_VARCHAR2_TABLE_100
543: , a31 out nocopy JTF_NUMBER_TABLE
544: , a32 out nocopy JTF_DATE_TABLE
545: , a33 out nocopy JTF_NUMBER_TABLE
546: , a34 out nocopy JTF_DATE_TABLE
547: , a35 out nocopy JTF_NUMBER_TABLE
548: ) as
549: ddindx binary_integer; indx binary_integer;
543: , a31 out nocopy JTF_NUMBER_TABLE
544: , a32 out nocopy JTF_DATE_TABLE
545: , a33 out nocopy JTF_NUMBER_TABLE
546: , a34 out nocopy JTF_DATE_TABLE
547: , a35 out nocopy JTF_NUMBER_TABLE
548: ) as
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
548: ) as
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_VARCHAR2_TABLE_100();
550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_VARCHAR2_TABLE_100();
558: a6 := JTF_NUMBER_TABLE();
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_VARCHAR2_TABLE_100();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_VARCHAR2_TABLE_100();
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_VARCHAR2_TABLE_100();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_VARCHAR2_TABLE_100();
560: a8 := JTF_VARCHAR2_TABLE_100();
554: a2 := JTF_NUMBER_TABLE();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_VARCHAR2_TABLE_100();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_VARCHAR2_TABLE_100();
560: a8 := JTF_VARCHAR2_TABLE_100();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
557: a5 := JTF_VARCHAR2_TABLE_100();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_VARCHAR2_TABLE_100();
560: a8 := JTF_VARCHAR2_TABLE_100();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_VARCHAR2_TABLE_100();
564: a12 := JTF_VARCHAR2_TABLE_300();
565: a13 := JTF_VARCHAR2_TABLE_500();
579: a27 := JTF_VARCHAR2_TABLE_500();
580: a28 := JTF_VARCHAR2_TABLE_500();
581: a29 := JTF_VARCHAR2_TABLE_500();
582: a30 := JTF_VARCHAR2_TABLE_100();
583: a31 := JTF_NUMBER_TABLE();
584: a32 := JTF_DATE_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
581: a29 := JTF_VARCHAR2_TABLE_500();
582: a30 := JTF_VARCHAR2_TABLE_100();
583: a31 := JTF_NUMBER_TABLE();
584: a32 := JTF_DATE_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
583: a31 := JTF_NUMBER_TABLE();
584: a32 := JTF_DATE_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
594: a5 := JTF_VARCHAR2_TABLE_100();
587: a35 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_NUMBER_TABLE();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_NUMBER_TABLE();
596: a7 := JTF_VARCHAR2_TABLE_100();
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_NUMBER_TABLE();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_NUMBER_TABLE();
596: a7 := JTF_VARCHAR2_TABLE_100();
597: a8 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_NUMBER_TABLE();
592: a3 := JTF_NUMBER_TABLE();
593: a4 := JTF_NUMBER_TABLE();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_NUMBER_TABLE();
596: a7 := JTF_VARCHAR2_TABLE_100();
597: a8 := JTF_VARCHAR2_TABLE_100();
598: a9 := JTF_NUMBER_TABLE();
599: a10 := JTF_VARCHAR2_TABLE_2000();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_NUMBER_TABLE();
596: a7 := JTF_VARCHAR2_TABLE_100();
597: a8 := JTF_VARCHAR2_TABLE_100();
598: a9 := JTF_NUMBER_TABLE();
599: a10 := JTF_VARCHAR2_TABLE_2000();
600: a11 := JTF_VARCHAR2_TABLE_100();
601: a12 := JTF_VARCHAR2_TABLE_300();
602: a13 := JTF_VARCHAR2_TABLE_500();
616: a27 := JTF_VARCHAR2_TABLE_500();
617: a28 := JTF_VARCHAR2_TABLE_500();
618: a29 := JTF_VARCHAR2_TABLE_500();
619: a30 := JTF_VARCHAR2_TABLE_100();
620: a31 := JTF_NUMBER_TABLE();
621: a32 := JTF_DATE_TABLE();
622: a33 := JTF_NUMBER_TABLE();
623: a34 := JTF_DATE_TABLE();
624: a35 := JTF_NUMBER_TABLE();
618: a29 := JTF_VARCHAR2_TABLE_500();
619: a30 := JTF_VARCHAR2_TABLE_100();
620: a31 := JTF_NUMBER_TABLE();
621: a32 := JTF_DATE_TABLE();
622: a33 := JTF_NUMBER_TABLE();
623: a34 := JTF_DATE_TABLE();
624: a35 := JTF_NUMBER_TABLE();
625: if t.count > 0 then
626: a0.extend(t.count);
620: a31 := JTF_NUMBER_TABLE();
621: a32 := JTF_DATE_TABLE();
622: a33 := JTF_NUMBER_TABLE();
623: a34 := JTF_DATE_TABLE();
624: a35 := JTF_NUMBER_TABLE();
625: if t.count > 0 then
626: a0.extend(t.count);
627: a1.extend(t.count);
628: a2.extend(t.count);
895: , p_init_msg_list VARCHAR2
896: , x_return_status out nocopy VARCHAR2
897: , x_msg_count out nocopy NUMBER
898: , x_msg_data out nocopy VARCHAR2
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
896: , x_return_status out nocopy VARCHAR2
897: , x_msg_count out nocopy NUMBER
898: , x_msg_data out nocopy VARCHAR2
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_VARCHAR2_TABLE_100
897: , x_msg_count out nocopy NUMBER
898: , x_msg_data out nocopy VARCHAR2
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_VARCHAR2_TABLE_100
905: , p5_a6 JTF_NUMBER_TABLE
898: , x_msg_data out nocopy VARCHAR2
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_VARCHAR2_TABLE_100
905: , p5_a6 JTF_NUMBER_TABLE
906: , p5_a7 JTF_VARCHAR2_TABLE_100
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_VARCHAR2_TABLE_100
905: , p5_a6 JTF_NUMBER_TABLE
906: , p5_a7 JTF_VARCHAR2_TABLE_100
907: , p5_a8 JTF_VARCHAR2_TABLE_100
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_VARCHAR2_TABLE_100
905: , p5_a6 JTF_NUMBER_TABLE
906: , p5_a7 JTF_VARCHAR2_TABLE_100
907: , p5_a8 JTF_VARCHAR2_TABLE_100
908: , p5_a9 JTF_NUMBER_TABLE
909: , p5_a10 JTF_VARCHAR2_TABLE_2000
904: , p5_a5 JTF_VARCHAR2_TABLE_100
905: , p5_a6 JTF_NUMBER_TABLE
906: , p5_a7 JTF_VARCHAR2_TABLE_100
907: , p5_a8 JTF_VARCHAR2_TABLE_100
908: , p5_a9 JTF_NUMBER_TABLE
909: , p5_a10 JTF_VARCHAR2_TABLE_2000
910: , p5_a11 JTF_VARCHAR2_TABLE_100
911: , p5_a12 JTF_VARCHAR2_TABLE_300
912: , p5_a13 JTF_VARCHAR2_TABLE_500
926: , p5_a27 JTF_VARCHAR2_TABLE_500
927: , p5_a28 JTF_VARCHAR2_TABLE_500
928: , p5_a29 JTF_VARCHAR2_TABLE_500
929: , p5_a30 JTF_VARCHAR2_TABLE_100
930: , p5_a31 JTF_NUMBER_TABLE
931: , p5_a32 JTF_DATE_TABLE
932: , p5_a33 JTF_NUMBER_TABLE
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
928: , p5_a29 JTF_VARCHAR2_TABLE_500
929: , p5_a30 JTF_VARCHAR2_TABLE_100
930: , p5_a31 JTF_NUMBER_TABLE
931: , p5_a32 JTF_DATE_TABLE
932: , p5_a33 JTF_NUMBER_TABLE
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
930: , p5_a31 JTF_NUMBER_TABLE
931: , p5_a32 JTF_DATE_TABLE
932: , p5_a33 JTF_NUMBER_TABLE
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
931: , p5_a32 JTF_DATE_TABLE
932: , p5_a33 JTF_NUMBER_TABLE
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
932: , p5_a33 JTF_NUMBER_TABLE
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
933: , p5_a34 JTF_DATE_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 out nocopy JTF_NUMBER_TABLE
934: , p5_a35 JTF_NUMBER_TABLE
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 out nocopy JTF_NUMBER_TABLE
942: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
935: , p6_a0 out nocopy JTF_NUMBER_TABLE
936: , p6_a1 out nocopy JTF_NUMBER_TABLE
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 out nocopy JTF_NUMBER_TABLE
942: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a2 out nocopy JTF_NUMBER_TABLE
938: , p6_a3 out nocopy JTF_NUMBER_TABLE
939: , p6_a4 out nocopy JTF_NUMBER_TABLE
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 out nocopy JTF_NUMBER_TABLE
942: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a9 out nocopy JTF_NUMBER_TABLE
945: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
940: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a6 out nocopy JTF_NUMBER_TABLE
942: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a9 out nocopy JTF_NUMBER_TABLE
945: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
946: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
948: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
962: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
963: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
964: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
965: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
966: , p6_a31 out nocopy JTF_NUMBER_TABLE
967: , p6_a32 out nocopy JTF_DATE_TABLE
968: , p6_a33 out nocopy JTF_NUMBER_TABLE
969: , p6_a34 out nocopy JTF_DATE_TABLE
970: , p6_a35 out nocopy JTF_NUMBER_TABLE
964: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
965: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
966: , p6_a31 out nocopy JTF_NUMBER_TABLE
967: , p6_a32 out nocopy JTF_DATE_TABLE
968: , p6_a33 out nocopy JTF_NUMBER_TABLE
969: , p6_a34 out nocopy JTF_DATE_TABLE
970: , p6_a35 out nocopy JTF_NUMBER_TABLE
971: )
972:
966: , p6_a31 out nocopy JTF_NUMBER_TABLE
967: , p6_a32 out nocopy JTF_DATE_TABLE
968: , p6_a33 out nocopy JTF_NUMBER_TABLE
969: , p6_a34 out nocopy JTF_DATE_TABLE
970: , p6_a35 out nocopy JTF_NUMBER_TABLE
971: )
972:
973: as
974: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1187: , p_init_msg_list VARCHAR2
1188: , x_return_status out nocopy VARCHAR2
1189: , x_msg_count out nocopy NUMBER
1190: , x_msg_data out nocopy VARCHAR2
1191: , p5_a0 JTF_NUMBER_TABLE
1192: , p5_a1 JTF_NUMBER_TABLE
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1188: , x_return_status out nocopy VARCHAR2
1189: , x_msg_count out nocopy NUMBER
1190: , x_msg_data out nocopy VARCHAR2
1191: , p5_a0 JTF_NUMBER_TABLE
1192: , p5_a1 JTF_NUMBER_TABLE
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1189: , x_msg_count out nocopy NUMBER
1190: , x_msg_data out nocopy VARCHAR2
1191: , p5_a0 JTF_NUMBER_TABLE
1192: , p5_a1 JTF_NUMBER_TABLE
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1197: , p5_a6 JTF_NUMBER_TABLE
1190: , x_msg_data out nocopy VARCHAR2
1191: , p5_a0 JTF_NUMBER_TABLE
1192: , p5_a1 JTF_NUMBER_TABLE
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1197: , p5_a6 JTF_NUMBER_TABLE
1198: , p5_a7 JTF_VARCHAR2_TABLE_100
1191: , p5_a0 JTF_NUMBER_TABLE
1192: , p5_a1 JTF_NUMBER_TABLE
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1197: , p5_a6 JTF_NUMBER_TABLE
1198: , p5_a7 JTF_VARCHAR2_TABLE_100
1199: , p5_a8 JTF_VARCHAR2_TABLE_100
1193: , p5_a2 JTF_NUMBER_TABLE
1194: , p5_a3 JTF_NUMBER_TABLE
1195: , p5_a4 JTF_NUMBER_TABLE
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1197: , p5_a6 JTF_NUMBER_TABLE
1198: , p5_a7 JTF_VARCHAR2_TABLE_100
1199: , p5_a8 JTF_VARCHAR2_TABLE_100
1200: , p5_a9 JTF_NUMBER_TABLE
1201: , p5_a10 JTF_VARCHAR2_TABLE_2000
1196: , p5_a5 JTF_VARCHAR2_TABLE_100
1197: , p5_a6 JTF_NUMBER_TABLE
1198: , p5_a7 JTF_VARCHAR2_TABLE_100
1199: , p5_a8 JTF_VARCHAR2_TABLE_100
1200: , p5_a9 JTF_NUMBER_TABLE
1201: , p5_a10 JTF_VARCHAR2_TABLE_2000
1202: , p5_a11 JTF_VARCHAR2_TABLE_100
1203: , p5_a12 JTF_VARCHAR2_TABLE_300
1204: , p5_a13 JTF_VARCHAR2_TABLE_500
1218: , p5_a27 JTF_VARCHAR2_TABLE_500
1219: , p5_a28 JTF_VARCHAR2_TABLE_500
1220: , p5_a29 JTF_VARCHAR2_TABLE_500
1221: , p5_a30 JTF_VARCHAR2_TABLE_100
1222: , p5_a31 JTF_NUMBER_TABLE
1223: , p5_a32 JTF_DATE_TABLE
1224: , p5_a33 JTF_NUMBER_TABLE
1225: , p5_a34 JTF_DATE_TABLE
1226: , p5_a35 JTF_NUMBER_TABLE
1220: , p5_a29 JTF_VARCHAR2_TABLE_500
1221: , p5_a30 JTF_VARCHAR2_TABLE_100
1222: , p5_a31 JTF_NUMBER_TABLE
1223: , p5_a32 JTF_DATE_TABLE
1224: , p5_a33 JTF_NUMBER_TABLE
1225: , p5_a34 JTF_DATE_TABLE
1226: , p5_a35 JTF_NUMBER_TABLE
1227: )
1228:
1222: , p5_a31 JTF_NUMBER_TABLE
1223: , p5_a32 JTF_DATE_TABLE
1224: , p5_a33 JTF_NUMBER_TABLE
1225: , p5_a34 JTF_DATE_TABLE
1226: , p5_a35 JTF_NUMBER_TABLE
1227: )
1228:
1229: as
1230: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1478: , p_init_msg_list VARCHAR2
1479: , x_return_status out nocopy VARCHAR2
1480: , x_msg_count out nocopy NUMBER
1481: , x_msg_data out nocopy VARCHAR2
1482: , p5_a0 JTF_NUMBER_TABLE
1483: , p5_a1 JTF_NUMBER_TABLE
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1479: , x_return_status out nocopy VARCHAR2
1480: , x_msg_count out nocopy NUMBER
1481: , x_msg_data out nocopy VARCHAR2
1482: , p5_a0 JTF_NUMBER_TABLE
1483: , p5_a1 JTF_NUMBER_TABLE
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1480: , x_msg_count out nocopy NUMBER
1481: , x_msg_data out nocopy VARCHAR2
1482: , p5_a0 JTF_NUMBER_TABLE
1483: , p5_a1 JTF_NUMBER_TABLE
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1488: , p5_a6 JTF_NUMBER_TABLE
1481: , x_msg_data out nocopy VARCHAR2
1482: , p5_a0 JTF_NUMBER_TABLE
1483: , p5_a1 JTF_NUMBER_TABLE
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1488: , p5_a6 JTF_NUMBER_TABLE
1489: , p5_a7 JTF_VARCHAR2_TABLE_100
1482: , p5_a0 JTF_NUMBER_TABLE
1483: , p5_a1 JTF_NUMBER_TABLE
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1488: , p5_a6 JTF_NUMBER_TABLE
1489: , p5_a7 JTF_VARCHAR2_TABLE_100
1490: , p5_a8 JTF_VARCHAR2_TABLE_100
1484: , p5_a2 JTF_NUMBER_TABLE
1485: , p5_a3 JTF_NUMBER_TABLE
1486: , p5_a4 JTF_NUMBER_TABLE
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1488: , p5_a6 JTF_NUMBER_TABLE
1489: , p5_a7 JTF_VARCHAR2_TABLE_100
1490: , p5_a8 JTF_VARCHAR2_TABLE_100
1491: , p5_a9 JTF_NUMBER_TABLE
1492: , p5_a10 JTF_VARCHAR2_TABLE_2000
1487: , p5_a5 JTF_VARCHAR2_TABLE_100
1488: , p5_a6 JTF_NUMBER_TABLE
1489: , p5_a7 JTF_VARCHAR2_TABLE_100
1490: , p5_a8 JTF_VARCHAR2_TABLE_100
1491: , p5_a9 JTF_NUMBER_TABLE
1492: , p5_a10 JTF_VARCHAR2_TABLE_2000
1493: , p5_a11 JTF_VARCHAR2_TABLE_100
1494: , p5_a12 JTF_VARCHAR2_TABLE_300
1495: , p5_a13 JTF_VARCHAR2_TABLE_500
1509: , p5_a27 JTF_VARCHAR2_TABLE_500
1510: , p5_a28 JTF_VARCHAR2_TABLE_500
1511: , p5_a29 JTF_VARCHAR2_TABLE_500
1512: , p5_a30 JTF_VARCHAR2_TABLE_100
1513: , p5_a31 JTF_NUMBER_TABLE
1514: , p5_a32 JTF_DATE_TABLE
1515: , p5_a33 JTF_NUMBER_TABLE
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1511: , p5_a29 JTF_VARCHAR2_TABLE_500
1512: , p5_a30 JTF_VARCHAR2_TABLE_100
1513: , p5_a31 JTF_NUMBER_TABLE
1514: , p5_a32 JTF_DATE_TABLE
1515: , p5_a33 JTF_NUMBER_TABLE
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1513: , p5_a31 JTF_NUMBER_TABLE
1514: , p5_a32 JTF_DATE_TABLE
1515: , p5_a33 JTF_NUMBER_TABLE
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p5_a32 JTF_DATE_TABLE
1515: , p5_a33 JTF_NUMBER_TABLE
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1515: , p5_a33 JTF_NUMBER_TABLE
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1516: , p5_a34 JTF_DATE_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p6_a6 out nocopy JTF_NUMBER_TABLE
1517: , p5_a35 JTF_NUMBER_TABLE
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p6_a6 out nocopy JTF_NUMBER_TABLE
1525: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1518: , p6_a0 out nocopy JTF_NUMBER_TABLE
1519: , p6_a1 out nocopy JTF_NUMBER_TABLE
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p6_a6 out nocopy JTF_NUMBER_TABLE
1525: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1526: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1520: , p6_a2 out nocopy JTF_NUMBER_TABLE
1521: , p6_a3 out nocopy JTF_NUMBER_TABLE
1522: , p6_a4 out nocopy JTF_NUMBER_TABLE
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p6_a6 out nocopy JTF_NUMBER_TABLE
1525: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1526: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1527: , p6_a9 out nocopy JTF_NUMBER_TABLE
1528: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1523: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p6_a6 out nocopy JTF_NUMBER_TABLE
1525: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1526: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1527: , p6_a9 out nocopy JTF_NUMBER_TABLE
1528: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1529: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1530: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
1531: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1545: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1546: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1547: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1548: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p6_a31 out nocopy JTF_NUMBER_TABLE
1550: , p6_a32 out nocopy JTF_DATE_TABLE
1551: , p6_a33 out nocopy JTF_NUMBER_TABLE
1552: , p6_a34 out nocopy JTF_DATE_TABLE
1553: , p6_a35 out nocopy JTF_NUMBER_TABLE
1547: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1548: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p6_a31 out nocopy JTF_NUMBER_TABLE
1550: , p6_a32 out nocopy JTF_DATE_TABLE
1551: , p6_a33 out nocopy JTF_NUMBER_TABLE
1552: , p6_a34 out nocopy JTF_DATE_TABLE
1553: , p6_a35 out nocopy JTF_NUMBER_TABLE
1554: )
1555:
1549: , p6_a31 out nocopy JTF_NUMBER_TABLE
1550: , p6_a32 out nocopy JTF_DATE_TABLE
1551: , p6_a33 out nocopy JTF_NUMBER_TABLE
1552: , p6_a34 out nocopy JTF_DATE_TABLE
1553: , p6_a35 out nocopy JTF_NUMBER_TABLE
1554: )
1555:
1556: as
1557: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1770: , p_init_msg_list VARCHAR2
1771: , x_return_status out nocopy VARCHAR2
1772: , x_msg_count out nocopy NUMBER
1773: , x_msg_data out nocopy VARCHAR2
1774: , p5_a0 JTF_NUMBER_TABLE
1775: , p5_a1 JTF_NUMBER_TABLE
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1771: , x_return_status out nocopy VARCHAR2
1772: , x_msg_count out nocopy NUMBER
1773: , x_msg_data out nocopy VARCHAR2
1774: , p5_a0 JTF_NUMBER_TABLE
1775: , p5_a1 JTF_NUMBER_TABLE
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1772: , x_msg_count out nocopy NUMBER
1773: , x_msg_data out nocopy VARCHAR2
1774: , p5_a0 JTF_NUMBER_TABLE
1775: , p5_a1 JTF_NUMBER_TABLE
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1780: , p5_a6 JTF_NUMBER_TABLE
1773: , x_msg_data out nocopy VARCHAR2
1774: , p5_a0 JTF_NUMBER_TABLE
1775: , p5_a1 JTF_NUMBER_TABLE
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1780: , p5_a6 JTF_NUMBER_TABLE
1781: , p5_a7 JTF_VARCHAR2_TABLE_100
1774: , p5_a0 JTF_NUMBER_TABLE
1775: , p5_a1 JTF_NUMBER_TABLE
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1780: , p5_a6 JTF_NUMBER_TABLE
1781: , p5_a7 JTF_VARCHAR2_TABLE_100
1782: , p5_a8 JTF_VARCHAR2_TABLE_100
1776: , p5_a2 JTF_NUMBER_TABLE
1777: , p5_a3 JTF_NUMBER_TABLE
1778: , p5_a4 JTF_NUMBER_TABLE
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1780: , p5_a6 JTF_NUMBER_TABLE
1781: , p5_a7 JTF_VARCHAR2_TABLE_100
1782: , p5_a8 JTF_VARCHAR2_TABLE_100
1783: , p5_a9 JTF_NUMBER_TABLE
1784: , p5_a10 JTF_VARCHAR2_TABLE_2000
1779: , p5_a5 JTF_VARCHAR2_TABLE_100
1780: , p5_a6 JTF_NUMBER_TABLE
1781: , p5_a7 JTF_VARCHAR2_TABLE_100
1782: , p5_a8 JTF_VARCHAR2_TABLE_100
1783: , p5_a9 JTF_NUMBER_TABLE
1784: , p5_a10 JTF_VARCHAR2_TABLE_2000
1785: , p5_a11 JTF_VARCHAR2_TABLE_100
1786: , p5_a12 JTF_VARCHAR2_TABLE_300
1787: , p5_a13 JTF_VARCHAR2_TABLE_500
1801: , p5_a27 JTF_VARCHAR2_TABLE_500
1802: , p5_a28 JTF_VARCHAR2_TABLE_500
1803: , p5_a29 JTF_VARCHAR2_TABLE_500
1804: , p5_a30 JTF_VARCHAR2_TABLE_100
1805: , p5_a31 JTF_NUMBER_TABLE
1806: , p5_a32 JTF_DATE_TABLE
1807: , p5_a33 JTF_NUMBER_TABLE
1808: , p5_a34 JTF_DATE_TABLE
1809: , p5_a35 JTF_NUMBER_TABLE
1803: , p5_a29 JTF_VARCHAR2_TABLE_500
1804: , p5_a30 JTF_VARCHAR2_TABLE_100
1805: , p5_a31 JTF_NUMBER_TABLE
1806: , p5_a32 JTF_DATE_TABLE
1807: , p5_a33 JTF_NUMBER_TABLE
1808: , p5_a34 JTF_DATE_TABLE
1809: , p5_a35 JTF_NUMBER_TABLE
1810: )
1811:
1805: , p5_a31 JTF_NUMBER_TABLE
1806: , p5_a32 JTF_DATE_TABLE
1807: , p5_a33 JTF_NUMBER_TABLE
1808: , p5_a34 JTF_DATE_TABLE
1809: , p5_a35 JTF_NUMBER_TABLE
1810: )
1811:
1812: as
1813: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1985: , p_init_msg_list VARCHAR2
1986: , x_return_status out nocopy VARCHAR2
1987: , x_msg_count out nocopy NUMBER
1988: , x_msg_data out nocopy VARCHAR2
1989: , p5_a0 JTF_NUMBER_TABLE
1990: , p5_a1 JTF_NUMBER_TABLE
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1986: , x_return_status out nocopy VARCHAR2
1987: , x_msg_count out nocopy NUMBER
1988: , x_msg_data out nocopy VARCHAR2
1989: , p5_a0 JTF_NUMBER_TABLE
1990: , p5_a1 JTF_NUMBER_TABLE
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1987: , x_msg_count out nocopy NUMBER
1988: , x_msg_data out nocopy VARCHAR2
1989: , p5_a0 JTF_NUMBER_TABLE
1990: , p5_a1 JTF_NUMBER_TABLE
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1995: , p5_a6 JTF_NUMBER_TABLE
1988: , x_msg_data out nocopy VARCHAR2
1989: , p5_a0 JTF_NUMBER_TABLE
1990: , p5_a1 JTF_NUMBER_TABLE
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1995: , p5_a6 JTF_NUMBER_TABLE
1996: , p5_a7 JTF_VARCHAR2_TABLE_100
1989: , p5_a0 JTF_NUMBER_TABLE
1990: , p5_a1 JTF_NUMBER_TABLE
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1995: , p5_a6 JTF_NUMBER_TABLE
1996: , p5_a7 JTF_VARCHAR2_TABLE_100
1997: , p5_a8 JTF_VARCHAR2_TABLE_100
1991: , p5_a2 JTF_NUMBER_TABLE
1992: , p5_a3 JTF_NUMBER_TABLE
1993: , p5_a4 JTF_NUMBER_TABLE
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1995: , p5_a6 JTF_NUMBER_TABLE
1996: , p5_a7 JTF_VARCHAR2_TABLE_100
1997: , p5_a8 JTF_VARCHAR2_TABLE_100
1998: , p5_a9 JTF_NUMBER_TABLE
1999: , p5_a10 JTF_VARCHAR2_TABLE_2000
1994: , p5_a5 JTF_VARCHAR2_TABLE_100
1995: , p5_a6 JTF_NUMBER_TABLE
1996: , p5_a7 JTF_VARCHAR2_TABLE_100
1997: , p5_a8 JTF_VARCHAR2_TABLE_100
1998: , p5_a9 JTF_NUMBER_TABLE
1999: , p5_a10 JTF_VARCHAR2_TABLE_2000
2000: , p5_a11 JTF_VARCHAR2_TABLE_100
2001: , p5_a12 JTF_VARCHAR2_TABLE_300
2002: , p5_a13 JTF_VARCHAR2_TABLE_500
2016: , p5_a27 JTF_VARCHAR2_TABLE_500
2017: , p5_a28 JTF_VARCHAR2_TABLE_500
2018: , p5_a29 JTF_VARCHAR2_TABLE_500
2019: , p5_a30 JTF_VARCHAR2_TABLE_100
2020: , p5_a31 JTF_NUMBER_TABLE
2021: , p5_a32 JTF_DATE_TABLE
2022: , p5_a33 JTF_NUMBER_TABLE
2023: , p5_a34 JTF_DATE_TABLE
2024: , p5_a35 JTF_NUMBER_TABLE
2018: , p5_a29 JTF_VARCHAR2_TABLE_500
2019: , p5_a30 JTF_VARCHAR2_TABLE_100
2020: , p5_a31 JTF_NUMBER_TABLE
2021: , p5_a32 JTF_DATE_TABLE
2022: , p5_a33 JTF_NUMBER_TABLE
2023: , p5_a34 JTF_DATE_TABLE
2024: , p5_a35 JTF_NUMBER_TABLE
2025: )
2026:
2020: , p5_a31 JTF_NUMBER_TABLE
2021: , p5_a32 JTF_DATE_TABLE
2022: , p5_a33 JTF_NUMBER_TABLE
2023: , p5_a34 JTF_DATE_TABLE
2024: , p5_a35 JTF_NUMBER_TABLE
2025: )
2026:
2027: as
2028: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
2088:
2089:
2090: end;
2091:
2092: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
2093: , p0_a1 JTF_NUMBER_TABLE
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2089:
2090: end;
2091:
2092: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
2093: , p0_a1 JTF_NUMBER_TABLE
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2090: end;
2091:
2092: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
2093: , p0_a1 JTF_NUMBER_TABLE
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2098: , p0_a6 JTF_NUMBER_TABLE
2091:
2092: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
2093: , p0_a1 JTF_NUMBER_TABLE
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2098: , p0_a6 JTF_NUMBER_TABLE
2099: , p0_a7 JTF_VARCHAR2_TABLE_100
2092: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
2093: , p0_a1 JTF_NUMBER_TABLE
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2098: , p0_a6 JTF_NUMBER_TABLE
2099: , p0_a7 JTF_VARCHAR2_TABLE_100
2100: , p0_a8 JTF_VARCHAR2_TABLE_100
2094: , p0_a2 JTF_NUMBER_TABLE
2095: , p0_a3 JTF_NUMBER_TABLE
2096: , p0_a4 JTF_NUMBER_TABLE
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2098: , p0_a6 JTF_NUMBER_TABLE
2099: , p0_a7 JTF_VARCHAR2_TABLE_100
2100: , p0_a8 JTF_VARCHAR2_TABLE_100
2101: , p0_a9 JTF_NUMBER_TABLE
2102: , p0_a10 JTF_VARCHAR2_TABLE_2000
2097: , p0_a5 JTF_VARCHAR2_TABLE_100
2098: , p0_a6 JTF_NUMBER_TABLE
2099: , p0_a7 JTF_VARCHAR2_TABLE_100
2100: , p0_a8 JTF_VARCHAR2_TABLE_100
2101: , p0_a9 JTF_NUMBER_TABLE
2102: , p0_a10 JTF_VARCHAR2_TABLE_2000
2103: , p0_a11 JTF_VARCHAR2_TABLE_100
2104: , p0_a12 JTF_VARCHAR2_TABLE_300
2105: , p0_a13 JTF_VARCHAR2_TABLE_500
2119: , p0_a27 JTF_VARCHAR2_TABLE_500
2120: , p0_a28 JTF_VARCHAR2_TABLE_500
2121: , p0_a29 JTF_VARCHAR2_TABLE_500
2122: , p0_a30 JTF_VARCHAR2_TABLE_100
2123: , p0_a31 JTF_NUMBER_TABLE
2124: , p0_a32 JTF_DATE_TABLE
2125: , p0_a33 JTF_NUMBER_TABLE
2126: , p0_a34 JTF_DATE_TABLE
2127: , p0_a35 JTF_NUMBER_TABLE
2121: , p0_a29 JTF_VARCHAR2_TABLE_500
2122: , p0_a30 JTF_VARCHAR2_TABLE_100
2123: , p0_a31 JTF_NUMBER_TABLE
2124: , p0_a32 JTF_DATE_TABLE
2125: , p0_a33 JTF_NUMBER_TABLE
2126: , p0_a34 JTF_DATE_TABLE
2127: , p0_a35 JTF_NUMBER_TABLE
2128: )
2129:
2123: , p0_a31 JTF_NUMBER_TABLE
2124: , p0_a32 JTF_DATE_TABLE
2125: , p0_a33 JTF_NUMBER_TABLE
2126: , p0_a34 JTF_DATE_TABLE
2127: , p0_a35 JTF_NUMBER_TABLE
2128: )
2129:
2130: as
2131: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;