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_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
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_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_DATE_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 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_VARCHAR2_TABLE_500
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if a0 is not null and a0.count > 0 then
97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_DATE_TABLE
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_DATE_TABLE
108: , a7 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_DATE_TABLE
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_VARCHAR2_TABLE_100
110: , a9 out nocopy JTF_VARCHAR2_TABLE_100
111: , a10 out nocopy JTF_VARCHAR2_TABLE_100
112: , a11 out nocopy JTF_VARCHAR2_TABLE_500
123: , a22 out nocopy JTF_VARCHAR2_TABLE_500
124: , a23 out nocopy JTF_VARCHAR2_TABLE_500
125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_VARCHAR2_TABLE_500
127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE
125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_VARCHAR2_TABLE_500
127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_DATE_TABLE();
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_DATE_TABLE();
143: a7 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_DATE_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_500();
158: a22 := JTF_VARCHAR2_TABLE_500();
159: a23 := JTF_VARCHAR2_TABLE_500();
160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_VARCHAR2_TABLE_500();
162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_VARCHAR2_TABLE_500();
162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_NUMBER_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_DATE_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_DATE_TABLE();
175: a7 := JTF_NUMBER_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_DATE_TABLE();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_VARCHAR2_TABLE_100();
177: a9 := JTF_VARCHAR2_TABLE_100();
178: a10 := JTF_VARCHAR2_TABLE_100();
179: a11 := JTF_VARCHAR2_TABLE_500();
190: a22 := JTF_VARCHAR2_TABLE_500();
191: a23 := JTF_VARCHAR2_TABLE_500();
192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_VARCHAR2_TABLE_500();
194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();
192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_VARCHAR2_TABLE_500();
194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);
194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);
201: a1.extend(t.count);
202: a2.extend(t.count);
271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_DATE_TABLE
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_DATE_TABLE
281: , a6 JTF_DATE_TABLE
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_DATE_TABLE
281: , a6 JTF_DATE_TABLE
282: , a7 JTF_NUMBER_TABLE
278: , a3 JTF_NUMBER_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_DATE_TABLE
281: , a6 JTF_DATE_TABLE
282: , a7 JTF_NUMBER_TABLE
283: , a8 JTF_VARCHAR2_TABLE_100
284: , a9 JTF_VARCHAR2_TABLE_100
285: , a10 JTF_VARCHAR2_TABLE_100
286: , a11 JTF_VARCHAR2_TABLE_500
297: , a22 JTF_VARCHAR2_TABLE_500
298: , a23 JTF_VARCHAR2_TABLE_500
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_VARCHAR2_TABLE_500
301: , a26 JTF_NUMBER_TABLE
302: , a27 JTF_DATE_TABLE
303: , a28 JTF_NUMBER_TABLE
304: , a29 JTF_DATE_TABLE
305: , a30 JTF_NUMBER_TABLE
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_VARCHAR2_TABLE_500
301: , a26 JTF_NUMBER_TABLE
302: , a27 JTF_DATE_TABLE
303: , a28 JTF_NUMBER_TABLE
304: , a29 JTF_DATE_TABLE
305: , a30 JTF_NUMBER_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
301: , a26 JTF_NUMBER_TABLE
302: , a27 JTF_DATE_TABLE
303: , a28 JTF_NUMBER_TABLE
304: , a29 JTF_DATE_TABLE
305: , a30 JTF_NUMBER_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin
309: if a0 is not null and a0.count > 0 then
350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_DATE_TABLE
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_DATE_TABLE
360: , a6 out nocopy JTF_DATE_TABLE
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_DATE_TABLE
360: , a6 out nocopy JTF_DATE_TABLE
361: , a7 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_NUMBER_TABLE
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_DATE_TABLE
360: , a6 out nocopy JTF_DATE_TABLE
361: , a7 out nocopy JTF_NUMBER_TABLE
362: , a8 out nocopy JTF_VARCHAR2_TABLE_100
363: , a9 out nocopy JTF_VARCHAR2_TABLE_100
364: , a10 out nocopy JTF_VARCHAR2_TABLE_100
365: , a11 out nocopy JTF_VARCHAR2_TABLE_500
376: , a22 out nocopy JTF_VARCHAR2_TABLE_500
377: , a23 out nocopy JTF_VARCHAR2_TABLE_500
378: , a24 out nocopy JTF_VARCHAR2_TABLE_500
379: , a25 out nocopy JTF_VARCHAR2_TABLE_500
380: , a26 out nocopy JTF_NUMBER_TABLE
381: , a27 out nocopy JTF_DATE_TABLE
382: , a28 out nocopy JTF_NUMBER_TABLE
383: , a29 out nocopy JTF_DATE_TABLE
384: , a30 out nocopy JTF_NUMBER_TABLE
378: , a24 out nocopy JTF_VARCHAR2_TABLE_500
379: , a25 out nocopy JTF_VARCHAR2_TABLE_500
380: , a26 out nocopy JTF_NUMBER_TABLE
381: , a27 out nocopy JTF_DATE_TABLE
382: , a28 out nocopy JTF_NUMBER_TABLE
383: , a29 out nocopy JTF_DATE_TABLE
384: , a30 out nocopy JTF_NUMBER_TABLE
385: ) as
386: ddindx binary_integer; indx binary_integer;
380: , a26 out nocopy JTF_NUMBER_TABLE
381: , a27 out nocopy JTF_DATE_TABLE
382: , a28 out nocopy JTF_NUMBER_TABLE
383: , a29 out nocopy JTF_DATE_TABLE
384: , a30 out nocopy JTF_NUMBER_TABLE
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_NUMBER_TABLE();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_NUMBER_TABLE();
393: a4 := JTF_VARCHAR2_TABLE_100();
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_NUMBER_TABLE();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_NUMBER_TABLE();
393: a4 := JTF_VARCHAR2_TABLE_100();
394: a5 := JTF_DATE_TABLE();
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_NUMBER_TABLE();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_NUMBER_TABLE();
393: a4 := JTF_VARCHAR2_TABLE_100();
394: a5 := JTF_DATE_TABLE();
395: a6 := JTF_DATE_TABLE();
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_NUMBER_TABLE();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_NUMBER_TABLE();
393: a4 := JTF_VARCHAR2_TABLE_100();
394: a5 := JTF_DATE_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
392: a3 := JTF_NUMBER_TABLE();
393: a4 := JTF_VARCHAR2_TABLE_100();
394: a5 := JTF_DATE_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: a9 := JTF_VARCHAR2_TABLE_100();
399: a10 := JTF_VARCHAR2_TABLE_100();
400: a11 := JTF_VARCHAR2_TABLE_500();
411: a22 := JTF_VARCHAR2_TABLE_500();
412: a23 := JTF_VARCHAR2_TABLE_500();
413: a24 := JTF_VARCHAR2_TABLE_500();
414: a25 := JTF_VARCHAR2_TABLE_500();
415: a26 := JTF_NUMBER_TABLE();
416: a27 := JTF_DATE_TABLE();
417: a28 := JTF_NUMBER_TABLE();
418: a29 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
413: a24 := JTF_VARCHAR2_TABLE_500();
414: a25 := JTF_VARCHAR2_TABLE_500();
415: a26 := JTF_NUMBER_TABLE();
416: a27 := JTF_DATE_TABLE();
417: a28 := JTF_NUMBER_TABLE();
418: a29 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
415: a26 := JTF_NUMBER_TABLE();
416: a27 := JTF_DATE_TABLE();
417: a28 := JTF_NUMBER_TABLE();
418: a29 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_NUMBER_TABLE();
417: a28 := JTF_NUMBER_TABLE();
418: a29 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_NUMBER_TABLE();
425: a4 := JTF_VARCHAR2_TABLE_100();
418: a29 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_NUMBER_TABLE();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_DATE_TABLE();
419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_NUMBER_TABLE();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_DATE_TABLE();
427: a6 := JTF_DATE_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_NUMBER_TABLE();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_DATE_TABLE();
427: a6 := JTF_DATE_TABLE();
428: a7 := JTF_NUMBER_TABLE();
424: a3 := JTF_NUMBER_TABLE();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_DATE_TABLE();
427: a6 := JTF_DATE_TABLE();
428: a7 := JTF_NUMBER_TABLE();
429: a8 := JTF_VARCHAR2_TABLE_100();
430: a9 := JTF_VARCHAR2_TABLE_100();
431: a10 := JTF_VARCHAR2_TABLE_100();
432: a11 := JTF_VARCHAR2_TABLE_500();
443: a22 := JTF_VARCHAR2_TABLE_500();
444: a23 := JTF_VARCHAR2_TABLE_500();
445: a24 := JTF_VARCHAR2_TABLE_500();
446: a25 := JTF_VARCHAR2_TABLE_500();
447: a26 := JTF_NUMBER_TABLE();
448: a27 := JTF_DATE_TABLE();
449: a28 := JTF_NUMBER_TABLE();
450: a29 := JTF_DATE_TABLE();
451: a30 := JTF_NUMBER_TABLE();
445: a24 := JTF_VARCHAR2_TABLE_500();
446: a25 := JTF_VARCHAR2_TABLE_500();
447: a26 := JTF_NUMBER_TABLE();
448: a27 := JTF_DATE_TABLE();
449: a28 := JTF_NUMBER_TABLE();
450: a29 := JTF_DATE_TABLE();
451: a30 := JTF_NUMBER_TABLE();
452: if t.count > 0 then
453: a0.extend(t.count);
447: a26 := JTF_NUMBER_TABLE();
448: a27 := JTF_DATE_TABLE();
449: a28 := JTF_NUMBER_TABLE();
450: a29 := JTF_DATE_TABLE();
451: a30 := JTF_NUMBER_TABLE();
452: if t.count > 0 then
453: a0.extend(t.count);
454: a1.extend(t.count);
455: a2.extend(t.count);
524: end if;
525: end if;
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
525: end if;
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
533: , a5 JTF_VARCHAR2_TABLE_100
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
533: , a5 JTF_VARCHAR2_TABLE_100
534: , a6 JTF_DATE_TABLE
527:
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
533: , a5 JTF_VARCHAR2_TABLE_100
534: , a6 JTF_DATE_TABLE
535: , a7 JTF_DATE_TABLE
528: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
529: , a1 JTF_NUMBER_TABLE
530: , a2 JTF_NUMBER_TABLE
531: , a3 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
533: , a5 JTF_VARCHAR2_TABLE_100
534: , a6 JTF_DATE_TABLE
535: , a7 JTF_DATE_TABLE
536: , a8 JTF_NUMBER_TABLE
532: , a4 JTF_NUMBER_TABLE
533: , a5 JTF_VARCHAR2_TABLE_100
534: , a6 JTF_DATE_TABLE
535: , a7 JTF_DATE_TABLE
536: , a8 JTF_NUMBER_TABLE
537: , a9 JTF_VARCHAR2_TABLE_100
538: , a10 JTF_VARCHAR2_TABLE_100
539: , a11 JTF_VARCHAR2_TABLE_100
540: , a12 JTF_VARCHAR2_TABLE_500
551: , a23 JTF_VARCHAR2_TABLE_500
552: , a24 JTF_VARCHAR2_TABLE_500
553: , a25 JTF_VARCHAR2_TABLE_500
554: , a26 JTF_VARCHAR2_TABLE_500
555: , a27 JTF_NUMBER_TABLE
556: , a28 JTF_DATE_TABLE
557: , a29 JTF_NUMBER_TABLE
558: , a30 JTF_DATE_TABLE
559: , a31 JTF_NUMBER_TABLE
553: , a25 JTF_VARCHAR2_TABLE_500
554: , a26 JTF_VARCHAR2_TABLE_500
555: , a27 JTF_NUMBER_TABLE
556: , a28 JTF_DATE_TABLE
557: , a29 JTF_NUMBER_TABLE
558: , a30 JTF_DATE_TABLE
559: , a31 JTF_NUMBER_TABLE
560: ) as
561: ddindx binary_integer; indx binary_integer;
555: , a27 JTF_NUMBER_TABLE
556: , a28 JTF_DATE_TABLE
557: , a29 JTF_NUMBER_TABLE
558: , a30 JTF_DATE_TABLE
559: , a31 JTF_NUMBER_TABLE
560: ) as
561: ddindx binary_integer; indx binary_integer;
562: begin
563: if a0 is not null and a0.count > 0 then
605: end loop;
606: end if;
607: end if;
608: end rosetta_table_copy_in_p8;
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
606: end if;
607: end if;
608: end rosetta_table_copy_in_p8;
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
614: , a5 out nocopy JTF_VARCHAR2_TABLE_100
607: end if;
608: end rosetta_table_copy_in_p8;
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
614: , a5 out nocopy JTF_VARCHAR2_TABLE_100
615: , a6 out nocopy JTF_DATE_TABLE
608: end rosetta_table_copy_in_p8;
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
614: , a5 out nocopy JTF_VARCHAR2_TABLE_100
615: , a6 out nocopy JTF_DATE_TABLE
616: , a7 out nocopy JTF_DATE_TABLE
609: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
610: , a1 out nocopy JTF_NUMBER_TABLE
611: , a2 out nocopy JTF_NUMBER_TABLE
612: , a3 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
614: , a5 out nocopy JTF_VARCHAR2_TABLE_100
615: , a6 out nocopy JTF_DATE_TABLE
616: , a7 out nocopy JTF_DATE_TABLE
617: , a8 out nocopy JTF_NUMBER_TABLE
613: , a4 out nocopy JTF_NUMBER_TABLE
614: , a5 out nocopy JTF_VARCHAR2_TABLE_100
615: , a6 out nocopy JTF_DATE_TABLE
616: , a7 out nocopy JTF_DATE_TABLE
617: , a8 out nocopy JTF_NUMBER_TABLE
618: , a9 out nocopy JTF_VARCHAR2_TABLE_100
619: , a10 out nocopy JTF_VARCHAR2_TABLE_100
620: , a11 out nocopy JTF_VARCHAR2_TABLE_100
621: , a12 out nocopy JTF_VARCHAR2_TABLE_500
632: , a23 out nocopy JTF_VARCHAR2_TABLE_500
633: , a24 out nocopy JTF_VARCHAR2_TABLE_500
634: , a25 out nocopy JTF_VARCHAR2_TABLE_500
635: , a26 out nocopy JTF_VARCHAR2_TABLE_500
636: , a27 out nocopy JTF_NUMBER_TABLE
637: , a28 out nocopy JTF_DATE_TABLE
638: , a29 out nocopy JTF_NUMBER_TABLE
639: , a30 out nocopy JTF_DATE_TABLE
640: , a31 out nocopy JTF_NUMBER_TABLE
634: , a25 out nocopy JTF_VARCHAR2_TABLE_500
635: , a26 out nocopy JTF_VARCHAR2_TABLE_500
636: , a27 out nocopy JTF_NUMBER_TABLE
637: , a28 out nocopy JTF_DATE_TABLE
638: , a29 out nocopy JTF_NUMBER_TABLE
639: , a30 out nocopy JTF_DATE_TABLE
640: , a31 out nocopy JTF_NUMBER_TABLE
641: ) as
642: ddindx binary_integer; indx binary_integer;
636: , a27 out nocopy JTF_NUMBER_TABLE
637: , a28 out nocopy JTF_DATE_TABLE
638: , a29 out nocopy JTF_NUMBER_TABLE
639: , a30 out nocopy JTF_DATE_TABLE
640: , a31 out nocopy JTF_NUMBER_TABLE
641: ) as
642: ddindx binary_integer; indx binary_integer;
643: begin
644: if t is null or t.count = 0 then
641: ) as
642: ddindx binary_integer; indx binary_integer;
643: begin
644: if t is null or t.count = 0 then
645: a0 := JTF_NUMBER_TABLE();
646: a1 := JTF_NUMBER_TABLE();
647: a2 := JTF_NUMBER_TABLE();
648: a3 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
642: ddindx binary_integer; indx binary_integer;
643: begin
644: if t is null or t.count = 0 then
645: a0 := JTF_NUMBER_TABLE();
646: a1 := JTF_NUMBER_TABLE();
647: a2 := JTF_NUMBER_TABLE();
648: a3 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
650: a5 := JTF_VARCHAR2_TABLE_100();
643: begin
644: if t is null or t.count = 0 then
645: a0 := JTF_NUMBER_TABLE();
646: a1 := JTF_NUMBER_TABLE();
647: a2 := JTF_NUMBER_TABLE();
648: a3 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
650: a5 := JTF_VARCHAR2_TABLE_100();
651: a6 := JTF_DATE_TABLE();
644: if t is null or t.count = 0 then
645: a0 := JTF_NUMBER_TABLE();
646: a1 := JTF_NUMBER_TABLE();
647: a2 := JTF_NUMBER_TABLE();
648: a3 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
650: a5 := JTF_VARCHAR2_TABLE_100();
651: a6 := JTF_DATE_TABLE();
652: a7 := JTF_DATE_TABLE();
645: a0 := JTF_NUMBER_TABLE();
646: a1 := JTF_NUMBER_TABLE();
647: a2 := JTF_NUMBER_TABLE();
648: a3 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
650: a5 := JTF_VARCHAR2_TABLE_100();
651: a6 := JTF_DATE_TABLE();
652: a7 := JTF_DATE_TABLE();
653: a8 := JTF_NUMBER_TABLE();
649: a4 := JTF_NUMBER_TABLE();
650: a5 := JTF_VARCHAR2_TABLE_100();
651: a6 := JTF_DATE_TABLE();
652: a7 := JTF_DATE_TABLE();
653: a8 := JTF_NUMBER_TABLE();
654: a9 := JTF_VARCHAR2_TABLE_100();
655: a10 := JTF_VARCHAR2_TABLE_100();
656: a11 := JTF_VARCHAR2_TABLE_100();
657: a12 := JTF_VARCHAR2_TABLE_500();
668: a23 := JTF_VARCHAR2_TABLE_500();
669: a24 := JTF_VARCHAR2_TABLE_500();
670: a25 := JTF_VARCHAR2_TABLE_500();
671: a26 := JTF_VARCHAR2_TABLE_500();
672: a27 := JTF_NUMBER_TABLE();
673: a28 := JTF_DATE_TABLE();
674: a29 := JTF_NUMBER_TABLE();
675: a30 := JTF_DATE_TABLE();
676: a31 := JTF_NUMBER_TABLE();
670: a25 := JTF_VARCHAR2_TABLE_500();
671: a26 := JTF_VARCHAR2_TABLE_500();
672: a27 := JTF_NUMBER_TABLE();
673: a28 := JTF_DATE_TABLE();
674: a29 := JTF_NUMBER_TABLE();
675: a30 := JTF_DATE_TABLE();
676: a31 := JTF_NUMBER_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
672: a27 := JTF_NUMBER_TABLE();
673: a28 := JTF_DATE_TABLE();
674: a29 := JTF_NUMBER_TABLE();
675: a30 := JTF_DATE_TABLE();
676: a31 := JTF_NUMBER_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
674: a29 := JTF_NUMBER_TABLE();
675: a30 := JTF_DATE_TABLE();
676: a31 := JTF_NUMBER_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
681: a3 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
675: a30 := JTF_DATE_TABLE();
676: a31 := JTF_NUMBER_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
681: a3 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
683: a5 := JTF_VARCHAR2_TABLE_100();
676: a31 := JTF_NUMBER_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
681: a3 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
683: a5 := JTF_VARCHAR2_TABLE_100();
684: a6 := JTF_DATE_TABLE();
677: else
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
681: a3 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
683: a5 := JTF_VARCHAR2_TABLE_100();
684: a6 := JTF_DATE_TABLE();
685: a7 := JTF_DATE_TABLE();
678: a0 := JTF_NUMBER_TABLE();
679: a1 := JTF_NUMBER_TABLE();
680: a2 := JTF_NUMBER_TABLE();
681: a3 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
683: a5 := JTF_VARCHAR2_TABLE_100();
684: a6 := JTF_DATE_TABLE();
685: a7 := JTF_DATE_TABLE();
686: a8 := JTF_NUMBER_TABLE();
682: a4 := JTF_NUMBER_TABLE();
683: a5 := JTF_VARCHAR2_TABLE_100();
684: a6 := JTF_DATE_TABLE();
685: a7 := JTF_DATE_TABLE();
686: a8 := JTF_NUMBER_TABLE();
687: a9 := JTF_VARCHAR2_TABLE_100();
688: a10 := JTF_VARCHAR2_TABLE_100();
689: a11 := JTF_VARCHAR2_TABLE_100();
690: a12 := JTF_VARCHAR2_TABLE_500();
701: a23 := JTF_VARCHAR2_TABLE_500();
702: a24 := JTF_VARCHAR2_TABLE_500();
703: a25 := JTF_VARCHAR2_TABLE_500();
704: a26 := JTF_VARCHAR2_TABLE_500();
705: a27 := JTF_NUMBER_TABLE();
706: a28 := JTF_DATE_TABLE();
707: a29 := JTF_NUMBER_TABLE();
708: a30 := JTF_DATE_TABLE();
709: a31 := JTF_NUMBER_TABLE();
703: a25 := JTF_VARCHAR2_TABLE_500();
704: a26 := JTF_VARCHAR2_TABLE_500();
705: a27 := JTF_NUMBER_TABLE();
706: a28 := JTF_DATE_TABLE();
707: a29 := JTF_NUMBER_TABLE();
708: a30 := JTF_DATE_TABLE();
709: a31 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
711: a0.extend(t.count);
705: a27 := JTF_NUMBER_TABLE();
706: a28 := JTF_DATE_TABLE();
707: a29 := JTF_NUMBER_TABLE();
708: a30 := JTF_DATE_TABLE();
709: a31 := JTF_NUMBER_TABLE();
710: if t.count > 0 then
711: a0.extend(t.count);
712: a1.extend(t.count);
713: a2.extend(t.count);
952: , p_init_msg_list VARCHAR2
953: , x_return_status out nocopy VARCHAR2
954: , x_msg_count out nocopy NUMBER
955: , x_msg_data out nocopy VARCHAR2
956: , p5_a0 JTF_NUMBER_TABLE
957: , p5_a1 JTF_NUMBER_TABLE
958: , p5_a2 JTF_NUMBER_TABLE
959: , p5_a3 JTF_NUMBER_TABLE
960: , p5_a4 JTF_VARCHAR2_TABLE_100
953: , x_return_status out nocopy VARCHAR2
954: , x_msg_count out nocopy NUMBER
955: , x_msg_data out nocopy VARCHAR2
956: , p5_a0 JTF_NUMBER_TABLE
957: , p5_a1 JTF_NUMBER_TABLE
958: , p5_a2 JTF_NUMBER_TABLE
959: , p5_a3 JTF_NUMBER_TABLE
960: , p5_a4 JTF_VARCHAR2_TABLE_100
961: , p5_a5 JTF_DATE_TABLE
954: , x_msg_count out nocopy NUMBER
955: , x_msg_data out nocopy VARCHAR2
956: , p5_a0 JTF_NUMBER_TABLE
957: , p5_a1 JTF_NUMBER_TABLE
958: , p5_a2 JTF_NUMBER_TABLE
959: , p5_a3 JTF_NUMBER_TABLE
960: , p5_a4 JTF_VARCHAR2_TABLE_100
961: , p5_a5 JTF_DATE_TABLE
962: , p5_a6 JTF_DATE_TABLE
955: , x_msg_data out nocopy VARCHAR2
956: , p5_a0 JTF_NUMBER_TABLE
957: , p5_a1 JTF_NUMBER_TABLE
958: , p5_a2 JTF_NUMBER_TABLE
959: , p5_a3 JTF_NUMBER_TABLE
960: , p5_a4 JTF_VARCHAR2_TABLE_100
961: , p5_a5 JTF_DATE_TABLE
962: , p5_a6 JTF_DATE_TABLE
963: , p5_a7 JTF_NUMBER_TABLE
959: , p5_a3 JTF_NUMBER_TABLE
960: , p5_a4 JTF_VARCHAR2_TABLE_100
961: , p5_a5 JTF_DATE_TABLE
962: , p5_a6 JTF_DATE_TABLE
963: , p5_a7 JTF_NUMBER_TABLE
964: , p5_a8 JTF_VARCHAR2_TABLE_100
965: , p5_a9 JTF_VARCHAR2_TABLE_100
966: , p5_a10 JTF_VARCHAR2_TABLE_100
967: , p5_a11 JTF_VARCHAR2_TABLE_500
978: , p5_a22 JTF_VARCHAR2_TABLE_500
979: , p5_a23 JTF_VARCHAR2_TABLE_500
980: , p5_a24 JTF_VARCHAR2_TABLE_500
981: , p5_a25 JTF_VARCHAR2_TABLE_500
982: , p5_a26 JTF_NUMBER_TABLE
983: , p5_a27 JTF_DATE_TABLE
984: , p5_a28 JTF_NUMBER_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
980: , p5_a24 JTF_VARCHAR2_TABLE_500
981: , p5_a25 JTF_VARCHAR2_TABLE_500
982: , p5_a26 JTF_NUMBER_TABLE
983: , p5_a27 JTF_DATE_TABLE
984: , p5_a28 JTF_NUMBER_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
982: , p5_a26 JTF_NUMBER_TABLE
983: , p5_a27 JTF_DATE_TABLE
984: , p5_a28 JTF_NUMBER_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
989: , p6_a2 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
983: , p5_a27 JTF_DATE_TABLE
984: , p5_a28 JTF_NUMBER_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
989: , p6_a2 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
991: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
984: , p5_a28 JTF_NUMBER_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
989: , p6_a2 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
991: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a5 out nocopy JTF_DATE_TABLE
985: , p5_a29 JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
989: , p6_a2 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
991: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a5 out nocopy JTF_DATE_TABLE
993: , p6_a6 out nocopy JTF_DATE_TABLE
986: , p5_a30 JTF_NUMBER_TABLE
987: , p6_a0 out nocopy JTF_NUMBER_TABLE
988: , p6_a1 out nocopy JTF_NUMBER_TABLE
989: , p6_a2 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
991: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a5 out nocopy JTF_DATE_TABLE
993: , p6_a6 out nocopy JTF_DATE_TABLE
994: , p6_a7 out nocopy JTF_NUMBER_TABLE
990: , p6_a3 out nocopy JTF_NUMBER_TABLE
991: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a5 out nocopy JTF_DATE_TABLE
993: , p6_a6 out nocopy JTF_DATE_TABLE
994: , p6_a7 out nocopy JTF_NUMBER_TABLE
995: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
996: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
997: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
998: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1009: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1010: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1011: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1012: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1013: , p6_a26 out nocopy JTF_NUMBER_TABLE
1014: , p6_a27 out nocopy JTF_DATE_TABLE
1015: , p6_a28 out nocopy JTF_NUMBER_TABLE
1016: , p6_a29 out nocopy JTF_DATE_TABLE
1017: , p6_a30 out nocopy JTF_NUMBER_TABLE
1011: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1012: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1013: , p6_a26 out nocopy JTF_NUMBER_TABLE
1014: , p6_a27 out nocopy JTF_DATE_TABLE
1015: , p6_a28 out nocopy JTF_NUMBER_TABLE
1016: , p6_a29 out nocopy JTF_DATE_TABLE
1017: , p6_a30 out nocopy JTF_NUMBER_TABLE
1018: )
1019:
1013: , p6_a26 out nocopy JTF_NUMBER_TABLE
1014: , p6_a27 out nocopy JTF_DATE_TABLE
1015: , p6_a28 out nocopy JTF_NUMBER_TABLE
1016: , p6_a29 out nocopy JTF_DATE_TABLE
1017: , p6_a30 out nocopy JTF_NUMBER_TABLE
1018: )
1019:
1020: as
1021: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1214: , p_init_msg_list VARCHAR2
1215: , x_return_status out nocopy VARCHAR2
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_NUMBER_TABLE
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1215: , x_return_status out nocopy VARCHAR2
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_NUMBER_TABLE
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_DATE_TABLE
1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_NUMBER_TABLE
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_DATE_TABLE
1224: , p5_a6 JTF_DATE_TABLE
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_NUMBER_TABLE
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_DATE_TABLE
1224: , p5_a6 JTF_DATE_TABLE
1225: , p5_a7 JTF_NUMBER_TABLE
1221: , p5_a3 JTF_NUMBER_TABLE
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_DATE_TABLE
1224: , p5_a6 JTF_DATE_TABLE
1225: , p5_a7 JTF_NUMBER_TABLE
1226: , p5_a8 JTF_VARCHAR2_TABLE_100
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_500
1240: , p5_a22 JTF_VARCHAR2_TABLE_500
1241: , p5_a23 JTF_VARCHAR2_TABLE_500
1242: , p5_a24 JTF_VARCHAR2_TABLE_500
1243: , p5_a25 JTF_VARCHAR2_TABLE_500
1244: , p5_a26 JTF_NUMBER_TABLE
1245: , p5_a27 JTF_DATE_TABLE
1246: , p5_a28 JTF_NUMBER_TABLE
1247: , p5_a29 JTF_DATE_TABLE
1248: , p5_a30 JTF_NUMBER_TABLE
1242: , p5_a24 JTF_VARCHAR2_TABLE_500
1243: , p5_a25 JTF_VARCHAR2_TABLE_500
1244: , p5_a26 JTF_NUMBER_TABLE
1245: , p5_a27 JTF_DATE_TABLE
1246: , p5_a28 JTF_NUMBER_TABLE
1247: , p5_a29 JTF_DATE_TABLE
1248: , p5_a30 JTF_NUMBER_TABLE
1249: )
1250:
1244: , p5_a26 JTF_NUMBER_TABLE
1245: , p5_a27 JTF_DATE_TABLE
1246: , p5_a28 JTF_NUMBER_TABLE
1247: , p5_a29 JTF_DATE_TABLE
1248: , p5_a30 JTF_NUMBER_TABLE
1249: )
1250:
1251: as
1252: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1475: , p_init_msg_list VARCHAR2
1476: , x_return_status out nocopy VARCHAR2
1477: , x_msg_count out nocopy NUMBER
1478: , x_msg_data out nocopy VARCHAR2
1479: , p5_a0 JTF_NUMBER_TABLE
1480: , p5_a1 JTF_NUMBER_TABLE
1481: , p5_a2 JTF_NUMBER_TABLE
1482: , p5_a3 JTF_NUMBER_TABLE
1483: , p5_a4 JTF_VARCHAR2_TABLE_100
1476: , x_return_status out nocopy VARCHAR2
1477: , x_msg_count out nocopy NUMBER
1478: , x_msg_data out nocopy VARCHAR2
1479: , p5_a0 JTF_NUMBER_TABLE
1480: , p5_a1 JTF_NUMBER_TABLE
1481: , p5_a2 JTF_NUMBER_TABLE
1482: , p5_a3 JTF_NUMBER_TABLE
1483: , p5_a4 JTF_VARCHAR2_TABLE_100
1484: , p5_a5 JTF_DATE_TABLE
1477: , x_msg_count out nocopy NUMBER
1478: , x_msg_data out nocopy VARCHAR2
1479: , p5_a0 JTF_NUMBER_TABLE
1480: , p5_a1 JTF_NUMBER_TABLE
1481: , p5_a2 JTF_NUMBER_TABLE
1482: , p5_a3 JTF_NUMBER_TABLE
1483: , p5_a4 JTF_VARCHAR2_TABLE_100
1484: , p5_a5 JTF_DATE_TABLE
1485: , p5_a6 JTF_DATE_TABLE
1478: , x_msg_data out nocopy VARCHAR2
1479: , p5_a0 JTF_NUMBER_TABLE
1480: , p5_a1 JTF_NUMBER_TABLE
1481: , p5_a2 JTF_NUMBER_TABLE
1482: , p5_a3 JTF_NUMBER_TABLE
1483: , p5_a4 JTF_VARCHAR2_TABLE_100
1484: , p5_a5 JTF_DATE_TABLE
1485: , p5_a6 JTF_DATE_TABLE
1486: , p5_a7 JTF_NUMBER_TABLE
1482: , p5_a3 JTF_NUMBER_TABLE
1483: , p5_a4 JTF_VARCHAR2_TABLE_100
1484: , p5_a5 JTF_DATE_TABLE
1485: , p5_a6 JTF_DATE_TABLE
1486: , p5_a7 JTF_NUMBER_TABLE
1487: , p5_a8 JTF_VARCHAR2_TABLE_100
1488: , p5_a9 JTF_VARCHAR2_TABLE_100
1489: , p5_a10 JTF_VARCHAR2_TABLE_100
1490: , p5_a11 JTF_VARCHAR2_TABLE_500
1501: , p5_a22 JTF_VARCHAR2_TABLE_500
1502: , p5_a23 JTF_VARCHAR2_TABLE_500
1503: , p5_a24 JTF_VARCHAR2_TABLE_500
1504: , p5_a25 JTF_VARCHAR2_TABLE_500
1505: , p5_a26 JTF_NUMBER_TABLE
1506: , p5_a27 JTF_DATE_TABLE
1507: , p5_a28 JTF_NUMBER_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1503: , p5_a24 JTF_VARCHAR2_TABLE_500
1504: , p5_a25 JTF_VARCHAR2_TABLE_500
1505: , p5_a26 JTF_NUMBER_TABLE
1506: , p5_a27 JTF_DATE_TABLE
1507: , p5_a28 JTF_NUMBER_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1505: , p5_a26 JTF_NUMBER_TABLE
1506: , p5_a27 JTF_DATE_TABLE
1507: , p5_a28 JTF_NUMBER_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1512: , p6_a2 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1506: , p5_a27 JTF_DATE_TABLE
1507: , p5_a28 JTF_NUMBER_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1512: , p6_a2 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1507: , p5_a28 JTF_NUMBER_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1512: , p6_a2 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1515: , p6_a5 out nocopy JTF_DATE_TABLE
1508: , p5_a29 JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1512: , p6_a2 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1515: , p6_a5 out nocopy JTF_DATE_TABLE
1516: , p6_a6 out nocopy JTF_DATE_TABLE
1509: , p5_a30 JTF_NUMBER_TABLE
1510: , p6_a0 out nocopy JTF_NUMBER_TABLE
1511: , p6_a1 out nocopy JTF_NUMBER_TABLE
1512: , p6_a2 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1515: , p6_a5 out nocopy JTF_DATE_TABLE
1516: , p6_a6 out nocopy JTF_DATE_TABLE
1517: , p6_a7 out nocopy JTF_NUMBER_TABLE
1513: , p6_a3 out nocopy JTF_NUMBER_TABLE
1514: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1515: , p6_a5 out nocopy JTF_DATE_TABLE
1516: , p6_a6 out nocopy JTF_DATE_TABLE
1517: , p6_a7 out nocopy JTF_NUMBER_TABLE
1518: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1519: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1520: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1521: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1532: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1533: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1534: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1535: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1536: , p6_a26 out nocopy JTF_NUMBER_TABLE
1537: , p6_a27 out nocopy JTF_DATE_TABLE
1538: , p6_a28 out nocopy JTF_NUMBER_TABLE
1539: , p6_a29 out nocopy JTF_DATE_TABLE
1540: , p6_a30 out nocopy JTF_NUMBER_TABLE
1534: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1535: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1536: , p6_a26 out nocopy JTF_NUMBER_TABLE
1537: , p6_a27 out nocopy JTF_DATE_TABLE
1538: , p6_a28 out nocopy JTF_NUMBER_TABLE
1539: , p6_a29 out nocopy JTF_DATE_TABLE
1540: , p6_a30 out nocopy JTF_NUMBER_TABLE
1541: )
1542:
1536: , p6_a26 out nocopy JTF_NUMBER_TABLE
1537: , p6_a27 out nocopy JTF_DATE_TABLE
1538: , p6_a28 out nocopy JTF_NUMBER_TABLE
1539: , p6_a29 out nocopy JTF_DATE_TABLE
1540: , p6_a30 out nocopy JTF_NUMBER_TABLE
1541: )
1542:
1543: as
1544: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1737: , p_init_msg_list VARCHAR2
1738: , x_return_status out nocopy VARCHAR2
1739: , x_msg_count out nocopy NUMBER
1740: , x_msg_data out nocopy VARCHAR2
1741: , p5_a0 JTF_NUMBER_TABLE
1742: , p5_a1 JTF_NUMBER_TABLE
1743: , p5_a2 JTF_NUMBER_TABLE
1744: , p5_a3 JTF_NUMBER_TABLE
1745: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , x_return_status out nocopy VARCHAR2
1739: , x_msg_count out nocopy NUMBER
1740: , x_msg_data out nocopy VARCHAR2
1741: , p5_a0 JTF_NUMBER_TABLE
1742: , p5_a1 JTF_NUMBER_TABLE
1743: , p5_a2 JTF_NUMBER_TABLE
1744: , p5_a3 JTF_NUMBER_TABLE
1745: , p5_a4 JTF_VARCHAR2_TABLE_100
1746: , p5_a5 JTF_DATE_TABLE
1739: , x_msg_count out nocopy NUMBER
1740: , x_msg_data out nocopy VARCHAR2
1741: , p5_a0 JTF_NUMBER_TABLE
1742: , p5_a1 JTF_NUMBER_TABLE
1743: , p5_a2 JTF_NUMBER_TABLE
1744: , p5_a3 JTF_NUMBER_TABLE
1745: , p5_a4 JTF_VARCHAR2_TABLE_100
1746: , p5_a5 JTF_DATE_TABLE
1747: , p5_a6 JTF_DATE_TABLE
1740: , x_msg_data out nocopy VARCHAR2
1741: , p5_a0 JTF_NUMBER_TABLE
1742: , p5_a1 JTF_NUMBER_TABLE
1743: , p5_a2 JTF_NUMBER_TABLE
1744: , p5_a3 JTF_NUMBER_TABLE
1745: , p5_a4 JTF_VARCHAR2_TABLE_100
1746: , p5_a5 JTF_DATE_TABLE
1747: , p5_a6 JTF_DATE_TABLE
1748: , p5_a7 JTF_NUMBER_TABLE
1744: , p5_a3 JTF_NUMBER_TABLE
1745: , p5_a4 JTF_VARCHAR2_TABLE_100
1746: , p5_a5 JTF_DATE_TABLE
1747: , p5_a6 JTF_DATE_TABLE
1748: , p5_a7 JTF_NUMBER_TABLE
1749: , p5_a8 JTF_VARCHAR2_TABLE_100
1750: , p5_a9 JTF_VARCHAR2_TABLE_100
1751: , p5_a10 JTF_VARCHAR2_TABLE_100
1752: , p5_a11 JTF_VARCHAR2_TABLE_500
1763: , p5_a22 JTF_VARCHAR2_TABLE_500
1764: , p5_a23 JTF_VARCHAR2_TABLE_500
1765: , p5_a24 JTF_VARCHAR2_TABLE_500
1766: , p5_a25 JTF_VARCHAR2_TABLE_500
1767: , p5_a26 JTF_NUMBER_TABLE
1768: , p5_a27 JTF_DATE_TABLE
1769: , p5_a28 JTF_NUMBER_TABLE
1770: , p5_a29 JTF_DATE_TABLE
1771: , p5_a30 JTF_NUMBER_TABLE
1765: , p5_a24 JTF_VARCHAR2_TABLE_500
1766: , p5_a25 JTF_VARCHAR2_TABLE_500
1767: , p5_a26 JTF_NUMBER_TABLE
1768: , p5_a27 JTF_DATE_TABLE
1769: , p5_a28 JTF_NUMBER_TABLE
1770: , p5_a29 JTF_DATE_TABLE
1771: , p5_a30 JTF_NUMBER_TABLE
1772: )
1773:
1767: , p5_a26 JTF_NUMBER_TABLE
1768: , p5_a27 JTF_DATE_TABLE
1769: , p5_a28 JTF_NUMBER_TABLE
1770: , p5_a29 JTF_DATE_TABLE
1771: , p5_a30 JTF_NUMBER_TABLE
1772: )
1773:
1774: as
1775: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;
1932: , p_init_msg_list VARCHAR2
1933: , x_return_status out nocopy VARCHAR2
1934: , x_msg_count out nocopy NUMBER
1935: , x_msg_data out nocopy VARCHAR2
1936: , p5_a0 JTF_NUMBER_TABLE
1937: , p5_a1 JTF_NUMBER_TABLE
1938: , p5_a2 JTF_NUMBER_TABLE
1939: , p5_a3 JTF_NUMBER_TABLE
1940: , p5_a4 JTF_VARCHAR2_TABLE_100
1933: , x_return_status out nocopy VARCHAR2
1934: , x_msg_count out nocopy NUMBER
1935: , x_msg_data out nocopy VARCHAR2
1936: , p5_a0 JTF_NUMBER_TABLE
1937: , p5_a1 JTF_NUMBER_TABLE
1938: , p5_a2 JTF_NUMBER_TABLE
1939: , p5_a3 JTF_NUMBER_TABLE
1940: , p5_a4 JTF_VARCHAR2_TABLE_100
1941: , p5_a5 JTF_DATE_TABLE
1934: , x_msg_count out nocopy NUMBER
1935: , x_msg_data out nocopy VARCHAR2
1936: , p5_a0 JTF_NUMBER_TABLE
1937: , p5_a1 JTF_NUMBER_TABLE
1938: , p5_a2 JTF_NUMBER_TABLE
1939: , p5_a3 JTF_NUMBER_TABLE
1940: , p5_a4 JTF_VARCHAR2_TABLE_100
1941: , p5_a5 JTF_DATE_TABLE
1942: , p5_a6 JTF_DATE_TABLE
1935: , x_msg_data out nocopy VARCHAR2
1936: , p5_a0 JTF_NUMBER_TABLE
1937: , p5_a1 JTF_NUMBER_TABLE
1938: , p5_a2 JTF_NUMBER_TABLE
1939: , p5_a3 JTF_NUMBER_TABLE
1940: , p5_a4 JTF_VARCHAR2_TABLE_100
1941: , p5_a5 JTF_DATE_TABLE
1942: , p5_a6 JTF_DATE_TABLE
1943: , p5_a7 JTF_NUMBER_TABLE
1939: , p5_a3 JTF_NUMBER_TABLE
1940: , p5_a4 JTF_VARCHAR2_TABLE_100
1941: , p5_a5 JTF_DATE_TABLE
1942: , p5_a6 JTF_DATE_TABLE
1943: , p5_a7 JTF_NUMBER_TABLE
1944: , p5_a8 JTF_VARCHAR2_TABLE_100
1945: , p5_a9 JTF_VARCHAR2_TABLE_100
1946: , p5_a10 JTF_VARCHAR2_TABLE_100
1947: , p5_a11 JTF_VARCHAR2_TABLE_500
1958: , p5_a22 JTF_VARCHAR2_TABLE_500
1959: , p5_a23 JTF_VARCHAR2_TABLE_500
1960: , p5_a24 JTF_VARCHAR2_TABLE_500
1961: , p5_a25 JTF_VARCHAR2_TABLE_500
1962: , p5_a26 JTF_NUMBER_TABLE
1963: , p5_a27 JTF_DATE_TABLE
1964: , p5_a28 JTF_NUMBER_TABLE
1965: , p5_a29 JTF_DATE_TABLE
1966: , p5_a30 JTF_NUMBER_TABLE
1960: , p5_a24 JTF_VARCHAR2_TABLE_500
1961: , p5_a25 JTF_VARCHAR2_TABLE_500
1962: , p5_a26 JTF_NUMBER_TABLE
1963: , p5_a27 JTF_DATE_TABLE
1964: , p5_a28 JTF_NUMBER_TABLE
1965: , p5_a29 JTF_DATE_TABLE
1966: , p5_a30 JTF_NUMBER_TABLE
1967: )
1968:
1962: , p5_a26 JTF_NUMBER_TABLE
1963: , p5_a27 JTF_DATE_TABLE
1964: , p5_a28 JTF_NUMBER_TABLE
1965: , p5_a29 JTF_DATE_TABLE
1966: , p5_a30 JTF_NUMBER_TABLE
1967: )
1968:
1969: as
1970: ddp_sidv_tbl okl_sid_pvt.sidv_tbl_type;