Search Results hr_oru_shd




Overview
Explore in AI Chat

Overview

HR_ORU_SHD is a shadow (seed data handler) package body in the APPS schema whose name derives from HR Organizational Units. It serves as the shadow API layer that sits above the base HR_ORU package, providing the mandatory shadow columns and descriptive flexfield handling associated with organization unit definitions. Organization units are the fundamental entities that describe a business enterprise and its internal structures — business groups, legal entities, operating units, inventory organizations, and departments — and they are stored in HR_ALL_ORGANIZATION_UNITS. The shadow package encapsulates the row-level plumbing required when these definitions are created or modified through the standard HR API surface. It is classified as OTHER in the ETRM documentation, indicating it is not a public, user-facing API but an internally coupled implementation component invoked by its parent API. Its status is VALID in the APPS schema, and the documented metadata shows a dependent architecture in which HR_ORU_SHD references APPS.HR_API, APPS.HR_UTILITY, APPS.FND_MESSAGE, and the base table HR_ALL_ORGANIZATION_UNITS, while itself being referenced by six other packages.

Key Procedures and Functions

The documented package exposes five procedures and functions. No parameter lists are presented in the metadata, and none are asserted here.

  • RETURN_API_DML_STATUS — Returns the DML status of the API invocation, allowing the calling layer to determine whether the last row operation succeeded or failed and to propagate that outcome to the caller.
  • CONSTRAINT_ERROR — Handles constraint violation conditions raised during organization unit manipulation, translating them into a consistent API-level error condition rather than allowing raw Oracle errors to surface.
  • API_UPDATING — Marks or detects that an update is being performed through the API, enabling correct branching between insert and update logic within the shadow layer.
  • LCK — Performs row locking on the target organization unit record, ensuring serialization of concurrent modifications before the update proceeds.
  • CONVERT_ARGS — Converts and validates incoming arguments into the internal format expected by the shadow layer, including the mapping required for shadow column population.

Tables Accessed

  • HR_ALL_ORGANIZATION_UNITS — The primary base table for organization unit definitions. HR_ORU_SHD reads current values and writes updated attributes, including the shadow-related columns, during API-driven maintenance of these records.
  • ALL_CONSTRAINTS — The data dictionary view of constraints owned by the current user and accessible to it. The package consults this view, consistent with the CONSTRAINT_ERROR procedure, to identify and interpret constraint metadata when validating or diagnosing failures.

Additional dependencies shown in the metadata include FND_MESSAGE for message resolution, HR_API for shared API infrastructure, and HR_UTILITY for common utility routines.

Usage Notes

HR_ORU_SHD is not intended for direct invocation by custom code, concurrent programs, or forms. It is a subordinate implementation package behind the base HR_ORU API, and the documentation explicitly states that HR_ORU_SHD is not referenced by any database object, confirming its position at the lower edge of the dependency graph. It is indirectly reached whenever organization units are inserted or updated through the standard HR organization APIs — for example, from HR forms that maintain organization definitions, from setup and migration routines, and from other HR product APIs including the six packages documented as referencing it. Because the package depends on HR_API and HR_UTILITY and manages shadow column semantics, any direct call would bypass supported validation and message handling. Oracle EBS 12.1.1 and 12.2.2 customers should treat HR_ORU_SHD as an internal component: functional extensions should be built on the supported base APIs, and the package should be left unmodified to preserve upgrade safety and patchability across releases.