DBA Data[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;