Search Results call_defaults

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:

• P_LF_EVT_CLPS_RESTORE — the primary driver procedure that orchestrates the restore of a life event collapse.
• REINSTATE_THE_PREV_ENRT_RSLT — reinstates the previous enrollment result records that were displaced by the collapse.
• REINSTATE_PCS_PER_PEN — reinstates per-participant/per-plan records.
• REINSTATE_PEA_PER_PEN — reinstates participant eligibility/activity records on a per-participant basis.
• GET_ORI_BCKDT_PIL and ELE_MADE_FOR_BCKDT_PIL — retrieve and identify the original back-dated plan-in-life information and the election made against it.
• COMP_ORI_NEW_PIL_OUTCOME — computes the outcome between the original and new plan-in-life data.
• VOID_LITERATURE — voids benefit literature associated with the collapsed event.
• PAD_CMNT_TO_RSND_LIT — appends comments when literature is re-sent.
• EXTEND_ENRT_DATE — extends the enrollment date range as part of the restore.
• UPDATE_PTNL_PER_FOR_LER — updates potential periods linked to the life event reason.
• P_REINSTATE_INFO_TO_FORM — passes reinstated data back to the calling form.
• CHECK_PL_TYP_DEFAULTED and CALL_DEFAULTS — validate whether a plan type was defaulted and invoke defaulting logic.

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.