Search Results ben_pro_ler




Overview
Explore in AI Chat

Overview

BEN_PRO_LER is a PL/SQL package owned by the APPS schema that supports the Life Event Registry (LER) and Life Event processing framework within Oracle Advanced Benefits (OAB). The "PRO" designation indicates that this package is associated with processing routines tied to a specific life event category — in this case, processing related to changes in pay proposals (pay rate changes) that qualify as life events. The package forms part of the eligibility determination layer that governs whether an assignment experiences a qualifying life event and, if so, whether that event triggers enrollment or benefit plan changes in Oracle EBS 12.1.1 and 12.2.2.

The ETRM record classifies BEN_PRO_LER under API classification "OTHER," meaning it is not exposed as a formal public API but functions as an internal processing engine called from within the benefits life event pipeline. Its status is VALID in both releases.

Key Procedures and Functions

The documented metadata identifies two procedures/functions within BEN_PRO_LER:

  • LER_CHK — Performs the core life event check logic. It evaluates assignment, person, and pay-related data to determine whether a qualifying life event exists for the assignment under processing. This is the primary entry point invoked by the LER framework to validate and record life event triggers.
  • QUA_IN_GR_LER_CHK — Handles life event checking specific to qualification within a grade (QUA_IN_GR), determining whether a change in the person's grade or associated pay grade rules constitutes a qualifying life event. This procedure is narrower in scope than LER_CHK and targets grade-driven eligibility transitions.

No parameter lists are documented in the ETRM record, and callers should obtain signature details from the package specification in the EBS instance.

Tables Accessed

BEN_PRO_LER reads and writes against a defined set of APPS synonym tables supporting benefits, payroll, and HR data:

The package also references BEN_ASG_LER and STANDARD, and is referenced by BEN_ASG_LER, PER_PYP_INS, and PER_PYP_UPD, indicating tight integration with the assignment-level LER handler and payroll proposal insert/update logic.

Usage Notes

BEN_PRO_LER is an internal processing package and should not be invoked directly by custom code without close analysis of transaction context. It is typically called through the benefits life event processing framework — most commonly initiated by payroll proposal changes (PER_PYP_INS/PER_PYP_UPD) or assignment updates that trigger the LER engine. Because it writes to life event and potential life event tables, improper invocation can generate erroneous qualifying events.

When troubleshooting benefits eligibility issues tied to pay or grade changes, DBAs and developers commonly trace execution into BEN_PRO_LER via BEN_ASG_LER. All schema-defined grants are APPS-only, so any custom invocation must run under the APPS schema or with equivalent privileges.