Search Results ben_ext_dpnt




Overview
Explore in AI Chat

Overview

BEN_EXT_DPNT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Advanced Benefits (OLAM/BEN) product family and is classified in ETRM as an "OTHER" API, meaning it is an internal supporting package rather than a published, end-user-facing API. Its name follows the BEN_EXT_* naming convention used for benefit extract routines, and the "DPNT" suffix associates it with the dependent entity within benefits eligibility processing.

Functionally, the package exists to support the extraction and processing of dependent-related data during benefits eligibility and enrolment calculations. Advanced Benefits must evaluate dependents — spouses, domestic partners, children and other eligible dependents — against plan rules, coverage definitions and life-event triggers. BEN_EXT_DPNT provides the data assembly logic that gathers the person, address, phone, contact-relationship and covered-dependent records required for that evaluation, and it is invoked as a dependency by the BEN_EXT_ENRT (enrolment extract) package when dependent-level processing is required. The package is documented as VALID in the ETRM repository for 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents a single program unit within the package:

  • MAIN — The primary entry point of the package. MAIN encapsulates the package's extraction and processing logic and is the routine called by dependent packages and internal benefit processes. Parameter lists, overloads and return types are not published in the ETRM metadata and should be confirmed by inspecting the package specification and body in the database prior to direct invocation.

No additional procedures or functions are documented for this package in the 12.2.2 metadata extract. Because only MAIN is exposed, the package should be treated as a single-purpose utility rather than a general-purpose API library.

Tables Accessed

The package references the following tables through APPS synonyms:

  • BEN_ELIG_CVRD_DPNT_F — The covered-dependent eligibility fact table. This is the core business table supplying the dependent records that the package processes and evaluates against plan eligibility criteria.
  • BEN_PER_IN_LER — The person-in-life-event-reason table, used to associate the person or dependent with the life-event records that drive eligibility recalculation.
  • BEN_PRMRY_CARE_PRVDR_F — The primary care provider fact table, accessed where dependent coverage records carry provider information.
  • PER_ADDRESSES — Supplies dependent address data required for eligibility rules that depend on location.
  • PER_ALL_PEOPLE_F — The core HR person table, providing person identity, effective-dated attributes and the relationship backbone for the dependent.
  • PER_CONTACT_RELATIONSHIPS — Provides the relationship definitions between the employee and the dependent, which are essential to determining who qualifies as a covered dependent.
  • PER_PHONES — Supplies telephone contact details for the person or dependent where these are required by the extraction output.

Usage Notes

BEN_EXT_DPNT is not exposed directly to end users through a form, concurrent program or public business API. It is an internal component invoked by other benefit packages; ETRM records BEN_EXT_ENRT as a referencing package, confirming its role in the wider benefits extract chain.

Typical invocation occurs during benefits eligibility and enrolment processing, life-event processing, and any dependent-level extract run that requires consolidated person, relationship, address, phone, provider and eligibility data. Custom development should not call BEN_EXT_DPNT directly unless the calling code fully replicates the context established by BEN_EXT_ENRT. Any extension work should be validated against both 12.1.1 and 12.2.2, and the package specification re-inspected after patching, since this object is subject to change through Oracle benefit application patches.