Search Results c_person_id

Overview

APPS.BEN_PEP_CACHE1 is a private PL/SQL package body belonging to the Oracle E-Business Suite Advanced Benefits (BEN) module. Its name reflects its purpose: it maintains an in-memory cache of "PEP" (Person/Plan Eligibility Period) data used by the benefits life-event processing engine. The package is classified as OTHER in ETRM, meaning it is not a public API but an internal implementation unit consumed by other benefit packages.

The package operates against the global record structure ben_pep_cache.g_pep_rec and collaborates with ben_manage_life_events.g_cache_proc_objects_rec, populating cached eligibility and enrollment detail rows keyed by person and effective date. Caching avoids repeated, expensive queries against eligibility and life-event tables during high-volume processing such as open enrollment, life-event evaluation, and eligibility recalculation. The header comments document sustained tuning across versions 115.0 through 115.8, including a refactor of eligibility logic into four cursors (Bug 3412822) and cursor corrections in Bug 5941500.

Key Procedures and Functions

• GET_CURROIPLIPPEP_DETS — Retrieves current "OIPLIP" (organization/plan-in-plan) PEP detail rows for a given person and effective date and loads them into the cache record. It defines and drives the cursor c_piloiplip_dets, which joins ben_elig_per_f to ben_per_in_ler to resolve the eligibility period identifiers applicable to the person.
• GET_CURRPLNPEP_DETS — Added in version 115.1, this procedure fetches current plan-level PEP details (the "PLN" variant of the cache population logic) and stores them in the shared cache. It parallels GET_CURROIPLIPPEP_DETS but targets plan-oriented eligibility context rather than organization-in-plan context.
• GET_CURRPEPCOBJ_CACHE — Serves as the cache accessor for PEP component objects, returning or refreshing cached PEP object data so that downstream benefit processing does not re-query the base tables.

Tables Accessed

• BEN_ELIG_PER_F — The eligibility periods fact table. It is the primary source of elig_per_id values and is filtered by person_id and the effective date. This table supplies the eligibility windows that determine whether a person qualifies for a given program or plan.
• BEN_PER_IN_LER — The person-in-life-event-reason table. It links persons to life events and is joined to BEN_ELIG_PER_F to constrain eligibility results to life-event-driven contexts, which is central to PEP cache population during life-event processing.

Usage Notes

BEN_PEP_CACHE1 is an internal, non-public package and should not be called directly from custom code. It is invoked indirectly through the benefits life-event and eligibility engine, particularly when ben_manage_life_events and ben_pep_cache drive cache construction during concurrent benefit processing. Because the cache is keyed by person and effective date, callers must supply consistent person and date values to avoid stale or mismatched cache entries.

When users search for c_person_id, that identifier is the cursor parameter through which the person context is passed into the PEP detail cursors; it corresponds to the person_id column of BEN_ELIG_PER_F and is the driving predicate for cache population. Customizations should not modify this package, as its logic is tightly coupled to the internal cache structures and is subject to Oracle patching.