Search Results reinstate_dpnt

Overview

The APPS.BEN_AUTOMATIC_ENROLLMENTS package is a PL/SQL API in the Oracle E-Business Suite Advanced Benefits (OAB) module. Its business function is to evaluate an employee's eligibility for benefits programs and to autonomously create enrollment results where the employee meets the criteria defined by the plan design but has not yet taken action. In practical terms, this package supports the "automatic enrollment" and "default enrollment" behavior of Oracle Advanced Benefits, ensuring that individuals who fail to actively elect coverage within a defined window are assigned to the default or automatically applicable benefit offerings configured by the plan administrator.

The package is declared AUTHID CURRENT_USER, meaning its database objects are resolved using the privileges of the invoking user rather than the definer. The package header is versioned 120.0.12000000.1 and is classified in the ETRM metadata as an "OTHER" API. It exposes exactly two documented procedures.

Key Procedures and Functions

• MAIN — The primary entry point for driver process. It accepts a person identifier, a legal entity (LER) identifier, a business group identifier, a processing mode, and an effective date. MAIN drives the automatic enrollment evaluation for the specified person and legal entity combination, reading eligibility and plan configuration data and writing the resulting enrollment records. The p_mode parameter governs the processing context, allowing the same procedure to serve different invocation scenarios (such as full processing versus simulation or reinstatement paths).
• REINSTATE_DPNT — Handles reinstatement of dependent coverage. It receives identifiers for the program, plan, option-in-plan, business group, person, person-in-LER record, eligible person elective choice, and prior participant enrollment result. It also accepts coverage start date rules and dates, plus an optional previous participant enrollment result identifier defaulted to NULL. This procedure is used when a previously terminated dependent enrollment must be reinstated rather than created anew, preserving the linkage to the prior election and coverage history.

Tables Accessed

The package reads and writes across the core Advanced Benefits configuration and results schema through APPS synonyms:

• BEN_DSGN_RQMT_F and BEN_DSGN_RQMT_RLSHP_TYP — design requirements and their relationship types, which define which enrollment rules apply to a given person's relationship to the plan.
• BEN_ELIG_PER_ELCTBL_CHC, BEN_PIL_ELCTBL_CHC_POPL, and BEN_PER_IN_LER — eligibility and electable-choice determination records used to decide whether a person qualifies for a given offering.
• BEN_ELIG_CVRD_DPNT_F, BEN_ELIG_DPNT, and PER_CONTACT_RELATIONSHIPS — dependent eligibility data supporting the REINSTATE_DPNT path.
• BEN_PL_F and BEN_OIPL_F — plan and option-in-plan flexfield definitions.
• BEN_ENRT_BNFT, BEN_ENRT_RT, and BEN_PRTT_ENRT_RSLT_F — the enrollment benefit, rate, and participant enrollment result tables into which automatic coverage is written.

Usage Notes

BEN_AUTOMATIC_ENROLLMENTS is typically invoked by the Benefits enrollment engine and related concurrent programs rather than directly by end users. The metadata confirms that it is referenced by two other packages, indicating that it is called as a subordinate API within a larger benefits processing flow rather than being a top-level user interface action. Its MAIN procedure is suited to batch orchestration across a population, while REINSTATE_DPNT addresses a narrower, record-specific correction path. Custom code should call these procedures only after validating required eligibility and configuration data, and should pass a consistent p_effective_date and business group context to avoid misaligned enrollment results.