Search Results ben_pen_ler




Overview
Explore in AI Chat

Overview

BEN_PEN_LER is a PL/SQL package in the APPS schema that supports the Life Event (LE) rules engine within Oracle Advanced Benefits (OAB). The "PEN" and "LER" components of the name designate it as a processor for Life Event Rules, the configuration objects that determine which life events a participant may report and which benefits-related consequences those events trigger. In Oracle EBS 12.1.1 and 12.2.2, life event rules drive enrollment opportunities, eligibility recalculation, and the opening of restricted enrollment windows after qualifying events. BEN_PEN_LER provides supporting logic for validating and processing life event data, functioning as a utility layer invoked from the broader life event trigger framework rather than as a standalone user-facing program. The package holds a VALID status in the ETRM 12.2.2 metadata and is classified as an OTHER API object, indicating it is intended primarily for internal use by other benefits modules rather than as a public integration interface.

Key Procedures and Functions

The documented ETRM metadata identifies a single program unit in BEN_PEN_LER:

  • LER_CHK — The lone documented procedure/function. Its name and the tables it accesses indicate that it performs life event rule checking: verifying the conditions, participant relationships, and related-person change criteria defined for a life event rule. It is not documented with a public parameter list, so its invocation should be treated as an internal contract between BEN_PEN_LER and its callers.

No other procedures or functions are catalogued for this package in the supplied metadata.

Tables Accessed

BEN_PEN_LER references a focused set of benefits and HR tables through APPS synonyms:

  • BEN_LER_F — The core Life Event Rules table, holding rule definitions and processing attributes evaluated during the check.
  • BEN_LER_PER_INFO_CS_LER_F, BEN_LER_RLTD_PER_CS_LER_F, BEN_PER_INFO_CHG_CS_LER_F, and BEN_RLTD_PER_CHG_CS_LER_F — The life event rule "change" setup tables covering person information changes and related-person changes, which define the criteria a reported event must satisfy.
  • BEN_PTNL_LER_FOR_PER — Potential life events for a person, used to match an event against the rules available to that participant.
  • PER_CONTACT_RELATIONSHIPS — Determines the relationship between a participant and a related person (for example, spouse or dependent) where related-person rules apply.
  • FND_SESSIONS — Used for session context, typically to identify the current user or session during processing.
  • DUAL and PLITBLM — Standard Oracle utilities used within the package for scalar evaluation and PL/SQL table handling.

Usage Notes

BEN_PEN_LER is referenced by BEN_DT_TRGR_HANDLE, the Date Trigger Handler that forms part of the benefits life event processing framework. This confirms the package is invoked indirectly during event processing rather than called directly from a form or concurrent program. It also references itself internally, indicating recursive or helper calls within its own logic. In practice, this package is executed when the life event rules engine evaluates whether reported events for a participant meet the configured rule criteria, typically in support of the Manage Life Events flows and date-triggered event handling. Developers should not call BEN_PEN_LER directly in custom code; instead, they should use the supported life event APIs and let the trigger handler orchestrate invocation. Any modification to life event rules should be tested through the standard benefits event flows, and the package should not be altered, as it is an Oracle-owned object subject to patching and upgrade in both 12.1.1 and 12.2.2.