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_ptm_pvt.ptm_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
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_ptm_pvt.ptm_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_DATE_TABLE
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptm_pvt.ptm_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_500
34: , a9 JTF_VARCHAR2_TABLE_500
35: , a10 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_VARCHAR2_TABLE_500
46: , a21 JTF_VARCHAR2_TABLE_500
47: , a22 JTF_VARCHAR2_TABLE_500
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_DATE_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_DATE_TABLE
52: , a27 JTF_NUMBER_TABLE
46: , a21 JTF_VARCHAR2_TABLE_500
47: , a22 JTF_VARCHAR2_TABLE_500
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_DATE_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_DATE_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_DATE_TABLE
50: , a25 JTF_NUMBER_TABLE
51: , a26 JTF_DATE_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_100
54: , a29 JTF_VARCHAR2_TABLE_100
55: ) as
56: ddindx binary_integer; indx binary_integer;
98: end loop;
99: end if;
100: end if;
101: end rosetta_table_copy_in_p2;
102: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_DATE_TABLE
99: end if;
100: end if;
101: end rosetta_table_copy_in_p2;
102: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_DATE_TABLE
107: , a5 out nocopy JTF_DATE_TABLE
101: end rosetta_table_copy_in_p2;
102: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_DATE_TABLE
107: , a5 out nocopy JTF_DATE_TABLE
108: , a6 out nocopy JTF_NUMBER_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_DATE_TABLE
107: , a5 out nocopy JTF_DATE_TABLE
108: , a6 out nocopy JTF_NUMBER_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_500
111: , a9 out nocopy JTF_VARCHAR2_TABLE_500
112: , a10 out nocopy JTF_VARCHAR2_TABLE_500
121: , a19 out nocopy JTF_VARCHAR2_TABLE_500
122: , a20 out nocopy JTF_VARCHAR2_TABLE_500
123: , a21 out nocopy JTF_VARCHAR2_TABLE_500
124: , a22 out nocopy JTF_VARCHAR2_TABLE_500
125: , a23 out nocopy JTF_NUMBER_TABLE
126: , a24 out nocopy JTF_DATE_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_DATE_TABLE
129: , a27 out nocopy JTF_NUMBER_TABLE
123: , a21 out nocopy JTF_VARCHAR2_TABLE_500
124: , a22 out nocopy JTF_VARCHAR2_TABLE_500
125: , a23 out nocopy JTF_NUMBER_TABLE
126: , a24 out nocopy JTF_DATE_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_DATE_TABLE
129: , a27 out nocopy JTF_NUMBER_TABLE
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
125: , a23 out nocopy JTF_NUMBER_TABLE
126: , a24 out nocopy JTF_DATE_TABLE
127: , a25 out nocopy JTF_NUMBER_TABLE
128: , a26 out nocopy JTF_DATE_TABLE
129: , a27 out nocopy JTF_NUMBER_TABLE
130: , a28 out nocopy JTF_VARCHAR2_TABLE_100
131: , a29 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_DATE_TABLE();
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_DATE_TABLE();
141: a5 := JTF_DATE_TABLE();
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_DATE_TABLE();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_DATE_TABLE();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
144: a8 := JTF_VARCHAR2_TABLE_500();
145: a9 := JTF_VARCHAR2_TABLE_500();
146: a10 := JTF_VARCHAR2_TABLE_500();
155: a19 := JTF_VARCHAR2_TABLE_500();
156: a20 := JTF_VARCHAR2_TABLE_500();
157: a21 := JTF_VARCHAR2_TABLE_500();
158: a22 := JTF_VARCHAR2_TABLE_500();
159: a23 := JTF_NUMBER_TABLE();
160: a24 := JTF_DATE_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
157: a21 := JTF_VARCHAR2_TABLE_500();
158: a22 := JTF_VARCHAR2_TABLE_500();
159: a23 := JTF_NUMBER_TABLE();
160: a24 := JTF_DATE_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_100();
159: a23 := JTF_NUMBER_TABLE();
160: a24 := JTF_DATE_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_DATE_TABLE();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_DATE_TABLE();
172: a5 := JTF_DATE_TABLE();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_DATE_TABLE();
172: a5 := JTF_DATE_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_DATE_TABLE();
172: a5 := JTF_DATE_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_500();
176: a9 := JTF_VARCHAR2_TABLE_500();
177: a10 := JTF_VARCHAR2_TABLE_500();
186: a19 := JTF_VARCHAR2_TABLE_500();
187: a20 := JTF_VARCHAR2_TABLE_500();
188: a21 := JTF_VARCHAR2_TABLE_500();
189: a22 := JTF_VARCHAR2_TABLE_500();
190: a23 := JTF_NUMBER_TABLE();
191: a24 := JTF_DATE_TABLE();
192: a25 := JTF_NUMBER_TABLE();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
188: a21 := JTF_VARCHAR2_TABLE_500();
189: a22 := JTF_VARCHAR2_TABLE_500();
190: a23 := JTF_NUMBER_TABLE();
191: a24 := JTF_DATE_TABLE();
192: a25 := JTF_NUMBER_TABLE();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_VARCHAR2_TABLE_100();
196: a29 := JTF_VARCHAR2_TABLE_100();
190: a23 := JTF_NUMBER_TABLE();
191: a24 := JTF_DATE_TABLE();
192: a25 := JTF_NUMBER_TABLE();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_VARCHAR2_TABLE_100();
196: a29 := JTF_VARCHAR2_TABLE_100();
197: if t.count > 0 then
198: a0.extend(t.count);
267: end if;
268: end if;
269: end rosetta_table_copy_out_p2;
270:
271: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
272: , a1 JTF_VARCHAR2_TABLE_100
273: , a2 JTF_VARCHAR2_TABLE_100
274: , a3 JTF_VARCHAR2_TABLE_100
275: , a4 JTF_VARCHAR2_TABLE_100
272: , a1 JTF_VARCHAR2_TABLE_100
273: , a2 JTF_VARCHAR2_TABLE_100
274: , a3 JTF_VARCHAR2_TABLE_100
275: , a4 JTF_VARCHAR2_TABLE_100
276: , a5 JTF_NUMBER_TABLE
277: , a6 JTF_DATE_TABLE
278: , a7 JTF_NUMBER_TABLE
279: , a8 JTF_DATE_TABLE
280: , a9 JTF_NUMBER_TABLE
274: , a3 JTF_VARCHAR2_TABLE_100
275: , a4 JTF_VARCHAR2_TABLE_100
276: , a5 JTF_NUMBER_TABLE
277: , a6 JTF_DATE_TABLE
278: , a7 JTF_NUMBER_TABLE
279: , a8 JTF_DATE_TABLE
280: , a9 JTF_NUMBER_TABLE
281: ) as
282: ddindx binary_integer; indx binary_integer;
276: , a5 JTF_NUMBER_TABLE
277: , a6 JTF_DATE_TABLE
278: , a7 JTF_NUMBER_TABLE
279: , a8 JTF_DATE_TABLE
280: , a9 JTF_NUMBER_TABLE
281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin
284: if a0 is not null and a0.count > 0 then
304: end loop;
305: end if;
306: end if;
307: end rosetta_table_copy_in_p5;
308: procedure rosetta_table_copy_out_p5(t okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_VARCHAR2_TABLE_100
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_DATE_TABLE
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_DATE_TABLE
317: , a9 out nocopy JTF_NUMBER_TABLE
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_DATE_TABLE
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_DATE_TABLE
317: , a9 out nocopy JTF_NUMBER_TABLE
318: ) as
319: ddindx binary_integer; indx binary_integer;
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_DATE_TABLE
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_DATE_TABLE
317: , a9 out nocopy JTF_NUMBER_TABLE
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin
321: if t is null or t.count = 0 then
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin
321: if t is null or t.count = 0 then
322: a0 := JTF_NUMBER_TABLE();
323: a1 := JTF_VARCHAR2_TABLE_100();
324: a2 := JTF_VARCHAR2_TABLE_100();
325: a3 := JTF_VARCHAR2_TABLE_100();
326: a4 := JTF_VARCHAR2_TABLE_100();
323: a1 := JTF_VARCHAR2_TABLE_100();
324: a2 := JTF_VARCHAR2_TABLE_100();
325: a3 := JTF_VARCHAR2_TABLE_100();
326: a4 := JTF_VARCHAR2_TABLE_100();
327: a5 := JTF_NUMBER_TABLE();
328: a6 := JTF_DATE_TABLE();
329: a7 := JTF_NUMBER_TABLE();
330: a8 := JTF_DATE_TABLE();
331: a9 := JTF_NUMBER_TABLE();
325: a3 := JTF_VARCHAR2_TABLE_100();
326: a4 := JTF_VARCHAR2_TABLE_100();
327: a5 := JTF_NUMBER_TABLE();
328: a6 := JTF_DATE_TABLE();
329: a7 := JTF_NUMBER_TABLE();
330: a8 := JTF_DATE_TABLE();
331: a9 := JTF_NUMBER_TABLE();
332: else
333: a0 := JTF_NUMBER_TABLE();
327: a5 := JTF_NUMBER_TABLE();
328: a6 := JTF_DATE_TABLE();
329: a7 := JTF_NUMBER_TABLE();
330: a8 := JTF_DATE_TABLE();
331: a9 := JTF_NUMBER_TABLE();
332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
329: a7 := JTF_NUMBER_TABLE();
330: a8 := JTF_DATE_TABLE();
331: a9 := JTF_NUMBER_TABLE();
332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_100();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: if t.count > 0 then
344: a0.extend(t.count);
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: if t.count > 0 then
344: a0.extend(t.count);
345: a1.extend(t.count);
346: a2.extend(t.count);
373: end if;
374: end if;
375: end rosetta_table_copy_out_p5;
376:
377: procedure rosetta_table_copy_in_p8(t out nocopy okl_ptm_pvt.ptmv_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_VARCHAR2_TABLE_100
380: , a3 JTF_NUMBER_TABLE
381: , a4 JTF_VARCHAR2_TABLE_100
374: end if;
375: end rosetta_table_copy_out_p5;
376:
377: procedure rosetta_table_copy_in_p8(t out nocopy okl_ptm_pvt.ptmv_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_VARCHAR2_TABLE_100
380: , a3 JTF_NUMBER_TABLE
381: , a4 JTF_VARCHAR2_TABLE_100
382: , a5 JTF_VARCHAR2_TABLE_100
376:
377: procedure rosetta_table_copy_in_p8(t out nocopy okl_ptm_pvt.ptmv_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_VARCHAR2_TABLE_100
380: , a3 JTF_NUMBER_TABLE
381: , a4 JTF_VARCHAR2_TABLE_100
382: , a5 JTF_VARCHAR2_TABLE_100
383: , a6 JTF_DATE_TABLE
384: , a7 JTF_DATE_TABLE
381: , a4 JTF_VARCHAR2_TABLE_100
382: , a5 JTF_VARCHAR2_TABLE_100
383: , a6 JTF_DATE_TABLE
384: , a7 JTF_DATE_TABLE
385: , a8 JTF_NUMBER_TABLE
386: , a9 JTF_VARCHAR2_TABLE_100
387: , a10 JTF_VARCHAR2_TABLE_500
388: , a11 JTF_VARCHAR2_TABLE_500
389: , a12 JTF_VARCHAR2_TABLE_500
398: , a21 JTF_VARCHAR2_TABLE_500
399: , a22 JTF_VARCHAR2_TABLE_500
400: , a23 JTF_VARCHAR2_TABLE_500
401: , a24 JTF_VARCHAR2_TABLE_500
402: , a25 JTF_NUMBER_TABLE
403: , a26 JTF_DATE_TABLE
404: , a27 JTF_NUMBER_TABLE
405: , a28 JTF_DATE_TABLE
406: , a29 JTF_NUMBER_TABLE
400: , a23 JTF_VARCHAR2_TABLE_500
401: , a24 JTF_VARCHAR2_TABLE_500
402: , a25 JTF_NUMBER_TABLE
403: , a26 JTF_DATE_TABLE
404: , a27 JTF_NUMBER_TABLE
405: , a28 JTF_DATE_TABLE
406: , a29 JTF_NUMBER_TABLE
407: , a30 JTF_VARCHAR2_TABLE_100
408: , a31 JTF_VARCHAR2_TABLE_100
402: , a25 JTF_NUMBER_TABLE
403: , a26 JTF_DATE_TABLE
404: , a27 JTF_NUMBER_TABLE
405: , a28 JTF_DATE_TABLE
406: , a29 JTF_NUMBER_TABLE
407: , a30 JTF_VARCHAR2_TABLE_100
408: , a31 JTF_VARCHAR2_TABLE_100
409: ) as
410: ddindx binary_integer; indx binary_integer;
454: end loop;
455: end if;
456: end if;
457: end rosetta_table_copy_in_p8;
458: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
459: , a1 out nocopy JTF_NUMBER_TABLE
460: , a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , a3 out nocopy JTF_NUMBER_TABLE
462: , a4 out nocopy JTF_VARCHAR2_TABLE_100
455: end if;
456: end if;
457: end rosetta_table_copy_in_p8;
458: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
459: , a1 out nocopy JTF_NUMBER_TABLE
460: , a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , a3 out nocopy JTF_NUMBER_TABLE
462: , a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , a5 out nocopy JTF_VARCHAR2_TABLE_100
457: end rosetta_table_copy_in_p8;
458: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
459: , a1 out nocopy JTF_NUMBER_TABLE
460: , a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , a3 out nocopy JTF_NUMBER_TABLE
462: , a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , a6 out nocopy JTF_DATE_TABLE
465: , a7 out nocopy JTF_DATE_TABLE
462: , a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , a6 out nocopy JTF_DATE_TABLE
465: , a7 out nocopy JTF_DATE_TABLE
466: , a8 out nocopy JTF_NUMBER_TABLE
467: , a9 out nocopy JTF_VARCHAR2_TABLE_100
468: , a10 out nocopy JTF_VARCHAR2_TABLE_500
469: , a11 out nocopy JTF_VARCHAR2_TABLE_500
470: , a12 out nocopy JTF_VARCHAR2_TABLE_500
479: , a21 out nocopy JTF_VARCHAR2_TABLE_500
480: , a22 out nocopy JTF_VARCHAR2_TABLE_500
481: , a23 out nocopy JTF_VARCHAR2_TABLE_500
482: , a24 out nocopy JTF_VARCHAR2_TABLE_500
483: , a25 out nocopy JTF_NUMBER_TABLE
484: , a26 out nocopy JTF_DATE_TABLE
485: , a27 out nocopy JTF_NUMBER_TABLE
486: , a28 out nocopy JTF_DATE_TABLE
487: , a29 out nocopy JTF_NUMBER_TABLE
481: , a23 out nocopy JTF_VARCHAR2_TABLE_500
482: , a24 out nocopy JTF_VARCHAR2_TABLE_500
483: , a25 out nocopy JTF_NUMBER_TABLE
484: , a26 out nocopy JTF_DATE_TABLE
485: , a27 out nocopy JTF_NUMBER_TABLE
486: , a28 out nocopy JTF_DATE_TABLE
487: , a29 out nocopy JTF_NUMBER_TABLE
488: , a30 out nocopy JTF_VARCHAR2_TABLE_100
489: , a31 out nocopy JTF_VARCHAR2_TABLE_100
483: , a25 out nocopy JTF_NUMBER_TABLE
484: , a26 out nocopy JTF_DATE_TABLE
485: , a27 out nocopy JTF_NUMBER_TABLE
486: , a28 out nocopy JTF_DATE_TABLE
487: , a29 out nocopy JTF_NUMBER_TABLE
488: , a30 out nocopy JTF_VARCHAR2_TABLE_100
489: , a31 out nocopy JTF_VARCHAR2_TABLE_100
490: ) as
491: ddindx binary_integer; indx binary_integer;
490: ) as
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
495: a1 := JTF_NUMBER_TABLE();
496: a2 := JTF_VARCHAR2_TABLE_100();
497: a3 := JTF_NUMBER_TABLE();
498: a4 := JTF_VARCHAR2_TABLE_100();
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
495: a1 := JTF_NUMBER_TABLE();
496: a2 := JTF_VARCHAR2_TABLE_100();
497: a3 := JTF_NUMBER_TABLE();
498: a4 := JTF_VARCHAR2_TABLE_100();
499: a5 := JTF_VARCHAR2_TABLE_100();
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();
495: a1 := JTF_NUMBER_TABLE();
496: a2 := JTF_VARCHAR2_TABLE_100();
497: a3 := JTF_NUMBER_TABLE();
498: a4 := JTF_VARCHAR2_TABLE_100();
499: a5 := JTF_VARCHAR2_TABLE_100();
500: a6 := JTF_DATE_TABLE();
501: a7 := JTF_DATE_TABLE();
498: a4 := JTF_VARCHAR2_TABLE_100();
499: a5 := JTF_VARCHAR2_TABLE_100();
500: a6 := JTF_DATE_TABLE();
501: a7 := JTF_DATE_TABLE();
502: a8 := JTF_NUMBER_TABLE();
503: a9 := JTF_VARCHAR2_TABLE_100();
504: a10 := JTF_VARCHAR2_TABLE_500();
505: a11 := JTF_VARCHAR2_TABLE_500();
506: a12 := JTF_VARCHAR2_TABLE_500();
515: a21 := JTF_VARCHAR2_TABLE_500();
516: a22 := JTF_VARCHAR2_TABLE_500();
517: a23 := JTF_VARCHAR2_TABLE_500();
518: a24 := JTF_VARCHAR2_TABLE_500();
519: a25 := JTF_NUMBER_TABLE();
520: a26 := JTF_DATE_TABLE();
521: a27 := JTF_NUMBER_TABLE();
522: a28 := JTF_DATE_TABLE();
523: a29 := JTF_NUMBER_TABLE();
517: a23 := JTF_VARCHAR2_TABLE_500();
518: a24 := JTF_VARCHAR2_TABLE_500();
519: a25 := JTF_NUMBER_TABLE();
520: a26 := JTF_DATE_TABLE();
521: a27 := JTF_NUMBER_TABLE();
522: a28 := JTF_DATE_TABLE();
523: a29 := JTF_NUMBER_TABLE();
524: a30 := JTF_VARCHAR2_TABLE_100();
525: a31 := JTF_VARCHAR2_TABLE_100();
519: a25 := JTF_NUMBER_TABLE();
520: a26 := JTF_DATE_TABLE();
521: a27 := JTF_NUMBER_TABLE();
522: a28 := JTF_DATE_TABLE();
523: a29 := JTF_NUMBER_TABLE();
524: a30 := JTF_VARCHAR2_TABLE_100();
525: a31 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
523: a29 := JTF_NUMBER_TABLE();
524: a30 := JTF_VARCHAR2_TABLE_100();
525: a31 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_NUMBER_TABLE();
529: a2 := JTF_VARCHAR2_TABLE_100();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
524: a30 := JTF_VARCHAR2_TABLE_100();
525: a31 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_NUMBER_TABLE();
529: a2 := JTF_VARCHAR2_TABLE_100();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_NUMBER_TABLE();
529: a2 := JTF_VARCHAR2_TABLE_100();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_100();
533: a6 := JTF_DATE_TABLE();
534: a7 := JTF_DATE_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_100();
533: a6 := JTF_DATE_TABLE();
534: a7 := JTF_DATE_TABLE();
535: a8 := JTF_NUMBER_TABLE();
536: a9 := JTF_VARCHAR2_TABLE_100();
537: a10 := JTF_VARCHAR2_TABLE_500();
538: a11 := JTF_VARCHAR2_TABLE_500();
539: a12 := JTF_VARCHAR2_TABLE_500();
548: a21 := JTF_VARCHAR2_TABLE_500();
549: a22 := JTF_VARCHAR2_TABLE_500();
550: a23 := JTF_VARCHAR2_TABLE_500();
551: a24 := JTF_VARCHAR2_TABLE_500();
552: a25 := JTF_NUMBER_TABLE();
553: a26 := JTF_DATE_TABLE();
554: a27 := JTF_NUMBER_TABLE();
555: a28 := JTF_DATE_TABLE();
556: a29 := JTF_NUMBER_TABLE();
550: a23 := JTF_VARCHAR2_TABLE_500();
551: a24 := JTF_VARCHAR2_TABLE_500();
552: a25 := JTF_NUMBER_TABLE();
553: a26 := JTF_DATE_TABLE();
554: a27 := JTF_NUMBER_TABLE();
555: a28 := JTF_DATE_TABLE();
556: a29 := JTF_NUMBER_TABLE();
557: a30 := JTF_VARCHAR2_TABLE_100();
558: a31 := JTF_VARCHAR2_TABLE_100();
552: a25 := JTF_NUMBER_TABLE();
553: a26 := JTF_DATE_TABLE();
554: a27 := JTF_NUMBER_TABLE();
555: a28 := JTF_DATE_TABLE();
556: a29 := JTF_NUMBER_TABLE();
557: a30 := JTF_VARCHAR2_TABLE_100();
558: a31 := JTF_VARCHAR2_TABLE_100();
559: if t.count > 0 then
560: a0.extend(t.count);
805: , p_init_msg_list VARCHAR2
806: , x_return_status out nocopy VARCHAR2
807: , x_msg_count out nocopy NUMBER
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_VARCHAR2_TABLE_100
806: , x_return_status out nocopy VARCHAR2
807: , x_msg_count out nocopy NUMBER
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_VARCHAR2_TABLE_100
814: , p5_a5 JTF_VARCHAR2_TABLE_100
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_VARCHAR2_TABLE_100
814: , p5_a5 JTF_VARCHAR2_TABLE_100
815: , p5_a6 JTF_DATE_TABLE
816: , p5_a7 JTF_DATE_TABLE
813: , p5_a4 JTF_VARCHAR2_TABLE_100
814: , p5_a5 JTF_VARCHAR2_TABLE_100
815: , p5_a6 JTF_DATE_TABLE
816: , p5_a7 JTF_DATE_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_VARCHAR2_TABLE_100
819: , p5_a10 JTF_VARCHAR2_TABLE_500
820: , p5_a11 JTF_VARCHAR2_TABLE_500
821: , p5_a12 JTF_VARCHAR2_TABLE_500
830: , p5_a21 JTF_VARCHAR2_TABLE_500
831: , p5_a22 JTF_VARCHAR2_TABLE_500
832: , p5_a23 JTF_VARCHAR2_TABLE_500
833: , p5_a24 JTF_VARCHAR2_TABLE_500
834: , p5_a25 JTF_NUMBER_TABLE
835: , p5_a26 JTF_DATE_TABLE
836: , p5_a27 JTF_NUMBER_TABLE
837: , p5_a28 JTF_DATE_TABLE
838: , p5_a29 JTF_NUMBER_TABLE
832: , p5_a23 JTF_VARCHAR2_TABLE_500
833: , p5_a24 JTF_VARCHAR2_TABLE_500
834: , p5_a25 JTF_NUMBER_TABLE
835: , p5_a26 JTF_DATE_TABLE
836: , p5_a27 JTF_NUMBER_TABLE
837: , p5_a28 JTF_DATE_TABLE
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_VARCHAR2_TABLE_100
840: , p5_a31 JTF_VARCHAR2_TABLE_100
834: , p5_a25 JTF_NUMBER_TABLE
835: , p5_a26 JTF_DATE_TABLE
836: , p5_a27 JTF_NUMBER_TABLE
837: , p5_a28 JTF_DATE_TABLE
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_VARCHAR2_TABLE_100
840: , p5_a31 JTF_VARCHAR2_TABLE_100
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
837: , p5_a28 JTF_DATE_TABLE
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_VARCHAR2_TABLE_100
840: , p5_a31 JTF_VARCHAR2_TABLE_100
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
838: , p5_a29 JTF_NUMBER_TABLE
839: , p5_a30 JTF_VARCHAR2_TABLE_100
840: , p5_a31 JTF_VARCHAR2_TABLE_100
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
840: , p5_a31 JTF_VARCHAR2_TABLE_100
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
847: , p6_a6 out nocopy JTF_DATE_TABLE
848: , p6_a7 out nocopy JTF_DATE_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
847: , p6_a6 out nocopy JTF_DATE_TABLE
848: , p6_a7 out nocopy JTF_DATE_TABLE
849: , p6_a8 out nocopy JTF_NUMBER_TABLE
850: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
852: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
853: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
863: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
865: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
866: , p6_a25 out nocopy JTF_NUMBER_TABLE
867: , p6_a26 out nocopy JTF_DATE_TABLE
868: , p6_a27 out nocopy JTF_NUMBER_TABLE
869: , p6_a28 out nocopy JTF_DATE_TABLE
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
864: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
865: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
866: , p6_a25 out nocopy JTF_NUMBER_TABLE
867: , p6_a26 out nocopy JTF_DATE_TABLE
868: , p6_a27 out nocopy JTF_NUMBER_TABLE
869: , p6_a28 out nocopy JTF_DATE_TABLE
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
871: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a25 out nocopy JTF_NUMBER_TABLE
867: , p6_a26 out nocopy JTF_DATE_TABLE
868: , p6_a27 out nocopy JTF_NUMBER_TABLE
869: , p6_a28 out nocopy JTF_DATE_TABLE
870: , p6_a29 out nocopy JTF_NUMBER_TABLE
871: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
873: )
874:
1073: , p_init_msg_list VARCHAR2
1074: , x_return_status out nocopy VARCHAR2
1075: , x_msg_count out nocopy NUMBER
1076: , x_msg_data out nocopy VARCHAR2
1077: , p5_a0 JTF_NUMBER_TABLE
1078: , p5_a1 JTF_NUMBER_TABLE
1079: , p5_a2 JTF_VARCHAR2_TABLE_100
1080: , p5_a3 JTF_NUMBER_TABLE
1081: , p5_a4 JTF_VARCHAR2_TABLE_100
1074: , x_return_status out nocopy VARCHAR2
1075: , x_msg_count out nocopy NUMBER
1076: , x_msg_data out nocopy VARCHAR2
1077: , p5_a0 JTF_NUMBER_TABLE
1078: , p5_a1 JTF_NUMBER_TABLE
1079: , p5_a2 JTF_VARCHAR2_TABLE_100
1080: , p5_a3 JTF_NUMBER_TABLE
1081: , p5_a4 JTF_VARCHAR2_TABLE_100
1082: , p5_a5 JTF_VARCHAR2_TABLE_100
1076: , x_msg_data out nocopy VARCHAR2
1077: , p5_a0 JTF_NUMBER_TABLE
1078: , p5_a1 JTF_NUMBER_TABLE
1079: , p5_a2 JTF_VARCHAR2_TABLE_100
1080: , p5_a3 JTF_NUMBER_TABLE
1081: , p5_a4 JTF_VARCHAR2_TABLE_100
1082: , p5_a5 JTF_VARCHAR2_TABLE_100
1083: , p5_a6 JTF_DATE_TABLE
1084: , p5_a7 JTF_DATE_TABLE
1081: , p5_a4 JTF_VARCHAR2_TABLE_100
1082: , p5_a5 JTF_VARCHAR2_TABLE_100
1083: , p5_a6 JTF_DATE_TABLE
1084: , p5_a7 JTF_DATE_TABLE
1085: , p5_a8 JTF_NUMBER_TABLE
1086: , p5_a9 JTF_VARCHAR2_TABLE_100
1087: , p5_a10 JTF_VARCHAR2_TABLE_500
1088: , p5_a11 JTF_VARCHAR2_TABLE_500
1089: , p5_a12 JTF_VARCHAR2_TABLE_500
1098: , p5_a21 JTF_VARCHAR2_TABLE_500
1099: , p5_a22 JTF_VARCHAR2_TABLE_500
1100: , p5_a23 JTF_VARCHAR2_TABLE_500
1101: , p5_a24 JTF_VARCHAR2_TABLE_500
1102: , p5_a25 JTF_NUMBER_TABLE
1103: , p5_a26 JTF_DATE_TABLE
1104: , p5_a27 JTF_NUMBER_TABLE
1105: , p5_a28 JTF_DATE_TABLE
1106: , p5_a29 JTF_NUMBER_TABLE
1100: , p5_a23 JTF_VARCHAR2_TABLE_500
1101: , p5_a24 JTF_VARCHAR2_TABLE_500
1102: , p5_a25 JTF_NUMBER_TABLE
1103: , p5_a26 JTF_DATE_TABLE
1104: , p5_a27 JTF_NUMBER_TABLE
1105: , p5_a28 JTF_DATE_TABLE
1106: , p5_a29 JTF_NUMBER_TABLE
1107: , p5_a30 JTF_VARCHAR2_TABLE_100
1108: , p5_a31 JTF_VARCHAR2_TABLE_100
1102: , p5_a25 JTF_NUMBER_TABLE
1103: , p5_a26 JTF_DATE_TABLE
1104: , p5_a27 JTF_NUMBER_TABLE
1105: , p5_a28 JTF_DATE_TABLE
1106: , p5_a29 JTF_NUMBER_TABLE
1107: , p5_a30 JTF_VARCHAR2_TABLE_100
1108: , p5_a31 JTF_VARCHAR2_TABLE_100
1109: )
1110:
1340: , p_init_msg_list VARCHAR2
1341: , x_return_status out nocopy VARCHAR2
1342: , x_msg_count out nocopy NUMBER
1343: , x_msg_data out nocopy VARCHAR2
1344: , p5_a0 JTF_NUMBER_TABLE
1345: , p5_a1 JTF_NUMBER_TABLE
1346: , p5_a2 JTF_VARCHAR2_TABLE_100
1347: , p5_a3 JTF_NUMBER_TABLE
1348: , p5_a4 JTF_VARCHAR2_TABLE_100
1341: , x_return_status out nocopy VARCHAR2
1342: , x_msg_count out nocopy NUMBER
1343: , x_msg_data out nocopy VARCHAR2
1344: , p5_a0 JTF_NUMBER_TABLE
1345: , p5_a1 JTF_NUMBER_TABLE
1346: , p5_a2 JTF_VARCHAR2_TABLE_100
1347: , p5_a3 JTF_NUMBER_TABLE
1348: , p5_a4 JTF_VARCHAR2_TABLE_100
1349: , p5_a5 JTF_VARCHAR2_TABLE_100
1343: , x_msg_data out nocopy VARCHAR2
1344: , p5_a0 JTF_NUMBER_TABLE
1345: , p5_a1 JTF_NUMBER_TABLE
1346: , p5_a2 JTF_VARCHAR2_TABLE_100
1347: , p5_a3 JTF_NUMBER_TABLE
1348: , p5_a4 JTF_VARCHAR2_TABLE_100
1349: , p5_a5 JTF_VARCHAR2_TABLE_100
1350: , p5_a6 JTF_DATE_TABLE
1351: , p5_a7 JTF_DATE_TABLE
1348: , p5_a4 JTF_VARCHAR2_TABLE_100
1349: , p5_a5 JTF_VARCHAR2_TABLE_100
1350: , p5_a6 JTF_DATE_TABLE
1351: , p5_a7 JTF_DATE_TABLE
1352: , p5_a8 JTF_NUMBER_TABLE
1353: , p5_a9 JTF_VARCHAR2_TABLE_100
1354: , p5_a10 JTF_VARCHAR2_TABLE_500
1355: , p5_a11 JTF_VARCHAR2_TABLE_500
1356: , p5_a12 JTF_VARCHAR2_TABLE_500
1365: , p5_a21 JTF_VARCHAR2_TABLE_500
1366: , p5_a22 JTF_VARCHAR2_TABLE_500
1367: , p5_a23 JTF_VARCHAR2_TABLE_500
1368: , p5_a24 JTF_VARCHAR2_TABLE_500
1369: , p5_a25 JTF_NUMBER_TABLE
1370: , p5_a26 JTF_DATE_TABLE
1371: , p5_a27 JTF_NUMBER_TABLE
1372: , p5_a28 JTF_DATE_TABLE
1373: , p5_a29 JTF_NUMBER_TABLE
1367: , p5_a23 JTF_VARCHAR2_TABLE_500
1368: , p5_a24 JTF_VARCHAR2_TABLE_500
1369: , p5_a25 JTF_NUMBER_TABLE
1370: , p5_a26 JTF_DATE_TABLE
1371: , p5_a27 JTF_NUMBER_TABLE
1372: , p5_a28 JTF_DATE_TABLE
1373: , p5_a29 JTF_NUMBER_TABLE
1374: , p5_a30 JTF_VARCHAR2_TABLE_100
1375: , p5_a31 JTF_VARCHAR2_TABLE_100
1369: , p5_a25 JTF_NUMBER_TABLE
1370: , p5_a26 JTF_DATE_TABLE
1371: , p5_a27 JTF_NUMBER_TABLE
1372: , p5_a28 JTF_DATE_TABLE
1373: , p5_a29 JTF_NUMBER_TABLE
1374: , p5_a30 JTF_VARCHAR2_TABLE_100
1375: , p5_a31 JTF_VARCHAR2_TABLE_100
1376: , p6_a0 out nocopy JTF_NUMBER_TABLE
1377: , p6_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a28 JTF_DATE_TABLE
1373: , p5_a29 JTF_NUMBER_TABLE
1374: , p5_a30 JTF_VARCHAR2_TABLE_100
1375: , p5_a31 JTF_VARCHAR2_TABLE_100
1376: , p6_a0 out nocopy JTF_NUMBER_TABLE
1377: , p6_a1 out nocopy JTF_NUMBER_TABLE
1378: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1379: , p6_a3 out nocopy JTF_NUMBER_TABLE
1380: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1373: , p5_a29 JTF_NUMBER_TABLE
1374: , p5_a30 JTF_VARCHAR2_TABLE_100
1375: , p5_a31 JTF_VARCHAR2_TABLE_100
1376: , p6_a0 out nocopy JTF_NUMBER_TABLE
1377: , p6_a1 out nocopy JTF_NUMBER_TABLE
1378: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1379: , p6_a3 out nocopy JTF_NUMBER_TABLE
1380: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1375: , p5_a31 JTF_VARCHAR2_TABLE_100
1376: , p6_a0 out nocopy JTF_NUMBER_TABLE
1377: , p6_a1 out nocopy JTF_NUMBER_TABLE
1378: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1379: , p6_a3 out nocopy JTF_NUMBER_TABLE
1380: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1382: , p6_a6 out nocopy JTF_DATE_TABLE
1383: , p6_a7 out nocopy JTF_DATE_TABLE
1380: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1382: , p6_a6 out nocopy JTF_DATE_TABLE
1383: , p6_a7 out nocopy JTF_DATE_TABLE
1384: , p6_a8 out nocopy JTF_NUMBER_TABLE
1385: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1386: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1387: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1388: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1397: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1398: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1399: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1400: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1401: , p6_a25 out nocopy JTF_NUMBER_TABLE
1402: , p6_a26 out nocopy JTF_DATE_TABLE
1403: , p6_a27 out nocopy JTF_NUMBER_TABLE
1404: , p6_a28 out nocopy JTF_DATE_TABLE
1405: , p6_a29 out nocopy JTF_NUMBER_TABLE
1399: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1400: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1401: , p6_a25 out nocopy JTF_NUMBER_TABLE
1402: , p6_a26 out nocopy JTF_DATE_TABLE
1403: , p6_a27 out nocopy JTF_NUMBER_TABLE
1404: , p6_a28 out nocopy JTF_DATE_TABLE
1405: , p6_a29 out nocopy JTF_NUMBER_TABLE
1406: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1407: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1401: , p6_a25 out nocopy JTF_NUMBER_TABLE
1402: , p6_a26 out nocopy JTF_DATE_TABLE
1403: , p6_a27 out nocopy JTF_NUMBER_TABLE
1404: , p6_a28 out nocopy JTF_DATE_TABLE
1405: , p6_a29 out nocopy JTF_NUMBER_TABLE
1406: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1407: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1408: )
1409:
1608: , p_init_msg_list VARCHAR2
1609: , x_return_status out nocopy VARCHAR2
1610: , x_msg_count out nocopy NUMBER
1611: , x_msg_data out nocopy VARCHAR2
1612: , p5_a0 JTF_NUMBER_TABLE
1613: , p5_a1 JTF_NUMBER_TABLE
1614: , p5_a2 JTF_VARCHAR2_TABLE_100
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_VARCHAR2_TABLE_100
1609: , x_return_status out nocopy VARCHAR2
1610: , x_msg_count out nocopy NUMBER
1611: , x_msg_data out nocopy VARCHAR2
1612: , p5_a0 JTF_NUMBER_TABLE
1613: , p5_a1 JTF_NUMBER_TABLE
1614: , p5_a2 JTF_VARCHAR2_TABLE_100
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_VARCHAR2_TABLE_100
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1611: , x_msg_data out nocopy VARCHAR2
1612: , p5_a0 JTF_NUMBER_TABLE
1613: , p5_a1 JTF_NUMBER_TABLE
1614: , p5_a2 JTF_VARCHAR2_TABLE_100
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_VARCHAR2_TABLE_100
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_DATE_TABLE
1619: , p5_a7 JTF_DATE_TABLE
1616: , p5_a4 JTF_VARCHAR2_TABLE_100
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_DATE_TABLE
1619: , p5_a7 JTF_DATE_TABLE
1620: , p5_a8 JTF_NUMBER_TABLE
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1622: , p5_a10 JTF_VARCHAR2_TABLE_500
1623: , p5_a11 JTF_VARCHAR2_TABLE_500
1624: , p5_a12 JTF_VARCHAR2_TABLE_500
1633: , p5_a21 JTF_VARCHAR2_TABLE_500
1634: , p5_a22 JTF_VARCHAR2_TABLE_500
1635: , p5_a23 JTF_VARCHAR2_TABLE_500
1636: , p5_a24 JTF_VARCHAR2_TABLE_500
1637: , p5_a25 JTF_NUMBER_TABLE
1638: , p5_a26 JTF_DATE_TABLE
1639: , p5_a27 JTF_NUMBER_TABLE
1640: , p5_a28 JTF_DATE_TABLE
1641: , p5_a29 JTF_NUMBER_TABLE
1635: , p5_a23 JTF_VARCHAR2_TABLE_500
1636: , p5_a24 JTF_VARCHAR2_TABLE_500
1637: , p5_a25 JTF_NUMBER_TABLE
1638: , p5_a26 JTF_DATE_TABLE
1639: , p5_a27 JTF_NUMBER_TABLE
1640: , p5_a28 JTF_DATE_TABLE
1641: , p5_a29 JTF_NUMBER_TABLE
1642: , p5_a30 JTF_VARCHAR2_TABLE_100
1643: , p5_a31 JTF_VARCHAR2_TABLE_100
1637: , p5_a25 JTF_NUMBER_TABLE
1638: , p5_a26 JTF_DATE_TABLE
1639: , p5_a27 JTF_NUMBER_TABLE
1640: , p5_a28 JTF_DATE_TABLE
1641: , p5_a29 JTF_NUMBER_TABLE
1642: , p5_a30 JTF_VARCHAR2_TABLE_100
1643: , p5_a31 JTF_VARCHAR2_TABLE_100
1644: )
1645:
1807: , p_init_msg_list VARCHAR2
1808: , x_return_status out nocopy VARCHAR2
1809: , x_msg_count out nocopy NUMBER
1810: , x_msg_data out nocopy VARCHAR2
1811: , p5_a0 JTF_NUMBER_TABLE
1812: , p5_a1 JTF_NUMBER_TABLE
1813: , p5_a2 JTF_VARCHAR2_TABLE_100
1814: , p5_a3 JTF_NUMBER_TABLE
1815: , p5_a4 JTF_VARCHAR2_TABLE_100
1808: , x_return_status out nocopy VARCHAR2
1809: , x_msg_count out nocopy NUMBER
1810: , x_msg_data out nocopy VARCHAR2
1811: , p5_a0 JTF_NUMBER_TABLE
1812: , p5_a1 JTF_NUMBER_TABLE
1813: , p5_a2 JTF_VARCHAR2_TABLE_100
1814: , p5_a3 JTF_NUMBER_TABLE
1815: , p5_a4 JTF_VARCHAR2_TABLE_100
1816: , p5_a5 JTF_VARCHAR2_TABLE_100
1810: , x_msg_data out nocopy VARCHAR2
1811: , p5_a0 JTF_NUMBER_TABLE
1812: , p5_a1 JTF_NUMBER_TABLE
1813: , p5_a2 JTF_VARCHAR2_TABLE_100
1814: , p5_a3 JTF_NUMBER_TABLE
1815: , p5_a4 JTF_VARCHAR2_TABLE_100
1816: , p5_a5 JTF_VARCHAR2_TABLE_100
1817: , p5_a6 JTF_DATE_TABLE
1818: , p5_a7 JTF_DATE_TABLE
1815: , p5_a4 JTF_VARCHAR2_TABLE_100
1816: , p5_a5 JTF_VARCHAR2_TABLE_100
1817: , p5_a6 JTF_DATE_TABLE
1818: , p5_a7 JTF_DATE_TABLE
1819: , p5_a8 JTF_NUMBER_TABLE
1820: , p5_a9 JTF_VARCHAR2_TABLE_100
1821: , p5_a10 JTF_VARCHAR2_TABLE_500
1822: , p5_a11 JTF_VARCHAR2_TABLE_500
1823: , p5_a12 JTF_VARCHAR2_TABLE_500
1832: , p5_a21 JTF_VARCHAR2_TABLE_500
1833: , p5_a22 JTF_VARCHAR2_TABLE_500
1834: , p5_a23 JTF_VARCHAR2_TABLE_500
1835: , p5_a24 JTF_VARCHAR2_TABLE_500
1836: , p5_a25 JTF_NUMBER_TABLE
1837: , p5_a26 JTF_DATE_TABLE
1838: , p5_a27 JTF_NUMBER_TABLE
1839: , p5_a28 JTF_DATE_TABLE
1840: , p5_a29 JTF_NUMBER_TABLE
1834: , p5_a23 JTF_VARCHAR2_TABLE_500
1835: , p5_a24 JTF_VARCHAR2_TABLE_500
1836: , p5_a25 JTF_NUMBER_TABLE
1837: , p5_a26 JTF_DATE_TABLE
1838: , p5_a27 JTF_NUMBER_TABLE
1839: , p5_a28 JTF_DATE_TABLE
1840: , p5_a29 JTF_NUMBER_TABLE
1841: , p5_a30 JTF_VARCHAR2_TABLE_100
1842: , p5_a31 JTF_VARCHAR2_TABLE_100
1836: , p5_a25 JTF_NUMBER_TABLE
1837: , p5_a26 JTF_DATE_TABLE
1838: , p5_a27 JTF_NUMBER_TABLE
1839: , p5_a28 JTF_DATE_TABLE
1840: , p5_a29 JTF_NUMBER_TABLE
1841: , p5_a30 JTF_VARCHAR2_TABLE_100
1842: , p5_a31 JTF_VARCHAR2_TABLE_100
1843: )
1844: