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
9: , a6 JTF_VARCHAR2_TABLE_100
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
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 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
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 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
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
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 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
9: , a6 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
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
19: , a16 JTF_NUMBER_TABLE
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
64: , a6 out nocopy JTF_VARCHAR2_TABLE_100
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
66: , a8 out nocopy JTF_VARCHAR2_TABLE_100
67: , a9 out nocopy JTF_VARCHAR2_TABLE_100
68: , a10 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
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
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
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
63: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a6 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
64: , a6 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
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
74: , a16 out nocopy JTF_NUMBER_TABLE
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();
87: a6 := JTF_VARCHAR2_TABLE_100();
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();
89: a8 := JTF_VARCHAR2_TABLE_100();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := 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();
89: a8 := JTF_VARCHAR2_TABLE_100();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_VARCHAR2_TABLE_100();
92: a11 := 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();
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();
86: a5 := JTF_VARCHAR2_TABLE_2000();
87: a6 := 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();
87: a6 := 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();
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();
97: a16 := JTF_NUMBER_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();
107: a6 := JTF_VARCHAR2_TABLE_100();
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();
109: a8 := JTF_VARCHAR2_TABLE_100();
110: a9 := JTF_VARCHAR2_TABLE_100();
111: a10 := 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();
109: a8 := JTF_VARCHAR2_TABLE_100();
110: a9 := JTF_VARCHAR2_TABLE_100();
111: a10 := JTF_VARCHAR2_TABLE_100();
112: a11 := 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();
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();
106: a5 := JTF_VARCHAR2_TABLE_2000();
107: a6 := 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();
107: a6 := 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();
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();
117: a16 := JTF_NUMBER_TABLE();
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
178: , a6 JTF_VARCHAR2_TABLE_100
179: , a7 JTF_VARCHAR2_TABLE_100
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
181: , a9 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
181: , a9 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
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
181: , a9 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_2000
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
181: , a9 JTF_NUMBER_TABLE
182: , a10 JTF_VARCHAR2_TABLE_100
183: , a11 JTF_VARCHAR2_TABLE_2000
184: , a12 JTF_NUMBER_TABLE
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
186: , a14 JTF_NUMBER_TABLE
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
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_VARCHAR2_TABLE_100
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
232: , a9 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
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_100
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
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
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
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
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
237: , a14 out nocopy JTF_NUMBER_TABLE
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();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_VARCHAR2_TABLE_100();
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();
253: a9 := 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();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
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();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_2000();
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();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_2000();
256: a12 := JTF_NUMBER_TABLE();
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();
258: a14 := 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();
268: a6 := JTF_VARCHAR2_TABLE_100();
269: a7 := JTF_VARCHAR2_TABLE_100();
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();
271: a9 := 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();
271: a9 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
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();
271: a9 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
273: a11 := JTF_VARCHAR2_TABLE_2000();
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();
271: a9 := JTF_NUMBER_TABLE();
272: a10 := JTF_VARCHAR2_TABLE_100();
273: a11 := JTF_VARCHAR2_TABLE_2000();
274: a12 := JTF_NUMBER_TABLE();
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();
276: a14 := JTF_NUMBER_TABLE();
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
332: , a5 JTF_NUMBER_TABLE
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
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
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
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_NUMBER_TABLE
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
369: , a5 out nocopy JTF_NUMBER_TABLE
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
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
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
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
371: , a7 out nocopy JTF_NUMBER_TABLE
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();
383: a5 := JTF_NUMBER_TABLE();
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();
383: a5 := JTF_NUMBER_TABLE();
384: a6 := JTF_DATE_TABLE();
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();
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();
392: a3 := JTF_VARCHAR2_TABLE_100();
393: a4 := JTF_VARCHAR2_TABLE_2000();
394: a5 := JTF_NUMBER_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();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_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();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
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
559: , p5_a6 JTF_VARCHAR2_TABLE_100
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
561: , p5_a8 JTF_VARCHAR2_TABLE_100
562: , p5_a9 JTF_VARCHAR2_TABLE_100
563: , p5_a10 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
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
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
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
558: , p5_a5 JTF_VARCHAR2_TABLE_2000
559: , p5_a6 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
559: , p5_a6 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
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
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
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
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
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
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
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
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
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
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
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
578: , p6_a6 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
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
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
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
791: , p5_a6 JTF_VARCHAR2_TABLE_100
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
793: , p5_a8 JTF_VARCHAR2_TABLE_100
794: , p5_a9 JTF_VARCHAR2_TABLE_100
795: , p5_a10 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
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
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
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
790: , p5_a5 JTF_VARCHAR2_TABLE_2000
791: , p5_a6 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
791: , p5_a6 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
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
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
810: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
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
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
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
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
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
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
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
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
810: , p6_a6 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
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
820: , p6_a16 out nocopy JTF_NUMBER_TABLE
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
981: , p5_a6 JTF_VARCHAR2_TABLE_100
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
983: , p5_a8 JTF_VARCHAR2_TABLE_100
984: , p5_a9 JTF_VARCHAR2_TABLE_100
985: , p5_a10 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
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
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
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
980: , p5_a5 JTF_VARCHAR2_TABLE_2000
981: , p5_a6 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
981: , p5_a6 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
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
991: , p5_a16 JTF_NUMBER_TABLE