Search Results ben_pep_cache1




Overview
Explore in AI Chat

Overview

BEN_PEP_CACHE1 is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Suite Advanced Benefits (OAB) life events and eligibility infrastructure. Its name indicates its role as a caching layer for "PEP" (Post-Election Processing / Payroll-Eligibility-Period) related data, used during the life event and eligibility determination cycle. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package is documented in the ETRM repository with a status of VALID and an API classification of OTHER, meaning it is an internal, non-public-API package rather than a supported extension point.

The package exists to reduce redundant database access during eligibility and life-event processing by holding intermediate results in a cache. It depends on BEN_MANAGE_LIFE_EVENTS and BEN_PEP_CACHE, confirming that it participates in the life event management flow and shares caching responsibilities with the broader BEN_PEP_CACHE package family.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package. Parameter lists are not published and are therefore not reproduced here.

  • GET_CURROIPLIPPEP_DETS — Retrieves current "OIPLIP" PEP detail information. This procedure/function supplies cache-sourced details relating to ongoing or in-progress life event processing, returning the current PEP detail set for downstream eligibility logic.
  • GET_CURRPLNPEP_DETS — Retrieves current "PLN" (plan) PEP detail information. It returns the plan-level PEP details held in the cache, supporting plan eligibility and enrollment determinations.
  • GET_CURRPEPCOBJ_CACHE — Returns the cached PEP "COBJ" (configuration object) data. This is the core cache accessor used by callers that need the current PEP configuration object without re-querying the base tables.

All three routines are read-oriented accessors that surface cached content to the calling eligibility and life event modules.

Tables Accessed

Two base tables are documented as being referenced through APPS synonyms:

  • BEN_ELIG_PER_F — The eligibility period fact table. It stores the periods against which eligibility is evaluated. The package reads this table to populate or validate the PEP detail cache.
  • BEN_PER_IN_LER — The life event reason to eligibility period relationship table. It defines which eligibility periods apply to a given life event reason. The package reads this to resolve the correct eligibility periods during life event processing.

In addition to the base tables, the package interacts with BEN_PEP_CACHE and BEN_MANAGE_LIFE_EVENTS, and is itself referenced by BEN_DETERMINE_ELIGIBILITY2, which is the principal consumer of the cached data.

Usage Notes

BEN_PEP_CACHE1 is an internal utility package and is not intended to be called directly from forms, concurrent programs, or custom code. It is invoked indirectly through BEN_DETERMINE_ELIGIBILITY2 and the life event management stack whenever eligibility determination requires PEP detail or PEP configuration object data. Because it is classified as OTHER rather than a public API, Oracle does not guarantee its signature across patches or upgrades.

Customers implementing custom eligibility rules or extensions should target supported APIs such as BEN_DETERMINE_ELIGIBILITY2 or the BEN_MANAGE_LIFE_EVENTS public interfaces rather than this cache package. Any direct dependency on BEN_PEP_CACHE1 risks breakage during upgrade from 12.1.1 to 12.2.2 or in subsequent patching, since its procedures, parameters, and caching strategy are subject to change without notice.