Results for “pqh_position_transactions_api”

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

Overview

APPS.PQH_POSITION_TRANSACTIONS_API is a public PL/SQL API package belonging to the Oracle E-Business Suite HRMS position management layer, built on the Enterprise Technical Reference Model (ETRM) and classified as an API in release 12.2.2. Its business purpose is to provide a controlled, business-rule-enforcing interface for creating, modifying, and removing position transactions — the dated records that capture changes to a position over time, such as job, location, organization, grade, or supervisor changes recorded against the PQH_POSITION_TRANSACTIONS entity. Rather than permitting direct DML against the underlying table, the package centralizes validation, date-effectivity handling, and derivation of attributes such as entry step, entry grade rule, and availability status, thereby preserving data integrity and supporting the position control and budgeting functionality delivered by Oracle HRMS.

Key Procedures and Functions

The documented package exposes three public procedures:

• CREATE_POSITION_TRANSACTION — Inserts a new position transaction record. It accepts the position identifier, effective dates, and the full range of descriptive and derivation attributes (job, location, organization, grade, supervisor and successor positions, availability status, bargaining unit, and so on), supports a validation-only mode via the p_validate flag, and returns the newly generated position transaction identifier to the caller.
• UPDATE_POSITION_TRANSACTION — Modifies an existing position transaction, applying the same validation and derivation logic used at creation so that changes remain consistent with position control rules and date-effectivity constraints.
• DELETE_POSITION_TRANSACTION — Removes a position transaction record. This is the procedure users most frequently search for by name, and it is the documented mechanism for reversing or cleaning up a position change that should no longer be effective.

The package header also declares package-level variables, notably g_package, used to prefix error messages and messages raised through the standard HRMS message and error-handling utilities.

Tables Accessed

The single documented table referenced through APPS synonyms is PQH_POSITION_TRANSACTIONS. This table stores the transaction rows themselves and is the primary target of the insert, update, and delete operations performed by the three public procedures. The package derives and validates attribute values before writing to this table, ensuring that each transaction row is internally consistent and correctly linked to its parent position.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2 this package is typically invoked from the Position Management and Position Control forms in the HRMS responsibility, where the form’s block logic delegates insert, update, and delete operations to the corresponding API procedures instead of issuing direct SQL. It may also be called from concurrent programs that mass-maintain positions, and from customer-written PL/SQL where position transactions must be created or removed programmatically. Because it is registered and classified as a public API in ETRM, it is a supported extension point and is referenced by two other packages in the ETRM inventory. Callers should supply the validation flag, handle the standard HRMS application errors raised by the package, and issue an explicit commit or rollback since the API does not manage transaction control. Direct DML against PQH_POSITION_TRANSACTIONS is not supported and bypasses the package’s validation and derivation logic.