[Home] [Help]
PACKAGE BODY: APPS.BEN_ELIG_PERSON_OPTION_API
Source
4 -- Package Variables
1 Package Body ben_Elig_Person_Option_api as
2 /* $Header: beepoapi.pkb 120.0 2005/05/28 02:41:54 appldev noship $ */
3 --
5 --
6 g_package varchar2(33) := ' ben_Elig_Person_Option_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_Elig_Person_Option >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Elig_Person_Option
13 (
14 p_validate in boolean default false
15 ,p_elig_per_opt_id out nocopy number
16 ,p_elig_per_id in number default null
17 ,p_effective_start_date out nocopy date
18 ,p_effective_end_date out nocopy date
19 ,p_prtn_ovridn_flag in varchar2 default null
20 ,p_prtn_ovridn_thru_dt in date default null
21 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default null
22 ,p_elig_flag in varchar2 default null
23 ,p_prtn_strt_dt in date default null
24 ,p_prtn_end_dt in date default null
25 ,p_wait_perd_cmpltn_date in date default null
26 ,p_wait_perd_strt_dt in date default null
27 ,p_prtn_ovridn_rsn_cd in varchar2 default null
28 ,p_pct_fl_tm_val in number default null
29 ,p_opt_id in number default null
30 ,p_per_in_ler_id in number default null
31 ,p_rt_comp_ref_amt in number default null
32 ,p_rt_cmbn_age_n_los_val in number default null
33 ,p_rt_comp_ref_uom in varchar2 default null
34 ,p_rt_age_val in number default null
38 ,p_rt_age_uom in varchar2 default null
35 ,p_rt_los_val in number default null
36 ,p_rt_hrs_wkd_val in number default null
37 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
39 ,p_rt_los_uom in varchar2 default null
40 ,p_rt_pct_fl_tm_val in number default null
41 ,p_rt_frz_los_flag in varchar2 default 'N'
42 ,p_rt_frz_age_flag in varchar2 default 'N'
43 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
44 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
45 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
46 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
47 ,p_comp_ref_amt in number default null
48 ,p_cmbn_age_n_los_val in number default null
49 ,p_comp_ref_uom in varchar2 default null
50 ,p_age_val in number default null
51 ,p_los_val in number default null
52 ,p_hrs_wkd_val in number default null
53 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
54 ,p_age_uom in varchar2 default null
55 ,p_los_uom in varchar2 default null
56 ,p_frz_los_flag in varchar2 default 'N'
57 ,p_frz_age_flag in varchar2 default 'N'
58 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
59 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
60 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
61 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
62 ,p_ovrid_svc_dt in date default null
63 ,p_inelg_rsn_cd in varchar2 default null
64 ,p_once_r_cntug_cd in varchar2 default null
65 ,p_oipl_ordr_num in number default null
66 ,p_business_group_id in number default null
67 ,p_epo_attribute_category in varchar2 default null
68 ,p_epo_attribute1 in varchar2 default null
69 ,p_epo_attribute2 in varchar2 default null
70 ,p_epo_attribute3 in varchar2 default null
71 ,p_epo_attribute4 in varchar2 default null
72 ,p_epo_attribute5 in varchar2 default null
73 ,p_epo_attribute6 in varchar2 default null
74 ,p_epo_attribute7 in varchar2 default null
75 ,p_epo_attribute8 in varchar2 default null
76 ,p_epo_attribute9 in varchar2 default null
77 ,p_epo_attribute10 in varchar2 default null
78 ,p_epo_attribute11 in varchar2 default null
79 ,p_epo_attribute12 in varchar2 default null
80 ,p_epo_attribute13 in varchar2 default null
81 ,p_epo_attribute14 in varchar2 default null
82 ,p_epo_attribute15 in varchar2 default null
83 ,p_epo_attribute16 in varchar2 default null
84 ,p_epo_attribute17 in varchar2 default null
85 ,p_epo_attribute18 in varchar2 default null
86 ,p_epo_attribute19 in varchar2 default null
87 ,p_epo_attribute20 in varchar2 default null
88 ,p_epo_attribute21 in varchar2 default null
89 ,p_epo_attribute22 in varchar2 default null
90 ,p_epo_attribute23 in varchar2 default null
91 ,p_epo_attribute24 in varchar2 default null
92 ,p_epo_attribute25 in varchar2 default null
93 ,p_epo_attribute26 in varchar2 default null
94 ,p_epo_attribute27 in varchar2 default null
95 ,p_epo_attribute28 in varchar2 default null
96 ,p_epo_attribute29 in varchar2 default null
97 ,p_epo_attribute30 in varchar2 default null
98 ,p_request_id in number default null
99 ,p_program_application_id in number default null
100 ,p_program_id in number default null
101 ,p_program_update_date in date default null
102 ,p_object_version_number out nocopy number
103 ,p_effective_date in date
104 ,p_override_validation in boolean default false
105 )
106 is
107 --
108 -- Declare cursors and local variables
109 --
110 l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
111 l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
112 l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
113 l_proc varchar2(72) := g_package||'create_Elig_Person_Option';
114 l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
115 --
116 begin
117 --
118 hr_utility.set_location('Entering:'|| l_proc, 10);
119 --
120 -- Issue a savepoint if operating in validation only mode
121 --
122 savepoint create_Elig_Person_Option;
123 --
124 hr_utility.set_location(l_proc, 20);
125 --
126 -- Process Logic
127 --
128 begin
129 --
130 -- Start of API User Hook for the before hook of create_Elig_Person_Option
131 --
132 ben_Elig_Person_Option_bk1.create_Elig_Person_Option_b
133 (
134 p_elig_per_id => p_elig_per_id
135 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
136 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
137 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
138 ,p_elig_flag => p_elig_flag
139 ,p_prtn_strt_dt => p_prtn_strt_dt
143 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
140 ,p_prtn_end_dt => p_prtn_end_dt
141 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
142 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
144 ,p_pct_fl_tm_val => p_pct_fl_tm_val
145 ,p_opt_id => p_opt_id
146 ,p_per_in_ler_id => p_per_in_ler_id
147 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
148 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
149 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
150 ,p_rt_age_val => p_rt_age_val
151 ,p_rt_los_val => p_rt_los_val
152 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
153 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
154 ,p_rt_age_uom => p_rt_age_uom
155 ,p_rt_los_uom => p_rt_los_uom
156 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
157 ,p_rt_frz_los_flag => p_rt_frz_los_flag
158 ,p_rt_frz_age_flag => p_rt_frz_age_flag
159 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
160 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
161 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
162 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
163 ,p_comp_ref_amt => p_comp_ref_amt
164 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
165 ,p_comp_ref_uom => p_comp_ref_uom
166 ,p_age_val => p_age_val
167 ,p_los_val => p_los_val
168 ,p_hrs_wkd_val => p_hrs_wkd_val
169 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
170 ,p_age_uom => p_age_uom
171 ,p_los_uom => p_los_uom
172 ,p_frz_los_flag => p_frz_los_flag
173 ,p_frz_age_flag => p_frz_age_flag
174 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
175 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
176 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
177 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
178 ,p_ovrid_svc_dt => p_ovrid_svc_dt
179 ,p_inelg_rsn_cd => p_inelg_rsn_cd
180 ,p_once_r_cntug_cd => p_once_r_cntug_cd
181 ,p_oipl_ordr_num => p_oipl_ordr_num
182 ,p_business_group_id => p_business_group_id
183 ,p_epo_attribute_category => p_epo_attribute_category
184 ,p_epo_attribute1 => p_epo_attribute1
185 ,p_epo_attribute2 => p_epo_attribute2
186 ,p_epo_attribute3 => p_epo_attribute3
187 ,p_epo_attribute4 => p_epo_attribute4
188 ,p_epo_attribute5 => p_epo_attribute5
189 ,p_epo_attribute6 => p_epo_attribute6
190 ,p_epo_attribute7 => p_epo_attribute7
191 ,p_epo_attribute8 => p_epo_attribute8
192 ,p_epo_attribute9 => p_epo_attribute9
193 ,p_epo_attribute10 => p_epo_attribute10
194 ,p_epo_attribute11 => p_epo_attribute11
195 ,p_epo_attribute12 => p_epo_attribute12
196 ,p_epo_attribute13 => p_epo_attribute13
197 ,p_epo_attribute14 => p_epo_attribute14
198 ,p_epo_attribute15 => p_epo_attribute15
199 ,p_epo_attribute16 => p_epo_attribute16
200 ,p_epo_attribute17 => p_epo_attribute17
201 ,p_epo_attribute18 => p_epo_attribute18
202 ,p_epo_attribute19 => p_epo_attribute19
203 ,p_epo_attribute20 => p_epo_attribute20
204 ,p_epo_attribute21 => p_epo_attribute21
205 ,p_epo_attribute22 => p_epo_attribute22
206 ,p_epo_attribute23 => p_epo_attribute23
207 ,p_epo_attribute24 => p_epo_attribute24
208 ,p_epo_attribute25 => p_epo_attribute25
209 ,p_epo_attribute26 => p_epo_attribute26
210 ,p_epo_attribute27 => p_epo_attribute27
211 ,p_epo_attribute28 => p_epo_attribute28
212 ,p_epo_attribute29 => p_epo_attribute29
213 ,p_epo_attribute30 => p_epo_attribute30
214 ,p_request_id => p_request_id
215 ,p_program_application_id => p_program_application_id
216 ,p_program_id => p_program_id
217 ,p_program_update_date => p_program_update_date
218 ,p_effective_date => trunc(p_effective_date)
219 );
220 exception
221 when hr_api.cannot_find_prog_unit then
222 hr_api.cannot_find_prog_unit_error
223 (
224 p_module_name => 'CREATE_Elig_Person_Option'
225 ,p_hook_type => 'BP'
226 );
227 --
228 -- End of API User Hook for the before hook of create_Elig_Person_Option
229 --
230 end;
231 --
232 ben_epo_ins.ins
233 (
234 p_elig_per_opt_id => l_elig_per_opt_id
235 ,p_elig_per_id => p_elig_per_id
236 ,p_effective_start_date => l_effective_start_date
237 ,p_effective_end_date => l_effective_end_date
238 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
242 ,p_prtn_strt_dt => p_prtn_strt_dt
239 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
240 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
241 ,p_elig_flag => p_elig_flag
243 ,p_prtn_end_dt => p_prtn_end_dt
244 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
245 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
246 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
247 ,p_pct_fl_tm_val => p_pct_fl_tm_val
248 ,p_opt_id => p_opt_id
249 ,p_per_in_ler_id => p_per_in_ler_id
250 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
251 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
252 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
253 ,p_rt_age_val => p_rt_age_val
254 ,p_rt_los_val => p_rt_los_val
255 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
256 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
257 ,p_rt_age_uom => p_rt_age_uom
258 ,p_rt_los_uom => p_rt_los_uom
259 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
260 ,p_rt_frz_los_flag => p_rt_frz_los_flag
261 ,p_rt_frz_age_flag => p_rt_frz_age_flag
262 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
263 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
264 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
265 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
266 ,p_comp_ref_amt => p_comp_ref_amt
267 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
268 ,p_comp_ref_uom => p_comp_ref_uom
269 ,p_age_val => p_age_val
270 ,p_los_val => p_los_val
271 ,p_hrs_wkd_val => p_hrs_wkd_val
272 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
273 ,p_age_uom => p_age_uom
274 ,p_los_uom => p_los_uom
275 ,p_frz_los_flag => p_frz_los_flag
276 ,p_frz_age_flag => p_frz_age_flag
277 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
278 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
279 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
280 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
281 ,p_ovrid_svc_dt => p_ovrid_svc_dt
282 ,p_inelg_rsn_cd => p_inelg_rsn_cd
283 ,p_once_r_cntug_cd => p_once_r_cntug_cd
284 ,p_oipl_ordr_num => p_oipl_ordr_num
285 ,p_business_group_id => p_business_group_id
286 ,p_epo_attribute_category => p_epo_attribute_category
287 ,p_epo_attribute1 => p_epo_attribute1
288 ,p_epo_attribute2 => p_epo_attribute2
289 ,p_epo_attribute3 => p_epo_attribute3
290 ,p_epo_attribute4 => p_epo_attribute4
291 ,p_epo_attribute5 => p_epo_attribute5
292 ,p_epo_attribute6 => p_epo_attribute6
293 ,p_epo_attribute7 => p_epo_attribute7
294 ,p_epo_attribute8 => p_epo_attribute8
295 ,p_epo_attribute9 => p_epo_attribute9
296 ,p_epo_attribute10 => p_epo_attribute10
297 ,p_epo_attribute11 => p_epo_attribute11
298 ,p_epo_attribute12 => p_epo_attribute12
299 ,p_epo_attribute13 => p_epo_attribute13
300 ,p_epo_attribute14 => p_epo_attribute14
301 ,p_epo_attribute15 => p_epo_attribute15
302 ,p_epo_attribute16 => p_epo_attribute16
303 ,p_epo_attribute17 => p_epo_attribute17
304 ,p_epo_attribute18 => p_epo_attribute18
305 ,p_epo_attribute19 => p_epo_attribute19
306 ,p_epo_attribute20 => p_epo_attribute20
307 ,p_epo_attribute21 => p_epo_attribute21
308 ,p_epo_attribute22 => p_epo_attribute22
309 ,p_epo_attribute23 => p_epo_attribute23
310 ,p_epo_attribute24 => p_epo_attribute24
311 ,p_epo_attribute25 => p_epo_attribute25
312 ,p_epo_attribute26 => p_epo_attribute26
313 ,p_epo_attribute27 => p_epo_attribute27
314 ,p_epo_attribute28 => p_epo_attribute28
315 ,p_epo_attribute29 => p_epo_attribute29
316 ,p_epo_attribute30 => p_epo_attribute30
317 ,p_request_id => p_request_id
318 ,p_program_application_id => p_program_application_id
319 ,p_program_id => p_program_id
320 ,p_program_update_date => p_program_update_date
321 ,p_object_version_number => l_object_version_number
322 ,p_effective_date => trunc(p_effective_date)
323 ,p_override_validation => p_override_validation
324 );
325 --
326 begin
327 --
328 -- Start of API User Hook for the after hook of create_Elig_Person_Option
329 --
330 ben_Elig_Person_Option_bk1.create_Elig_Person_Option_a
331 (
332 p_elig_per_opt_id => l_elig_per_opt_id
333 ,p_elig_per_id => p_elig_per_id
334 ,p_effective_start_date => l_effective_start_date
335 ,p_effective_end_date => l_effective_end_date
336 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
337 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
338 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
339 ,p_elig_flag => p_elig_flag
340 ,p_prtn_strt_dt => p_prtn_strt_dt
344 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
341 ,p_prtn_end_dt => p_prtn_end_dt
342 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
343 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
345 ,p_pct_fl_tm_val => p_pct_fl_tm_val
346 ,p_opt_id => p_opt_id
347 ,p_per_in_ler_id => p_per_in_ler_id
348 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
349 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
350 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
351 ,p_rt_age_val => p_rt_age_val
352 ,p_rt_los_val => p_rt_los_val
353 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
354 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
355 ,p_rt_age_uom => p_rt_age_uom
356 ,p_rt_los_uom => p_rt_los_uom
357 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
358 ,p_rt_frz_los_flag => p_rt_frz_los_flag
359 ,p_rt_frz_age_flag => p_rt_frz_age_flag
360 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
361 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
362 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
363 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
364 ,p_comp_ref_amt => p_comp_ref_amt
365 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
366 ,p_comp_ref_uom => p_comp_ref_uom
367 ,p_age_val => p_age_val
368 ,p_los_val => p_los_val
369 ,p_hrs_wkd_val => p_hrs_wkd_val
370 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
371 ,p_age_uom => p_age_uom
372 ,p_los_uom => p_los_uom
373 ,p_frz_los_flag => p_frz_los_flag
374 ,p_frz_age_flag => p_frz_age_flag
375 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
376 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
377 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
378 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
379 ,p_ovrid_svc_dt => p_ovrid_svc_dt
380 ,p_inelg_rsn_cd => p_inelg_rsn_cd
381 ,p_once_r_cntug_cd => p_once_r_cntug_cd
382 ,p_oipl_ordr_num => p_oipl_ordr_num
383 ,p_business_group_id => p_business_group_id
384 ,p_epo_attribute_category => p_epo_attribute_category
385 ,p_epo_attribute1 => p_epo_attribute1
386 ,p_epo_attribute2 => p_epo_attribute2
387 ,p_epo_attribute3 => p_epo_attribute3
388 ,p_epo_attribute4 => p_epo_attribute4
389 ,p_epo_attribute5 => p_epo_attribute5
390 ,p_epo_attribute6 => p_epo_attribute6
391 ,p_epo_attribute7 => p_epo_attribute7
392 ,p_epo_attribute8 => p_epo_attribute8
393 ,p_epo_attribute9 => p_epo_attribute9
394 ,p_epo_attribute10 => p_epo_attribute10
395 ,p_epo_attribute11 => p_epo_attribute11
396 ,p_epo_attribute12 => p_epo_attribute12
397 ,p_epo_attribute13 => p_epo_attribute13
398 ,p_epo_attribute14 => p_epo_attribute14
399 ,p_epo_attribute15 => p_epo_attribute15
400 ,p_epo_attribute16 => p_epo_attribute16
401 ,p_epo_attribute17 => p_epo_attribute17
402 ,p_epo_attribute18 => p_epo_attribute18
403 ,p_epo_attribute19 => p_epo_attribute19
404 ,p_epo_attribute20 => p_epo_attribute20
405 ,p_epo_attribute21 => p_epo_attribute21
406 ,p_epo_attribute22 => p_epo_attribute22
407 ,p_epo_attribute23 => p_epo_attribute23
408 ,p_epo_attribute24 => p_epo_attribute24
409 ,p_epo_attribute25 => p_epo_attribute25
410 ,p_epo_attribute26 => p_epo_attribute26
411 ,p_epo_attribute27 => p_epo_attribute27
412 ,p_epo_attribute28 => p_epo_attribute28
413 ,p_epo_attribute29 => p_epo_attribute29
414 ,p_epo_attribute30 => p_epo_attribute30
415 ,p_request_id => p_request_id
416 ,p_program_application_id => p_program_application_id
417 ,p_program_id => p_program_id
418 ,p_program_update_date => p_program_update_date
419 ,p_object_version_number => l_object_version_number
420 ,p_effective_date => trunc(p_effective_date)
421 );
422 exception
423 when hr_api.cannot_find_prog_unit then
424 hr_api.cannot_find_prog_unit_error
425 (p_module_name => 'CREATE_Elig_Person_Option'
426 ,p_hook_type => 'AP'
427 );
428 --
429 -- End of API User Hook for the after hook of create_Elig_Person_Option
430 --
431 end;
432 --
433 hr_utility.set_location(l_proc, 60);
434 --
435 -- When in validation only mode raise the Validate_Enabled exception
436 --
437 if p_validate then
438 raise hr_api.validate_enabled;
439 end if;
440 --
441 -- Set all output arguments
442 --
443 p_elig_per_opt_id := l_elig_per_opt_id;
444 p_effective_start_date := l_effective_start_date;
445 p_effective_end_date := l_effective_end_date;
449 --
446 p_object_version_number := l_object_version_number;
447 --
448 hr_utility.set_location(' Leaving:'||l_proc, 70);
450 exception
451 --
452 when hr_api.validate_enabled then
453 --
454 -- As the Validate_Enabled exception has been raised
455 -- we must rollback to the savepoint
456 --
457 ROLLBACK TO create_Elig_Person_Option;
458 --
459 -- Only set output warning arguments
460 -- (Any key or derived arguments must be set to null
461 -- when validation only mode is being used.)
462 --
463 p_elig_per_opt_id := null;
464 p_effective_start_date := null;
465 p_effective_end_date := null;
466 p_object_version_number := null;
467 hr_utility.set_location(' Leaving:'||l_proc, 80);
468 --
469 when others then
470 --
471 -- A validation or unexpected error has occured
472 --
473 ROLLBACK TO create_Elig_Person_Option;
474 --
475 p_elig_per_opt_id := null;
476 p_effective_start_date := null;
477 p_effective_end_date := null;
478 p_object_version_number := null;
479 hr_utility.set_location(' Leaving:'||l_proc, 80);
480 --
481 raise;
482 --
483 end create_Elig_Person_Option;
484 --
485 -- ----------------------------------------------------------------------------
486 -- |------------------< create_perf_Elig_Person_Option >----------------------|
487 -- ----------------------------------------------------------------------------
488 --
489 procedure create_perf_Elig_Person_Option
490 (p_validate in boolean default false
491 ,p_elig_per_opt_id out nocopy number
492 ,p_elig_per_id in number default null
493 ,p_effective_start_date out nocopy date
494 ,p_effective_end_date out nocopy date
495 ,p_prtn_ovridn_flag in varchar2 default null
496 ,p_prtn_ovridn_thru_dt in date default null
497 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default null
498 ,p_elig_flag in varchar2 default null
499 ,p_prtn_strt_dt in date default null
500 ,p_prtn_end_dt in date default null
501 ,p_wait_perd_cmpltn_date in date default null
502 ,p_wait_perd_strt_dt in date default null
503 ,p_prtn_ovridn_rsn_cd in varchar2 default null
504 ,p_pct_fl_tm_val in number default null
505 ,p_opt_id in number default null
506 ,p_per_in_ler_id in number default null
507 ,p_rt_comp_ref_amt in number default null
508 ,p_rt_cmbn_age_n_los_val in number default null
509 ,p_rt_comp_ref_uom in varchar2 default null
510 ,p_rt_age_val in number default null
511 ,p_rt_los_val in number default null
512 ,p_rt_hrs_wkd_val in number default null
513 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
514 ,p_rt_age_uom in varchar2 default null
515 ,p_rt_los_uom in varchar2 default null
516 ,p_rt_pct_fl_tm_val in number default null
517 ,p_rt_frz_los_flag in varchar2 default 'N'
518 ,p_rt_frz_age_flag in varchar2 default 'N'
519 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
520 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
521 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
522 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
523 ,p_comp_ref_amt in number default null
524 ,p_cmbn_age_n_los_val in number default null
525 ,p_comp_ref_uom in varchar2 default null
526 ,p_age_val in number default null
527 ,p_los_val in number default null
528 ,p_hrs_wkd_val in number default null
529 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
530 ,p_age_uom in varchar2 default null
531 ,p_los_uom in varchar2 default null
532 ,p_frz_los_flag in varchar2 default 'N'
533 ,p_frz_age_flag in varchar2 default 'N'
534 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
535 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
536 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
537 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
538 ,p_ovrid_svc_dt in date default null
539 ,p_inelg_rsn_cd in varchar2 default null
540 ,p_once_r_cntug_cd in varchar2 default null
541 ,p_oipl_ordr_num in number default null
542 ,p_business_group_id in number default null
543 ,p_epo_attribute_category in varchar2 default null
544 ,p_epo_attribute1 in varchar2 default null
545 ,p_epo_attribute2 in varchar2 default null
546 ,p_epo_attribute3 in varchar2 default null
547 ,p_epo_attribute4 in varchar2 default null
548 ,p_epo_attribute5 in varchar2 default null
549 ,p_epo_attribute6 in varchar2 default null
550 ,p_epo_attribute7 in varchar2 default null
551 ,p_epo_attribute8 in varchar2 default null
552 ,p_epo_attribute9 in varchar2 default null
553 ,p_epo_attribute10 in varchar2 default null
554 ,p_epo_attribute11 in varchar2 default null
555 ,p_epo_attribute12 in varchar2 default null
556 ,p_epo_attribute13 in varchar2 default null
560 ,p_epo_attribute17 in varchar2 default null
557 ,p_epo_attribute14 in varchar2 default null
558 ,p_epo_attribute15 in varchar2 default null
559 ,p_epo_attribute16 in varchar2 default null
561 ,p_epo_attribute18 in varchar2 default null
562 ,p_epo_attribute19 in varchar2 default null
563 ,p_epo_attribute20 in varchar2 default null
564 ,p_epo_attribute21 in varchar2 default null
565 ,p_epo_attribute22 in varchar2 default null
566 ,p_epo_attribute23 in varchar2 default null
567 ,p_epo_attribute24 in varchar2 default null
568 ,p_epo_attribute25 in varchar2 default null
569 ,p_epo_attribute26 in varchar2 default null
570 ,p_epo_attribute27 in varchar2 default null
571 ,p_epo_attribute28 in varchar2 default null
572 ,p_epo_attribute29 in varchar2 default null
573 ,p_epo_attribute30 in varchar2 default null
574 ,p_request_id in number default null
575 ,p_program_application_id in number default null
576 ,p_program_id in number default null
577 ,p_program_update_date in date default null
578 ,p_object_version_number out nocopy number
579 ,p_effective_date in date
580 ,p_override_validation in boolean default false
581 )
582 is
583 --
584 l_proc varchar2(72) := g_package||'create_perf_Elig_Person_Option';
585 --
586 -- Declare cursors and local variables
587 --
588 l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
589 l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590 l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591 l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592 --
593 l_created_by ben_elig_per_opt_f.created_by%TYPE;
594 l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595 l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596 l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597 l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598 --
599 Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
600 --
601 l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
602 --
603 begin
604 --
605 hr_utility.set_location('Entering:'|| l_proc, 10);
606 --
607 -- Issue a savepoint if operating in validation only mode
608 --
609 savepoint create_perf_Elig_Person_Option;
610 --
611 -- Derive maximum start and end dates
612 --
613 l_effective_start_date := p_effective_date;
614 l_effective_end_date := hr_api.g_eot;
615 --
616 -- Elig Per
617 --
618 if p_elig_per_id is not null then
619 --
620 ben_batch_dt_api.get_elig_perobject
621 (p_elig_per_id => p_elig_per_id
622 ,p_rec => l_minmax_rec
623 );
624 --
625 ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
626 (p_effective_date => p_effective_date
627 ,p_parcolumn_name => 'elig_per_id'
628 ,p_min_esd => l_minmax_rec.min_esd
629 ,p_max_eed => l_minmax_rec.max_eed
630 --
631 ,p_esd => l_effective_start_date
632 ,p_eed => l_effective_end_date
633 );
634 --
635 end if;
636 --
637 -- Insert the row
638 --
639 -- Set the object version number for the insert
640 --
641 l_object_version_number := 1;
642 --
643 ben_epo_shd.g_api_dml := true; -- Set the api dml status
644 --
645 -- Select the next sequence number
646 --
647 Open C_Sel1;
648 Fetch C_Sel1 Into l_elig_per_opt_id;
649 Close C_Sel1;
650 --
651 -- Insert the row into: ben_elig_per_f
652 --
653 hr_utility.set_location('Insert: '||l_proc, 5);
654 hr_utility.set_location('Ins EPO:'||l_proc, 5);
655 insert into ben_elig_per_opt_f
656 ( elig_per_opt_id,
657 elig_per_id,
658 effective_start_date,
659 effective_end_date,
660 prtn_ovridn_flag,
661 prtn_ovridn_thru_dt,
662 no_mx_prtn_ovrid_thru_flag,
663 elig_flag,
664 prtn_strt_dt,
665 prtn_end_dt,
666 wait_perd_cmpltn_date,
667 wait_perd_strt_dt,
668 prtn_ovridn_rsn_cd,
669 pct_fl_tm_val,
670 opt_id,
671 per_in_ler_id,
672 rt_comp_ref_amt,
673 rt_cmbn_age_n_los_val,
674 rt_comp_ref_uom,
675 rt_age_val,
676 rt_los_val,
677 rt_hrs_wkd_val,
678 rt_hrs_wkd_bndry_perd_cd,
679 rt_age_uom,
680 rt_los_uom,
681 rt_pct_fl_tm_val,
682 rt_frz_los_flag,
683 rt_frz_age_flag,
684 rt_frz_cmp_lvl_flag,
685 rt_frz_pct_fl_tm_flag,
686 rt_frz_hrs_wkd_flag,
687 rt_frz_comb_age_and_los_flag,
688 comp_ref_amt,
689 cmbn_age_n_los_val,
690 comp_ref_uom,
691 age_val,
692 los_val,
693 hrs_wkd_val,
694 hrs_wkd_bndry_perd_cd,
695 age_uom,
696 los_uom,
697 frz_los_flag,
698 frz_age_flag,
699 frz_cmp_lvl_flag,
700 frz_pct_fl_tm_flag,
701 frz_hrs_wkd_flag,
702 frz_comb_age_and_los_flag,
703 ovrid_svc_dt,
704 inelg_rsn_cd,
705 once_r_cntug_cd,
706 oipl_ordr_num,
707 business_group_id,
708 epo_attribute_category,
709 epo_attribute1,
710 epo_attribute2,
711 epo_attribute3,
715 epo_attribute7,
712 epo_attribute4,
713 epo_attribute5,
714 epo_attribute6,
716 epo_attribute8,
717 epo_attribute9,
718 epo_attribute10,
719 epo_attribute11,
720 epo_attribute12,
721 epo_attribute13,
722 epo_attribute14,
723 epo_attribute15,
724 epo_attribute16,
725 epo_attribute17,
726 epo_attribute18,
727 epo_attribute19,
728 epo_attribute20,
729 epo_attribute21,
730 epo_attribute22,
731 epo_attribute23,
732 epo_attribute24,
733 epo_attribute25,
734 epo_attribute26,
735 epo_attribute27,
736 epo_attribute28,
737 epo_attribute29,
738 epo_attribute30,
739 request_id,
740 program_application_id,
741 program_id,
742 program_update_date,
743 object_version_number,
744 created_by,
745 creation_date,
746 last_update_date,
747 last_updated_by,
748 last_update_login
749 )
750 Values
751 ( l_elig_per_opt_id,
752 p_elig_per_id,
753 l_effective_start_date,
754 l_effective_end_date,
755 p_prtn_ovridn_flag,
756 p_prtn_ovridn_thru_dt,
757 p_no_mx_prtn_ovrid_thru_flag,
758 p_elig_flag,
759 p_prtn_strt_dt,
760 p_prtn_end_dt,
761 p_wait_perd_cmpltn_date,
762 p_wait_perd_strt_dt,
763 p_prtn_ovridn_rsn_cd,
764 p_pct_fl_tm_val,
765 p_opt_id,
766 p_per_in_ler_id,
767 p_rt_comp_ref_amt,
768 p_rt_cmbn_age_n_los_val,
769 p_rt_comp_ref_uom,
770 p_rt_age_val,
771 p_rt_los_val,
772 p_rt_hrs_wkd_val,
773 p_rt_hrs_wkd_bndry_perd_cd,
774 p_rt_age_uom,
775 p_rt_los_uom,
776 p_rt_pct_fl_tm_val,
777 p_rt_frz_los_flag,
778 p_rt_frz_age_flag,
779 p_rt_frz_cmp_lvl_flag,
780 p_rt_frz_pct_fl_tm_flag,
781 p_rt_frz_hrs_wkd_flag,
782 p_rt_frz_comb_age_and_los_flag,
783 p_comp_ref_amt,
784 p_cmbn_age_n_los_val,
785 p_comp_ref_uom,
786 p_age_val,
787 p_los_val,
788 p_hrs_wkd_val,
789 p_hrs_wkd_bndry_perd_cd,
790 p_age_uom,
791 p_los_uom,
792 p_frz_los_flag,
793 p_frz_age_flag,
794 p_frz_cmp_lvl_flag,
795 p_frz_pct_fl_tm_flag,
796 p_frz_hrs_wkd_flag,
797 p_frz_comb_age_and_los_flag,
798 p_ovrid_svc_dt,
799 p_inelg_rsn_cd,
800 p_once_r_cntug_cd,
801 p_oipl_ordr_num,
802 p_business_group_id,
803 p_epo_attribute_category,
804 p_epo_attribute1,
805 p_epo_attribute2,
806 p_epo_attribute3,
807 p_epo_attribute4,
808 p_epo_attribute5,
809 p_epo_attribute6,
810 p_epo_attribute7,
811 p_epo_attribute8,
812 p_epo_attribute9,
813 p_epo_attribute10,
814 p_epo_attribute11,
815 p_epo_attribute12,
816 p_epo_attribute13,
817 p_epo_attribute14,
818 p_epo_attribute15,
819 p_epo_attribute16,
820 p_epo_attribute17,
821 p_epo_attribute18,
822 p_epo_attribute19,
823 p_epo_attribute20,
824 p_epo_attribute21,
825 p_epo_attribute22,
826 p_epo_attribute23,
827 p_epo_attribute24,
828 p_epo_attribute25,
829 p_epo_attribute26,
830 p_epo_attribute27,
831 p_epo_attribute28,
832 p_epo_attribute29,
833 p_epo_attribute30,
834 p_request_id,
835 p_program_application_id,
836 p_program_id,
837 p_program_update_date,
838 l_object_version_number,
839 l_created_by,
840 l_creation_date,
841 l_last_update_date,
842 l_last_updated_by,
843 l_last_update_login
844 );
845 hr_utility.set_location('Dn Insert: '||l_proc, 5);
846 --
847 ben_epo_shd.g_api_dml := false; -- Unset the api dml status
848 --
849 -- When in validation only mode raise the Validate_Enabled exception
850 --
851 if p_validate then
852 raise hr_api.validate_enabled;
853 end if;
854 --
855 -- Set all output arguments
856 --
857 p_elig_per_opt_id := l_elig_per_opt_id;
858 p_effective_start_date := l_effective_start_date;
859 p_effective_end_date := l_effective_end_date;
860 p_object_version_number := l_object_version_number;
861 --
862 hr_utility.set_location(' Leaving:'||l_proc, 70);
863 --
864 exception
865 --
866 when hr_api.validate_enabled then
867 --
868 -- As the Validate_Enabled exception has been raised
869 -- we must rollback to the savepoint
870 --
871 ROLLBACK TO create_perf_Elig_Person_Option;
872 --
873 -- Only set output warning arguments
874 -- (Any key or derived arguments must be set to null
875 -- when validation only mode is being used.)
876 --
877 p_elig_per_opt_id := null;
878 p_effective_start_date := null;
879 p_effective_end_date := null;
880 p_object_version_number := null;
881 hr_utility.set_location(' Leaving:'||l_proc, 80);
882 --
883 when others then
884 --
885 -- A validation or unexpected error has occured
886 --
887 ROLLBACK TO create_perf_Elig_Person_Option;
888 --
889 p_elig_per_opt_id := null;
890 p_effective_start_date := null;
891 p_effective_end_date := null;
892 p_object_version_number := null;
893 hr_utility.set_location(' Leaving:'||l_proc, 80);
897 end create_perf_Elig_Person_Option;
894 --
895 raise;
896 --
898 -- ----------------------------------------------------------------------------
899 -- |------------------------< update_Elig_Person_Option >--- ------------------|
900 -- ----------------------------------------------------------------------------
901 --
902 procedure update_Elig_Person_Option
903 (p_validate in boolean default false
904 ,p_elig_per_opt_id in number
905 ,p_elig_per_id in number default hr_api.g_number
906 ,p_effective_start_date out nocopy date
907 ,p_effective_end_date out nocopy date
908 ,p_prtn_ovridn_flag in varchar2 default hr_api.g_varchar2
909 ,p_prtn_ovridn_thru_dt in date default hr_api.g_date
910 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default hr_api.g_varchar2
911 ,p_elig_flag in varchar2 default hr_api.g_varchar2
912 ,p_prtn_strt_dt in date default hr_api.g_date
913 ,p_prtn_end_dt in date default hr_api.g_date
914 ,p_wait_perd_cmpltn_date in date default hr_api.g_date
915 ,p_wait_perd_strt_dt in date default hr_api.g_date
916 ,p_prtn_ovridn_rsn_cd in varchar2 default hr_api.g_varchar2
917 ,p_pct_fl_tm_val in number default hr_api.g_number
918 ,p_opt_id in number default hr_api.g_number
919 ,p_per_in_ler_id in number default hr_api.g_number
920 ,p_rt_comp_ref_amt in number default hr_api.g_number
921 ,p_rt_cmbn_age_n_los_val in number default hr_api.g_number
922 ,p_rt_comp_ref_uom in varchar2 default hr_api.g_varchar2
923 ,p_rt_age_val in number default hr_api.g_number
924 ,p_rt_los_val in number default hr_api.g_number
925 ,p_rt_hrs_wkd_val in number default hr_api.g_number
926 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
927 ,p_rt_age_uom in varchar2 default hr_api.g_varchar2
928 ,p_rt_los_uom in varchar2 default hr_api.g_varchar2
929 ,p_rt_pct_fl_tm_val in number default hr_api.g_number
930 ,p_rt_frz_los_flag in varchar2 default hr_api.g_varchar2
931 ,p_rt_frz_age_flag in varchar2 default hr_api.g_varchar2
932 ,p_rt_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
933 ,p_rt_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
934 ,p_rt_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
935 ,p_rt_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
936 ,p_comp_ref_amt in number default hr_api.g_number
937 ,p_cmbn_age_n_los_val in number default hr_api.g_number
938 ,p_comp_ref_uom in varchar2 default hr_api.g_varchar2
939 ,p_age_val in number default hr_api.g_number
940 ,p_los_val in number default hr_api.g_number
941 ,p_hrs_wkd_val in number default hr_api.g_number
942 ,p_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
943 ,p_age_uom in varchar2 default hr_api.g_varchar2
944 ,p_los_uom in varchar2 default hr_api.g_varchar2
945 ,p_frz_los_flag in varchar2 default hr_api.g_varchar2
946 ,p_frz_age_flag in varchar2 default hr_api.g_varchar2
947 ,p_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
948 ,p_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
949 ,p_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
950 ,p_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
951 ,p_ovrid_svc_dt in date default hr_api.g_date
952 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
953 ,p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2
954 ,p_oipl_ordr_num in number default hr_api.g_number
955 ,p_business_group_id in number default hr_api.g_number
956 ,p_epo_attribute_category in varchar2 default hr_api.g_varchar2
957 ,p_epo_attribute1 in varchar2 default hr_api.g_varchar2
958 ,p_epo_attribute2 in varchar2 default hr_api.g_varchar2
959 ,p_epo_attribute3 in varchar2 default hr_api.g_varchar2
960 ,p_epo_attribute4 in varchar2 default hr_api.g_varchar2
961 ,p_epo_attribute5 in varchar2 default hr_api.g_varchar2
962 ,p_epo_attribute6 in varchar2 default hr_api.g_varchar2
963 ,p_epo_attribute7 in varchar2 default hr_api.g_varchar2
964 ,p_epo_attribute8 in varchar2 default hr_api.g_varchar2
965 ,p_epo_attribute9 in varchar2 default hr_api.g_varchar2
966 ,p_epo_attribute10 in varchar2 default hr_api.g_varchar2
967 ,p_epo_attribute11 in varchar2 default hr_api.g_varchar2
968 ,p_epo_attribute12 in varchar2 default hr_api.g_varchar2
969 ,p_epo_attribute13 in varchar2 default hr_api.g_varchar2
970 ,p_epo_attribute14 in varchar2 default hr_api.g_varchar2
971 ,p_epo_attribute15 in varchar2 default hr_api.g_varchar2
972 ,p_epo_attribute16 in varchar2 default hr_api.g_varchar2
973 ,p_epo_attribute17 in varchar2 default hr_api.g_varchar2
974 ,p_epo_attribute18 in varchar2 default hr_api.g_varchar2
975 ,p_epo_attribute19 in varchar2 default hr_api.g_varchar2
976 ,p_epo_attribute20 in varchar2 default hr_api.g_varchar2
980 ,p_epo_attribute24 in varchar2 default hr_api.g_varchar2
977 ,p_epo_attribute21 in varchar2 default hr_api.g_varchar2
978 ,p_epo_attribute22 in varchar2 default hr_api.g_varchar2
979 ,p_epo_attribute23 in varchar2 default hr_api.g_varchar2
981 ,p_epo_attribute25 in varchar2 default hr_api.g_varchar2
982 ,p_epo_attribute26 in varchar2 default hr_api.g_varchar2
983 ,p_epo_attribute27 in varchar2 default hr_api.g_varchar2
984 ,p_epo_attribute28 in varchar2 default hr_api.g_varchar2
985 ,p_epo_attribute29 in varchar2 default hr_api.g_varchar2
986 ,p_epo_attribute30 in varchar2 default hr_api.g_varchar2
987 ,p_request_id in number default hr_api.g_number
988 ,p_program_application_id in number default hr_api.g_number
989 ,p_program_id in number default hr_api.g_number
990 ,p_program_update_date in date default hr_api.g_date
991 ,p_object_version_number in out nocopy number
992 ,p_effective_date in date
993 ,p_datetrack_mode in varchar2
994 ) is
995 --
996 -- Declare cursors and local variables
997 --
998 l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
999 l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1000 l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1001 l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1002 --
1003 begin
1004 --
1005 hr_utility.set_location('Entering:'|| l_proc, 10);
1006 --
1007 -- Issue a savepoint if operating in validation only mode
1008 --
1009 savepoint update_Elig_Person_Option;
1010 --
1011 hr_utility.set_location(l_proc, 20);
1012 --
1013 -- Process Logic
1014 --
1015 l_object_version_number := p_object_version_number;
1016 --
1017 begin
1018 --
1019 -- Start of API User Hook for the before hook of update_Elig_Person_Option
1020 --
1021 ben_Elig_Person_Option_bk2.update_Elig_Person_Option_b
1022 (
1023 p_elig_per_opt_id => p_elig_per_opt_id
1024 ,p_elig_per_id => p_elig_per_id
1025 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1026 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1027 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1028 ,p_elig_flag => p_elig_flag
1029 ,p_prtn_strt_dt => p_prtn_strt_dt
1030 ,p_prtn_end_dt => p_prtn_end_dt
1031 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
1032 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
1033 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1034 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1035 ,p_opt_id => p_opt_id
1036 ,p_per_in_ler_id => p_per_in_ler_id
1037 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1038 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1039 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1040 ,p_rt_age_val => p_rt_age_val
1041 ,p_rt_los_val => p_rt_los_val
1042 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1043 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1044 ,p_rt_age_uom => p_rt_age_uom
1045 ,p_rt_los_uom => p_rt_los_uom
1046 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1047 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1048 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1049 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1050 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1051 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1052 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1053 ,p_comp_ref_amt => p_comp_ref_amt
1054 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1055 ,p_comp_ref_uom => p_comp_ref_uom
1056 ,p_age_val => p_age_val
1057 ,p_los_val => p_los_val
1058 ,p_hrs_wkd_val => p_hrs_wkd_val
1059 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1060 ,p_age_uom => p_age_uom
1061 ,p_los_uom => p_los_uom
1062 ,p_frz_los_flag => p_frz_los_flag
1063 ,p_frz_age_flag => p_frz_age_flag
1064 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1065 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1066 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1067 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1068 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1069 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1070 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1071 ,p_oipl_ordr_num => p_oipl_ordr_num
1072 ,p_business_group_id => p_business_group_id
1073 ,p_epo_attribute_category => p_epo_attribute_category
1074 ,p_epo_attribute1 => p_epo_attribute1
1075 ,p_epo_attribute2 => p_epo_attribute2
1076 ,p_epo_attribute3 => p_epo_attribute3
1077 ,p_epo_attribute4 => p_epo_attribute4
1078 ,p_epo_attribute5 => p_epo_attribute5
1082 ,p_epo_attribute9 => p_epo_attribute9
1079 ,p_epo_attribute6 => p_epo_attribute6
1080 ,p_epo_attribute7 => p_epo_attribute7
1081 ,p_epo_attribute8 => p_epo_attribute8
1083 ,p_epo_attribute10 => p_epo_attribute10
1084 ,p_epo_attribute11 => p_epo_attribute11
1085 ,p_epo_attribute12 => p_epo_attribute12
1086 ,p_epo_attribute13 => p_epo_attribute13
1087 ,p_epo_attribute14 => p_epo_attribute14
1088 ,p_epo_attribute15 => p_epo_attribute15
1089 ,p_epo_attribute16 => p_epo_attribute16
1090 ,p_epo_attribute17 => p_epo_attribute17
1091 ,p_epo_attribute18 => p_epo_attribute18
1092 ,p_epo_attribute19 => p_epo_attribute19
1093 ,p_epo_attribute20 => p_epo_attribute20
1094 ,p_epo_attribute21 => p_epo_attribute21
1095 ,p_epo_attribute22 => p_epo_attribute22
1096 ,p_epo_attribute23 => p_epo_attribute23
1097 ,p_epo_attribute24 => p_epo_attribute24
1098 ,p_epo_attribute25 => p_epo_attribute25
1099 ,p_epo_attribute26 => p_epo_attribute26
1100 ,p_epo_attribute27 => p_epo_attribute27
1101 ,p_epo_attribute28 => p_epo_attribute28
1102 ,p_epo_attribute29 => p_epo_attribute29
1103 ,p_epo_attribute30 => p_epo_attribute30
1104 ,p_request_id => p_request_id
1105 ,p_program_application_id => p_program_application_id
1106 ,p_program_id => p_program_id
1107 ,p_program_update_date => p_program_update_date
1108 ,p_object_version_number => p_object_version_number
1109 ,p_effective_date => trunc(p_effective_date)
1110 ,p_datetrack_mode => p_datetrack_mode
1111 );
1112 exception
1113 when hr_api.cannot_find_prog_unit then
1114 hr_api.cannot_find_prog_unit_error
1115 (p_module_name => 'UPDATE_Elig_Person_Option'
1116 ,p_hook_type => 'BP'
1117 );
1118 --
1119 -- End of API User Hook for the before hook of update_Elig_Person_Option
1120 --
1121 end;
1122 --
1123 ben_epo_upd.upd
1124 (
1125 p_elig_per_opt_id => p_elig_per_opt_id
1126 ,p_elig_per_id => p_elig_per_id
1127 ,p_effective_start_date => l_effective_start_date
1128 ,p_effective_end_date => l_effective_end_date
1129 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1130 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1131 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1132 ,p_elig_flag => p_elig_flag
1133 ,p_prtn_strt_dt => p_prtn_strt_dt
1134 ,p_prtn_end_dt => p_prtn_end_dt
1135 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
1136 ,p_wait_perd_strt_dt => p_wait_perd_strt_dt
1137 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1138 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1139 ,p_opt_id => p_opt_id
1140 ,p_per_in_ler_id => p_per_in_ler_id
1141 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1142 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1143 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1144 ,p_rt_age_val => p_rt_age_val
1145 ,p_rt_los_val => p_rt_los_val
1146 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1147 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1148 ,p_rt_age_uom => p_rt_age_uom
1149 ,p_rt_los_uom => p_rt_los_uom
1150 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1151 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1152 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1153 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1154 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1155 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1156 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1157 ,p_comp_ref_amt => p_comp_ref_amt
1158 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1159 ,p_comp_ref_uom => p_comp_ref_uom
1160 ,p_age_val => p_age_val
1161 ,p_los_val => p_los_val
1162 ,p_hrs_wkd_val => p_hrs_wkd_val
1163 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1164 ,p_age_uom => p_age_uom
1165 ,p_los_uom => p_los_uom
1166 ,p_frz_los_flag => p_frz_los_flag
1167 ,p_frz_age_flag => p_frz_age_flag
1168 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1169 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1170 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1171 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1172 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1173 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1174 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1175 ,p_oipl_ordr_num => p_oipl_ordr_num
1176 ,p_business_group_id => p_business_group_id
1177 ,p_epo_attribute_category => p_epo_attribute_category
1178 ,p_epo_attribute1 => p_epo_attribute1
1179 ,p_epo_attribute2 => p_epo_attribute2
1180 ,p_epo_attribute3 => p_epo_attribute3
1181 ,p_epo_attribute4 => p_epo_attribute4
1182 ,p_epo_attribute5 => p_epo_attribute5
1186 ,p_epo_attribute9 => p_epo_attribute9
1183 ,p_epo_attribute6 => p_epo_attribute6
1184 ,p_epo_attribute7 => p_epo_attribute7
1185 ,p_epo_attribute8 => p_epo_attribute8
1187 ,p_epo_attribute10 => p_epo_attribute10
1188 ,p_epo_attribute11 => p_epo_attribute11
1189 ,p_epo_attribute12 => p_epo_attribute12
1190 ,p_epo_attribute13 => p_epo_attribute13
1191 ,p_epo_attribute14 => p_epo_attribute14
1192 ,p_epo_attribute15 => p_epo_attribute15
1193 ,p_epo_attribute16 => p_epo_attribute16
1194 ,p_epo_attribute17 => p_epo_attribute17
1195 ,p_epo_attribute18 => p_epo_attribute18
1196 ,p_epo_attribute19 => p_epo_attribute19
1197 ,p_epo_attribute20 => p_epo_attribute20
1198 ,p_epo_attribute21 => p_epo_attribute21
1199 ,p_epo_attribute22 => p_epo_attribute22
1200 ,p_epo_attribute23 => p_epo_attribute23
1201 ,p_epo_attribute24 => p_epo_attribute24
1202 ,p_epo_attribute25 => p_epo_attribute25
1203 ,p_epo_attribute26 => p_epo_attribute26
1204 ,p_epo_attribute27 => p_epo_attribute27
1205 ,p_epo_attribute28 => p_epo_attribute28
1206 ,p_epo_attribute29 => p_epo_attribute29
1207 ,p_epo_attribute30 => p_epo_attribute30
1208 ,p_request_id => p_request_id
1209 ,p_program_application_id => p_program_application_id
1210 ,p_program_id => p_program_id
1214 ,p_datetrack_mode => p_datetrack_mode
1211 ,p_program_update_date => p_program_update_date
1212 ,p_object_version_number => l_object_version_number
1213 ,p_effective_date => trunc(p_effective_date)
1215 );
1216 --
1217 begin
1218 --
1219 -- Start of API User Hook for the after hook of update_Elig_Person_Option
1220 --
1221 ben_Elig_Person_Option_bk2.update_Elig_Person_Option_a
1222 (
1223 p_elig_per_opt_id => p_elig_per_opt_id
1224 ,p_elig_per_id => p_elig_per_id
1225 ,p_effective_start_date => l_effective_start_date
1226 ,p_effective_end_date => l_effective_end_date
1227 ,p_prtn_ovridn_flag => p_prtn_ovridn_flag
1228 ,p_prtn_ovridn_thru_dt => p_prtn_ovridn_thru_dt
1229 ,p_no_mx_prtn_ovrid_thru_flag => p_no_mx_prtn_ovrid_thru_flag
1230 ,p_elig_flag => p_elig_flag
1231 ,p_prtn_strt_dt => p_prtn_strt_dt
1232 ,p_prtn_end_dt => p_prtn_end_dt
1233 ,p_wait_perd_cmpltn_date => p_wait_perd_cmpltn_date
1234 ,p_wait_perd_strt_dt => p_wait_perd_Strt_dt
1235 ,p_prtn_ovridn_rsn_cd => p_prtn_ovridn_rsn_cd
1236 ,p_pct_fl_tm_val => p_pct_fl_tm_val
1237 ,p_opt_id => p_opt_id
1238 ,p_per_in_ler_id => p_per_in_ler_id
1239 ,p_rt_comp_ref_amt => p_rt_comp_ref_amt
1240 ,p_rt_cmbn_age_n_los_val => p_rt_cmbn_age_n_los_val
1241 ,p_rt_comp_ref_uom => p_rt_comp_ref_uom
1242 ,p_rt_age_val => p_rt_age_val
1243 ,p_rt_los_val => p_rt_los_val
1244 ,p_rt_hrs_wkd_val => p_rt_hrs_wkd_val
1245 ,p_rt_hrs_wkd_bndry_perd_cd => p_rt_hrs_wkd_bndry_perd_cd
1246 ,p_rt_age_uom => p_rt_age_uom
1247 ,p_rt_los_uom => p_rt_los_uom
1248 ,p_rt_pct_fl_tm_val => p_rt_pct_fl_tm_val
1249 ,p_rt_frz_los_flag => p_rt_frz_los_flag
1250 ,p_rt_frz_age_flag => p_rt_frz_age_flag
1251 ,p_rt_frz_cmp_lvl_flag => p_rt_frz_cmp_lvl_flag
1252 ,p_rt_frz_pct_fl_tm_flag => p_rt_frz_pct_fl_tm_flag
1253 ,p_rt_frz_hrs_wkd_flag => p_rt_frz_hrs_wkd_flag
1254 ,p_rt_frz_comb_age_and_los_flag => p_rt_frz_comb_age_and_los_flag
1255 ,p_comp_ref_amt => p_comp_ref_amt
1256 ,p_cmbn_age_n_los_val => p_cmbn_age_n_los_val
1257 ,p_comp_ref_uom => p_comp_ref_uom
1258 ,p_age_val => p_age_val
1259 ,p_los_val => p_los_val
1260 ,p_hrs_wkd_val => p_hrs_wkd_val
1261 ,p_hrs_wkd_bndry_perd_cd => p_hrs_wkd_bndry_perd_cd
1262 ,p_age_uom => p_age_uom
1263 ,p_los_uom => p_los_uom
1264 ,p_frz_los_flag => p_frz_los_flag
1265 ,p_frz_age_flag => p_frz_age_flag
1269 ,p_frz_comb_age_and_los_flag => p_frz_comb_age_and_los_flag
1266 ,p_frz_cmp_lvl_flag => p_frz_cmp_lvl_flag
1267 ,p_frz_pct_fl_tm_flag => p_frz_pct_fl_tm_flag
1268 ,p_frz_hrs_wkd_flag => p_frz_hrs_wkd_flag
1270 ,p_ovrid_svc_dt => p_ovrid_svc_dt
1271 ,p_inelg_rsn_cd => p_inelg_rsn_cd
1272 ,p_once_r_cntug_cd => p_once_r_cntug_cd
1273 ,p_oipl_ordr_num => p_oipl_ordr_num
1274 ,p_business_group_id => p_business_group_id
1275 ,p_epo_attribute_category => p_epo_attribute_category
1276 ,p_epo_attribute1 => p_epo_attribute1
1277 ,p_epo_attribute2 => p_epo_attribute2
1278 ,p_epo_attribute3 => p_epo_attribute3
1279 ,p_epo_attribute4 => p_epo_attribute4
1280 ,p_epo_attribute5 => p_epo_attribute5
1281 ,p_epo_attribute6 => p_epo_attribute6
1282 ,p_epo_attribute7 => p_epo_attribute7
1283 ,p_epo_attribute8 => p_epo_attribute8
1284 ,p_epo_attribute9 => p_epo_attribute9
1285 ,p_epo_attribute10 => p_epo_attribute10
1286 ,p_epo_attribute11 => p_epo_attribute11
1287 ,p_epo_attribute12 => p_epo_attribute12
1288 ,p_epo_attribute13 => p_epo_attribute13
1289 ,p_epo_attribute14 => p_epo_attribute14
1290 ,p_epo_attribute15 => p_epo_attribute15
1291 ,p_epo_attribute16 => p_epo_attribute16
1292 ,p_epo_attribute17 => p_epo_attribute17
1293 ,p_epo_attribute18 => p_epo_attribute18
1294 ,p_epo_attribute19 => p_epo_attribute19
1295 ,p_epo_attribute20 => p_epo_attribute20
1296 ,p_epo_attribute21 => p_epo_attribute21
1297 ,p_epo_attribute22 => p_epo_attribute22
1298 ,p_epo_attribute23 => p_epo_attribute23
1299 ,p_epo_attribute24 => p_epo_attribute24
1300 ,p_epo_attribute25 => p_epo_attribute25
1301 ,p_epo_attribute26 => p_epo_attribute26
1302 ,p_epo_attribute27 => p_epo_attribute27
1303 ,p_epo_attribute28 => p_epo_attribute28
1304 ,p_epo_attribute29 => p_epo_attribute29
1305 ,p_epo_attribute30 => p_epo_attribute30
1306 ,p_request_id => p_request_id
1307 ,p_program_application_id => p_program_application_id
1308 ,p_program_id => p_program_id
1309 ,p_program_update_date => p_program_update_date
1310 ,p_object_version_number => l_object_version_number
1311 ,p_effective_date => trunc(p_effective_date)
1312 ,p_datetrack_mode => p_datetrack_mode
1313 );
1314 exception
1315 when hr_api.cannot_find_prog_unit then
1316 hr_api.cannot_find_prog_unit_error
1317 (p_module_name => 'UPDATE_Elig_Person_Option'
1318 ,p_hook_type => 'AP'
1319 );
1320 --
1321 -- End of API User Hook for the after hook of update_Elig_Person_Option
1322 --
1323 end;
1324 --
1325 hr_utility.set_location(l_proc, 60);
1326 --
1327 -- When in validation only mode raise the Validate_Enabled exception
1328 --
1329 if p_validate then
1330 raise hr_api.validate_enabled;
1331 end if;
1332 --
1333 -- Set all output arguments
1334 --
1338 --
1335 p_object_version_number := l_object_version_number;
1336 p_effective_start_date := l_effective_start_date;
1337 p_effective_end_date := l_effective_end_date;
1339 hr_utility.set_location(' Leaving:'||l_proc, 70);
1340 --
1341 exception
1342 --
1343 when hr_api.validate_enabled then
1344 --
1345 -- As the Validate_Enabled exception has been raised
1346 -- we must rollback to the savepoint
1347 --
1348 ROLLBACK TO update_Elig_Person_Option;
1349 --
1350 -- Only set output warning arguments
1351 -- (Any key or derived arguments must be set to null
1352 -- when validation only mode is being used.)
1353 --
1354 hr_utility.set_location(' Leaving:'||l_proc, 80);
1355 --
1356 when others then
1357 --
1358 -- A validation or unexpected error has occured
1359 --
1360 ROLLBACK TO update_Elig_Person_Option;
1361 --
1362 p_object_version_number := l_object_version_number;
1363 p_effective_start_date := l_effective_start_date;
1364 p_effective_end_date := l_effective_end_date;
1365 --
1366 hr_utility.set_location(' Leaving:'||l_proc, 70);
1367 --
1368 raise;
1369 --
1370 end update_Elig_Person_Option;
1371 -- ----------------------------------------------------------------------------
1372 -- |------------------------< delete_Elig_Person_Option >----------------------|
1373 -- ----------------------------------------------------------------------------
1374 --
1375 procedure delete_Elig_Person_Option
1376 (p_validate in boolean default false
1377 ,p_elig_per_opt_id in number
1378 ,p_effective_start_date out nocopy date
1379 ,p_effective_end_date out nocopy date
1380 ,p_object_version_number in out nocopy number
1381 ,p_effective_date in date
1382 ,p_datetrack_mode in varchar2
1383 ) is
1384 --
1385 -- Declare cursors and local variables
1386 --
1387 l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
1388 l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1389 l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1390 l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1391 --
1392 begin
1393 --
1394 hr_utility.set_location('Entering:'|| l_proc, 10);
1395 --
1396 -- Issue a savepoint if operating in validation only mode
1397 --
1398 savepoint delete_Elig_Person_Option;
1399 --
1400 hr_utility.set_location(l_proc, 20);
1401 --
1402 -- Process Logic
1403 --
1404 l_object_version_number := p_object_version_number;
1405 --
1406 --
1407 begin
1408 --
1409 -- Start of API User Hook for the before hook of delete_Elig_Person_Option
1410 --
1411 ben_Elig_Person_Option_bk3.delete_Elig_Person_Option_b
1412 (
1413 p_elig_per_opt_id => p_elig_per_opt_id
1414 ,p_object_version_number => p_object_version_number
1415 ,p_effective_date => trunc(p_effective_date)
1416 ,p_datetrack_mode => p_datetrack_mode
1417 );
1418 exception
1419 when hr_api.cannot_find_prog_unit then
1420 hr_api.cannot_find_prog_unit_error
1421 (p_module_name => 'DELETE_Elig_Person_Option'
1422 ,p_hook_type => 'BP'
1423 );
1424 --
1425 -- End of API User Hook for the before hook of delete_Elig_Person_Option
1426 --
1427 end;
1428 --
1429 ben_epo_del.del
1430 (
1431 p_elig_per_opt_id => p_elig_per_opt_id
1432 ,p_effective_start_date => l_effective_start_date
1433 ,p_effective_end_date => l_effective_end_date
1434 ,p_object_version_number => l_object_version_number
1435 ,p_effective_date => p_effective_date
1436 ,p_datetrack_mode => p_datetrack_mode
1437 );
1438 --
1439 begin
1440 --
1441 -- Start of API User Hook for the after hook of delete_Elig_Person_Option
1442 --
1443 ben_Elig_Person_Option_bk3.delete_Elig_Person_Option_a
1444 (
1445 p_elig_per_opt_id => p_elig_per_opt_id
1446 ,p_effective_start_date => l_effective_start_date
1447 ,p_effective_end_date => l_effective_end_date
1448 ,p_object_version_number => l_object_version_number
1449 ,p_effective_date => trunc(p_effective_date)
1450 ,p_datetrack_mode => p_datetrack_mode
1451 );
1452 exception
1453 when hr_api.cannot_find_prog_unit then
1454 hr_api.cannot_find_prog_unit_error
1455 (p_module_name => 'DELETE_Elig_Person_Option'
1456 ,p_hook_type => 'AP'
1457 );
1458 --
1459 -- End of API User Hook for the after hook of delete_Elig_Person_Option
1460 --
1461 end;
1462 --
1463 hr_utility.set_location(l_proc, 60);
1464 --
1465 -- When in validation only mode raise the Validate_Enabled exception
1466 --
1467 if p_validate then
1468 raise hr_api.validate_enabled;
1469 end if;
1470 --
1471 hr_utility.set_location(' Leaving:'||l_proc, 70);
1472 --
1473 exception
1474 --
1475 when hr_api.validate_enabled then
1476 --
1477 -- As the Validate_Enabled exception has been raised
1478 -- we must rollback to the savepoint
1482 -- Only set output warning arguments
1479 --
1480 ROLLBACK TO delete_Elig_Person_Option;
1481 --
1483 -- (Any key or derived arguments must be set to null
1484 -- when validation only mode is being used.)
1485 --
1486 p_effective_start_date := null;
1487 p_effective_end_date := null;
1488 --
1489 when others then
1490 --
1491 -- A validation or unexpected error has occured
1492 --
1493 ROLLBACK TO delete_Elig_Person_Option;
1494 --
1495 p_object_version_number := l_object_version_number;
1496 p_effective_start_date := l_effective_start_date;
1497 p_effective_end_date := l_effective_end_date;
1498 --
1499 hr_utility.set_location(' Leaving:'||l_proc, 70);
1500 --
1501 raise;
1502 --
1503 end delete_Elig_Person_Option;
1504 --
1505 -- ----------------------------------------------------------------------------
1506 -- |-------------------------------< lck >------------------------------------|
1507 -- ----------------------------------------------------------------------------
1508 --
1509 procedure lck
1510 (
1511 p_elig_per_opt_id in number
1512 ,p_object_version_number in number
1516 ,p_validation_end_date out nocopy date
1513 ,p_effective_date in date
1514 ,p_datetrack_mode in varchar2
1515 ,p_validation_start_date out nocopy date
1517 ) is
1518 --
1519 --
1520 -- Declare cursors and local variables
1521 --
1522 l_proc varchar2(72) := g_package||'lck';
1523 l_validation_start_date date;
1524 l_validation_end_date date;
1525 --
1526 begin
1527 --
1528 hr_utility.set_location('Entering:'|| l_proc, 10);
1529 --
1530 ben_epo_shd.lck
1531 (
1532 p_elig_per_opt_id => p_elig_per_opt_id
1533 ,p_validation_start_date => l_validation_start_date
1534 ,p_validation_end_date => l_validation_end_date
1535 ,p_object_version_number => p_object_version_number
1536 ,p_effective_date => p_effective_date
1537 ,p_datetrack_mode => p_datetrack_mode
1538 );
1539 --
1540 hr_utility.set_location(' Leaving:'||l_proc, 70);
1541 --
1542 end lck;
1543 --
1544 end ben_Elig_Person_Option_api;