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