Search Results per_pos_structure_version_api




Overview
Explore in AI Chat

Overview

The APPS.PER_POS_STRUCTURE_VERSION_API package is a public PL/SQL API belonging to the Oracle E-Business Suite Human Resources (HR) module. It provides the programmatic interface for managing position structure versions — the dated, versioned containers that define the hierarchy and reporting relationships of positions within an organization over time. In Oracle HRMS, position structures describe how positions relate to one another (for example, supervisory or reporting hierarchies). Because organizational structures change, each structure is maintained through one or more versions, each with an effective date range. This package allows that versioning information to be created, modified, and removed in a controlled, validated manner rather than through direct table manipulation.

The package is registered in the ETRM repository with owner APPS, status VALID, and an API classification, confirming it is a supported, callable interface. It depends on HR_API and the standard SYS.STANDARD package, and it is referenced by PER_POSITION_STRUCTURE_API, PER_POS_STRUCTURE_VERSION_SWI, and itself.

Key Procedures and Functions

The documented interface exposes three procedures:

  • CREATE_POS_STRUCTURE_VERSION — Inserts a new version of a position structure, establishing its effective dates and associated structure definition. This is the entry point for introducing a new dated iteration of an existing position hierarchy.
  • UPDATE_POS_STRUCTURE_VERSION — Modifies the attributes of an existing position structure version, such as its effective date range or descriptive data, while preserving referential integrity with related position structure records.
  • DELETE_POS_STRUCTURE_VERSION — Removes a position structure version. Deletion is subject to the business rules enforced by the API, helping prevent the removal of versions that are still referenced by active position structure data.

All three procedures follow the standard HRMS API conventions, including the use of an HR_API error-handling model that returns status and error messages to the caller rather than raising unhandled exceptions. Parameter lists are intentionally omitted here and should be validated against the deployed package specification.

Tables Accessed

The package reads and writes two core HRMS tables through APPS synonyms:

  • PER_POSITION_STRUCTURES — Stores the definition of each position structure. The API validates and references the parent structure when managing its versions.
  • PER_POS_STRUCTURE_VERSIONS — Stores the dated versions of each position structure, including effective start and end dates. This is the primary table on which the create, update, and delete operations act.

These tables underpin the versioning model that allows an organization to retain historical hierarchy definitions while evolving the current structure.

Usage Notes

This package is typically invoked from Oracle HRMS forms, from concurrent programs, and from custom PL/SQL that needs to maintain position structure versions programmatically. The PER_POS_STRUCTURE_VERSION_SWI package, which references this API, indicates that the API is also exposed through a server-side web interface layer used by self-service and web-based position management. Because PER_POSITION_STRUCTURE_API references this package, callers managing a complete position structure commonly work through the parent structure API, which in turn delegates version handling here.

Oracle recommends calling the API rather than inserting or updating PER_POS_STRUCTURE_VERSIONS directly, since the API enforces date validation, structure consistency, and the HR_API error-handling contract. Custom code should inspect the returned status and error table for failures. This behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, where the package retains the same owner, status, and documented procedure set.