[Home] [Help]
PACKAGE BODY: APPS.BEN_ELIGIBLE_PERSON_API
Source
1 Package Body ben_Eligible_Person_api as
2 /* $Header: bepepapi.pkb 120.0 2005/05/28 10:38:50 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_Eligible_Person_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_Eligible_Person >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Eligible_Person
13 (p_validate in boolean default false
14 ,p_elig_per_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_pl_id in number default null
19 ,p_pgm_id in number default null
20 ,p_plip_id in number default null
21 ,p_ptip_id in number default null
22 ,p_ler_id in number default null
23 ,p_person_id in number default null
24 ,p_per_in_ler_id in number default null
25 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default 'N'
26 ,p_prtn_ovridn_thru_dt in date default null
27 ,p_pl_key_ee_flag in varchar2 default 'N'
28 ,p_pl_hghly_compd_flag in varchar2 default 'N'
29 ,p_elig_flag in varchar2 default 'N'
30 ,p_comp_ref_amt in number default null
31 ,p_cmbn_age_n_los_val in number default null
32 ,p_comp_ref_uom in varchar2 default null
33 ,p_age_val in number default null
34 ,p_los_val in number default null
35 ,p_prtn_end_dt in date default null
36 ,p_prtn_strt_dt in date default null
37 ,p_wait_perd_cmpltn_dt in date default null
38 ,p_wait_perd_strt_dt in date default null
39 ,p_wv_ctfn_typ_cd in varchar2 default null
40 ,p_hrs_wkd_val in number default null
41 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
42 ,p_prtn_ovridn_flag in varchar2 default null
43 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default 'N'
44 ,p_prtn_ovridn_rsn_cd in varchar2 default null
45 ,p_age_uom in varchar2 default null
46 ,p_los_uom in varchar2 default null
47 ,p_ovrid_svc_dt in date default null
48 ,p_inelg_rsn_cd in varchar2 default null
49 ,p_frz_los_flag in varchar2 default 'N'
50 ,p_frz_age_flag in varchar2 default 'N'
51 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
52 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
53 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
54 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
55 ,p_dstr_rstcn_flag in varchar2 default 'N'
56 ,p_pct_fl_tm_val in number default null
57 ,p_wv_prtn_rsn_cd in varchar2 default null
58 ,p_pl_wvd_flag in varchar2 default 'N'
59 ,p_rt_comp_ref_amt in number default null
60 ,p_rt_cmbn_age_n_los_val in number default null
61 ,p_rt_comp_ref_uom in varchar2 default null
62 ,p_rt_age_val in number default null
63 ,p_rt_los_val in number default null
64 ,p_rt_hrs_wkd_val in number default null
65 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
66 ,p_rt_age_uom in varchar2 default null
67 ,p_rt_los_uom in varchar2 default null
68 ,p_rt_pct_fl_tm_val in number default null
69 ,p_rt_frz_los_flag in varchar2 default 'N'
70 ,p_rt_frz_age_flag in varchar2 default 'N'
71 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
72 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
73 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
74 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
75 ,p_once_r_cntug_cd in varchar2 default null
76 ,p_pl_ordr_num in number default null
77 ,p_plip_ordr_num in number default null
78 ,p_ptip_ordr_num in number default null
79 ,p_pep_attribute_category in varchar2 default null
80 ,p_pep_attribute1 in varchar2 default null
81 ,p_pep_attribute2 in varchar2 default null
82 ,p_pep_attribute3 in varchar2 default null
83 ,p_pep_attribute4 in varchar2 default null
84 ,p_pep_attribute5 in varchar2 default null
85 ,p_pep_attribute6 in varchar2 default null
86 ,p_pep_attribute7 in varchar2 default null
87 ,p_pep_attribute8 in varchar2 default null
88 ,p_pep_attribute9 in varchar2 default null
89 ,p_pep_attribute10 in varchar2 default null
90 ,p_pep_attribute11 in varchar2 default null
91 ,p_pep_attribute12 in varchar2 default null
92 ,p_pep_attribute13 in varchar2 default null
93 ,p_pep_attribute14 in varchar2 default null
94 ,p_pep_attribute15 in varchar2 default null
95 ,p_pep_attribute16 in varchar2 default null
96 ,p_pep_attribute17 in varchar2 default null
97 ,p_pep_attribute18 in varchar2 default null
98 ,p_pep_attribute19 in varchar2 default null
99 ,p_pep_attribute20 in varchar2 default null
100 ,p_pep_attribute21 in varchar2 default null
101 ,p_pep_attribute22 in varchar2 default null
102 ,p_pep_attribute23 in varchar2 default null
103 ,p_pep_attribute24 in varchar2 default null
104 ,p_pep_attribute25 in varchar2 default null
105 ,p_pep_attribute26 in varchar2 default null
106 ,p_pep_attribute27 in varchar2 default null
107 ,p_pep_attribute28 in varchar2 default null
108 ,p_pep_attribute29 in varchar2 default null
109 ,p_pep_attribute30 in varchar2 default null
110 ,p_request_id in number default null
111 ,p_program_application_id in number default null
112 ,p_program_id in number default null
113 ,p_program_update_date in date default null
114 ,p_object_version_number out nocopy number
115 ,p_effective_date in date
116 ,p_override_validation in boolean default false
117 )
118 is
119 --
120 -- Declare cursors and local variables
121 --
122 l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
123 l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
124 l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
125 l_proc varchar2(72) := g_package||'create_Eligible_Person';
126 l_object_version_number ben_elig_per_f.object_version_number%TYPE;
127 --
128 begin
129 --
130 hr_utility.set_location('Entering:'|| l_proc, 10);
131 --
132 -- Issue a savepoint if operating in validation only mode
133 --
134 savepoint create_Eligible_Person;
135 --
136 hr_utility.set_location(l_proc, 20);
137 --
138 -- Process Logic
139 --
140 begin
141 --
142 -- Start of API User Hook for the before hook of create_Eligible_Person
143 --
144 ben_Eligible_Person_bk1.create_Eligible_Person_b
145 (p_business_group_id => p_business_group_id
146 ,p_pl_id => p_pl_id
147 ,p_pgm_id => p_pgm_id
148 ,p_plip_id => p_plip_id
149 ,p_ptip_id => p_ptip_id
150 ,p_ler_id => p_ler_id
151 ,p_person_id => p_person_id
152 ,p_per_in_ler_id => p_per_in_ler_id
153 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
154 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
155 ,p_pl_key_ee_flag => p_pl_key_ee_flag
156 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
157 ,p_elig_flag => p_elig_flag
158 ,p_comp_ref_amt => p_comp_ref_amt
159 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
160 ,p_comp_ref_uom => p_comp_ref_uom
161 ,p_age_val => p_age_val
162 ,p_los_val => p_los_val
163 ,p_prtn_end_dt => p_prtn_end_dt
164 ,p_prtn_strt_dt => p_prtn_strt_dt
165 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
166 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
167 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
168 ,p_hrs_wkd_val => p_hrs_wkd_val
169 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
170 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
171 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
172 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
173 ,p_age_uom => p_age_uom
174 ,p_los_uom => p_los_uom
175 ,p_ovrid_svc_dt => p_ovrid_svc_dt
176 ,p_inelg_rsn_cd => p_inelg_rsn_cd
177 ,p_frz_los_flag => p_frz_los_flag
178 ,p_frz_age_flag => p_frz_age_flag
179 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
180 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
181 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
182 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
183 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
184 ,p_pct_fl_tm_val => p_pct_fl_tm_val
185 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
186 ,p_pl_wvd_flag => p_pl_wvd_flag
187 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
188 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
189 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
190 ,p_rt_age_val => p_rt_age_val
191 ,p_rt_los_val => p_rt_los_val
192 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
193 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
194 ,p_rt_age_uom => p_rt_age_uom
195 ,p_rt_los_uom => p_rt_los_uom
196 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
197 ,p_rt_frz_los_flag => p_rt_frz_los_flag
198 ,p_rt_frz_age_flag => p_rt_frz_age_flag
199 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
200 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
201 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
202 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
203 ,p_once_r_cntug_cd => p_once_r_cntug_cd
204 ,p_pl_ordr_num => p_pl_ordr_num
205 ,p_plip_ordr_num => p_plip_ordr_num
206 ,p_ptip_ordr_num => p_ptip_ordr_num
207 ,p_pep_attribute_category => p_pep_attribute_category
208 ,p_pep_attribute1 => p_pep_attribute1
209 ,p_pep_attribute2 => p_pep_attribute2
210 ,p_pep_attribute3 => p_pep_attribute3
211 ,p_pep_attribute4 => p_pep_attribute4
212 ,p_pep_attribute5 => p_pep_attribute5
213 ,p_pep_attribute6 => p_pep_attribute6
214 ,p_pep_attribute7 => p_pep_attribute7
215 ,p_pep_attribute8 => p_pep_attribute8
216 ,p_pep_attribute9 => p_pep_attribute9
217 ,p_pep_attribute10 => p_pep_attribute10
218 ,p_pep_attribute11 => p_pep_attribute11
219 ,p_pep_attribute12 => p_pep_attribute12
220 ,p_pep_attribute13 => p_pep_attribute13
221 ,p_pep_attribute14 => p_pep_attribute14
222 ,p_pep_attribute15 => p_pep_attribute15
223 ,p_pep_attribute16 => p_pep_attribute16
224 ,p_pep_attribute17 => p_pep_attribute17
225 ,p_pep_attribute18 => p_pep_attribute18
226 ,p_pep_attribute19 => p_pep_attribute19
227 ,p_pep_attribute20 => p_pep_attribute20
228 ,p_pep_attribute21 => p_pep_attribute21
229 ,p_pep_attribute22 => p_pep_attribute22
230 ,p_pep_attribute23 => p_pep_attribute23
231 ,p_pep_attribute24 => p_pep_attribute24
232 ,p_pep_attribute25 => p_pep_attribute25
233 ,p_pep_attribute26 => p_pep_attribute26
234 ,p_pep_attribute27 => p_pep_attribute27
235 ,p_pep_attribute28 => p_pep_attribute28
236 ,p_pep_attribute29 => p_pep_attribute29
237 ,p_pep_attribute30 => p_pep_attribute30
238 ,p_request_id => p_request_id
239 ,p_program_application_id => p_program_application_id
240 ,p_program_id => p_program_id
241 ,p_program_update_date => p_program_update_date
242 ,p_effective_date => trunc(p_effective_date));
243 --
244 exception
245 --
246 when hr_api.cannot_find_prog_unit then
247 --
248 hr_api.cannot_find_prog_unit_error
249 (p_module_name => 'CREATE_Eligible_Person'
250 ,p_hook_type => 'BP');
251 --
252 -- End of API User Hook for the before hook of create_Eligible_Person
253 --
254 end;
255 --
256 ben_pep_ins.ins
257 (p_elig_per_id => l_elig_per_id
258 ,p_effective_start_date => l_effective_start_date
259 ,p_effective_end_date => l_effective_end_date
260 ,p_business_group_id => p_business_group_id
261 ,p_pl_id => p_pl_id
262 ,p_pgm_id => p_pgm_id
263 ,p_plip_id => p_plip_id
264 ,p_ptip_id => p_ptip_id
265 ,p_ler_id => p_ler_id
266 ,p_person_id => p_person_id
267 ,p_per_in_ler_id => p_per_in_ler_id
268 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
269 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
270 ,p_pl_key_ee_flag => p_pl_key_ee_flag
271 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
272 ,p_elig_flag => p_elig_flag
273 ,p_comp_ref_amt => p_comp_ref_amt
274 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
275 ,p_comp_ref_uom => p_comp_ref_uom
276 ,p_age_val => p_age_val
277 ,p_los_val => p_los_val
278 ,p_prtn_end_dt => p_prtn_end_dt
279 ,p_prtn_strt_dt => p_prtn_strt_dt
280 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
281 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
282 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
283 ,p_hrs_wkd_val => p_hrs_wkd_val
284 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
285 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
286 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
287 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
288 ,p_age_uom => p_age_uom
289 ,p_los_uom => p_los_uom
290 ,p_ovrid_svc_dt => p_ovrid_svc_dt
291 ,p_inelg_rsn_cd => p_inelg_rsn_cd
292 ,p_frz_los_flag => p_frz_los_flag
293 ,p_frz_age_flag => p_frz_age_flag
294 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
295 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
296 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
297 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
298 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
299 ,p_pct_fl_tm_val => p_pct_fl_tm_val
300 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
301 ,p_pl_wvd_flag => p_pl_wvd_flag
302 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
303 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
304 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
305 ,p_rt_age_val => p_rt_age_val
306 ,p_rt_los_val => p_rt_los_val
307 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
308 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
309 ,p_rt_age_uom => p_rt_age_uom
310 ,p_rt_los_uom => p_rt_los_uom
311 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
312 ,p_rt_frz_los_flag => p_rt_frz_los_flag
313 ,p_rt_frz_age_flag => p_rt_frz_age_flag
314 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
315 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
316 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
317 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
318 ,p_once_r_cntug_cd => p_once_r_cntug_cd
319 ,p_pl_ordr_num => p_pl_ordr_num
320 ,p_plip_ordr_num => p_plip_ordr_num
321 ,p_ptip_ordr_num => p_ptip_ordr_num
322 ,p_pep_attribute_category => p_pep_attribute_category
323 ,p_pep_attribute1 => p_pep_attribute1
324 ,p_pep_attribute2 => p_pep_attribute2
325 ,p_pep_attribute3 => p_pep_attribute3
326 ,p_pep_attribute4 => p_pep_attribute4
327 ,p_pep_attribute5 => p_pep_attribute5
328 ,p_pep_attribute6 => p_pep_attribute6
329 ,p_pep_attribute7 => p_pep_attribute7
330 ,p_pep_attribute8 => p_pep_attribute8
331 ,p_pep_attribute9 => p_pep_attribute9
332 ,p_pep_attribute10 => p_pep_attribute10
333 ,p_pep_attribute11 => p_pep_attribute11
334 ,p_pep_attribute12 => p_pep_attribute12
335 ,p_pep_attribute13 => p_pep_attribute13
336 ,p_pep_attribute14 => p_pep_attribute14
337 ,p_pep_attribute15 => p_pep_attribute15
338 ,p_pep_attribute16 => p_pep_attribute16
339 ,p_pep_attribute17 => p_pep_attribute17
340 ,p_pep_attribute18 => p_pep_attribute18
341 ,p_pep_attribute19 => p_pep_attribute19
342 ,p_pep_attribute20 => p_pep_attribute20
343 ,p_pep_attribute21 => p_pep_attribute21
344 ,p_pep_attribute22 => p_pep_attribute22
345 ,p_pep_attribute23 => p_pep_attribute23
346 ,p_pep_attribute24 => p_pep_attribute24
347 ,p_pep_attribute25 => p_pep_attribute25
348 ,p_pep_attribute26 => p_pep_attribute26
349 ,p_pep_attribute27 => p_pep_attribute27
350 ,p_pep_attribute28 => p_pep_attribute28
351 ,p_pep_attribute29 => p_pep_attribute29
352 ,p_pep_attribute30 => p_pep_attribute30
353 ,p_request_id => p_request_id
354 ,p_program_application_id => p_program_application_id
355 ,p_program_id => p_program_id
356 ,p_program_update_date => p_program_update_date
357 ,p_object_version_number => l_object_version_number
358 ,p_effective_date => trunc(p_effective_date)
359 ,p_override_validation => p_override_validation
360 );
361 --
362 begin
363 --
364 -- Start of API User Hook for the after hook of create_Eligible_Person
365 --
366 ben_Eligible_Person_bk1.create_Eligible_Person_a
367 (p_elig_per_id => l_elig_per_id
368 ,p_effective_start_date => l_effective_start_date
369 ,p_effective_end_date => l_effective_end_date
370 ,p_business_group_id => p_business_group_id
371 ,p_pl_id => p_pl_id
372 ,p_pgm_id => p_pgm_id
373 ,p_plip_id => p_plip_id
374 ,p_ptip_id => p_ptip_id
375 ,p_ler_id => p_ler_id
376 ,p_person_id => p_person_id
377 ,p_per_in_ler_id => p_per_in_ler_id
378 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
379 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
380 ,p_pl_key_ee_flag => p_pl_key_ee_flag
381 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
382 ,p_elig_flag => p_elig_flag
383 ,p_comp_ref_amt => p_comp_ref_amt
384 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
385 ,p_comp_ref_uom => p_comp_ref_uom
386 ,p_age_val => p_age_val
387 ,p_los_val => p_los_val
388 ,p_prtn_end_dt => p_prtn_end_dt
389 ,p_prtn_strt_dt => p_prtn_strt_dt
390 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
391 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
392 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
393 ,p_hrs_wkd_val => p_hrs_wkd_val
394 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
395 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
396 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
397 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
398 ,p_age_uom => p_age_uom
399 ,p_los_uom => p_los_uom
400 ,p_ovrid_svc_dt => p_ovrid_svc_dt
401 ,p_inelg_rsn_cd => p_inelg_rsn_cd
402 ,p_frz_los_flag => p_frz_los_flag
403 ,p_frz_age_flag => p_frz_age_flag
404 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
405 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
406 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
407 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
408 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
409 ,p_pct_fl_tm_val => p_pct_fl_tm_val
410 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
411 ,p_pl_wvd_flag => p_pl_wvd_flag
412 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
413 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
414 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
415 ,p_rt_age_val => p_rt_age_val
416 ,p_rt_los_val => p_rt_los_val
417 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
418 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
419 ,p_rt_age_uom => p_rt_age_uom
420 ,p_rt_los_uom => p_rt_los_uom
421 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
422 ,p_rt_frz_los_flag => p_rt_frz_los_flag
423 ,p_rt_frz_age_flag => p_rt_frz_age_flag
424 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
425 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
426 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
427 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
428 ,p_once_r_cntug_cd => p_once_r_cntug_cd
429 ,p_pl_ordr_num => p_pl_ordr_num
430 ,p_plip_ordr_num => p_plip_ordr_num
431 ,p_ptip_ordr_num => p_ptip_ordr_num
432 ,p_pep_attribute_category => p_pep_attribute_category
433 ,p_pep_attribute1 => p_pep_attribute1
434 ,p_pep_attribute2 => p_pep_attribute2
435 ,p_pep_attribute3 => p_pep_attribute3
436 ,p_pep_attribute4 => p_pep_attribute4
437 ,p_pep_attribute5 => p_pep_attribute5
438 ,p_pep_attribute6 => p_pep_attribute6
439 ,p_pep_attribute7 => p_pep_attribute7
440 ,p_pep_attribute8 => p_pep_attribute8
441 ,p_pep_attribute9 => p_pep_attribute9
442 ,p_pep_attribute10 => p_pep_attribute10
443 ,p_pep_attribute11 => p_pep_attribute11
444 ,p_pep_attribute12 => p_pep_attribute12
445 ,p_pep_attribute13 => p_pep_attribute13
446 ,p_pep_attribute14 => p_pep_attribute14
447 ,p_pep_attribute15 => p_pep_attribute15
448 ,p_pep_attribute16 => p_pep_attribute16
449 ,p_pep_attribute17 => p_pep_attribute17
450 ,p_pep_attribute18 => p_pep_attribute18
451 ,p_pep_attribute19 => p_pep_attribute19
452 ,p_pep_attribute20 => p_pep_attribute20
453 ,p_pep_attribute21 => p_pep_attribute21
454 ,p_pep_attribute22 => p_pep_attribute22
455 ,p_pep_attribute23 => p_pep_attribute23
456 ,p_pep_attribute24 => p_pep_attribute24
457 ,p_pep_attribute25 => p_pep_attribute25
458 ,p_pep_attribute26 => p_pep_attribute26
459 ,p_pep_attribute27 => p_pep_attribute27
460 ,p_pep_attribute28 => p_pep_attribute28
461 ,p_pep_attribute29 => p_pep_attribute29
462 ,p_pep_attribute30 => p_pep_attribute30
463 ,p_request_id => p_request_id
464 ,p_program_application_id => p_program_application_id
465 ,p_program_id => p_program_id
466 ,p_program_update_date => p_program_update_date
467 ,p_object_version_number => l_object_version_number
468 ,p_effective_date => trunc(p_effective_date));
469 --
470 exception
471 --
472 when hr_api.cannot_find_prog_unit then
473 --
474 hr_api.cannot_find_prog_unit_error
475 (p_module_name => 'CREATE_Eligible_Person'
476 ,p_hook_type => 'AP');
477 --
478 -- End of API User Hook for the after hook of create_Eligible_Person
479 --
480 end;
481 --
482 hr_utility.set_location(l_proc, 60);
483 --
484 -- When in validation only mode raise the Validate_Enabled exception
485 --
486 if p_validate then
487 raise hr_api.validate_enabled;
488 end if;
489 --
490 -- Set all output arguments
491 --
492 p_elig_per_id := l_elig_per_id;
493 p_effective_start_date := l_effective_start_date;
494 p_effective_end_date := l_effective_end_date;
495 p_object_version_number := l_object_version_number;
496 --
497 hr_utility.set_location(' Leaving:'||l_proc, 70);
498 --
499 exception
500 --
501 when hr_api.validate_enabled then
502 --
503 -- As the Validate_Enabled exception has been raised
504 -- we must rollback to the savepoint
505 --
506 ROLLBACK TO create_Eligible_Person;
507 --
508 -- Only set output warning arguments
509 -- (Any key or derived arguments must be set to null
510 -- when validation only mode is being used.)
511 --
512 p_elig_per_id := null;
513 p_effective_start_date := null;
514 p_effective_end_date := null;
515 p_object_version_number := null;
516 hr_utility.set_location(' Leaving:'||l_proc, 80);
517 --
518 when others then
519 --
520 -- A validation or unexpected error has occured
521 --
522 ROLLBACK TO create_Eligible_Person;
523 p_effective_start_date := null;
524 p_effective_end_date := null;
525 p_object_version_number := null;
526
527 raise;
528 --
529 end create_Eligible_Person;
530 --
531 -- ----------------------------------------------------------------------------
532 -- |---------------------< create_perf_Eligible_Person >----------------------|
533 -- ----------------------------------------------------------------------------
534 --
535 procedure create_perf_Eligible_Person
536 (p_validate in boolean default false
537 ,p_elig_per_id out nocopy number
538 ,p_effective_start_date out nocopy date
539 ,p_effective_end_date out nocopy date
540 ,p_business_group_id in number default null
541 ,p_pl_id in number default null
542 ,p_pgm_id in number default null
543 ,p_plip_id in number default null
544 ,p_ptip_id in number default null
545 ,p_ler_id in number default null
546 ,p_person_id in number default null
547 ,p_per_in_ler_id in number default null
548 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default 'N'
549 ,p_prtn_ovridn_thru_dt in date default null
550 ,p_pl_key_ee_flag in varchar2 default 'N'
551 ,p_pl_hghly_compd_flag in varchar2 default 'N'
552 ,p_elig_flag in varchar2 default 'N'
553 ,p_comp_ref_amt in number default null
554 ,p_cmbn_age_n_los_val in number default null
555 ,p_comp_ref_uom in varchar2 default null
556 ,p_age_val in number default null
557 ,p_los_val in number default null
558 ,p_prtn_end_dt in date default null
559 ,p_prtn_strt_dt in date default null
560 ,p_wait_perd_cmpltn_dt in date default null
561 ,p_wait_perd_strt_dt in date default null
562 ,p_wv_ctfn_typ_cd in varchar2 default null
563 ,p_hrs_wkd_val in number default null
564 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
565 ,p_prtn_ovridn_flag in varchar2 default null
566 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default 'N'
567 ,p_prtn_ovridn_rsn_cd in varchar2 default null
568 ,p_age_uom in varchar2 default null
569 ,p_los_uom in varchar2 default null
570 ,p_ovrid_svc_dt in date default null
571 ,p_inelg_rsn_cd in varchar2 default null
572 ,p_frz_los_flag in varchar2 default 'N'
573 ,p_frz_age_flag in varchar2 default 'N'
574 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
575 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
576 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
577 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
578 ,p_dstr_rstcn_flag in varchar2 default 'N'
579 ,p_pct_fl_tm_val in number default null
580 ,p_wv_prtn_rsn_cd in varchar2 default null
581 ,p_pl_wvd_flag in varchar2 default 'N'
582 ,p_rt_comp_ref_amt in number default null
583 ,p_rt_cmbn_age_n_los_val in number default null
584 ,p_rt_comp_ref_uom in varchar2 default null
585 ,p_rt_age_val in number default null
586 ,p_rt_los_val in number default null
587 ,p_rt_hrs_wkd_val in number default null
588 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
589 ,p_rt_age_uom in varchar2 default null
590 ,p_rt_los_uom in varchar2 default null
591 ,p_rt_pct_fl_tm_val in number default null
592 ,p_rt_frz_los_flag in varchar2 default 'N'
593 ,p_rt_frz_age_flag in varchar2 default 'N'
594 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
595 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
596 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
597 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
598 ,p_once_r_cntug_cd in varchar2 default null
599 ,p_pl_ordr_num in number default null
600 ,p_plip_ordr_num in number default null
601 ,p_ptip_ordr_num in number default null
602 ,p_pep_attribute_category in varchar2 default null
603 ,p_pep_attribute1 in varchar2 default null
604 ,p_pep_attribute2 in varchar2 default null
605 ,p_pep_attribute3 in varchar2 default null
606 ,p_pep_attribute4 in varchar2 default null
607 ,p_pep_attribute5 in varchar2 default null
608 ,p_pep_attribute6 in varchar2 default null
609 ,p_pep_attribute7 in varchar2 default null
610 ,p_pep_attribute8 in varchar2 default null
611 ,p_pep_attribute9 in varchar2 default null
612 ,p_pep_attribute10 in varchar2 default null
613 ,p_pep_attribute11 in varchar2 default null
614 ,p_pep_attribute12 in varchar2 default null
615 ,p_pep_attribute13 in varchar2 default null
616 ,p_pep_attribute14 in varchar2 default null
617 ,p_pep_attribute15 in varchar2 default null
618 ,p_pep_attribute16 in varchar2 default null
619 ,p_pep_attribute17 in varchar2 default null
620 ,p_pep_attribute18 in varchar2 default null
621 ,p_pep_attribute19 in varchar2 default null
622 ,p_pep_attribute20 in varchar2 default null
623 ,p_pep_attribute21 in varchar2 default null
624 ,p_pep_attribute22 in varchar2 default null
625 ,p_pep_attribute23 in varchar2 default null
626 ,p_pep_attribute24 in varchar2 default null
627 ,p_pep_attribute25 in varchar2 default null
628 ,p_pep_attribute26 in varchar2 default null
629 ,p_pep_attribute27 in varchar2 default null
630 ,p_pep_attribute28 in varchar2 default null
631 ,p_pep_attribute29 in varchar2 default null
632 ,p_pep_attribute30 in varchar2 default null
633 ,p_request_id in number default null
634 ,p_program_application_id in number default null
635 ,p_program_id in number default null
636 ,p_program_update_date in date default null
637 ,p_object_version_number out nocopy number
638 ,p_effective_date in date
639 ,p_override_validation in boolean default false
640 )
641 is
642 --
643 l_proc varchar2(72) := g_package||'create_Eligible_Person';
644 --
645 l_rec ben_pep_shd.g_rec_type;
646 --
647 -- Declare cursors and local variables
648 --
649 l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
650 l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651 l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652 l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653 --
654 l_created_by ben_elig_per_f.created_by%TYPE;
655 l_creation_date ben_elig_per_f.creation_date%TYPE;
656 l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657 l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658 l_last_update_login ben_elig_per_f.last_update_login%TYPE;
659 --
660 l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
661 --
662 begin
663 --
664 hr_utility.set_location('Entering:'|| l_proc, 10);
665 --
666 -- Issue a savepoint if operating in validation only mode
667 --
668 savepoint create_perf_Eligible_Person;
669 --
670 -- Derive maximum start and end dates
671 --
672 l_effective_start_date := p_effective_date;
673 l_effective_end_date := hr_api.g_eot;
674 --
675 -- Person
676 --
677 ben_batch_dt_api.get_personobject
678 (p_person_id => p_person_id
679 ,p_rec => l_minmax_rec
680 );
681 --
682 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
683 (p_effective_date => p_effective_date
684 ,p_parcolumn_name => 'person_id'
685 ,p_min_esd => l_minmax_rec.min_esd
686 ,p_max_eed => l_minmax_rec.max_eed
687 --
688 ,p_esd => l_effective_start_date
689 ,p_eed => l_effective_end_date
690 );
691 --
692 -- Ler
693 --
694 if p_ler_id is not null then
695 --
696 ben_batch_dt_api.get_lerobject
697 (p_ler_id => p_ler_id
698 ,p_rec => l_minmax_rec
699 );
700 --
701 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
702 (p_effective_date => p_effective_date
703 ,p_parcolumn_name => 'ler_id'
704 ,p_min_esd => l_minmax_rec.min_esd
705 ,p_max_eed => l_minmax_rec.max_eed
706 --
707 ,p_esd => l_effective_start_date
708 ,p_eed => l_effective_end_date
709 );
710 --
711 end if;
712 --
713 -- Pgm
714 --
715 if p_pgm_id is not null then
716 --
717 ben_batch_dt_api.get_pgmobject
718 (p_pgm_id => p_pgm_id
719 ,p_rec => l_minmax_rec
720 );
721 --
722 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
723 (p_effective_date => p_effective_date
724 ,p_parcolumn_name => 'pgm_id'
725 ,p_min_esd => l_minmax_rec.min_esd
726 ,p_max_eed => l_minmax_rec.max_eed
727 --
728 ,p_esd => l_effective_start_date
729 ,p_eed => l_effective_end_date
730 );
731 --
732 end if;
733 --
734 -- Ptip
735 --
736 if p_ptip_id is not null then
737 --
738 ben_batch_dt_api.get_ptipobject
739 (p_ptip_id => p_ptip_id
740 ,p_rec => l_minmax_rec
741 );
742 --
743 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
744 (p_effective_date => p_effective_date
745 ,p_parcolumn_name => 'ptip_id'
746 ,p_min_esd => l_minmax_rec.min_esd
747 ,p_max_eed => l_minmax_rec.max_eed
748 --
749 ,p_esd => l_effective_start_date
750 ,p_eed => l_effective_end_date
751 );
752 --
753 end if;
754 --
755 -- Plip
756 --
757 if p_plip_id is not null then
758 --
759 ben_batch_dt_api.get_plipobject
760 (p_plip_id => p_plip_id
761 ,p_rec => l_minmax_rec
762 );
763 --
764 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
765 (p_effective_date => p_effective_date
766 ,p_parcolumn_name => 'plip_id'
767 ,p_min_esd => l_minmax_rec.min_esd
768 ,p_max_eed => l_minmax_rec.max_eed
769 --
770 ,p_esd => l_effective_start_date
771 ,p_eed => l_effective_end_date
772 );
773 --
774 end if;
775 --
776 -- Plan
777 --
778 if p_pl_id is not null then
779 --
780 ben_batch_dt_api.get_plobject
781 (p_pl_id => p_pl_id
782 ,p_rec => l_minmax_rec
783 );
784 --
785 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
786 (p_effective_date => p_effective_date
787 ,p_parcolumn_name => 'pl_id'
788 ,p_min_esd => l_minmax_rec.min_esd
789 ,p_max_eed => l_minmax_rec.max_eed
790 --
791 ,p_esd => l_effective_start_date
792 ,p_eed => l_effective_end_date
793 );
794 --
795 end if;
796 --
797 -- Insert the row
798 --
799 -- Set the object version number for the insert
800 --
801 l_object_version_number := 1;
802 --
803 ben_pep_shd.g_api_dml := true; -- Set the api dml status
804 --
805 -- Insert the row into: ben_elig_per_f
806 --
807 hr_utility.set_location('Insert: '||l_proc, 5);
808 insert into ben_elig_per_f
809 (
810 elig_per_id,
811 effective_start_date,
812 effective_end_date,
813 business_group_id,
814 pl_id,
815 pgm_id,
816 plip_id,
817 ptip_id,
818 ler_id,
819 person_id,
820 per_in_ler_id,
821 dpnt_othr_pl_cvrd_rl_flag,
822 prtn_ovridn_thru_dt,
823 pl_key_ee_flag,
824 pl_hghly_compd_flag,
825 elig_flag,
826 comp_ref_amt,
827 cmbn_age_n_los_val,
828 comp_ref_uom,
829 age_val,
830 los_val,
831 prtn_end_dt,
832 prtn_strt_dt,
833 wait_perd_cmpltn_dt,
834 wait_perd_strt_dt ,
835 wv_ctfn_typ_cd,
836 hrs_wkd_val,
837 hrs_wkd_bndry_perd_cd,
838 prtn_ovridn_flag,
839 no_mx_prtn_ovrid_thru_flag,
840 prtn_ovridn_rsn_cd,
841 age_uom,
842 los_uom,
843 ovrid_svc_dt,
844 inelg_rsn_cd,
845 frz_los_flag,
846 frz_age_flag,
847 frz_cmp_lvl_flag,
848 frz_pct_fl_tm_flag,
849 frz_hrs_wkd_flag,
850 frz_comb_age_and_los_flag,
851 dstr_rstcn_flag,
852 pct_fl_tm_val,
853 wv_prtn_rsn_cd,
854 pl_wvd_flag,
855 rt_comp_ref_amt,
856 rt_cmbn_age_n_los_val,
857 rt_comp_ref_uom,
858 rt_age_val,
859 rt_los_val,
860 rt_hrs_wkd_val,
861 rt_hrs_wkd_bndry_perd_cd,
862 rt_age_uom,
863 rt_los_uom,
864 rt_pct_fl_tm_val,
865 rt_frz_los_flag,
866 rt_frz_age_flag,
867 rt_frz_cmp_lvl_flag,
868 rt_frz_pct_fl_tm_flag,
869 rt_frz_hrs_wkd_flag,
870 rt_frz_comb_age_and_los_flag,
871 once_r_cntug_cd,
872 pep_attribute_category,
873 pep_attribute1,
874 pep_attribute2,
875 pep_attribute3,
876 pep_attribute4,
877 pep_attribute5,
878 pep_attribute6,
879 pep_attribute7,
880 pep_attribute8,
881 pep_attribute9,
882 pep_attribute10,
883 pep_attribute11,
884 pep_attribute12,
885 pep_attribute13,
886 pep_attribute14,
887 pep_attribute15,
888 pep_attribute16,
889 pep_attribute17,
890 pep_attribute18,
891 pep_attribute19,
892 pep_attribute20,
893 pep_attribute21,
894 pep_attribute22,
895 pep_attribute23,
896 pep_attribute24,
897 pep_attribute25,
898 pep_attribute26,
899 pep_attribute27,
900 pep_attribute28,
901 pep_attribute29,
902 pep_attribute30,
903 request_id,
904 program_application_id,
905 program_id,
906 program_update_date,
907 object_version_number,
908 created_by,
909 creation_date,
910 last_update_date,
911 last_updated_by,
912 last_update_login
913 )
914 Values
915 (
916 ben_elig_per_f_s.nextval,
917 l_effective_start_date,
918 l_effective_end_date,
919 p_business_group_id,
920 p_pl_id,
921 p_pgm_id,
922 p_plip_id,
923 p_ptip_id,
924 p_ler_id,
925 p_person_id,
926 p_per_in_ler_id,
927 p_dpnt_othr_pl_cvrd_rl_flag,
928 p_prtn_ovridn_thru_dt,
929 p_pl_key_ee_flag,
930 p_pl_hghly_compd_flag,
931 p_elig_flag,
932 p_comp_ref_amt,
933 p_cmbn_age_n_los_val,
934 p_comp_ref_uom,
935 p_age_val,
936 p_los_val,
937 p_prtn_end_dt,
938 p_prtn_strt_dt,
939 p_wait_perd_cmpltn_dt,
940 p_wait_perd_strt_dt ,
941 p_wv_ctfn_typ_cd,
942 p_hrs_wkd_val,
943 p_hrs_wkd_bndry_perd_cd,
944 p_prtn_ovridn_flag,
945 p_no_mx_prtn_ovrid_thru_flag,
946 p_prtn_ovridn_rsn_cd,
947 p_age_uom,
948 p_los_uom,
949 p_ovrid_svc_dt,
950 p_inelg_rsn_cd,
951 p_frz_los_flag,
952 p_frz_age_flag,
953 p_frz_cmp_lvl_flag,
954 p_frz_pct_fl_tm_flag,
955 p_frz_hrs_wkd_flag,
956 p_frz_comb_age_and_los_flag,
957 p_dstr_rstcn_flag,
958 p_pct_fl_tm_val,
959 p_wv_prtn_rsn_cd,
960 p_pl_wvd_flag,
961 p_rt_comp_ref_amt,
962 p_rt_cmbn_age_n_los_val,
963 p_rt_comp_ref_uom,
964 p_rt_age_val,
965 p_rt_los_val,
966 p_rt_hrs_wkd_val,
967 p_rt_hrs_wkd_bndry_perd_cd,
968 p_rt_age_uom,
969 p_rt_los_uom,
970 p_rt_pct_fl_tm_val,
971 p_rt_frz_los_flag,
972 p_rt_frz_age_flag,
973 p_rt_frz_cmp_lvl_flag,
974 p_rt_frz_pct_fl_tm_flag,
975 p_rt_frz_hrs_wkd_flag,
976 p_rt_frz_comb_age_and_los_flag,
977 p_once_r_cntug_cd,
978 p_pep_attribute_category,
979 p_pep_attribute1,
980 p_pep_attribute2,
981 p_pep_attribute3,
982 p_pep_attribute4,
983 p_pep_attribute5,
984 p_pep_attribute6,
985 p_pep_attribute7,
986 p_pep_attribute8,
987 p_pep_attribute9,
988 p_pep_attribute10,
989 p_pep_attribute11,
990 p_pep_attribute12,
991 p_pep_attribute13,
992 p_pep_attribute14,
993 p_pep_attribute15,
994 p_pep_attribute16,
995 p_pep_attribute17,
996 p_pep_attribute18,
997 p_pep_attribute19,
998 p_pep_attribute20,
999 p_pep_attribute21,
1000 p_pep_attribute22,
1001 p_pep_attribute23,
1002 p_pep_attribute24,
1003 p_pep_attribute25,
1004 p_pep_attribute26,
1005 p_pep_attribute27,
1006 p_pep_attribute28,
1007 p_pep_attribute29,
1008 p_pep_attribute30,
1009 p_request_id,
1010 p_program_application_id,
1011 p_program_id,
1012 p_program_update_date,
1013 l_object_version_number,
1014 l_created_by,
1015 l_creation_date,
1016 l_last_update_date,
1017 l_last_updated_by,
1018 l_last_update_login
1019 ) RETURNING elig_per_id into l_elig_per_id;
1020 hr_utility.set_location('Dn Insert: '||l_proc, 5);
1021 --
1022 ben_pep_shd.g_api_dml := false; -- Unset the api dml status
1023 --
1024 -- When in validation only mode raise the Validate_Enabled exception
1025 --
1026 if p_validate then
1027 raise hr_api.validate_enabled;
1028 end if;
1029 --
1030 -- Set all output arguments
1031 --
1032 p_elig_per_id := l_elig_per_id;
1033 p_effective_start_date := l_effective_start_date;
1034 p_effective_end_date := l_effective_end_date;
1035 p_object_version_number := l_object_version_number;
1036 --
1037 hr_utility.set_location(' Leaving:'||l_proc, 70);
1038 --
1039 exception
1040 --
1041 when hr_api.validate_enabled then
1042 --
1043 -- As the Validate_Enabled exception has been raised
1044 -- we must rollback to the savepoint
1045 --
1046 ROLLBACK TO create_perf_Eligible_Person;
1047 --
1048 -- Only set output warning arguments
1049 -- (Any key or derived arguments must be set to null
1050 -- when validation only mode is being used.)
1051 --
1052 p_elig_per_id := null;
1053 p_effective_start_date := null;
1054 p_effective_end_date := null;
1055 p_object_version_number := null;
1056 hr_utility.set_location(' Leaving:'||l_proc, 80);
1057 --
1058 when others then
1059 --
1060 -- A validation or unexpected error has occured
1061 --
1062 ROLLBACK TO create_perf_Eligible_Person;
1063 p_effective_start_date := null;
1064 p_effective_end_date := null;
1065 p_object_version_number := l_object_version_number;
1066
1067 raise;
1068 --
1069 end create_perf_Eligible_Person;
1070 --
1071 -- ----------------------------------------------------------------------------
1072 -- |------------------------< update_Eligible_Person >------------------------|
1073 -- ----------------------------------------------------------------------------
1074 --
1075 procedure update_Eligible_Person
1076 (p_validate in boolean default false
1077 ,p_elig_per_id in number
1078 ,p_effective_start_date out nocopy date
1079 ,p_effective_end_date out nocopy date
1080 ,p_business_group_id in number default hr_api.g_number
1081 ,p_pl_id in number default hr_api.g_number
1082 ,p_pgm_id in number default hr_api.g_number
1083 ,p_plip_id in number default hr_api.g_number
1084 ,p_ptip_id in number default hr_api.g_number
1085 ,p_ler_id in number default hr_api.g_number
1086 ,p_person_id in number default hr_api.g_number
1087 ,p_per_in_ler_id in number default hr_api.g_number
1088 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default hr_api.g_varchar2
1089 ,p_prtn_ovridn_thru_dt in date default hr_api.g_date
1090 ,p_pl_key_ee_flag in varchar2 default hr_api.g_varchar2
1091 ,p_pl_hghly_compd_flag in varchar2 default hr_api.g_varchar2
1092 ,p_elig_flag in varchar2 default hr_api.g_varchar2
1093 ,p_comp_ref_amt in number default hr_api.g_number
1094 ,p_cmbn_age_n_los_val in number default hr_api.g_number
1095 ,p_comp_ref_uom in varchar2 default hr_api.g_varchar2
1096 ,p_age_val in number default hr_api.g_number
1097 ,p_los_val in number default hr_api.g_number
1098 ,p_prtn_end_dt in date default hr_api.g_date
1099 ,p_prtn_strt_dt in date default hr_api.g_date
1100 ,p_wait_perd_cmpltn_dt in date default hr_api.g_date
1101 ,p_wait_perd_strt_dt in date default hr_api.g_date
1102 ,p_wv_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
1103 ,p_hrs_wkd_val in number default hr_api.g_number
1104 ,p_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
1105 ,p_prtn_ovridn_flag in varchar2 default hr_api.g_varchar2
1106 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default hr_api.g_varchar2
1107 ,p_prtn_ovridn_rsn_cd in varchar2 default hr_api.g_varchar2
1108 ,p_age_uom in varchar2 default hr_api.g_varchar2
1109 ,p_los_uom in varchar2 default hr_api.g_varchar2
1110 ,p_ovrid_svc_dt in date default hr_api.g_date
1111 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
1112 ,p_frz_los_flag in varchar2 default hr_api.g_varchar2
1113 ,p_frz_age_flag in varchar2 default hr_api.g_varchar2
1114 ,p_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
1115 ,p_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
1116 ,p_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
1117 ,p_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
1118 ,p_dstr_rstcn_flag in varchar2 default hr_api.g_varchar2
1119 ,p_pct_fl_tm_val in number default hr_api.g_number
1120 ,p_wv_prtn_rsn_cd in varchar2 default hr_api.g_varchar2
1121 ,p_pl_wvd_flag in varchar2 default hr_api.g_varchar2
1122 ,p_rt_comp_ref_amt in number default hr_api.g_number
1123 ,p_rt_cmbn_age_n_los_val in number default hr_api.g_number
1124 ,p_rt_comp_ref_uom in varchar2 default hr_api.g_varchar2
1125 ,p_rt_age_val in number default hr_api.g_number
1126 ,p_rt_los_val in number default hr_api.g_number
1127 ,p_rt_hrs_wkd_val in number default hr_api.g_number
1128 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
1129 ,p_rt_age_uom in varchar2 default hr_api.g_varchar2
1130 ,p_rt_los_uom in varchar2 default hr_api.g_varchar2
1131 ,p_rt_pct_fl_tm_val in number default hr_api.g_number
1132 ,p_rt_frz_los_flag in varchar2 default hr_api.g_varchar2
1133 ,p_rt_frz_age_flag in varchar2 default hr_api.g_varchar2
1134 ,p_rt_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
1135 ,p_rt_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
1136 ,p_rt_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
1137 ,p_rt_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
1138 ,p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2
1139 ,p_pl_ordr_num in number default hr_api.g_number
1140 ,p_plip_ordr_num in number default hr_api.g_number
1141 ,p_ptip_ordr_num in number default hr_api.g_number
1142 ,p_pep_attribute_category in varchar2 default hr_api.g_varchar2
1143 ,p_pep_attribute1 in varchar2 default hr_api.g_varchar2
1144 ,p_pep_attribute2 in varchar2 default hr_api.g_varchar2
1145 ,p_pep_attribute3 in varchar2 default hr_api.g_varchar2
1146 ,p_pep_attribute4 in varchar2 default hr_api.g_varchar2
1147 ,p_pep_attribute5 in varchar2 default hr_api.g_varchar2
1148 ,p_pep_attribute6 in varchar2 default hr_api.g_varchar2
1149 ,p_pep_attribute7 in varchar2 default hr_api.g_varchar2
1150 ,p_pep_attribute8 in varchar2 default hr_api.g_varchar2
1151 ,p_pep_attribute9 in varchar2 default hr_api.g_varchar2
1152 ,p_pep_attribute10 in varchar2 default hr_api.g_varchar2
1153 ,p_pep_attribute11 in varchar2 default hr_api.g_varchar2
1154 ,p_pep_attribute12 in varchar2 default hr_api.g_varchar2
1155 ,p_pep_attribute13 in varchar2 default hr_api.g_varchar2
1156 ,p_pep_attribute14 in varchar2 default hr_api.g_varchar2
1157 ,p_pep_attribute15 in varchar2 default hr_api.g_varchar2
1158 ,p_pep_attribute16 in varchar2 default hr_api.g_varchar2
1159 ,p_pep_attribute17 in varchar2 default hr_api.g_varchar2
1160 ,p_pep_attribute18 in varchar2 default hr_api.g_varchar2
1161 ,p_pep_attribute19 in varchar2 default hr_api.g_varchar2
1162 ,p_pep_attribute20 in varchar2 default hr_api.g_varchar2
1163 ,p_pep_attribute21 in varchar2 default hr_api.g_varchar2
1164 ,p_pep_attribute22 in varchar2 default hr_api.g_varchar2
1165 ,p_pep_attribute23 in varchar2 default hr_api.g_varchar2
1166 ,p_pep_attribute24 in varchar2 default hr_api.g_varchar2
1167 ,p_pep_attribute25 in varchar2 default hr_api.g_varchar2
1168 ,p_pep_attribute26 in varchar2 default hr_api.g_varchar2
1169 ,p_pep_attribute27 in varchar2 default hr_api.g_varchar2
1170 ,p_pep_attribute28 in varchar2 default hr_api.g_varchar2
1171 ,p_pep_attribute29 in varchar2 default hr_api.g_varchar2
1172 ,p_pep_attribute30 in varchar2 default hr_api.g_varchar2
1173 ,p_request_id in number default hr_api.g_number
1174 ,p_program_application_id in number default hr_api.g_number
1175 ,p_program_id in number default hr_api.g_number
1176 ,p_program_update_date in date default hr_api.g_date
1177 ,p_object_version_number in out nocopy number
1178 ,p_effective_date in date
1179 ,p_datetrack_mode in varchar2) is
1180 --
1181 -- Declare cursors and local variables
1182 --
1183 l_proc varchar2(72) := g_package||'update_Eligible_Person';
1184 l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1185 l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1186 l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1187 --
1188 begin
1189 --
1190 hr_utility.set_location('Entering:'|| l_proc, 10);
1191 --
1192 -- Issue a savepoint if operating in validation only mode
1193 --
1194 savepoint update_Eligible_Person;
1195 --
1196 hr_utility.set_location(l_proc, 20);
1197 --
1198 -- Process Logic
1199 --
1200 l_object_version_number := p_object_version_number;
1201 --
1202 begin
1203 --
1204 -- Start of API User Hook for the before hook of update_Eligible_Person
1205 --
1206 ben_Eligible_Person_bk2.update_Eligible_Person_b
1207 (p_elig_per_id => p_elig_per_id
1208 ,p_business_group_id => p_business_group_id
1209 ,p_pl_id => p_pl_id
1210 ,p_pgm_id => p_pgm_id
1211 ,p_plip_id => p_plip_id
1212 ,p_ptip_id => p_ptip_id
1213 ,p_ler_id => p_ler_id
1214 ,p_person_id => p_person_id
1215 ,p_per_in_ler_id => p_per_in_ler_id
1216 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
1217 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1218 ,p_pl_key_ee_flag => p_pl_key_ee_flag
1219 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
1220 ,p_elig_flag => p_elig_flag
1221 ,p_comp_ref_amt => p_comp_ref_amt
1222 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1223 ,p_comp_ref_uom => p_comp_ref_uom
1224 ,p_age_val => p_age_val
1225 ,p_los_val => p_los_val
1226 ,p_prtn_end_dt => p_prtn_end_dt
1227 ,p_prtn_strt_dt => p_prtn_strt_dt
1228 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
1229 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
1230 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
1231 ,p_hrs_wkd_val => p_hrs_wkd_val
1232 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1233 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1234 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1235 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1236 ,p_age_uom => p_age_uom
1237 ,p_los_uom => p_los_uom
1238 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1239 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1240 ,p_frz_los_flag => p_frz_los_flag
1241 ,p_frz_age_flag => p_frz_age_flag
1242 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1243 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1244 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1245 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1246 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
1247 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1248 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
1249 ,p_pl_wvd_flag => p_pl_wvd_flag
1250 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1251 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1252 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1253 ,p_rt_age_val => p_rt_age_val
1254 ,p_rt_los_val => p_rt_los_val
1255 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1256 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1257 ,p_rt_age_uom => p_rt_age_uom
1258 ,p_rt_los_uom => p_rt_los_uom
1259 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1260 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1261 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1262 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1263 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1264 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1265 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1266 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1267 ,p_pl_ordr_num => p_pl_ordr_num
1268 ,p_plip_ordr_num => p_plip_ordr_num
1269 ,p_ptip_ordr_num => p_ptip_ordr_num
1270 ,p_pep_attribute_category => p_pep_attribute_category
1271 ,p_pep_attribute1 => p_pep_attribute1
1272 ,p_pep_attribute2 => p_pep_attribute2
1273 ,p_pep_attribute3 => p_pep_attribute3
1274 ,p_pep_attribute4 => p_pep_attribute4
1275 ,p_pep_attribute5 => p_pep_attribute5
1276 ,p_pep_attribute6 => p_pep_attribute6
1277 ,p_pep_attribute7 => p_pep_attribute7
1278 ,p_pep_attribute8 => p_pep_attribute8
1279 ,p_pep_attribute9 => p_pep_attribute9
1280 ,p_pep_attribute10 => p_pep_attribute10
1281 ,p_pep_attribute11 => p_pep_attribute11
1282 ,p_pep_attribute12 => p_pep_attribute12
1283 ,p_pep_attribute13 => p_pep_attribute13
1284 ,p_pep_attribute14 => p_pep_attribute14
1285 ,p_pep_attribute15 => p_pep_attribute15
1286 ,p_pep_attribute16 => p_pep_attribute16
1287 ,p_pep_attribute17 => p_pep_attribute17
1288 ,p_pep_attribute18 => p_pep_attribute18
1289 ,p_pep_attribute19 => p_pep_attribute19
1290 ,p_pep_attribute20 => p_pep_attribute20
1291 ,p_pep_attribute21 => p_pep_attribute21
1292 ,p_pep_attribute22 => p_pep_attribute22
1293 ,p_pep_attribute23 => p_pep_attribute23
1294 ,p_pep_attribute24 => p_pep_attribute24
1295 ,p_pep_attribute25 => p_pep_attribute25
1296 ,p_pep_attribute26 => p_pep_attribute26
1297 ,p_pep_attribute27 => p_pep_attribute27
1298 ,p_pep_attribute28 => p_pep_attribute28
1299 ,p_pep_attribute29 => p_pep_attribute29
1300 ,p_pep_attribute30 => p_pep_attribute30
1301 ,p_request_id => p_request_id
1302 ,p_program_application_id => p_program_application_id
1303 ,p_program_id => p_program_id
1304 ,p_program_update_date => p_program_update_date
1305 ,p_object_version_number => p_object_version_number
1306 ,p_effective_date => trunc(p_effective_date)
1307 ,p_datetrack_mode => p_datetrack_mode);
1308 --
1309 exception
1310 --
1311 when hr_api.cannot_find_prog_unit then
1312 --
1313 hr_api.cannot_find_prog_unit_error
1314 (p_module_name => 'UPDATE_Eligible_Person'
1315 ,p_hook_type => 'BP');
1316 --
1317 -- End of API User Hook for the before hook of update_Eligible_Person
1318 --
1319 end;
1320 --
1321 ben_pep_upd.upd
1322 (p_elig_per_id => p_elig_per_id
1323 ,p_effective_start_date => l_effective_start_date
1324 ,p_effective_end_date => l_effective_end_date
1325 ,p_business_group_id => p_business_group_id
1326 ,p_pl_id => p_pl_id
1327 ,p_pgm_id => p_pgm_id
1328 ,p_plip_id => p_plip_id
1329 ,p_ptip_id => p_ptip_id
1330 ,p_ler_id => p_ler_id
1331 ,p_person_id => p_person_id
1332 ,p_per_in_ler_id => p_per_in_ler_id
1333 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
1334 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1335 ,p_pl_key_ee_flag => p_pl_key_ee_flag
1336 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
1337 ,p_elig_flag => p_elig_flag
1338 ,p_comp_ref_amt => p_comp_ref_amt
1339 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1340 ,p_comp_ref_uom => p_comp_ref_uom
1341 ,p_age_val => p_age_val
1342 ,p_los_val => p_los_val
1343 ,p_prtn_end_dt => p_prtn_end_dt
1344 ,p_prtn_strt_dt => p_prtn_strt_dt
1345 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
1346 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
1347 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
1348 ,p_hrs_wkd_val => p_hrs_wkd_val
1349 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1350 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1351 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1352 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1353 ,p_age_uom => p_age_uom
1354 ,p_los_uom => p_los_uom
1355 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1356 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1357 ,p_frz_los_flag => p_frz_los_flag
1358 ,p_frz_age_flag => p_frz_age_flag
1359 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1360 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1361 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1362 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1363 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
1364 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1365 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
1366 ,p_pl_wvd_flag => p_pl_wvd_flag
1367 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1368 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1369 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1370 ,p_rt_age_val => p_rt_age_val
1371 ,p_rt_los_val => p_rt_los_val
1372 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1373 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1374 ,p_rt_age_uom => p_rt_age_uom
1375 ,p_rt_los_uom => p_rt_los_uom
1376 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1377 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1378 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1379 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1380 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1381 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1382 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1383 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1384 ,p_pl_ordr_num => p_pl_ordr_num
1385 ,p_plip_ordr_num => p_plip_ordr_num
1386 ,p_ptip_ordr_num => p_ptip_ordr_num
1387 ,p_pep_attribute_category => p_pep_attribute_category
1388 ,p_pep_attribute1 => p_pep_attribute1
1389 ,p_pep_attribute2 => p_pep_attribute2
1390 ,p_pep_attribute3 => p_pep_attribute3
1391 ,p_pep_attribute4 => p_pep_attribute4
1392 ,p_pep_attribute5 => p_pep_attribute5
1393 ,p_pep_attribute6 => p_pep_attribute6
1394 ,p_pep_attribute7 => p_pep_attribute7
1395 ,p_pep_attribute8 => p_pep_attribute8
1396 ,p_pep_attribute9 => p_pep_attribute9
1397 ,p_pep_attribute10 => p_pep_attribute10
1398 ,p_pep_attribute11 => p_pep_attribute11
1399 ,p_pep_attribute12 => p_pep_attribute12
1400 ,p_pep_attribute13 => p_pep_attribute13
1401 ,p_pep_attribute14 => p_pep_attribute14
1402 ,p_pep_attribute15 => p_pep_attribute15
1403 ,p_pep_attribute16 => p_pep_attribute16
1404 ,p_pep_attribute17 => p_pep_attribute17
1405 ,p_pep_attribute18 => p_pep_attribute18
1406 ,p_pep_attribute19 => p_pep_attribute19
1407 ,p_pep_attribute20 => p_pep_attribute20
1408 ,p_pep_attribute21 => p_pep_attribute21
1409 ,p_pep_attribute22 => p_pep_attribute22
1410 ,p_pep_attribute23 => p_pep_attribute23
1411 ,p_pep_attribute24 => p_pep_attribute24
1412 ,p_pep_attribute25 => p_pep_attribute25
1413 ,p_pep_attribute26 => p_pep_attribute26
1414 ,p_pep_attribute27 => p_pep_attribute27
1415 ,p_pep_attribute28 => p_pep_attribute28
1416 ,p_pep_attribute29 => p_pep_attribute29
1417 ,p_pep_attribute30 => p_pep_attribute30
1418 ,p_request_id => p_request_id
1419 ,p_program_application_id => p_program_application_id
1420 ,p_program_id => p_program_id
1421 ,p_program_update_date => p_program_update_date
1422 ,p_object_version_number => l_object_version_number
1423 ,p_effective_date => trunc(p_effective_date)
1424 ,p_datetrack_mode => p_datetrack_mode);
1425 --
1426 begin
1427 --
1428 -- Start of API User Hook for the after hook of update_Eligible_Person
1429 --
1430 ben_Eligible_Person_bk2.update_Eligible_Person_a
1431 (p_elig_per_id => p_elig_per_id
1432 ,p_effective_start_date => l_effective_start_date
1433 ,p_effective_end_date => l_effective_end_date
1434 ,p_business_group_id => p_business_group_id
1435 ,p_pl_id => p_pl_id
1436 ,p_pgm_id => p_pgm_id
1437 ,p_plip_id => p_plip_id
1438 ,p_ptip_id => p_ptip_id
1439 ,p_ler_id => p_ler_id
1440 ,p_person_id => p_person_id
1441 ,p_per_in_ler_id => p_per_in_ler_id
1442 ,p_dpnt_othr_pl_cvrd_rl_flag => p_dpnt_othr_pl_cvrd_rl_flag
1443 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1444 ,p_pl_key_ee_flag => p_pl_key_ee_flag
1445 ,p_pl_hghly_compd_flag => p_pl_hghly_compd_flag
1446 ,p_elig_flag => p_elig_flag
1447 ,p_comp_ref_amt => p_comp_ref_amt
1448 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1449 ,p_comp_ref_uom => p_comp_ref_uom
1450 ,p_age_val => p_age_val
1451 ,p_los_val => p_los_val
1452 ,p_prtn_end_dt => p_prtn_end_dt
1453 ,p_prtn_strt_dt => p_prtn_strt_dt
1454 ,p_wait_perd_cmpltn_dt => p_wait_perd_cmpltn_dt
1455 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
1456 ,p_wv_ctfn_typ_cd => p_wv_ctfn_typ_cd
1457 ,p_hrs_wkd_val => p_hrs_wkd_val
1458 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1459 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1460 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1461 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1462 ,p_age_uom => p_age_uom
1463 ,p_los_uom => p_los_uom
1464 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1465 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1466 ,p_frz_los_flag => p_frz_los_flag
1467 ,p_frz_age_flag => p_frz_age_flag
1468 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1469 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1470 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1471 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1472 ,p_dstr_rstcn_flag => p_dstr_rstcn_flag
1473 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1474 ,p_wv_prtn_rsn_cd => p_wv_prtn_rsn_cd
1475 ,p_pl_wvd_flag => p_pl_wvd_flag
1476 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1477 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1478 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1479 ,p_rt_age_val => p_rt_age_val
1480 ,p_rt_los_val => p_rt_los_val
1481 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1482 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1483 ,p_rt_age_uom => p_rt_age_uom
1484 ,p_rt_los_uom => p_rt_los_uom
1485 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1486 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1487 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1488 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1489 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1490 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1491 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1492 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1493 ,p_pl_ordr_num => p_pl_ordr_num
1494 ,p_plip_ordr_num => p_plip_ordr_num
1495 ,p_ptip_ordr_num => p_ptip_ordr_num
1496 ,p_pep_attribute_category => p_pep_attribute_category
1497 ,p_pep_attribute1 => p_pep_attribute1
1498 ,p_pep_attribute2 => p_pep_attribute2
1499 ,p_pep_attribute3 => p_pep_attribute3
1500 ,p_pep_attribute4 => p_pep_attribute4
1501 ,p_pep_attribute5 => p_pep_attribute5
1502 ,p_pep_attribute6 => p_pep_attribute6
1503 ,p_pep_attribute7 => p_pep_attribute7
1504 ,p_pep_attribute8 => p_pep_attribute8
1505 ,p_pep_attribute9 => p_pep_attribute9
1506 ,p_pep_attribute10 => p_pep_attribute10
1507 ,p_pep_attribute11 => p_pep_attribute11
1508 ,p_pep_attribute12 => p_pep_attribute12
1509 ,p_pep_attribute13 => p_pep_attribute13
1510 ,p_pep_attribute14 => p_pep_attribute14
1511 ,p_pep_attribute15 => p_pep_attribute15
1512 ,p_pep_attribute16 => p_pep_attribute16
1513 ,p_pep_attribute17 => p_pep_attribute17
1514 ,p_pep_attribute18 => p_pep_attribute18
1515 ,p_pep_attribute19 => p_pep_attribute19
1516 ,p_pep_attribute20 => p_pep_attribute20
1517 ,p_pep_attribute21 => p_pep_attribute21
1518 ,p_pep_attribute22 => p_pep_attribute22
1519 ,p_pep_attribute23 => p_pep_attribute23
1520 ,p_pep_attribute24 => p_pep_attribute24
1521 ,p_pep_attribute25 => p_pep_attribute25
1522 ,p_pep_attribute26 => p_pep_attribute26
1523 ,p_pep_attribute27 => p_pep_attribute27
1524 ,p_pep_attribute28 => p_pep_attribute28
1525 ,p_pep_attribute29 => p_pep_attribute29
1526 ,p_pep_attribute30 => p_pep_attribute30
1527 ,p_request_id => p_request_id
1528 ,p_program_application_id => p_program_application_id
1529 ,p_program_id => p_program_id
1530 ,p_program_update_date => p_program_update_date
1531 ,p_object_version_number => l_object_version_number
1532 ,p_effective_date => trunc(p_effective_date)
1533 ,p_datetrack_mode => p_datetrack_mode);
1534 --
1535 exception
1536 --
1537 when hr_api.cannot_find_prog_unit then
1538 --
1539 hr_api.cannot_find_prog_unit_error
1540 (p_module_name => 'UPDATE_Eligible_Person'
1541 ,p_hook_type => 'AP');
1542 --
1543 -- End of API User Hook for the after hook of update_Eligible_Person
1544 --
1545 end;
1546 --
1547 hr_utility.set_location(l_proc, 60);
1548 --
1549 -- When in validation only mode raise the Validate_Enabled exception
1550 --
1551 if p_validate then
1552 raise hr_api.validate_enabled;
1553 end if;
1554 --
1555 -- Set all output arguments
1556 --
1557 p_object_version_number := l_object_version_number;
1558 p_effective_start_date := l_effective_start_date;
1559 p_effective_end_date := l_effective_end_date;
1560 --
1561 hr_utility.set_location(' Leaving:'||l_proc, 70);
1562 --
1563 exception
1564 --
1565 when hr_api.validate_enabled then
1566 --
1567 -- As the Validate_Enabled exception has been raised
1568 -- we must rollback to the savepoint
1569 --
1570 ROLLBACK TO update_Eligible_Person;
1571 --
1572 -- Only set output warning arguments
1573 -- (Any key or derived arguments must be set to null
1574 -- when validation only mode is being used.)
1575 --
1576 hr_utility.set_location(' Leaving:'||l_proc, 80);
1577 --
1578 when others then
1579 --
1580 -- A validation or unexpected error has occured
1581 --
1582 ROLLBACK TO update_Eligible_Person;
1583 p_effective_start_date := null;
1584 p_effective_end_date := null;
1585 p_object_version_number := l_object_version_number;
1586 raise;
1587 --
1588 end update_Eligible_Person;
1589 -- ----------------------------------------------------------------------------
1590 -- |--------------------------< delete_Eligible_Person >----------------------|
1591 -- ----------------------------------------------------------------------------
1592 --
1593 procedure delete_Eligible_Person
1594 (p_validate in boolean default false
1595 ,p_elig_per_id in number
1596 ,p_effective_start_date out nocopy date
1597 ,p_effective_end_date out nocopy date
1598 ,p_object_version_number in out nocopy number
1599 ,p_effective_date in date
1600 ,p_datetrack_mode in varchar2) is
1601 --
1602 -- Declare cursors and local variables
1603 --
1604 l_proc varchar2(72) := g_package||'update_Eligible_Person';
1605 l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1606 l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1607 l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1608 --
1609 begin
1610 --
1611 hr_utility.set_location('Entering:'|| l_proc, 10);
1612 --
1613 -- Issue a savepoint if operating in validation only mode
1614 --
1615 savepoint delete_Eligible_Person;
1616 --
1617 hr_utility.set_location(l_proc, 20);
1618 --
1619 -- Process Logic
1620 --
1621 l_object_version_number := p_object_version_number;
1622 --
1623 --
1624 begin
1625 --
1626 -- Start of API User Hook for the before hook of delete_Eligible_Person
1627 --
1628 ben_Eligible_Person_bk3.delete_Eligible_Person_b
1629 (p_elig_per_id => p_elig_per_id
1630 ,p_object_version_number => p_object_version_number
1631 ,p_effective_date => trunc(p_effective_date)
1632 ,p_datetrack_mode => p_datetrack_mode);
1633 --
1634 exception
1635 --
1636 when hr_api.cannot_find_prog_unit then
1637 --
1638 hr_api.cannot_find_prog_unit_error
1639 (p_module_name => 'DELETE_Eligible_Person'
1640 ,p_hook_type => 'BP');
1641 --
1642 -- End of API User Hook for the before hook of delete_Eligible_Person
1643 --
1644 end;
1645 --
1646 ben_pep_del.del
1647 (p_elig_per_id => p_elig_per_id
1648 ,p_effective_start_date => l_effective_start_date
1649 ,p_effective_end_date => l_effective_end_date
1650 ,p_object_version_number => l_object_version_number
1651 ,p_effective_date => p_effective_date
1652 ,p_datetrack_mode => p_datetrack_mode);
1653 --
1654 begin
1655 --
1656 -- Start of API User Hook for the after hook of delete_Eligible_Person
1657 --
1658 ben_Eligible_Person_bk3.delete_Eligible_Person_a
1659 (p_elig_per_id => p_elig_per_id
1660 ,p_effective_start_date => l_effective_start_date
1661 ,p_effective_end_date => l_effective_end_date
1662 ,p_object_version_number => l_object_version_number
1663 ,p_effective_date => trunc(p_effective_date)
1664 ,p_datetrack_mode => p_datetrack_mode);
1665 --
1666 exception
1667 --
1668 when hr_api.cannot_find_prog_unit then
1669 --
1670 hr_api.cannot_find_prog_unit_error
1671 (p_module_name => 'DELETE_Eligible_Person'
1672 ,p_hook_type => 'AP');
1673 --
1674 -- End of API User Hook for the after hook of delete_Eligible_Person
1675 --
1676 end;
1677 --
1678 hr_utility.set_location(l_proc, 60);
1679 --
1680 -- When in validation only mode raise the Validate_Enabled exception
1681 --
1682 if p_validate then
1683 raise hr_api.validate_enabled;
1684 end if;
1685 --
1686 hr_utility.set_location(' Leaving:'||l_proc, 70);
1687 --
1688 exception
1689 --
1690 when hr_api.validate_enabled then
1691 --
1692 -- As the Validate_Enabled exception has been raised
1693 -- we must rollback to the savepoint
1694 --
1695 ROLLBACK TO delete_Eligible_Person;
1696 --
1697 -- Only set output warning arguments
1698 -- (Any key or derived arguments must be set to null
1699 -- when validation only mode is being used.)
1700 --
1701 p_effective_start_date := null;
1702 p_effective_end_date := null;
1703 --
1704 when others then
1705 --
1706 -- A validation or unexpected error has occured
1707 --
1708 ROLLBACK TO delete_Eligible_Person;
1709 p_effective_start_date := null;
1710 p_effective_end_date := null;
1711 p_object_version_number := l_object_version_number;
1712
1713 raise;
1714 --
1715 end delete_Eligible_Person;
1716 --
1717 -- ----------------------------------------------------------------------------
1718 -- |-------------------------------< lck >------------------------------------|
1719 -- ----------------------------------------------------------------------------
1720 --
1721 procedure lck
1722 (p_elig_per_id in number
1723 ,p_object_version_number in number
1724 ,p_effective_date in date
1725 ,p_datetrack_mode in varchar2
1726 ,p_validation_start_date out nocopy date
1727 ,p_validation_end_date out nocopy date) is
1728 --
1729 --
1730 -- Declare cursors and local variables
1731 --
1732 l_proc varchar2(72) := g_package||'lck';
1733 l_validation_start_date date;
1734 l_validation_end_date date;
1735 --
1736 begin
1737 --
1738 hr_utility.set_location('Entering:'|| l_proc, 10);
1739 --
1740 ben_pep_shd.lck
1741 (p_elig_per_id => p_elig_per_id
1742 ,p_validation_start_date => l_validation_start_date
1743 ,p_validation_end_date => l_validation_end_date
1744 ,p_object_version_number => p_object_version_number
1745 ,p_effective_date => p_effective_date
1746 ,p_datetrack_mode => p_datetrack_mode);
1747 --
1748 hr_utility.set_location(' Leaving:'||l_proc, 70);
1749 --
1750 end lck;
1751 --
1752 end ben_Eligible_Person_api;