[Home] [Help]
PACKAGE BODY: APPS.BEN_COMP_LEVEL_FACTORS_API
Source
1 Package Body ben_comp_level_factors_api as
2 /* $Header: beclfapi.pkb 120.0 2005/05/28 01:03:42 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_comp_level_factors_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_comp_level_factors >---------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_comp_level_factors
13 (p_validate in boolean default false
14 ,p_comp_lvl_fctr_id out nocopy number
15 ,p_name in varchar2 default null
16 ,p_comp_lvl_det_cd in varchar2 default null
17 ,p_comp_lvl_det_rl in number default null
18 ,p_comp_lvl_uom in varchar2 default null
19 ,p_comp_src_cd in varchar2 default null
20 ,p_no_mn_comp_flag in varchar2 default null
21 ,p_no_mx_comp_flag in varchar2 default null
22 ,p_mx_comp_val in number default null
23 ,p_mn_comp_val in number default null
24 ,p_rndg_cd in varchar2 default null
25 ,p_rndg_rl in number default null
26 ,p_defined_balance_id in number default null
27 ,p_bnfts_bal_id in number default null
28 ,p_comp_alt_val_to_use_cd in varchar2 default null
29 ,p_comp_calc_rl in number default null
30 ,p_business_group_id in number default null
31 ,p_proration_flag in Varchar2 default 'N'
32 ,p_start_day_mo in Varchar2 default null
33 ,p_end_day_mo in Varchar2 default null
34 ,p_start_year in Varchar2 default null
35 ,p_end_year in Varchar2 default null
36 ,p_clf_attribute_category in varchar2 default null
37 ,p_clf_attribute1 in varchar2 default null
38 ,p_clf_attribute2 in varchar2 default null
39 ,p_clf_attribute3 in varchar2 default null
40 ,p_clf_attribute4 in varchar2 default null
41 ,p_clf_attribute5 in varchar2 default null
42 ,p_clf_attribute6 in varchar2 default null
43 ,p_clf_attribute7 in varchar2 default null
44 ,p_clf_attribute8 in varchar2 default null
45 ,p_clf_attribute9 in varchar2 default null
46 ,p_clf_attribute10 in varchar2 default null
47 ,p_clf_attribute11 in varchar2 default null
48 ,p_clf_attribute12 in varchar2 default null
49 ,p_clf_attribute13 in varchar2 default null
50 ,p_clf_attribute14 in varchar2 default null
51 ,p_clf_attribute15 in varchar2 default null
52 ,p_clf_attribute16 in varchar2 default null
53 ,p_clf_attribute17 in varchar2 default null
54 ,p_clf_attribute18 in varchar2 default null
55 ,p_clf_attribute19 in varchar2 default null
56 ,p_clf_attribute20 in varchar2 default null
57 ,p_clf_attribute21 in varchar2 default null
58 ,p_clf_attribute22 in varchar2 default null
59 ,p_clf_attribute23 in varchar2 default null
60 ,p_clf_attribute24 in varchar2 default null
61 ,p_clf_attribute25 in varchar2 default null
62 ,p_clf_attribute26 in varchar2 default null
63 ,p_clf_attribute27 in varchar2 default null
64 ,p_clf_attribute28 in varchar2 default null
65 ,p_clf_attribute29 in varchar2 default null
66 ,p_clf_attribute30 in varchar2 default null
67 ,p_object_version_number out nocopy number
68 ,p_effective_date in date
69 ,p_sttd_sal_prdcty_cd in varchar2 default null
70 ) is
71 --
72 -- Declare cursors and local variables
73 --
74 l_comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%TYPE;
75 l_proc varchar2(72) := g_package||'create_comp_level_factors';
76 l_object_version_number ben_comp_lvl_fctr.object_version_number%TYPE;
77 --
78 begin
79 --
80 hr_utility.set_location('Entering:'|| l_proc, 10);
81 --
82 -- Issue a savepoint if operating in validation only mode
83 --
84 savepoint create_comp_level_factors;
85 --
86 hr_utility.set_location(l_proc, 20);
87 --
88 -- Process Logic
89 --
90 begin
91 --
92 -- Start of API User Hook for the before hook of create_comp_level_factors
93 --
94 ben_comp_level_factors_bk1.create_comp_level_factors_b
95 (
96 p_name => p_name
97 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
98 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
99 ,p_comp_lvl_uom => p_comp_lvl_uom
100 ,p_comp_src_cd => p_comp_src_cd
101 ,p_no_mn_comp_flag => p_no_mn_comp_flag
102 ,p_no_mx_comp_flag => p_no_mx_comp_flag
103 ,p_mx_comp_val => p_mx_comp_val
104 ,p_mn_comp_val => p_mn_comp_val
105 ,p_rndg_cd => p_rndg_cd
106 ,p_rndg_rl => p_rndg_rl
107 ,p_defined_balance_id => p_defined_balance_id
108 ,p_bnfts_bal_id => p_bnfts_bal_id
109 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
110 ,p_comp_calc_rl => p_comp_calc_rl
111 ,p_business_group_id => p_business_group_id
112 ,p_proration_flag => p_proration_flag
113 ,p_start_day_mo => p_start_day_mo
114 ,p_end_day_mo => p_end_day_mo
115 ,p_start_year => p_start_year
116 ,p_end_year => p_end_year
117 ,p_clf_attribute_category => p_clf_attribute_category
118 ,p_clf_attribute1 => p_clf_attribute1
119 ,p_clf_attribute2 => p_clf_attribute2
120 ,p_clf_attribute3 => p_clf_attribute3
121 ,p_clf_attribute4 => p_clf_attribute4
122 ,p_clf_attribute5 => p_clf_attribute5
123 ,p_clf_attribute6 => p_clf_attribute6
124 ,p_clf_attribute7 => p_clf_attribute7
125 ,p_clf_attribute8 => p_clf_attribute8
126 ,p_clf_attribute9 => p_clf_attribute9
127 ,p_clf_attribute10 => p_clf_attribute10
128 ,p_clf_attribute11 => p_clf_attribute11
129 ,p_clf_attribute12 => p_clf_attribute12
130 ,p_clf_attribute13 => p_clf_attribute13
131 ,p_clf_attribute14 => p_clf_attribute14
132 ,p_clf_attribute15 => p_clf_attribute15
133 ,p_clf_attribute16 => p_clf_attribute16
134 ,p_clf_attribute17 => p_clf_attribute17
135 ,p_clf_attribute18 => p_clf_attribute18
136 ,p_clf_attribute19 => p_clf_attribute19
137 ,p_clf_attribute20 => p_clf_attribute20
138 ,p_clf_attribute21 => p_clf_attribute21
139 ,p_clf_attribute22 => p_clf_attribute22
140 ,p_clf_attribute23 => p_clf_attribute23
141 ,p_clf_attribute24 => p_clf_attribute24
142 ,p_clf_attribute25 => p_clf_attribute25
143 ,p_clf_attribute26 => p_clf_attribute26
144 ,p_clf_attribute27 => p_clf_attribute27
145 ,p_clf_attribute28 => p_clf_attribute28
146 ,p_clf_attribute29 => p_clf_attribute29
147 ,p_clf_attribute30 => p_clf_attribute30
148 ,p_effective_date => trunc(p_effective_date)
149 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
150 );
151 exception
152 when hr_api.cannot_find_prog_unit then
153 hr_api.cannot_find_prog_unit_error
154 (
155 p_module_name => 'CREATE_comp_level_factors'
156 ,p_hook_type => 'BP'
157 );
158 --
159 -- End of API User Hook for the before hook of create_comp_level_factors
160 --
161 end;
162 --
163 ben_clf_ins.ins
164 (
165 p_comp_lvl_fctr_id => l_comp_lvl_fctr_id
166 ,p_name => p_name
167 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
168 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
169 ,p_comp_lvl_uom => p_comp_lvl_uom
170 ,p_comp_src_cd => p_comp_src_cd
171 ,p_no_mn_comp_flag => p_no_mn_comp_flag
172 ,p_no_mx_comp_flag => p_no_mx_comp_flag
173 ,p_mx_comp_val => p_mx_comp_val
174 ,p_mn_comp_val => p_mn_comp_val
175 ,p_rndg_cd => p_rndg_cd
176 ,p_rndg_rl => p_rndg_rl
177 ,p_defined_balance_id => p_defined_balance_id
178 ,p_bnfts_bal_id => p_bnfts_bal_id
179 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
180 ,p_comp_calc_rl => p_comp_calc_rl
181 ,p_business_group_id => p_business_group_id
182 ,p_proration_flag => p_proration_flag
183 ,p_start_day_mo => p_start_day_mo
184 ,p_end_day_mo => p_end_day_mo
185 ,p_start_year => p_start_year
186 ,p_end_year => p_end_year
187 ,p_clf_attribute_category => p_clf_attribute_category
188 ,p_clf_attribute1 => p_clf_attribute1
189 ,p_clf_attribute2 => p_clf_attribute2
190 ,p_clf_attribute3 => p_clf_attribute3
191 ,p_clf_attribute4 => p_clf_attribute4
192 ,p_clf_attribute5 => p_clf_attribute5
193 ,p_clf_attribute6 => p_clf_attribute6
194 ,p_clf_attribute7 => p_clf_attribute7
195 ,p_clf_attribute8 => p_clf_attribute8
196 ,p_clf_attribute9 => p_clf_attribute9
197 ,p_clf_attribute10 => p_clf_attribute10
198 ,p_clf_attribute11 => p_clf_attribute11
199 ,p_clf_attribute12 => p_clf_attribute12
200 ,p_clf_attribute13 => p_clf_attribute13
201 ,p_clf_attribute14 => p_clf_attribute14
202 ,p_clf_attribute15 => p_clf_attribute15
203 ,p_clf_attribute16 => p_clf_attribute16
204 ,p_clf_attribute17 => p_clf_attribute17
205 ,p_clf_attribute18 => p_clf_attribute18
206 ,p_clf_attribute19 => p_clf_attribute19
207 ,p_clf_attribute20 => p_clf_attribute20
208 ,p_clf_attribute21 => p_clf_attribute21
209 ,p_clf_attribute22 => p_clf_attribute22
210 ,p_clf_attribute23 => p_clf_attribute23
211 ,p_clf_attribute24 => p_clf_attribute24
212 ,p_clf_attribute25 => p_clf_attribute25
213 ,p_clf_attribute26 => p_clf_attribute26
214 ,p_clf_attribute27 => p_clf_attribute27
215 ,p_clf_attribute28 => p_clf_attribute28
216 ,p_clf_attribute29 => p_clf_attribute29
217 ,p_clf_attribute30 => p_clf_attribute30
218 ,p_object_version_number => l_object_version_number
219 ,p_effective_date => trunc(p_effective_date)
220 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
221 );
222 --
223 begin
224 --
225 -- Start of API User Hook for the after hook of create_comp_level_factors
226 --
227 ben_comp_level_factors_bk1.create_comp_level_factors_a
228 (
229 p_comp_lvl_fctr_id => l_comp_lvl_fctr_id
230 ,p_name => p_name
231 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
232 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
233 ,p_comp_lvl_uom => p_comp_lvl_uom
234 ,p_comp_src_cd => p_comp_src_cd
235 ,p_no_mn_comp_flag => p_no_mn_comp_flag
236 ,p_no_mx_comp_flag => p_no_mx_comp_flag
237 ,p_mx_comp_val => p_mx_comp_val
238 ,p_mn_comp_val => p_mn_comp_val
239 ,p_rndg_cd => p_rndg_cd
240 ,p_rndg_rl => p_rndg_rl
241 ,p_defined_balance_id => p_defined_balance_id
242 ,p_bnfts_bal_id => p_bnfts_bal_id
243 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
244 ,p_comp_calc_rl => p_comp_calc_rl
245 ,p_business_group_id => p_business_group_id
246 ,p_proration_flag => p_proration_flag
247 ,p_start_day_mo => p_start_day_mo
248 ,p_end_day_mo => p_end_day_mo
249 ,p_start_year => p_start_year
250 ,p_end_year => p_end_year
251 ,p_clf_attribute_category => p_clf_attribute_category
252 ,p_clf_attribute1 => p_clf_attribute1
253 ,p_clf_attribute2 => p_clf_attribute2
254 ,p_clf_attribute3 => p_clf_attribute3
255 ,p_clf_attribute4 => p_clf_attribute4
256 ,p_clf_attribute5 => p_clf_attribute5
257 ,p_clf_attribute6 => p_clf_attribute6
258 ,p_clf_attribute7 => p_clf_attribute7
259 ,p_clf_attribute8 => p_clf_attribute8
260 ,p_clf_attribute9 => p_clf_attribute9
261 ,p_clf_attribute10 => p_clf_attribute10
262 ,p_clf_attribute11 => p_clf_attribute11
263 ,p_clf_attribute12 => p_clf_attribute12
264 ,p_clf_attribute13 => p_clf_attribute13
265 ,p_clf_attribute14 => p_clf_attribute14
266 ,p_clf_attribute15 => p_clf_attribute15
267 ,p_clf_attribute16 => p_clf_attribute16
268 ,p_clf_attribute17 => p_clf_attribute17
269 ,p_clf_attribute18 => p_clf_attribute18
270 ,p_clf_attribute19 => p_clf_attribute19
271 ,p_clf_attribute20 => p_clf_attribute20
272 ,p_clf_attribute21 => p_clf_attribute21
273 ,p_clf_attribute22 => p_clf_attribute22
274 ,p_clf_attribute23 => p_clf_attribute23
275 ,p_clf_attribute24 => p_clf_attribute24
276 ,p_clf_attribute25 => p_clf_attribute25
277 ,p_clf_attribute26 => p_clf_attribute26
278 ,p_clf_attribute27 => p_clf_attribute27
279 ,p_clf_attribute28 => p_clf_attribute28
280 ,p_clf_attribute29 => p_clf_attribute29
281 ,p_clf_attribute30 => p_clf_attribute30
282 ,p_object_version_number => l_object_version_number
283 ,p_effective_date => trunc(p_effective_date)
284 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
285 );
286 exception
287 when hr_api.cannot_find_prog_unit then
288 hr_api.cannot_find_prog_unit_error
289 (p_module_name => 'CREATE_comp_level_factors'
290 ,p_hook_type => 'AP'
291 );
292 --
293 -- End of API User Hook for the after hook of create_comp_level_factors
294 --
295 end;
296 --
297 hr_utility.set_location(l_proc, 60);
298 --
299 -- When in validation only mode raise the Validate_Enabled exception
300 --
301 if p_validate then
302 raise hr_api.validate_enabled;
303 end if;
304 --
305 -- Set all output arguments
306 --
307 p_comp_lvl_fctr_id := l_comp_lvl_fctr_id;
308 p_object_version_number := l_object_version_number;
309 --
310 hr_utility.set_location(' Leaving:'||l_proc, 70);
311 --
312 exception
313 --
314 when hr_api.validate_enabled then
315 --
316 -- As the Validate_Enabled exception has been raised
317 -- we must rollback to the savepoint
318 --
319 ROLLBACK TO create_comp_level_factors;
320 --
321 -- Only set output warning arguments
322 -- (Any key or derived arguments must be set to null
323 -- when validation only mode is being used.)
324 --
325 p_comp_lvl_fctr_id := null;
326 p_object_version_number := null;
327 hr_utility.set_location(' Leaving:'||l_proc, 80);
328 --
329 when others then
330 --
331 -- A validation or unexpected error has occured
332 --
333 ROLLBACK TO create_comp_level_factors;
334 /* Inserted for nocopy changes */
335 p_object_version_number := l_object_version_number;
336 raise;
337 --
338 end create_comp_level_factors;
339 -- ----------------------------------------------------------------------------
340 -- |------------------------< update_comp_level_factors >--- ------------------|
341 -- ----------------------------------------------------------------------------
342 --
343 procedure update_comp_level_factors
344 (p_validate in boolean default false
345 ,p_comp_lvl_fctr_id in number
346 ,p_name in varchar2 default hr_api.g_varchar2
347 ,p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2
348 ,p_comp_lvl_det_rl in number default hr_api.g_number
349 ,p_comp_lvl_uom in varchar2 default hr_api.g_varchar2
350 ,p_comp_src_cd in varchar2 default hr_api.g_varchar2
351 ,p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2
352 ,p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2
353 ,p_mx_comp_val in number default hr_api.g_number
354 ,p_mn_comp_val in number default hr_api.g_number
355 ,p_rndg_cd in varchar2 default hr_api.g_varchar2
356 ,p_rndg_rl in number default hr_api.g_number
357 ,p_defined_balance_id in number default hr_api.g_number
358 ,p_bnfts_bal_id in number default hr_api.g_number
359 ,p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
360 ,p_comp_calc_rl in number default hr_api.g_number
361 ,p_business_group_id in number default hr_api.g_number
362 ,p_proration_flag in varchar2 default hr_api.g_varchar2
363 ,p_start_day_mo in varchar2 default hr_api.g_varchar2
364 ,p_end_day_mo in varchar2 default hr_api.g_varchar2
365 ,p_start_year in varchar2 default hr_api.g_varchar2
366 ,p_end_year in varchar2 default hr_api.g_varchar2
367 ,p_clf_attribute_category in varchar2 default hr_api.g_varchar2
368 ,p_clf_attribute1 in varchar2 default hr_api.g_varchar2
369 ,p_clf_attribute2 in varchar2 default hr_api.g_varchar2
370 ,p_clf_attribute3 in varchar2 default hr_api.g_varchar2
371 ,p_clf_attribute4 in varchar2 default hr_api.g_varchar2
372 ,p_clf_attribute5 in varchar2 default hr_api.g_varchar2
373 ,p_clf_attribute6 in varchar2 default hr_api.g_varchar2
374 ,p_clf_attribute7 in varchar2 default hr_api.g_varchar2
375 ,p_clf_attribute8 in varchar2 default hr_api.g_varchar2
376 ,p_clf_attribute9 in varchar2 default hr_api.g_varchar2
377 ,p_clf_attribute10 in varchar2 default hr_api.g_varchar2
378 ,p_clf_attribute11 in varchar2 default hr_api.g_varchar2
379 ,p_clf_attribute12 in varchar2 default hr_api.g_varchar2
380 ,p_clf_attribute13 in varchar2 default hr_api.g_varchar2
381 ,p_clf_attribute14 in varchar2 default hr_api.g_varchar2
382 ,p_clf_attribute15 in varchar2 default hr_api.g_varchar2
383 ,p_clf_attribute16 in varchar2 default hr_api.g_varchar2
384 ,p_clf_attribute17 in varchar2 default hr_api.g_varchar2
385 ,p_clf_attribute18 in varchar2 default hr_api.g_varchar2
386 ,p_clf_attribute19 in varchar2 default hr_api.g_varchar2
387 ,p_clf_attribute20 in varchar2 default hr_api.g_varchar2
388 ,p_clf_attribute21 in varchar2 default hr_api.g_varchar2
389 ,p_clf_attribute22 in varchar2 default hr_api.g_varchar2
390 ,p_clf_attribute23 in varchar2 default hr_api.g_varchar2
391 ,p_clf_attribute24 in varchar2 default hr_api.g_varchar2
392 ,p_clf_attribute25 in varchar2 default hr_api.g_varchar2
393 ,p_clf_attribute26 in varchar2 default hr_api.g_varchar2
394 ,p_clf_attribute27 in varchar2 default hr_api.g_varchar2
395 ,p_clf_attribute28 in varchar2 default hr_api.g_varchar2
396 ,p_clf_attribute29 in varchar2 default hr_api.g_varchar2
397 ,p_clf_attribute30 in varchar2 default hr_api.g_varchar2
398 ,p_object_version_number in out nocopy number
399 ,p_effective_date in date
400 ,p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
401 ) is
402 --
403 -- Declare cursors and local variables
404 --
405 l_proc varchar2(72) := g_package||'update_comp_level_factors';
406 l_object_version_number ben_comp_lvl_fctr.object_version_number%TYPE;
407 l_in_object_version_number number := p_object_version_number ;
408 --
409 begin
410 --
411 hr_utility.set_location('Entering:'|| l_proc, 10);
412 --
413 -- Issue a savepoint if operating in validation only mode
414 --
415 savepoint update_comp_level_factors;
416 --
417 hr_utility.set_location(l_proc, 20);
418 --
419 -- Process Logic
420 --
421 l_object_version_number := p_object_version_number;
422 --
423 begin
424 --
425 -- Start of API User Hook for the before hook of update_comp_level_factors
426 --
427 ben_comp_level_factors_bk2.update_comp_level_factors_b
428 (
429 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
430 ,p_name => p_name
431 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
432 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
433 ,p_comp_lvl_uom => p_comp_lvl_uom
434 ,p_comp_src_cd => p_comp_src_cd
435 ,p_no_mn_comp_flag => p_no_mn_comp_flag
436 ,p_no_mx_comp_flag => p_no_mx_comp_flag
437 ,p_mx_comp_val => p_mx_comp_val
438 ,p_mn_comp_val => p_mn_comp_val
439 ,p_rndg_cd => p_rndg_cd
440 ,p_rndg_rl => p_rndg_rl
441 ,p_defined_balance_id => p_defined_balance_id
442 ,p_bnfts_bal_id => p_bnfts_bal_id
443 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
444 ,p_comp_calc_rl => p_comp_calc_rl
445 ,p_business_group_id => p_business_group_id
446 ,p_proration_flag => p_proration_flag
447 ,p_start_day_mo => p_start_day_mo
448 ,p_end_day_mo => p_end_day_mo
449 ,p_start_year => p_start_year
450 ,p_end_year => p_end_year
451 ,p_clf_attribute_category => p_clf_attribute_category
452 ,p_clf_attribute1 => p_clf_attribute1
453 ,p_clf_attribute2 => p_clf_attribute2
454 ,p_clf_attribute3 => p_clf_attribute3
455 ,p_clf_attribute4 => p_clf_attribute4
456 ,p_clf_attribute5 => p_clf_attribute5
457 ,p_clf_attribute6 => p_clf_attribute6
458 ,p_clf_attribute7 => p_clf_attribute7
459 ,p_clf_attribute8 => p_clf_attribute8
460 ,p_clf_attribute9 => p_clf_attribute9
461 ,p_clf_attribute10 => p_clf_attribute10
462 ,p_clf_attribute11 => p_clf_attribute11
463 ,p_clf_attribute12 => p_clf_attribute12
464 ,p_clf_attribute13 => p_clf_attribute13
465 ,p_clf_attribute14 => p_clf_attribute14
466 ,p_clf_attribute15 => p_clf_attribute15
467 ,p_clf_attribute16 => p_clf_attribute16
468 ,p_clf_attribute17 => p_clf_attribute17
469 ,p_clf_attribute18 => p_clf_attribute18
470 ,p_clf_attribute19 => p_clf_attribute19
471 ,p_clf_attribute20 => p_clf_attribute20
472 ,p_clf_attribute21 => p_clf_attribute21
473 ,p_clf_attribute22 => p_clf_attribute22
474 ,p_clf_attribute23 => p_clf_attribute23
475 ,p_clf_attribute24 => p_clf_attribute24
476 ,p_clf_attribute25 => p_clf_attribute25
477 ,p_clf_attribute26 => p_clf_attribute26
478 ,p_clf_attribute27 => p_clf_attribute27
479 ,p_clf_attribute28 => p_clf_attribute28
480 ,p_clf_attribute29 => p_clf_attribute29
481 ,p_clf_attribute30 => p_clf_attribute30
482 ,p_object_version_number => p_object_version_number
483 ,p_effective_date => trunc(p_effective_date)
484 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
485 );
486 exception
487 when hr_api.cannot_find_prog_unit then
488 hr_api.cannot_find_prog_unit_error
489 (p_module_name => 'UPDATE_comp_level_factors'
490 ,p_hook_type => 'BP'
491 );
492 --
493 -- End of API User Hook for the before hook of update_comp_level_factors
494 --
495 end;
496 --
497 ben_clf_upd.upd
498 (
499 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
500 ,p_name => p_name
501 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
502 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
503 ,p_comp_lvl_uom => p_comp_lvl_uom
504 ,p_comp_src_cd => p_comp_src_cd
505 ,p_no_mn_comp_flag => p_no_mn_comp_flag
506 ,p_no_mx_comp_flag => p_no_mx_comp_flag
507 ,p_mx_comp_val => p_mx_comp_val
508 ,p_mn_comp_val => p_mn_comp_val
509 ,p_rndg_cd => p_rndg_cd
510 ,p_rndg_rl => p_rndg_rl
511 ,p_defined_balance_id => p_defined_balance_id
512 ,p_bnfts_bal_id => p_bnfts_bal_id
513 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
514 ,p_comp_calc_rl => p_comp_calc_rl
515 ,p_business_group_id => p_business_group_id
516 ,p_proration_flag => p_proration_flag
517 ,p_start_day_mo => p_start_day_mo
518 ,p_end_day_mo => p_end_day_mo
519 ,p_start_year => p_start_year
520 ,p_end_year => p_end_year
521 ,p_clf_attribute_category => p_clf_attribute_category
522 ,p_clf_attribute1 => p_clf_attribute1
523 ,p_clf_attribute2 => p_clf_attribute2
524 ,p_clf_attribute3 => p_clf_attribute3
525 ,p_clf_attribute4 => p_clf_attribute4
526 ,p_clf_attribute5 => p_clf_attribute5
527 ,p_clf_attribute6 => p_clf_attribute6
528 ,p_clf_attribute7 => p_clf_attribute7
529 ,p_clf_attribute8 => p_clf_attribute8
530 ,p_clf_attribute9 => p_clf_attribute9
531 ,p_clf_attribute10 => p_clf_attribute10
532 ,p_clf_attribute11 => p_clf_attribute11
533 ,p_clf_attribute12 => p_clf_attribute12
534 ,p_clf_attribute13 => p_clf_attribute13
535 ,p_clf_attribute14 => p_clf_attribute14
536 ,p_clf_attribute15 => p_clf_attribute15
537 ,p_clf_attribute16 => p_clf_attribute16
538 ,p_clf_attribute17 => p_clf_attribute17
539 ,p_clf_attribute18 => p_clf_attribute18
540 ,p_clf_attribute19 => p_clf_attribute19
541 ,p_clf_attribute20 => p_clf_attribute20
542 ,p_clf_attribute21 => p_clf_attribute21
543 ,p_clf_attribute22 => p_clf_attribute22
544 ,p_clf_attribute23 => p_clf_attribute23
545 ,p_clf_attribute24 => p_clf_attribute24
546 ,p_clf_attribute25 => p_clf_attribute25
547 ,p_clf_attribute26 => p_clf_attribute26
548 ,p_clf_attribute27 => p_clf_attribute27
549 ,p_clf_attribute28 => p_clf_attribute28
550 ,p_clf_attribute29 => p_clf_attribute29
551 ,p_clf_attribute30 => p_clf_attribute30
552 ,p_object_version_number => l_object_version_number
553 ,p_effective_date => trunc(p_effective_date)
554 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
555 );
556 --
557 begin
558 --
559 -- Start of API User Hook for the after hook of update_comp_level_factors
560 --
561 ben_comp_level_factors_bk2.update_comp_level_factors_a
562 (
563 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
564 ,p_name => p_name
565 ,p_comp_lvl_det_cd => p_comp_lvl_det_cd
566 ,p_comp_lvl_det_rl => p_comp_lvl_det_rl
567 ,p_comp_lvl_uom => p_comp_lvl_uom
568 ,p_comp_src_cd => p_comp_src_cd
569 ,p_no_mn_comp_flag => p_no_mn_comp_flag
570 ,p_no_mx_comp_flag => p_no_mx_comp_flag
571 ,p_mx_comp_val => p_mx_comp_val
572 ,p_mn_comp_val => p_mn_comp_val
573 ,p_rndg_cd => p_rndg_cd
574 ,p_rndg_rl => p_rndg_rl
575 ,p_defined_balance_id => p_defined_balance_id
576 ,p_bnfts_bal_id => p_bnfts_bal_id
577 ,p_comp_alt_val_to_use_cd => p_comp_alt_val_to_use_cd
578 ,p_comp_calc_rl => p_comp_calc_rl
579 ,p_business_group_id => p_business_group_id
580 ,p_proration_flag => p_proration_flag
581 ,p_start_day_mo => p_start_day_mo
582 ,p_end_day_mo => p_end_day_mo
583 ,p_start_year => p_start_year
584 ,p_end_year => p_end_year
585 ,p_clf_attribute_category => p_clf_attribute_category
586 ,p_clf_attribute1 => p_clf_attribute1
587 ,p_clf_attribute2 => p_clf_attribute2
588 ,p_clf_attribute3 => p_clf_attribute3
589 ,p_clf_attribute4 => p_clf_attribute4
590 ,p_clf_attribute5 => p_clf_attribute5
591 ,p_clf_attribute6 => p_clf_attribute6
592 ,p_clf_attribute7 => p_clf_attribute7
593 ,p_clf_attribute8 => p_clf_attribute8
594 ,p_clf_attribute9 => p_clf_attribute9
595 ,p_clf_attribute10 => p_clf_attribute10
596 ,p_clf_attribute11 => p_clf_attribute11
597 ,p_clf_attribute12 => p_clf_attribute12
598 ,p_clf_attribute13 => p_clf_attribute13
599 ,p_clf_attribute14 => p_clf_attribute14
600 ,p_clf_attribute15 => p_clf_attribute15
601 ,p_clf_attribute16 => p_clf_attribute16
602 ,p_clf_attribute17 => p_clf_attribute17
603 ,p_clf_attribute18 => p_clf_attribute18
604 ,p_clf_attribute19 => p_clf_attribute19
605 ,p_clf_attribute20 => p_clf_attribute20
606 ,p_clf_attribute21 => p_clf_attribute21
607 ,p_clf_attribute22 => p_clf_attribute22
608 ,p_clf_attribute23 => p_clf_attribute23
609 ,p_clf_attribute24 => p_clf_attribute24
610 ,p_clf_attribute25 => p_clf_attribute25
611 ,p_clf_attribute26 => p_clf_attribute26
612 ,p_clf_attribute27 => p_clf_attribute27
613 ,p_clf_attribute28 => p_clf_attribute28
614 ,p_clf_attribute29 => p_clf_attribute29
615 ,p_clf_attribute30 => p_clf_attribute30
616 ,p_object_version_number => l_object_version_number
617 ,p_effective_date => trunc(p_effective_date)
618 ,p_sttd_sal_prdcty_cd => p_sttd_sal_prdcty_cd
619 );
620 exception
621 when hr_api.cannot_find_prog_unit then
622 hr_api.cannot_find_prog_unit_error
623 (p_module_name => 'UPDATE_comp_level_factors'
624 ,p_hook_type => 'AP'
625 );
626 --
627 -- End of API User Hook for the after hook of update_comp_level_factors
628 --
629 end;
630 --
631 hr_utility.set_location(l_proc, 60);
632 --
633 -- When in validation only mode raise the Validate_Enabled exception
634 --
635 if p_validate then
636 raise hr_api.validate_enabled;
637 end if;
638 --
639 -- Set all output arguments
640 --
641 p_object_version_number := l_object_version_number;
642 --
643 hr_utility.set_location(' Leaving:'||l_proc, 70);
644 --
645 exception
646 --
647 when hr_api.validate_enabled then
648 --
649 -- As the Validate_Enabled exception has been raised
650 -- we must rollback to the savepoint
651 --
652 ROLLBACK TO update_comp_level_factors;
653 --
654 -- Only set output warning arguments
655 -- (Any key or derived arguments must be set to null
656 -- when validation only mode is being used.)
657 --
658 hr_utility.set_location(' Leaving:'||l_proc, 80);
659 --
660 when others then
661 --
662 -- A validation or unexpected error has occured
663 p_object_version_number := l_in_object_version_number ;
664 --
665 ROLLBACK TO update_comp_level_factors;
666 /* Inserted for nocopy changes */
667 raise;
668 --
669 end update_comp_level_factors;
670 -- ----------------------------------------------------------------------------
671 -- |------------------------< delete_comp_level_factors >----------------------|
672 -- ----------------------------------------------------------------------------
673 --
674 procedure delete_comp_level_factors
675 (p_validate in boolean default false
676 ,p_comp_lvl_fctr_id in number
677 ,p_object_version_number in out nocopy number
678 ,p_effective_date in date
679 ) is
680 --
681 -- Declare cursors and local variables
682 --
683 l_proc varchar2(72) := g_package||'update_comp_level_factors';
684 l_object_version_number ben_comp_lvl_fctr.object_version_number%TYPE;
685 l_in_object_version_number number := p_object_version_number ;
686 --
687 begin
688 --
689 hr_utility.set_location('Entering:'|| l_proc, 10);
690 --
691 -- Issue a savepoint if operating in validation only mode
692 --
693 savepoint delete_comp_level_factors;
694 --
695 hr_utility.set_location(l_proc, 20);
696 --
697 -- Process Logic
698 --
699 l_object_version_number := p_object_version_number;
700 --
701 --
702 begin
703 --
704 -- Start of API User Hook for the before hook of delete_comp_level_factors
705 --
706 ben_comp_level_factors_bk3.delete_comp_level_factors_b
707 (
708 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
709 ,p_object_version_number => p_object_version_number
710 ,p_effective_date => trunc(p_effective_date)
711 );
712 exception
713 when hr_api.cannot_find_prog_unit then
714 hr_api.cannot_find_prog_unit_error
715 (p_module_name => 'DELETE_comp_level_factors'
716 ,p_hook_type => 'BP'
717 );
718 --
719 -- End of API User Hook for the before hook of delete_comp_level_factors
720 --
721 end;
722 --
723 ben_clf_del.del
724 (
725 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
726 ,p_object_version_number => l_object_version_number
727 ,p_effective_date => p_effective_date
728 );
729 --
730 begin
731 --
732 -- Start of API User Hook for the after hook of delete_comp_level_factors
733 --
734 ben_comp_level_factors_bk3.delete_comp_level_factors_a
735 (
736 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
737 ,p_object_version_number => l_object_version_number
738 ,p_effective_date => trunc(p_effective_date)
739 );
740 exception
741 when hr_api.cannot_find_prog_unit then
742 hr_api.cannot_find_prog_unit_error
743 (p_module_name => 'DELETE_comp_level_factors'
744 ,p_hook_type => 'AP'
745 );
746 --
747 -- End of API User Hook for the after hook of delete_comp_level_factors
748 --
749 end;
750 --
751 hr_utility.set_location(l_proc, 60);
752 --
753 -- When in validation only mode raise the Validate_Enabled exception
754 --
755 if p_validate then
756 raise hr_api.validate_enabled;
757 end if;
758 --
759 hr_utility.set_location(' Leaving:'||l_proc, 70);
760 --
761 exception
762 --
763 when hr_api.validate_enabled then
764 --
765 -- As the Validate_Enabled exception has been raised
766 -- we must rollback to the savepoint
767 --
768 ROLLBACK TO delete_comp_level_factors;
769 --
770 -- Only set output warning arguments
771 -- (Any key or derived arguments must be set to null
772 -- when validation only mode is being used.)
773 --
774 --
775 when others then
776 --
777 -- A validation or unexpected error has occured
778 --
779 p_object_version_number := l_in_object_version_number ;
780 ROLLBACK TO delete_comp_level_factors;
781 raise;
782 --
783 end delete_comp_level_factors;
784 --
785 -- ----------------------------------------------------------------------------
786 -- |-------------------------------< lck >------------------------------------|
787 -- ----------------------------------------------------------------------------
788 --
789 procedure lck
790 (
791 p_comp_lvl_fctr_id in number
792 ,p_object_version_number in number
793 ) is
794 --
795 --
796 -- Declare cursors and local variables
797 --
798 l_proc varchar2(72) := g_package||'lck';
799 --
800 begin
801 --
802 hr_utility.set_location('Entering:'|| l_proc, 10);
803 --
804 ben_clf_shd.lck
805 (
806 p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
807 ,p_object_version_number => p_object_version_number
808 );
809 --
810 hr_utility.set_location(' Leaving:'||l_proc, 70);
811 --
812 end lck;
813 --
814 end ben_comp_level_factors_api;