Search Results pay_pss_tx_steps_pkg




Overview
Explore in AI Chat

Overview

The APPS.PAY_PSS_TX_STEPS_PKG package body is a database-tier PL/SQL component belonging to the Oracle E-Business Suite Payroll (PAY) product family, specifically the Public Sector / Payroll Streamlined Steps (PSS) subsystem. Its responsibility is to manage the transactional step records associated with Payroll PSS transactions. In EBS 12.1.1 and 12.2.2, it provides a controlled, centralized interface for inserting, updating, and deleting rows within the PAY_PSS_TRANSACTION_STEPS entity, insulating callers from direct DML against the underlying transaction step table. The package is classified as OTHER (a general-purpose data manipulation package rather than a published business API) and is registered as VALID in the APPS schema. It is documented in ETRM under object type PACKAGE BODY and exposes four documented procedures.

Key Procedures and Functions

The package body defines four documented procedures:

  • INSERT_ROW – Creates a new transaction step record in the transaction steps table, registering a step against a PSS transaction.
  • UPDATE_ROW – Modifies an existing transaction step record, allowing attributes of a previously created step to be changed.
  • DELETE_ROW – Removes a single transaction step row, typically used when a specific step must be reversed or removed.
  • DELETE_ROWS – Removes multiple transaction step rows in a single operation, supporting bulk removal of steps associated with a transaction or processing run.

These procedures form a small CRUD-style surface around the transaction steps entity. No parameter lists are documented in the ETRM metadata; the procedures are described here by name and intended purpose only.

Tables Accessed

The package body references the following tables through APPS synonyms:

  • PAY_PSS_TRANSACTION_STEPS – the primary table holding transaction step data written and read by INSERT_ROW, UPDATE_ROW, and the delete procedures.
  • PAY_PSS_TRANSACTION_STEPS_S – the sequence (or surrogate key) source used to generate unique identifiers for new step rows during insertion.
  • PAY_PSS_TRANSACTIONS_S – a sequence tied to the parent PSS transaction, referenced for identifier generation or coordination with the owning transaction.
  • DUAL – used for single-row selection and sequence value retrieval.

Standard SYS.STANDARD and the APPS.PAY_PSS_TX_STEPS_PKG package specification are also listed as dependencies.

Usage Notes

PAY_PSS_TX_STEPS_PKG is not referenced by any database object, indicating that it is invoked through PL/SQL calls from forms, concurrent programs, or custom extensions rather than being a dependency of another stored program in the schema. The ETRM metadata records that it is referenced by two other packages, suggesting external code depends on its procedures for step maintenance. Typical invocations include OAF or Forms-based maintenance of Payroll PSS transactions, concurrent programs that build or adjust transaction steps, and custom PL/SQL that must persist step-level detail. Because the package performs direct DML rather than routing through a published business API, callers should respect the same validation and commit conventions imposed by the calling form or program. In both 12.1.1 and 12.2.2, the package retains a VALID status, and its behavior is consistent across these releases.