1 PACKAGE CN_SRP_PMT_PLANS_PUB_VUHK AS
2 /* $Header: cnisppas.pls 120.1 2005/06/10 13:57:07 appldev $ */
3
4 -- Start of comments
5 -- API name : Create_Srp_Pmt_Plan_Pre
6 -- Type : Public.
7 -- Pre-reqs : None.
8 -- Usage : Customization before create a new payment plan assignment to
9 -- an salesrep
10 -- Desc :
11 -- Parameters :
12 -- IN : p_api_version IN NUMBER Require
13 -- p_init_msg_list IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_commit IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_validation_level IN NUMBER Optional
18 -- Default = FND_API.G_VALID_LEVEL_FULL
19 -- p_srp_pmt_plans_rec IN OUT NOCOPY
20 -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
21 -- Required input :
22 -- PMT_PLAN_NAME payment plan name
23 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
24 -- ROLE_NAME which sales role to be assigned
25 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
26 -- x_msg_count OUT NOCOPY NUMBER
27 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
28 -- x_loading_status OUT NOCOPY VARCHAR2(30)
29 -- Version : Current version 1.0
30 -- Initial version 1.0
31 -- Notes :
32 --
33 -- End of comments
34
35 PROCEDURE Create_Srp_Pmt_Plan_Pre
36 (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
45 x_srp_pmt_plan_id OUT NOCOPY NUMBER,
46 x_loading_status OUT NOCOPY VARCHAR2
47 );
48
49 -- Start of comments
50 -- API name : Create_Srp_Pmt_Plan_Post
51 -- Type : Public.
52 -- Pre-reqs : None.
53 -- Usage : Customization after create a new payment plan assignment to
54 -- an salesrep
55 -- Desc :
56 -- Parameters :
57 -- IN : p_api_version IN NUMBER Require
58 -- p_init_msg_list IN VARCHAR2 Optional
59 -- Default = FND_API.G_FALSE
60 -- p_commit IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_validation_level IN NUMBER Optional
63 -- Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_srp_pmt_plans_rec IN
65 -- cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
66 -- Required input :
67 -- PMT_PLAN_NAME payment plan name
68 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
69 -- ROLE_NAME which sales role to be assigned
70 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
71 -- x_msg_count OUT NOCOPY NUMBER
72 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
73 -- x_loading_status OUT NOCOPY VARCHAR2(30)
74 -- Version : Current version 1.0
75 -- Initial version 1.0
76 -- Notes :
77 --
78 -- End of comments
79
80 PROCEDURE Create_Srp_Pmt_Plan_Post
81 (
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
90 x_srp_pmt_plan_id OUT NOCOPY NUMBER,
91 x_loading_status OUT NOCOPY VARCHAR2
92 );
93
94 -- Start of comments
95 -- API name : Update_Srp_Pmt_Plan_Pre
96 -- Type : Public.
97 -- Pre-reqs : None.
98 -- Usage : Customize before update pmt plan assignment of an salesrep
99 -- Desc : Procedure to update pmt plan assignment of an salesrep
100 -- Parameters :
101 -- IN : p_api_version IN NUMBER Require
102 -- p_init_msg_list IN VARCHAR2 Optional
103 -- Default = FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Optional
105 -- Default = FND_API.G_FALSE
106 -- p_validation_level IN NUMBER Optional
107 -- Default = FND_API.G_VALID_LEVEL_FULL
108 -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
109 -- Required input :
110 -- PMT_PLAN_NAME payment plan name
111 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
112 -- ROLE_NAME which sales role to be assigned
113 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
114 -- x_msg_count OUT NOCOPY NUMBER
115 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
116 -- x_loading_status OUT NOCOPY VARCHAR2(30)
117 -- Version : Current version 1.0
118 -- Initial version 1.0
119 -- Notes :
120 --
121 -- End of comments
122
123 PROCEDURE Update_Srp_Pmt_Plan_Pre
124 (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127 p_commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_old_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
133 p_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
134 x_loading_status OUT NOCOPY VARCHAR2
135 );
136
137 -- Start of comments
138 -- API name : Update_Srp_Pmt_Plan_Post
139 -- Type : Public.
140 -- Pre-reqs : None.
141 -- Usage : Customize after update pmt plan assignment of an salesrep
142 -- Desc : Procedure to update pmt plan assignment of an salesrep
143 -- Parameters :
144 -- IN : p_api_version IN NUMBER Require
145 -- p_init_msg_list IN VARCHAR2 Optional
146 -- Default = FND_API.G_FALSE
147 -- p_commit IN VARCHAR2 Optional
148 -- Default = FND_API.G_FALSE
149 -- p_validation_level IN NUMBER Optional
150 -- Default = FND_API.G_VALID_LEVEL_FULL
151 -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
152 -- Required input :
153 -- PMT_PLAN_NAME payment plan name
154 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
155 -- ROLE_NAME which sales role to be assigned
156 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
157 -- x_msg_count OUT NOCOPY NUMBER
158 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
159 -- x_loading_status OUT NOCOPY VARCHAR2(30)
160 -- Version : Current version 1.0
161 -- Initial version 1.0
162 -- Notes :
163 --
164 -- End of comments
165
166 PROCEDURE Update_Srp_Pmt_Plan_Post
167 (
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_old_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
176 := cn_srp_pmt_plans_pub.G_MISS_SRP_PMT_PLANS_REC,
177 p_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
178 := cn_srp_pmt_plans_pub.G_MISS_SRP_PMT_PLANS_REC,
179 x_loading_status OUT NOCOPY VARCHAR2
180 );
181
182 -- Start of comments
183 -- API name : Delete_Srp_Pmt_Plan_Pre
184 -- Type : Public.
185 -- Pre-reqs : None.
186 -- Usage : Customize before delete a payment plan assign to an salesrep
187 -- Desc : Procedure to delete a payment plan assignment to salesrep
188 -- Parameters :
189 -- IN : p_api_version IN NUMBER Require
190 -- p_init_msg_list IN VARCHAR2 Optional
191 -- Default = FND_API.G_FALSE
192 -- p_commit IN VARCHAR2 Optional
193 -- Default = FND_API.G_FALSE
194 -- p_validation_level IN NUMBER Optional
195 -- Default = FND_API.G_VALID_LEVEL_FULL
196 -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
197 -- Required input :
198 -- PMT_PLAN_NAME payment plan name
199 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
200 -- ROLE_NAME which sales role to be assigned
201 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
202 -- x_msg_count OUT NOCOPY NUMBER
203 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
204 -- x_loading_status OUT NOCOPY VARCHAR2(30)
205 -- Version : Current version 1.0
206 -- Initial version 1.0
207 -- Notes :
208 -- End of comments
209
210 PROCEDURE Delete_Srp_Pmt_Plan_Pre
211 (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214 p_commit IN VARCHAR2 := FND_API.G_FALSE,
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_srp_pmt_plans_rec IN OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type,
220 x_loading_status OUT NOCOPY VARCHAR2
221 );
222
223 -- Start of comments
224 -- API name : Delete_Srp_Pmt_Plan_Post
225 -- Type : Public.
226 -- Pre-reqs : None.
227 -- Usage : Customize after delete a payment plan assign to an salesrep
228 -- Desc : Procedure to delete a payment plan assignment to salesrep
229 -- Parameters :
230 -- IN : p_api_version IN NUMBER Require
231 -- p_init_msg_list IN VARCHAR2 Optional
232 -- Default = FND_API.G_FALSE
233 -- p_commit IN VARCHAR2 Optional
234 -- Default = FND_API.G_FALSE
235 -- p_validation_level IN NUMBER Optional
236 -- Default = FND_API.G_VALID_LEVEL_FULL
237 -- p_srp_pmt_plans_rec IN OUT NOCOPY srp_pmt_plans_rec_type
238 -- Required input :
239 -- PMT_PLAN_NAME payment plan name
240 -- SALESREP_TYPE,EMP_NUM use to get salesrep info
241 -- ROLE_NAME which sales role to be assigned
242 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
243 -- x_msg_count OUT NOCOPY NUMBER
244 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
245 -- x_loading_status OUT NOCOPY VARCHAR2(30)
246 -- Version : Current version 1.0
247 -- Initial version 1.0
248 -- Notes :
249 -- End of comments
250
251 PROCEDURE Delete_Srp_Pmt_Plan_Post
252 (
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255 p_commit IN VARCHAR2 := FND_API.G_FALSE,
256 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_srp_pmt_plans_rec IN cn_srp_pmt_plans_pub.srp_pmt_plans_rec_type
261 := cn_srp_pmt_plans_pub.G_MISS_SRP_PMT_PLANS_REC,
262 x_loading_status OUT NOCOPY VARCHAR2
263 );
264
265 -- API name : Get_Srp_Pmt_Plan_Pre
266 -- Type : Public.
267 -- Pre-reqs : None.
268 -- Usage : Customize before get payment plan assignment from db
269 -- Desc : Procedure to payment plan assignment from db
270 -- Parameters :
271 -- IN : p_api_version IN NUMBER Require
272 -- p_init_msg_list IN VARCHAR2 Optional
273 -- Default = FND_API.G_FALSE
274 -- p_commit IN VARCHAR2 Optional
275 -- Default = FND_API.G_FALSE
276 -- p_validation_level IN NUMBER Optional
277 -- Default = FND_API.G_VALID_LEVEL_FULL
278 -- p_pmt_plan_name IN VARCHAR2 Optional
279 -- Default = FND_API.G_MISS_CHAR
280 -- p_salesrep_type IN VARCHAR2 Optional
281 -- Default = FND_API.G_MISS_CHAR
282 -- p_emp_num IN VARCHAR2 Optional
283 -- Default = FND_API.G_MISS_CHAR
284 -- p_role_name IN VARCHAR2 Optional
285 -- Default = FND_API.G_MISS_CHAR
286 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
287 -- x_msg_count OUT NOCOPY NUMBER
288 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
289 -- x_srp_pmt_plans_rec_tbl OUT NOCOPY srp_pmt_plans_tbl_type
290 -- x_loading_status OUT NOCOPY VARCHAR2(30)
291 -- Version : Current version 1.0
292 -- Initial version 1.0
293 -- Notes :
294 -- End of comments
295
296 PROCEDURE Get_Srp_Pmt_Plan_Pre
297 (
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300 p_commit IN VARCHAR2 := FND_API.G_FALSE,
301 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_pmt_plan_name IN OUT NOCOPY VARCHAR2,
306 p_salesrep_type IN OUT NOCOPY VARCHAR2,
307 p_emp_num IN OUT NOCOPY VARCHAR2 ,
308 p_role_name IN OUT NOCOPY VARCHAR2 ,
309 x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
310 x_loading_status OUT NOCOPY VARCHAR2
311 );
312
313 -- API name : Get_Srp_Pmt_Plan_Post
314 -- Type : Public.
315 -- Pre-reqs : None.
316 -- Usage : Customize after get payment plan assignment from db
317 -- Desc : Procedure to payment plan assignment from db
318 -- Parameters :
319 -- IN : p_api_version IN NUMBER Require
320 -- p_init_msg_list IN VARCHAR2 Optional
321 -- Default = FND_API.G_FALSE
322 -- p_commit IN VARCHAR2 Optional
323 -- Default = FND_API.G_FALSE
324 -- p_validation_level IN NUMBER Optional
325 -- Default = FND_API.G_VALID_LEVEL_FULL
326 -- p_pmt_plan_name IN VARCHAR2 Optional
327 -- Default = FND_API.G_MISS_CHAR
328 -- p_salesrep_type IN VARCHAR2 Optional
329 -- Default = FND_API.G_MISS_CHAR
330 -- p_emp_num IN VARCHAR2 Optional
331 -- Default = FND_API.G_MISS_CHAR
332 -- p_role_name IN VARCHAR2 Optional
333 -- Default = FND_API.G_MISS_CHAR
334 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
335 -- x_msg_count OUT NOCOPY NUMBER
336 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
337 -- x_srp_pmt_plans_rec_tbl OUT NOCOPY srp_pmt_plans_tbl_type
338 -- x_loading_status OUT NOCOPY VARCHAR2(30)
339 -- Version : Current version 1.0
340 -- Initial version 1.0
341 -- Notes :
342 -- End of comments
343
344 PROCEDURE Get_Srp_Pmt_Plan_Post
345 (
346 p_api_version IN NUMBER,
347 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348 p_commit IN VARCHAR2 := FND_API.G_FALSE,
349 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353 p_pmt_plan_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
354 p_salesrep_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
355 p_emp_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
356 p_role_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
357 x_srp_pmt_plans_rec_tbl OUT NOCOPY cn_srp_pmt_plans_pub.srp_pmt_plans_tbl_type ,
358 x_loading_status OUT NOCOPY VARCHAR2
359 );
360
361 END CN_SRP_PMT_PLANS_PUB_VUHK ;