7676: p_per_in_ler_id;
7677: p_person_id;
7678: */
7679: --- Determine FONM for delete enrollment
7680: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7681:
7682: if l_pen.fonm_cvg_strt_dt is not null then
7683: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7684: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7679: --- Determine FONM for delete enrollment
7680: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7681:
7682: if l_pen.fonm_cvg_strt_dt is not null then
7683: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7684: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7685: end if ;
7686:
7687: else
7680: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7681:
7682: if l_pen.fonm_cvg_strt_dt is not null then
7683: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7684: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7685: end if ;
7686:
7687: else
7688: -- set theflag and date to null
7685: end if ;
7686:
7687: else
7688: -- set theflag and date to null
7689: ben_manage_life_events.fonm := 'N';
7690: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7691: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7692:
7693: end if ;
7686:
7687: else
7688: -- set theflag and date to null
7689: ben_manage_life_events.fonm := 'N';
7690: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7691: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7692:
7693: end if ;
7694: else
7687: else
7688: -- set theflag and date to null
7689: ben_manage_life_events.fonm := 'N';
7690: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7691: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7692:
7693: end if ;
7694: else
7695: if l_pen.fonm_cvg_strt_dt is not null then
7692:
7693: end if ;
7694: else
7695: if l_pen.fonm_cvg_strt_dt is not null then
7696: ben_manage_life_events.fonm := 'Y';
7697: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7698: else
7699: ben_manage_life_events.fonm := 'N';
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7693: end if ;
7694: else
7695: if l_pen.fonm_cvg_strt_dt is not null then
7696: ben_manage_life_events.fonm := 'Y';
7697: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7698: else
7699: ben_manage_life_events.fonm := 'N';
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7695: if l_pen.fonm_cvg_strt_dt is not null then
7696: ben_manage_life_events.fonm := 'Y';
7697: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7698: else
7699: ben_manage_life_events.fonm := 'N';
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7702: end if ;
7703: end if ;
7696: ben_manage_life_events.fonm := 'Y';
7697: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7698: else
7699: ben_manage_life_events.fonm := 'N';
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7702: end if ;
7703: end if ;
7704: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7697: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7698: else
7699: ben_manage_life_events.fonm := 'N';
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7702: end if ;
7703: end if ;
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 ) ;
7700: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7702: end if ;
7703: end if ;
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
7701: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7702: end if ;
7703: end if ;
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'