Search Results hr_oru_ins




Overview
Explore in AI Chat

Overview

HR_ORU_SHD is a shared utility package in the APPS schema that supports the Oracle Human Resources Organization Unit (ORU) API stack in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix "SHD" conventionally designates a package that holds shared logic referenced by sibling packages rather than by external callers directly. In this role, HR_ORU_SHD provides common services — DML status tracking, concurrency or locking control, argument conversion, and constraint-error handling — that the insert (HR_ORU_INS), update (HR_ORU_UPD), and delete (HR_ORU_DEL) business packages rely upon when managing rows in the HR_ALL_ORGANIZATION_UNITS entity.

The ETRM metadata classifies HR_ORU_SHD under API classification OTHER, with status VALID. It is referenced by six other packages, confirming its position as an internal dependency of the organization unit API family rather than a standalone public API.

Key Procedures and Functions

Five documented procedures/functions are exposed by HR_ORU_SHD. Parameter lists are not published in the metadata, so only their purpose is described below.

  • RETURN_API_DML_STATUS — Returns the outcome of the most recent DML operation performed through the ORU API stack, allowing callers to determine whether an insert, update, or delete succeeded. This supports the standard EBS API pattern in which a separate status function reports the result of a prior API call.
  • CONSTRAINT_ERROR — Provides centralized handling for database constraint violations raised during organization unit DML, translating native Oracle errors into meaningful API-level feedback.
  • API_UPDATING — Signals or detects that an API-driven update is in progress, enabling the shared layer to distinguish API-initiated changes from other modifications to the organization unit data.
  • LCK — Implements locking logic, typically acquiring or managing a lock on the relevant organization unit record to preserve concurrency integrity during multi-step API processing.
  • CONVERT_ARGS — Converts or normalizes arguments passed between the business packages and the shared layer, ensuring consistent data types and representations across the ORU API family.

Tables Accessed

ETRM documents two tables referenced through APPS synonyms:

  • ALL_CONSTRAINTS — The data dictionary view consulted to validate constraint definitions and interpret constraint violations. Its use aligns with the CONSTRAINT_ERROR routine, which must map Oracle error codes to the responsible constraint.
  • HR_ALL_ORGANIZATION_UNITS — The base organization unit table maintained by the ORU API family. HR_ORU_SHD supports the DML performed against this table by the insert, update, and delete siblings, though the shared package itself primarily supplies the surrounding control logic.

The dependency listing also shows a reference to the SYS STANDARD package, a normal PL/SQL runtime dependency rather than an application data access.

Usage Notes

HR_ORU_SHD is not intended for direct invocation by forms, concurrent programs, or custom code. It is an internal support package consumed by the ORU business packages (HR_ORU_INS, HR_ORU_UPD, HR_ORU_DEL, and HR_ORU_BUS) and surfaced indirectly through the HR_ORGANIZATION_API and the HR_ALL_ORGANIZATION_UNITS_OVN object. Customizations that create or modify organization units should call the supported public APIs — HR_ORGANIZATION_API and its ORU siblings — rather than HR_ORU_SHD itself.

Because the ETRM metadata records signature-level detail as unresolved ("show dependent code"), developers investigating the package should retrieve the live source from the APPS schema in the target environment. Any modification to HR_ORU_SHD carries broad impact, as six dependent packages would be affected by interface or behavioral changes.