Search Results p_consolidation_set_id

Overview

PAY_CONSOLIDATION_SETS_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the maintenance and validation of payroll consolidation sets. Consolidation sets are used in Oracle Payroll to group multiple payrolls so that related payroll runs, costing, or reporting activities can be processed and viewed together. The package encapsulates the core business logic required to manage the consolidation set definitions stored in the underlying tables, and it is classified as an OTHER API in the ETRM documentation for Oracle EBS 12.1.1 and 12.2.2.

The package body is documented as VALID and interacts with the base tables PAY_CONSOLIDATION_SETS, PAY_CONSOLIDATION_SETS_S, PAY_PAYROLLS_F, and PAY_PAYROLL_ACTIONS, drawing on HR_UTILITY for common date and utility operations. It does not expose public synonyms of its own; the object name queried, PAY_CONSOLIDATION_SETS_S, corresponds to the date-tracked (surrogate key) table used by the consolidation set foundation, which the package references and maintains.

Key Procedures and Functions

The package body exposes three documented program units that implement the validation and sequencing logic for consolidation set records.

• GET_NEXT_SEQUENCE — Returns the next available sequence value used when creating or validating consolidation set records. This function supplies the surrogate identifier required by the date-tracked consolidation set table, ensuring uniqueness of the generated key.
• CHECK_UNIQUE_NAME — Validates that a proposed consolidation set name is unique within its applicable context. This prevents duplicate consolidation set definitions, which would otherwise cause ambiguity when payrolls are grouped.
• CHECK_DELETE — Determines whether a consolidation set may be safely deleted. It evaluates dependent payroll and payroll action data, preventing deletion of a set that is still referenced by active payroll processing.

The ETRM metadata does not publish parameter lists for these units, so they are described by purpose only. The package does not reference any additional packages and is not referenced by any other database object, indicating it is invoked directly rather than through inter-package dependencies.

Tables Accessed

• PAY_CONSOLIDATION_SETS — The primary definition table holding consolidation set headers; the package reads and validates this data during name and delete checks.
• PAY_CONSOLIDATION_SETS_S — The date-tracked (surrogate key) companion table that stores effective-dated versions of consolidation set definitions. GET_NEXT_SEQUENCE supports creation of the surrogate identifiers used here.
• PAY_PAYROLLS_F — The payroll definitions table, consulted to determine whether payrolls are assigned to a consolidation set.
• PAY_PAYROLL_ACTIONS — Records payroll processing actions; queried by CHECK_DELETE to prevent removal of a consolidation set that has associated payroll activity.

Usage Notes

PAY_CONSOLIDATION_SETS_PKG is typically invoked from the Oracle Payroll consolidation set maintenance form (the Consolidation Sets window) as well as from any custom code that programmatically creates, renames, or deletes consolidation sets. The validation routines CHECK_UNIQUE_NAME and CHECK_DELETE are commonly called before a DML operation to enforce integrity rules, while GET_NEXT_SEQUENCE supplies the next surrogate key during record creation. Because the package is not referenced by other database objects, it functions as a leaf-level utility that relies on HR_UTILITY and the standard consolidation set tables. Custom integrations performing bulk maintenance of consolidation sets should call these procedures to preserve the same validation behavior enforced by the standard application.