Search Results per_ose_del




Overview
Explore in AI Chat

Overview

PER_OSE_DEL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance and deletion of Organization Structure Element (OSE) records within Oracle Human Resources. Organization Structure Elements represent the hierarchical relationships that make up an organization hierarchy in Oracle HRMS, linking business groups, organizations, and their reporting structures. The package provides the deletion logic required to remove these hierarchy elements safely while preserving the referential integrity of the underlying organization structure.

The package is classified as an "OTHER" API, meaning it is a supporting internal utility rather than a fully published, externally-facing public API. In the ETRM metadata it is reported as VALID in both Oracle EBS 12.1.1 and 12.2.2, confirming that its interface and body remained stable across the two releases. It forms part of the broader PER_OSE family of packages, which together handle the creation, update, business validation, and deletion of organization structure elements.

Key Procedures and Functions

The documented metadata records two named routines: DEL and CHK_ORG_IN_HIERARCHY. The object header also references an internal package body and a shadow/private declaration component (PER_OSE_SHD), which is consistent with the standard EBS pattern of pairing a public specification with a shared private implementation.

  • DEL — the primary deletion routine. It removes an organization structure element from the hierarchy, applying the necessary business-rule and referential checks before the row is deleted. It is the entry point invoked by callers that need to dismantle or restructure an organization hierarchy.
  • CHK_ORG_IN_HIERARCHY — a validation helper that determines whether a given organization is already present in a hierarchy. Its purpose is to prevent duplicate insertions and to guard the deletion logic against attempting to remove elements that are referenced elsewhere in the structure.

The metadata lists three documented procedures/functions in total; the two above are the named entries, with the third accounted for by the package body's shared declarations. No parameter signatures are published in the ETRM record and none should be assumed.

Tables Accessed

The only base table documented as referenced through APPS synonyms is PER_ORG_STRUCTURE_ELEMENTS. This is the core HRMS table storing organization structure element rows. PER_OSE_DEL reads from it to locate the element targeted for deletion and to verify the hierarchy context, and writes to it in order to perform the physical removal of the row. Because the package operates on this single table, its transactional scope is narrow and its locking footprint is limited to the specific element being processed.

Usage Notes

PER_OSE_DEL is not intended to be called directly by end users. It is invoked programmatically by two dependent packages, HR_HIERARCHY_ELEMENT_API and PER_OSE_BUS, both of which provide the higher-level business and API layers for hierarchy element maintenance. HR_HIERARCHY_ELEMENT_API exposes the public API surface used by Oracle HRMS forms and by customer extensions, delegating the low-level delete operation to PER_OSE_DEL. PER_OSE_BUS supplies the business-rule layer that surrounds that operation.

Typical invocation paths therefore include the Organization Hierarchy window in the HRMS forms, concurrent programs that rebuild or reorganize hierarchies, and custom PL/SQL that legitimately calls the published hierarchy element API. Customizations should call HR_HIERARCHY_ELEMENT_API or PER_OSE_BUS rather than PER_OSE_DEL, since the latter is an internal implementation package without a documented public contract. Any direct call bypasses the business validation performed by the higher layers. Deletions should always be committed by the caller within a controlled transaction, and hierarchy-dependent reports such as the Organization Hierarchy diagram should be re-run after changes to confirm consistency.