[Home] [Help]
323: date-1 or effective date -1.
324: Changed remove_cert_action_items.
325: 115.142 20-jul-00 kmahendr Effective date is to be passed if effective date -1 >
326: life event occurred - related to version -115.141
327: 115.143 11-aug-00 gperry Fixed call to ben_determine_date.
328: Was passing cvg_end_dt_cd and
329: cvg_strt_dt_rl. Should have passed
330: cvg_end_dt_rl.
331: Fix for WWBUG 1375481.
427: benuneai, pass this to p_called_from parameter of
428: unhook_dpnt.
429: 2. When elig_per_elctbl_chc_id is null, we need to pass
430: lee_rsn_id and enrt_perd_id also along with pgm,pl,oipl
431: to ben_determine_date.rate_and_coverage_dates call.
432: 115.184 25-Jun-02 tjesumic bug:2479616 for the 1 prior rate end date code, the date is
433: calcualted on coverage start date, that was changed to
434: calculate on rate start date
435: 115.185 05-Jul-02 ikasire bug:2479616 fixed a typo in the 1 prior rate if condition
2002: open c_pel(p_elig_per_elctbl_chc_id);
2003: fetch c_pel into l_pel;
2004: close c_pel;
2005:
2006: ben_determine_date.rate_and_coverage_dates
2007: (p_which_dates_cd => 'R'
2008: ,p_date_mandatory_flag => 'Y'
2009: ,p_compute_dates_flag => 'Y'
2010: ,p_business_group_id => p_business_group_id
3858: open c_pel(l_prem.elig_per_elctbl_chc_id);
3859: fetch c_pel into l_pel;
3860: close c_pel;
3861:
3862: ben_determine_date.rate_and_coverage_dates
3863: (p_which_dates_cd => 'R'
3864: ,p_date_mandatory_flag => 'Y'
3865: ,p_compute_dates_flag => 'Y'
3866: ,p_business_group_id => p_business_group_id
5384: hr_utility.set_location('dpnt_strt_cd'|| l_cvg_strt_cd,15);
5385: end if;
5386: if (p_calc_strt_dt and l_cvg_strt_cd is not NULL) then
5387: l_step := 20;
5388: ben_determine_date.main
5389: (P_DATE_CD => l_cvg_strt_cd
5390: ,p_formula_id => l_cvg_strt_rl
5391: ,P_ELIG_PER_ELCTBL_CHC_ID => p_elig_per_elctbl_chc_id
5392: ,P_BUSINESS_GROUP_ID => p_business_group_id
5397: l_cvg_strt_dt := NULL;
5398: end if;
5399: if (p_calc_end_dt and l_cvg_end_cd is not NULL) then
5400: l_step := 30;
5401: ben_determine_date.main
5402: (P_DATE_CD => l_cvg_end_cd
5403: ,p_formula_id => l_cvg_end_rl
5404: ,p_enrt_cvg_end_dt => p_enrt_cvg_end_dt
5405: ,P_ELIG_PER_ELCTBL_CHC_ID => p_elig_per_elctbl_chc_id
5425: ,p_cvg_end_rl => l_cvg_end_rl
5426: );
5427: if (p_calc_strt_dt and l_cvg_strt_cd is not null) then
5428: l_step := 50;
5429: ben_determine_date.main
5430: (P_DATE_CD => l_cvg_strt_cd
5431: ,p_formula_id => l_cvg_strt_rl
5432: ,P_PER_IN_LER_ID => p_per_in_ler_id
5433: ,P_PERSON_ID => p_person_id
5442: l_cvg_strt_dt := NULL;
5443: end if;
5444: if (p_calc_end_dt and l_cvg_end_cd is not NULL) then
5445: l_step := 60;
5446: ben_determine_date.main
5447: (P_DATE_CD => l_cvg_end_cd
5448: ,p_formula_id => l_cvg_end_rl
5449: ,p_enrt_cvg_end_dt => p_enrt_cvg_end_dt
5450: ,P_PER_IN_LER_ID => p_per_in_ler_id
7403: if c_enrt_rt%found then
7404: close c_enrt_rt;
7405: hr_utility.set_location('l_enrt_rt.elig_per_elctbl_chc_id '|| l_enrt_rt.enb_per_elctbl_chc_id, 10);
7406: --
7407: ben_determine_date.rate_and_coverage_dates
7408: (p_which_dates_cd => 'R'
7409: ,p_business_group_id => p_business_group_id
7410: ,p_elig_per_elctbl_chc_id => nvl(l_enrt_rt.elig_per_elctbl_chc_id,
7411: l_enrt_rt.enb_per_elctbl_chc_id)
7704: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7705: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7706: -- eof FONM
7707:
7708: ben_determine_date.rate_and_coverage_dates
7709: (p_which_dates_cd => 'C'
7710: ,p_date_mandatory_flag => 'N'
7711: ,p_compute_dates_flag => 'N'
7712: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7743: return;
7744: end if;
7745:
7746: --
7747: ben_determine_date.rate_and_coverage_dates
7748: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7749: ,p_business_group_id => l_pen.business_group_id
7750: ,P_PER_IN_LER_ID => l_pen.per_in_ler_id
7751: ,P_PERSON_ID => l_pen.person_id
7775: substr(nvl(l_rt_end_dt_cd, 'X'), 1, 2) = 'LW' or ------Bug 7209243
7776: l_rt_end_dt_cd in ('LDPPOEFD','LDPPFEFD','LODBEWM','ODBEWM')) ------Bug 7209243
7777: and l_ler_typ_cd not in ('IREC','GSP','COMP','ABS','SCHEDDU') then
7778: --determine new rt start date
7779: ben_determine_date.rate_and_coverage_dates
7780: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
7781: ,p_business_group_id => l_pen.business_group_id
7782: ,P_PER_IN_LER_ID => l_pen.per_in_ler_id
7783: ,P_PERSON_ID => l_pen.person_id
8586: ---get the new rt start dat to compute the end date
8587: open c_get_epe(l_pen.pl_typ_id);
8588: fetch c_get_epe into l_get_epe;
8589: if c_get_epe%found then
8590: ben_determine_date.rate_and_coverage_dates
8591: (p_elig_per_elctbl_chc_id => l_get_epe.elig_per_elctbl_chc_id
8592: ,p_business_group_id => l_get_epe.business_group_id
8593: ,P_PER_IN_LER_ID => l_get_epe.per_in_ler_id
8594: ,P_PERSON_ID => l_pen.person_id
10192: if c_enrt_rt%found then
10193: close c_enrt_rt;
10194: hr_utility.set_location('l_enrt_rt.elig_per_elctbl_chc_id '|| l_enrt_rt.enb_per_elctbl_chc_id, 10);
10195: --
10196: ben_determine_date.rate_and_coverage_dates
10197: (p_which_dates_cd => 'R'
10198: ,p_business_group_id => p_business_group_id
10199: ,p_elig_per_elctbl_chc_id => nvl(l_enrt_rt.elig_per_elctbl_chc_id,
10200: l_enrt_rt.enb_per_elctbl_chc_id)