Search Results ben_pep_cache




Overview
Explore in AI Chat

Overview

The APPS.BEN_PEP_CACHE package body is a supporting PL/SQL object within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its name reflects its primary role: maintaining an in-memory cache of "PEP" data, where PEP denotes the processed eligibility and participation context associated with a person, a benefit plan, an option, or a combination thereof. Rather than re-deriving eligibility and rate facts on every request, the package stores these derived results so they can be reused across the processing cycle of a single session or transaction.

In practical terms, BEN_PEP_CACHE acts as a performance-oriented memoization layer. It is invoked by higher-level benefits processing routines that must repeatedly evaluate the same eligibility periods, plan enrollments, and option selections. By caching the derived "facts," the package avoids redundant calls into the eligibility and rate derivation engines (BEN_DERIVE_PART_AND_RATE_FACTS) and the underlying eligibility tables. The package is classified as OTHER in the ETRM API taxonomy, indicating that it is an internal support package rather than a public, customer-facing API.

The object is documented as VALID in the APPS schema and is referenced by ten other packages, confirming that it functions as a shared dependency within the Benefits module rather than a standalone entry point.

Key Procedures and Functions

Eight documented procedures and functions make up the package's public surface. Their naming convention follows a get/clear pattern.

  • GET_PILPEP_DETS — Retrieves cached PEP details in the context of a plan-in-list processing path. It returns the derived eligibility/participation facts for the requested key, populating the cache on a miss.
  • GET_PILEPO_DETS — Retrieves cached PEP details for a plan-in-list enrollment/option context, complementing the plan-level accessor.
  • GET_CURRPEPEPO_DETS — Returns details for the current effective PEP-to-enrollment-option mapping, allowing callers to obtain the active context without recomputing it.
  • GET_CURROIPLIPPEP_DETS — Returns current details for an open/in-progress plan-in-list PEP scenario, supporting in-flight eligibility processing.
  • GET_CURRPLNPEP_DETS — Returns current details for the plan-level PEP context, used when resolving active plan participation.
  • CLEAR_DOWN_CACHE — General-purpose cache invalidation routine that flushes the package's cached entries.
  • CLEAR_DOWN_PEPCACHE — Targeted invalidation of the PEP-specific cache segment.
  • CLEAR_DOWN_EPOCACHE — Targeted invalidation of the enrollment-option (EPO) cache segment.

Tables Accessed

The package reads through APPS synonyms for the following base tables:

  • BEN_ELIG_PER_F — The eligibility-per-person fact table; supplies the foundational eligibility determinations used to populate cached PEP details.
  • BEN_ELIG_PER_OPT_F — The eligibility-per-person-per-option fact table; provides option-level eligibility that feeds the EPO cache segment.
  • BEN_PER_IN_LER — The person-in-life-event-record table; links participants to life events and supports the "current/open" accessors.
  • PLITBLM — The PL/SQL integer table (index-by table) type used for bulk collection and in-memory structuring of cache keys and results.

Usage Notes

BEN_PEP_CACHE is an internal dependency rather than a directly callable API. It is referenced by ten other packages, including BEN_DERIVE_PART_AND_RATE_FACTS, BEN_MANAGE_LIFE_EVENTS, and BEN_HASH_UTILITY, which invoke its getters and clear-down routines during eligibility evaluation, life-event processing, and rate derivation.

Typical invocation occurs from Oracle Forms-based Benefits windows and from concurrent programs that process large participant populations. Custom code should not rely on the cache persisting across database sessions: entries are session-scoped and must be cleared via the CLEAR_DOWN routines whenever underlying eligibility data changes within the same session to prevent stale results.