[Home] [Help]
PACKAGE BODY: APPS.BEN_ELIG_PER_ELC_CHC_SWI
Source
1 Package Body ben_elig_per_elc_chc_swi As
2 /* $Header: beepeswi.pkb 120.3 2006/01/06 05:38:02 narvenka noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'ben_elig_per_elc_chc_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_elig_per_elc_chc >-----------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_elig_per_elc_chc
12 (p_validate in number default hr_api.g_false_num
13 ,p_elig_per_elctbl_chc_id out nocopy number
14 ,p_enrt_typ_cycl_cd in varchar2 default null
15 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
16 ,p_enrt_perd_end_dt in date default null
17 ,p_enrt_perd_strt_dt in date default null
18 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
19 ,p_ctfn_rqd_flag in varchar2 default null
20 ,p_pil_elctbl_chc_popl_id in number default null
21 ,p_roll_crs_flag in varchar2 default null
22 ,p_crntly_enrd_flag in varchar2 default null
23 ,p_dflt_flag in varchar2 default null
24 ,p_elctbl_flag in varchar2 default null
25 ,p_mndtry_flag in varchar2 default null
26 ,p_in_pndg_wkflow_flag in varchar2 default null
27 ,p_dflt_enrt_dt in date default null
28 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
29 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
30 ,p_enrt_cvg_strt_dt in date default null
31 ,p_alws_dpnt_dsgn_flag in varchar2 default null
32 ,p_dpnt_dsgn_cd in varchar2 default null
33 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
34 ,p_erlst_deenrt_dt in date default null
35 ,p_procg_end_dt in date default null
36 ,p_comp_lvl_cd in varchar2 default null
37 ,p_pl_id in number default null
38 ,p_oipl_id in number default null
39 ,p_pgm_id in number default null
40 ,p_pgm_typ_cd in varchar2 default null
41 ,p_plip_id in number default null
42 ,p_ptip_id in number default null
43 ,p_pl_typ_id in number default null
44 ,p_oiplip_id in number default null
45 ,p_cmbn_plip_id in number default null
46 ,p_cmbn_ptip_id in number default null
47 ,p_cmbn_ptip_opt_id in number default null
48 ,p_assignment_id in number default null
49 ,p_spcl_rt_pl_id in number default null
50 ,p_spcl_rt_oipl_id in number default null
51 ,p_must_enrl_anthr_pl_id in number default null
52 ,p_int_elig_per_elctbl_chc_id in number default null
53 ,p_prtt_enrt_rslt_id in number default null
54 ,p_bnft_prvdr_pool_id in number default null
55 ,p_per_in_ler_id in number default null
56 ,p_yr_perd_id in number default null
57 ,p_auto_enrt_flag in varchar2 default null
58 ,p_business_group_id in number default null
59 ,p_pl_ordr_num in number default null
60 ,p_plip_ordr_num in number default null
61 ,p_ptip_ordr_num in number default null
62 ,p_oipl_ordr_num in number default null
63 ,p_comments in varchar2 default null
64 ,p_elig_flag in varchar2 default null
65 ,p_elig_ovrid_dt in date default null
66 ,p_elig_ovrid_person_id in number default null
67 ,p_inelig_rsn_cd in varchar2 default null
68 ,p_mgr_ovrid_dt in date default null
69 ,p_mgr_ovrid_person_id in number default null
70 ,p_ws_mgr_id in number default null
71 ,p_epe_attribute_category in varchar2 default null
72 ,p_epe_attribute1 in varchar2 default null
73 ,p_epe_attribute2 in varchar2 default null
74 ,p_epe_attribute3 in varchar2 default null
75 ,p_epe_attribute4 in varchar2 default null
76 ,p_epe_attribute5 in varchar2 default null
77 ,p_epe_attribute6 in varchar2 default null
78 ,p_epe_attribute7 in varchar2 default null
79 ,p_epe_attribute8 in varchar2 default null
80 ,p_epe_attribute9 in varchar2 default null
81 ,p_epe_attribute10 in varchar2 default null
82 ,p_epe_attribute11 in varchar2 default null
83 ,p_epe_attribute12 in varchar2 default null
84 ,p_epe_attribute13 in varchar2 default null
85 ,p_epe_attribute14 in varchar2 default null
86 ,p_epe_attribute15 in varchar2 default null
87 ,p_epe_attribute16 in varchar2 default null
88 ,p_epe_attribute17 in varchar2 default null
89 ,p_epe_attribute18 in varchar2 default null
90 ,p_epe_attribute19 in varchar2 default null
91 ,p_epe_attribute20 in varchar2 default null
92 ,p_epe_attribute21 in varchar2 default null
93 ,p_epe_attribute22 in varchar2 default null
94 ,p_epe_attribute23 in varchar2 default null
95 ,p_epe_attribute24 in varchar2 default null
96 ,p_epe_attribute25 in varchar2 default null
97 ,p_epe_attribute26 in varchar2 default null
98 ,p_epe_attribute27 in varchar2 default null
99 ,p_epe_attribute28 in varchar2 default null
100 ,p_epe_attribute29 in varchar2 default null
101 ,p_epe_attribute30 in varchar2 default null
102 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
103 ,p_request_id in number default null
104 ,p_program_application_id in number default null
105 ,p_program_id in number default null
106 ,p_program_update_date in date default null
107 ,p_object_version_number out nocopy number
108 ,p_effective_date in date
109 ,p_enrt_perd_id in number default null
110 ,p_lee_rsn_id in number default null
111 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
112 ,p_uom in varchar2 default null
113 ,p_acty_ref_perd_cd in varchar2 default null
114 ,p_approval_status_cd in varchar2 default null
115 ,p_return_status out nocopy varchar2
116 ) is
117 --
118 -- Variables for API Boolean parameters
119 l_validate boolean;
120 --
121 -- Variables for IN/OUT parameters
122 --
123 -- Other variables
124 l_proc varchar2(72) := g_package ||'create_elig_per_elc_chc';
125 Begin
126 hr_utility.set_location(' Entering:' || l_proc,10);
127 --
128 -- Issue a savepoint
129 --
130 savepoint create_elig_per_elc_chc_swi;
131 --
132 -- Initialise Multiple Message Detection
133 --
134 hr_multi_message.enable_message_list;
135 --
136 -- Remember IN OUT parameter IN values
137 --
138 --
139 -- Convert constant values to their corresponding boolean value
140 --
141 l_validate :=
142 hr_api.constant_to_boolean
143 (p_constant_value => p_validate);
144 --
145 -- Register Surrogate ID or user key values
146 --
147 --
148 -- Call API
149 --
150 ben_elig_per_elc_chc_api.create_elig_per_elc_chc
151 (p_validate => l_validate
152 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
153 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
154 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
155 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
156 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
157 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
158 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
159 ,p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
160 ,p_roll_crs_flag => p_roll_crs_flag
161 ,p_crntly_enrd_flag => p_crntly_enrd_flag
162 ,p_dflt_flag => p_dflt_flag
163 ,p_elctbl_flag => p_elctbl_flag
164 ,p_mndtry_flag => p_mndtry_flag
165 ,p_in_pndg_wkflow_flag => p_in_pndg_wkflow_flag
166 ,p_dflt_enrt_dt => p_dflt_enrt_dt
167 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
168 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
169 ,p_enrt_cvg_strt_dt => p_enrt_cvg_strt_dt
170 ,p_alws_dpnt_dsgn_flag => p_alws_dpnt_dsgn_flag
171 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
172 ,p_ler_chg_dpnt_cvg_cd => p_ler_chg_dpnt_cvg_cd
173 ,p_erlst_deenrt_dt => p_erlst_deenrt_dt
174 ,p_procg_end_dt => p_procg_end_dt
175 ,p_comp_lvl_cd => p_comp_lvl_cd
176 ,p_pl_id => p_pl_id
177 ,p_oipl_id => p_oipl_id
178 ,p_pgm_id => p_pgm_id
179 ,p_pgm_typ_cd => p_pgm_typ_cd
180 ,p_plip_id => p_plip_id
181 ,p_ptip_id => p_ptip_id
182 ,p_pl_typ_id => p_pl_typ_id
183 ,p_oiplip_id => p_oiplip_id
184 ,p_cmbn_plip_id => p_cmbn_plip_id
185 ,p_cmbn_ptip_id => p_cmbn_ptip_id
186 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
187 ,p_assignment_id => p_assignment_id
188 ,p_spcl_rt_pl_id => p_spcl_rt_pl_id
189 ,p_spcl_rt_oipl_id => p_spcl_rt_oipl_id
190 ,p_must_enrl_anthr_pl_id => p_must_enrl_anthr_pl_id
191 ,p_int_elig_per_elctbl_chc_id => p_int_elig_per_elctbl_chc_id
192 ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
193 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
194 ,p_per_in_ler_id => p_per_in_ler_id
195 ,p_yr_perd_id => p_yr_perd_id
196 ,p_auto_enrt_flag => p_auto_enrt_flag
197 ,p_business_group_id => p_business_group_id
198 ,p_pl_ordr_num => p_pl_ordr_num
199 ,p_plip_ordr_num => p_plip_ordr_num
200 ,p_ptip_ordr_num => p_ptip_ordr_num
201 ,p_oipl_ordr_num => p_oipl_ordr_num
202 ,p_comments => p_comments
203 ,p_elig_flag => p_elig_flag
204 ,p_elig_ovrid_dt => p_elig_ovrid_dt
205 ,p_elig_ovrid_person_id => p_elig_ovrid_person_id
206 ,p_inelig_rsn_cd => p_inelig_rsn_cd
207 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
208 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
209 ,p_ws_mgr_id => p_ws_mgr_id
210 ,p_epe_attribute_category => p_epe_attribute_category
211 ,p_epe_attribute1 => p_epe_attribute1
212 ,p_epe_attribute2 => p_epe_attribute2
213 ,p_epe_attribute3 => p_epe_attribute3
214 ,p_epe_attribute4 => p_epe_attribute4
215 ,p_epe_attribute5 => p_epe_attribute5
216 ,p_epe_attribute6 => p_epe_attribute6
217 ,p_epe_attribute7 => p_epe_attribute7
218 ,p_epe_attribute8 => p_epe_attribute8
219 ,p_epe_attribute9 => p_epe_attribute9
220 ,p_epe_attribute10 => p_epe_attribute10
221 ,p_epe_attribute11 => p_epe_attribute11
222 ,p_epe_attribute12 => p_epe_attribute12
223 ,p_epe_attribute13 => p_epe_attribute13
224 ,p_epe_attribute14 => p_epe_attribute14
225 ,p_epe_attribute15 => p_epe_attribute15
226 ,p_epe_attribute16 => p_epe_attribute16
227 ,p_epe_attribute17 => p_epe_attribute17
228 ,p_epe_attribute18 => p_epe_attribute18
229 ,p_epe_attribute19 => p_epe_attribute19
230 ,p_epe_attribute20 => p_epe_attribute20
231 ,p_epe_attribute21 => p_epe_attribute21
232 ,p_epe_attribute22 => p_epe_attribute22
233 ,p_epe_attribute23 => p_epe_attribute23
234 ,p_epe_attribute24 => p_epe_attribute24
235 ,p_epe_attribute25 => p_epe_attribute25
236 ,p_epe_attribute26 => p_epe_attribute26
237 ,p_epe_attribute27 => p_epe_attribute27
238 ,p_epe_attribute28 => p_epe_attribute28
239 ,p_epe_attribute29 => p_epe_attribute29
240 ,p_epe_attribute30 => p_epe_attribute30
241 ,p_cryfwd_elig_dpnt_cd => p_cryfwd_elig_dpnt_cd
242 ,p_request_id => p_request_id
243 ,p_program_application_id => p_program_application_id
244 ,p_program_id => p_program_id
245 ,p_program_update_date => p_program_update_date
246 ,p_object_version_number => p_object_version_number
247 ,p_effective_date => p_effective_date
248 ,p_enrt_perd_id => p_enrt_perd_id
249 ,p_lee_rsn_id => p_lee_rsn_id
250 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
251 ,p_uom => p_uom
252 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
253 ,p_approval_status_cd => p_approval_status_cd
254 );
255 --
256 -- Convert API warning boolean parameter values to specific
257 -- messages and add them to Multiple Message List
258 --
259 --
260 -- Convert API non-warning boolean parameter values
261 --
262 --
263 -- Derive the API return status value based on whether
264 -- messages of any type exist in the Multiple Message List.
265 -- Also disable Multiple Message Detection.
266 --
267 p_return_status := hr_multi_message.get_return_status_disable;
268 hr_utility.set_location(' Leaving:' || l_proc,20);
269 --
270 exception
271 when hr_multi_message.error_message_exist then
272 --
273 -- Catch the Multiple Message List exception which
274 -- indicates API processing has been aborted because
275 -- at least one message exists in the list.
276 --
277 rollback to create_elig_per_elc_chc_swi;
278 --
279 -- Reset IN OUT parameters and set OUT parameters
280 --
281 p_elig_per_elctbl_chc_id := null;
282 p_object_version_number := null;
283 p_return_status := hr_multi_message.get_return_status_disable;
284 hr_utility.set_location(' Leaving:' || l_proc, 30);
285 when others then
286 --
287 -- When Multiple Message Detection is enabled catch
288 -- any Application specific or other unexpected
289 -- exceptions. Adding appropriate details to the
290 -- Multiple Message List. Otherwise re-raise the
291 -- error.
292 --
293 rollback to create_elig_per_elc_chc_swi;
294 if hr_multi_message.unexpected_error_add(l_proc) then
295 hr_utility.set_location(' Leaving:' || l_proc,40);
296 raise;
297 end if;
298 --
299 -- Reset IN OUT and set OUT parameters
300 --
301 p_elig_per_elctbl_chc_id := null;
302 p_object_version_number := null;
303 p_return_status := hr_multi_message.get_return_status_disable;
304 hr_utility.set_location(' Leaving:' || l_proc,50);
305 end create_elig_per_elc_chc;
306 -- ----------------------------------------------------------------------------
307 -- |---------------------< create_perf_elig_per_elc_chc >---------------------|
308 -- ----------------------------------------------------------------------------
309 PROCEDURE create_perf_elig_per_elc_chc
310 (p_validate in number default hr_api.g_false_num
311 ,p_elig_per_elctbl_chc_id out nocopy number
312 ,p_enrt_typ_cycl_cd in varchar2 default null
316 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
313 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
314 ,p_enrt_perd_end_dt in date default null
315 ,p_enrt_perd_strt_dt in date default null
317 ,p_ctfn_rqd_flag in varchar2 default null
318 ,p_pil_elctbl_chc_popl_id in number default null
319 ,p_roll_crs_flag in varchar2 default null
320 ,p_crntly_enrd_flag in varchar2 default null
321 ,p_dflt_flag in varchar2 default null
322 ,p_elctbl_flag in varchar2 default null
323 ,p_mndtry_flag in varchar2 default null
324 ,p_in_pndg_wkflow_flag in varchar2 default null
325 ,p_dflt_enrt_dt in date default null
326 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
327 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
328 ,p_enrt_cvg_strt_dt in date default null
329 ,p_alws_dpnt_dsgn_flag in varchar2 default null
330 ,p_dpnt_dsgn_cd in varchar2 default null
331 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
332 ,p_erlst_deenrt_dt in date default null
333 ,p_procg_end_dt in date default null
334 ,p_comp_lvl_cd in varchar2 default null
335 ,p_pl_id in number default null
336 ,p_oipl_id in number default null
337 ,p_pgm_id in number default null
338 ,p_pgm_typ_cd in varchar2 default null
339 ,p_plip_id in number default null
340 ,p_ptip_id in number default null
341 ,p_pl_typ_id in number default null
342 ,p_oiplip_id in number default null
343 ,p_cmbn_plip_id in number default null
344 ,p_cmbn_ptip_id in number default null
345 ,p_cmbn_ptip_opt_id in number default null
346 ,p_assignment_id in number default null
347 ,p_spcl_rt_pl_id in number default null
348 ,p_spcl_rt_oipl_id in number default null
349 ,p_must_enrl_anthr_pl_id in number default null
350 ,p_int_elig_per_elctbl_chc_id in number default null
351 ,p_prtt_enrt_rslt_id in number default null
352 ,p_bnft_prvdr_pool_id in number default null
353 ,p_per_in_ler_id in number default null
354 ,p_yr_perd_id in number default null
355 ,p_auto_enrt_flag in varchar2 default null
356 ,p_business_group_id in number default null
357 ,p_pl_ordr_num in number default null
358 ,p_plip_ordr_num in number default null
359 ,p_ptip_ordr_num in number default null
360 ,p_oipl_ordr_num in number default null
361 ,p_comments in varchar2 default null
362 ,p_elig_flag in varchar2 default null
363 ,p_elig_ovrid_dt in date default null
364 ,p_elig_ovrid_person_id in number default null
365 ,p_inelig_rsn_cd in varchar2 default null
366 ,p_mgr_ovrid_dt in date default null
367 ,p_mgr_ovrid_person_id in number default null
368 ,p_ws_mgr_id in number default null
369 ,p_epe_attribute_category in varchar2 default null
370 ,p_epe_attribute1 in varchar2 default null
371 ,p_epe_attribute2 in varchar2 default null
372 ,p_epe_attribute3 in varchar2 default null
373 ,p_epe_attribute4 in varchar2 default null
374 ,p_epe_attribute5 in varchar2 default null
375 ,p_epe_attribute6 in varchar2 default null
376 ,p_epe_attribute7 in varchar2 default null
377 ,p_epe_attribute8 in varchar2 default null
378 ,p_epe_attribute9 in varchar2 default null
379 ,p_epe_attribute10 in varchar2 default null
380 ,p_epe_attribute11 in varchar2 default null
381 ,p_epe_attribute12 in varchar2 default null
382 ,p_epe_attribute13 in varchar2 default null
383 ,p_epe_attribute14 in varchar2 default null
384 ,p_epe_attribute15 in varchar2 default null
385 ,p_epe_attribute16 in varchar2 default null
386 ,p_epe_attribute17 in varchar2 default null
387 ,p_epe_attribute18 in varchar2 default null
388 ,p_epe_attribute19 in varchar2 default null
389 ,p_epe_attribute20 in varchar2 default null
390 ,p_epe_attribute21 in varchar2 default null
391 ,p_epe_attribute22 in varchar2 default null
392 ,p_epe_attribute23 in varchar2 default null
393 ,p_epe_attribute24 in varchar2 default null
394 ,p_epe_attribute25 in varchar2 default null
395 ,p_epe_attribute26 in varchar2 default null
396 ,p_epe_attribute27 in varchar2 default null
397 ,p_epe_attribute28 in varchar2 default null
398 ,p_epe_attribute29 in varchar2 default null
402 ,p_program_application_id in number default null
399 ,p_epe_attribute30 in varchar2 default null
400 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
401 ,p_request_id in number default null
403 ,p_program_id in number default null
404 ,p_program_update_date in date default null
405 ,p_object_version_number out nocopy number
406 ,p_effective_date in date
407 ,p_enrt_perd_id in number default null
408 ,p_lee_rsn_id in number default null
409 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
410 ,p_uom in varchar2 default null
411 ,p_acty_ref_perd_cd in varchar2 default null
412 ,p_mode in varchar2 default null
413 ,p_approval_status_cd in varchar2 default null
414 ,p_return_status out nocopy varchar2
415 ) is
416 --
417 -- Variables for API Boolean parameters
418 l_validate boolean;
419 --
420 -- Variables for IN/OUT parameters
421 --
422 -- Other variables
423 l_proc varchar2(72) := g_package ||'create_perf_elig_per_elc_chc';
424 Begin
425 hr_utility.set_location(' Entering:' || l_proc,10);
426 --
427 -- Issue a savepoint
428 --
429 savepoint crt_perf_elig_per_elc_chc_swi;
430 --
431 -- Initialise Multiple Message Detection
432 --
433 hr_multi_message.enable_message_list;
434 --
435 -- Remember IN OUT parameter IN values
436 --
437 --
438 -- Convert constant values to their corresponding boolean value
439 --
440 l_validate :=
441 hr_api.constant_to_boolean
442 (p_constant_value => p_validate);
443 --
444 -- Register Surrogate ID or user key values
445 --
446 --
447 -- Call API
448 --
449 ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
450 (p_validate => l_validate
451 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
452 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
453 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
454 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
455 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
456 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
457 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
458 ,p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
459 ,p_roll_crs_flag => p_roll_crs_flag
460 ,p_crntly_enrd_flag => p_crntly_enrd_flag
461 ,p_dflt_flag => p_dflt_flag
462 ,p_elctbl_flag => p_elctbl_flag
463 ,p_mndtry_flag => p_mndtry_flag
464 ,p_in_pndg_wkflow_flag => p_in_pndg_wkflow_flag
465 ,p_dflt_enrt_dt => p_dflt_enrt_dt
466 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
467 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
468 ,p_enrt_cvg_strt_dt => p_enrt_cvg_strt_dt
469 ,p_alws_dpnt_dsgn_flag => p_alws_dpnt_dsgn_flag
470 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
471 ,p_ler_chg_dpnt_cvg_cd => p_ler_chg_dpnt_cvg_cd
472 ,p_erlst_deenrt_dt => p_erlst_deenrt_dt
473 ,p_procg_end_dt => p_procg_end_dt
474 ,p_comp_lvl_cd => p_comp_lvl_cd
475 ,p_pl_id => p_pl_id
476 ,p_oipl_id => p_oipl_id
477 ,p_pgm_id => p_pgm_id
478 ,p_pgm_typ_cd => p_pgm_typ_cd
479 ,p_plip_id => p_plip_id
480 ,p_ptip_id => p_ptip_id
481 ,p_pl_typ_id => p_pl_typ_id
482 ,p_oiplip_id => p_oiplip_id
483 ,p_cmbn_plip_id => p_cmbn_plip_id
484 ,p_cmbn_ptip_id => p_cmbn_ptip_id
485 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
486 ,p_assignment_id => p_assignment_id
487 ,p_spcl_rt_pl_id => p_spcl_rt_pl_id
488 ,p_spcl_rt_oipl_id => p_spcl_rt_oipl_id
489 ,p_must_enrl_anthr_pl_id => p_must_enrl_anthr_pl_id
490 ,p_int_elig_per_elctbl_chc_id => p_int_elig_per_elctbl_chc_id
491 ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
492 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
493 ,p_per_in_ler_id => p_per_in_ler_id
494 ,p_yr_perd_id => p_yr_perd_id
495 ,p_auto_enrt_flag => p_auto_enrt_flag
496 ,p_business_group_id => p_business_group_id
497 ,p_pl_ordr_num => p_pl_ordr_num
498 ,p_plip_ordr_num => p_plip_ordr_num
499 ,p_ptip_ordr_num => p_ptip_ordr_num
500 ,p_oipl_ordr_num => p_oipl_ordr_num
501 ,p_comments => p_comments
502 ,p_elig_flag => p_elig_flag
503 ,p_elig_ovrid_dt => p_elig_ovrid_dt
504 ,p_elig_ovrid_person_id => p_elig_ovrid_person_id
505 ,p_inelig_rsn_cd => p_inelig_rsn_cd
506 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
507 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
508 ,p_ws_mgr_id => p_ws_mgr_id
509 ,p_epe_attribute_category => p_epe_attribute_category
513 ,p_epe_attribute4 => p_epe_attribute4
510 ,p_epe_attribute1 => p_epe_attribute1
511 ,p_epe_attribute2 => p_epe_attribute2
512 ,p_epe_attribute3 => p_epe_attribute3
514 ,p_epe_attribute5 => p_epe_attribute5
515 ,p_epe_attribute6 => p_epe_attribute6
516 ,p_epe_attribute7 => p_epe_attribute7
517 ,p_epe_attribute8 => p_epe_attribute8
518 ,p_epe_attribute9 => p_epe_attribute9
519 ,p_epe_attribute10 => p_epe_attribute10
520 ,p_epe_attribute11 => p_epe_attribute11
521 ,p_epe_attribute12 => p_epe_attribute12
522 ,p_epe_attribute13 => p_epe_attribute13
523 ,p_epe_attribute14 => p_epe_attribute14
524 ,p_epe_attribute15 => p_epe_attribute15
525 ,p_epe_attribute16 => p_epe_attribute16
526 ,p_epe_attribute17 => p_epe_attribute17
527 ,p_epe_attribute18 => p_epe_attribute18
528 ,p_epe_attribute19 => p_epe_attribute19
529 ,p_epe_attribute20 => p_epe_attribute20
530 ,p_epe_attribute21 => p_epe_attribute21
531 ,p_epe_attribute22 => p_epe_attribute22
532 ,p_epe_attribute23 => p_epe_attribute23
533 ,p_epe_attribute24 => p_epe_attribute24
534 ,p_epe_attribute25 => p_epe_attribute25
535 ,p_epe_attribute26 => p_epe_attribute26
536 ,p_epe_attribute27 => p_epe_attribute27
537 ,p_epe_attribute28 => p_epe_attribute28
538 ,p_epe_attribute29 => p_epe_attribute29
539 ,p_epe_attribute30 => p_epe_attribute30
540 ,p_cryfwd_elig_dpnt_cd => p_cryfwd_elig_dpnt_cd
541 ,p_request_id => p_request_id
542 ,p_program_application_id => p_program_application_id
543 ,p_program_id => p_program_id
544 ,p_program_update_date => p_program_update_date
545 ,p_object_version_number => p_object_version_number
546 ,p_effective_date => p_effective_date
547 ,p_enrt_perd_id => p_enrt_perd_id
548 ,p_lee_rsn_id => p_lee_rsn_id
549 ,p_cls_enrt_dt_to_use_cd => p_cls_enrt_dt_to_use_cd
550 ,p_uom => p_uom
551 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
552 ,p_approval_status_cd => p_approval_status_cd
553 ,p_mode => p_mode
554 );
555 --
556 -- Convert API warning boolean parameter values to specific
557 -- messages and add them to Multiple Message List
558 --
559 --
560 -- Convert API non-warning boolean parameter values
561 --
562 --
563 -- Derive the API return status value based on whether
564 -- messages of any type exist in the Multiple Message List.
565 -- Also disable Multiple Message Detection.
566 --
567 p_return_status := hr_multi_message.get_return_status_disable;
568 hr_utility.set_location(' Leaving:' || l_proc,20);
569 --
570 exception
571 when hr_multi_message.error_message_exist then
572 --
573 -- Catch the Multiple Message List exception which
574 -- indicates API processing has been aborted because
575 -- at least one message exists in the list.
576 --
577 rollback to crt_perf_elig_per_elc_chc_swi;
578 --
579 -- Reset IN OUT parameters and set OUT parameters
580 --
581 p_elig_per_elctbl_chc_id := null;
582 p_object_version_number := null;
583 p_return_status := hr_multi_message.get_return_status_disable;
584 hr_utility.set_location(' Leaving:' || l_proc, 30);
585 when others then
586 --
587 -- When Multiple Message Detection is enabled catch
588 -- any Application specific or other unexpected
589 -- exceptions. Adding appropriate details to the
590 -- Multiple Message List. Otherwise re-raise the
591 -- error.
592 --
593 rollback to crt_perf_elig_per_elc_chc_swi;
594 if hr_multi_message.unexpected_error_add(l_proc) then
595 hr_utility.set_location(' Leaving:' || l_proc,40);
596 raise;
597 end if;
598 --
599 -- Reset IN OUT and set OUT parameters
600 --
601 p_elig_per_elctbl_chc_id := null;
602 p_object_version_number := null;
603 p_return_status := hr_multi_message.get_return_status_disable;
604 hr_utility.set_location(' Leaving:' || l_proc,50);
605 end create_perf_elig_per_elc_chc;
606 -- ----------------------------------------------------------------------------
607 -- |------------------------< delete_elig_per_elc_chc >-----------------------|
608 -- ----------------------------------------------------------------------------
609 PROCEDURE delete_elig_per_elc_chc
610 (p_validate in number default hr_api.g_false_num
611 ,p_elig_per_elctbl_chc_id in number
612 ,p_object_version_number in out nocopy number
613 ,p_effective_date in date
614 ,p_return_status out nocopy varchar2
615 ) is
616 --
617 -- Variables for API Boolean parameters
618 l_validate boolean;
619 --
620 -- Variables for IN/OUT parameters
621 l_object_version_number number;
622 --
623 -- Other variables
627 --
624 l_proc varchar2(72) := g_package ||'delete_elig_per_elc_chc';
625 Begin
626 hr_utility.set_location(' Entering:' || l_proc,10);
628 -- Issue a savepoint
629 --
630 savepoint delete_elig_per_elc_chc_swi;
631 --
632 -- Initialise Multiple Message Detection
633 --
634 hr_multi_message.enable_message_list;
635 --
636 -- Remember IN OUT parameter IN values
637 --
638 l_object_version_number := p_object_version_number;
639 --
640 -- Convert constant values to their corresponding boolean value
641 --
642 l_validate :=
643 hr_api.constant_to_boolean
644 (p_constant_value => p_validate);
645 --
646 -- Register Surrogate ID or user key values
647 --
648 --
649 -- Call API
650 --
651 ben_elig_per_elc_chc_api.delete_elig_per_elc_chc
652 (p_validate => l_validate
653 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
654 ,p_object_version_number => p_object_version_number
655 ,p_effective_date => p_effective_date
656 );
657 --
658 -- Convert API warning boolean parameter values to specific
659 -- messages and add them to Multiple Message List
660 --
661 --
662 -- Convert API non-warning boolean parameter values
663 --
664 --
665 -- Derive the API return status value based on whether
666 -- messages of any type exist in the Multiple Message List.
667 -- Also disable Multiple Message Detection.
668 --
669 p_return_status := hr_multi_message.get_return_status_disable;
670 hr_utility.set_location(' Leaving:' || l_proc,20);
671 --
672 exception
673 when hr_multi_message.error_message_exist then
674 --
675 -- Catch the Multiple Message List exception which
676 -- indicates API processing has been aborted because
677 -- at least one message exists in the list.
678 --
679 rollback to delete_elig_per_elc_chc_swi;
680 --
681 -- Reset IN OUT parameters and set OUT parameters
682 --
683 p_object_version_number := l_object_version_number;
684 p_return_status := hr_multi_message.get_return_status_disable;
685 hr_utility.set_location(' Leaving:' || l_proc, 30);
686 when others then
687 --
688 -- When Multiple Message Detection is enabled catch
689 -- any Application specific or other unexpected
690 -- exceptions. Adding appropriate details to the
691 -- Multiple Message List. Otherwise re-raise the
692 -- error.
693 --
694 rollback to delete_elig_per_elc_chc_swi;
695 if hr_multi_message.unexpected_error_add(l_proc) then
696 hr_utility.set_location(' Leaving:' || l_proc,40);
697 raise;
698 end if;
699 --
700 -- Reset IN OUT and set OUT parameters
701 --
702 p_object_version_number := l_object_version_number;
703 p_return_status := hr_multi_message.get_return_status_disable;
704 hr_utility.set_location(' Leaving:' || l_proc,50);
705 end delete_elig_per_elc_chc;
706 -- ----------------------------------------------------------------------------
707 -- |----------------------------------< lck >---------------------------------|
708 -- ----------------------------------------------------------------------------
709 PROCEDURE lck
710 (p_elig_per_elctbl_chc_id in number
711 ,p_object_version_number in number
712 ,p_return_status out nocopy varchar2
713 ) is
714 --
715 -- Variables for API Boolean parameters
716 --
717 -- Variables for IN/OUT parameters
718 --
719 -- Other variables
720 l_proc varchar2(72) := g_package ||'lck';
721 Begin
722 hr_utility.set_location(' Entering:' || l_proc,10);
723 --
724 -- Issue a savepoint
725 --
726 savepoint lck_swi;
727 --
728 -- Initialise Multiple Message Detection
729 --
730 hr_multi_message.enable_message_list;
731 --
732 -- Remember IN OUT parameter IN values
733 --
734 --
735 -- Convert constant values to their corresponding boolean value
736 --
737 --
738 -- Register Surrogate ID or user key values
739 --
740 --
741 -- Call API
742 --
743 ben_elig_per_elc_chc_api.lck
744 (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
745 ,p_object_version_number => p_object_version_number
746 );
747 --
748 -- Convert API warning boolean parameter values to specific
749 -- messages and add them to Multiple Message List
750 --
751 --
752 -- Convert API non-warning boolean parameter values
753 --
754 --
755 -- Derive the API return status value based on whether
756 -- messages of any type exist in the Multiple Message List.
757 -- Also disable Multiple Message Detection.
758 --
759 p_return_status := hr_multi_message.get_return_status_disable;
760 hr_utility.set_location(' Leaving:' || l_proc,20);
761 --
762 exception
763 when hr_multi_message.error_message_exist then
764 --
765 -- Catch the Multiple Message List exception which
766 -- indicates API processing has been aborted because
767 -- at least one message exists in the list.
771 -- Reset IN OUT parameters and set OUT parameters
768 --
769 rollback to lck_swi;
770 --
772 --
773 p_return_status := hr_multi_message.get_return_status_disable;
774 hr_utility.set_location(' Leaving:' || l_proc, 30);
775 when others then
776 --
777 -- When Multiple Message Detection is enabled catch
778 -- any Application specific or other unexpected
779 -- exceptions. Adding appropriate details to the
780 -- Multiple Message List. Otherwise re-raise the
781 -- error.
782 --
783 rollback to lck_swi;
784 if hr_multi_message.unexpected_error_add(l_proc) then
785 hr_utility.set_location(' Leaving:' || l_proc,40);
786 raise;
787 end if;
788 --
789 -- Reset IN OUT and set OUT parameters
790 --
791 p_return_status := hr_multi_message.get_return_status_disable;
792 hr_utility.set_location(' Leaving:' || l_proc,50);
793 end lck;
794 -- ----------------------------------------------------------------------------
795 -- |------------------------< update_elig_per_elc_chc >-----------------------|
796 -- ----------------------------------------------------------------------------
797 PROCEDURE update_elig_per_elc_chc
798 (p_validate in number default hr_api.g_false_num
799 ,p_elig_per_elctbl_chc_id in number
800 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802 ,p_enrt_perd_end_dt in date default hr_api.g_date
803 ,p_enrt_perd_strt_dt in date default hr_api.g_date
804 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813 ,p_dflt_enrt_dt in date default hr_api.g_date
814 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820 ,p_erlst_deenrt_dt in date default hr_api.g_date
821 ,p_procg_end_dt in date default hr_api.g_date
822 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823 ,p_pl_id in number default hr_api.g_number
824 ,p_oipl_id in number default hr_api.g_number
825 ,p_pgm_id in number default hr_api.g_number
826 ,p_plip_id in number default hr_api.g_number
827 ,p_ptip_id in number default hr_api.g_number
828 ,p_pl_typ_id in number default hr_api.g_number
829 ,p_oiplip_id in number default hr_api.g_number
830 ,p_cmbn_plip_id in number default hr_api.g_number
831 ,p_cmbn_ptip_id in number default hr_api.g_number
832 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833 ,p_assignment_id in number default hr_api.g_number
834 ,p_spcl_rt_pl_id in number default hr_api.g_number
835 ,p_spcl_rt_oipl_id in number default hr_api.g_number
836 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840 ,p_per_in_ler_id in number default hr_api.g_number
841 ,p_yr_perd_id in number default hr_api.g_number
842 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843 ,p_business_group_id in number default hr_api.g_number
844 ,p_pl_ordr_num in number default hr_api.g_number
845 ,p_plip_ordr_num in number default hr_api.g_number
846 ,p_ptip_ordr_num in number default hr_api.g_number
847 ,p_oipl_ordr_num in number default hr_api.g_number
848 ,p_comments in varchar2 default hr_api.g_varchar2
849 ,p_elig_flag in varchar2 default hr_api.g_varchar2
850 ,p_elig_ovrid_dt in date default hr_api.g_date
851 ,p_elig_ovrid_person_id in number default hr_api.g_number
852 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853 ,p_mgr_ovrid_dt in date default hr_api.g_date
854 ,p_mgr_ovrid_person_id in number default hr_api.g_number
855 ,p_ws_mgr_id in number default hr_api.g_number
859 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
856 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
860 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888 ,p_request_id in number default hr_api.g_number
889 ,p_program_application_id in number default hr_api.g_number
890 ,p_program_id in number default hr_api.g_number
891 ,p_program_update_date in date default hr_api.g_date
892 ,p_object_version_number in out nocopy number
893 ,p_effective_date in date
894 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
895 ,p_return_status out nocopy varchar2
896 ) is
897 --
898 -- Variables for API Boolean parameters
899 l_validate boolean;
900 --
901 -- Variables for IN/OUT parameters
902 l_object_version_number number;
903 --
904 -- Other variables
905 l_proc varchar2(72) := g_package ||'update_elig_per_elc_chc';
906 Begin
907 hr_utility.set_location(' Entering:' || l_proc,10);
908 --
909 -- Issue a savepoint
910 --
911 savepoint update_elig_per_elc_chc_swi;
912 --
913 -- Initialise Multiple Message Detection
914 --
915 hr_multi_message.enable_message_list;
916 --
917 -- Remember IN OUT parameter IN values
918 --
919 l_object_version_number := p_object_version_number;
920 --
921 -- Convert constant values to their corresponding boolean value
922 --
923 l_validate :=
924 hr_api.constant_to_boolean
925 (p_constant_value => p_validate);
926 --
927 -- Register Surrogate ID or user key values
928 --
929 --
930 -- Call API
931 --
932 ben_elig_per_elc_chc_api.update_elig_per_elc_chc
933 (p_validate => l_validate
934 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
935 ,p_enrt_typ_cycl_cd => p_enrt_typ_cycl_cd
936 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
937 ,p_enrt_perd_end_dt => p_enrt_perd_end_dt
938 ,p_enrt_perd_strt_dt => p_enrt_perd_strt_dt
939 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
940 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
941 ,p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
942 ,p_roll_crs_flag => p_roll_crs_flag
943 ,p_crntly_enrd_flag => p_crntly_enrd_flag
944 ,p_dflt_flag => p_dflt_flag
945 ,p_elctbl_flag => p_elctbl_flag
946 ,p_mndtry_flag => p_mndtry_flag
947 ,p_in_pndg_wkflow_flag => p_in_pndg_wkflow_flag
948 ,p_dflt_enrt_dt => p_dflt_enrt_dt
949 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
950 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
951 ,p_enrt_cvg_strt_dt => p_enrt_cvg_strt_dt
952 ,p_alws_dpnt_dsgn_flag => p_alws_dpnt_dsgn_flag
953 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
954 ,p_ler_chg_dpnt_cvg_cd => p_ler_chg_dpnt_cvg_cd
955 ,p_erlst_deenrt_dt => p_erlst_deenrt_dt
956 ,p_procg_end_dt => p_procg_end_dt
960 ,p_pgm_id => p_pgm_id
957 ,p_comp_lvl_cd => p_comp_lvl_cd
958 ,p_pl_id => p_pl_id
959 ,p_oipl_id => p_oipl_id
961 ,p_plip_id => p_plip_id
962 ,p_ptip_id => p_ptip_id
963 ,p_pl_typ_id => p_pl_typ_id
964 ,p_oiplip_id => p_oiplip_id
965 ,p_cmbn_plip_id => p_cmbn_plip_id
966 ,p_cmbn_ptip_id => p_cmbn_ptip_id
967 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
968 ,p_assignment_id => p_assignment_id
969 ,p_spcl_rt_pl_id => p_spcl_rt_pl_id
970 ,p_spcl_rt_oipl_id => p_spcl_rt_oipl_id
971 ,p_must_enrl_anthr_pl_id => p_must_enrl_anthr_pl_id
972 ,p_int_elig_per_elctbl_chc_id => p_int_elig_per_elctbl_chc_id
973 ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
974 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
975 ,p_per_in_ler_id => p_per_in_ler_id
976 ,p_yr_perd_id => p_yr_perd_id
977 ,p_auto_enrt_flag => p_auto_enrt_flag
978 ,p_business_group_id => p_business_group_id
979 ,p_pl_ordr_num => p_pl_ordr_num
980 ,p_plip_ordr_num => p_plip_ordr_num
981 ,p_ptip_ordr_num => p_ptip_ordr_num
982 ,p_oipl_ordr_num => p_oipl_ordr_num
983 ,p_comments => p_comments
984 ,p_elig_flag => p_elig_flag
985 ,p_elig_ovrid_dt => p_elig_ovrid_dt
986 ,p_elig_ovrid_person_id => p_elig_ovrid_person_id
987 ,p_inelig_rsn_cd => p_inelig_rsn_cd
988 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
989 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
990 ,p_ws_mgr_id => p_ws_mgr_id
991 ,p_epe_attribute_category => p_epe_attribute_category
992 ,p_epe_attribute1 => p_epe_attribute1
993 ,p_epe_attribute2 => p_epe_attribute2
994 ,p_epe_attribute3 => p_epe_attribute3
995 ,p_epe_attribute4 => p_epe_attribute4
996 ,p_epe_attribute5 => p_epe_attribute5
997 ,p_epe_attribute6 => p_epe_attribute6
998 ,p_epe_attribute7 => p_epe_attribute7
999 ,p_epe_attribute8 => p_epe_attribute8
1000 ,p_epe_attribute9 => p_epe_attribute9
1001 ,p_epe_attribute10 => p_epe_attribute10
1002 ,p_epe_attribute11 => p_epe_attribute11
1003 ,p_epe_attribute12 => p_epe_attribute12
1004 ,p_epe_attribute13 => p_epe_attribute13
1005 ,p_epe_attribute14 => p_epe_attribute14
1006 ,p_epe_attribute15 => p_epe_attribute15
1007 ,p_epe_attribute16 => p_epe_attribute16
1008 ,p_epe_attribute17 => p_epe_attribute17
1009 ,p_epe_attribute18 => p_epe_attribute18
1010 ,p_epe_attribute19 => p_epe_attribute19
1011 ,p_epe_attribute20 => p_epe_attribute20
1012 ,p_epe_attribute21 => p_epe_attribute21
1013 ,p_epe_attribute22 => p_epe_attribute22
1014 ,p_epe_attribute23 => p_epe_attribute23
1015 ,p_epe_attribute24 => p_epe_attribute24
1016 ,p_epe_attribute25 => p_epe_attribute25
1017 ,p_epe_attribute26 => p_epe_attribute26
1018 ,p_epe_attribute27 => p_epe_attribute27
1019 ,p_epe_attribute28 => p_epe_attribute28
1020 ,p_epe_attribute29 => p_epe_attribute29
1021 ,p_epe_attribute30 => p_epe_attribute30
1022 ,p_cryfwd_elig_dpnt_cd => p_cryfwd_elig_dpnt_cd
1023 ,p_request_id => p_request_id
1024 ,p_program_application_id => p_program_application_id
1025 ,p_program_id => p_program_id
1026 ,p_program_update_date => p_program_update_date
1027 ,p_object_version_number => p_object_version_number
1028 ,p_effective_date => p_effective_date
1029 ,p_approval_status_cd => p_approval_status_cd
1030 );
1031 --
1032 -- Convert API warning boolean parameter values to specific
1033 -- messages and add them to Multiple Message List
1034 --
1035 --
1036 -- Convert API non-warning boolean parameter values
1037 --
1038 --
1039 -- Derive the API return status value based on whether
1040 -- messages of any type exist in the Multiple Message List.
1041 -- Also disable Multiple Message Detection.
1042 --
1043 p_return_status := hr_multi_message.get_return_status_disable;
1044 hr_utility.set_location(' Leaving:' || l_proc,20);
1045 --
1046 exception
1047 when hr_multi_message.error_message_exist then
1048 --
1049 -- Catch the Multiple Message List exception which
1050 -- indicates API processing has been aborted because
1051 -- at least one message exists in the list.
1052 --
1053 rollback to update_elig_per_elc_chc_swi;
1054 --
1055 -- Reset IN OUT parameters and set OUT parameters
1056 --
1057 p_object_version_number := l_object_version_number;
1058 p_return_status := hr_multi_message.get_return_status_disable;
1059 hr_utility.set_location(' Leaving:' || l_proc, 30);
1060 when others then
1061 --
1062 -- When Multiple Message Detection is enabled catch
1066 -- error.
1063 -- any Application specific or other unexpected
1064 -- exceptions. Adding appropriate details to the
1065 -- Multiple Message List. Otherwise re-raise the
1067 --
1068 rollback to update_elig_per_elc_chc_swi;
1069 if hr_multi_message.unexpected_error_add(l_proc) then
1070 hr_utility.set_location(' Leaving:' || l_proc,40);
1071 raise;
1072 end if;
1073 --
1074 -- Reset IN OUT and set OUT parameters
1075 --
1076 p_object_version_number := l_object_version_number;
1077 p_return_status := hr_multi_message.get_return_status_disable;
1078 hr_utility.set_location(' Leaving:' || l_proc,50);
1079 end update_elig_per_elc_chc;
1080 -- ----------------------------------------------------------------------------
1081 -- |---------------------< update_perf_elig_per_elc_chc >---------------------|
1082 -- ----------------------------------------------------------------------------
1083 PROCEDURE update_perf_elig_per_elc_chc
1084 (p_validate in number default hr_api.g_false_num
1085 ,p_elig_per_elctbl_chc_id in number
1086 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102 ,p_erlst_deenrt_dt in date default hr_api.g_date
1103 ,p_procg_end_dt in date default hr_api.g_date
1104 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105 ,p_pl_id in number default hr_api.g_number
1106 ,p_oipl_id in number default hr_api.g_number
1107 ,p_pgm_id in number default hr_api.g_number
1108 ,p_plip_id in number default hr_api.g_number
1109 ,p_ptip_id in number default hr_api.g_number
1110 ,p_pl_typ_id in number default hr_api.g_number
1111 ,p_oiplip_id in number default hr_api.g_number
1112 ,p_cmbn_plip_id in number default hr_api.g_number
1113 ,p_cmbn_ptip_id in number default hr_api.g_number
1114 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115 ,p_assignment_id in number default hr_api.g_number
1116 ,p_spcl_rt_pl_id in number default hr_api.g_number
1117 ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122 ,p_per_in_ler_id in number default hr_api.g_number
1123 ,p_yr_perd_id in number default hr_api.g_number
1124 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125 ,p_business_group_id in number default hr_api.g_number
1126 ,p_pl_ordr_num in number default hr_api.g_number
1127 ,p_plip_ordr_num in number default hr_api.g_number
1128 ,p_ptip_ordr_num in number default hr_api.g_number
1129 ,p_oipl_ordr_num in number default hr_api.g_number
1130 ,p_comments in varchar2 default hr_api.g_varchar2
1131 ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132 ,p_elig_ovrid_dt in date default hr_api.g_date
1133 ,p_elig_ovrid_person_id in number default hr_api.g_number
1134 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135 ,p_mgr_ovrid_dt in date default hr_api.g_date
1136 ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137 ,p_ws_mgr_id in number default hr_api.g_number
1138 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1148 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1145 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1149 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170 ,p_request_id in number default hr_api.g_number
1171 ,p_program_application_id in number default hr_api.g_number
1172 ,p_program_id in number default hr_api.g_number
1173 ,p_program_update_date in date default hr_api.g_date
1174 ,p_object_version_number in out nocopy number
1175 ,p_effective_date in date
1176 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1177 ,p_return_status out nocopy varchar2
1178 ) is
1179 --
1180 -- Variables for API Boolean parameters
1181 l_validate boolean;
1182 --
1183 -- Variables for IN/OUT parameters
1184 l_object_version_number number;
1185 --
1186 -- Other variables
1187 l_proc varchar2(72) := g_package ||'update_perf_elig_per_elc_chc';
1188 Begin
1189 hr_utility.set_location(' Entering:' || l_proc,10);
1190 --
1191 -- Issue a savepoint
1192 --
1193 savepoint upd_perf_elig_per_elc_chc_swi;
1194 --
1195 -- Initialise Multiple Message Detection
1196 --
1197 hr_multi_message.enable_message_list;
1198 --
1199 -- Remember IN OUT parameter IN values
1200 --
1201 l_object_version_number := p_object_version_number;
1202 --
1203 -- Convert constant values to their corresponding boolean value
1204 --
1205 l_validate :=
1206 hr_api.constant_to_boolean
1207 (p_constant_value => p_validate);
1208 --
1209 -- Register Surrogate ID or user key values
1210 --
1211 --
1212 -- Call API
1213 --
1214 ben_elig_per_elc_chc_api.update_perf_elig_per_elc_chc
1215 (p_validate => l_validate
1216 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1217 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
1218 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
1219 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1220 ,p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id
1221 ,p_roll_crs_flag => p_roll_crs_flag
1222 ,p_crntly_enrd_flag => p_crntly_enrd_flag
1223 ,p_dflt_flag => p_dflt_flag
1224 ,p_elctbl_flag => p_elctbl_flag
1225 ,p_mndtry_flag => p_mndtry_flag
1226 ,p_in_pndg_wkflow_flag => p_in_pndg_wkflow_flag
1227 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
1228 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
1229 ,p_enrt_cvg_strt_dt => p_enrt_cvg_strt_dt
1230 ,p_alws_dpnt_dsgn_flag => p_alws_dpnt_dsgn_flag
1231 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
1232 ,p_ler_chg_dpnt_cvg_cd => p_ler_chg_dpnt_cvg_cd
1233 ,p_erlst_deenrt_dt => p_erlst_deenrt_dt
1234 ,p_procg_end_dt => p_procg_end_dt
1235 ,p_comp_lvl_cd => p_comp_lvl_cd
1236 ,p_pl_id => p_pl_id
1237 ,p_oipl_id => p_oipl_id
1238 ,p_pgm_id => p_pgm_id
1239 ,p_plip_id => p_plip_id
1240 ,p_ptip_id => p_ptip_id
1241 ,p_pl_typ_id => p_pl_typ_id
1242 ,p_oiplip_id => p_oiplip_id
1243 ,p_cmbn_plip_id => p_cmbn_plip_id
1244 ,p_cmbn_ptip_id => p_cmbn_ptip_id
1245 ,p_cmbn_ptip_opt_id => p_cmbn_ptip_opt_id
1246 ,p_assignment_id => p_assignment_id
1247 ,p_spcl_rt_pl_id => p_spcl_rt_pl_id
1248 ,p_spcl_rt_oipl_id => p_spcl_rt_oipl_id
1249 ,p_must_enrl_anthr_pl_id => p_must_enrl_anthr_pl_id
1250 ,p_int_elig_per_elctbl_chc_id => p_int_elig_per_elctbl_chc_id
1251 ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
1252 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
1253 ,p_per_in_ler_id => p_per_in_ler_id
1254 ,p_yr_perd_id => p_yr_perd_id
1255 ,p_auto_enrt_flag => p_auto_enrt_flag
1256 ,p_business_group_id => p_business_group_id
1257 ,p_pl_ordr_num => p_pl_ordr_num
1258 ,p_plip_ordr_num => p_plip_ordr_num
1259 ,p_ptip_ordr_num => p_ptip_ordr_num
1260 ,p_oipl_ordr_num => p_oipl_ordr_num
1261 ,p_comments => p_comments
1262 ,p_elig_flag => p_elig_flag
1263 ,p_elig_ovrid_dt => p_elig_ovrid_dt
1264 ,p_elig_ovrid_person_id => p_elig_ovrid_person_id
1265 ,p_inelig_rsn_cd => p_inelig_rsn_cd
1266 ,p_mgr_ovrid_dt => p_mgr_ovrid_dt
1267 ,p_mgr_ovrid_person_id => p_mgr_ovrid_person_id
1268 ,p_ws_mgr_id => p_ws_mgr_id
1269 ,p_epe_attribute_category => p_epe_attribute_category
1270 ,p_epe_attribute1 => p_epe_attribute1
1274 ,p_epe_attribute5 => p_epe_attribute5
1271 ,p_epe_attribute2 => p_epe_attribute2
1272 ,p_epe_attribute3 => p_epe_attribute3
1273 ,p_epe_attribute4 => p_epe_attribute4
1275 ,p_epe_attribute6 => p_epe_attribute6
1276 ,p_epe_attribute7 => p_epe_attribute7
1277 ,p_epe_attribute8 => p_epe_attribute8
1278 ,p_epe_attribute9 => p_epe_attribute9
1279 ,p_epe_attribute10 => p_epe_attribute10
1280 ,p_epe_attribute11 => p_epe_attribute11
1281 ,p_epe_attribute12 => p_epe_attribute12
1282 ,p_epe_attribute13 => p_epe_attribute13
1283 ,p_epe_attribute14 => p_epe_attribute14
1284 ,p_epe_attribute15 => p_epe_attribute15
1285 ,p_epe_attribute16 => p_epe_attribute16
1286 ,p_epe_attribute17 => p_epe_attribute17
1287 ,p_epe_attribute18 => p_epe_attribute18
1288 ,p_epe_attribute19 => p_epe_attribute19
1289 ,p_epe_attribute20 => p_epe_attribute20
1290 ,p_epe_attribute21 => p_epe_attribute21
1291 ,p_epe_attribute22 => p_epe_attribute22
1292 ,p_epe_attribute23 => p_epe_attribute23
1293 ,p_epe_attribute24 => p_epe_attribute24
1294 ,p_epe_attribute25 => p_epe_attribute25
1295 ,p_epe_attribute26 => p_epe_attribute26
1296 ,p_epe_attribute27 => p_epe_attribute27
1297 ,p_epe_attribute28 => p_epe_attribute28
1298 ,p_epe_attribute29 => p_epe_attribute29
1299 ,p_epe_attribute30 => p_epe_attribute30
1300 ,p_cryfwd_elig_dpnt_cd => p_cryfwd_elig_dpnt_cd
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 => p_effective_date
1307 ,p_approval_status_cd => p_approval_status_cd
1308 );
1309 --
1310 -- Convert API warning boolean parameter values to specific
1311 -- messages and add them to Multiple Message List
1312 --
1313 --
1314 -- Convert API non-warning boolean parameter values
1315 --
1316 --
1317 -- Derive the API return status value based on whether
1318 -- messages of any type exist in the Multiple Message List.
1319 -- Also disable Multiple Message Detection.
1320 --
1321 p_return_status := hr_multi_message.get_return_status_disable;
1322 hr_utility.set_location(' Leaving:' || l_proc,20);
1323 --
1324 exception
1325 when hr_multi_message.error_message_exist then
1326 --
1327 -- Catch the Multiple Message List exception which
1328 -- indicates API processing has been aborted because
1329 -- at least one message exists in the list.
1330 --
1331 rollback to upd_perf_elig_per_elc_chc_swi;
1332 --
1333 -- Reset IN OUT parameters and set OUT parameters
1334 --
1335 p_object_version_number := l_object_version_number;
1336 p_return_status := hr_multi_message.get_return_status_disable;
1337 hr_utility.set_location(' Leaving:' || l_proc, 30);
1338 when others then
1339 --
1340 -- When Multiple Message Detection is enabled catch
1341 -- any Application specific or other unexpected
1342 -- exceptions. Adding appropriate details to the
1343 -- Multiple Message List. Otherwise re-raise the
1344 -- error.
1345 --
1346 rollback to upd_perf_elig_per_elc_chc_swi;
1347 if hr_multi_message.unexpected_error_add(l_proc) then
1348 hr_utility.set_location(' Leaving:' || l_proc,40);
1349 raise;
1350 end if;
1351 --
1352 -- Reset IN OUT and set OUT parameters
1353 --
1354 p_object_version_number := l_object_version_number;
1355 p_return_status := hr_multi_message.get_return_status_disable;
1356 hr_utility.set_location(' Leaving:' || l_proc,50);
1357 end update_perf_elig_per_elc_chc;
1358 -- ----------------------------------------------------------------------------
1359 -- |----------------------------< process_api >-------------------------------|
1360 -- ----------------------------------------------------------------------------
1361 procedure process_api
1362 (
1363 p_document in CLOB
1364 ,p_return_status out nocopy VARCHAR2
1365 ,p_validate in number default hr_api.g_false_num
1366 ,p_effective_date in date default null
1367 )
1368 IS
1369 l_postState VARCHAR2(2);
1370 l_return_status VARCHAR2(1);
1371 l_object_version_number number;
1372 l_commitElement xmldom.DOMElement;
1373 l_parser xmlparser.Parser;
1374 l_CommitNode xmldom.DOMNode;
1375 l_proc varchar2(72) := g_package || 'process_api';
1376
1377 --
1378
1379 BEGIN
1380
1381 hr_utility.set_location(' Entering:' || l_proc,10);
1382 hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1383
1384 l_parser := xmlparser.newParser;
1385 xmlparser.ParseCLOB(l_parser,p_document);
1386 l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1387
1388 hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1389
1390 l_commitElement := xmldom.makeElement(l_CommitNode);
1391 l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1392
1393 --Get in/out parameters
1394 l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1395
1396 if l_postState = '2' then
1397 --
1398 ben_elig_per_elc_chc_swi.update_perf_elig_per_elc_chc
1402 ,p_enrt_cvg_strt_dt_rl => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EnrtCvgStrtDtRl')
1399 (p_validate => p_validate
1400 ,p_elig_per_elctbl_chc_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EligPerElctblChcId')
1401 ,p_enrt_cvg_strt_dt_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EnrtCvgStrtDtCd')
1403 ,p_ctfn_rqd_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CtfnRqdFlag')
1404 ,p_pil_elctbl_chc_popl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PilElctblChcPoplId')
1405 ,p_roll_crs_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RollCrsFlag')
1406 ,p_crntly_enrd_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CrntlyEnrdFlag')
1407 ,p_dflt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DfltFlag')
1408 ,p_elctbl_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ElctblFlag')
1409 ,p_mndtry_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MndtryFlag')
1410 ,p_in_pndg_wkflow_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InPndgWkflowFlag')
1411 ,p_dpnt_cvg_strt_dt_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DpntCvgStrtDtCd')
1412 ,p_dpnt_cvg_strt_dt_rl => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DpntCvgStrtDtRl')
1413 ,p_enrt_cvg_strt_dt => hr_transaction_swi.getDateValue(l_CommitNode,'EnrtCvgStrtDt')
1414 ,p_alws_dpnt_dsgn_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AlwsDpntDsgnFlag')
1415 ,p_dpnt_dsgn_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DpntDsgnCd')
1416 ,p_ler_chg_dpnt_cvg_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LerChgDpntCvgCd')
1417 ,p_erlst_deenrt_dt => hr_transaction_swi.getDateValue(l_CommitNode,'ErlstDeenrtDt')
1418 ,p_procg_end_dt => hr_transaction_swi.getDateValue(l_CommitNode,'ProcgEndDt')
1419 ,p_comp_lvl_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompLvlCd')
1420 ,p_pl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PlId')
1421 ,p_oipl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OiplId')
1422 ,p_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PgmId')
1423 ,p_plip_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PlipId')
1424 ,p_ptip_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PtipId')
1425 ,p_pl_typ_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PlTypId')
1426 ,p_oiplip_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OiplipId')
1427 ,p_cmbn_plip_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CmbnPlipId')
1428 ,p_cmbn_ptip_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CmbnPtipId')
1429 ,p_cmbn_ptip_opt_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CmbnPtipOptId')
1430 ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
1431 ,p_spcl_rt_pl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpclRtPlId')
1432 ,p_spcl_rt_oipl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpclRtOiplId')
1433 ,p_must_enrl_anthr_pl_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MustEnrlAnthrPlId')
1434 ,p_int_elig_per_elctbl_chc_id => hr_transaction_swi.getNumberValue(l_CommitNode,'IntEligPerElctblChcId')
1435 ,p_prtt_enrt_rslt_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PrttEnrtRsltId')
1436 ,p_bnft_prvdr_pool_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BnftPrvdrPoolId')
1437 ,p_per_in_ler_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerInLerId')
1438 ,p_yr_perd_id => hr_transaction_swi.getNumberValue(l_CommitNode,'YrPerdId')
1439 ,p_auto_enrt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AutoEnrtFlag')
1440 ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
1441 ,p_pl_ordr_num => hr_transaction_swi.getNumberValue(l_CommitNode,'PlOrdrNum')
1442 ,p_plip_ordr_num => hr_transaction_swi.getNumberValue(l_CommitNode,'PlipOrdrNum')
1443 ,p_ptip_ordr_num => hr_transaction_swi.getNumberValue(l_CommitNode,'PtipOrdrNum')
1444 ,p_oipl_ordr_num => hr_transaction_swi.getNumberValue(l_CommitNode,'OiplOrdrNum')
1445 ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1446 ,p_elig_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EligFlag')
1447 ,p_elig_ovrid_dt => hr_transaction_swi.getDateValue(l_CommitNode,'EligOvridDt')
1448 ,p_elig_ovrid_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EligOvridPersonId')
1449 ,p_inelig_rsn_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IneligRsnCd')
1450 ,p_mgr_ovrid_dt => hr_transaction_swi.getDateValue(l_CommitNode,'MgrOvridDt')
1451 ,p_mgr_ovrid_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MgrOvridPersonId')
1452 ,p_ws_mgr_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WsMgrId')
1453 ,p_epe_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttributeCategory')
1454 ,p_epe_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute1')
1455 ,p_epe_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute2')
1459 ,p_epe_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute6')
1456 ,p_epe_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute3')
1457 ,p_epe_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute4')
1458 ,p_epe_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute5')
1460 ,p_epe_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute7')
1461 ,p_epe_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute8')
1462 ,p_epe_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute9')
1463 ,p_epe_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute10')
1464 ,p_epe_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute11')
1465 ,p_epe_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute12')
1466 ,p_epe_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute13')
1467 ,p_epe_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute14')
1471 ,p_epe_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute18')
1468 ,p_epe_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute15')
1469 ,p_epe_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute16')
1470 ,p_epe_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute17')
1472 ,p_epe_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute19')
1473 ,p_epe_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute20')
1474 ,p_epe_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute21')
1475 ,p_epe_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute22')
1476 ,p_epe_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute23')
1477 ,p_epe_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute24')
1478 ,p_epe_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute25')
1479 ,p_epe_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute26')
1480 ,p_epe_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute27')
1481 ,p_epe_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute28')
1485 ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
1482 ,p_epe_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute29')
1483 ,p_epe_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EpeAttribute30')
1484 ,p_cryfwd_elig_dpnt_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CryfwdEligDpntCd')
1486 ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
1487 ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
1488 ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
1489 ,p_object_version_number => l_object_version_number
1490 ,p_effective_date => p_effective_date
1491 ,p_approval_status_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ApprovalStatusCd')
1492 ,p_return_status => l_return_status
1493 );
1494 --
1495 --
1496 end if;
1497 p_return_status := l_return_status;
1498 hr_utility.set_location('Exiting:' || l_proc,40);
1499
1500 end process_api;
1501
1502 end ben_elig_per_elc_chc_swi;