1 package ben_manage_unres_life_events as
2 /* $Header: bebmures.pkh 120.2 2006/04/04 04:22:22 ssarkar noship $ */
3 --
4 type g_unrest_epe_inst_row is record
5 (
6 FONM_CVG_STRT_DT BEN_ELIG_PER_ELCTBL_CHC.FONM_CVG_STRT_DT%TYPE
7 ,PGM_ID BEN_ELIG_PER_ELCTBL_CHC.PGM_ID%TYPE
8 ,PL_ID BEN_ELIG_PER_ELCTBL_CHC.PL_ID%TYPE
9 ,PL_TYP_ID BEN_ELIG_PER_ELCTBL_CHC.PL_TYP_ID%TYPE
10 ,PLIP_ID BEN_ELIG_PER_ELCTBL_CHC.PLIP_ID%TYPE
11 ,PTIP_ID BEN_ELIG_PER_ELCTBL_CHC.PTIP_ID%TYPE
12 ,ENRT_CVG_STRT_DT_CD BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT_CD%TYPE
13 ,ENRT_CVG_STRT_DT_RL BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT_RL%TYPE
14 ,PRTT_ENRT_RSLT_ID BEN_ELIG_PER_ELCTBL_CHC.PRTT_ENRT_RSLT_ID%TYPE
15 ,DPNT_CVG_STRT_DT_CD BEN_ELIG_PER_ELCTBL_CHC.DPNT_CVG_STRT_DT_CD%TYPE
16 ,DPNT_CVG_STRT_DT_RL BEN_ELIG_PER_ELCTBL_CHC.DPNT_CVG_STRT_DT_RL%TYPE
17 ,ENRT_CVG_STRT_DT BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT%TYPE
18 ,DPNT_DSGN_CD BEN_ELIG_PER_ELCTBL_CHC.DPNT_DSGN_CD%TYPE
19 ,LER_CHG_DPNT_CVG_CD BEN_ELIG_PER_ELCTBL_CHC.LER_CHG_DPNT_CVG_CD%TYPE
20 ,ERLST_DEENRT_DT BEN_ELIG_PER_ELCTBL_CHC.ERLST_DEENRT_DT%TYPE
21 ,PROCG_END_DT BEN_ELIG_PER_ELCTBL_CHC.PROCG_END_DT%TYPE
22 ,CRYFWD_ELIG_DPNT_CD BEN_ELIG_PER_ELCTBL_CHC.CRYFWD_ELIG_DPNT_CD%TYPE
23 ,ELIG_FLAG BEN_ELIG_PER_ELCTBL_CHC.ELIG_FLAG%TYPE
24 ,ELIG_OVRID_DT BEN_ELIG_PER_ELCTBL_CHC.ELIG_OVRID_DT%TYPE
25 ,ELIG_OVRID_PERSON_ID BEN_ELIG_PER_ELCTBL_CHC.ELIG_OVRID_PERSON_ID%TYPE
26 ,INELIG_RSN_CD BEN_ELIG_PER_ELCTBL_CHC.INELIG_RSN_CD%TYPE
27 ,MGR_OVRID_DT BEN_ELIG_PER_ELCTBL_CHC.MGR_OVRID_DT%TYPE
28 ,MGR_OVRID_PERSON_ID BEN_ELIG_PER_ELCTBL_CHC.MGR_OVRID_PERSON_ID%TYPE
29 ,WS_MGR_ID BEN_ELIG_PER_ELCTBL_CHC.WS_MGR_ID%TYPE
30 ,ASSIGNMENT_ID BEN_ELIG_PER_ELCTBL_CHC.ASSIGNMENT_ID%TYPE
31 ,ROLL_CRS_FLAG BEN_ELIG_PER_ELCTBL_CHC.ROLL_CRS_FLAG%TYPE
32 ,CRNTLY_ENRD_FLAG BEN_ELIG_PER_ELCTBL_CHC.CRNTLY_ENRD_FLAG%TYPE
33 ,DFLT_FLAG BEN_ELIG_PER_ELCTBL_CHC.DFLT_FLAG%TYPE
34 ,ELCTBL_FLAG BEN_ELIG_PER_ELCTBL_CHC.ELCTBL_FLAG%TYPE
35 ,MNDTRY_FLAG BEN_ELIG_PER_ELCTBL_CHC.MNDTRY_FLAG%TYPE
36 ,ALWS_DPNT_DSGN_FLAG BEN_ELIG_PER_ELCTBL_CHC.ALWS_DPNT_DSGN_FLAG%TYPE
37 ,COMP_LVL_CD BEN_ELIG_PER_ELCTBL_CHC.COMP_LVL_CD%TYPE
38 ,AUTO_ENRT_FLAG BEN_ELIG_PER_ELCTBL_CHC.AUTO_ENRT_FLAG%TYPE
39 ,CTFN_RQD_FLAG BEN_ELIG_PER_ELCTBL_CHC.CTFN_RQD_FLAG%TYPE
40 ,PER_IN_LER_ID BEN_ELIG_PER_ELCTBL_CHC.PER_IN_LER_ID%TYPE
41 ,YR_PERD_ID BEN_ELIG_PER_ELCTBL_CHC.YR_PERD_ID%TYPE
42 ,OIPLIP_ID BEN_ELIG_PER_ELCTBL_CHC.OIPLIP_ID%TYPE
43 ,PL_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PL_ORDR_NUM%TYPE
44 ,PLIP_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PLIP_ORDR_NUM%TYPE
45 ,PTIP_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PTIP_ORDR_NUM%TYPE
46 ,OIPL_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.OIPL_ORDR_NUM%TYPE
47 ,MUST_ENRL_ANTHR_PL_ID BEN_ELIG_PER_ELCTBL_CHC.MUST_ENRL_ANTHR_PL_ID%TYPE
48 ,SPCL_RT_PL_ID BEN_ELIG_PER_ELCTBL_CHC.SPCL_RT_PL_ID%TYPE
49 ,SPCL_RT_OIPL_ID BEN_ELIG_PER_ELCTBL_CHC.SPCL_RT_OIPL_ID%TYPE
50 ,BNFT_PRVDR_POOL_ID BEN_ELIG_PER_ELCTBL_CHC.BNFT_PRVDR_POOL_ID%TYPE
51 ,CMBN_PTIP_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PTIP_ID%TYPE
52 ,CMBN_PTIP_OPT_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PTIP_OPT_ID%TYPE
53 ,CMBN_PLIP_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PLIP_ID%TYPE
54 ,OIPL_ID BEN_ELIG_PER_ELCTBL_CHC.OIPL_ID%TYPE
55 ,APPROVAL_STATUS_CD BEN_ELIG_PER_ELCTBL_CHC.APPROVAL_STATUS_CD%TYPE
56 ,elig_per_elctbl_chc_id number
57 ,object_version_number number
58 ,mark_delete varchar2(1)
59 );
60 --
61 type g_unrest_epe_inst_tbl is table of g_unrest_epe_inst_row
62 index by binary_integer;
63 --
64 g_unrest_epe_instance g_unrest_epe_inst_tbl;
65 --
66 type g_unrest_ecr_inst_row is record
67 (enrt_rt_id number
68 ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
69 ,ENRT_BNFT_ID BEN_ENRT_RT.ENRT_BNFT_ID%TYPE
70 ,OBJECT_VERSION_NUMBER number
71 ,ACTY_BASE_RT_ID BEN_ENRT_RT.ACTY_BASE_RT_ID%TYPE
72 ,mark_delete varchar2(1)
73 );
74 --
75 type g_unrest_ecr_inst_tbl is table of g_unrest_ecr_inst_row
76 index by binary_integer;
77 --
78 g_unrest_ecr_instance g_unrest_ecr_inst_tbl;
79 g_unrest_ecr_instance_row g_unrest_ecr_inst_row;
80 --
81 --
82 type g_unrest_enb_inst_row is record
83 (enrt_bnft_id number
84 ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
85 ,ORDR_NUM BEN_ENRT_BNFT.ORDR_NUM%TYPE
86 ,OBJECT_VERSION_NUMBER number
87 ,mark_delete varchar2(1)
88 );
89 --
90 type g_unrest_enb_inst_tbl is table of g_unrest_enb_inst_row
91 index by binary_integer;
92 --
93 g_unrest_enb_instance g_unrest_enb_inst_tbl;
94 g_unrest_enb_instance_row g_unrest_enb_inst_row;
95 --
96 type g_unrest_epr_inst_row is record
97 (enrt_prem_id number
98 ,ACTL_PREM_ID BEN_ENRT_PREM.ACTL_PREM_ID%TYPE
99 ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
100 ,ENRT_BNFT_ID number
101 ,OBJECT_VERSION_NUMBER BEN_ENRT_PREM.OBJECT_VERSION_NUMBER%TYPE
102 ,mark_delete varchar2(1)
103 );
104 --
105 type g_unrest_epr_inst_tbl is table of g_unrest_epr_inst_row
106 index by binary_integer;
107 --
108 g_unrest_epr_instance g_unrest_epr_inst_tbl;
109 g_unrest_epr_instance_row g_unrest_epr_inst_row;
110 --
111 type g_unrest_ecc_inst_row is record
112 (elctbl_chc_ctfn_id number
113 ,ENRT_CTFN_TYP_CD BEN_ELCTBL_CHC_CTFN.ENRT_CTFN_TYP_CD%TYPE
114 ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
115 ,ENRT_BNFT_ID BEN_ELCTBL_CHC_CTFN.ENRT_BNFT_ID%TYPE
116 ,OBJECT_VERSION_NUMBER BEN_ENRT_PREM.OBJECT_VERSION_NUMBER%TYPE
117 ,mark_delete varchar2(1)
118 );
119 --
120 type g_unrest_ecc_inst_tbl is table of g_unrest_ecc_inst_row
121 index by binary_integer;
122 --
123 g_unrest_ecc_instance g_unrest_ecc_inst_tbl;
124 g_unrest_ecc_instance_row g_unrest_ecc_inst_row;
125 --
126 type g_unrest_egd_inst_row is record
127 (elig_dpnt_id number
128 ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
129 ,PER_IN_LER_ID BEN_ELIG_DPNT.PER_IN_LER_ID%TYPE
130 ,ELIG_PER_ID BEN_ELIG_DPNT.ELIG_PER_ID%TYPE
131 ,ELIG_PER_OPT_ID BEN_ELIG_DPNT.ELIG_PER_OPT_ID%TYPE
132 ,ELIG_CVRD_DPNT_ID BEN_ELIG_DPNT.ELIG_CVRD_DPNT_ID%TYPE
133 ,DPNT_INELIG_FLAG BEN_ELIG_DPNT.DPNT_INELIG_FLAG%TYPE
134 ,OVRDN_FLAG BEN_ELIG_DPNT.OVRDN_FLAG%TYPE
135 ,DPNT_PERSON_ID BEN_ELIG_DPNT.DPNT_PERSON_ID%TYPE
136 ,OBJECT_VERSION_NUMBER BEN_ENRT_PREM.OBJECT_VERSION_NUMBER%TYPE
137 ,mark_delete varchar2(1)
138 );
139 --
140 type g_unrest_egd_inst_tbl is table of g_unrest_egd_inst_row
141 index by binary_integer;
142 --
143 g_unrest_egd_instance g_unrest_egd_inst_tbl;
144 g_unrest_egd_instance_row g_unrest_egd_inst_row;
145 --
146 procedure update_in_pend_flag
147 (p_person_id in number
148 ,p_per_in_ler_id in number
149 ,p_business_group_id in number
150 ,p_effective_date in date
151 );
152 --
153 procedure delete_elctbl_choice
154 (p_person_id in number
155 ,p_effective_date in date
156 ,p_business_group_id in number
157 ,p_rec out nocopy benutils.g_active_life_event
158 );
159 --
160 function epe_exists
161 ( p_per_in_ler_id number
162 ,p_pgm_id number default null
163 ,p_pl_id number default null
164 ,p_oipl_id number default null
165 ,p_plip_id number default null
166 ,p_oiplip_id number default null
167 ,p_ptip_id number default null
168 ,p_bnft_prvdr_pool_id number default null
169 ,p_CMBN_PTIP_ID number default null
170 ,p_CMBN_PTIP_OPT_ID number default null
171 ,p_CMBN_PLIP_ID number default null
172 ,p_comp_lvl_cd varchar2 default null
173 ) return number;
174
175 --
176 function enb_exists
177 (p_ELIG_PER_ELCTBL_CHC_ID number default null
178 ,p_ORDR_NUM number default null
179 ) return number;
180 --
181 function ecr_exists
182 (p_ELIG_PER_ELCTBL_CHC_ID number default null
183 ,p_enrt_bnft_id number default null
184 ,p_acty_base_rt_id number
185 ) return number;
186 --
187 function egd_exists
188 (p_PER_IN_LER_ID number
189 ,p_ELIG_PER_ID number
190 ,p_ELIG_PER_OPT_ID number default null
191 ,p_DPNT_PERSON_ID number
192 ) return number;
193 --
194 function epr_exists
195 (p_ELIG_PER_ELCTBL_CHC_ID number default null
196 ,p_enrt_bnft_id number default null
197 ,p_ACTL_PREM_ID number
198 ) return number;
199 --
200 function ecc_exists
201 ( p_ELIG_PER_ELCTBL_CHC_ID number default null
202 ,p_enrt_bnft_id number default null
203 ,p_ENRT_CTFN_TYP_CD varchar2
204 ) return number;
205 --
206 procedure clear_cache;
207 -- Added during Bug fix - 4640014
208 procedure clear_epe_cache;
209 --
210 procedure update_elig_per_elctbl_choice
211 (
212 p_elig_per_elctbl_chc_id in number
213 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
214 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
215 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
216 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
217 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
218 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
219 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
220 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
221 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
222 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
223 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
224 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
225 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
226 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
227 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
228 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
229 ,p_erlst_deenrt_dt in date default hr_api.g_date
230 ,p_procg_end_dt in date default hr_api.g_date
231 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
232 ,p_pl_id in number default hr_api.g_number
233 ,p_oipl_id in number default hr_api.g_number
234 ,p_pgm_id in number default hr_api.g_number
235 ,p_plip_id in number default hr_api.g_number
236 ,p_ptip_id in number default hr_api.g_number
237 ,p_pl_typ_id in number default hr_api.g_number
238 ,p_oiplip_id in number default hr_api.g_number
239 ,p_cmbn_plip_id in number default hr_api.g_number
240 ,p_cmbn_ptip_id in number default hr_api.g_number
241 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
242 ,p_assignment_id in number default hr_api.g_number
243 ,p_spcl_rt_pl_id in number default hr_api.g_number
244 ,p_spcl_rt_oipl_id in number default hr_api.g_number
245 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
246 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
247 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
248 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
249 ,p_per_in_ler_id in number default hr_api.g_number
250 ,p_yr_perd_id in number default hr_api.g_number
251 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
252 ,p_business_group_id in number default hr_api.g_number
253 ,p_pl_ordr_num in number default hr_api.g_number
254 ,p_plip_ordr_num in number default hr_api.g_number
255 ,p_ptip_ordr_num in number default hr_api.g_number
256 ,p_oipl_ordr_num in number default hr_api.g_number
257 ,p_comments in varchar2 default hr_api.g_varchar2
258 ,p_elig_flag in varchar2 default hr_api.g_varchar2
259 ,p_elig_ovrid_dt in date default hr_api.g_date
260 ,p_elig_ovrid_person_id in number default hr_api.g_number
261 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
262 ,p_mgr_ovrid_dt in date default hr_api.g_date
263 ,p_mgr_ovrid_person_id in number default hr_api.g_number
264 ,p_ws_mgr_id in number default hr_api.g_number
265 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
266 ,p_fonm_cvg_strt_dt in date default hr_api.g_date
267 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
268 ,p_effective_date in date
269 ,p_pgm_typ_cd in varchar2 default hr_api.g_varchar2
270 ,p_enrt_perd_end_dt in date default hr_api.g_date
271 ,p_enrt_perd_strt_dt in date default hr_api.g_date
272 ,p_dflt_enrt_dt in varchar2 default hr_api.g_date --g_varchar2 --4051269
273 ,p_uom in varchar2 default hr_api.g_varchar2
274 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
275 ,p_lee_rsn_id in number default hr_api.g_number
276 ,p_enrt_perd_id in number default hr_api.g_number
277 ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
278 );
279 --
280 procedure update_enrt_bnft
281 ( p_enrt_bnft_id in number
282 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
286 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
283 ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
284 ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
285 ,p_val in number default hr_api.g_number
287 ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
288 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
289 ,p_mn_val in number default hr_api.g_number
290 ,p_mx_val in number default hr_api.g_number
291 ,p_incrmt_val in number default hr_api.g_number
292 ,p_dflt_val in number default hr_api.g_number
293 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
294 ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
295 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
296 ,p_ordr_num in number default hr_api.g_number
297 ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
298 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
299 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
300 ,p_comp_lvl_fctr_id in number default hr_api.g_number
301 ,p_business_group_id in number default hr_api.g_number
302 ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
303 ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
304 ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
305 ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
306 ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
307 ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
308 ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
309 ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
310 ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
311 ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
312 ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
313 ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
314 ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
315 ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
316 ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
317 ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
318 ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
319 ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
320 ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
321 ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
322 ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
323 ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
324 ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
325 ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
326 ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
327 ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
328 ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
329 ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
330 ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
331 ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
332 ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
333 ,p_request_id in number default hr_api.g_number
334 ,p_program_application_id in number default hr_api.g_number
335 ,p_program_id in number default hr_api.g_number
336 ,p_program_update_date in date default hr_api.g_date
337 ,p_mx_wout_ctfn_val in number default hr_api.g_number
338 ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
339 ,p_effective_date in date
340 );
341 --
342 procedure update_enrt_rt
343 ( p_enrt_rt_id in NUMBER,
344 p_ordr_num in number default hr_api.g_number,
345 p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
346 p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
347 p_ctfn_rqd_flag in VARCHAR2 DEFAULT 'N',
348 p_dflt_flag in VARCHAR2 DEFAULT 'N',
349 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT 'N',
350 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT 'N',
351 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT 'N',
352 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT 'N',
353 p_asn_on_enrt_flag in VARCHAR2 DEFAULT 'N',
354 p_rl_crs_only_flag in VARCHAR2 DEFAULT 'N',
355 p_dflt_val in NUMBER DEFAULT hr_api.g_number,
356 p_ann_val in NUMBER DEFAULT hr_api.g_number,
357 p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
358 p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
359 p_val in NUMBER DEFAULT hr_api.g_number,
360 p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
361 p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
362 p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
363 p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
364 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
368 p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
365 p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
366 p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
367 p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
369 p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
370 p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
371 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
372 p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
373 p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
374 p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
375 p_entr_ann_val_flag in VARCHAR2,
376 p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
377 p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
378 p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
379 p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
380 p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
381 p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
382 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
383 p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
384 p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
385 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
386 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
387 p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
388 p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
389 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
390 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
391 p_business_group_id in NUMBER,
392 p_perf_min_max_edit in VARCHAR2 DEFAULT hr_api.g_varchar2,
393 p_iss_val in number DEFAULT hr_api.g_number,
394 p_val_last_upd_date in date DEFAULT hr_api.g_date,
395 p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
396 p_pp_in_yr_used_num in number default hr_api.g_number,
397 p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
398 p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
399 p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
400 p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
401 p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
402 p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
403 p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
404 p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
405 p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
406 p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
407 p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
408 p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
409 p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
410 p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
411 p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
412 p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
413 p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
414 p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
415 p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
416 p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
417 p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
418 p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
419 p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
420 p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
421 p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
422 p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
423 p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
424 p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
425 p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
426 p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
427 p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
428 p_request_id in NUMBER DEFAULT hr_api.g_number,
429 p_program_application_id in NUMBER DEFAULT hr_api.g_number,
430 p_program_id in NUMBER DEFAULT hr_api.g_number,
431 p_program_update_date in DATE DEFAULT hr_api.g_date,
432 p_effective_date in date
433 );
434 --
435 procedure update_elig_dpnt
436 ( p_elig_dpnt_id in number
437 ,p_create_dt in date default hr_api.g_date
438 ,p_elig_strt_dt in date default hr_api.g_date
439 ,p_elig_thru_dt in date default hr_api.g_date
440 ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
441 ,p_ovrdn_thru_dt in date default hr_api.g_date
442 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
443 ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
444 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
445 ,p_per_in_ler_id in number default hr_api.g_number
446 ,p_elig_per_id in number default hr_api.g_number
447 ,p_elig_per_opt_id in number default hr_api.g_number
448 ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
449 ,p_dpnt_person_id in number default hr_api.g_number
450 ,p_business_group_id in number default hr_api.g_number
451 ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
452 ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
453 ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
457 ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
454 ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
455 ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
456 ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
458 ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
459 ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
460 ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
461 ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
462 ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
463 ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
464 ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
465 ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
466 ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
467 ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
468 ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
469 ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
470 ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
471 ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
472 ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
473 ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
474 ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
475 ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
476 ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
477 ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
478 ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
479 ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
480 ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
481 ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
482 ,p_request_id in number default hr_api.g_number
483 ,p_program_application_id in number default hr_api.g_number
484 ,p_program_id in number default hr_api.g_number
485 ,p_program_update_date in date default hr_api.g_date
486 ,p_object_version_number in out nocopy number
487 ,p_effective_date in date
488 );
489 --
490 procedure update_enrt_prem
491 ( p_enrt_prem_id in number
492 ,p_val in number default hr_api.g_number
493 ,p_uom in varchar2 default hr_api.g_varchar2
494 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
495 ,p_enrt_bnft_id in number default hr_api.g_number
496 ,p_actl_prem_id in number default hr_api.g_number
497 ,p_business_group_id in number default hr_api.g_number
498 ,p_epr_attribute_category in varchar2 default hr_api.g_varchar2
499 ,p_epr_attribute1 in varchar2 default hr_api.g_varchar2
500 ,p_epr_attribute2 in varchar2 default hr_api.g_varchar2
501 ,p_epr_attribute3 in varchar2 default hr_api.g_varchar2
502 ,p_epr_attribute4 in varchar2 default hr_api.g_varchar2
503 ,p_epr_attribute5 in varchar2 default hr_api.g_varchar2
504 ,p_epr_attribute6 in varchar2 default hr_api.g_varchar2
505 ,p_epr_attribute7 in varchar2 default hr_api.g_varchar2
506 ,p_epr_attribute8 in varchar2 default hr_api.g_varchar2
507 ,p_epr_attribute9 in varchar2 default hr_api.g_varchar2
508 ,p_epr_attribute10 in varchar2 default hr_api.g_varchar2
509 ,p_epr_attribute11 in varchar2 default hr_api.g_varchar2
510 ,p_epr_attribute12 in varchar2 default hr_api.g_varchar2
511 ,p_epr_attribute13 in varchar2 default hr_api.g_varchar2
512 ,p_epr_attribute14 in varchar2 default hr_api.g_varchar2
513 ,p_epr_attribute15 in varchar2 default hr_api.g_varchar2
514 ,p_epr_attribute16 in varchar2 default hr_api.g_varchar2
515 ,p_epr_attribute17 in varchar2 default hr_api.g_varchar2
516 ,p_epr_attribute18 in varchar2 default hr_api.g_varchar2
517 ,p_epr_attribute19 in varchar2 default hr_api.g_varchar2
518 ,p_epr_attribute20 in varchar2 default hr_api.g_varchar2
519 ,p_epr_attribute21 in varchar2 default hr_api.g_varchar2
520 ,p_epr_attribute22 in varchar2 default hr_api.g_varchar2
521 ,p_epr_attribute23 in varchar2 default hr_api.g_varchar2
522 ,p_epr_attribute24 in varchar2 default hr_api.g_varchar2
523 ,p_epr_attribute25 in varchar2 default hr_api.g_varchar2
524 ,p_epr_attribute26 in varchar2 default hr_api.g_varchar2
525 ,p_epr_attribute27 in varchar2 default hr_api.g_varchar2
526 ,p_epr_attribute28 in varchar2 default hr_api.g_varchar2
527 ,p_epr_attribute29 in varchar2 default hr_api.g_varchar2
528 ,p_epr_attribute30 in varchar2 default hr_api.g_varchar2
529 ,p_object_version_number in out nocopy number
530 ,p_request_id in number default hr_api.g_number
531 ,p_program_application_id in number default hr_api.g_number
532 ,p_program_id in number default hr_api.g_number
533 ,p_program_update_date in date default hr_api.g_date
534 );
535 --
536 procedure update_enrt_ctfn
537 ( p_elctbl_chc_ctfn_id in number
541 ,p_enrt_bnft_id in number default hr_api.g_number
538 ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
539 ,p_rqd_flag in varchar2 default hr_api.g_varchar2
540 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
542 ,p_business_group_id in number default hr_api.g_number
543 ,p_ecc_attribute_category in varchar2 default hr_api.g_varchar2
544 ,p_ecc_attribute1 in varchar2 default hr_api.g_varchar2
545 ,p_ecc_attribute2 in varchar2 default hr_api.g_varchar2
546 ,p_ecc_attribute3 in varchar2 default hr_api.g_varchar2
547 ,p_ecc_attribute4 in varchar2 default hr_api.g_varchar2
548 ,p_ecc_attribute5 in varchar2 default hr_api.g_varchar2
549 ,p_ecc_attribute6 in varchar2 default hr_api.g_varchar2
550 ,p_ecc_attribute7 in varchar2 default hr_api.g_varchar2
551 ,p_ecc_attribute8 in varchar2 default hr_api.g_varchar2
552 ,p_ecc_attribute9 in varchar2 default hr_api.g_varchar2
553 ,p_ecc_attribute10 in varchar2 default hr_api.g_varchar2
554 ,p_ecc_attribute11 in varchar2 default hr_api.g_varchar2
555 ,p_ecc_attribute12 in varchar2 default hr_api.g_varchar2
556 ,p_ecc_attribute13 in varchar2 default hr_api.g_varchar2
557 ,p_ecc_attribute14 in varchar2 default hr_api.g_varchar2
558 ,p_ecc_attribute15 in varchar2 default hr_api.g_varchar2
559 ,p_ecc_attribute16 in varchar2 default hr_api.g_varchar2
560 ,p_ecc_attribute17 in varchar2 default hr_api.g_varchar2
561 ,p_ecc_attribute18 in varchar2 default hr_api.g_varchar2
562 ,p_ecc_attribute19 in varchar2 default hr_api.g_varchar2
563 ,p_ecc_attribute20 in varchar2 default hr_api.g_varchar2
564 ,p_ecc_attribute21 in varchar2 default hr_api.g_varchar2
565 ,p_ecc_attribute22 in varchar2 default hr_api.g_varchar2
566 ,p_ecc_attribute23 in varchar2 default hr_api.g_varchar2
567 ,p_ecc_attribute24 in varchar2 default hr_api.g_varchar2
568 ,p_ecc_attribute25 in varchar2 default hr_api.g_varchar2
569 ,p_ecc_attribute26 in varchar2 default hr_api.g_varchar2
570 ,p_ecc_attribute27 in varchar2 default hr_api.g_varchar2
571 ,p_ecc_attribute28 in varchar2 default hr_api.g_varchar2
572 ,p_ecc_attribute29 in varchar2 default hr_api.g_varchar2
573 ,p_ecc_attribute30 in varchar2 default hr_api.g_varchar2
574 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
575 ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
576 ,p_request_id in number default hr_api.g_number
577 ,p_program_application_id in number default hr_api.g_number
578 ,p_program_id in number default hr_api.g_number
579 ,p_program_update_date in date default hr_api.g_date
580 ,p_object_version_number in out nocopy number
581 ,p_effective_date in date
582 );
583 --
584 PROCEDURE end_date_elig_per_rows (
585 p_person_id IN NUMBER,
586 p_per_in_ler_id IN NUMBER,
587 p_effective_date IN DATE
588 );
589
590 end ben_manage_unres_life_events;
[Home] [Help]