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