Search Results get_event_date




Overview
Explore in AI Chat

Overview

APPS.BEN_DETERMINE_DATE is an Oracle E-Business Suite Advanced Benefits (OLM/OCM) package body responsible for deriving effective dates associated with plan years, enrollment periods, life events, and rate and coverage determinations. Within the benefits processing engine, the package resolves which plan year or enrollment period applies to a given life event or effective date, ensuring that eligibility, enrollment, and rating logic operate against the correct temporal boundaries. This is essential because benefits processing in EBS 12.1.1 and 12.2.2 is heavily date-driven; enrollments, coverage, and premium rates are all evaluated against the plan year in force at the time a qualifying event occurs.

The package body carries the header identifier bendetdt.pkb and is delivered under the APPS schema. A utility function, get_profile_ff_warn_val, retrieves the value of the BEN_DISP_FF_WARN_MSG profile option, defaulting to 'Y' when the profile is not set — a mechanism introduced under Bug 5088591 to control display of fast formula warning messages. The body also contains internal cursors such as c_pgm_popl_yr and c_pl_popl_yr that resolve plan year boundaries by joining BEN_YR_PERD with the program and plan year period tables.

Key Procedures and Functions

The ETRM metadata documents four procedures/functions in this package beyond the internal helper routines visible in the source excerpt:

  • MAIN — The primary driver procedure that determines the appropriate date or plan year context for the calling benefits process. It orchestrates the evaluation of effective dates against plan year and enrollment period definitions.
  • RATE_AND_COVERAGE_DATES — Determines the effective dates used when computing rates and coverage for a participant, aligning rate and coverage evaluations with the correct plan year or election period.
  • DO_DATE_AT_ENROLLMENT — Resolves the date that applies at the point of enrollment, typically during the enrollment or life event processing cycle.
  • RATE_AND_COVERAGE_DATES_NC — A variant of rate and coverage date determination, likely a "no coverage" or alternate-mode version used in specific processing paths.

These public entry points are supported internally by procedures such as get_plan_year, which accepts effective date, life event occurrence date, plan, program, and OIPL identifiers along with a date code, and returns start and end dates for the applicable plan year.

Tables Accessed

The package reads from a broad set of Advanced Benefits configuration and transactional tables through APPS synonyms. Plan and program definition tables include BEN_PGM_F, BEN_PL_F, BEN_PLIP_F, BEN_PTIP_F, and BEN_OIPL_F. Eligibility logic draws on BEN_ELIG_PER_F, BEN_ELIG_CVRD_DPNT_F, and BEN_ELIG_PER_ELCTBL_CHC. Enrollment and life event processing relies on BEN_ENRT_PERD, BEN_ENRT_PERD_FOR_PL_F, BEN_ENRT_BNFT, BEN_ENRT_RT, BEN_LER_F, and BEN_LEE_RSN_F. Option definitions are read from BEN_OPT_F. These reads supply the date boundaries against which enrollment and rating events are evaluated; the package is primarily a read-oriented date resolution utility rather than a writer of transactional data.

Usage Notes

BEN_DETERMINE_DATE is referenced by 58 other packages, making it a foundational dependency in the benefits processing stack. It is invoked indirectly whenever a life event, enrollment, or rating process must establish the correct plan year or enrollment period — for example, during benefits enrollment through the standard enrollment flows, during life event processing, and during rate and coverage determination jobs. Because the package is classified as OTHER rather than as a public API, direct custom invocation is not recommended. Oracle Forms, concurrent programs, and the benefits engine call into this package through higher-level APIs. Customizations should avoid calling these procedures directly where a supported public API exists, since internal behavior may change across patch levels, as evidenced by the header revision history.