APPS.OKL_SEC_INVESTOR_REVENUE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
9: , a6 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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
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

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
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

Line 18: , a2 out nocopy 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
22: , a6 out nocopy JTF_NUMBER_TABLE

Line 26: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
29:
30: procedure create_investor_revenue(p_api_version NUMBER

Line 27: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
29:
30: procedure create_investor_revenue(p_api_version NUMBER
31: , p_init_msg_list VARCHAR2

Line 115: , p5_a2 JTF_VARCHAR2_TABLE_100

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
119: , p5_a6 JTF_NUMBER_TABLE

Line 123: , p5_a10 JTF_VARCHAR2_TABLE_100

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
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

Line 124: , p5_a11 JTF_VARCHAR2_TABLE_100

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
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

Line 127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
131: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138: procedure update_investor_revenue(p_api_version NUMBER
139: , p_init_msg_list VARCHAR2

Line 136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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
136: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138: procedure update_investor_revenue(p_api_version NUMBER
139: , p_init_msg_list VARCHAR2
140: , x_return_status out nocopy VARCHAR2

Line 145: , p5_a2 JTF_VARCHAR2_TABLE_100

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
149: , p5_a6 JTF_NUMBER_TABLE

Line 153: , p5_a10 JTF_VARCHAR2_TABLE_100

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
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

Line 154: , p5_a11 JTF_VARCHAR2_TABLE_100

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
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

Line 157: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
161: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 165: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168: procedure delete_investor_revenue(p_api_version NUMBER
169: , p_init_msg_list VARCHAR2

Line 166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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
166: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168: procedure delete_investor_revenue(p_api_version NUMBER
169: , p_init_msg_list VARCHAR2
170: , x_return_status out nocopy VARCHAR2

Line 175: , p5_a2 JTF_VARCHAR2_TABLE_100

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
179: , p5_a6 JTF_NUMBER_TABLE

Line 183: , p5_a10 JTF_VARCHAR2_TABLE_100

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
184: , p5_a11 JTF_VARCHAR2_TABLE_100
185: );
186: end okl_sec_investor_revenue_pvt_w;

Line 184: , p5_a11 JTF_VARCHAR2_TABLE_100

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
184: , p5_a11 JTF_VARCHAR2_TABLE_100
185: );
186: end okl_sec_investor_revenue_pvt_w;