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_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_siy_pvt.siy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_VARCHAR2_TABLE_500
50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_DATE_TABLE
55: , a33 JTF_NUMBER_TABLE
48: , a26 JTF_VARCHAR2_TABLE_500
49: , a27 JTF_VARCHAR2_TABLE_500
50: , a28 JTF_VARCHAR2_TABLE_500
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_DATE_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_DATE_TABLE
55: , a33 JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if a0 is not null and a0.count > 0 then
103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: end if;
105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_VARCHAR2_TABLE_100
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_siy_pvt.siy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_VARCHAR2_TABLE_100
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_VARCHAR2_TABLE_100
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_VARCHAR2_TABLE_100
119: , a12 out nocopy JTF_VARCHAR2_TABLE_100
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_VARCHAR2_TABLE_100
119: , a12 out nocopy JTF_VARCHAR2_TABLE_100
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
121: , a14 out nocopy JTF_VARCHAR2_TABLE_500
132: , a25 out nocopy JTF_VARCHAR2_TABLE_500
133: , a26 out nocopy JTF_VARCHAR2_TABLE_500
134: , a27 out nocopy JTF_VARCHAR2_TABLE_500
135: , a28 out nocopy JTF_VARCHAR2_TABLE_500
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
133: , a26 out nocopy JTF_VARCHAR2_TABLE_500
134: , a27 out nocopy JTF_VARCHAR2_TABLE_500
135: , a28 out nocopy JTF_VARCHAR2_TABLE_500
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as
136: , a29 out nocopy JTF_NUMBER_TABLE
137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_DATE_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_VARCHAR2_TABLE_100();
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_VARCHAR2_TABLE_100();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_100();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_500();
170: a25 := JTF_VARCHAR2_TABLE_500();
171: a26 := JTF_VARCHAR2_TABLE_500();
172: a27 := JTF_VARCHAR2_TABLE_500();
173: a28 := JTF_VARCHAR2_TABLE_500();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
171: a26 := JTF_VARCHAR2_TABLE_500();
172: a27 := JTF_VARCHAR2_TABLE_500();
173: a28 := JTF_VARCHAR2_TABLE_500();
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
174: a29 := JTF_NUMBER_TABLE();
175: a30 := JTF_NUMBER_TABLE();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
176: a31 := JTF_DATE_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();
188: a8 := JTF_VARCHAR2_TABLE_100();
189: a9 := JTF_NUMBER_TABLE();
190: a10 := JTF_NUMBER_TABLE();
191: a11 := JTF_VARCHAR2_TABLE_100();
192: a12 := JTF_VARCHAR2_TABLE_100();
193: a13 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_VARCHAR2_TABLE_100();
187: a7 := JTF_VARCHAR2_TABLE_100();
188: a8 := JTF_VARCHAR2_TABLE_100();
189: a9 := JTF_NUMBER_TABLE();
190: a10 := JTF_NUMBER_TABLE();
191: a11 := JTF_VARCHAR2_TABLE_100();
192: a12 := JTF_VARCHAR2_TABLE_100();
193: a13 := JTF_VARCHAR2_TABLE_100();
194: a14 := JTF_VARCHAR2_TABLE_500();
205: a25 := JTF_VARCHAR2_TABLE_500();
206: a26 := JTF_VARCHAR2_TABLE_500();
207: a27 := JTF_VARCHAR2_TABLE_500();
208: a28 := JTF_VARCHAR2_TABLE_500();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();
206: a26 := JTF_VARCHAR2_TABLE_500();
207: a27 := JTF_VARCHAR2_TABLE_500();
208: a28 := JTF_VARCHAR2_TABLE_500();
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then
209: a29 := JTF_NUMBER_TABLE();
210: a30 := JTF_NUMBER_TABLE();
211: a31 := JTF_DATE_TABLE();
212: a32 := JTF_DATE_TABLE();
213: a33 := JTF_NUMBER_TABLE();
214: if t.count > 0 then
215: a0.extend(t.count);
216: a1.extend(t.count);
217: a2.extend(t.count);
292: end if;
293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100
293: end if;
294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100
301: , a5 JTF_VARCHAR2_TABLE_100
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_siy_pvt.siyv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_VARCHAR2_TABLE_100
301: , a5 JTF_VARCHAR2_TABLE_100
302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100
301: , a5 JTF_VARCHAR2_TABLE_100
302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100
304: , a8 JTF_VARCHAR2_TABLE_100
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_NUMBER_TABLE
307: , a11 JTF_VARCHAR2_TABLE_100
308: , a12 JTF_VARCHAR2_TABLE_100
309: , a13 JTF_VARCHAR2_TABLE_100
302: , a6 JTF_VARCHAR2_TABLE_100
303: , a7 JTF_VARCHAR2_TABLE_100
304: , a8 JTF_VARCHAR2_TABLE_100
305: , a9 JTF_NUMBER_TABLE
306: , a10 JTF_NUMBER_TABLE
307: , a11 JTF_VARCHAR2_TABLE_100
308: , a12 JTF_VARCHAR2_TABLE_100
309: , a13 JTF_VARCHAR2_TABLE_100
310: , a14 JTF_VARCHAR2_TABLE_500
321: , a25 JTF_VARCHAR2_TABLE_500
322: , a26 JTF_VARCHAR2_TABLE_500
323: , a27 JTF_VARCHAR2_TABLE_500
324: , a28 JTF_VARCHAR2_TABLE_500
325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE
322: , a26 JTF_VARCHAR2_TABLE_500
323: , a27 JTF_VARCHAR2_TABLE_500
324: , a28 JTF_VARCHAR2_TABLE_500
325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE
330: ) as
325: , a29 JTF_NUMBER_TABLE
326: , a30 JTF_NUMBER_TABLE
327: , a31 JTF_DATE_TABLE
328: , a32 JTF_DATE_TABLE
329: , a33 JTF_NUMBER_TABLE
330: ) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if a0 is not null and a0.count > 0 then
377: end loop;
378: end if;
379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100
378: end if;
379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100
386: , a5 out nocopy JTF_VARCHAR2_TABLE_100
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_siy_pvt.siyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_VARCHAR2_TABLE_100
386: , a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100
386: , a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100
389: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a9 out nocopy JTF_NUMBER_TABLE
391: , a10 out nocopy JTF_NUMBER_TABLE
392: , a11 out nocopy JTF_VARCHAR2_TABLE_100
393: , a12 out nocopy JTF_VARCHAR2_TABLE_100
394: , a13 out nocopy JTF_VARCHAR2_TABLE_100
387: , a6 out nocopy JTF_VARCHAR2_TABLE_100
388: , a7 out nocopy JTF_VARCHAR2_TABLE_100
389: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a9 out nocopy JTF_NUMBER_TABLE
391: , a10 out nocopy JTF_NUMBER_TABLE
392: , a11 out nocopy JTF_VARCHAR2_TABLE_100
393: , a12 out nocopy JTF_VARCHAR2_TABLE_100
394: , a13 out nocopy JTF_VARCHAR2_TABLE_100
395: , a14 out nocopy JTF_VARCHAR2_TABLE_500
406: , a25 out nocopy JTF_VARCHAR2_TABLE_500
407: , a26 out nocopy JTF_VARCHAR2_TABLE_500
408: , a27 out nocopy JTF_VARCHAR2_TABLE_500
409: , a28 out nocopy JTF_VARCHAR2_TABLE_500
410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE
407: , a26 out nocopy JTF_VARCHAR2_TABLE_500
408: , a27 out nocopy JTF_VARCHAR2_TABLE_500
409: , a28 out nocopy JTF_VARCHAR2_TABLE_500
410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE
415: ) as
410: , a29 out nocopy JTF_NUMBER_TABLE
411: , a30 out nocopy JTF_NUMBER_TABLE
412: , a31 out nocopy JTF_DATE_TABLE
413: , a32 out nocopy JTF_DATE_TABLE
414: , a33 out nocopy JTF_NUMBER_TABLE
415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_VARCHAR2_TABLE_100();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_VARCHAR2_TABLE_100();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_VARCHAR2_TABLE_100();
433: a14 := JTF_VARCHAR2_TABLE_500();
444: a25 := JTF_VARCHAR2_TABLE_500();
445: a26 := JTF_VARCHAR2_TABLE_500();
446: a27 := JTF_VARCHAR2_TABLE_500();
447: a28 := JTF_VARCHAR2_TABLE_500();
448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
445: a26 := JTF_VARCHAR2_TABLE_500();
446: a27 := JTF_VARCHAR2_TABLE_500();
447: a28 := JTF_VARCHAR2_TABLE_500();
448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
448: a29 := JTF_NUMBER_TABLE();
449: a30 := JTF_NUMBER_TABLE();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
450: a31 := JTF_DATE_TABLE();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();
451: a32 := JTF_DATE_TABLE();
452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();
459: a5 := JTF_VARCHAR2_TABLE_100();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_100();
459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();
459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();
462: a8 := JTF_VARCHAR2_TABLE_100();
463: a9 := JTF_NUMBER_TABLE();
464: a10 := JTF_NUMBER_TABLE();
465: a11 := JTF_VARCHAR2_TABLE_100();
466: a12 := JTF_VARCHAR2_TABLE_100();
467: a13 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_100();
461: a7 := JTF_VARCHAR2_TABLE_100();
462: a8 := JTF_VARCHAR2_TABLE_100();
463: a9 := JTF_NUMBER_TABLE();
464: a10 := JTF_NUMBER_TABLE();
465: a11 := JTF_VARCHAR2_TABLE_100();
466: a12 := JTF_VARCHAR2_TABLE_100();
467: a13 := JTF_VARCHAR2_TABLE_100();
468: a14 := JTF_VARCHAR2_TABLE_500();
479: a25 := JTF_VARCHAR2_TABLE_500();
480: a26 := JTF_VARCHAR2_TABLE_500();
481: a27 := JTF_VARCHAR2_TABLE_500();
482: a28 := JTF_VARCHAR2_TABLE_500();
483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();
480: a26 := JTF_VARCHAR2_TABLE_500();
481: a27 := JTF_VARCHAR2_TABLE_500();
482: a28 := JTF_VARCHAR2_TABLE_500();
483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();
488: if t.count > 0 then
483: a29 := JTF_NUMBER_TABLE();
484: a30 := JTF_NUMBER_TABLE();
485: a31 := JTF_DATE_TABLE();
486: a32 := JTF_DATE_TABLE();
487: a33 := JTF_NUMBER_TABLE();
488: if t.count > 0 then
489: a0.extend(t.count);
490: a1.extend(t.count);
491: a2.extend(t.count);
746: , p_init_msg_list VARCHAR2
747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100
747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100
755: , p5_a5 JTF_VARCHAR2_TABLE_100
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_100
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100
758: , p5_a8 JTF_VARCHAR2_TABLE_100
759: , p5_a9 JTF_NUMBER_TABLE
760: , p5_a10 JTF_NUMBER_TABLE
761: , p5_a11 JTF_VARCHAR2_TABLE_100
762: , p5_a12 JTF_VARCHAR2_TABLE_100
763: , p5_a13 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_100
758: , p5_a8 JTF_VARCHAR2_TABLE_100
759: , p5_a9 JTF_NUMBER_TABLE
760: , p5_a10 JTF_NUMBER_TABLE
761: , p5_a11 JTF_VARCHAR2_TABLE_100
762: , p5_a12 JTF_VARCHAR2_TABLE_100
763: , p5_a13 JTF_VARCHAR2_TABLE_100
764: , p5_a14 JTF_VARCHAR2_TABLE_500
775: , p5_a25 JTF_VARCHAR2_TABLE_500
776: , p5_a26 JTF_VARCHAR2_TABLE_500
777: , p5_a27 JTF_VARCHAR2_TABLE_500
778: , p5_a28 JTF_VARCHAR2_TABLE_500
779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
776: , p5_a26 JTF_VARCHAR2_TABLE_500
777: , p5_a27 JTF_VARCHAR2_TABLE_500
778: , p5_a28 JTF_VARCHAR2_TABLE_500
779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
779: , p5_a29 JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
780: , p5_a30 JTF_NUMBER_TABLE
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
781: , p5_a31 JTF_DATE_TABLE
782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_NUMBER_TABLE
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
791: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a9 out nocopy JTF_NUMBER_TABLE
794: , p6_a10 out nocopy JTF_NUMBER_TABLE
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
798: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
812: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
812: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE
818: )
813: , p6_a29 out nocopy JTF_NUMBER_TABLE
814: , p6_a30 out nocopy JTF_NUMBER_TABLE
815: , p6_a31 out nocopy JTF_DATE_TABLE
816: , p6_a32 out nocopy JTF_DATE_TABLE
817: , p6_a33 out nocopy JTF_NUMBER_TABLE
818: )
819:
820: as
821: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;
1026: , p_init_msg_list VARCHAR2
1027: , x_return_status out nocopy VARCHAR2
1028: , x_msg_count out nocopy NUMBER
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100
1027: , x_return_status out nocopy VARCHAR2
1028: , x_msg_count out nocopy NUMBER
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100
1035: , p5_a5 JTF_VARCHAR2_TABLE_100
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_VARCHAR2_TABLE_100
1035: , p5_a5 JTF_VARCHAR2_TABLE_100
1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100
1035: , p5_a5 JTF_VARCHAR2_TABLE_100
1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100
1038: , p5_a8 JTF_VARCHAR2_TABLE_100
1039: , p5_a9 JTF_NUMBER_TABLE
1040: , p5_a10 JTF_NUMBER_TABLE
1041: , p5_a11 JTF_VARCHAR2_TABLE_100
1042: , p5_a12 JTF_VARCHAR2_TABLE_100
1043: , p5_a13 JTF_VARCHAR2_TABLE_100
1036: , p5_a6 JTF_VARCHAR2_TABLE_100
1037: , p5_a7 JTF_VARCHAR2_TABLE_100
1038: , p5_a8 JTF_VARCHAR2_TABLE_100
1039: , p5_a9 JTF_NUMBER_TABLE
1040: , p5_a10 JTF_NUMBER_TABLE
1041: , p5_a11 JTF_VARCHAR2_TABLE_100
1042: , p5_a12 JTF_VARCHAR2_TABLE_100
1043: , p5_a13 JTF_VARCHAR2_TABLE_100
1044: , p5_a14 JTF_VARCHAR2_TABLE_500
1055: , p5_a25 JTF_VARCHAR2_TABLE_500
1056: , p5_a26 JTF_VARCHAR2_TABLE_500
1057: , p5_a27 JTF_VARCHAR2_TABLE_500
1058: , p5_a28 JTF_VARCHAR2_TABLE_500
1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE
1056: , p5_a26 JTF_VARCHAR2_TABLE_500
1057: , p5_a27 JTF_VARCHAR2_TABLE_500
1058: , p5_a28 JTF_VARCHAR2_TABLE_500
1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE
1064: )
1059: , p5_a29 JTF_NUMBER_TABLE
1060: , p5_a30 JTF_NUMBER_TABLE
1061: , p5_a31 JTF_DATE_TABLE
1062: , p5_a32 JTF_DATE_TABLE
1063: , p5_a33 JTF_NUMBER_TABLE
1064: )
1065:
1066: as
1067: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;
1305: , p_init_msg_list VARCHAR2
1306: , x_return_status out nocopy VARCHAR2
1307: , x_msg_count out nocopy NUMBER
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100
1306: , x_return_status out nocopy VARCHAR2
1307: , x_msg_count out nocopy NUMBER
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100
1314: , p5_a5 JTF_VARCHAR2_TABLE_100
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_VARCHAR2_TABLE_100
1314: , p5_a5 JTF_VARCHAR2_TABLE_100
1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100
1314: , p5_a5 JTF_VARCHAR2_TABLE_100
1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100
1317: , p5_a8 JTF_VARCHAR2_TABLE_100
1318: , p5_a9 JTF_NUMBER_TABLE
1319: , p5_a10 JTF_NUMBER_TABLE
1320: , p5_a11 JTF_VARCHAR2_TABLE_100
1321: , p5_a12 JTF_VARCHAR2_TABLE_100
1322: , p5_a13 JTF_VARCHAR2_TABLE_100
1315: , p5_a6 JTF_VARCHAR2_TABLE_100
1316: , p5_a7 JTF_VARCHAR2_TABLE_100
1317: , p5_a8 JTF_VARCHAR2_TABLE_100
1318: , p5_a9 JTF_NUMBER_TABLE
1319: , p5_a10 JTF_NUMBER_TABLE
1320: , p5_a11 JTF_VARCHAR2_TABLE_100
1321: , p5_a12 JTF_VARCHAR2_TABLE_100
1322: , p5_a13 JTF_VARCHAR2_TABLE_100
1323: , p5_a14 JTF_VARCHAR2_TABLE_500
1334: , p5_a25 JTF_VARCHAR2_TABLE_500
1335: , p5_a26 JTF_VARCHAR2_TABLE_500
1336: , p5_a27 JTF_VARCHAR2_TABLE_500
1337: , p5_a28 JTF_VARCHAR2_TABLE_500
1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1335: , p5_a26 JTF_VARCHAR2_TABLE_500
1336: , p5_a27 JTF_VARCHAR2_TABLE_500
1337: , p5_a28 JTF_VARCHAR2_TABLE_500
1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1338: , p5_a29 JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1339: , p5_a30 JTF_NUMBER_TABLE
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1340: , p5_a31 JTF_DATE_TABLE
1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1348: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a9 out nocopy JTF_NUMBER_TABLE
1353: , p6_a10 out nocopy JTF_NUMBER_TABLE
1354: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1355: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1349: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a9 out nocopy JTF_NUMBER_TABLE
1353: , p6_a10 out nocopy JTF_NUMBER_TABLE
1354: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1355: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1357: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1368: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1369: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1370: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1371: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1369: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1370: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1371: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1377: )
1372: , p6_a29 out nocopy JTF_NUMBER_TABLE
1373: , p6_a30 out nocopy JTF_NUMBER_TABLE
1374: , p6_a31 out nocopy JTF_DATE_TABLE
1375: , p6_a32 out nocopy JTF_DATE_TABLE
1376: , p6_a33 out nocopy JTF_NUMBER_TABLE
1377: )
1378:
1379: as
1380: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;
1585: , p_init_msg_list VARCHAR2
1586: , x_return_status out nocopy VARCHAR2
1587: , x_msg_count out nocopy NUMBER
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100
1586: , x_return_status out nocopy VARCHAR2
1587: , x_msg_count out nocopy NUMBER
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100
1594: , p5_a5 JTF_VARCHAR2_TABLE_100
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_VARCHAR2_TABLE_100
1594: , p5_a5 JTF_VARCHAR2_TABLE_100
1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100
1594: , p5_a5 JTF_VARCHAR2_TABLE_100
1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100
1597: , p5_a8 JTF_VARCHAR2_TABLE_100
1598: , p5_a9 JTF_NUMBER_TABLE
1599: , p5_a10 JTF_NUMBER_TABLE
1600: , p5_a11 JTF_VARCHAR2_TABLE_100
1601: , p5_a12 JTF_VARCHAR2_TABLE_100
1602: , p5_a13 JTF_VARCHAR2_TABLE_100
1595: , p5_a6 JTF_VARCHAR2_TABLE_100
1596: , p5_a7 JTF_VARCHAR2_TABLE_100
1597: , p5_a8 JTF_VARCHAR2_TABLE_100
1598: , p5_a9 JTF_NUMBER_TABLE
1599: , p5_a10 JTF_NUMBER_TABLE
1600: , p5_a11 JTF_VARCHAR2_TABLE_100
1601: , p5_a12 JTF_VARCHAR2_TABLE_100
1602: , p5_a13 JTF_VARCHAR2_TABLE_100
1603: , p5_a14 JTF_VARCHAR2_TABLE_500
1614: , p5_a25 JTF_VARCHAR2_TABLE_500
1615: , p5_a26 JTF_VARCHAR2_TABLE_500
1616: , p5_a27 JTF_VARCHAR2_TABLE_500
1617: , p5_a28 JTF_VARCHAR2_TABLE_500
1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE
1615: , p5_a26 JTF_VARCHAR2_TABLE_500
1616: , p5_a27 JTF_VARCHAR2_TABLE_500
1617: , p5_a28 JTF_VARCHAR2_TABLE_500
1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE
1623: )
1618: , p5_a29 JTF_NUMBER_TABLE
1619: , p5_a30 JTF_NUMBER_TABLE
1620: , p5_a31 JTF_DATE_TABLE
1621: , p5_a32 JTF_DATE_TABLE
1622: , p5_a33 JTF_NUMBER_TABLE
1623: )
1624:
1625: as
1626: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;
1792: , p_init_msg_list VARCHAR2
1793: , x_return_status out nocopy VARCHAR2
1794: , x_msg_count out nocopy NUMBER
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100
1793: , x_return_status out nocopy VARCHAR2
1794: , x_msg_count out nocopy NUMBER
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100
1801: , p5_a5 JTF_VARCHAR2_TABLE_100
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_VARCHAR2_TABLE_100
1801: , p5_a5 JTF_VARCHAR2_TABLE_100
1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100
1801: , p5_a5 JTF_VARCHAR2_TABLE_100
1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100
1804: , p5_a8 JTF_VARCHAR2_TABLE_100
1805: , p5_a9 JTF_NUMBER_TABLE
1806: , p5_a10 JTF_NUMBER_TABLE
1807: , p5_a11 JTF_VARCHAR2_TABLE_100
1808: , p5_a12 JTF_VARCHAR2_TABLE_100
1809: , p5_a13 JTF_VARCHAR2_TABLE_100
1802: , p5_a6 JTF_VARCHAR2_TABLE_100
1803: , p5_a7 JTF_VARCHAR2_TABLE_100
1804: , p5_a8 JTF_VARCHAR2_TABLE_100
1805: , p5_a9 JTF_NUMBER_TABLE
1806: , p5_a10 JTF_NUMBER_TABLE
1807: , p5_a11 JTF_VARCHAR2_TABLE_100
1808: , p5_a12 JTF_VARCHAR2_TABLE_100
1809: , p5_a13 JTF_VARCHAR2_TABLE_100
1810: , p5_a14 JTF_VARCHAR2_TABLE_500
1821: , p5_a25 JTF_VARCHAR2_TABLE_500
1822: , p5_a26 JTF_VARCHAR2_TABLE_500
1823: , p5_a27 JTF_VARCHAR2_TABLE_500
1824: , p5_a28 JTF_VARCHAR2_TABLE_500
1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE
1822: , p5_a26 JTF_VARCHAR2_TABLE_500
1823: , p5_a27 JTF_VARCHAR2_TABLE_500
1824: , p5_a28 JTF_VARCHAR2_TABLE_500
1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE
1830: )
1825: , p5_a29 JTF_NUMBER_TABLE
1826: , p5_a30 JTF_NUMBER_TABLE
1827: , p5_a31 JTF_DATE_TABLE
1828: , p5_a32 JTF_DATE_TABLE
1829: , p5_a33 JTF_NUMBER_TABLE
1830: )
1831:
1832: as
1833: ddp_siyv_tbl okl_siy_pvt.siyv_tbl_type;