DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_ELIG_LOS_PRTE_API

Source


1 Package Body ben_ELIG_LOS_PRTE_api as
2 /* $Header: beelsapi.pkb 120.0 2005/05/28 02:21:53 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package  varchar2(33) := '  ben_ELIG_LOS_PRTE_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_ELIG_LOS_PRTE >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_ELIG_LOS_PRTE
13   (p_validate                       in  boolean   default false
14   ,p_elig_los_prte_id               out nocopy number
15   ,p_effective_start_date           out nocopy date
16   ,p_effective_end_date             out nocopy date
17   ,p_business_group_id              in  number    default null
18   ,p_los_fctr_id                    in  number    default null
19   ,p_eligy_prfl_id                  in  number    default null
20   ,p_ordr_num                       in  number    default null
21   ,p_excld_flag                     in  varchar2  default null
22   ,p_els_attribute_category         in  varchar2  default null
23   ,p_els_attribute1                 in  varchar2  default null
24   ,p_els_attribute2                 in  varchar2  default null
25   ,p_els_attribute3                 in  varchar2  default null
26   ,p_els_attribute4                 in  varchar2  default null
27   ,p_els_attribute5                 in  varchar2  default null
28   ,p_els_attribute6                 in  varchar2  default null
29   ,p_els_attribute7                 in  varchar2  default null
30   ,p_els_attribute8                 in  varchar2  default null
31   ,p_els_attribute9                 in  varchar2  default null
32   ,p_els_attribute10                in  varchar2  default null
33   ,p_els_attribute11                in  varchar2  default null
34   ,p_els_attribute12                in  varchar2  default null
35   ,p_els_attribute13                in  varchar2  default null
36   ,p_els_attribute14                in  varchar2  default null
37   ,p_els_attribute15                in  varchar2  default null
38   ,p_els_attribute16                in  varchar2  default null
39   ,p_els_attribute17                in  varchar2  default null
40   ,p_els_attribute18                in  varchar2  default null
41   ,p_els_attribute19                in  varchar2  default null
42   ,p_els_attribute20                in  varchar2  default null
43   ,p_els_attribute21                in  varchar2  default null
44   ,p_els_attribute22                in  varchar2  default null
45   ,p_els_attribute23                in  varchar2  default null
46   ,p_els_attribute24                in  varchar2  default null
47   ,p_els_attribute25                in  varchar2  default null
48   ,p_els_attribute26                in  varchar2  default null
49   ,p_els_attribute27                in  varchar2  default null
50   ,p_els_attribute28                in  varchar2  default null
51   ,p_els_attribute29                in  varchar2  default null
52   ,p_els_attribute30                in  varchar2  default null
53   ,p_object_version_number          out nocopy number
54   ,p_effective_date                 in  date
55   ,p_criteria_score                 in number     default null
56   ,p_criteria_weight                in  number    default null
57   ) is
58   --
59   -- Declare cursors and local variables
60   --
61   l_elig_los_prte_id ben_elig_los_prte_f.elig_los_prte_id%TYPE;
62   l_effective_start_date ben_elig_los_prte_f.effective_start_date%TYPE;
63   l_effective_end_date ben_elig_los_prte_f.effective_end_date%TYPE;
64   l_proc varchar2(72) := g_package||'create_ELIG_LOS_PRTE';
65   l_object_version_number ben_elig_los_prte_f.object_version_number%TYPE;
66   --
67 begin
68   --
69   hr_utility.set_location('Entering:'|| l_proc, 10);
70   --
71   -- Issue a savepoint if operating in validation only mode
72   --
73   savepoint create_ELIG_LOS_PRTE;
74   --
75   hr_utility.set_location(l_proc, 20);
76   --
77   -- Process Logic
78   --
79   begin
80     --
81     -- Start of API User Hook for the before hook of create_ELIG_LOS_PRTE
82     --
83     ben_ELIG_LOS_PRTE_bk1.create_ELIG_LOS_PRTE_b
84       (
85        p_business_group_id              =>  p_business_group_id
86       ,p_los_fctr_id                    =>  p_los_fctr_id
87       ,p_eligy_prfl_id                  =>  p_eligy_prfl_id
88       ,p_ordr_num                       =>  p_ordr_num
89       ,p_excld_flag                     =>  p_excld_flag
90       ,p_els_attribute_category         =>  p_els_attribute_category
91       ,p_els_attribute1                 =>  p_els_attribute1
92       ,p_els_attribute2                 =>  p_els_attribute2
93       ,p_els_attribute3                 =>  p_els_attribute3
94       ,p_els_attribute4                 =>  p_els_attribute4
95       ,p_els_attribute5                 =>  p_els_attribute5
96       ,p_els_attribute6                 =>  p_els_attribute6
97       ,p_els_attribute7                 =>  p_els_attribute7
98       ,p_els_attribute8                 =>  p_els_attribute8
99       ,p_els_attribute9                 =>  p_els_attribute9
100       ,p_els_attribute10                =>  p_els_attribute10
101       ,p_els_attribute11                =>  p_els_attribute11
102       ,p_els_attribute12                =>  p_els_attribute12
103       ,p_els_attribute13                =>  p_els_attribute13
104       ,p_els_attribute14                =>  p_els_attribute14
105       ,p_els_attribute15                =>  p_els_attribute15
106       ,p_els_attribute16                =>  p_els_attribute16
107       ,p_els_attribute17                =>  p_els_attribute17
108       ,p_els_attribute18                =>  p_els_attribute18
109       ,p_els_attribute19                =>  p_els_attribute19
110       ,p_els_attribute20                =>  p_els_attribute20
111       ,p_els_attribute21                =>  p_els_attribute21
112       ,p_els_attribute22                =>  p_els_attribute22
113       ,p_els_attribute23                =>  p_els_attribute23
114       ,p_els_attribute24                =>  p_els_attribute24
115       ,p_els_attribute25                =>  p_els_attribute25
116       ,p_els_attribute26                =>  p_els_attribute26
117       ,p_els_attribute27                =>  p_els_attribute27
118       ,p_els_attribute28                =>  p_els_attribute28
119       ,p_els_attribute29                =>  p_els_attribute29
120       ,p_els_attribute30                =>  p_els_attribute30
121       ,p_effective_date                 => trunc(p_effective_date)
122       ,p_criteria_score                 =>  p_criteria_score
123       ,p_criteria_weight                =>  p_criteria_weight
124       );
125   exception
126     when hr_api.cannot_find_prog_unit then
127       hr_api.cannot_find_prog_unit_error
128         (
129          p_module_name => 'CREATE_ELIG_LOS_PRTE'
130         ,p_hook_type   => 'BP'
131         );
132     --
133     -- End of API User Hook for the before hook of create_ELIG_LOS_PRTE
134     --
135   end;
136   --
137   ben_els_ins.ins
138     (
139      p_elig_los_prte_id              => l_elig_los_prte_id
140     ,p_effective_start_date          => l_effective_start_date
141     ,p_effective_end_date            => l_effective_end_date
142     ,p_business_group_id             => p_business_group_id
143     ,p_los_fctr_id                   => p_los_fctr_id
144     ,p_eligy_prfl_id                 => p_eligy_prfl_id
145     ,p_ordr_num                      => p_ordr_num
146     ,p_excld_flag                    => p_excld_flag
147     ,p_els_attribute_category        => p_els_attribute_category
148     ,p_els_attribute1                => p_els_attribute1
149     ,p_els_attribute2                => p_els_attribute2
150     ,p_els_attribute3                => p_els_attribute3
151     ,p_els_attribute4                => p_els_attribute4
152     ,p_els_attribute5                => p_els_attribute5
153     ,p_els_attribute6                => p_els_attribute6
154     ,p_els_attribute7                => p_els_attribute7
155     ,p_els_attribute8                => p_els_attribute8
156     ,p_els_attribute9                => p_els_attribute9
157     ,p_els_attribute10               => p_els_attribute10
158     ,p_els_attribute11               => p_els_attribute11
159     ,p_els_attribute12               => p_els_attribute12
160     ,p_els_attribute13               => p_els_attribute13
161     ,p_els_attribute14               => p_els_attribute14
162     ,p_els_attribute15               => p_els_attribute15
163     ,p_els_attribute16               => p_els_attribute16
164     ,p_els_attribute17               => p_els_attribute17
165     ,p_els_attribute18               => p_els_attribute18
166     ,p_els_attribute19               => p_els_attribute19
167     ,p_els_attribute20               => p_els_attribute20
168     ,p_els_attribute21               => p_els_attribute21
169     ,p_els_attribute22               => p_els_attribute22
170     ,p_els_attribute23               => p_els_attribute23
171     ,p_els_attribute24               => p_els_attribute24
172     ,p_els_attribute25               => p_els_attribute25
173     ,p_els_attribute26               => p_els_attribute26
174     ,p_els_attribute27               => p_els_attribute27
175     ,p_els_attribute28               => p_els_attribute28
176     ,p_els_attribute29               => p_els_attribute29
177     ,p_els_attribute30               => p_els_attribute30
178     ,p_object_version_number         => l_object_version_number
179     ,p_effective_date                => trunc(p_effective_date)
180     ,p_criteria_score                =>  p_criteria_score
181     ,p_criteria_weight               =>  p_criteria_weight
182     );
183   --
184   begin
185     --
186     -- Start of API User Hook for the after hook of create_ELIG_LOS_PRTE
187     --
188     ben_ELIG_LOS_PRTE_bk1.create_ELIG_LOS_PRTE_a
189       (
190        p_elig_los_prte_id               =>  l_elig_los_prte_id
191       ,p_effective_start_date           =>  l_effective_start_date
192       ,p_effective_end_date             =>  l_effective_end_date
193       ,p_business_group_id              =>  p_business_group_id
194       ,p_los_fctr_id                    =>  p_los_fctr_id
195       ,p_eligy_prfl_id                  =>  p_eligy_prfl_id
196       ,p_ordr_num                       =>  p_ordr_num
197       ,p_excld_flag                     =>  p_excld_flag
198       ,p_els_attribute_category         =>  p_els_attribute_category
199       ,p_els_attribute1                 =>  p_els_attribute1
200       ,p_els_attribute2                 =>  p_els_attribute2
201       ,p_els_attribute3                 =>  p_els_attribute3
202       ,p_els_attribute4                 =>  p_els_attribute4
203       ,p_els_attribute5                 =>  p_els_attribute5
204       ,p_els_attribute6                 =>  p_els_attribute6
205       ,p_els_attribute7                 =>  p_els_attribute7
206       ,p_els_attribute8                 =>  p_els_attribute8
207       ,p_els_attribute9                 =>  p_els_attribute9
208       ,p_els_attribute10                =>  p_els_attribute10
209       ,p_els_attribute11                =>  p_els_attribute11
210       ,p_els_attribute12                =>  p_els_attribute12
211       ,p_els_attribute13                =>  p_els_attribute13
212       ,p_els_attribute14                =>  p_els_attribute14
213       ,p_els_attribute15                =>  p_els_attribute15
214       ,p_els_attribute16                =>  p_els_attribute16
215       ,p_els_attribute17                =>  p_els_attribute17
216       ,p_els_attribute18                =>  p_els_attribute18
217       ,p_els_attribute19                =>  p_els_attribute19
218       ,p_els_attribute20                =>  p_els_attribute20
219       ,p_els_attribute21                =>  p_els_attribute21
220       ,p_els_attribute22                =>  p_els_attribute22
221       ,p_els_attribute23                =>  p_els_attribute23
222       ,p_els_attribute24                =>  p_els_attribute24
223       ,p_els_attribute25                =>  p_els_attribute25
224       ,p_els_attribute26                =>  p_els_attribute26
225       ,p_els_attribute27                =>  p_els_attribute27
226       ,p_els_attribute28                =>  p_els_attribute28
227       ,p_els_attribute29                =>  p_els_attribute29
228       ,p_els_attribute30                =>  p_els_attribute30
229       ,p_object_version_number          =>  l_object_version_number
230       ,p_effective_date                      => trunc(p_effective_date)
231       ,p_criteria_score                 =>  p_criteria_score
232       ,p_criteria_weight                =>  p_criteria_weight
233       );
234   exception
235     when hr_api.cannot_find_prog_unit then
236       hr_api.cannot_find_prog_unit_error
237         (p_module_name => 'CREATE_ELIG_LOS_PRTE'
238         ,p_hook_type   => 'AP'
239         );
240     --
241     -- End of API User Hook for the after hook of create_ELIG_LOS_PRTE
242     --
243   end;
244   --
245   ben_profile_handler.event_handler
246     (p_event                       => 'CREATE',
247      p_base_table                  => 'BEN_ELIGY_PRFL_F',
248      p_base_table_column           => 'ELIGY_PRFL_ID',
249      p_base_table_column_value     => p_eligy_prfl_id,
250      p_base_table_reference_column => 'ELIG_LOS_FLAG',
251      p_reference_table             => 'BEN_ELIG_LOS_PRTE_F',
252      p_reference_table_column      => 'ELIGY_PRFL_ID');
253   --
254    ben_derivable_factor.derivable_factor_handler
255     (p_event                      => 'CREATE',
256      p_eligy_prfl_id              => p_eligy_prfl_id);
257   --
258 
259   hr_utility.set_location(l_proc, 60);
260   --
261   -- When in validation only mode raise the Validate_Enabled exception
262   --
263   if p_validate then
264     raise hr_api.validate_enabled;
265   end if;
266   --
267   -- Set all output arguments
268   --
269   p_elig_los_prte_id := l_elig_los_prte_id;
270   p_effective_start_date := l_effective_start_date;
271   p_effective_end_date := l_effective_end_date;
272   p_object_version_number := l_object_version_number;
273   --
274   hr_utility.set_location(' Leaving:'||l_proc, 70);
275   --
276 exception
277   --
278   when hr_api.validate_enabled then
279     --
280     -- As the Validate_Enabled exception has been raised
281     -- we must rollback to the savepoint
282     --
283     ROLLBACK TO create_ELIG_LOS_PRTE;
284     --
285     -- Only set output warning arguments
286     -- (Any key or derived arguments must be set to null
287     -- when validation only mode is being used.)
288     --
289     p_elig_los_prte_id := null;
290     p_effective_start_date := null;
291     p_effective_end_date := null;
292     p_object_version_number  := null;
293     hr_utility.set_location(' Leaving:'||l_proc, 80);
294     --
295   when others then
296     --
297     -- A validation or unexpected error has occured
298     --
299     ROLLBACK TO create_ELIG_LOS_PRTE;
300     raise;
301     --
302 end create_ELIG_LOS_PRTE;
303 -- ----------------------------------------------------------------------------
304 -- |------------------------< update_ELIG_LOS_PRTE >--- ------------------|
305 -- ----------------------------------------------------------------------------
306 --
307 procedure update_ELIG_LOS_PRTE
308   (p_validate                       in  boolean   default false
309   ,p_elig_los_prte_id               in  number
310   ,p_effective_start_date           out nocopy date
311   ,p_effective_end_date             out nocopy date
312   ,p_business_group_id              in  number    default hr_api.g_number
313   ,p_los_fctr_id                    in  number    default hr_api.g_number
314   ,p_eligy_prfl_id                  in  number    default hr_api.g_number
315   ,p_ordr_num                       in  number    default hr_api.g_number
316   ,p_excld_flag                     in  varchar2  default hr_api.g_varchar2
317   ,p_els_attribute_category         in  varchar2  default hr_api.g_varchar2
318   ,p_els_attribute1                 in  varchar2  default hr_api.g_varchar2
319   ,p_els_attribute2                 in  varchar2  default hr_api.g_varchar2
320   ,p_els_attribute3                 in  varchar2  default hr_api.g_varchar2
321   ,p_els_attribute4                 in  varchar2  default hr_api.g_varchar2
322   ,p_els_attribute5                 in  varchar2  default hr_api.g_varchar2
323   ,p_els_attribute6                 in  varchar2  default hr_api.g_varchar2
327   ,p_els_attribute10                in  varchar2  default hr_api.g_varchar2
324   ,p_els_attribute7                 in  varchar2  default hr_api.g_varchar2
325   ,p_els_attribute8                 in  varchar2  default hr_api.g_varchar2
326   ,p_els_attribute9                 in  varchar2  default hr_api.g_varchar2
328   ,p_els_attribute11                in  varchar2  default hr_api.g_varchar2
329   ,p_els_attribute12                in  varchar2  default hr_api.g_varchar2
330   ,p_els_attribute13                in  varchar2  default hr_api.g_varchar2
331   ,p_els_attribute14                in  varchar2  default hr_api.g_varchar2
332   ,p_els_attribute15                in  varchar2  default hr_api.g_varchar2
333   ,p_els_attribute16                in  varchar2  default hr_api.g_varchar2
334   ,p_els_attribute17                in  varchar2  default hr_api.g_varchar2
335   ,p_els_attribute18                in  varchar2  default hr_api.g_varchar2
336   ,p_els_attribute19                in  varchar2  default hr_api.g_varchar2
337   ,p_els_attribute20                in  varchar2  default hr_api.g_varchar2
338   ,p_els_attribute21                in  varchar2  default hr_api.g_varchar2
339   ,p_els_attribute22                in  varchar2  default hr_api.g_varchar2
340   ,p_els_attribute23                in  varchar2  default hr_api.g_varchar2
341   ,p_els_attribute24                in  varchar2  default hr_api.g_varchar2
342   ,p_els_attribute25                in  varchar2  default hr_api.g_varchar2
343   ,p_els_attribute26                in  varchar2  default hr_api.g_varchar2
344   ,p_els_attribute27                in  varchar2  default hr_api.g_varchar2
345   ,p_els_attribute28                in  varchar2  default hr_api.g_varchar2
346   ,p_els_attribute29                in  varchar2  default hr_api.g_varchar2
347   ,p_els_attribute30                in  varchar2  default hr_api.g_varchar2
348   ,p_object_version_number          in out nocopy number
349   ,p_effective_date                 in  date
350   ,p_datetrack_mode                 in  varchar2
351   ,p_criteria_score                 in number     default hr_api.g_number
352   ,p_criteria_weight                in  number    default hr_api.g_number
353   ) is
354   --
355   -- Declare cursors and local variables
356   --
357   l_proc varchar2(72) := g_package||'update_ELIG_LOS_PRTE';
358   l_object_version_number ben_elig_los_prte_f.object_version_number%TYPE;
359   l_effective_start_date ben_elig_los_prte_f.effective_start_date%TYPE;
360   l_effective_end_date ben_elig_los_prte_f.effective_end_date%TYPE;
361   --
362 begin
363   --
364   hr_utility.set_location('Entering:'|| l_proc, 10);
365   --
366   -- Issue a savepoint if operating in validation only mode
367   --
368   savepoint update_ELIG_LOS_PRTE;
369   --
370   hr_utility.set_location(l_proc, 20);
371   --
372   -- Process Logic
373   --
374   l_object_version_number := p_object_version_number;
375   --
376   begin
377     --
378     -- Start of API User Hook for the before hook of update_ELIG_LOS_PRTE
379     --
380     ben_ELIG_LOS_PRTE_bk2.update_ELIG_LOS_PRTE_b
381       (
382        p_elig_los_prte_id               =>  p_elig_los_prte_id
383       ,p_business_group_id              =>  p_business_group_id
384       ,p_los_fctr_id                    =>  p_los_fctr_id
385       ,p_eligy_prfl_id                  =>  p_eligy_prfl_id
386       ,p_ordr_num                       =>  p_ordr_num
387       ,p_excld_flag                     =>  p_excld_flag
388       ,p_els_attribute_category         =>  p_els_attribute_category
389       ,p_els_attribute1                 =>  p_els_attribute1
390       ,p_els_attribute2                 =>  p_els_attribute2
391       ,p_els_attribute3                 =>  p_els_attribute3
392       ,p_els_attribute4                 =>  p_els_attribute4
393       ,p_els_attribute5                 =>  p_els_attribute5
394       ,p_els_attribute6                 =>  p_els_attribute6
395       ,p_els_attribute7                 =>  p_els_attribute7
396       ,p_els_attribute8                 =>  p_els_attribute8
397       ,p_els_attribute9                 =>  p_els_attribute9
398       ,p_els_attribute10                =>  p_els_attribute10
399       ,p_els_attribute11                =>  p_els_attribute11
400       ,p_els_attribute12                =>  p_els_attribute12
401       ,p_els_attribute13                =>  p_els_attribute13
402       ,p_els_attribute14                =>  p_els_attribute14
403       ,p_els_attribute15                =>  p_els_attribute15
404       ,p_els_attribute16                =>  p_els_attribute16
405       ,p_els_attribute17                =>  p_els_attribute17
406       ,p_els_attribute18                =>  p_els_attribute18
407       ,p_els_attribute19                =>  p_els_attribute19
408       ,p_els_attribute20                =>  p_els_attribute20
409       ,p_els_attribute21                =>  p_els_attribute21
410       ,p_els_attribute22                =>  p_els_attribute22
411       ,p_els_attribute23                =>  p_els_attribute23
412       ,p_els_attribute24                =>  p_els_attribute24
413       ,p_els_attribute25                =>  p_els_attribute25
414       ,p_els_attribute26                =>  p_els_attribute26
415       ,p_els_attribute27                =>  p_els_attribute27
416       ,p_els_attribute28                =>  p_els_attribute28
417       ,p_els_attribute29                =>  p_els_attribute29
418       ,p_els_attribute30                =>  p_els_attribute30
419       ,p_object_version_number          =>  p_object_version_number
420     ,p_effective_date                      => trunc(p_effective_date)
424       );
421     ,p_datetrack_mode                      => p_datetrack_mode
422       ,p_criteria_score                 =>  p_criteria_score
423       ,p_criteria_weight                =>  p_criteria_weight
425   exception
426     when hr_api.cannot_find_prog_unit then
427       hr_api.cannot_find_prog_unit_error
428         (p_module_name => 'UPDATE_ELIG_LOS_PRTE'
429         ,p_hook_type   => 'BP'
430         );
431     --
432     -- End of API User Hook for the before hook of update_ELIG_LOS_PRTE
433     --
434   end;
435   --
436   ben_els_upd.upd
437     (
438      p_elig_los_prte_id              => p_elig_los_prte_id
439     ,p_effective_start_date          => l_effective_start_date
440     ,p_effective_end_date            => l_effective_end_date
441     ,p_business_group_id             => p_business_group_id
442     ,p_los_fctr_id                   => p_los_fctr_id
443     ,p_eligy_prfl_id                 => p_eligy_prfl_id
444     ,p_ordr_num                      => p_ordr_num
445     ,p_excld_flag                    => p_excld_flag
446     ,p_els_attribute_category        => p_els_attribute_category
447     ,p_els_attribute1                => p_els_attribute1
448     ,p_els_attribute2                => p_els_attribute2
449     ,p_els_attribute3                => p_els_attribute3
450     ,p_els_attribute4                => p_els_attribute4
451     ,p_els_attribute5                => p_els_attribute5
452     ,p_els_attribute6                => p_els_attribute6
453     ,p_els_attribute7                => p_els_attribute7
454     ,p_els_attribute8                => p_els_attribute8
455     ,p_els_attribute9                => p_els_attribute9
456     ,p_els_attribute10               => p_els_attribute10
457     ,p_els_attribute11               => p_els_attribute11
458     ,p_els_attribute12               => p_els_attribute12
459     ,p_els_attribute13               => p_els_attribute13
460     ,p_els_attribute14               => p_els_attribute14
461     ,p_els_attribute15               => p_els_attribute15
462     ,p_els_attribute16               => p_els_attribute16
463     ,p_els_attribute17               => p_els_attribute17
464     ,p_els_attribute18               => p_els_attribute18
465     ,p_els_attribute19               => p_els_attribute19
466     ,p_els_attribute20               => p_els_attribute20
467     ,p_els_attribute21               => p_els_attribute21
468     ,p_els_attribute22               => p_els_attribute22
469     ,p_els_attribute23               => p_els_attribute23
470     ,p_els_attribute24               => p_els_attribute24
471     ,p_els_attribute25               => p_els_attribute25
472     ,p_els_attribute26               => p_els_attribute26
473     ,p_els_attribute27               => p_els_attribute27
474     ,p_els_attribute28               => p_els_attribute28
475     ,p_els_attribute29               => p_els_attribute29
476     ,p_els_attribute30               => p_els_attribute30
477     ,p_object_version_number         => l_object_version_number
478     ,p_effective_date                => trunc(p_effective_date)
479     ,p_datetrack_mode                => p_datetrack_mode
480     ,p_criteria_score                =>  p_criteria_score
481     ,p_criteria_weight               =>  p_criteria_weight
482     );
483   --
484   begin
485     --
486     -- Start of API User Hook for the after hook of update_ELIG_LOS_PRTE
487     --
488     ben_ELIG_LOS_PRTE_bk2.update_ELIG_LOS_PRTE_a
489       (
490        p_elig_los_prte_id               =>  p_elig_los_prte_id
491       ,p_effective_start_date           =>  l_effective_start_date
492       ,p_effective_end_date             =>  l_effective_end_date
493       ,p_business_group_id              =>  p_business_group_id
494       ,p_los_fctr_id                    =>  p_los_fctr_id
495       ,p_eligy_prfl_id                  =>  p_eligy_prfl_id
496       ,p_ordr_num                       =>  p_ordr_num
497       ,p_excld_flag                     =>  p_excld_flag
498       ,p_els_attribute_category         =>  p_els_attribute_category
499       ,p_els_attribute1                 =>  p_els_attribute1
500       ,p_els_attribute2                 =>  p_els_attribute2
501       ,p_els_attribute3                 =>  p_els_attribute3
502       ,p_els_attribute4                 =>  p_els_attribute4
503       ,p_els_attribute5                 =>  p_els_attribute5
504       ,p_els_attribute6                 =>  p_els_attribute6
505       ,p_els_attribute7                 =>  p_els_attribute7
506       ,p_els_attribute8                 =>  p_els_attribute8
507       ,p_els_attribute9                 =>  p_els_attribute9
508       ,p_els_attribute10                =>  p_els_attribute10
509       ,p_els_attribute11                =>  p_els_attribute11
510       ,p_els_attribute12                =>  p_els_attribute12
511       ,p_els_attribute13                =>  p_els_attribute13
512       ,p_els_attribute14                =>  p_els_attribute14
513       ,p_els_attribute15                =>  p_els_attribute15
514       ,p_els_attribute16                =>  p_els_attribute16
515       ,p_els_attribute17                =>  p_els_attribute17
516       ,p_els_attribute18                =>  p_els_attribute18
517       ,p_els_attribute19                =>  p_els_attribute19
518       ,p_els_attribute20                =>  p_els_attribute20
519       ,p_els_attribute21                =>  p_els_attribute21
520       ,p_els_attribute22                =>  p_els_attribute22
521       ,p_els_attribute23                =>  p_els_attribute23
522       ,p_els_attribute24                =>  p_els_attribute24
526       ,p_els_attribute28                =>  p_els_attribute28
523       ,p_els_attribute25                =>  p_els_attribute25
524       ,p_els_attribute26                =>  p_els_attribute26
525       ,p_els_attribute27                =>  p_els_attribute27
527       ,p_els_attribute29                =>  p_els_attribute29
528       ,p_els_attribute30                =>  p_els_attribute30
529       ,p_object_version_number          =>  l_object_version_number
530       ,p_effective_date                     => trunc(p_effective_date)
531       ,p_datetrack_mode                     => p_datetrack_mode
532       ,p_criteria_score                 =>  p_criteria_score
533       ,p_criteria_weight                =>  p_criteria_weight
534       );
535   exception
536     when hr_api.cannot_find_prog_unit then
537       hr_api.cannot_find_prog_unit_error
538         (p_module_name => 'UPDATE_ELIG_LOS_PRTE'
539         ,p_hook_type   => 'AP'
540         );
541     --
542     -- End of API User Hook for the after hook of update_ELIG_LOS_PRTE
543     --
544   end;
545   --
546   hr_utility.set_location(l_proc, 60);
547   --
548   -- When in validation only mode raise the Validate_Enabled exception
549   --
550   if p_validate then
551     raise hr_api.validate_enabled;
552   end if;
553   --
554   -- Set all output arguments
555   --
556   p_object_version_number := l_object_version_number;
557   p_effective_start_date := l_effective_start_date;
558   p_effective_end_date := l_effective_end_date;
559   --
560   hr_utility.set_location(' Leaving:'||l_proc, 70);
561   --
562 exception
563   --
564   when hr_api.validate_enabled then
565     --
566     -- As the Validate_Enabled exception has been raised
567     -- we must rollback to the savepoint
568     --
569     ROLLBACK TO update_ELIG_LOS_PRTE;
570     --
571     -- Only set output warning arguments
572     -- (Any key or derived arguments must be set to null
573     -- when validation only mode is being used.)
574     --
575     hr_utility.set_location(' Leaving:'||l_proc, 80);
576     --
577   when others then
578     --
579     -- A validation or unexpected error has occured
580     --
581     ROLLBACK TO update_ELIG_LOS_PRTE;
582     raise;
583     --
584 end update_ELIG_LOS_PRTE;
585 -- ----------------------------------------------------------------------------
586 -- |------------------------< delete_ELIG_LOS_PRTE >----------------------|
587 -- ----------------------------------------------------------------------------
588 --
589 procedure delete_ELIG_LOS_PRTE
590   (p_validate                       in  boolean  default false
591   ,p_elig_los_prte_id               in  number
592   ,p_effective_start_date           out nocopy date
593   ,p_effective_end_date             out nocopy date
594   ,p_object_version_number          in out nocopy number
595   ,p_effective_date                 in  date
596   ,p_datetrack_mode                 in  varchar2
597   ) is
598   --
599   -- Declare cursors and local variables
600   --
601   l_proc varchar2(72) := g_package||'update_ELIG_LOS_PRTE';
602   l_object_version_number ben_elig_los_prte_f.object_version_number%TYPE;
603   l_effective_start_date ben_elig_los_prte_f.effective_start_date%TYPE;
604   l_effective_end_date ben_elig_los_prte_f.effective_end_date%TYPE;
605   --
606 begin
607   --
608   hr_utility.set_location('Entering:'|| l_proc, 10);
609   --
610   -- Issue a savepoint if operating in validation only mode
611   --
612   savepoint delete_ELIG_LOS_PRTE;
613   --
614   hr_utility.set_location(l_proc, 20);
615   --
616   -- Process Logic
617   --
618   l_object_version_number := p_object_version_number;
619   --
620   --
621   begin
622     --
623     -- Start of API User Hook for the before hook of delete_ELIG_LOS_PRTE
624     --
625     ben_ELIG_LOS_PRTE_bk3.delete_ELIG_LOS_PRTE_b
626       (
627        p_elig_los_prte_id               =>  p_elig_los_prte_id
628       ,p_object_version_number          =>  p_object_version_number
629     ,p_effective_date                      => trunc(p_effective_date)
630     ,p_datetrack_mode                      => p_datetrack_mode
631       );
632   exception
633     when hr_api.cannot_find_prog_unit then
634       hr_api.cannot_find_prog_unit_error
635         (p_module_name => 'DELETE_ELIG_LOS_PRTE'
636         ,p_hook_type   => 'BP'
637         );
638     --
639     -- End of API User Hook for the before hook of delete_ELIG_LOS_PRTE
640     --
641   end;
642   --
643   ben_els_del.del
644     (
645      p_elig_los_prte_id              => p_elig_los_prte_id
646     ,p_effective_start_date          => l_effective_start_date
647     ,p_effective_end_date            => l_effective_end_date
648     ,p_object_version_number         => l_object_version_number
649     ,p_effective_date                => p_effective_date
650     ,p_datetrack_mode                => p_datetrack_mode
651     );
652   --
653   begin
654     --
655     -- Start of API User Hook for the after hook of delete_ELIG_LOS_PRTE
656     --
657     ben_ELIG_LOS_PRTE_bk3.delete_ELIG_LOS_PRTE_a
658       (
659        p_elig_los_prte_id               =>  p_elig_los_prte_id
660       ,p_effective_start_date           =>  l_effective_start_date
661       ,p_effective_end_date             =>  l_effective_end_date
662       ,p_object_version_number          =>  l_object_version_number
663     ,p_effective_date                      => trunc(p_effective_date)
664     ,p_datetrack_mode                      => p_datetrack_mode
665       );
666   exception
667     when hr_api.cannot_find_prog_unit then
668       hr_api.cannot_find_prog_unit_error
669         (p_module_name => 'DELETE_ELIG_LOS_PRTE'
670         ,p_hook_type   => 'AP'
671         );
672     --
673     -- End of API User Hook for the after hook of delete_ELIG_LOS_PRTE
674     --
675   end;
676   --
677   ben_profile_handler.event_handler
678     (p_event                       => 'DELETE',
679      p_base_table                  => 'BEN_ELIGY_PRFL_F',
680      p_base_table_column           => 'ELIGY_PRFL_ID',
681      p_base_table_column_value     => ben_els_shd.g_old_rec.eligy_prfl_id,
682      p_base_table_reference_column => 'ELIG_LOS_FLAG',
683      p_reference_table             => 'BEN_ELIG_LOS_PRTE_F',
684      p_reference_table_column      => 'ELIGY_PRFL_ID');
685   --
686    ben_derivable_factor.derivable_factor_handler
687     (p_event                      => 'DELETE',
688      p_eligy_prfl_id              => ben_els_shd.g_old_rec.eligy_prfl_id);
689   --
690 
691   hr_utility.set_location(l_proc, 60);
692   --
693   -- When in validation only mode raise the Validate_Enabled exception
694   --
695   if p_validate then
696     raise hr_api.validate_enabled;
697   end if;
698   --
699   hr_utility.set_location(' Leaving:'||l_proc, 70);
700   --
701 exception
702   --
703   when hr_api.validate_enabled then
704     --
705     -- As the Validate_Enabled exception has been raised
706     -- we must rollback to the savepoint
707     --
708     ROLLBACK TO delete_ELIG_LOS_PRTE;
709     --
713     --
710     -- Only set output warning arguments
711     -- (Any key or derived arguments must be set to null
712     -- when validation only mode is being used.)
714     p_effective_start_date := null;
715     p_effective_end_date := null;
716     --
717   when others then
718     --
719     -- A validation or unexpected error has occured
720     --
721     ROLLBACK TO delete_ELIG_LOS_PRTE;
722     raise;
723     --
724 end delete_ELIG_LOS_PRTE;
725 --
726 -- ----------------------------------------------------------------------------
727 -- |-------------------------------< lck >------------------------------------|
728 -- ----------------------------------------------------------------------------
729 --
730 procedure lck
731   (
732    p_elig_los_prte_id                   in     number
733   ,p_object_version_number          in     number
734   ,p_effective_date                 in     date
735   ,p_datetrack_mode                 in     varchar2
736   ,p_validation_start_date          out nocopy    date
737   ,p_validation_end_date            out nocopy    date
738   ) is
739   --
740   --
741   -- Declare cursors and local variables
742   --
743   l_proc varchar2(72) := g_package||'lck';
744   l_validation_start_date date;
745   l_validation_end_date date;
746   --
747 begin
748   --
749   hr_utility.set_location('Entering:'|| l_proc, 10);
750   --
751   ben_els_shd.lck
752     (
753       p_elig_los_prte_id                 => p_elig_los_prte_id
754      ,p_validation_start_date      => l_validation_start_date
755      ,p_validation_end_date        => l_validation_end_date
756      ,p_object_version_number      => p_object_version_number
757      ,p_effective_date             => p_effective_date
758      ,p_datetrack_mode             => p_datetrack_mode
759     );
760   --
761   hr_utility.set_location(' Leaving:'||l_proc, 70);
762   --
763 end lck;
764 --
765 end ben_ELIG_LOS_PRTE_api;