7033: p_per_in_ler_id;
7034: p_person_id;
7035: */
7036: --- Determine FONM for delete enrollment
7037: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7038:
7039: if l_pen.fonm_cvg_strt_dt is not null then
7040: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7041: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7036: --- Determine FONM for delete enrollment
7037: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7038:
7039: if l_pen.fonm_cvg_strt_dt is not null then
7040: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7041: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7042: end if ;
7043:
7044: else
7037: if nvl( ben_manage_life_events.fonm,'N') = 'Y' then
7038:
7039: if l_pen.fonm_cvg_strt_dt is not null then
7040: if l_pen.fonm_cvg_strt_dt <> ben_manage_life_events.g_fonm_cvg_strt_dt then
7041: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7042: end if ;
7043:
7044: else
7045: -- set theflag and date to null
7042: end if ;
7043:
7044: else
7045: -- set theflag and date to null
7046: ben_manage_life_events.fonm := 'N';
7047: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7048: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7049:
7050: end if ;
7043:
7044: else
7045: -- set theflag and date to null
7046: ben_manage_life_events.fonm := 'N';
7047: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7048: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7049:
7050: end if ;
7051: else
7044: else
7045: -- set theflag and date to null
7046: ben_manage_life_events.fonm := 'N';
7047: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7048: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7049:
7050: end if ;
7051: else
7052: if l_pen.fonm_cvg_strt_dt is not null then
7049:
7050: end if ;
7051: else
7052: if l_pen.fonm_cvg_strt_dt is not null then
7053: ben_manage_life_events.fonm := 'Y';
7054: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7055: else
7056: ben_manage_life_events.fonm := 'N';
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7050: end if ;
7051: else
7052: if l_pen.fonm_cvg_strt_dt is not null then
7053: ben_manage_life_events.fonm := 'Y';
7054: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7055: else
7056: ben_manage_life_events.fonm := 'N';
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7052: if l_pen.fonm_cvg_strt_dt is not null then
7053: ben_manage_life_events.fonm := 'Y';
7054: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7055: else
7056: ben_manage_life_events.fonm := 'N';
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7059: end if ;
7060: end if ;
7053: ben_manage_life_events.fonm := 'Y';
7054: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7055: else
7056: ben_manage_life_events.fonm := 'N';
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7059: end if ;
7060: end if ;
7061: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7054: ben_manage_life_events.g_fonm_cvg_strt_dt := l_pen.fonm_cvg_strt_dt ;
7055: else
7056: ben_manage_life_events.fonm := 'N';
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7059: end if ;
7060: end if ;
7061: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7062: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7057: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7059: end if ;
7060: end if ;
7061: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7062: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7063: -- eof FONM
7064:
7065: ben_determine_date.rate_and_coverage_dates
7058: ben_manage_life_events.g_fonm_rt_strt_dt := null;
7059: end if ;
7060: end if ;
7061: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
7062: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7063: -- eof FONM
7064:
7065: ben_determine_date.rate_and_coverage_dates
7066: (p_which_dates_cd => 'C'