Search Results pay_set_bus




Overview
Explore in AI Chat

Overview

PAY_SET_BUS is a validation and business-rule package within the Oracle E-Business Suite Payroll (PAY) module. It belongs to the family of "SET" packages that support the management and maintenance of payroll element sets and their associated shadow (template-based) definitions. In EBS 12.1.1 and 12.2.2, element sets and their template-driven definitions are stored in a set of shadow tables that mirror the runtime element configuration. PAY_SET_BUS provides the centralized validation logic invoked before and during data manipulation against these shadow structures, ensuring that element-set operations respect the mandatory and referential constraints defined by the application.

The package is classified as "OTHER" in the ETRM metadata, and it exposes exactly three documented entry points, all of which are validation routines. This confirms its role as a validation layer rather than as a data-manipulation or query API.

Key Procedures and Functions

  • INSERT_VALIDATE — Validates the data that is about to be inserted into the shadow element-set and template structures. It enforces the business rules, required values, and cross-table consistency checks that must pass before a new element set or template record is created.
  • UPDATE_VALIDATE — Validates modifications to existing shadow element-set and template records. It ensures that any change remains consistent with existing dependent rows and does not violate the rules governing element-set definitions.
  • DELETE_VALIDATE — Validates whether a shadow element-set or template record may be removed. It protects referential integrity by confirming that no dependent configuration references the row being deleted.

The parameter lists are not documented in the available metadata and are therefore not reproduced here. The naming convention and the reference graph strongly indicate that each routine is a validation handler called immediately before the corresponding DML operation.

Tables Accessed

The package reads and writes via APPS synonyms to a broad set of shadow and template tables:

It also references PAY_SET_SHD, the shadow base table whose content the validation routines protect.

Usage Notes

PAY_SET_BUS is referenced by three sibling packages — PAY_SET_INS, PAY_SET_UPD, and PAY_SET_DEL — which perform the actual insert, update, and delete operations against the shadow element-set structures. Each of those packages calls the matching validation routine in PAY_SET_BUS as a precondition to its DML, establishing a clear separation between business validation and physical data manipulation. The package is also self-referencing, indicating internal calls between its own routines.

Because it is an internal support package rather than a public API, it is not normally invoked directly from forms, concurrent programs, or custom code. Customizations that manipulate shadow element-set or template data should call the PAY_SET_INS, PAY_SET_UPD, and PAY_SET_DEL packages instead, allowing them to drive the appropriate validation routines in PAY_SET_BUS. Direct calls to PAY_SET_BUS bypass supported processing order and are not recommended.