Results for “ben_manage_override”

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

Overview

BEN_MANAGE_OVERRIDE is an Oracle EBS Advanced Benefits (OLTP) PL/SQL package owned by APPS and classified as an "OTHER" API within the ETRM repository. Its business purpose is to manage manual overrides and corrections applied to a participant's benefits enrollment after the standard eligibility, election, rating, and premium calculation engine has already processed a person's enrollment results. In practice, benefits administrators frequently encounter situations that the automated rules cannot resolve — a dependent must be added or removed outside the normal life event window, a rate must be corrected, a premium must be recalculated, or an entire election must be backed out. This package provides the supporting programmatic logic for those administrative override activities, operating primarily on the tables that store processed enrollment results, electable choices, rates, premiums, and covered dependents.

Key Procedures and Functions

The package exposes eleven documented procedures covering the override lifecycle:

• CREATE_ELECTABLE_CHOICES — builds the set of electable choices available to a participant for a given program, plan, option, and life event, returning flags and identifiers used by downstream processing.
• POST_OVERRIDE — applies an override action against an eligibility/electable choice record, committing the change into the enrollment results.
• UPDATE_ELIG_DPNT — modifies dependent eligibility records, typically when a covered dependent must be added, altered, or corrected manually.
• END_RATE_AND_DEPENDENTS — end-dates rate and dependent records when coverage is terminated, ensuring historical accuracy.
• REOPEN_RATE_AND_DEPENDENTS — reverses the end-dating performed above, restoring rate and dependent rows to an active state.
• OVERRIDE_PRTT_PREM — overrides a participant's calculated premium amount.
• CORRECT_PRTT_ENRT_RSLT — corrects an existing participant enrollment result record.
• OVERRIDE_DEBIT_LEDGER_ENTRY — adjusts the debit ledger entry generated for a benefit, supporting financial reconciliation.
• OVERRIDE_PRTT_RT_VAL — overrides a participant's rate value.
• OVERRIDE_CERTIFICATIONS — manages certification overrides associated with a benefit election.
• ROLLBACK_CHOICES — reverses previously created electable choices, restoring the prior state.

Tables Accessed

The package reads and writes several core Benefits tables through APPS synonyms. Electable choice and enrollment data reside in BEN_ELIG_PER_ELCTBL_CHC, BEN_PIL_ELCTBL_CHC_POPL, BEN_PRTT_ENRT_RSLT_F, BEN_PRTT_ENRT_ACTN_F, BEN_ENRT_BNFT, and BEN_PER_IN_LER. Rated and premium amounts are stored in BEN_ENRT_RT, BEN_PRTT_PREM_F, BEN_ENRT_PREM, BEN_ACTY_BASE_RT_F, and BEN_BNFT_PRVDD_LDGR_F. Dependent coverage references BEN_ELIG_CVRD_DPNT_F. Plan and program setup context is drawn from BEN_PL_F, BEN_PGM_F, and BEN_PLIP_F. Collectively these tables support the override of eligibility, elections, rates, premiums, dependents, and ledger entries.

Usage Notes

BEN_MANAGE_OVERRIDE is typically invoked from Benefits administration forms and from custom or extension code that performs administrative back-office overrides, rather than from standard concurrent programs. Because it operates on processed enrollment results, it should be called after the normal Benefits engine has run. The AUTHID CURRENT_USER declaration means it executes under the caller's schema privileges. The package is referenced by one other package in the ETRM metadata, indicating that it is also consumed as a supporting utility by related Benefits processing logic. Developers should treat these procedures as privileged administrative operations, since they directly alter committed enrollment, rate, premium, and ledger data.