Search Results per_psv_bus




Overview
Explore in AI Chat

Overview

The APPS.PER_PSV_BUS package body implements the business logic layer for Oracle E-Business Suite position structure versioning, commonly referred to within the HRMS schema as "PSV" (Position Structure Version). It is the executable counterpart to the PER_PSV_BUS package specification and functions as the private business rules engine behind the public PER_PSV_SHD shadow (seed/date-tracked) package. In Oracle EBS 12.1.1 and 12.2.2, position structures are the hierarchical containers used to organize positions into reporting, grading, or other organizational frameworks. Because these structures are date-tracked entities subject to the DateTrack model, the package enforces validation, security group context, and row-level integrity on the underlying tables before any DML is permitted.

The package is classified as an "OTHER" API in the ETRM repository. It is a valid, compiled PL/SQL object owned by APPS. It is not referenced by any other database object, but it depends on several HRMS utilities and message infrastructure components.

Key Procedures and Functions

  • GET_BUSINESS_GROUP_ID — Returns the current business group identifier used to scope operations on position structures and their elements. The value is typically derived from the session context or passed through the API call chain.
  • SET_SECURITY_GROUP_ID — Establishes the security group context for the session. This is required before any security-checked DML against position structure data, ensuring that users only manipulate structures belonging to business groups for which they hold data access privileges.
  • RETURN_LEGISLATION_CODE — Returns the legislation code associated with the business group or structure. Legislation determines which validation rules and reference data apply to a given position structure element.
  • INSERT_VALIDATE — Performs pre-insert validation on position structure element data. It verifies business group existence, structure hierarchy integrity, and date-track correctness before the row is committed.
  • UPDATE_VALIDATE — Validates changes to existing position structure elements, including date-tracked splits and updates, prior to the modification being applied.
  • DELETE_VALIDATE — Validates deletion requests, ensuring the element or structure version is not referenced in a way that would violate referential or business rules.

Tables Accessed

  • PER_POSITION_STRUCTURES — The parent table holding the definition of each position structure. Reads supply structure metadata used for validation.
  • PER_POS_STRUCTURE_ELEMENTS — Stores the individual elements (positions or sub-structures) that make up a structure. This is the primary target of validation and DML operations.
  • PER_POS_STRUCTURE_ELEMENTS_S — The shadow table that mirrors the base elements table with DateTrack effective start and end dates. All date-tracked queries and DML flow through this table.
  • PER_POS_STRUCTURE_VERSIONS — Tracks versions of a position structure over time.
  • PER_BUSINESS_GROUPS — Provides business group context and legislation code.
  • DUAL — Used for scalar lookups and single-row function returns.

Usage Notes

PER_PSV_BUS is not intended for direct invocation by end users or custom code. It is typically called by the public shadow package PER_PSV_SHD, which is in turn invoked from the Position Structures forms (such as the Define Position Structure window) and from HRMS concurrent programs that maintain position hierarchies. The package also depends on FND_MESSAGE for error messaging and on HR_API and HR_UTILITY for shared HRMS error-handling and date-track utilities. Because it is referenced by three other packages, any change to its behavior can ripple through the HRMS position management stack. Because the returned status is VALID and the package is not referenced by any database object beyond the documented set, customizations should extend it through the shadow API rather than modifying its internals. All operations assume the correct business group and security group have been set via the corresponding setters before validation routines are called. Custom concurrent programs that need to create or modify position structures should invoke PER_PSV_SHD, letting this package enforce the documented validation rules.