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