Search Results pay_sdb_del




Overview
Explore in AI Chat

Overview

PAY_SDB_DEL is a PL/SQL package in the APPS schema of Oracle E-Business Suite, associated with the Oracle Payroll module (the PAY prefix). Its name and dependency graph indicate that it operates on "Shadow Defined Balance" data — specifically records held in the PAY_SHADOW_DEFINED_BALANCES table. Shadow defined balances are the payroll engine's staging or snapshot copies of defined balance results, used during balance processing, retroactive recalculation, and purge or reorganization routines. The package exists to remove (delete) rows from this shadow balance store, returning the underlying structure to a clean state so that subsequent balance runs are not corrupted by stale results.

The object is classified in the ETRM as API classification OTHER, meaning it is an internal utility rather than a public, supported application programming interface. It is not intended for direct invocation by external integrations. Its status is VALID in the documented environments (12.1.1 and 12.2.2), and its only declared dependency outside the SYS.STANDARD built-in package is APPS.PAY_SDB_SHD. This dependency shows that PAY_SDB_DEL is part of a loosely coupled pair of packages built around shadow balance handling, where PAY_SDB_SHD likely supplies shared shadow-operations logic consumed by the deletion routines.

Key Procedures and Functions

ETRM documents a single callable program unit within this package:

  • DEL — The deletion routine. It carries out the package's core purpose: removal of entries from the shadow defined balances store. The name is deliberately terse because the procedure is an internal helper rather than a user-facing API. No parameter list is documented, and none is inferred here; in practice the routine would be invoked by payroll balance-processing code that has already determined which shadow records have become obsolete, typically after a balance run has been committed or after a failed run has been abandoned.

No further procedures or functions are declared in the documented metadata, so the package should be regarded as a narrow, single-purpose utility rather than a general balance administration toolkit.

Tables Accessed

The metadata records one table reachable through APPS synonyms:

  • PAY_SHADOW_DEFINED_BALANCES — The shadow copy of defined balance results. PAY_SDB_DEL writes to this table by deleting rows. Deletion here matters because the payroll balance engine reads shadow balances when reconstructing results after retroactive changes; obsolete rows would cause incorrect balance values to be carried forward.

Because the package references PAY_SDB_SHD, it may also interact indirectly with tables owned or used by that package, but only PAY_SHADOW_DEFINED_BALANCES is explicitly documented. No inserts or updates are recorded; the documented behaviour is purely deletion.

Usage Notes

PAY_SDB_DEL is an internal payroll engine component and is not exposed through a standard Oracle Payroll form or concurrent program. It is invoked from within the payroll balance processing stack, typically after a defined balance run completes or during cleanup of an aborted run. The package is referenced by no other documented packages, confirming that its callers are embedded in the payroll processing code rather than in a broad API surface.

Customers and implementers should not call PAY_SDB_DEL directly from custom PL/SQL, concurrent programs, or forms. Direct deletion from PAY_SHADOW_DEFINED_BALANCES bypasses the sequencing and validation that the payroll engine expects, and can leave balances inconsistent. Where cleanup is genuinely required, the supported route is to run the appropriate Oracle Payroll balance processes, which manage shadow data internally. Any diagnostic investigation of this package should begin with the dependent package PAY_SDB_SHD and the standard payroll balance diagnostics for the release in use.