1: package body ahl_prd_mrshl_pvt_w as
2: /* $Header: AHLWPMLB.pls 120.1.12020000.2 2012/12/14 03:35:09 shnatu ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_prd_mrshl_pvt_w as
2: /* $Header: AHLWPMLB.pls 120.1.12020000.2 2012/12/14 03:35:09 shnatu ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: ) as
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if a0 is not null and a0.count > 0 then
92: end loop;
93: end if;
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_300
99: , a3 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
93: end if;
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_300
99: , a3 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
96: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_300
99: , a3 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_VARCHAR2_TABLE_300
99: , a3 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a3 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_VARCHAR2_TABLE_100
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_VARCHAR2_TABLE_100
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_DATE_TABLE
105: , a9 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_VARCHAR2_TABLE_100
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_DATE_TABLE
113: , a17 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_NUMBER_TABLE
110: , a14 out nocopy JTF_VARCHAR2_TABLE_100
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_DATE_TABLE
113: , a17 out nocopy JTF_NUMBER_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_VARCHAR2_TABLE_100
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_DATE_TABLE
113: , a17 out nocopy JTF_NUMBER_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
118: , a22 out nocopy JTF_NUMBER_TABLE
112: , a16 out nocopy JTF_DATE_TABLE
113: , a17 out nocopy JTF_NUMBER_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
118: , a22 out nocopy JTF_NUMBER_TABLE
119: , a23 out nocopy JTF_NUMBER_TABLE
120: , a24 out nocopy JTF_NUMBER_TABLE
114: , a18 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
118: , a22 out nocopy JTF_NUMBER_TABLE
119: , a23 out nocopy JTF_NUMBER_TABLE
120: , a24 out nocopy JTF_NUMBER_TABLE
121: , a25 out nocopy JTF_VARCHAR2_TABLE_100
122: , a26 out nocopy JTF_NUMBER_TABLE
115: , a19 out nocopy JTF_DATE_TABLE
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
118: , a22 out nocopy JTF_NUMBER_TABLE
119: , a23 out nocopy JTF_NUMBER_TABLE
120: , a24 out nocopy JTF_NUMBER_TABLE
121: , a25 out nocopy JTF_VARCHAR2_TABLE_100
122: , a26 out nocopy JTF_NUMBER_TABLE
123: , a27 out nocopy JTF_VARCHAR2_TABLE_300
116: , a20 out nocopy JTF_NUMBER_TABLE
117: , a21 out nocopy JTF_DATE_TABLE
118: , a22 out nocopy JTF_NUMBER_TABLE
119: , a23 out nocopy JTF_NUMBER_TABLE
120: , a24 out nocopy JTF_NUMBER_TABLE
121: , a25 out nocopy JTF_VARCHAR2_TABLE_100
122: , a26 out nocopy JTF_NUMBER_TABLE
123: , a27 out nocopy JTF_VARCHAR2_TABLE_300
124: , a28 out nocopy JTF_VARCHAR2_TABLE_100
118: , a22 out nocopy JTF_NUMBER_TABLE
119: , a23 out nocopy JTF_NUMBER_TABLE
120: , a24 out nocopy JTF_NUMBER_TABLE
121: , a25 out nocopy JTF_VARCHAR2_TABLE_100
122: , a26 out nocopy JTF_NUMBER_TABLE
123: , a27 out nocopy JTF_VARCHAR2_TABLE_300
124: , a28 out nocopy JTF_VARCHAR2_TABLE_100
125: , a29 out nocopy JTF_VARCHAR2_TABLE_100
126: , a30 out nocopy JTF_VARCHAR2_TABLE_100
126: , a30 out nocopy JTF_VARCHAR2_TABLE_100
127: , a31 out nocopy JTF_VARCHAR2_TABLE_100
128: , a32 out nocopy JTF_VARCHAR2_TABLE_100
129: , a33 out nocopy JTF_VARCHAR2_TABLE_100
130: , a34 out nocopy JTF_NUMBER_TABLE
131: , a35 out nocopy JTF_VARCHAR2_TABLE_100
132: , a36 out nocopy JTF_VARCHAR2_TABLE_100
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
129: , a33 out nocopy JTF_VARCHAR2_TABLE_100
130: , a34 out nocopy JTF_NUMBER_TABLE
131: , a35 out nocopy JTF_VARCHAR2_TABLE_100
132: , a36 out nocopy JTF_VARCHAR2_TABLE_100
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_300();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_NUMBER_TABLE();
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_300();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_300();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
140: a2 := JTF_VARCHAR2_TABLE_300();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
149: a11 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_VARCHAR2_TABLE_100();
153: a15 := JTF_VARCHAR2_TABLE_100();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_VARCHAR2_TABLE_100();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_DATE_TABLE();
147: a9 := JTF_VARCHAR2_TABLE_100();
148: a10 := JTF_VARCHAR2_TABLE_100();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_VARCHAR2_TABLE_100();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_DATE_TABLE();
155: a17 := JTF_NUMBER_TABLE();
151: a13 := JTF_NUMBER_TABLE();
152: a14 := JTF_VARCHAR2_TABLE_100();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_DATE_TABLE();
155: a17 := JTF_NUMBER_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
152: a14 := JTF_VARCHAR2_TABLE_100();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_DATE_TABLE();
155: a17 := JTF_NUMBER_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
160: a22 := JTF_NUMBER_TABLE();
154: a16 := JTF_DATE_TABLE();
155: a17 := JTF_NUMBER_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
160: a22 := JTF_NUMBER_TABLE();
161: a23 := JTF_NUMBER_TABLE();
162: a24 := JTF_NUMBER_TABLE();
156: a18 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
160: a22 := JTF_NUMBER_TABLE();
161: a23 := JTF_NUMBER_TABLE();
162: a24 := JTF_NUMBER_TABLE();
163: a25 := JTF_VARCHAR2_TABLE_100();
164: a26 := JTF_NUMBER_TABLE();
157: a19 := JTF_DATE_TABLE();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
160: a22 := JTF_NUMBER_TABLE();
161: a23 := JTF_NUMBER_TABLE();
162: a24 := JTF_NUMBER_TABLE();
163: a25 := JTF_VARCHAR2_TABLE_100();
164: a26 := JTF_NUMBER_TABLE();
165: a27 := JTF_VARCHAR2_TABLE_300();
158: a20 := JTF_NUMBER_TABLE();
159: a21 := JTF_DATE_TABLE();
160: a22 := JTF_NUMBER_TABLE();
161: a23 := JTF_NUMBER_TABLE();
162: a24 := JTF_NUMBER_TABLE();
163: a25 := JTF_VARCHAR2_TABLE_100();
164: a26 := JTF_NUMBER_TABLE();
165: a27 := JTF_VARCHAR2_TABLE_300();
166: a28 := JTF_VARCHAR2_TABLE_100();
160: a22 := JTF_NUMBER_TABLE();
161: a23 := JTF_NUMBER_TABLE();
162: a24 := JTF_NUMBER_TABLE();
163: a25 := JTF_VARCHAR2_TABLE_100();
164: a26 := JTF_NUMBER_TABLE();
165: a27 := JTF_VARCHAR2_TABLE_300();
166: a28 := JTF_VARCHAR2_TABLE_100();
167: a29 := JTF_VARCHAR2_TABLE_100();
168: a30 := JTF_VARCHAR2_TABLE_100();
168: a30 := JTF_VARCHAR2_TABLE_100();
169: a31 := JTF_VARCHAR2_TABLE_100();
170: a32 := JTF_VARCHAR2_TABLE_100();
171: a33 := JTF_VARCHAR2_TABLE_100();
172: a34 := JTF_NUMBER_TABLE();
173: a35 := JTF_VARCHAR2_TABLE_100();
174: a36 := JTF_VARCHAR2_TABLE_100();
175: a37 := JTF_NUMBER_TABLE();
176: else
171: a33 := JTF_VARCHAR2_TABLE_100();
172: a34 := JTF_NUMBER_TABLE();
173: a35 := JTF_VARCHAR2_TABLE_100();
174: a36 := JTF_VARCHAR2_TABLE_100();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
173: a35 := JTF_VARCHAR2_TABLE_100();
174: a36 := JTF_VARCHAR2_TABLE_100();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_300();
181: a4 := JTF_NUMBER_TABLE();
174: a36 := JTF_VARCHAR2_TABLE_100();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_300();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_300();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_300();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_VARCHAR2_TABLE_300();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
188: a11 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_DATE_TABLE();
186: a9 := JTF_VARCHAR2_TABLE_100();
187: a10 := JTF_VARCHAR2_TABLE_100();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_DATE_TABLE();
194: a17 := JTF_NUMBER_TABLE();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_DATE_TABLE();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_DATE_TABLE();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
199: a22 := JTF_NUMBER_TABLE();
193: a16 := JTF_DATE_TABLE();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
199: a22 := JTF_NUMBER_TABLE();
200: a23 := JTF_NUMBER_TABLE();
201: a24 := JTF_NUMBER_TABLE();
195: a18 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
199: a22 := JTF_NUMBER_TABLE();
200: a23 := JTF_NUMBER_TABLE();
201: a24 := JTF_NUMBER_TABLE();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_NUMBER_TABLE();
196: a19 := JTF_DATE_TABLE();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
199: a22 := JTF_NUMBER_TABLE();
200: a23 := JTF_NUMBER_TABLE();
201: a24 := JTF_NUMBER_TABLE();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_NUMBER_TABLE();
204: a27 := JTF_VARCHAR2_TABLE_300();
197: a20 := JTF_NUMBER_TABLE();
198: a21 := JTF_DATE_TABLE();
199: a22 := JTF_NUMBER_TABLE();
200: a23 := JTF_NUMBER_TABLE();
201: a24 := JTF_NUMBER_TABLE();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_NUMBER_TABLE();
204: a27 := JTF_VARCHAR2_TABLE_300();
205: a28 := JTF_VARCHAR2_TABLE_100();
199: a22 := JTF_NUMBER_TABLE();
200: a23 := JTF_NUMBER_TABLE();
201: a24 := JTF_NUMBER_TABLE();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_NUMBER_TABLE();
204: a27 := JTF_VARCHAR2_TABLE_300();
205: a28 := JTF_VARCHAR2_TABLE_100();
206: a29 := JTF_VARCHAR2_TABLE_100();
207: a30 := JTF_VARCHAR2_TABLE_100();
207: a30 := JTF_VARCHAR2_TABLE_100();
208: a31 := JTF_VARCHAR2_TABLE_100();
209: a32 := JTF_VARCHAR2_TABLE_100();
210: a33 := JTF_VARCHAR2_TABLE_100();
211: a34 := JTF_NUMBER_TABLE();
212: a35 := JTF_VARCHAR2_TABLE_100();
213: a36 := JTF_VARCHAR2_TABLE_100();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
210: a33 := JTF_VARCHAR2_TABLE_100();
211: a34 := JTF_NUMBER_TABLE();
212: a35 := JTF_VARCHAR2_TABLE_100();
213: a36 := JTF_VARCHAR2_TABLE_100();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
218: a2.extend(t.count);
301: end if;
302: end if;
303: end rosetta_table_copy_out_p2;
304:
305: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_300
308: , a3 JTF_VARCHAR2_TABLE_300
309: , a4 JTF_NUMBER_TABLE
302: end if;
303: end rosetta_table_copy_out_p2;
304:
305: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_300
308: , a3 JTF_VARCHAR2_TABLE_300
309: , a4 JTF_NUMBER_TABLE
310: , a5 JTF_VARCHAR2_TABLE_100
305: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_300
308: , a3 JTF_VARCHAR2_TABLE_300
309: , a4 JTF_NUMBER_TABLE
310: , a5 JTF_VARCHAR2_TABLE_100
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
307: , a2 JTF_VARCHAR2_TABLE_300
308: , a3 JTF_VARCHAR2_TABLE_300
309: , a4 JTF_NUMBER_TABLE
310: , a5 JTF_VARCHAR2_TABLE_100
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_300
309: , a4 JTF_NUMBER_TABLE
310: , a5 JTF_VARCHAR2_TABLE_100
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
316: , a11 JTF_NUMBER_TABLE
309: , a4 JTF_NUMBER_TABLE
310: , a5 JTF_VARCHAR2_TABLE_100
311: , a6 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_VARCHAR2_TABLE_100
320: , a15 JTF_VARCHAR2_TABLE_100
313: , a8 JTF_NUMBER_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_VARCHAR2_TABLE_100
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_DATE_TABLE
314: , a9 JTF_VARCHAR2_TABLE_100
315: , a10 JTF_VARCHAR2_TABLE_100
316: , a11 JTF_NUMBER_TABLE
317: , a12 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_VARCHAR2_TABLE_100
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_DATE_TABLE
322: , a17 JTF_NUMBER_TABLE
318: , a13 JTF_NUMBER_TABLE
319: , a14 JTF_VARCHAR2_TABLE_100
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_DATE_TABLE
322: , a17 JTF_NUMBER_TABLE
323: , a18 JTF_DATE_TABLE
324: , a19 JTF_NUMBER_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
320: , a15 JTF_VARCHAR2_TABLE_100
321: , a16 JTF_DATE_TABLE
322: , a17 JTF_NUMBER_TABLE
323: , a18 JTF_DATE_TABLE
324: , a19 JTF_NUMBER_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
321: , a16 JTF_DATE_TABLE
322: , a17 JTF_NUMBER_TABLE
323: , a18 JTF_DATE_TABLE
324: , a19 JTF_NUMBER_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
329: , a24 JTF_NUMBER_TABLE
323: , a18 JTF_DATE_TABLE
324: , a19 JTF_NUMBER_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
329: , a24 JTF_NUMBER_TABLE
330: , a25 JTF_VARCHAR2_TABLE_100
331: , a26 JTF_NUMBER_TABLE
324: , a19 JTF_NUMBER_TABLE
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
329: , a24 JTF_NUMBER_TABLE
330: , a25 JTF_VARCHAR2_TABLE_100
331: , a26 JTF_NUMBER_TABLE
332: , a27 JTF_VARCHAR2_TABLE_300
325: , a20 JTF_NUMBER_TABLE
326: , a21 JTF_DATE_TABLE
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
329: , a24 JTF_NUMBER_TABLE
330: , a25 JTF_VARCHAR2_TABLE_100
331: , a26 JTF_NUMBER_TABLE
332: , a27 JTF_VARCHAR2_TABLE_300
333: , a28 JTF_VARCHAR2_TABLE_100
327: , a22 JTF_NUMBER_TABLE
328: , a23 JTF_NUMBER_TABLE
329: , a24 JTF_NUMBER_TABLE
330: , a25 JTF_VARCHAR2_TABLE_100
331: , a26 JTF_NUMBER_TABLE
332: , a27 JTF_VARCHAR2_TABLE_300
333: , a28 JTF_VARCHAR2_TABLE_100
334: , a29 JTF_VARCHAR2_TABLE_100
335: , a30 JTF_VARCHAR2_TABLE_100
332: , a27 JTF_VARCHAR2_TABLE_300
333: , a28 JTF_VARCHAR2_TABLE_100
334: , a29 JTF_VARCHAR2_TABLE_100
335: , a30 JTF_VARCHAR2_TABLE_100
336: , a31 JTF_NUMBER_TABLE
337: , a32 JTF_VARCHAR2_TABLE_100
338: , a33 JTF_NUMBER_TABLE
339: , a34 JTF_NUMBER_TABLE
340: , a35 JTF_VARCHAR2_TABLE_100
334: , a29 JTF_VARCHAR2_TABLE_100
335: , a30 JTF_VARCHAR2_TABLE_100
336: , a31 JTF_NUMBER_TABLE
337: , a32 JTF_VARCHAR2_TABLE_100
338: , a33 JTF_NUMBER_TABLE
339: , a34 JTF_NUMBER_TABLE
340: , a35 JTF_VARCHAR2_TABLE_100
341: , a36 JTF_VARCHAR2_TABLE_100
342: , a37 JTF_VARCHAR2_TABLE_100
335: , a30 JTF_VARCHAR2_TABLE_100
336: , a31 JTF_NUMBER_TABLE
337: , a32 JTF_VARCHAR2_TABLE_100
338: , a33 JTF_NUMBER_TABLE
339: , a34 JTF_NUMBER_TABLE
340: , a35 JTF_VARCHAR2_TABLE_100
341: , a36 JTF_VARCHAR2_TABLE_100
342: , a37 JTF_VARCHAR2_TABLE_100
343: , a38 JTF_NUMBER_TABLE
339: , a34 JTF_NUMBER_TABLE
340: , a35 JTF_VARCHAR2_TABLE_100
341: , a36 JTF_VARCHAR2_TABLE_100
342: , a37 JTF_VARCHAR2_TABLE_100
343: , a38 JTF_NUMBER_TABLE
344: , a39 JTF_VARCHAR2_TABLE_100
345: , a40 JTF_VARCHAR2_TABLE_100
346: , a41 JTF_NUMBER_TABLE
347: ) as
342: , a37 JTF_VARCHAR2_TABLE_100
343: , a38 JTF_NUMBER_TABLE
344: , a39 JTF_VARCHAR2_TABLE_100
345: , a40 JTF_VARCHAR2_TABLE_100
346: , a41 JTF_NUMBER_TABLE
347: ) as
348: ddindx binary_integer; indx binary_integer;
349: begin
350: if a0 is not null and a0.count > 0 then
402: end loop;
403: end if;
404: end if;
405: end rosetta_table_copy_in_p4;
406: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_VARCHAR2_TABLE_300
409: , a3 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_NUMBER_TABLE
403: end if;
404: end if;
405: end rosetta_table_copy_in_p4;
406: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_VARCHAR2_TABLE_300
409: , a3 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_NUMBER_TABLE
411: , a5 out nocopy JTF_VARCHAR2_TABLE_100
406: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_VARCHAR2_TABLE_300
409: , a3 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_NUMBER_TABLE
411: , a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_VARCHAR2_TABLE_300
409: , a3 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_NUMBER_TABLE
411: , a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
409: , a3 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_NUMBER_TABLE
411: , a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
417: , a11 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_NUMBER_TABLE
411: , a5 out nocopy JTF_VARCHAR2_TABLE_100
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
417: , a11 out nocopy JTF_NUMBER_TABLE
418: , a12 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
417: , a11 out nocopy JTF_NUMBER_TABLE
418: , a12 out nocopy JTF_NUMBER_TABLE
419: , a13 out nocopy JTF_NUMBER_TABLE
420: , a14 out nocopy JTF_VARCHAR2_TABLE_100
421: , a15 out nocopy JTF_VARCHAR2_TABLE_100
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
417: , a11 out nocopy JTF_NUMBER_TABLE
418: , a12 out nocopy JTF_NUMBER_TABLE
419: , a13 out nocopy JTF_NUMBER_TABLE
420: , a14 out nocopy JTF_VARCHAR2_TABLE_100
421: , a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , a16 out nocopy JTF_DATE_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_100
417: , a11 out nocopy JTF_NUMBER_TABLE
418: , a12 out nocopy JTF_NUMBER_TABLE
419: , a13 out nocopy JTF_NUMBER_TABLE
420: , a14 out nocopy JTF_VARCHAR2_TABLE_100
421: , a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , a16 out nocopy JTF_DATE_TABLE
423: , a17 out nocopy JTF_NUMBER_TABLE
419: , a13 out nocopy JTF_NUMBER_TABLE
420: , a14 out nocopy JTF_VARCHAR2_TABLE_100
421: , a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , a16 out nocopy JTF_DATE_TABLE
423: , a17 out nocopy JTF_NUMBER_TABLE
424: , a18 out nocopy JTF_DATE_TABLE
425: , a19 out nocopy JTF_NUMBER_TABLE
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
421: , a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , a16 out nocopy JTF_DATE_TABLE
423: , a17 out nocopy JTF_NUMBER_TABLE
424: , a18 out nocopy JTF_DATE_TABLE
425: , a19 out nocopy JTF_NUMBER_TABLE
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
422: , a16 out nocopy JTF_DATE_TABLE
423: , a17 out nocopy JTF_NUMBER_TABLE
424: , a18 out nocopy JTF_DATE_TABLE
425: , a19 out nocopy JTF_NUMBER_TABLE
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
430: , a24 out nocopy JTF_NUMBER_TABLE
424: , a18 out nocopy JTF_DATE_TABLE
425: , a19 out nocopy JTF_NUMBER_TABLE
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
430: , a24 out nocopy JTF_NUMBER_TABLE
431: , a25 out nocopy JTF_VARCHAR2_TABLE_100
432: , a26 out nocopy JTF_NUMBER_TABLE
425: , a19 out nocopy JTF_NUMBER_TABLE
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
430: , a24 out nocopy JTF_NUMBER_TABLE
431: , a25 out nocopy JTF_VARCHAR2_TABLE_100
432: , a26 out nocopy JTF_NUMBER_TABLE
433: , a27 out nocopy JTF_VARCHAR2_TABLE_300
426: , a20 out nocopy JTF_NUMBER_TABLE
427: , a21 out nocopy JTF_DATE_TABLE
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
430: , a24 out nocopy JTF_NUMBER_TABLE
431: , a25 out nocopy JTF_VARCHAR2_TABLE_100
432: , a26 out nocopy JTF_NUMBER_TABLE
433: , a27 out nocopy JTF_VARCHAR2_TABLE_300
434: , a28 out nocopy JTF_VARCHAR2_TABLE_100
428: , a22 out nocopy JTF_NUMBER_TABLE
429: , a23 out nocopy JTF_NUMBER_TABLE
430: , a24 out nocopy JTF_NUMBER_TABLE
431: , a25 out nocopy JTF_VARCHAR2_TABLE_100
432: , a26 out nocopy JTF_NUMBER_TABLE
433: , a27 out nocopy JTF_VARCHAR2_TABLE_300
434: , a28 out nocopy JTF_VARCHAR2_TABLE_100
435: , a29 out nocopy JTF_VARCHAR2_TABLE_100
436: , a30 out nocopy JTF_VARCHAR2_TABLE_100
433: , a27 out nocopy JTF_VARCHAR2_TABLE_300
434: , a28 out nocopy JTF_VARCHAR2_TABLE_100
435: , a29 out nocopy JTF_VARCHAR2_TABLE_100
436: , a30 out nocopy JTF_VARCHAR2_TABLE_100
437: , a31 out nocopy JTF_NUMBER_TABLE
438: , a32 out nocopy JTF_VARCHAR2_TABLE_100
439: , a33 out nocopy JTF_NUMBER_TABLE
440: , a34 out nocopy JTF_NUMBER_TABLE
441: , a35 out nocopy JTF_VARCHAR2_TABLE_100
435: , a29 out nocopy JTF_VARCHAR2_TABLE_100
436: , a30 out nocopy JTF_VARCHAR2_TABLE_100
437: , a31 out nocopy JTF_NUMBER_TABLE
438: , a32 out nocopy JTF_VARCHAR2_TABLE_100
439: , a33 out nocopy JTF_NUMBER_TABLE
440: , a34 out nocopy JTF_NUMBER_TABLE
441: , a35 out nocopy JTF_VARCHAR2_TABLE_100
442: , a36 out nocopy JTF_VARCHAR2_TABLE_100
443: , a37 out nocopy JTF_VARCHAR2_TABLE_100
436: , a30 out nocopy JTF_VARCHAR2_TABLE_100
437: , a31 out nocopy JTF_NUMBER_TABLE
438: , a32 out nocopy JTF_VARCHAR2_TABLE_100
439: , a33 out nocopy JTF_NUMBER_TABLE
440: , a34 out nocopy JTF_NUMBER_TABLE
441: , a35 out nocopy JTF_VARCHAR2_TABLE_100
442: , a36 out nocopy JTF_VARCHAR2_TABLE_100
443: , a37 out nocopy JTF_VARCHAR2_TABLE_100
444: , a38 out nocopy JTF_NUMBER_TABLE
440: , a34 out nocopy JTF_NUMBER_TABLE
441: , a35 out nocopy JTF_VARCHAR2_TABLE_100
442: , a36 out nocopy JTF_VARCHAR2_TABLE_100
443: , a37 out nocopy JTF_VARCHAR2_TABLE_100
444: , a38 out nocopy JTF_NUMBER_TABLE
445: , a39 out nocopy JTF_VARCHAR2_TABLE_100
446: , a40 out nocopy JTF_VARCHAR2_TABLE_100
447: , a41 out nocopy JTF_NUMBER_TABLE
448: ) as
443: , a37 out nocopy JTF_VARCHAR2_TABLE_100
444: , a38 out nocopy JTF_NUMBER_TABLE
445: , a39 out nocopy JTF_VARCHAR2_TABLE_100
446: , a40 out nocopy JTF_VARCHAR2_TABLE_100
447: , a41 out nocopy JTF_NUMBER_TABLE
448: ) as
449: ddindx binary_integer; indx binary_integer;
450: begin
451: if t is null or t.count = 0 then
448: ) as
449: ddindx binary_integer; indx binary_integer;
450: begin
451: if t is null or t.count = 0 then
452: a0 := JTF_NUMBER_TABLE();
453: a1 := JTF_NUMBER_TABLE();
454: a2 := JTF_VARCHAR2_TABLE_300();
455: a3 := JTF_VARCHAR2_TABLE_300();
456: a4 := JTF_NUMBER_TABLE();
449: ddindx binary_integer; indx binary_integer;
450: begin
451: if t is null or t.count = 0 then
452: a0 := JTF_NUMBER_TABLE();
453: a1 := JTF_NUMBER_TABLE();
454: a2 := JTF_VARCHAR2_TABLE_300();
455: a3 := JTF_VARCHAR2_TABLE_300();
456: a4 := JTF_NUMBER_TABLE();
457: a5 := JTF_VARCHAR2_TABLE_100();
452: a0 := JTF_NUMBER_TABLE();
453: a1 := JTF_NUMBER_TABLE();
454: a2 := JTF_VARCHAR2_TABLE_300();
455: a3 := JTF_VARCHAR2_TABLE_300();
456: a4 := JTF_NUMBER_TABLE();
457: a5 := JTF_VARCHAR2_TABLE_100();
458: a6 := JTF_NUMBER_TABLE();
459: a7 := JTF_NUMBER_TABLE();
460: a8 := JTF_NUMBER_TABLE();
454: a2 := JTF_VARCHAR2_TABLE_300();
455: a3 := JTF_VARCHAR2_TABLE_300();
456: a4 := JTF_NUMBER_TABLE();
457: a5 := JTF_VARCHAR2_TABLE_100();
458: a6 := JTF_NUMBER_TABLE();
459: a7 := JTF_NUMBER_TABLE();
460: a8 := JTF_NUMBER_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
455: a3 := JTF_VARCHAR2_TABLE_300();
456: a4 := JTF_NUMBER_TABLE();
457: a5 := JTF_VARCHAR2_TABLE_100();
458: a6 := JTF_NUMBER_TABLE();
459: a7 := JTF_NUMBER_TABLE();
460: a8 := JTF_NUMBER_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
463: a11 := JTF_NUMBER_TABLE();
456: a4 := JTF_NUMBER_TABLE();
457: a5 := JTF_VARCHAR2_TABLE_100();
458: a6 := JTF_NUMBER_TABLE();
459: a7 := JTF_NUMBER_TABLE();
460: a8 := JTF_NUMBER_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
463: a11 := JTF_NUMBER_TABLE();
464: a12 := JTF_NUMBER_TABLE();
459: a7 := JTF_NUMBER_TABLE();
460: a8 := JTF_NUMBER_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
463: a11 := JTF_NUMBER_TABLE();
464: a12 := JTF_NUMBER_TABLE();
465: a13 := JTF_NUMBER_TABLE();
466: a14 := JTF_VARCHAR2_TABLE_100();
467: a15 := JTF_VARCHAR2_TABLE_100();
460: a8 := JTF_NUMBER_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
463: a11 := JTF_NUMBER_TABLE();
464: a12 := JTF_NUMBER_TABLE();
465: a13 := JTF_NUMBER_TABLE();
466: a14 := JTF_VARCHAR2_TABLE_100();
467: a15 := JTF_VARCHAR2_TABLE_100();
468: a16 := JTF_DATE_TABLE();
461: a9 := JTF_VARCHAR2_TABLE_100();
462: a10 := JTF_VARCHAR2_TABLE_100();
463: a11 := JTF_NUMBER_TABLE();
464: a12 := JTF_NUMBER_TABLE();
465: a13 := JTF_NUMBER_TABLE();
466: a14 := JTF_VARCHAR2_TABLE_100();
467: a15 := JTF_VARCHAR2_TABLE_100();
468: a16 := JTF_DATE_TABLE();
469: a17 := JTF_NUMBER_TABLE();
465: a13 := JTF_NUMBER_TABLE();
466: a14 := JTF_VARCHAR2_TABLE_100();
467: a15 := JTF_VARCHAR2_TABLE_100();
468: a16 := JTF_DATE_TABLE();
469: a17 := JTF_NUMBER_TABLE();
470: a18 := JTF_DATE_TABLE();
471: a19 := JTF_NUMBER_TABLE();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
467: a15 := JTF_VARCHAR2_TABLE_100();
468: a16 := JTF_DATE_TABLE();
469: a17 := JTF_NUMBER_TABLE();
470: a18 := JTF_DATE_TABLE();
471: a19 := JTF_NUMBER_TABLE();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
468: a16 := JTF_DATE_TABLE();
469: a17 := JTF_NUMBER_TABLE();
470: a18 := JTF_DATE_TABLE();
471: a19 := JTF_NUMBER_TABLE();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
476: a24 := JTF_NUMBER_TABLE();
470: a18 := JTF_DATE_TABLE();
471: a19 := JTF_NUMBER_TABLE();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
476: a24 := JTF_NUMBER_TABLE();
477: a25 := JTF_VARCHAR2_TABLE_100();
478: a26 := JTF_NUMBER_TABLE();
471: a19 := JTF_NUMBER_TABLE();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
476: a24 := JTF_NUMBER_TABLE();
477: a25 := JTF_VARCHAR2_TABLE_100();
478: a26 := JTF_NUMBER_TABLE();
479: a27 := JTF_VARCHAR2_TABLE_300();
472: a20 := JTF_NUMBER_TABLE();
473: a21 := JTF_DATE_TABLE();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
476: a24 := JTF_NUMBER_TABLE();
477: a25 := JTF_VARCHAR2_TABLE_100();
478: a26 := JTF_NUMBER_TABLE();
479: a27 := JTF_VARCHAR2_TABLE_300();
480: a28 := JTF_VARCHAR2_TABLE_100();
474: a22 := JTF_NUMBER_TABLE();
475: a23 := JTF_NUMBER_TABLE();
476: a24 := JTF_NUMBER_TABLE();
477: a25 := JTF_VARCHAR2_TABLE_100();
478: a26 := JTF_NUMBER_TABLE();
479: a27 := JTF_VARCHAR2_TABLE_300();
480: a28 := JTF_VARCHAR2_TABLE_100();
481: a29 := JTF_VARCHAR2_TABLE_100();
482: a30 := JTF_VARCHAR2_TABLE_100();
479: a27 := JTF_VARCHAR2_TABLE_300();
480: a28 := JTF_VARCHAR2_TABLE_100();
481: a29 := JTF_VARCHAR2_TABLE_100();
482: a30 := JTF_VARCHAR2_TABLE_100();
483: a31 := JTF_NUMBER_TABLE();
484: a32 := JTF_VARCHAR2_TABLE_100();
485: a33 := JTF_NUMBER_TABLE();
486: a34 := JTF_NUMBER_TABLE();
487: a35 := JTF_VARCHAR2_TABLE_100();
481: a29 := JTF_VARCHAR2_TABLE_100();
482: a30 := JTF_VARCHAR2_TABLE_100();
483: a31 := JTF_NUMBER_TABLE();
484: a32 := JTF_VARCHAR2_TABLE_100();
485: a33 := JTF_NUMBER_TABLE();
486: a34 := JTF_NUMBER_TABLE();
487: a35 := JTF_VARCHAR2_TABLE_100();
488: a36 := JTF_VARCHAR2_TABLE_100();
489: a37 := JTF_VARCHAR2_TABLE_100();
482: a30 := JTF_VARCHAR2_TABLE_100();
483: a31 := JTF_NUMBER_TABLE();
484: a32 := JTF_VARCHAR2_TABLE_100();
485: a33 := JTF_NUMBER_TABLE();
486: a34 := JTF_NUMBER_TABLE();
487: a35 := JTF_VARCHAR2_TABLE_100();
488: a36 := JTF_VARCHAR2_TABLE_100();
489: a37 := JTF_VARCHAR2_TABLE_100();
490: a38 := JTF_NUMBER_TABLE();
486: a34 := JTF_NUMBER_TABLE();
487: a35 := JTF_VARCHAR2_TABLE_100();
488: a36 := JTF_VARCHAR2_TABLE_100();
489: a37 := JTF_VARCHAR2_TABLE_100();
490: a38 := JTF_NUMBER_TABLE();
491: a39 := JTF_VARCHAR2_TABLE_100();
492: a40 := JTF_VARCHAR2_TABLE_100();
493: a41 := JTF_NUMBER_TABLE();
494: else
489: a37 := JTF_VARCHAR2_TABLE_100();
490: a38 := JTF_NUMBER_TABLE();
491: a39 := JTF_VARCHAR2_TABLE_100();
492: a40 := JTF_VARCHAR2_TABLE_100();
493: a41 := JTF_NUMBER_TABLE();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
491: a39 := JTF_VARCHAR2_TABLE_100();
492: a40 := JTF_VARCHAR2_TABLE_100();
493: a41 := JTF_NUMBER_TABLE();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_NUMBER_TABLE();
492: a40 := JTF_VARCHAR2_TABLE_100();
493: a41 := JTF_NUMBER_TABLE();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_NUMBER_TABLE();
500: a5 := JTF_VARCHAR2_TABLE_100();
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_NUMBER_TABLE();
500: a5 := JTF_VARCHAR2_TABLE_100();
501: a6 := JTF_NUMBER_TABLE();
502: a7 := JTF_NUMBER_TABLE();
503: a8 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_NUMBER_TABLE();
500: a5 := JTF_VARCHAR2_TABLE_100();
501: a6 := JTF_NUMBER_TABLE();
502: a7 := JTF_NUMBER_TABLE();
503: a8 := JTF_NUMBER_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_NUMBER_TABLE();
500: a5 := JTF_VARCHAR2_TABLE_100();
501: a6 := JTF_NUMBER_TABLE();
502: a7 := JTF_NUMBER_TABLE();
503: a8 := JTF_NUMBER_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
506: a11 := JTF_NUMBER_TABLE();
499: a4 := JTF_NUMBER_TABLE();
500: a5 := JTF_VARCHAR2_TABLE_100();
501: a6 := JTF_NUMBER_TABLE();
502: a7 := JTF_NUMBER_TABLE();
503: a8 := JTF_NUMBER_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
506: a11 := JTF_NUMBER_TABLE();
507: a12 := JTF_NUMBER_TABLE();
502: a7 := JTF_NUMBER_TABLE();
503: a8 := JTF_NUMBER_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
506: a11 := JTF_NUMBER_TABLE();
507: a12 := JTF_NUMBER_TABLE();
508: a13 := JTF_NUMBER_TABLE();
509: a14 := JTF_VARCHAR2_TABLE_100();
510: a15 := JTF_VARCHAR2_TABLE_100();
503: a8 := JTF_NUMBER_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
506: a11 := JTF_NUMBER_TABLE();
507: a12 := JTF_NUMBER_TABLE();
508: a13 := JTF_NUMBER_TABLE();
509: a14 := JTF_VARCHAR2_TABLE_100();
510: a15 := JTF_VARCHAR2_TABLE_100();
511: a16 := JTF_DATE_TABLE();
504: a9 := JTF_VARCHAR2_TABLE_100();
505: a10 := JTF_VARCHAR2_TABLE_100();
506: a11 := JTF_NUMBER_TABLE();
507: a12 := JTF_NUMBER_TABLE();
508: a13 := JTF_NUMBER_TABLE();
509: a14 := JTF_VARCHAR2_TABLE_100();
510: a15 := JTF_VARCHAR2_TABLE_100();
511: a16 := JTF_DATE_TABLE();
512: a17 := JTF_NUMBER_TABLE();
508: a13 := JTF_NUMBER_TABLE();
509: a14 := JTF_VARCHAR2_TABLE_100();
510: a15 := JTF_VARCHAR2_TABLE_100();
511: a16 := JTF_DATE_TABLE();
512: a17 := JTF_NUMBER_TABLE();
513: a18 := JTF_DATE_TABLE();
514: a19 := JTF_NUMBER_TABLE();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
510: a15 := JTF_VARCHAR2_TABLE_100();
511: a16 := JTF_DATE_TABLE();
512: a17 := JTF_NUMBER_TABLE();
513: a18 := JTF_DATE_TABLE();
514: a19 := JTF_NUMBER_TABLE();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
511: a16 := JTF_DATE_TABLE();
512: a17 := JTF_NUMBER_TABLE();
513: a18 := JTF_DATE_TABLE();
514: a19 := JTF_NUMBER_TABLE();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
519: a24 := JTF_NUMBER_TABLE();
513: a18 := JTF_DATE_TABLE();
514: a19 := JTF_NUMBER_TABLE();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
519: a24 := JTF_NUMBER_TABLE();
520: a25 := JTF_VARCHAR2_TABLE_100();
521: a26 := JTF_NUMBER_TABLE();
514: a19 := JTF_NUMBER_TABLE();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
519: a24 := JTF_NUMBER_TABLE();
520: a25 := JTF_VARCHAR2_TABLE_100();
521: a26 := JTF_NUMBER_TABLE();
522: a27 := JTF_VARCHAR2_TABLE_300();
515: a20 := JTF_NUMBER_TABLE();
516: a21 := JTF_DATE_TABLE();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
519: a24 := JTF_NUMBER_TABLE();
520: a25 := JTF_VARCHAR2_TABLE_100();
521: a26 := JTF_NUMBER_TABLE();
522: a27 := JTF_VARCHAR2_TABLE_300();
523: a28 := JTF_VARCHAR2_TABLE_100();
517: a22 := JTF_NUMBER_TABLE();
518: a23 := JTF_NUMBER_TABLE();
519: a24 := JTF_NUMBER_TABLE();
520: a25 := JTF_VARCHAR2_TABLE_100();
521: a26 := JTF_NUMBER_TABLE();
522: a27 := JTF_VARCHAR2_TABLE_300();
523: a28 := JTF_VARCHAR2_TABLE_100();
524: a29 := JTF_VARCHAR2_TABLE_100();
525: a30 := JTF_VARCHAR2_TABLE_100();
522: a27 := JTF_VARCHAR2_TABLE_300();
523: a28 := JTF_VARCHAR2_TABLE_100();
524: a29 := JTF_VARCHAR2_TABLE_100();
525: a30 := JTF_VARCHAR2_TABLE_100();
526: a31 := JTF_NUMBER_TABLE();
527: a32 := JTF_VARCHAR2_TABLE_100();
528: a33 := JTF_NUMBER_TABLE();
529: a34 := JTF_NUMBER_TABLE();
530: a35 := JTF_VARCHAR2_TABLE_100();
524: a29 := JTF_VARCHAR2_TABLE_100();
525: a30 := JTF_VARCHAR2_TABLE_100();
526: a31 := JTF_NUMBER_TABLE();
527: a32 := JTF_VARCHAR2_TABLE_100();
528: a33 := JTF_NUMBER_TABLE();
529: a34 := JTF_NUMBER_TABLE();
530: a35 := JTF_VARCHAR2_TABLE_100();
531: a36 := JTF_VARCHAR2_TABLE_100();
532: a37 := JTF_VARCHAR2_TABLE_100();
525: a30 := JTF_VARCHAR2_TABLE_100();
526: a31 := JTF_NUMBER_TABLE();
527: a32 := JTF_VARCHAR2_TABLE_100();
528: a33 := JTF_NUMBER_TABLE();
529: a34 := JTF_NUMBER_TABLE();
530: a35 := JTF_VARCHAR2_TABLE_100();
531: a36 := JTF_VARCHAR2_TABLE_100();
532: a37 := JTF_VARCHAR2_TABLE_100();
533: a38 := JTF_NUMBER_TABLE();
529: a34 := JTF_NUMBER_TABLE();
530: a35 := JTF_VARCHAR2_TABLE_100();
531: a36 := JTF_VARCHAR2_TABLE_100();
532: a37 := JTF_VARCHAR2_TABLE_100();
533: a38 := JTF_NUMBER_TABLE();
534: a39 := JTF_VARCHAR2_TABLE_100();
535: a40 := JTF_VARCHAR2_TABLE_100();
536: a41 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
532: a37 := JTF_VARCHAR2_TABLE_100();
533: a38 := JTF_NUMBER_TABLE();
534: a39 := JTF_VARCHAR2_TABLE_100();
535: a40 := JTF_VARCHAR2_TABLE_100();
536: a41 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
538: a0.extend(t.count);
539: a1.extend(t.count);
540: a2.extend(t.count);
631: end if;
632: end if;
633: end rosetta_table_copy_out_p4;
634:
635: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
636: , a1 JTF_VARCHAR2_TABLE_100
637: , a2 JTF_NUMBER_TABLE
638: , a3 JTF_NUMBER_TABLE
639: , a4 JTF_NUMBER_TABLE
633: end rosetta_table_copy_out_p4;
634:
635: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
636: , a1 JTF_VARCHAR2_TABLE_100
637: , a2 JTF_NUMBER_TABLE
638: , a3 JTF_NUMBER_TABLE
639: , a4 JTF_NUMBER_TABLE
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
634:
635: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
636: , a1 JTF_VARCHAR2_TABLE_100
637: , a2 JTF_NUMBER_TABLE
638: , a3 JTF_NUMBER_TABLE
639: , a4 JTF_NUMBER_TABLE
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
635: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
636: , a1 JTF_VARCHAR2_TABLE_100
637: , a2 JTF_NUMBER_TABLE
638: , a3 JTF_NUMBER_TABLE
639: , a4 JTF_NUMBER_TABLE
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
643: , a8 JTF_NUMBER_TABLE
638: , a3 JTF_NUMBER_TABLE
639: , a4 JTF_NUMBER_TABLE
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
643: , a8 JTF_NUMBER_TABLE
644: , a9 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
639: , a4 JTF_NUMBER_TABLE
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
643: , a8 JTF_NUMBER_TABLE
644: , a9 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
640: , a5 JTF_VARCHAR2_TABLE_300
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
643: , a8 JTF_NUMBER_TABLE
644: , a9 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
641: , a6 JTF_VARCHAR2_TABLE_100
642: , a7 JTF_NUMBER_TABLE
643: , a8 JTF_NUMBER_TABLE
644: , a9 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
644: , a9 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
645: , a10 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
646: , a11 JTF_VARCHAR2_TABLE_300
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
647: , a12 JTF_VARCHAR2_TABLE_100
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
648: , a13 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
649: , a14 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
650: , a15 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
651: , a16 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
652: , a17 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
660: , a25 JTF_NUMBER_TABLE
653: , a18 JTF_NUMBER_TABLE
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
660: , a25 JTF_NUMBER_TABLE
661: ) as
654: , a19 JTF_NUMBER_TABLE
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
660: , a25 JTF_NUMBER_TABLE
661: ) as
662: ddindx binary_integer; indx binary_integer;
655: , a20 JTF_NUMBER_TABLE
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
660: , a25 JTF_NUMBER_TABLE
661: ) as
662: ddindx binary_integer; indx binary_integer;
663: begin
656: , a21 JTF_NUMBER_TABLE
657: , a22 JTF_NUMBER_TABLE
658: , a23 JTF_NUMBER_TABLE
659: , a24 JTF_NUMBER_TABLE
660: , a25 JTF_NUMBER_TABLE
661: ) as
662: ddindx binary_integer; indx binary_integer;
663: begin
664: if a0 is not null and a0.count > 0 then
700: end loop;
701: end if;
702: end if;
703: end rosetta_table_copy_in_p6;
704: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
705: , a1 out nocopy JTF_VARCHAR2_TABLE_100
706: , a2 out nocopy JTF_NUMBER_TABLE
707: , a3 out nocopy JTF_NUMBER_TABLE
708: , a4 out nocopy JTF_NUMBER_TABLE
702: end if;
703: end rosetta_table_copy_in_p6;
704: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
705: , a1 out nocopy JTF_VARCHAR2_TABLE_100
706: , a2 out nocopy JTF_NUMBER_TABLE
707: , a3 out nocopy JTF_NUMBER_TABLE
708: , a4 out nocopy JTF_NUMBER_TABLE
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
703: end rosetta_table_copy_in_p6;
704: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
705: , a1 out nocopy JTF_VARCHAR2_TABLE_100
706: , a2 out nocopy JTF_NUMBER_TABLE
707: , a3 out nocopy JTF_NUMBER_TABLE
708: , a4 out nocopy JTF_NUMBER_TABLE
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
704: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
705: , a1 out nocopy JTF_VARCHAR2_TABLE_100
706: , a2 out nocopy JTF_NUMBER_TABLE
707: , a3 out nocopy JTF_NUMBER_TABLE
708: , a4 out nocopy JTF_NUMBER_TABLE
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
712: , a8 out nocopy JTF_NUMBER_TABLE
707: , a3 out nocopy JTF_NUMBER_TABLE
708: , a4 out nocopy JTF_NUMBER_TABLE
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
712: , a8 out nocopy JTF_NUMBER_TABLE
713: , a9 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
708: , a4 out nocopy JTF_NUMBER_TABLE
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
712: , a8 out nocopy JTF_NUMBER_TABLE
713: , a9 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
709: , a5 out nocopy JTF_VARCHAR2_TABLE_300
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
712: , a8 out nocopy JTF_NUMBER_TABLE
713: , a9 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
710: , a6 out nocopy JTF_VARCHAR2_TABLE_100
711: , a7 out nocopy JTF_NUMBER_TABLE
712: , a8 out nocopy JTF_NUMBER_TABLE
713: , a9 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
713: , a9 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
714: , a10 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
715: , a11 out nocopy JTF_VARCHAR2_TABLE_300
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
716: , a12 out nocopy JTF_VARCHAR2_TABLE_100
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
717: , a13 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
718: , a14 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
719: , a15 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
720: , a16 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
721: , a17 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
729: , a25 out nocopy JTF_NUMBER_TABLE
722: , a18 out nocopy JTF_NUMBER_TABLE
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
729: , a25 out nocopy JTF_NUMBER_TABLE
730: ) as
723: , a19 out nocopy JTF_NUMBER_TABLE
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
729: , a25 out nocopy JTF_NUMBER_TABLE
730: ) as
731: ddindx binary_integer; indx binary_integer;
724: , a20 out nocopy JTF_NUMBER_TABLE
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
729: , a25 out nocopy JTF_NUMBER_TABLE
730: ) as
731: ddindx binary_integer; indx binary_integer;
732: begin
725: , a21 out nocopy JTF_NUMBER_TABLE
726: , a22 out nocopy JTF_NUMBER_TABLE
727: , a23 out nocopy JTF_NUMBER_TABLE
728: , a24 out nocopy JTF_NUMBER_TABLE
729: , a25 out nocopy JTF_NUMBER_TABLE
730: ) as
731: ddindx binary_integer; indx binary_integer;
732: begin
733: if t is null or t.count = 0 then
730: ) as
731: ddindx binary_integer; indx binary_integer;
732: begin
733: if t is null or t.count = 0 then
734: a0 := JTF_NUMBER_TABLE();
735: a1 := JTF_VARCHAR2_TABLE_100();
736: a2 := JTF_NUMBER_TABLE();
737: a3 := JTF_NUMBER_TABLE();
738: a4 := JTF_NUMBER_TABLE();
732: begin
733: if t is null or t.count = 0 then
734: a0 := JTF_NUMBER_TABLE();
735: a1 := JTF_VARCHAR2_TABLE_100();
736: a2 := JTF_NUMBER_TABLE();
737: a3 := JTF_NUMBER_TABLE();
738: a4 := JTF_NUMBER_TABLE();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
733: if t is null or t.count = 0 then
734: a0 := JTF_NUMBER_TABLE();
735: a1 := JTF_VARCHAR2_TABLE_100();
736: a2 := JTF_NUMBER_TABLE();
737: a3 := JTF_NUMBER_TABLE();
738: a4 := JTF_NUMBER_TABLE();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
734: a0 := JTF_NUMBER_TABLE();
735: a1 := JTF_VARCHAR2_TABLE_100();
736: a2 := JTF_NUMBER_TABLE();
737: a3 := JTF_NUMBER_TABLE();
738: a4 := JTF_NUMBER_TABLE();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
742: a8 := JTF_NUMBER_TABLE();
737: a3 := JTF_NUMBER_TABLE();
738: a4 := JTF_NUMBER_TABLE();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
742: a8 := JTF_NUMBER_TABLE();
743: a9 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
738: a4 := JTF_NUMBER_TABLE();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
742: a8 := JTF_NUMBER_TABLE();
743: a9 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
739: a5 := JTF_VARCHAR2_TABLE_300();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
742: a8 := JTF_NUMBER_TABLE();
743: a9 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
740: a6 := JTF_VARCHAR2_TABLE_100();
741: a7 := JTF_NUMBER_TABLE();
742: a8 := JTF_NUMBER_TABLE();
743: a9 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
743: a9 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
744: a10 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
745: a11 := JTF_VARCHAR2_TABLE_300();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
746: a12 := JTF_VARCHAR2_TABLE_100();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
747: a13 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
748: a14 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
749: a15 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
750: a16 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
751: a17 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
752: a18 := JTF_NUMBER_TABLE();
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
753: a19 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
761: a0 := JTF_NUMBER_TABLE();
754: a20 := JTF_NUMBER_TABLE();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
755: a21 := JTF_NUMBER_TABLE();
756: a22 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
763: a2 := JTF_NUMBER_TABLE();
757: a23 := JTF_NUMBER_TABLE();
758: a24 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
763: a2 := JTF_NUMBER_TABLE();
764: a3 := JTF_NUMBER_TABLE();
765: a4 := JTF_NUMBER_TABLE();
759: a25 := JTF_NUMBER_TABLE();
760: else
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
763: a2 := JTF_NUMBER_TABLE();
764: a3 := JTF_NUMBER_TABLE();
765: a4 := JTF_NUMBER_TABLE();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
760: else
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
763: a2 := JTF_NUMBER_TABLE();
764: a3 := JTF_NUMBER_TABLE();
765: a4 := JTF_NUMBER_TABLE();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
761: a0 := JTF_NUMBER_TABLE();
762: a1 := JTF_VARCHAR2_TABLE_100();
763: a2 := JTF_NUMBER_TABLE();
764: a3 := JTF_NUMBER_TABLE();
765: a4 := JTF_NUMBER_TABLE();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
769: a8 := JTF_NUMBER_TABLE();
764: a3 := JTF_NUMBER_TABLE();
765: a4 := JTF_NUMBER_TABLE();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
769: a8 := JTF_NUMBER_TABLE();
770: a9 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
765: a4 := JTF_NUMBER_TABLE();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
769: a8 := JTF_NUMBER_TABLE();
770: a9 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
766: a5 := JTF_VARCHAR2_TABLE_300();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
769: a8 := JTF_NUMBER_TABLE();
770: a9 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
767: a6 := JTF_VARCHAR2_TABLE_100();
768: a7 := JTF_NUMBER_TABLE();
769: a8 := JTF_NUMBER_TABLE();
770: a9 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
770: a9 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
771: a10 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
772: a11 := JTF_VARCHAR2_TABLE_300();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
773: a12 := JTF_VARCHAR2_TABLE_100();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
774: a13 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
775: a14 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
776: a15 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
777: a16 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
778: a17 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
786: a25 := JTF_NUMBER_TABLE();
779: a18 := JTF_NUMBER_TABLE();
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
786: a25 := JTF_NUMBER_TABLE();
787: if t.count > 0 then
780: a19 := JTF_NUMBER_TABLE();
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
786: a25 := JTF_NUMBER_TABLE();
787: if t.count > 0 then
788: a0.extend(t.count);
781: a20 := JTF_NUMBER_TABLE();
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
786: a25 := JTF_NUMBER_TABLE();
787: if t.count > 0 then
788: a0.extend(t.count);
789: a1.extend(t.count);
782: a21 := JTF_NUMBER_TABLE();
783: a22 := JTF_NUMBER_TABLE();
784: a23 := JTF_NUMBER_TABLE();
785: a24 := JTF_NUMBER_TABLE();
786: a25 := JTF_NUMBER_TABLE();
787: if t.count > 0 then
788: a0.extend(t.count);
789: a1.extend(t.count);
790: a2.extend(t.count);
862: , p6_a3 VARCHAR2
863: , p6_a4 VARCHAR2
864: , p6_a5 VARCHAR2
865: , p6_a6 VARCHAR2
866: , p7_a0 out nocopy JTF_NUMBER_TABLE
867: , p7_a1 out nocopy JTF_NUMBER_TABLE
868: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
869: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
863: , p6_a4 VARCHAR2
864: , p6_a5 VARCHAR2
865: , p6_a6 VARCHAR2
866: , p7_a0 out nocopy JTF_NUMBER_TABLE
867: , p7_a1 out nocopy JTF_NUMBER_TABLE
868: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
869: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
871: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
866: , p7_a0 out nocopy JTF_NUMBER_TABLE
867: , p7_a1 out nocopy JTF_NUMBER_TABLE
868: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
869: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
871: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a6 out nocopy JTF_NUMBER_TABLE
873: , p7_a7 out nocopy JTF_NUMBER_TABLE
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
868: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
869: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
871: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a6 out nocopy JTF_NUMBER_TABLE
873: , p7_a7 out nocopy JTF_NUMBER_TABLE
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
869: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
871: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a6 out nocopy JTF_NUMBER_TABLE
873: , p7_a7 out nocopy JTF_NUMBER_TABLE
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a11 out nocopy JTF_NUMBER_TABLE
870: , p7_a4 out nocopy JTF_NUMBER_TABLE
871: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
872: , p7_a6 out nocopy JTF_NUMBER_TABLE
873: , p7_a7 out nocopy JTF_NUMBER_TABLE
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a11 out nocopy JTF_NUMBER_TABLE
878: , p7_a12 out nocopy JTF_NUMBER_TABLE
873: , p7_a7 out nocopy JTF_NUMBER_TABLE
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a11 out nocopy JTF_NUMBER_TABLE
878: , p7_a12 out nocopy JTF_NUMBER_TABLE
879: , p7_a13 out nocopy JTF_NUMBER_TABLE
880: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
874: , p7_a8 out nocopy JTF_NUMBER_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a11 out nocopy JTF_NUMBER_TABLE
878: , p7_a12 out nocopy JTF_NUMBER_TABLE
879: , p7_a13 out nocopy JTF_NUMBER_TABLE
880: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a16 out nocopy JTF_DATE_TABLE
875: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a11 out nocopy JTF_NUMBER_TABLE
878: , p7_a12 out nocopy JTF_NUMBER_TABLE
879: , p7_a13 out nocopy JTF_NUMBER_TABLE
880: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a16 out nocopy JTF_DATE_TABLE
883: , p7_a17 out nocopy JTF_NUMBER_TABLE
879: , p7_a13 out nocopy JTF_NUMBER_TABLE
880: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a16 out nocopy JTF_DATE_TABLE
883: , p7_a17 out nocopy JTF_NUMBER_TABLE
884: , p7_a18 out nocopy JTF_NUMBER_TABLE
885: , p7_a19 out nocopy JTF_DATE_TABLE
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
880: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a16 out nocopy JTF_DATE_TABLE
883: , p7_a17 out nocopy JTF_NUMBER_TABLE
884: , p7_a18 out nocopy JTF_NUMBER_TABLE
885: , p7_a19 out nocopy JTF_DATE_TABLE
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
882: , p7_a16 out nocopy JTF_DATE_TABLE
883: , p7_a17 out nocopy JTF_NUMBER_TABLE
884: , p7_a18 out nocopy JTF_NUMBER_TABLE
885: , p7_a19 out nocopy JTF_DATE_TABLE
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
889: , p7_a23 out nocopy JTF_NUMBER_TABLE
890: , p7_a24 out nocopy JTF_NUMBER_TABLE
884: , p7_a18 out nocopy JTF_NUMBER_TABLE
885: , p7_a19 out nocopy JTF_DATE_TABLE
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
889: , p7_a23 out nocopy JTF_NUMBER_TABLE
890: , p7_a24 out nocopy JTF_NUMBER_TABLE
891: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
892: , p7_a26 out nocopy JTF_NUMBER_TABLE
885: , p7_a19 out nocopy JTF_DATE_TABLE
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
889: , p7_a23 out nocopy JTF_NUMBER_TABLE
890: , p7_a24 out nocopy JTF_NUMBER_TABLE
891: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
892: , p7_a26 out nocopy JTF_NUMBER_TABLE
893: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
886: , p7_a20 out nocopy JTF_NUMBER_TABLE
887: , p7_a21 out nocopy JTF_DATE_TABLE
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
889: , p7_a23 out nocopy JTF_NUMBER_TABLE
890: , p7_a24 out nocopy JTF_NUMBER_TABLE
891: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
892: , p7_a26 out nocopy JTF_NUMBER_TABLE
893: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
894: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
888: , p7_a22 out nocopy JTF_NUMBER_TABLE
889: , p7_a23 out nocopy JTF_NUMBER_TABLE
890: , p7_a24 out nocopy JTF_NUMBER_TABLE
891: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
892: , p7_a26 out nocopy JTF_NUMBER_TABLE
893: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
894: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
896: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
896: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
897: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
898: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
899: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
900: , p7_a34 out nocopy JTF_NUMBER_TABLE
901: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
902: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
903: , p7_a37 out nocopy JTF_NUMBER_TABLE
904: , x_return_status out nocopy VARCHAR2
899: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
900: , p7_a34 out nocopy JTF_NUMBER_TABLE
901: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
902: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
903: , p7_a37 out nocopy JTF_NUMBER_TABLE
904: , x_return_status out nocopy VARCHAR2
905: , x_msg_count out nocopy NUMBER
906: , x_msg_data out nocopy VARCHAR2
907: )
1008: , p6_a3 VARCHAR2
1009: , p6_a4 VARCHAR2
1010: , p6_a5 VARCHAR2
1011: , p6_a6 VARCHAR2
1012: , p7_a0 out nocopy JTF_NUMBER_TABLE
1013: , p7_a1 out nocopy JTF_NUMBER_TABLE
1014: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1015: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1009: , p6_a4 VARCHAR2
1010: , p6_a5 VARCHAR2
1011: , p6_a6 VARCHAR2
1012: , p7_a0 out nocopy JTF_NUMBER_TABLE
1013: , p7_a1 out nocopy JTF_NUMBER_TABLE
1014: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1015: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1017: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1012: , p7_a0 out nocopy JTF_NUMBER_TABLE
1013: , p7_a1 out nocopy JTF_NUMBER_TABLE
1014: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1015: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1017: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a6 out nocopy JTF_NUMBER_TABLE
1019: , p7_a7 out nocopy JTF_NUMBER_TABLE
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1014: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
1015: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1017: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a6 out nocopy JTF_NUMBER_TABLE
1019: , p7_a7 out nocopy JTF_NUMBER_TABLE
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1015: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1017: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a6 out nocopy JTF_NUMBER_TABLE
1019: , p7_a7 out nocopy JTF_NUMBER_TABLE
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a11 out nocopy JTF_NUMBER_TABLE
1016: , p7_a4 out nocopy JTF_NUMBER_TABLE
1017: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p7_a6 out nocopy JTF_NUMBER_TABLE
1019: , p7_a7 out nocopy JTF_NUMBER_TABLE
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a11 out nocopy JTF_NUMBER_TABLE
1024: , p7_a12 out nocopy JTF_NUMBER_TABLE
1019: , p7_a7 out nocopy JTF_NUMBER_TABLE
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a11 out nocopy JTF_NUMBER_TABLE
1024: , p7_a12 out nocopy JTF_NUMBER_TABLE
1025: , p7_a13 out nocopy JTF_NUMBER_TABLE
1026: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p7_a8 out nocopy JTF_NUMBER_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a11 out nocopy JTF_NUMBER_TABLE
1024: , p7_a12 out nocopy JTF_NUMBER_TABLE
1025: , p7_a13 out nocopy JTF_NUMBER_TABLE
1026: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p7_a16 out nocopy JTF_DATE_TABLE
1021: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a11 out nocopy JTF_NUMBER_TABLE
1024: , p7_a12 out nocopy JTF_NUMBER_TABLE
1025: , p7_a13 out nocopy JTF_NUMBER_TABLE
1026: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p7_a16 out nocopy JTF_DATE_TABLE
1029: , p7_a17 out nocopy JTF_NUMBER_TABLE
1025: , p7_a13 out nocopy JTF_NUMBER_TABLE
1026: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p7_a16 out nocopy JTF_DATE_TABLE
1029: , p7_a17 out nocopy JTF_NUMBER_TABLE
1030: , p7_a18 out nocopy JTF_DATE_TABLE
1031: , p7_a19 out nocopy JTF_NUMBER_TABLE
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1027: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p7_a16 out nocopy JTF_DATE_TABLE
1029: , p7_a17 out nocopy JTF_NUMBER_TABLE
1030: , p7_a18 out nocopy JTF_DATE_TABLE
1031: , p7_a19 out nocopy JTF_NUMBER_TABLE
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1028: , p7_a16 out nocopy JTF_DATE_TABLE
1029: , p7_a17 out nocopy JTF_NUMBER_TABLE
1030: , p7_a18 out nocopy JTF_DATE_TABLE
1031: , p7_a19 out nocopy JTF_NUMBER_TABLE
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1036: , p7_a24 out nocopy JTF_NUMBER_TABLE
1030: , p7_a18 out nocopy JTF_DATE_TABLE
1031: , p7_a19 out nocopy JTF_NUMBER_TABLE
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1036: , p7_a24 out nocopy JTF_NUMBER_TABLE
1037: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1038: , p7_a26 out nocopy JTF_NUMBER_TABLE
1031: , p7_a19 out nocopy JTF_NUMBER_TABLE
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1036: , p7_a24 out nocopy JTF_NUMBER_TABLE
1037: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1038: , p7_a26 out nocopy JTF_NUMBER_TABLE
1039: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1032: , p7_a20 out nocopy JTF_NUMBER_TABLE
1033: , p7_a21 out nocopy JTF_DATE_TABLE
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1036: , p7_a24 out nocopy JTF_NUMBER_TABLE
1037: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1038: , p7_a26 out nocopy JTF_NUMBER_TABLE
1039: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1040: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1034: , p7_a22 out nocopy JTF_NUMBER_TABLE
1035: , p7_a23 out nocopy JTF_NUMBER_TABLE
1036: , p7_a24 out nocopy JTF_NUMBER_TABLE
1037: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
1038: , p7_a26 out nocopy JTF_NUMBER_TABLE
1039: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1040: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
1040: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p7_a31 out nocopy JTF_NUMBER_TABLE
1044: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1045: , p7_a33 out nocopy JTF_NUMBER_TABLE
1046: , p7_a34 out nocopy JTF_NUMBER_TABLE
1047: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p7_a31 out nocopy JTF_NUMBER_TABLE
1044: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1045: , p7_a33 out nocopy JTF_NUMBER_TABLE
1046: , p7_a34 out nocopy JTF_NUMBER_TABLE
1047: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1048: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1049: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p7_a31 out nocopy JTF_NUMBER_TABLE
1044: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1045: , p7_a33 out nocopy JTF_NUMBER_TABLE
1046: , p7_a34 out nocopy JTF_NUMBER_TABLE
1047: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1048: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1049: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1050: , p7_a38 out nocopy JTF_NUMBER_TABLE
1046: , p7_a34 out nocopy JTF_NUMBER_TABLE
1047: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1048: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
1049: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1050: , p7_a38 out nocopy JTF_NUMBER_TABLE
1051: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p7_a41 out nocopy JTF_NUMBER_TABLE
1054: , x_return_status out nocopy VARCHAR2
1049: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1050: , p7_a38 out nocopy JTF_NUMBER_TABLE
1051: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p7_a41 out nocopy JTF_NUMBER_TABLE
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: )
1158: , p_module_type VARCHAR2
1159: , p_unit_header_id NUMBER
1160: , p_item_instance_id NUMBER
1161: , p_visit_id NUMBER
1162: , p9_a0 out nocopy JTF_NUMBER_TABLE
1163: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1164: , p9_a2 out nocopy JTF_NUMBER_TABLE
1165: , p9_a3 out nocopy JTF_NUMBER_TABLE
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1160: , p_item_instance_id NUMBER
1161: , p_visit_id NUMBER
1162: , p9_a0 out nocopy JTF_NUMBER_TABLE
1163: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1164: , p9_a2 out nocopy JTF_NUMBER_TABLE
1165: , p9_a3 out nocopy JTF_NUMBER_TABLE
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1161: , p_visit_id NUMBER
1162: , p9_a0 out nocopy JTF_NUMBER_TABLE
1163: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1164: , p9_a2 out nocopy JTF_NUMBER_TABLE
1165: , p9_a3 out nocopy JTF_NUMBER_TABLE
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1162: , p9_a0 out nocopy JTF_NUMBER_TABLE
1163: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1164: , p9_a2 out nocopy JTF_NUMBER_TABLE
1165: , p9_a3 out nocopy JTF_NUMBER_TABLE
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1170: , p9_a8 out nocopy JTF_NUMBER_TABLE
1165: , p9_a3 out nocopy JTF_NUMBER_TABLE
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1170: , p9_a8 out nocopy JTF_NUMBER_TABLE
1171: , p9_a9 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1166: , p9_a4 out nocopy JTF_NUMBER_TABLE
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1170: , p9_a8 out nocopy JTF_NUMBER_TABLE
1171: , p9_a9 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1170: , p9_a8 out nocopy JTF_NUMBER_TABLE
1171: , p9_a9 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1168: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p9_a7 out nocopy JTF_NUMBER_TABLE
1170: , p9_a8 out nocopy JTF_NUMBER_TABLE
1171: , p9_a9 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1171: , p9_a9 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1172: , p9_a10 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1173: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1174: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1175: , p9_a13 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1176: , p9_a14 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1177: , p9_a15 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1178: , p9_a16 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1179: , p9_a17 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1187: , p9_a25 out nocopy JTF_NUMBER_TABLE
1180: , p9_a18 out nocopy JTF_NUMBER_TABLE
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1187: , p9_a25 out nocopy JTF_NUMBER_TABLE
1188: , x_return_status out nocopy VARCHAR2
1181: , p9_a19 out nocopy JTF_NUMBER_TABLE
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1187: , p9_a25 out nocopy JTF_NUMBER_TABLE
1188: , x_return_status out nocopy VARCHAR2
1189: , x_msg_count out nocopy NUMBER
1182: , p9_a20 out nocopy JTF_NUMBER_TABLE
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1187: , p9_a25 out nocopy JTF_NUMBER_TABLE
1188: , x_return_status out nocopy VARCHAR2
1189: , x_msg_count out nocopy NUMBER
1190: , x_msg_data out nocopy VARCHAR2
1183: , p9_a21 out nocopy JTF_NUMBER_TABLE
1184: , p9_a22 out nocopy JTF_NUMBER_TABLE
1185: , p9_a23 out nocopy JTF_NUMBER_TABLE
1186: , p9_a24 out nocopy JTF_NUMBER_TABLE
1187: , p9_a25 out nocopy JTF_NUMBER_TABLE
1188: , x_return_status out nocopy VARCHAR2
1189: , x_msg_count out nocopy NUMBER
1190: , x_msg_data out nocopy VARCHAR2
1191: )