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