Search Results pay_siv_bus




Overview
Explore in AI Chat

Overview

PAY_SIV_BUS is an Oracle EBS Payroll (PAY) schema business-layer PL/SQL package owned by the APPS schema. Its naming convention reflects its role as the business logic layer for the "SIV" object family — Shadow Input Values — which is part of the Oracle Payroll shadow (simulation/date-tracked copy) data architecture. The package encapsulates the validation logic applied to shadow input value records as they are created, modified, or removed within the shadow schema.

In Oracle Payroll, the shadow schema holds date-tracked copies of payroll definitions and element configuration data (formulas, element types, input values, balance feeds, rules), enabling retroactive processing and date-effective changes without disturbing core definitions. Business rules governing the validity of these records must be enforced consistently across all mutation paths. PAY_SIV_BUS centralises those rules, delegating persistence to the companion packages PAY_SIV_INS, PAY_SIV_UPD, PAY_SIV_DEL, and the shared layer PAY_SIV_SHD. In the ETRM catalogue it is classified as API classification OTHER, indicating it is an internal business component rather than a public, callable API.

Key Procedures and Functions

Three documented procedures constitute the package interface, each corresponding to one data manipulation operation on shadow input values:

  • INSERT_VALIDATE — Validates a shadow input value record before insertion. It confirms the record is structurally and semantically consistent with payroll business rules prior to physical creation, preventing invalid shadow data from entering the schema.
  • UPDATE_VALIDATE — Validates proposed changes to an existing shadow input value record before the update is applied, ensuring modified attributes remain compliant with payroll constraints and date-effective integrity.
  • DELETE_VALIDATE — Validates that a shadow input value record may be safely removed, checking for conditions that would render deletion invalid or leave dependent payroll structures inconsistent.

No formal parameter lists are documented; the procedures are internal validation entry points invoked by the corresponding DML packages rather than by external consumers.

Tables Accessed

The package operates against the following APPS-synonymed tables, principally within the PAY_SHADOW_* family that constitutes the shadow schema:

Collectively these accesses reflect a validation routine that verifies structural ownership (template and element type membership), rule compliance (formulas, formula rules, iterative rules, exclusion rules), and downstream balance impact.

Usage Notes

PAY_SIV_BUS is not intended for direct invocation by end users, concurrent programs, or external integrations. It is called internally by the shadow input value DML packages — PAY_SIV_INS, PAY_SIV_UPD, and PAY_SIV_DEL — each of which invokes the matching validation procedure prior to performing its insert, update, or delete. The package itself is also referenced by its own package body, and it depends on PAY_SIV_SHD for shared shadow-schema utility logic and on the SYS.STANDARD package.

Typical invocation therefore occurs during payroll element configuration maintenance — including template-based element creation and date-effective changes — where shadow records are generated or altered. Because the package enforces validation rather than performing DML, customisations should never call it to persist data; developers extending shadow input value processing should invoke the appropriate DML package, which in turn triggers PAY_SIV_BUS validation. Direct calls risk bypassing transactional ordering assumed by PAY_SIV_SHD. In both EBS 12.1.1 and 12.2.2 the object ships in VALID status as a standard, Oracle-owned component.