Search Results run_sql_stmt_noerr

Overview

APPS.HRI_OPL_BEN_DIM_REFRESH is a PL/SQL package body that supports the Oracle E-Business Suite HR Intelligence (HRI) dimensional collection architecture. Its role is to manage the refresh of benefit-related dimension collections used by Oracle Daily Business Intelligence and related HR reporting products. The package name reflects its purpose: HRI (HR Intelligence), OPL (Oracle Programming Language/collection layer), BEN (Benefits), DIM (Dimension), REFRESH. It is an internal, implementation-support package rather than a public API.

The package body operates within the HRI schema and maintains package-level state that controls the scope of a collection run, including global variables for the full-refresh range (g_full_refresh), the business group identifier (g_business_group_id), the HRI schema name (g_schema), and a concurrent request flag (g_conc_request_flag) that determines whether output is written to a concurrent log. The version header identifies it as $Header: hripbdrf.pkb 120.0 2005/09/21, an unshipped (noship) build consistent with the EBS 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

ETRM documents two procedures for this package:

• LOAD — The primary worker routine. It drives the refresh of benefit dimension collections, reading from benefit fact and dimension tables and populating the corresponding HRI collection tables. The LOAD procedure is invoked in a mode dictated by the full/not-full refresh constants and the business group identifier held in package state.
• dbg / output (internal helpers) — While only LOAD is formally documented, the source excerpt shows supporting routines such as dbg (which delegates to HRI_BPL_CONC_LOG.dbg) and output (which writes to the concurrent request log when g_conc_request_flag is TRUE). These provide diagnostic and logging behavior during a collection run.

With regard to the user's search term, run_sql_stmt_noerr, no such procedure is documented within this package's metadata. That identifier corresponds to a common HRI/HR utility for executing dynamic SQL without raising an error on failure; if used by the Benefits dimension refresh logic it would be inherited from a shared HRI helper package rather than defined locally here.

Tables Accessed

The package reads from Oracle Benefits and HR Intelligence tables through APPS synonyms. The documented references include:

• Benefit dimension and fact tables: BEN_ENRT_PERD, BEN_OIPLIP_F, BEN_OIPL_F, BEN_PGM_F, BEN_PLIP_F, BEN_PL_F, BEN_PL_TYP_F, BEN_POPL_ENRT_TYP_CYCL_F, BEN_POPL_RPTG_GRP_F, and BEN_PTIP_F. These supply plan, program, plan type, enrollment period, and reporting group data used to build benefit dimensions.
• HRI collection tables: HRI_CS_COMPOBJ_CT, HRI_CS_COMPOBJ_CT_S, HRI_CS_CO_PGMH_PLIP_CT, HRI_CS_CO_PGMH_PTIP_CT, and HRI_CS_CO_PGM_CT. These are the collection (snapshot) tables populated during a refresh and read by downstream reporting.

Usage Notes

HRI_OPL_BEN_DIM_REFRESH is not a public API and is referenced by zero other packages per the ETRM metadata. It is typically invoked indirectly, either through the HRI collection concurrent programs (the g_cncrnt_prgrm_shrtnm constant defaults to 'HRI_CS_COMP_OBJ_ENRT_PERD') or through the HR Intelligence collection framework. Administrators trigger it by scheduling the associated Benefits dimension collection concurrent request; the package logs progress to the concurrent request log when g_conc_request_flag is enabled. Custom code should not call this package directly, as its interfaces are internal and subject to change across EBS patch levels.