Results for “hr_oru_upd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_ORU_UPD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the internal update layer for Organization Unit records maintained within Oracle Human Resources (Oracle HRMS). The package name derives from the HR Organization Unit (ORU) naming convention, and its role is to encapsulate the logic used when an existing organization unit definition must be modified in the underlying HR tables. In EBS 12.1.1 and 12.2.2, organization information is stored in HR_ALL_ORGANIZATION_UNITS, the base table that holds the core descriptive attributes of every business group, organization, and organization unit recorded in the system. HR_ORU_UPD operates as a supporting package beneath the public organization APIs, ensuring that update operations against this table are performed through a controlled, instrumented pathway rather than by direct DML. The package is classified as OTHER in the ETRM documentation, meaning it is not part of the published, customer-callable API set but is instead an internal utility invoked by higher-level product code.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package: UPD. As the only exposed program unit, UPD serves as the internal entry point for applying changes to an organization unit record. Its purpose is to accept the identifying context of an organization unit along with the attributes to be changed, resolve the current row in HR_ALL_ORGANIZATION_UNITS, and write the updated values back while preserving the integrity of the organization unit structure. The procedure is the mechanism through which the surrounding organization API stack delegates the physical update of organization unit data. Consistent with the limited documentation available, no additional public procedures or functions are registered for this package. Custom code should treat UPD as an internal routine and should not invoke it directly.

Tables Accessed

The documented table reference for HR_ORU_UPD is HR_ALL_ORGANIZATION_UNITS via an APPS synonym. This is the primary and, per the documented metadata, the only table the package touches. HR_ALL_ORGANIZATION_UNITS stores the fundamental attributes of an organization unit, including its name, business group, location reference, and internal/external classification flags. Because HR_ORU_UPD exists specifically to update organization unit records, writes to this table constitute its core behavior. No additional HR tables are listed in the documented dependency set, indicating that the package is narrowly scoped to the organization unit row itself and relies on callers to have already validated and normalized input values before the update is attempted.

Usage Notes

HR_ORU_UPD is referenced by the APPS.HR_ORGANIZATION_API package, which is the supported, public interface for creating and maintaining organizations in Oracle HRMS. In practice, this means HR_ORU_UPD is invoked indirectly whenever an organization unit is changed through supported pathways such as the Organization form, the organization-related concurrent programs, or customer code that calls HR_ORGANIZATION_API rather than writing to HR_ALL_ORGANIZATION_UNITS directly. The package also references dependencies including HR_API and HR_ORU_SHD, with HR_ORU_SHD indicating an associated shadow table used for audit or history tracking of organization unit changes. Because HR_ORU_UPD belongs to the internal implementation tier, direct invocation from forms, reports, or custom PL/SQL is not supported and risks bypassing the validation, security, and audit behavior enforced by HR_ORGANIZATION_API. Developers extending Oracle HR should always route organization changes through the public API and treat HR_ORU_UPD as an implementation detail that may change between releases.