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