Search Results g_cache_ptip_rec_table

Overview

APPS.BEN_COMP_OBJECT is a PL/SQL caching utility within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. Its stated purpose, drawn from the package header comments, is to return compensation object information. The package was originally created by G. Perry on 05 May 1999 under version 115.0 and has been revised incrementally through version 115.10 (29 Dec 2000), with history entries recording the addition of caches for COBRA and OIPLIP processing, the transition to on-demand object caching, the introduction of a "last record got" cache, and NOCOPY performance tuning.

The design centers on a set of package-level PL/SQL collection types that mirror the rowtypes of core Benefits tables. Each collection is an associative array indexed by BINARY_INTEGER, populated lazily as compensation object definitions are requested. The header declares structures such as G_CACHE_PGM_REC_TABLE (based on BEN_PGM_F%), G_CACHE_PL_REC_TABLE (BEN_PL_F%), G_CACHE_OIPL_REC_TABLE (BEN_OIPL_F%), G_CACHE_PTIP_REC_TABLE (BEN_PTIP_F%), G_CACHE_PLIP_REC_TABLE (BEN_PLIP_F%), G_CACHE_OPT_REC_TABLE (BEN_OPT_F%), and G_CACHE_OIPLIP_REC_TABLE (BEN_OIPLIP_F%), with corresponding global cache variables including G_CACHE_PGM_REC, G_CACHE_PL_REC, and G_CACHE_PGM_COBRA_REC. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling schema.

Key Procedures and Functions

ETRM documents 23 procedures and functions in this package. The principal public entry points are:

• SET_OBJECT — Populates the internal cache with a compensation object definition, allowing subsequent lookups to be served from memory rather than from the base tables. It is the write-side counterpart to the retrieval routines.
• GET_OBJECT — The primary accessor, corresponding directly to the user's search term "get_object." It returns comp object information for a requested object, consulting the in-memory cache and loading from the underlying tables on demand.
• GET_OBJECT_SET_COBRA — A variant of the retrieval routine dedicated to COBRA-related compensation object processing, added in version 115.1 to provide a separate cache path for COBRA plan and program data.
• CLEAR_DOWN_CACHE — Resets the package-level collections, releasing cached rows and forcing subsequent calls to reload from the database. This is the standard invalidation mechanism in such caching packages.

The remaining documented procedures are internal helper routines that support these four public operations. No parameter lists are reproduced here; callers should consult the package specification in the EBS instance for exact signatures.

Tables Accessed

The package reads Benefits compensation object definitions and related eligibility and plan-year structures through APPS synonyms:

• BEN_PGM_F, BEN_PL_F, BEN_OPT_F — program, plan, and option definitions, the core compensation objects.
• BEN_OIPL_F, BEN_OIPLIP_F, BEN_PLIP_F, BEN_PTIP_F — the option-in-plan, option-in-plan-in-program, plan-in-program, and program-in-plan type relationship tables that establish object hierarchies.
• BEN_ELIG_PER_F, BEN_PER_IN_LER — eligibility and person-in-eligibility records used to resolve who qualifies for an object.
• BEN_PL_REGN_F, BEN_REGN_F — plan and general regulations affecting object availability.
• PLITBLM — the PL/SQL table-to-column bulk mapping utility, invoked to move cached collection data efficiently.

Rows retrieved are stored in the rowtype-based collections described in the header, minimizing repeated physical reads during a single session or transaction.

Usage Notes

BEN_COMP_OBJECT is an internal Benefits infrastructure package rather than a documented public API; ETRM classifies it as OTHER and it is referenced by 16 other packages in the application. It is most commonly invoked indirectly from Benefits forms and concurrent programs that display or validate compensation objects, where repeated lookups of program, plan, and option definitions would otherwise generate significant redundant I/O. Custom code may call GET_OBJECT to resolve an object identifier to its full definition, but developers should treat the cache lifecycle carefully: SET_OBJECT or the first GET_OBJECT call loads entries, and CLEAR_DOWN_CACHE must be invoked when underlying data changes within the same session to avoid stale results. Because the package is AUTHID CURRENT_USER, callers must have appropriate privileges on the underlying BEN tables and PLITBLM directly or through enabled roles.