1: package body cn_plan_element_pub_w as
2: /* $Header: cnwppes.pls 120.1.12000000.2 2007/10/09 06:28:56 rnagired ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package body cn_plan_element_pub_w as
2: /* $Header: cnwppes.pls 120.1.12000000.2 2007/10/09 06:28:56 rnagired ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: cnwppes.pls 120.1.12000000.2 2007/10/09 06:28:56 rnagired ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
40: , a37 JTF_VARCHAR2_TABLE_200
41: , a38 JTF_VARCHAR2_TABLE_200
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin
41: , a38 JTF_VARCHAR2_TABLE_200
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if a0 is not null and a0.count > 0 then
102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p2;
106: procedure rosetta_table_copy_out_p2(t cn_plan_element_pub.plan_element_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_VARCHAR2_TABLE_1900
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
104: end if;
105: end rosetta_table_copy_in_p2;
106: procedure rosetta_table_copy_out_p2(t cn_plan_element_pub.plan_element_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_VARCHAR2_TABLE_1900
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
105: end rosetta_table_copy_in_p2;
106: procedure rosetta_table_copy_out_p2(t cn_plan_element_pub.plan_element_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_VARCHAR2_TABLE_1900
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_VARCHAR2_TABLE_1900
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_NUMBER_TABLE
117: , a11 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_NUMBER_TABLE
117: , a11 out nocopy JTF_NUMBER_TABLE
118: , a12 out nocopy JTF_DATE_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_100
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_NUMBER_TABLE
117: , a11 out nocopy JTF_NUMBER_TABLE
118: , a12 out nocopy JTF_DATE_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
116: , a10 out nocopy JTF_NUMBER_TABLE
117: , a11 out nocopy JTF_NUMBER_TABLE
118: , a12 out nocopy JTF_DATE_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_VARCHAR2_TABLE_100
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
117: , a11 out nocopy JTF_NUMBER_TABLE
118: , a12 out nocopy JTF_DATE_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_VARCHAR2_TABLE_100
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
118: , a12 out nocopy JTF_DATE_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_VARCHAR2_TABLE_100
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_VARCHAR2_TABLE_100
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
127: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a14 out nocopy JTF_VARCHAR2_TABLE_100
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
127: , a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
127: , a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , a24 out nocopy JTF_VARCHAR2_TABLE_200
131: , a25 out nocopy JTF_VARCHAR2_TABLE_200
124: , a18 out nocopy JTF_VARCHAR2_TABLE_100
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
127: , a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , a24 out nocopy JTF_VARCHAR2_TABLE_200
131: , a25 out nocopy JTF_VARCHAR2_TABLE_200
132: , a26 out nocopy JTF_VARCHAR2_TABLE_200
125: , a19 out nocopy JTF_NUMBER_TABLE
126: , a20 out nocopy JTF_NUMBER_TABLE
127: , a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , a24 out nocopy JTF_VARCHAR2_TABLE_200
131: , a25 out nocopy JTF_VARCHAR2_TABLE_200
132: , a26 out nocopy JTF_VARCHAR2_TABLE_200
133: , a27 out nocopy JTF_VARCHAR2_TABLE_200
143: , a37 out nocopy JTF_VARCHAR2_TABLE_200
144: , a38 out nocopy JTF_VARCHAR2_TABLE_200
145: , a39 out nocopy JTF_NUMBER_TABLE
146: , a40 out nocopy JTF_NUMBER_TABLE
147: , a41 out nocopy JTF_VARCHAR2_TABLE_100
148: , a42 out nocopy JTF_VARCHAR2_TABLE_100
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
144: , a38 out nocopy JTF_VARCHAR2_TABLE_200
145: , a39 out nocopy JTF_NUMBER_TABLE
146: , a40 out nocopy JTF_NUMBER_TABLE
147: , a41 out nocopy JTF_VARCHAR2_TABLE_100
148: , a42 out nocopy JTF_VARCHAR2_TABLE_100
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
152: if t is null or t.count = 0 then
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_1900();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
151: begin
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_1900();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_1900();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_1900();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_DATE_TABLE();
158: a5 := JTF_VARCHAR2_TABLE_100();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_VARCHAR2_TABLE_100();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_DATE_TABLE();
166: a13 := JTF_DATE_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_DATE_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_VARCHAR2_TABLE_100();
168: a15 := JTF_VARCHAR2_TABLE_100();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_DATE_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_VARCHAR2_TABLE_100();
168: a15 := JTF_VARCHAR2_TABLE_100();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
165: a12 := JTF_DATE_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_VARCHAR2_TABLE_100();
168: a15 := JTF_VARCHAR2_TABLE_100();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_VARCHAR2_TABLE_100();
168: a15 := JTF_VARCHAR2_TABLE_100();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
174: a21 := JTF_VARCHAR2_TABLE_100();
167: a14 := JTF_VARCHAR2_TABLE_100();
168: a15 := JTF_VARCHAR2_TABLE_100();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
174: a21 := JTF_VARCHAR2_TABLE_100();
175: a22 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_100();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
174: a21 := JTF_VARCHAR2_TABLE_100();
175: a22 := JTF_VARCHAR2_TABLE_100();
176: a23 := JTF_VARCHAR2_TABLE_100();
177: a24 := JTF_VARCHAR2_TABLE_200();
178: a25 := JTF_VARCHAR2_TABLE_200();
171: a18 := JTF_VARCHAR2_TABLE_100();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
174: a21 := JTF_VARCHAR2_TABLE_100();
175: a22 := JTF_VARCHAR2_TABLE_100();
176: a23 := JTF_VARCHAR2_TABLE_100();
177: a24 := JTF_VARCHAR2_TABLE_200();
178: a25 := JTF_VARCHAR2_TABLE_200();
179: a26 := JTF_VARCHAR2_TABLE_200();
172: a19 := JTF_NUMBER_TABLE();
173: a20 := JTF_NUMBER_TABLE();
174: a21 := JTF_VARCHAR2_TABLE_100();
175: a22 := JTF_VARCHAR2_TABLE_100();
176: a23 := JTF_VARCHAR2_TABLE_100();
177: a24 := JTF_VARCHAR2_TABLE_200();
178: a25 := JTF_VARCHAR2_TABLE_200();
179: a26 := JTF_VARCHAR2_TABLE_200();
180: a27 := JTF_VARCHAR2_TABLE_200();
190: a37 := JTF_VARCHAR2_TABLE_200();
191: a38 := JTF_VARCHAR2_TABLE_200();
192: a39 := JTF_NUMBER_TABLE();
193: a40 := JTF_NUMBER_TABLE();
194: a41 := JTF_VARCHAR2_TABLE_100();
195: a42 := JTF_VARCHAR2_TABLE_100();
196: else
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
191: a38 := JTF_VARCHAR2_TABLE_200();
192: a39 := JTF_NUMBER_TABLE();
193: a40 := JTF_NUMBER_TABLE();
194: a41 := JTF_VARCHAR2_TABLE_100();
195: a42 := JTF_VARCHAR2_TABLE_100();
196: else
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
199: a2 := JTF_VARCHAR2_TABLE_100();
193: a40 := JTF_NUMBER_TABLE();
194: a41 := JTF_VARCHAR2_TABLE_100();
195: a42 := JTF_VARCHAR2_TABLE_100();
196: else
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
199: a2 := JTF_VARCHAR2_TABLE_100();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
195: a42 := JTF_VARCHAR2_TABLE_100();
196: else
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
199: a2 := JTF_VARCHAR2_TABLE_100();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
196: else
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
199: a2 := JTF_VARCHAR2_TABLE_100();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_VARCHAR2_TABLE_1900();
199: a2 := JTF_VARCHAR2_TABLE_100();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_VARCHAR2_TABLE_100();
206: a9 := JTF_VARCHAR2_TABLE_100();
199: a2 := JTF_VARCHAR2_TABLE_100();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_VARCHAR2_TABLE_100();
206: a9 := JTF_VARCHAR2_TABLE_100();
207: a10 := JTF_NUMBER_TABLE();
200: a3 := JTF_VARCHAR2_TABLE_100();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_VARCHAR2_TABLE_100();
206: a9 := JTF_VARCHAR2_TABLE_100();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_VARCHAR2_TABLE_100();
206: a9 := JTF_VARCHAR2_TABLE_100();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: a12 := JTF_DATE_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_100();
203: a6 := JTF_VARCHAR2_TABLE_100();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_VARCHAR2_TABLE_100();
206: a9 := JTF_VARCHAR2_TABLE_100();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: a12 := JTF_DATE_TABLE();
210: a13 := JTF_DATE_TABLE();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: a12 := JTF_DATE_TABLE();
210: a13 := JTF_DATE_TABLE();
211: a14 := JTF_VARCHAR2_TABLE_100();
212: a15 := JTF_VARCHAR2_TABLE_100();
213: a16 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
208: a11 := JTF_NUMBER_TABLE();
209: a12 := JTF_DATE_TABLE();
210: a13 := JTF_DATE_TABLE();
211: a14 := JTF_VARCHAR2_TABLE_100();
212: a15 := JTF_VARCHAR2_TABLE_100();
213: a16 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
209: a12 := JTF_DATE_TABLE();
210: a13 := JTF_DATE_TABLE();
211: a14 := JTF_VARCHAR2_TABLE_100();
212: a15 := JTF_VARCHAR2_TABLE_100();
213: a16 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
210: a13 := JTF_DATE_TABLE();
211: a14 := JTF_VARCHAR2_TABLE_100();
212: a15 := JTF_VARCHAR2_TABLE_100();
213: a16 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
218: a21 := JTF_VARCHAR2_TABLE_100();
211: a14 := JTF_VARCHAR2_TABLE_100();
212: a15 := JTF_VARCHAR2_TABLE_100();
213: a16 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
218: a21 := JTF_VARCHAR2_TABLE_100();
219: a22 := JTF_VARCHAR2_TABLE_100();
214: a17 := JTF_VARCHAR2_TABLE_100();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
218: a21 := JTF_VARCHAR2_TABLE_100();
219: a22 := JTF_VARCHAR2_TABLE_100();
220: a23 := JTF_VARCHAR2_TABLE_100();
221: a24 := JTF_VARCHAR2_TABLE_200();
222: a25 := JTF_VARCHAR2_TABLE_200();
215: a18 := JTF_VARCHAR2_TABLE_100();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
218: a21 := JTF_VARCHAR2_TABLE_100();
219: a22 := JTF_VARCHAR2_TABLE_100();
220: a23 := JTF_VARCHAR2_TABLE_100();
221: a24 := JTF_VARCHAR2_TABLE_200();
222: a25 := JTF_VARCHAR2_TABLE_200();
223: a26 := JTF_VARCHAR2_TABLE_200();
216: a19 := JTF_NUMBER_TABLE();
217: a20 := JTF_NUMBER_TABLE();
218: a21 := JTF_VARCHAR2_TABLE_100();
219: a22 := JTF_VARCHAR2_TABLE_100();
220: a23 := JTF_VARCHAR2_TABLE_100();
221: a24 := JTF_VARCHAR2_TABLE_200();
222: a25 := JTF_VARCHAR2_TABLE_200();
223: a26 := JTF_VARCHAR2_TABLE_200();
224: a27 := JTF_VARCHAR2_TABLE_200();
234: a37 := JTF_VARCHAR2_TABLE_200();
235: a38 := JTF_VARCHAR2_TABLE_200();
236: a39 := JTF_NUMBER_TABLE();
237: a40 := JTF_NUMBER_TABLE();
238: a41 := JTF_VARCHAR2_TABLE_100();
239: a42 := JTF_VARCHAR2_TABLE_100();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);
235: a38 := JTF_VARCHAR2_TABLE_200();
236: a39 := JTF_NUMBER_TABLE();
237: a40 := JTF_NUMBER_TABLE();
238: a41 := JTF_VARCHAR2_TABLE_100();
239: a42 := JTF_VARCHAR2_TABLE_100();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);
243: a2.extend(t.count);
336: end if;
337: end if;
338: end rosetta_table_copy_out_p2;
339:
340: procedure rosetta_table_copy_in_p5(t out nocopy cn_plan_element_pub.period_quotas_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_NUMBER_TABLE
343: , a3 JTF_NUMBER_TABLE
344: , a4 JTF_VARCHAR2_TABLE_200
355: , a15 JTF_VARCHAR2_TABLE_200
356: , a16 JTF_VARCHAR2_TABLE_200
357: , a17 JTF_VARCHAR2_TABLE_200
358: , a18 JTF_VARCHAR2_TABLE_200
359: , a19 JTF_VARCHAR2_TABLE_100
360: , a20 JTF_NUMBER_TABLE
361: ) as
362: ddindx binary_integer; indx binary_integer;
363: begin
395: end loop;
396: end if;
397: end if;
398: end rosetta_table_copy_in_p5;
399: procedure rosetta_table_copy_out_p5(t cn_plan_element_pub.period_quotas_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_NUMBER_TABLE
402: , a3 out nocopy JTF_NUMBER_TABLE
403: , a4 out nocopy JTF_VARCHAR2_TABLE_200
414: , a15 out nocopy JTF_VARCHAR2_TABLE_200
415: , a16 out nocopy JTF_VARCHAR2_TABLE_200
416: , a17 out nocopy JTF_VARCHAR2_TABLE_200
417: , a18 out nocopy JTF_VARCHAR2_TABLE_200
418: , a19 out nocopy JTF_VARCHAR2_TABLE_100
419: , a20 out nocopy JTF_NUMBER_TABLE
420: ) as
421: ddindx binary_integer; indx binary_integer;
422: begin
420: ) as
421: ddindx binary_integer; indx binary_integer;
422: begin
423: if t is null or t.count = 0 then
424: a0 := JTF_VARCHAR2_TABLE_100();
425: a1 := JTF_NUMBER_TABLE();
426: a2 := JTF_NUMBER_TABLE();
427: a3 := JTF_NUMBER_TABLE();
428: a4 := JTF_VARCHAR2_TABLE_200();
439: a15 := JTF_VARCHAR2_TABLE_200();
440: a16 := JTF_VARCHAR2_TABLE_200();
441: a17 := JTF_VARCHAR2_TABLE_200();
442: a18 := JTF_VARCHAR2_TABLE_200();
443: a19 := JTF_VARCHAR2_TABLE_100();
444: a20 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_VARCHAR2_TABLE_100();
447: a1 := JTF_NUMBER_TABLE();
442: a18 := JTF_VARCHAR2_TABLE_200();
443: a19 := JTF_VARCHAR2_TABLE_100();
444: a20 := JTF_NUMBER_TABLE();
445: else
446: a0 := JTF_VARCHAR2_TABLE_100();
447: a1 := JTF_NUMBER_TABLE();
448: a2 := JTF_NUMBER_TABLE();
449: a3 := JTF_NUMBER_TABLE();
450: a4 := JTF_VARCHAR2_TABLE_200();
461: a15 := JTF_VARCHAR2_TABLE_200();
462: a16 := JTF_VARCHAR2_TABLE_200();
463: a17 := JTF_VARCHAR2_TABLE_200();
464: a18 := JTF_VARCHAR2_TABLE_200();
465: a19 := JTF_VARCHAR2_TABLE_100();
466: a20 := JTF_NUMBER_TABLE();
467: if t.count > 0 then
468: a0.extend(t.count);
469: a1.extend(t.count);
519: end if;
520: end if;
521: end rosetta_table_copy_out_p5;
522:
523: procedure rosetta_table_copy_in_p8(t out nocopy cn_plan_element_pub.revenue_class_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
524: , a1 JTF_NUMBER_TABLE
525: , a2 JTF_NUMBER_TABLE
526: , a3 JTF_NUMBER_TABLE
527: , a4 JTF_VARCHAR2_TABLE_1900
524: , a1 JTF_NUMBER_TABLE
525: , a2 JTF_NUMBER_TABLE
526: , a3 JTF_NUMBER_TABLE
527: , a4 JTF_VARCHAR2_TABLE_1900
528: , a5 JTF_VARCHAR2_TABLE_100
529: , a6 JTF_VARCHAR2_TABLE_200
530: , a7 JTF_VARCHAR2_TABLE_200
531: , a8 JTF_VARCHAR2_TABLE_200
532: , a9 JTF_VARCHAR2_TABLE_200
540: , a17 JTF_VARCHAR2_TABLE_200
541: , a18 JTF_VARCHAR2_TABLE_200
542: , a19 JTF_VARCHAR2_TABLE_200
543: , a20 JTF_VARCHAR2_TABLE_200
544: , a21 JTF_VARCHAR2_TABLE_100
545: , a22 JTF_NUMBER_TABLE
546: ) as
547: ddindx binary_integer; indx binary_integer;
548: begin
582: end loop;
583: end if;
584: end if;
585: end rosetta_table_copy_in_p8;
586: procedure rosetta_table_copy_out_p8(t cn_plan_element_pub.revenue_class_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
587: , a1 out nocopy JTF_NUMBER_TABLE
588: , a2 out nocopy JTF_NUMBER_TABLE
589: , a3 out nocopy JTF_NUMBER_TABLE
590: , a4 out nocopy JTF_VARCHAR2_TABLE_1900
587: , a1 out nocopy JTF_NUMBER_TABLE
588: , a2 out nocopy JTF_NUMBER_TABLE
589: , a3 out nocopy JTF_NUMBER_TABLE
590: , a4 out nocopy JTF_VARCHAR2_TABLE_1900
591: , a5 out nocopy JTF_VARCHAR2_TABLE_100
592: , a6 out nocopy JTF_VARCHAR2_TABLE_200
593: , a7 out nocopy JTF_VARCHAR2_TABLE_200
594: , a8 out nocopy JTF_VARCHAR2_TABLE_200
595: , a9 out nocopy JTF_VARCHAR2_TABLE_200
603: , a17 out nocopy JTF_VARCHAR2_TABLE_200
604: , a18 out nocopy JTF_VARCHAR2_TABLE_200
605: , a19 out nocopy JTF_VARCHAR2_TABLE_200
606: , a20 out nocopy JTF_VARCHAR2_TABLE_200
607: , a21 out nocopy JTF_VARCHAR2_TABLE_100
608: , a22 out nocopy JTF_NUMBER_TABLE
609: ) as
610: ddindx binary_integer; indx binary_integer;
611: begin
609: ) as
610: ddindx binary_integer; indx binary_integer;
611: begin
612: if t is null or t.count = 0 then
613: a0 := JTF_VARCHAR2_TABLE_100();
614: a1 := JTF_NUMBER_TABLE();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_1900();
614: a1 := JTF_NUMBER_TABLE();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_1900();
618: a5 := JTF_VARCHAR2_TABLE_100();
619: a6 := JTF_VARCHAR2_TABLE_200();
620: a7 := JTF_VARCHAR2_TABLE_200();
621: a8 := JTF_VARCHAR2_TABLE_200();
622: a9 := JTF_VARCHAR2_TABLE_200();
630: a17 := JTF_VARCHAR2_TABLE_200();
631: a18 := JTF_VARCHAR2_TABLE_200();
632: a19 := JTF_VARCHAR2_TABLE_200();
633: a20 := JTF_VARCHAR2_TABLE_200();
634: a21 := JTF_VARCHAR2_TABLE_100();
635: a22 := JTF_NUMBER_TABLE();
636: else
637: a0 := JTF_VARCHAR2_TABLE_100();
638: a1 := JTF_NUMBER_TABLE();
633: a20 := JTF_VARCHAR2_TABLE_200();
634: a21 := JTF_VARCHAR2_TABLE_100();
635: a22 := JTF_NUMBER_TABLE();
636: else
637: a0 := JTF_VARCHAR2_TABLE_100();
638: a1 := JTF_NUMBER_TABLE();
639: a2 := JTF_NUMBER_TABLE();
640: a3 := JTF_NUMBER_TABLE();
641: a4 := JTF_VARCHAR2_TABLE_1900();
638: a1 := JTF_NUMBER_TABLE();
639: a2 := JTF_NUMBER_TABLE();
640: a3 := JTF_NUMBER_TABLE();
641: a4 := JTF_VARCHAR2_TABLE_1900();
642: a5 := JTF_VARCHAR2_TABLE_100();
643: a6 := JTF_VARCHAR2_TABLE_200();
644: a7 := JTF_VARCHAR2_TABLE_200();
645: a8 := JTF_VARCHAR2_TABLE_200();
646: a9 := JTF_VARCHAR2_TABLE_200();
654: a17 := JTF_VARCHAR2_TABLE_200();
655: a18 := JTF_VARCHAR2_TABLE_200();
656: a19 := JTF_VARCHAR2_TABLE_200();
657: a20 := JTF_VARCHAR2_TABLE_200();
658: a21 := JTF_VARCHAR2_TABLE_100();
659: a22 := JTF_NUMBER_TABLE();
660: if t.count > 0 then
661: a0.extend(t.count);
662: a1.extend(t.count);
716: end if;
717: end if;
718: end rosetta_table_copy_out_p8;
719:
720: procedure rosetta_table_copy_in_p11(t out nocopy cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
721: , a1 JTF_DATE_TABLE
722: , a2 JTF_DATE_TABLE
723: , a3 JTF_NUMBER_TABLE
724: , a4 JTF_NUMBER_TABLE
721: , a1 JTF_DATE_TABLE
722: , a2 JTF_DATE_TABLE
723: , a3 JTF_NUMBER_TABLE
724: , a4 JTF_NUMBER_TABLE
725: , a5 JTF_VARCHAR2_TABLE_100
726: , a6 JTF_VARCHAR2_TABLE_200
727: , a7 JTF_VARCHAR2_TABLE_200
728: , a8 JTF_VARCHAR2_TABLE_200
729: , a9 JTF_VARCHAR2_TABLE_200
737: , a17 JTF_VARCHAR2_TABLE_200
738: , a18 JTF_VARCHAR2_TABLE_200
739: , a19 JTF_VARCHAR2_TABLE_200
740: , a20 JTF_VARCHAR2_TABLE_200
741: , a21 JTF_VARCHAR2_TABLE_100
742: , a22 JTF_DATE_TABLE
743: , a23 JTF_DATE_TABLE
744: , a24 JTF_NUMBER_TABLE
745: , a25 JTF_NUMBER_TABLE
785: end loop;
786: end if;
787: end if;
788: end rosetta_table_copy_in_p11;
789: procedure rosetta_table_copy_out_p11(t cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
790: , a1 out nocopy JTF_DATE_TABLE
791: , a2 out nocopy JTF_DATE_TABLE
792: , a3 out nocopy JTF_NUMBER_TABLE
793: , a4 out nocopy JTF_NUMBER_TABLE
790: , a1 out nocopy JTF_DATE_TABLE
791: , a2 out nocopy JTF_DATE_TABLE
792: , a3 out nocopy JTF_NUMBER_TABLE
793: , a4 out nocopy JTF_NUMBER_TABLE
794: , a5 out nocopy JTF_VARCHAR2_TABLE_100
795: , a6 out nocopy JTF_VARCHAR2_TABLE_200
796: , a7 out nocopy JTF_VARCHAR2_TABLE_200
797: , a8 out nocopy JTF_VARCHAR2_TABLE_200
798: , a9 out nocopy JTF_VARCHAR2_TABLE_200
806: , a17 out nocopy JTF_VARCHAR2_TABLE_200
807: , a18 out nocopy JTF_VARCHAR2_TABLE_200
808: , a19 out nocopy JTF_VARCHAR2_TABLE_200
809: , a20 out nocopy JTF_VARCHAR2_TABLE_200
810: , a21 out nocopy JTF_VARCHAR2_TABLE_100
811: , a22 out nocopy JTF_DATE_TABLE
812: , a23 out nocopy JTF_DATE_TABLE
813: , a24 out nocopy JTF_NUMBER_TABLE
814: , a25 out nocopy JTF_NUMBER_TABLE
815: ) as
816: ddindx binary_integer; indx binary_integer;
817: begin
818: if t is null or t.count = 0 then
819: a0 := JTF_VARCHAR2_TABLE_100();
820: a1 := JTF_DATE_TABLE();
821: a2 := JTF_DATE_TABLE();
822: a3 := JTF_NUMBER_TABLE();
823: a4 := JTF_NUMBER_TABLE();
820: a1 := JTF_DATE_TABLE();
821: a2 := JTF_DATE_TABLE();
822: a3 := JTF_NUMBER_TABLE();
823: a4 := JTF_NUMBER_TABLE();
824: a5 := JTF_VARCHAR2_TABLE_100();
825: a6 := JTF_VARCHAR2_TABLE_200();
826: a7 := JTF_VARCHAR2_TABLE_200();
827: a8 := JTF_VARCHAR2_TABLE_200();
828: a9 := JTF_VARCHAR2_TABLE_200();
836: a17 := JTF_VARCHAR2_TABLE_200();
837: a18 := JTF_VARCHAR2_TABLE_200();
838: a19 := JTF_VARCHAR2_TABLE_200();
839: a20 := JTF_VARCHAR2_TABLE_200();
840: a21 := JTF_VARCHAR2_TABLE_100();
841: a22 := JTF_DATE_TABLE();
842: a23 := JTF_DATE_TABLE();
843: a24 := JTF_NUMBER_TABLE();
844: a25 := JTF_NUMBER_TABLE();
842: a23 := JTF_DATE_TABLE();
843: a24 := JTF_NUMBER_TABLE();
844: a25 := JTF_NUMBER_TABLE();
845: else
846: a0 := JTF_VARCHAR2_TABLE_100();
847: a1 := JTF_DATE_TABLE();
848: a2 := JTF_DATE_TABLE();
849: a3 := JTF_NUMBER_TABLE();
850: a4 := JTF_NUMBER_TABLE();
847: a1 := JTF_DATE_TABLE();
848: a2 := JTF_DATE_TABLE();
849: a3 := JTF_NUMBER_TABLE();
850: a4 := JTF_NUMBER_TABLE();
851: a5 := JTF_VARCHAR2_TABLE_100();
852: a6 := JTF_VARCHAR2_TABLE_200();
853: a7 := JTF_VARCHAR2_TABLE_200();
854: a8 := JTF_VARCHAR2_TABLE_200();
855: a9 := JTF_VARCHAR2_TABLE_200();
863: a17 := JTF_VARCHAR2_TABLE_200();
864: a18 := JTF_VARCHAR2_TABLE_200();
865: a19 := JTF_VARCHAR2_TABLE_200();
866: a20 := JTF_VARCHAR2_TABLE_200();
867: a21 := JTF_VARCHAR2_TABLE_100();
868: a22 := JTF_DATE_TABLE();
869: a23 := JTF_DATE_TABLE();
870: a24 := JTF_NUMBER_TABLE();
871: a25 := JTF_NUMBER_TABLE();
934: end if;
935: end if;
936: end rosetta_table_copy_out_p11;
937:
938: procedure rosetta_table_copy_in_p14(t out nocopy cn_plan_element_pub.trx_factor_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
939: , a1 JTF_NUMBER_TABLE
940: , a2 JTF_VARCHAR2_TABLE_100
941: , a3 JTF_NUMBER_TABLE
942: ) as
936: end rosetta_table_copy_out_p11;
937:
938: procedure rosetta_table_copy_in_p14(t out nocopy cn_plan_element_pub.trx_factor_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
939: , a1 JTF_NUMBER_TABLE
940: , a2 JTF_VARCHAR2_TABLE_100
941: , a3 JTF_NUMBER_TABLE
942: ) as
943: ddindx binary_integer; indx binary_integer;
944: begin
959: end loop;
960: end if;
961: end if;
962: end rosetta_table_copy_in_p14;
963: procedure rosetta_table_copy_out_p14(t cn_plan_element_pub.trx_factor_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
964: , a1 out nocopy JTF_NUMBER_TABLE
965: , a2 out nocopy JTF_VARCHAR2_TABLE_100
966: , a3 out nocopy JTF_NUMBER_TABLE
967: ) as
961: end if;
962: end rosetta_table_copy_in_p14;
963: procedure rosetta_table_copy_out_p14(t cn_plan_element_pub.trx_factor_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
964: , a1 out nocopy JTF_NUMBER_TABLE
965: , a2 out nocopy JTF_VARCHAR2_TABLE_100
966: , a3 out nocopy JTF_NUMBER_TABLE
967: ) as
968: ddindx binary_integer; indx binary_integer;
969: begin
967: ) as
968: ddindx binary_integer; indx binary_integer;
969: begin
970: if t is null or t.count = 0 then
971: a0 := JTF_VARCHAR2_TABLE_100();
972: a1 := JTF_NUMBER_TABLE();
973: a2 := JTF_VARCHAR2_TABLE_100();
974: a3 := JTF_NUMBER_TABLE();
975: else
969: begin
970: if t is null or t.count = 0 then
971: a0 := JTF_VARCHAR2_TABLE_100();
972: a1 := JTF_NUMBER_TABLE();
973: a2 := JTF_VARCHAR2_TABLE_100();
974: a3 := JTF_NUMBER_TABLE();
975: else
976: a0 := JTF_VARCHAR2_TABLE_100();
977: a1 := JTF_NUMBER_TABLE();
972: a1 := JTF_NUMBER_TABLE();
973: a2 := JTF_VARCHAR2_TABLE_100();
974: a3 := JTF_NUMBER_TABLE();
975: else
976: a0 := JTF_VARCHAR2_TABLE_100();
977: a1 := JTF_NUMBER_TABLE();
978: a2 := JTF_VARCHAR2_TABLE_100();
979: a3 := JTF_NUMBER_TABLE();
980: if t.count > 0 then
974: a3 := JTF_NUMBER_TABLE();
975: else
976: a0 := JTF_VARCHAR2_TABLE_100();
977: a1 := JTF_NUMBER_TABLE();
978: a2 := JTF_VARCHAR2_TABLE_100();
979: a3 := JTF_NUMBER_TABLE();
980: if t.count > 0 then
981: a0.extend(t.count);
982: a1.extend(t.count);
998: end if;
999: end if;
1000: end rosetta_table_copy_out_p14;
1001:
1002: procedure rosetta_table_copy_in_p18(t out nocopy cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1003: , a1 JTF_VARCHAR2_TABLE_100
1004: , a2 JTF_DATE_TABLE
1005: , a3 JTF_DATE_TABLE
1006: , a4 JTF_VARCHAR2_TABLE_100
999: end if;
1000: end rosetta_table_copy_out_p14;
1001:
1002: procedure rosetta_table_copy_in_p18(t out nocopy cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1003: , a1 JTF_VARCHAR2_TABLE_100
1004: , a2 JTF_DATE_TABLE
1005: , a3 JTF_DATE_TABLE
1006: , a4 JTF_VARCHAR2_TABLE_100
1007: , a5 JTF_VARCHAR2_TABLE_200
1002: procedure rosetta_table_copy_in_p18(t out nocopy cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1003: , a1 JTF_VARCHAR2_TABLE_100
1004: , a2 JTF_DATE_TABLE
1005: , a3 JTF_DATE_TABLE
1006: , a4 JTF_VARCHAR2_TABLE_100
1007: , a5 JTF_VARCHAR2_TABLE_200
1008: , a6 JTF_VARCHAR2_TABLE_200
1009: , a7 JTF_VARCHAR2_TABLE_200
1010: , a8 JTF_VARCHAR2_TABLE_200
1018: , a16 JTF_VARCHAR2_TABLE_200
1019: , a17 JTF_VARCHAR2_TABLE_200
1020: , a18 JTF_VARCHAR2_TABLE_200
1021: , a19 JTF_VARCHAR2_TABLE_200
1022: , a20 JTF_VARCHAR2_TABLE_100
1023: , a21 JTF_DATE_TABLE
1024: , a22 JTF_DATE_TABLE
1025: , a23 JTF_NUMBER_TABLE
1026: ) as
1063: end loop;
1064: end if;
1065: end if;
1066: end rosetta_table_copy_in_p18;
1067: procedure rosetta_table_copy_out_p18(t cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1068: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1069: , a2 out nocopy JTF_DATE_TABLE
1070: , a3 out nocopy JTF_DATE_TABLE
1071: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1064: end if;
1065: end if;
1066: end rosetta_table_copy_in_p18;
1067: procedure rosetta_table_copy_out_p18(t cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1068: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1069: , a2 out nocopy JTF_DATE_TABLE
1070: , a3 out nocopy JTF_DATE_TABLE
1071: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1072: , a5 out nocopy JTF_VARCHAR2_TABLE_200
1067: procedure rosetta_table_copy_out_p18(t cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1068: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1069: , a2 out nocopy JTF_DATE_TABLE
1070: , a3 out nocopy JTF_DATE_TABLE
1071: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1072: , a5 out nocopy JTF_VARCHAR2_TABLE_200
1073: , a6 out nocopy JTF_VARCHAR2_TABLE_200
1074: , a7 out nocopy JTF_VARCHAR2_TABLE_200
1075: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1083: , a16 out nocopy JTF_VARCHAR2_TABLE_200
1084: , a17 out nocopy JTF_VARCHAR2_TABLE_200
1085: , a18 out nocopy JTF_VARCHAR2_TABLE_200
1086: , a19 out nocopy JTF_VARCHAR2_TABLE_200
1087: , a20 out nocopy JTF_VARCHAR2_TABLE_100
1088: , a21 out nocopy JTF_DATE_TABLE
1089: , a22 out nocopy JTF_DATE_TABLE
1090: , a23 out nocopy JTF_NUMBER_TABLE
1091: ) as
1091: ) as
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094: if t is null or t.count = 0 then
1095: a0 := JTF_VARCHAR2_TABLE_100();
1096: a1 := JTF_VARCHAR2_TABLE_100();
1097: a2 := JTF_DATE_TABLE();
1098: a3 := JTF_DATE_TABLE();
1099: a4 := JTF_VARCHAR2_TABLE_100();
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094: if t is null or t.count = 0 then
1095: a0 := JTF_VARCHAR2_TABLE_100();
1096: a1 := JTF_VARCHAR2_TABLE_100();
1097: a2 := JTF_DATE_TABLE();
1098: a3 := JTF_DATE_TABLE();
1099: a4 := JTF_VARCHAR2_TABLE_100();
1100: a5 := JTF_VARCHAR2_TABLE_200();
1095: a0 := JTF_VARCHAR2_TABLE_100();
1096: a1 := JTF_VARCHAR2_TABLE_100();
1097: a2 := JTF_DATE_TABLE();
1098: a3 := JTF_DATE_TABLE();
1099: a4 := JTF_VARCHAR2_TABLE_100();
1100: a5 := JTF_VARCHAR2_TABLE_200();
1101: a6 := JTF_VARCHAR2_TABLE_200();
1102: a7 := JTF_VARCHAR2_TABLE_200();
1103: a8 := JTF_VARCHAR2_TABLE_200();
1111: a16 := JTF_VARCHAR2_TABLE_200();
1112: a17 := JTF_VARCHAR2_TABLE_200();
1113: a18 := JTF_VARCHAR2_TABLE_200();
1114: a19 := JTF_VARCHAR2_TABLE_200();
1115: a20 := JTF_VARCHAR2_TABLE_100();
1116: a21 := JTF_DATE_TABLE();
1117: a22 := JTF_DATE_TABLE();
1118: a23 := JTF_NUMBER_TABLE();
1119: else
1116: a21 := JTF_DATE_TABLE();
1117: a22 := JTF_DATE_TABLE();
1118: a23 := JTF_NUMBER_TABLE();
1119: else
1120: a0 := JTF_VARCHAR2_TABLE_100();
1121: a1 := JTF_VARCHAR2_TABLE_100();
1122: a2 := JTF_DATE_TABLE();
1123: a3 := JTF_DATE_TABLE();
1124: a4 := JTF_VARCHAR2_TABLE_100();
1117: a22 := JTF_DATE_TABLE();
1118: a23 := JTF_NUMBER_TABLE();
1119: else
1120: a0 := JTF_VARCHAR2_TABLE_100();
1121: a1 := JTF_VARCHAR2_TABLE_100();
1122: a2 := JTF_DATE_TABLE();
1123: a3 := JTF_DATE_TABLE();
1124: a4 := JTF_VARCHAR2_TABLE_100();
1125: a5 := JTF_VARCHAR2_TABLE_200();
1120: a0 := JTF_VARCHAR2_TABLE_100();
1121: a1 := JTF_VARCHAR2_TABLE_100();
1122: a2 := JTF_DATE_TABLE();
1123: a3 := JTF_DATE_TABLE();
1124: a4 := JTF_VARCHAR2_TABLE_100();
1125: a5 := JTF_VARCHAR2_TABLE_200();
1126: a6 := JTF_VARCHAR2_TABLE_200();
1127: a7 := JTF_VARCHAR2_TABLE_200();
1128: a8 := JTF_VARCHAR2_TABLE_200();
1136: a16 := JTF_VARCHAR2_TABLE_200();
1137: a17 := JTF_VARCHAR2_TABLE_200();
1138: a18 := JTF_VARCHAR2_TABLE_200();
1139: a19 := JTF_VARCHAR2_TABLE_200();
1140: a20 := JTF_VARCHAR2_TABLE_100();
1141: a21 := JTF_DATE_TABLE();
1142: a22 := JTF_DATE_TABLE();
1143: a23 := JTF_NUMBER_TABLE();
1144: if t.count > 0 then
1252: , p7_a39 NUMBER
1253: , p7_a40 NUMBER
1254: , p7_a41 VARCHAR2
1255: , p7_a42 VARCHAR2
1256: , p8_a0 JTF_VARCHAR2_TABLE_100
1257: , p8_a1 JTF_NUMBER_TABLE
1258: , p8_a2 JTF_NUMBER_TABLE
1259: , p8_a3 JTF_NUMBER_TABLE
1260: , p8_a4 JTF_VARCHAR2_TABLE_1900
1257: , p8_a1 JTF_NUMBER_TABLE
1258: , p8_a2 JTF_NUMBER_TABLE
1259: , p8_a3 JTF_NUMBER_TABLE
1260: , p8_a4 JTF_VARCHAR2_TABLE_1900
1261: , p8_a5 JTF_VARCHAR2_TABLE_100
1262: , p8_a6 JTF_VARCHAR2_TABLE_200
1263: , p8_a7 JTF_VARCHAR2_TABLE_200
1264: , p8_a8 JTF_VARCHAR2_TABLE_200
1265: , p8_a9 JTF_VARCHAR2_TABLE_200
1273: , p8_a17 JTF_VARCHAR2_TABLE_200
1274: , p8_a18 JTF_VARCHAR2_TABLE_200
1275: , p8_a19 JTF_VARCHAR2_TABLE_200
1276: , p8_a20 JTF_VARCHAR2_TABLE_200
1277: , p8_a21 JTF_VARCHAR2_TABLE_100
1278: , p8_a22 JTF_NUMBER_TABLE
1279: , p9_a0 JTF_VARCHAR2_TABLE_100
1280: , p9_a1 JTF_DATE_TABLE
1281: , p9_a2 JTF_DATE_TABLE
1275: , p8_a19 JTF_VARCHAR2_TABLE_200
1276: , p8_a20 JTF_VARCHAR2_TABLE_200
1277: , p8_a21 JTF_VARCHAR2_TABLE_100
1278: , p8_a22 JTF_NUMBER_TABLE
1279: , p9_a0 JTF_VARCHAR2_TABLE_100
1280: , p9_a1 JTF_DATE_TABLE
1281: , p9_a2 JTF_DATE_TABLE
1282: , p9_a3 JTF_NUMBER_TABLE
1283: , p9_a4 JTF_NUMBER_TABLE
1280: , p9_a1 JTF_DATE_TABLE
1281: , p9_a2 JTF_DATE_TABLE
1282: , p9_a3 JTF_NUMBER_TABLE
1283: , p9_a4 JTF_NUMBER_TABLE
1284: , p9_a5 JTF_VARCHAR2_TABLE_100
1285: , p9_a6 JTF_VARCHAR2_TABLE_200
1286: , p9_a7 JTF_VARCHAR2_TABLE_200
1287: , p9_a8 JTF_VARCHAR2_TABLE_200
1288: , p9_a9 JTF_VARCHAR2_TABLE_200
1296: , p9_a17 JTF_VARCHAR2_TABLE_200
1297: , p9_a18 JTF_VARCHAR2_TABLE_200
1298: , p9_a19 JTF_VARCHAR2_TABLE_200
1299: , p9_a20 JTF_VARCHAR2_TABLE_200
1300: , p9_a21 JTF_VARCHAR2_TABLE_100
1301: , p9_a22 JTF_DATE_TABLE
1302: , p9_a23 JTF_DATE_TABLE
1303: , p9_a24 JTF_NUMBER_TABLE
1304: , p9_a25 JTF_NUMBER_TABLE
1301: , p9_a22 JTF_DATE_TABLE
1302: , p9_a23 JTF_DATE_TABLE
1303: , p9_a24 JTF_NUMBER_TABLE
1304: , p9_a25 JTF_NUMBER_TABLE
1305: , p10_a0 JTF_VARCHAR2_TABLE_100
1306: , p10_a1 JTF_NUMBER_TABLE
1307: , p10_a2 JTF_VARCHAR2_TABLE_100
1308: , p10_a3 JTF_NUMBER_TABLE
1309: , p11_a0 JTF_VARCHAR2_TABLE_100
1303: , p9_a24 JTF_NUMBER_TABLE
1304: , p9_a25 JTF_NUMBER_TABLE
1305: , p10_a0 JTF_VARCHAR2_TABLE_100
1306: , p10_a1 JTF_NUMBER_TABLE
1307: , p10_a2 JTF_VARCHAR2_TABLE_100
1308: , p10_a3 JTF_NUMBER_TABLE
1309: , p11_a0 JTF_VARCHAR2_TABLE_100
1310: , p11_a1 JTF_NUMBER_TABLE
1311: , p11_a2 JTF_NUMBER_TABLE
1305: , p10_a0 JTF_VARCHAR2_TABLE_100
1306: , p10_a1 JTF_NUMBER_TABLE
1307: , p10_a2 JTF_VARCHAR2_TABLE_100
1308: , p10_a3 JTF_NUMBER_TABLE
1309: , p11_a0 JTF_VARCHAR2_TABLE_100
1310: , p11_a1 JTF_NUMBER_TABLE
1311: , p11_a2 JTF_NUMBER_TABLE
1312: , p11_a3 JTF_NUMBER_TABLE
1313: , p11_a4 JTF_VARCHAR2_TABLE_200
1324: , p11_a15 JTF_VARCHAR2_TABLE_200
1325: , p11_a16 JTF_VARCHAR2_TABLE_200
1326: , p11_a17 JTF_VARCHAR2_TABLE_200
1327: , p11_a18 JTF_VARCHAR2_TABLE_200
1328: , p11_a19 JTF_VARCHAR2_TABLE_100
1329: , p11_a20 JTF_NUMBER_TABLE
1330: , p12_a0 JTF_VARCHAR2_TABLE_100
1331: , p12_a1 JTF_VARCHAR2_TABLE_100
1332: , p12_a2 JTF_DATE_TABLE
1326: , p11_a17 JTF_VARCHAR2_TABLE_200
1327: , p11_a18 JTF_VARCHAR2_TABLE_200
1328: , p11_a19 JTF_VARCHAR2_TABLE_100
1329: , p11_a20 JTF_NUMBER_TABLE
1330: , p12_a0 JTF_VARCHAR2_TABLE_100
1331: , p12_a1 JTF_VARCHAR2_TABLE_100
1332: , p12_a2 JTF_DATE_TABLE
1333: , p12_a3 JTF_DATE_TABLE
1334: , p12_a4 JTF_VARCHAR2_TABLE_100
1327: , p11_a18 JTF_VARCHAR2_TABLE_200
1328: , p11_a19 JTF_VARCHAR2_TABLE_100
1329: , p11_a20 JTF_NUMBER_TABLE
1330: , p12_a0 JTF_VARCHAR2_TABLE_100
1331: , p12_a1 JTF_VARCHAR2_TABLE_100
1332: , p12_a2 JTF_DATE_TABLE
1333: , p12_a3 JTF_DATE_TABLE
1334: , p12_a4 JTF_VARCHAR2_TABLE_100
1335: , p12_a5 JTF_VARCHAR2_TABLE_200
1330: , p12_a0 JTF_VARCHAR2_TABLE_100
1331: , p12_a1 JTF_VARCHAR2_TABLE_100
1332: , p12_a2 JTF_DATE_TABLE
1333: , p12_a3 JTF_DATE_TABLE
1334: , p12_a4 JTF_VARCHAR2_TABLE_100
1335: , p12_a5 JTF_VARCHAR2_TABLE_200
1336: , p12_a6 JTF_VARCHAR2_TABLE_200
1337: , p12_a7 JTF_VARCHAR2_TABLE_200
1338: , p12_a8 JTF_VARCHAR2_TABLE_200
1346: , p12_a16 JTF_VARCHAR2_TABLE_200
1347: , p12_a17 JTF_VARCHAR2_TABLE_200
1348: , p12_a18 JTF_VARCHAR2_TABLE_200
1349: , p12_a19 JTF_VARCHAR2_TABLE_200
1350: , p12_a20 JTF_VARCHAR2_TABLE_100
1351: , p12_a21 JTF_DATE_TABLE
1352: , p12_a22 JTF_DATE_TABLE
1353: , p12_a23 JTF_NUMBER_TABLE
1354: , x_loading_status out nocopy VARCHAR2
1611: , p7_a40 NUMBER
1612: , p7_a41 VARCHAR2
1613: , p7_a42 VARCHAR2
1614: , p_quota_name_old VARCHAR2
1615: , p9_a0 JTF_VARCHAR2_TABLE_100
1616: , p9_a1 JTF_NUMBER_TABLE
1617: , p9_a2 JTF_NUMBER_TABLE
1618: , p9_a3 JTF_NUMBER_TABLE
1619: , p9_a4 JTF_VARCHAR2_TABLE_1900
1616: , p9_a1 JTF_NUMBER_TABLE
1617: , p9_a2 JTF_NUMBER_TABLE
1618: , p9_a3 JTF_NUMBER_TABLE
1619: , p9_a4 JTF_VARCHAR2_TABLE_1900
1620: , p9_a5 JTF_VARCHAR2_TABLE_100
1621: , p9_a6 JTF_VARCHAR2_TABLE_200
1622: , p9_a7 JTF_VARCHAR2_TABLE_200
1623: , p9_a8 JTF_VARCHAR2_TABLE_200
1624: , p9_a9 JTF_VARCHAR2_TABLE_200
1632: , p9_a17 JTF_VARCHAR2_TABLE_200
1633: , p9_a18 JTF_VARCHAR2_TABLE_200
1634: , p9_a19 JTF_VARCHAR2_TABLE_200
1635: , p9_a20 JTF_VARCHAR2_TABLE_200
1636: , p9_a21 JTF_VARCHAR2_TABLE_100
1637: , p9_a22 JTF_NUMBER_TABLE
1638: , p10_a0 JTF_VARCHAR2_TABLE_100
1639: , p10_a1 JTF_DATE_TABLE
1640: , p10_a2 JTF_DATE_TABLE
1634: , p9_a19 JTF_VARCHAR2_TABLE_200
1635: , p9_a20 JTF_VARCHAR2_TABLE_200
1636: , p9_a21 JTF_VARCHAR2_TABLE_100
1637: , p9_a22 JTF_NUMBER_TABLE
1638: , p10_a0 JTF_VARCHAR2_TABLE_100
1639: , p10_a1 JTF_DATE_TABLE
1640: , p10_a2 JTF_DATE_TABLE
1641: , p10_a3 JTF_NUMBER_TABLE
1642: , p10_a4 JTF_NUMBER_TABLE
1639: , p10_a1 JTF_DATE_TABLE
1640: , p10_a2 JTF_DATE_TABLE
1641: , p10_a3 JTF_NUMBER_TABLE
1642: , p10_a4 JTF_NUMBER_TABLE
1643: , p10_a5 JTF_VARCHAR2_TABLE_100
1644: , p10_a6 JTF_VARCHAR2_TABLE_200
1645: , p10_a7 JTF_VARCHAR2_TABLE_200
1646: , p10_a8 JTF_VARCHAR2_TABLE_200
1647: , p10_a9 JTF_VARCHAR2_TABLE_200
1655: , p10_a17 JTF_VARCHAR2_TABLE_200
1656: , p10_a18 JTF_VARCHAR2_TABLE_200
1657: , p10_a19 JTF_VARCHAR2_TABLE_200
1658: , p10_a20 JTF_VARCHAR2_TABLE_200
1659: , p10_a21 JTF_VARCHAR2_TABLE_100
1660: , p10_a22 JTF_DATE_TABLE
1661: , p10_a23 JTF_DATE_TABLE
1662: , p10_a24 JTF_NUMBER_TABLE
1663: , p10_a25 JTF_NUMBER_TABLE
1660: , p10_a22 JTF_DATE_TABLE
1661: , p10_a23 JTF_DATE_TABLE
1662: , p10_a24 JTF_NUMBER_TABLE
1663: , p10_a25 JTF_NUMBER_TABLE
1664: , p11_a0 JTF_VARCHAR2_TABLE_100
1665: , p11_a1 JTF_NUMBER_TABLE
1666: , p11_a2 JTF_VARCHAR2_TABLE_100
1667: , p11_a3 JTF_NUMBER_TABLE
1668: , p12_a0 JTF_VARCHAR2_TABLE_100
1662: , p10_a24 JTF_NUMBER_TABLE
1663: , p10_a25 JTF_NUMBER_TABLE
1664: , p11_a0 JTF_VARCHAR2_TABLE_100
1665: , p11_a1 JTF_NUMBER_TABLE
1666: , p11_a2 JTF_VARCHAR2_TABLE_100
1667: , p11_a3 JTF_NUMBER_TABLE
1668: , p12_a0 JTF_VARCHAR2_TABLE_100
1669: , p12_a1 JTF_NUMBER_TABLE
1670: , p12_a2 JTF_NUMBER_TABLE
1664: , p11_a0 JTF_VARCHAR2_TABLE_100
1665: , p11_a1 JTF_NUMBER_TABLE
1666: , p11_a2 JTF_VARCHAR2_TABLE_100
1667: , p11_a3 JTF_NUMBER_TABLE
1668: , p12_a0 JTF_VARCHAR2_TABLE_100
1669: , p12_a1 JTF_NUMBER_TABLE
1670: , p12_a2 JTF_NUMBER_TABLE
1671: , p12_a3 JTF_NUMBER_TABLE
1672: , p12_a4 JTF_VARCHAR2_TABLE_200
1683: , p12_a15 JTF_VARCHAR2_TABLE_200
1684: , p12_a16 JTF_VARCHAR2_TABLE_200
1685: , p12_a17 JTF_VARCHAR2_TABLE_200
1686: , p12_a18 JTF_VARCHAR2_TABLE_200
1687: , p12_a19 JTF_VARCHAR2_TABLE_100
1688: , p12_a20 JTF_NUMBER_TABLE
1689: , p13_a0 JTF_VARCHAR2_TABLE_100
1690: , p13_a1 JTF_VARCHAR2_TABLE_100
1691: , p13_a2 JTF_DATE_TABLE
1685: , p12_a17 JTF_VARCHAR2_TABLE_200
1686: , p12_a18 JTF_VARCHAR2_TABLE_200
1687: , p12_a19 JTF_VARCHAR2_TABLE_100
1688: , p12_a20 JTF_NUMBER_TABLE
1689: , p13_a0 JTF_VARCHAR2_TABLE_100
1690: , p13_a1 JTF_VARCHAR2_TABLE_100
1691: , p13_a2 JTF_DATE_TABLE
1692: , p13_a3 JTF_DATE_TABLE
1693: , p13_a4 JTF_VARCHAR2_TABLE_100
1686: , p12_a18 JTF_VARCHAR2_TABLE_200
1687: , p12_a19 JTF_VARCHAR2_TABLE_100
1688: , p12_a20 JTF_NUMBER_TABLE
1689: , p13_a0 JTF_VARCHAR2_TABLE_100
1690: , p13_a1 JTF_VARCHAR2_TABLE_100
1691: , p13_a2 JTF_DATE_TABLE
1692: , p13_a3 JTF_DATE_TABLE
1693: , p13_a4 JTF_VARCHAR2_TABLE_100
1694: , p13_a5 JTF_VARCHAR2_TABLE_200
1689: , p13_a0 JTF_VARCHAR2_TABLE_100
1690: , p13_a1 JTF_VARCHAR2_TABLE_100
1691: , p13_a2 JTF_DATE_TABLE
1692: , p13_a3 JTF_DATE_TABLE
1693: , p13_a4 JTF_VARCHAR2_TABLE_100
1694: , p13_a5 JTF_VARCHAR2_TABLE_200
1695: , p13_a6 JTF_VARCHAR2_TABLE_200
1696: , p13_a7 JTF_VARCHAR2_TABLE_200
1697: , p13_a8 JTF_VARCHAR2_TABLE_200
1705: , p13_a16 JTF_VARCHAR2_TABLE_200
1706: , p13_a17 JTF_VARCHAR2_TABLE_200
1707: , p13_a18 JTF_VARCHAR2_TABLE_200
1708: , p13_a19 JTF_VARCHAR2_TABLE_200
1709: , p13_a20 JTF_VARCHAR2_TABLE_100
1710: , p13_a21 JTF_DATE_TABLE
1711: , p13_a22 JTF_DATE_TABLE
1712: , p13_a23 JTF_NUMBER_TABLE
1713: , x_loading_status out nocopy VARCHAR2
1968: , p7_a39 NUMBER
1969: , p7_a40 NUMBER
1970: , p7_a41 VARCHAR2
1971: , p7_a42 VARCHAR2
1972: , p8_a0 JTF_VARCHAR2_TABLE_100
1973: , p8_a1 JTF_NUMBER_TABLE
1974: , p8_a2 JTF_NUMBER_TABLE
1975: , p8_a3 JTF_NUMBER_TABLE
1976: , p8_a4 JTF_VARCHAR2_TABLE_1900
1973: , p8_a1 JTF_NUMBER_TABLE
1974: , p8_a2 JTF_NUMBER_TABLE
1975: , p8_a3 JTF_NUMBER_TABLE
1976: , p8_a4 JTF_VARCHAR2_TABLE_1900
1977: , p8_a5 JTF_VARCHAR2_TABLE_100
1978: , p8_a6 JTF_VARCHAR2_TABLE_200
1979: , p8_a7 JTF_VARCHAR2_TABLE_200
1980: , p8_a8 JTF_VARCHAR2_TABLE_200
1981: , p8_a9 JTF_VARCHAR2_TABLE_200
1989: , p8_a17 JTF_VARCHAR2_TABLE_200
1990: , p8_a18 JTF_VARCHAR2_TABLE_200
1991: , p8_a19 JTF_VARCHAR2_TABLE_200
1992: , p8_a20 JTF_VARCHAR2_TABLE_200
1993: , p8_a21 JTF_VARCHAR2_TABLE_100
1994: , p8_a22 JTF_NUMBER_TABLE
1995: , p9_a0 JTF_VARCHAR2_TABLE_100
1996: , p9_a1 JTF_DATE_TABLE
1997: , p9_a2 JTF_DATE_TABLE
1991: , p8_a19 JTF_VARCHAR2_TABLE_200
1992: , p8_a20 JTF_VARCHAR2_TABLE_200
1993: , p8_a21 JTF_VARCHAR2_TABLE_100
1994: , p8_a22 JTF_NUMBER_TABLE
1995: , p9_a0 JTF_VARCHAR2_TABLE_100
1996: , p9_a1 JTF_DATE_TABLE
1997: , p9_a2 JTF_DATE_TABLE
1998: , p9_a3 JTF_NUMBER_TABLE
1999: , p9_a4 JTF_NUMBER_TABLE
1996: , p9_a1 JTF_DATE_TABLE
1997: , p9_a2 JTF_DATE_TABLE
1998: , p9_a3 JTF_NUMBER_TABLE
1999: , p9_a4 JTF_NUMBER_TABLE
2000: , p9_a5 JTF_VARCHAR2_TABLE_100
2001: , p9_a6 JTF_VARCHAR2_TABLE_200
2002: , p9_a7 JTF_VARCHAR2_TABLE_200
2003: , p9_a8 JTF_VARCHAR2_TABLE_200
2004: , p9_a9 JTF_VARCHAR2_TABLE_200
2012: , p9_a17 JTF_VARCHAR2_TABLE_200
2013: , p9_a18 JTF_VARCHAR2_TABLE_200
2014: , p9_a19 JTF_VARCHAR2_TABLE_200
2015: , p9_a20 JTF_VARCHAR2_TABLE_200
2016: , p9_a21 JTF_VARCHAR2_TABLE_100
2017: , p9_a22 JTF_DATE_TABLE
2018: , p9_a23 JTF_DATE_TABLE
2019: , p9_a24 JTF_NUMBER_TABLE
2020: , p9_a25 JTF_NUMBER_TABLE
2017: , p9_a22 JTF_DATE_TABLE
2018: , p9_a23 JTF_DATE_TABLE
2019: , p9_a24 JTF_NUMBER_TABLE
2020: , p9_a25 JTF_NUMBER_TABLE
2021: , p10_a0 JTF_VARCHAR2_TABLE_100
2022: , p10_a1 JTF_VARCHAR2_TABLE_100
2023: , p10_a2 JTF_DATE_TABLE
2024: , p10_a3 JTF_DATE_TABLE
2025: , p10_a4 JTF_VARCHAR2_TABLE_100
2018: , p9_a23 JTF_DATE_TABLE
2019: , p9_a24 JTF_NUMBER_TABLE
2020: , p9_a25 JTF_NUMBER_TABLE
2021: , p10_a0 JTF_VARCHAR2_TABLE_100
2022: , p10_a1 JTF_VARCHAR2_TABLE_100
2023: , p10_a2 JTF_DATE_TABLE
2024: , p10_a3 JTF_DATE_TABLE
2025: , p10_a4 JTF_VARCHAR2_TABLE_100
2026: , p10_a5 JTF_VARCHAR2_TABLE_200
2021: , p10_a0 JTF_VARCHAR2_TABLE_100
2022: , p10_a1 JTF_VARCHAR2_TABLE_100
2023: , p10_a2 JTF_DATE_TABLE
2024: , p10_a3 JTF_DATE_TABLE
2025: , p10_a4 JTF_VARCHAR2_TABLE_100
2026: , p10_a5 JTF_VARCHAR2_TABLE_200
2027: , p10_a6 JTF_VARCHAR2_TABLE_200
2028: , p10_a7 JTF_VARCHAR2_TABLE_200
2029: , p10_a8 JTF_VARCHAR2_TABLE_200
2037: , p10_a16 JTF_VARCHAR2_TABLE_200
2038: , p10_a17 JTF_VARCHAR2_TABLE_200
2039: , p10_a18 JTF_VARCHAR2_TABLE_200
2040: , p10_a19 JTF_VARCHAR2_TABLE_200
2041: , p10_a20 JTF_VARCHAR2_TABLE_100
2042: , p10_a21 JTF_DATE_TABLE
2043: , p10_a22 JTF_DATE_TABLE
2044: , p10_a23 JTF_NUMBER_TABLE
2045: , x_loading_status out nocopy VARCHAR2