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