Search Results drop_event




Overview
Explore in AI Chat

Overview

APPS.HRI_EDW_DIM_EVENTS is a PL/SQL package that supports the Oracle Human Resources Intelligence (HRI) Enterprise Data Warehouse (EDW) dimensional model. Its principal business function is the maintenance of user-defined event definitions and their associated threshold and hierarchy metadata, which form the event dimension used by HR analytics and event-tracking reporting. The package provides the administrative plumbing for registering, configuring, enabling, disabling, and loading event rows that describe how HR events are grouped, parented, and measured against global or user-specific thresholds.

The package is classified by ETRM as an OTHER API, meaning it is not a public business API intended for broad subscription, but rather an internal or administrative utility package used to populate and maintain EDW event dimension tables. It exposes nine documented procedures, does not reference any documented functions, and is not referenced by any other package, indicating it is a top of the call chain rather than a shared library.

Key Procedures and Functions

  • ADD_GLOBAL — Registers a global-level event configuration for a given user event type, including its units, threshold value, and enabled flag.
  • SET_GLOBAL — Sets the numeric threshold value for a specified user event type. This is the procedure most closely associated with the search term "set_global."
  • ENABLE_GLOBAL — Activates the global event configuration for the supplied user event type.
  • DISABLE_GLOBAL — Deactivates the global event configuration for the supplied user event type.
  • ADD_EVENT — Adds a specific event code to a user event type together with its event threshold.
  • DROP_EVENT — Removes an event code from a user event type.
  • LOAD_HRHY_ROW — Loads an event hierarchy row, capturing ownership, hierarchy, level, event code, parent event, reason type, and user event type.
  • LOAD_USER_ROW — Loads a user event row with its threshold value, threshold units, global threshold value, and global flag.
  • LOAD_CMBN_ROW — Loads a combination row mapping a combination identifier to its gain, loss, reconciliation, and separation event identifiers along with facts, description, and reason type.

Tables Accessed

  • HRI_EDW_USER_EVENTS — Stores user-defined event definitions and their threshold configuration; maintained primarily by ADD_EVENT, DROP_EVENT, SET_GLOBAL, ENABLE_GLOBAL, DISABLE_GLOBAL, and LOAD_USER_ROW.
  • HRI_EDW_USER_EVENTS_S — The sequence or surrogate-key companion used to generate unique identifiers for user event records.
  • HRI_EDW_EVENT_HRCHYS — Stores the event hierarchy structure, populated by LOAD_HRHY_ROW.
  • HRI_EDW_EVENT_HRCHY_CMBNS — Stores event hierarchy combinations linking combination identifiers to their related event codes, populated by LOAD_CMBN_ROW.

Usage Notes

Because HRI_EDW_DIM_EVENTS is an OTHER-classified package and is not referenced by any other package, invocation is typically direct — from concurrent programs that seed or refresh EDW event dimension data, from administrative forms, or from custom PL/SQL that must register or adjust event thresholds. SET_GLOBAL is the routine most commonly called when an administrator or batch process needs to update a global threshold for a user event type without redefining the entire event. The LOAD_* procedures are best suited to controlled data-loading contexts, since they write directly into the dimension tables and should be executed within a defined transaction boundary. On Oracle EBS 12.1.1 and 12.2.2, callers should invoke these procedures as APPS and account for the fact that no dependent packages wrap them, so error handling and commit control remain the caller's responsibility.