Search Results ben_use_cvg_rt_date




Overview
Explore in AI Chat

Overview

BEN_USE_CVG_RT_DATE is an Oracle EBS Advanced Benefits (Oracle Benefits) PL/SQL package owned by the APPS schema. In Oracle EBS 12.1.1 and 12.2.2, the package supports benefits rating and coverage-date processing logic — specifically, resolving and caching whether a coverage rate date (or comparable date-type context) applies when the benefits engine determines premiums and rates. Its role is internal: it exposes utility functions used by higher-level rate determination and eligibility packages rather than a user-facing or self-contained business API.

The package is classified as an OTHER-type API, meaning it is not a public, supported interface like the standard Benefits ben_*_api family. It is a helper module consumed internally by the rate and eligibility engines, and its documented metadata shows it is referenced by six other packages. Because its subobjects carry no custom parameter documentation, treat it as a private utility used inside the Benefits rate calculation chain.

Key Procedures and Functions

  • GET_CSD_RSD_STATUS — Returns status information relating to coverage start date (CSD) and rate start date (RSD). It is used by the rate engine to determine whether a valid coverage/rate date exists for the processing context before rates are applied.
  • FONM_CLEAR_DOWN_CACHE — Clears a downward cached value associated with the "FONM" (formula/reference object number mapping) global state. It supports cache consistency when the underlying mapping data changes.
  • GET_FONM — Retrieves the FONM value, likely resolving a mapping/identifier and returning it to the caller. This is the read counterpart to caching operations.
  • SET_FONM — Sets (assigns) the FONM value into the package's in-memory state for reuse during a processing run.
  • CLEAR_FONM_GLOBALS — Resets all FONM-related package globals, which is important for session cleanup and to prevent stale data between processing cycles.

Tables Accessed

  • BEN_PLIP_F — Benefits plan-in-program (participation) records; used to resolve plan/participation context for date and rate determination.
  • BEN_PL_F — Benefits plan definition records; provides plan-level attributes required when evaluating rate and coverage date applicability.
  • BEN_PTIP_F — Benefits plan type-in-program records; contributes plan type context for the same determination logic.

These tables are referenced via APPS synonyms, consistent with standard Benefits data structures. The package reads them to resolve plan and participation context that governs coverage and rate date behavior.

Usage Notes

BEN_USE_CVG_RT_DATE is typically invoked indirectly rather than by end users. It is called by the Benefits rate determination packages (BEN_DETERMINE_RATES, BEN_DETERMINE_ACTUAL_PREMIUM), eligibility evaluation packages (BEN_EVALUATE_ELIG_PROFILES, BEN_EVALUATE_RATE_PROFILES), and life event processing (BEN_MANAGE_LIFE_EVENTS). It is also self-referential, which indicates internal recursion or reuse within its own logic. This makes it a foundational utility within benefits rating; custom code should not call it directly. Any extension of benefits rate logic should hook into the supported Benefits APIs, allowing this package to behave as an internal dependency. Because its documented subobjects lack parameter detail in ETRM, developers inspecting 12.1.1/12.2.2 should reference the actual package source for signatures.