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