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