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