Results for “hri_time_rolling_pkg”
13 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.HRI_TIME_ROLLING_PKG package is a stored PL/SQL program unit within the Oracle E-Business Suite (EBS) Applications schema. It belongs to the Human Resources Intelligence (HRI) family of database objects, a naming convention associated with the Oracle HRMS time and labor analytics infrastructure. Its primary business purpose is to manage and load rolling offset definitions used in time-based calculations within the HRMS environment. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its API classification is listed as OTHER, indicating that it is an internal utility rather than a formally published public API.
Rolling offsets are fundamental to human resources time processing because they define dynamic date ranges relative to a given point in time—such as "the current week," "the last thirty days," or "the previous pay period." The package provides the mechanism by which these offset configurations are populated into the underlying repository so that reporting, timecard, and accrual logic can resolve relative date windows consistently.
Key Procedures and Functions
The ETRM metadata documents a single callable program unit within this package:
LOAD_ROLLING_OFFSETS— This procedure is responsible for loading rolling offset definitions into the HRI time rolling offsets repository. Its purpose is to populate or refresh the set of offset records that downstream HRMS time calculations depend upon. As an internal loader, it is typically executed during setup, patching, or data synchronization activities rather than in interactive user sessions.
No additional procedures or functions are documented in the metadata. Complete implementation details, including parameter signatures and internal logic, are held within the package body and are not exposed in the high-level documentation.
Tables Accessed
The package interacts with one documented table via an APPS synonym:
HRI_TIME_ROLLING_OFFSETS— This table stores the rolling offset definitions managed by the package.LOAD_ROLLING_OFFSETSreads from and writes to this table, maintaining the offset records that define relative time windows for HRMS time processing. The table is the persistence layer for the offsets consumed by other HRI time components.
The dependency metadata also records a reference to SYS.STANDARD, the built-in PL/SQL package providing standard language constructs, which is normal for virtually every compiled PL/SQL unit and does not represent a business data dependency.
Usage Notes
Because HRI_TIME_ROLLING_PKG is classified as an OTHER API and is not a published public interface, it is generally invoked indirectly. Oracle's standard practice is to expose such loader packages through concurrent programs, setup forms, or higher-level HRMS processes that orchestrate time-related configuration. The dependency metadata shows that the package is referenced by APPS.HRI_TIME_C, meaning the HRI_TIME_C package may call into HRI_TIME_ROLLING_PKG to load or refresh offset data as part of broader time-processing operations.
Customers and implementers should treat this package as Oracle-owned internal code. Direct invocation from custom code is not recommended because the package body is not a formally supported public API and its behavior may change across patch levels or releases. Where the rolling offset data must be seeded or corrected, the preferred approach is to use the supported Oracle HRMS setup and concurrent program interfaces that ultimately drive this loader. Any custom dependencies on HRI_TIME_ROLLING_PKG should be reviewed thoroughly during upgrades between 12.1.1 and 12.2.2 to confirm continued compatibility.
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
PACKAGE: APPS.HRI_TIME_C 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2