Results for “ben_determine_dpnt_elig_ss”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.BEN_DETERMINE_DPNT_ELIG_SS package is a PL/SQL stored program in the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. Its name reflects its role as the dependent eligibility determination engine, where the _SS suffix denotes a server-side (server-side stored) implementation. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the business logic required to evaluate whether a dependent or family member qualifies for coverage under a given benefits program, plan, or option. It performs the eligibility checks that drive dependent enrollment, coverage elections, and the creation or update of dependent contact and person records. The package is classified as an OTHER API within the ETRM repository, indicating it is an internal processing unit rather than a published, externally supported interface.

Key Procedures and Functions

The documented package exposes seven procedures and functions, each handling a discrete part of the dependent eligibility lifecycle:

• MAIN — The primary entry point that orchestrates the dependent eligibility determination process, invoking the supporting routines as required to evaluate and record eligibility outcomes.
• FMLY_MMBR_CD_EXIST — Determines whether a family member code already exists, supporting duplicate detection and relationship validation for a dependent.
• CREATE_CONTACT_W — Creates a contact record associated with the dependent, establishing the person or contact information required for benefits processing.
• UPDATE_CONTACT_W — Updates an existing contact record when dependent information changes.
• UPDATE_PERSON_W — Updates the underlying person record, typically within the PER_ALL_PEOPLE_F entity, to keep dependent personal data synchronized.
• VALIDATE_NATIONAL_IDENTIFIER_W — Validates a dependent's national identifier against applicable format and business rules.
• CHECK_NI_UNIQUE_W — Confirms that a national identifier is unique, preventing duplicate dependent registrations under the same identifier.

Tables Accessed

The package reads from and writes to a broad set of Oracle Benefits and HR tables through APPS synonyms. Eligibility configuration is sourced from BEN_PGM_F, BEN_PL_F, BEN_PLIP_F, BEN_OIPL_F, BEN_PTIP_F, and BEN_ELIG_DPNT, which define programs, plans, plan-in-program relationships, options-in-plan relationships, tips, and dependent eligibility criteria. Life event and rate processing relies on BEN_LER_F, BEN_LER_CHG_DPNT_CVG_F, and BEN_ELIG_TO_PRTE_RSN_F, which govern life event reasons and changes to dependent coverage. Election and electable choice data are handled through BEN_ELIG_PER_ELCTBL_CHC, BEN_ELIG_CVRD_DPNT_F, and BEN_PRTT_ENRT_RSLT_F, which store participant enrollment results and covered dependent facts. Participant-to-life-event relationships are captured in BEN_PER_IN_LER, while personal data is drawn from PER_ALL_PEOPLE_F. Together these tables supply the configuration context and hold the eligibility decisions the package produces.

Usage Notes

This package is invoked internally by other Benefits components. ETRM documents that it is referenced by BEN_DETERMINE_DPNT_ELIG_SS itself (recursive or nested invocation) and by BEN_ON_LINE_LF_EVT, the online life event processing package. Accordingly, it is typically triggered during online life event handling and dependent eligibility workflows rather than being called directly from a form or concurrent program by end users. Its dependency on HR_API confirms that it leverages the standard HR API layer for person and contact maintenance, consistent with Oracle's practice of routing person data changes through supported APIs. Because this object is classified as OTHER rather than a public API, customers and implementers should treat it as an internal implementation detail whose signature may change between releases; custom code should not invoke it directly. Its eligibility results ultimately surface through the Benefits enrollment and life event user interfaces.