Search Results defer_delete_enrollment

Overview

The APPS.BEN_NEWLY_INELIGIBLE package is a PL/SQL utility within the Oracle E-Business Suite Advanced Benefits (Oracle BenAdmin) module. Its primary business function is to process participants who have transitioned from an eligible to an ineligible status for one or more benefit programs, plans, or options. When a life event, coverage recalculation, or periodic eligibility evaluation determines that a person no longer qualifies for a benefit, this package identifies the affected enrollment results and manages their disposition — either by terminating the coverage immediately or by deferring its removal to an appropriate date.

The package resides in the APPS schema, is classified as VALID in both 12.1.1 and 12.2.2, and is documented in the ETRM with an API classification of OTHER. It is a core dependency of several higher-level BenAdmin processes, meaning it is invoked automatically during routine benefits processing rather than being called directly by end users.

Key Procedures and Functions

Two procedures are documented for this package:

• MAIN — The primary entry point. It orchestrates the newly-ineligible processing logic, evaluating the ineligible participant's current enrollments and determining the appropriate action, including invoking the deferred-deletion logic where applicable.
• DEFER_DELETE_ENROLLMENT — Handles the deferral of enrollment deletion. Rather than removing an enrollment result outright, this procedure schedules or marks the enrollment for deletion based on the applicable rules, preserving auditability and allowing downstream processes to react correctly to the change.

No parameter signatures are documented in the available metadata; consumers should not assume argument lists and should reference the shipped package specification for exact interfaces.

Tables Accessed

The package reads and writes a range of BenAdmin configuration and transaction tables, all accessed through APPS synonyms:

• Eligibility configuration: BEN_ELIG_PER_F, BEN_ELIG_PER_OPT_F, BEN_PIL_ELCTBL_CHC_POPL, BEN_POPL_ENRT_TYP_CYCL_F, and BEN_PGM_F — used to resolve which programs, plans, and electable choices apply to the participant.
• Enrollment and coverage: BEN_ENRT_PERD, BEN_PRTT_ENRT_RSLT_F — the primary enrollment result and enrollment period records that are evaluated and potentially deleted or deferred.
• Life event and reason context: BEN_LEE_RSN_F, BEN_LER_F, BEN_PER_IN_LER, BEN_OIPL_F — provide the life event, its reason, and the person-in-life-event linkage that triggered the ineligibility.
• Plan definitions: BEN_PL_F — supplies plan-level attributes needed to determine proper termination behavior.

Usage Notes

BEN_NEWLY_INELIGIBLE is an internal processing package rather than a user-facing API. It is referenced by six other packages, notably BEN_CLOSE_ENROLLMENT, BEN_DETERMINE_COVERAGE, BEN_DETERMINE_ELIGIBILITY2, BEN_ENROLMENT_REQUIREMENTS, BEN_MANAGE_LIFE_EVENTS, and BEN_PRTT_ENRT_RESULT_API. These callers drive it during life event processing, eligibility reevaluation, and enrollment result maintenance. It is typically triggered indirectly — through concurrent programs such as the Participate in Life Events process or eligibility determination — rather than from a form or custom code. Customizations should avoid direct invocation and instead rely on the supported APIs; direct calls risk circumventing the dependency chain maintained by the calling packages. Because the package writes to enrollment result tables, any custom use must observe the same validation and date-effective rules enforced by the standard BenAdmin processes.