DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_MANAGE_UNRES_LIFE_EVENTS

Line 4322: l_epe_exists := ben_manage_unres_life_events.epe_exists

4318: --bug#4096382
4319: elsif l_currepe_dets.elig_per_elctbl_chc_id is not null and
4320: p_run_mode in ('U','R') THEN
4321: --
4322: l_epe_exists := ben_manage_unres_life_events.epe_exists
4323: (p_per_in_ler_id => l_per_in_ler_id,
4324: p_pgm_id => p_pgm_id,
4325: p_pl_id => l_pl_id,
4326: p_oipl_id =>p_oipl_id);

Line 6868: l_epe_exists := ben_manage_unres_life_events.epe_exists

6864: if g_debug then
6865: hr_utility.set_location('before epe exists',11);
6866: end if;
6867: --
6868: l_epe_exists := ben_manage_unres_life_events.epe_exists
6869: (p_per_in_ler_id => l_per_in_ler_id,
6870: p_pgm_id => p_pgm_id,
6871: p_pl_id => l_pl_id,
6872: p_oipl_id =>p_oipl_id);

Line 6874: ben_manage_unres_life_events.update_elig_per_elctbl_choice

6870: p_pgm_id => p_pgm_id,
6871: p_pl_id => l_pl_id,
6872: p_oipl_id =>p_oipl_id);
6873: if l_epe_exists is not null then
6874: ben_manage_unres_life_events.update_elig_per_elctbl_choice
6875: (
6876: p_elig_per_elctbl_chc_id => l_epe_exists,
6877: p_business_group_id => p_business_group_id,
6878: p_auto_enrt_flag => NVL(l_rec_auto_enrt_flag,'N'),

Line 7130: l_epe_exists := ben_manage_unres_life_events.epe_exists

7126: if g_debug then
7127: hr_utility.set_location('before epe exists',11);
7128: end if;
7129: --
7130: l_epe_exists := ben_manage_unres_life_events.epe_exists
7131: (p_per_in_ler_id => l_per_in_ler_id,
7132: p_pgm_id => p_pgm_id,
7133: p_pl_id => l_pl_id,
7134: p_oipl_id =>-1);

Line 7146: ben_manage_unres_life_events.update_elig_per_elctbl_choice

7142: -- If its the new PIL, epe_exists will b null, but if exists in the DB,
7143: -- then just update it.
7144: -- for savings plan: PLAN epe shd be updated with pen_id
7145: --
7146: ben_manage_unres_life_events.update_elig_per_elctbl_choice
7147: (p_elig_per_elctbl_chc_id => nvl(l_epe_exists,l_choice_exists_flag),
7148: p_business_group_id => p_business_group_id,
7149: p_auto_enrt_flag => 'N',
7150: p_per_in_ler_id => l_per_in_ler_id,