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_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_VARCHAR2_TABLE_300
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_VARCHAR2_TABLE_300
50: , a28 JTF_VARCHAR2_TABLE_300
51: ) as
93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_VARCHAR2_TABLE_100
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_VARCHAR2_TABLE_100
103: , a6 out nocopy JTF_VARCHAR2_TABLE_500
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_VARCHAR2_TABLE_100
103: , a6 out nocopy JTF_VARCHAR2_TABLE_500
104: , a7 out nocopy JTF_VARCHAR2_TABLE_500
114: , a17 out nocopy JTF_VARCHAR2_TABLE_500
115: , a18 out nocopy JTF_VARCHAR2_TABLE_500
116: , a19 out nocopy JTF_VARCHAR2_TABLE_500
117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_NUMBER_TABLE
119: , a22 out nocopy JTF_DATE_TABLE
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_DATE_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
116: , a19 out nocopy JTF_VARCHAR2_TABLE_500
117: , a20 out nocopy JTF_VARCHAR2_TABLE_500
118: , a21 out nocopy JTF_NUMBER_TABLE
119: , a22 out nocopy JTF_DATE_TABLE
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_DATE_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_VARCHAR2_TABLE_300
118: , a21 out nocopy JTF_NUMBER_TABLE
119: , a22 out nocopy JTF_DATE_TABLE
120: , a23 out nocopy JTF_NUMBER_TABLE
121: , a24 out nocopy JTF_DATE_TABLE
122: , a25 out nocopy JTF_NUMBER_TABLE
123: , a26 out nocopy JTF_DATE_TABLE
124: , a27 out nocopy JTF_VARCHAR2_TABLE_300
125: , a28 out nocopy JTF_VARCHAR2_TABLE_300
126: ) as
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_NUMBER_TABLE();
134: a4 := JTF_DATE_TABLE();
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_NUMBER_TABLE();
134: a4 := JTF_DATE_TABLE();
135: a5 := JTF_VARCHAR2_TABLE_100();
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_NUMBER_TABLE();
134: a4 := JTF_DATE_TABLE();
135: a5 := JTF_VARCHAR2_TABLE_100();
136: a6 := JTF_VARCHAR2_TABLE_500();
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_NUMBER_TABLE();
134: a4 := JTF_DATE_TABLE();
135: a5 := JTF_VARCHAR2_TABLE_100();
136: a6 := JTF_VARCHAR2_TABLE_500();
137: a7 := JTF_VARCHAR2_TABLE_500();
147: a17 := JTF_VARCHAR2_TABLE_500();
148: a18 := JTF_VARCHAR2_TABLE_500();
149: a19 := JTF_VARCHAR2_TABLE_500();
150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_NUMBER_TABLE();
152: a22 := JTF_DATE_TABLE();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_DATE_TABLE();
155: a25 := JTF_NUMBER_TABLE();
149: a19 := JTF_VARCHAR2_TABLE_500();
150: a20 := JTF_VARCHAR2_TABLE_500();
151: a21 := JTF_NUMBER_TABLE();
152: a22 := JTF_DATE_TABLE();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_DATE_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_VARCHAR2_TABLE_300();
151: a21 := JTF_NUMBER_TABLE();
152: a22 := JTF_DATE_TABLE();
153: a23 := JTF_NUMBER_TABLE();
154: a24 := JTF_DATE_TABLE();
155: a25 := JTF_NUMBER_TABLE();
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_VARCHAR2_TABLE_300();
158: a28 := JTF_VARCHAR2_TABLE_300();
159: else
156: a26 := JTF_DATE_TABLE();
157: a27 := JTF_VARCHAR2_TABLE_300();
158: a28 := JTF_VARCHAR2_TABLE_300();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
157: a27 := JTF_VARCHAR2_TABLE_300();
158: a28 := JTF_VARCHAR2_TABLE_300();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();
158: a28 := JTF_VARCHAR2_TABLE_300();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_500();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_500();
167: a7 := JTF_VARCHAR2_TABLE_500();
177: a17 := JTF_VARCHAR2_TABLE_500();
178: a18 := JTF_VARCHAR2_TABLE_500();
179: a19 := JTF_VARCHAR2_TABLE_500();
180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_NUMBER_TABLE();
182: a22 := JTF_DATE_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_DATE_TABLE();
185: a25 := JTF_NUMBER_TABLE();
179: a19 := JTF_VARCHAR2_TABLE_500();
180: a20 := JTF_VARCHAR2_TABLE_500();
181: a21 := JTF_NUMBER_TABLE();
182: a22 := JTF_DATE_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_DATE_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_VARCHAR2_TABLE_300();
181: a21 := JTF_NUMBER_TABLE();
182: a22 := JTF_DATE_TABLE();
183: a23 := JTF_NUMBER_TABLE();
184: a24 := JTF_DATE_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_DATE_TABLE();
187: a27 := JTF_VARCHAR2_TABLE_300();
188: a28 := JTF_VARCHAR2_TABLE_300();
189: if t.count > 0 then
257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_100
263: , a2 JTF_VARCHAR2_TABLE_100
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_VARCHAR2_TABLE_200
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_VARCHAR2_TABLE_200
266: , a5 JTF_VARCHAR2_TABLE_2000
267: , a6 JTF_VARCHAR2_TABLE_2000
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_DATE_TABLE
270: , a9 JTF_NUMBER_TABLE
271: , a10 JTF_DATE_TABLE
272: , a11 JTF_NUMBER_TABLE
266: , a5 JTF_VARCHAR2_TABLE_2000
267: , a6 JTF_VARCHAR2_TABLE_2000
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_DATE_TABLE
270: , a9 JTF_NUMBER_TABLE
271: , a10 JTF_DATE_TABLE
272: , a11 JTF_NUMBER_TABLE
273: ) as
274: ddindx binary_integer; indx binary_integer;
268: , a7 JTF_NUMBER_TABLE
269: , a8 JTF_DATE_TABLE
270: , a9 JTF_NUMBER_TABLE
271: , a10 JTF_DATE_TABLE
272: , a11 JTF_NUMBER_TABLE
273: ) as
274: ddindx binary_integer; indx binary_integer;
275: begin
276: if a0 is not null and a0.count > 0 then
298: end loop;
299: end if;
300: end if;
301: end rosetta_table_copy_in_p5;
302: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
303: , a1 out nocopy JTF_VARCHAR2_TABLE_100
304: , a2 out nocopy JTF_VARCHAR2_TABLE_100
305: , a3 out nocopy JTF_VARCHAR2_TABLE_100
306: , a4 out nocopy JTF_VARCHAR2_TABLE_200
305: , a3 out nocopy JTF_VARCHAR2_TABLE_100
306: , a4 out nocopy JTF_VARCHAR2_TABLE_200
307: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
308: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
309: , a7 out nocopy JTF_NUMBER_TABLE
310: , a8 out nocopy JTF_DATE_TABLE
311: , a9 out nocopy JTF_NUMBER_TABLE
312: , a10 out nocopy JTF_DATE_TABLE
313: , a11 out nocopy JTF_NUMBER_TABLE
307: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
308: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
309: , a7 out nocopy JTF_NUMBER_TABLE
310: , a8 out nocopy JTF_DATE_TABLE
311: , a9 out nocopy JTF_NUMBER_TABLE
312: , a10 out nocopy JTF_DATE_TABLE
313: , a11 out nocopy JTF_NUMBER_TABLE
314: ) as
315: ddindx binary_integer; indx binary_integer;
309: , a7 out nocopy JTF_NUMBER_TABLE
310: , a8 out nocopy JTF_DATE_TABLE
311: , a9 out nocopy JTF_NUMBER_TABLE
312: , a10 out nocopy JTF_DATE_TABLE
313: , a11 out nocopy JTF_NUMBER_TABLE
314: ) as
315: ddindx binary_integer; indx binary_integer;
316: begin
317: if t is null or t.count = 0 then
314: ) as
315: ddindx binary_integer; indx binary_integer;
316: begin
317: if t is null or t.count = 0 then
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_VARCHAR2_TABLE_100();
320: a2 := JTF_VARCHAR2_TABLE_100();
321: a3 := JTF_VARCHAR2_TABLE_100();
322: a4 := JTF_VARCHAR2_TABLE_200();
321: a3 := JTF_VARCHAR2_TABLE_100();
322: a4 := JTF_VARCHAR2_TABLE_200();
323: a5 := JTF_VARCHAR2_TABLE_2000();
324: a6 := JTF_VARCHAR2_TABLE_2000();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_DATE_TABLE();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_DATE_TABLE();
329: a11 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_2000();
324: a6 := JTF_VARCHAR2_TABLE_2000();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_DATE_TABLE();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_DATE_TABLE();
329: a11 := JTF_NUMBER_TABLE();
330: else
331: a0 := JTF_NUMBER_TABLE();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_DATE_TABLE();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_DATE_TABLE();
329: a11 := JTF_NUMBER_TABLE();
330: else
331: a0 := JTF_NUMBER_TABLE();
332: a1 := JTF_VARCHAR2_TABLE_100();
333: a2 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_DATE_TABLE();
329: a11 := JTF_NUMBER_TABLE();
330: else
331: a0 := JTF_NUMBER_TABLE();
332: a1 := JTF_VARCHAR2_TABLE_100();
333: a2 := JTF_VARCHAR2_TABLE_100();
334: a3 := JTF_VARCHAR2_TABLE_100();
335: a4 := JTF_VARCHAR2_TABLE_200();
334: a3 := JTF_VARCHAR2_TABLE_100();
335: a4 := JTF_VARCHAR2_TABLE_200();
336: a5 := JTF_VARCHAR2_TABLE_2000();
337: a6 := JTF_VARCHAR2_TABLE_2000();
338: a7 := JTF_NUMBER_TABLE();
339: a8 := JTF_DATE_TABLE();
340: a9 := JTF_NUMBER_TABLE();
341: a10 := JTF_DATE_TABLE();
342: a11 := JTF_NUMBER_TABLE();
336: a5 := JTF_VARCHAR2_TABLE_2000();
337: a6 := JTF_VARCHAR2_TABLE_2000();
338: a7 := JTF_NUMBER_TABLE();
339: a8 := JTF_DATE_TABLE();
340: a9 := JTF_NUMBER_TABLE();
341: a10 := JTF_DATE_TABLE();
342: a11 := JTF_NUMBER_TABLE();
343: if t.count > 0 then
344: a0.extend(t.count);
338: a7 := JTF_NUMBER_TABLE();
339: a8 := JTF_DATE_TABLE();
340: a9 := JTF_NUMBER_TABLE();
341: a10 := JTF_DATE_TABLE();
342: a11 := JTF_NUMBER_TABLE();
343: if t.count > 0 then
344: a0.extend(t.count);
345: a1.extend(t.count);
346: a2.extend(t.count);
377: end if;
378: end if;
379: end rosetta_table_copy_out_p5;
380:
381: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
382: , a1 JTF_NUMBER_TABLE
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_VARCHAR2_TABLE_100
385: , a4 JTF_VARCHAR2_TABLE_200
378: end if;
379: end rosetta_table_copy_out_p5;
380:
381: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
382: , a1 JTF_NUMBER_TABLE
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_VARCHAR2_TABLE_100
385: , a4 JTF_VARCHAR2_TABLE_200
386: , a5 JTF_VARCHAR2_TABLE_2000
379: end rosetta_table_copy_out_p5;
380:
381: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
382: , a1 JTF_NUMBER_TABLE
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_VARCHAR2_TABLE_100
385: , a4 JTF_VARCHAR2_TABLE_200
386: , a5 JTF_VARCHAR2_TABLE_2000
387: , a6 JTF_NUMBER_TABLE
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_VARCHAR2_TABLE_100
385: , a4 JTF_VARCHAR2_TABLE_200
386: , a5 JTF_VARCHAR2_TABLE_2000
387: , a6 JTF_NUMBER_TABLE
388: , a7 JTF_VARCHAR2_TABLE_2000
389: , a8 JTF_DATE_TABLE
390: , a9 JTF_VARCHAR2_TABLE_100
391: , a10 JTF_VARCHAR2_TABLE_500
402: , a21 JTF_VARCHAR2_TABLE_500
403: , a22 JTF_VARCHAR2_TABLE_500
404: , a23 JTF_VARCHAR2_TABLE_500
405: , a24 JTF_VARCHAR2_TABLE_500
406: , a25 JTF_NUMBER_TABLE
407: , a26 JTF_DATE_TABLE
408: , a27 JTF_NUMBER_TABLE
409: , a28 JTF_DATE_TABLE
410: , a29 JTF_NUMBER_TABLE
404: , a23 JTF_VARCHAR2_TABLE_500
405: , a24 JTF_VARCHAR2_TABLE_500
406: , a25 JTF_NUMBER_TABLE
407: , a26 JTF_DATE_TABLE
408: , a27 JTF_NUMBER_TABLE
409: , a28 JTF_DATE_TABLE
410: , a29 JTF_NUMBER_TABLE
411: , a30 JTF_DATE_TABLE
412: , a31 JTF_VARCHAR2_TABLE_300
406: , a25 JTF_NUMBER_TABLE
407: , a26 JTF_DATE_TABLE
408: , a27 JTF_NUMBER_TABLE
409: , a28 JTF_DATE_TABLE
410: , a29 JTF_NUMBER_TABLE
411: , a30 JTF_DATE_TABLE
412: , a31 JTF_VARCHAR2_TABLE_300
413: , a32 JTF_VARCHAR2_TABLE_300
414: ) as
460: end loop;
461: end if;
462: end if;
463: end rosetta_table_copy_in_p8;
464: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
465: , a1 out nocopy JTF_NUMBER_TABLE
466: , a2 out nocopy JTF_NUMBER_TABLE
467: , a3 out nocopy JTF_VARCHAR2_TABLE_100
468: , a4 out nocopy JTF_VARCHAR2_TABLE_200
461: end if;
462: end if;
463: end rosetta_table_copy_in_p8;
464: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
465: , a1 out nocopy JTF_NUMBER_TABLE
466: , a2 out nocopy JTF_NUMBER_TABLE
467: , a3 out nocopy JTF_VARCHAR2_TABLE_100
468: , a4 out nocopy JTF_VARCHAR2_TABLE_200
469: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
462: end if;
463: end rosetta_table_copy_in_p8;
464: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
465: , a1 out nocopy JTF_NUMBER_TABLE
466: , a2 out nocopy JTF_NUMBER_TABLE
467: , a3 out nocopy JTF_VARCHAR2_TABLE_100
468: , a4 out nocopy JTF_VARCHAR2_TABLE_200
469: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
470: , a6 out nocopy JTF_NUMBER_TABLE
466: , a2 out nocopy JTF_NUMBER_TABLE
467: , a3 out nocopy JTF_VARCHAR2_TABLE_100
468: , a4 out nocopy JTF_VARCHAR2_TABLE_200
469: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
470: , a6 out nocopy JTF_NUMBER_TABLE
471: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
472: , a8 out nocopy JTF_DATE_TABLE
473: , a9 out nocopy JTF_VARCHAR2_TABLE_100
474: , a10 out nocopy JTF_VARCHAR2_TABLE_500
485: , a21 out nocopy JTF_VARCHAR2_TABLE_500
486: , a22 out nocopy JTF_VARCHAR2_TABLE_500
487: , a23 out nocopy JTF_VARCHAR2_TABLE_500
488: , a24 out nocopy JTF_VARCHAR2_TABLE_500
489: , a25 out nocopy JTF_NUMBER_TABLE
490: , a26 out nocopy JTF_DATE_TABLE
491: , a27 out nocopy JTF_NUMBER_TABLE
492: , a28 out nocopy JTF_DATE_TABLE
493: , a29 out nocopy JTF_NUMBER_TABLE
487: , a23 out nocopy JTF_VARCHAR2_TABLE_500
488: , a24 out nocopy JTF_VARCHAR2_TABLE_500
489: , a25 out nocopy JTF_NUMBER_TABLE
490: , a26 out nocopy JTF_DATE_TABLE
491: , a27 out nocopy JTF_NUMBER_TABLE
492: , a28 out nocopy JTF_DATE_TABLE
493: , a29 out nocopy JTF_NUMBER_TABLE
494: , a30 out nocopy JTF_DATE_TABLE
495: , a31 out nocopy JTF_VARCHAR2_TABLE_300
489: , a25 out nocopy JTF_NUMBER_TABLE
490: , a26 out nocopy JTF_DATE_TABLE
491: , a27 out nocopy JTF_NUMBER_TABLE
492: , a28 out nocopy JTF_DATE_TABLE
493: , a29 out nocopy JTF_NUMBER_TABLE
494: , a30 out nocopy JTF_DATE_TABLE
495: , a31 out nocopy JTF_VARCHAR2_TABLE_300
496: , a32 out nocopy JTF_VARCHAR2_TABLE_300
497: ) as
497: ) as
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_VARCHAR2_TABLE_100();
505: a4 := JTF_VARCHAR2_TABLE_200();
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_VARCHAR2_TABLE_100();
505: a4 := JTF_VARCHAR2_TABLE_200();
506: a5 := JTF_VARCHAR2_TABLE_2000();
499: begin
500: if t is null or t.count = 0 then
501: a0 := JTF_NUMBER_TABLE();
502: a1 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_VARCHAR2_TABLE_100();
505: a4 := JTF_VARCHAR2_TABLE_200();
506: a5 := JTF_VARCHAR2_TABLE_2000();
507: a6 := JTF_NUMBER_TABLE();
503: a2 := JTF_NUMBER_TABLE();
504: a3 := JTF_VARCHAR2_TABLE_100();
505: a4 := JTF_VARCHAR2_TABLE_200();
506: a5 := JTF_VARCHAR2_TABLE_2000();
507: a6 := JTF_NUMBER_TABLE();
508: a7 := JTF_VARCHAR2_TABLE_2000();
509: a8 := JTF_DATE_TABLE();
510: a9 := JTF_VARCHAR2_TABLE_100();
511: a10 := JTF_VARCHAR2_TABLE_500();
522: a21 := JTF_VARCHAR2_TABLE_500();
523: a22 := JTF_VARCHAR2_TABLE_500();
524: a23 := JTF_VARCHAR2_TABLE_500();
525: a24 := JTF_VARCHAR2_TABLE_500();
526: a25 := JTF_NUMBER_TABLE();
527: a26 := JTF_DATE_TABLE();
528: a27 := JTF_NUMBER_TABLE();
529: a28 := JTF_DATE_TABLE();
530: a29 := JTF_NUMBER_TABLE();
524: a23 := JTF_VARCHAR2_TABLE_500();
525: a24 := JTF_VARCHAR2_TABLE_500();
526: a25 := JTF_NUMBER_TABLE();
527: a26 := JTF_DATE_TABLE();
528: a27 := JTF_NUMBER_TABLE();
529: a28 := JTF_DATE_TABLE();
530: a29 := JTF_NUMBER_TABLE();
531: a30 := JTF_DATE_TABLE();
532: a31 := JTF_VARCHAR2_TABLE_300();
526: a25 := JTF_NUMBER_TABLE();
527: a26 := JTF_DATE_TABLE();
528: a27 := JTF_NUMBER_TABLE();
529: a28 := JTF_DATE_TABLE();
530: a29 := JTF_NUMBER_TABLE();
531: a30 := JTF_DATE_TABLE();
532: a31 := JTF_VARCHAR2_TABLE_300();
533: a32 := JTF_VARCHAR2_TABLE_300();
534: else
531: a30 := JTF_DATE_TABLE();
532: a31 := JTF_VARCHAR2_TABLE_300();
533: a32 := JTF_VARCHAR2_TABLE_300();
534: else
535: a0 := JTF_NUMBER_TABLE();
536: a1 := JTF_NUMBER_TABLE();
537: a2 := JTF_NUMBER_TABLE();
538: a3 := JTF_VARCHAR2_TABLE_100();
539: a4 := JTF_VARCHAR2_TABLE_200();
532: a31 := JTF_VARCHAR2_TABLE_300();
533: a32 := JTF_VARCHAR2_TABLE_300();
534: else
535: a0 := JTF_NUMBER_TABLE();
536: a1 := JTF_NUMBER_TABLE();
537: a2 := JTF_NUMBER_TABLE();
538: a3 := JTF_VARCHAR2_TABLE_100();
539: a4 := JTF_VARCHAR2_TABLE_200();
540: a5 := JTF_VARCHAR2_TABLE_2000();
533: a32 := JTF_VARCHAR2_TABLE_300();
534: else
535: a0 := JTF_NUMBER_TABLE();
536: a1 := JTF_NUMBER_TABLE();
537: a2 := JTF_NUMBER_TABLE();
538: a3 := JTF_VARCHAR2_TABLE_100();
539: a4 := JTF_VARCHAR2_TABLE_200();
540: a5 := JTF_VARCHAR2_TABLE_2000();
541: a6 := JTF_NUMBER_TABLE();
537: a2 := JTF_NUMBER_TABLE();
538: a3 := JTF_VARCHAR2_TABLE_100();
539: a4 := JTF_VARCHAR2_TABLE_200();
540: a5 := JTF_VARCHAR2_TABLE_2000();
541: a6 := JTF_NUMBER_TABLE();
542: a7 := JTF_VARCHAR2_TABLE_2000();
543: a8 := JTF_DATE_TABLE();
544: a9 := JTF_VARCHAR2_TABLE_100();
545: a10 := JTF_VARCHAR2_TABLE_500();
556: a21 := JTF_VARCHAR2_TABLE_500();
557: a22 := JTF_VARCHAR2_TABLE_500();
558: a23 := JTF_VARCHAR2_TABLE_500();
559: a24 := JTF_VARCHAR2_TABLE_500();
560: a25 := JTF_NUMBER_TABLE();
561: a26 := JTF_DATE_TABLE();
562: a27 := JTF_NUMBER_TABLE();
563: a28 := JTF_DATE_TABLE();
564: a29 := JTF_NUMBER_TABLE();
558: a23 := JTF_VARCHAR2_TABLE_500();
559: a24 := JTF_VARCHAR2_TABLE_500();
560: a25 := JTF_NUMBER_TABLE();
561: a26 := JTF_DATE_TABLE();
562: a27 := JTF_NUMBER_TABLE();
563: a28 := JTF_DATE_TABLE();
564: a29 := JTF_NUMBER_TABLE();
565: a30 := JTF_DATE_TABLE();
566: a31 := JTF_VARCHAR2_TABLE_300();
560: a25 := JTF_NUMBER_TABLE();
561: a26 := JTF_DATE_TABLE();
562: a27 := JTF_NUMBER_TABLE();
563: a28 := JTF_DATE_TABLE();
564: a29 := JTF_NUMBER_TABLE();
565: a30 := JTF_DATE_TABLE();
566: a31 := JTF_VARCHAR2_TABLE_300();
567: a32 := JTF_VARCHAR2_TABLE_300();
568: if t.count > 0 then
820: , p_init_msg_list VARCHAR2
821: , x_return_status out nocopy VARCHAR2
822: , x_msg_count out nocopy NUMBER
823: , x_msg_data out nocopy VARCHAR2
824: , p5_a0 JTF_NUMBER_TABLE
825: , p5_a1 JTF_NUMBER_TABLE
826: , p5_a2 JTF_NUMBER_TABLE
827: , p5_a3 JTF_VARCHAR2_TABLE_100
828: , p5_a4 JTF_VARCHAR2_TABLE_200
821: , x_return_status out nocopy VARCHAR2
822: , x_msg_count out nocopy NUMBER
823: , x_msg_data out nocopy VARCHAR2
824: , p5_a0 JTF_NUMBER_TABLE
825: , p5_a1 JTF_NUMBER_TABLE
826: , p5_a2 JTF_NUMBER_TABLE
827: , p5_a3 JTF_VARCHAR2_TABLE_100
828: , p5_a4 JTF_VARCHAR2_TABLE_200
829: , p5_a5 JTF_VARCHAR2_TABLE_2000
822: , x_msg_count out nocopy NUMBER
823: , x_msg_data out nocopy VARCHAR2
824: , p5_a0 JTF_NUMBER_TABLE
825: , p5_a1 JTF_NUMBER_TABLE
826: , p5_a2 JTF_NUMBER_TABLE
827: , p5_a3 JTF_VARCHAR2_TABLE_100
828: , p5_a4 JTF_VARCHAR2_TABLE_200
829: , p5_a5 JTF_VARCHAR2_TABLE_2000
830: , p5_a6 JTF_NUMBER_TABLE
826: , p5_a2 JTF_NUMBER_TABLE
827: , p5_a3 JTF_VARCHAR2_TABLE_100
828: , p5_a4 JTF_VARCHAR2_TABLE_200
829: , p5_a5 JTF_VARCHAR2_TABLE_2000
830: , p5_a6 JTF_NUMBER_TABLE
831: , p5_a7 JTF_VARCHAR2_TABLE_2000
832: , p5_a8 JTF_DATE_TABLE
833: , p5_a9 JTF_VARCHAR2_TABLE_100
834: , p5_a10 JTF_VARCHAR2_TABLE_500
845: , p5_a21 JTF_VARCHAR2_TABLE_500
846: , p5_a22 JTF_VARCHAR2_TABLE_500
847: , p5_a23 JTF_VARCHAR2_TABLE_500
848: , p5_a24 JTF_VARCHAR2_TABLE_500
849: , p5_a25 JTF_NUMBER_TABLE
850: , p5_a26 JTF_DATE_TABLE
851: , p5_a27 JTF_NUMBER_TABLE
852: , p5_a28 JTF_DATE_TABLE
853: , p5_a29 JTF_NUMBER_TABLE
847: , p5_a23 JTF_VARCHAR2_TABLE_500
848: , p5_a24 JTF_VARCHAR2_TABLE_500
849: , p5_a25 JTF_NUMBER_TABLE
850: , p5_a26 JTF_DATE_TABLE
851: , p5_a27 JTF_NUMBER_TABLE
852: , p5_a28 JTF_DATE_TABLE
853: , p5_a29 JTF_NUMBER_TABLE
854: , p5_a30 JTF_DATE_TABLE
855: , p5_a31 JTF_VARCHAR2_TABLE_300
849: , p5_a25 JTF_NUMBER_TABLE
850: , p5_a26 JTF_DATE_TABLE
851: , p5_a27 JTF_NUMBER_TABLE
852: , p5_a28 JTF_DATE_TABLE
853: , p5_a29 JTF_NUMBER_TABLE
854: , p5_a30 JTF_DATE_TABLE
855: , p5_a31 JTF_VARCHAR2_TABLE_300
856: , p5_a32 JTF_VARCHAR2_TABLE_300
857: , p6_a0 out nocopy JTF_NUMBER_TABLE
853: , p5_a29 JTF_NUMBER_TABLE
854: , p5_a30 JTF_DATE_TABLE
855: , p5_a31 JTF_VARCHAR2_TABLE_300
856: , p5_a32 JTF_VARCHAR2_TABLE_300
857: , p6_a0 out nocopy JTF_NUMBER_TABLE
858: , p6_a1 out nocopy JTF_NUMBER_TABLE
859: , p6_a2 out nocopy JTF_NUMBER_TABLE
860: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
854: , p5_a30 JTF_DATE_TABLE
855: , p5_a31 JTF_VARCHAR2_TABLE_300
856: , p5_a32 JTF_VARCHAR2_TABLE_300
857: , p6_a0 out nocopy JTF_NUMBER_TABLE
858: , p6_a1 out nocopy JTF_NUMBER_TABLE
859: , p6_a2 out nocopy JTF_NUMBER_TABLE
860: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
862: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
855: , p5_a31 JTF_VARCHAR2_TABLE_300
856: , p5_a32 JTF_VARCHAR2_TABLE_300
857: , p6_a0 out nocopy JTF_NUMBER_TABLE
858: , p6_a1 out nocopy JTF_NUMBER_TABLE
859: , p6_a2 out nocopy JTF_NUMBER_TABLE
860: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
862: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p6_a6 out nocopy JTF_NUMBER_TABLE
859: , p6_a2 out nocopy JTF_NUMBER_TABLE
860: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
862: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p6_a6 out nocopy JTF_NUMBER_TABLE
864: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
865: , p6_a8 out nocopy JTF_DATE_TABLE
866: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
878: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
879: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
880: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
881: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
882: , p6_a25 out nocopy JTF_NUMBER_TABLE
883: , p6_a26 out nocopy JTF_DATE_TABLE
884: , p6_a27 out nocopy JTF_NUMBER_TABLE
885: , p6_a28 out nocopy JTF_DATE_TABLE
886: , p6_a29 out nocopy JTF_NUMBER_TABLE
880: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
881: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
882: , p6_a25 out nocopy JTF_NUMBER_TABLE
883: , p6_a26 out nocopy JTF_DATE_TABLE
884: , p6_a27 out nocopy JTF_NUMBER_TABLE
885: , p6_a28 out nocopy JTF_DATE_TABLE
886: , p6_a29 out nocopy JTF_NUMBER_TABLE
887: , p6_a30 out nocopy JTF_DATE_TABLE
888: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
882: , p6_a25 out nocopy JTF_NUMBER_TABLE
883: , p6_a26 out nocopy JTF_DATE_TABLE
884: , p6_a27 out nocopy JTF_NUMBER_TABLE
885: , p6_a28 out nocopy JTF_DATE_TABLE
886: , p6_a29 out nocopy JTF_NUMBER_TABLE
887: , p6_a30 out nocopy JTF_DATE_TABLE
888: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
889: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
890: )
1094: , p_init_msg_list VARCHAR2
1095: , x_return_status out nocopy VARCHAR2
1096: , x_msg_count out nocopy NUMBER
1097: , x_msg_data out nocopy VARCHAR2
1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_NUMBER_TABLE
1100: , p5_a2 JTF_NUMBER_TABLE
1101: , p5_a3 JTF_VARCHAR2_TABLE_100
1102: , p5_a4 JTF_VARCHAR2_TABLE_200
1095: , x_return_status out nocopy VARCHAR2
1096: , x_msg_count out nocopy NUMBER
1097: , x_msg_data out nocopy VARCHAR2
1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_NUMBER_TABLE
1100: , p5_a2 JTF_NUMBER_TABLE
1101: , p5_a3 JTF_VARCHAR2_TABLE_100
1102: , p5_a4 JTF_VARCHAR2_TABLE_200
1103: , p5_a5 JTF_VARCHAR2_TABLE_2000
1096: , x_msg_count out nocopy NUMBER
1097: , x_msg_data out nocopy VARCHAR2
1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_NUMBER_TABLE
1100: , p5_a2 JTF_NUMBER_TABLE
1101: , p5_a3 JTF_VARCHAR2_TABLE_100
1102: , p5_a4 JTF_VARCHAR2_TABLE_200
1103: , p5_a5 JTF_VARCHAR2_TABLE_2000
1104: , p5_a6 JTF_NUMBER_TABLE
1100: , p5_a2 JTF_NUMBER_TABLE
1101: , p5_a3 JTF_VARCHAR2_TABLE_100
1102: , p5_a4 JTF_VARCHAR2_TABLE_200
1103: , p5_a5 JTF_VARCHAR2_TABLE_2000
1104: , p5_a6 JTF_NUMBER_TABLE
1105: , p5_a7 JTF_VARCHAR2_TABLE_2000
1106: , p5_a8 JTF_DATE_TABLE
1107: , p5_a9 JTF_VARCHAR2_TABLE_100
1108: , p5_a10 JTF_VARCHAR2_TABLE_500
1119: , p5_a21 JTF_VARCHAR2_TABLE_500
1120: , p5_a22 JTF_VARCHAR2_TABLE_500
1121: , p5_a23 JTF_VARCHAR2_TABLE_500
1122: , p5_a24 JTF_VARCHAR2_TABLE_500
1123: , p5_a25 JTF_NUMBER_TABLE
1124: , p5_a26 JTF_DATE_TABLE
1125: , p5_a27 JTF_NUMBER_TABLE
1126: , p5_a28 JTF_DATE_TABLE
1127: , p5_a29 JTF_NUMBER_TABLE
1121: , p5_a23 JTF_VARCHAR2_TABLE_500
1122: , p5_a24 JTF_VARCHAR2_TABLE_500
1123: , p5_a25 JTF_NUMBER_TABLE
1124: , p5_a26 JTF_DATE_TABLE
1125: , p5_a27 JTF_NUMBER_TABLE
1126: , p5_a28 JTF_DATE_TABLE
1127: , p5_a29 JTF_NUMBER_TABLE
1128: , p5_a30 JTF_DATE_TABLE
1129: , p5_a31 JTF_VARCHAR2_TABLE_300
1123: , p5_a25 JTF_NUMBER_TABLE
1124: , p5_a26 JTF_DATE_TABLE
1125: , p5_a27 JTF_NUMBER_TABLE
1126: , p5_a28 JTF_DATE_TABLE
1127: , p5_a29 JTF_NUMBER_TABLE
1128: , p5_a30 JTF_DATE_TABLE
1129: , p5_a31 JTF_VARCHAR2_TABLE_300
1130: , p5_a32 JTF_VARCHAR2_TABLE_300
1131: )
1367: , p_init_msg_list VARCHAR2
1368: , x_return_status out nocopy VARCHAR2
1369: , x_msg_count out nocopy NUMBER
1370: , x_msg_data out nocopy VARCHAR2
1371: , p5_a0 JTF_NUMBER_TABLE
1372: , p5_a1 JTF_NUMBER_TABLE
1373: , p5_a2 JTF_NUMBER_TABLE
1374: , p5_a3 JTF_VARCHAR2_TABLE_100
1375: , p5_a4 JTF_VARCHAR2_TABLE_200
1368: , x_return_status out nocopy VARCHAR2
1369: , x_msg_count out nocopy NUMBER
1370: , x_msg_data out nocopy VARCHAR2
1371: , p5_a0 JTF_NUMBER_TABLE
1372: , p5_a1 JTF_NUMBER_TABLE
1373: , p5_a2 JTF_NUMBER_TABLE
1374: , p5_a3 JTF_VARCHAR2_TABLE_100
1375: , p5_a4 JTF_VARCHAR2_TABLE_200
1376: , p5_a5 JTF_VARCHAR2_TABLE_2000
1369: , x_msg_count out nocopy NUMBER
1370: , x_msg_data out nocopy VARCHAR2
1371: , p5_a0 JTF_NUMBER_TABLE
1372: , p5_a1 JTF_NUMBER_TABLE
1373: , p5_a2 JTF_NUMBER_TABLE
1374: , p5_a3 JTF_VARCHAR2_TABLE_100
1375: , p5_a4 JTF_VARCHAR2_TABLE_200
1376: , p5_a5 JTF_VARCHAR2_TABLE_2000
1377: , p5_a6 JTF_NUMBER_TABLE
1373: , p5_a2 JTF_NUMBER_TABLE
1374: , p5_a3 JTF_VARCHAR2_TABLE_100
1375: , p5_a4 JTF_VARCHAR2_TABLE_200
1376: , p5_a5 JTF_VARCHAR2_TABLE_2000
1377: , p5_a6 JTF_NUMBER_TABLE
1378: , p5_a7 JTF_VARCHAR2_TABLE_2000
1379: , p5_a8 JTF_DATE_TABLE
1380: , p5_a9 JTF_VARCHAR2_TABLE_100
1381: , p5_a10 JTF_VARCHAR2_TABLE_500
1392: , p5_a21 JTF_VARCHAR2_TABLE_500
1393: , p5_a22 JTF_VARCHAR2_TABLE_500
1394: , p5_a23 JTF_VARCHAR2_TABLE_500
1395: , p5_a24 JTF_VARCHAR2_TABLE_500
1396: , p5_a25 JTF_NUMBER_TABLE
1397: , p5_a26 JTF_DATE_TABLE
1398: , p5_a27 JTF_NUMBER_TABLE
1399: , p5_a28 JTF_DATE_TABLE
1400: , p5_a29 JTF_NUMBER_TABLE
1394: , p5_a23 JTF_VARCHAR2_TABLE_500
1395: , p5_a24 JTF_VARCHAR2_TABLE_500
1396: , p5_a25 JTF_NUMBER_TABLE
1397: , p5_a26 JTF_DATE_TABLE
1398: , p5_a27 JTF_NUMBER_TABLE
1399: , p5_a28 JTF_DATE_TABLE
1400: , p5_a29 JTF_NUMBER_TABLE
1401: , p5_a30 JTF_DATE_TABLE
1402: , p5_a31 JTF_VARCHAR2_TABLE_300
1396: , p5_a25 JTF_NUMBER_TABLE
1397: , p5_a26 JTF_DATE_TABLE
1398: , p5_a27 JTF_NUMBER_TABLE
1399: , p5_a28 JTF_DATE_TABLE
1400: , p5_a29 JTF_NUMBER_TABLE
1401: , p5_a30 JTF_DATE_TABLE
1402: , p5_a31 JTF_VARCHAR2_TABLE_300
1403: , p5_a32 JTF_VARCHAR2_TABLE_300
1404: , p6_a0 out nocopy JTF_NUMBER_TABLE
1400: , p5_a29 JTF_NUMBER_TABLE
1401: , p5_a30 JTF_DATE_TABLE
1402: , p5_a31 JTF_VARCHAR2_TABLE_300
1403: , p5_a32 JTF_VARCHAR2_TABLE_300
1404: , p6_a0 out nocopy JTF_NUMBER_TABLE
1405: , p6_a1 out nocopy JTF_NUMBER_TABLE
1406: , p6_a2 out nocopy JTF_NUMBER_TABLE
1407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1401: , p5_a30 JTF_DATE_TABLE
1402: , p5_a31 JTF_VARCHAR2_TABLE_300
1403: , p5_a32 JTF_VARCHAR2_TABLE_300
1404: , p6_a0 out nocopy JTF_NUMBER_TABLE
1405: , p6_a1 out nocopy JTF_NUMBER_TABLE
1406: , p6_a2 out nocopy JTF_NUMBER_TABLE
1407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1409: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1402: , p5_a31 JTF_VARCHAR2_TABLE_300
1403: , p5_a32 JTF_VARCHAR2_TABLE_300
1404: , p6_a0 out nocopy JTF_NUMBER_TABLE
1405: , p6_a1 out nocopy JTF_NUMBER_TABLE
1406: , p6_a2 out nocopy JTF_NUMBER_TABLE
1407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1409: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1410: , p6_a6 out nocopy JTF_NUMBER_TABLE
1406: , p6_a2 out nocopy JTF_NUMBER_TABLE
1407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1409: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1410: , p6_a6 out nocopy JTF_NUMBER_TABLE
1411: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1412: , p6_a8 out nocopy JTF_DATE_TABLE
1413: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1414: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1425: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1426: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1427: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1428: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1429: , p6_a25 out nocopy JTF_NUMBER_TABLE
1430: , p6_a26 out nocopy JTF_DATE_TABLE
1431: , p6_a27 out nocopy JTF_NUMBER_TABLE
1432: , p6_a28 out nocopy JTF_DATE_TABLE
1433: , p6_a29 out nocopy JTF_NUMBER_TABLE
1427: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1428: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1429: , p6_a25 out nocopy JTF_NUMBER_TABLE
1430: , p6_a26 out nocopy JTF_DATE_TABLE
1431: , p6_a27 out nocopy JTF_NUMBER_TABLE
1432: , p6_a28 out nocopy JTF_DATE_TABLE
1433: , p6_a29 out nocopy JTF_NUMBER_TABLE
1434: , p6_a30 out nocopy JTF_DATE_TABLE
1435: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
1429: , p6_a25 out nocopy JTF_NUMBER_TABLE
1430: , p6_a26 out nocopy JTF_DATE_TABLE
1431: , p6_a27 out nocopy JTF_NUMBER_TABLE
1432: , p6_a28 out nocopy JTF_DATE_TABLE
1433: , p6_a29 out nocopy JTF_NUMBER_TABLE
1434: , p6_a30 out nocopy JTF_DATE_TABLE
1435: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
1436: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1437: )
1641: , p_init_msg_list VARCHAR2
1642: , x_return_status out nocopy VARCHAR2
1643: , x_msg_count out nocopy NUMBER
1644: , x_msg_data out nocopy VARCHAR2
1645: , p5_a0 JTF_NUMBER_TABLE
1646: , p5_a1 JTF_NUMBER_TABLE
1647: , p5_a2 JTF_NUMBER_TABLE
1648: , p5_a3 JTF_VARCHAR2_TABLE_100
1649: , p5_a4 JTF_VARCHAR2_TABLE_200
1642: , x_return_status out nocopy VARCHAR2
1643: , x_msg_count out nocopy NUMBER
1644: , x_msg_data out nocopy VARCHAR2
1645: , p5_a0 JTF_NUMBER_TABLE
1646: , p5_a1 JTF_NUMBER_TABLE
1647: , p5_a2 JTF_NUMBER_TABLE
1648: , p5_a3 JTF_VARCHAR2_TABLE_100
1649: , p5_a4 JTF_VARCHAR2_TABLE_200
1650: , p5_a5 JTF_VARCHAR2_TABLE_2000
1643: , x_msg_count out nocopy NUMBER
1644: , x_msg_data out nocopy VARCHAR2
1645: , p5_a0 JTF_NUMBER_TABLE
1646: , p5_a1 JTF_NUMBER_TABLE
1647: , p5_a2 JTF_NUMBER_TABLE
1648: , p5_a3 JTF_VARCHAR2_TABLE_100
1649: , p5_a4 JTF_VARCHAR2_TABLE_200
1650: , p5_a5 JTF_VARCHAR2_TABLE_2000
1651: , p5_a6 JTF_NUMBER_TABLE
1647: , p5_a2 JTF_NUMBER_TABLE
1648: , p5_a3 JTF_VARCHAR2_TABLE_100
1649: , p5_a4 JTF_VARCHAR2_TABLE_200
1650: , p5_a5 JTF_VARCHAR2_TABLE_2000
1651: , p5_a6 JTF_NUMBER_TABLE
1652: , p5_a7 JTF_VARCHAR2_TABLE_2000
1653: , p5_a8 JTF_DATE_TABLE
1654: , p5_a9 JTF_VARCHAR2_TABLE_100
1655: , p5_a10 JTF_VARCHAR2_TABLE_500
1666: , p5_a21 JTF_VARCHAR2_TABLE_500
1667: , p5_a22 JTF_VARCHAR2_TABLE_500
1668: , p5_a23 JTF_VARCHAR2_TABLE_500
1669: , p5_a24 JTF_VARCHAR2_TABLE_500
1670: , p5_a25 JTF_NUMBER_TABLE
1671: , p5_a26 JTF_DATE_TABLE
1672: , p5_a27 JTF_NUMBER_TABLE
1673: , p5_a28 JTF_DATE_TABLE
1674: , p5_a29 JTF_NUMBER_TABLE
1668: , p5_a23 JTF_VARCHAR2_TABLE_500
1669: , p5_a24 JTF_VARCHAR2_TABLE_500
1670: , p5_a25 JTF_NUMBER_TABLE
1671: , p5_a26 JTF_DATE_TABLE
1672: , p5_a27 JTF_NUMBER_TABLE
1673: , p5_a28 JTF_DATE_TABLE
1674: , p5_a29 JTF_NUMBER_TABLE
1675: , p5_a30 JTF_DATE_TABLE
1676: , p5_a31 JTF_VARCHAR2_TABLE_300
1670: , p5_a25 JTF_NUMBER_TABLE
1671: , p5_a26 JTF_DATE_TABLE
1672: , p5_a27 JTF_NUMBER_TABLE
1673: , p5_a28 JTF_DATE_TABLE
1674: , p5_a29 JTF_NUMBER_TABLE
1675: , p5_a30 JTF_DATE_TABLE
1676: , p5_a31 JTF_VARCHAR2_TABLE_300
1677: , p5_a32 JTF_VARCHAR2_TABLE_300
1678: )
1844: , p_init_msg_list VARCHAR2
1845: , x_return_status out nocopy VARCHAR2
1846: , x_msg_count out nocopy NUMBER
1847: , x_msg_data out nocopy VARCHAR2
1848: , p5_a0 JTF_NUMBER_TABLE
1849: , p5_a1 JTF_NUMBER_TABLE
1850: , p5_a2 JTF_NUMBER_TABLE
1851: , p5_a3 JTF_VARCHAR2_TABLE_100
1852: , p5_a4 JTF_VARCHAR2_TABLE_200
1845: , x_return_status out nocopy VARCHAR2
1846: , x_msg_count out nocopy NUMBER
1847: , x_msg_data out nocopy VARCHAR2
1848: , p5_a0 JTF_NUMBER_TABLE
1849: , p5_a1 JTF_NUMBER_TABLE
1850: , p5_a2 JTF_NUMBER_TABLE
1851: , p5_a3 JTF_VARCHAR2_TABLE_100
1852: , p5_a4 JTF_VARCHAR2_TABLE_200
1853: , p5_a5 JTF_VARCHAR2_TABLE_2000
1846: , x_msg_count out nocopy NUMBER
1847: , x_msg_data out nocopy VARCHAR2
1848: , p5_a0 JTF_NUMBER_TABLE
1849: , p5_a1 JTF_NUMBER_TABLE
1850: , p5_a2 JTF_NUMBER_TABLE
1851: , p5_a3 JTF_VARCHAR2_TABLE_100
1852: , p5_a4 JTF_VARCHAR2_TABLE_200
1853: , p5_a5 JTF_VARCHAR2_TABLE_2000
1854: , p5_a6 JTF_NUMBER_TABLE
1850: , p5_a2 JTF_NUMBER_TABLE
1851: , p5_a3 JTF_VARCHAR2_TABLE_100
1852: , p5_a4 JTF_VARCHAR2_TABLE_200
1853: , p5_a5 JTF_VARCHAR2_TABLE_2000
1854: , p5_a6 JTF_NUMBER_TABLE
1855: , p5_a7 JTF_VARCHAR2_TABLE_2000
1856: , p5_a8 JTF_DATE_TABLE
1857: , p5_a9 JTF_VARCHAR2_TABLE_100
1858: , p5_a10 JTF_VARCHAR2_TABLE_500
1869: , p5_a21 JTF_VARCHAR2_TABLE_500
1870: , p5_a22 JTF_VARCHAR2_TABLE_500
1871: , p5_a23 JTF_VARCHAR2_TABLE_500
1872: , p5_a24 JTF_VARCHAR2_TABLE_500
1873: , p5_a25 JTF_NUMBER_TABLE
1874: , p5_a26 JTF_DATE_TABLE
1875: , p5_a27 JTF_NUMBER_TABLE
1876: , p5_a28 JTF_DATE_TABLE
1877: , p5_a29 JTF_NUMBER_TABLE
1871: , p5_a23 JTF_VARCHAR2_TABLE_500
1872: , p5_a24 JTF_VARCHAR2_TABLE_500
1873: , p5_a25 JTF_NUMBER_TABLE
1874: , p5_a26 JTF_DATE_TABLE
1875: , p5_a27 JTF_NUMBER_TABLE
1876: , p5_a28 JTF_DATE_TABLE
1877: , p5_a29 JTF_NUMBER_TABLE
1878: , p5_a30 JTF_DATE_TABLE
1879: , p5_a31 JTF_VARCHAR2_TABLE_300
1873: , p5_a25 JTF_NUMBER_TABLE
1874: , p5_a26 JTF_DATE_TABLE
1875: , p5_a27 JTF_NUMBER_TABLE
1876: , p5_a28 JTF_DATE_TABLE
1877: , p5_a29 JTF_NUMBER_TABLE
1878: , p5_a30 JTF_DATE_TABLE
1879: , p5_a31 JTF_VARCHAR2_TABLE_300
1880: , p5_a32 JTF_VARCHAR2_TABLE_300
1881: )