Results for “add_event”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRI_EDW_DIM_EVENTS is an Oracle E-Business Suite PL/SQL package defined in the APPS schema that supports the Oracle Human Resources Intelligence (HRI) Enterprise Data Warehouse (EDW) event framework. Its principal business function is the maintenance and configuration of user-defined event thresholds and hierarchical event definitions used when loading dimensional data for HR analytics. The package provides a programmatic API through which global and user-specific event thresholds can be created, enabled, disabled, updated, or removed. In the context of Oracle EBS 12.1.1 and 12.2.2, this package belongs to the HR Intelligence product family and is classified as an "OTHER" API, meaning it is an internal utility rather than a formally published public interface. The package manages both the definitional metadata of events (hierarchy relationships and combination mappings) and runtime event records, bridging human resources data structures to the reporting and alerting capabilities of the HRI EDW.
Key Procedures and Functions
The package exposes nine documented program units, organized around two concerns: event threshold management and physical event row loading.
- ADD_GLOBAL — Inserts a global event record, prefixing the user event type with "GLOBAL_" and supplying threshold units, threshold value, and enabled flag.
- SET_GLOBAL — Updates the global threshold value for an existing event, invoking the internal GLOBAL_EXISTS check before applying the change.
- ENABLE_GLOBAL — Sets the global enabled flag to an active value for a specified user event type.
- DISABLE_GLOBAL — Sets the global enabled flag to an inactive value, suppressing the event without deleting its definition.
- ADD_EVENT — Creates a new user-defined event definition in the events repository.
- DROP_EVENT — Removes an event definition from the repository.
- LOAD_HRHY_ROW — Loads a hierarchy row into the event hierarchy structures, supporting dimensional reporting relationships.
- LOAD_USER_ROW — Loads a user-dimension row associated with event data.
- LOAD_CMBN_ROW — Loads a combination row, mapping hierarchy members to their combinations for the EDW.
Private helper functions such as GLOBAL_EXISTS support these routines by verifying the presence of a "GLOBAL_" prefixed record before update operations proceed.
Tables Accessed
The package operates over four documented tables, referenced through APPS synonyms:
- HRI_EDW_USER_EVENTS — The primary repository for user event definitions, holding the user event type, threshold units, global threshold value, and global enabled flag.
- HRI_EDW_USER_EVENTS_S — The sequence used to generate unique user_event_id values during insert operations such as ADD_GLOBAL.
- HRI_EDW_EVENT_HRCHYS — Stores event hierarchy definitions used during row loads.
- HRI_EDW_EVENT_HRCHY_CMBNS — Stores the combination mappings that associate hierarchy members with dimensional combinations.
Usage Notes
This package is typically invoked internally by the HRI EDW data collection and reporting components, or from custom PL/SQL during implementation of HR analytics alerting. Event threshold configuration is commonly driven through HR Intelligence setup forms or concurrent programs that manage the user events repository. Because the package is classified as OTHER and shows no dependencies from other documented packages, it should be called only from code that explicitly targets the HRI EDW event tables. Direct modification of HRI_EDW_USER_EVENTS is discouraged in favour of the documented API, which preserves the "GLOBAL_" naming convention and the corresponding global/user event pairing. Releases 12.1.1 and 12.2.2 share this package behavior, with the header indicating a long-stable code line dating to 2005.
-
PACKAGE: CTXSYS.CTX_OUTPUT 12.1.1
-
PACKAGE: CTXSYS.CTX_OUTPUT 12.2.2
-
PACKAGE: CTXSYS.CTX_OUTPUT 12.2.2
-
PACKAGE: CTXSYS.CTX_OUTPUT 12.1.1