18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_VARCHAR2_TABLE_100
45: ) as
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_NUMBER_TABLE
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: end if;
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_100
88: , a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
98: , a13 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
98: , a13 out nocopy JTF_VARCHAR2_TABLE_100
99: , a14 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
98: , a13 out nocopy JTF_VARCHAR2_TABLE_100
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
98: , a13 out nocopy JTF_VARCHAR2_TABLE_100
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , a19 out nocopy JTF_NUMBER_TABLE
97: , a12 out nocopy JTF_VARCHAR2_TABLE_100
98: , a13 out nocopy JTF_VARCHAR2_TABLE_100
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , a19 out nocopy JTF_NUMBER_TABLE
105: , a20 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , a19 out nocopy JTF_NUMBER_TABLE
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_VARCHAR2_TABLE_100
108: ) as
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , a19 out nocopy JTF_NUMBER_TABLE
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_VARCHAR2_TABLE_100
108: ) as
109: ddindx binary_integer; indx binary_integer;
102: , a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , a19 out nocopy JTF_NUMBER_TABLE
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_VARCHAR2_TABLE_100
108: ) as
109: ddindx binary_integer; indx binary_integer;
110: begin
108: ) as
109: ddindx binary_integer; indx binary_integer;
110: begin
111: if t is null or t.count = 0 then
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_VARCHAR2_TABLE_100();
109: ddindx binary_integer; indx binary_integer;
110: begin
111: if t is null or t.count = 0 then
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_VARCHAR2_TABLE_100();
117: a5 := JTF_VARCHAR2_TABLE_100();
110: begin
111: if t is null or t.count = 0 then
112: a0 := JTF_NUMBER_TABLE();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_NUMBER_TABLE();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_VARCHAR2_TABLE_100();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_VARCHAR2_TABLE_100();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_VARCHAR2_TABLE_100();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_NUMBER_TABLE();
123: a11 := JTF_VARCHAR2_TABLE_100();
116: a4 := JTF_VARCHAR2_TABLE_100();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_VARCHAR2_TABLE_100();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_NUMBER_TABLE();
123: a11 := JTF_VARCHAR2_TABLE_100();
124: a12 := JTF_VARCHAR2_TABLE_100();
117: a5 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_VARCHAR2_TABLE_100();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_NUMBER_TABLE();
123: a11 := JTF_VARCHAR2_TABLE_100();
124: a12 := JTF_VARCHAR2_TABLE_100();
125: a13 := JTF_VARCHAR2_TABLE_100();
118: a6 := JTF_VARCHAR2_TABLE_100();
119: a7 := JTF_NUMBER_TABLE();
120: a8 := JTF_NUMBER_TABLE();
121: a9 := JTF_NUMBER_TABLE();
122: a10 := JTF_NUMBER_TABLE();
123: a11 := JTF_VARCHAR2_TABLE_100();
124: a12 := JTF_VARCHAR2_TABLE_100();
125: a13 := JTF_VARCHAR2_TABLE_100();
126: a14 := JTF_NUMBER_TABLE();
122: a10 := JTF_NUMBER_TABLE();
123: a11 := JTF_VARCHAR2_TABLE_100();
124: a12 := JTF_VARCHAR2_TABLE_100();
125: a13 := JTF_VARCHAR2_TABLE_100();
126: a14 := JTF_NUMBER_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
123: a11 := JTF_VARCHAR2_TABLE_100();
124: a12 := JTF_VARCHAR2_TABLE_100();
125: a13 := JTF_VARCHAR2_TABLE_100();
126: a14 := JTF_NUMBER_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
131: a19 := JTF_NUMBER_TABLE();
124: a12 := JTF_VARCHAR2_TABLE_100();
125: a13 := JTF_VARCHAR2_TABLE_100();
126: a14 := JTF_NUMBER_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
131: a19 := JTF_NUMBER_TABLE();
132: a20 := JTF_NUMBER_TABLE();
127: a15 := JTF_NUMBER_TABLE();
128: a16 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
131: a19 := JTF_NUMBER_TABLE();
132: a20 := JTF_NUMBER_TABLE();
133: a21 := JTF_NUMBER_TABLE();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
128: a16 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
131: a19 := JTF_NUMBER_TABLE();
132: a20 := JTF_NUMBER_TABLE();
133: a21 := JTF_NUMBER_TABLE();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
136: a0 := JTF_NUMBER_TABLE();
129: a17 := JTF_VARCHAR2_TABLE_100();
130: a18 := JTF_VARCHAR2_TABLE_100();
131: a19 := JTF_NUMBER_TABLE();
132: a20 := JTF_NUMBER_TABLE();
133: a21 := JTF_NUMBER_TABLE();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
132: a20 := JTF_NUMBER_TABLE();
133: a21 := JTF_NUMBER_TABLE();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
133: a21 := JTF_NUMBER_TABLE();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
134: a22 := JTF_VARCHAR2_TABLE_100();
135: else
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_VARCHAR2_TABLE_100();
150: a14 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_VARCHAR2_TABLE_100();
150: a14 := JTF_NUMBER_TABLE();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_NUMBER_TABLE();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_VARCHAR2_TABLE_100();
150: a14 := JTF_NUMBER_TABLE();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_NUMBER_TABLE();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
155: a19 := JTF_NUMBER_TABLE();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_VARCHAR2_TABLE_100();
150: a14 := JTF_NUMBER_TABLE();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_NUMBER_TABLE();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
155: a19 := JTF_NUMBER_TABLE();
156: a20 := JTF_NUMBER_TABLE();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_NUMBER_TABLE();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
155: a19 := JTF_NUMBER_TABLE();
156: a20 := JTF_NUMBER_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_VARCHAR2_TABLE_100();
159: if t.count > 0 then
152: a16 := JTF_NUMBER_TABLE();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
155: a19 := JTF_NUMBER_TABLE();
156: a20 := JTF_NUMBER_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_VARCHAR2_TABLE_100();
159: if t.count > 0 then
160: a0.extend(t.count);
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_VARCHAR2_TABLE_100();
155: a19 := JTF_NUMBER_TABLE();
156: a20 := JTF_NUMBER_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_VARCHAR2_TABLE_100();
159: if t.count > 0 then
160: a0.extend(t.count);
161: a1.extend(t.count);
215: end if;
216: end if;
217: end rosetta_table_copy_out_p2;
218:
219: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100
216: end if;
217: end rosetta_table_copy_out_p2;
218:
219: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100
224: , a5 JTF_VARCHAR2_TABLE_100
217: end rosetta_table_copy_out_p2;
218:
219: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100
224: , a5 JTF_VARCHAR2_TABLE_100
225: , a6 JTF_VARCHAR2_TABLE_100
218:
219: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100
224: , a5 JTF_VARCHAR2_TABLE_100
225: , a6 JTF_VARCHAR2_TABLE_100
226: , a7 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100
224: , a5 JTF_VARCHAR2_TABLE_100
225: , a6 JTF_VARCHAR2_TABLE_100
226: , a7 JTF_NUMBER_TABLE
227: , a8 JTF_VARCHAR2_TABLE_100
228: , a9 JTF_VARCHAR2_TABLE_100
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_VARCHAR2_TABLE_100
227: , a8 JTF_VARCHAR2_TABLE_100
228: , a9 JTF_VARCHAR2_TABLE_100
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_VARCHAR2_TABLE_100
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_NUMBER_TABLE
234: , a15 JTF_NUMBER_TABLE
235: , a16 JTF_NUMBER_TABLE
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_VARCHAR2_TABLE_100
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_NUMBER_TABLE
234: , a15 JTF_NUMBER_TABLE
235: , a16 JTF_NUMBER_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_VARCHAR2_TABLE_100
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_NUMBER_TABLE
234: , a15 JTF_NUMBER_TABLE
235: , a16 JTF_NUMBER_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_DATE_TABLE
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_NUMBER_TABLE
234: , a15 JTF_NUMBER_TABLE
235: , a16 JTF_NUMBER_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_DATE_TABLE
239: , a20 JTF_DATE_TABLE
232: , a13 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_NUMBER_TABLE
234: , a15 JTF_NUMBER_TABLE
235: , a16 JTF_NUMBER_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_DATE_TABLE
239: , a20 JTF_DATE_TABLE
240: , a21 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_DATE_TABLE
239: , a20 JTF_DATE_TABLE
240: , a21 JTF_VARCHAR2_TABLE_100
241: , a22 JTF_DATE_TABLE
242: , a23 JTF_NUMBER_TABLE
243: , a24 JTF_DATE_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
240: , a21 JTF_VARCHAR2_TABLE_100
241: , a22 JTF_DATE_TABLE
242: , a23 JTF_NUMBER_TABLE
243: , a24 JTF_DATE_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
241: , a22 JTF_DATE_TABLE
242: , a23 JTF_NUMBER_TABLE
243: , a24 JTF_DATE_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
242: , a23 JTF_NUMBER_TABLE
243: , a24 JTF_DATE_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
250: , a31 JTF_VARCHAR2_TABLE_100
243: , a24 JTF_DATE_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
250: , a31 JTF_VARCHAR2_TABLE_100
251: , a32 JTF_NUMBER_TABLE
244: , a25 JTF_NUMBER_TABLE
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
250: , a31 JTF_VARCHAR2_TABLE_100
251: , a32 JTF_NUMBER_TABLE
252: , a33 JTF_VARCHAR2_TABLE_100
245: , a26 JTF_NUMBER_TABLE
246: , a27 JTF_NUMBER_TABLE
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
250: , a31 JTF_VARCHAR2_TABLE_100
251: , a32 JTF_NUMBER_TABLE
252: , a33 JTF_VARCHAR2_TABLE_100
253: , a34 JTF_VARCHAR2_TABLE_100
247: , a28 JTF_NUMBER_TABLE
248: , a29 JTF_NUMBER_TABLE
249: , a30 JTF_NUMBER_TABLE
250: , a31 JTF_VARCHAR2_TABLE_100
251: , a32 JTF_NUMBER_TABLE
252: , a33 JTF_VARCHAR2_TABLE_100
253: , a34 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;
302: end loop;
303: end if;
304: end if;
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
303: end if;
304: end if;
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_VARCHAR2_TABLE_100
304: end if;
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_VARCHAR2_TABLE_100
312: , a6 out nocopy JTF_VARCHAR2_TABLE_100
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_VARCHAR2_TABLE_100
312: , a6 out nocopy JTF_VARCHAR2_TABLE_100
313: , a7 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_VARCHAR2_TABLE_100
312: , a6 out nocopy JTF_VARCHAR2_TABLE_100
313: , a7 out nocopy JTF_NUMBER_TABLE
314: , a8 out nocopy JTF_VARCHAR2_TABLE_100
315: , a9 out nocopy JTF_VARCHAR2_TABLE_100
316: , a10 out nocopy JTF_VARCHAR2_TABLE_100
317: , a11 out nocopy JTF_VARCHAR2_TABLE_100
314: , a8 out nocopy JTF_VARCHAR2_TABLE_100
315: , a9 out nocopy JTF_VARCHAR2_TABLE_100
316: , a10 out nocopy JTF_VARCHAR2_TABLE_100
317: , a11 out nocopy JTF_VARCHAR2_TABLE_100
318: , a12 out nocopy JTF_NUMBER_TABLE
319: , a13 out nocopy JTF_VARCHAR2_TABLE_100
320: , a14 out nocopy JTF_NUMBER_TABLE
321: , a15 out nocopy JTF_NUMBER_TABLE
322: , a16 out nocopy JTF_NUMBER_TABLE
316: , a10 out nocopy JTF_VARCHAR2_TABLE_100
317: , a11 out nocopy JTF_VARCHAR2_TABLE_100
318: , a12 out nocopy JTF_NUMBER_TABLE
319: , a13 out nocopy JTF_VARCHAR2_TABLE_100
320: , a14 out nocopy JTF_NUMBER_TABLE
321: , a15 out nocopy JTF_NUMBER_TABLE
322: , a16 out nocopy JTF_NUMBER_TABLE
323: , a17 out nocopy JTF_NUMBER_TABLE
324: , a18 out nocopy JTF_VARCHAR2_TABLE_100
317: , a11 out nocopy JTF_VARCHAR2_TABLE_100
318: , a12 out nocopy JTF_NUMBER_TABLE
319: , a13 out nocopy JTF_VARCHAR2_TABLE_100
320: , a14 out nocopy JTF_NUMBER_TABLE
321: , a15 out nocopy JTF_NUMBER_TABLE
322: , a16 out nocopy JTF_NUMBER_TABLE
323: , a17 out nocopy JTF_NUMBER_TABLE
324: , a18 out nocopy JTF_VARCHAR2_TABLE_100
325: , a19 out nocopy JTF_DATE_TABLE
318: , a12 out nocopy JTF_NUMBER_TABLE
319: , a13 out nocopy JTF_VARCHAR2_TABLE_100
320: , a14 out nocopy JTF_NUMBER_TABLE
321: , a15 out nocopy JTF_NUMBER_TABLE
322: , a16 out nocopy JTF_NUMBER_TABLE
323: , a17 out nocopy JTF_NUMBER_TABLE
324: , a18 out nocopy JTF_VARCHAR2_TABLE_100
325: , a19 out nocopy JTF_DATE_TABLE
326: , a20 out nocopy JTF_DATE_TABLE
319: , a13 out nocopy JTF_VARCHAR2_TABLE_100
320: , a14 out nocopy JTF_NUMBER_TABLE
321: , a15 out nocopy JTF_NUMBER_TABLE
322: , a16 out nocopy JTF_NUMBER_TABLE
323: , a17 out nocopy JTF_NUMBER_TABLE
324: , a18 out nocopy JTF_VARCHAR2_TABLE_100
325: , a19 out nocopy JTF_DATE_TABLE
326: , a20 out nocopy JTF_DATE_TABLE
327: , a21 out nocopy JTF_VARCHAR2_TABLE_100
325: , a19 out nocopy JTF_DATE_TABLE
326: , a20 out nocopy JTF_DATE_TABLE
327: , a21 out nocopy JTF_VARCHAR2_TABLE_100
328: , a22 out nocopy JTF_DATE_TABLE
329: , a23 out nocopy JTF_NUMBER_TABLE
330: , a24 out nocopy JTF_DATE_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
327: , a21 out nocopy JTF_VARCHAR2_TABLE_100
328: , a22 out nocopy JTF_DATE_TABLE
329: , a23 out nocopy JTF_NUMBER_TABLE
330: , a24 out nocopy JTF_DATE_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
328: , a22 out nocopy JTF_DATE_TABLE
329: , a23 out nocopy JTF_NUMBER_TABLE
330: , a24 out nocopy JTF_DATE_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
329: , a23 out nocopy JTF_NUMBER_TABLE
330: , a24 out nocopy JTF_DATE_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
337: , a31 out nocopy JTF_VARCHAR2_TABLE_100
330: , a24 out nocopy JTF_DATE_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
337: , a31 out nocopy JTF_VARCHAR2_TABLE_100
338: , a32 out nocopy JTF_NUMBER_TABLE
331: , a25 out nocopy JTF_NUMBER_TABLE
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
337: , a31 out nocopy JTF_VARCHAR2_TABLE_100
338: , a32 out nocopy JTF_NUMBER_TABLE
339: , a33 out nocopy JTF_VARCHAR2_TABLE_100
332: , a26 out nocopy JTF_NUMBER_TABLE
333: , a27 out nocopy JTF_NUMBER_TABLE
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
337: , a31 out nocopy JTF_VARCHAR2_TABLE_100
338: , a32 out nocopy JTF_NUMBER_TABLE
339: , a33 out nocopy JTF_VARCHAR2_TABLE_100
340: , a34 out nocopy JTF_VARCHAR2_TABLE_100
334: , a28 out nocopy JTF_NUMBER_TABLE
335: , a29 out nocopy JTF_NUMBER_TABLE
336: , a30 out nocopy JTF_NUMBER_TABLE
337: , a31 out nocopy JTF_VARCHAR2_TABLE_100
338: , a32 out nocopy JTF_NUMBER_TABLE
339: , a33 out nocopy JTF_VARCHAR2_TABLE_100
340: , a34 out nocopy JTF_VARCHAR2_TABLE_100
341: ) as
342: ddindx binary_integer; indx binary_integer;
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: a1 := JTF_NUMBER_TABLE();
347: a2 := JTF_NUMBER_TABLE();
348: a3 := JTF_NUMBER_TABLE();
349: a4 := JTF_VARCHAR2_TABLE_100();
342: ddindx binary_integer; indx binary_integer;
343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: a1 := JTF_NUMBER_TABLE();
347: a2 := JTF_NUMBER_TABLE();
348: a3 := JTF_NUMBER_TABLE();
349: a4 := JTF_VARCHAR2_TABLE_100();
350: a5 := JTF_VARCHAR2_TABLE_100();
343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: a1 := JTF_NUMBER_TABLE();
347: a2 := JTF_NUMBER_TABLE();
348: a3 := JTF_NUMBER_TABLE();
349: a4 := JTF_VARCHAR2_TABLE_100();
350: a5 := JTF_VARCHAR2_TABLE_100();
351: a6 := JTF_VARCHAR2_TABLE_100();
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: a1 := JTF_NUMBER_TABLE();
347: a2 := JTF_NUMBER_TABLE();
348: a3 := JTF_NUMBER_TABLE();
349: a4 := JTF_VARCHAR2_TABLE_100();
350: a5 := JTF_VARCHAR2_TABLE_100();
351: a6 := JTF_VARCHAR2_TABLE_100();
352: a7 := JTF_NUMBER_TABLE();
348: a3 := JTF_NUMBER_TABLE();
349: a4 := JTF_VARCHAR2_TABLE_100();
350: a5 := JTF_VARCHAR2_TABLE_100();
351: a6 := JTF_VARCHAR2_TABLE_100();
352: a7 := JTF_NUMBER_TABLE();
353: a8 := JTF_VARCHAR2_TABLE_100();
354: a9 := JTF_VARCHAR2_TABLE_100();
355: a10 := JTF_VARCHAR2_TABLE_100();
356: a11 := JTF_VARCHAR2_TABLE_100();
353: a8 := JTF_VARCHAR2_TABLE_100();
354: a9 := JTF_VARCHAR2_TABLE_100();
355: a10 := JTF_VARCHAR2_TABLE_100();
356: a11 := JTF_VARCHAR2_TABLE_100();
357: a12 := JTF_NUMBER_TABLE();
358: a13 := JTF_VARCHAR2_TABLE_100();
359: a14 := JTF_NUMBER_TABLE();
360: a15 := JTF_NUMBER_TABLE();
361: a16 := JTF_NUMBER_TABLE();
355: a10 := JTF_VARCHAR2_TABLE_100();
356: a11 := JTF_VARCHAR2_TABLE_100();
357: a12 := JTF_NUMBER_TABLE();
358: a13 := JTF_VARCHAR2_TABLE_100();
359: a14 := JTF_NUMBER_TABLE();
360: a15 := JTF_NUMBER_TABLE();
361: a16 := JTF_NUMBER_TABLE();
362: a17 := JTF_NUMBER_TABLE();
363: a18 := JTF_VARCHAR2_TABLE_100();
356: a11 := JTF_VARCHAR2_TABLE_100();
357: a12 := JTF_NUMBER_TABLE();
358: a13 := JTF_VARCHAR2_TABLE_100();
359: a14 := JTF_NUMBER_TABLE();
360: a15 := JTF_NUMBER_TABLE();
361: a16 := JTF_NUMBER_TABLE();
362: a17 := JTF_NUMBER_TABLE();
363: a18 := JTF_VARCHAR2_TABLE_100();
364: a19 := JTF_DATE_TABLE();
357: a12 := JTF_NUMBER_TABLE();
358: a13 := JTF_VARCHAR2_TABLE_100();
359: a14 := JTF_NUMBER_TABLE();
360: a15 := JTF_NUMBER_TABLE();
361: a16 := JTF_NUMBER_TABLE();
362: a17 := JTF_NUMBER_TABLE();
363: a18 := JTF_VARCHAR2_TABLE_100();
364: a19 := JTF_DATE_TABLE();
365: a20 := JTF_DATE_TABLE();
358: a13 := JTF_VARCHAR2_TABLE_100();
359: a14 := JTF_NUMBER_TABLE();
360: a15 := JTF_NUMBER_TABLE();
361: a16 := JTF_NUMBER_TABLE();
362: a17 := JTF_NUMBER_TABLE();
363: a18 := JTF_VARCHAR2_TABLE_100();
364: a19 := JTF_DATE_TABLE();
365: a20 := JTF_DATE_TABLE();
366: a21 := JTF_VARCHAR2_TABLE_100();
364: a19 := JTF_DATE_TABLE();
365: a20 := JTF_DATE_TABLE();
366: a21 := JTF_VARCHAR2_TABLE_100();
367: a22 := JTF_DATE_TABLE();
368: a23 := JTF_NUMBER_TABLE();
369: a24 := JTF_DATE_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
366: a21 := JTF_VARCHAR2_TABLE_100();
367: a22 := JTF_DATE_TABLE();
368: a23 := JTF_NUMBER_TABLE();
369: a24 := JTF_DATE_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
367: a22 := JTF_DATE_TABLE();
368: a23 := JTF_NUMBER_TABLE();
369: a24 := JTF_DATE_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
368: a23 := JTF_NUMBER_TABLE();
369: a24 := JTF_DATE_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
376: a31 := JTF_VARCHAR2_TABLE_100();
369: a24 := JTF_DATE_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
376: a31 := JTF_VARCHAR2_TABLE_100();
377: a32 := JTF_NUMBER_TABLE();
370: a25 := JTF_NUMBER_TABLE();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
376: a31 := JTF_VARCHAR2_TABLE_100();
377: a32 := JTF_NUMBER_TABLE();
378: a33 := JTF_VARCHAR2_TABLE_100();
371: a26 := JTF_NUMBER_TABLE();
372: a27 := JTF_NUMBER_TABLE();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
376: a31 := JTF_VARCHAR2_TABLE_100();
377: a32 := JTF_NUMBER_TABLE();
378: a33 := JTF_VARCHAR2_TABLE_100();
379: a34 := JTF_VARCHAR2_TABLE_100();
373: a28 := JTF_NUMBER_TABLE();
374: a29 := JTF_NUMBER_TABLE();
375: a30 := JTF_NUMBER_TABLE();
376: a31 := JTF_VARCHAR2_TABLE_100();
377: a32 := JTF_NUMBER_TABLE();
378: a33 := JTF_VARCHAR2_TABLE_100();
379: a34 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
377: a32 := JTF_NUMBER_TABLE();
378: a33 := JTF_VARCHAR2_TABLE_100();
379: a34 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_100();
378: a33 := JTF_VARCHAR2_TABLE_100();
379: a34 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_100();
386: a5 := JTF_VARCHAR2_TABLE_100();
379: a34 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_100();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_100();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_VARCHAR2_TABLE_100();
388: a7 := JTF_NUMBER_TABLE();
384: a3 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_100();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_VARCHAR2_TABLE_100();
388: a7 := JTF_NUMBER_TABLE();
389: a8 := JTF_VARCHAR2_TABLE_100();
390: a9 := JTF_VARCHAR2_TABLE_100();
391: a10 := JTF_VARCHAR2_TABLE_100();
392: a11 := JTF_VARCHAR2_TABLE_100();
389: a8 := JTF_VARCHAR2_TABLE_100();
390: a9 := JTF_VARCHAR2_TABLE_100();
391: a10 := JTF_VARCHAR2_TABLE_100();
392: a11 := JTF_VARCHAR2_TABLE_100();
393: a12 := JTF_NUMBER_TABLE();
394: a13 := JTF_VARCHAR2_TABLE_100();
395: a14 := JTF_NUMBER_TABLE();
396: a15 := JTF_NUMBER_TABLE();
397: a16 := JTF_NUMBER_TABLE();
391: a10 := JTF_VARCHAR2_TABLE_100();
392: a11 := JTF_VARCHAR2_TABLE_100();
393: a12 := JTF_NUMBER_TABLE();
394: a13 := JTF_VARCHAR2_TABLE_100();
395: a14 := JTF_NUMBER_TABLE();
396: a15 := JTF_NUMBER_TABLE();
397: a16 := JTF_NUMBER_TABLE();
398: a17 := JTF_NUMBER_TABLE();
399: a18 := JTF_VARCHAR2_TABLE_100();
392: a11 := JTF_VARCHAR2_TABLE_100();
393: a12 := JTF_NUMBER_TABLE();
394: a13 := JTF_VARCHAR2_TABLE_100();
395: a14 := JTF_NUMBER_TABLE();
396: a15 := JTF_NUMBER_TABLE();
397: a16 := JTF_NUMBER_TABLE();
398: a17 := JTF_NUMBER_TABLE();
399: a18 := JTF_VARCHAR2_TABLE_100();
400: a19 := JTF_DATE_TABLE();
393: a12 := JTF_NUMBER_TABLE();
394: a13 := JTF_VARCHAR2_TABLE_100();
395: a14 := JTF_NUMBER_TABLE();
396: a15 := JTF_NUMBER_TABLE();
397: a16 := JTF_NUMBER_TABLE();
398: a17 := JTF_NUMBER_TABLE();
399: a18 := JTF_VARCHAR2_TABLE_100();
400: a19 := JTF_DATE_TABLE();
401: a20 := JTF_DATE_TABLE();
394: a13 := JTF_VARCHAR2_TABLE_100();
395: a14 := JTF_NUMBER_TABLE();
396: a15 := JTF_NUMBER_TABLE();
397: a16 := JTF_NUMBER_TABLE();
398: a17 := JTF_NUMBER_TABLE();
399: a18 := JTF_VARCHAR2_TABLE_100();
400: a19 := JTF_DATE_TABLE();
401: a20 := JTF_DATE_TABLE();
402: a21 := JTF_VARCHAR2_TABLE_100();
400: a19 := JTF_DATE_TABLE();
401: a20 := JTF_DATE_TABLE();
402: a21 := JTF_VARCHAR2_TABLE_100();
403: a22 := JTF_DATE_TABLE();
404: a23 := JTF_NUMBER_TABLE();
405: a24 := JTF_DATE_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
402: a21 := JTF_VARCHAR2_TABLE_100();
403: a22 := JTF_DATE_TABLE();
404: a23 := JTF_NUMBER_TABLE();
405: a24 := JTF_DATE_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
403: a22 := JTF_DATE_TABLE();
404: a23 := JTF_NUMBER_TABLE();
405: a24 := JTF_DATE_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
404: a23 := JTF_NUMBER_TABLE();
405: a24 := JTF_DATE_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
412: a31 := JTF_VARCHAR2_TABLE_100();
405: a24 := JTF_DATE_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
412: a31 := JTF_VARCHAR2_TABLE_100();
413: a32 := JTF_NUMBER_TABLE();
406: a25 := JTF_NUMBER_TABLE();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
412: a31 := JTF_VARCHAR2_TABLE_100();
413: a32 := JTF_NUMBER_TABLE();
414: a33 := JTF_VARCHAR2_TABLE_100();
407: a26 := JTF_NUMBER_TABLE();
408: a27 := JTF_NUMBER_TABLE();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
412: a31 := JTF_VARCHAR2_TABLE_100();
413: a32 := JTF_NUMBER_TABLE();
414: a33 := JTF_VARCHAR2_TABLE_100();
415: a34 := JTF_VARCHAR2_TABLE_100();
409: a28 := JTF_NUMBER_TABLE();
410: a29 := JTF_NUMBER_TABLE();
411: a30 := JTF_NUMBER_TABLE();
412: a31 := JTF_VARCHAR2_TABLE_100();
413: a32 := JTF_NUMBER_TABLE();
414: a33 := JTF_VARCHAR2_TABLE_100();
415: a34 := JTF_VARCHAR2_TABLE_100();
416: if t.count > 0 then
417: a0.extend(t.count);
496: end if;
497: end if;
498: end rosetta_table_copy_out_p4;
499:
500: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
501: , a1 JTF_NUMBER_TABLE
502: , a2 JTF_VARCHAR2_TABLE_100
503: , a3 JTF_NUMBER_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100
497: end if;
498: end rosetta_table_copy_out_p4;
499:
500: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
501: , a1 JTF_NUMBER_TABLE
502: , a2 JTF_VARCHAR2_TABLE_100
503: , a3 JTF_NUMBER_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100
505: , a5 JTF_VARCHAR2_TABLE_100
499:
500: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
501: , a1 JTF_NUMBER_TABLE
502: , a2 JTF_VARCHAR2_TABLE_100
503: , a3 JTF_NUMBER_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100
505: , a5 JTF_VARCHAR2_TABLE_100
506: , a6 JTF_DATE_TABLE
507: , a7 JTF_DATE_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100
505: , a5 JTF_VARCHAR2_TABLE_100
506: , a6 JTF_DATE_TABLE
507: , a7 JTF_DATE_TABLE
508: , a8 JTF_NUMBER_TABLE
509: , a9 JTF_NUMBER_TABLE
510: , a10 JTF_DATE_TABLE
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
505: , a5 JTF_VARCHAR2_TABLE_100
506: , a6 JTF_DATE_TABLE
507: , a7 JTF_DATE_TABLE
508: , a8 JTF_NUMBER_TABLE
509: , a9 JTF_NUMBER_TABLE
510: , a10 JTF_DATE_TABLE
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
513: , a13 JTF_NUMBER_TABLE
507: , a7 JTF_DATE_TABLE
508: , a8 JTF_NUMBER_TABLE
509: , a9 JTF_NUMBER_TABLE
510: , a10 JTF_DATE_TABLE
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
513: , a13 JTF_NUMBER_TABLE
514: , a14 JTF_NUMBER_TABLE
515: , a15 JTF_NUMBER_TABLE
509: , a9 JTF_NUMBER_TABLE
510: , a10 JTF_DATE_TABLE
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
513: , a13 JTF_NUMBER_TABLE
514: , a14 JTF_NUMBER_TABLE
515: , a15 JTF_NUMBER_TABLE
516: , a16 JTF_VARCHAR2_TABLE_100
517: ) as
510: , a10 JTF_DATE_TABLE
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
513: , a13 JTF_NUMBER_TABLE
514: , a14 JTF_NUMBER_TABLE
515: , a15 JTF_NUMBER_TABLE
516: , a16 JTF_VARCHAR2_TABLE_100
517: ) as
518: ddindx binary_integer; indx binary_integer;
511: , a11 JTF_NUMBER_TABLE
512: , a12 JTF_DATE_TABLE
513: , a13 JTF_NUMBER_TABLE
514: , a14 JTF_NUMBER_TABLE
515: , a15 JTF_NUMBER_TABLE
516: , a16 JTF_VARCHAR2_TABLE_100
517: ) as
518: ddindx binary_integer; indx binary_integer;
519: begin
547: end loop;
548: end if;
549: end if;
550: end rosetta_table_copy_in_p6;
551: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
552: , a1 out nocopy JTF_NUMBER_TABLE
553: , a2 out nocopy JTF_VARCHAR2_TABLE_100
554: , a3 out nocopy JTF_NUMBER_TABLE
555: , a4 out nocopy JTF_VARCHAR2_TABLE_100
548: end if;
549: end if;
550: end rosetta_table_copy_in_p6;
551: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
552: , a1 out nocopy JTF_NUMBER_TABLE
553: , a2 out nocopy JTF_VARCHAR2_TABLE_100
554: , a3 out nocopy JTF_NUMBER_TABLE
555: , a4 out nocopy JTF_VARCHAR2_TABLE_100
556: , a5 out nocopy JTF_VARCHAR2_TABLE_100
550: end rosetta_table_copy_in_p6;
551: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
552: , a1 out nocopy JTF_NUMBER_TABLE
553: , a2 out nocopy JTF_VARCHAR2_TABLE_100
554: , a3 out nocopy JTF_NUMBER_TABLE
555: , a4 out nocopy JTF_VARCHAR2_TABLE_100
556: , a5 out nocopy JTF_VARCHAR2_TABLE_100
557: , a6 out nocopy JTF_DATE_TABLE
558: , a7 out nocopy JTF_DATE_TABLE
555: , a4 out nocopy JTF_VARCHAR2_TABLE_100
556: , a5 out nocopy JTF_VARCHAR2_TABLE_100
557: , a6 out nocopy JTF_DATE_TABLE
558: , a7 out nocopy JTF_DATE_TABLE
559: , a8 out nocopy JTF_NUMBER_TABLE
560: , a9 out nocopy JTF_NUMBER_TABLE
561: , a10 out nocopy JTF_DATE_TABLE
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
556: , a5 out nocopy JTF_VARCHAR2_TABLE_100
557: , a6 out nocopy JTF_DATE_TABLE
558: , a7 out nocopy JTF_DATE_TABLE
559: , a8 out nocopy JTF_NUMBER_TABLE
560: , a9 out nocopy JTF_NUMBER_TABLE
561: , a10 out nocopy JTF_DATE_TABLE
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
564: , a13 out nocopy JTF_NUMBER_TABLE
558: , a7 out nocopy JTF_DATE_TABLE
559: , a8 out nocopy JTF_NUMBER_TABLE
560: , a9 out nocopy JTF_NUMBER_TABLE
561: , a10 out nocopy JTF_DATE_TABLE
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
564: , a13 out nocopy JTF_NUMBER_TABLE
565: , a14 out nocopy JTF_NUMBER_TABLE
566: , a15 out nocopy JTF_NUMBER_TABLE
560: , a9 out nocopy JTF_NUMBER_TABLE
561: , a10 out nocopy JTF_DATE_TABLE
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
564: , a13 out nocopy JTF_NUMBER_TABLE
565: , a14 out nocopy JTF_NUMBER_TABLE
566: , a15 out nocopy JTF_NUMBER_TABLE
567: , a16 out nocopy JTF_VARCHAR2_TABLE_100
568: ) as
561: , a10 out nocopy JTF_DATE_TABLE
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
564: , a13 out nocopy JTF_NUMBER_TABLE
565: , a14 out nocopy JTF_NUMBER_TABLE
566: , a15 out nocopy JTF_NUMBER_TABLE
567: , a16 out nocopy JTF_VARCHAR2_TABLE_100
568: ) as
569: ddindx binary_integer; indx binary_integer;
562: , a11 out nocopy JTF_NUMBER_TABLE
563: , a12 out nocopy JTF_DATE_TABLE
564: , a13 out nocopy JTF_NUMBER_TABLE
565: , a14 out nocopy JTF_NUMBER_TABLE
566: , a15 out nocopy JTF_NUMBER_TABLE
567: , a16 out nocopy JTF_VARCHAR2_TABLE_100
568: ) as
569: ddindx binary_integer; indx binary_integer;
570: begin
568: ) as
569: ddindx binary_integer; indx binary_integer;
570: begin
571: if t is null or t.count = 0 then
572: a0 := JTF_NUMBER_TABLE();
573: a1 := JTF_NUMBER_TABLE();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_NUMBER_TABLE();
576: a4 := JTF_VARCHAR2_TABLE_100();
569: ddindx binary_integer; indx binary_integer;
570: begin
571: if t is null or t.count = 0 then
572: a0 := JTF_NUMBER_TABLE();
573: a1 := JTF_NUMBER_TABLE();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_NUMBER_TABLE();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_VARCHAR2_TABLE_100();
571: if t is null or t.count = 0 then
572: a0 := JTF_NUMBER_TABLE();
573: a1 := JTF_NUMBER_TABLE();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_NUMBER_TABLE();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_VARCHAR2_TABLE_100();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_DATE_TABLE();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_VARCHAR2_TABLE_100();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_DATE_TABLE();
580: a8 := JTF_NUMBER_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: a10 := JTF_DATE_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
577: a5 := JTF_VARCHAR2_TABLE_100();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_DATE_TABLE();
580: a8 := JTF_NUMBER_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: a10 := JTF_DATE_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
585: a13 := JTF_NUMBER_TABLE();
579: a7 := JTF_DATE_TABLE();
580: a8 := JTF_NUMBER_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: a10 := JTF_DATE_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
585: a13 := JTF_NUMBER_TABLE();
586: a14 := JTF_NUMBER_TABLE();
587: a15 := JTF_NUMBER_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: a10 := JTF_DATE_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
585: a13 := JTF_NUMBER_TABLE();
586: a14 := JTF_NUMBER_TABLE();
587: a15 := JTF_NUMBER_TABLE();
588: a16 := JTF_VARCHAR2_TABLE_100();
589: else
582: a10 := JTF_DATE_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
585: a13 := JTF_NUMBER_TABLE();
586: a14 := JTF_NUMBER_TABLE();
587: a15 := JTF_NUMBER_TABLE();
588: a16 := JTF_VARCHAR2_TABLE_100();
589: else
590: a0 := JTF_NUMBER_TABLE();
583: a11 := JTF_NUMBER_TABLE();
584: a12 := JTF_DATE_TABLE();
585: a13 := JTF_NUMBER_TABLE();
586: a14 := JTF_NUMBER_TABLE();
587: a15 := JTF_NUMBER_TABLE();
588: a16 := JTF_VARCHAR2_TABLE_100();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
586: a14 := JTF_NUMBER_TABLE();
587: a15 := JTF_NUMBER_TABLE();
588: a16 := JTF_VARCHAR2_TABLE_100();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_VARCHAR2_TABLE_100();
593: a3 := JTF_NUMBER_TABLE();
594: a4 := JTF_VARCHAR2_TABLE_100();
587: a15 := JTF_NUMBER_TABLE();
588: a16 := JTF_VARCHAR2_TABLE_100();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_VARCHAR2_TABLE_100();
593: a3 := JTF_NUMBER_TABLE();
594: a4 := JTF_VARCHAR2_TABLE_100();
595: a5 := JTF_VARCHAR2_TABLE_100();
589: else
590: a0 := JTF_NUMBER_TABLE();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_VARCHAR2_TABLE_100();
593: a3 := JTF_NUMBER_TABLE();
594: a4 := JTF_VARCHAR2_TABLE_100();
595: a5 := JTF_VARCHAR2_TABLE_100();
596: a6 := JTF_DATE_TABLE();
597: a7 := JTF_DATE_TABLE();
594: a4 := JTF_VARCHAR2_TABLE_100();
595: a5 := JTF_VARCHAR2_TABLE_100();
596: a6 := JTF_DATE_TABLE();
597: a7 := JTF_DATE_TABLE();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_DATE_TABLE();
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
595: a5 := JTF_VARCHAR2_TABLE_100();
596: a6 := JTF_DATE_TABLE();
597: a7 := JTF_DATE_TABLE();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_DATE_TABLE();
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
603: a13 := JTF_NUMBER_TABLE();
597: a7 := JTF_DATE_TABLE();
598: a8 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_DATE_TABLE();
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
603: a13 := JTF_NUMBER_TABLE();
604: a14 := JTF_NUMBER_TABLE();
605: a15 := JTF_NUMBER_TABLE();
599: a9 := JTF_NUMBER_TABLE();
600: a10 := JTF_DATE_TABLE();
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
603: a13 := JTF_NUMBER_TABLE();
604: a14 := JTF_NUMBER_TABLE();
605: a15 := JTF_NUMBER_TABLE();
606: a16 := JTF_VARCHAR2_TABLE_100();
607: if t.count > 0 then
600: a10 := JTF_DATE_TABLE();
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
603: a13 := JTF_NUMBER_TABLE();
604: a14 := JTF_NUMBER_TABLE();
605: a15 := JTF_NUMBER_TABLE();
606: a16 := JTF_VARCHAR2_TABLE_100();
607: if t.count > 0 then
608: a0.extend(t.count);
601: a11 := JTF_NUMBER_TABLE();
602: a12 := JTF_DATE_TABLE();
603: a13 := JTF_NUMBER_TABLE();
604: a14 := JTF_NUMBER_TABLE();
605: a15 := JTF_NUMBER_TABLE();
606: a16 := JTF_VARCHAR2_TABLE_100();
607: if t.count > 0 then
608: a0.extend(t.count);
609: a1.extend(t.count);
651: end if;
652: end if;
653: end rosetta_table_copy_out_p6;
654:
655: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656: , a1 JTF_NUMBER_TABLE
657: , a2 JTF_VARCHAR2_TABLE_100
658: , a3 JTF_NUMBER_TABLE
659: , a4 JTF_NUMBER_TABLE
652: end if;
653: end rosetta_table_copy_out_p6;
654:
655: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656: , a1 JTF_NUMBER_TABLE
657: , a2 JTF_VARCHAR2_TABLE_100
658: , a3 JTF_NUMBER_TABLE
659: , a4 JTF_NUMBER_TABLE
660: , a5 JTF_DATE_TABLE
654:
655: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656: , a1 JTF_NUMBER_TABLE
657: , a2 JTF_VARCHAR2_TABLE_100
658: , a3 JTF_NUMBER_TABLE
659: , a4 JTF_NUMBER_TABLE
660: , a5 JTF_DATE_TABLE
661: , a6 JTF_DATE_TABLE
662: , a7 JTF_VARCHAR2_TABLE_100
655: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656: , a1 JTF_NUMBER_TABLE
657: , a2 JTF_VARCHAR2_TABLE_100
658: , a3 JTF_NUMBER_TABLE
659: , a4 JTF_NUMBER_TABLE
660: , a5 JTF_DATE_TABLE
661: , a6 JTF_DATE_TABLE
662: , a7 JTF_VARCHAR2_TABLE_100
663: ) as
684: end loop;
685: end if;
686: end if;
687: end rosetta_table_copy_in_p8;
688: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689: , a1 out nocopy JTF_NUMBER_TABLE
690: , a2 out nocopy JTF_VARCHAR2_TABLE_100
691: , a3 out nocopy JTF_NUMBER_TABLE
692: , a4 out nocopy JTF_NUMBER_TABLE
685: end if;
686: end if;
687: end rosetta_table_copy_in_p8;
688: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689: , a1 out nocopy JTF_NUMBER_TABLE
690: , a2 out nocopy JTF_VARCHAR2_TABLE_100
691: , a3 out nocopy JTF_NUMBER_TABLE
692: , a4 out nocopy JTF_NUMBER_TABLE
693: , a5 out nocopy JTF_DATE_TABLE
687: end rosetta_table_copy_in_p8;
688: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689: , a1 out nocopy JTF_NUMBER_TABLE
690: , a2 out nocopy JTF_VARCHAR2_TABLE_100
691: , a3 out nocopy JTF_NUMBER_TABLE
692: , a4 out nocopy JTF_NUMBER_TABLE
693: , a5 out nocopy JTF_DATE_TABLE
694: , a6 out nocopy JTF_DATE_TABLE
695: , a7 out nocopy JTF_VARCHAR2_TABLE_100
688: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689: , a1 out nocopy JTF_NUMBER_TABLE
690: , a2 out nocopy JTF_VARCHAR2_TABLE_100
691: , a3 out nocopy JTF_NUMBER_TABLE
692: , a4 out nocopy JTF_NUMBER_TABLE
693: , a5 out nocopy JTF_DATE_TABLE
694: , a6 out nocopy JTF_DATE_TABLE
695: , a7 out nocopy JTF_VARCHAR2_TABLE_100
696: ) as
696: ) as
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
700: a0 := JTF_NUMBER_TABLE();
701: a1 := JTF_NUMBER_TABLE();
702: a2 := JTF_VARCHAR2_TABLE_100();
703: a3 := JTF_NUMBER_TABLE();
704: a4 := JTF_NUMBER_TABLE();
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
700: a0 := JTF_NUMBER_TABLE();
701: a1 := JTF_NUMBER_TABLE();
702: a2 := JTF_VARCHAR2_TABLE_100();
703: a3 := JTF_NUMBER_TABLE();
704: a4 := JTF_NUMBER_TABLE();
705: a5 := JTF_DATE_TABLE();
699: if t is null or t.count = 0 then
700: a0 := JTF_NUMBER_TABLE();
701: a1 := JTF_NUMBER_TABLE();
702: a2 := JTF_VARCHAR2_TABLE_100();
703: a3 := JTF_NUMBER_TABLE();
704: a4 := JTF_NUMBER_TABLE();
705: a5 := JTF_DATE_TABLE();
706: a6 := JTF_DATE_TABLE();
707: a7 := JTF_VARCHAR2_TABLE_100();
700: a0 := JTF_NUMBER_TABLE();
701: a1 := JTF_NUMBER_TABLE();
702: a2 := JTF_VARCHAR2_TABLE_100();
703: a3 := JTF_NUMBER_TABLE();
704: a4 := JTF_NUMBER_TABLE();
705: a5 := JTF_DATE_TABLE();
706: a6 := JTF_DATE_TABLE();
707: a7 := JTF_VARCHAR2_TABLE_100();
708: else
705: a5 := JTF_DATE_TABLE();
706: a6 := JTF_DATE_TABLE();
707: a7 := JTF_VARCHAR2_TABLE_100();
708: else
709: a0 := JTF_NUMBER_TABLE();
710: a1 := JTF_NUMBER_TABLE();
711: a2 := JTF_VARCHAR2_TABLE_100();
712: a3 := JTF_NUMBER_TABLE();
713: a4 := JTF_NUMBER_TABLE();
706: a6 := JTF_DATE_TABLE();
707: a7 := JTF_VARCHAR2_TABLE_100();
708: else
709: a0 := JTF_NUMBER_TABLE();
710: a1 := JTF_NUMBER_TABLE();
711: a2 := JTF_VARCHAR2_TABLE_100();
712: a3 := JTF_NUMBER_TABLE();
713: a4 := JTF_NUMBER_TABLE();
714: a5 := JTF_DATE_TABLE();
708: else
709: a0 := JTF_NUMBER_TABLE();
710: a1 := JTF_NUMBER_TABLE();
711: a2 := JTF_VARCHAR2_TABLE_100();
712: a3 := JTF_NUMBER_TABLE();
713: a4 := JTF_NUMBER_TABLE();
714: a5 := JTF_DATE_TABLE();
715: a6 := JTF_DATE_TABLE();
716: a7 := JTF_VARCHAR2_TABLE_100();
709: a0 := JTF_NUMBER_TABLE();
710: a1 := JTF_NUMBER_TABLE();
711: a2 := JTF_VARCHAR2_TABLE_100();
712: a3 := JTF_NUMBER_TABLE();
713: a4 := JTF_NUMBER_TABLE();
714: a5 := JTF_DATE_TABLE();
715: a6 := JTF_DATE_TABLE();
716: a7 := JTF_VARCHAR2_TABLE_100();
717: if t.count > 0 then
743: end if;
744: end if;
745: end rosetta_table_copy_out_p8;
746:
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
744: end if;
745: end rosetta_table_copy_out_p8;
746:
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
752: , a5 JTF_VARCHAR2_TABLE_100
745: end rosetta_table_copy_out_p8;
746:
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
752: , a5 JTF_VARCHAR2_TABLE_100
753: , a6 JTF_VARCHAR2_TABLE_100
746:
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
752: , a5 JTF_VARCHAR2_TABLE_100
753: , a6 JTF_VARCHAR2_TABLE_100
754: , a7 JTF_VARCHAR2_TABLE_100
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
752: , a5 JTF_VARCHAR2_TABLE_100
753: , a6 JTF_VARCHAR2_TABLE_100
754: , a7 JTF_VARCHAR2_TABLE_100
755: , a8 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE
752: , a5 JTF_VARCHAR2_TABLE_100
753: , a6 JTF_VARCHAR2_TABLE_100
754: , a7 JTF_VARCHAR2_TABLE_100
755: , a8 JTF_NUMBER_TABLE
756: , a9 JTF_VARCHAR2_TABLE_100
757: , a10 JTF_DATE_TABLE
758: , a11 JTF_DATE_TABLE
759: , a12 JTF_VARCHAR2_TABLE_100
756: , a9 JTF_VARCHAR2_TABLE_100
757: , a10 JTF_DATE_TABLE
758: , a11 JTF_DATE_TABLE
759: , a12 JTF_VARCHAR2_TABLE_100
760: , a13 JTF_NUMBER_TABLE
761: , a14 JTF_VARCHAR2_TABLE_100
762: ) as
763: ddindx binary_integer; indx binary_integer;
764: begin
790: end loop;
791: end if;
792: end if;
793: end rosetta_table_copy_in_p10;
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
791: end if;
792: end if;
793: end rosetta_table_copy_in_p10;
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
799: , a5 out nocopy JTF_VARCHAR2_TABLE_100
792: end if;
793: end rosetta_table_copy_in_p10;
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
799: , a5 out nocopy JTF_VARCHAR2_TABLE_100
800: , a6 out nocopy JTF_VARCHAR2_TABLE_100
793: end rosetta_table_copy_in_p10;
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
799: , a5 out nocopy JTF_VARCHAR2_TABLE_100
800: , a6 out nocopy JTF_VARCHAR2_TABLE_100
801: , a7 out nocopy JTF_VARCHAR2_TABLE_100
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
799: , a5 out nocopy JTF_VARCHAR2_TABLE_100
800: , a6 out nocopy JTF_VARCHAR2_TABLE_100
801: , a7 out nocopy JTF_VARCHAR2_TABLE_100
802: , a8 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE
799: , a5 out nocopy JTF_VARCHAR2_TABLE_100
800: , a6 out nocopy JTF_VARCHAR2_TABLE_100
801: , a7 out nocopy JTF_VARCHAR2_TABLE_100
802: , a8 out nocopy JTF_NUMBER_TABLE
803: , a9 out nocopy JTF_VARCHAR2_TABLE_100
804: , a10 out nocopy JTF_DATE_TABLE
805: , a11 out nocopy JTF_DATE_TABLE
806: , a12 out nocopy JTF_VARCHAR2_TABLE_100
803: , a9 out nocopy JTF_VARCHAR2_TABLE_100
804: , a10 out nocopy JTF_DATE_TABLE
805: , a11 out nocopy JTF_DATE_TABLE
806: , a12 out nocopy JTF_VARCHAR2_TABLE_100
807: , a13 out nocopy JTF_NUMBER_TABLE
808: , a14 out nocopy JTF_VARCHAR2_TABLE_100
809: ) as
810: ddindx binary_integer; indx binary_integer;
811: begin
809: ) as
810: ddindx binary_integer; indx binary_integer;
811: begin
812: if t is null or t.count = 0 then
813: a0 := JTF_NUMBER_TABLE();
814: a1 := JTF_NUMBER_TABLE();
815: a2 := JTF_NUMBER_TABLE();
816: a3 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
810: ddindx binary_integer; indx binary_integer;
811: begin
812: if t is null or t.count = 0 then
813: a0 := JTF_NUMBER_TABLE();
814: a1 := JTF_NUMBER_TABLE();
815: a2 := JTF_NUMBER_TABLE();
816: a3 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
818: a5 := JTF_VARCHAR2_TABLE_100();
811: begin
812: if t is null or t.count = 0 then
813: a0 := JTF_NUMBER_TABLE();
814: a1 := JTF_NUMBER_TABLE();
815: a2 := JTF_NUMBER_TABLE();
816: a3 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
818: a5 := JTF_VARCHAR2_TABLE_100();
819: a6 := JTF_VARCHAR2_TABLE_100();
812: if t is null or t.count = 0 then
813: a0 := JTF_NUMBER_TABLE();
814: a1 := JTF_NUMBER_TABLE();
815: a2 := JTF_NUMBER_TABLE();
816: a3 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
818: a5 := JTF_VARCHAR2_TABLE_100();
819: a6 := JTF_VARCHAR2_TABLE_100();
820: a7 := JTF_VARCHAR2_TABLE_100();
813: a0 := JTF_NUMBER_TABLE();
814: a1 := JTF_NUMBER_TABLE();
815: a2 := JTF_NUMBER_TABLE();
816: a3 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
818: a5 := JTF_VARCHAR2_TABLE_100();
819: a6 := JTF_VARCHAR2_TABLE_100();
820: a7 := JTF_VARCHAR2_TABLE_100();
821: a8 := JTF_NUMBER_TABLE();
817: a4 := JTF_NUMBER_TABLE();
818: a5 := JTF_VARCHAR2_TABLE_100();
819: a6 := JTF_VARCHAR2_TABLE_100();
820: a7 := JTF_VARCHAR2_TABLE_100();
821: a8 := JTF_NUMBER_TABLE();
822: a9 := JTF_VARCHAR2_TABLE_100();
823: a10 := JTF_DATE_TABLE();
824: a11 := JTF_DATE_TABLE();
825: a12 := JTF_VARCHAR2_TABLE_100();
822: a9 := JTF_VARCHAR2_TABLE_100();
823: a10 := JTF_DATE_TABLE();
824: a11 := JTF_DATE_TABLE();
825: a12 := JTF_VARCHAR2_TABLE_100();
826: a13 := JTF_NUMBER_TABLE();
827: a14 := JTF_VARCHAR2_TABLE_100();
828: else
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
825: a12 := JTF_VARCHAR2_TABLE_100();
826: a13 := JTF_NUMBER_TABLE();
827: a14 := JTF_VARCHAR2_TABLE_100();
828: else
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
826: a13 := JTF_NUMBER_TABLE();
827: a14 := JTF_VARCHAR2_TABLE_100();
828: else
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
834: a5 := JTF_VARCHAR2_TABLE_100();
827: a14 := JTF_VARCHAR2_TABLE_100();
828: else
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
834: a5 := JTF_VARCHAR2_TABLE_100();
835: a6 := JTF_VARCHAR2_TABLE_100();
828: else
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
834: a5 := JTF_VARCHAR2_TABLE_100();
835: a6 := JTF_VARCHAR2_TABLE_100();
836: a7 := JTF_VARCHAR2_TABLE_100();
829: a0 := JTF_NUMBER_TABLE();
830: a1 := JTF_NUMBER_TABLE();
831: a2 := JTF_NUMBER_TABLE();
832: a3 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
834: a5 := JTF_VARCHAR2_TABLE_100();
835: a6 := JTF_VARCHAR2_TABLE_100();
836: a7 := JTF_VARCHAR2_TABLE_100();
837: a8 := JTF_NUMBER_TABLE();
833: a4 := JTF_NUMBER_TABLE();
834: a5 := JTF_VARCHAR2_TABLE_100();
835: a6 := JTF_VARCHAR2_TABLE_100();
836: a7 := JTF_VARCHAR2_TABLE_100();
837: a8 := JTF_NUMBER_TABLE();
838: a9 := JTF_VARCHAR2_TABLE_100();
839: a10 := JTF_DATE_TABLE();
840: a11 := JTF_DATE_TABLE();
841: a12 := JTF_VARCHAR2_TABLE_100();
838: a9 := JTF_VARCHAR2_TABLE_100();
839: a10 := JTF_DATE_TABLE();
840: a11 := JTF_DATE_TABLE();
841: a12 := JTF_VARCHAR2_TABLE_100();
842: a13 := JTF_NUMBER_TABLE();
843: a14 := JTF_VARCHAR2_TABLE_100();
844: if t.count > 0 then
845: a0.extend(t.count);
846: a1.extend(t.count);
884: end if;
885: end if;
886: end rosetta_table_copy_out_p10;
887:
888: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
889: , a1 JTF_DATE_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE
886: end rosetta_table_copy_out_p10;
887:
888: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
889: , a1 JTF_DATE_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE
893: , a5 JTF_NUMBER_TABLE
894: , a6 JTF_NUMBER_TABLE
888: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
889: , a1 JTF_DATE_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE
893: , a5 JTF_NUMBER_TABLE
894: , a6 JTF_NUMBER_TABLE
895: , a7 JTF_VARCHAR2_TABLE_100
896: , a8 JTF_VARCHAR2_TABLE_100
889: , a1 JTF_DATE_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE
893: , a5 JTF_NUMBER_TABLE
894: , a6 JTF_NUMBER_TABLE
895: , a7 JTF_VARCHAR2_TABLE_100
896: , a8 JTF_VARCHAR2_TABLE_100
897: , a9 JTF_VARCHAR2_TABLE_300
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE
893: , a5 JTF_NUMBER_TABLE
894: , a6 JTF_NUMBER_TABLE
895: , a7 JTF_VARCHAR2_TABLE_100
896: , a8 JTF_VARCHAR2_TABLE_100
897: , a9 JTF_VARCHAR2_TABLE_300
898: , a10 JTF_DATE_TABLE
896: , a8 JTF_VARCHAR2_TABLE_100
897: , a9 JTF_VARCHAR2_TABLE_300
898: , a10 JTF_DATE_TABLE
899: , a11 JTF_DATE_TABLE
900: , a12 JTF_NUMBER_TABLE
901: , a13 JTF_NUMBER_TABLE
902: , a14 JTF_VARCHAR2_TABLE_100
903: , a15 JTF_VARCHAR2_TABLE_300
904: , a16 JTF_VARCHAR2_TABLE_300
897: , a9 JTF_VARCHAR2_TABLE_300
898: , a10 JTF_DATE_TABLE
899: , a11 JTF_DATE_TABLE
900: , a12 JTF_NUMBER_TABLE
901: , a13 JTF_NUMBER_TABLE
902: , a14 JTF_VARCHAR2_TABLE_100
903: , a15 JTF_VARCHAR2_TABLE_300
904: , a16 JTF_VARCHAR2_TABLE_300
905: , a17 JTF_VARCHAR2_TABLE_300
915: , a27 JTF_VARCHAR2_TABLE_300
916: , a28 JTF_VARCHAR2_TABLE_300
917: , a29 JTF_VARCHAR2_TABLE_300
918: , a30 JTF_VARCHAR2_TABLE_100
919: , a31 JTF_NUMBER_TABLE
920: , a32 JTF_VARCHAR2_TABLE_100
921: ) as
922: ddindx binary_integer; indx binary_integer;
923: begin
967: end loop;
968: end if;
969: end if;
970: end rosetta_table_copy_in_p12;
971: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972: , a1 out nocopy JTF_DATE_TABLE
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE
969: end if;
970: end rosetta_table_copy_in_p12;
971: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972: , a1 out nocopy JTF_DATE_TABLE
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE
976: , a5 out nocopy JTF_NUMBER_TABLE
977: , a6 out nocopy JTF_NUMBER_TABLE
971: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972: , a1 out nocopy JTF_DATE_TABLE
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE
976: , a5 out nocopy JTF_NUMBER_TABLE
977: , a6 out nocopy JTF_NUMBER_TABLE
978: , a7 out nocopy JTF_VARCHAR2_TABLE_100
979: , a8 out nocopy JTF_VARCHAR2_TABLE_100
972: , a1 out nocopy JTF_DATE_TABLE
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE
976: , a5 out nocopy JTF_NUMBER_TABLE
977: , a6 out nocopy JTF_NUMBER_TABLE
978: , a7 out nocopy JTF_VARCHAR2_TABLE_100
979: , a8 out nocopy JTF_VARCHAR2_TABLE_100
980: , a9 out nocopy JTF_VARCHAR2_TABLE_300
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE
976: , a5 out nocopy JTF_NUMBER_TABLE
977: , a6 out nocopy JTF_NUMBER_TABLE
978: , a7 out nocopy JTF_VARCHAR2_TABLE_100
979: , a8 out nocopy JTF_VARCHAR2_TABLE_100
980: , a9 out nocopy JTF_VARCHAR2_TABLE_300
981: , a10 out nocopy JTF_DATE_TABLE
979: , a8 out nocopy JTF_VARCHAR2_TABLE_100
980: , a9 out nocopy JTF_VARCHAR2_TABLE_300
981: , a10 out nocopy JTF_DATE_TABLE
982: , a11 out nocopy JTF_DATE_TABLE
983: , a12 out nocopy JTF_NUMBER_TABLE
984: , a13 out nocopy JTF_NUMBER_TABLE
985: , a14 out nocopy JTF_VARCHAR2_TABLE_100
986: , a15 out nocopy JTF_VARCHAR2_TABLE_300
987: , a16 out nocopy JTF_VARCHAR2_TABLE_300
980: , a9 out nocopy JTF_VARCHAR2_TABLE_300
981: , a10 out nocopy JTF_DATE_TABLE
982: , a11 out nocopy JTF_DATE_TABLE
983: , a12 out nocopy JTF_NUMBER_TABLE
984: , a13 out nocopy JTF_NUMBER_TABLE
985: , a14 out nocopy JTF_VARCHAR2_TABLE_100
986: , a15 out nocopy JTF_VARCHAR2_TABLE_300
987: , a16 out nocopy JTF_VARCHAR2_TABLE_300
988: , a17 out nocopy JTF_VARCHAR2_TABLE_300
998: , a27 out nocopy JTF_VARCHAR2_TABLE_300
999: , a28 out nocopy JTF_VARCHAR2_TABLE_300
1000: , a29 out nocopy JTF_VARCHAR2_TABLE_300
1001: , a30 out nocopy JTF_VARCHAR2_TABLE_100
1002: , a31 out nocopy JTF_NUMBER_TABLE
1003: , a32 out nocopy JTF_VARCHAR2_TABLE_100
1004: ) as
1005: ddindx binary_integer; indx binary_integer;
1006: begin
1004: ) as
1005: ddindx binary_integer; indx binary_integer;
1006: begin
1007: if t is null or t.count = 0 then
1008: a0 := JTF_NUMBER_TABLE();
1009: a1 := JTF_DATE_TABLE();
1010: a2 := JTF_NUMBER_TABLE();
1011: a3 := JTF_DATE_TABLE();
1012: a4 := JTF_NUMBER_TABLE();
1006: begin
1007: if t is null or t.count = 0 then
1008: a0 := JTF_NUMBER_TABLE();
1009: a1 := JTF_DATE_TABLE();
1010: a2 := JTF_NUMBER_TABLE();
1011: a3 := JTF_DATE_TABLE();
1012: a4 := JTF_NUMBER_TABLE();
1013: a5 := JTF_NUMBER_TABLE();
1014: a6 := JTF_NUMBER_TABLE();
1008: a0 := JTF_NUMBER_TABLE();
1009: a1 := JTF_DATE_TABLE();
1010: a2 := JTF_NUMBER_TABLE();
1011: a3 := JTF_DATE_TABLE();
1012: a4 := JTF_NUMBER_TABLE();
1013: a5 := JTF_NUMBER_TABLE();
1014: a6 := JTF_NUMBER_TABLE();
1015: a7 := JTF_VARCHAR2_TABLE_100();
1016: a8 := JTF_VARCHAR2_TABLE_100();
1009: a1 := JTF_DATE_TABLE();
1010: a2 := JTF_NUMBER_TABLE();
1011: a3 := JTF_DATE_TABLE();
1012: a4 := JTF_NUMBER_TABLE();
1013: a5 := JTF_NUMBER_TABLE();
1014: a6 := JTF_NUMBER_TABLE();
1015: a7 := JTF_VARCHAR2_TABLE_100();
1016: a8 := JTF_VARCHAR2_TABLE_100();
1017: a9 := JTF_VARCHAR2_TABLE_300();
1010: a2 := JTF_NUMBER_TABLE();
1011: a3 := JTF_DATE_TABLE();
1012: a4 := JTF_NUMBER_TABLE();
1013: a5 := JTF_NUMBER_TABLE();
1014: a6 := JTF_NUMBER_TABLE();
1015: a7 := JTF_VARCHAR2_TABLE_100();
1016: a8 := JTF_VARCHAR2_TABLE_100();
1017: a9 := JTF_VARCHAR2_TABLE_300();
1018: a10 := JTF_DATE_TABLE();
1016: a8 := JTF_VARCHAR2_TABLE_100();
1017: a9 := JTF_VARCHAR2_TABLE_300();
1018: a10 := JTF_DATE_TABLE();
1019: a11 := JTF_DATE_TABLE();
1020: a12 := JTF_NUMBER_TABLE();
1021: a13 := JTF_NUMBER_TABLE();
1022: a14 := JTF_VARCHAR2_TABLE_100();
1023: a15 := JTF_VARCHAR2_TABLE_300();
1024: a16 := JTF_VARCHAR2_TABLE_300();
1017: a9 := JTF_VARCHAR2_TABLE_300();
1018: a10 := JTF_DATE_TABLE();
1019: a11 := JTF_DATE_TABLE();
1020: a12 := JTF_NUMBER_TABLE();
1021: a13 := JTF_NUMBER_TABLE();
1022: a14 := JTF_VARCHAR2_TABLE_100();
1023: a15 := JTF_VARCHAR2_TABLE_300();
1024: a16 := JTF_VARCHAR2_TABLE_300();
1025: a17 := JTF_VARCHAR2_TABLE_300();
1035: a27 := JTF_VARCHAR2_TABLE_300();
1036: a28 := JTF_VARCHAR2_TABLE_300();
1037: a29 := JTF_VARCHAR2_TABLE_300();
1038: a30 := JTF_VARCHAR2_TABLE_100();
1039: a31 := JTF_NUMBER_TABLE();
1040: a32 := JTF_VARCHAR2_TABLE_100();
1041: else
1042: a0 := JTF_NUMBER_TABLE();
1043: a1 := JTF_DATE_TABLE();
1038: a30 := JTF_VARCHAR2_TABLE_100();
1039: a31 := JTF_NUMBER_TABLE();
1040: a32 := JTF_VARCHAR2_TABLE_100();
1041: else
1042: a0 := JTF_NUMBER_TABLE();
1043: a1 := JTF_DATE_TABLE();
1044: a2 := JTF_NUMBER_TABLE();
1045: a3 := JTF_DATE_TABLE();
1046: a4 := JTF_NUMBER_TABLE();
1040: a32 := JTF_VARCHAR2_TABLE_100();
1041: else
1042: a0 := JTF_NUMBER_TABLE();
1043: a1 := JTF_DATE_TABLE();
1044: a2 := JTF_NUMBER_TABLE();
1045: a3 := JTF_DATE_TABLE();
1046: a4 := JTF_NUMBER_TABLE();
1047: a5 := JTF_NUMBER_TABLE();
1048: a6 := JTF_NUMBER_TABLE();
1042: a0 := JTF_NUMBER_TABLE();
1043: a1 := JTF_DATE_TABLE();
1044: a2 := JTF_NUMBER_TABLE();
1045: a3 := JTF_DATE_TABLE();
1046: a4 := JTF_NUMBER_TABLE();
1047: a5 := JTF_NUMBER_TABLE();
1048: a6 := JTF_NUMBER_TABLE();
1049: a7 := JTF_VARCHAR2_TABLE_100();
1050: a8 := JTF_VARCHAR2_TABLE_100();
1043: a1 := JTF_DATE_TABLE();
1044: a2 := JTF_NUMBER_TABLE();
1045: a3 := JTF_DATE_TABLE();
1046: a4 := JTF_NUMBER_TABLE();
1047: a5 := JTF_NUMBER_TABLE();
1048: a6 := JTF_NUMBER_TABLE();
1049: a7 := JTF_VARCHAR2_TABLE_100();
1050: a8 := JTF_VARCHAR2_TABLE_100();
1051: a9 := JTF_VARCHAR2_TABLE_300();
1044: a2 := JTF_NUMBER_TABLE();
1045: a3 := JTF_DATE_TABLE();
1046: a4 := JTF_NUMBER_TABLE();
1047: a5 := JTF_NUMBER_TABLE();
1048: a6 := JTF_NUMBER_TABLE();
1049: a7 := JTF_VARCHAR2_TABLE_100();
1050: a8 := JTF_VARCHAR2_TABLE_100();
1051: a9 := JTF_VARCHAR2_TABLE_300();
1052: a10 := JTF_DATE_TABLE();
1050: a8 := JTF_VARCHAR2_TABLE_100();
1051: a9 := JTF_VARCHAR2_TABLE_300();
1052: a10 := JTF_DATE_TABLE();
1053: a11 := JTF_DATE_TABLE();
1054: a12 := JTF_NUMBER_TABLE();
1055: a13 := JTF_NUMBER_TABLE();
1056: a14 := JTF_VARCHAR2_TABLE_100();
1057: a15 := JTF_VARCHAR2_TABLE_300();
1058: a16 := JTF_VARCHAR2_TABLE_300();
1051: a9 := JTF_VARCHAR2_TABLE_300();
1052: a10 := JTF_DATE_TABLE();
1053: a11 := JTF_DATE_TABLE();
1054: a12 := JTF_NUMBER_TABLE();
1055: a13 := JTF_NUMBER_TABLE();
1056: a14 := JTF_VARCHAR2_TABLE_100();
1057: a15 := JTF_VARCHAR2_TABLE_300();
1058: a16 := JTF_VARCHAR2_TABLE_300();
1059: a17 := JTF_VARCHAR2_TABLE_300();
1069: a27 := JTF_VARCHAR2_TABLE_300();
1070: a28 := JTF_VARCHAR2_TABLE_300();
1071: a29 := JTF_VARCHAR2_TABLE_300();
1072: a30 := JTF_VARCHAR2_TABLE_100();
1073: a31 := JTF_NUMBER_TABLE();
1074: a32 := JTF_VARCHAR2_TABLE_100();
1075: if t.count > 0 then
1076: a0.extend(t.count);
1077: a1.extend(t.count);
1151: end if;
1152: end if;
1153: end rosetta_table_copy_out_p12;
1154:
1155: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1156: , a1 JTF_NUMBER_TABLE
1157: , a2 JTF_NUMBER_TABLE
1158: , a3 JTF_VARCHAR2_TABLE_100
1159: ) as
1152: end if;
1153: end rosetta_table_copy_out_p12;
1154:
1155: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1156: , a1 JTF_NUMBER_TABLE
1157: , a2 JTF_NUMBER_TABLE
1158: , a3 JTF_VARCHAR2_TABLE_100
1159: ) as
1160: ddindx binary_integer; indx binary_integer;
1153: end rosetta_table_copy_out_p12;
1154:
1155: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1156: , a1 JTF_NUMBER_TABLE
1157: , a2 JTF_NUMBER_TABLE
1158: , a3 JTF_VARCHAR2_TABLE_100
1159: ) as
1160: ddindx binary_integer; indx binary_integer;
1161: begin
1176: end loop;
1177: end if;
1178: end if;
1179: end rosetta_table_copy_in_p14;
1180: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1181: , a1 out nocopy JTF_NUMBER_TABLE
1182: , a2 out nocopy JTF_NUMBER_TABLE
1183: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1184: ) as
1177: end if;
1178: end if;
1179: end rosetta_table_copy_in_p14;
1180: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1181: , a1 out nocopy JTF_NUMBER_TABLE
1182: , a2 out nocopy JTF_NUMBER_TABLE
1183: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1184: ) as
1185: ddindx binary_integer; indx binary_integer;
1178: end if;
1179: end rosetta_table_copy_in_p14;
1180: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1181: , a1 out nocopy JTF_NUMBER_TABLE
1182: , a2 out nocopy JTF_NUMBER_TABLE
1183: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1184: ) as
1185: ddindx binary_integer; indx binary_integer;
1186: begin
1184: ) as
1185: ddindx binary_integer; indx binary_integer;
1186: begin
1187: if t is null or t.count = 0 then
1188: a0 := JTF_NUMBER_TABLE();
1189: a1 := JTF_NUMBER_TABLE();
1190: a2 := JTF_NUMBER_TABLE();
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1185: ddindx binary_integer; indx binary_integer;
1186: begin
1187: if t is null or t.count = 0 then
1188: a0 := JTF_NUMBER_TABLE();
1189: a1 := JTF_NUMBER_TABLE();
1190: a2 := JTF_NUMBER_TABLE();
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1186: begin
1187: if t is null or t.count = 0 then
1188: a0 := JTF_NUMBER_TABLE();
1189: a1 := JTF_NUMBER_TABLE();
1190: a2 := JTF_NUMBER_TABLE();
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: a1 := JTF_NUMBER_TABLE();
1189: a1 := JTF_NUMBER_TABLE();
1190: a2 := JTF_NUMBER_TABLE();
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: a1 := JTF_NUMBER_TABLE();
1195: a2 := JTF_NUMBER_TABLE();
1196: a3 := JTF_VARCHAR2_TABLE_100();
1197: if t.count > 0 then
1190: a2 := JTF_NUMBER_TABLE();
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: a1 := JTF_NUMBER_TABLE();
1195: a2 := JTF_NUMBER_TABLE();
1196: a3 := JTF_VARCHAR2_TABLE_100();
1197: if t.count > 0 then
1198: a0.extend(t.count);
1191: a3 := JTF_VARCHAR2_TABLE_100();
1192: else
1193: a0 := JTF_NUMBER_TABLE();
1194: a1 := JTF_NUMBER_TABLE();
1195: a2 := JTF_NUMBER_TABLE();
1196: a3 := JTF_VARCHAR2_TABLE_100();
1197: if t.count > 0 then
1198: a0.extend(t.count);
1199: a1.extend(t.count);
1217: end rosetta_table_copy_out_p14;
1218:
1219: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1220: , a1 JTF_VARCHAR2_TABLE_100
1221: , a2 JTF_NUMBER_TABLE
1222: , a3 JTF_NUMBER_TABLE
1223: , a4 JTF_VARCHAR2_TABLE_100
1224: , a5 JTF_NUMBER_TABLE
1225: , a6 JTF_DATE_TABLE
1218:
1219: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1220: , a1 JTF_VARCHAR2_TABLE_100
1221: , a2 JTF_NUMBER_TABLE
1222: , a3 JTF_NUMBER_TABLE
1223: , a4 JTF_VARCHAR2_TABLE_100
1224: , a5 JTF_NUMBER_TABLE
1225: , a6 JTF_DATE_TABLE
1226: , a7 JTF_DATE_TABLE
1220: , a1 JTF_VARCHAR2_TABLE_100
1221: , a2 JTF_NUMBER_TABLE
1222: , a3 JTF_NUMBER_TABLE
1223: , a4 JTF_VARCHAR2_TABLE_100
1224: , a5 JTF_NUMBER_TABLE
1225: , a6 JTF_DATE_TABLE
1226: , a7 JTF_DATE_TABLE
1227: , a8 JTF_VARCHAR2_TABLE_100
1228: , a9 JTF_VARCHAR2_TABLE_100
1225: , a6 JTF_DATE_TABLE
1226: , a7 JTF_DATE_TABLE
1227: , a8 JTF_VARCHAR2_TABLE_100
1228: , a9 JTF_VARCHAR2_TABLE_100
1229: , a10 JTF_NUMBER_TABLE
1230: , a11 JTF_VARCHAR2_TABLE_100
1231: , a12 JTF_NUMBER_TABLE
1232: , a13 JTF_NUMBER_TABLE
1233: , a14 JTF_VARCHAR2_TABLE_100
1227: , a8 JTF_VARCHAR2_TABLE_100
1228: , a9 JTF_VARCHAR2_TABLE_100
1229: , a10 JTF_NUMBER_TABLE
1230: , a11 JTF_VARCHAR2_TABLE_100
1231: , a12 JTF_NUMBER_TABLE
1232: , a13 JTF_NUMBER_TABLE
1233: , a14 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1228: , a9 JTF_VARCHAR2_TABLE_100
1229: , a10 JTF_NUMBER_TABLE
1230: , a11 JTF_VARCHAR2_TABLE_100
1231: , a12 JTF_NUMBER_TABLE
1232: , a13 JTF_NUMBER_TABLE
1233: , a14 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1230: , a11 JTF_VARCHAR2_TABLE_100
1231: , a12 JTF_NUMBER_TABLE
1232: , a13 JTF_NUMBER_TABLE
1233: , a14 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1237: , a18 JTF_NUMBER_TABLE
1238: , a19 JTF_NUMBER_TABLE
1232: , a13 JTF_NUMBER_TABLE
1233: , a14 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1237: , a18 JTF_NUMBER_TABLE
1238: , a19 JTF_NUMBER_TABLE
1239: , a20 JTF_NUMBER_TABLE
1240: , a21 JTF_VARCHAR2_TABLE_100
1233: , a14 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1237: , a18 JTF_NUMBER_TABLE
1238: , a19 JTF_NUMBER_TABLE
1239: , a20 JTF_NUMBER_TABLE
1240: , a21 JTF_VARCHAR2_TABLE_100
1241: , a22 JTF_VARCHAR2_TABLE_100
1234: , a15 JTF_NUMBER_TABLE
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1237: , a18 JTF_NUMBER_TABLE
1238: , a19 JTF_NUMBER_TABLE
1239: , a20 JTF_NUMBER_TABLE
1240: , a21 JTF_VARCHAR2_TABLE_100
1241: , a22 JTF_VARCHAR2_TABLE_100
1242: , a23 JTF_VARCHAR2_TABLE_100
1235: , a16 JTF_VARCHAR2_TABLE_100
1236: , a17 JTF_NUMBER_TABLE
1237: , a18 JTF_NUMBER_TABLE
1238: , a19 JTF_NUMBER_TABLE
1239: , a20 JTF_NUMBER_TABLE
1240: , a21 JTF_VARCHAR2_TABLE_100
1241: , a22 JTF_VARCHAR2_TABLE_100
1242: , a23 JTF_VARCHAR2_TABLE_100
1243: , a24 JTF_VARCHAR2_TABLE_300
1241: , a22 JTF_VARCHAR2_TABLE_100
1242: , a23 JTF_VARCHAR2_TABLE_100
1243: , a24 JTF_VARCHAR2_TABLE_300
1244: , a25 JTF_VARCHAR2_TABLE_100
1245: , a26 JTF_NUMBER_TABLE
1246: , a27 JTF_VARCHAR2_TABLE_100
1247: , a28 JTF_VARCHAR2_TABLE_100
1248: , a29 JTF_VARCHAR2_TABLE_300
1249: , a30 JTF_VARCHAR2_TABLE_100
1253: , a34 JTF_VARCHAR2_TABLE_300
1254: , a35 JTF_VARCHAR2_TABLE_100
1255: , a36 JTF_VARCHAR2_TABLE_300
1256: , a37 JTF_VARCHAR2_TABLE_300
1257: , a38 JTF_NUMBER_TABLE
1258: , a39 JTF_VARCHAR2_TABLE_2000
1259: , a40 JTF_VARCHAR2_TABLE_100
1260: , a41 JTF_VARCHAR2_TABLE_300
1261: , a42 JTF_VARCHAR2_TABLE_300
1271: , a52 JTF_VARCHAR2_TABLE_300
1272: , a53 JTF_VARCHAR2_TABLE_300
1273: , a54 JTF_VARCHAR2_TABLE_300
1274: , a55 JTF_VARCHAR2_TABLE_300
1275: , a56 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1272: , a53 JTF_VARCHAR2_TABLE_300
1273: , a54 JTF_VARCHAR2_TABLE_300
1274: , a55 JTF_VARCHAR2_TABLE_300
1275: , a56 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1273: , a54 JTF_VARCHAR2_TABLE_300
1274: , a55 JTF_VARCHAR2_TABLE_300
1275: , a56 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1274: , a55 JTF_VARCHAR2_TABLE_300
1275: , a56 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1275: , a56 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1276: , a57 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1277: , a58 JTF_NUMBER_TABLE
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1278: , a59 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1286: , a67 JTF_NUMBER_TABLE
1279: , a60 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1286: , a67 JTF_NUMBER_TABLE
1287: , a68 JTF_NUMBER_TABLE
1280: , a61 JTF_NUMBER_TABLE
1281: , a62 JTF_NUMBER_TABLE
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1286: , a67 JTF_NUMBER_TABLE
1287: , a68 JTF_NUMBER_TABLE
1288: , a69 JTF_VARCHAR2_TABLE_300
1282: , a63 JTF_NUMBER_TABLE
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1286: , a67 JTF_NUMBER_TABLE
1287: , a68 JTF_NUMBER_TABLE
1288: , a69 JTF_VARCHAR2_TABLE_300
1289: , a70 JTF_VARCHAR2_TABLE_300
1290: ) as
1283: , a64 JTF_NUMBER_TABLE
1284: , a65 JTF_NUMBER_TABLE
1285: , a66 JTF_VARCHAR2_TABLE_100
1286: , a67 JTF_NUMBER_TABLE
1287: , a68 JTF_NUMBER_TABLE
1288: , a69 JTF_VARCHAR2_TABLE_300
1289: , a70 JTF_VARCHAR2_TABLE_300
1290: ) as
1291: ddindx binary_integer; indx binary_integer;
1376: end if;
1377: end rosetta_table_copy_in_p17;
1378: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1380: , a2 out nocopy JTF_NUMBER_TABLE
1381: , a3 out nocopy JTF_NUMBER_TABLE
1382: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1383: , a5 out nocopy JTF_NUMBER_TABLE
1384: , a6 out nocopy JTF_DATE_TABLE
1377: end rosetta_table_copy_in_p17;
1378: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1380: , a2 out nocopy JTF_NUMBER_TABLE
1381: , a3 out nocopy JTF_NUMBER_TABLE
1382: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1383: , a5 out nocopy JTF_NUMBER_TABLE
1384: , a6 out nocopy JTF_DATE_TABLE
1385: , a7 out nocopy JTF_DATE_TABLE
1379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1380: , a2 out nocopy JTF_NUMBER_TABLE
1381: , a3 out nocopy JTF_NUMBER_TABLE
1382: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1383: , a5 out nocopy JTF_NUMBER_TABLE
1384: , a6 out nocopy JTF_DATE_TABLE
1385: , a7 out nocopy JTF_DATE_TABLE
1386: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1387: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1384: , a6 out nocopy JTF_DATE_TABLE
1385: , a7 out nocopy JTF_DATE_TABLE
1386: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1387: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1388: , a10 out nocopy JTF_NUMBER_TABLE
1389: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1390: , a12 out nocopy JTF_NUMBER_TABLE
1391: , a13 out nocopy JTF_NUMBER_TABLE
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1386: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1387: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1388: , a10 out nocopy JTF_NUMBER_TABLE
1389: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1390: , a12 out nocopy JTF_NUMBER_TABLE
1391: , a13 out nocopy JTF_NUMBER_TABLE
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1387: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1388: , a10 out nocopy JTF_NUMBER_TABLE
1389: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1390: , a12 out nocopy JTF_NUMBER_TABLE
1391: , a13 out nocopy JTF_NUMBER_TABLE
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1389: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1390: , a12 out nocopy JTF_NUMBER_TABLE
1391: , a13 out nocopy JTF_NUMBER_TABLE
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1396: , a18 out nocopy JTF_NUMBER_TABLE
1397: , a19 out nocopy JTF_NUMBER_TABLE
1391: , a13 out nocopy JTF_NUMBER_TABLE
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1396: , a18 out nocopy JTF_NUMBER_TABLE
1397: , a19 out nocopy JTF_NUMBER_TABLE
1398: , a20 out nocopy JTF_NUMBER_TABLE
1399: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1392: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1396: , a18 out nocopy JTF_NUMBER_TABLE
1397: , a19 out nocopy JTF_NUMBER_TABLE
1398: , a20 out nocopy JTF_NUMBER_TABLE
1399: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1400: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a15 out nocopy JTF_NUMBER_TABLE
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1396: , a18 out nocopy JTF_NUMBER_TABLE
1397: , a19 out nocopy JTF_NUMBER_TABLE
1398: , a20 out nocopy JTF_NUMBER_TABLE
1399: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1400: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1401: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1394: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a17 out nocopy JTF_NUMBER_TABLE
1396: , a18 out nocopy JTF_NUMBER_TABLE
1397: , a19 out nocopy JTF_NUMBER_TABLE
1398: , a20 out nocopy JTF_NUMBER_TABLE
1399: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1400: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1401: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1402: , a24 out nocopy JTF_VARCHAR2_TABLE_300
1400: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1401: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1402: , a24 out nocopy JTF_VARCHAR2_TABLE_300
1403: , a25 out nocopy JTF_VARCHAR2_TABLE_100
1404: , a26 out nocopy JTF_NUMBER_TABLE
1405: , a27 out nocopy JTF_VARCHAR2_TABLE_100
1406: , a28 out nocopy JTF_VARCHAR2_TABLE_100
1407: , a29 out nocopy JTF_VARCHAR2_TABLE_300
1408: , a30 out nocopy JTF_VARCHAR2_TABLE_100
1412: , a34 out nocopy JTF_VARCHAR2_TABLE_300
1413: , a35 out nocopy JTF_VARCHAR2_TABLE_100
1414: , a36 out nocopy JTF_VARCHAR2_TABLE_300
1415: , a37 out nocopy JTF_VARCHAR2_TABLE_300
1416: , a38 out nocopy JTF_NUMBER_TABLE
1417: , a39 out nocopy JTF_VARCHAR2_TABLE_2000
1418: , a40 out nocopy JTF_VARCHAR2_TABLE_100
1419: , a41 out nocopy JTF_VARCHAR2_TABLE_300
1420: , a42 out nocopy JTF_VARCHAR2_TABLE_300
1430: , a52 out nocopy JTF_VARCHAR2_TABLE_300
1431: , a53 out nocopy JTF_VARCHAR2_TABLE_300
1432: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1433: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1434: , a56 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1431: , a53 out nocopy JTF_VARCHAR2_TABLE_300
1432: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1433: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1434: , a56 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1432: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1433: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1434: , a56 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1433: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1434: , a56 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1434: , a56 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1435: , a57 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1436: , a58 out nocopy JTF_NUMBER_TABLE
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1437: , a59 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445: , a67 out nocopy JTF_NUMBER_TABLE
1438: , a60 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445: , a67 out nocopy JTF_NUMBER_TABLE
1446: , a68 out nocopy JTF_NUMBER_TABLE
1439: , a61 out nocopy JTF_NUMBER_TABLE
1440: , a62 out nocopy JTF_NUMBER_TABLE
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445: , a67 out nocopy JTF_NUMBER_TABLE
1446: , a68 out nocopy JTF_NUMBER_TABLE
1447: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1441: , a63 out nocopy JTF_NUMBER_TABLE
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445: , a67 out nocopy JTF_NUMBER_TABLE
1446: , a68 out nocopy JTF_NUMBER_TABLE
1447: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1448: , a70 out nocopy JTF_VARCHAR2_TABLE_300
1449: ) as
1442: , a64 out nocopy JTF_NUMBER_TABLE
1443: , a65 out nocopy JTF_NUMBER_TABLE
1444: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445: , a67 out nocopy JTF_NUMBER_TABLE
1446: , a68 out nocopy JTF_NUMBER_TABLE
1447: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1448: , a70 out nocopy JTF_VARCHAR2_TABLE_300
1449: ) as
1450: ddindx binary_integer; indx binary_integer;
1451: begin
1452: if t is null or t.count = 0 then
1453: a0 := JTF_VARCHAR2_TABLE_100();
1454: a1 := JTF_VARCHAR2_TABLE_100();
1455: a2 := JTF_NUMBER_TABLE();
1456: a3 := JTF_NUMBER_TABLE();
1457: a4 := JTF_VARCHAR2_TABLE_100();
1458: a5 := JTF_NUMBER_TABLE();
1459: a6 := JTF_DATE_TABLE();
1452: if t is null or t.count = 0 then
1453: a0 := JTF_VARCHAR2_TABLE_100();
1454: a1 := JTF_VARCHAR2_TABLE_100();
1455: a2 := JTF_NUMBER_TABLE();
1456: a3 := JTF_NUMBER_TABLE();
1457: a4 := JTF_VARCHAR2_TABLE_100();
1458: a5 := JTF_NUMBER_TABLE();
1459: a6 := JTF_DATE_TABLE();
1460: a7 := JTF_DATE_TABLE();
1454: a1 := JTF_VARCHAR2_TABLE_100();
1455: a2 := JTF_NUMBER_TABLE();
1456: a3 := JTF_NUMBER_TABLE();
1457: a4 := JTF_VARCHAR2_TABLE_100();
1458: a5 := JTF_NUMBER_TABLE();
1459: a6 := JTF_DATE_TABLE();
1460: a7 := JTF_DATE_TABLE();
1461: a8 := JTF_VARCHAR2_TABLE_100();
1462: a9 := JTF_VARCHAR2_TABLE_100();
1459: a6 := JTF_DATE_TABLE();
1460: a7 := JTF_DATE_TABLE();
1461: a8 := JTF_VARCHAR2_TABLE_100();
1462: a9 := JTF_VARCHAR2_TABLE_100();
1463: a10 := JTF_NUMBER_TABLE();
1464: a11 := JTF_VARCHAR2_TABLE_100();
1465: a12 := JTF_NUMBER_TABLE();
1466: a13 := JTF_NUMBER_TABLE();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1461: a8 := JTF_VARCHAR2_TABLE_100();
1462: a9 := JTF_VARCHAR2_TABLE_100();
1463: a10 := JTF_NUMBER_TABLE();
1464: a11 := JTF_VARCHAR2_TABLE_100();
1465: a12 := JTF_NUMBER_TABLE();
1466: a13 := JTF_NUMBER_TABLE();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1462: a9 := JTF_VARCHAR2_TABLE_100();
1463: a10 := JTF_NUMBER_TABLE();
1464: a11 := JTF_VARCHAR2_TABLE_100();
1465: a12 := JTF_NUMBER_TABLE();
1466: a13 := JTF_NUMBER_TABLE();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1464: a11 := JTF_VARCHAR2_TABLE_100();
1465: a12 := JTF_NUMBER_TABLE();
1466: a13 := JTF_NUMBER_TABLE();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1471: a18 := JTF_NUMBER_TABLE();
1472: a19 := JTF_NUMBER_TABLE();
1466: a13 := JTF_NUMBER_TABLE();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1471: a18 := JTF_NUMBER_TABLE();
1472: a19 := JTF_NUMBER_TABLE();
1473: a20 := JTF_NUMBER_TABLE();
1474: a21 := JTF_VARCHAR2_TABLE_100();
1467: a14 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1471: a18 := JTF_NUMBER_TABLE();
1472: a19 := JTF_NUMBER_TABLE();
1473: a20 := JTF_NUMBER_TABLE();
1474: a21 := JTF_VARCHAR2_TABLE_100();
1475: a22 := JTF_VARCHAR2_TABLE_100();
1468: a15 := JTF_NUMBER_TABLE();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1471: a18 := JTF_NUMBER_TABLE();
1472: a19 := JTF_NUMBER_TABLE();
1473: a20 := JTF_NUMBER_TABLE();
1474: a21 := JTF_VARCHAR2_TABLE_100();
1475: a22 := JTF_VARCHAR2_TABLE_100();
1476: a23 := JTF_VARCHAR2_TABLE_100();
1469: a16 := JTF_VARCHAR2_TABLE_100();
1470: a17 := JTF_NUMBER_TABLE();
1471: a18 := JTF_NUMBER_TABLE();
1472: a19 := JTF_NUMBER_TABLE();
1473: a20 := JTF_NUMBER_TABLE();
1474: a21 := JTF_VARCHAR2_TABLE_100();
1475: a22 := JTF_VARCHAR2_TABLE_100();
1476: a23 := JTF_VARCHAR2_TABLE_100();
1477: a24 := JTF_VARCHAR2_TABLE_300();
1475: a22 := JTF_VARCHAR2_TABLE_100();
1476: a23 := JTF_VARCHAR2_TABLE_100();
1477: a24 := JTF_VARCHAR2_TABLE_300();
1478: a25 := JTF_VARCHAR2_TABLE_100();
1479: a26 := JTF_NUMBER_TABLE();
1480: a27 := JTF_VARCHAR2_TABLE_100();
1481: a28 := JTF_VARCHAR2_TABLE_100();
1482: a29 := JTF_VARCHAR2_TABLE_300();
1483: a30 := JTF_VARCHAR2_TABLE_100();
1487: a34 := JTF_VARCHAR2_TABLE_300();
1488: a35 := JTF_VARCHAR2_TABLE_100();
1489: a36 := JTF_VARCHAR2_TABLE_300();
1490: a37 := JTF_VARCHAR2_TABLE_300();
1491: a38 := JTF_NUMBER_TABLE();
1492: a39 := JTF_VARCHAR2_TABLE_2000();
1493: a40 := JTF_VARCHAR2_TABLE_100();
1494: a41 := JTF_VARCHAR2_TABLE_300();
1495: a42 := JTF_VARCHAR2_TABLE_300();
1505: a52 := JTF_VARCHAR2_TABLE_300();
1506: a53 := JTF_VARCHAR2_TABLE_300();
1507: a54 := JTF_VARCHAR2_TABLE_300();
1508: a55 := JTF_VARCHAR2_TABLE_300();
1509: a56 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1506: a53 := JTF_VARCHAR2_TABLE_300();
1507: a54 := JTF_VARCHAR2_TABLE_300();
1508: a55 := JTF_VARCHAR2_TABLE_300();
1509: a56 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1507: a54 := JTF_VARCHAR2_TABLE_300();
1508: a55 := JTF_VARCHAR2_TABLE_300();
1509: a56 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1508: a55 := JTF_VARCHAR2_TABLE_300();
1509: a56 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1509: a56 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1510: a57 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1511: a58 := JTF_NUMBER_TABLE();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1512: a59 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1520: a67 := JTF_NUMBER_TABLE();
1513: a60 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1520: a67 := JTF_NUMBER_TABLE();
1521: a68 := JTF_NUMBER_TABLE();
1514: a61 := JTF_NUMBER_TABLE();
1515: a62 := JTF_NUMBER_TABLE();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1520: a67 := JTF_NUMBER_TABLE();
1521: a68 := JTF_NUMBER_TABLE();
1522: a69 := JTF_VARCHAR2_TABLE_300();
1516: a63 := JTF_NUMBER_TABLE();
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1520: a67 := JTF_NUMBER_TABLE();
1521: a68 := JTF_NUMBER_TABLE();
1522: a69 := JTF_VARCHAR2_TABLE_300();
1523: a70 := JTF_VARCHAR2_TABLE_300();
1524: else
1517: a64 := JTF_NUMBER_TABLE();
1518: a65 := JTF_NUMBER_TABLE();
1519: a66 := JTF_VARCHAR2_TABLE_100();
1520: a67 := JTF_NUMBER_TABLE();
1521: a68 := JTF_NUMBER_TABLE();
1522: a69 := JTF_VARCHAR2_TABLE_300();
1523: a70 := JTF_VARCHAR2_TABLE_300();
1524: else
1525: a0 := JTF_VARCHAR2_TABLE_100();
1523: a70 := JTF_VARCHAR2_TABLE_300();
1524: else
1525: a0 := JTF_VARCHAR2_TABLE_100();
1526: a1 := JTF_VARCHAR2_TABLE_100();
1527: a2 := JTF_NUMBER_TABLE();
1528: a3 := JTF_NUMBER_TABLE();
1529: a4 := JTF_VARCHAR2_TABLE_100();
1530: a5 := JTF_NUMBER_TABLE();
1531: a6 := JTF_DATE_TABLE();
1524: else
1525: a0 := JTF_VARCHAR2_TABLE_100();
1526: a1 := JTF_VARCHAR2_TABLE_100();
1527: a2 := JTF_NUMBER_TABLE();
1528: a3 := JTF_NUMBER_TABLE();
1529: a4 := JTF_VARCHAR2_TABLE_100();
1530: a5 := JTF_NUMBER_TABLE();
1531: a6 := JTF_DATE_TABLE();
1532: a7 := JTF_DATE_TABLE();
1526: a1 := JTF_VARCHAR2_TABLE_100();
1527: a2 := JTF_NUMBER_TABLE();
1528: a3 := JTF_NUMBER_TABLE();
1529: a4 := JTF_VARCHAR2_TABLE_100();
1530: a5 := JTF_NUMBER_TABLE();
1531: a6 := JTF_DATE_TABLE();
1532: a7 := JTF_DATE_TABLE();
1533: a8 := JTF_VARCHAR2_TABLE_100();
1534: a9 := JTF_VARCHAR2_TABLE_100();
1531: a6 := JTF_DATE_TABLE();
1532: a7 := JTF_DATE_TABLE();
1533: a8 := JTF_VARCHAR2_TABLE_100();
1534: a9 := JTF_VARCHAR2_TABLE_100();
1535: a10 := JTF_NUMBER_TABLE();
1536: a11 := JTF_VARCHAR2_TABLE_100();
1537: a12 := JTF_NUMBER_TABLE();
1538: a13 := JTF_NUMBER_TABLE();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1533: a8 := JTF_VARCHAR2_TABLE_100();
1534: a9 := JTF_VARCHAR2_TABLE_100();
1535: a10 := JTF_NUMBER_TABLE();
1536: a11 := JTF_VARCHAR2_TABLE_100();
1537: a12 := JTF_NUMBER_TABLE();
1538: a13 := JTF_NUMBER_TABLE();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1534: a9 := JTF_VARCHAR2_TABLE_100();
1535: a10 := JTF_NUMBER_TABLE();
1536: a11 := JTF_VARCHAR2_TABLE_100();
1537: a12 := JTF_NUMBER_TABLE();
1538: a13 := JTF_NUMBER_TABLE();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1536: a11 := JTF_VARCHAR2_TABLE_100();
1537: a12 := JTF_NUMBER_TABLE();
1538: a13 := JTF_NUMBER_TABLE();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1543: a18 := JTF_NUMBER_TABLE();
1544: a19 := JTF_NUMBER_TABLE();
1538: a13 := JTF_NUMBER_TABLE();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1543: a18 := JTF_NUMBER_TABLE();
1544: a19 := JTF_NUMBER_TABLE();
1545: a20 := JTF_NUMBER_TABLE();
1546: a21 := JTF_VARCHAR2_TABLE_100();
1539: a14 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1543: a18 := JTF_NUMBER_TABLE();
1544: a19 := JTF_NUMBER_TABLE();
1545: a20 := JTF_NUMBER_TABLE();
1546: a21 := JTF_VARCHAR2_TABLE_100();
1547: a22 := JTF_VARCHAR2_TABLE_100();
1540: a15 := JTF_NUMBER_TABLE();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1543: a18 := JTF_NUMBER_TABLE();
1544: a19 := JTF_NUMBER_TABLE();
1545: a20 := JTF_NUMBER_TABLE();
1546: a21 := JTF_VARCHAR2_TABLE_100();
1547: a22 := JTF_VARCHAR2_TABLE_100();
1548: a23 := JTF_VARCHAR2_TABLE_100();
1541: a16 := JTF_VARCHAR2_TABLE_100();
1542: a17 := JTF_NUMBER_TABLE();
1543: a18 := JTF_NUMBER_TABLE();
1544: a19 := JTF_NUMBER_TABLE();
1545: a20 := JTF_NUMBER_TABLE();
1546: a21 := JTF_VARCHAR2_TABLE_100();
1547: a22 := JTF_VARCHAR2_TABLE_100();
1548: a23 := JTF_VARCHAR2_TABLE_100();
1549: a24 := JTF_VARCHAR2_TABLE_300();
1547: a22 := JTF_VARCHAR2_TABLE_100();
1548: a23 := JTF_VARCHAR2_TABLE_100();
1549: a24 := JTF_VARCHAR2_TABLE_300();
1550: a25 := JTF_VARCHAR2_TABLE_100();
1551: a26 := JTF_NUMBER_TABLE();
1552: a27 := JTF_VARCHAR2_TABLE_100();
1553: a28 := JTF_VARCHAR2_TABLE_100();
1554: a29 := JTF_VARCHAR2_TABLE_300();
1555: a30 := JTF_VARCHAR2_TABLE_100();
1559: a34 := JTF_VARCHAR2_TABLE_300();
1560: a35 := JTF_VARCHAR2_TABLE_100();
1561: a36 := JTF_VARCHAR2_TABLE_300();
1562: a37 := JTF_VARCHAR2_TABLE_300();
1563: a38 := JTF_NUMBER_TABLE();
1564: a39 := JTF_VARCHAR2_TABLE_2000();
1565: a40 := JTF_VARCHAR2_TABLE_100();
1566: a41 := JTF_VARCHAR2_TABLE_300();
1567: a42 := JTF_VARCHAR2_TABLE_300();
1577: a52 := JTF_VARCHAR2_TABLE_300();
1578: a53 := JTF_VARCHAR2_TABLE_300();
1579: a54 := JTF_VARCHAR2_TABLE_300();
1580: a55 := JTF_VARCHAR2_TABLE_300();
1581: a56 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1578: a53 := JTF_VARCHAR2_TABLE_300();
1579: a54 := JTF_VARCHAR2_TABLE_300();
1580: a55 := JTF_VARCHAR2_TABLE_300();
1581: a56 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1579: a54 := JTF_VARCHAR2_TABLE_300();
1580: a55 := JTF_VARCHAR2_TABLE_300();
1581: a56 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1580: a55 := JTF_VARCHAR2_TABLE_300();
1581: a56 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1581: a56 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1582: a57 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1583: a58 := JTF_NUMBER_TABLE();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1584: a59 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1592: a67 := JTF_NUMBER_TABLE();
1585: a60 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1592: a67 := JTF_NUMBER_TABLE();
1593: a68 := JTF_NUMBER_TABLE();
1586: a61 := JTF_NUMBER_TABLE();
1587: a62 := JTF_NUMBER_TABLE();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1592: a67 := JTF_NUMBER_TABLE();
1593: a68 := JTF_NUMBER_TABLE();
1594: a69 := JTF_VARCHAR2_TABLE_300();
1588: a63 := JTF_NUMBER_TABLE();
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1592: a67 := JTF_NUMBER_TABLE();
1593: a68 := JTF_NUMBER_TABLE();
1594: a69 := JTF_VARCHAR2_TABLE_300();
1595: a70 := JTF_VARCHAR2_TABLE_300();
1596: if t.count > 0 then
1589: a64 := JTF_NUMBER_TABLE();
1590: a65 := JTF_NUMBER_TABLE();
1591: a66 := JTF_VARCHAR2_TABLE_100();
1592: a67 := JTF_NUMBER_TABLE();
1593: a68 := JTF_NUMBER_TABLE();
1594: a69 := JTF_VARCHAR2_TABLE_300();
1595: a70 := JTF_VARCHAR2_TABLE_300();
1596: if t.count > 0 then
1597: a0.extend(t.count);
1753: , a1 JTF_VARCHAR2_TABLE_100
1754: , a2 JTF_VARCHAR2_TABLE_300
1755: , a3 JTF_VARCHAR2_TABLE_300
1756: , a4 JTF_VARCHAR2_TABLE_100
1757: , a5 JTF_NUMBER_TABLE
1758: , a6 JTF_NUMBER_TABLE
1759: , a7 JTF_NUMBER_TABLE
1760: , a8 JTF_NUMBER_TABLE
1761: , a9 JTF_DATE_TABLE
1754: , a2 JTF_VARCHAR2_TABLE_300
1755: , a3 JTF_VARCHAR2_TABLE_300
1756: , a4 JTF_VARCHAR2_TABLE_100
1757: , a5 JTF_NUMBER_TABLE
1758: , a6 JTF_NUMBER_TABLE
1759: , a7 JTF_NUMBER_TABLE
1760: , a8 JTF_NUMBER_TABLE
1761: , a9 JTF_DATE_TABLE
1762: , a10 JTF_DATE_TABLE
1755: , a3 JTF_VARCHAR2_TABLE_300
1756: , a4 JTF_VARCHAR2_TABLE_100
1757: , a5 JTF_NUMBER_TABLE
1758: , a6 JTF_NUMBER_TABLE
1759: , a7 JTF_NUMBER_TABLE
1760: , a8 JTF_NUMBER_TABLE
1761: , a9 JTF_DATE_TABLE
1762: , a10 JTF_DATE_TABLE
1763: , a11 JTF_NUMBER_TABLE
1756: , a4 JTF_VARCHAR2_TABLE_100
1757: , a5 JTF_NUMBER_TABLE
1758: , a6 JTF_NUMBER_TABLE
1759: , a7 JTF_NUMBER_TABLE
1760: , a8 JTF_NUMBER_TABLE
1761: , a9 JTF_DATE_TABLE
1762: , a10 JTF_DATE_TABLE
1763: , a11 JTF_NUMBER_TABLE
1764: , a12 JTF_VARCHAR2_TABLE_100
1759: , a7 JTF_NUMBER_TABLE
1760: , a8 JTF_NUMBER_TABLE
1761: , a9 JTF_DATE_TABLE
1762: , a10 JTF_DATE_TABLE
1763: , a11 JTF_NUMBER_TABLE
1764: , a12 JTF_VARCHAR2_TABLE_100
1765: , a13 JTF_VARCHAR2_TABLE_100
1766: , a14 JTF_VARCHAR2_TABLE_300
1767: , a15 JTF_VARCHAR2_TABLE_300
1828: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1829: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1830: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1832: , a5 out nocopy JTF_NUMBER_TABLE
1833: , a6 out nocopy JTF_NUMBER_TABLE
1834: , a7 out nocopy JTF_NUMBER_TABLE
1835: , a8 out nocopy JTF_NUMBER_TABLE
1836: , a9 out nocopy JTF_DATE_TABLE
1829: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1830: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1832: , a5 out nocopy JTF_NUMBER_TABLE
1833: , a6 out nocopy JTF_NUMBER_TABLE
1834: , a7 out nocopy JTF_NUMBER_TABLE
1835: , a8 out nocopy JTF_NUMBER_TABLE
1836: , a9 out nocopy JTF_DATE_TABLE
1837: , a10 out nocopy JTF_DATE_TABLE
1830: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1832: , a5 out nocopy JTF_NUMBER_TABLE
1833: , a6 out nocopy JTF_NUMBER_TABLE
1834: , a7 out nocopy JTF_NUMBER_TABLE
1835: , a8 out nocopy JTF_NUMBER_TABLE
1836: , a9 out nocopy JTF_DATE_TABLE
1837: , a10 out nocopy JTF_DATE_TABLE
1838: , a11 out nocopy JTF_NUMBER_TABLE
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1832: , a5 out nocopy JTF_NUMBER_TABLE
1833: , a6 out nocopy JTF_NUMBER_TABLE
1834: , a7 out nocopy JTF_NUMBER_TABLE
1835: , a8 out nocopy JTF_NUMBER_TABLE
1836: , a9 out nocopy JTF_DATE_TABLE
1837: , a10 out nocopy JTF_DATE_TABLE
1838: , a11 out nocopy JTF_NUMBER_TABLE
1839: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1834: , a7 out nocopy JTF_NUMBER_TABLE
1835: , a8 out nocopy JTF_NUMBER_TABLE
1836: , a9 out nocopy JTF_DATE_TABLE
1837: , a10 out nocopy JTF_DATE_TABLE
1838: , a11 out nocopy JTF_NUMBER_TABLE
1839: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1840: , a13 out nocopy JTF_VARCHAR2_TABLE_100
1841: , a14 out nocopy JTF_VARCHAR2_TABLE_300
1842: , a15 out nocopy JTF_VARCHAR2_TABLE_300
1861: a1 := JTF_VARCHAR2_TABLE_100();
1862: a2 := JTF_VARCHAR2_TABLE_300();
1863: a3 := JTF_VARCHAR2_TABLE_300();
1864: a4 := JTF_VARCHAR2_TABLE_100();
1865: a5 := JTF_NUMBER_TABLE();
1866: a6 := JTF_NUMBER_TABLE();
1867: a7 := JTF_NUMBER_TABLE();
1868: a8 := JTF_NUMBER_TABLE();
1869: a9 := JTF_DATE_TABLE();
1862: a2 := JTF_VARCHAR2_TABLE_300();
1863: a3 := JTF_VARCHAR2_TABLE_300();
1864: a4 := JTF_VARCHAR2_TABLE_100();
1865: a5 := JTF_NUMBER_TABLE();
1866: a6 := JTF_NUMBER_TABLE();
1867: a7 := JTF_NUMBER_TABLE();
1868: a8 := JTF_NUMBER_TABLE();
1869: a9 := JTF_DATE_TABLE();
1870: a10 := JTF_DATE_TABLE();
1863: a3 := JTF_VARCHAR2_TABLE_300();
1864: a4 := JTF_VARCHAR2_TABLE_100();
1865: a5 := JTF_NUMBER_TABLE();
1866: a6 := JTF_NUMBER_TABLE();
1867: a7 := JTF_NUMBER_TABLE();
1868: a8 := JTF_NUMBER_TABLE();
1869: a9 := JTF_DATE_TABLE();
1870: a10 := JTF_DATE_TABLE();
1871: a11 := JTF_NUMBER_TABLE();
1864: a4 := JTF_VARCHAR2_TABLE_100();
1865: a5 := JTF_NUMBER_TABLE();
1866: a6 := JTF_NUMBER_TABLE();
1867: a7 := JTF_NUMBER_TABLE();
1868: a8 := JTF_NUMBER_TABLE();
1869: a9 := JTF_DATE_TABLE();
1870: a10 := JTF_DATE_TABLE();
1871: a11 := JTF_NUMBER_TABLE();
1872: a12 := JTF_VARCHAR2_TABLE_100();
1867: a7 := JTF_NUMBER_TABLE();
1868: a8 := JTF_NUMBER_TABLE();
1869: a9 := JTF_DATE_TABLE();
1870: a10 := JTF_DATE_TABLE();
1871: a11 := JTF_NUMBER_TABLE();
1872: a12 := JTF_VARCHAR2_TABLE_100();
1873: a13 := JTF_VARCHAR2_TABLE_100();
1874: a14 := JTF_VARCHAR2_TABLE_300();
1875: a15 := JTF_VARCHAR2_TABLE_300();
1891: a1 := JTF_VARCHAR2_TABLE_100();
1892: a2 := JTF_VARCHAR2_TABLE_300();
1893: a3 := JTF_VARCHAR2_TABLE_300();
1894: a4 := JTF_VARCHAR2_TABLE_100();
1895: a5 := JTF_NUMBER_TABLE();
1896: a6 := JTF_NUMBER_TABLE();
1897: a7 := JTF_NUMBER_TABLE();
1898: a8 := JTF_NUMBER_TABLE();
1899: a9 := JTF_DATE_TABLE();
1892: a2 := JTF_VARCHAR2_TABLE_300();
1893: a3 := JTF_VARCHAR2_TABLE_300();
1894: a4 := JTF_VARCHAR2_TABLE_100();
1895: a5 := JTF_NUMBER_TABLE();
1896: a6 := JTF_NUMBER_TABLE();
1897: a7 := JTF_NUMBER_TABLE();
1898: a8 := JTF_NUMBER_TABLE();
1899: a9 := JTF_DATE_TABLE();
1900: a10 := JTF_DATE_TABLE();
1893: a3 := JTF_VARCHAR2_TABLE_300();
1894: a4 := JTF_VARCHAR2_TABLE_100();
1895: a5 := JTF_NUMBER_TABLE();
1896: a6 := JTF_NUMBER_TABLE();
1897: a7 := JTF_NUMBER_TABLE();
1898: a8 := JTF_NUMBER_TABLE();
1899: a9 := JTF_DATE_TABLE();
1900: a10 := JTF_DATE_TABLE();
1901: a11 := JTF_NUMBER_TABLE();
1894: a4 := JTF_VARCHAR2_TABLE_100();
1895: a5 := JTF_NUMBER_TABLE();
1896: a6 := JTF_NUMBER_TABLE();
1897: a7 := JTF_NUMBER_TABLE();
1898: a8 := JTF_NUMBER_TABLE();
1899: a9 := JTF_DATE_TABLE();
1900: a10 := JTF_DATE_TABLE();
1901: a11 := JTF_NUMBER_TABLE();
1902: a12 := JTF_VARCHAR2_TABLE_100();
1897: a7 := JTF_NUMBER_TABLE();
1898: a8 := JTF_NUMBER_TABLE();
1899: a9 := JTF_DATE_TABLE();
1900: a10 := JTF_DATE_TABLE();
1901: a11 := JTF_NUMBER_TABLE();
1902: a12 := JTF_VARCHAR2_TABLE_100();
1903: a13 := JTF_VARCHAR2_TABLE_100();
1904: a14 := JTF_VARCHAR2_TABLE_300();
1905: a15 := JTF_VARCHAR2_TABLE_300();
1987: end if;
1988: end if;
1989: end rosetta_table_copy_out_p19;
1990:
1991: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992: , a1 JTF_NUMBER_TABLE
1993: , a2 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100
1988: end if;
1989: end rosetta_table_copy_out_p19;
1990:
1991: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992: , a1 JTF_NUMBER_TABLE
1993: , a2 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100
1996: , a5 JTF_VARCHAR2_TABLE_100
1989: end rosetta_table_copy_out_p19;
1990:
1991: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992: , a1 JTF_NUMBER_TABLE
1993: , a2 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100
1996: , a5 JTF_VARCHAR2_TABLE_100
1997: , a6 JTF_VARCHAR2_TABLE_100
1990:
1991: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992: , a1 JTF_NUMBER_TABLE
1993: , a2 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100
1996: , a5 JTF_VARCHAR2_TABLE_100
1997: , a6 JTF_VARCHAR2_TABLE_100
1998: , a7 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100
1996: , a5 JTF_VARCHAR2_TABLE_100
1997: , a6 JTF_VARCHAR2_TABLE_100
1998: , a7 JTF_NUMBER_TABLE
1999: , a8 JTF_VARCHAR2_TABLE_100
2000: , a9 JTF_VARCHAR2_TABLE_100
2001: , a10 JTF_VARCHAR2_TABLE_100
2002: , a11 JTF_VARCHAR2_TABLE_100
1999: , a8 JTF_VARCHAR2_TABLE_100
2000: , a9 JTF_VARCHAR2_TABLE_100
2001: , a10 JTF_VARCHAR2_TABLE_100
2002: , a11 JTF_VARCHAR2_TABLE_100
2003: , a12 JTF_NUMBER_TABLE
2004: , a13 JTF_NUMBER_TABLE
2005: , a14 JTF_VARCHAR2_TABLE_100
2006: , a15 JTF_NUMBER_TABLE
2007: , a16 JTF_NUMBER_TABLE
2000: , a9 JTF_VARCHAR2_TABLE_100
2001: , a10 JTF_VARCHAR2_TABLE_100
2002: , a11 JTF_VARCHAR2_TABLE_100
2003: , a12 JTF_NUMBER_TABLE
2004: , a13 JTF_NUMBER_TABLE
2005: , a14 JTF_VARCHAR2_TABLE_100
2006: , a15 JTF_NUMBER_TABLE
2007: , a16 JTF_NUMBER_TABLE
2008: , a17 JTF_VARCHAR2_TABLE_300
2002: , a11 JTF_VARCHAR2_TABLE_100
2003: , a12 JTF_NUMBER_TABLE
2004: , a13 JTF_NUMBER_TABLE
2005: , a14 JTF_VARCHAR2_TABLE_100
2006: , a15 JTF_NUMBER_TABLE
2007: , a16 JTF_NUMBER_TABLE
2008: , a17 JTF_VARCHAR2_TABLE_300
2009: , a18 JTF_VARCHAR2_TABLE_2000
2010: , a19 JTF_VARCHAR2_TABLE_100
2003: , a12 JTF_NUMBER_TABLE
2004: , a13 JTF_NUMBER_TABLE
2005: , a14 JTF_VARCHAR2_TABLE_100
2006: , a15 JTF_NUMBER_TABLE
2007: , a16 JTF_NUMBER_TABLE
2008: , a17 JTF_VARCHAR2_TABLE_300
2009: , a18 JTF_VARCHAR2_TABLE_2000
2010: , a19 JTF_VARCHAR2_TABLE_100
2011: , a20 JTF_NUMBER_TABLE
2007: , a16 JTF_NUMBER_TABLE
2008: , a17 JTF_VARCHAR2_TABLE_300
2009: , a18 JTF_VARCHAR2_TABLE_2000
2010: , a19 JTF_VARCHAR2_TABLE_100
2011: , a20 JTF_NUMBER_TABLE
2012: ) as
2013: ddindx binary_integer; indx binary_integer;
2014: begin
2015: if a0 is not null and a0.count > 0 then
2046: end loop;
2047: end if;
2048: end if;
2049: end rosetta_table_copy_in_p21;
2050: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051: , a1 out nocopy JTF_NUMBER_TABLE
2052: , a2 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2047: end if;
2048: end if;
2049: end rosetta_table_copy_in_p21;
2050: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051: , a1 out nocopy JTF_NUMBER_TABLE
2052: , a2 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2055: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2048: end if;
2049: end rosetta_table_copy_in_p21;
2050: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051: , a1 out nocopy JTF_NUMBER_TABLE
2052: , a2 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2055: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2056: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2049: end rosetta_table_copy_in_p21;
2050: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051: , a1 out nocopy JTF_NUMBER_TABLE
2052: , a2 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2055: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2056: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2057: , a7 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2055: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2056: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2057: , a7 out nocopy JTF_NUMBER_TABLE
2058: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2059: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2060: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2061: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2058: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2059: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2060: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2061: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2062: , a12 out nocopy JTF_NUMBER_TABLE
2063: , a13 out nocopy JTF_NUMBER_TABLE
2064: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2065: , a15 out nocopy JTF_NUMBER_TABLE
2066: , a16 out nocopy JTF_NUMBER_TABLE
2059: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2060: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2061: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2062: , a12 out nocopy JTF_NUMBER_TABLE
2063: , a13 out nocopy JTF_NUMBER_TABLE
2064: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2065: , a15 out nocopy JTF_NUMBER_TABLE
2066: , a16 out nocopy JTF_NUMBER_TABLE
2067: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2061: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2062: , a12 out nocopy JTF_NUMBER_TABLE
2063: , a13 out nocopy JTF_NUMBER_TABLE
2064: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2065: , a15 out nocopy JTF_NUMBER_TABLE
2066: , a16 out nocopy JTF_NUMBER_TABLE
2067: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2068: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2069: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2062: , a12 out nocopy JTF_NUMBER_TABLE
2063: , a13 out nocopy JTF_NUMBER_TABLE
2064: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2065: , a15 out nocopy JTF_NUMBER_TABLE
2066: , a16 out nocopy JTF_NUMBER_TABLE
2067: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2068: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2069: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2070: , a20 out nocopy JTF_NUMBER_TABLE
2066: , a16 out nocopy JTF_NUMBER_TABLE
2067: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2068: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2069: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2070: , a20 out nocopy JTF_NUMBER_TABLE
2071: ) as
2072: ddindx binary_integer; indx binary_integer;
2073: begin
2074: if t is null or t.count = 0 then
2071: ) as
2072: ddindx binary_integer; indx binary_integer;
2073: begin
2074: if t is null or t.count = 0 then
2075: a0 := JTF_NUMBER_TABLE();
2076: a1 := JTF_NUMBER_TABLE();
2077: a2 := JTF_NUMBER_TABLE();
2078: a3 := JTF_NUMBER_TABLE();
2079: a4 := JTF_VARCHAR2_TABLE_100();
2072: ddindx binary_integer; indx binary_integer;
2073: begin
2074: if t is null or t.count = 0 then
2075: a0 := JTF_NUMBER_TABLE();
2076: a1 := JTF_NUMBER_TABLE();
2077: a2 := JTF_NUMBER_TABLE();
2078: a3 := JTF_NUMBER_TABLE();
2079: a4 := JTF_VARCHAR2_TABLE_100();
2080: a5 := JTF_VARCHAR2_TABLE_100();
2073: begin
2074: if t is null or t.count = 0 then
2075: a0 := JTF_NUMBER_TABLE();
2076: a1 := JTF_NUMBER_TABLE();
2077: a2 := JTF_NUMBER_TABLE();
2078: a3 := JTF_NUMBER_TABLE();
2079: a4 := JTF_VARCHAR2_TABLE_100();
2080: a5 := JTF_VARCHAR2_TABLE_100();
2081: a6 := JTF_VARCHAR2_TABLE_100();
2074: if t is null or t.count = 0 then
2075: a0 := JTF_NUMBER_TABLE();
2076: a1 := JTF_NUMBER_TABLE();
2077: a2 := JTF_NUMBER_TABLE();
2078: a3 := JTF_NUMBER_TABLE();
2079: a4 := JTF_VARCHAR2_TABLE_100();
2080: a5 := JTF_VARCHAR2_TABLE_100();
2081: a6 := JTF_VARCHAR2_TABLE_100();
2082: a7 := JTF_NUMBER_TABLE();
2078: a3 := JTF_NUMBER_TABLE();
2079: a4 := JTF_VARCHAR2_TABLE_100();
2080: a5 := JTF_VARCHAR2_TABLE_100();
2081: a6 := JTF_VARCHAR2_TABLE_100();
2082: a7 := JTF_NUMBER_TABLE();
2083: a8 := JTF_VARCHAR2_TABLE_100();
2084: a9 := JTF_VARCHAR2_TABLE_100();
2085: a10 := JTF_VARCHAR2_TABLE_100();
2086: a11 := JTF_VARCHAR2_TABLE_100();
2083: a8 := JTF_VARCHAR2_TABLE_100();
2084: a9 := JTF_VARCHAR2_TABLE_100();
2085: a10 := JTF_VARCHAR2_TABLE_100();
2086: a11 := JTF_VARCHAR2_TABLE_100();
2087: a12 := JTF_NUMBER_TABLE();
2088: a13 := JTF_NUMBER_TABLE();
2089: a14 := JTF_VARCHAR2_TABLE_100();
2090: a15 := JTF_NUMBER_TABLE();
2091: a16 := JTF_NUMBER_TABLE();
2084: a9 := JTF_VARCHAR2_TABLE_100();
2085: a10 := JTF_VARCHAR2_TABLE_100();
2086: a11 := JTF_VARCHAR2_TABLE_100();
2087: a12 := JTF_NUMBER_TABLE();
2088: a13 := JTF_NUMBER_TABLE();
2089: a14 := JTF_VARCHAR2_TABLE_100();
2090: a15 := JTF_NUMBER_TABLE();
2091: a16 := JTF_NUMBER_TABLE();
2092: a17 := JTF_VARCHAR2_TABLE_300();
2086: a11 := JTF_VARCHAR2_TABLE_100();
2087: a12 := JTF_NUMBER_TABLE();
2088: a13 := JTF_NUMBER_TABLE();
2089: a14 := JTF_VARCHAR2_TABLE_100();
2090: a15 := JTF_NUMBER_TABLE();
2091: a16 := JTF_NUMBER_TABLE();
2092: a17 := JTF_VARCHAR2_TABLE_300();
2093: a18 := JTF_VARCHAR2_TABLE_2000();
2094: a19 := JTF_VARCHAR2_TABLE_100();
2087: a12 := JTF_NUMBER_TABLE();
2088: a13 := JTF_NUMBER_TABLE();
2089: a14 := JTF_VARCHAR2_TABLE_100();
2090: a15 := JTF_NUMBER_TABLE();
2091: a16 := JTF_NUMBER_TABLE();
2092: a17 := JTF_VARCHAR2_TABLE_300();
2093: a18 := JTF_VARCHAR2_TABLE_2000();
2094: a19 := JTF_VARCHAR2_TABLE_100();
2095: a20 := JTF_NUMBER_TABLE();
2091: a16 := JTF_NUMBER_TABLE();
2092: a17 := JTF_VARCHAR2_TABLE_300();
2093: a18 := JTF_VARCHAR2_TABLE_2000();
2094: a19 := JTF_VARCHAR2_TABLE_100();
2095: a20 := JTF_NUMBER_TABLE();
2096: else
2097: a0 := JTF_NUMBER_TABLE();
2098: a1 := JTF_NUMBER_TABLE();
2099: a2 := JTF_NUMBER_TABLE();
2093: a18 := JTF_VARCHAR2_TABLE_2000();
2094: a19 := JTF_VARCHAR2_TABLE_100();
2095: a20 := JTF_NUMBER_TABLE();
2096: else
2097: a0 := JTF_NUMBER_TABLE();
2098: a1 := JTF_NUMBER_TABLE();
2099: a2 := JTF_NUMBER_TABLE();
2100: a3 := JTF_NUMBER_TABLE();
2101: a4 := JTF_VARCHAR2_TABLE_100();
2094: a19 := JTF_VARCHAR2_TABLE_100();
2095: a20 := JTF_NUMBER_TABLE();
2096: else
2097: a0 := JTF_NUMBER_TABLE();
2098: a1 := JTF_NUMBER_TABLE();
2099: a2 := JTF_NUMBER_TABLE();
2100: a3 := JTF_NUMBER_TABLE();
2101: a4 := JTF_VARCHAR2_TABLE_100();
2102: a5 := JTF_VARCHAR2_TABLE_100();
2095: a20 := JTF_NUMBER_TABLE();
2096: else
2097: a0 := JTF_NUMBER_TABLE();
2098: a1 := JTF_NUMBER_TABLE();
2099: a2 := JTF_NUMBER_TABLE();
2100: a3 := JTF_NUMBER_TABLE();
2101: a4 := JTF_VARCHAR2_TABLE_100();
2102: a5 := JTF_VARCHAR2_TABLE_100();
2103: a6 := JTF_VARCHAR2_TABLE_100();
2096: else
2097: a0 := JTF_NUMBER_TABLE();
2098: a1 := JTF_NUMBER_TABLE();
2099: a2 := JTF_NUMBER_TABLE();
2100: a3 := JTF_NUMBER_TABLE();
2101: a4 := JTF_VARCHAR2_TABLE_100();
2102: a5 := JTF_VARCHAR2_TABLE_100();
2103: a6 := JTF_VARCHAR2_TABLE_100();
2104: a7 := JTF_NUMBER_TABLE();
2100: a3 := JTF_NUMBER_TABLE();
2101: a4 := JTF_VARCHAR2_TABLE_100();
2102: a5 := JTF_VARCHAR2_TABLE_100();
2103: a6 := JTF_VARCHAR2_TABLE_100();
2104: a7 := JTF_NUMBER_TABLE();
2105: a8 := JTF_VARCHAR2_TABLE_100();
2106: a9 := JTF_VARCHAR2_TABLE_100();
2107: a10 := JTF_VARCHAR2_TABLE_100();
2108: a11 := JTF_VARCHAR2_TABLE_100();
2105: a8 := JTF_VARCHAR2_TABLE_100();
2106: a9 := JTF_VARCHAR2_TABLE_100();
2107: a10 := JTF_VARCHAR2_TABLE_100();
2108: a11 := JTF_VARCHAR2_TABLE_100();
2109: a12 := JTF_NUMBER_TABLE();
2110: a13 := JTF_NUMBER_TABLE();
2111: a14 := JTF_VARCHAR2_TABLE_100();
2112: a15 := JTF_NUMBER_TABLE();
2113: a16 := JTF_NUMBER_TABLE();
2106: a9 := JTF_VARCHAR2_TABLE_100();
2107: a10 := JTF_VARCHAR2_TABLE_100();
2108: a11 := JTF_VARCHAR2_TABLE_100();
2109: a12 := JTF_NUMBER_TABLE();
2110: a13 := JTF_NUMBER_TABLE();
2111: a14 := JTF_VARCHAR2_TABLE_100();
2112: a15 := JTF_NUMBER_TABLE();
2113: a16 := JTF_NUMBER_TABLE();
2114: a17 := JTF_VARCHAR2_TABLE_300();
2108: a11 := JTF_VARCHAR2_TABLE_100();
2109: a12 := JTF_NUMBER_TABLE();
2110: a13 := JTF_NUMBER_TABLE();
2111: a14 := JTF_VARCHAR2_TABLE_100();
2112: a15 := JTF_NUMBER_TABLE();
2113: a16 := JTF_NUMBER_TABLE();
2114: a17 := JTF_VARCHAR2_TABLE_300();
2115: a18 := JTF_VARCHAR2_TABLE_2000();
2116: a19 := JTF_VARCHAR2_TABLE_100();
2109: a12 := JTF_NUMBER_TABLE();
2110: a13 := JTF_NUMBER_TABLE();
2111: a14 := JTF_VARCHAR2_TABLE_100();
2112: a15 := JTF_NUMBER_TABLE();
2113: a16 := JTF_NUMBER_TABLE();
2114: a17 := JTF_VARCHAR2_TABLE_300();
2115: a18 := JTF_VARCHAR2_TABLE_2000();
2116: a19 := JTF_VARCHAR2_TABLE_100();
2117: a20 := JTF_NUMBER_TABLE();
2113: a16 := JTF_NUMBER_TABLE();
2114: a17 := JTF_VARCHAR2_TABLE_300();
2115: a18 := JTF_VARCHAR2_TABLE_2000();
2116: a19 := JTF_VARCHAR2_TABLE_100();
2117: a20 := JTF_NUMBER_TABLE();
2118: if t.count > 0 then
2119: a0.extend(t.count);
2120: a1.extend(t.count);
2121: a2.extend(t.count);
2170: end if;
2171: end if;
2172: end rosetta_table_copy_out_p21;
2173:
2174: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175: , a1 JTF_VARCHAR2_TABLE_100
2176: , a2 JTF_NUMBER_TABLE
2177: , a3 JTF_NUMBER_TABLE
2178: , a4 JTF_NUMBER_TABLE
2172: end rosetta_table_copy_out_p21;
2173:
2174: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175: , a1 JTF_VARCHAR2_TABLE_100
2176: , a2 JTF_NUMBER_TABLE
2177: , a3 JTF_NUMBER_TABLE
2178: , a4 JTF_NUMBER_TABLE
2179: , a5 JTF_VARCHAR2_TABLE_100
2180: , a6 JTF_VARCHAR2_TABLE_100
2173:
2174: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175: , a1 JTF_VARCHAR2_TABLE_100
2176: , a2 JTF_NUMBER_TABLE
2177: , a3 JTF_NUMBER_TABLE
2178: , a4 JTF_NUMBER_TABLE
2179: , a5 JTF_VARCHAR2_TABLE_100
2180: , a6 JTF_VARCHAR2_TABLE_100
2181: , a7 JTF_VARCHAR2_TABLE_300
2174: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175: , a1 JTF_VARCHAR2_TABLE_100
2176: , a2 JTF_NUMBER_TABLE
2177: , a3 JTF_NUMBER_TABLE
2178: , a4 JTF_NUMBER_TABLE
2179: , a5 JTF_VARCHAR2_TABLE_100
2180: , a6 JTF_VARCHAR2_TABLE_100
2181: , a7 JTF_VARCHAR2_TABLE_300
2182: , a8 JTF_VARCHAR2_TABLE_100
2181: , a7 JTF_VARCHAR2_TABLE_300
2182: , a8 JTF_VARCHAR2_TABLE_100
2183: , a9 JTF_VARCHAR2_TABLE_100
2184: , a10 JTF_VARCHAR2_TABLE_100
2185: , a11 JTF_NUMBER_TABLE
2186: ) as
2187: ddindx binary_integer; indx binary_integer;
2188: begin
2189: if a0 is not null and a0.count > 0 then
2211: end loop;
2212: end if;
2213: end if;
2214: end rosetta_table_copy_in_p23;
2215: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217: , a2 out nocopy JTF_NUMBER_TABLE
2218: , a3 out nocopy JTF_NUMBER_TABLE
2219: , a4 out nocopy JTF_NUMBER_TABLE
2213: end if;
2214: end rosetta_table_copy_in_p23;
2215: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217: , a2 out nocopy JTF_NUMBER_TABLE
2218: , a3 out nocopy JTF_NUMBER_TABLE
2219: , a4 out nocopy JTF_NUMBER_TABLE
2220: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2221: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2214: end rosetta_table_copy_in_p23;
2215: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217: , a2 out nocopy JTF_NUMBER_TABLE
2218: , a3 out nocopy JTF_NUMBER_TABLE
2219: , a4 out nocopy JTF_NUMBER_TABLE
2220: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2221: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2222: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2215: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217: , a2 out nocopy JTF_NUMBER_TABLE
2218: , a3 out nocopy JTF_NUMBER_TABLE
2219: , a4 out nocopy JTF_NUMBER_TABLE
2220: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2221: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2222: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2223: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2222: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2223: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2224: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2225: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2226: , a11 out nocopy JTF_NUMBER_TABLE
2227: ) as
2228: ddindx binary_integer; indx binary_integer;
2229: begin
2230: if t is null or t.count = 0 then
2227: ) as
2228: ddindx binary_integer; indx binary_integer;
2229: begin
2230: if t is null or t.count = 0 then
2231: a0 := JTF_NUMBER_TABLE();
2232: a1 := JTF_VARCHAR2_TABLE_100();
2233: a2 := JTF_NUMBER_TABLE();
2234: a3 := JTF_NUMBER_TABLE();
2235: a4 := JTF_NUMBER_TABLE();
2229: begin
2230: if t is null or t.count = 0 then
2231: a0 := JTF_NUMBER_TABLE();
2232: a1 := JTF_VARCHAR2_TABLE_100();
2233: a2 := JTF_NUMBER_TABLE();
2234: a3 := JTF_NUMBER_TABLE();
2235: a4 := JTF_NUMBER_TABLE();
2236: a5 := JTF_VARCHAR2_TABLE_100();
2237: a6 := JTF_VARCHAR2_TABLE_100();
2230: if t is null or t.count = 0 then
2231: a0 := JTF_NUMBER_TABLE();
2232: a1 := JTF_VARCHAR2_TABLE_100();
2233: a2 := JTF_NUMBER_TABLE();
2234: a3 := JTF_NUMBER_TABLE();
2235: a4 := JTF_NUMBER_TABLE();
2236: a5 := JTF_VARCHAR2_TABLE_100();
2237: a6 := JTF_VARCHAR2_TABLE_100();
2238: a7 := JTF_VARCHAR2_TABLE_300();
2231: a0 := JTF_NUMBER_TABLE();
2232: a1 := JTF_VARCHAR2_TABLE_100();
2233: a2 := JTF_NUMBER_TABLE();
2234: a3 := JTF_NUMBER_TABLE();
2235: a4 := JTF_NUMBER_TABLE();
2236: a5 := JTF_VARCHAR2_TABLE_100();
2237: a6 := JTF_VARCHAR2_TABLE_100();
2238: a7 := JTF_VARCHAR2_TABLE_300();
2239: a8 := JTF_VARCHAR2_TABLE_100();
2238: a7 := JTF_VARCHAR2_TABLE_300();
2239: a8 := JTF_VARCHAR2_TABLE_100();
2240: a9 := JTF_VARCHAR2_TABLE_100();
2241: a10 := JTF_VARCHAR2_TABLE_100();
2242: a11 := JTF_NUMBER_TABLE();
2243: else
2244: a0 := JTF_NUMBER_TABLE();
2245: a1 := JTF_VARCHAR2_TABLE_100();
2246: a2 := JTF_NUMBER_TABLE();
2240: a9 := JTF_VARCHAR2_TABLE_100();
2241: a10 := JTF_VARCHAR2_TABLE_100();
2242: a11 := JTF_NUMBER_TABLE();
2243: else
2244: a0 := JTF_NUMBER_TABLE();
2245: a1 := JTF_VARCHAR2_TABLE_100();
2246: a2 := JTF_NUMBER_TABLE();
2247: a3 := JTF_NUMBER_TABLE();
2248: a4 := JTF_NUMBER_TABLE();
2242: a11 := JTF_NUMBER_TABLE();
2243: else
2244: a0 := JTF_NUMBER_TABLE();
2245: a1 := JTF_VARCHAR2_TABLE_100();
2246: a2 := JTF_NUMBER_TABLE();
2247: a3 := JTF_NUMBER_TABLE();
2248: a4 := JTF_NUMBER_TABLE();
2249: a5 := JTF_VARCHAR2_TABLE_100();
2250: a6 := JTF_VARCHAR2_TABLE_100();
2243: else
2244: a0 := JTF_NUMBER_TABLE();
2245: a1 := JTF_VARCHAR2_TABLE_100();
2246: a2 := JTF_NUMBER_TABLE();
2247: a3 := JTF_NUMBER_TABLE();
2248: a4 := JTF_NUMBER_TABLE();
2249: a5 := JTF_VARCHAR2_TABLE_100();
2250: a6 := JTF_VARCHAR2_TABLE_100();
2251: a7 := JTF_VARCHAR2_TABLE_300();
2244: a0 := JTF_NUMBER_TABLE();
2245: a1 := JTF_VARCHAR2_TABLE_100();
2246: a2 := JTF_NUMBER_TABLE();
2247: a3 := JTF_NUMBER_TABLE();
2248: a4 := JTF_NUMBER_TABLE();
2249: a5 := JTF_VARCHAR2_TABLE_100();
2250: a6 := JTF_VARCHAR2_TABLE_100();
2251: a7 := JTF_VARCHAR2_TABLE_300();
2252: a8 := JTF_VARCHAR2_TABLE_100();
2251: a7 := JTF_VARCHAR2_TABLE_300();
2252: a8 := JTF_VARCHAR2_TABLE_100();
2253: a9 := JTF_VARCHAR2_TABLE_100();
2254: a10 := JTF_VARCHAR2_TABLE_100();
2255: a11 := JTF_NUMBER_TABLE();
2256: if t.count > 0 then
2257: a0.extend(t.count);
2258: a1.extend(t.count);
2259: a2.extend(t.count);
2290: end if;
2291: end if;
2292: end rosetta_table_copy_out_p23;
2293:
2294: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100
2291: end if;
2292: end rosetta_table_copy_out_p23;
2293:
2294: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100
2299: , a5 JTF_NUMBER_TABLE
2292: end rosetta_table_copy_out_p23;
2293:
2294: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100
2299: , a5 JTF_NUMBER_TABLE
2300: , a6 JTF_VARCHAR2_TABLE_100
2293:
2294: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100
2299: , a5 JTF_NUMBER_TABLE
2300: , a6 JTF_VARCHAR2_TABLE_100
2301: , a7 JTF_VARCHAR2_TABLE_100
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100
2299: , a5 JTF_NUMBER_TABLE
2300: , a6 JTF_VARCHAR2_TABLE_100
2301: , a7 JTF_VARCHAR2_TABLE_100
2302: , a8 JTF_VARCHAR2_TABLE_100
2303: , a9 JTF_NUMBER_TABLE
2299: , a5 JTF_NUMBER_TABLE
2300: , a6 JTF_VARCHAR2_TABLE_100
2301: , a7 JTF_VARCHAR2_TABLE_100
2302: , a8 JTF_VARCHAR2_TABLE_100
2303: , a9 JTF_NUMBER_TABLE
2304: , a10 JTF_NUMBER_TABLE
2305: , a11 JTF_NUMBER_TABLE
2306: , a12 JTF_VARCHAR2_TABLE_100
2307: ) as
2300: , a6 JTF_VARCHAR2_TABLE_100
2301: , a7 JTF_VARCHAR2_TABLE_100
2302: , a8 JTF_VARCHAR2_TABLE_100
2303: , a9 JTF_NUMBER_TABLE
2304: , a10 JTF_NUMBER_TABLE
2305: , a11 JTF_NUMBER_TABLE
2306: , a12 JTF_VARCHAR2_TABLE_100
2307: ) as
2308: ddindx binary_integer; indx binary_integer;
2301: , a7 JTF_VARCHAR2_TABLE_100
2302: , a8 JTF_VARCHAR2_TABLE_100
2303: , a9 JTF_NUMBER_TABLE
2304: , a10 JTF_NUMBER_TABLE
2305: , a11 JTF_NUMBER_TABLE
2306: , a12 JTF_VARCHAR2_TABLE_100
2307: ) as
2308: ddindx binary_integer; indx binary_integer;
2309: begin
2333: end loop;
2334: end if;
2335: end if;
2336: end rosetta_table_copy_in_p25;
2337: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2334: end if;
2335: end if;
2336: end rosetta_table_copy_in_p25;
2337: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2342: , a5 out nocopy JTF_NUMBER_TABLE
2335: end if;
2336: end rosetta_table_copy_in_p25;
2337: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2342: , a5 out nocopy JTF_NUMBER_TABLE
2343: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2336: end rosetta_table_copy_in_p25;
2337: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2342: , a5 out nocopy JTF_NUMBER_TABLE
2343: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2344: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2342: , a5 out nocopy JTF_NUMBER_TABLE
2343: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2344: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2345: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2346: , a9 out nocopy JTF_NUMBER_TABLE
2342: , a5 out nocopy JTF_NUMBER_TABLE
2343: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2344: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2345: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2346: , a9 out nocopy JTF_NUMBER_TABLE
2347: , a10 out nocopy JTF_NUMBER_TABLE
2348: , a11 out nocopy JTF_NUMBER_TABLE
2349: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2350: ) as
2343: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2344: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2345: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2346: , a9 out nocopy JTF_NUMBER_TABLE
2347: , a10 out nocopy JTF_NUMBER_TABLE
2348: , a11 out nocopy JTF_NUMBER_TABLE
2349: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2350: ) as
2351: ddindx binary_integer; indx binary_integer;
2344: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2345: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2346: , a9 out nocopy JTF_NUMBER_TABLE
2347: , a10 out nocopy JTF_NUMBER_TABLE
2348: , a11 out nocopy JTF_NUMBER_TABLE
2349: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2350: ) as
2351: ddindx binary_integer; indx binary_integer;
2352: begin
2350: ) as
2351: ddindx binary_integer; indx binary_integer;
2352: begin
2353: if t is null or t.count = 0 then
2354: a0 := JTF_NUMBER_TABLE();
2355: a1 := JTF_NUMBER_TABLE();
2356: a2 := JTF_NUMBER_TABLE();
2357: a3 := JTF_NUMBER_TABLE();
2358: a4 := JTF_VARCHAR2_TABLE_100();
2351: ddindx binary_integer; indx binary_integer;
2352: begin
2353: if t is null or t.count = 0 then
2354: a0 := JTF_NUMBER_TABLE();
2355: a1 := JTF_NUMBER_TABLE();
2356: a2 := JTF_NUMBER_TABLE();
2357: a3 := JTF_NUMBER_TABLE();
2358: a4 := JTF_VARCHAR2_TABLE_100();
2359: a5 := JTF_NUMBER_TABLE();
2352: begin
2353: if t is null or t.count = 0 then
2354: a0 := JTF_NUMBER_TABLE();
2355: a1 := JTF_NUMBER_TABLE();
2356: a2 := JTF_NUMBER_TABLE();
2357: a3 := JTF_NUMBER_TABLE();
2358: a4 := JTF_VARCHAR2_TABLE_100();
2359: a5 := JTF_NUMBER_TABLE();
2360: a6 := JTF_VARCHAR2_TABLE_100();
2353: if t is null or t.count = 0 then
2354: a0 := JTF_NUMBER_TABLE();
2355: a1 := JTF_NUMBER_TABLE();
2356: a2 := JTF_NUMBER_TABLE();
2357: a3 := JTF_NUMBER_TABLE();
2358: a4 := JTF_VARCHAR2_TABLE_100();
2359: a5 := JTF_NUMBER_TABLE();
2360: a6 := JTF_VARCHAR2_TABLE_100();
2361: a7 := JTF_VARCHAR2_TABLE_100();
2355: a1 := JTF_NUMBER_TABLE();
2356: a2 := JTF_NUMBER_TABLE();
2357: a3 := JTF_NUMBER_TABLE();
2358: a4 := JTF_VARCHAR2_TABLE_100();
2359: a5 := JTF_NUMBER_TABLE();
2360: a6 := JTF_VARCHAR2_TABLE_100();
2361: a7 := JTF_VARCHAR2_TABLE_100();
2362: a8 := JTF_VARCHAR2_TABLE_100();
2363: a9 := JTF_NUMBER_TABLE();
2359: a5 := JTF_NUMBER_TABLE();
2360: a6 := JTF_VARCHAR2_TABLE_100();
2361: a7 := JTF_VARCHAR2_TABLE_100();
2362: a8 := JTF_VARCHAR2_TABLE_100();
2363: a9 := JTF_NUMBER_TABLE();
2364: a10 := JTF_NUMBER_TABLE();
2365: a11 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2360: a6 := JTF_VARCHAR2_TABLE_100();
2361: a7 := JTF_VARCHAR2_TABLE_100();
2362: a8 := JTF_VARCHAR2_TABLE_100();
2363: a9 := JTF_NUMBER_TABLE();
2364: a10 := JTF_NUMBER_TABLE();
2365: a11 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2361: a7 := JTF_VARCHAR2_TABLE_100();
2362: a8 := JTF_VARCHAR2_TABLE_100();
2363: a9 := JTF_NUMBER_TABLE();
2364: a10 := JTF_NUMBER_TABLE();
2365: a11 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2369: a1 := JTF_NUMBER_TABLE();
2364: a10 := JTF_NUMBER_TABLE();
2365: a11 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2369: a1 := JTF_NUMBER_TABLE();
2370: a2 := JTF_NUMBER_TABLE();
2371: a3 := JTF_NUMBER_TABLE();
2372: a4 := JTF_VARCHAR2_TABLE_100();
2365: a11 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2369: a1 := JTF_NUMBER_TABLE();
2370: a2 := JTF_NUMBER_TABLE();
2371: a3 := JTF_NUMBER_TABLE();
2372: a4 := JTF_VARCHAR2_TABLE_100();
2373: a5 := JTF_NUMBER_TABLE();
2366: a12 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2369: a1 := JTF_NUMBER_TABLE();
2370: a2 := JTF_NUMBER_TABLE();
2371: a3 := JTF_NUMBER_TABLE();
2372: a4 := JTF_VARCHAR2_TABLE_100();
2373: a5 := JTF_NUMBER_TABLE();
2374: a6 := JTF_VARCHAR2_TABLE_100();
2367: else
2368: a0 := JTF_NUMBER_TABLE();
2369: a1 := JTF_NUMBER_TABLE();
2370: a2 := JTF_NUMBER_TABLE();
2371: a3 := JTF_NUMBER_TABLE();
2372: a4 := JTF_VARCHAR2_TABLE_100();
2373: a5 := JTF_NUMBER_TABLE();
2374: a6 := JTF_VARCHAR2_TABLE_100();
2375: a7 := JTF_VARCHAR2_TABLE_100();
2369: a1 := JTF_NUMBER_TABLE();
2370: a2 := JTF_NUMBER_TABLE();
2371: a3 := JTF_NUMBER_TABLE();
2372: a4 := JTF_VARCHAR2_TABLE_100();
2373: a5 := JTF_NUMBER_TABLE();
2374: a6 := JTF_VARCHAR2_TABLE_100();
2375: a7 := JTF_VARCHAR2_TABLE_100();
2376: a8 := JTF_VARCHAR2_TABLE_100();
2377: a9 := JTF_NUMBER_TABLE();
2373: a5 := JTF_NUMBER_TABLE();
2374: a6 := JTF_VARCHAR2_TABLE_100();
2375: a7 := JTF_VARCHAR2_TABLE_100();
2376: a8 := JTF_VARCHAR2_TABLE_100();
2377: a9 := JTF_NUMBER_TABLE();
2378: a10 := JTF_NUMBER_TABLE();
2379: a11 := JTF_NUMBER_TABLE();
2380: a12 := JTF_VARCHAR2_TABLE_100();
2381: if t.count > 0 then
2374: a6 := JTF_VARCHAR2_TABLE_100();
2375: a7 := JTF_VARCHAR2_TABLE_100();
2376: a8 := JTF_VARCHAR2_TABLE_100();
2377: a9 := JTF_NUMBER_TABLE();
2378: a10 := JTF_NUMBER_TABLE();
2379: a11 := JTF_NUMBER_TABLE();
2380: a12 := JTF_VARCHAR2_TABLE_100();
2381: if t.count > 0 then
2382: a0.extend(t.count);
2375: a7 := JTF_VARCHAR2_TABLE_100();
2376: a8 := JTF_VARCHAR2_TABLE_100();
2377: a9 := JTF_NUMBER_TABLE();
2378: a10 := JTF_NUMBER_TABLE();
2379: a11 := JTF_NUMBER_TABLE();
2380: a12 := JTF_VARCHAR2_TABLE_100();
2381: if t.count > 0 then
2382: a0.extend(t.count);
2383: a1.extend(t.count);
2426: , x_msg_data out nocopy VARCHAR2
2427: , p_offer_type VARCHAR2
2428: , p8_a0 JTF_VARCHAR2_TABLE_100
2429: , p8_a1 JTF_VARCHAR2_TABLE_100
2430: , p8_a2 JTF_NUMBER_TABLE
2431: , p8_a3 JTF_NUMBER_TABLE
2432: , p8_a4 JTF_VARCHAR2_TABLE_100
2433: , p8_a5 JTF_NUMBER_TABLE
2434: , p8_a6 JTF_DATE_TABLE
2427: , p_offer_type VARCHAR2
2428: , p8_a0 JTF_VARCHAR2_TABLE_100
2429: , p8_a1 JTF_VARCHAR2_TABLE_100
2430: , p8_a2 JTF_NUMBER_TABLE
2431: , p8_a3 JTF_NUMBER_TABLE
2432: , p8_a4 JTF_VARCHAR2_TABLE_100
2433: , p8_a5 JTF_NUMBER_TABLE
2434: , p8_a6 JTF_DATE_TABLE
2435: , p8_a7 JTF_DATE_TABLE
2429: , p8_a1 JTF_VARCHAR2_TABLE_100
2430: , p8_a2 JTF_NUMBER_TABLE
2431: , p8_a3 JTF_NUMBER_TABLE
2432: , p8_a4 JTF_VARCHAR2_TABLE_100
2433: , p8_a5 JTF_NUMBER_TABLE
2434: , p8_a6 JTF_DATE_TABLE
2435: , p8_a7 JTF_DATE_TABLE
2436: , p8_a8 JTF_VARCHAR2_TABLE_100
2437: , p8_a9 JTF_VARCHAR2_TABLE_100
2434: , p8_a6 JTF_DATE_TABLE
2435: , p8_a7 JTF_DATE_TABLE
2436: , p8_a8 JTF_VARCHAR2_TABLE_100
2437: , p8_a9 JTF_VARCHAR2_TABLE_100
2438: , p8_a10 JTF_NUMBER_TABLE
2439: , p8_a11 JTF_VARCHAR2_TABLE_100
2440: , p8_a12 JTF_NUMBER_TABLE
2441: , p8_a13 JTF_NUMBER_TABLE
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2436: , p8_a8 JTF_VARCHAR2_TABLE_100
2437: , p8_a9 JTF_VARCHAR2_TABLE_100
2438: , p8_a10 JTF_NUMBER_TABLE
2439: , p8_a11 JTF_VARCHAR2_TABLE_100
2440: , p8_a12 JTF_NUMBER_TABLE
2441: , p8_a13 JTF_NUMBER_TABLE
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2437: , p8_a9 JTF_VARCHAR2_TABLE_100
2438: , p8_a10 JTF_NUMBER_TABLE
2439: , p8_a11 JTF_VARCHAR2_TABLE_100
2440: , p8_a12 JTF_NUMBER_TABLE
2441: , p8_a13 JTF_NUMBER_TABLE
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2439: , p8_a11 JTF_VARCHAR2_TABLE_100
2440: , p8_a12 JTF_NUMBER_TABLE
2441: , p8_a13 JTF_NUMBER_TABLE
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2446: , p8_a18 JTF_NUMBER_TABLE
2447: , p8_a19 JTF_NUMBER_TABLE
2441: , p8_a13 JTF_NUMBER_TABLE
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2446: , p8_a18 JTF_NUMBER_TABLE
2447: , p8_a19 JTF_NUMBER_TABLE
2448: , p8_a20 JTF_NUMBER_TABLE
2449: , p8_a21 JTF_VARCHAR2_TABLE_100
2442: , p8_a14 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2446: , p8_a18 JTF_NUMBER_TABLE
2447: , p8_a19 JTF_NUMBER_TABLE
2448: , p8_a20 JTF_NUMBER_TABLE
2449: , p8_a21 JTF_VARCHAR2_TABLE_100
2450: , p8_a22 JTF_VARCHAR2_TABLE_100
2443: , p8_a15 JTF_NUMBER_TABLE
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2446: , p8_a18 JTF_NUMBER_TABLE
2447: , p8_a19 JTF_NUMBER_TABLE
2448: , p8_a20 JTF_NUMBER_TABLE
2449: , p8_a21 JTF_VARCHAR2_TABLE_100
2450: , p8_a22 JTF_VARCHAR2_TABLE_100
2451: , p8_a23 JTF_VARCHAR2_TABLE_100
2444: , p8_a16 JTF_VARCHAR2_TABLE_100
2445: , p8_a17 JTF_NUMBER_TABLE
2446: , p8_a18 JTF_NUMBER_TABLE
2447: , p8_a19 JTF_NUMBER_TABLE
2448: , p8_a20 JTF_NUMBER_TABLE
2449: , p8_a21 JTF_VARCHAR2_TABLE_100
2450: , p8_a22 JTF_VARCHAR2_TABLE_100
2451: , p8_a23 JTF_VARCHAR2_TABLE_100
2452: , p8_a24 JTF_VARCHAR2_TABLE_300
2450: , p8_a22 JTF_VARCHAR2_TABLE_100
2451: , p8_a23 JTF_VARCHAR2_TABLE_100
2452: , p8_a24 JTF_VARCHAR2_TABLE_300
2453: , p8_a25 JTF_VARCHAR2_TABLE_100
2454: , p8_a26 JTF_NUMBER_TABLE
2455: , p8_a27 JTF_VARCHAR2_TABLE_100
2456: , p8_a28 JTF_VARCHAR2_TABLE_100
2457: , p8_a29 JTF_VARCHAR2_TABLE_300
2458: , p8_a30 JTF_VARCHAR2_TABLE_100
2462: , p8_a34 JTF_VARCHAR2_TABLE_300
2463: , p8_a35 JTF_VARCHAR2_TABLE_100
2464: , p8_a36 JTF_VARCHAR2_TABLE_300
2465: , p8_a37 JTF_VARCHAR2_TABLE_300
2466: , p8_a38 JTF_NUMBER_TABLE
2467: , p8_a39 JTF_VARCHAR2_TABLE_2000
2468: , p8_a40 JTF_VARCHAR2_TABLE_100
2469: , p8_a41 JTF_VARCHAR2_TABLE_300
2470: , p8_a42 JTF_VARCHAR2_TABLE_300
2480: , p8_a52 JTF_VARCHAR2_TABLE_300
2481: , p8_a53 JTF_VARCHAR2_TABLE_300
2482: , p8_a54 JTF_VARCHAR2_TABLE_300
2483: , p8_a55 JTF_VARCHAR2_TABLE_300
2484: , p8_a56 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2481: , p8_a53 JTF_VARCHAR2_TABLE_300
2482: , p8_a54 JTF_VARCHAR2_TABLE_300
2483: , p8_a55 JTF_VARCHAR2_TABLE_300
2484: , p8_a56 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2482: , p8_a54 JTF_VARCHAR2_TABLE_300
2483: , p8_a55 JTF_VARCHAR2_TABLE_300
2484: , p8_a56 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2483: , p8_a55 JTF_VARCHAR2_TABLE_300
2484: , p8_a56 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2484: , p8_a56 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2485: , p8_a57 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2486: , p8_a58 JTF_NUMBER_TABLE
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2487: , p8_a59 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2495: , p8_a67 JTF_NUMBER_TABLE
2488: , p8_a60 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2495: , p8_a67 JTF_NUMBER_TABLE
2496: , p8_a68 JTF_NUMBER_TABLE
2489: , p8_a61 JTF_NUMBER_TABLE
2490: , p8_a62 JTF_NUMBER_TABLE
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2495: , p8_a67 JTF_NUMBER_TABLE
2496: , p8_a68 JTF_NUMBER_TABLE
2497: , p8_a69 JTF_VARCHAR2_TABLE_300
2491: , p8_a63 JTF_NUMBER_TABLE
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2495: , p8_a67 JTF_NUMBER_TABLE
2496: , p8_a68 JTF_NUMBER_TABLE
2497: , p8_a69 JTF_VARCHAR2_TABLE_300
2498: , p8_a70 JTF_VARCHAR2_TABLE_300
2499: , p9_a0 JTF_VARCHAR2_TABLE_100
2492: , p8_a64 JTF_NUMBER_TABLE
2493: , p8_a65 JTF_NUMBER_TABLE
2494: , p8_a66 JTF_VARCHAR2_TABLE_100
2495: , p8_a67 JTF_NUMBER_TABLE
2496: , p8_a68 JTF_NUMBER_TABLE
2497: , p8_a69 JTF_VARCHAR2_TABLE_300
2498: , p8_a70 JTF_VARCHAR2_TABLE_300
2499: , p9_a0 JTF_VARCHAR2_TABLE_100
2500: , p9_a1 JTF_VARCHAR2_TABLE_100
2500: , p9_a1 JTF_VARCHAR2_TABLE_100
2501: , p9_a2 JTF_VARCHAR2_TABLE_300
2502: , p9_a3 JTF_VARCHAR2_TABLE_300
2503: , p9_a4 JTF_VARCHAR2_TABLE_100
2504: , p9_a5 JTF_NUMBER_TABLE
2505: , p9_a6 JTF_NUMBER_TABLE
2506: , p9_a7 JTF_NUMBER_TABLE
2507: , p9_a8 JTF_NUMBER_TABLE
2508: , p9_a9 JTF_DATE_TABLE
2501: , p9_a2 JTF_VARCHAR2_TABLE_300
2502: , p9_a3 JTF_VARCHAR2_TABLE_300
2503: , p9_a4 JTF_VARCHAR2_TABLE_100
2504: , p9_a5 JTF_NUMBER_TABLE
2505: , p9_a6 JTF_NUMBER_TABLE
2506: , p9_a7 JTF_NUMBER_TABLE
2507: , p9_a8 JTF_NUMBER_TABLE
2508: , p9_a9 JTF_DATE_TABLE
2509: , p9_a10 JTF_DATE_TABLE
2502: , p9_a3 JTF_VARCHAR2_TABLE_300
2503: , p9_a4 JTF_VARCHAR2_TABLE_100
2504: , p9_a5 JTF_NUMBER_TABLE
2505: , p9_a6 JTF_NUMBER_TABLE
2506: , p9_a7 JTF_NUMBER_TABLE
2507: , p9_a8 JTF_NUMBER_TABLE
2508: , p9_a9 JTF_DATE_TABLE
2509: , p9_a10 JTF_DATE_TABLE
2510: , p9_a11 JTF_NUMBER_TABLE
2503: , p9_a4 JTF_VARCHAR2_TABLE_100
2504: , p9_a5 JTF_NUMBER_TABLE
2505: , p9_a6 JTF_NUMBER_TABLE
2506: , p9_a7 JTF_NUMBER_TABLE
2507: , p9_a8 JTF_NUMBER_TABLE
2508: , p9_a9 JTF_DATE_TABLE
2509: , p9_a10 JTF_DATE_TABLE
2510: , p9_a11 JTF_NUMBER_TABLE
2511: , p9_a12 JTF_VARCHAR2_TABLE_100
2506: , p9_a7 JTF_NUMBER_TABLE
2507: , p9_a8 JTF_NUMBER_TABLE
2508: , p9_a9 JTF_DATE_TABLE
2509: , p9_a10 JTF_DATE_TABLE
2510: , p9_a11 JTF_NUMBER_TABLE
2511: , p9_a12 JTF_VARCHAR2_TABLE_100
2512: , p9_a13 JTF_VARCHAR2_TABLE_100
2513: , p9_a14 JTF_VARCHAR2_TABLE_300
2514: , p9_a15 JTF_VARCHAR2_TABLE_300
2524: , p9_a25 JTF_VARCHAR2_TABLE_300
2525: , p9_a26 JTF_VARCHAR2_TABLE_300
2526: , p9_a27 JTF_VARCHAR2_TABLE_300
2527: , p9_a28 JTF_VARCHAR2_TABLE_300
2528: , p10_a0 JTF_NUMBER_TABLE
2529: , p10_a1 JTF_NUMBER_TABLE
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2525: , p9_a26 JTF_VARCHAR2_TABLE_300
2526: , p9_a27 JTF_VARCHAR2_TABLE_300
2527: , p9_a28 JTF_VARCHAR2_TABLE_300
2528: , p10_a0 JTF_NUMBER_TABLE
2529: , p10_a1 JTF_NUMBER_TABLE
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2533: , p11_a1 JTF_NUMBER_TABLE
2526: , p9_a27 JTF_VARCHAR2_TABLE_300
2527: , p9_a28 JTF_VARCHAR2_TABLE_300
2528: , p10_a0 JTF_NUMBER_TABLE
2529: , p10_a1 JTF_NUMBER_TABLE
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2533: , p11_a1 JTF_NUMBER_TABLE
2534: , p11_a2 JTF_NUMBER_TABLE
2528: , p10_a0 JTF_NUMBER_TABLE
2529: , p10_a1 JTF_NUMBER_TABLE
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2533: , p11_a1 JTF_NUMBER_TABLE
2534: , p11_a2 JTF_NUMBER_TABLE
2535: , p11_a3 JTF_VARCHAR2_TABLE_100
2536: , p11_a4 JTF_VARCHAR2_TABLE_100
2529: , p10_a1 JTF_NUMBER_TABLE
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2533: , p11_a1 JTF_NUMBER_TABLE
2534: , p11_a2 JTF_NUMBER_TABLE
2535: , p11_a3 JTF_VARCHAR2_TABLE_100
2536: , p11_a4 JTF_VARCHAR2_TABLE_100
2537: , p11_a5 JTF_VARCHAR2_TABLE_100
2530: , p10_a2 JTF_NUMBER_TABLE
2531: , p10_a3 JTF_VARCHAR2_TABLE_100
2532: , p11_a0 JTF_NUMBER_TABLE
2533: , p11_a1 JTF_NUMBER_TABLE
2534: , p11_a2 JTF_NUMBER_TABLE
2535: , p11_a3 JTF_VARCHAR2_TABLE_100
2536: , p11_a4 JTF_VARCHAR2_TABLE_100
2537: , p11_a5 JTF_VARCHAR2_TABLE_100
2538: , p11_a6 JTF_VARCHAR2_TABLE_100
2535: , p11_a3 JTF_VARCHAR2_TABLE_100
2536: , p11_a4 JTF_VARCHAR2_TABLE_100
2537: , p11_a5 JTF_VARCHAR2_TABLE_100
2538: , p11_a6 JTF_VARCHAR2_TABLE_100
2539: , p11_a7 JTF_NUMBER_TABLE
2540: , p11_a8 JTF_NUMBER_TABLE
2541: , p11_a9 JTF_NUMBER_TABLE
2542: , p11_a10 JTF_NUMBER_TABLE
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2536: , p11_a4 JTF_VARCHAR2_TABLE_100
2537: , p11_a5 JTF_VARCHAR2_TABLE_100
2538: , p11_a6 JTF_VARCHAR2_TABLE_100
2539: , p11_a7 JTF_NUMBER_TABLE
2540: , p11_a8 JTF_NUMBER_TABLE
2541: , p11_a9 JTF_NUMBER_TABLE
2542: , p11_a10 JTF_NUMBER_TABLE
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2537: , p11_a5 JTF_VARCHAR2_TABLE_100
2538: , p11_a6 JTF_VARCHAR2_TABLE_100
2539: , p11_a7 JTF_NUMBER_TABLE
2540: , p11_a8 JTF_NUMBER_TABLE
2541: , p11_a9 JTF_NUMBER_TABLE
2542: , p11_a10 JTF_NUMBER_TABLE
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2545: , p11_a13 JTF_VARCHAR2_TABLE_100
2538: , p11_a6 JTF_VARCHAR2_TABLE_100
2539: , p11_a7 JTF_NUMBER_TABLE
2540: , p11_a8 JTF_NUMBER_TABLE
2541: , p11_a9 JTF_NUMBER_TABLE
2542: , p11_a10 JTF_NUMBER_TABLE
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2545: , p11_a13 JTF_VARCHAR2_TABLE_100
2546: , p11_a14 JTF_NUMBER_TABLE
2542: , p11_a10 JTF_NUMBER_TABLE
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2545: , p11_a13 JTF_VARCHAR2_TABLE_100
2546: , p11_a14 JTF_NUMBER_TABLE
2547: , p11_a15 JTF_NUMBER_TABLE
2548: , p11_a16 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2543: , p11_a11 JTF_VARCHAR2_TABLE_100
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2545: , p11_a13 JTF_VARCHAR2_TABLE_100
2546: , p11_a14 JTF_NUMBER_TABLE
2547: , p11_a15 JTF_NUMBER_TABLE
2548: , p11_a16 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2551: , p11_a19 JTF_NUMBER_TABLE
2544: , p11_a12 JTF_VARCHAR2_TABLE_100
2545: , p11_a13 JTF_VARCHAR2_TABLE_100
2546: , p11_a14 JTF_NUMBER_TABLE
2547: , p11_a15 JTF_NUMBER_TABLE
2548: , p11_a16 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2551: , p11_a19 JTF_NUMBER_TABLE
2552: , p11_a20 JTF_NUMBER_TABLE
2547: , p11_a15 JTF_NUMBER_TABLE
2548: , p11_a16 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2551: , p11_a19 JTF_NUMBER_TABLE
2552: , p11_a20 JTF_NUMBER_TABLE
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2548: , p11_a16 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2551: , p11_a19 JTF_NUMBER_TABLE
2552: , p11_a20 JTF_NUMBER_TABLE
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2549: , p11_a17 JTF_VARCHAR2_TABLE_100
2550: , p11_a18 JTF_VARCHAR2_TABLE_100
2551: , p11_a19 JTF_NUMBER_TABLE
2552: , p11_a20 JTF_NUMBER_TABLE
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2557: , p12_a2 JTF_NUMBER_TABLE
2551: , p11_a19 JTF_NUMBER_TABLE
2552: , p11_a20 JTF_NUMBER_TABLE
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2557: , p12_a2 JTF_NUMBER_TABLE
2558: , p12_a3 JTF_NUMBER_TABLE
2559: , p12_a4 JTF_VARCHAR2_TABLE_100
2552: , p11_a20 JTF_NUMBER_TABLE
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2557: , p12_a2 JTF_NUMBER_TABLE
2558: , p12_a3 JTF_NUMBER_TABLE
2559: , p12_a4 JTF_VARCHAR2_TABLE_100
2560: , p12_a5 JTF_VARCHAR2_TABLE_100
2553: , p11_a21 JTF_NUMBER_TABLE
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2557: , p12_a2 JTF_NUMBER_TABLE
2558: , p12_a3 JTF_NUMBER_TABLE
2559: , p12_a4 JTF_VARCHAR2_TABLE_100
2560: , p12_a5 JTF_VARCHAR2_TABLE_100
2561: , p12_a6 JTF_VARCHAR2_TABLE_100
2554: , p11_a22 JTF_VARCHAR2_TABLE_100
2555: , p12_a0 JTF_NUMBER_TABLE
2556: , p12_a1 JTF_NUMBER_TABLE
2557: , p12_a2 JTF_NUMBER_TABLE
2558: , p12_a3 JTF_NUMBER_TABLE
2559: , p12_a4 JTF_VARCHAR2_TABLE_100
2560: , p12_a5 JTF_VARCHAR2_TABLE_100
2561: , p12_a6 JTF_VARCHAR2_TABLE_100
2562: , p12_a7 JTF_NUMBER_TABLE
2558: , p12_a3 JTF_NUMBER_TABLE
2559: , p12_a4 JTF_VARCHAR2_TABLE_100
2560: , p12_a5 JTF_VARCHAR2_TABLE_100
2561: , p12_a6 JTF_VARCHAR2_TABLE_100
2562: , p12_a7 JTF_NUMBER_TABLE
2563: , p12_a8 JTF_VARCHAR2_TABLE_100
2564: , p12_a9 JTF_VARCHAR2_TABLE_100
2565: , p12_a10 JTF_VARCHAR2_TABLE_100
2566: , p12_a11 JTF_VARCHAR2_TABLE_100
2563: , p12_a8 JTF_VARCHAR2_TABLE_100
2564: , p12_a9 JTF_VARCHAR2_TABLE_100
2565: , p12_a10 JTF_VARCHAR2_TABLE_100
2566: , p12_a11 JTF_VARCHAR2_TABLE_100
2567: , p12_a12 JTF_NUMBER_TABLE
2568: , p12_a13 JTF_VARCHAR2_TABLE_100
2569: , p12_a14 JTF_NUMBER_TABLE
2570: , p12_a15 JTF_NUMBER_TABLE
2571: , p12_a16 JTF_NUMBER_TABLE
2565: , p12_a10 JTF_VARCHAR2_TABLE_100
2566: , p12_a11 JTF_VARCHAR2_TABLE_100
2567: , p12_a12 JTF_NUMBER_TABLE
2568: , p12_a13 JTF_VARCHAR2_TABLE_100
2569: , p12_a14 JTF_NUMBER_TABLE
2570: , p12_a15 JTF_NUMBER_TABLE
2571: , p12_a16 JTF_NUMBER_TABLE
2572: , p12_a17 JTF_NUMBER_TABLE
2573: , p12_a18 JTF_VARCHAR2_TABLE_100
2566: , p12_a11 JTF_VARCHAR2_TABLE_100
2567: , p12_a12 JTF_NUMBER_TABLE
2568: , p12_a13 JTF_VARCHAR2_TABLE_100
2569: , p12_a14 JTF_NUMBER_TABLE
2570: , p12_a15 JTF_NUMBER_TABLE
2571: , p12_a16 JTF_NUMBER_TABLE
2572: , p12_a17 JTF_NUMBER_TABLE
2573: , p12_a18 JTF_VARCHAR2_TABLE_100
2574: , p12_a19 JTF_DATE_TABLE
2567: , p12_a12 JTF_NUMBER_TABLE
2568: , p12_a13 JTF_VARCHAR2_TABLE_100
2569: , p12_a14 JTF_NUMBER_TABLE
2570: , p12_a15 JTF_NUMBER_TABLE
2571: , p12_a16 JTF_NUMBER_TABLE
2572: , p12_a17 JTF_NUMBER_TABLE
2573: , p12_a18 JTF_VARCHAR2_TABLE_100
2574: , p12_a19 JTF_DATE_TABLE
2575: , p12_a20 JTF_DATE_TABLE
2568: , p12_a13 JTF_VARCHAR2_TABLE_100
2569: , p12_a14 JTF_NUMBER_TABLE
2570: , p12_a15 JTF_NUMBER_TABLE
2571: , p12_a16 JTF_NUMBER_TABLE
2572: , p12_a17 JTF_NUMBER_TABLE
2573: , p12_a18 JTF_VARCHAR2_TABLE_100
2574: , p12_a19 JTF_DATE_TABLE
2575: , p12_a20 JTF_DATE_TABLE
2576: , p12_a21 JTF_VARCHAR2_TABLE_100
2574: , p12_a19 JTF_DATE_TABLE
2575: , p12_a20 JTF_DATE_TABLE
2576: , p12_a21 JTF_VARCHAR2_TABLE_100
2577: , p12_a22 JTF_DATE_TABLE
2578: , p12_a23 JTF_NUMBER_TABLE
2579: , p12_a24 JTF_DATE_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2576: , p12_a21 JTF_VARCHAR2_TABLE_100
2577: , p12_a22 JTF_DATE_TABLE
2578: , p12_a23 JTF_NUMBER_TABLE
2579: , p12_a24 JTF_DATE_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2577: , p12_a22 JTF_DATE_TABLE
2578: , p12_a23 JTF_NUMBER_TABLE
2579: , p12_a24 JTF_DATE_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2578: , p12_a23 JTF_NUMBER_TABLE
2579: , p12_a24 JTF_DATE_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2579: , p12_a24 JTF_DATE_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2587: , p12_a32 JTF_NUMBER_TABLE
2580: , p12_a25 JTF_NUMBER_TABLE
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2587: , p12_a32 JTF_NUMBER_TABLE
2588: , p12_a33 JTF_VARCHAR2_TABLE_100
2581: , p12_a26 JTF_NUMBER_TABLE
2582: , p12_a27 JTF_NUMBER_TABLE
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2587: , p12_a32 JTF_NUMBER_TABLE
2588: , p12_a33 JTF_VARCHAR2_TABLE_100
2589: , p12_a34 JTF_VARCHAR2_TABLE_100
2583: , p12_a28 JTF_NUMBER_TABLE
2584: , p12_a29 JTF_NUMBER_TABLE
2585: , p12_a30 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2587: , p12_a32 JTF_NUMBER_TABLE
2588: , p12_a33 JTF_VARCHAR2_TABLE_100
2589: , p12_a34 JTF_VARCHAR2_TABLE_100
2590: , p13_a0 JTF_NUMBER_TABLE
2591: , p13_a1 JTF_NUMBER_TABLE
2586: , p12_a31 JTF_VARCHAR2_TABLE_100
2587: , p12_a32 JTF_NUMBER_TABLE
2588: , p12_a33 JTF_VARCHAR2_TABLE_100
2589: , p12_a34 JTF_VARCHAR2_TABLE_100
2590: , p13_a0 JTF_NUMBER_TABLE
2591: , p13_a1 JTF_NUMBER_TABLE
2592: , p13_a2 JTF_VARCHAR2_TABLE_100
2593: , p13_a3 JTF_NUMBER_TABLE
2594: , p13_a4 JTF_NUMBER_TABLE
2587: , p12_a32 JTF_NUMBER_TABLE
2588: , p12_a33 JTF_VARCHAR2_TABLE_100
2589: , p12_a34 JTF_VARCHAR2_TABLE_100
2590: , p13_a0 JTF_NUMBER_TABLE
2591: , p13_a1 JTF_NUMBER_TABLE
2592: , p13_a2 JTF_VARCHAR2_TABLE_100
2593: , p13_a3 JTF_NUMBER_TABLE
2594: , p13_a4 JTF_NUMBER_TABLE
2595: , p13_a5 JTF_DATE_TABLE
2589: , p12_a34 JTF_VARCHAR2_TABLE_100
2590: , p13_a0 JTF_NUMBER_TABLE
2591: , p13_a1 JTF_NUMBER_TABLE
2592: , p13_a2 JTF_VARCHAR2_TABLE_100
2593: , p13_a3 JTF_NUMBER_TABLE
2594: , p13_a4 JTF_NUMBER_TABLE
2595: , p13_a5 JTF_DATE_TABLE
2596: , p13_a6 JTF_DATE_TABLE
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2590: , p13_a0 JTF_NUMBER_TABLE
2591: , p13_a1 JTF_NUMBER_TABLE
2592: , p13_a2 JTF_VARCHAR2_TABLE_100
2593: , p13_a3 JTF_NUMBER_TABLE
2594: , p13_a4 JTF_NUMBER_TABLE
2595: , p13_a5 JTF_DATE_TABLE
2596: , p13_a6 JTF_DATE_TABLE
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2594: , p13_a4 JTF_NUMBER_TABLE
2595: , p13_a5 JTF_DATE_TABLE
2596: , p13_a6 JTF_DATE_TABLE
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2599: , p14_a1 JTF_NUMBER_TABLE
2600: , p14_a2 JTF_NUMBER_TABLE
2601: , p14_a3 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2595: , p13_a5 JTF_DATE_TABLE
2596: , p13_a6 JTF_DATE_TABLE
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2599: , p14_a1 JTF_NUMBER_TABLE
2600: , p14_a2 JTF_NUMBER_TABLE
2601: , p14_a3 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2603: , p14_a5 JTF_VARCHAR2_TABLE_100
2596: , p13_a6 JTF_DATE_TABLE
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2599: , p14_a1 JTF_NUMBER_TABLE
2600: , p14_a2 JTF_NUMBER_TABLE
2601: , p14_a3 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2603: , p14_a5 JTF_VARCHAR2_TABLE_100
2604: , p14_a6 JTF_VARCHAR2_TABLE_100
2597: , p13_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2599: , p14_a1 JTF_NUMBER_TABLE
2600: , p14_a2 JTF_NUMBER_TABLE
2601: , p14_a3 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2603: , p14_a5 JTF_VARCHAR2_TABLE_100
2604: , p14_a6 JTF_VARCHAR2_TABLE_100
2605: , p14_a7 JTF_VARCHAR2_TABLE_100
2598: , p14_a0 JTF_NUMBER_TABLE
2599: , p14_a1 JTF_NUMBER_TABLE
2600: , p14_a2 JTF_NUMBER_TABLE
2601: , p14_a3 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2603: , p14_a5 JTF_VARCHAR2_TABLE_100
2604: , p14_a6 JTF_VARCHAR2_TABLE_100
2605: , p14_a7 JTF_VARCHAR2_TABLE_100
2606: , p14_a8 JTF_NUMBER_TABLE
2602: , p14_a4 JTF_NUMBER_TABLE
2603: , p14_a5 JTF_VARCHAR2_TABLE_100
2604: , p14_a6 JTF_VARCHAR2_TABLE_100
2605: , p14_a7 JTF_VARCHAR2_TABLE_100
2606: , p14_a8 JTF_NUMBER_TABLE
2607: , p14_a9 JTF_VARCHAR2_TABLE_100
2608: , p14_a10 JTF_DATE_TABLE
2609: , p14_a11 JTF_DATE_TABLE
2610: , p14_a12 JTF_VARCHAR2_TABLE_100
2607: , p14_a9 JTF_VARCHAR2_TABLE_100
2608: , p14_a10 JTF_DATE_TABLE
2609: , p14_a11 JTF_DATE_TABLE
2610: , p14_a12 JTF_VARCHAR2_TABLE_100
2611: , p14_a13 JTF_NUMBER_TABLE
2612: , p14_a14 JTF_VARCHAR2_TABLE_100
2613: , p15_a0 JTF_NUMBER_TABLE
2614: , p15_a1 JTF_NUMBER_TABLE
2615: , p15_a2 JTF_VARCHAR2_TABLE_100
2609: , p14_a11 JTF_DATE_TABLE
2610: , p14_a12 JTF_VARCHAR2_TABLE_100
2611: , p14_a13 JTF_NUMBER_TABLE
2612: , p14_a14 JTF_VARCHAR2_TABLE_100
2613: , p15_a0 JTF_NUMBER_TABLE
2614: , p15_a1 JTF_NUMBER_TABLE
2615: , p15_a2 JTF_VARCHAR2_TABLE_100
2616: , p15_a3 JTF_NUMBER_TABLE
2617: , p15_a4 JTF_VARCHAR2_TABLE_100
2610: , p14_a12 JTF_VARCHAR2_TABLE_100
2611: , p14_a13 JTF_NUMBER_TABLE
2612: , p14_a14 JTF_VARCHAR2_TABLE_100
2613: , p15_a0 JTF_NUMBER_TABLE
2614: , p15_a1 JTF_NUMBER_TABLE
2615: , p15_a2 JTF_VARCHAR2_TABLE_100
2616: , p15_a3 JTF_NUMBER_TABLE
2617: , p15_a4 JTF_VARCHAR2_TABLE_100
2618: , p15_a5 JTF_VARCHAR2_TABLE_100
2612: , p14_a14 JTF_VARCHAR2_TABLE_100
2613: , p15_a0 JTF_NUMBER_TABLE
2614: , p15_a1 JTF_NUMBER_TABLE
2615: , p15_a2 JTF_VARCHAR2_TABLE_100
2616: , p15_a3 JTF_NUMBER_TABLE
2617: , p15_a4 JTF_VARCHAR2_TABLE_100
2618: , p15_a5 JTF_VARCHAR2_TABLE_100
2619: , p15_a6 JTF_DATE_TABLE
2620: , p15_a7 JTF_DATE_TABLE
2617: , p15_a4 JTF_VARCHAR2_TABLE_100
2618: , p15_a5 JTF_VARCHAR2_TABLE_100
2619: , p15_a6 JTF_DATE_TABLE
2620: , p15_a7 JTF_DATE_TABLE
2621: , p15_a8 JTF_NUMBER_TABLE
2622: , p15_a9 JTF_NUMBER_TABLE
2623: , p15_a10 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2618: , p15_a5 JTF_VARCHAR2_TABLE_100
2619: , p15_a6 JTF_DATE_TABLE
2620: , p15_a7 JTF_DATE_TABLE
2621: , p15_a8 JTF_NUMBER_TABLE
2622: , p15_a9 JTF_NUMBER_TABLE
2623: , p15_a10 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2620: , p15_a7 JTF_DATE_TABLE
2621: , p15_a8 JTF_NUMBER_TABLE
2622: , p15_a9 JTF_NUMBER_TABLE
2623: , p15_a10 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2627: , p15_a14 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2622: , p15_a9 JTF_NUMBER_TABLE
2623: , p15_a10 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2627: , p15_a14 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2629: , p15_a16 JTF_VARCHAR2_TABLE_100
2630: , p16_a0 JTF_NUMBER_TABLE
2623: , p15_a10 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2627: , p15_a14 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2629: , p15_a16 JTF_VARCHAR2_TABLE_100
2630: , p16_a0 JTF_NUMBER_TABLE
2631: , p16_a1 JTF_DATE_TABLE
2624: , p15_a11 JTF_NUMBER_TABLE
2625: , p15_a12 JTF_DATE_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2627: , p15_a14 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2629: , p15_a16 JTF_VARCHAR2_TABLE_100
2630: , p16_a0 JTF_NUMBER_TABLE
2631: , p16_a1 JTF_DATE_TABLE
2632: , p16_a2 JTF_NUMBER_TABLE
2626: , p15_a13 JTF_NUMBER_TABLE
2627: , p15_a14 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2629: , p15_a16 JTF_VARCHAR2_TABLE_100
2630: , p16_a0 JTF_NUMBER_TABLE
2631: , p16_a1 JTF_DATE_TABLE
2632: , p16_a2 JTF_NUMBER_TABLE
2633: , p16_a3 JTF_DATE_TABLE
2634: , p16_a4 JTF_NUMBER_TABLE
2628: , p15_a15 JTF_NUMBER_TABLE
2629: , p15_a16 JTF_VARCHAR2_TABLE_100
2630: , p16_a0 JTF_NUMBER_TABLE
2631: , p16_a1 JTF_DATE_TABLE
2632: , p16_a2 JTF_NUMBER_TABLE
2633: , p16_a3 JTF_DATE_TABLE
2634: , p16_a4 JTF_NUMBER_TABLE
2635: , p16_a5 JTF_NUMBER_TABLE
2636: , p16_a6 JTF_NUMBER_TABLE
2630: , p16_a0 JTF_NUMBER_TABLE
2631: , p16_a1 JTF_DATE_TABLE
2632: , p16_a2 JTF_NUMBER_TABLE
2633: , p16_a3 JTF_DATE_TABLE
2634: , p16_a4 JTF_NUMBER_TABLE
2635: , p16_a5 JTF_NUMBER_TABLE
2636: , p16_a6 JTF_NUMBER_TABLE
2637: , p16_a7 JTF_VARCHAR2_TABLE_100
2638: , p16_a8 JTF_VARCHAR2_TABLE_100
2631: , p16_a1 JTF_DATE_TABLE
2632: , p16_a2 JTF_NUMBER_TABLE
2633: , p16_a3 JTF_DATE_TABLE
2634: , p16_a4 JTF_NUMBER_TABLE
2635: , p16_a5 JTF_NUMBER_TABLE
2636: , p16_a6 JTF_NUMBER_TABLE
2637: , p16_a7 JTF_VARCHAR2_TABLE_100
2638: , p16_a8 JTF_VARCHAR2_TABLE_100
2639: , p16_a9 JTF_VARCHAR2_TABLE_300
2632: , p16_a2 JTF_NUMBER_TABLE
2633: , p16_a3 JTF_DATE_TABLE
2634: , p16_a4 JTF_NUMBER_TABLE
2635: , p16_a5 JTF_NUMBER_TABLE
2636: , p16_a6 JTF_NUMBER_TABLE
2637: , p16_a7 JTF_VARCHAR2_TABLE_100
2638: , p16_a8 JTF_VARCHAR2_TABLE_100
2639: , p16_a9 JTF_VARCHAR2_TABLE_300
2640: , p16_a10 JTF_DATE_TABLE
2638: , p16_a8 JTF_VARCHAR2_TABLE_100
2639: , p16_a9 JTF_VARCHAR2_TABLE_300
2640: , p16_a10 JTF_DATE_TABLE
2641: , p16_a11 JTF_DATE_TABLE
2642: , p16_a12 JTF_NUMBER_TABLE
2643: , p16_a13 JTF_NUMBER_TABLE
2644: , p16_a14 JTF_VARCHAR2_TABLE_100
2645: , p16_a15 JTF_VARCHAR2_TABLE_300
2646: , p16_a16 JTF_VARCHAR2_TABLE_300
2639: , p16_a9 JTF_VARCHAR2_TABLE_300
2640: , p16_a10 JTF_DATE_TABLE
2641: , p16_a11 JTF_DATE_TABLE
2642: , p16_a12 JTF_NUMBER_TABLE
2643: , p16_a13 JTF_NUMBER_TABLE
2644: , p16_a14 JTF_VARCHAR2_TABLE_100
2645: , p16_a15 JTF_VARCHAR2_TABLE_300
2646: , p16_a16 JTF_VARCHAR2_TABLE_300
2647: , p16_a17 JTF_VARCHAR2_TABLE_300
2657: , p16_a27 JTF_VARCHAR2_TABLE_300
2658: , p16_a28 JTF_VARCHAR2_TABLE_300
2659: , p16_a29 JTF_VARCHAR2_TABLE_300
2660: , p16_a30 JTF_VARCHAR2_TABLE_100
2661: , p16_a31 JTF_NUMBER_TABLE
2662: , p16_a32 JTF_VARCHAR2_TABLE_100
2663: , x_qp_list_header_id out nocopy NUMBER
2664: , x_error_location out nocopy NUMBER
2665: , p7_a0 NUMBER := 0-1962.0724
3155: , p_commit VARCHAR2
3156: , x_return_status out nocopy VARCHAR2
3157: , x_msg_count out nocopy NUMBER
3158: , x_msg_data out nocopy VARCHAR2
3159: , p7_a0 JTF_NUMBER_TABLE
3160: , p7_a1 JTF_NUMBER_TABLE
3161: , p7_a2 JTF_NUMBER_TABLE
3162: , p7_a3 JTF_NUMBER_TABLE
3163: , p7_a4 JTF_VARCHAR2_TABLE_100
3156: , x_return_status out nocopy VARCHAR2
3157: , x_msg_count out nocopy NUMBER
3158: , x_msg_data out nocopy VARCHAR2
3159: , p7_a0 JTF_NUMBER_TABLE
3160: , p7_a1 JTF_NUMBER_TABLE
3161: , p7_a2 JTF_NUMBER_TABLE
3162: , p7_a3 JTF_NUMBER_TABLE
3163: , p7_a4 JTF_VARCHAR2_TABLE_100
3164: , p7_a5 JTF_VARCHAR2_TABLE_100
3157: , x_msg_count out nocopy NUMBER
3158: , x_msg_data out nocopy VARCHAR2
3159: , p7_a0 JTF_NUMBER_TABLE
3160: , p7_a1 JTF_NUMBER_TABLE
3161: , p7_a2 JTF_NUMBER_TABLE
3162: , p7_a3 JTF_NUMBER_TABLE
3163: , p7_a4 JTF_VARCHAR2_TABLE_100
3164: , p7_a5 JTF_VARCHAR2_TABLE_100
3165: , p7_a6 JTF_VARCHAR2_TABLE_100
3158: , x_msg_data out nocopy VARCHAR2
3159: , p7_a0 JTF_NUMBER_TABLE
3160: , p7_a1 JTF_NUMBER_TABLE
3161: , p7_a2 JTF_NUMBER_TABLE
3162: , p7_a3 JTF_NUMBER_TABLE
3163: , p7_a4 JTF_VARCHAR2_TABLE_100
3164: , p7_a5 JTF_VARCHAR2_TABLE_100
3165: , p7_a6 JTF_VARCHAR2_TABLE_100
3166: , p7_a7 JTF_NUMBER_TABLE
3162: , p7_a3 JTF_NUMBER_TABLE
3163: , p7_a4 JTF_VARCHAR2_TABLE_100
3164: , p7_a5 JTF_VARCHAR2_TABLE_100
3165: , p7_a6 JTF_VARCHAR2_TABLE_100
3166: , p7_a7 JTF_NUMBER_TABLE
3167: , p7_a8 JTF_VARCHAR2_TABLE_100
3168: , p7_a9 JTF_VARCHAR2_TABLE_100
3169: , p7_a10 JTF_VARCHAR2_TABLE_100
3170: , p7_a11 JTF_VARCHAR2_TABLE_100
3167: , p7_a8 JTF_VARCHAR2_TABLE_100
3168: , p7_a9 JTF_VARCHAR2_TABLE_100
3169: , p7_a10 JTF_VARCHAR2_TABLE_100
3170: , p7_a11 JTF_VARCHAR2_TABLE_100
3171: , p7_a12 JTF_NUMBER_TABLE
3172: , p7_a13 JTF_NUMBER_TABLE
3173: , p7_a14 JTF_VARCHAR2_TABLE_100
3174: , p7_a15 JTF_NUMBER_TABLE
3175: , p7_a16 JTF_NUMBER_TABLE
3168: , p7_a9 JTF_VARCHAR2_TABLE_100
3169: , p7_a10 JTF_VARCHAR2_TABLE_100
3170: , p7_a11 JTF_VARCHAR2_TABLE_100
3171: , p7_a12 JTF_NUMBER_TABLE
3172: , p7_a13 JTF_NUMBER_TABLE
3173: , p7_a14 JTF_VARCHAR2_TABLE_100
3174: , p7_a15 JTF_NUMBER_TABLE
3175: , p7_a16 JTF_NUMBER_TABLE
3176: , p7_a17 JTF_VARCHAR2_TABLE_300
3170: , p7_a11 JTF_VARCHAR2_TABLE_100
3171: , p7_a12 JTF_NUMBER_TABLE
3172: , p7_a13 JTF_NUMBER_TABLE
3173: , p7_a14 JTF_VARCHAR2_TABLE_100
3174: , p7_a15 JTF_NUMBER_TABLE
3175: , p7_a16 JTF_NUMBER_TABLE
3176: , p7_a17 JTF_VARCHAR2_TABLE_300
3177: , p7_a18 JTF_VARCHAR2_TABLE_2000
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3171: , p7_a12 JTF_NUMBER_TABLE
3172: , p7_a13 JTF_NUMBER_TABLE
3173: , p7_a14 JTF_VARCHAR2_TABLE_100
3174: , p7_a15 JTF_NUMBER_TABLE
3175: , p7_a16 JTF_NUMBER_TABLE
3176: , p7_a17 JTF_VARCHAR2_TABLE_300
3177: , p7_a18 JTF_VARCHAR2_TABLE_2000
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3175: , p7_a16 JTF_NUMBER_TABLE
3176: , p7_a17 JTF_VARCHAR2_TABLE_300
3177: , p7_a18 JTF_VARCHAR2_TABLE_2000
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3180: , p8_a0 JTF_NUMBER_TABLE
3181: , p8_a1 JTF_NUMBER_TABLE
3182: , p8_a2 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3176: , p7_a17 JTF_VARCHAR2_TABLE_300
3177: , p7_a18 JTF_VARCHAR2_TABLE_2000
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3180: , p8_a0 JTF_NUMBER_TABLE
3181: , p8_a1 JTF_NUMBER_TABLE
3182: , p8_a2 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3184: , p8_a4 JTF_VARCHAR2_TABLE_100
3177: , p7_a18 JTF_VARCHAR2_TABLE_2000
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3180: , p8_a0 JTF_NUMBER_TABLE
3181: , p8_a1 JTF_NUMBER_TABLE
3182: , p8_a2 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3184: , p8_a4 JTF_VARCHAR2_TABLE_100
3185: , p8_a5 JTF_VARCHAR2_TABLE_100
3178: , p7_a19 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3180: , p8_a0 JTF_NUMBER_TABLE
3181: , p8_a1 JTF_NUMBER_TABLE
3182: , p8_a2 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3184: , p8_a4 JTF_VARCHAR2_TABLE_100
3185: , p8_a5 JTF_VARCHAR2_TABLE_100
3186: , p8_a6 JTF_VARCHAR2_TABLE_100
3179: , p7_a20 JTF_NUMBER_TABLE
3180: , p8_a0 JTF_NUMBER_TABLE
3181: , p8_a1 JTF_NUMBER_TABLE
3182: , p8_a2 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3184: , p8_a4 JTF_VARCHAR2_TABLE_100
3185: , p8_a5 JTF_VARCHAR2_TABLE_100
3186: , p8_a6 JTF_VARCHAR2_TABLE_100
3187: , p8_a7 JTF_NUMBER_TABLE
3183: , p8_a3 JTF_NUMBER_TABLE
3184: , p8_a4 JTF_VARCHAR2_TABLE_100
3185: , p8_a5 JTF_VARCHAR2_TABLE_100
3186: , p8_a6 JTF_VARCHAR2_TABLE_100
3187: , p8_a7 JTF_NUMBER_TABLE
3188: , p8_a8 JTF_VARCHAR2_TABLE_100
3189: , p8_a9 JTF_VARCHAR2_TABLE_100
3190: , p8_a10 JTF_VARCHAR2_TABLE_100
3191: , p8_a11 JTF_VARCHAR2_TABLE_100
3188: , p8_a8 JTF_VARCHAR2_TABLE_100
3189: , p8_a9 JTF_VARCHAR2_TABLE_100
3190: , p8_a10 JTF_VARCHAR2_TABLE_100
3191: , p8_a11 JTF_VARCHAR2_TABLE_100
3192: , p8_a12 JTF_NUMBER_TABLE
3193: , p8_a13 JTF_NUMBER_TABLE
3194: , p8_a14 JTF_VARCHAR2_TABLE_100
3195: , p8_a15 JTF_NUMBER_TABLE
3196: , p8_a16 JTF_NUMBER_TABLE
3189: , p8_a9 JTF_VARCHAR2_TABLE_100
3190: , p8_a10 JTF_VARCHAR2_TABLE_100
3191: , p8_a11 JTF_VARCHAR2_TABLE_100
3192: , p8_a12 JTF_NUMBER_TABLE
3193: , p8_a13 JTF_NUMBER_TABLE
3194: , p8_a14 JTF_VARCHAR2_TABLE_100
3195: , p8_a15 JTF_NUMBER_TABLE
3196: , p8_a16 JTF_NUMBER_TABLE
3197: , p8_a17 JTF_VARCHAR2_TABLE_300
3191: , p8_a11 JTF_VARCHAR2_TABLE_100
3192: , p8_a12 JTF_NUMBER_TABLE
3193: , p8_a13 JTF_NUMBER_TABLE
3194: , p8_a14 JTF_VARCHAR2_TABLE_100
3195: , p8_a15 JTF_NUMBER_TABLE
3196: , p8_a16 JTF_NUMBER_TABLE
3197: , p8_a17 JTF_VARCHAR2_TABLE_300
3198: , p8_a18 JTF_VARCHAR2_TABLE_2000
3199: , p8_a19 JTF_VARCHAR2_TABLE_100
3192: , p8_a12 JTF_NUMBER_TABLE
3193: , p8_a13 JTF_NUMBER_TABLE
3194: , p8_a14 JTF_VARCHAR2_TABLE_100
3195: , p8_a15 JTF_NUMBER_TABLE
3196: , p8_a16 JTF_NUMBER_TABLE
3197: , p8_a17 JTF_VARCHAR2_TABLE_300
3198: , p8_a18 JTF_VARCHAR2_TABLE_2000
3199: , p8_a19 JTF_VARCHAR2_TABLE_100
3200: , p8_a20 JTF_NUMBER_TABLE
3196: , p8_a16 JTF_NUMBER_TABLE
3197: , p8_a17 JTF_VARCHAR2_TABLE_300
3198: , p8_a18 JTF_VARCHAR2_TABLE_2000
3199: , p8_a19 JTF_VARCHAR2_TABLE_100
3200: , p8_a20 JTF_NUMBER_TABLE
3201: , p9_a0 JTF_NUMBER_TABLE
3202: , p9_a1 JTF_VARCHAR2_TABLE_100
3203: , p9_a2 JTF_NUMBER_TABLE
3204: , p9_a3 JTF_NUMBER_TABLE
3197: , p8_a17 JTF_VARCHAR2_TABLE_300
3198: , p8_a18 JTF_VARCHAR2_TABLE_2000
3199: , p8_a19 JTF_VARCHAR2_TABLE_100
3200: , p8_a20 JTF_NUMBER_TABLE
3201: , p9_a0 JTF_NUMBER_TABLE
3202: , p9_a1 JTF_VARCHAR2_TABLE_100
3203: , p9_a2 JTF_NUMBER_TABLE
3204: , p9_a3 JTF_NUMBER_TABLE
3205: , p9_a4 JTF_NUMBER_TABLE
3199: , p8_a19 JTF_VARCHAR2_TABLE_100
3200: , p8_a20 JTF_NUMBER_TABLE
3201: , p9_a0 JTF_NUMBER_TABLE
3202: , p9_a1 JTF_VARCHAR2_TABLE_100
3203: , p9_a2 JTF_NUMBER_TABLE
3204: , p9_a3 JTF_NUMBER_TABLE
3205: , p9_a4 JTF_NUMBER_TABLE
3206: , p9_a5 JTF_VARCHAR2_TABLE_100
3207: , p9_a6 JTF_VARCHAR2_TABLE_100
3200: , p8_a20 JTF_NUMBER_TABLE
3201: , p9_a0 JTF_NUMBER_TABLE
3202: , p9_a1 JTF_VARCHAR2_TABLE_100
3203: , p9_a2 JTF_NUMBER_TABLE
3204: , p9_a3 JTF_NUMBER_TABLE
3205: , p9_a4 JTF_NUMBER_TABLE
3206: , p9_a5 JTF_VARCHAR2_TABLE_100
3207: , p9_a6 JTF_VARCHAR2_TABLE_100
3208: , p9_a7 JTF_VARCHAR2_TABLE_300
3201: , p9_a0 JTF_NUMBER_TABLE
3202: , p9_a1 JTF_VARCHAR2_TABLE_100
3203: , p9_a2 JTF_NUMBER_TABLE
3204: , p9_a3 JTF_NUMBER_TABLE
3205: , p9_a4 JTF_NUMBER_TABLE
3206: , p9_a5 JTF_VARCHAR2_TABLE_100
3207: , p9_a6 JTF_VARCHAR2_TABLE_100
3208: , p9_a7 JTF_VARCHAR2_TABLE_300
3209: , p9_a8 JTF_VARCHAR2_TABLE_100
3208: , p9_a7 JTF_VARCHAR2_TABLE_300
3209: , p9_a8 JTF_VARCHAR2_TABLE_100
3210: , p9_a9 JTF_VARCHAR2_TABLE_100
3211: , p9_a10 JTF_VARCHAR2_TABLE_100
3212: , p9_a11 JTF_NUMBER_TABLE
3213: , p10_a0 JTF_VARCHAR2_TABLE_100
3214: , p10_a1 JTF_VARCHAR2_TABLE_100
3215: , p10_a2 JTF_VARCHAR2_TABLE_300
3216: , p10_a3 JTF_VARCHAR2_TABLE_300
3214: , p10_a1 JTF_VARCHAR2_TABLE_100
3215: , p10_a2 JTF_VARCHAR2_TABLE_300
3216: , p10_a3 JTF_VARCHAR2_TABLE_300
3217: , p10_a4 JTF_VARCHAR2_TABLE_100
3218: , p10_a5 JTF_NUMBER_TABLE
3219: , p10_a6 JTF_NUMBER_TABLE
3220: , p10_a7 JTF_NUMBER_TABLE
3221: , p10_a8 JTF_NUMBER_TABLE
3222: , p10_a9 JTF_DATE_TABLE
3215: , p10_a2 JTF_VARCHAR2_TABLE_300
3216: , p10_a3 JTF_VARCHAR2_TABLE_300
3217: , p10_a4 JTF_VARCHAR2_TABLE_100
3218: , p10_a5 JTF_NUMBER_TABLE
3219: , p10_a6 JTF_NUMBER_TABLE
3220: , p10_a7 JTF_NUMBER_TABLE
3221: , p10_a8 JTF_NUMBER_TABLE
3222: , p10_a9 JTF_DATE_TABLE
3223: , p10_a10 JTF_DATE_TABLE
3216: , p10_a3 JTF_VARCHAR2_TABLE_300
3217: , p10_a4 JTF_VARCHAR2_TABLE_100
3218: , p10_a5 JTF_NUMBER_TABLE
3219: , p10_a6 JTF_NUMBER_TABLE
3220: , p10_a7 JTF_NUMBER_TABLE
3221: , p10_a8 JTF_NUMBER_TABLE
3222: , p10_a9 JTF_DATE_TABLE
3223: , p10_a10 JTF_DATE_TABLE
3224: , p10_a11 JTF_NUMBER_TABLE
3217: , p10_a4 JTF_VARCHAR2_TABLE_100
3218: , p10_a5 JTF_NUMBER_TABLE
3219: , p10_a6 JTF_NUMBER_TABLE
3220: , p10_a7 JTF_NUMBER_TABLE
3221: , p10_a8 JTF_NUMBER_TABLE
3222: , p10_a9 JTF_DATE_TABLE
3223: , p10_a10 JTF_DATE_TABLE
3224: , p10_a11 JTF_NUMBER_TABLE
3225: , p10_a12 JTF_VARCHAR2_TABLE_100
3220: , p10_a7 JTF_NUMBER_TABLE
3221: , p10_a8 JTF_NUMBER_TABLE
3222: , p10_a9 JTF_DATE_TABLE
3223: , p10_a10 JTF_DATE_TABLE
3224: , p10_a11 JTF_NUMBER_TABLE
3225: , p10_a12 JTF_VARCHAR2_TABLE_100
3226: , p10_a13 JTF_VARCHAR2_TABLE_100
3227: , p10_a14 JTF_VARCHAR2_TABLE_300
3228: , p10_a15 JTF_VARCHAR2_TABLE_300
3238: , p10_a25 JTF_VARCHAR2_TABLE_300
3239: , p10_a26 JTF_VARCHAR2_TABLE_300
3240: , p10_a27 JTF_VARCHAR2_TABLE_300
3241: , p10_a28 JTF_VARCHAR2_TABLE_300
3242: , p11_a0 JTF_NUMBER_TABLE
3243: , p11_a1 JTF_NUMBER_TABLE
3244: , p11_a2 JTF_NUMBER_TABLE
3245: , p11_a3 JTF_NUMBER_TABLE
3246: , p11_a4 JTF_VARCHAR2_TABLE_100
3239: , p10_a26 JTF_VARCHAR2_TABLE_300
3240: , p10_a27 JTF_VARCHAR2_TABLE_300
3241: , p10_a28 JTF_VARCHAR2_TABLE_300
3242: , p11_a0 JTF_NUMBER_TABLE
3243: , p11_a1 JTF_NUMBER_TABLE
3244: , p11_a2 JTF_NUMBER_TABLE
3245: , p11_a3 JTF_NUMBER_TABLE
3246: , p11_a4 JTF_VARCHAR2_TABLE_100
3247: , p11_a5 JTF_NUMBER_TABLE
3240: , p10_a27 JTF_VARCHAR2_TABLE_300
3241: , p10_a28 JTF_VARCHAR2_TABLE_300
3242: , p11_a0 JTF_NUMBER_TABLE
3243: , p11_a1 JTF_NUMBER_TABLE
3244: , p11_a2 JTF_NUMBER_TABLE
3245: , p11_a3 JTF_NUMBER_TABLE
3246: , p11_a4 JTF_VARCHAR2_TABLE_100
3247: , p11_a5 JTF_NUMBER_TABLE
3248: , p11_a6 JTF_VARCHAR2_TABLE_100
3241: , p10_a28 JTF_VARCHAR2_TABLE_300
3242: , p11_a0 JTF_NUMBER_TABLE
3243: , p11_a1 JTF_NUMBER_TABLE
3244: , p11_a2 JTF_NUMBER_TABLE
3245: , p11_a3 JTF_NUMBER_TABLE
3246: , p11_a4 JTF_VARCHAR2_TABLE_100
3247: , p11_a5 JTF_NUMBER_TABLE
3248: , p11_a6 JTF_VARCHAR2_TABLE_100
3249: , p11_a7 JTF_VARCHAR2_TABLE_100
3243: , p11_a1 JTF_NUMBER_TABLE
3244: , p11_a2 JTF_NUMBER_TABLE
3245: , p11_a3 JTF_NUMBER_TABLE
3246: , p11_a4 JTF_VARCHAR2_TABLE_100
3247: , p11_a5 JTF_NUMBER_TABLE
3248: , p11_a6 JTF_VARCHAR2_TABLE_100
3249: , p11_a7 JTF_VARCHAR2_TABLE_100
3250: , p11_a8 JTF_VARCHAR2_TABLE_100
3251: , p11_a9 JTF_NUMBER_TABLE
3247: , p11_a5 JTF_NUMBER_TABLE
3248: , p11_a6 JTF_VARCHAR2_TABLE_100
3249: , p11_a7 JTF_VARCHAR2_TABLE_100
3250: , p11_a8 JTF_VARCHAR2_TABLE_100
3251: , p11_a9 JTF_NUMBER_TABLE
3252: , p11_a10 JTF_NUMBER_TABLE
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3248: , p11_a6 JTF_VARCHAR2_TABLE_100
3249: , p11_a7 JTF_VARCHAR2_TABLE_100
3250: , p11_a8 JTF_VARCHAR2_TABLE_100
3251: , p11_a9 JTF_NUMBER_TABLE
3252: , p11_a10 JTF_NUMBER_TABLE
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3256: , p12_a1 JTF_NUMBER_TABLE
3249: , p11_a7 JTF_VARCHAR2_TABLE_100
3250: , p11_a8 JTF_VARCHAR2_TABLE_100
3251: , p11_a9 JTF_NUMBER_TABLE
3252: , p11_a10 JTF_NUMBER_TABLE
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3256: , p12_a1 JTF_NUMBER_TABLE
3257: , p12_a2 JTF_NUMBER_TABLE
3251: , p11_a9 JTF_NUMBER_TABLE
3252: , p11_a10 JTF_NUMBER_TABLE
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3256: , p12_a1 JTF_NUMBER_TABLE
3257: , p12_a2 JTF_NUMBER_TABLE
3258: , p12_a3 JTF_VARCHAR2_TABLE_100
3259: , x_qp_list_header_id out nocopy NUMBER
3252: , p11_a10 JTF_NUMBER_TABLE
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3256: , p12_a1 JTF_NUMBER_TABLE
3257: , p12_a2 JTF_NUMBER_TABLE
3258: , p12_a3 JTF_VARCHAR2_TABLE_100
3259: , x_qp_list_header_id out nocopy NUMBER
3260: , x_error_location out nocopy NUMBER
3253: , p11_a11 JTF_NUMBER_TABLE
3254: , p11_a12 JTF_VARCHAR2_TABLE_100
3255: , p12_a0 JTF_NUMBER_TABLE
3256: , p12_a1 JTF_NUMBER_TABLE
3257: , p12_a2 JTF_NUMBER_TABLE
3258: , p12_a3 JTF_VARCHAR2_TABLE_100
3259: , x_qp_list_header_id out nocopy NUMBER
3260: , x_error_location out nocopy NUMBER
3261: , p6_a0 NUMBER := 0-1962.0724