[Home] [Help]
PACKAGE BODY: APPS.BEN_PIL_ELCTBL_CHC_POPL_API
Source
1 Package Body ben_Pil_Elctbl_chc_Popl_api as
2 /* $Header: bepelapi.pkb 120.0.12000000.2 2007/05/13 23:07:23 rtagarra noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_Pil_Elctbl_chc_Popl_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_Pil_Elctbl_chc_Popl >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Pil_Elctbl_chc_Popl
13 (p_validate in boolean default false
14 ,p_pil_elctbl_chc_popl_id out nocopy number
15 ,p_dflt_enrt_dt in date default null
16 ,p_dflt_asnd_dt in date default null
17 ,p_elcns_made_dt in date default null
18 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
19 ,p_enrt_typ_cycl_cd in varchar2 default null
20 ,p_enrt_perd_end_dt in date default null
21 ,p_enrt_perd_strt_dt in date default null
22 ,p_procg_end_dt in date default null
23 ,p_pil_elctbl_popl_stat_cd in varchar2 default null
24 ,p_acty_ref_perd_cd in varchar2 default null
25 ,p_uom in varchar2 default null
26 ,p_comments in varchar2 default null
27 ,p_mgr_ovrid_dt in date default null
28 ,p_ws_mgr_id in number default null
29 ,p_mgr_ovrid_person_id in number default null
30 ,p_assignment_id in number default null
31 --cwb
32 ,p_bdgt_acc_cd in varchar2 default null
33 ,p_pop_cd in varchar2 default null
34 ,p_bdgt_due_dt in date default null
35 ,p_bdgt_export_flag in varchar2 default 'N'
36 ,p_bdgt_iss_dt in date default null
37 ,p_bdgt_stat_cd in varchar2 default null
38 ,p_ws_acc_cd in varchar2 default null
39 ,p_ws_due_dt in date default null
40 ,p_ws_export_flag in varchar2 default 'N'
41 ,p_ws_iss_dt in date default null
42 ,p_ws_stat_cd in varchar2 default null
43 --cwb
44 ,p_reinstate_cd in varchar2 default null
45 ,p_reinstate_ovrdn_cd in varchar2 default null
46 ,p_auto_asnd_dt in date default null
47 ,p_cbr_elig_perd_strt_dt in date default null
48 ,p_cbr_elig_perd_end_dt in date default null
49 ,p_lee_rsn_id in number default null
50 ,p_enrt_perd_id in number default null
51 ,p_per_in_ler_id in number default null
52 ,p_pgm_id in number default null
53 ,p_pl_id in number default null
54 ,p_business_group_id in number default null
55 ,p_pel_attribute_category in varchar2 default null
56 ,p_pel_attribute1 in varchar2 default null
57 ,p_pel_attribute2 in varchar2 default null
58 ,p_pel_attribute3 in varchar2 default null
59 ,p_pel_attribute4 in varchar2 default null
60 ,p_pel_attribute5 in varchar2 default null
61 ,p_pel_attribute6 in varchar2 default null
62 ,p_pel_attribute7 in varchar2 default null
63 ,p_pel_attribute8 in varchar2 default null
64 ,p_pel_attribute9 in varchar2 default null
65 ,p_pel_attribute10 in varchar2 default null
66 ,p_pel_attribute11 in varchar2 default null
67 ,p_pel_attribute12 in varchar2 default null
68 ,p_pel_attribute13 in varchar2 default null
69 ,p_pel_attribute14 in varchar2 default null
70 ,p_pel_attribute15 in varchar2 default null
71 ,p_pel_attribute16 in varchar2 default null
72 ,p_pel_attribute17 in varchar2 default null
73 ,p_pel_attribute18 in varchar2 default null
74 ,p_pel_attribute19 in varchar2 default null
75 ,p_pel_attribute20 in varchar2 default null
76 ,p_pel_attribute21 in varchar2 default null
77 ,p_pel_attribute22 in varchar2 default null
78 ,p_pel_attribute23 in varchar2 default null
79 ,p_pel_attribute24 in varchar2 default null
80 ,p_pel_attribute25 in varchar2 default null
81 ,p_pel_attribute26 in varchar2 default null
82 ,p_pel_attribute27 in varchar2 default null
83 ,p_pel_attribute28 in varchar2 default null
84 ,p_pel_attribute29 in varchar2 default null
85 ,p_pel_attribute30 in varchar2 default null
86 ,p_request_id in number default null
87 ,p_program_application_id in number default null
88 ,p_program_id in number default null
89 ,p_program_update_date in date default null
90 ,p_object_version_number out nocopy number
91 ,p_effective_date in date
92 ,p_defer_deenrol_flag in varchar2 default 'N'
93 ,p_deenrol_made_dt in date default null
94 ) is
95 --
96 -- Declare cursors and local variables
97 --
98 l_pil_elctbl_chc_popl_id ben_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id%TYPE;
99 l_proc varchar2(72) := g_package||'create_Pil_Elctbl_chc_Popl';
100 l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;
101 --
102 begin
103 --
104 hr_utility.set_location('Entering:'|| l_proc, 10);
105 --
106 -- Issue a savepoint if operating in validation only mode
107 --
108 savepoint create_Pil_Elctbl_chc_Popl;
109 --
110 hr_utility.set_location(l_proc, 20);
111 --
112 -- Process Logic
113 --
114 begin
115 --
116 -- Start of API User Hook for the before hook of create_Pil_Elctbl_chc_Popl
117 --
118 ben_Pil_Elctbl_chc_Popl_bk1.create_Pil_Elctbl_chc_Popl_b
119 (
120 p_dflt_enrt_dt => p_dflt_enrt_dt
121 ,p_dflt_asnd_dt => p_dflt_asnd_dt
122 ,p_elcns_made_dt => p_elcns_made_dt
123 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
124 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
125 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
126 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
127 ,p_procg_end_dt => p_procg_end_dt
128 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
129 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
130 ,p_uom => p_uom
131 ,p_comments => p_comments
132 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
133 ,p_ws_mgr_id => p_ws_mgr_id
134 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
135 ,p_assignment_id => p_assignment_id
136 --cwb
137 ,p_bdgt_acc_cd => p_bdgt_acc_cd
138 ,p_pop_cd => p_pop_cd
139 ,p_bdgt_due_dt => p_bdgt_due_dt
140 ,p_bdgt_export_flag => p_bdgt_export_flag
141 ,p_bdgt_iss_dt => p_bdgt_iss_dt
142 ,p_bdgt_stat_cd => p_bdgt_stat_cd
143 ,p_ws_acc_cd => p_ws_acc_cd
144 ,p_ws_due_dt => p_ws_due_dt
145 ,p_ws_export_flag => p_ws_export_flag
146 ,p_ws_iss_dt => p_ws_iss_dt
147 ,p_ws_stat_cd => p_ws_stat_cd
148 --cwb
149 ,p_reinstate_cd => p_reinstate_cd
150 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
151 ,p_auto_asnd_dt => p_auto_asnd_dt
152 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
153 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
154 ,p_lee_rsn_id => p_lee_rsn_id
155 ,p_enrt_perd_id => p_enrt_perd_id
156 ,p_per_in_ler_id => p_per_in_ler_id
157 ,p_pgm_id => p_pgm_id
158 ,p_pl_id => p_pl_id
159 ,p_business_group_id => p_business_group_id
160 ,p_pel_attribute_category => p_pel_attribute_category
161 ,p_pel_attribute1 => p_pel_attribute1
162 ,p_pel_attribute2 => p_pel_attribute2
163 ,p_pel_attribute3 => p_pel_attribute3
164 ,p_pel_attribute4 => p_pel_attribute4
165 ,p_pel_attribute5 => p_pel_attribute5
166 ,p_pel_attribute6 => p_pel_attribute6
167 ,p_pel_attribute7 => p_pel_attribute7
168 ,p_pel_attribute8 => p_pel_attribute8
169 ,p_pel_attribute9 => p_pel_attribute9
170 ,p_pel_attribute10 => p_pel_attribute10
171 ,p_pel_attribute11 => p_pel_attribute11
172 ,p_pel_attribute12 => p_pel_attribute12
173 ,p_pel_attribute13 => p_pel_attribute13
174 ,p_pel_attribute14 => p_pel_attribute14
175 ,p_pel_attribute15 => p_pel_attribute15
176 ,p_pel_attribute16 => p_pel_attribute16
177 ,p_pel_attribute17 => p_pel_attribute17
178 ,p_pel_attribute18 => p_pel_attribute18
179 ,p_pel_attribute19 => p_pel_attribute19
180 ,p_pel_attribute20 => p_pel_attribute20
181 ,p_pel_attribute21 => p_pel_attribute21
182 ,p_pel_attribute22 => p_pel_attribute22
183 ,p_pel_attribute23 => p_pel_attribute23
184 ,p_pel_attribute24 => p_pel_attribute24
185 ,p_pel_attribute25 => p_pel_attribute25
186 ,p_pel_attribute26 => p_pel_attribute26
187 ,p_pel_attribute27 => p_pel_attribute27
188 ,p_pel_attribute28 => p_pel_attribute28
189 ,p_pel_attribute29 => p_pel_attribute29
190 ,p_pel_attribute30 => p_pel_attribute30
191 ,p_request_id => p_request_id
192 ,p_program_application_id => p_program_application_id
193 ,p_program_id => p_program_id
194 ,p_program_update_date => p_program_update_date
195 ,p_effective_date => trunc(p_effective_date)
196 ,p_defer_deenrol_flag => p_defer_deenrol_flag
197 ,p_deenrol_made_dt => p_deenrol_made_dt
198 );
199 exception
200 when hr_api.cannot_find_prog_unit then
201 hr_api.cannot_find_prog_unit_error
202 (
203 p_module_name => 'CREATE_Pil_Elctbl_chc_Popl'
204 ,p_hook_type => 'BP'
205 );
206 --
207 -- End of API User Hook for the before hook of create_Pil_Elctbl_chc_Popl
208 --
209 end;
210 --
211 ben_pel_ins.ins
212 (
213 p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
214 ,p_dflt_enrt_dt => p_dflt_enrt_dt
215 ,p_dflt_asnd_dt => p_dflt_asnd_dt
216 ,p_elcns_made_dt => p_elcns_made_dt
217 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
218 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
219 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
220 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
221 ,p_procg_end_dt => p_procg_end_dt
222 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
223 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
224 ,p_uom => p_uom
225 ,p_comments => p_comments
226 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
227 ,p_ws_mgr_id => p_ws_mgr_id
228 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
229 ,p_assignment_id => p_assignment_id
230 --cwb
231 ,p_bdgt_acc_cd => p_bdgt_acc_cd
232 ,p_pop_cd => p_pop_cd
233 ,p_bdgt_due_dt => p_bdgt_due_dt
234 ,p_bdgt_export_flag => p_bdgt_export_flag
235 ,p_bdgt_iss_dt => p_bdgt_iss_dt
236 ,p_bdgt_stat_cd => p_bdgt_stat_cd
237 ,p_ws_acc_cd => p_ws_acc_cd
238 ,p_ws_due_dt => p_ws_due_dt
239 ,p_ws_export_flag => p_ws_export_flag
240 ,p_ws_iss_dt => p_ws_iss_dt
241 ,p_ws_stat_cd => p_ws_stat_cd
242 --cwb
243 ,p_reinstate_cd => p_reinstate_cd
244 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
245 ,p_auto_asnd_dt => p_auto_asnd_dt
246 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
247 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
248 ,p_lee_rsn_id => p_lee_rsn_id
249 ,p_enrt_perd_id => p_enrt_perd_id
250 ,p_per_in_ler_id => p_per_in_ler_id
251 ,p_pgm_id => p_pgm_id
252 ,p_pl_id => p_pl_id
253 ,p_business_group_id => p_business_group_id
254 ,p_pel_attribute_category => p_pel_attribute_category
255 ,p_pel_attribute1 => p_pel_attribute1
256 ,p_pel_attribute2 => p_pel_attribute2
257 ,p_pel_attribute3 => p_pel_attribute3
258 ,p_pel_attribute4 => p_pel_attribute4
259 ,p_pel_attribute5 => p_pel_attribute5
260 ,p_pel_attribute6 => p_pel_attribute6
261 ,p_pel_attribute7 => p_pel_attribute7
262 ,p_pel_attribute8 => p_pel_attribute8
263 ,p_pel_attribute9 => p_pel_attribute9
264 ,p_pel_attribute10 => p_pel_attribute10
265 ,p_pel_attribute11 => p_pel_attribute11
266 ,p_pel_attribute12 => p_pel_attribute12
267 ,p_pel_attribute13 => p_pel_attribute13
268 ,p_pel_attribute14 => p_pel_attribute14
269 ,p_pel_attribute15 => p_pel_attribute15
270 ,p_pel_attribute16 => p_pel_attribute16
271 ,p_pel_attribute17 => p_pel_attribute17
272 ,p_pel_attribute18 => p_pel_attribute18
273 ,p_pel_attribute19 => p_pel_attribute19
274 ,p_pel_attribute20 => p_pel_attribute20
275 ,p_pel_attribute21 => p_pel_attribute21
276 ,p_pel_attribute22 => p_pel_attribute22
277 ,p_pel_attribute23 => p_pel_attribute23
278 ,p_pel_attribute24 => p_pel_attribute24
279 ,p_pel_attribute25 => p_pel_attribute25
280 ,p_pel_attribute26 => p_pel_attribute26
281 ,p_pel_attribute27 => p_pel_attribute27
282 ,p_pel_attribute28 => p_pel_attribute28
283 ,p_pel_attribute29 => p_pel_attribute29
284 ,p_pel_attribute30 => p_pel_attribute30
285 ,p_request_id => p_request_id
286 ,p_program_application_id => p_program_application_id
287 ,p_program_id => p_program_id
288 ,p_program_update_date => p_program_update_date
289 ,p_object_version_number => l_object_version_number
290 ,p_effective_date => trunc(p_effective_date)
291 ,p_defer_deenrol_flag => p_defer_deenrol_flag
292 ,p_deenrol_made_dt => p_deenrol_made_dt
293 );
294 --
295 begin
296 --
297 -- Start of API User Hook for the after hook of create_Pil_Elctbl_chc_Popl
298 --
299 ben_Pil_Elctbl_chc_Popl_bk1.create_Pil_Elctbl_chc_Popl_a
300 (
301 p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id
302 ,p_dflt_enrt_dt => p_dflt_enrt_dt
303 ,p_dflt_asnd_dt => p_dflt_asnd_dt
304 ,p_elcns_made_dt => p_elcns_made_dt
305 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
306 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
307 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
308 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
309 ,p_procg_end_dt => p_procg_end_dt
310 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
311 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
312 ,p_uom => p_uom
313 ,p_comments => p_comments
314 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
315 ,p_ws_mgr_id => p_ws_mgr_id
316 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
317 ,p_assignment_id => p_assignment_id
318 --cwb
319 ,p_bdgt_acc_cd => p_bdgt_acc_cd
320 ,p_pop_cd => p_pop_cd
321 ,p_bdgt_due_dt => p_bdgt_due_dt
322 ,p_bdgt_export_flag => p_bdgt_export_flag
323 ,p_bdgt_iss_dt => p_bdgt_iss_dt
324 ,p_bdgt_stat_cd => p_bdgt_stat_cd
325 ,p_ws_acc_cd => p_ws_acc_cd
326 ,p_ws_due_dt => p_ws_due_dt
327 ,p_ws_export_flag => p_ws_export_flag
328 ,p_ws_iss_dt => p_ws_iss_dt
329 ,p_ws_stat_cd => p_ws_stat_cd
330 --cwb
331 ,p_reinstate_cd => p_reinstate_cd
332 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
333 ,p_auto_asnd_dt => p_auto_asnd_dt
334 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
335 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
336 ,p_lee_rsn_id => p_lee_rsn_id
337 ,p_enrt_perd_id => p_enrt_perd_id
338 ,p_per_in_ler_id => p_per_in_ler_id
339 ,p_pgm_id => p_pgm_id
340 ,p_pl_id => p_pl_id
341 ,p_business_group_id => p_business_group_id
342 ,p_pel_attribute_category => p_pel_attribute_category
343 ,p_pel_attribute1 => p_pel_attribute1
344 ,p_pel_attribute2 => p_pel_attribute2
345 ,p_pel_attribute3 => p_pel_attribute3
346 ,p_pel_attribute4 => p_pel_attribute4
347 ,p_pel_attribute5 => p_pel_attribute5
348 ,p_pel_attribute6 => p_pel_attribute6
349 ,p_pel_attribute7 => p_pel_attribute7
350 ,p_pel_attribute8 => p_pel_attribute8
351 ,p_pel_attribute9 => p_pel_attribute9
352 ,p_pel_attribute10 => p_pel_attribute10
353 ,p_pel_attribute11 => p_pel_attribute11
354 ,p_pel_attribute12 => p_pel_attribute12
355 ,p_pel_attribute13 => p_pel_attribute13
356 ,p_pel_attribute14 => p_pel_attribute14
357 ,p_pel_attribute15 => p_pel_attribute15
358 ,p_pel_attribute16 => p_pel_attribute16
359 ,p_pel_attribute17 => p_pel_attribute17
360 ,p_pel_attribute18 => p_pel_attribute18
361 ,p_pel_attribute19 => p_pel_attribute19
362 ,p_pel_attribute20 => p_pel_attribute20
363 ,p_pel_attribute21 => p_pel_attribute21
364 ,p_pel_attribute22 => p_pel_attribute22
365 ,p_pel_attribute23 => p_pel_attribute23
366 ,p_pel_attribute24 => p_pel_attribute24
367 ,p_pel_attribute25 => p_pel_attribute25
368 ,p_pel_attribute26 => p_pel_attribute26
369 ,p_pel_attribute27 => p_pel_attribute27
370 ,p_pel_attribute28 => p_pel_attribute28
371 ,p_pel_attribute29 => p_pel_attribute29
372 ,p_pel_attribute30 => p_pel_attribute30
373 ,p_request_id => p_request_id
374 ,p_program_application_id => p_program_application_id
375 ,p_program_id => p_program_id
376 ,p_program_update_date => p_program_update_date
377 ,p_object_version_number => l_object_version_number
378 ,p_effective_date => trunc(p_effective_date)
379 ,p_defer_deenrol_flag => p_defer_deenrol_flag
380 ,p_deenrol_made_dt => p_deenrol_made_dt
381 );
382 exception
383 when hr_api.cannot_find_prog_unit then
384 hr_api.cannot_find_prog_unit_error
385 (p_module_name => 'CREATE_Pil_Elctbl_chc_Popl'
386 ,p_hook_type => 'AP'
387 );
388 --
389 -- End of API User Hook for the after hook of create_Pil_Elctbl_chc_Popl
390 --
391 end;
392 --
393 hr_utility.set_location(l_proc, 60);
394 --
395 -- When in validation only mode raise the Validate_Enabled exception
396 --
397 if p_validate then
398 raise hr_api.validate_enabled;
399 end if;
400 --
401 -- Set all output arguments
402 --
403 p_pil_elctbl_chc_popl_id := l_pil_elctbl_chc_popl_id;
404 p_object_version_number := l_object_version_number;
405 --
406 hr_utility.set_location(' Leaving:'||l_proc, 70);
407 --
408 exception
409 --
410 when hr_api.validate_enabled then
411 --
412 -- As the Validate_Enabled exception has been raised
413 -- we must rollback to the savepoint
414 --
415 ROLLBACK TO create_Pil_Elctbl_chc_Popl;
416 --
417 -- Only set output warning arguments
418 -- (Any key or derived arguments must be set to null
419 -- when validation only mode is being used.)
420 --
421 p_pil_elctbl_chc_popl_id := null;
422 p_object_version_number := null;
423 hr_utility.set_location(' Leaving:'||l_proc, 80);
424 --
425 when others then
426 --
427 -- A validation or unexpected error has occured
428 -- nocopy changes
429 ROLLBACK TO create_Pil_Elctbl_chc_Popl;
430 p_pil_elctbl_chc_popl_id := null;
431 p_object_version_number := null;
432
433 raise;
434 --
435 end create_Pil_Elctbl_chc_Popl;
436 -- ----------------------------------------------------------------------------
437 -- |------------------------< update_Pil_Elctbl_chc_Popl >--- ------------------|
438 -- ----------------------------------------------------------------------------
439 --
440 procedure update_Pil_Elctbl_chc_Popl
441 (p_validate in boolean default false
442 ,p_pil_elctbl_chc_popl_id in number
443 ,p_dflt_enrt_dt in date default hr_api.g_date
444 ,p_dflt_asnd_dt in date default hr_api.g_date
445 ,p_elcns_made_dt in date default hr_api.g_date
446 ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
447 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
448 ,p_enrt_perd_end_dt in date default hr_api.g_date
449 ,p_enrt_perd_strt_dt in date default hr_api.g_date
450 ,p_procg_end_dt in date default hr_api.g_date
451 ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
452 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
453 ,p_uom in varchar2 default hr_api.g_varchar2
454 ,p_comments in varchar2 default hr_api.g_varchar2
455 ,p_mgr_ovrid_dt in date default hr_api.g_date
456 ,p_ws_mgr_id in number default hr_api.g_number
457 ,p_mgr_ovrid_person_id in number default hr_api.g_number
458 ,p_assignment_id in number default hr_api.g_number
459 --cwb
460 ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461 ,p_pop_cd in varchar2 default hr_api.g_varchar2
462 ,p_bdgt_due_dt in date default hr_api.g_date
463 ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464 ,p_bdgt_iss_dt in date default hr_api.g_date
465 ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466 ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467 ,p_ws_due_dt in date default hr_api.g_date
468 ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469 ,p_ws_iss_dt in date default hr_api.g_date
470 ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471 --cwb
472 ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
473 ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
474 ,p_auto_asnd_dt in date default hr_api.g_date
475 ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
476 ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
477 ,p_lee_rsn_id in number default hr_api.g_number
478 ,p_enrt_perd_id in number default hr_api.g_number
479 ,p_per_in_ler_id in number default hr_api.g_number
480 ,p_pgm_id in number default hr_api.g_number
481 ,p_pl_id in number default hr_api.g_number
482 ,p_business_group_id in number default hr_api.g_number
483 ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
484 ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
485 ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
486 ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
487 ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
488 ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
489 ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
490 ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
491 ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
492 ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
493 ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
494 ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
495 ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
496 ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
497 ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
498 ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
499 ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
500 ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
501 ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
502 ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
503 ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
504 ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
505 ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
506 ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
507 ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
508 ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
509 ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
510 ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
511 ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
512 ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
513 ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
514 ,p_request_id in number default hr_api.g_number
515 ,p_program_application_id in number default hr_api.g_number
516 ,p_program_id in number default hr_api.g_number
517 ,p_program_update_date in date default hr_api.g_date
518 ,p_object_version_number in out nocopy number
519 ,p_effective_date in date
520 ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
521 ,p_deenrol_made_dt in date default hr_api.g_date
522 ) is
523 --
524 -- Declare cursors and local variables
525 --
526 l_proc varchar2(72) := g_package||'update_Pil_Elctbl_chc_Popl';
527 l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;
528 --
529 begin
530 --
531 hr_utility.set_location('Entering:'|| l_proc, 10);
532 --
533 -- Issue a savepoint if operating in validation only mode
534 --
535 savepoint update_Pil_Elctbl_chc_Popl;
536 --
537 hr_utility.set_location(l_proc, 20);
538 --
539 -- Process Logic
540 --
541 l_object_version_number := p_object_version_number;
542 --
543 begin
544 --
545 -- Start of API User Hook for the before hook of update_Pil_Elctbl_chc_Popl
546 --
547 ben_Pil_Elctbl_chc_Popl_bk2.update_Pil_Elctbl_chc_Popl_b
548 (
549 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
550 ,p_dflt_enrt_dt => p_dflt_enrt_dt
551 ,p_dflt_asnd_dt => p_dflt_asnd_dt
552 ,p_elcns_made_dt => p_elcns_made_dt
553 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
554 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
555 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
556 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
557 ,p_procg_end_dt => p_procg_end_dt
558 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
559 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
560 ,p_uom => p_uom
561 ,p_comments => p_comments
562 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
563 ,p_ws_mgr_id => p_ws_mgr_id
564 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
565 ,p_assignment_id => p_assignment_id
566 --cwb
567 ,p_bdgt_acc_cd => p_bdgt_acc_cd
568 ,p_pop_cd => p_pop_cd
569 ,p_bdgt_due_dt => p_bdgt_due_dt
570 ,p_bdgt_export_flag => p_bdgt_export_flag
571 ,p_bdgt_iss_dt => p_bdgt_iss_dt
572 ,p_bdgt_stat_cd => p_bdgt_stat_cd
573 ,p_ws_acc_cd => p_ws_acc_cd
574 ,p_ws_due_dt => p_ws_due_dt
575 ,p_ws_export_flag => p_ws_export_flag
576 ,p_ws_iss_dt => p_ws_iss_dt
577 ,p_ws_stat_cd => p_ws_stat_cd
578 --cwb
579 ,p_reinstate_cd => p_reinstate_cd
580 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
581 ,p_auto_asnd_dt => p_auto_asnd_dt
582 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
583 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
584 ,p_lee_rsn_id => p_lee_rsn_id
585 ,p_enrt_perd_id => p_enrt_perd_id
586 ,p_per_in_ler_id => p_per_in_ler_id
587 ,p_pgm_id => p_pgm_id
588 ,p_pl_id => p_pl_id
589 ,p_business_group_id => p_business_group_id
590 ,p_pel_attribute_category => p_pel_attribute_category
591 ,p_pel_attribute1 => p_pel_attribute1
592 ,p_pel_attribute2 => p_pel_attribute2
593 ,p_pel_attribute3 => p_pel_attribute3
594 ,p_pel_attribute4 => p_pel_attribute4
595 ,p_pel_attribute5 => p_pel_attribute5
596 ,p_pel_attribute6 => p_pel_attribute6
597 ,p_pel_attribute7 => p_pel_attribute7
598 ,p_pel_attribute8 => p_pel_attribute8
599 ,p_pel_attribute9 => p_pel_attribute9
600 ,p_pel_attribute10 => p_pel_attribute10
601 ,p_pel_attribute11 => p_pel_attribute11
602 ,p_pel_attribute12 => p_pel_attribute12
603 ,p_pel_attribute13 => p_pel_attribute13
604 ,p_pel_attribute14 => p_pel_attribute14
605 ,p_pel_attribute15 => p_pel_attribute15
606 ,p_pel_attribute16 => p_pel_attribute16
607 ,p_pel_attribute17 => p_pel_attribute17
608 ,p_pel_attribute18 => p_pel_attribute18
609 ,p_pel_attribute19 => p_pel_attribute19
610 ,p_pel_attribute20 => p_pel_attribute20
611 ,p_pel_attribute21 => p_pel_attribute21
612 ,p_pel_attribute22 => p_pel_attribute22
613 ,p_pel_attribute23 => p_pel_attribute23
614 ,p_pel_attribute24 => p_pel_attribute24
615 ,p_pel_attribute25 => p_pel_attribute25
616 ,p_pel_attribute26 => p_pel_attribute26
617 ,p_pel_attribute27 => p_pel_attribute27
618 ,p_pel_attribute28 => p_pel_attribute28
619 ,p_pel_attribute29 => p_pel_attribute29
620 ,p_pel_attribute30 => p_pel_attribute30
621 ,p_request_id => p_request_id
622 ,p_program_application_id => p_program_application_id
623 ,p_program_id => p_program_id
624 ,p_program_update_date => p_program_update_date
625 ,p_object_version_number => p_object_version_number
626 ,p_effective_date => trunc(p_effective_date)
627 ,p_defer_deenrol_flag => p_defer_deenrol_flag
628 ,p_deenrol_made_dt => p_deenrol_made_dt
629 );
630 exception
631 when hr_api.cannot_find_prog_unit then
632 hr_api.cannot_find_prog_unit_error
633 (p_module_name => 'UPDATE_Pil_Elctbl_chc_Popl'
634 ,p_hook_type => 'BP'
635 );
636 --
637 -- End of API User Hook for the before hook of update_Pil_Elctbl_chc_Popl
638 --
639 end;
640 --
641 ben_pel_upd.upd
642 (
643 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
644 ,p_dflt_enrt_dt => p_dflt_enrt_dt
645 ,p_dflt_asnd_dt => p_dflt_asnd_dt
646 ,p_elcns_made_dt => p_elcns_made_dt
647 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
648 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
649 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
650 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
651 ,p_procg_end_dt => p_procg_end_dt
652 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
653 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
654 ,p_uom => p_uom
655 ,p_comments => p_comments
656 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
657 ,p_ws_mgr_id => p_ws_mgr_id
658 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
659 ,p_assignment_id => p_assignment_id
660 --cwb
661 ,p_bdgt_acc_cd => p_bdgt_acc_cd
662 ,p_pop_cd => p_pop_cd
663 ,p_bdgt_due_dt => p_bdgt_due_dt
664 ,p_bdgt_export_flag => p_bdgt_export_flag
665 ,p_bdgt_iss_dt => p_bdgt_iss_dt
666 ,p_bdgt_stat_cd => p_bdgt_stat_cd
667 ,p_ws_acc_cd => p_ws_acc_cd
668 ,p_ws_due_dt => p_ws_due_dt
669 ,p_ws_export_flag => p_ws_export_flag
670 ,p_ws_iss_dt => p_ws_iss_dt
671 ,p_ws_stat_cd => p_ws_stat_cd
672 --cwb
673 ,p_reinstate_cd => p_reinstate_cd
674 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
675 ,p_auto_asnd_dt => p_auto_asnd_dt
676 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
677 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
678 ,p_lee_rsn_id => p_lee_rsn_id
679 ,p_enrt_perd_id => p_enrt_perd_id
680 ,p_per_in_ler_id => p_per_in_ler_id
681 ,p_pgm_id => p_pgm_id
682 ,p_pl_id => p_pl_id
683 ,p_business_group_id => p_business_group_id
684 ,p_pel_attribute_category => p_pel_attribute_category
685 ,p_pel_attribute1 => p_pel_attribute1
686 ,p_pel_attribute2 => p_pel_attribute2
687 ,p_pel_attribute3 => p_pel_attribute3
688 ,p_pel_attribute4 => p_pel_attribute4
689 ,p_pel_attribute5 => p_pel_attribute5
690 ,p_pel_attribute6 => p_pel_attribute6
691 ,p_pel_attribute7 => p_pel_attribute7
692 ,p_pel_attribute8 => p_pel_attribute8
693 ,p_pel_attribute9 => p_pel_attribute9
694 ,p_pel_attribute10 => p_pel_attribute10
695 ,p_pel_attribute11 => p_pel_attribute11
696 ,p_pel_attribute12 => p_pel_attribute12
697 ,p_pel_attribute13 => p_pel_attribute13
698 ,p_pel_attribute14 => p_pel_attribute14
699 ,p_pel_attribute15 => p_pel_attribute15
700 ,p_pel_attribute16 => p_pel_attribute16
701 ,p_pel_attribute17 => p_pel_attribute17
702 ,p_pel_attribute18 => p_pel_attribute18
703 ,p_pel_attribute19 => p_pel_attribute19
704 ,p_pel_attribute20 => p_pel_attribute20
705 ,p_pel_attribute21 => p_pel_attribute21
706 ,p_pel_attribute22 => p_pel_attribute22
707 ,p_pel_attribute23 => p_pel_attribute23
708 ,p_pel_attribute24 => p_pel_attribute24
709 ,p_pel_attribute25 => p_pel_attribute25
710 ,p_pel_attribute26 => p_pel_attribute26
711 ,p_pel_attribute27 => p_pel_attribute27
712 ,p_pel_attribute28 => p_pel_attribute28
713 ,p_pel_attribute29 => p_pel_attribute29
714 ,p_pel_attribute30 => p_pel_attribute30
715 ,p_request_id => p_request_id
716 ,p_program_application_id => p_program_application_id
717 ,p_program_id => p_program_id
718 ,p_program_update_date => p_program_update_date
719 ,p_object_version_number => l_object_version_number
720 ,p_effective_date => trunc(p_effective_date)
721 ,p_defer_deenrol_flag => p_defer_deenrol_flag
722 ,p_deenrol_made_dt => p_deenrol_made_dt
723 );
724 --
725 begin
726 --
727 -- Start of API User Hook for the after hook of update_Pil_Elctbl_chc_Popl
728 --
729 ben_Pil_Elctbl_chc_Popl_bk2.update_Pil_Elctbl_chc_Popl_a
730 (
731 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
732 ,p_dflt_enrt_dt => p_dflt_enrt_dt
733 ,p_dflt_asnd_dt => p_dflt_asnd_dt
734 ,p_elcns_made_dt => p_elcns_made_dt
735 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
736 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
737 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
738 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
739 ,p_procg_end_dt => p_procg_end_dt
740 ,p_pil_elctbl_popl_stat_cd => p_pil_elctbl_popl_stat_cd
741 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
742 ,p_uom => p_uom
743 ,p_comments => p_comments
744 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
745 ,p_ws_mgr_id => p_ws_mgr_id
746 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
747 ,p_assignment_id => p_assignment_id
748 --cwb
749 ,p_bdgt_acc_cd => p_bdgt_acc_cd
750 ,p_pop_cd => p_pop_cd
751 ,p_bdgt_due_dt => p_bdgt_due_dt
752 ,p_bdgt_export_flag => p_bdgt_export_flag
753 ,p_bdgt_iss_dt => p_bdgt_iss_dt
754 ,p_bdgt_stat_cd => p_bdgt_stat_cd
755 ,p_ws_acc_cd => p_ws_acc_cd
756 ,p_ws_due_dt => p_ws_due_dt
757 ,p_ws_export_flag => p_ws_export_flag
758 ,p_ws_iss_dt => p_ws_iss_dt
759 ,p_ws_stat_cd => p_ws_stat_cd
760 --cwb
761 ,p_reinstate_cd => p_reinstate_cd
762 ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
763 ,p_auto_asnd_dt => p_auto_asnd_dt
764 ,p_cbr_elig_perd_strt_dt => p_cbr_elig_perd_strt_dt
765 ,p_cbr_elig_perd_end_dt => p_cbr_elig_perd_end_dt
766 ,p_lee_rsn_id => p_lee_rsn_id
767 ,p_enrt_perd_id => p_enrt_perd_id
768 ,p_per_in_ler_id => p_per_in_ler_id
769 ,p_pgm_id => p_pgm_id
770 ,p_pl_id => p_pl_id
771 ,p_business_group_id => p_business_group_id
772 ,p_pel_attribute_category => p_pel_attribute_category
773 ,p_pel_attribute1 => p_pel_attribute1
774 ,p_pel_attribute2 => p_pel_attribute2
775 ,p_pel_attribute3 => p_pel_attribute3
776 ,p_pel_attribute4 => p_pel_attribute4
777 ,p_pel_attribute5 => p_pel_attribute5
778 ,p_pel_attribute6 => p_pel_attribute6
779 ,p_pel_attribute7 => p_pel_attribute7
780 ,p_pel_attribute8 => p_pel_attribute8
781 ,p_pel_attribute9 => p_pel_attribute9
782 ,p_pel_attribute10 => p_pel_attribute10
783 ,p_pel_attribute11 => p_pel_attribute11
784 ,p_pel_attribute12 => p_pel_attribute12
785 ,p_pel_attribute13 => p_pel_attribute13
786 ,p_pel_attribute14 => p_pel_attribute14
787 ,p_pel_attribute15 => p_pel_attribute15
788 ,p_pel_attribute16 => p_pel_attribute16
789 ,p_pel_attribute17 => p_pel_attribute17
790 ,p_pel_attribute18 => p_pel_attribute18
791 ,p_pel_attribute19 => p_pel_attribute19
792 ,p_pel_attribute20 => p_pel_attribute20
793 ,p_pel_attribute21 => p_pel_attribute21
794 ,p_pel_attribute22 => p_pel_attribute22
795 ,p_pel_attribute23 => p_pel_attribute23
796 ,p_pel_attribute24 => p_pel_attribute24
797 ,p_pel_attribute25 => p_pel_attribute25
798 ,p_pel_attribute26 => p_pel_attribute26
799 ,p_pel_attribute27 => p_pel_attribute27
800 ,p_pel_attribute28 => p_pel_attribute28
801 ,p_pel_attribute29 => p_pel_attribute29
802 ,p_pel_attribute30 => p_pel_attribute30
803 ,p_request_id => p_request_id
804 ,p_program_application_id => p_program_application_id
805 ,p_program_id => p_program_id
806 ,p_program_update_date => p_program_update_date
807 ,p_object_version_number => l_object_version_number
808 ,p_effective_date => trunc(p_effective_date)
809 ,p_defer_deenrol_flag => p_defer_deenrol_flag
810 ,p_deenrol_made_dt => p_deenrol_made_dt
811 );
812 exception
813 when hr_api.cannot_find_prog_unit then
814 hr_api.cannot_find_prog_unit_error
815 (p_module_name => 'UPDATE_Pil_Elctbl_chc_Popl'
816 ,p_hook_type => 'AP'
817 );
818 --
819 -- End of API User Hook for the after hook of update_Pil_Elctbl_chc_Popl
820 --
821 end;
822 --
823 hr_utility.set_location(l_proc, 60);
824 --
825 -- When in validation only mode raise the Validate_Enabled exception
826 --
827 if p_validate then
828 raise hr_api.validate_enabled;
829 end if;
830 --
831 -- Set all output arguments
832 --
833 p_object_version_number := l_object_version_number;
834 --
835 hr_utility.set_location(' Leaving:'||l_proc, 70);
836 --
837 exception
838 --
839 when hr_api.validate_enabled then
840 --
841 -- As the Validate_Enabled exception has been raised
842 -- we must rollback to the savepoint
843 --
844 ROLLBACK TO update_Pil_Elctbl_chc_Popl;
845 --
846 -- Only set output warning arguments
847 -- (Any key or derived arguments must be set to null
848 -- when validation only mode is being used.)
849 --
850 hr_utility.set_location(' Leaving:'||l_proc, 80);
851 --
852 when others then
853 --
854 -- A validation or unexpected error has occured
855 --
856 ROLLBACK TO update_Pil_Elctbl_chc_Popl;
857 --nocopy change
858 p_object_version_number := l_object_version_number;
859 raise;
860 --
861 end update_Pil_Elctbl_chc_Popl;
862 -- ----------------------------------------------------------------------------
863 -- |------------------------< delete_Pil_Elctbl_chc_Popl >----------------------|
864 -- ----------------------------------------------------------------------------
865 --
866 procedure delete_Pil_Elctbl_chc_Popl
867 (p_validate in boolean default false
868 ,p_pil_elctbl_chc_popl_id in number
869 ,p_object_version_number in out nocopy number
870 ,p_effective_date in date
871 ) is
872 --
873 -- Declare cursors and local variables
874 --
875 l_proc varchar2(72) := g_package||'update_Pil_Elctbl_chc_Popl';
876 l_object_version_number ben_pil_elctbl_chc_popl.object_version_number%TYPE;
877 --
878 begin
879 --
880 hr_utility.set_location('Entering:'|| l_proc, 10);
881 --
882 -- Issue a savepoint if operating in validation only mode
883 --
884 savepoint delete_Pil_Elctbl_chc_Popl;
885 --
886 hr_utility.set_location(l_proc, 20);
887 --
888 -- Process Logic
889 --
890 l_object_version_number := p_object_version_number;
891 --
892 --
893 begin
894 --
895 -- Start of API User Hook for the before hook of delete_Pil_Elctbl_chc_Popl
896 --
897 ben_Pil_Elctbl_chc_Popl_bk3.delete_Pil_Elctbl_chc_Popl_b
898 (
899 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
900 ,p_object_version_number => p_object_version_number
901 ,p_effective_date => trunc(p_effective_date)
902 );
903 exception
904 when hr_api.cannot_find_prog_unit then
905 hr_api.cannot_find_prog_unit_error
906 (p_module_name => 'DELETE_Pil_Elctbl_chc_Popl'
907 ,p_hook_type => 'BP'
908 );
909 --
910 -- End of API User Hook for the before hook of delete_Pil_Elctbl_chc_Popl
911 --
912 end;
913 --
914 ben_pel_del.del
915 (
916 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
917 ,p_object_version_number => l_object_version_number
918 ,p_effective_date => p_effective_date
919 );
920 --
921 begin
922 --
923 -- Start of API User Hook for the after hook of delete_Pil_Elctbl_chc_Popl
924 --
925 ben_Pil_Elctbl_chc_Popl_bk3.delete_Pil_Elctbl_chc_Popl_a
926 (
927 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
928 ,p_object_version_number => l_object_version_number
929 ,p_effective_date => trunc(p_effective_date)
930 );
931 exception
932 when hr_api.cannot_find_prog_unit then
933 hr_api.cannot_find_prog_unit_error
934 (p_module_name => 'DELETE_Pil_Elctbl_chc_Popl'
935 ,p_hook_type => 'AP'
936 );
937 --
938 -- End of API User Hook for the after hook of delete_Pil_Elctbl_chc_Popl
939 --
940 end;
941 --
942 hr_utility.set_location(l_proc, 60);
943 --
944 -- When in validation only mode raise the Validate_Enabled exception
945 --
946 if p_validate then
947 raise hr_api.validate_enabled;
948 end if;
949 --
950 hr_utility.set_location(' Leaving:'||l_proc, 70);
951 --
952 exception
953 --
954 when hr_api.validate_enabled then
955 --
956 -- As the Validate_Enabled exception has been raised
957 -- we must rollback to the savepoint
958 --
959 ROLLBACK TO delete_Pil_Elctbl_chc_Popl;
960 --
961 -- Only set output warning arguments
962 -- (Any key or derived arguments must be set to null
963 -- when validation only mode is being used.)
964 --
965 --
966 when others then
967 --
968 -- A validation or unexpected error has occured
969 --
970 ROLLBACK TO delete_Pil_Elctbl_chc_Popl;
971 --nocopy change
972 p_object_version_number := l_object_version_number;
973 raise;
974 --
975 end delete_Pil_Elctbl_chc_Popl;
976 --
977 -- ----------------------------------------------------------------------------
978 -- |-------------------------------< lck >------------------------------------|
979 -- ----------------------------------------------------------------------------
980 --
981 procedure lck
982 (
983 p_pil_elctbl_chc_popl_id in number
984 ,p_object_version_number in number
985 ) is
986 --
987 --
988 -- Declare cursors and local variables
989 --
990 l_proc varchar2(72) := g_package||'lck';
991 --
992 begin
993 --
994 hr_utility.set_location('Entering:'|| l_proc, 10);
995 --
996 ben_pel_shd.lck
997 (
998 p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
999 ,p_object_version_number => p_object_version_number
1000 );
1001 --
1002 hr_utility.set_location(' Leaving:'||l_proc, 70);
1003 --
1004 end lck;
1005 --
1006 end ben_Pil_Elctbl_chc_Popl_api;