Search Results ben_determine_dpnt_eligibility




Overview
Explore in AI Chat

Overview

BEN_DETERMINE_DPNT_ELIGIBILITY is an Oracle Applications (APPS) PL/SQL package within the Oracle Advanced Benefits (BEN) module. Its role is to evaluate and resolve dependent eligibility for benefits offerings in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Dependent eligibility is one of the most complex eligibility dimensions in Oracle Advanced Benefits, since a dependent's eligibility may depend on the primary participant's enrollment, the relationship of the dependent to the participant, the plan or program configuration, coverage tier rules, and life event activity. The package consolidates this logic so that the enrollment engine, life event processing, and eligibility determination routines can consistently decide whether a given dependent qualifies for a plan, program, or option.

The package is classified as an OTHER API in the ETRM registry, meaning it is an internal plumbing routine rather than a public, supported extension API. It is owned by APPS and reports a VALID status in the documented environment.

Key Procedures and Functions

The documented package exposes two procedures/functions:

  • MAIN — the primary entry point for the package. It orchestrates the dependent eligibility determination process, driving the evaluation rules that compare dependent records against eligibility definitions and coverage requirements for the participant and offering in context.
  • P_UPD_EGD_WITH_EPE_ID — a supporting routine that updates an eligibility record (an "EGD" row) with an associated eligibility/processing identifier ("EPE ID"). Its name indicates it performs a targeted update, likely persisting the outcome of eligibility processing back to the eligibility data structures used by downstream enrollment logic.

Parameter lists are not published in the documented metadata; callers should treat these as internal signatures and rely on the supported enrollment APIs rather than invoking them directly.

Tables Accessed

The package reads and writes a broad set of Advanced Benefits and HR tables through APPS synonyms. These include:

Collectively these tables supply the rules, the participant assignment context, the life event context, and the destination for eligibility outcomes.

Usage Notes

BEN_DETERMINE_DPNT_ELIGIBILITY is not intended for direct invocation by end users or customizations. The ETRM dependency information shows it is referenced by other APPS packages, including BEN_DETERMINE_DPNT_ELIGIBILITY (self-reference), BEN_ENROLMENT_REQUIREMENTS, and BEN_MANAGE_LIFE_EVENTS. This places the package inside the standard Advanced Benefits processing chain: it is called during enrollment requirement evaluation and during life event management when dependent eligibility must be recomputed. Typical triggers include running the Participation and Eligibility process, processing a life event that changes dependent coverage, or invoking the enrollment requirements engine from the Benefits forms. Custom code should target the supported Oracle Advanced Benefits public APIs rather than calling MAIN or P_UPD_EGD_WITH_EPE_ID directly, since their signatures and internal logic may change across patch levels and are not guaranteed by Oracle support.