Search Results set_parameters

Overview

The APPS.HRI_OPL_BDGTS_LBRCST_ORGMGR package body is an Oracle Human Resources Intelligence (HRMS Intelligence / Daily Business Intelligence) component responsible for managing the labor cost budgeting data associated with the organization manager dimension. Within the Oracle EBS 12.1.1 and 12.2.2 application schema, this package supports the extract, refresh, and collection mechanisms used to populate the HR Intelligence analytical tables that feed budgeting and workforce cost reporting. Its name decomposes into "Budgets," "Labor Cost," and "Org Manager," indicating that its primary business role is to relate budgeted labor cost figures to the organizational manager hierarchy so that costs can be aggregated, compared, and analyzed by the managers who are accountable for them.

The header comment (hrioblom.pkb 120.1) and its noship designation confirm this is a shipped but internally classified HRMS Intelligence package, not part of the public API surface intended for direct customer invocation. It operates against global state that reflects refresh parameters — including a refresh start date, a refresh end date, and a full-refresh flag — together with debugging and concurrent-program flags that govern logging behavior.

Key Procedures and Functions

Two documented procedures comprise the functional core of this package:

• LOAD_TABLE — Responsible for loading the labor cost budget data into the appropriate HR Intelligence collection tables. It forms the data-population step that reads from source staging structures and materializes rows for the organization manager dimension.
• PROCESS — Orchestrates the overall processing logic, coordinating refresh parameters (start date, end date, full refresh) and invoking the loading work. This is the entry point most likely registered against a concurrent program or scheduled collection.

The package also provides internal utility procedures that are not part of the documented public surface but are essential to its operation: OUTPUT, which routes diagnostic text either to the concurrent program log via FND_FILE.PUT_LINE or to HR_UTILITY.TRACE depending on the concurrent flag; DBG, which writes trace text only when the debug flag is enabled; and RUN_SQL_STMT_NOERR, which executes a dynamically supplied SQL statement and suppresses any raised exception after logging a truncated form of the statement. These utilities explain the prominence of the "post_process" concern in this object: all post-processing diagnostics and non-fatal error handling flow through these routines.

Tables Accessed

The package references the following tables through APPS synonyms:

• HRI_CS_SUPH_ORGMGR_CT — The HR Intelligence collection staging table for the supervisor/organization manager hierarchy, providing the manager dimension used to attribute budgeted labor cost.
• HRI_MB_BDGTS_CT — The budgeting collection table that holds budget measures, supplying the budget figures to be associated with labor cost.
• HRI_MDP_BDGTS_LBRCST_ORGMGR_CT — The multi-dimensional partition/collection table that stores the resulting labor cost budget data at the organization manager grain, which this package populates.

Reads against the first two tables drive the transformation that writes into the third.

Usage Notes

Because it is classified as "OTHER" and no other package references it, this package is intended to be invoked indirectly — typically through an HRMS Intelligence concurrent program or a scheduled collection process that passes refresh parameters and sets the concurrent and debug flags. In Oracle EBS 12.1.1 and 12.2.2, such packages are generally run from the standard concurrent manager rather than from forms or custom PL/SQL. Administrators diagnosing post-processing issues should enable the debug flag and review the concurrent request log, where OUTPUT and DBG direct all messages. Direct invocation from custom code is not recommended, as the signature and global-parameter contract are not a supported public interface.