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_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_800
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_800
27: , a5 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_800
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: ) as
53: ddindx binary_integer; indx binary_integer;
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: ) as
53: ddindx binary_integer; indx binary_integer;
54: begin
55: if a0 is not null and a0.count > 0 then
95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p2;
99: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_800
96: end if;
97: end if;
98: end rosetta_table_copy_in_p2;
99: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_800
104: , a5 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_800
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_DATE_TABLE
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
120: , a21 out nocopy JTF_VARCHAR2_TABLE_500
121: , a22 out nocopy JTF_VARCHAR2_TABLE_500
122: , a23 out nocopy JTF_VARCHAR2_TABLE_500
123: , a24 out nocopy JTF_VARCHAR2_TABLE_500
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
122: , a23 out nocopy JTF_VARCHAR2_TABLE_500
123: , a24 out nocopy JTF_VARCHAR2_TABLE_500
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: ) as
130: ddindx binary_integer; indx binary_integer;
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_200();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_VARCHAR2_TABLE_800();
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_200();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_VARCHAR2_TABLE_800();
138: a5 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_200();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_VARCHAR2_TABLE_800();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_DATE_TABLE();
140: a7 := JTF_DATE_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_100();
142: a9 := JTF_VARCHAR2_TABLE_100();
154: a21 := JTF_VARCHAR2_TABLE_500();
155: a22 := JTF_VARCHAR2_TABLE_500();
156: a23 := JTF_VARCHAR2_TABLE_500();
157: a24 := JTF_VARCHAR2_TABLE_500();
158: a25 := JTF_NUMBER_TABLE();
159: a26 := JTF_DATE_TABLE();
160: a27 := JTF_NUMBER_TABLE();
161: a28 := JTF_DATE_TABLE();
162: a29 := JTF_NUMBER_TABLE();
156: a23 := JTF_VARCHAR2_TABLE_500();
157: a24 := JTF_VARCHAR2_TABLE_500();
158: a25 := JTF_NUMBER_TABLE();
159: a26 := JTF_DATE_TABLE();
160: a27 := JTF_NUMBER_TABLE();
161: a28 := JTF_DATE_TABLE();
162: a29 := JTF_NUMBER_TABLE();
163: else
164: a0 := JTF_NUMBER_TABLE();
158: a25 := JTF_NUMBER_TABLE();
159: a26 := JTF_DATE_TABLE();
160: a27 := JTF_NUMBER_TABLE();
161: a28 := JTF_DATE_TABLE();
162: a29 := JTF_NUMBER_TABLE();
163: else
164: a0 := JTF_NUMBER_TABLE();
165: a1 := JTF_NUMBER_TABLE();
166: a2 := JTF_VARCHAR2_TABLE_200();
160: a27 := JTF_NUMBER_TABLE();
161: a28 := JTF_DATE_TABLE();
162: a29 := JTF_NUMBER_TABLE();
163: else
164: a0 := JTF_NUMBER_TABLE();
165: a1 := JTF_NUMBER_TABLE();
166: a2 := JTF_VARCHAR2_TABLE_200();
167: a3 := JTF_VARCHAR2_TABLE_100();
168: a4 := JTF_VARCHAR2_TABLE_800();
161: a28 := JTF_DATE_TABLE();
162: a29 := JTF_NUMBER_TABLE();
163: else
164: a0 := JTF_NUMBER_TABLE();
165: a1 := JTF_NUMBER_TABLE();
166: a2 := JTF_VARCHAR2_TABLE_200();
167: a3 := JTF_VARCHAR2_TABLE_100();
168: a4 := JTF_VARCHAR2_TABLE_800();
169: a5 := JTF_NUMBER_TABLE();
165: a1 := JTF_NUMBER_TABLE();
166: a2 := JTF_VARCHAR2_TABLE_200();
167: a3 := JTF_VARCHAR2_TABLE_100();
168: a4 := JTF_VARCHAR2_TABLE_800();
169: a5 := JTF_NUMBER_TABLE();
170: a6 := JTF_DATE_TABLE();
171: a7 := JTF_DATE_TABLE();
172: a8 := JTF_VARCHAR2_TABLE_100();
173: a9 := JTF_VARCHAR2_TABLE_100();
185: a21 := JTF_VARCHAR2_TABLE_500();
186: a22 := JTF_VARCHAR2_TABLE_500();
187: a23 := JTF_VARCHAR2_TABLE_500();
188: a24 := JTF_VARCHAR2_TABLE_500();
189: a25 := JTF_NUMBER_TABLE();
190: a26 := JTF_DATE_TABLE();
191: a27 := JTF_NUMBER_TABLE();
192: a28 := JTF_DATE_TABLE();
193: a29 := JTF_NUMBER_TABLE();
187: a23 := JTF_VARCHAR2_TABLE_500();
188: a24 := JTF_VARCHAR2_TABLE_500();
189: a25 := JTF_NUMBER_TABLE();
190: a26 := JTF_DATE_TABLE();
191: a27 := JTF_NUMBER_TABLE();
192: a28 := JTF_DATE_TABLE();
193: a29 := JTF_NUMBER_TABLE();
194: if t.count > 0 then
195: a0.extend(t.count);
189: a25 := JTF_NUMBER_TABLE();
190: a26 := JTF_DATE_TABLE();
191: a27 := JTF_NUMBER_TABLE();
192: a28 := JTF_DATE_TABLE();
193: a29 := JTF_NUMBER_TABLE();
194: if t.count > 0 then
195: a0.extend(t.count);
196: a1.extend(t.count);
197: a2.extend(t.count);
264: end if;
265: end if;
266: end rosetta_table_copy_out_p2;
267:
268: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE
269: , a1 JTF_VARCHAR2_TABLE_100
270: , a2 JTF_VARCHAR2_TABLE_100
271: , a3 JTF_VARCHAR2_TABLE_100
272: , a4 JTF_VARCHAR2_TABLE_2000
269: , a1 JTF_VARCHAR2_TABLE_100
270: , a2 JTF_VARCHAR2_TABLE_100
271: , a3 JTF_VARCHAR2_TABLE_100
272: , a4 JTF_VARCHAR2_TABLE_2000
273: , a5 JTF_NUMBER_TABLE
274: , a6 JTF_DATE_TABLE
275: , a7 JTF_NUMBER_TABLE
276: , a8 JTF_DATE_TABLE
277: , a9 JTF_NUMBER_TABLE
271: , a3 JTF_VARCHAR2_TABLE_100
272: , a4 JTF_VARCHAR2_TABLE_2000
273: , a5 JTF_NUMBER_TABLE
274: , a6 JTF_DATE_TABLE
275: , a7 JTF_NUMBER_TABLE
276: , a8 JTF_DATE_TABLE
277: , a9 JTF_NUMBER_TABLE
278: ) as
279: ddindx binary_integer; indx binary_integer;
273: , a5 JTF_NUMBER_TABLE
274: , a6 JTF_DATE_TABLE
275: , a7 JTF_NUMBER_TABLE
276: , a8 JTF_DATE_TABLE
277: , a9 JTF_NUMBER_TABLE
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if a0 is not null and a0.count > 0 then
301: end loop;
302: end if;
303: end if;
304: end rosetta_table_copy_in_p5;
305: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE
306: , a1 out nocopy JTF_VARCHAR2_TABLE_100
307: , a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
306: , a1 out nocopy JTF_VARCHAR2_TABLE_100
307: , a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
310: , a5 out nocopy JTF_NUMBER_TABLE
311: , a6 out nocopy JTF_DATE_TABLE
312: , a7 out nocopy JTF_NUMBER_TABLE
313: , a8 out nocopy JTF_DATE_TABLE
314: , a9 out nocopy JTF_NUMBER_TABLE
308: , a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
310: , a5 out nocopy JTF_NUMBER_TABLE
311: , a6 out nocopy JTF_DATE_TABLE
312: , a7 out nocopy JTF_NUMBER_TABLE
313: , a8 out nocopy JTF_DATE_TABLE
314: , a9 out nocopy JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
310: , a5 out nocopy JTF_NUMBER_TABLE
311: , a6 out nocopy JTF_DATE_TABLE
312: , a7 out nocopy JTF_NUMBER_TABLE
313: , a8 out nocopy JTF_DATE_TABLE
314: , a9 out nocopy JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if t is null or t.count = 0 then
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if t is null or t.count = 0 then
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_VARCHAR2_TABLE_2000();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_VARCHAR2_TABLE_2000();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_DATE_TABLE();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_DATE_TABLE();
328: a9 := JTF_NUMBER_TABLE();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_VARCHAR2_TABLE_2000();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_DATE_TABLE();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_DATE_TABLE();
328: a9 := JTF_NUMBER_TABLE();
329: else
330: a0 := JTF_NUMBER_TABLE();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_DATE_TABLE();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_DATE_TABLE();
328: a9 := JTF_NUMBER_TABLE();
329: else
330: a0 := JTF_NUMBER_TABLE();
331: a1 := JTF_VARCHAR2_TABLE_100();
332: a2 := JTF_VARCHAR2_TABLE_100();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_DATE_TABLE();
328: a9 := JTF_NUMBER_TABLE();
329: else
330: a0 := JTF_NUMBER_TABLE();
331: a1 := JTF_VARCHAR2_TABLE_100();
332: a2 := JTF_VARCHAR2_TABLE_100();
333: a3 := JTF_VARCHAR2_TABLE_100();
334: a4 := JTF_VARCHAR2_TABLE_2000();
331: a1 := JTF_VARCHAR2_TABLE_100();
332: a2 := JTF_VARCHAR2_TABLE_100();
333: a3 := JTF_VARCHAR2_TABLE_100();
334: a4 := JTF_VARCHAR2_TABLE_2000();
335: a5 := JTF_NUMBER_TABLE();
336: a6 := JTF_DATE_TABLE();
337: a7 := JTF_NUMBER_TABLE();
338: a8 := JTF_DATE_TABLE();
339: a9 := JTF_NUMBER_TABLE();
333: a3 := JTF_VARCHAR2_TABLE_100();
334: a4 := JTF_VARCHAR2_TABLE_2000();
335: a5 := JTF_NUMBER_TABLE();
336: a6 := JTF_DATE_TABLE();
337: a7 := JTF_NUMBER_TABLE();
338: a8 := JTF_DATE_TABLE();
339: a9 := JTF_NUMBER_TABLE();
340: if t.count > 0 then
341: a0.extend(t.count);
335: a5 := JTF_NUMBER_TABLE();
336: a6 := JTF_DATE_TABLE();
337: a7 := JTF_NUMBER_TABLE();
338: a8 := JTF_DATE_TABLE();
339: a9 := JTF_NUMBER_TABLE();
340: if t.count > 0 then
341: a0.extend(t.count);
342: a1.extend(t.count);
343: a2.extend(t.count);
370: end if;
371: end if;
372: end rosetta_table_copy_out_p5;
373:
374: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_VARCHAR2_TABLE_100
377: , a3 JTF_VARCHAR2_TABLE_100
378: , a4 JTF_VARCHAR2_TABLE_200
371: end if;
372: end rosetta_table_copy_out_p5;
373:
374: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_VARCHAR2_TABLE_100
377: , a3 JTF_VARCHAR2_TABLE_100
378: , a4 JTF_VARCHAR2_TABLE_200
379: , a5 JTF_VARCHAR2_TABLE_2000
396: , a22 JTF_VARCHAR2_TABLE_500
397: , a23 JTF_VARCHAR2_TABLE_500
398: , a24 JTF_VARCHAR2_TABLE_500
399: , a25 JTF_VARCHAR2_TABLE_500
400: , a26 JTF_NUMBER_TABLE
401: , a27 JTF_NUMBER_TABLE
402: , a28 JTF_DATE_TABLE
403: , a29 JTF_NUMBER_TABLE
404: , a30 JTF_DATE_TABLE
397: , a23 JTF_VARCHAR2_TABLE_500
398: , a24 JTF_VARCHAR2_TABLE_500
399: , a25 JTF_VARCHAR2_TABLE_500
400: , a26 JTF_NUMBER_TABLE
401: , a27 JTF_NUMBER_TABLE
402: , a28 JTF_DATE_TABLE
403: , a29 JTF_NUMBER_TABLE
404: , a30 JTF_DATE_TABLE
405: , a31 JTF_NUMBER_TABLE
399: , a25 JTF_VARCHAR2_TABLE_500
400: , a26 JTF_NUMBER_TABLE
401: , a27 JTF_NUMBER_TABLE
402: , a28 JTF_DATE_TABLE
403: , a29 JTF_NUMBER_TABLE
404: , a30 JTF_DATE_TABLE
405: , a31 JTF_NUMBER_TABLE
406: ) as
407: ddindx binary_integer; indx binary_integer;
401: , a27 JTF_NUMBER_TABLE
402: , a28 JTF_DATE_TABLE
403: , a29 JTF_NUMBER_TABLE
404: , a30 JTF_DATE_TABLE
405: , a31 JTF_NUMBER_TABLE
406: ) as
407: ddindx binary_integer; indx binary_integer;
408: begin
409: if a0 is not null and a0.count > 0 then
451: end loop;
452: end if;
453: end if;
454: end rosetta_table_copy_in_p8;
455: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_VARCHAR2_TABLE_100
458: , a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , a4 out nocopy JTF_VARCHAR2_TABLE_200
452: end if;
453: end if;
454: end rosetta_table_copy_in_p8;
455: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_VARCHAR2_TABLE_100
458: , a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , a4 out nocopy JTF_VARCHAR2_TABLE_200
460: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
477: , a22 out nocopy JTF_VARCHAR2_TABLE_500
478: , a23 out nocopy JTF_VARCHAR2_TABLE_500
479: , a24 out nocopy JTF_VARCHAR2_TABLE_500
480: , a25 out nocopy JTF_VARCHAR2_TABLE_500
481: , a26 out nocopy JTF_NUMBER_TABLE
482: , a27 out nocopy JTF_NUMBER_TABLE
483: , a28 out nocopy JTF_DATE_TABLE
484: , a29 out nocopy JTF_NUMBER_TABLE
485: , a30 out nocopy JTF_DATE_TABLE
478: , a23 out nocopy JTF_VARCHAR2_TABLE_500
479: , a24 out nocopy JTF_VARCHAR2_TABLE_500
480: , a25 out nocopy JTF_VARCHAR2_TABLE_500
481: , a26 out nocopy JTF_NUMBER_TABLE
482: , a27 out nocopy JTF_NUMBER_TABLE
483: , a28 out nocopy JTF_DATE_TABLE
484: , a29 out nocopy JTF_NUMBER_TABLE
485: , a30 out nocopy JTF_DATE_TABLE
486: , a31 out nocopy JTF_NUMBER_TABLE
480: , a25 out nocopy JTF_VARCHAR2_TABLE_500
481: , a26 out nocopy JTF_NUMBER_TABLE
482: , a27 out nocopy JTF_NUMBER_TABLE
483: , a28 out nocopy JTF_DATE_TABLE
484: , a29 out nocopy JTF_NUMBER_TABLE
485: , a30 out nocopy JTF_DATE_TABLE
486: , a31 out nocopy JTF_NUMBER_TABLE
487: ) as
488: ddindx binary_integer; indx binary_integer;
482: , a27 out nocopy JTF_NUMBER_TABLE
483: , a28 out nocopy JTF_DATE_TABLE
484: , a29 out nocopy JTF_NUMBER_TABLE
485: , a30 out nocopy JTF_DATE_TABLE
486: , a31 out nocopy JTF_NUMBER_TABLE
487: ) as
488: ddindx binary_integer; indx binary_integer;
489: begin
490: if t is null or t.count = 0 then
487: ) as
488: ddindx binary_integer; indx binary_integer;
489: begin
490: if t is null or t.count = 0 then
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_VARCHAR2_TABLE_100();
495: a4 := JTF_VARCHAR2_TABLE_200();
488: ddindx binary_integer; indx binary_integer;
489: begin
490: if t is null or t.count = 0 then
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_VARCHAR2_TABLE_100();
495: a4 := JTF_VARCHAR2_TABLE_200();
496: a5 := JTF_VARCHAR2_TABLE_2000();
513: a22 := JTF_VARCHAR2_TABLE_500();
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_VARCHAR2_TABLE_500();
516: a25 := JTF_VARCHAR2_TABLE_500();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_NUMBER_TABLE();
519: a28 := JTF_DATE_TABLE();
520: a29 := JTF_NUMBER_TABLE();
521: a30 := JTF_DATE_TABLE();
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_VARCHAR2_TABLE_500();
516: a25 := JTF_VARCHAR2_TABLE_500();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_NUMBER_TABLE();
519: a28 := JTF_DATE_TABLE();
520: a29 := JTF_NUMBER_TABLE();
521: a30 := JTF_DATE_TABLE();
522: a31 := JTF_NUMBER_TABLE();
516: a25 := JTF_VARCHAR2_TABLE_500();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_NUMBER_TABLE();
519: a28 := JTF_DATE_TABLE();
520: a29 := JTF_NUMBER_TABLE();
521: a30 := JTF_DATE_TABLE();
522: a31 := JTF_NUMBER_TABLE();
523: else
524: a0 := JTF_NUMBER_TABLE();
518: a27 := JTF_NUMBER_TABLE();
519: a28 := JTF_DATE_TABLE();
520: a29 := JTF_NUMBER_TABLE();
521: a30 := JTF_DATE_TABLE();
522: a31 := JTF_NUMBER_TABLE();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_VARCHAR2_TABLE_100();
520: a29 := JTF_NUMBER_TABLE();
521: a30 := JTF_DATE_TABLE();
522: a31 := JTF_NUMBER_TABLE();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_VARCHAR2_TABLE_100();
527: a3 := JTF_VARCHAR2_TABLE_100();
528: a4 := JTF_VARCHAR2_TABLE_200();
521: a30 := JTF_DATE_TABLE();
522: a31 := JTF_NUMBER_TABLE();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_VARCHAR2_TABLE_100();
527: a3 := JTF_VARCHAR2_TABLE_100();
528: a4 := JTF_VARCHAR2_TABLE_200();
529: a5 := JTF_VARCHAR2_TABLE_2000();
546: a22 := JTF_VARCHAR2_TABLE_500();
547: a23 := JTF_VARCHAR2_TABLE_500();
548: a24 := JTF_VARCHAR2_TABLE_500();
549: a25 := JTF_VARCHAR2_TABLE_500();
550: a26 := JTF_NUMBER_TABLE();
551: a27 := JTF_NUMBER_TABLE();
552: a28 := JTF_DATE_TABLE();
553: a29 := JTF_NUMBER_TABLE();
554: a30 := JTF_DATE_TABLE();
547: a23 := JTF_VARCHAR2_TABLE_500();
548: a24 := JTF_VARCHAR2_TABLE_500();
549: a25 := JTF_VARCHAR2_TABLE_500();
550: a26 := JTF_NUMBER_TABLE();
551: a27 := JTF_NUMBER_TABLE();
552: a28 := JTF_DATE_TABLE();
553: a29 := JTF_NUMBER_TABLE();
554: a30 := JTF_DATE_TABLE();
555: a31 := JTF_NUMBER_TABLE();
549: a25 := JTF_VARCHAR2_TABLE_500();
550: a26 := JTF_NUMBER_TABLE();
551: a27 := JTF_NUMBER_TABLE();
552: a28 := JTF_DATE_TABLE();
553: a29 := JTF_NUMBER_TABLE();
554: a30 := JTF_DATE_TABLE();
555: a31 := JTF_NUMBER_TABLE();
556: if t.count > 0 then
557: a0.extend(t.count);
551: a27 := JTF_NUMBER_TABLE();
552: a28 := JTF_DATE_TABLE();
553: a29 := JTF_NUMBER_TABLE();
554: a30 := JTF_DATE_TABLE();
555: a31 := JTF_NUMBER_TABLE();
556: if t.count > 0 then
557: a0.extend(t.count);
558: a1.extend(t.count);
559: a2.extend(t.count);
802: , p_init_msg_list VARCHAR2
803: , x_return_status out nocopy VARCHAR2
804: , x_msg_count out nocopy NUMBER
805: , x_msg_data out nocopy VARCHAR2
806: , p5_a0 JTF_NUMBER_TABLE
807: , p5_a1 JTF_NUMBER_TABLE
808: , p5_a2 JTF_VARCHAR2_TABLE_100
809: , p5_a3 JTF_VARCHAR2_TABLE_100
810: , p5_a4 JTF_VARCHAR2_TABLE_200
803: , x_return_status out nocopy VARCHAR2
804: , x_msg_count out nocopy NUMBER
805: , x_msg_data out nocopy VARCHAR2
806: , p5_a0 JTF_NUMBER_TABLE
807: , p5_a1 JTF_NUMBER_TABLE
808: , p5_a2 JTF_VARCHAR2_TABLE_100
809: , p5_a3 JTF_VARCHAR2_TABLE_100
810: , p5_a4 JTF_VARCHAR2_TABLE_200
811: , p5_a5 JTF_VARCHAR2_TABLE_2000
828: , p5_a22 JTF_VARCHAR2_TABLE_500
829: , p5_a23 JTF_VARCHAR2_TABLE_500
830: , p5_a24 JTF_VARCHAR2_TABLE_500
831: , p5_a25 JTF_VARCHAR2_TABLE_500
832: , p5_a26 JTF_NUMBER_TABLE
833: , p5_a27 JTF_NUMBER_TABLE
834: , p5_a28 JTF_DATE_TABLE
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
829: , p5_a23 JTF_VARCHAR2_TABLE_500
830: , p5_a24 JTF_VARCHAR2_TABLE_500
831: , p5_a25 JTF_VARCHAR2_TABLE_500
832: , p5_a26 JTF_NUMBER_TABLE
833: , p5_a27 JTF_NUMBER_TABLE
834: , p5_a28 JTF_DATE_TABLE
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
837: , p5_a31 JTF_NUMBER_TABLE
831: , p5_a25 JTF_VARCHAR2_TABLE_500
832: , p5_a26 JTF_NUMBER_TABLE
833: , p5_a27 JTF_NUMBER_TABLE
834: , p5_a28 JTF_DATE_TABLE
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
837: , p5_a31 JTF_NUMBER_TABLE
838: , p6_a0 out nocopy JTF_NUMBER_TABLE
839: , p6_a1 out nocopy JTF_NUMBER_TABLE
833: , p5_a27 JTF_NUMBER_TABLE
834: , p5_a28 JTF_DATE_TABLE
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
837: , p5_a31 JTF_NUMBER_TABLE
838: , p6_a0 out nocopy JTF_NUMBER_TABLE
839: , p6_a1 out nocopy JTF_NUMBER_TABLE
840: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
841: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
834: , p5_a28 JTF_DATE_TABLE
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
837: , p5_a31 JTF_NUMBER_TABLE
838: , p6_a0 out nocopy JTF_NUMBER_TABLE
839: , p6_a1 out nocopy JTF_NUMBER_TABLE
840: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
841: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
835: , p5_a29 JTF_NUMBER_TABLE
836: , p5_a30 JTF_DATE_TABLE
837: , p5_a31 JTF_NUMBER_TABLE
838: , p6_a0 out nocopy JTF_NUMBER_TABLE
839: , p6_a1 out nocopy JTF_NUMBER_TABLE
840: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
841: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
843: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
860: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
861: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
863: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a26 out nocopy JTF_NUMBER_TABLE
865: , p6_a27 out nocopy JTF_NUMBER_TABLE
866: , p6_a28 out nocopy JTF_DATE_TABLE
867: , p6_a29 out nocopy JTF_NUMBER_TABLE
868: , p6_a30 out nocopy JTF_DATE_TABLE
861: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
863: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a26 out nocopy JTF_NUMBER_TABLE
865: , p6_a27 out nocopy JTF_NUMBER_TABLE
866: , p6_a28 out nocopy JTF_DATE_TABLE
867: , p6_a29 out nocopy JTF_NUMBER_TABLE
868: , p6_a30 out nocopy JTF_DATE_TABLE
869: , p6_a31 out nocopy JTF_NUMBER_TABLE
863: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a26 out nocopy JTF_NUMBER_TABLE
865: , p6_a27 out nocopy JTF_NUMBER_TABLE
866: , p6_a28 out nocopy JTF_DATE_TABLE
867: , p6_a29 out nocopy JTF_NUMBER_TABLE
868: , p6_a30 out nocopy JTF_DATE_TABLE
869: , p6_a31 out nocopy JTF_NUMBER_TABLE
870: )
871:
865: , p6_a27 out nocopy JTF_NUMBER_TABLE
866: , p6_a28 out nocopy JTF_DATE_TABLE
867: , p6_a29 out nocopy JTF_NUMBER_TABLE
868: , p6_a30 out nocopy JTF_DATE_TABLE
869: , p6_a31 out nocopy JTF_NUMBER_TABLE
870: )
871:
872: as
873: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1070: , p_init_msg_list VARCHAR2
1071: , x_return_status out nocopy VARCHAR2
1072: , x_msg_count out nocopy NUMBER
1073: , x_msg_data out nocopy VARCHAR2
1074: , p5_a0 JTF_NUMBER_TABLE
1075: , p5_a1 JTF_NUMBER_TABLE
1076: , p5_a2 JTF_VARCHAR2_TABLE_100
1077: , p5_a3 JTF_VARCHAR2_TABLE_100
1078: , p5_a4 JTF_VARCHAR2_TABLE_200
1071: , x_return_status out nocopy VARCHAR2
1072: , x_msg_count out nocopy NUMBER
1073: , x_msg_data out nocopy VARCHAR2
1074: , p5_a0 JTF_NUMBER_TABLE
1075: , p5_a1 JTF_NUMBER_TABLE
1076: , p5_a2 JTF_VARCHAR2_TABLE_100
1077: , p5_a3 JTF_VARCHAR2_TABLE_100
1078: , p5_a4 JTF_VARCHAR2_TABLE_200
1079: , p5_a5 JTF_VARCHAR2_TABLE_2000
1096: , p5_a22 JTF_VARCHAR2_TABLE_500
1097: , p5_a23 JTF_VARCHAR2_TABLE_500
1098: , p5_a24 JTF_VARCHAR2_TABLE_500
1099: , p5_a25 JTF_VARCHAR2_TABLE_500
1100: , p5_a26 JTF_NUMBER_TABLE
1101: , p5_a27 JTF_NUMBER_TABLE
1102: , p5_a28 JTF_DATE_TABLE
1103: , p5_a29 JTF_NUMBER_TABLE
1104: , p5_a30 JTF_DATE_TABLE
1097: , p5_a23 JTF_VARCHAR2_TABLE_500
1098: , p5_a24 JTF_VARCHAR2_TABLE_500
1099: , p5_a25 JTF_VARCHAR2_TABLE_500
1100: , p5_a26 JTF_NUMBER_TABLE
1101: , p5_a27 JTF_NUMBER_TABLE
1102: , p5_a28 JTF_DATE_TABLE
1103: , p5_a29 JTF_NUMBER_TABLE
1104: , p5_a30 JTF_DATE_TABLE
1105: , p5_a31 JTF_NUMBER_TABLE
1099: , p5_a25 JTF_VARCHAR2_TABLE_500
1100: , p5_a26 JTF_NUMBER_TABLE
1101: , p5_a27 JTF_NUMBER_TABLE
1102: , p5_a28 JTF_DATE_TABLE
1103: , p5_a29 JTF_NUMBER_TABLE
1104: , p5_a30 JTF_DATE_TABLE
1105: , p5_a31 JTF_NUMBER_TABLE
1106: )
1107:
1101: , p5_a27 JTF_NUMBER_TABLE
1102: , p5_a28 JTF_DATE_TABLE
1103: , p5_a29 JTF_NUMBER_TABLE
1104: , p5_a30 JTF_DATE_TABLE
1105: , p5_a31 JTF_NUMBER_TABLE
1106: )
1107:
1108: as
1109: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1337: , p_init_msg_list VARCHAR2
1338: , x_return_status out nocopy VARCHAR2
1339: , x_msg_count out nocopy NUMBER
1340: , x_msg_data out nocopy VARCHAR2
1341: , p5_a0 JTF_NUMBER_TABLE
1342: , p5_a1 JTF_NUMBER_TABLE
1343: , p5_a2 JTF_VARCHAR2_TABLE_100
1344: , p5_a3 JTF_VARCHAR2_TABLE_100
1345: , p5_a4 JTF_VARCHAR2_TABLE_200
1338: , x_return_status out nocopy VARCHAR2
1339: , x_msg_count out nocopy NUMBER
1340: , x_msg_data out nocopy VARCHAR2
1341: , p5_a0 JTF_NUMBER_TABLE
1342: , p5_a1 JTF_NUMBER_TABLE
1343: , p5_a2 JTF_VARCHAR2_TABLE_100
1344: , p5_a3 JTF_VARCHAR2_TABLE_100
1345: , p5_a4 JTF_VARCHAR2_TABLE_200
1346: , p5_a5 JTF_VARCHAR2_TABLE_2000
1363: , p5_a22 JTF_VARCHAR2_TABLE_500
1364: , p5_a23 JTF_VARCHAR2_TABLE_500
1365: , p5_a24 JTF_VARCHAR2_TABLE_500
1366: , p5_a25 JTF_VARCHAR2_TABLE_500
1367: , p5_a26 JTF_NUMBER_TABLE
1368: , p5_a27 JTF_NUMBER_TABLE
1369: , p5_a28 JTF_DATE_TABLE
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1364: , p5_a23 JTF_VARCHAR2_TABLE_500
1365: , p5_a24 JTF_VARCHAR2_TABLE_500
1366: , p5_a25 JTF_VARCHAR2_TABLE_500
1367: , p5_a26 JTF_NUMBER_TABLE
1368: , p5_a27 JTF_NUMBER_TABLE
1369: , p5_a28 JTF_DATE_TABLE
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1372: , p5_a31 JTF_NUMBER_TABLE
1366: , p5_a25 JTF_VARCHAR2_TABLE_500
1367: , p5_a26 JTF_NUMBER_TABLE
1368: , p5_a27 JTF_NUMBER_TABLE
1369: , p5_a28 JTF_DATE_TABLE
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1372: , p5_a31 JTF_NUMBER_TABLE
1373: , p6_a0 out nocopy JTF_NUMBER_TABLE
1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1368: , p5_a27 JTF_NUMBER_TABLE
1369: , p5_a28 JTF_DATE_TABLE
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1372: , p5_a31 JTF_NUMBER_TABLE
1373: , p6_a0 out nocopy JTF_NUMBER_TABLE
1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1369: , p5_a28 JTF_DATE_TABLE
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1372: , p5_a31 JTF_NUMBER_TABLE
1373: , p6_a0 out nocopy JTF_NUMBER_TABLE
1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1370: , p5_a29 JTF_NUMBER_TABLE
1371: , p5_a30 JTF_DATE_TABLE
1372: , p5_a31 JTF_NUMBER_TABLE
1373: , p6_a0 out nocopy JTF_NUMBER_TABLE
1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1397: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1398: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1399: , p6_a26 out nocopy JTF_NUMBER_TABLE
1400: , p6_a27 out nocopy JTF_NUMBER_TABLE
1401: , p6_a28 out nocopy JTF_DATE_TABLE
1402: , p6_a29 out nocopy JTF_NUMBER_TABLE
1403: , p6_a30 out nocopy JTF_DATE_TABLE
1396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1397: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1398: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1399: , p6_a26 out nocopy JTF_NUMBER_TABLE
1400: , p6_a27 out nocopy JTF_NUMBER_TABLE
1401: , p6_a28 out nocopy JTF_DATE_TABLE
1402: , p6_a29 out nocopy JTF_NUMBER_TABLE
1403: , p6_a30 out nocopy JTF_DATE_TABLE
1404: , p6_a31 out nocopy JTF_NUMBER_TABLE
1398: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1399: , p6_a26 out nocopy JTF_NUMBER_TABLE
1400: , p6_a27 out nocopy JTF_NUMBER_TABLE
1401: , p6_a28 out nocopy JTF_DATE_TABLE
1402: , p6_a29 out nocopy JTF_NUMBER_TABLE
1403: , p6_a30 out nocopy JTF_DATE_TABLE
1404: , p6_a31 out nocopy JTF_NUMBER_TABLE
1405: )
1406:
1400: , p6_a27 out nocopy JTF_NUMBER_TABLE
1401: , p6_a28 out nocopy JTF_DATE_TABLE
1402: , p6_a29 out nocopy JTF_NUMBER_TABLE
1403: , p6_a30 out nocopy JTF_DATE_TABLE
1404: , p6_a31 out nocopy JTF_NUMBER_TABLE
1405: )
1406:
1407: as
1408: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1605: , p_init_msg_list VARCHAR2
1606: , x_return_status out nocopy VARCHAR2
1607: , x_msg_count out nocopy NUMBER
1608: , x_msg_data out nocopy VARCHAR2
1609: , p5_a0 JTF_NUMBER_TABLE
1610: , p5_a1 JTF_NUMBER_TABLE
1611: , p5_a2 JTF_VARCHAR2_TABLE_100
1612: , p5_a3 JTF_VARCHAR2_TABLE_100
1613: , p5_a4 JTF_VARCHAR2_TABLE_200
1606: , x_return_status out nocopy VARCHAR2
1607: , x_msg_count out nocopy NUMBER
1608: , x_msg_data out nocopy VARCHAR2
1609: , p5_a0 JTF_NUMBER_TABLE
1610: , p5_a1 JTF_NUMBER_TABLE
1611: , p5_a2 JTF_VARCHAR2_TABLE_100
1612: , p5_a3 JTF_VARCHAR2_TABLE_100
1613: , p5_a4 JTF_VARCHAR2_TABLE_200
1614: , p5_a5 JTF_VARCHAR2_TABLE_2000
1631: , p5_a22 JTF_VARCHAR2_TABLE_500
1632: , p5_a23 JTF_VARCHAR2_TABLE_500
1633: , p5_a24 JTF_VARCHAR2_TABLE_500
1634: , p5_a25 JTF_VARCHAR2_TABLE_500
1635: , p5_a26 JTF_NUMBER_TABLE
1636: , p5_a27 JTF_NUMBER_TABLE
1637: , p5_a28 JTF_DATE_TABLE
1638: , p5_a29 JTF_NUMBER_TABLE
1639: , p5_a30 JTF_DATE_TABLE
1632: , p5_a23 JTF_VARCHAR2_TABLE_500
1633: , p5_a24 JTF_VARCHAR2_TABLE_500
1634: , p5_a25 JTF_VARCHAR2_TABLE_500
1635: , p5_a26 JTF_NUMBER_TABLE
1636: , p5_a27 JTF_NUMBER_TABLE
1637: , p5_a28 JTF_DATE_TABLE
1638: , p5_a29 JTF_NUMBER_TABLE
1639: , p5_a30 JTF_DATE_TABLE
1640: , p5_a31 JTF_NUMBER_TABLE
1634: , p5_a25 JTF_VARCHAR2_TABLE_500
1635: , p5_a26 JTF_NUMBER_TABLE
1636: , p5_a27 JTF_NUMBER_TABLE
1637: , p5_a28 JTF_DATE_TABLE
1638: , p5_a29 JTF_NUMBER_TABLE
1639: , p5_a30 JTF_DATE_TABLE
1640: , p5_a31 JTF_NUMBER_TABLE
1641: )
1642:
1636: , p5_a27 JTF_NUMBER_TABLE
1637: , p5_a28 JTF_DATE_TABLE
1638: , p5_a29 JTF_NUMBER_TABLE
1639: , p5_a30 JTF_DATE_TABLE
1640: , p5_a31 JTF_NUMBER_TABLE
1641: )
1642:
1643: as
1644: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;
1804: , p_init_msg_list VARCHAR2
1805: , x_return_status out nocopy VARCHAR2
1806: , x_msg_count out nocopy NUMBER
1807: , x_msg_data out nocopy VARCHAR2
1808: , p5_a0 JTF_NUMBER_TABLE
1809: , p5_a1 JTF_NUMBER_TABLE
1810: , p5_a2 JTF_VARCHAR2_TABLE_100
1811: , p5_a3 JTF_VARCHAR2_TABLE_100
1812: , p5_a4 JTF_VARCHAR2_TABLE_200
1805: , x_return_status out nocopy VARCHAR2
1806: , x_msg_count out nocopy NUMBER
1807: , x_msg_data out nocopy VARCHAR2
1808: , p5_a0 JTF_NUMBER_TABLE
1809: , p5_a1 JTF_NUMBER_TABLE
1810: , p5_a2 JTF_VARCHAR2_TABLE_100
1811: , p5_a3 JTF_VARCHAR2_TABLE_100
1812: , p5_a4 JTF_VARCHAR2_TABLE_200
1813: , p5_a5 JTF_VARCHAR2_TABLE_2000
1830: , p5_a22 JTF_VARCHAR2_TABLE_500
1831: , p5_a23 JTF_VARCHAR2_TABLE_500
1832: , p5_a24 JTF_VARCHAR2_TABLE_500
1833: , p5_a25 JTF_VARCHAR2_TABLE_500
1834: , p5_a26 JTF_NUMBER_TABLE
1835: , p5_a27 JTF_NUMBER_TABLE
1836: , p5_a28 JTF_DATE_TABLE
1837: , p5_a29 JTF_NUMBER_TABLE
1838: , p5_a30 JTF_DATE_TABLE
1831: , p5_a23 JTF_VARCHAR2_TABLE_500
1832: , p5_a24 JTF_VARCHAR2_TABLE_500
1833: , p5_a25 JTF_VARCHAR2_TABLE_500
1834: , p5_a26 JTF_NUMBER_TABLE
1835: , p5_a27 JTF_NUMBER_TABLE
1836: , p5_a28 JTF_DATE_TABLE
1837: , p5_a29 JTF_NUMBER_TABLE
1838: , p5_a30 JTF_DATE_TABLE
1839: , p5_a31 JTF_NUMBER_TABLE
1833: , p5_a25 JTF_VARCHAR2_TABLE_500
1834: , p5_a26 JTF_NUMBER_TABLE
1835: , p5_a27 JTF_NUMBER_TABLE
1836: , p5_a28 JTF_DATE_TABLE
1837: , p5_a29 JTF_NUMBER_TABLE
1838: , p5_a30 JTF_DATE_TABLE
1839: , p5_a31 JTF_NUMBER_TABLE
1840: )
1841:
1835: , p5_a27 JTF_NUMBER_TABLE
1836: , p5_a28 JTF_DATE_TABLE
1837: , p5_a29 JTF_NUMBER_TABLE
1838: , p5_a30 JTF_DATE_TABLE
1839: , p5_a31 JTF_NUMBER_TABLE
1840: )
1841:
1842: as
1843: ddp_dsfv_tbl okl_dsf_pvt.dsfv_tbl_type;