1: package body okl_ecc_pvt_w as
2: /* $Header: OKLIECCB.pls 120.1 2005/10/30 04:58:33 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
1: package body okl_ecc_pvt_w as
2: /* $Header: OKLIECCB.pls 120.1 2005/10/30 04:58:33 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000
2: /* $Header: OKLIECCB.pls 120.1 2005/10/30 04:58:33 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
54: end loop;
55: end if;
56: end if;
57: end rosetta_table_copy_in_p1;
58: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_VARCHAR2_TABLE_300
55: end if;
56: end if;
57: end rosetta_table_copy_in_p1;
58: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_VARCHAR2_TABLE_300
63: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
57: end rosetta_table_copy_in_p1;
58: procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_VARCHAR2_TABLE_300
63: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a6 out nocopy JTF_VARCHAR2_TABLE_100
65: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a7 out nocopy JTF_VARCHAR2_TABLE_100
66: , a8 out nocopy JTF_VARCHAR2_TABLE_100
67: , a9 out nocopy JTF_VARCHAR2_TABLE_100
68: , a10 out nocopy JTF_VARCHAR2_TABLE_100
69: , a11 out nocopy JTF_NUMBER_TABLE
70: , a12 out nocopy JTF_VARCHAR2_TABLE_100
71: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a14 out nocopy JTF_NUMBER_TABLE
73: , a15 out nocopy JTF_DATE_TABLE
68: , a10 out nocopy JTF_VARCHAR2_TABLE_100
69: , a11 out nocopy JTF_NUMBER_TABLE
70: , a12 out nocopy JTF_VARCHAR2_TABLE_100
71: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a14 out nocopy JTF_NUMBER_TABLE
73: , a15 out nocopy JTF_DATE_TABLE
74: , a16 out nocopy JTF_NUMBER_TABLE
75: , a17 out nocopy JTF_DATE_TABLE
76: , a18 out nocopy JTF_NUMBER_TABLE
70: , a12 out nocopy JTF_VARCHAR2_TABLE_100
71: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a14 out nocopy JTF_NUMBER_TABLE
73: , a15 out nocopy JTF_DATE_TABLE
74: , a16 out nocopy JTF_NUMBER_TABLE
75: , a17 out nocopy JTF_DATE_TABLE
76: , a18 out nocopy JTF_NUMBER_TABLE
77: ) as
78: ddindx binary_integer; indx binary_integer;
72: , a14 out nocopy JTF_NUMBER_TABLE
73: , a15 out nocopy JTF_DATE_TABLE
74: , a16 out nocopy JTF_NUMBER_TABLE
75: , a17 out nocopy JTF_DATE_TABLE
76: , a18 out nocopy JTF_NUMBER_TABLE
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if t is null or t.count = 0 then
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if t is null or t.count = 0 then
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_VARCHAR2_TABLE_100();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_300();
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if t is null or t.count = 0 then
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_VARCHAR2_TABLE_100();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_300();
86: a5 := JTF_VARCHAR2_TABLE_2000();
80: if t is null or t.count = 0 then
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_NUMBER_TABLE();
83: a2 := JTF_VARCHAR2_TABLE_100();
84: a3 := JTF_NUMBER_TABLE();
85: a4 := JTF_VARCHAR2_TABLE_300();
86: a5 := JTF_VARCHAR2_TABLE_2000();
87: a6 := JTF_VARCHAR2_TABLE_100();
88: a7 := JTF_VARCHAR2_TABLE_100();
88: a7 := JTF_VARCHAR2_TABLE_100();
89: a8 := JTF_VARCHAR2_TABLE_100();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_VARCHAR2_TABLE_100();
92: a11 := JTF_NUMBER_TABLE();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_2000();
95: a14 := JTF_NUMBER_TABLE();
96: a15 := JTF_DATE_TABLE();
91: a10 := JTF_VARCHAR2_TABLE_100();
92: a11 := JTF_NUMBER_TABLE();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_2000();
95: a14 := JTF_NUMBER_TABLE();
96: a15 := JTF_DATE_TABLE();
97: a16 := JTF_NUMBER_TABLE();
98: a17 := JTF_DATE_TABLE();
99: a18 := JTF_NUMBER_TABLE();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_2000();
95: a14 := JTF_NUMBER_TABLE();
96: a15 := JTF_DATE_TABLE();
97: a16 := JTF_NUMBER_TABLE();
98: a17 := JTF_DATE_TABLE();
99: a18 := JTF_NUMBER_TABLE();
100: else
101: a0 := JTF_NUMBER_TABLE();
95: a14 := JTF_NUMBER_TABLE();
96: a15 := JTF_DATE_TABLE();
97: a16 := JTF_NUMBER_TABLE();
98: a17 := JTF_DATE_TABLE();
99: a18 := JTF_NUMBER_TABLE();
100: else
101: a0 := JTF_NUMBER_TABLE();
102: a1 := JTF_NUMBER_TABLE();
103: a2 := JTF_VARCHAR2_TABLE_100();
97: a16 := JTF_NUMBER_TABLE();
98: a17 := JTF_DATE_TABLE();
99: a18 := JTF_NUMBER_TABLE();
100: else
101: a0 := JTF_NUMBER_TABLE();
102: a1 := JTF_NUMBER_TABLE();
103: a2 := JTF_VARCHAR2_TABLE_100();
104: a3 := JTF_NUMBER_TABLE();
105: a4 := JTF_VARCHAR2_TABLE_300();
98: a17 := JTF_DATE_TABLE();
99: a18 := JTF_NUMBER_TABLE();
100: else
101: a0 := JTF_NUMBER_TABLE();
102: a1 := JTF_NUMBER_TABLE();
103: a2 := JTF_VARCHAR2_TABLE_100();
104: a3 := JTF_NUMBER_TABLE();
105: a4 := JTF_VARCHAR2_TABLE_300();
106: a5 := JTF_VARCHAR2_TABLE_2000();
100: else
101: a0 := JTF_NUMBER_TABLE();
102: a1 := JTF_NUMBER_TABLE();
103: a2 := JTF_VARCHAR2_TABLE_100();
104: a3 := JTF_NUMBER_TABLE();
105: a4 := JTF_VARCHAR2_TABLE_300();
106: a5 := JTF_VARCHAR2_TABLE_2000();
107: a6 := JTF_VARCHAR2_TABLE_100();
108: a7 := JTF_VARCHAR2_TABLE_100();
108: a7 := JTF_VARCHAR2_TABLE_100();
109: a8 := JTF_VARCHAR2_TABLE_100();
110: a9 := JTF_VARCHAR2_TABLE_100();
111: a10 := JTF_VARCHAR2_TABLE_100();
112: a11 := JTF_NUMBER_TABLE();
113: a12 := JTF_VARCHAR2_TABLE_100();
114: a13 := JTF_VARCHAR2_TABLE_2000();
115: a14 := JTF_NUMBER_TABLE();
116: a15 := JTF_DATE_TABLE();
111: a10 := JTF_VARCHAR2_TABLE_100();
112: a11 := JTF_NUMBER_TABLE();
113: a12 := JTF_VARCHAR2_TABLE_100();
114: a13 := JTF_VARCHAR2_TABLE_2000();
115: a14 := JTF_NUMBER_TABLE();
116: a15 := JTF_DATE_TABLE();
117: a16 := JTF_NUMBER_TABLE();
118: a17 := JTF_DATE_TABLE();
119: a18 := JTF_NUMBER_TABLE();
113: a12 := JTF_VARCHAR2_TABLE_100();
114: a13 := JTF_VARCHAR2_TABLE_2000();
115: a14 := JTF_NUMBER_TABLE();
116: a15 := JTF_DATE_TABLE();
117: a16 := JTF_NUMBER_TABLE();
118: a17 := JTF_DATE_TABLE();
119: a18 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
115: a14 := JTF_NUMBER_TABLE();
116: a15 := JTF_DATE_TABLE();
117: a16 := JTF_NUMBER_TABLE();
118: a17 := JTF_DATE_TABLE();
119: a18 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
122: a1.extend(t.count);
123: a2.extend(t.count);
168: end if;
169: end if;
170: end rosetta_table_copy_out_p1;
171:
172: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_VARCHAR2_TABLE_300
175: , a3 JTF_VARCHAR2_TABLE_100
176: , a4 JTF_NUMBER_TABLE
169: end if;
170: end rosetta_table_copy_out_p1;
171:
172: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_VARCHAR2_TABLE_300
175: , a3 JTF_VARCHAR2_TABLE_100
176: , a4 JTF_NUMBER_TABLE
177: , a5 JTF_VARCHAR2_TABLE_100
172: procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_VARCHAR2_TABLE_300
175: , a3 JTF_VARCHAR2_TABLE_100
176: , a4 JTF_NUMBER_TABLE
177: , a5 JTF_VARCHAR2_TABLE_100
178: , a6 JTF_VARCHAR2_TABLE_100
179: , a7 JTF_VARCHAR2_TABLE_100
180: , a8 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_100
178: , a6 JTF_VARCHAR2_TABLE_100
179: , a7 JTF_VARCHAR2_TABLE_100
180: , a8 JTF_VARCHAR2_TABLE_100
181: , a9 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_2000
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_DATE_TABLE
180: , a8 JTF_VARCHAR2_TABLE_100
181: , a9 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_2000
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_DATE_TABLE
186: , a14 JTF_NUMBER_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_2000
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_DATE_TABLE
186: , a14 JTF_NUMBER_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
184: , a12 JTF_NUMBER_TABLE
185: , a13 JTF_DATE_TABLE
186: , a14 JTF_NUMBER_TABLE
187: , a15 JTF_DATE_TABLE
188: , a16 JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin
192: if a0 is not null and a0.count > 0 then
219: end loop;
220: end if;
221: end if;
222: end rosetta_table_copy_in_p3;
223: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_VARCHAR2_TABLE_300
226: , a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , a4 out nocopy JTF_NUMBER_TABLE
220: end if;
221: end if;
222: end rosetta_table_copy_in_p3;
223: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_VARCHAR2_TABLE_300
226: , a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_100
223: procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_VARCHAR2_TABLE_300
226: , a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_100
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , a8 out nocopy JTF_VARCHAR2_TABLE_100
228: , a5 out nocopy JTF_VARCHAR2_TABLE_100
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , a8 out nocopy JTF_VARCHAR2_TABLE_100
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_DATE_TABLE
231: , a8 out nocopy JTF_VARCHAR2_TABLE_100
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_DATE_TABLE
237: , a14 out nocopy JTF_NUMBER_TABLE
238: , a15 out nocopy JTF_DATE_TABLE
239: , a16 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_DATE_TABLE
237: , a14 out nocopy JTF_NUMBER_TABLE
238: , a15 out nocopy JTF_DATE_TABLE
239: , a16 out nocopy JTF_NUMBER_TABLE
240: ) as
241: ddindx binary_integer; indx binary_integer;
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_DATE_TABLE
237: , a14 out nocopy JTF_NUMBER_TABLE
238: , a15 out nocopy JTF_DATE_TABLE
239: , a16 out nocopy JTF_NUMBER_TABLE
240: ) as
241: ddindx binary_integer; indx binary_integer;
242: begin
243: if t is null or t.count = 0 then
240: ) as
241: ddindx binary_integer; indx binary_integer;
242: begin
243: if t is null or t.count = 0 then
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_300();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
241: ddindx binary_integer; indx binary_integer;
242: begin
243: if t is null or t.count = 0 then
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_300();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_VARCHAR2_TABLE_100();
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_300();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_VARCHAR2_TABLE_100();
252: a8 := JTF_VARCHAR2_TABLE_100();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_VARCHAR2_TABLE_100();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_2000();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_DATE_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_2000();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_DATE_TABLE();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_DATE_TABLE();
260: a16 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_2000();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_DATE_TABLE();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_DATE_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: else
262: a0 := JTF_NUMBER_TABLE();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_DATE_TABLE();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_DATE_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_300();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_DATE_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_300();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_NUMBER_TABLE();
259: a15 := JTF_DATE_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: else
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_300();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_NUMBER_TABLE();
267: a5 := JTF_VARCHAR2_TABLE_100();
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_300();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_NUMBER_TABLE();
267: a5 := JTF_VARCHAR2_TABLE_100();
268: a6 := JTF_VARCHAR2_TABLE_100();
269: a7 := JTF_VARCHAR2_TABLE_100();
270: a8 := JTF_VARCHAR2_TABLE_100();
267: a5 := JTF_VARCHAR2_TABLE_100();
268: a6 := JTF_VARCHAR2_TABLE_100();
269: a7 := JTF_VARCHAR2_TABLE_100();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
273: a11 := JTF_VARCHAR2_TABLE_2000();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_DATE_TABLE();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
273: a11 := JTF_VARCHAR2_TABLE_2000();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_DATE_TABLE();
276: a14 := JTF_NUMBER_TABLE();
277: a15 := JTF_DATE_TABLE();
278: a16 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
273: a11 := JTF_VARCHAR2_TABLE_2000();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_DATE_TABLE();
276: a14 := JTF_NUMBER_TABLE();
277: a15 := JTF_DATE_TABLE();
278: a16 := JTF_NUMBER_TABLE();
279: if t.count > 0 then
280: a0.extend(t.count);
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_DATE_TABLE();
276: a14 := JTF_NUMBER_TABLE();
277: a15 := JTF_DATE_TABLE();
278: a16 := JTF_NUMBER_TABLE();
279: if t.count > 0 then
280: a0.extend(t.count);
281: a1.extend(t.count);
282: a2.extend(t.count);
323: end if;
324: end if;
325: end rosetta_table_copy_out_p3;
326:
327: procedure rosetta_table_copy_in_p5(t out nocopy okl_ecc_pvt.okl_ecctl_tbl, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_2000
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_2000
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_NUMBER_TABLE
335: , a8 JTF_DATE_TABLE
336: , a9 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_2000
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_NUMBER_TABLE
335: , a8 JTF_DATE_TABLE
336: , a9 JTF_NUMBER_TABLE
337: ) as
338: ddindx binary_integer; indx binary_integer;
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_NUMBER_TABLE
335: , a8 JTF_DATE_TABLE
336: , a9 JTF_NUMBER_TABLE
337: ) as
338: ddindx binary_integer; indx binary_integer;
339: begin
340: if a0 is not null and a0.count > 0 then
360: end loop;
361: end if;
362: end if;
363: end rosetta_table_copy_in_p5;
364: procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE
365: , a1 out nocopy JTF_VARCHAR2_TABLE_100
366: , a2 out nocopy JTF_VARCHAR2_TABLE_100
367: , a3 out nocopy JTF_VARCHAR2_TABLE_100
368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
365: , a1 out nocopy JTF_VARCHAR2_TABLE_100
366: , a2 out nocopy JTF_VARCHAR2_TABLE_100
367: , a3 out nocopy JTF_VARCHAR2_TABLE_100
368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
371: , a7 out nocopy JTF_NUMBER_TABLE
372: , a8 out nocopy JTF_DATE_TABLE
373: , a9 out nocopy JTF_NUMBER_TABLE
367: , a3 out nocopy JTF_VARCHAR2_TABLE_100
368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
371: , a7 out nocopy JTF_NUMBER_TABLE
372: , a8 out nocopy JTF_DATE_TABLE
373: , a9 out nocopy JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
371: , a7 out nocopy JTF_NUMBER_TABLE
372: , a8 out nocopy JTF_DATE_TABLE
373: , a9 out nocopy JTF_NUMBER_TABLE
374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if t is null or t.count = 0 then
374: ) as
375: ddindx binary_integer; indx binary_integer;
376: begin
377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_100();
380: a2 := JTF_VARCHAR2_TABLE_100();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_2000();
379: a1 := JTF_VARCHAR2_TABLE_100();
380: a2 := JTF_VARCHAR2_TABLE_100();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_2000();
383: a5 := JTF_NUMBER_TABLE();
384: a6 := JTF_DATE_TABLE();
385: a7 := JTF_NUMBER_TABLE();
386: a8 := JTF_DATE_TABLE();
387: a9 := JTF_NUMBER_TABLE();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_2000();
383: a5 := JTF_NUMBER_TABLE();
384: a6 := JTF_DATE_TABLE();
385: a7 := JTF_NUMBER_TABLE();
386: a8 := JTF_DATE_TABLE();
387: a9 := JTF_NUMBER_TABLE();
388: else
389: a0 := JTF_NUMBER_TABLE();
383: a5 := JTF_NUMBER_TABLE();
384: a6 := JTF_DATE_TABLE();
385: a7 := JTF_NUMBER_TABLE();
386: a8 := JTF_DATE_TABLE();
387: a9 := JTF_NUMBER_TABLE();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_100();
385: a7 := JTF_NUMBER_TABLE();
386: a8 := JTF_DATE_TABLE();
387: a9 := JTF_NUMBER_TABLE();
388: else
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_100();
392: a3 := JTF_VARCHAR2_TABLE_100();
393: a4 := JTF_VARCHAR2_TABLE_2000();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_100();
392: a3 := JTF_VARCHAR2_TABLE_100();
393: a4 := JTF_VARCHAR2_TABLE_2000();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
397: a8 := JTF_DATE_TABLE();
398: a9 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_100();
393: a4 := JTF_VARCHAR2_TABLE_2000();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
397: a8 := JTF_DATE_TABLE();
398: a9 := JTF_NUMBER_TABLE();
399: if t.count > 0 then
400: a0.extend(t.count);
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
397: a8 := JTF_DATE_TABLE();
398: a9 := JTF_NUMBER_TABLE();
399: if t.count > 0 then
400: a0.extend(t.count);
401: a1.extend(t.count);
402: a2.extend(t.count);
549: , p_init_msg_list VARCHAR2
550: , x_return_status out nocopy VARCHAR2
551: , x_msg_count out nocopy NUMBER
552: , x_msg_data out nocopy VARCHAR2
553: , p5_a0 JTF_NUMBER_TABLE
554: , p5_a1 JTF_NUMBER_TABLE
555: , p5_a2 JTF_VARCHAR2_TABLE_100
556: , p5_a3 JTF_NUMBER_TABLE
557: , p5_a4 JTF_VARCHAR2_TABLE_300
550: , x_return_status out nocopy VARCHAR2
551: , x_msg_count out nocopy NUMBER
552: , x_msg_data out nocopy VARCHAR2
553: , p5_a0 JTF_NUMBER_TABLE
554: , p5_a1 JTF_NUMBER_TABLE
555: , p5_a2 JTF_VARCHAR2_TABLE_100
556: , p5_a3 JTF_NUMBER_TABLE
557: , p5_a4 JTF_VARCHAR2_TABLE_300
558: , p5_a5 JTF_VARCHAR2_TABLE_2000
552: , x_msg_data out nocopy VARCHAR2
553: , p5_a0 JTF_NUMBER_TABLE
554: , p5_a1 JTF_NUMBER_TABLE
555: , p5_a2 JTF_VARCHAR2_TABLE_100
556: , p5_a3 JTF_NUMBER_TABLE
557: , p5_a4 JTF_VARCHAR2_TABLE_300
558: , p5_a5 JTF_VARCHAR2_TABLE_2000
559: , p5_a6 JTF_VARCHAR2_TABLE_100
560: , p5_a7 JTF_VARCHAR2_TABLE_100
560: , p5_a7 JTF_VARCHAR2_TABLE_100
561: , p5_a8 JTF_VARCHAR2_TABLE_100
562: , p5_a9 JTF_VARCHAR2_TABLE_100
563: , p5_a10 JTF_VARCHAR2_TABLE_100
564: , p5_a11 JTF_NUMBER_TABLE
565: , p5_a12 JTF_VARCHAR2_TABLE_100
566: , p5_a13 JTF_VARCHAR2_TABLE_2000
567: , p5_a14 JTF_NUMBER_TABLE
568: , p5_a15 JTF_DATE_TABLE
563: , p5_a10 JTF_VARCHAR2_TABLE_100
564: , p5_a11 JTF_NUMBER_TABLE
565: , p5_a12 JTF_VARCHAR2_TABLE_100
566: , p5_a13 JTF_VARCHAR2_TABLE_2000
567: , p5_a14 JTF_NUMBER_TABLE
568: , p5_a15 JTF_DATE_TABLE
569: , p5_a16 JTF_NUMBER_TABLE
570: , p5_a17 JTF_DATE_TABLE
571: , p5_a18 JTF_NUMBER_TABLE
565: , p5_a12 JTF_VARCHAR2_TABLE_100
566: , p5_a13 JTF_VARCHAR2_TABLE_2000
567: , p5_a14 JTF_NUMBER_TABLE
568: , p5_a15 JTF_DATE_TABLE
569: , p5_a16 JTF_NUMBER_TABLE
570: , p5_a17 JTF_DATE_TABLE
571: , p5_a18 JTF_NUMBER_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a14 JTF_NUMBER_TABLE
568: , p5_a15 JTF_DATE_TABLE
569: , p5_a16 JTF_NUMBER_TABLE
570: , p5_a17 JTF_DATE_TABLE
571: , p5_a18 JTF_NUMBER_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_NUMBER_TABLE
568: , p5_a15 JTF_DATE_TABLE
569: , p5_a16 JTF_NUMBER_TABLE
570: , p5_a17 JTF_DATE_TABLE
571: , p5_a18 JTF_NUMBER_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_NUMBER_TABLE
576: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
569: , p5_a16 JTF_NUMBER_TABLE
570: , p5_a17 JTF_DATE_TABLE
571: , p5_a18 JTF_NUMBER_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_NUMBER_TABLE
576: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
571: , p5_a18 JTF_NUMBER_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_NUMBER_TABLE
576: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
579: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
579: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
581: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
582: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a11 out nocopy JTF_NUMBER_TABLE
584: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
586: , p6_a14 out nocopy JTF_NUMBER_TABLE
587: , p6_a15 out nocopy JTF_DATE_TABLE
582: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a11 out nocopy JTF_NUMBER_TABLE
584: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
586: , p6_a14 out nocopy JTF_NUMBER_TABLE
587: , p6_a15 out nocopy JTF_DATE_TABLE
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
589: , p6_a17 out nocopy JTF_DATE_TABLE
590: , p6_a18 out nocopy JTF_NUMBER_TABLE
584: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
586: , p6_a14 out nocopy JTF_NUMBER_TABLE
587: , p6_a15 out nocopy JTF_DATE_TABLE
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
589: , p6_a17 out nocopy JTF_DATE_TABLE
590: , p6_a18 out nocopy JTF_NUMBER_TABLE
591: )
592:
586: , p6_a14 out nocopy JTF_NUMBER_TABLE
587: , p6_a15 out nocopy JTF_DATE_TABLE
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
589: , p6_a17 out nocopy JTF_DATE_TABLE
590: , p6_a18 out nocopy JTF_NUMBER_TABLE
591: )
592:
593: as
594: ddp_eccv_tbl okl_ecc_pvt.okl_eccv_tbl;
781: , p_init_msg_list VARCHAR2
782: , x_return_status out nocopy VARCHAR2
783: , x_msg_count out nocopy NUMBER
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_VARCHAR2_TABLE_100
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_300
782: , x_return_status out nocopy VARCHAR2
783: , x_msg_count out nocopy NUMBER
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_VARCHAR2_TABLE_100
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_300
790: , p5_a5 JTF_VARCHAR2_TABLE_2000
784: , x_msg_data out nocopy VARCHAR2
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_VARCHAR2_TABLE_100
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_300
790: , p5_a5 JTF_VARCHAR2_TABLE_2000
791: , p5_a6 JTF_VARCHAR2_TABLE_100
792: , p5_a7 JTF_VARCHAR2_TABLE_100
792: , p5_a7 JTF_VARCHAR2_TABLE_100
793: , p5_a8 JTF_VARCHAR2_TABLE_100
794: , p5_a9 JTF_VARCHAR2_TABLE_100
795: , p5_a10 JTF_VARCHAR2_TABLE_100
796: , p5_a11 JTF_NUMBER_TABLE
797: , p5_a12 JTF_VARCHAR2_TABLE_100
798: , p5_a13 JTF_VARCHAR2_TABLE_2000
799: , p5_a14 JTF_NUMBER_TABLE
800: , p5_a15 JTF_DATE_TABLE
795: , p5_a10 JTF_VARCHAR2_TABLE_100
796: , p5_a11 JTF_NUMBER_TABLE
797: , p5_a12 JTF_VARCHAR2_TABLE_100
798: , p5_a13 JTF_VARCHAR2_TABLE_2000
799: , p5_a14 JTF_NUMBER_TABLE
800: , p5_a15 JTF_DATE_TABLE
801: , p5_a16 JTF_NUMBER_TABLE
802: , p5_a17 JTF_DATE_TABLE
803: , p5_a18 JTF_NUMBER_TABLE
797: , p5_a12 JTF_VARCHAR2_TABLE_100
798: , p5_a13 JTF_VARCHAR2_TABLE_2000
799: , p5_a14 JTF_NUMBER_TABLE
800: , p5_a15 JTF_DATE_TABLE
801: , p5_a16 JTF_NUMBER_TABLE
802: , p5_a17 JTF_DATE_TABLE
803: , p5_a18 JTF_NUMBER_TABLE
804: , p6_a0 out nocopy JTF_NUMBER_TABLE
805: , p6_a1 out nocopy JTF_NUMBER_TABLE
799: , p5_a14 JTF_NUMBER_TABLE
800: , p5_a15 JTF_DATE_TABLE
801: , p5_a16 JTF_NUMBER_TABLE
802: , p5_a17 JTF_DATE_TABLE
803: , p5_a18 JTF_NUMBER_TABLE
804: , p6_a0 out nocopy JTF_NUMBER_TABLE
805: , p6_a1 out nocopy JTF_NUMBER_TABLE
806: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a3 out nocopy JTF_NUMBER_TABLE
800: , p5_a15 JTF_DATE_TABLE
801: , p5_a16 JTF_NUMBER_TABLE
802: , p5_a17 JTF_DATE_TABLE
803: , p5_a18 JTF_NUMBER_TABLE
804: , p6_a0 out nocopy JTF_NUMBER_TABLE
805: , p6_a1 out nocopy JTF_NUMBER_TABLE
806: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a3 out nocopy JTF_NUMBER_TABLE
808: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
801: , p5_a16 JTF_NUMBER_TABLE
802: , p5_a17 JTF_DATE_TABLE
803: , p5_a18 JTF_NUMBER_TABLE
804: , p6_a0 out nocopy JTF_NUMBER_TABLE
805: , p6_a1 out nocopy JTF_NUMBER_TABLE
806: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a3 out nocopy JTF_NUMBER_TABLE
808: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
809: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
803: , p5_a18 JTF_NUMBER_TABLE
804: , p6_a0 out nocopy JTF_NUMBER_TABLE
805: , p6_a1 out nocopy JTF_NUMBER_TABLE
806: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a3 out nocopy JTF_NUMBER_TABLE
808: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
809: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
810: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
811: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
811: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
812: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
813: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
814: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a11 out nocopy JTF_NUMBER_TABLE
816: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
817: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
818: , p6_a14 out nocopy JTF_NUMBER_TABLE
819: , p6_a15 out nocopy JTF_DATE_TABLE
814: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a11 out nocopy JTF_NUMBER_TABLE
816: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
817: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
818: , p6_a14 out nocopy JTF_NUMBER_TABLE
819: , p6_a15 out nocopy JTF_DATE_TABLE
820: , p6_a16 out nocopy JTF_NUMBER_TABLE
821: , p6_a17 out nocopy JTF_DATE_TABLE
822: , p6_a18 out nocopy JTF_NUMBER_TABLE
816: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
817: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
818: , p6_a14 out nocopy JTF_NUMBER_TABLE
819: , p6_a15 out nocopy JTF_DATE_TABLE
820: , p6_a16 out nocopy JTF_NUMBER_TABLE
821: , p6_a17 out nocopy JTF_DATE_TABLE
822: , p6_a18 out nocopy JTF_NUMBER_TABLE
823: )
824:
818: , p6_a14 out nocopy JTF_NUMBER_TABLE
819: , p6_a15 out nocopy JTF_DATE_TABLE
820: , p6_a16 out nocopy JTF_NUMBER_TABLE
821: , p6_a17 out nocopy JTF_DATE_TABLE
822: , p6_a18 out nocopy JTF_NUMBER_TABLE
823: )
824:
825: as
826: ddp_eccv_tbl okl_ecc_pvt.okl_eccv_tbl;
971: , p_init_msg_list VARCHAR2
972: , x_return_status out nocopy VARCHAR2
973: , x_msg_count out nocopy NUMBER
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_NUMBER_TABLE
977: , p5_a2 JTF_VARCHAR2_TABLE_100
978: , p5_a3 JTF_NUMBER_TABLE
979: , p5_a4 JTF_VARCHAR2_TABLE_300
972: , x_return_status out nocopy VARCHAR2
973: , x_msg_count out nocopy NUMBER
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_NUMBER_TABLE
977: , p5_a2 JTF_VARCHAR2_TABLE_100
978: , p5_a3 JTF_NUMBER_TABLE
979: , p5_a4 JTF_VARCHAR2_TABLE_300
980: , p5_a5 JTF_VARCHAR2_TABLE_2000
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_NUMBER_TABLE
977: , p5_a2 JTF_VARCHAR2_TABLE_100
978: , p5_a3 JTF_NUMBER_TABLE
979: , p5_a4 JTF_VARCHAR2_TABLE_300
980: , p5_a5 JTF_VARCHAR2_TABLE_2000
981: , p5_a6 JTF_VARCHAR2_TABLE_100
982: , p5_a7 JTF_VARCHAR2_TABLE_100
982: , p5_a7 JTF_VARCHAR2_TABLE_100
983: , p5_a8 JTF_VARCHAR2_TABLE_100
984: , p5_a9 JTF_VARCHAR2_TABLE_100
985: , p5_a10 JTF_VARCHAR2_TABLE_100
986: , p5_a11 JTF_NUMBER_TABLE
987: , p5_a12 JTF_VARCHAR2_TABLE_100
988: , p5_a13 JTF_VARCHAR2_TABLE_2000
989: , p5_a14 JTF_NUMBER_TABLE
990: , p5_a15 JTF_DATE_TABLE
985: , p5_a10 JTF_VARCHAR2_TABLE_100
986: , p5_a11 JTF_NUMBER_TABLE
987: , p5_a12 JTF_VARCHAR2_TABLE_100
988: , p5_a13 JTF_VARCHAR2_TABLE_2000
989: , p5_a14 JTF_NUMBER_TABLE
990: , p5_a15 JTF_DATE_TABLE
991: , p5_a16 JTF_NUMBER_TABLE
992: , p5_a17 JTF_DATE_TABLE
993: , p5_a18 JTF_NUMBER_TABLE
987: , p5_a12 JTF_VARCHAR2_TABLE_100
988: , p5_a13 JTF_VARCHAR2_TABLE_2000
989: , p5_a14 JTF_NUMBER_TABLE
990: , p5_a15 JTF_DATE_TABLE
991: , p5_a16 JTF_NUMBER_TABLE
992: , p5_a17 JTF_DATE_TABLE
993: , p5_a18 JTF_NUMBER_TABLE
994: )
995:
989: , p5_a14 JTF_NUMBER_TABLE
990: , p5_a15 JTF_DATE_TABLE
991: , p5_a16 JTF_NUMBER_TABLE
992: , p5_a17 JTF_DATE_TABLE
993: , p5_a18 JTF_NUMBER_TABLE
994: )
995:
996: as
997: ddp_eccv_tbl okl_ecc_pvt.okl_eccv_tbl;