1 PACKAGE CN_ROLE_PLANS_PUB_CUHK AS
2 /* $Header: cncrlpls.pls 120.1 2005/06/10 13:53:38 appldev $ */
3
4 -- Start of Comments
5 -- API name : Create_Role_Plan_Pre
6 -- Type : Public.
7 -- Pre-reqs : None.
8 -- Usage : Customization before create a sales role and comp plan
9 -- assignment.
10 -- Parameters :
11 -- IN : p_api_version IN NUMBER Require
12 -- : p_init_msg_list IN VARCHAR2 Optional
13 -- Default = FND_API.G_FALSE
14 -- : p_commit IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- : p_validation_level IN NUMBER Optional
17 -- Default = FND_API.G_VALID_LEVEL_FULL
18 -- : p_role_plan_rec IN OUT NOCOPY
19 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
20 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
21 -- : x_msg_count OUT NOCOPY NUMBER
22 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
23 -- : x_loading_status OUT NOCOPY VARCHAR2
24 --
25 --
26 -- Version : Current version 1.0
27 -- Initial version 1.0
28 --
29 -- Notes
30 -- End of comments
31
32
33 PROCEDURE Create_Role_Plan_Pre
34 ( p_api_version IN NUMBER ,
35 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
36 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
37 p_validation_level IN NUMBER := CN_API.g_valid_level_full,
38 x_return_status OUT NOCOPY VARCHAR2 ,
39 x_loading_status OUT NOCOPY VARCHAR2 ,
40 x_msg_count OUT NOCOPY NUMBER ,
41 x_msg_data OUT NOCOPY VARCHAR2 ,
42 p_role_plan_rec IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
43 );
44
45
46
47 -- Start of Comments
48 -- API name : Create_Role_Plan_Post
49 -- Type : Public.
50 -- Pre-reqs : None.
51 -- Usage : Customization after create a sales role and comp plan
52 -- assignment.
53 -- Parameters :
54 -- IN : p_api_version IN NUMBER Require
55 -- : p_init_msg_list IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 -- : p_commit IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- : p_validation_level IN NUMBER Optional
60 -- Default = FND_API.G_VALID_LEVEL_FULL
61 -- : p_role_plan_rec IN OUT NOCOPY
62 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
63 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
64 -- : x_msg_count OUT NOCOPY NUMBER
65 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
66 -- : x_loading_status OUT NOCOPY VARCHAR2
67 --
68 --
69 -- Version : Current version 1.0
70 -- Initial version 1.0
71 --
72 -- Notes
73 -- End of comments
74
75
76 PROCEDURE Create_Role_Plan_Post
77 ( p_api_version IN NUMBER ,
78 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
79 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
80 p_validation_level IN NUMBER := CN_API.g_valid_level_full,
81 x_return_status OUT NOCOPY VARCHAR2 ,
82 x_loading_status OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_msg_data OUT NOCOPY VARCHAR2 ,
85 p_role_plan_rec IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
86 );
87
88
89
90 -- Start of Comments
91 -- API name : Update_Role_Plan_Pre
92 -- Type : Public.
93 -- Pre-reqs : None.
94 -- Usage : Customize before update a sales role and comp plan assignment.
95 -- Parameters :
96 -- IN : p_api_version IN NUMBER Require
97 -- : p_init_msg_list IN VARCHAR2 Optional
98 -- Default = FND_API.G_FALSE
99 -- : p_commit IN VARCHAR2 Optional
100 -- Default = FND_API.G_FALSE
101 -- : p_validation_level IN NUMBER Optional
102 -- Default = FND_API.G_VALID_LEVEL_FULL
103 -- : p_role_plan_rec_old IN OUT NOCOPY
104 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
105 -- : p_role_plan_rec_new IN OUT NOCOPY
106 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
107 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
108 -- : x_msg_count OUT NOCOPY NUMBER
109 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
110 -- : x_loading_status OUT NOCOPY VARCHAR2
111 --
112 --
113 -- Version : Current version 1.0
114 -- Initial version 1.0
115 --
116 -- Notes
117 -- End of comments
118
119
120 PROCEDURE Update_Role_Plan_Pre
121 ( p_api_version IN NUMBER ,
122 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
123 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
124 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
125 x_return_status OUT NOCOPY VARCHAR2 ,
126 x_loading_status OUT NOCOPY VARCHAR2 ,
127 x_msg_count OUT NOCOPY NUMBER ,
128 x_msg_data OUT NOCOPY VARCHAR2 ,
129 p_role_plan_rec_old IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type,
130 p_role_plan_rec_new IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
131 );
132
133
134 -- Start of Comments
135 -- API name : Update_Role_Plan_Post
136 -- Type : Public.
137 -- Pre-reqs : None.
138 -- Usage : Customize after update a sales role and comp plan assignment.
139 -- Parameters :
140 -- IN : p_api_version IN NUMBER Require
141 -- : p_init_msg_list IN VARCHAR2 Optional
142 -- Default = FND_API.G_FALSE
143 -- : p_commit IN VARCHAR2 Optional
144 -- Default = FND_API.G_FALSE
145 -- : p_validation_level IN NUMBER Optional
146 -- Default = FND_API.G_VALID_LEVEL_FULL
147 -- : p_role_plan_rec_old IN OUT NOCOPY
148 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
149 -- : p_role_plan_rec_new IN OUT NOCOPY
150 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
151 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
152 -- : x_msg_count OUT NOCOPY NUMBER
153 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
154 -- : x_loading_status OUT NOCOPY VARCHAR2
155 --
156 --
157 -- Version : Current version 1.0
158 -- Initial version 1.0
159 --
160 -- Notes
161 -- End of comments
162
163
164 PROCEDURE Update_Role_Plan_Post
165 ( p_api_version IN NUMBER ,
166 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
167 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
168 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
169 x_return_status OUT NOCOPY VARCHAR2 ,
170 x_loading_status OUT NOCOPY VARCHAR2 ,
171 x_msg_count OUT NOCOPY NUMBER ,
172 x_msg_data OUT NOCOPY VARCHAR2 ,
173 p_role_plan_rec_old IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type,
174 p_role_plan_rec_new IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
175 );
176
177 -- Start of Comments
178 -- API name : Delete_Role_Plan_Pre
179 -- Type : Public.
180 -- Pre-reqs : None.
181 -- Usage : Customize before delete a sales role and comp plan assignment.
182 -- Parameters :
183 -- IN : p_api_version IN NUMBER Require
184 -- : p_init_msg_list IN VARCHAR2 Optional
185 -- Default = FND_API.G_FALSE
186 -- : p_commit IN VARCHAR2 Optional
187 -- Default = FND_API.G_FALSE
188 -- : p_validation_level IN NUMBER Optional
189 -- Default = FND_API.G_VALID_LEVEL_FULL
190 -- p_role_plan_rec IN OUT NOCOPY
191 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
192 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
193 -- : x_msg_count OUT NOCOPY NUMBER
194 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
195 -- : x_loading_status OUT NOCOPY VARCHAR2
196 --
197 --
198 -- Version : Current version 1.0
199 -- Initial version 1.0
200 --
201 -- Notes
202 -- End of comments
203
204
205 PROCEDURE Delete_Role_Plan_Pre
206 ( p_api_version IN NUMBER ,
207 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
208 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
209 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
210 x_return_status OUT NOCOPY VARCHAR2 ,
211 x_loading_status OUT NOCOPY VARCHAR2 ,
212 x_msg_count OUT NOCOPY NUMBER ,
213 x_msg_data OUT NOCOPY VARCHAR2 ,
214 p_role_plan_rec IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
215 );
216
217
218 -- Start of Comments
219 -- API name : Delete_Role_Plan_Post
220 -- Type : Public.
221 -- Pre-reqs : None.
222 -- Usage : Customize after delete a sales role and comp plan assignment.
223 -- Parameters :
224 -- IN : p_api_version IN NUMBER Require
225 -- : p_init_msg_list IN VARCHAR2 Optional
226 -- Default = FND_API.G_FALSE
227 -- : p_commit IN VARCHAR2 Optional
228 -- Default = FND_API.G_FALSE
229 -- : p_validation_level IN NUMBER Optional
230 -- Default = FND_API.G_VALID_LEVEL_FULL
231 -- p_role_plan_rec IN OUT NOCOPY
232 -- CN_ROLE_PLANS_PUB.ROLE_PLAN_REC_TYPE
233 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
234 -- : x_msg_count OUT NOCOPY NUMBER
235 -- : x_msg_data OUT NOCOPY VARCHAR2(2000)
236 -- : x_loading_status OUT NOCOPY VARCHAR2
237 --
238 --
239 -- Version : Current version 1.0
240 -- Initial version 1.0
241 --
242 -- Notes
243 -- End of comments
244
245
246 PROCEDURE Delete_Role_Plan_Post
247 ( p_api_version IN NUMBER ,
248 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE ,
249 p_commit IN VARCHAR2 := CN_API.G_FALSE ,
250 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
251 x_return_status OUT NOCOPY VARCHAR2 ,
252 x_loading_status OUT NOCOPY VARCHAR2 ,
253 x_msg_count OUT NOCOPY NUMBER ,
254 x_msg_data OUT NOCOPY VARCHAR2 ,
255 p_role_plan_rec IN OUT NOCOPY cn_role_plans_pub.role_plan_rec_type
256 );
257
258
259
260 -- Start of comments
261 -- API name : ok_to_generate_msg
262 -- Type : Public.
263 -- Pre-reqs : None.
264 -- Usage : Function to decide whether message needs to be generated
265 --
266 -- Desc :
267 --
268 -- Parameters :
269 -- IN :
270 -- OUT :
271 -- Version : Current version 1.0
272 -- Initial version 1.0
273 --
274 -- End of comments
275
276 FUNCTION ok_to_generate_msg
277 ( p_role_plan_rec IN cn_role_plans_pub.role_plan_rec_type)
278 RETURN BOOLEAN;
279
280
281 END cn_role_plans_pub_cuhk;