[Home] [Help]
PACKAGE BODY: APPS.PER_ALLOCATED_CHECKLIST_API
Source
1 Package Body PER_ALLOCATED_CHECKLIST_API as
2 /* $Header: pepacapi.pkb 120.0 2005/09/28 07:42:33 lsilveir noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' PER_ALLOCATED_CHECKLIST_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< CREATE_ALLOC_CHECKLIST >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure CREATE_ALLOC_CHECKLIST
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_checklist_id in number default null
16 ,p_person_id in number
17 ,p_assignment_id in number default null
18 ,p_checklist_name in varchar2 default null
19 ,p_description in varchar2 default null
20 ,p_checklist_category in varchar2 default null
21 --
22 ,p_attribute_category in varchar2 default null
23 ,p_attribute1 in varchar2 default null
24 ,p_attribute2 in varchar2 default null
25 ,p_attribute3 in varchar2 default null
26 ,p_attribute4 in varchar2 default null
27 ,p_attribute5 in varchar2 default null
28 ,p_attribute6 in varchar2 default null
29 ,p_attribute7 in varchar2 default null
30 ,p_attribute8 in varchar2 default null
31 ,p_attribute9 in varchar2 default null
32 ,p_attribute10 in varchar2 default null
33 ,p_attribute11 in varchar2 default null
34 ,p_attribute12 in varchar2 default null
35 ,p_attribute13 in varchar2 default null
36 ,p_attribute14 in varchar2 default null
37 ,p_attribute15 in varchar2 default null
38 ,p_attribute16 in varchar2 default null
39 ,p_attribute17 in varchar2 default null
40 ,p_attribute18 in varchar2 default null
41 ,p_attribute19 in varchar2 default null
42 ,p_attribute20 in varchar2 default null
43 ,p_information_category in varchar2 default null
44 ,p_information1 in varchar2 default null
45 ,p_information2 in varchar2 default null
46 ,p_information3 in varchar2 default null
47 ,p_information4 in varchar2 default null
48 ,p_information5 in varchar2 default null
49 ,p_information6 in varchar2 default null
50 ,p_information7 in varchar2 default null
51 ,p_information8 in varchar2 default null
52 ,p_information9 in varchar2 default null
53 ,p_information10 in varchar2 default null
54 ,p_information11 in varchar2 default null
55 ,p_information12 in varchar2 default null
56 ,p_information13 in varchar2 default null
57 ,p_information14 in varchar2 default null
58 ,p_information15 in varchar2 default null
59 ,p_information16 in varchar2 default null
60 ,p_information17 in varchar2 default null
61 ,p_information18 in varchar2 default null
62 ,p_information19 in varchar2 default null
63 ,p_information20 in varchar2 default null
64 ,p_allocated_checklist_id out nocopy number
65 ,p_object_version_number out nocopy number
66 ) is
67 --
68 -- Declare cursors and local variables
69 --
70 l_effective_date date;
71 l_object_version_number number(9);
72 l_allocated_checklist_id number(9);
73 l_proc varchar2(72) := g_package||'Create_checklist';
74
75 begin
76 hr_utility.set_location('Entering:'|| l_proc, 10);
77 --
78 -- Issue a savepoint
79 --
80 savepoint CREATE_ALLOC_CHECKLIST;
81 --
82 -- Remember IN OUT parameter IN values
83 --
84 -- l_allocated_checklist_id := p_allocated_checklist_id;
85 -- l_object_version_number := p_object_version_number;
86 --
87 -- Truncate the time portion from all IN date parameters
88 --
89 l_effective_date := trunc(p_effective_date);
90
91 --
92 -- Call Before Process User Hook
93 --
94
95
96 begin
97 PER_ALLOCATED_CHECKLIST_BK1.create_alloc_checklist_b
98 (p_effective_date => l_effective_date
99 ,p_checklist_id => p_checklist_id
100 ,p_person_id => p_person_id
101 ,p_assignment_id => p_assignment_id
102 ,p_checklist_name => p_checklist_name
103 ,p_description => p_description
104 ,p_checklist_category => p_checklist_category
105 --
106 ,p_attribute_category => p_attribute_category
107 ,p_attribute1 => p_attribute1
108 ,p_attribute2 => p_attribute2
109 ,p_attribute3 => p_attribute3
110 ,p_attribute4 => p_attribute4
111 ,p_attribute5 => p_attribute5
112 ,p_attribute6 => p_attribute6
113 ,p_attribute7 => p_attribute7
114 ,p_attribute8 => p_attribute8
115 ,p_attribute9 => p_attribute9
116 ,p_attribute10 => p_attribute10
117 ,p_attribute11 => p_attribute11
118 ,p_attribute12 => p_attribute12
119 ,p_attribute13 => p_attribute13
120 ,p_attribute14 => p_attribute14
121 ,p_attribute15 => p_attribute15
122 ,p_attribute16 => p_attribute16
123 ,p_attribute17 => p_attribute17
124 ,p_attribute18 => p_attribute18
125 ,p_attribute19 => p_attribute19
126 ,p_attribute20 => p_attribute20
127 ,p_information_category => p_information_category
128 ,p_information1 => p_information1
129 ,p_information2 => p_information2
130 ,p_information3 => p_information3
131 ,p_information4 => p_information4
132 ,p_information5 => p_information5
133 ,p_information6 => p_information6
134 ,p_information7 => p_information7
135 ,p_information8 => p_information8
136 ,p_information9 => p_information9
137 ,p_information10 => p_information10
138 ,p_information11 => p_information11
139 ,p_information12 => p_information12
140 ,p_information13 => p_information13
141 ,p_information14 => p_information14
142 ,p_information15 => p_information15
143 ,p_information16 => p_information16
144 ,p_information17 => p_information17
145 ,p_information18 => p_information18
146 ,p_information19 => p_information19
147 ,p_information20 => p_information20
148 );
149
150 /*
151 (p_effective_date => l_effective_date
152 ,p_business_group_id => p_business_group_id
153 ,p_in_out_parameter => p_in_out_parameter
154 ,p_non_mandatory_arg => p_non_mandatory_arg
155 );
156 */
157 exception
158 when hr_api.cannot_find_prog_unit then
159 hr_api.cannot_find_prog_unit_error
160 (p_module_name => 'CREATE_ALLOC_CHECKLIST'
161 ,p_hook_type => 'BP'
162 );
163 end;
164 --
165 -- Validation in addition to Row Handlers
166 --
167
168
169
170 --
171 -- Process Logic
172 --
173 per_pac_ins.ins
174 (p_effective_date => p_effective_date
175 ,p_checklist_id => p_checklist_id
176 ,p_person_id => p_person_id
177 ,p_assignment_id => p_assignment_id
178 ,p_checklist_name => p_checklist_name
179 ,p_description => p_description
180 ,p_checklist_category => p_checklist_category
181 --
182 ,p_attribute_category => p_attribute_category
183 ,p_attribute1 => p_attribute1
184 ,p_attribute2 => p_attribute2
185 ,p_attribute3 => p_attribute3
186 ,p_attribute4 => p_attribute4
187 ,p_attribute5 => p_attribute5
188 ,p_attribute6 => p_attribute6
189 ,p_attribute7 => p_attribute7
190 ,p_attribute8 => p_attribute8
191 ,p_attribute9 => p_attribute9
192 ,p_attribute10 => p_attribute10
193 ,p_attribute11 => p_attribute11
194 ,p_attribute12 => p_attribute12
195 ,p_attribute13 => p_attribute13
196 ,p_attribute14 => p_attribute14
197 ,p_attribute15 => p_attribute15
198 ,p_attribute16 => p_attribute16
199 ,p_attribute17 => p_attribute17
200 ,p_attribute18 => p_attribute18
201 ,p_attribute19 => p_attribute19
202 ,p_attribute20 => p_attribute20
203 ,p_information_category => p_information_category
204 ,p_information1 => p_information1
205 ,p_information2 => p_information2
206 ,p_information3 => p_information3
207 ,p_information4 => p_information4
208 ,p_information5 => p_information5
209 ,p_information6 => p_information6
210 ,p_information7 => p_information7
211 ,p_information8 => p_information8
212 ,p_information9 => p_information9
213 ,p_information10 => p_information10
214 ,p_information11 => p_information11
215 ,p_information12 => p_information12
216 ,p_information13 => p_information13
217 ,p_information14 => p_information14
218 ,p_information15 => p_information15
219 ,p_information16 => p_information16
220 ,p_information17 => p_information17
221 ,p_information18 => p_information18
222 ,p_information19 => p_information19
223 ,p_information20 => p_information20
224 ,p_allocated_checklist_id => l_allocated_checklist_id
225 ,p_object_version_number => l_object_version_number
226 );
227
228
229 --
230 -- Call After Process User Hook
231 --
232 begin
233 PER_ALLOCATED_CHECKLIST_BK1.CREATE_ALLOC_CHECKLIST_A
234 (p_effective_date => l_effective_date
235 ,p_checklist_id => p_checklist_id
236 ,p_person_id => p_person_id
237 ,p_assignment_id => p_assignment_id
238 ,p_checklist_name => p_checklist_name
239 ,p_description => p_description
240 ,p_checklist_category => p_checklist_category
241 --
242 ,p_attribute_category => p_attribute_category
243 ,p_attribute1 => p_attribute1
244 ,p_attribute2 => p_attribute2
245 ,p_attribute3 => p_attribute3
246 ,p_attribute4 => p_attribute4
247 ,p_attribute5 => p_attribute5
248 ,p_attribute6 => p_attribute6
249 ,p_attribute7 => p_attribute7
250 ,p_attribute8 => p_attribute8
251 ,p_attribute9 => p_attribute9
252 ,p_attribute10 => p_attribute10
253 ,p_attribute11 => p_attribute11
254 ,p_attribute12 => p_attribute12
255 ,p_attribute13 => p_attribute13
256 ,p_attribute14 => p_attribute14
257 ,p_attribute15 => p_attribute15
258 ,p_attribute16 => p_attribute16
259 ,p_attribute17 => p_attribute17
260 ,p_attribute18 => p_attribute18
261 ,p_attribute19 => p_attribute19
262 ,p_attribute20 => p_attribute20
263 ,p_information_category => p_information_category
264 ,p_information1 => p_information1
265 ,p_information2 => p_information2
266 ,p_information3 => p_information3
267 ,p_information4 => p_information4
268 ,p_information5 => p_information5
269 ,p_information6 => p_information6
270 ,p_information7 => p_information7
271 ,p_information8 => p_information8
272 ,p_information9 => p_information9
273 ,p_information10 => p_information10
274 ,p_information11 => p_information11
275 ,p_information12 => p_information12
276 ,p_information13 => p_information13
277 ,p_information14 => p_information14
278 ,p_information15 => p_information15
279 ,p_information16 => p_information16
280 ,p_information17 => p_information17
281 ,p_information18 => p_information18
282 ,p_information19 => p_information19
283 ,p_information20 => p_information20
284 ,p_allocated_checklist_id => l_allocated_checklist_id
285 ,p_object_version_number => l_object_version_number
286
287 );
288
289
290 /*
291 =======
292 (p_effective_date => l_effective_date
293 ,p_business_group_id => p_business_group_id
294 ,p_in_out_parameter => <local_var_set_in_process_logic>
295 ,p_non_mandatory_arg => p_non_mandatory_arg
296 ,p_id => <local_var_set_in_process_logic>
297 ,p_object_version_number => <local_var_set_in_process_logic>
298 ,p_some_warning => <local_var_set_in_process_logic>
299 );
300 */
304 (p_module_name => 'CREATE_ALLOC_CHECKLIST'
301 exception
302 when hr_api.cannot_find_prog_unit then
303 hr_api.cannot_find_prog_unit_error
305 ,p_hook_type => 'AP'
306 );
307 end;
308 --
309 -- When in validation only mode raise the Validate_Enabled exception
310 --
311 if p_validate then
312 raise hr_api.validate_enabled;
313 end if;
314 --
315 -- Set all IN OUT and OUT parameters with out values
316 --
317 p_allocated_checklist_id := l_allocated_checklist_id;
318 --p_in_out_parameter := <local_var_set_in_process_logic>
319 p_object_version_number := l_object_version_number;
320 --p_some_warning := <local_var_set_in_process_logic>
321 --
322 hr_utility.set_location(' Leaving:'||l_proc, 70);
323 exception
324 when hr_api.validate_enabled then
325 --
326 -- As the Validate_Enabled exception has been raised
327 -- we must rollback to the savepoint
328 --
329 rollback to CREATE_ALLOC_CHECKLIST;
330 --
331 -- Reset IN OUT parameters and set OUT parameters
332 -- (Any key or derived arguments must be set to null
333 -- when validation only mode is being used.)
334 --
335 --p_in_out_parameter := l_in_out_parameter;
336 p_allocated_checklist_id := null;
337 p_object_version_number := null;
338 --p_some_warning := <local_var_set_in_process_logic>
339 hr_utility.set_location(' Leaving:'||l_proc, 80);
340 when others then
341 --
342 -- A validation or unexpected error has occured
343 --
344 rollback to CREATE_ALLOC_CHECKLIST;
345 --
346 -- Reset IN OUT parameters and set all
347 -- OUT parameters, including warnings, to null
348 --
349 --p_in_out_parameter := l_in_out_parameter;
350 p_allocated_checklist_id := null;
351 p_object_version_number := null;
352 --p_some_warning := null;
353 hr_utility.set_location(' Leaving:'||l_proc, 90);
354 raise;
355 end CREATE_ALLOC_CHECKLIST;
356 --
357 -- ----------------------------------------------------------------------------
358 -- |--------------------------< UPDATE_ALLOC_CHECKLIST >----------------------|
359 -- ----------------------------------------------------------------------------
360 --
361 procedure UPDATE_ALLOC_CHECKLIST
362 (p_validate in boolean default false
363 ,p_effective_date in date
364 ,p_allocated_checklist_id in number
365 ,p_checklist_id in number default null
366 ,p_person_id in number default null
367 ,p_assignment_id in number default null
368 ,p_checklist_name in varchar2 default null
369 ,p_description in varchar2 default null
370 ,p_checklist_category in varchar2 default null
371 --
372 ,p_attribute_category in varchar2 default null
373 ,p_attribute1 in varchar2 default null
374 ,p_attribute2 in varchar2 default null
375 ,p_attribute3 in varchar2 default null
376 ,p_attribute4 in varchar2 default null
377 ,p_attribute5 in varchar2 default null
378 ,p_attribute6 in varchar2 default null
379 ,p_attribute7 in varchar2 default null
380 ,p_attribute8 in varchar2 default null
381 ,p_attribute9 in varchar2 default null
382 ,p_attribute10 in varchar2 default null
383 ,p_attribute11 in varchar2 default null
384 ,p_attribute12 in varchar2 default null
385 ,p_attribute13 in varchar2 default null
386 ,p_attribute14 in varchar2 default null
387 ,p_attribute15 in varchar2 default null
388 ,p_attribute16 in varchar2 default null
389 ,p_attribute17 in varchar2 default null
390 ,p_attribute18 in varchar2 default null
391 ,p_attribute19 in varchar2 default null
392 ,p_attribute20 in varchar2 default null
393 ,p_information_category in varchar2 default null
394 ,p_information1 in varchar2 default null
395 ,p_information2 in varchar2 default null
396 ,p_information3 in varchar2 default null
397 ,p_information4 in varchar2 default null
398 ,p_information5 in varchar2 default null
399 ,p_information6 in varchar2 default null
400 ,p_information7 in varchar2 default null
401 ,p_information8 in varchar2 default null
402 ,p_information9 in varchar2 default null
403 ,p_information10 in varchar2 default null
404 ,p_information11 in varchar2 default null
405 ,p_information12 in varchar2 default null
406 ,p_information13 in varchar2 default null
407 ,p_information14 in varchar2 default null
408 ,p_information15 in varchar2 default null
409 ,p_information16 in varchar2 default null
410 ,p_information17 in varchar2 default null
411 ,p_information18 in varchar2 default null
412 ,p_information19 in varchar2 default null
413 ,p_information20 in varchar2 default null
414 ,p_object_version_number in out nocopy number
415 ) is
416
417 --
418 -- Declare cursors and local variables
419 --
423 l_temp_ovn number;
420 l_proc varchar2(72) := g_package||'update_alloc_checklist';
421 l_effective_date date;
422 l_object_version_number number;
424
425 begin
426 hr_utility.set_location('Entering:'|| l_proc, 10);
427 --
428 -- Issue a savepoint
429 --
430 savepoint UPDATE_ALLOC_CHECKLIST;
431 --
432 -- Truncate the time portion from all IN date parameters
433 --
434 l_effective_date := TRUNC(p_effective_date);
435 l_object_version_number := p_object_version_number;
436 l_temp_ovn := p_object_version_number;
437 /* This needs to be removed, after confirming this is not needed TP
438 --
439 --
440 -- Validate the language parameter. l_language_code should be passed
441 -- instead of p_language_code from now on, to allow an IN OUT parameter to
445 hr_api.validate_language_code(p_language_code => l_language_code);
442 -- be passed through.
443 --
444 l_language_code := p_language_code;
446 */
447 --
448 -- Call Before Process User Hook
449 --
450 begin
451 PER_ALLOCATED_CHECKLIST_BK2.UPDATE_ALLOC_CHECKLIST_B
452 (p_allocated_checklist_id => p_allocated_checklist_id
453 ,p_effective_date => l_effective_date
454 ,p_checklist_id => p_checklist_id
455 ,p_person_id => p_person_id
456 ,p_assignment_id => p_assignment_id
457 ,p_checklist_name => p_checklist_name
458 ,p_description => p_description
459 ,p_checklist_category => p_checklist_category
460 --
461 ,p_attribute_category => p_attribute_category
462 ,p_attribute1 => p_attribute1
463 ,p_attribute2 => p_attribute2
464 ,p_attribute3 => p_attribute3
465 ,p_attribute4 => p_attribute4
466 ,p_attribute5 => p_attribute5
467 ,p_attribute6 => p_attribute6
468 ,p_attribute7 => p_attribute7
469 ,p_attribute8 => p_attribute8
470 ,p_attribute9 => p_attribute9
471 ,p_attribute10 => p_attribute10
472 ,p_attribute11 => p_attribute11
473 ,p_attribute12 => p_attribute12
474 ,p_attribute13 => p_attribute13
475 ,p_attribute14 => p_attribute14
476 ,p_attribute15 => p_attribute15
477 ,p_attribute16 => p_attribute16
478 ,p_attribute17 => p_attribute17
479 ,p_attribute18 => p_attribute18
480 ,p_attribute19 => p_attribute19
481 ,p_attribute20 => p_attribute20
482 ,p_information_category => p_information_category
483 ,p_information1 => p_information1
484 ,p_information2 => p_information2
485 ,p_information3 => p_information3
486 ,p_information4 => p_information4
487 ,p_information5 => p_information5
488 ,p_information6 => p_information6
489 ,p_information7 => p_information7
490 ,p_information8 => p_information8
491 ,p_information9 => p_information9
492 ,p_information10 => p_information10
493 ,p_information11 => p_information11
494 ,p_information12 => p_information12
495 ,p_information13 => p_information13
496 ,p_information14 => p_information14
497 ,p_information15 => p_information15
498 ,p_information16 => p_information16
499 ,p_information17 => p_information17
500 ,p_information18 => p_information18
501 ,p_information19 => p_information19
502 ,p_information20 => p_information20
503 ,p_object_version_number => l_object_version_number
504 );
505 --
506 exception
507 when hr_Api.cannot_find_prog_unit then
508 hr_Api.cannot_find_prog_unit_error
509 (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
510 ,p_hook_type => 'BP'
511 );
512 end;
513
514 --
515 -- Process Logic
516 --
517
518 per_pac_upd.upd
519 (p_effective_date => l_effective_date
520 ,p_allocated_checklist_id => p_allocated_checklist_id
521 ,p_object_version_number => l_object_version_number
522 ,p_checklist_id => p_checklist_id
523 ,p_person_id => p_person_id
524 ,p_assignment_id => p_assignment_id
525 ,p_checklist_name => p_checklist_name
526 ,p_description => p_description
527 ,p_checklist_category => p_checklist_category
528 --
529 ,p_attribute_category => p_attribute_category
530 ,p_attribute1 => p_attribute1
531 ,p_attribute2 => p_attribute2
532 ,p_attribute3 => p_attribute3
533 ,p_attribute4 => p_attribute4
534 ,p_attribute5 => p_attribute5
535 ,p_attribute6 => p_attribute6
536 ,p_attribute7 => p_attribute7
537 ,p_attribute8 => p_attribute8
538 ,p_attribute9 => p_attribute9
539 ,p_attribute10 => p_attribute10
540 ,p_attribute11 => p_attribute11
541 ,p_attribute12 => p_attribute12
542 ,p_attribute13 => p_attribute13
543 ,p_attribute14 => p_attribute14
544 ,p_attribute15 => p_attribute15
545 ,p_attribute16 => p_attribute16
546 ,p_attribute17 => p_attribute17
547 ,p_attribute18 => p_attribute18
548 ,p_attribute19 => p_attribute19
549 ,p_attribute20 => p_attribute20
550 ,p_information_category => p_information_category
551 ,p_information1 => p_information1
552 ,p_information2 => p_information2
553 ,p_information3 => p_information3
554 ,p_information4 => p_information4
555 ,p_information5 => p_information5
556 ,p_information6 => p_information6
557 ,p_information7 => p_information7
558 ,p_information8 => p_information8
562 ,p_information12 => p_information12
559 ,p_information9 => p_information9
560 ,p_information10 => p_information10
561 ,p_information11 => p_information11
563 ,p_information13 => p_information13
564 ,p_information14 => p_information14
565 ,p_information15 => p_information15
566 ,p_information16 => p_information16
567 ,p_information17 => p_information17
568 ,p_information18 => p_information18
569 ,p_information19 => p_information19
570 ,p_information20 => p_information20
571 );
572
573 --
574 -- Call After Process User Hook
575 --
576 begin
577 PER_ALLOCATED_CHECKLIST_BK2.UPDATE_ALLOC_CHECKLIST_A
578 (p_effective_date => l_effective_date
579 ,p_allocated_checklist_id => p_allocated_checklist_id
580 ,p_checklist_id => p_checklist_id
581 ,p_person_id => p_person_id
582 ,p_assignment_id => p_assignment_id
583 ,p_checklist_name => p_checklist_name
584 ,p_description => p_description
585 ,p_checklist_category => p_checklist_category
586 --
587 ,p_attribute_category => p_attribute_category
588 ,p_attribute1 => p_attribute1
589 ,p_attribute2 => p_attribute2
590 ,p_attribute3 => p_attribute3
591 ,p_attribute4 => p_attribute4
592 ,p_attribute5 => p_attribute5
593 ,p_attribute6 => p_attribute6
594 ,p_attribute7 => p_attribute7
595 ,p_attribute8 => p_attribute8
596 ,p_attribute9 => p_attribute9
597 ,p_attribute10 => p_attribute10
598 ,p_attribute11 => p_attribute11
599 ,p_attribute12 => p_attribute12
600 ,p_attribute13 => p_attribute13
601 ,p_attribute14 => p_attribute14
602 ,p_attribute15 => p_attribute15
603 ,p_attribute16 => p_attribute16
604 ,p_attribute17 => p_attribute17
605 ,p_attribute18 => p_attribute18
606 ,p_attribute19 => p_attribute19
607 ,p_attribute20 => p_attribute20
608 ,p_information_category => p_information_category
609 ,p_information1 => p_information1
610 ,p_information2 => p_information2
611 ,p_information3 => p_information3
612 ,p_information4 => p_information4
613 ,p_information5 => p_information5
614 ,p_information6 => p_information6
615 ,p_information7 => p_information7
616 ,p_information8 => p_information8
617 ,p_information9 => p_information9
618 ,p_information10 => p_information10
619 ,p_information11 => p_information11
620 ,p_information12 => p_information12
621 ,p_information13 => p_information13
622 ,p_information14 => p_information14
623 ,p_information15 => p_information15
624 ,p_information16 => p_information16
625 ,p_information17 => p_information17
626 ,p_information18 => p_information18
627 ,p_information19 => p_information19
628 ,p_information20 => p_information20
629 ,p_object_version_number => l_object_version_number);
630 exception
631 when hr_Api.cannot_find_prog_unit then
632 hr_Api.cannot_find_prog_unit_error
633 (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
634 ,p_hook_type => 'AP'
635 );
636 end;
637 --
638 -- When in validation only mode raise the Validate_Enabled exception
639 --
640 if p_validate then
641 raise hr_Api.validate_enabled;
642 end if;
643 --
644 -- Set all output arguements
645 --
646 p_object_version_number := l_object_version_number;
647 hr_utility.set_location(' Leaving:'||l_proc, 70);
648 exception
649 when hr_Api.validate_enabled then
650 --
651 -- As the Validate_Enabled exception has been raised
652 -- we must rollback to the savepoint
653 --
654 rollback to UPDATE_ALLOC_CHECKLIST;
655 --
656 -- Only set output warning arguments
657 -- (Any key or derived arguments must be set to null
658 -- when validation only mode is being used.)
659 --
660 hr_utility.set_location(' Leaving:'||l_proc, 80);
661 when others then
662 --
663 -- A validation or unexpected error has occured
664 --
665 p_object_version_number := l_temp_ovn;
666 rollback to UPDATE_ALLOC_CHECKLIST;
667 hr_utility.set_location(' Leaving:'||l_proc, 90);
668 raise;
669
670 end UPDATE_ALLOC_CHECKLIST;
671 --
672 -- ----------------------------------------------------------------------------
673 -- |------------------------<DELETE_ALLOC_CHECKLIST>-------------------------|
674 -- ----------------------------------------------------------------------------
675 --
676 procedure DELETE_ALLOC_CHECKLIST
677 (p_validate in boolean default false
678 ,p_allocated_checklist_id in number
679 ,p_object_version_number in number
680 ) is
681 --
682 -- Declare cursors and local variables
683 --
684 l_proc varchar2(72) := g_package||'delete_alloc_checklist';
688 hr_utility.set_location('Entering:'|| l_proc, 10);
685 l_object_version_number number(9) := p_object_version_number;
686
687 begin
689 --
690 -- Issue a savepoint
691 --
692 savepoint DELETE_ALLOC_CHECKLIST;
693 --
694 -- Call Before Process User Hook
695 --
696 begin
697 PER_ALLOCATED_CHECKLIST_BK3.DELETE_ALLOC_CHECKLIST_B
698 (p_allocated_checklist_id => p_allocated_checklist_id
699 ,p_object_version_number => p_object_version_number
700 );
701 exception
702 when hr_Api.cannot_find_prog_unit then
703 hr_Api.cannot_find_prog_unit_error
704 (p_module_name => 'DELETE_ALLOC_CHECKLIST'
705 ,p_hook_type => 'BP'
706 );
707 end;
708
709 --
710 -- Process Logic
711 --
712 per_pac_del.del
713 (p_allocated_checklist_id => p_allocated_checklist_id
714 ,p_object_version_number => p_object_version_number
715 );
716
717 --
718 -- Call After Process User Hook
719 --
720 begin
721 PER_ALLOCATED_CHECKLIST_BK3.DELETE_ALLOC_CHECKLIST_A
722 (p_allocated_checklist_id => p_allocated_checklist_id
723 ,p_object_version_number => p_object_version_number
724 );
725 exception
726 when hr_api.cannot_find_prog_unit then
727 hr_Api.cannot_find_prog_unit_error
728 (p_module_name => 'DELETE_ALLOC_CHECKLIST'
729 ,p_hook_type => 'AP'
730 );
731 end;
732 --
733 -- When in validation only mode raise the Validate_Enabled exception
734 --
735 if p_validate then
736 raise hr_Api.validate_enabled;
737 end if;
738 --
739 hr_utility.set_location(' Leaving:'||l_proc, 70);
740 exception
741 when hr_Api.validate_enabled then
742 --
743 -- As the Validate_Enabled exception has been raised
744 -- we must rollback to the savepoint
745 --
746 rollback to DELETE_ALLOC_CHECKLIST;
747 --
748 hr_utility.set_location(' Leaving:'||l_proc, 80);
749 when others then
750 --
751 -- A validation or unexpected error has occured
752 --
753 rollback to DELETE_ALLOC_CHECKLIST;
754 hr_utility.set_location(' Leaving:'||l_proc, 90);
755 raise;
756 end DELETE_ALLOC_CHECKLIST;
757 --
758 end PER_ALLOCATED_CHECKLIST_API;