Search Results per_positions_s

Overview

APPS.PER_POSITIONS_PKG is the central PL/SQL package body responsible for maintaining position records within Oracle E-Business Suite Human Resources. In Oracle EBS 12.1.1 and 12.2.2, a "position" represents a defined role or seat within an organization's hierarchy, distinct from the employee assignment that fills it. This package encapsulates the business logic required to insert, update, lock, and delete rows in the PER_POSITIONS entity, while enforcing date-effectivity rules, hierarchy validation, budget and grade restrictions, and identifier flexfield structure checks. Because positions are foundational to headcount management, budgeting, and vacancy tracking, the integrity logic concentrated in this package protects the entire position lifecycle.

The package is classified as an "OTHER" API rather than a public, supported interface, meaning it is primarily invoked internally by Oracle HRMS forms, concurrent processes, and dependent packages rather than by customer code. Its status is VALID, and it is referenced by two other database packages, confirming its role as a reusable maintenance layer.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions:

• INSERT_ROW — Creates a new position row, applying defaulting and validation logic before the record is committed.
• UPDATE_ROW — Modifies an existing position record, re-validating date-effective and structural constraints.
• DELETE_ROW — Removes a position record from the entity.
• LOCK_ROW — Acquires a lock on the target position row to serialize concurrent maintenance.
• PRE_DELETE_CHECKS — Performs referential and business-rule validation before permitting a deletion.
• CHECK_ID_FLEX_STRUCT — Validates the key flexfield structure associated with the position against configured flexfield definitions.
• CHECK_DATE_EFFECTIVE — Ensures date-effective datetracked operations are valid across the position's effective period.
• CHECK_VALID_GRADES — Verifies that grades attached to a position conform to valid grade rules.
• MAINTAIN_VALID_GRADES — Inserts, updates, or removes grade associations for a position.
• EXISTS_IN_HIERARCHY — Determines whether a position participates in a position hierarchy structure.
• GET_SHARED_POS_WARN_FLAG — Retrieves the indicator controlling warnings for shared-position scenarios.
• SET_SHARED_POS_WARN_FLAG — Sets that shared-position warning indicator.

Tables Accessed

The package reads and writes a broad set of HRMS and related tables through APPS synonyms. Core entity tables include PER_POSITIONS and its localized/secure view PER_POSITIONS_S, plus PER_ALL_POSITIONS for the denormalized position view. Hierarchy and structure validation uses PER_POS_STRUCTURE_ELEMENTS. Grade and budget enforcement draws on PER_GRADES, PER_VALID_GRADES, and PER_BUDGET_ELEMENTS. Assignment dependencies are checked through PER_ALL_ASSIGNMENTS_F, while PER_JOB_EVALUATIONS, PER_JOB_REQUIREMENTS, and PER_MM_POSITIONS support job-related and mass-maintenance validation. Flexfield structure integrity relies on FND_ID_FLEX_STRUCTURES and FND_COMPILED_ID_FLEX_STRUCTS. Vacancy and benefits copy integration use PER_VACANCIES, BEN_COPY_ENTITY_RESULTS, and BEN_COPY_ENTITY_RESULTS_S. Payroll linkage validation references PAY_ELEMENT_LINKS_F.

Usage Notes

PER_POSITIONS_PKG is typically invoked from the Position form and related HRMS windows, from concurrent programs that maintain or validate position data, and from the two dependent packages that call it. The internal helper packages HR_UTILITY, PER_OTA_PREDEL_VALIDATION, and DBMS_SQL (used for dynamic flexfield validation) are leveraged during execution. Because the package is classified as OTHER and is not a documented public API, direct customer invocation should be avoided; customizations should instead call supported position APIs or DML on the underlying views. The presence of LOCK_ROW and PRE_DELETE_CHECKS indicates it is designed for safe concurrent maintenance and must be used within a commit-controlled transaction.