Search Results per_pos_structure_versions_s




Overview
Explore in AI Chat

Overview

The APPS.PER_POS_STRUCTURE_VERSIONS_PKG package body encapsulates the business logic that governs versioning of position hierarchies within Oracle EBS Human Resources (PER). A "position structure version" represents a dated, point-in-time snapshot of a position hierarchy, allowing organizations to maintain historical records of how positions were organized and reported to one another. This package provides the core DML and validation layer used to create, maintain, and remove those version definitions together with the position structure elements they contain. Because the package is classified as OTHER rather than as a public API, it is a supporting implementation package that is invoked indirectly by the forms and concurrent processes that manage position hierarchies, rather than being exposed as a documented integration interface.

Key Procedures and Functions

The package body documents ten procedures and functions that collectively manage the lifecycle of a position structure version:

  • GET_NEXT_FREE_NO — Returns the next available version number, used to generate a unique version identifier for a new position structure version.
  • CHECK_VERSION_NUMBER — Validates that a proposed version number is acceptable, typically enforcing uniqueness against existing versions.
  • CHECK_DATE_GAP — Verifies that a new or modified version's effective dates do not leave invalid gaps relative to adjacent versions.
  • CHECK_OVERLAP — Ensures that the date range of a version does not overlap with the date ranges of other existing versions.
  • COPY_ELEMENTS — Copies position structure elements from a source version into a target version, supporting the creation of a new version based on an existing hierarchy.
  • PRE_DELETE_CHECKS — Performs prerequisite validation before a version may be deleted, preventing removal of versions that are still referenced or otherwise protected.
  • INSERT_ROW — Inserts a new position structure version record after validation.
  • LOCK_ROW — Acquires a lock on a version record to ensure transactional consistency during update or delete operations.
  • UPDATE_ROW — Updates an existing position structure version record.
  • DELETE_ROW — Removes a position structure version record following successful pre-delete validation.

Tables Accessed

The package operates against the following tables through APPS synonyms. PER_POS_STRUCTURE_VERSIONS stores the version header records that define each dated snapshot, and PER_POS_STRUCTURE_VERSIONS_S is its corresponding sequence/primary-key support table. PER_POS_STRUCTURE_ELEMENTS holds the individual position relationships that make up a version's hierarchy, with PER_POS_STRUCTURE_ELEMENTS_S providing the associated key generation. PER_SECURITY_PROFILES is referenced to apply or validate security profile restrictions against the structure data. These tables are read and written to support the validation, insertion, updating, copying, and deletion of position structure versions and their constituent elements.

Usage Notes

PER_POS_STRUCTURE_VERSIONS_PKG is invoked by the Oracle HRMS forms and internal processes that administer position hierarchies, particularly when users create a new version, copy an existing hierarchy, or adjust the effective dates of a version. It is not referenced by any other database object, and no external package depends on it, confirming its role as an internal implementation package. Customizations should generally avoid calling these procedures directly; instead, they should rely on supported HR APIs, since direct invocation bypasses the safeguards enforced at the form and API layers. The package depends on APP_EXCEPTION, FND_MESSAGE, HR_UTILITY, and STANDARD for error handling and utility services.