Search Results pay_etm_bus




Overview
Explore in AI Chat

Overview

PAY_ETM_BUS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Payroll Element Templates module (ETM). Its name follows the standard EBS convention in which the _BUS suffix denotes a business-layer package, sitting between the user interface and the underlying database tables. The package encapsulates the core validation logic used to maintain element templates — the reusable definitions that determine how payroll elements are created, grouped, and restricted for a legislative or business context.

The package is documented with a status of VALID in both EBS 12.1.1 and 12.2.2, and its API classification in the ETRM metadata is OTHER. It is a tightly scoped support package rather than a public application programming interface; it provides the business rules that higher-level DML routines rely upon before committing changes to template data.

Key Procedures and Functions

Three procedures are documented for this package. Their names indicate that they implement row-level validation for the three standard DML operations performed on element template data:

  • INSERT_VALIDATE — Validates the attributes of a new element template record before insertion, ensuring the definition is complete and consistent with the template model.
  • UPDATE_VALIDATE — Validates proposed changes to an existing element template record, confirming that modifications do not violate the rules governing template structure or exclusion behaviour.
  • DELETE_VALIDATE — Validates that an element template may be safely removed, preventing deletion where dependent or template-related data would be left inconsistent.

The exact parameter lists are not published in the ETRM metadata and should not be assumed. In practice these routines are invoked internally rather than called directly by customers.

Tables Accessed

The package operates against the following tables through APPS synonyms:

Collectively these reads confirm that template records, their core object mappings, their exclusion rules, and the referenced element and balance type definitions are all consistent before a change is accepted.

Usage Notes

PAY_ETM_BUS sits beneath the user-facing element template maintenance functions. It is referenced by three other packages — PAY_ETM_INS, PAY_ETM_UPD, and PAY_ETM_DEL — which correspond to the insert, update, and delete paths of the template maintenance flow, and it references PAY_ETM_SHD, the shadow table maintenance package. Because the validation procedures are called by these DML packages rather than by end users, the package is normally executed indirectly: when a payroll administrator creates, modifies, or deletes an element template through the Element Templates form in Oracle Payroll. Direct invocation from custom code is possible but unsupported. Any local extension should avoid modifying this package and instead rely on the documented template APIs.