Search Results ben_lf_evt_clps_restore




Overview
Explore in AI Chat

Overview

APPS.BEN_LF_EVT_CLPS_RESTORE is a PL/SQL package within the Oracle E-Benefits (Advanced Benefits) module of Oracle EBS 12.1.1 and 12.2.2. Its business purpose is to restore, reinstate, or reverse the effects of a Life Event collapse (closing) that was previously applied to a participant's enrollment results. When a Life Event is processed, Oracle Benefits may collapse or close existing enrollments, eligibility records, and related results. If that collapse must be undone — due to a back-out, a correction, or a reversal of a prior life event — this package performs the restore logic that returns the participant's records to their pre-collapse state. The package is classified as OTHER in the ETRM registry and currently holds a VALID status in the APPS schema.

The name itself reflects its role: LF denotes Life Event, EVT denotes event, and CLPS_RESTORE denotes restore of a collapse. It therefore operates as a supporting utility invoked primarily during life event back-out processing and reinstatement scenarios.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions that collectively handle the restoration workflow:

Tables Accessed

The package reads and writes a broad set of Benefits base tables through APPS synonyms, including BEN_ENRT_BNFT and BEN_ENRT_RT (enrollment benefits and rates), BEN_ELIG_PER_ELCTBL_CHC, BEN_ELIG_DPNT, and BEN_ELIG_CVRD_DPNT_F (eligibility and covered dependent records), BEN_ACTY_BASE_RT_F (activity base rates), BEN_APLCN_TO_BNFT_POOL_F, BEN_BNFT_PRVDR_POOL_F, and BEN_BNFT_PRVDD_LDGR_F (benefit pool and provided ledger records), BEN_CBR_PER_IN_LER and BEN_CBR_QUALD_BNF (compensation and qualified beneficiary links), BEN_CM_TRGR (communication triggers), and BEN_LE_CLSN_N_RSTR, which stores the life event closure and restoration linkage. BEN_LER_F provides the life event reason definition used to drive the logic.

Usage Notes

BEN_LF_EVT_CLPS_RESTORE is referenced by nine other packages, notably BEN_BACK_OUT_LIFE_EVENT, BEN_MANAGE_LIFE_EVENTS, and BEN_ON_LINE_LF_EVT. It is therefore invoked indirectly through the standard Benefits back-out and life event management flows rather than called directly by end users. The P_REINSTATE_INFO_TO_FORM procedure indicates integration with the OAB (Online Activities and Benefits) forms, where reinstated data is displayed back to the user. It depends on BEN_LER_F and standard SYS objects. Customizations that need to reverse a life event collapse programmatically should call this package rather than manipulating the underlying tables directly, to preserve data integrity.