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_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if a0 is not null and a0.count > 0 then
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a8 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_DATE_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_DATE_TABLE
115: , a12 out nocopy JTF_VARCHAR2_TABLE_500
126: , a23 out nocopy JTF_VARCHAR2_TABLE_500
127: , a24 out nocopy JTF_VARCHAR2_TABLE_500
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_200();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_200();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_200();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_2000();
147: a8 := JTF_NUMBER_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_2000();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_DATE_TABLE();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_DATE_TABLE();
151: a12 := JTF_VARCHAR2_TABLE_500();
162: a23 := JTF_VARCHAR2_TABLE_500();
163: a24 := JTF_VARCHAR2_TABLE_500();
164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_2000();
180: a8 := JTF_NUMBER_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_2000();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_DATE_TABLE();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_VARCHAR2_TABLE_500();
195: a23 := JTF_VARCHAR2_TABLE_500();
196: a24 := JTF_VARCHAR2_TABLE_500();
197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: a1.extend(t.count);
207: a2.extend(t.count);
278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_fma_pvt.okl_formulae_tl_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE
292: ) as
293: ddindx binary_integer; indx binary_integer;
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE
292: ) as
293: ddindx binary_integer; indx binary_integer;
294: begin
295: if a0 is not null and a0.count > 0 then
315: end loop;
316: end if;
317: end if;
318: end rosetta_table_copy_in_p5;
319: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
320: , a1 out nocopy JTF_VARCHAR2_TABLE_100
321: , a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
320: , a1 out nocopy JTF_VARCHAR2_TABLE_100
321: , a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE
322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE
329: ) as
330: ddindx binary_integer; indx binary_integer;
324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE
329: ) as
330: ddindx binary_integer; indx binary_integer;
331: begin
332: if t is null or t.count = 0 then
329: ) as
330: ddindx binary_integer; indx binary_integer;
331: begin
332: if t is null or t.count = 0 then
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_2000();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_2000();
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_2000();
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: else
344: a0 := JTF_NUMBER_TABLE();
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: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();
347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);
356: a1.extend(t.count);
357: a2.extend(t.count);
384: end if;
385: end if;
386: end rosetta_table_copy_out_p5;
387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100
385: end if;
386: end rosetta_table_copy_out_p5;
387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100
393: , a5 JTF_VARCHAR2_TABLE_200
387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100
393: , a5 JTF_VARCHAR2_TABLE_200
394: , a6 JTF_VARCHAR2_TABLE_2000
395: , a7 JTF_VARCHAR2_TABLE_2000
411: , a23 JTF_VARCHAR2_TABLE_500
412: , a24 JTF_VARCHAR2_TABLE_500
413: , a25 JTF_VARCHAR2_TABLE_500
414: , a26 JTF_VARCHAR2_TABLE_500
415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
413: , a25 JTF_VARCHAR2_TABLE_500
414: , a26 JTF_VARCHAR2_TABLE_500
415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE
415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE
422: ) as
423: ddindx binary_integer; indx binary_integer;
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE
422: ) as
423: ddindx binary_integer; indx binary_integer;
424: begin
425: if a0 is not null and a0.count > 0 then
469: end loop;
470: end if;
471: end if;
472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100
470: end if;
471: end if;
472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , a5 out nocopy JTF_VARCHAR2_TABLE_200
472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , a5 out nocopy JTF_VARCHAR2_TABLE_200
479: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
480: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
496: , a23 out nocopy JTF_VARCHAR2_TABLE_500
497: , a24 out nocopy JTF_VARCHAR2_TABLE_500
498: , a25 out nocopy JTF_VARCHAR2_TABLE_500
499: , a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
498: , a25 out nocopy JTF_VARCHAR2_TABLE_500
499: , a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE
500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE
507: ) as
508: ddindx binary_integer; indx binary_integer;
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE
507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then
507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();
516: a5 := JTF_VARCHAR2_TABLE_200();
510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();
516: a5 := JTF_VARCHAR2_TABLE_200();
517: a6 := JTF_VARCHAR2_TABLE_2000();
518: a7 := JTF_VARCHAR2_TABLE_2000();
534: a23 := JTF_VARCHAR2_TABLE_500();
535: a24 := JTF_VARCHAR2_TABLE_500();
536: a25 := JTF_VARCHAR2_TABLE_500();
537: a26 := JTF_VARCHAR2_TABLE_500();
538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
536: a25 := JTF_VARCHAR2_TABLE_500();
537: a26 := JTF_VARCHAR2_TABLE_500();
538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();
551: a5 := JTF_VARCHAR2_TABLE_200();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();
551: a5 := JTF_VARCHAR2_TABLE_200();
552: a6 := JTF_VARCHAR2_TABLE_2000();
553: a7 := JTF_VARCHAR2_TABLE_2000();
569: a23 := JTF_VARCHAR2_TABLE_500();
570: a24 := JTF_VARCHAR2_TABLE_500();
571: a25 := JTF_VARCHAR2_TABLE_500();
572: a26 := JTF_VARCHAR2_TABLE_500();
573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
571: a25 := JTF_VARCHAR2_TABLE_500();
572: a26 := JTF_VARCHAR2_TABLE_500();
573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();
573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();
580: if t.count > 0 then
581: a0.extend(t.count);
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();
580: if t.count > 0 then
581: a0.extend(t.count);
582: a1.extend(t.count);
583: a2.extend(t.count);
838: , p_init_msg_list VARCHAR2
839: , x_return_status out nocopy VARCHAR2
840: , x_msg_count out nocopy NUMBER
841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100
839: , x_return_status out nocopy VARCHAR2
840: , x_msg_count out nocopy NUMBER
841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100
847: , p5_a5 JTF_VARCHAR2_TABLE_200
841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100
847: , p5_a5 JTF_VARCHAR2_TABLE_200
848: , p5_a6 JTF_VARCHAR2_TABLE_2000
849: , p5_a7 JTF_VARCHAR2_TABLE_2000
865: , p5_a23 JTF_VARCHAR2_TABLE_500
866: , p5_a24 JTF_VARCHAR2_TABLE_500
867: , p5_a25 JTF_VARCHAR2_TABLE_500
868: , p5_a26 JTF_VARCHAR2_TABLE_500
869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
867: , p5_a25 JTF_VARCHAR2_TABLE_500
868: , p5_a26 JTF_VARCHAR2_TABLE_500
869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
882: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
883: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
899: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
900: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
901: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
902: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
901: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
902: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE
903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE
910: )
911:
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE
910: )
911:
912: as
913: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;
1118: , p_init_msg_list VARCHAR2
1119: , x_return_status out nocopy VARCHAR2
1120: , x_msg_count out nocopy NUMBER
1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100
1119: , x_return_status out nocopy VARCHAR2
1120: , x_msg_count out nocopy NUMBER
1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100
1127: , p5_a5 JTF_VARCHAR2_TABLE_200
1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100
1127: , p5_a5 JTF_VARCHAR2_TABLE_200
1128: , p5_a6 JTF_VARCHAR2_TABLE_2000
1129: , p5_a7 JTF_VARCHAR2_TABLE_2000
1145: , p5_a23 JTF_VARCHAR2_TABLE_500
1146: , p5_a24 JTF_VARCHAR2_TABLE_500
1147: , p5_a25 JTF_VARCHAR2_TABLE_500
1148: , p5_a26 JTF_VARCHAR2_TABLE_500
1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1147: , p5_a25 JTF_VARCHAR2_TABLE_500
1148: , p5_a26 JTF_VARCHAR2_TABLE_500
1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE
1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE
1156: )
1157:
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE
1156: )
1157:
1158: as
1159: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;
1397: , p_init_msg_list VARCHAR2
1398: , x_return_status out nocopy VARCHAR2
1399: , x_msg_count out nocopy NUMBER
1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100
1398: , x_return_status out nocopy VARCHAR2
1399: , x_msg_count out nocopy NUMBER
1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100
1406: , p5_a5 JTF_VARCHAR2_TABLE_200
1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100
1406: , p5_a5 JTF_VARCHAR2_TABLE_200
1407: , p5_a6 JTF_VARCHAR2_TABLE_2000
1408: , p5_a7 JTF_VARCHAR2_TABLE_2000
1424: , p5_a23 JTF_VARCHAR2_TABLE_500
1425: , p5_a24 JTF_VARCHAR2_TABLE_500
1426: , p5_a25 JTF_VARCHAR2_TABLE_500
1427: , p5_a26 JTF_VARCHAR2_TABLE_500
1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1426: , p5_a25 JTF_VARCHAR2_TABLE_500
1427: , p5_a26 JTF_VARCHAR2_TABLE_500
1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1440: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1440: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1441: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1442: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1458: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1459: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1460: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1461: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1460: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1461: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE
1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE
1469: )
1470:
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE
1469: )
1470:
1471: as
1472: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;
1677: , p_init_msg_list VARCHAR2
1678: , x_return_status out nocopy VARCHAR2
1679: , x_msg_count out nocopy NUMBER
1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100
1678: , x_return_status out nocopy VARCHAR2
1679: , x_msg_count out nocopy NUMBER
1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100
1686: , p5_a5 JTF_VARCHAR2_TABLE_200
1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100
1686: , p5_a5 JTF_VARCHAR2_TABLE_200
1687: , p5_a6 JTF_VARCHAR2_TABLE_2000
1688: , p5_a7 JTF_VARCHAR2_TABLE_2000
1704: , p5_a23 JTF_VARCHAR2_TABLE_500
1705: , p5_a24 JTF_VARCHAR2_TABLE_500
1706: , p5_a25 JTF_VARCHAR2_TABLE_500
1707: , p5_a26 JTF_VARCHAR2_TABLE_500
1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1706: , p5_a25 JTF_VARCHAR2_TABLE_500
1707: , p5_a26 JTF_VARCHAR2_TABLE_500
1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE
1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE
1715: )
1716:
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE
1715: )
1716:
1717: as
1718: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;
1884: , p_init_msg_list VARCHAR2
1885: , x_return_status out nocopy VARCHAR2
1886: , x_msg_count out nocopy NUMBER
1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100
1885: , x_return_status out nocopy VARCHAR2
1886: , x_msg_count out nocopy NUMBER
1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100
1893: , p5_a5 JTF_VARCHAR2_TABLE_200
1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100
1893: , p5_a5 JTF_VARCHAR2_TABLE_200
1894: , p5_a6 JTF_VARCHAR2_TABLE_2000
1895: , p5_a7 JTF_VARCHAR2_TABLE_2000
1911: , p5_a23 JTF_VARCHAR2_TABLE_500
1912: , p5_a24 JTF_VARCHAR2_TABLE_500
1913: , p5_a25 JTF_VARCHAR2_TABLE_500
1914: , p5_a26 JTF_VARCHAR2_TABLE_500
1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1913: , p5_a25 JTF_VARCHAR2_TABLE_500
1914: , p5_a26 JTF_VARCHAR2_TABLE_500
1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE
1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE
1922: )
1923:
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE
1922: )
1923:
1924: as
1925: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;