Search Results pay_shadow_balance_types_s

Overview

PAY_SBT_INS is an internal Oracle E-Business Suite package body owned by the APPS schema that supports the maintenance of Shadow Balance Types within Oracle Payroll. Shadow Balance Types define the stored definitions against which payroll balance results are held, and the PAY_SHADOW_BALANCE_TYPES table and its _S (security/sequence) companion are the central persistence objects for these definitions. The package is classified as an OTHER API in the ETRM repository, meaning it is not published as an open, externally supported interface but functions as a module implementing the business logic required to create (insert) shadow balance type records consistently and with the appropriate validation. Its responsibilities align with the broader SBT family of packages, notably PAY_SBT_BUS (business logic), PAY_SBT_SHD (shadow record handling), and PAY_SBT_INS itself.

The package is dependent on HR_API and HR_UTILITY for common HRMS utilities, and on the STANDARD package for SQL cursor and type definitions. It does not appear as a referenced object in the dependency graph of other database objects, confirming its role as a leaf-level implementation module invoked by higher-level SBT packages and by the forms that drive shadow balance type setup.

Key Procedures and Functions

The ETRM metadata records a single documented procedure, INS. This procedure is the insert routine for shadow balance type definitions. It encapsulates the logic required to write a new shadow balance type row, including any dependent validation, key derivation, and coordination with the associated business package PAY_SBT_BUS. It is deliberately scoped to the creation path rather than update or delete, which are handled elsewhere in the SBT package family. No public parameter list is documented for this procedure, reflecting its internal (OTHER-classified) nature; callers are expected to be EBS-internal code rather than customer extensions.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

• PAY_SHADOW_BALANCE_TYPES — the primary definition table for shadow balance types. The INS procedure writes rows into this table as part of the creation of a new shadow balance type.
• PAY_SHADOW_BALANCE_TYPES_S — the companion table used for sequence-number and/or security-related attributes. The INS procedure also writes to this table to keep the shadow balance type definition and its sequence identity in step. The user's search for pay_shadow_balance_types_s directly reflects this dependency.

The package also references the DUAL pseudo-table through the SYS schema for simple inline expressions, consistent with standard PL/SQL implementation practice.

Usage Notes

PAY_SBT_INS is an internal implementation package. It is not intended to be called directly by customers or by custom code, and because no object references it in the dependency graph, its callers are the SBT family of packages and the Oracle Payroll setup forms that manage shadow balance types. The documented call path is through PAY_SBT_BUS, which applies the business rules and delegates insertion to PAY_SBT_INS. In Oracle EBS 12.1.1 and 12.2.2, the package is invoked during shadow balance type creation, either through the relevant Payroll setup form or through internal processing that establishes balance definitions. Because the API classification is OTHER, any direct invocation outside the supported SBT call path is unsupported; customizations should use the supported business-layer APIs or the setup forms instead of calling INS directly. The package is marked VALID in the ETRM repository, confirming it is compiled and available in the runtime environment.