Search Results pay_sbt_ins




Overview
Explore in AI Chat

Overview

PAY_SBT_INS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Shadow Balance Types feature within Oracle Payroll. Shadow balance types allow implementers to define derived or mirrored balances that are maintained alongside the standard payroll balance framework without being independently fed, enabling reporting, retroactive analysis, and reconciliation of payroll results. In ETRM 12.2.2 the object is classified as an "OTHER" API, indicating that it is an internal component rather than a publicly certified extension point. The package status is recorded as VALID, and its principal documented dependency is on APPS.PAY_SBT_SHD, a package that carries the core shadow balance type logic. PAY_SBT_INS therefore acts as the insert-oriented counterpart to that shared logic, responsible for seeding rows associated with shadow balance type definitions.

Key Procedures and Functions

The ETRM metadata records a single documented program unit, INS, within the package specification. Its name and placement — paired with the dependency on PAY_SBT_SHD — indicate that it performs the insertion of shadow balance type records, delegating validation and derivation rules to the shared PAY_SBT_SHD package. No parameter lists are documented in ETRM; callers should not rely on an inferred interface and must obtain exact signatures from the installed source in the target environment. The procedure is not classified as a public API, so its behaviour should be treated as implementation-dependent and subject to change between patch levels.

Tables Accessed

Two application tables are documented as referenced through APPS synonyms: PAY_SHADOW_BALANCE_TYPES and PAY_SHADOW_BALANCE_TYPES_S. PAY_SHADOW_BALANCE_TYPES holds the definition rows for each shadow balance type, including the relationship between the source balance and its shadowed counterpart. PAY_SHADOW_BALANCE_TYPES_S is the corresponding translated or secondary table in the Oracle Payroll balance type model. The package writes and reads these tables to create and verify shadow balance type definitions; because the tables are accessed via APPS synonyms, the user of the package must operate in a context where those synonyms resolve, as is customary for APPS-owned payroll utilities.

Usage Notes

PAY_SBT_INS is not intended for direct invocation by customers. It is referenced by three other packages — PAY_AE_ELEMENT_TEMPLATE_PKG, PAY_CREATE_ELEMNT_TMPLT_RECORD, and PAY_ELEMENT_TEMPLATE_UTIL — which places it firmly within the element template and balance setup flow. When an element template that carries shadow balance requirements is created or copied, these higher-level packages call into PAY_SBT_INS to materialise the necessary shadow balance type rows. The package is consequently invoked from element template processing rather than from a standalone form or concurrent program, and it is also listed as self-referencing, consistent with internal recursion or helper invocation. Custom code should not call PAY_SBT_INS; integrators requiring shadow balance type creation are advised to drive the documented element template APIs instead, and to verify the actual INS signature against the deployed package before attempting any dependency. Because the object is an unpromoted internal unit, its behaviour, validation rules, and error handling should be re-verified after each payroll patch or upgrade between 12.1.1 and 12.2.2. Do not call it directly. It is an internal helper. Use supported element template APIs and treat this package as read-only reference material when diagnosing setup issues.