Search Results get_oiplip_dets

Overview

BEN_COBJ_CACHE is an Oracle EBS Advanced Benefits (OLTP) PL/SQL package body owned by the APPS schema. Its purpose is to improve the performance of eligibility and compensation object resolution by caches the results of frequently executed lookups against benefit configuration entities. Rather than querying the underlying base tables repeatedly during eligibility processing, dependent program units call the accessor functions in this package to retrieve pre-resolved cache rows.

The package operates alongside the core BEN_*_F tables that define benefit programs, plans, plan types, options, and eligibility rules. It exposes both retrieval routines (GET_*_DETS) and cache control routines (SET_NO_CACHE_CONTEXT, CLEAR_DOWN_CACHE), allowing callers to enable or disable caching for a given context and to flush cached values. The object is documented as VALID and is classified as an OTHER API in the ETRM registry for release 12.2.2, with the same metadata applicable to 12.1.1.

Key Procedures and Functions

The package exposes eleven documented program units. They are:

• GET_OIPLIP_DETS — resolves and returns detail rows joining the input plan (OIPL) and input plan type (OIPLIP) entities.
• GET_OIPL_DETS — returns detail information for a benefit input plan.
• GET_OPT_DETS — returns detail information for a benefit option.
• GET_PGM_DETS — returns detail information for a benefit program.
• GET_PTIP_DETS — returns detail information for a plan type in program context.
• GET_PLIP_DETS — returns detail information for a plan in program context.
• GET_PL_DETS — returns detail information for a benefit plan.
• GET_ETPR_DETS — returns detail information for eligibility-to-plan-type relationship records.
• GET_PREL_DETS — returns detail information for plan relationship records.
• CLEAR_DOWN_CACHE — clears cached data, typically invoked when configuration changes invalidate stored results.
• SET_NO_CACHE_CONTEXT — establishes a context in which caching is bypassed so that live data is returned.

These routines are consumed by eligibility processing logic and any code that must resolve benefit object identifiers quickly.

Tables Accessed

The package reads from the following base configuration tables through APPS synonyms: BEN_ELIG_TO_PRTE_RSN_F, BEN_OIPLIP_F, BEN_OIPL_F, BEN_OPT_F, BEN_PGM_F, BEN_PLIP_F, BEN_PL_F, BEN_PRTN_ELIG_F, and BEN_PTIP_F. These tables store benefit program, plan, plan type, option, and eligibility definitions and their effective-dated relationships. PLITBLM, a public synonym for a PL/SQL table type, is used for in-memory caching of retrieved detail rows. The package also depends on BEN_PL_F, BEN_PGM_F, BEN_OIPL_F, BEN_OIPLIP_F, and BEN_PRTN_ELIG_F within its dependency list, and on the BEN_HASH_UTILITY package for hash-based cache keying.

Usage Notes

BEN_COBJ_CACHE is referenced by 28 other database objects, indicating that it functions as a shared utility layer within the Advanced Benefits schema rather than as a top-level API. It is typically invoked indirectly from eligibility and enrollment processing routines that must repeatedly resolve benefit object details. Callers that require fresh, uncached data can invoke SET_NO_CACHE_CONTEXT before processing; cache invalidation following configuration changes should use CLEAR_DOWN_CACHE. Customizations that call these routines directly should preserve the documented signatures, ensure the APPS schema is the executing schema, and avoid modifying package body logic, as dependent standard code relies on its caching semantics.