Search Results pay_sbt_bus




Overview
Explore in AI Chat

Overview

APPS.PAY_SBT_SHD is a PL/SQL package in the Oracle E-Business Suite Payroll (PAY) module. It supports the Shadow Balance feature, which maintains parallel or "shadow" balances for payroll elements so that changes can be modeled, validated, or staged without immediately affecting live payroll balances. Shadow balance types allow implementers and administrators to test element configurations, cost allocations, or recalculation scenarios before committing them, and to reconcile differences between a primary balance and its shadow counterpart.

In the context of EBS 12.1.1 and 12.2.2, the package acts as a service-layer component that sits behind the business logic (PAY_SBT_BUS) and the DML layer (PAY_SBT_INS, PAY_SBT_UPD, PAY_SBT_DEL) for shadow balance type records. It is classified as OTHER (non-public API), meaning Oracle does not promote it as a supported customer-facing interface. Its status is VALID in the documented release, confirming it is compiled and operational.

Key Procedures and Functions

  • CONSTRAINT_ERROR — Handles or reports constraint violations encountered while processing shadow balance type data. It centralizes error detection so that integrity violations are surfaced consistently to the calling business layer.
  • API_UPDATING — Determines or signals whether an update is currently being performed through a supported API path, allowing the package to guard against unsupported direct modifications of shadow balance records.
  • LCK — Provides record-level locking for shadow balance type rows, preventing concurrent modification conflicts during multi-user payroll configuration activity.
  • CONVERT_ARGS — Transforms or normalizes incoming arguments before they are passed to the underlying operations, reconciling caller-supplied values with the expected internal representation.

These four documented routines represent a support/utility role rather than a broad functional API. All are oriented toward safe, consistent manipulation of the shadow balance type entity.

Tables Accessed

  • PAY_SHADOW_BALANCE_TYPES — The core table storing shadow balance type definitions. This is the primary data object the package processes, and the reason the package exists.
  • ALL_CONSTRAINTS — A data dictionary view used to inspect constraint definitions, supporting the constraint validation and error-reporting logic implemented in CONSTRAINT_ERROR.

Usage Notes

PAY_SBT_SHD is an internal dependency, not a standalone entry point. It is invoked indirectly through the shadow balance type transaction stack: PAY_ELEMENT_TEMPLATE_GEN, PAY_ELEMENT_TEMPLATE_UTIL, PAY_SBT_BUS, PAY_SBT_INS, PAY_SBT_UPD, and PAY_SBT_DEL all reference it. In practice, a user reaches this code by configuring allocation or balance-type information through the Payroll element template and shadow balance maintenance forms, or through concurrent programs that generate element templates.

Custom development should not call this package directly. The correct integration path is through PAY_SBT_BUS or the module's supported APIs; invoking PAY_SBT_SHD bypasses the validation and locking conventions enforced by the business layer. Because it references ALL_CONSTRAINTS and the STANDARD package, deployments that alter constraint structures or schema synonyms can affect its compilation. Dependency recompilation should be performed after any change to PAY_SHADOW_BALANCE_TYPES or to the six referencing packages.