1 PACKAGE cn_plan_element_cuhk AS
2 /* $Header: cncpes.pls 120.1 2005/06/14 19:00:50 appldev $ */
3
4 -- Start of Comments
5 -- API name : Create_Plan_Element_Pre
6 -- Type : Public.
7 -- Pre-reqs : None.
8 -- Usage : User hook before create a plan element
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_plan_element_rec IN OUT PLAN_ELEMENT_REC_TYPE
18 -- p_revenue_class_rec_tbl IN OUT REVENUE_CLASS_REC_TBL_TYPE
19 -- p_rev_uplift_rec_tbl IN OUT REV_CLASS_REC_TBL_TYPE
20 -- p_trx_factors_rec_tbl IN OUT TRX_FACTORS_REC_TBL
21 -- p_rt_quota_asgns_rec_tbl IN OUT PERIOD_QUOTAS_REC_TBL_TYPE
22 -- p_period_quotas_rec_tbl IN OUT RT_QUOTA_ASGNS_REC_TBL_TYPE
23 --
24 -- OUT : x_return_status OUT VARCHAR2(1)
25 -- x_msg_count OUT NUMBER
26 -- x_msg_data OUT VARCHAR2(2000)
27 -- x_status OUT VARCHAR2
28 --
29 --
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --
33 --
34 -- End of comments
35 --
36 PROCEDURE create_plan_element_pre (
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_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45 p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47 p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48 p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49 p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
50 x_loading_status OUT NOCOPY VARCHAR2
51 );
52
53 -- Start of Comments
54 -- API name : Create_Plan_Element_Post
55 -- Type : Public.
56 -- Pre-reqs : None.
57 -- Usage : User hook after create a plan element
58 -- Parameters :
59 -- IN : p_api_version IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_commit IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional
65 -- Default = FND_API.G_VALID_LEVEL_FULL
66 -- p_plan_element_rec IN PLAN_ELEMENT_REC_TYPE
67 -- p_revenue_class_rec_tbl IN REVENUE_CLASS_REC_TBL_TYPE
68 -- p_rev_uplift_rec_tbl IN REV_CLASS_REC_TBL_TYPE
69 -- p_trx_factors_rec_tbl IN TRX_FACTORS_REC_TBL
70 -- p_rt_quota_asgns_rec_tbl IN PERIOD_QUOTAS_REC_TBL_TYPE
71 -- p_period_quotas_rec_tbl IN RT_QUOTA_ASGNS_REC_TBL_TYPE
72 --
73 -- OUT : x_return_status OUT VARCHAR2(1)
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2(2000)
76 -- x_status OUT VARCHAR2
77 --
78 --
79 -- Version : Current version 1.0
80 -- Initial version 1.0
81 --
82 --
83 -- End of comments
84 --
85 PROCEDURE create_plan_element_post (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
88 p_commit IN VARCHAR2 := fnd_api.g_false,
89 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97 p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
99 x_loading_status OUT NOCOPY VARCHAR2
100 );
101
102 -- Start of Comments
103 -- API name : Update_Plan_Element_Pre
104 -- Type : Public.
105 -- Pre-reqs : None.
106 -- Usage : User Hook before Update a plan element
107 -- Parameters :
108 -- IN : p_api_version IN NUMBER Require
109 -- p_init_msg_list IN VARCHAR2 Optional
110 -- Default = FND_API.G_FALSE
111 -- p_commit IN VARCHAR2 Optional
112 -- Default = FND_API.G_FALSE
113 -- p_validation_level IN NUMBER Optional
114 -- Default = FND_API.G_VALID_LEVEL_FULL
115 -- p_quota_name_old IN OUT VARCHAR2
116 -- p_new_plan_element_rec IN OUT PLAN_ELEMENT_REC_TYPE
117 -- p_revenue_class_rec_tbl IN OUT REVENUE_CLASS_REC_TBL_TYPE
118 -- p_rev_uplift_rec_tbl IN OUT REV_CLASS_REC_TBL_TYPE
119 -- p_trx_factors_rec_tbl IN OUT TRX_FACTORS_REC_TBL_TYPE
120 -- p_period_quotas_rec_tbl IN OUT PERIOD_QUOTAS_REC_TBL_TYPE
121 --
122 -- OUT : x_return_status OUT VARCHAR2
123 -- x_msg_count OUT NUMBER
124 -- x_msg_data OUT VARCHAR2
125 -- x_status OUT VARCHAR2
126 --
127 -- Version : Current version 1.0
128 -- Initial version 1.0
129 --
130 -- End of comments
131 PROCEDURE update_plan_element_pre (
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
134 p_commit IN VARCHAR2 := fnd_api.g_false,
135 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
140 p_quota_name_old IN OUT NOCOPY VARCHAR2,
141 p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143 p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144 p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145 p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
146 x_loading_status OUT NOCOPY VARCHAR2
147 );
148
149 -- Start of Comments
150 -- API name : Update_Plan_Element_Post
151 -- Type : Public.
152 -- Pre-reqs : None.
153 -- Usage : User Hook after Update a plan element
154 -- Parameters :
155 -- IN : p_api_version IN NUMBER Require
156 -- p_init_msg_list IN VARCHAR2 Optional
157 -- Default = FND_API.G_FALSE
158 -- p_commit IN VARCHAR2 Optional
159 -- Default = FND_API.G_FALSE
160 -- p_validation_level IN NUMBER Optional
161 -- Default = FND_API.G_VALID_LEVEL_FULL
162 -- p_quota_name_old IN VARCHAR2
163 -- p_new_plan_element_rec IN PLAN_ELEMENT_REC_TYPE
164 -- p_revenue_class_rec_tbl IN REVENUE_CLASS_REC_TBL_TYPE
165 -- p_rev_uplift_rec_tbl IN REV_CLASS_REC_TBL_TYPE
166 -- p_trx_factors_rec_tbl IN TRX_FACTORS_REC_TBL_TYPE
167 -- p_period_quotas_rec_tbl IN Optional
168 --
169 -- OUT : x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- x_status OUT VARCHAR2
173 --
174 -- Version : Current version 1.0
175 -- Initial version 1.0
176 --
177 -- End of comments
178 PROCEDURE update_plan_element_post (
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
181 p_commit IN VARCHAR2 := fnd_api.g_false,
182 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
187 p_quota_name_old IN VARCHAR2,
188 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191 p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
193 x_loading_status OUT NOCOPY VARCHAR2
194 );
195
196 -- Start of Comments
197 -- API name : Delete_Plan_Element_Pre
198 -- Type : Public.
199 -- Pre-reqs : None.
200 -- Usage : User Hook before Delete a plan element
201 -- Parameters :
202 -- IN : p_api_version IN NUMBER Require
203 -- p_init_msg_list IN VARCHAR2 Optional
204 -- Default = FND_API.G_FALSE
205 -- p_commit IN VARCHAR2 Optional
206 -- Default = FND_API.G_FALSE
207 -- p_validation_level IN NUMBER Optional
208 -- Default = FND_API.G_VALID_LEVEL_FULL
209 -- p_quota_name IN OUT VARCHAR2
210 -- p_revenue_class_rec_tbl IN OUT revenue_class_rec_tbl_type
211 -- p_rev_uplift_rec_tbl IN OUT rev_uplift_rec_tbl_type
212 -- p_rt_quota_asgns_rec_tbl IN OUT rt_quota_asgns_rec_tbl_type
213 --
214 -- OUT : x_return_status OUT VARCHAR2(1)
215 -- x_msg_count OUT NUMBER
216 -- x_msg_data OUT VARCHAR2(2000)
217 --
218 -- Version : Current version 1.0
219 -- Initial version 1.0
220 --
221 -- End of comments
222 --
223 PROCEDURE delete_plan_element_pre (
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226 p_commit IN VARCHAR2 := fnd_api.g_false,
227 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_quota_name IN OUT NOCOPY VARCHAR2,
232 p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
233 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
234 p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
235 x_loading_status OUT NOCOPY VARCHAR2
236 );
237
238 -- Start of Comments
239 -- API name : Delete_Plan_Element_Post
240 -- Type : Public.
241 -- Pre-reqs : None.
242 -- Usage : User Hook after Delete a plan element
243 -- Parameters :
244 -- IN : p_api_version IN NUMBER Require
245 -- p_init_msg_list IN VARCHAR2 Optional
246 -- Default = FND_API.G_FALSE
247 -- p_commit IN VARCHAR2 Optional
248 -- Default = FND_API.G_FALSE
249 -- p_validation_level IN NUMBER Optional
250 -- Default = FND_API.G_VALID_LEVEL_FULL
251 -- p_quota_name IN VARCHAR2
252 -- p_revenue_class_rec_tbl IN revenue_class_rec_tbl_type
253 -- p_rev_uplift_rec_tbl IN rev_uplift_rec_tbl_type
254 -- p_rt_quota_asgns_rec_tbl IN rt_quota_asgns_rec_tbl_type
255 --
256 -- OUT : x_return_status OUT VARCHAR2(1)
257 -- x_msg_count OUT NUMBER
258 -- x_msg_data OUT VARCHAR2(2000)
259 --
260 -- Version : Current version 1.0
261 -- Initial version 1.0
262 --
263 -- End of comments
264 --
265 PROCEDURE delete_plan_element_post (
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
268 p_commit IN VARCHAR2 := fnd_api.g_false,
269 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_quota_name IN VARCHAR2,
274 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
275 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
276 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
277 x_loading_status OUT NOCOPY VARCHAR2
278 );
279
280 -- Start Comments
281 -- API name : Duplicate_Plan_Element_Pre
282 -- Type : Public.
283 -- Pre-reqs : None.
284 -- Usage : User Hook before Duplicate a plan element
285 -- Parameters :
286 -- IN : p_api_version IN NUMBER Require
287 -- p_init_msg_list IN VARCHAR2 Optional
291 -- p_validation_level IN NUMBER Optional
288 -- Default = FND_API.G_FALSE
289 -- p_commit IN VARCHAR2 Optional
290 -- Default = FND_API.G_FALSE
292 -- Default = FND_API.G_VALID_LEVEL_FULL
293 -- p_plan_element_name IN OUT cn_quotas.name%TYPE
294 --
295 -- OUT : x_return_status OUT VARCHAR2(1)
296 -- x_msg_count OUT NUMBER
297 -- x_msg_data OUT VARCHAR2(2000)
298 -- x_plan_element_name IN OUT cn_quotas.name%TYPE
299 --
300 -- Version : Current version 1.0
301 -- Initial version 1.0
302 --
303 -- End of comments
304 --
305 PROCEDURE duplicate_plan_element_pre (
306 p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
308 p_commit IN VARCHAR2 := fnd_api.g_false,
309 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313 p_plan_element_name IN OUT NOCOPY cn_quotas.NAME%TYPE,
314 x_plan_element_name IN OUT NOCOPY cn_quotas.NAME%TYPE,
315 x_loading_status OUT NOCOPY VARCHAR2
316 );
317
318 -- Start Comments
319 -- API name : Duplicate_Plan_Element_Post
320 -- Type : Public.
321 -- Pre-reqs : None.
322 -- Usage : User Hook after Duplicate a plan element
323 -- Parameters :
324 -- IN : p_api_version IN NUMBER Require
325 -- p_init_msg_list IN VARCHAR2 Optional
326 -- Default = FND_API.G_FALSE
327 -- p_commit IN VARCHAR2 Optional
328 -- Default = FND_API.G_FALSE
329 -- p_validation_level IN NUMBER Optional
330 -- Default = FND_API.G_VALID_LEVEL_FULL
331 -- p_plan_element_name IN cn_quotas.name%TYPE
332 --
333 -- OUT : x_return_status OUT VARCHAR2(1)
334 -- x_msg_count OUT NUMBER
335 -- x_msg_data OUT VARCHAR2(2000)
336 -- x_plan_element_name IN OUT cn_quotas.name%TYPE
337 --
338 -- Version : Current version 1.0
339 -- Initial version 1.0
340 --
341 -- End of comments
342 --
343 PROCEDURE duplicate_plan_element_post (
344 p_api_version IN NUMBER,
345 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
346 p_commit IN VARCHAR2 := fnd_api.g_false,
347 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2,
351 p_plan_element_name IN cn_quotas.NAME%TYPE,
352 x_plan_element_name IN OUT NOCOPY cn_quotas.NAME%TYPE,
353 x_loading_status OUT NOCOPY VARCHAR2
354 );
355
356 -- Start of Comments
357 -- API name : Ok_To_Generate_Msg
358 -- Type : Public.
359 -- Pre-reqs : None.
360 -- Usage : Judge whether it is ok to generate message or not
361 -- Parameters :
362 -- IN : p_plan_element_rec IN Optional
363 -- p_revenue_class_rec_tbl IN Optional
364 -- p_rev_uplift_rec_tbl IN Optional
365 -- p_trx_factors_rec_tbl IN Optional
366 -- p_rt_quota_asgns_rec_tbl IN Optional
367 -- p_period_quotas_rec_tbl IN Optional
368 -- p_plan_element_name IN Optional
369 --
370 -- Version : Current version 1.0
371 -- Initial version 1.0
372 --
373 --
374 -- End of comments
375 --
376 FUNCTION ok_to_generate_msg (
377 p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378 p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380 p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381 p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
383 p_plan_element_name IN VARCHAR2 := NULL
384 )
385 RETURN BOOLEAN;
386 END cn_plan_element_cuhk;