Search Results hr_organization_units_s




Overview
Explore in AI Chat

Overview

The APPS.HR_ORU_INS package body is a private, internal PL/SQL component of the Oracle E-Business Suite Human Resources (HR) organization unit API stack. Its name follows the Oracle naming convention for generated API implementation units: "HR" denotes the Human Resources product, "ORU" denotes Organization Units, and "INS" denotes the insert (creation) operation. The package provides the low-level row insertion logic that supports the creation of organization unit records in the HR schema.

In Oracle EBS, organization units are the fundamental building blocks of the enterprise structure and are exposed to end users through the HR_ORGANIZATION_UNITS_S table and its associated date-tracked entity. The public API for creating these records is HR_ORGANIZATION_UNIT_API, which internally delegates the physical insert work to the ORU stack. HR_ORU_INS is the bottom layer of that stack, invoked by HR_ORU_BUS (business logic) and paired with HR_ORU_RKI (row key information) and HR_ORU_SHD (shadow/audit). Because it is a package body with no standalone specification documented as an API, it is not intended for direct customer invocation.

Key Procedures and Functions

  • SET_BASE_KEY_VALUE — Internal helper that establishes the base key value for the organization unit row being created. In the ORU insert stack, the base key identifies the date-tracked entity record that the insert will anchor, ensuring the object version and _S (short) table rows are linked to a consistent base key before the physical insert is attempted.
  • INS — The principal procedure that performs the actual insert of an organization unit. It writes the new row into the HR organization structures, applies the row key information supplied by HR_ORU_RKI, invokes business-rule validation through HR_ORU_BUS, and coordinates with HR_ORU_SHD for the shadow record that Oracle HRMS date-tracking requires. It also uses HR_API and HR_UTILITY services for error handling and who-column population.

Tables Accessed

  • HR_ORGANIZATION_UNITS_S — The primary target of the insert. This short table holds the current organization unit definition (name, type, dates, and location references).
  • HR_ALL_ORGANIZATION_UNITS — The common organization master table. Every organization unit creation also materializes a corresponding row here, since HRMS organizations span multiple organization classifications.
  • PER_ORGANIZATION_LIST — Consulted for organization list membership rows generated alongside the organization unit.
  • PER_SECURITY_PROFILES — Read to apply security profile / organization hierarchy security implications when the new unit is inserted.
  • DUAL and FND_PROFILE — Used for profile option lookups and singleton SELECTs supporting the insert logic.

Usage Notes

HR_ORU_INS is never called directly by forms, concurrent programs, or custom code. It is reached only through the public HR_ORGANIZATION_UNIT_API.CREATE_ORG_UNIT entry point, which is invoked when a user defines a new organization in the Organization form, when the organization setup concurrent programs run, or when third-party integrations create organization units through supported APIs. Because the documented dependency list shows that HR_ORU_INS is not referenced by any database object, its exposure is confined to the ORU package family itself. Customizations that attempt to bypass the public API and call HR_ORU_INS.INS directly will skip enforced validation and should be avoided; Oracle recommends all organization unit creation use the supported HR API layer.