APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_MANAGE_UNRES_LIFE_EVENTS

Line 639: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

635: --
636: if p_mode in ('U','R') then
637: --
638: l_elig_per_elctbl_chc_id := null;
639: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
640: (p_per_in_ler_id => p_per_in_ler_id,
641: p_pgm_id => l_epe_pgm.pgm_id,
642: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
643: p_comp_lvl_cd =>'PGM');

Line 649: ben_manage_unres_life_events.update_elig_per_elctbl_choice

645: end if;
646: --
647: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
648: --
649: ben_manage_unres_life_events.update_elig_per_elctbl_choice
650: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
651: p_elctbl_flag => 'N',
652: p_comp_lvl_cd => 'PGM',
653: p_pgm_id => l_epe_pgm.pgm_id,

Line 789: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

785: --
786: if p_mode in ('U','R') then
787: --
788: l_elig_per_elctbl_chc_id := null;
789: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
790: (p_per_in_ler_id => p_per_in_ler_id,
791: p_pgm_id => l_epe_plip.pgm_id,
792: p_plip_id => l_epe_plip.plip_id,
793: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,

Line 800: ben_manage_unres_life_events.update_elig_per_elctbl_choice

796: end if;
797: --
798: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
799: --
800: ben_manage_unres_life_events.update_elig_per_elctbl_choice
801: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
802: p_elctbl_flag => 'N',
803: p_comp_lvl_cd => 'PLIP',
804: p_pgm_id => l_epe_plip.pgm_id,

Line 960: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

956: l_num_cmbn := l_num_cmbn+1;
957: if p_mode in ('U','R') then
958: --
959: l_elig_per_elctbl_chc_id := null;
960: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
961: (p_per_in_ler_id => p_per_in_ler_id,
962: p_cmbn_plip_id => l_cmbn_plip_id,
963: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
964: p_comp_lvl_cd =>'CPLIP');

Line 970: ben_manage_unres_life_events.update_elig_per_elctbl_choice

966: end if;
967: --
968: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
969: --
970: ben_manage_unres_life_events.update_elig_per_elctbl_choice
971: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
972: p_elctbl_flag => 'N',
973: p_comp_lvl_cd => 'CPLIP',
974: p_pgm_id => l_epe_plip.pgm_id,

Line 1094: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

1090: --
1091: if p_mode in ('U','R') then
1092: --
1093: l_elig_per_elctbl_chc_id := null;
1094: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
1095: (p_per_in_ler_id => p_per_in_ler_id,
1096: p_pgm_id => l_epe_ptip.pgm_id,
1097: p_ptip_id => l_epe_ptip.ptip_id,
1098: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,

Line 1105: ben_manage_unres_life_events.update_elig_per_elctbl_choice

1101: end if;
1102: --
1103: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
1104: --
1105: ben_manage_unres_life_events.update_elig_per_elctbl_choice
1106: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1107: p_elctbl_flag => 'N',
1108: p_comp_lvl_cd => 'PTIP',
1109: p_pgm_id => l_epe_ptip.pgm_id,

Line 1234: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

1230: --
1231: if p_mode in ('U','R') then
1232: --
1233: l_elig_per_elctbl_chc_id := null;
1234: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
1235: (p_per_in_ler_id => p_per_in_ler_id,
1236: p_pgm_id => l_epe_ptip.pgm_id,
1237: p_cmbn_ptip_id => l_cmbn_ptip_id,
1238: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,

Line 1245: ben_manage_unres_life_events.update_elig_per_elctbl_choice

1241: end if;
1242: --
1243: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
1244: --
1245: ben_manage_unres_life_events.update_elig_per_elctbl_choice
1246: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1247: p_elctbl_flag => 'N',
1248: p_comp_lvl_cd => 'CPTIP',
1249: p_pgm_id => l_epe_ptip.pgm_id,

Line 1429: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

1425: --
1426: if p_mode in ('U','R') then
1427: --
1428: l_elig_per_elctbl_chc_id := null;
1429: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
1430: (p_per_in_ler_id => p_per_in_ler_id,
1431: p_pgm_id => l_epe_oipl.pgm_id,
1432: p_oiplip_id => l_epe_oipl.oiplip_id,
1433: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,

Line 1440: ben_manage_unres_life_events.update_elig_per_elctbl_choice

1436: end if;
1437: --
1438: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
1439: --
1440: ben_manage_unres_life_events.update_elig_per_elctbl_choice
1441: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1442: p_elctbl_flag => 'N',
1443: p_comp_lvl_cd => 'OIPLIP',
1444: p_pgm_id => l_epe_oipl.pgm_id,

Line 1634: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists

1630:
1631: if p_mode in ('U','R') then
1632: --
1633: l_elig_per_elctbl_chc_id := null;
1634: l_elig_per_elctbl_chc_id := ben_manage_unres_life_events.epe_exists
1635: (p_per_in_ler_id => p_per_in_ler_id,
1636: p_pgm_id => l_epe_oipl.pgm_id,
1637: p_cmbn_ptip_opt_id => l_cmbn_ptip_opt_id,
1638: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,

Line 1645: ben_manage_unres_life_events.update_elig_per_elctbl_choice

1641: end if;
1642: --
1643: if l_elig_per_elctbl_chc_id is not null and p_mode in ('U','R') then
1644: --
1645: ben_manage_unres_life_events.update_elig_per_elctbl_choice
1646: (p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id,
1647: p_elctbl_flag => 'N',
1648: p_comp_lvl_cd => 'CPTIPOPT',
1649: p_pgm_id => l_epe_oipl.pgm_id,