21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pox_pvt.poxv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pox_pvt.poxv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pox_pvt.poxv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_pox_pvt.poxv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_DATE_TABLE
32: , a7 JTF_DATE_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_VARCHAR2_TABLE_100
38: , a13 JTF_VARCHAR2_TABLE_100
39: , a14 JTF_VARCHAR2_TABLE_500
40: , a15 JTF_VARCHAR2_TABLE_500
50: , a25 JTF_VARCHAR2_TABLE_500
51: , a26 JTF_VARCHAR2_TABLE_500
52: , a27 JTF_VARCHAR2_TABLE_500
53: , a28 JTF_VARCHAR2_TABLE_500
54: , a29 JTF_NUMBER_TABLE
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_NUMBER_TABLE
51: , a26 JTF_VARCHAR2_TABLE_500
52: , a27 JTF_VARCHAR2_TABLE_500
53: , a28 JTF_VARCHAR2_TABLE_500
54: , a29 JTF_NUMBER_TABLE
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
52: , a27 JTF_VARCHAR2_TABLE_500
53: , a28 JTF_VARCHAR2_TABLE_500
54: , a29 JTF_NUMBER_TABLE
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
54: , a29 JTF_NUMBER_TABLE
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_NUMBER_TABLE
63: , a38 JTF_NUMBER_TABLE
64: ) as
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_NUMBER_TABLE
63: , a38 JTF_NUMBER_TABLE
64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
59: , a34 JTF_DATE_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_NUMBER_TABLE
63: , a38 JTF_NUMBER_TABLE
64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
67: if a0 is not null and a0.count > 0 then
116: end loop;
117: end if;
118: end if;
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_NUMBER_TABLE
122: , a2 out nocopy JTF_NUMBER_TABLE
123: , a3 out nocopy JTF_NUMBER_TABLE
124: , a4 out nocopy JTF_DATE_TABLE
117: end if;
118: end if;
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_NUMBER_TABLE
122: , a2 out nocopy JTF_NUMBER_TABLE
123: , a3 out nocopy JTF_NUMBER_TABLE
124: , a4 out nocopy JTF_DATE_TABLE
125: , a5 out nocopy JTF_VARCHAR2_TABLE_100
118: end if;
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_NUMBER_TABLE
122: , a2 out nocopy JTF_NUMBER_TABLE
123: , a3 out nocopy JTF_NUMBER_TABLE
124: , a4 out nocopy JTF_DATE_TABLE
125: , a5 out nocopy JTF_VARCHAR2_TABLE_100
126: , a6 out nocopy JTF_VARCHAR2_TABLE_100
119: end rosetta_table_copy_in_p2;
120: procedure rosetta_table_copy_out_p2(t okl_pox_pvt.poxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_NUMBER_TABLE
122: , a2 out nocopy JTF_NUMBER_TABLE
123: , a3 out nocopy JTF_NUMBER_TABLE
124: , a4 out nocopy JTF_DATE_TABLE
125: , a5 out nocopy JTF_VARCHAR2_TABLE_100
126: , a6 out nocopy JTF_VARCHAR2_TABLE_100
127: , a7 out nocopy JTF_DATE_TABLE
127: , a7 out nocopy JTF_DATE_TABLE
128: , a8 out nocopy JTF_VARCHAR2_TABLE_100
129: , a9 out nocopy JTF_VARCHAR2_TABLE_100
130: , a10 out nocopy JTF_DATE_TABLE
131: , a11 out nocopy JTF_NUMBER_TABLE
132: , a12 out nocopy JTF_VARCHAR2_TABLE_100
133: , a13 out nocopy JTF_VARCHAR2_TABLE_100
134: , a14 out nocopy JTF_VARCHAR2_TABLE_500
135: , a15 out nocopy JTF_VARCHAR2_TABLE_500
145: , a25 out nocopy JTF_VARCHAR2_TABLE_500
146: , a26 out nocopy JTF_VARCHAR2_TABLE_500
147: , a27 out nocopy JTF_VARCHAR2_TABLE_500
148: , a28 out nocopy JTF_VARCHAR2_TABLE_500
149: , a29 out nocopy JTF_NUMBER_TABLE
150: , a30 out nocopy JTF_NUMBER_TABLE
151: , a31 out nocopy JTF_NUMBER_TABLE
152: , a32 out nocopy JTF_DATE_TABLE
153: , a33 out nocopy JTF_NUMBER_TABLE
146: , a26 out nocopy JTF_VARCHAR2_TABLE_500
147: , a27 out nocopy JTF_VARCHAR2_TABLE_500
148: , a28 out nocopy JTF_VARCHAR2_TABLE_500
149: , a29 out nocopy JTF_NUMBER_TABLE
150: , a30 out nocopy JTF_NUMBER_TABLE
151: , a31 out nocopy JTF_NUMBER_TABLE
152: , a32 out nocopy JTF_DATE_TABLE
153: , a33 out nocopy JTF_NUMBER_TABLE
154: , a34 out nocopy JTF_DATE_TABLE
147: , a27 out nocopy JTF_VARCHAR2_TABLE_500
148: , a28 out nocopy JTF_VARCHAR2_TABLE_500
149: , a29 out nocopy JTF_NUMBER_TABLE
150: , a30 out nocopy JTF_NUMBER_TABLE
151: , a31 out nocopy JTF_NUMBER_TABLE
152: , a32 out nocopy JTF_DATE_TABLE
153: , a33 out nocopy JTF_NUMBER_TABLE
154: , a34 out nocopy JTF_DATE_TABLE
155: , a35 out nocopy JTF_NUMBER_TABLE
149: , a29 out nocopy JTF_NUMBER_TABLE
150: , a30 out nocopy JTF_NUMBER_TABLE
151: , a31 out nocopy JTF_NUMBER_TABLE
152: , a32 out nocopy JTF_DATE_TABLE
153: , a33 out nocopy JTF_NUMBER_TABLE
154: , a34 out nocopy JTF_DATE_TABLE
155: , a35 out nocopy JTF_NUMBER_TABLE
156: , a36 out nocopy JTF_DATE_TABLE
157: , a37 out nocopy JTF_NUMBER_TABLE
151: , a31 out nocopy JTF_NUMBER_TABLE
152: , a32 out nocopy JTF_DATE_TABLE
153: , a33 out nocopy JTF_NUMBER_TABLE
154: , a34 out nocopy JTF_DATE_TABLE
155: , a35 out nocopy JTF_NUMBER_TABLE
156: , a36 out nocopy JTF_DATE_TABLE
157: , a37 out nocopy JTF_NUMBER_TABLE
158: , a38 out nocopy JTF_NUMBER_TABLE
159: ) as
153: , a33 out nocopy JTF_NUMBER_TABLE
154: , a34 out nocopy JTF_DATE_TABLE
155: , a35 out nocopy JTF_NUMBER_TABLE
156: , a36 out nocopy JTF_DATE_TABLE
157: , a37 out nocopy JTF_NUMBER_TABLE
158: , a38 out nocopy JTF_NUMBER_TABLE
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
154: , a34 out nocopy JTF_DATE_TABLE
155: , a35 out nocopy JTF_NUMBER_TABLE
156: , a36 out nocopy JTF_DATE_TABLE
157: , a37 out nocopy JTF_NUMBER_TABLE
158: , a38 out nocopy JTF_NUMBER_TABLE
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_DATE_TABLE();
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_VARCHAR2_TABLE_100();
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_VARCHAR2_TABLE_100();
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_VARCHAR2_TABLE_100();
170: a7 := JTF_DATE_TABLE();
170: a7 := JTF_DATE_TABLE();
171: a8 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_DATE_TABLE();
174: a11 := JTF_NUMBER_TABLE();
175: a12 := JTF_VARCHAR2_TABLE_100();
176: a13 := JTF_VARCHAR2_TABLE_100();
177: a14 := JTF_VARCHAR2_TABLE_500();
178: a15 := JTF_VARCHAR2_TABLE_500();
188: a25 := JTF_VARCHAR2_TABLE_500();
189: a26 := JTF_VARCHAR2_TABLE_500();
190: a27 := JTF_VARCHAR2_TABLE_500();
191: a28 := JTF_VARCHAR2_TABLE_500();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_NUMBER_TABLE();
195: a32 := JTF_DATE_TABLE();
196: a33 := JTF_NUMBER_TABLE();
189: a26 := JTF_VARCHAR2_TABLE_500();
190: a27 := JTF_VARCHAR2_TABLE_500();
191: a28 := JTF_VARCHAR2_TABLE_500();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_NUMBER_TABLE();
195: a32 := JTF_DATE_TABLE();
196: a33 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
190: a27 := JTF_VARCHAR2_TABLE_500();
191: a28 := JTF_VARCHAR2_TABLE_500();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_NUMBER_TABLE();
195: a32 := JTF_DATE_TABLE();
196: a33 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
198: a35 := JTF_NUMBER_TABLE();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_NUMBER_TABLE();
195: a32 := JTF_DATE_TABLE();
196: a33 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
194: a31 := JTF_NUMBER_TABLE();
195: a32 := JTF_DATE_TABLE();
196: a33 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_NUMBER_TABLE();
202: else
196: a33 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
197: a34 := JTF_DATE_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
205: a2 := JTF_NUMBER_TABLE();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_NUMBER_TABLE();
207: a4 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_NUMBER_TABLE();
207: a4 := JTF_DATE_TABLE();
208: a5 := JTF_VARCHAR2_TABLE_100();
201: a38 := JTF_NUMBER_TABLE();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_NUMBER_TABLE();
207: a4 := JTF_DATE_TABLE();
208: a5 := JTF_VARCHAR2_TABLE_100();
209: a6 := JTF_VARCHAR2_TABLE_100();
202: else
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_NUMBER_TABLE();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_NUMBER_TABLE();
207: a4 := JTF_DATE_TABLE();
208: a5 := JTF_VARCHAR2_TABLE_100();
209: a6 := JTF_VARCHAR2_TABLE_100();
210: a7 := JTF_DATE_TABLE();
210: a7 := JTF_DATE_TABLE();
211: a8 := JTF_VARCHAR2_TABLE_100();
212: a9 := JTF_VARCHAR2_TABLE_100();
213: a10 := JTF_DATE_TABLE();
214: a11 := JTF_NUMBER_TABLE();
215: a12 := JTF_VARCHAR2_TABLE_100();
216: a13 := JTF_VARCHAR2_TABLE_100();
217: a14 := JTF_VARCHAR2_TABLE_500();
218: a15 := JTF_VARCHAR2_TABLE_500();
228: a25 := JTF_VARCHAR2_TABLE_500();
229: a26 := JTF_VARCHAR2_TABLE_500();
230: a27 := JTF_VARCHAR2_TABLE_500();
231: a28 := JTF_VARCHAR2_TABLE_500();
232: a29 := JTF_NUMBER_TABLE();
233: a30 := JTF_NUMBER_TABLE();
234: a31 := JTF_NUMBER_TABLE();
235: a32 := JTF_DATE_TABLE();
236: a33 := JTF_NUMBER_TABLE();
229: a26 := JTF_VARCHAR2_TABLE_500();
230: a27 := JTF_VARCHAR2_TABLE_500();
231: a28 := JTF_VARCHAR2_TABLE_500();
232: a29 := JTF_NUMBER_TABLE();
233: a30 := JTF_NUMBER_TABLE();
234: a31 := JTF_NUMBER_TABLE();
235: a32 := JTF_DATE_TABLE();
236: a33 := JTF_NUMBER_TABLE();
237: a34 := JTF_DATE_TABLE();
230: a27 := JTF_VARCHAR2_TABLE_500();
231: a28 := JTF_VARCHAR2_TABLE_500();
232: a29 := JTF_NUMBER_TABLE();
233: a30 := JTF_NUMBER_TABLE();
234: a31 := JTF_NUMBER_TABLE();
235: a32 := JTF_DATE_TABLE();
236: a33 := JTF_NUMBER_TABLE();
237: a34 := JTF_DATE_TABLE();
238: a35 := JTF_NUMBER_TABLE();
232: a29 := JTF_NUMBER_TABLE();
233: a30 := JTF_NUMBER_TABLE();
234: a31 := JTF_NUMBER_TABLE();
235: a32 := JTF_DATE_TABLE();
236: a33 := JTF_NUMBER_TABLE();
237: a34 := JTF_DATE_TABLE();
238: a35 := JTF_NUMBER_TABLE();
239: a36 := JTF_DATE_TABLE();
240: a37 := JTF_NUMBER_TABLE();
234: a31 := JTF_NUMBER_TABLE();
235: a32 := JTF_DATE_TABLE();
236: a33 := JTF_NUMBER_TABLE();
237: a34 := JTF_DATE_TABLE();
238: a35 := JTF_NUMBER_TABLE();
239: a36 := JTF_DATE_TABLE();
240: a37 := JTF_NUMBER_TABLE();
241: a38 := JTF_NUMBER_TABLE();
242: if t.count > 0 then
236: a33 := JTF_NUMBER_TABLE();
237: a34 := JTF_DATE_TABLE();
238: a35 := JTF_NUMBER_TABLE();
239: a36 := JTF_DATE_TABLE();
240: a37 := JTF_NUMBER_TABLE();
241: a38 := JTF_NUMBER_TABLE();
242: if t.count > 0 then
243: a0.extend(t.count);
244: a1.extend(t.count);
237: a34 := JTF_DATE_TABLE();
238: a35 := JTF_NUMBER_TABLE();
239: a36 := JTF_DATE_TABLE();
240: a37 := JTF_NUMBER_TABLE();
241: a38 := JTF_NUMBER_TABLE();
242: if t.count > 0 then
243: a0.extend(t.count);
244: a1.extend(t.count);
245: a2.extend(t.count);
330: end if;
331: end if;
332: end rosetta_table_copy_out_p2;
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_DATE_TABLE
331: end if;
332: end rosetta_table_copy_out_p2;
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_DATE_TABLE
339: , a5 JTF_VARCHAR2_TABLE_100
332: end rosetta_table_copy_out_p2;
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_DATE_TABLE
339: , a5 JTF_VARCHAR2_TABLE_100
340: , a6 JTF_VARCHAR2_TABLE_100
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy okl_pox_pvt.pox_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_DATE_TABLE
339: , a5 JTF_VARCHAR2_TABLE_100
340: , a6 JTF_VARCHAR2_TABLE_100
341: , a7 JTF_VARCHAR2_TABLE_100
342: , a8 JTF_DATE_TABLE
343: , a9 JTF_VARCHAR2_TABLE_100
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_DATE_TABLE
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_VARCHAR2_TABLE_100
348: , a14 JTF_VARCHAR2_TABLE_500
349: , a15 JTF_VARCHAR2_TABLE_500
350: , a16 JTF_VARCHAR2_TABLE_500
359: , a25 JTF_VARCHAR2_TABLE_500
360: , a26 JTF_VARCHAR2_TABLE_500
361: , a27 JTF_VARCHAR2_TABLE_500
362: , a28 JTF_VARCHAR2_TABLE_500
363: , a29 JTF_NUMBER_TABLE
364: , a30 JTF_NUMBER_TABLE
365: , a31 JTF_NUMBER_TABLE
366: , a32 JTF_DATE_TABLE
367: , a33 JTF_NUMBER_TABLE
360: , a26 JTF_VARCHAR2_TABLE_500
361: , a27 JTF_VARCHAR2_TABLE_500
362: , a28 JTF_VARCHAR2_TABLE_500
363: , a29 JTF_NUMBER_TABLE
364: , a30 JTF_NUMBER_TABLE
365: , a31 JTF_NUMBER_TABLE
366: , a32 JTF_DATE_TABLE
367: , a33 JTF_NUMBER_TABLE
368: , a34 JTF_DATE_TABLE
361: , a27 JTF_VARCHAR2_TABLE_500
362: , a28 JTF_VARCHAR2_TABLE_500
363: , a29 JTF_NUMBER_TABLE
364: , a30 JTF_NUMBER_TABLE
365: , a31 JTF_NUMBER_TABLE
366: , a32 JTF_DATE_TABLE
367: , a33 JTF_NUMBER_TABLE
368: , a34 JTF_DATE_TABLE
369: , a35 JTF_NUMBER_TABLE
363: , a29 JTF_NUMBER_TABLE
364: , a30 JTF_NUMBER_TABLE
365: , a31 JTF_NUMBER_TABLE
366: , a32 JTF_DATE_TABLE
367: , a33 JTF_NUMBER_TABLE
368: , a34 JTF_DATE_TABLE
369: , a35 JTF_NUMBER_TABLE
370: , a36 JTF_DATE_TABLE
371: , a37 JTF_NUMBER_TABLE
365: , a31 JTF_NUMBER_TABLE
366: , a32 JTF_DATE_TABLE
367: , a33 JTF_NUMBER_TABLE
368: , a34 JTF_DATE_TABLE
369: , a35 JTF_NUMBER_TABLE
370: , a36 JTF_DATE_TABLE
371: , a37 JTF_NUMBER_TABLE
372: , a38 JTF_NUMBER_TABLE
373: ) as
367: , a33 JTF_NUMBER_TABLE
368: , a34 JTF_DATE_TABLE
369: , a35 JTF_NUMBER_TABLE
370: , a36 JTF_DATE_TABLE
371: , a37 JTF_NUMBER_TABLE
372: , a38 JTF_NUMBER_TABLE
373: ) as
374: ddindx binary_integer; indx binary_integer;
375: begin
368: , a34 JTF_DATE_TABLE
369: , a35 JTF_NUMBER_TABLE
370: , a36 JTF_DATE_TABLE
371: , a37 JTF_NUMBER_TABLE
372: , a38 JTF_NUMBER_TABLE
373: ) as
374: ddindx binary_integer; indx binary_integer;
375: begin
376: if a0 is not null and a0.count > 0 then
425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_DATE_TABLE
426: end if;
427: end if;
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_DATE_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_100
427: end if;
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_DATE_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_100
435: , a6 out nocopy JTF_VARCHAR2_TABLE_100
428: end rosetta_table_copy_in_p5;
429: procedure rosetta_table_copy_out_p5(t okl_pox_pvt.pox_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: , a4 out nocopy JTF_DATE_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_100
435: , a6 out nocopy JTF_VARCHAR2_TABLE_100
436: , a7 out nocopy JTF_VARCHAR2_TABLE_100
437: , a8 out nocopy JTF_DATE_TABLE
438: , a9 out nocopy JTF_VARCHAR2_TABLE_100
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_DATE_TABLE
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_VARCHAR2_TABLE_100
443: , a14 out nocopy JTF_VARCHAR2_TABLE_500
444: , a15 out nocopy JTF_VARCHAR2_TABLE_500
445: , a16 out nocopy JTF_VARCHAR2_TABLE_500
454: , a25 out nocopy JTF_VARCHAR2_TABLE_500
455: , a26 out nocopy JTF_VARCHAR2_TABLE_500
456: , a27 out nocopy JTF_VARCHAR2_TABLE_500
457: , a28 out nocopy JTF_VARCHAR2_TABLE_500
458: , a29 out nocopy JTF_NUMBER_TABLE
459: , a30 out nocopy JTF_NUMBER_TABLE
460: , a31 out nocopy JTF_NUMBER_TABLE
461: , a32 out nocopy JTF_DATE_TABLE
462: , a33 out nocopy JTF_NUMBER_TABLE
455: , a26 out nocopy JTF_VARCHAR2_TABLE_500
456: , a27 out nocopy JTF_VARCHAR2_TABLE_500
457: , a28 out nocopy JTF_VARCHAR2_TABLE_500
458: , a29 out nocopy JTF_NUMBER_TABLE
459: , a30 out nocopy JTF_NUMBER_TABLE
460: , a31 out nocopy JTF_NUMBER_TABLE
461: , a32 out nocopy JTF_DATE_TABLE
462: , a33 out nocopy JTF_NUMBER_TABLE
463: , a34 out nocopy JTF_DATE_TABLE
456: , a27 out nocopy JTF_VARCHAR2_TABLE_500
457: , a28 out nocopy JTF_VARCHAR2_TABLE_500
458: , a29 out nocopy JTF_NUMBER_TABLE
459: , a30 out nocopy JTF_NUMBER_TABLE
460: , a31 out nocopy JTF_NUMBER_TABLE
461: , a32 out nocopy JTF_DATE_TABLE
462: , a33 out nocopy JTF_NUMBER_TABLE
463: , a34 out nocopy JTF_DATE_TABLE
464: , a35 out nocopy JTF_NUMBER_TABLE
458: , a29 out nocopy JTF_NUMBER_TABLE
459: , a30 out nocopy JTF_NUMBER_TABLE
460: , a31 out nocopy JTF_NUMBER_TABLE
461: , a32 out nocopy JTF_DATE_TABLE
462: , a33 out nocopy JTF_NUMBER_TABLE
463: , a34 out nocopy JTF_DATE_TABLE
464: , a35 out nocopy JTF_NUMBER_TABLE
465: , a36 out nocopy JTF_DATE_TABLE
466: , a37 out nocopy JTF_NUMBER_TABLE
460: , a31 out nocopy JTF_NUMBER_TABLE
461: , a32 out nocopy JTF_DATE_TABLE
462: , a33 out nocopy JTF_NUMBER_TABLE
463: , a34 out nocopy JTF_DATE_TABLE
464: , a35 out nocopy JTF_NUMBER_TABLE
465: , a36 out nocopy JTF_DATE_TABLE
466: , a37 out nocopy JTF_NUMBER_TABLE
467: , a38 out nocopy JTF_NUMBER_TABLE
468: ) as
462: , a33 out nocopy JTF_NUMBER_TABLE
463: , a34 out nocopy JTF_DATE_TABLE
464: , a35 out nocopy JTF_NUMBER_TABLE
465: , a36 out nocopy JTF_DATE_TABLE
466: , a37 out nocopy JTF_NUMBER_TABLE
467: , a38 out nocopy JTF_NUMBER_TABLE
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin
463: , a34 out nocopy JTF_DATE_TABLE
464: , a35 out nocopy JTF_NUMBER_TABLE
465: , a36 out nocopy JTF_DATE_TABLE
466: , a37 out nocopy JTF_NUMBER_TABLE
467: , a38 out nocopy JTF_NUMBER_TABLE
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null or t.count = 0 then
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null or t.count = 0 then
472: a0 := JTF_NUMBER_TABLE();
473: a1 := JTF_NUMBER_TABLE();
474: a2 := JTF_NUMBER_TABLE();
475: a3 := JTF_NUMBER_TABLE();
476: a4 := JTF_DATE_TABLE();
469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null or t.count = 0 then
472: a0 := JTF_NUMBER_TABLE();
473: a1 := JTF_NUMBER_TABLE();
474: a2 := JTF_NUMBER_TABLE();
475: a3 := JTF_NUMBER_TABLE();
476: a4 := JTF_DATE_TABLE();
477: a5 := JTF_VARCHAR2_TABLE_100();
470: begin
471: if t is null or t.count = 0 then
472: a0 := JTF_NUMBER_TABLE();
473: a1 := JTF_NUMBER_TABLE();
474: a2 := JTF_NUMBER_TABLE();
475: a3 := JTF_NUMBER_TABLE();
476: a4 := JTF_DATE_TABLE();
477: a5 := JTF_VARCHAR2_TABLE_100();
478: a6 := JTF_VARCHAR2_TABLE_100();
471: if t is null or t.count = 0 then
472: a0 := JTF_NUMBER_TABLE();
473: a1 := JTF_NUMBER_TABLE();
474: a2 := JTF_NUMBER_TABLE();
475: a3 := JTF_NUMBER_TABLE();
476: a4 := JTF_DATE_TABLE();
477: a5 := JTF_VARCHAR2_TABLE_100();
478: a6 := JTF_VARCHAR2_TABLE_100();
479: a7 := JTF_VARCHAR2_TABLE_100();
480: a8 := JTF_DATE_TABLE();
481: a9 := JTF_VARCHAR2_TABLE_100();
482: a10 := JTF_VARCHAR2_TABLE_100();
483: a11 := JTF_DATE_TABLE();
484: a12 := JTF_NUMBER_TABLE();
485: a13 := JTF_VARCHAR2_TABLE_100();
486: a14 := JTF_VARCHAR2_TABLE_500();
487: a15 := JTF_VARCHAR2_TABLE_500();
488: a16 := JTF_VARCHAR2_TABLE_500();
497: a25 := JTF_VARCHAR2_TABLE_500();
498: a26 := JTF_VARCHAR2_TABLE_500();
499: a27 := JTF_VARCHAR2_TABLE_500();
500: a28 := JTF_VARCHAR2_TABLE_500();
501: a29 := JTF_NUMBER_TABLE();
502: a30 := JTF_NUMBER_TABLE();
503: a31 := JTF_NUMBER_TABLE();
504: a32 := JTF_DATE_TABLE();
505: a33 := JTF_NUMBER_TABLE();
498: a26 := JTF_VARCHAR2_TABLE_500();
499: a27 := JTF_VARCHAR2_TABLE_500();
500: a28 := JTF_VARCHAR2_TABLE_500();
501: a29 := JTF_NUMBER_TABLE();
502: a30 := JTF_NUMBER_TABLE();
503: a31 := JTF_NUMBER_TABLE();
504: a32 := JTF_DATE_TABLE();
505: a33 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
499: a27 := JTF_VARCHAR2_TABLE_500();
500: a28 := JTF_VARCHAR2_TABLE_500();
501: a29 := JTF_NUMBER_TABLE();
502: a30 := JTF_NUMBER_TABLE();
503: a31 := JTF_NUMBER_TABLE();
504: a32 := JTF_DATE_TABLE();
505: a33 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
507: a35 := JTF_NUMBER_TABLE();
501: a29 := JTF_NUMBER_TABLE();
502: a30 := JTF_NUMBER_TABLE();
503: a31 := JTF_NUMBER_TABLE();
504: a32 := JTF_DATE_TABLE();
505: a33 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
507: a35 := JTF_NUMBER_TABLE();
508: a36 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
503: a31 := JTF_NUMBER_TABLE();
504: a32 := JTF_DATE_TABLE();
505: a33 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
507: a35 := JTF_NUMBER_TABLE();
508: a36 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
510: a38 := JTF_NUMBER_TABLE();
511: else
505: a33 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
507: a35 := JTF_NUMBER_TABLE();
508: a36 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
510: a38 := JTF_NUMBER_TABLE();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
506: a34 := JTF_DATE_TABLE();
507: a35 := JTF_NUMBER_TABLE();
508: a36 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
510: a38 := JTF_NUMBER_TABLE();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
514: a2 := JTF_NUMBER_TABLE();
508: a36 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
510: a38 := JTF_NUMBER_TABLE();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
514: a2 := JTF_NUMBER_TABLE();
515: a3 := JTF_NUMBER_TABLE();
516: a4 := JTF_DATE_TABLE();
509: a37 := JTF_NUMBER_TABLE();
510: a38 := JTF_NUMBER_TABLE();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
514: a2 := JTF_NUMBER_TABLE();
515: a3 := JTF_NUMBER_TABLE();
516: a4 := JTF_DATE_TABLE();
517: a5 := JTF_VARCHAR2_TABLE_100();
510: a38 := JTF_NUMBER_TABLE();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
514: a2 := JTF_NUMBER_TABLE();
515: a3 := JTF_NUMBER_TABLE();
516: a4 := JTF_DATE_TABLE();
517: a5 := JTF_VARCHAR2_TABLE_100();
518: a6 := JTF_VARCHAR2_TABLE_100();
511: else
512: a0 := JTF_NUMBER_TABLE();
513: a1 := JTF_NUMBER_TABLE();
514: a2 := JTF_NUMBER_TABLE();
515: a3 := JTF_NUMBER_TABLE();
516: a4 := JTF_DATE_TABLE();
517: a5 := JTF_VARCHAR2_TABLE_100();
518: a6 := JTF_VARCHAR2_TABLE_100();
519: a7 := JTF_VARCHAR2_TABLE_100();
520: a8 := JTF_DATE_TABLE();
521: a9 := JTF_VARCHAR2_TABLE_100();
522: a10 := JTF_VARCHAR2_TABLE_100();
523: a11 := JTF_DATE_TABLE();
524: a12 := JTF_NUMBER_TABLE();
525: a13 := JTF_VARCHAR2_TABLE_100();
526: a14 := JTF_VARCHAR2_TABLE_500();
527: a15 := JTF_VARCHAR2_TABLE_500();
528: a16 := JTF_VARCHAR2_TABLE_500();
537: a25 := JTF_VARCHAR2_TABLE_500();
538: a26 := JTF_VARCHAR2_TABLE_500();
539: a27 := JTF_VARCHAR2_TABLE_500();
540: a28 := JTF_VARCHAR2_TABLE_500();
541: a29 := JTF_NUMBER_TABLE();
542: a30 := JTF_NUMBER_TABLE();
543: a31 := JTF_NUMBER_TABLE();
544: a32 := JTF_DATE_TABLE();
545: a33 := JTF_NUMBER_TABLE();
538: a26 := JTF_VARCHAR2_TABLE_500();
539: a27 := JTF_VARCHAR2_TABLE_500();
540: a28 := JTF_VARCHAR2_TABLE_500();
541: a29 := JTF_NUMBER_TABLE();
542: a30 := JTF_NUMBER_TABLE();
543: a31 := JTF_NUMBER_TABLE();
544: a32 := JTF_DATE_TABLE();
545: a33 := JTF_NUMBER_TABLE();
546: a34 := JTF_DATE_TABLE();
539: a27 := JTF_VARCHAR2_TABLE_500();
540: a28 := JTF_VARCHAR2_TABLE_500();
541: a29 := JTF_NUMBER_TABLE();
542: a30 := JTF_NUMBER_TABLE();
543: a31 := JTF_NUMBER_TABLE();
544: a32 := JTF_DATE_TABLE();
545: a33 := JTF_NUMBER_TABLE();
546: a34 := JTF_DATE_TABLE();
547: a35 := JTF_NUMBER_TABLE();
541: a29 := JTF_NUMBER_TABLE();
542: a30 := JTF_NUMBER_TABLE();
543: a31 := JTF_NUMBER_TABLE();
544: a32 := JTF_DATE_TABLE();
545: a33 := JTF_NUMBER_TABLE();
546: a34 := JTF_DATE_TABLE();
547: a35 := JTF_NUMBER_TABLE();
548: a36 := JTF_DATE_TABLE();
549: a37 := JTF_NUMBER_TABLE();
543: a31 := JTF_NUMBER_TABLE();
544: a32 := JTF_DATE_TABLE();
545: a33 := JTF_NUMBER_TABLE();
546: a34 := JTF_DATE_TABLE();
547: a35 := JTF_NUMBER_TABLE();
548: a36 := JTF_DATE_TABLE();
549: a37 := JTF_NUMBER_TABLE();
550: a38 := JTF_NUMBER_TABLE();
551: if t.count > 0 then
545: a33 := JTF_NUMBER_TABLE();
546: a34 := JTF_DATE_TABLE();
547: a35 := JTF_NUMBER_TABLE();
548: a36 := JTF_DATE_TABLE();
549: a37 := JTF_NUMBER_TABLE();
550: a38 := JTF_NUMBER_TABLE();
551: if t.count > 0 then
552: a0.extend(t.count);
553: a1.extend(t.count);
546: a34 := JTF_DATE_TABLE();
547: a35 := JTF_NUMBER_TABLE();
548: a36 := JTF_DATE_TABLE();
549: a37 := JTF_NUMBER_TABLE();
550: a38 := JTF_NUMBER_TABLE();
551: if t.count > 0 then
552: a0.extend(t.count);
553: a1.extend(t.count);
554: a2.extend(t.count);
839: , p_init_msg_list VARCHAR2
840: , x_return_status out nocopy VARCHAR2
841: , x_msg_count out nocopy NUMBER
842: , x_msg_data out nocopy VARCHAR2
843: , p5_a0 JTF_NUMBER_TABLE
844: , p5_a1 JTF_NUMBER_TABLE
845: , p5_a2 JTF_NUMBER_TABLE
846: , p5_a3 JTF_NUMBER_TABLE
847: , p5_a4 JTF_DATE_TABLE
840: , x_return_status out nocopy VARCHAR2
841: , x_msg_count out nocopy NUMBER
842: , x_msg_data out nocopy VARCHAR2
843: , p5_a0 JTF_NUMBER_TABLE
844: , p5_a1 JTF_NUMBER_TABLE
845: , p5_a2 JTF_NUMBER_TABLE
846: , p5_a3 JTF_NUMBER_TABLE
847: , p5_a4 JTF_DATE_TABLE
848: , p5_a5 JTF_VARCHAR2_TABLE_100
841: , x_msg_count out nocopy NUMBER
842: , x_msg_data out nocopy VARCHAR2
843: , p5_a0 JTF_NUMBER_TABLE
844: , p5_a1 JTF_NUMBER_TABLE
845: , p5_a2 JTF_NUMBER_TABLE
846: , p5_a3 JTF_NUMBER_TABLE
847: , p5_a4 JTF_DATE_TABLE
848: , p5_a5 JTF_VARCHAR2_TABLE_100
849: , p5_a6 JTF_VARCHAR2_TABLE_100
842: , x_msg_data out nocopy VARCHAR2
843: , p5_a0 JTF_NUMBER_TABLE
844: , p5_a1 JTF_NUMBER_TABLE
845: , p5_a2 JTF_NUMBER_TABLE
846: , p5_a3 JTF_NUMBER_TABLE
847: , p5_a4 JTF_DATE_TABLE
848: , p5_a5 JTF_VARCHAR2_TABLE_100
849: , p5_a6 JTF_VARCHAR2_TABLE_100
850: , p5_a7 JTF_DATE_TABLE
850: , p5_a7 JTF_DATE_TABLE
851: , p5_a8 JTF_VARCHAR2_TABLE_100
852: , p5_a9 JTF_VARCHAR2_TABLE_100
853: , p5_a10 JTF_DATE_TABLE
854: , p5_a11 JTF_NUMBER_TABLE
855: , p5_a12 JTF_VARCHAR2_TABLE_100
856: , p5_a13 JTF_VARCHAR2_TABLE_100
857: , p5_a14 JTF_VARCHAR2_TABLE_500
858: , p5_a15 JTF_VARCHAR2_TABLE_500
868: , p5_a25 JTF_VARCHAR2_TABLE_500
869: , p5_a26 JTF_VARCHAR2_TABLE_500
870: , p5_a27 JTF_VARCHAR2_TABLE_500
871: , p5_a28 JTF_VARCHAR2_TABLE_500
872: , p5_a29 JTF_NUMBER_TABLE
873: , p5_a30 JTF_NUMBER_TABLE
874: , p5_a31 JTF_NUMBER_TABLE
875: , p5_a32 JTF_DATE_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
869: , p5_a26 JTF_VARCHAR2_TABLE_500
870: , p5_a27 JTF_VARCHAR2_TABLE_500
871: , p5_a28 JTF_VARCHAR2_TABLE_500
872: , p5_a29 JTF_NUMBER_TABLE
873: , p5_a30 JTF_NUMBER_TABLE
874: , p5_a31 JTF_NUMBER_TABLE
875: , p5_a32 JTF_DATE_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
870: , p5_a27 JTF_VARCHAR2_TABLE_500
871: , p5_a28 JTF_VARCHAR2_TABLE_500
872: , p5_a29 JTF_NUMBER_TABLE
873: , p5_a30 JTF_NUMBER_TABLE
874: , p5_a31 JTF_NUMBER_TABLE
875: , p5_a32 JTF_DATE_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
872: , p5_a29 JTF_NUMBER_TABLE
873: , p5_a30 JTF_NUMBER_TABLE
874: , p5_a31 JTF_NUMBER_TABLE
875: , p5_a32 JTF_DATE_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
874: , p5_a31 JTF_NUMBER_TABLE
875: , p5_a32 JTF_DATE_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
876: , p5_a33 JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
877: , p5_a34 JTF_DATE_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
885: , p6_a3 out nocopy JTF_NUMBER_TABLE
878: , p5_a35 JTF_NUMBER_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
885: , p6_a3 out nocopy JTF_NUMBER_TABLE
886: , p6_a4 out nocopy JTF_DATE_TABLE
879: , p5_a36 JTF_DATE_TABLE
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
885: , p6_a3 out nocopy JTF_NUMBER_TABLE
886: , p6_a4 out nocopy JTF_DATE_TABLE
887: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
880: , p5_a37 JTF_NUMBER_TABLE
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
885: , p6_a3 out nocopy JTF_NUMBER_TABLE
886: , p6_a4 out nocopy JTF_DATE_TABLE
887: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
888: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
881: , p5_a38 JTF_NUMBER_TABLE
882: , p6_a0 out nocopy JTF_NUMBER_TABLE
883: , p6_a1 out nocopy JTF_NUMBER_TABLE
884: , p6_a2 out nocopy JTF_NUMBER_TABLE
885: , p6_a3 out nocopy JTF_NUMBER_TABLE
886: , p6_a4 out nocopy JTF_DATE_TABLE
887: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
888: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
889: , p6_a7 out nocopy JTF_DATE_TABLE
889: , p6_a7 out nocopy JTF_DATE_TABLE
890: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
891: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a10 out nocopy JTF_DATE_TABLE
893: , p6_a11 out nocopy JTF_NUMBER_TABLE
894: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
895: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
896: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
897: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
907: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
908: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
909: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
910: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
911: , p6_a29 out nocopy JTF_NUMBER_TABLE
912: , p6_a30 out nocopy JTF_NUMBER_TABLE
913: , p6_a31 out nocopy JTF_NUMBER_TABLE
914: , p6_a32 out nocopy JTF_DATE_TABLE
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
908: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
909: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
910: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
911: , p6_a29 out nocopy JTF_NUMBER_TABLE
912: , p6_a30 out nocopy JTF_NUMBER_TABLE
913: , p6_a31 out nocopy JTF_NUMBER_TABLE
914: , p6_a32 out nocopy JTF_DATE_TABLE
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
916: , p6_a34 out nocopy JTF_DATE_TABLE
909: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
910: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
911: , p6_a29 out nocopy JTF_NUMBER_TABLE
912: , p6_a30 out nocopy JTF_NUMBER_TABLE
913: , p6_a31 out nocopy JTF_NUMBER_TABLE
914: , p6_a32 out nocopy JTF_DATE_TABLE
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
916: , p6_a34 out nocopy JTF_DATE_TABLE
917: , p6_a35 out nocopy JTF_NUMBER_TABLE
911: , p6_a29 out nocopy JTF_NUMBER_TABLE
912: , p6_a30 out nocopy JTF_NUMBER_TABLE
913: , p6_a31 out nocopy JTF_NUMBER_TABLE
914: , p6_a32 out nocopy JTF_DATE_TABLE
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
916: , p6_a34 out nocopy JTF_DATE_TABLE
917: , p6_a35 out nocopy JTF_NUMBER_TABLE
918: , p6_a36 out nocopy JTF_DATE_TABLE
919: , p6_a37 out nocopy JTF_NUMBER_TABLE
913: , p6_a31 out nocopy JTF_NUMBER_TABLE
914: , p6_a32 out nocopy JTF_DATE_TABLE
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
916: , p6_a34 out nocopy JTF_DATE_TABLE
917: , p6_a35 out nocopy JTF_NUMBER_TABLE
918: , p6_a36 out nocopy JTF_DATE_TABLE
919: , p6_a37 out nocopy JTF_NUMBER_TABLE
920: , p6_a38 out nocopy JTF_NUMBER_TABLE
921: )
915: , p6_a33 out nocopy JTF_NUMBER_TABLE
916: , p6_a34 out nocopy JTF_DATE_TABLE
917: , p6_a35 out nocopy JTF_NUMBER_TABLE
918: , p6_a36 out nocopy JTF_DATE_TABLE
919: , p6_a37 out nocopy JTF_NUMBER_TABLE
920: , p6_a38 out nocopy JTF_NUMBER_TABLE
921: )
922:
923: as
916: , p6_a34 out nocopy JTF_DATE_TABLE
917: , p6_a35 out nocopy JTF_NUMBER_TABLE
918: , p6_a36 out nocopy JTF_DATE_TABLE
919: , p6_a37 out nocopy JTF_NUMBER_TABLE
920: , p6_a38 out nocopy JTF_NUMBER_TABLE
921: )
922:
923: as
924: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1149: , p_init_msg_list VARCHAR2
1150: , x_return_status out nocopy VARCHAR2
1151: , x_msg_count out nocopy NUMBER
1152: , x_msg_data out nocopy VARCHAR2
1153: , p5_a0 JTF_NUMBER_TABLE
1154: , p5_a1 JTF_NUMBER_TABLE
1155: , p5_a2 JTF_NUMBER_TABLE
1156: , p5_a3 JTF_NUMBER_TABLE
1157: , p5_a4 JTF_DATE_TABLE
1150: , x_return_status out nocopy VARCHAR2
1151: , x_msg_count out nocopy NUMBER
1152: , x_msg_data out nocopy VARCHAR2
1153: , p5_a0 JTF_NUMBER_TABLE
1154: , p5_a1 JTF_NUMBER_TABLE
1155: , p5_a2 JTF_NUMBER_TABLE
1156: , p5_a3 JTF_NUMBER_TABLE
1157: , p5_a4 JTF_DATE_TABLE
1158: , p5_a5 JTF_VARCHAR2_TABLE_100
1151: , x_msg_count out nocopy NUMBER
1152: , x_msg_data out nocopy VARCHAR2
1153: , p5_a0 JTF_NUMBER_TABLE
1154: , p5_a1 JTF_NUMBER_TABLE
1155: , p5_a2 JTF_NUMBER_TABLE
1156: , p5_a3 JTF_NUMBER_TABLE
1157: , p5_a4 JTF_DATE_TABLE
1158: , p5_a5 JTF_VARCHAR2_TABLE_100
1159: , p5_a6 JTF_VARCHAR2_TABLE_100
1152: , x_msg_data out nocopy VARCHAR2
1153: , p5_a0 JTF_NUMBER_TABLE
1154: , p5_a1 JTF_NUMBER_TABLE
1155: , p5_a2 JTF_NUMBER_TABLE
1156: , p5_a3 JTF_NUMBER_TABLE
1157: , p5_a4 JTF_DATE_TABLE
1158: , p5_a5 JTF_VARCHAR2_TABLE_100
1159: , p5_a6 JTF_VARCHAR2_TABLE_100
1160: , p5_a7 JTF_DATE_TABLE
1160: , p5_a7 JTF_DATE_TABLE
1161: , p5_a8 JTF_VARCHAR2_TABLE_100
1162: , p5_a9 JTF_VARCHAR2_TABLE_100
1163: , p5_a10 JTF_DATE_TABLE
1164: , p5_a11 JTF_NUMBER_TABLE
1165: , p5_a12 JTF_VARCHAR2_TABLE_100
1166: , p5_a13 JTF_VARCHAR2_TABLE_100
1167: , p5_a14 JTF_VARCHAR2_TABLE_500
1168: , p5_a15 JTF_VARCHAR2_TABLE_500
1178: , p5_a25 JTF_VARCHAR2_TABLE_500
1179: , p5_a26 JTF_VARCHAR2_TABLE_500
1180: , p5_a27 JTF_VARCHAR2_TABLE_500
1181: , p5_a28 JTF_VARCHAR2_TABLE_500
1182: , p5_a29 JTF_NUMBER_TABLE
1183: , p5_a30 JTF_NUMBER_TABLE
1184: , p5_a31 JTF_NUMBER_TABLE
1185: , p5_a32 JTF_DATE_TABLE
1186: , p5_a33 JTF_NUMBER_TABLE
1179: , p5_a26 JTF_VARCHAR2_TABLE_500
1180: , p5_a27 JTF_VARCHAR2_TABLE_500
1181: , p5_a28 JTF_VARCHAR2_TABLE_500
1182: , p5_a29 JTF_NUMBER_TABLE
1183: , p5_a30 JTF_NUMBER_TABLE
1184: , p5_a31 JTF_NUMBER_TABLE
1185: , p5_a32 JTF_DATE_TABLE
1186: , p5_a33 JTF_NUMBER_TABLE
1187: , p5_a34 JTF_DATE_TABLE
1180: , p5_a27 JTF_VARCHAR2_TABLE_500
1181: , p5_a28 JTF_VARCHAR2_TABLE_500
1182: , p5_a29 JTF_NUMBER_TABLE
1183: , p5_a30 JTF_NUMBER_TABLE
1184: , p5_a31 JTF_NUMBER_TABLE
1185: , p5_a32 JTF_DATE_TABLE
1186: , p5_a33 JTF_NUMBER_TABLE
1187: , p5_a34 JTF_DATE_TABLE
1188: , p5_a35 JTF_NUMBER_TABLE
1182: , p5_a29 JTF_NUMBER_TABLE
1183: , p5_a30 JTF_NUMBER_TABLE
1184: , p5_a31 JTF_NUMBER_TABLE
1185: , p5_a32 JTF_DATE_TABLE
1186: , p5_a33 JTF_NUMBER_TABLE
1187: , p5_a34 JTF_DATE_TABLE
1188: , p5_a35 JTF_NUMBER_TABLE
1189: , p5_a36 JTF_DATE_TABLE
1190: , p5_a37 JTF_NUMBER_TABLE
1184: , p5_a31 JTF_NUMBER_TABLE
1185: , p5_a32 JTF_DATE_TABLE
1186: , p5_a33 JTF_NUMBER_TABLE
1187: , p5_a34 JTF_DATE_TABLE
1188: , p5_a35 JTF_NUMBER_TABLE
1189: , p5_a36 JTF_DATE_TABLE
1190: , p5_a37 JTF_NUMBER_TABLE
1191: , p5_a38 JTF_NUMBER_TABLE
1192: )
1186: , p5_a33 JTF_NUMBER_TABLE
1187: , p5_a34 JTF_DATE_TABLE
1188: , p5_a35 JTF_NUMBER_TABLE
1189: , p5_a36 JTF_DATE_TABLE
1190: , p5_a37 JTF_NUMBER_TABLE
1191: , p5_a38 JTF_NUMBER_TABLE
1192: )
1193:
1194: as
1187: , p5_a34 JTF_DATE_TABLE
1188: , p5_a35 JTF_NUMBER_TABLE
1189: , p5_a36 JTF_DATE_TABLE
1190: , p5_a37 JTF_NUMBER_TABLE
1191: , p5_a38 JTF_NUMBER_TABLE
1192: )
1193:
1194: as
1195: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1458: , p_init_msg_list VARCHAR2
1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_NUMBER_TABLE
1465: , p5_a3 JTF_NUMBER_TABLE
1466: , p5_a4 JTF_DATE_TABLE
1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_NUMBER_TABLE
1465: , p5_a3 JTF_NUMBER_TABLE
1466: , p5_a4 JTF_DATE_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_NUMBER_TABLE
1465: , p5_a3 JTF_NUMBER_TABLE
1466: , p5_a4 JTF_DATE_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_NUMBER_TABLE
1465: , p5_a3 JTF_NUMBER_TABLE
1466: , p5_a4 JTF_DATE_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_DATE_TABLE
1469: , p5_a7 JTF_DATE_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1471: , p5_a9 JTF_VARCHAR2_TABLE_100
1472: , p5_a10 JTF_DATE_TABLE
1473: , p5_a11 JTF_NUMBER_TABLE
1474: , p5_a12 JTF_VARCHAR2_TABLE_100
1475: , p5_a13 JTF_VARCHAR2_TABLE_100
1476: , p5_a14 JTF_VARCHAR2_TABLE_500
1477: , p5_a15 JTF_VARCHAR2_TABLE_500
1487: , p5_a25 JTF_VARCHAR2_TABLE_500
1488: , p5_a26 JTF_VARCHAR2_TABLE_500
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_NUMBER_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1488: , p5_a26 JTF_VARCHAR2_TABLE_500
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_NUMBER_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_NUMBER_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_NUMBER_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1496: , p5_a34 JTF_DATE_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1504: , p6_a3 out nocopy JTF_NUMBER_TABLE
1497: , p5_a35 JTF_NUMBER_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1504: , p6_a3 out nocopy JTF_NUMBER_TABLE
1505: , p6_a4 out nocopy JTF_DATE_TABLE
1498: , p5_a36 JTF_DATE_TABLE
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1504: , p6_a3 out nocopy JTF_NUMBER_TABLE
1505: , p6_a4 out nocopy JTF_DATE_TABLE
1506: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1499: , p5_a37 JTF_NUMBER_TABLE
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1504: , p6_a3 out nocopy JTF_NUMBER_TABLE
1505: , p6_a4 out nocopy JTF_DATE_TABLE
1506: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1507: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1500: , p5_a38 JTF_NUMBER_TABLE
1501: , p6_a0 out nocopy JTF_NUMBER_TABLE
1502: , p6_a1 out nocopy JTF_NUMBER_TABLE
1503: , p6_a2 out nocopy JTF_NUMBER_TABLE
1504: , p6_a3 out nocopy JTF_NUMBER_TABLE
1505: , p6_a4 out nocopy JTF_DATE_TABLE
1506: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1507: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1508: , p6_a7 out nocopy JTF_DATE_TABLE
1508: , p6_a7 out nocopy JTF_DATE_TABLE
1509: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1510: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1511: , p6_a10 out nocopy JTF_DATE_TABLE
1512: , p6_a11 out nocopy JTF_NUMBER_TABLE
1513: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1514: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1515: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1516: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1526: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1527: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1528: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1529: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1530: , p6_a29 out nocopy JTF_NUMBER_TABLE
1531: , p6_a30 out nocopy JTF_NUMBER_TABLE
1532: , p6_a31 out nocopy JTF_NUMBER_TABLE
1533: , p6_a32 out nocopy JTF_DATE_TABLE
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1527: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1528: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1529: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1530: , p6_a29 out nocopy JTF_NUMBER_TABLE
1531: , p6_a30 out nocopy JTF_NUMBER_TABLE
1532: , p6_a31 out nocopy JTF_NUMBER_TABLE
1533: , p6_a32 out nocopy JTF_DATE_TABLE
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1528: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1529: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1530: , p6_a29 out nocopy JTF_NUMBER_TABLE
1531: , p6_a30 out nocopy JTF_NUMBER_TABLE
1532: , p6_a31 out nocopy JTF_NUMBER_TABLE
1533: , p6_a32 out nocopy JTF_DATE_TABLE
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1536: , p6_a35 out nocopy JTF_NUMBER_TABLE
1530: , p6_a29 out nocopy JTF_NUMBER_TABLE
1531: , p6_a30 out nocopy JTF_NUMBER_TABLE
1532: , p6_a31 out nocopy JTF_NUMBER_TABLE
1533: , p6_a32 out nocopy JTF_DATE_TABLE
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1536: , p6_a35 out nocopy JTF_NUMBER_TABLE
1537: , p6_a36 out nocopy JTF_DATE_TABLE
1538: , p6_a37 out nocopy JTF_NUMBER_TABLE
1532: , p6_a31 out nocopy JTF_NUMBER_TABLE
1533: , p6_a32 out nocopy JTF_DATE_TABLE
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1536: , p6_a35 out nocopy JTF_NUMBER_TABLE
1537: , p6_a36 out nocopy JTF_DATE_TABLE
1538: , p6_a37 out nocopy JTF_NUMBER_TABLE
1539: , p6_a38 out nocopy JTF_NUMBER_TABLE
1540: )
1534: , p6_a33 out nocopy JTF_NUMBER_TABLE
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1536: , p6_a35 out nocopy JTF_NUMBER_TABLE
1537: , p6_a36 out nocopy JTF_DATE_TABLE
1538: , p6_a37 out nocopy JTF_NUMBER_TABLE
1539: , p6_a38 out nocopy JTF_NUMBER_TABLE
1540: )
1541:
1542: as
1535: , p6_a34 out nocopy JTF_DATE_TABLE
1536: , p6_a35 out nocopy JTF_NUMBER_TABLE
1537: , p6_a36 out nocopy JTF_DATE_TABLE
1538: , p6_a37 out nocopy JTF_NUMBER_TABLE
1539: , p6_a38 out nocopy JTF_NUMBER_TABLE
1540: )
1541:
1542: as
1543: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1768: , p_init_msg_list VARCHAR2
1769: , x_return_status out nocopy VARCHAR2
1770: , x_msg_count out nocopy NUMBER
1771: , x_msg_data out nocopy VARCHAR2
1772: , p5_a0 JTF_NUMBER_TABLE
1773: , p5_a1 JTF_NUMBER_TABLE
1774: , p5_a2 JTF_NUMBER_TABLE
1775: , p5_a3 JTF_NUMBER_TABLE
1776: , p5_a4 JTF_DATE_TABLE
1769: , x_return_status out nocopy VARCHAR2
1770: , x_msg_count out nocopy NUMBER
1771: , x_msg_data out nocopy VARCHAR2
1772: , p5_a0 JTF_NUMBER_TABLE
1773: , p5_a1 JTF_NUMBER_TABLE
1774: , p5_a2 JTF_NUMBER_TABLE
1775: , p5_a3 JTF_NUMBER_TABLE
1776: , p5_a4 JTF_DATE_TABLE
1777: , p5_a5 JTF_VARCHAR2_TABLE_100
1770: , x_msg_count out nocopy NUMBER
1771: , x_msg_data out nocopy VARCHAR2
1772: , p5_a0 JTF_NUMBER_TABLE
1773: , p5_a1 JTF_NUMBER_TABLE
1774: , p5_a2 JTF_NUMBER_TABLE
1775: , p5_a3 JTF_NUMBER_TABLE
1776: , p5_a4 JTF_DATE_TABLE
1777: , p5_a5 JTF_VARCHAR2_TABLE_100
1778: , p5_a6 JTF_VARCHAR2_TABLE_100
1771: , x_msg_data out nocopy VARCHAR2
1772: , p5_a0 JTF_NUMBER_TABLE
1773: , p5_a1 JTF_NUMBER_TABLE
1774: , p5_a2 JTF_NUMBER_TABLE
1775: , p5_a3 JTF_NUMBER_TABLE
1776: , p5_a4 JTF_DATE_TABLE
1777: , p5_a5 JTF_VARCHAR2_TABLE_100
1778: , p5_a6 JTF_VARCHAR2_TABLE_100
1779: , p5_a7 JTF_DATE_TABLE
1779: , p5_a7 JTF_DATE_TABLE
1780: , p5_a8 JTF_VARCHAR2_TABLE_100
1781: , p5_a9 JTF_VARCHAR2_TABLE_100
1782: , p5_a10 JTF_DATE_TABLE
1783: , p5_a11 JTF_NUMBER_TABLE
1784: , p5_a12 JTF_VARCHAR2_TABLE_100
1785: , p5_a13 JTF_VARCHAR2_TABLE_100
1786: , p5_a14 JTF_VARCHAR2_TABLE_500
1787: , p5_a15 JTF_VARCHAR2_TABLE_500
1797: , p5_a25 JTF_VARCHAR2_TABLE_500
1798: , p5_a26 JTF_VARCHAR2_TABLE_500
1799: , p5_a27 JTF_VARCHAR2_TABLE_500
1800: , p5_a28 JTF_VARCHAR2_TABLE_500
1801: , p5_a29 JTF_NUMBER_TABLE
1802: , p5_a30 JTF_NUMBER_TABLE
1803: , p5_a31 JTF_NUMBER_TABLE
1804: , p5_a32 JTF_DATE_TABLE
1805: , p5_a33 JTF_NUMBER_TABLE
1798: , p5_a26 JTF_VARCHAR2_TABLE_500
1799: , p5_a27 JTF_VARCHAR2_TABLE_500
1800: , p5_a28 JTF_VARCHAR2_TABLE_500
1801: , p5_a29 JTF_NUMBER_TABLE
1802: , p5_a30 JTF_NUMBER_TABLE
1803: , p5_a31 JTF_NUMBER_TABLE
1804: , p5_a32 JTF_DATE_TABLE
1805: , p5_a33 JTF_NUMBER_TABLE
1806: , p5_a34 JTF_DATE_TABLE
1799: , p5_a27 JTF_VARCHAR2_TABLE_500
1800: , p5_a28 JTF_VARCHAR2_TABLE_500
1801: , p5_a29 JTF_NUMBER_TABLE
1802: , p5_a30 JTF_NUMBER_TABLE
1803: , p5_a31 JTF_NUMBER_TABLE
1804: , p5_a32 JTF_DATE_TABLE
1805: , p5_a33 JTF_NUMBER_TABLE
1806: , p5_a34 JTF_DATE_TABLE
1807: , p5_a35 JTF_NUMBER_TABLE
1801: , p5_a29 JTF_NUMBER_TABLE
1802: , p5_a30 JTF_NUMBER_TABLE
1803: , p5_a31 JTF_NUMBER_TABLE
1804: , p5_a32 JTF_DATE_TABLE
1805: , p5_a33 JTF_NUMBER_TABLE
1806: , p5_a34 JTF_DATE_TABLE
1807: , p5_a35 JTF_NUMBER_TABLE
1808: , p5_a36 JTF_DATE_TABLE
1809: , p5_a37 JTF_NUMBER_TABLE
1803: , p5_a31 JTF_NUMBER_TABLE
1804: , p5_a32 JTF_DATE_TABLE
1805: , p5_a33 JTF_NUMBER_TABLE
1806: , p5_a34 JTF_DATE_TABLE
1807: , p5_a35 JTF_NUMBER_TABLE
1808: , p5_a36 JTF_DATE_TABLE
1809: , p5_a37 JTF_NUMBER_TABLE
1810: , p5_a38 JTF_NUMBER_TABLE
1811: )
1805: , p5_a33 JTF_NUMBER_TABLE
1806: , p5_a34 JTF_DATE_TABLE
1807: , p5_a35 JTF_NUMBER_TABLE
1808: , p5_a36 JTF_DATE_TABLE
1809: , p5_a37 JTF_NUMBER_TABLE
1810: , p5_a38 JTF_NUMBER_TABLE
1811: )
1812:
1813: as
1806: , p5_a34 JTF_DATE_TABLE
1807: , p5_a35 JTF_NUMBER_TABLE
1808: , p5_a36 JTF_DATE_TABLE
1809: , p5_a37 JTF_NUMBER_TABLE
1810: , p5_a38 JTF_NUMBER_TABLE
1811: )
1812:
1813: as
1814: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;
1995: , p_init_msg_list VARCHAR2
1996: , x_return_status out nocopy VARCHAR2
1997: , x_msg_count out nocopy NUMBER
1998: , x_msg_data out nocopy VARCHAR2
1999: , p5_a0 JTF_NUMBER_TABLE
2000: , p5_a1 JTF_NUMBER_TABLE
2001: , p5_a2 JTF_NUMBER_TABLE
2002: , p5_a3 JTF_NUMBER_TABLE
2003: , p5_a4 JTF_DATE_TABLE
1996: , x_return_status out nocopy VARCHAR2
1997: , x_msg_count out nocopy NUMBER
1998: , x_msg_data out nocopy VARCHAR2
1999: , p5_a0 JTF_NUMBER_TABLE
2000: , p5_a1 JTF_NUMBER_TABLE
2001: , p5_a2 JTF_NUMBER_TABLE
2002: , p5_a3 JTF_NUMBER_TABLE
2003: , p5_a4 JTF_DATE_TABLE
2004: , p5_a5 JTF_VARCHAR2_TABLE_100
1997: , x_msg_count out nocopy NUMBER
1998: , x_msg_data out nocopy VARCHAR2
1999: , p5_a0 JTF_NUMBER_TABLE
2000: , p5_a1 JTF_NUMBER_TABLE
2001: , p5_a2 JTF_NUMBER_TABLE
2002: , p5_a3 JTF_NUMBER_TABLE
2003: , p5_a4 JTF_DATE_TABLE
2004: , p5_a5 JTF_VARCHAR2_TABLE_100
2005: , p5_a6 JTF_VARCHAR2_TABLE_100
1998: , x_msg_data out nocopy VARCHAR2
1999: , p5_a0 JTF_NUMBER_TABLE
2000: , p5_a1 JTF_NUMBER_TABLE
2001: , p5_a2 JTF_NUMBER_TABLE
2002: , p5_a3 JTF_NUMBER_TABLE
2003: , p5_a4 JTF_DATE_TABLE
2004: , p5_a5 JTF_VARCHAR2_TABLE_100
2005: , p5_a6 JTF_VARCHAR2_TABLE_100
2006: , p5_a7 JTF_DATE_TABLE
2006: , p5_a7 JTF_DATE_TABLE
2007: , p5_a8 JTF_VARCHAR2_TABLE_100
2008: , p5_a9 JTF_VARCHAR2_TABLE_100
2009: , p5_a10 JTF_DATE_TABLE
2010: , p5_a11 JTF_NUMBER_TABLE
2011: , p5_a12 JTF_VARCHAR2_TABLE_100
2012: , p5_a13 JTF_VARCHAR2_TABLE_100
2013: , p5_a14 JTF_VARCHAR2_TABLE_500
2014: , p5_a15 JTF_VARCHAR2_TABLE_500
2024: , p5_a25 JTF_VARCHAR2_TABLE_500
2025: , p5_a26 JTF_VARCHAR2_TABLE_500
2026: , p5_a27 JTF_VARCHAR2_TABLE_500
2027: , p5_a28 JTF_VARCHAR2_TABLE_500
2028: , p5_a29 JTF_NUMBER_TABLE
2029: , p5_a30 JTF_NUMBER_TABLE
2030: , p5_a31 JTF_NUMBER_TABLE
2031: , p5_a32 JTF_DATE_TABLE
2032: , p5_a33 JTF_NUMBER_TABLE
2025: , p5_a26 JTF_VARCHAR2_TABLE_500
2026: , p5_a27 JTF_VARCHAR2_TABLE_500
2027: , p5_a28 JTF_VARCHAR2_TABLE_500
2028: , p5_a29 JTF_NUMBER_TABLE
2029: , p5_a30 JTF_NUMBER_TABLE
2030: , p5_a31 JTF_NUMBER_TABLE
2031: , p5_a32 JTF_DATE_TABLE
2032: , p5_a33 JTF_NUMBER_TABLE
2033: , p5_a34 JTF_DATE_TABLE
2026: , p5_a27 JTF_VARCHAR2_TABLE_500
2027: , p5_a28 JTF_VARCHAR2_TABLE_500
2028: , p5_a29 JTF_NUMBER_TABLE
2029: , p5_a30 JTF_NUMBER_TABLE
2030: , p5_a31 JTF_NUMBER_TABLE
2031: , p5_a32 JTF_DATE_TABLE
2032: , p5_a33 JTF_NUMBER_TABLE
2033: , p5_a34 JTF_DATE_TABLE
2034: , p5_a35 JTF_NUMBER_TABLE
2028: , p5_a29 JTF_NUMBER_TABLE
2029: , p5_a30 JTF_NUMBER_TABLE
2030: , p5_a31 JTF_NUMBER_TABLE
2031: , p5_a32 JTF_DATE_TABLE
2032: , p5_a33 JTF_NUMBER_TABLE
2033: , p5_a34 JTF_DATE_TABLE
2034: , p5_a35 JTF_NUMBER_TABLE
2035: , p5_a36 JTF_DATE_TABLE
2036: , p5_a37 JTF_NUMBER_TABLE
2030: , p5_a31 JTF_NUMBER_TABLE
2031: , p5_a32 JTF_DATE_TABLE
2032: , p5_a33 JTF_NUMBER_TABLE
2033: , p5_a34 JTF_DATE_TABLE
2034: , p5_a35 JTF_NUMBER_TABLE
2035: , p5_a36 JTF_DATE_TABLE
2036: , p5_a37 JTF_NUMBER_TABLE
2037: , p5_a38 JTF_NUMBER_TABLE
2038: )
2032: , p5_a33 JTF_NUMBER_TABLE
2033: , p5_a34 JTF_DATE_TABLE
2034: , p5_a35 JTF_NUMBER_TABLE
2035: , p5_a36 JTF_DATE_TABLE
2036: , p5_a37 JTF_NUMBER_TABLE
2037: , p5_a38 JTF_NUMBER_TABLE
2038: )
2039:
2040: as
2033: , p5_a34 JTF_DATE_TABLE
2034: , p5_a35 JTF_NUMBER_TABLE
2035: , p5_a36 JTF_DATE_TABLE
2036: , p5_a37 JTF_NUMBER_TABLE
2037: , p5_a38 JTF_NUMBER_TABLE
2038: )
2039:
2040: as
2041: ddp_poxv_tbl okl_pox_pvt.poxv_tbl_type;