Search Results permit_extended_pay

Overview

APPS.PQH_PTX_BUS is the business-layer package body for the Position Transactions entity within the Oracle E-Business Suite Public Sector / Human Resources (PQH) module. It forms part of the standard Table Handler (TAPI) stack generated for the PQH_POSITION_TRANSACTIONS table, sitting above the shadow package PQH_PTX_SHD and working alongside the private API package PQH_PTX_API. Its principal business function is to centralise validation rules that govern the creation, modification, and removal of position transaction records — the records that capture workforce and budgetary position changes, including assignment, budget, and costing transactions.

The package header revision ($Header: pqptxrhi.pkb 120.0.12010000.2) confirms it is a released 12.1.1-era object that remains present in 12.2.2. Within the ETRM reference it is classified as API type OTHER, indicating it is not a public declarative API but an internal validation layer invoked by the higher-level TAPI.

Key Procedures and Functions

• CHK_POSITION_TRANSACTION_ID (internal) — verifies that the primary key for the table is constructed correctly: it must be null on insert and must not be altered on update. The procedure calls PQH_PTX_SHD.api_updating and raises a constraint error referencing PQH_POSITION_TRANSACTIONS_PK if the key changes.
• RETURN_LEGISLATION_CODE — returns the legislation code applicable to the position transaction, allowing downstream validation to apply the correct country-specific business rules for the record being processed.
• CHK_END_DATES — validates the end-date attributes of the transaction, ensuring that date ranges are internally consistent and adhere to the effective-dating rules required for position transaction records.
• INSERT_VALIDATE — executes the full set of row-level business validations required before a new position transaction row is inserted, rejecting the record where validation fails.
• UPDATE_VALIDATE — executes the corresponding validations for an existing row prior to update, including checks against the current object version number to preserve optimistic locking.
• DELETE_VALIDATE — applies the business rules that determine whether an existing position transaction may be deleted.

The procedures communicate failures through the standard HR error-handling mechanism (hr_utility.set_location and constraint_error), consistent with Oracle's generated table handler conventions.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• PQH_POSITION_TRANSACTIONS — the primary entity table; the target of insert, update, and delete validation.
• PQH_PTX_EXTRA_INFO — supplementary descriptive information attached to position transactions, consulted during validation.
• PER_POSITION_DEFINITIONS — position definitions against which the transaction is validated.
• HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL — organisation and location data used to confirm the validity of the position context.
• PER_GRADES, PER_JOBS — grade and job reference data applied during validation.
• PER_SHARED_TYPES — shared lookup/type values used for code validation.

Usage Notes

PQH_PTX_BUS is not intended for direct invocation by end users or custom code. It is called indirectly by the PQH position transaction TAPI whenever a position transaction is inserted, updated, or deleted — typically from the Position Transactions form, related concurrent processes, or other PQH packages that manipulate position data. The metadata records three packages referencing it, which confirms its role as a shared, internal dependency rather than an entry point. Implementers extending position transaction behaviour should do so through the public TAPI and API layers rather than by altering this business package. The term permit_extended_pay surfaced in the search does not appear as a documented procedure or column in this package; extended pay/permitted-pay behavior associated with position transactions is handled elsewhere in the PQH/PAY integration and should not be attributed to PQH_PTX_BUS on the basis of this metadata.