DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_MANAGE_UNRES_LIFE_EVENTS

Line 4412: l_epe_exists := ben_manage_unres_life_events.epe_exists

4408: --bug#4096382
4409: elsif l_currepe_dets.elig_per_elctbl_chc_id is not null and
4410: p_run_mode in ('U','R') THEN
4411: --
4412: l_epe_exists := ben_manage_unres_life_events.epe_exists
4413: (p_per_in_ler_id => l_per_in_ler_id,
4414: p_pgm_id => p_pgm_id,
4415: p_pl_id => l_pl_id,
4416: p_oipl_id =>p_oipl_id);

Line 7002: l_epe_exists := ben_manage_unres_life_events.epe_exists

6998: if g_debug then
6999: hr_utility.set_location('before epe exists',11);
7000: end if;
7001: --
7002: l_epe_exists := ben_manage_unres_life_events.epe_exists
7003: (p_per_in_ler_id => l_per_in_ler_id,
7004: p_pgm_id => p_pgm_id,
7005: p_pl_id => l_pl_id,
7006: p_oipl_id =>p_oipl_id);

Line 7008: ben_manage_unres_life_events.update_elig_per_elctbl_choice

7004: p_pgm_id => p_pgm_id,
7005: p_pl_id => l_pl_id,
7006: p_oipl_id =>p_oipl_id);
7007: if l_epe_exists is not null then
7008: ben_manage_unres_life_events.update_elig_per_elctbl_choice
7009: (
7010: p_elig_per_elctbl_chc_id => l_epe_exists,
7011: p_business_group_id => p_business_group_id,
7012: p_auto_enrt_flag => NVL(l_rec_auto_enrt_flag,'N'),

Line 7266: l_epe_exists := ben_manage_unres_life_events.epe_exists

7262: if g_debug then
7263: hr_utility.set_location('before epe exists',11);
7264: end if;
7265: --
7266: l_epe_exists := ben_manage_unres_life_events.epe_exists
7267: (p_per_in_ler_id => l_per_in_ler_id,
7268: p_pgm_id => p_pgm_id,
7269: p_pl_id => l_pl_id,
7270: p_oipl_id =>-1);

Line 7282: ben_manage_unres_life_events.update_elig_per_elctbl_choice

7278: -- If its the new PIL, epe_exists will b null, but if exists in the DB,
7279: -- then just update it.
7280: -- for savings plan: PLAN epe shd be updated with pen_id
7281: --
7282: ben_manage_unres_life_events.update_elig_per_elctbl_choice
7283: (p_elig_per_elctbl_chc_id => nvl(l_epe_exists,l_choice_exists_flag),
7284: p_business_group_id => p_business_group_id,
7285: p_auto_enrt_flag => 'N',
7286: p_per_in_ler_id => l_per_in_ler_id,