Results for “per_org_structure_version_api”

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

Overview

The APPS.PER_ORG_STRUCTURE_VERSION_API package is a public PL/SQL API within the Oracle E-Business Suite Human Resources (HR) module. It provides a supported programmatic interface for creating, maintaining, and removing versions of organization structures. In Oracle HRMS, an organization structure (also referred to as an organization hierarchy) defines a parent-child relationship between organizations, such as a reporting or costing hierarchy. Each structure is maintained over time through dated versions, which allow the hierarchy to reflect organizational changes without losing historical configuration.

This package encapsulates the business logic and validation rules required to manipulate those structure versions consistently, ensuring that direct table manipulation is avoided and that all integrity constraints, date-effectivity rules, and derived data remain valid. Because it is classified as an API object and is owned by the APPS schema, it is intended to be called from forms, concurrent programs, and custom extensions rather than queried or modified directly at the table level.

Key Procedures and Functions

The documented interface exposes three procedures:

• CREATE_ORG_STRUCTURE_VERSION — Establishes a new version of an organization structure. It is used when a new dated instance of a hierarchy must be introduced, capturing the effective period and the structural definition for that version.
• UPDATE_ORG_STRUCTURE_VERSION — Modifies an existing organization structure version. This supports corrections or adjustments to a version that has already been defined, applying the package's validation rules before the change is persisted.
• DELETE_ORG_STRUCTURE_VERSION — Removes an organization structure version. This procedure enforces any restrictions governing which versions may be deleted, preserving referential and historical consistency across the HR schema.

Parameter lists are not reproduced here; callers should consult the package specification or the ETRM object documentation for the exact signatures, which typically include version identifiers, organization structure identifiers, and date-effective attributes.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• PER_ORGANIZATION_STRUCTURES — Holds the definition of each organization structure (hierarchy) itself, providing the parent record to which versions belong.
• PER_ORG_STRUCTURE_VERSIONS — Stores the dated versions of each structure. This is the primary table affected by create, update, and delete operations.
• PER_ORG_STRUCTURE_ELEMENTS — Contains the individual organization entries that comprise a given structure version, defining the members of the hierarchy.

Together these tables form the persistent model that the API maintains, and the package reads and writes them in a coordinated manner to keep a structure and its versions consistent.

Usage Notes

PER_ORG_STRUCTURE_VERSION_API is referenced by the concurrent program packages HRDPP_CREATE_ORG_STRUCTURE_VER and HRDPP_UPDATE_ORG_STRUCTURE_VER, by the higher-level PER_ORGANIZATION_STRUCTURE_API, and by the security wrapper PER_ORG_STRUCTURE_VERSION_SWI. It also depends on HR_API, the standard HR error-handling and utility package.

Typical invocation occurs from the Organization Structures forms, from the associated concurrent programs used for bulk version maintenance, or from custom PL/SQL that must create or revise hierarchy versions during data loading and integration. Because it is a secured API, callers should invoke it through the appropriate wrapper where security validation is required, and should always handle the standard HR error conditions returned via HR_API.