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