[Home] [Help]
PACKAGE: APPS.CN_COMP_PLAN_PVT_W
Source
1 package cn_comp_plan_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwcmpns.pls 120.2.12010000.2 2009/08/04 17:21:46 rnagaraj ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_1900
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_200
16 , a13 JTF_VARCHAR2_TABLE_200
17 , a14 JTF_VARCHAR2_TABLE_200
18 , a15 JTF_VARCHAR2_TABLE_200
19 , a16 JTF_VARCHAR2_TABLE_200
20 , a17 JTF_VARCHAR2_TABLE_200
21 , a18 JTF_VARCHAR2_TABLE_200
22 , a19 JTF_VARCHAR2_TABLE_200
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_VARCHAR2_TABLE_200
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_VARCHAR2_TABLE_200
27 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 );
33 procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_VARCHAR2_TABLE_100
35 , a2 out nocopy JTF_VARCHAR2_TABLE_100
36 , a3 out nocopy JTF_VARCHAR2_TABLE_1900
37 , a4 out nocopy JTF_VARCHAR2_TABLE_100
38 , a5 out nocopy JTF_VARCHAR2_TABLE_100
39 , a6 out nocopy JTF_DATE_TABLE
40 , a7 out nocopy JTF_VARCHAR2_TABLE_100
41 , a8 out nocopy JTF_VARCHAR2_TABLE_100
42 , a9 out nocopy JTF_DATE_TABLE
43 , a10 out nocopy JTF_DATE_TABLE
44 , a11 out nocopy JTF_VARCHAR2_TABLE_100
45 , a12 out nocopy JTF_VARCHAR2_TABLE_200
46 , a13 out nocopy JTF_VARCHAR2_TABLE_200
47 , a14 out nocopy JTF_VARCHAR2_TABLE_200
48 , a15 out nocopy JTF_VARCHAR2_TABLE_200
49 , a16 out nocopy JTF_VARCHAR2_TABLE_200
50 , a17 out nocopy JTF_VARCHAR2_TABLE_200
51 , a18 out nocopy JTF_VARCHAR2_TABLE_200
52 , a19 out nocopy JTF_VARCHAR2_TABLE_200
53 , a20 out nocopy JTF_VARCHAR2_TABLE_200
54 , a21 out nocopy JTF_VARCHAR2_TABLE_200
55 , a22 out nocopy JTF_VARCHAR2_TABLE_200
56 , a23 out nocopy JTF_VARCHAR2_TABLE_200
57 , a24 out nocopy JTF_VARCHAR2_TABLE_200
58 , a25 out nocopy JTF_VARCHAR2_TABLE_200
59 , a26 out nocopy JTF_VARCHAR2_TABLE_200
60 , a27 out nocopy JTF_NUMBER_TABLE
61 , a28 out nocopy JTF_NUMBER_TABLE
62 );
63
64 procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
65 , a1 JTF_NUMBER_TABLE
66 , a2 JTF_NUMBER_TABLE
67 , a3 JTF_VARCHAR2_TABLE_100
68 , a4 JTF_VARCHAR2_TABLE_200
69 , a5 JTF_DATE_TABLE
70 , a6 JTF_DATE_TABLE
71 , a7 JTF_NUMBER_TABLE
72 );
73 procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74 , a1 out nocopy JTF_NUMBER_TABLE
75 , a2 out nocopy JTF_NUMBER_TABLE
76 , a3 out nocopy JTF_VARCHAR2_TABLE_100
77 , a4 out nocopy JTF_VARCHAR2_TABLE_200
78 , a5 out nocopy JTF_DATE_TABLE
79 , a6 out nocopy JTF_DATE_TABLE
80 , a7 out nocopy JTF_NUMBER_TABLE
81 );
82
83 procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
84 , a1 JTF_NUMBER_TABLE
85 , a2 JTF_NUMBER_TABLE
86 , a3 JTF_VARCHAR2_TABLE_100
87 , a4 JTF_VARCHAR2_TABLE_400
88 , a5 JTF_VARCHAR2_TABLE_100
89 , a6 JTF_DATE_TABLE
90 , a7 JTF_DATE_TABLE
91 );
92 procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93 , a1 out nocopy JTF_NUMBER_TABLE
94 , a2 out nocopy JTF_NUMBER_TABLE
95 , a3 out nocopy JTF_VARCHAR2_TABLE_100
96 , a4 out nocopy JTF_VARCHAR2_TABLE_400
97 , a5 out nocopy JTF_VARCHAR2_TABLE_100
98 , a6 out nocopy JTF_DATE_TABLE
99 , a7 out nocopy JTF_DATE_TABLE
100 );
101
102 procedure create_comp_plan(p_api_version NUMBER
103 , p_init_msg_list VARCHAR2
104 , p_commit VARCHAR2
105 , p_validation_level NUMBER
106 , p4_a0 in out nocopy NUMBER
107 , p4_a1 in out nocopy VARCHAR2
108 , p4_a2 in out nocopy VARCHAR2
109 , p4_a3 in out nocopy VARCHAR2
110 , p4_a4 in out nocopy VARCHAR2
111 , p4_a5 in out nocopy VARCHAR2
112 , p4_a6 in out nocopy DATE
113 , p4_a7 in out nocopy VARCHAR2
114 , p4_a8 in out nocopy VARCHAR2
115 , p4_a9 in out nocopy DATE
116 , p4_a10 in out nocopy DATE
117 , p4_a11 in out nocopy VARCHAR2
118 , p4_a12 in out nocopy VARCHAR2
119 , p4_a13 in out nocopy VARCHAR2
120 , p4_a14 in out nocopy VARCHAR2
121 , p4_a15 in out nocopy VARCHAR2
122 , p4_a16 in out nocopy VARCHAR2
123 , p4_a17 in out nocopy VARCHAR2
124 , p4_a18 in out nocopy VARCHAR2
125 , p4_a19 in out nocopy VARCHAR2
126 , p4_a20 in out nocopy VARCHAR2
127 , p4_a21 in out nocopy VARCHAR2
128 , p4_a22 in out nocopy VARCHAR2
129 , p4_a23 in out nocopy VARCHAR2
130 , p4_a24 in out nocopy VARCHAR2
131 , p4_a25 in out nocopy VARCHAR2
132 , p4_a26 in out nocopy VARCHAR2
133 , p4_a27 in out nocopy NUMBER
134 , p4_a28 in out nocopy NUMBER
135 , x_comp_plan_id out nocopy NUMBER
136 , x_return_status out nocopy VARCHAR2
137 , x_msg_count out nocopy NUMBER
138 , x_msg_data out nocopy VARCHAR2
139 );
140 procedure update_comp_plan(p_api_version NUMBER
141 , p_init_msg_list VARCHAR2
142 , p_commit VARCHAR2
143 , p_validation_level NUMBER
144 , p4_a0 in out nocopy NUMBER
145 , p4_a1 in out nocopy VARCHAR2
146 , p4_a2 in out nocopy VARCHAR2
147 , p4_a3 in out nocopy VARCHAR2
148 , p4_a4 in out nocopy VARCHAR2
149 , p4_a5 in out nocopy VARCHAR2
150 , p4_a6 in out nocopy DATE
151 , p4_a7 in out nocopy VARCHAR2
152 , p4_a8 in out nocopy VARCHAR2
153 , p4_a9 in out nocopy DATE
154 , p4_a10 in out nocopy DATE
155 , p4_a11 in out nocopy VARCHAR2
156 , p4_a12 in out nocopy VARCHAR2
157 , p4_a13 in out nocopy VARCHAR2
158 , p4_a14 in out nocopy VARCHAR2
159 , p4_a15 in out nocopy VARCHAR2
160 , p4_a16 in out nocopy VARCHAR2
161 , p4_a17 in out nocopy VARCHAR2
162 , p4_a18 in out nocopy VARCHAR2
163 , p4_a19 in out nocopy VARCHAR2
164 , p4_a20 in out nocopy VARCHAR2
165 , p4_a21 in out nocopy VARCHAR2
166 , p4_a22 in out nocopy VARCHAR2
167 , p4_a23 in out nocopy VARCHAR2
168 , p4_a24 in out nocopy VARCHAR2
169 , p4_a25 in out nocopy VARCHAR2
170 , p4_a26 in out nocopy VARCHAR2
171 , p4_a27 in out nocopy NUMBER
172 , p4_a28 in out nocopy NUMBER
173 , x_return_status out nocopy VARCHAR2
174 , x_msg_count out nocopy NUMBER
175 , x_msg_data out nocopy VARCHAR2
176 );
177 procedure delete_comp_plan(p_api_version NUMBER
178 , p_init_msg_list VARCHAR2
179 , p_commit VARCHAR2
180 , p_validation_level NUMBER
181 , p4_a0 in out nocopy NUMBER
182 , p4_a1 in out nocopy VARCHAR2
183 , p4_a2 in out nocopy VARCHAR2
184 , p4_a3 in out nocopy VARCHAR2
185 , p4_a4 in out nocopy VARCHAR2
186 , p4_a5 in out nocopy VARCHAR2
187 , p4_a6 in out nocopy DATE
188 , p4_a7 in out nocopy VARCHAR2
189 , p4_a8 in out nocopy VARCHAR2
190 , p4_a9 in out nocopy DATE
191 , p4_a10 in out nocopy DATE
192 , p4_a11 in out nocopy VARCHAR2
193 , p4_a12 in out nocopy VARCHAR2
194 , p4_a13 in out nocopy VARCHAR2
195 , p4_a14 in out nocopy VARCHAR2
196 , p4_a15 in out nocopy VARCHAR2
197 , p4_a16 in out nocopy VARCHAR2
198 , p4_a17 in out nocopy VARCHAR2
199 , p4_a18 in out nocopy VARCHAR2
200 , p4_a19 in out nocopy VARCHAR2
201 , p4_a20 in out nocopy VARCHAR2
202 , p4_a21 in out nocopy VARCHAR2
203 , p4_a22 in out nocopy VARCHAR2
204 , p4_a23 in out nocopy VARCHAR2
205 , p4_a24 in out nocopy VARCHAR2
206 , p4_a25 in out nocopy VARCHAR2
207 , p4_a26 in out nocopy VARCHAR2
208 , p4_a27 in out nocopy NUMBER
209 , p4_a28 in out nocopy NUMBER
210 , x_return_status out nocopy VARCHAR2
211 , x_msg_count out nocopy NUMBER
212 , x_msg_data out nocopy VARCHAR2
213 );
214 procedure get_comp_plan_sum(p_api_version NUMBER
215 , p_init_msg_list VARCHAR2
216 , p_commit VARCHAR2
217 , p_validation_level NUMBER
218 , p_start_record NUMBER
219 , p_fetch_size NUMBER
220 , p_search_name VARCHAR2
221 , p_search_date DATE
222 , p_search_status VARCHAR2
223 , p9_a0 out nocopy JTF_NUMBER_TABLE
224 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
225 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
226 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
227 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
228 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
229 , p9_a6 out nocopy JTF_DATE_TABLE
230 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
231 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
232 , p9_a9 out nocopy JTF_DATE_TABLE
233 , p9_a10 out nocopy JTF_DATE_TABLE
234 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
235 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
236 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
237 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200
238 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_200
239 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_200
240 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_200
241 , p9_a18 out nocopy JTF_VARCHAR2_TABLE_200
242 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_200
243 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_200
244 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_200
245 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_200
246 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
247 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
248 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
249 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
250 , p9_a27 out nocopy JTF_NUMBER_TABLE
251 , p9_a28 out nocopy JTF_NUMBER_TABLE
252 , x_total_record out nocopy NUMBER
253 , x_return_status out nocopy VARCHAR2
254 , x_msg_count out nocopy NUMBER
255 , x_msg_data out nocopy VARCHAR2
256 );
257 procedure get_comp_plan_dtl(p_api_version NUMBER
258 , p_init_msg_list VARCHAR2
259 , p_commit VARCHAR2
260 , p_validation_level NUMBER
261 , p_comp_plan_id NUMBER
262 , p5_a0 out nocopy JTF_NUMBER_TABLE
263 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
264 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
265 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
266 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
267 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
268 , p5_a6 out nocopy JTF_DATE_TABLE
269 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
270 , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
271 , p5_a9 out nocopy JTF_DATE_TABLE
272 , p5_a10 out nocopy JTF_DATE_TABLE
273 , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
274 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
275 , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200
276 , p5_a14 out nocopy JTF_VARCHAR2_TABLE_200
277 , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
278 , p5_a16 out nocopy JTF_VARCHAR2_TABLE_200
279 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_200
280 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_200
281 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_200
282 , p5_a20 out nocopy JTF_VARCHAR2_TABLE_200
283 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_200
284 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_200
285 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
286 , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
287 , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
288 , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
289 , p5_a27 out nocopy JTF_NUMBER_TABLE
290 , p5_a28 out nocopy JTF_NUMBER_TABLE
291 , x_return_status out nocopy VARCHAR2
292 , x_msg_count out nocopy NUMBER
293 , x_msg_data out nocopy VARCHAR2
294 );
295 procedure get_sales_role(p_api_version NUMBER
296 , p_init_msg_list VARCHAR2
297 , p_commit VARCHAR2
298 , p_validation_level NUMBER
299 , p_comp_plan_id NUMBER
300 , p5_a0 out nocopy JTF_NUMBER_TABLE
301 , p5_a1 out nocopy JTF_NUMBER_TABLE
302 , p5_a2 out nocopy JTF_NUMBER_TABLE
303 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
304 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
305 , p5_a5 out nocopy JTF_DATE_TABLE
306 , p5_a6 out nocopy JTF_DATE_TABLE
307 , p5_a7 out nocopy JTF_NUMBER_TABLE
308 , x_return_status out nocopy VARCHAR2
309 , x_msg_count out nocopy NUMBER
310 , x_msg_data out nocopy VARCHAR2
311 );
312 procedure validate_comp_plan(p_api_version NUMBER
313 , p_init_msg_list VARCHAR2
314 , p_commit VARCHAR2
315 , p_validation_level NUMBER
316 , p4_a0 NUMBER
317 , p4_a1 VARCHAR2
318 , p4_a2 VARCHAR2
319 , p4_a3 VARCHAR2
320 , p4_a4 VARCHAR2
321 , p4_a5 VARCHAR2
322 , p4_a6 DATE
323 , p4_a7 VARCHAR2
324 , p4_a8 VARCHAR2
325 , p4_a9 DATE
326 , p4_a10 DATE
327 , p4_a11 VARCHAR2
328 , p4_a12 VARCHAR2
329 , p4_a13 VARCHAR2
330 , p4_a14 VARCHAR2
331 , p4_a15 VARCHAR2
332 , p4_a16 VARCHAR2
333 , p4_a17 VARCHAR2
334 , p4_a18 VARCHAR2
335 , p4_a19 VARCHAR2
336 , p4_a20 VARCHAR2
337 , p4_a21 VARCHAR2
338 , p4_a22 VARCHAR2
339 , p4_a23 VARCHAR2
340 , p4_a24 VARCHAR2
341 , p4_a25 VARCHAR2
342 , p4_a26 VARCHAR2
343 , p4_a27 NUMBER
344 , p4_a28 NUMBER
345 , x_return_status out nocopy VARCHAR2
346 , x_msg_count out nocopy NUMBER
347 , x_msg_data out nocopy VARCHAR2
348 );
349 procedure get_assigned_salesreps(p_comp_plan_id NUMBER
350 , p_range_low NUMBER
351 , p_range_high NUMBER
352 , x_total_rows out nocopy NUMBER
353 , p4_a0 out nocopy JTF_NUMBER_TABLE
354 , p4_a1 out nocopy JTF_NUMBER_TABLE
355 , p4_a2 out nocopy JTF_NUMBER_TABLE
356 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
357 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
358 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
359 , p4_a6 out nocopy JTF_DATE_TABLE
360 , p4_a7 out nocopy JTF_DATE_TABLE
361 );
362 end cn_comp_plan_pvt_w;