1: package body okl_eth_pvt_w as
2: /* $Header: OKLIETHB.pls 120.0 2005/07/07 10:38:19 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
1: package body okl_eth_pvt_w as
2: /* $Header: OKLIETHB.pls 120.0 2005/07/07 10:38:19 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then
84: end loop;
85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_DATE_TABLE
100: , a12 out nocopy JTF_DATE_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100
113: , a25 out nocopy JTF_VARCHAR2_TABLE_500
114: , a26 out nocopy JTF_VARCHAR2_TABLE_500
115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_DATE_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_DATE_TABLE();
138: a12 := JTF_DATE_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();
151: a25 := JTF_VARCHAR2_TABLE_500();
152: a26 := JTF_VARCHAR2_TABLE_500();
153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_DATE_TABLE();
173: a12 := JTF_DATE_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();
186: a25 := JTF_VARCHAR2_TABLE_500();
187: a26 := JTF_VARCHAR2_TABLE_500();
188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);
273: end if;
274: end if;
275: end rosetta_table_copy_out_p1;
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
274: end if;
275: end rosetta_table_copy_out_p1;
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100
285: , a8 JTF_NUMBER_TABLE
286: , a9 JTF_VARCHAR2_TABLE_100
287: , a10 JTF_DATE_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100
285: , a8 JTF_NUMBER_TABLE
286: , a9 JTF_VARCHAR2_TABLE_100
287: , a10 JTF_DATE_TABLE
288: , a11 JTF_DATE_TABLE
289: , a12 JTF_VARCHAR2_TABLE_100
301: , a24 JTF_VARCHAR2_TABLE_500
302: , a25 JTF_VARCHAR2_TABLE_500
303: , a26 JTF_VARCHAR2_TABLE_500
304: , a27 JTF_VARCHAR2_TABLE_500
305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE
303: , a26 JTF_VARCHAR2_TABLE_500
304: , a27 JTF_VARCHAR2_TABLE_500
305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
312: begin
313: if a0 is not null and a0.count > 0 then
356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
357: end if;
358: end if;
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100
368: , a8 out nocopy JTF_NUMBER_TABLE
369: , a9 out nocopy JTF_VARCHAR2_TABLE_100
370: , a10 out nocopy JTF_DATE_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100
368: , a8 out nocopy JTF_NUMBER_TABLE
369: , a9 out nocopy JTF_VARCHAR2_TABLE_100
370: , a10 out nocopy JTF_DATE_TABLE
371: , a11 out nocopy JTF_DATE_TABLE
372: , a12 out nocopy JTF_VARCHAR2_TABLE_100
384: , a24 out nocopy JTF_VARCHAR2_TABLE_500
385: , a25 out nocopy JTF_VARCHAR2_TABLE_500
386: , a26 out nocopy JTF_VARCHAR2_TABLE_500
387: , a27 out nocopy JTF_VARCHAR2_TABLE_500
388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE
386: , a26 out nocopy JTF_VARCHAR2_TABLE_500
387: , a27 out nocopy JTF_VARCHAR2_TABLE_500
388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE
393: ) as
394: ddindx binary_integer; indx binary_integer;
388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE
393: ) as
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
393: ) as
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();
405: a8 := JTF_NUMBER_TABLE();
406: a9 := JTF_VARCHAR2_TABLE_100();
407: a10 := JTF_DATE_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();
405: a8 := JTF_NUMBER_TABLE();
406: a9 := JTF_VARCHAR2_TABLE_100();
407: a10 := JTF_DATE_TABLE();
408: a11 := JTF_DATE_TABLE();
409: a12 := JTF_VARCHAR2_TABLE_100();
421: a24 := JTF_VARCHAR2_TABLE_500();
422: a25 := JTF_VARCHAR2_TABLE_500();
423: a26 := JTF_VARCHAR2_TABLE_500();
424: a27 := JTF_VARCHAR2_TABLE_500();
425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
423: a26 := JTF_VARCHAR2_TABLE_500();
424: a27 := JTF_VARCHAR2_TABLE_500();
425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();
439: a8 := JTF_NUMBER_TABLE();
440: a9 := JTF_VARCHAR2_TABLE_100();
441: a10 := JTF_DATE_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();
439: a8 := JTF_NUMBER_TABLE();
440: a9 := JTF_VARCHAR2_TABLE_100();
441: a10 := JTF_DATE_TABLE();
442: a11 := JTF_DATE_TABLE();
443: a12 := JTF_VARCHAR2_TABLE_100();
455: a24 := JTF_VARCHAR2_TABLE_500();
456: a25 := JTF_VARCHAR2_TABLE_500();
457: a26 := JTF_VARCHAR2_TABLE_500();
458: a27 := JTF_VARCHAR2_TABLE_500();
459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();
457: a26 := JTF_VARCHAR2_TABLE_500();
458: a27 := JTF_VARCHAR2_TABLE_500();
459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();
464: if t.count > 0 then
465: a0.extend(t.count);
459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();
464: if t.count > 0 then
465: a0.extend(t.count);
466: a1.extend(t.count);
467: a2.extend(t.count);
540: end if;
541: end if;
542: end rosetta_table_copy_out_p3;
543:
544: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE
545: , a1 JTF_VARCHAR2_TABLE_2000
546: , a2 JTF_VARCHAR2_TABLE_100
547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100
545: , a1 JTF_VARCHAR2_TABLE_2000
546: , a2 JTF_VARCHAR2_TABLE_100
547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100
549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE
547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100
549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE
554: ) as
555: ddindx binary_integer; indx binary_integer;
549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE
554: ) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if a0 is not null and a0.count > 0 then
577: end loop;
578: end if;
579: end if;
580: end rosetta_table_copy_in_p5;
581: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
582: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
583: , a2 out nocopy JTF_VARCHAR2_TABLE_100
584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100
582: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
583: , a2 out nocopy JTF_VARCHAR2_TABLE_100
584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100
586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE
584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100
586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_NUMBER_TABLE();
596: a1 := JTF_VARCHAR2_TABLE_2000();
597: a2 := JTF_VARCHAR2_TABLE_100();
598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();
596: a1 := JTF_VARCHAR2_TABLE_2000();
597: a2 := JTF_VARCHAR2_TABLE_100();
598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();
600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();
600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();
600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();
607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();
607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();
609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();
607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();
609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();
611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();
609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();
611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();
616: if t.count > 0 then
617: a0.extend(t.count);
611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();
616: if t.count > 0 then
617: a0.extend(t.count);
618: a1.extend(t.count);
619: a2.extend(t.count);
826: , p_init_msg_list VARCHAR2
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100
839: , p5_a9 JTF_NUMBER_TABLE
840: , p5_a10 JTF_VARCHAR2_TABLE_100
841: , p5_a11 JTF_DATE_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100
839: , p5_a9 JTF_NUMBER_TABLE
840: , p5_a10 JTF_VARCHAR2_TABLE_100
841: , p5_a11 JTF_DATE_TABLE
842: , p5_a12 JTF_DATE_TABLE
843: , p5_a13 JTF_VARCHAR2_TABLE_100
855: , p5_a25 JTF_VARCHAR2_TABLE_500
856: , p5_a26 JTF_VARCHAR2_TABLE_500
857: , p5_a27 JTF_VARCHAR2_TABLE_500
858: , p5_a28 JTF_VARCHAR2_TABLE_500
859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
857: , p5_a27 JTF_VARCHAR2_TABLE_500
858: , p5_a28 JTF_VARCHAR2_TABLE_500
859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a9 out nocopy JTF_NUMBER_TABLE
874: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a11 out nocopy JTF_DATE_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a9 out nocopy JTF_NUMBER_TABLE
874: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a11 out nocopy JTF_DATE_TABLE
876: , p6_a12 out nocopy JTF_DATE_TABLE
877: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
889: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
890: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
891: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
892: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE
891: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
892: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE
898: )
899:
893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE
898: )
899:
900: as
901: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;
1178: , p_init_msg_list VARCHAR2
1179: , x_return_status out nocopy VARCHAR2
1180: , x_msg_count out nocopy NUMBER
1181: , x_msg_data out nocopy VARCHAR2
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1179: , x_return_status out nocopy VARCHAR2
1180: , x_msg_count out nocopy NUMBER
1181: , x_msg_data out nocopy VARCHAR2
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100
1191: , p5_a9 JTF_NUMBER_TABLE
1192: , p5_a10 JTF_VARCHAR2_TABLE_100
1193: , p5_a11 JTF_DATE_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100
1191: , p5_a9 JTF_NUMBER_TABLE
1192: , p5_a10 JTF_VARCHAR2_TABLE_100
1193: , p5_a11 JTF_DATE_TABLE
1194: , p5_a12 JTF_DATE_TABLE
1195: , p5_a13 JTF_VARCHAR2_TABLE_100
1207: , p5_a25 JTF_VARCHAR2_TABLE_500
1208: , p5_a26 JTF_VARCHAR2_TABLE_500
1209: , p5_a27 JTF_VARCHAR2_TABLE_500
1210: , p5_a28 JTF_VARCHAR2_TABLE_500
1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1209: , p5_a27 JTF_VARCHAR2_TABLE_500
1210: , p5_a28 JTF_VARCHAR2_TABLE_500
1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p6_a9 out nocopy JTF_NUMBER_TABLE
1226: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p6_a11 out nocopy JTF_DATE_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p6_a9 out nocopy JTF_NUMBER_TABLE
1226: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p6_a11 out nocopy JTF_DATE_TABLE
1228: , p6_a12 out nocopy JTF_DATE_TABLE
1229: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1242: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE
1243: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE
1250: )
1251:
1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE
1250: )
1251:
1252: as
1253: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;
1458: , p_init_msg_list VARCHAR2
1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1471: , p5_a9 JTF_NUMBER_TABLE
1472: , p5_a10 JTF_VARCHAR2_TABLE_100
1473: , p5_a11 JTF_DATE_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1471: , p5_a9 JTF_NUMBER_TABLE
1472: , p5_a10 JTF_VARCHAR2_TABLE_100
1473: , p5_a11 JTF_DATE_TABLE
1474: , p5_a12 JTF_DATE_TABLE
1475: , p5_a13 JTF_VARCHAR2_TABLE_100
1487: , p5_a25 JTF_VARCHAR2_TABLE_500
1488: , p5_a26 JTF_VARCHAR2_TABLE_500
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: )
1497:
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: )
1497:
1498: as
1499: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;