1: package okl_sec_investor_revenue_pvt_w as
2: /* $Header: OKLESZRS.pls 120.2 2005/10/30 03:21:05 appldev noship $ */
3: procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_sec_investor_revenue_pvt_w as
2: /* $Header: OKLESZRS.pls 120.2 2005/10/30 03:21:05 appldev noship $ */
3: procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: OKLESZRS.pls 120.2 2005/10/30 03:21:05 appldev noship $ */
3: procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
16: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_DATE_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_DATE_TABLE
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_DATE_TABLE
26: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , p_init_msg_list VARCHAR2
110: , x_return_status out nocopy VARCHAR2
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
110: , x_return_status out nocopy VARCHAR2
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
115: , p5_a2 JTF_VARCHAR2_TABLE_100
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_NUMBER_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
121: , p5_a8 JTF_DATE_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
124: , p5_a11 JTF_VARCHAR2_TABLE_100
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
122: , p5_a9 JTF_DATE_TABLE
123: , p5_a10 JTF_VARCHAR2_TABLE_100
124: , p5_a11 JTF_VARCHAR2_TABLE_100
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
124: , p5_a11 JTF_VARCHAR2_TABLE_100
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_DATE_TABLE
133: , p6_a8 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
139: , p_init_msg_list VARCHAR2
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: , p5_a0 JTF_NUMBER_TABLE
144: , p5_a1 JTF_NUMBER_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: , p5_a0 JTF_NUMBER_TABLE
144: , p5_a1 JTF_NUMBER_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
142: , x_msg_data out nocopy VARCHAR2
143: , p5_a0 JTF_NUMBER_TABLE
144: , p5_a1 JTF_NUMBER_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
143: , p5_a0 JTF_NUMBER_TABLE
144: , p5_a1 JTF_NUMBER_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
144: , p5_a1 JTF_NUMBER_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
145: , p5_a2 JTF_VARCHAR2_TABLE_100
146: , p5_a3 JTF_NUMBER_TABLE
147: , p5_a4 JTF_NUMBER_TABLE
148: , p5_a5 JTF_NUMBER_TABLE
149: , p5_a6 JTF_NUMBER_TABLE
150: , p5_a7 JTF_DATE_TABLE
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a8 JTF_DATE_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
154: , p5_a11 JTF_VARCHAR2_TABLE_100
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p5_a9 JTF_DATE_TABLE
153: , p5_a10 JTF_VARCHAR2_TABLE_100
154: , p5_a11 JTF_VARCHAR2_TABLE_100
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
154: , p5_a11 JTF_VARCHAR2_TABLE_100
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
156: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a3 out nocopy JTF_NUMBER_TABLE
159: , p6_a4 out nocopy JTF_NUMBER_TABLE
160: , p6_a5 out nocopy JTF_NUMBER_TABLE
161: , p6_a6 out nocopy JTF_NUMBER_TABLE
162: , p6_a7 out nocopy JTF_DATE_TABLE
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
169: , p_init_msg_list VARCHAR2
170: , x_return_status out nocopy VARCHAR2
171: , x_msg_count out nocopy NUMBER
172: , x_msg_data out nocopy VARCHAR2
173: , p5_a0 JTF_NUMBER_TABLE
174: , p5_a1 JTF_NUMBER_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
170: , x_return_status out nocopy VARCHAR2
171: , x_msg_count out nocopy NUMBER
172: , x_msg_data out nocopy VARCHAR2
173: , p5_a0 JTF_NUMBER_TABLE
174: , p5_a1 JTF_NUMBER_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
172: , x_msg_data out nocopy VARCHAR2
173: , p5_a0 JTF_NUMBER_TABLE
174: , p5_a1 JTF_NUMBER_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
173: , p5_a0 JTF_NUMBER_TABLE
174: , p5_a1 JTF_NUMBER_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
174: , p5_a1 JTF_NUMBER_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
182: , p5_a9 JTF_DATE_TABLE
175: , p5_a2 JTF_VARCHAR2_TABLE_100
176: , p5_a3 JTF_NUMBER_TABLE
177: , p5_a4 JTF_NUMBER_TABLE
178: , p5_a5 JTF_NUMBER_TABLE
179: , p5_a6 JTF_NUMBER_TABLE
180: , p5_a7 JTF_DATE_TABLE
181: , p5_a8 JTF_DATE_TABLE
182: , p5_a9 JTF_DATE_TABLE
183: , p5_a10 JTF_VARCHAR2_TABLE_100