Search Results hr_organization_units_pkg




Overview
Explore in AI Chat

Overview

APPS.HR_ORGANIZATION_UNITS_PKG is a PL/SQL package body that encapsulates the core business logic for maintaining organization unit definitions within Oracle E-Business Suite Human Resources. Its scope spans both the base organization unit entity (HR_ALL_ORGANIZATION_UNITS) and its translatable name and description attributes, together with the flexible key‑flex style "organization information" rows that classify an organization—for example, Representative Body, RepBody_Constituencies, GRE, and org class assignments. The package is registered as an OTHER‑classified API, meaning it is primarily intended for internal use by the Oracle Forms application and by other server‑side packages rather than as a formally versioned public interface. Historically, the package header trace ("peoru01t.pkb 120.0") confirms it originates from the HR organization units form family. Although a search for inv_organization_parameters may lead implementers here, the package itself does not manage Inventory organization parameters; it manages HR organization unit records and the organization‑information contexts on which inventory and other classifications depend.

Key Procedures and Functions

The fifteen documented units cover validation, hierarchy navigation, form support, and standard row‑level data manipulation:

  • CHK_REPBODY_SEAT_NUMBERS — validates that the maximum number of seats defined for a Representative Body is not exceeded by the sum of constituency seats recorded in RepBody_Constituencies information rows.
  • IS_ORG_A_NODE and EXISTS_IN_HIERARCHY — determine whether an organization participates in an organization hierarchy structure.
  • GET_PARENT — returns the parent organization for a given unit, supporting hierarchy traversal.
  • FORM_POST_QUERY — populates derived form fields after a query is executed.
  • CHECK_GRE — performs validation of Government Reporting Entity attributes.
  • INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW — the standard form‑level DML handlers, including optimistic locking.
  • ZOOM_FORMS — drives drill‑down navigation to related forms.
  • ADD_LANGUAGE, SET_TRANSLATION_GLOBALS, VALIDATE_TRANSLATION — manage multilingual name and description rows in the translation table, using package globals for business group and legislation context.
  • GET_ORG_CLASS — retrieves the organization classification code for a unit.

Tables Accessed

The package reads and writes HR_ALL_ORGANIZATION_UNITS (the base organization unit), HR_ALL_ORGANIZATION_UNITS_TL (translatable name and description), HR_ORGANIZATION_UNITS_S (the organization definition sequence surrogate), HR_ORGANIZATION_INFORMATION (flexible context‑driven attributes such as Representative Body and RepBody_Constituencies), and PER_ORG_STRUCTURE_ELEMENTS (hierarchy membership). FND_LANGUAGES supplies installed language codes for translation validation. DBMS_SQL and USER_OBJECTS are referenced for dynamic SQL and object existence checks. The seat‑number logic in CHK_REPBODY_SEAT_NUMBERS queries HR_ORGANIZATION_INFORMATION twice—once for the Representative Body maximum and once for the summed constituency seats, excluding the current ROWID during update.

Usage Notes

In EBS 12.1.1 and 12.2.2 this package is invoked principally from the Organization Units form (PERWSORG) through its INSERT_ROW, UPDATE_ROW, DELETE_ROW and post‑query triggers, and by related HR forms that navigate hierarchies. It is referenced by five other packages, indicating server‑side reuse for organization validation. Custom code should avoid direct calls to its form‑oriented handlers and instead use supported HR APIs. When investigating inv_organization_parameters, note that inventory parameters are stored in separate tables (e.g., MTL_PARAMETERS); this package governs the HR organization foundation, not Inventory setup itself.