Search Results end_prtt_rt_val

Overview

BEN_DET_ENRT_RATES is an Oracle Applications (APPS) PL/SQL package within the Oracle Advanced Benefits (OAB) module of Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. The package encapsulates the logic required to determine enrollment rates for participants during benefits processing. Its responsibilities span rate calculation, eligibility-driven rate value determination, and the population of enrollment result and rate result tables used downstream by the benefits engine.

The package is classified as OTHER in the ETRM API registry, meaning it is not a public, supported API with frozen signatures, but rather an internal engine component referenced by other benefits packages. It sits within the rate determination layer of the benefits processing architecture, closely coupled with the dependent package BEN_DETERMINE_RATE_CHG and the result-processing package BEN_PROC_COMMON_ENRT_RSLT, both of which invoke it. Its effective date handling, global variables, and eligibility selection logic make it central to producing correct contribution and rate amounts during enrollment and mid-year life event processing.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions:

• P_DET_ENRT_RATES — The primary driver procedure that determines enrollment rates for the population under processing.
• DET_ENRT_RATES_ERL — Handles rate determination in the context of eligibility result lines (ERL), applying eligibility restrictions to which rates apply.
• END_PRTT_RT_VAL — Concludes or closes the participant rate value records, effectively dating the end of a rate value row.
• SET_GLOBAL_ENRT_RSLT — Establishes package-level global variables for enrollment result identifiers used across calls.
• SET_GLOBAL_ENRT_RT — Establishes package-level globals for enrollment rate context.
• CLEAR_GLOBALS — Resets package global variables, ensuring no stale state persists between processing iterations.

The combination of setter and clear routines reflects a session-scoped global pattern common to benefits engine packages, where repeated rate calculations reuse cached identifiers for efficiency.

Tables Accessed

Through APPS synonyms, the package reads and writes the following documented tables:

• BEN_PRTT_ENRT_RSLT_F and BEN_PRTT_RT_VAL — The participant enrollment result and participant rate value tables, which the package populates and closes.
• BEN_ENRT_BNFT and BEN_ENRT_RT — Enrollment benefit and enrollment rate definitions supplying rate structure.
• BEN_ELIG_PER_ELCTBL_CHC, BEN_PIL_ELCTBL_CHC_POPL, BEN_PER_IN_LER, BEN_LER_F, and BEN_OIPL_F — Eligibility and electable choice tables that determine whether and how a participant qualifies for a given rate.
• BEN_ACTY_BASE_RT_F — Activity base rate definitions providing the rate basis.
• BEN_BNFT_PRVDR_POOL_F, BEN_BNFT_POOL_RLOVR_RQMT_F, and BEN_BNFT_PRVDD_LDGR_F — Benefit provider pool, rollover requirement, and provided ledger tables supporting pooled and rollover rate scenarios.
• PLITBLM — A standard Oracle HRMS date/utility table used for effective date handling.

Usage Notes

BEN_DET_ENRT_RATES is invoked by four documented packages: BEN_DETERMINE_RATE_CHG, BEN_EFC_ADJUSTMENTS1, BEN_ELECTION_INFORMATION, and BEN_PROC_COMMON_ENRT_RSLT. It is typically called during benefits enrollment processing and rate recalculation, both from concurrent programs that run the benefits engine and from forms where election information is displayed or validated. Because it manipulates session globals, callers within a single processing run should invoke the setter procedures before rate determination and CLEAR_GLOBALS afterward. As an internal engine package, it is not a supported extension point; customizations should target supported benefits APIs rather than this object.