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