Search Results is_org_a_node




Overview
Explore in AI Chat

Overview

APPS.HR_ORGANIZATION_UNITS_PKG is a server-side PL/SQL package in Oracle E-Business Suite that centralizes the business logic used to create, maintain, and validate organization units in the Human Resources (HR) and shared organization model. Organization units are the foundational entities of the EBS enterprise structure: they represent business groups, legal entities, operating units, inventory organizations, and other classification-bearing units that drive security, reporting, and transaction routing across HR, Financials, and Supply Chain modules.

The package is declared AUTHID CURRENT_USER and is invoked primarily by the Oracle Forms-based Organization, Position, and Hierarchy windows, as well as by concurrent processes and custom extensions that must maintain referential and hierarchical integrity of organizations. Its responsibilities include row-level DML encapsulation for the organization tables, hierarchy navigation (establishing whether an organization exists within a structure and identifying its parent), post-query enrichment of Forms blocks, and validation routines that enforce business rules such as representative body seat numbers.

Key Procedures and Functions

  • INSERT_ROW / LOCK_ROW / UPDATE_ROW / DELETE_ROW — the core DML interface for organization units. These procedures encapsulate inserts, row locking, updates, and deletions against the organization base tables, including handling of the date-tracked (datetracked) segments and translation records.
  • FORM_POST_QUERY — a Forms-oriented routine executed after a query returns rows into a block. It evaluates the organization's position within the selected hierarchy, applies the security profile and "view all organizations" setting, and computes the number of subordinate organizations for display or navigation control.
  • IS_ORG_A_NODE — a function returning a character indicator of whether a given organization functions as a node within a specified organization structure.
  • EXISTS_IN_HIERARCHY — determines whether an organization is present within a given organization structure version, commonly used to control hierarchical navigation and validation.
  • GET_PARENT — returns the parent organization identifier for a given organization within a structure version, supporting upward navigation of the hierarchy.
  • CHK_REPBODY_SEAT_NUMBERS — validates representative body seat number information held in organization information flexfield segments, enforcing consistency of these values during organization maintenance.
  • CHECK_GRE — performs validation related to the organization's GRE (Government Reporting Entity) designation, confirming that statutory reporting attributes are correctly established.
  • ZOOM_FORMS — supports the Forms "zoom" navigation pattern, enabling users to drill from an organization record to a related window or detail block. This is the routine associated with the user's zoom_forms search term.
  • ADD_LANGUAGE / SET_TRANSLATION_GLOBALS / VALIDATE_TRANSLATION — the translation management interface. These routines insert translated rows into the TL table, initialize the global language context (based on FND_LANGUAGES) used by the translation APIs, and validate that translated records are complete and consistent against the base language row.
  • GET_ORG_CLASS — retrieves the organization classification, allowing callers to branch logic based on whether the unit is, for example, a business group, legal entity, or operating unit.

Tables Accessed

  • HR_ALL_ORGANIZATION_UNITS / HR_ALL_ORGANIZATION_UNITS_TL — the base and translation tables for organization units; the DML and translation procedures read and write these directly.
  • HR_ORGANIZATION_UNITS_S — the security/date-tracked shadow segment used by the DML and hierarchy routines.
  • HR_ORGANIZATION_INFORMATION — stores additional organization attributes (flexfield segments), read and validated by CHK_REPBODY_SEAT_NUMBERS and CHECK_GRE.
  • PER_ORG_STRUCTURE_ELEMENTS — the hierarchy definition table consulted by IS_ORG_A_NODE, EXISTS_IN_HIERARCHY, and GET_PARENT.
  • FND_LANGUAGES — supplies the installed language context for translation routines.
  • USER_OBJECTS and DBMS_SQL — used for dynamic object existence checks and dynamic SQL execution within validation and translation logic.

Usage Notes

The package is invoked most frequently from Oracle Forms through the organization and hierarchy windows, where FORM_POST_QUERY, ZOOM_FORMS, and the DML procedures drive block behavior. Concurrent programs and custom PL/SQL APIs that create or update organizations typically call INSERT_ROW, UPDATE_ROW, and the translation routines rather than writing directly to the base tables, preserving datetrack and translation integrity. Because the package is referenced by five other packages, changes to its interfaces should be assessed for downstream impact. In 12.1.1 and 12.2.2, the package behavior is consistent, though 12.2.x deployments benefit from the unified tablespace and Online Patching considerations when custom code wraps these procedures.