Search Results pay_ppmv4_ss




Overview
Explore in AI Chat

Overview

PAY_PSS_TX_STEPS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Payroll. It belongs to the transaction step processing layer of the Payroll Secondary Sub-ledger (PSS) architecture, a framework introduced to support payroll cost allocation and sub-ledger transfer processing. The package encapsulates the data manipulation logic required to maintain records in the transaction step tables, which represent the individual processing stages, statuses, and outcomes associated with payroll transactions as they move through the PSS pipeline. Its classification as "OTHER" in the ETRM metadata indicates that it is an internal helper package rather than a public API, and it is intended to be called by other PSS components rather than directly by end users.

The primary business purpose of the package is to provide controlled insert, update, and delete operations against the transaction step entities, ensuring consistent maintenance of step-level records throughout the lifecycle of a payroll transaction.

Key Procedures and Functions

The package exposes four documented procedures:

  • INSERT_ROW — Creates a new transaction step record. It is used when a payroll transaction enters a new processing stage and a corresponding step row must be established.
  • UPDATE_ROW — Modifies an existing transaction step record, typically to reflect a change in status, completion flags, or processing outcome for a given step.
  • DELETE_ROW — Removes a single transaction step record, used when an individual step entry is no longer required or must be reversed.
  • DELETE_ROWS — Removes multiple transaction step records in a single operation, supporting bulk cleanup of step data associated with one or more transactions.

The ETRM metadata does not publish parameter lists for these procedures; parameter signatures must be confirmed directly from the package source in the database. The procedures follow the standard EBS DML-wrapper convention used throughout the PSS packages.

Tables Accessed

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

  • PAY_PSS_TRANSACTION_STEPS — The base table holding individual transaction step records, including step identifiers, statuses, and associated attributes.
  • PAY_PSS_TRANSACTION_STEPS_S — The corresponding multilingual (translation) table, providing language-specific content for step definitions where applicable.
  • PAY_PSS_TRANSACTIONS_S — The transaction translation table, consulted to validate or correlate step data against parent transactions.
  • DUAL — Used for single-row scalar evaluations and default value derivation within the package logic.

These tables collectively support the persistence and maintenance of the PSS transaction step model.

Usage Notes

PAY_PSS_TX_STEPS_PKG is not designed for direct invocation by end users or custom code. The ETRM dependency data shows it is referenced by two other packages: PAY_PPMV4_SS, which appears twice in the reference list, and PAY_PPMV4_UTILS_SS, along with a self-reference from PAY_PSS_TX_STEPS_PKG itself. This confirms its role as a subordinate utility invoked by higher-level PSS processing packages, such as those handling payroll sub-ledger transfer and transaction routing. Typical invocation occurs during online payroll processing, concurrent program execution, or background transfer jobs that drive transactions through their PSS steps. Because the package manipulates core transaction step data, any customization or extension should treat it as an internal component, and modifications should be validated against the calling PSS packages to preserve expected behavior in both EBS 12.1.1 and 12.2.2.