Search Results pay_tco_bus




Overview
Explore in AI Chat

Overview

APPS.PAY_TCO_BUS is a PL/SQL package that forms part of the Oracle Payroll "TCO" (Table Consonance Operation) validation layer within Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, this package is registered as VALID in the APPS schema and is classified as an "OTHER" API type rather than a public-accessible business API. Its primary business function is to enforce referential and business-rule consonance across the complex web of Payroll configuration entities — element types, balance types, balance feeds, element templates, formula result rules, and gross-up configurations — so that dependent definitions remain internally consistent whenever payroll setup data is inserted, changed, or removed.

The package is tightly coupled to the shadow-table mechanism used by Oracle Payroll. It uses APPS.PAY_TCO_SHD as its reference source and is invoked by three sibling wrapper packages — PAY_TCO_INS, PAY_TCO_UPD, and PAY_TCO_DEL — which correspond to the insert, update, and delete trigger or API entry points. This design isolates the validation rules from the calling context, allowing the same consonance checks to be reused by multiple DML pathways.

Key Procedures and Functions

ETRM documents three procedures or functions in PAY_TCO_BUS:

  • INSERT_VALIDATE — Validates payroll configuration data as it is being inserted. It verifies that new element types, balance definitions, and their associated feed, classification, and template records are compatible with existing definitions before the row is committed.
  • UPDATE_VALIDATE — Applies the same consonance logic to modifications of existing payroll definitions. It ensures that changes to an element type, balance type, or formula result rule do not invalidate dependent balance feeds, shadow balance classifications, or gross-up exclusions.
  • DELETE_VALIDATE — Checks whether a payroll definition may be removed without leaving orphaned or inconsistent downstream references, protecting the integrity of the balance feed and result rule graph.

The metadata does not expose parameter lists, so the exact signatures cannot be published; consumers should inspect the package body for the precise IN/OUT parameters.

Tables Accessed

PAY_TCO_BUS reads and writes a broad set of Payroll core and configuration tables through APPS synonyms, including:

Usage Notes

PAY_TCO_BUS is not intended for direct invocation by end users or custom code. It is invoked indirectly by the PAY_TCO_INS, PAY_TCO_UPD, and PAY_TCO_DEL packages, which are themselves triggered from Payroll setup forms such as Element Types, Balance Types, and Formula Result Rules, from concurrent programs that load payroll definitions, and from dataloader or API-based setup migrations. Because it participates in the DML transaction, validation errors raised here surface to the calling form or loader and roll back the offending operation. Custom integrators should prefer the documented public APIs rather than calling INSERT_VALIDATE, UPDATE_VALIDATE, or DELETE_VALIDATE directly, since the package's contract is internal and may evolve across patch levels. When troubleshooting payroll setup errors, referencing this package and its callers in the PL/SQL stack trace is a reliable way to identify which consonance rule was violated.