[Home] [Help]
PACKAGE BODY: APPS.BEN_ELIG_OBJ_ELIG_PROFL_API
Source
1 Package Body ben_ELIG_OBJ_ELIG_PROFL_api as
2 /* $Header: bebepapi.pkb 120.0 2005/05/28 00:39:02 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_ELIG_OBJ_ELIG_PROFL_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_ELIG_OBJ_ELIG_PROFL >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_ELIG_OBJ_ELIG_PROFL
13 (p_validate in boolean default false
14 ,p_elig_obj_elig_prfl_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_business_group_id in number default null
18 ,p_elig_obj_id in number default null
19 ,p_elig_prfl_id in number default null
20 ,p_mndtry_flag in varchar2 default null
21 ,p_bep_attribute_category in varchar2 default null
22 ,p_bep_attribute1 in varchar2 default null
23 ,p_bep_attribute2 in varchar2 default null
24 ,p_bep_attribute3 in varchar2 default null
25 ,p_bep_attribute4 in varchar2 default null
26 ,p_bep_attribute5 in varchar2 default null
27 ,p_bep_attribute6 in varchar2 default null
28 ,p_bep_attribute7 in varchar2 default null
29 ,p_bep_attribute8 in varchar2 default null
30 ,p_bep_attribute9 in varchar2 default null
31 ,p_bep_attribute10 in varchar2 default null
32 ,p_bep_attribute11 in varchar2 default null
33 ,p_bep_attribute12 in varchar2 default null
34 ,p_bep_attribute13 in varchar2 default null
35 ,p_bep_attribute14 in varchar2 default null
36 ,p_bep_attribute15 in varchar2 default null
37 ,p_bep_attribute16 in varchar2 default null
38 ,p_bep_attribute17 in varchar2 default null
39 ,p_bep_attribute18 in varchar2 default null
40 ,p_bep_attribute19 in varchar2 default null
41 ,p_bep_attribute20 in varchar2 default null
42 ,p_object_version_number out nocopy number
43 ,p_effective_date in date
44 ) is
45 --
46 -- Declare cursors and local variables
47 --
48 l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49 l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50 l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51 l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52 l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53 --
54 begin
55 --
56 hr_utility.set_location('Entering:'|| l_proc, 10);
57 --
58 -- Issue a savepoint if operating in validation only mode
59 --
60 savepoint create_ELIG_OBJ_ELIG_PROFL;
61 --
62 hr_utility.set_location(l_proc, 20);
63 --
64 -- Process Logic
65 --
66 begin
67 --
68 -- Start of API User Hook for the before hook of create_ELIG_OBJ_ELIG_PROFL
69 --
70 ben_ELIG_OBJ_ELIG_PROFL_bk1.create_ELIG_OBJ_ELIG_PROFL_b
71 (
72 p_business_group_id => p_business_group_id
73 ,p_elig_obj_id => p_elig_obj_id
74 ,p_elig_prfl_id => p_elig_prfl_id
75 ,p_mndtry_flag => p_mndtry_flag
76 ,p_bep_attribute_category => p_bep_attribute_category
77 ,p_bep_attribute1 => p_bep_attribute1
78 ,p_bep_attribute2 => p_bep_attribute2
79 ,p_bep_attribute3 => p_bep_attribute3
80 ,p_bep_attribute4 => p_bep_attribute4
81 ,p_bep_attribute5 => p_bep_attribute5
82 ,p_bep_attribute6 => p_bep_attribute6
83 ,p_bep_attribute7 => p_bep_attribute7
84 ,p_bep_attribute8 => p_bep_attribute8
85 ,p_bep_attribute9 => p_bep_attribute9
86 ,p_bep_attribute10 => p_bep_attribute10
87 ,p_bep_attribute11 => p_bep_attribute11
88 ,p_bep_attribute12 => p_bep_attribute12
89 ,p_bep_attribute13 => p_bep_attribute13
90 ,p_bep_attribute14 => p_bep_attribute14
91 ,p_bep_attribute15 => p_bep_attribute15
92 ,p_bep_attribute16 => p_bep_attribute16
93 ,p_bep_attribute17 => p_bep_attribute17
94 ,p_bep_attribute18 => p_bep_attribute18
95 ,p_bep_attribute19 => p_bep_attribute19
96 ,p_bep_attribute20 => p_bep_attribute20
97 ,p_effective_date => trunc(p_effective_date)
98 );
99 exception
100 when hr_api.cannot_find_prog_unit then
101 hr_api.cannot_find_prog_unit_error
102 (
103 p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
104 ,p_hook_type => 'BP'
105 );
106 --
107 -- End of API User Hook for the before hook of create_ELIG_OBJ_ELIG_PROFL
108 --
109 end;
110 --
111 ben_bep_ins.ins
112 (
113 p_elig_obj_elig_prfl_id => l_elig_obj_elig_prfl_id
114 ,p_effective_start_date => l_effective_start_date
115 ,p_effective_end_date => l_effective_end_date
116 ,p_business_group_id => p_business_group_id
117 ,p_elig_obj_id => p_elig_obj_id
118 ,p_elig_prfl_id => p_elig_prfl_id
119 ,p_mndtry_flag => p_mndtry_flag
120 ,p_bep_attribute_category => p_bep_attribute_category
121 ,p_bep_attribute1 => p_bep_attribute1
122 ,p_bep_attribute2 => p_bep_attribute2
123 ,p_bep_attribute3 => p_bep_attribute3
124 ,p_bep_attribute4 => p_bep_attribute4
125 ,p_bep_attribute5 => p_bep_attribute5
126 ,p_bep_attribute6 => p_bep_attribute6
127 ,p_bep_attribute7 => p_bep_attribute7
128 ,p_bep_attribute8 => p_bep_attribute8
129 ,p_bep_attribute9 => p_bep_attribute9
130 ,p_bep_attribute10 => p_bep_attribute10
131 ,p_bep_attribute11 => p_bep_attribute11
132 ,p_bep_attribute12 => p_bep_attribute12
133 ,p_bep_attribute13 => p_bep_attribute13
134 ,p_bep_attribute14 => p_bep_attribute14
135 ,p_bep_attribute15 => p_bep_attribute15
136 ,p_bep_attribute16 => p_bep_attribute16
137 ,p_bep_attribute17 => p_bep_attribute17
138 ,p_bep_attribute18 => p_bep_attribute18
139 ,p_bep_attribute19 => p_bep_attribute19
140 ,p_bep_attribute20 => p_bep_attribute20
141 ,p_object_version_number => l_object_version_number
142 ,p_effective_date => trunc(p_effective_date)
143 );
144 --
145 begin
146 --
147 -- Start of API User Hook for the after hook of create_ELIG_OBJ_ELIG_PROFL
148 --
149 ben_ELIG_OBJ_ELIG_PROFL_bk1.create_ELIG_OBJ_ELIG_PROFL_a
150 (
151 p_elig_obj_elig_prfl_id => l_elig_obj_elig_prfl_id
152 ,p_effective_start_date => l_effective_start_date
153 ,p_effective_end_date => l_effective_end_date
154 ,p_business_group_id => p_business_group_id
155 ,p_elig_obj_id => p_elig_obj_id
156 ,p_elig_prfl_id => p_elig_prfl_id
157 ,p_mndtry_flag => p_mndtry_flag
158 ,p_bep_attribute_category => p_bep_attribute_category
159 ,p_bep_attribute1 => p_bep_attribute1
160 ,p_bep_attribute2 => p_bep_attribute2
161 ,p_bep_attribute3 => p_bep_attribute3
162 ,p_bep_attribute4 => p_bep_attribute4
163 ,p_bep_attribute5 => p_bep_attribute5
164 ,p_bep_attribute6 => p_bep_attribute6
165 ,p_bep_attribute7 => p_bep_attribute7
166 ,p_bep_attribute8 => p_bep_attribute8
167 ,p_bep_attribute9 => p_bep_attribute9
168 ,p_bep_attribute10 => p_bep_attribute10
169 ,p_bep_attribute11 => p_bep_attribute11
170 ,p_bep_attribute12 => p_bep_attribute12
171 ,p_bep_attribute13 => p_bep_attribute13
172 ,p_bep_attribute14 => p_bep_attribute14
173 ,p_bep_attribute15 => p_bep_attribute15
174 ,p_bep_attribute16 => p_bep_attribute16
175 ,p_bep_attribute17 => p_bep_attribute17
176 ,p_bep_attribute18 => p_bep_attribute18
177 ,p_bep_attribute19 => p_bep_attribute19
178 ,p_bep_attribute20 => p_bep_attribute20
179 ,p_object_version_number => l_object_version_number
180 ,p_effective_date => trunc(p_effective_date)
181 );
182 exception
183 when hr_api.cannot_find_prog_unit then
184 hr_api.cannot_find_prog_unit_error
185 (p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
186 ,p_hook_type => 'AP'
187 );
188 --
189 -- End of API User Hook for the after hook of create_ELIG_OBJ_ELIG_PROFL
190 --
191 end;
192 --
193 hr_utility.set_location(l_proc, 60);
194 --
195 -- When in validation only mode raise the Validate_Enabled exception
196 --
197 if p_validate then
198 raise hr_api.validate_enabled;
199 end if;
200 --
201 -- Set all output arguments
202 --
203 p_elig_obj_elig_prfl_id := l_elig_obj_elig_prfl_id;
204 p_effective_start_date := l_effective_start_date;
205 p_effective_end_date := l_effective_end_date;
206 p_object_version_number := l_object_version_number;
207 --
208 hr_utility.set_location(' Leaving:'||l_proc, 70);
209 --
210 exception
211 --
212 when hr_api.validate_enabled then
213 --
214 -- As the Validate_Enabled exception has been raised
215 -- we must rollback to the savepoint
216 --
217 ROLLBACK TO create_ELIG_OBJ_ELIG_PROFL;
218 --
219 -- Only set output warning arguments
220 -- (Any key or derived arguments must be set to null
221 -- when validation only mode is being used.)
222 --
223 p_elig_obj_elig_prfl_id := null;
224 p_effective_start_date := null;
225 p_effective_end_date := null;
226 p_object_version_number := null;
227 hr_utility.set_location(' Leaving:'||l_proc, 80);
228 --
229 when others then
230 --
231 -- A validation or unexpected error has occured
232 --
233 ROLLBACK TO create_ELIG_OBJ_ELIG_PROFL;
234 raise;
235 --
236 end create_ELIG_OBJ_ELIG_PROFL;
237 -- ----------------------------------------------------------------------------
238 -- |------------------------< update_ELIG_OBJ_ELIG_PROFL >--- ------------------|
239 -- ----------------------------------------------------------------------------
240 --
241 procedure update_ELIG_OBJ_ELIG_PROFL
242 (p_validate in boolean default false
243 ,p_elig_obj_elig_prfl_id in number
244 ,p_effective_start_date out nocopy date
245 ,p_effective_end_date out nocopy date
246 ,p_business_group_id in number default hr_api.g_number
247 ,p_elig_obj_id in number default hr_api.g_number
248 ,p_elig_prfl_id in number default hr_api.g_number
249 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250 ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251 ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252 ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253 ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254 ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255 ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256 ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257 ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258 ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259 ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260 ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261 ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262 ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263 ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264 ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265 ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266 ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267 ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268 ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269 ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270 ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
271 ,p_object_version_number in out nocopy number
272 ,p_effective_date in date
273 ,p_datetrack_mode in varchar2
274 ) is
275 --
276 -- Declare cursors and local variables
277 --
278 l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279 l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280 l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281 l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282 --
283 begin
284 --
285 hr_utility.set_location('Entering:'|| l_proc, 10);
286 --
287 -- Issue a savepoint if operating in validation only mode
288 --
289 savepoint update_ELIG_OBJ_ELIG_PROFL;
290 --
291 hr_utility.set_location(l_proc, 20);
292 --
293 -- Process Logic
294 --
295 l_object_version_number := p_object_version_number;
296 --
297 begin
298 --
299 -- Start of API User Hook for the before hook of update_ELIG_OBJ_ELIG_PROFL
300 --
301 ben_ELIG_OBJ_ELIG_PROFL_bk2.update_ELIG_OBJ_ELIG_PROFL_b
302 (
303 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
304 ,p_business_group_id => p_business_group_id
305 ,p_elig_obj_id => p_elig_obj_id
306 ,p_elig_prfl_id => p_elig_prfl_id
307 ,p_mndtry_flag => p_mndtry_flag
308 ,p_bep_attribute_category => p_bep_attribute_category
309 ,p_bep_attribute1 => p_bep_attribute1
310 ,p_bep_attribute2 => p_bep_attribute2
311 ,p_bep_attribute3 => p_bep_attribute3
312 ,p_bep_attribute4 => p_bep_attribute4
313 ,p_bep_attribute5 => p_bep_attribute5
314 ,p_bep_attribute6 => p_bep_attribute6
315 ,p_bep_attribute7 => p_bep_attribute7
316 ,p_bep_attribute8 => p_bep_attribute8
317 ,p_bep_attribute9 => p_bep_attribute9
318 ,p_bep_attribute10 => p_bep_attribute10
319 ,p_bep_attribute11 => p_bep_attribute11
320 ,p_bep_attribute12 => p_bep_attribute12
321 ,p_bep_attribute13 => p_bep_attribute13
322 ,p_bep_attribute14 => p_bep_attribute14
323 ,p_bep_attribute15 => p_bep_attribute15
324 ,p_bep_attribute16 => p_bep_attribute16
325 ,p_bep_attribute17 => p_bep_attribute17
326 ,p_bep_attribute18 => p_bep_attribute18
327 ,p_bep_attribute19 => p_bep_attribute19
328 ,p_bep_attribute20 => p_bep_attribute20
329 ,p_object_version_number => p_object_version_number
330 ,p_effective_date => trunc(p_effective_date)
331 ,p_datetrack_mode => p_datetrack_mode
332 );
333 exception
334 when hr_api.cannot_find_prog_unit then
335 hr_api.cannot_find_prog_unit_error
336 (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
337 ,p_hook_type => 'BP'
338 );
339 --
340 -- End of API User Hook for the before hook of update_ELIG_OBJ_ELIG_PROFL
341 --
342 end;
343 --
344 ben_bep_upd.upd
345 (
346 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
347 ,p_effective_start_date => l_effective_start_date
348 ,p_effective_end_date => l_effective_end_date
349 ,p_business_group_id => p_business_group_id
350 ,p_elig_obj_id => p_elig_obj_id
351 ,p_elig_prfl_id => p_elig_prfl_id
352 ,p_mndtry_flag => p_mndtry_flag
353 ,p_bep_attribute_category => p_bep_attribute_category
354 ,p_bep_attribute1 => p_bep_attribute1
355 ,p_bep_attribute2 => p_bep_attribute2
356 ,p_bep_attribute3 => p_bep_attribute3
357 ,p_bep_attribute4 => p_bep_attribute4
358 ,p_bep_attribute5 => p_bep_attribute5
359 ,p_bep_attribute6 => p_bep_attribute6
360 ,p_bep_attribute7 => p_bep_attribute7
361 ,p_bep_attribute8 => p_bep_attribute8
362 ,p_bep_attribute9 => p_bep_attribute9
363 ,p_bep_attribute10 => p_bep_attribute10
364 ,p_bep_attribute11 => p_bep_attribute11
365 ,p_bep_attribute12 => p_bep_attribute12
366 ,p_bep_attribute13 => p_bep_attribute13
367 ,p_bep_attribute14 => p_bep_attribute14
368 ,p_bep_attribute15 => p_bep_attribute15
369 ,p_bep_attribute16 => p_bep_attribute16
370 ,p_bep_attribute17 => p_bep_attribute17
371 ,p_bep_attribute18 => p_bep_attribute18
372 ,p_bep_attribute19 => p_bep_attribute19
373 ,p_bep_attribute20 => p_bep_attribute20
374 ,p_object_version_number => l_object_version_number
375 ,p_effective_date => trunc(p_effective_date)
376 ,p_datetrack_mode => p_datetrack_mode
377 );
378 --
379 begin
380 --
381 -- Start of API User Hook for the after hook of update_ELIG_OBJ_ELIG_PROFL
382 --
383 ben_ELIG_OBJ_ELIG_PROFL_bk2.update_ELIG_OBJ_ELIG_PROFL_a
384 (
385 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
386 ,p_effective_start_date => l_effective_start_date
387 ,p_effective_end_date => l_effective_end_date
388 ,p_business_group_id => p_business_group_id
389 ,p_elig_obj_id => p_elig_obj_id
390 ,p_elig_prfl_id => p_elig_prfl_id
391 ,p_mndtry_flag => p_mndtry_flag
392 ,p_bep_attribute_category => p_bep_attribute_category
393 ,p_bep_attribute1 => p_bep_attribute1
394 ,p_bep_attribute2 => p_bep_attribute2
395 ,p_bep_attribute3 => p_bep_attribute3
396 ,p_bep_attribute4 => p_bep_attribute4
397 ,p_bep_attribute5 => p_bep_attribute5
398 ,p_bep_attribute6 => p_bep_attribute6
399 ,p_bep_attribute7 => p_bep_attribute7
400 ,p_bep_attribute8 => p_bep_attribute8
401 ,p_bep_attribute9 => p_bep_attribute9
402 ,p_bep_attribute10 => p_bep_attribute10
403 ,p_bep_attribute11 => p_bep_attribute11
404 ,p_bep_attribute12 => p_bep_attribute12
405 ,p_bep_attribute13 => p_bep_attribute13
406 ,p_bep_attribute14 => p_bep_attribute14
407 ,p_bep_attribute15 => p_bep_attribute15
408 ,p_bep_attribute16 => p_bep_attribute16
409 ,p_bep_attribute17 => p_bep_attribute17
410 ,p_bep_attribute18 => p_bep_attribute18
411 ,p_bep_attribute19 => p_bep_attribute19
412 ,p_bep_attribute20 => p_bep_attribute20
413 ,p_object_version_number => l_object_version_number
414 ,p_effective_date => trunc(p_effective_date)
415 ,p_datetrack_mode => p_datetrack_mode
416 );
417 exception
418 when hr_api.cannot_find_prog_unit then
419 hr_api.cannot_find_prog_unit_error
420 (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
421 ,p_hook_type => 'AP'
422 );
423 --
424 -- End of API User Hook for the after hook of update_ELIG_OBJ_ELIG_PROFL
425 --
426 end;
427 --
428 hr_utility.set_location(l_proc, 60);
429 --
430 -- When in validation only mode raise the Validate_Enabled exception
431 --
432 if p_validate then
433 raise hr_api.validate_enabled;
434 end if;
435 --
436 -- Set all output arguments
437 --
438 p_object_version_number := l_object_version_number;
439 p_effective_start_date := l_effective_start_date;
440 p_effective_end_date := l_effective_end_date;
441 --
442 hr_utility.set_location(' Leaving:'||l_proc, 70);
443 --
444 exception
445 --
446 when hr_api.validate_enabled then
447 --
448 -- As the Validate_Enabled exception has been raised
449 -- we must rollback to the savepoint
450 --
451 ROLLBACK TO update_ELIG_OBJ_ELIG_PROFL;
452 --
453 -- Only set output warning arguments
454 -- (Any key or derived arguments must be set to null
455 -- when validation only mode is being used.)
456 --
457 hr_utility.set_location(' Leaving:'||l_proc, 80);
458 --
459 when others then
460 --
461 -- A validation or unexpected error has occured
462 --
463 ROLLBACK TO update_ELIG_OBJ_ELIG_PROFL;
464 raise;
465 --
466 end update_ELIG_OBJ_ELIG_PROFL;
467 -- ----------------------------------------------------------------------------
468 -- |------------------------< delete_ELIG_OBJ_ELIG_PROFL >----------------------|
469 -- ----------------------------------------------------------------------------
470 --
471 procedure delete_ELIG_OBJ_ELIG_PROFL
472 (p_validate in boolean default false
473 ,p_elig_obj_elig_prfl_id in number
474 ,p_effective_start_date out nocopy date
475 ,p_effective_end_date out nocopy date
476 ,p_object_version_number in out nocopy number
477 ,p_effective_date in date
478 ,p_datetrack_mode in varchar2
479 ) is
480 --
481 -- Declare cursors and local variables
482 --
483 l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484 l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485 l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486 l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487 --
488 begin
489 --
490 hr_utility.set_location('Entering:'|| l_proc, 10);
491 --
492 -- Issue a savepoint if operating in validation only mode
493 --
494 savepoint delete_ELIG_OBJ_ELIG_PROFL;
495 --
496 hr_utility.set_location(l_proc, 20);
497 --
498 -- Process Logic
499 --
500 l_object_version_number := p_object_version_number;
501 --
502 --
503 begin
504 --
505 -- Start of API User Hook for the before hook of delete_ELIG_OBJ_ELIG_PROFL
506 --
507 ben_ELIG_OBJ_ELIG_PROFL_bk3.delete_ELIG_OBJ_ELIG_PROFL_b
508 (
509 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
510 ,p_object_version_number => p_object_version_number
511 ,p_effective_date => trunc(p_effective_date)
512 ,p_datetrack_mode => p_datetrack_mode
513 );
514 exception
515 when hr_api.cannot_find_prog_unit then
516 hr_api.cannot_find_prog_unit_error
517 (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
518 ,p_hook_type => 'BP'
519 );
520 --
521 -- End of API User Hook for the before hook of delete_ELIG_OBJ_ELIG_PROFL
522 --
523 end;
524 --
525 ben_bep_del.del
526 (
527 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
528 ,p_effective_start_date => l_effective_start_date
529 ,p_effective_end_date => l_effective_end_date
530 ,p_object_version_number => l_object_version_number
531 ,p_effective_date => p_effective_date
532 ,p_datetrack_mode => p_datetrack_mode
533 );
534 --
535 begin
536 --
537 -- Start of API User Hook for the after hook of delete_ELIG_OBJ_ELIG_PROFL
538 --
539 ben_ELIG_OBJ_ELIG_PROFL_bk3.delete_ELIG_OBJ_ELIG_PROFL_a
540 (
541 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
542 ,p_effective_start_date => l_effective_start_date
543 ,p_effective_end_date => l_effective_end_date
544 ,p_object_version_number => l_object_version_number
545 ,p_effective_date => trunc(p_effective_date)
546 ,p_datetrack_mode => p_datetrack_mode
547 );
548 exception
549 when hr_api.cannot_find_prog_unit then
550 hr_api.cannot_find_prog_unit_error
551 (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
552 ,p_hook_type => 'AP'
553 );
554 --
555 -- End of API User Hook for the after hook of delete_ELIG_OBJ_ELIG_PROFL
556 --
557 end;
558 --
559 hr_utility.set_location(l_proc, 60);
560 --
561 -- When in validation only mode raise the Validate_Enabled exception
562 --
563 if p_validate then
564 raise hr_api.validate_enabled;
565 end if;
566 --
567 hr_utility.set_location(' Leaving:'||l_proc, 70);
568 --
569 exception
570 --
571 when hr_api.validate_enabled then
572 --
573 -- As the Validate_Enabled exception has been raised
574 -- we must rollback to the savepoint
575 --
576 ROLLBACK TO delete_ELIG_OBJ_ELIG_PROFL;
577 --
578 -- Only set output warning arguments
579 -- (Any key or derived arguments must be set to null
580 -- when validation only mode is being used.)
581 --
582 p_effective_start_date := null;
583 p_effective_end_date := null;
584 --
585 when others then
586 --
587 -- A validation or unexpected error has occured
588 --
589 ROLLBACK TO delete_ELIG_OBJ_ELIG_PROFL;
590 raise;
591 --
592 end delete_ELIG_OBJ_ELIG_PROFL;
593 --
594 -- ----------------------------------------------------------------------------
595 -- |-------------------------------< lck >------------------------------------|
596 -- ----------------------------------------------------------------------------
597 --
598 procedure lck
599 (
600 p_elig_obj_elig_prfl_id in number
601 ,p_object_version_number in number
602 ,p_effective_date in date
603 ,p_datetrack_mode in varchar2
604 ,p_validation_start_date out nocopy date
605 ,p_validation_end_date out nocopy date
606 ) is
607 --
608 --
609 -- Declare cursors and local variables
610 --
611 l_proc varchar2(72) := g_package||'lck';
612 l_validation_start_date date;
613 l_validation_end_date date;
614 --
615 begin
616 --
617 hr_utility.set_location('Entering:'|| l_proc, 10);
618 --
619 ben_bep_shd.lck
620 (
621 p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
622 ,p_validation_start_date => l_validation_start_date
623 ,p_validation_end_date => l_validation_end_date
624 ,p_object_version_number => p_object_version_number
625 ,p_effective_date => p_effective_date
626 ,p_datetrack_mode => p_datetrack_mode
627 );
628 --
629 hr_utility.set_location(' Leaving:'||l_proc, 70);
630 --
631 end lck;
632 --
633 end ben_ELIG_OBJ_ELIG_PROFL_api;