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