Search Results pay_sdb_upd




Overview
Explore in AI Chat

Overview

PAY_SDB_UPD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Payroll (PAY) product family. The name follows Oracle's Shadow Defined Balance convention, where the "SDB" prefix denotes the Shadow Defined Balance subsystem and the "UPD" suffix indicates an update-oriented package. Its documented dependencies on PAY_SDB_BUS (business logic layer), PAY_SDB_SHD (shadow definition layer), and PAY_SDB_UPD itself confirm it is a member of the Payroll shadow balance API stack rather than a standalone utility.

The package provides the database-side implementation for persisting and refreshing shadow defined balance rows, which are preprocessed balance values maintained for reporting, costing, and downstream balance retrieval. By isolating update logic in a dedicated package, Oracle separates write operations from the read-oriented shadow balance routines and from the business-layer validation routines, allowing payroll calculations and balance maintenance to invoke controlled, encapsulated DML against shadow balance storage. The body is documented as VALID in the 12.1.1 and 12.2.2 releases covered by ETRM.

Key Procedures and Functions

The ETRM metadata documents a single declared program unit in this package body: UPD. The procedure name, together with the package name PAY_SDB_UPD, indicates its role as the update entry point for shadow defined balance records. In keeping with the layered design evidenced by the dependency list, UPD is the write-side counterpart to the read-side routines exposed by PAY_SDB_SHD and the business validation routines in PAY_SDB_BUS. ETRM records no parameter list for this unit, and none should be assumed; callers must consult the package specification PAY_SDB_UPD in the target instance to determine the exact signature, including any identifiers for the balance, assignment, or effective date context it operates upon.

No additional procedures or functions are documented for this body. Because the object is a package body rather than a specification, the public callable surface is defined entirely by the corresponding package specification, while private helper units may exist internally without being enumerated in ETRM.

Tables Accessed

The only table documented as referenced through an APPS synonym is PAY_SHADOW_DEFINED_BALANCES. This is the shadow defined balance storage table, holding the precomputed balance values that the shadow balance subsystem exposes to payroll and reporting consumers. As an update package, PAY_SDB_UPD is the component responsible for modifying rows in this table, consistent with its naming and its position in the SDB stack. The package additionally references the SYS.STANDARD package and the HR_API and HR_UTILITY packages, which supply standard PL/SQL constructs and Oracle HRMS API and utility services used during processing.

Usage Notes

PAY_SDB_UPD is not referenced by any other database object according to ETRM, indicating that it is invoked as a top-level entry point rather than as a nested dependency of another stored package. Typical invocation paths are therefore direct calls from Payroll concurrent programs, from PL/SQL business logic that recalculates shadow balances, or from the shadow balance business layer when a recalculation must be written through to PAY_SHADOW_DEFINED_BALANCES. Because the package body is documented as valid and unreferenced, administrators should treat it as a stable internal API: custom code may call it, but Oracle does not guarantee the interface across releases. Any extension or direct DML bypassing this package risks leaving shadow balance data inconsistent with the balance definitions maintained by PAY_SDB_SHD and PAY_SDB_BUS.