DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_PARTICIPATION_ELIG_API

Source


1 Package Body ben_Participation_Elig_api as
2 /* $Header: beepaapi.pkb 120.0 2005/05/28 02:34:54 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package  varchar2(33) := '  ben_Participation_Elig_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_Participation_Elig >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Participation_Elig
13   (p_validate                       in  boolean   default false
14   ,p_prtn_elig_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_pgm_id                         in  number    default null
19   ,p_pl_id                          in  number    default null
20   ,p_oipl_id                        in  number    default null
21   ,p_ptip_id                        in  number    default null
22   ,p_plip_id                        in  number    default null
23   ,p_trk_scr_for_inelg_flag         in  varchar2  default null
24   ,p_prtn_eff_strt_dt_cd            in  varchar2  default null
25   ,p_prtn_eff_end_dt_cd             in  varchar2  default null
26   ,p_prtn_eff_strt_dt_rl            in  number    default null
27   ,p_prtn_eff_end_dt_rl             in  number    default null
28   ,p_wait_perd_dt_to_use_cd         in  varchar2  default null
29   ,p_wait_perd_dt_to_use_rl         in  number    default null
30   ,p_wait_perd_val                  in  number    default null
31   ,p_wait_perd_uom                  in  varchar2  default null
32   ,p_wait_perd_rl                   in  number    default null
33   ,p_mx_poe_det_dt_cd               in  varchar2  default null
34   ,p_mx_poe_det_dt_rl               in  number    default null
35   ,p_mx_poe_val                     in  number    default null
36   ,p_mx_poe_uom                     in  varchar2  default null
37   ,p_mx_poe_rl                      in  number    default null
38   ,p_mx_poe_apls_cd                 in  varchar2  default null
39   ,p_epa_attribute_category         in  varchar2  default null
40   ,p_epa_attribute1                 in  varchar2  default null
41   ,p_epa_attribute2                 in  varchar2  default null
42   ,p_epa_attribute3                 in  varchar2  default null
43   ,p_epa_attribute4                 in  varchar2  default null
44   ,p_epa_attribute5                 in  varchar2  default null
45   ,p_epa_attribute6                 in  varchar2  default null
46   ,p_epa_attribute7                 in  varchar2  default null
47   ,p_epa_attribute8                 in  varchar2  default null
48   ,p_epa_attribute9                 in  varchar2  default null
49   ,p_epa_attribute10                in  varchar2  default null
50   ,p_epa_attribute11                in  varchar2  default null
51   ,p_epa_attribute12                in  varchar2  default null
52   ,p_epa_attribute13                in  varchar2  default null
53   ,p_epa_attribute14                in  varchar2  default null
54   ,p_epa_attribute15                in  varchar2  default null
55   ,p_epa_attribute16                in  varchar2  default null
56   ,p_epa_attribute17                in  varchar2  default null
57   ,p_epa_attribute18                in  varchar2  default null
58   ,p_epa_attribute19                in  varchar2  default null
59   ,p_epa_attribute20                in  varchar2  default null
60   ,p_epa_attribute21                in  varchar2  default null
61   ,p_epa_attribute22                in  varchar2  default null
62   ,p_epa_attribute23                in  varchar2  default null
63   ,p_epa_attribute24                in  varchar2  default null
64   ,p_epa_attribute25                in  varchar2  default null
65   ,p_epa_attribute26                in  varchar2  default null
66   ,p_epa_attribute27                in  varchar2  default null
67   ,p_epa_attribute28                in  varchar2  default null
68   ,p_epa_attribute29                in  varchar2  default null
69   ,p_epa_attribute30                in  varchar2  default null
70   ,p_object_version_number          out nocopy number
71   ,p_effective_date                 in  date
72   ) is
73   --
74   -- Declare cursors and local variables
75   --
76   l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77   l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78   l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79   l_proc varchar2(72) := g_package||'create_Participation_Elig';
80   l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81   --
82 begin
83   --
84   hr_utility.set_location('Entering:'|| l_proc, 10);
85   --
86   -- Issue a savepoint if operating in validation only mode
87   --
88   savepoint create_Participation_Elig;
89   --
90   hr_utility.set_location(l_proc, 20);
91   --
92   -- Process Logic
93   --
94   begin
95     --
96     -- Start of API User Hook for the before hook of create_Participation_Elig
97     --
98     ben_Participation_Elig_bk1.create_Participation_Elig_b
99       (p_business_group_id              =>  p_business_group_id
100       ,p_pgm_id                         =>  p_pgm_id
101       ,p_pl_id                          =>  p_pl_id
102       ,p_oipl_id                        =>  p_oipl_id
103       ,p_ptip_id                        =>  p_ptip_id
104       ,p_plip_id                        =>  p_plip_id
105       ,p_trk_scr_for_inelg_flag         =>  p_trk_scr_for_inelg_flag
106       ,p_prtn_eff_strt_dt_cd            =>  p_prtn_eff_strt_dt_cd
107       ,p_prtn_eff_end_dt_cd             =>  p_prtn_eff_end_dt_cd
108       ,p_prtn_eff_strt_dt_rl            =>  p_prtn_eff_strt_dt_rl
109       ,p_prtn_eff_end_dt_rl             =>  p_prtn_eff_end_dt_rl
110       ,p_wait_perd_dt_to_use_cd         =>  p_wait_perd_dt_to_use_cd
111       ,p_wait_perd_dt_to_use_rl         =>  p_wait_perd_dt_to_use_rl
112       ,p_wait_perd_val                  =>  p_wait_perd_val
113       ,p_wait_perd_uom                  =>  p_wait_perd_uom
114       ,p_wait_perd_rl                   =>  p_wait_perd_rl
115       ,p_mx_poe_det_dt_cd               =>  p_mx_poe_det_dt_cd
116       ,p_mx_poe_det_dt_rl               =>  p_mx_poe_det_dt_rl
117       ,p_mx_poe_val                     =>  p_mx_poe_val
118       ,p_mx_poe_uom                     =>  p_mx_poe_uom
119       ,p_mx_poe_rl                      =>  p_mx_poe_rl
120       ,p_mx_poe_apls_cd                 =>  p_mx_poe_apls_cd
121       ,p_epa_attribute_category         =>  p_epa_attribute_category
122       ,p_epa_attribute1                 =>  p_epa_attribute1
123       ,p_epa_attribute2                 =>  p_epa_attribute2
124       ,p_epa_attribute3                 =>  p_epa_attribute3
125       ,p_epa_attribute4                 =>  p_epa_attribute4
126       ,p_epa_attribute5                 =>  p_epa_attribute5
127       ,p_epa_attribute6                 =>  p_epa_attribute6
128       ,p_epa_attribute7                 =>  p_epa_attribute7
129       ,p_epa_attribute8                 =>  p_epa_attribute8
130       ,p_epa_attribute9                 =>  p_epa_attribute9
131       ,p_epa_attribute10                =>  p_epa_attribute10
132       ,p_epa_attribute11                =>  p_epa_attribute11
133       ,p_epa_attribute12                =>  p_epa_attribute12
134       ,p_epa_attribute13                =>  p_epa_attribute13
135       ,p_epa_attribute14                =>  p_epa_attribute14
136       ,p_epa_attribute15                =>  p_epa_attribute15
137       ,p_epa_attribute16                =>  p_epa_attribute16
138       ,p_epa_attribute17                =>  p_epa_attribute17
139       ,p_epa_attribute18                =>  p_epa_attribute18
140       ,p_epa_attribute19                =>  p_epa_attribute19
141       ,p_epa_attribute20                =>  p_epa_attribute20
142       ,p_epa_attribute21                =>  p_epa_attribute21
143       ,p_epa_attribute22                =>  p_epa_attribute22
144       ,p_epa_attribute23                =>  p_epa_attribute23
145       ,p_epa_attribute24                =>  p_epa_attribute24
146       ,p_epa_attribute25                =>  p_epa_attribute25
147       ,p_epa_attribute26                =>  p_epa_attribute26
148       ,p_epa_attribute27                =>  p_epa_attribute27
149       ,p_epa_attribute28                =>  p_epa_attribute28
150       ,p_epa_attribute29                =>  p_epa_attribute29
151       ,p_epa_attribute30                =>  p_epa_attribute30
152       ,p_effective_date                 =>  trunc(p_effective_date));
153     --
154   exception
155     --
156     when hr_api.cannot_find_prog_unit then
157       --
158       hr_api.cannot_find_prog_unit_error
159         (p_module_name => 'CREATE_Participation_Elig'
160         ,p_hook_type   => 'BP');
161     --
162     -- End of API User Hook for the before hook of create_Participation_Elig
163     --
164   end;
165   --
166   ben_epa_ins.ins
167     (p_prtn_elig_id                  => l_prtn_elig_id
168     ,p_effective_start_date          => l_effective_start_date
169     ,p_effective_end_date            => l_effective_end_date
170     ,p_business_group_id             => p_business_group_id
171     ,p_pgm_id                        => p_pgm_id
172     ,p_pl_id                         => p_pl_id
173     ,p_oipl_id                       => p_oipl_id
174     ,p_ptip_id                       => p_ptip_id
175     ,p_plip_id                       => p_plip_id
176     ,p_trk_scr_for_inelg_flag        => p_trk_scr_for_inelg_flag
177     ,p_prtn_eff_strt_dt_cd           => p_prtn_eff_strt_dt_cd
178     ,p_prtn_eff_end_dt_cd            => p_prtn_eff_end_dt_cd
179     ,p_prtn_eff_strt_dt_rl           => p_prtn_eff_strt_dt_rl
180     ,p_prtn_eff_end_dt_rl            => p_prtn_eff_end_dt_rl
181     ,p_wait_perd_dt_to_use_cd        =>  p_wait_perd_dt_to_use_cd
182     ,p_wait_perd_dt_to_use_rl        =>  p_wait_perd_dt_to_use_rl
183     ,p_wait_perd_val                 =>  p_wait_perd_val
184     ,p_wait_perd_uom                 =>  p_wait_perd_uom
185     ,p_wait_perd_rl                  =>  p_wait_perd_rl
186     ,p_mx_poe_det_dt_cd              =>  p_mx_poe_det_dt_cd
187     ,p_mx_poe_det_dt_rl              =>  p_mx_poe_det_dt_rl
188     ,p_mx_poe_val                    =>  p_mx_poe_val
189     ,p_mx_poe_uom                    =>  p_mx_poe_uom
190     ,p_mx_poe_rl                     =>  p_mx_poe_rl
191     ,p_mx_poe_apls_cd                => p_mx_poe_apls_cd
192     ,p_epa_attribute_category        => p_epa_attribute_category
193     ,p_epa_attribute1                => p_epa_attribute1
194     ,p_epa_attribute2                => p_epa_attribute2
195     ,p_epa_attribute3                => p_epa_attribute3
196     ,p_epa_attribute4                => p_epa_attribute4
197     ,p_epa_attribute5                => p_epa_attribute5
198     ,p_epa_attribute6                => p_epa_attribute6
199     ,p_epa_attribute7                => p_epa_attribute7
200     ,p_epa_attribute8                => p_epa_attribute8
201     ,p_epa_attribute9                => p_epa_attribute9
202     ,p_epa_attribute10               => p_epa_attribute10
203     ,p_epa_attribute11               => p_epa_attribute11
204     ,p_epa_attribute12               => p_epa_attribute12
205     ,p_epa_attribute13               => p_epa_attribute13
206     ,p_epa_attribute14               => p_epa_attribute14
207     ,p_epa_attribute15               => p_epa_attribute15
208     ,p_epa_attribute16               => p_epa_attribute16
209     ,p_epa_attribute17               => p_epa_attribute17
210     ,p_epa_attribute18               => p_epa_attribute18
211     ,p_epa_attribute19               => p_epa_attribute19
212     ,p_epa_attribute20               => p_epa_attribute20
213     ,p_epa_attribute21               => p_epa_attribute21
214     ,p_epa_attribute22               => p_epa_attribute22
215     ,p_epa_attribute23               => p_epa_attribute23
216     ,p_epa_attribute24               => p_epa_attribute24
217     ,p_epa_attribute25               => p_epa_attribute25
218     ,p_epa_attribute26               => p_epa_attribute26
219     ,p_epa_attribute27               => p_epa_attribute27
220     ,p_epa_attribute28               => p_epa_attribute28
221     ,p_epa_attribute29               => p_epa_attribute29
222     ,p_epa_attribute30               => p_epa_attribute30
223     ,p_object_version_number         => l_object_version_number
224     ,p_effective_date                => trunc(p_effective_date));
225   --
226   begin
227     --
228     -- Start of API User Hook for the after hook of create_Participation_Elig
229     --
230     ben_Participation_Elig_bk1.create_Participation_Elig_a
231       (p_prtn_elig_id                   =>  l_prtn_elig_id
232       ,p_effective_start_date           =>  l_effective_start_date
233       ,p_effective_end_date             =>  l_effective_end_date
234       ,p_business_group_id              =>  p_business_group_id
235       ,p_pgm_id                         =>  p_pgm_id
236       ,p_pl_id                          =>  p_pl_id
237       ,p_oipl_id                        =>  p_oipl_id
238       ,p_ptip_id                        =>  p_ptip_id
239       ,p_plip_id                        =>  p_plip_id
240       ,p_trk_scr_for_inelg_flag         =>  p_trk_scr_for_inelg_flag
241       ,p_prtn_eff_strt_dt_cd            =>  p_prtn_eff_strt_dt_cd
242       ,p_prtn_eff_end_dt_cd             =>  p_prtn_eff_end_dt_cd
243       ,p_prtn_eff_strt_dt_rl            =>  p_prtn_eff_strt_dt_rl
244       ,p_prtn_eff_end_dt_rl             =>  p_prtn_eff_end_dt_rl
245       ,p_wait_perd_dt_to_use_cd         =>  p_wait_perd_dt_to_use_cd
246       ,p_wait_perd_dt_to_use_rl         =>  p_wait_perd_dt_to_use_rl
247       ,p_wait_perd_val                  =>  p_wait_perd_val
248       ,p_wait_perd_uom                  =>  p_wait_perd_uom
249       ,p_wait_perd_rl                   =>  p_wait_perd_rl
250       ,p_mx_poe_det_dt_cd               =>  p_mx_poe_det_dt_cd
251       ,p_mx_poe_det_dt_rl               =>  p_mx_poe_det_dt_rl
252       ,p_mx_poe_val                     =>  p_mx_poe_val
253       ,p_mx_poe_uom                     =>  p_mx_poe_uom
254       ,p_mx_poe_rl                      =>  p_mx_poe_rl
255       ,p_mx_poe_apls_cd                 =>  p_mx_poe_apls_cd
256       ,p_epa_attribute_category         =>  p_epa_attribute_category
257       ,p_epa_attribute1                 =>  p_epa_attribute1
258       ,p_epa_attribute2                 =>  p_epa_attribute2
259       ,p_epa_attribute3                 =>  p_epa_attribute3
260       ,p_epa_attribute4                 =>  p_epa_attribute4
261       ,p_epa_attribute5                 =>  p_epa_attribute5
262       ,p_epa_attribute6                 =>  p_epa_attribute6
263       ,p_epa_attribute7                 =>  p_epa_attribute7
264       ,p_epa_attribute8                 =>  p_epa_attribute8
265       ,p_epa_attribute9                 =>  p_epa_attribute9
266       ,p_epa_attribute10                =>  p_epa_attribute10
267       ,p_epa_attribute11                =>  p_epa_attribute11
268       ,p_epa_attribute12                =>  p_epa_attribute12
269       ,p_epa_attribute13                =>  p_epa_attribute13
270       ,p_epa_attribute14                =>  p_epa_attribute14
271       ,p_epa_attribute15                =>  p_epa_attribute15
272       ,p_epa_attribute16                =>  p_epa_attribute16
273       ,p_epa_attribute17                =>  p_epa_attribute17
274       ,p_epa_attribute18                =>  p_epa_attribute18
275       ,p_epa_attribute19                =>  p_epa_attribute19
276       ,p_epa_attribute20                =>  p_epa_attribute20
277       ,p_epa_attribute21                =>  p_epa_attribute21
278       ,p_epa_attribute22                =>  p_epa_attribute22
279       ,p_epa_attribute23                =>  p_epa_attribute23
280       ,p_epa_attribute24                =>  p_epa_attribute24
281       ,p_epa_attribute25                =>  p_epa_attribute25
282       ,p_epa_attribute26                =>  p_epa_attribute26
283       ,p_epa_attribute27                =>  p_epa_attribute27
284       ,p_epa_attribute28                =>  p_epa_attribute28
285       ,p_epa_attribute29                =>  p_epa_attribute29
286       ,p_epa_attribute30                =>  p_epa_attribute30
287       ,p_object_version_number          =>  l_object_version_number
288       ,p_effective_date                 =>  trunc(p_effective_date));
289     --
290   exception
291     --
292     when hr_api.cannot_find_prog_unit then
293       --
294       hr_api.cannot_find_prog_unit_error
295         (p_module_name => 'CREATE_Participation_Elig'
296         ,p_hook_type   => 'AP');
297     --
298     -- End of API User Hook for the after hook of create_Participation_Elig
299     --
300   end;
301   --
302   hr_utility.set_location(l_proc, 60);
303   --
304   -- When in validation only mode raise the Validate_Enabled exception
305   --
306   if p_validate then
307     raise hr_api.validate_enabled;
308   end if;
309   --
310   -- Set all output arguments
311   --
312   p_prtn_elig_id := l_prtn_elig_id;
313   p_effective_start_date := l_effective_start_date;
314   p_effective_end_date := l_effective_end_date;
315   p_object_version_number := l_object_version_number;
316   --
317   hr_utility.set_location(' Leaving:'||l_proc, 70);
318   --
319 exception
320   --
321   when hr_api.validate_enabled then
322     --
323     -- As the Validate_Enabled exception has been raised
324     -- we must rollback to the savepoint
325     --
326     ROLLBACK TO create_Participation_Elig;
327     --
328     -- Only set output warning arguments
329     -- (Any key or derived arguments must be set to null
330     -- when validation only mode is being used.)
331     --
332     p_prtn_elig_id := null;
333     p_effective_start_date := null;
334     p_effective_end_date := null;
335     p_object_version_number  := null;
336     hr_utility.set_location(' Leaving:'||l_proc, 80);
337     --
338   when others then
339     --
340     -- A validation or unexpected error has occured
341     --
342     p_prtn_elig_id := null;
343     p_effective_start_date := null;
344     p_effective_end_date := null;
345     p_object_version_number  := null;
346     hr_utility.set_location(' Leaving:'||l_proc, 80);
347     --
348     ROLLBACK TO create_Participation_Elig;
349     raise;
350     --
351 end create_Participation_Elig;
352 -- ----------------------------------------------------------------------------
353 -- |------------------------< update_Participation_Elig >---------------------|
354 -- ----------------------------------------------------------------------------
355 --
356 procedure update_Participation_Elig
357   (p_validate                       in  boolean   default false
358   ,p_prtn_elig_id                   in  number
359   ,p_effective_start_date           out nocopy date
360   ,p_effective_end_date             out nocopy date
361   ,p_business_group_id              in  number    default hr_api.g_number
362   ,p_pgm_id                         in  number    default hr_api.g_number
363   ,p_pl_id                          in  number    default hr_api.g_number
364   ,p_oipl_id                        in  number    default hr_api.g_number
365   ,p_ptip_id                        in  number    default hr_api.g_number
366   ,p_plip_id                        in  number    default hr_api.g_number
367   ,p_trk_scr_for_inelg_flag         in  varchar2  default hr_api.g_varchar2
368   ,p_prtn_eff_strt_dt_cd            in  varchar2  default hr_api.g_varchar2
369   ,p_prtn_eff_end_dt_cd             in  varchar2  default hr_api.g_varchar2
370   ,p_prtn_eff_strt_dt_rl            in  number    default hr_api.g_number
371   ,p_prtn_eff_end_dt_rl             in  number    default hr_api.g_number
372   ,p_wait_perd_dt_to_use_cd         in  varchar2  default hr_api.g_varchar2
373   ,p_wait_perd_dt_to_use_rl         in  number    default hr_api.g_number
374   ,p_wait_perd_val                  in  number    default hr_api.g_number
375   ,p_wait_perd_uom                  in  varchar2  default hr_api.g_varchar2
376   ,p_wait_perd_rl                   in  number    default hr_api.g_number
377   ,p_mx_poe_det_dt_cd               in  varchar2  default hr_api.g_varchar2
378   ,p_mx_poe_det_dt_rl               in  number    default hr_api.g_number
379   ,p_mx_poe_val                     in  number    default hr_api.g_number
380   ,p_mx_poe_uom                     in  varchar2  default hr_api.g_varchar2
381   ,p_mx_poe_rl                      in  number    default hr_api.g_number
382   ,p_mx_poe_apls_cd                 in  varchar2  default hr_api.g_varchar2
383   ,p_epa_attribute_category         in  varchar2  default hr_api.g_varchar2
384   ,p_epa_attribute1                 in  varchar2  default hr_api.g_varchar2
385   ,p_epa_attribute2                 in  varchar2  default hr_api.g_varchar2
386   ,p_epa_attribute3                 in  varchar2  default hr_api.g_varchar2
387   ,p_epa_attribute4                 in  varchar2  default hr_api.g_varchar2
388   ,p_epa_attribute5                 in  varchar2  default hr_api.g_varchar2
389   ,p_epa_attribute6                 in  varchar2  default hr_api.g_varchar2
390   ,p_epa_attribute7                 in  varchar2  default hr_api.g_varchar2
391   ,p_epa_attribute8                 in  varchar2  default hr_api.g_varchar2
392   ,p_epa_attribute9                 in  varchar2  default hr_api.g_varchar2
393   ,p_epa_attribute10                in  varchar2  default hr_api.g_varchar2
394   ,p_epa_attribute11                in  varchar2  default hr_api.g_varchar2
395   ,p_epa_attribute12                in  varchar2  default hr_api.g_varchar2
396   ,p_epa_attribute13                in  varchar2  default hr_api.g_varchar2
397   ,p_epa_attribute14                in  varchar2  default hr_api.g_varchar2
398   ,p_epa_attribute15                in  varchar2  default hr_api.g_varchar2
399   ,p_epa_attribute16                in  varchar2  default hr_api.g_varchar2
400   ,p_epa_attribute17                in  varchar2  default hr_api.g_varchar2
401   ,p_epa_attribute18                in  varchar2  default hr_api.g_varchar2
402   ,p_epa_attribute19                in  varchar2  default hr_api.g_varchar2
403   ,p_epa_attribute20                in  varchar2  default hr_api.g_varchar2
404   ,p_epa_attribute21                in  varchar2  default hr_api.g_varchar2
405   ,p_epa_attribute22                in  varchar2  default hr_api.g_varchar2
406   ,p_epa_attribute23                in  varchar2  default hr_api.g_varchar2
407   ,p_epa_attribute24                in  varchar2  default hr_api.g_varchar2
408   ,p_epa_attribute25                in  varchar2  default hr_api.g_varchar2
409   ,p_epa_attribute26                in  varchar2  default hr_api.g_varchar2
410   ,p_epa_attribute27                in  varchar2  default hr_api.g_varchar2
411   ,p_epa_attribute28                in  varchar2  default hr_api.g_varchar2
412   ,p_epa_attribute29                in  varchar2  default hr_api.g_varchar2
413   ,p_epa_attribute30                in  varchar2  default hr_api.g_varchar2
414   ,p_object_version_number          in out nocopy number
415   ,p_effective_date                 in  date
416   ,p_datetrack_mode                 in  varchar2) is
417   --
418   -- Declare cursors and local variables
419   --
420   l_proc varchar2(72) := g_package||'update_Participation_Elig';
421   l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422   l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423   l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424   --
425 begin
426   --
427   hr_utility.set_location('Entering:'|| l_proc, 10);
428   --
429   -- Issue a savepoint if operating in validation only mode
430   --
431   savepoint update_Participation_Elig;
432   --
433   hr_utility.set_location(l_proc, 20);
434   --
435   -- Process Logic
436   --
437   l_object_version_number := p_object_version_number;
438   --
439   begin
440     --
441     -- Start of API User Hook for the before hook of update_Participation_Elig
442     --
443     ben_Participation_Elig_bk2.update_Participation_Elig_b
444       (p_prtn_elig_id                   =>  p_prtn_elig_id
445       ,p_business_group_id              =>  p_business_group_id
446       ,p_pgm_id                         =>  p_pgm_id
447       ,p_pl_id                          =>  p_pl_id
448       ,p_oipl_id                        =>  p_oipl_id
449       ,p_ptip_id                        =>  p_ptip_id
450       ,p_plip_id                        =>  p_plip_id
451       ,p_trk_scr_for_inelg_flag         =>  p_trk_scr_for_inelg_flag
452       ,p_prtn_eff_strt_dt_cd            =>  p_prtn_eff_strt_dt_cd
453       ,p_prtn_eff_end_dt_cd             =>  p_prtn_eff_end_dt_cd
454       ,p_prtn_eff_strt_dt_rl            =>  p_prtn_eff_strt_dt_rl
455       ,p_prtn_eff_end_dt_rl             =>  p_prtn_eff_end_dt_rl
456       ,p_wait_perd_dt_to_use_cd         =>  p_wait_perd_dt_to_use_cd
457       ,p_wait_perd_dt_to_use_rl         =>  p_wait_perd_dt_to_use_rl
458       ,p_wait_perd_val                  =>  p_wait_perd_val
459       ,p_wait_perd_uom                  =>  p_wait_perd_uom
460       ,p_wait_perd_rl                   =>  p_wait_perd_rl
461       ,p_mx_poe_det_dt_cd               =>  p_mx_poe_det_dt_cd
462       ,p_mx_poe_det_dt_rl               =>  p_mx_poe_det_dt_rl
463       ,p_mx_poe_val                     =>  p_mx_poe_val
464       ,p_mx_poe_uom                     =>  p_mx_poe_uom
465       ,p_mx_poe_rl                      =>  p_mx_poe_rl
466       ,p_mx_poe_apls_cd                 =>  p_mx_poe_apls_cd
467       ,p_epa_attribute_category         =>  p_epa_attribute_category
468       ,p_epa_attribute1                 =>  p_epa_attribute1
469       ,p_epa_attribute2                 =>  p_epa_attribute2
470       ,p_epa_attribute3                 =>  p_epa_attribute3
471       ,p_epa_attribute4                 =>  p_epa_attribute4
472       ,p_epa_attribute5                 =>  p_epa_attribute5
473       ,p_epa_attribute6                 =>  p_epa_attribute6
474       ,p_epa_attribute7                 =>  p_epa_attribute7
475       ,p_epa_attribute8                 =>  p_epa_attribute8
476       ,p_epa_attribute9                 =>  p_epa_attribute9
477       ,p_epa_attribute10                =>  p_epa_attribute10
478       ,p_epa_attribute11                =>  p_epa_attribute11
479       ,p_epa_attribute12                =>  p_epa_attribute12
480       ,p_epa_attribute13                =>  p_epa_attribute13
481       ,p_epa_attribute14                =>  p_epa_attribute14
482       ,p_epa_attribute15                =>  p_epa_attribute15
483       ,p_epa_attribute16                =>  p_epa_attribute16
484       ,p_epa_attribute17                =>  p_epa_attribute17
485       ,p_epa_attribute18                =>  p_epa_attribute18
486       ,p_epa_attribute19                =>  p_epa_attribute19
487       ,p_epa_attribute20                =>  p_epa_attribute20
488       ,p_epa_attribute21                =>  p_epa_attribute21
489       ,p_epa_attribute22                =>  p_epa_attribute22
490       ,p_epa_attribute23                =>  p_epa_attribute23
491       ,p_epa_attribute24                =>  p_epa_attribute24
492       ,p_epa_attribute25                =>  p_epa_attribute25
493       ,p_epa_attribute26                =>  p_epa_attribute26
494       ,p_epa_attribute27                =>  p_epa_attribute27
495       ,p_epa_attribute28                =>  p_epa_attribute28
496       ,p_epa_attribute29                =>  p_epa_attribute29
497       ,p_epa_attribute30                =>  p_epa_attribute30
498       ,p_object_version_number          =>  p_object_version_number
499       ,p_effective_date                 =>  trunc(p_effective_date)
500       ,p_datetrack_mode                 =>  p_datetrack_mode);
501     --
502   exception
503     --
504     when hr_api.cannot_find_prog_unit then
505       --
506       hr_api.cannot_find_prog_unit_error
507         (p_module_name => 'UPDATE_Participation_Elig'
508         ,p_hook_type   => 'BP');
509     --
510     -- End of API User Hook for the before hook of update_Participation_Elig
511     --
512   end;
513   --
514   ben_epa_upd.upd
515     (p_prtn_elig_id                  => p_prtn_elig_id
516     ,p_effective_start_date          => l_effective_start_date
517     ,p_effective_end_date            => l_effective_end_date
518     ,p_business_group_id             => p_business_group_id
519     ,p_pgm_id                        => p_pgm_id
520     ,p_pl_id                         => p_pl_id
521     ,p_oipl_id                       => p_oipl_id
522     ,p_ptip_id                       => p_ptip_id
523     ,p_plip_id                       => p_plip_id
524     ,p_trk_scr_for_inelg_flag        => p_trk_scr_for_inelg_flag
525     ,p_prtn_eff_strt_dt_cd           => p_prtn_eff_strt_dt_cd
526     ,p_prtn_eff_end_dt_cd            => p_prtn_eff_end_dt_cd
527     ,p_prtn_eff_strt_dt_rl           => p_prtn_eff_strt_dt_rl
528     ,p_prtn_eff_end_dt_rl            => p_prtn_eff_end_dt_rl
529     ,p_wait_perd_dt_to_use_cd        => p_wait_perd_dt_to_use_cd
530     ,p_wait_perd_dt_to_use_rl        => p_wait_perd_dt_to_use_rl
531     ,p_wait_perd_val                 => p_wait_perd_val
532     ,p_wait_perd_uom                 => p_wait_perd_uom
533     ,p_wait_perd_rl                  => p_wait_perd_rl
534     ,p_mx_poe_det_dt_cd              => p_mx_poe_det_dt_cd
535     ,p_mx_poe_det_dt_rl              => p_mx_poe_det_dt_rl
536     ,p_mx_poe_val                    => p_mx_poe_val
537     ,p_mx_poe_uom                    => p_mx_poe_uom
538     ,p_mx_poe_rl                     => p_mx_poe_rl
539     ,p_mx_poe_apls_cd                => p_mx_poe_apls_cd
540     ,p_epa_attribute_category        => p_epa_attribute_category
541     ,p_epa_attribute1                => p_epa_attribute1
542     ,p_epa_attribute2                => p_epa_attribute2
543     ,p_epa_attribute3                => p_epa_attribute3
544     ,p_epa_attribute4                => p_epa_attribute4
545     ,p_epa_attribute5                => p_epa_attribute5
546     ,p_epa_attribute6                => p_epa_attribute6
547     ,p_epa_attribute7                => p_epa_attribute7
548     ,p_epa_attribute8                => p_epa_attribute8
549     ,p_epa_attribute9                => p_epa_attribute9
550     ,p_epa_attribute10               => p_epa_attribute10
551     ,p_epa_attribute11               => p_epa_attribute11
552     ,p_epa_attribute12               => p_epa_attribute12
553     ,p_epa_attribute13               => p_epa_attribute13
554     ,p_epa_attribute14               => p_epa_attribute14
555     ,p_epa_attribute15               => p_epa_attribute15
556     ,p_epa_attribute16               => p_epa_attribute16
557     ,p_epa_attribute17               => p_epa_attribute17
558     ,p_epa_attribute18               => p_epa_attribute18
559     ,p_epa_attribute19               => p_epa_attribute19
560     ,p_epa_attribute20               => p_epa_attribute20
561     ,p_epa_attribute21               => p_epa_attribute21
562     ,p_epa_attribute22               => p_epa_attribute22
563     ,p_epa_attribute23               => p_epa_attribute23
564     ,p_epa_attribute24               => p_epa_attribute24
565     ,p_epa_attribute25               => p_epa_attribute25
566     ,p_epa_attribute26               => p_epa_attribute26
567     ,p_epa_attribute27               => p_epa_attribute27
568     ,p_epa_attribute28               => p_epa_attribute28
569     ,p_epa_attribute29               => p_epa_attribute29
570     ,p_epa_attribute30               => p_epa_attribute30
571     ,p_object_version_number         => l_object_version_number
572     ,p_effective_date                => trunc(p_effective_date)
573     ,p_datetrack_mode                => p_datetrack_mode);
574   --
575   begin
576     --
577     -- Start of API User Hook for the after hook of update_Participation_Elig
578     --
579     ben_Participation_Elig_bk2.update_Participation_Elig_a
580       (p_prtn_elig_id                   =>  p_prtn_elig_id
581       ,p_effective_start_date           =>  l_effective_start_date
582       ,p_effective_end_date             =>  l_effective_end_date
583       ,p_business_group_id              =>  p_business_group_id
584       ,p_pgm_id                         =>  p_pgm_id
585       ,p_pl_id                          =>  p_pl_id
586       ,p_oipl_id                        =>  p_oipl_id
587       ,p_ptip_id                        =>  p_ptip_id
588       ,p_plip_id                        =>  p_plip_id
589       ,p_trk_scr_for_inelg_flag         =>  p_trk_scr_for_inelg_flag
590       ,p_prtn_eff_strt_dt_cd            =>  p_prtn_eff_strt_dt_cd
591       ,p_prtn_eff_end_dt_cd             =>  p_prtn_eff_end_dt_cd
592       ,p_prtn_eff_strt_dt_rl            =>  p_prtn_eff_strt_dt_rl
593       ,p_prtn_eff_end_dt_rl             =>  p_prtn_eff_end_dt_rl
594       ,p_wait_perd_dt_to_use_cd         =>  p_wait_perd_dt_to_use_cd
595       ,p_wait_perd_dt_to_use_rl         =>  p_wait_perd_dt_to_use_rl
596       ,p_wait_perd_val                  =>  p_wait_perd_val
597       ,p_wait_perd_uom                  =>  p_wait_perd_uom
598       ,p_wait_perd_rl                   =>  p_wait_perd_rl
599       ,p_mx_poe_det_dt_cd               =>  p_mx_poe_det_dt_cd
600       ,p_mx_poe_det_dt_rl               =>  p_mx_poe_det_dt_rl
601       ,p_mx_poe_val                     =>  p_mx_poe_val
602       ,p_mx_poe_uom                     =>  p_mx_poe_uom
603       ,p_mx_poe_rl                      =>  p_mx_poe_rl
604       ,p_mx_poe_apls_cd                 =>  p_mx_poe_apls_cd
605       ,p_epa_attribute_category         =>  p_epa_attribute_category
606       ,p_epa_attribute1                 =>  p_epa_attribute1
607       ,p_epa_attribute2                 =>  p_epa_attribute2
608       ,p_epa_attribute3                 =>  p_epa_attribute3
609       ,p_epa_attribute4                 =>  p_epa_attribute4
610       ,p_epa_attribute5                 =>  p_epa_attribute5
611       ,p_epa_attribute6                 =>  p_epa_attribute6
612       ,p_epa_attribute7                 =>  p_epa_attribute7
613       ,p_epa_attribute8                 =>  p_epa_attribute8
614       ,p_epa_attribute9                 =>  p_epa_attribute9
615       ,p_epa_attribute10                =>  p_epa_attribute10
616       ,p_epa_attribute11                =>  p_epa_attribute11
617       ,p_epa_attribute12                =>  p_epa_attribute12
618       ,p_epa_attribute13                =>  p_epa_attribute13
619       ,p_epa_attribute14                =>  p_epa_attribute14
620       ,p_epa_attribute15                =>  p_epa_attribute15
621       ,p_epa_attribute16                =>  p_epa_attribute16
622       ,p_epa_attribute17                =>  p_epa_attribute17
623       ,p_epa_attribute18                =>  p_epa_attribute18
624       ,p_epa_attribute19                =>  p_epa_attribute19
625       ,p_epa_attribute20                =>  p_epa_attribute20
626       ,p_epa_attribute21                =>  p_epa_attribute21
627       ,p_epa_attribute22                =>  p_epa_attribute22
628       ,p_epa_attribute23                =>  p_epa_attribute23
629       ,p_epa_attribute24                =>  p_epa_attribute24
630       ,p_epa_attribute25                =>  p_epa_attribute25
631       ,p_epa_attribute26                =>  p_epa_attribute26
632       ,p_epa_attribute27                =>  p_epa_attribute27
633       ,p_epa_attribute28                =>  p_epa_attribute28
634       ,p_epa_attribute29                =>  p_epa_attribute29
635       ,p_epa_attribute30                =>  p_epa_attribute30
636       ,p_object_version_number          =>  l_object_version_number
637       ,p_effective_date                 =>  trunc(p_effective_date)
638       ,p_datetrack_mode                 =>  p_datetrack_mode);
639     --
640   exception
641     --
642     when hr_api.cannot_find_prog_unit then
643       --
644       hr_api.cannot_find_prog_unit_error
645         (p_module_name => 'UPDATE_Participation_Elig'
646         ,p_hook_type   => 'AP');
647     --
648     -- End of API User Hook for the after hook of update_Participation_Elig
649     --
650   end;
651   --
652   hr_utility.set_location(l_proc, 60);
653   --
654   -- When in validation only mode raise the Validate_Enabled exception
655   --
656   if p_validate then
657     raise hr_api.validate_enabled;
658   end if;
659   --
660   -- Set all output arguments
661   --
662   p_object_version_number := l_object_version_number;
663   p_effective_start_date := l_effective_start_date;
664   p_effective_end_date := l_effective_end_date;
665   --
666   hr_utility.set_location(' Leaving:'||l_proc, 70);
667   --
668 exception
669   --
670   when hr_api.validate_enabled then
671     --
672     -- As the Validate_Enabled exception has been raised
673     -- we must rollback to the savepoint
674     --
675     ROLLBACK TO update_Participation_Elig;
676     --
677     -- Only set output warning arguments
678     -- (Any key or derived arguments must be set to null
679     -- when validation only mode is being used.)
680     --
681     hr_utility.set_location(' Leaving:'||l_proc, 80);
682     --
683   when others then
684     --
685     -- A validation or unexpected error has occured
686     --
687     p_effective_start_date := null;
688     p_effective_end_date := null;
689     p_object_version_number  := l_object_version_number;
690     hr_utility.set_location(' Leaving:'||l_proc, 80);
691     --
692     ROLLBACK TO update_Participation_Elig;
693     raise;
694     --
695 end update_Participation_Elig;
696 --
697 -- ----------------------------------------------------------------------------
698 -- |-----------------------< delete_Participation_Elig >----------------------|
699 -- ----------------------------------------------------------------------------
700 --
701 procedure delete_Participation_Elig
702   (p_validate                       in  boolean  default false
703   ,p_prtn_elig_id                   in  number
704   ,p_effective_start_date           out nocopy date
705   ,p_effective_end_date             out nocopy date
706   ,p_object_version_number          in out nocopy number
707   ,p_effective_date                 in  date
708   ,p_datetrack_mode                 in  varchar2) is
709   --
710   -- Declare cursors and local variables
711   --
712   l_proc varchar2(72) := g_package||'update_Participation_Elig';
713   l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714   l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715   l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716   --
717 begin
718   --
719   hr_utility.set_location('Entering:'|| l_proc, 10);
720   --
721   -- Issue a savepoint if operating in validation only mode
722   --
723   savepoint delete_Participation_Elig;
724   --
725   hr_utility.set_location(l_proc, 20);
726   --
727   -- Process Logic
728   --
729   l_object_version_number := p_object_version_number;
730   --
731   --
732   begin
733     --
734     -- Start of API User Hook for the before hook of delete_Participation_Elig
735     --
736     ben_Participation_Elig_bk3.delete_Participation_Elig_b
737       (p_prtn_elig_id                   =>  p_prtn_elig_id
738       ,p_object_version_number          =>  p_object_version_number
739       ,p_effective_date                 =>  trunc(p_effective_date)
740       ,p_datetrack_mode                 =>  p_datetrack_mode);
741     --
742   exception
743     --
744     when hr_api.cannot_find_prog_unit then
745       --
746       hr_api.cannot_find_prog_unit_error
747         (p_module_name => 'DELETE_Participation_Elig'
748         ,p_hook_type   => 'BP');
749     --
750     -- End of API User Hook for the before hook of delete_Participation_Elig
751     --
752   end;
753   --
754   ben_epa_del.del
755     (p_prtn_elig_id                  => p_prtn_elig_id
756     ,p_effective_start_date          => l_effective_start_date
757     ,p_effective_end_date            => l_effective_end_date
758     ,p_object_version_number         => l_object_version_number
759     ,p_effective_date                => p_effective_date
760     ,p_datetrack_mode                => p_datetrack_mode);
761   --
762   begin
763     --
764     -- Start of API User Hook for the after hook of delete_Participation_Elig
765     --
766     ben_Participation_Elig_bk3.delete_Participation_Elig_a
767       (p_prtn_elig_id                   =>  p_prtn_elig_id
768       ,p_effective_start_date           =>  l_effective_start_date
769       ,p_effective_end_date             =>  l_effective_end_date
770       ,p_object_version_number          =>  l_object_version_number
771       ,p_effective_date                 =>  trunc(p_effective_date)
772       ,p_datetrack_mode                 =>  p_datetrack_mode);
773     --
774   exception
775     --
776     when hr_api.cannot_find_prog_unit then
777       --
778       hr_api.cannot_find_prog_unit_error
779         (p_module_name => 'DELETE_Participation_Elig'
780         ,p_hook_type   => 'AP');
781     --
782     -- End of API User Hook for the after hook of delete_Participation_Elig
783     --
784   end;
785   --
786   hr_utility.set_location(l_proc, 60);
787   --
788   -- When in validation only mode raise the Validate_Enabled exception
789   --
790   if p_validate then
791     raise hr_api.validate_enabled;
792   end if;
793   --
794   hr_utility.set_location(' Leaving:'||l_proc, 70);
795   --
796 exception
797   --
798   when hr_api.validate_enabled then
799     --
800     -- As the Validate_Enabled exception has been raised
801     -- we must rollback to the savepoint
802     --
803     ROLLBACK TO delete_Participation_Elig;
804     --
805     -- Only set output warning arguments
806     -- (Any key or derived arguments must be set to null
807     -- when validation only mode is being used.)
808     --
809     p_effective_start_date := null;
810     p_effective_end_date := null;
811     --
812   when others then
813     --
814     -- A validation or unexpected error has occured
815     --
816     p_effective_start_date := null;
817     p_effective_end_date := null;
818     p_object_version_number  := l_object_version_number;
819     hr_utility.set_location(' Leaving:'||l_proc, 80);
820     --
821     ROLLBACK TO delete_Participation_Elig;
822     raise;
823     --
824 end delete_Participation_Elig;
825 --
826 -- ----------------------------------------------------------------------------
827 -- |-------------------------------< lck >------------------------------------|
828 -- ----------------------------------------------------------------------------
829 --
830 procedure lck
831   (p_prtn_elig_id                   in     number
832   ,p_object_version_number          in     number
833   ,p_effective_date                 in     date
834   ,p_datetrack_mode                 in     varchar2
835   ,p_validation_start_date          out nocopy    date
836   ,p_validation_end_date            out nocopy    date) is
837   --
838   --
839   -- Declare cursors and local variables
840   --
841   l_proc varchar2(72) := g_package||'lck';
842   l_validation_start_date date;
843   l_validation_end_date date;
844   --
845 begin
846   --
847   hr_utility.set_location('Entering:'|| l_proc, 10);
848   --
849   ben_epa_shd.lck
850     (p_prtn_elig_id               => p_prtn_elig_id
851     ,p_validation_start_date      => l_validation_start_date
852     ,p_validation_end_date        => l_validation_end_date
853     ,p_object_version_number      => p_object_version_number
854     ,p_effective_date             => p_effective_date
855     ,p_datetrack_mode             => p_datetrack_mode);
856   --
857   hr_utility.set_location(' Leaving:'||l_proc, 70);
858   --
859 end lck;
860 --
861 end ben_Participation_Elig_api;