Search Results pay_bal_classifications_pkg




Overview
Explore in AI Chat

Overview

The APPS.PAY_BAL_CLASSIFICATIONS_PKG package is a stored PL/SQL package in the Oracle E-Business Suite (EBS) Payroll (PAY) application. Its purpose is to provide the low-level Data Manipulation Language (DML) layer for the balance classification definitions used throughout Oracle Payroll. Balance classifications govern how payroll balances are grouped, categorized, and reported — for example, by assigning balances to classifications such as earnings, deductions, taxes, or employer contributions. These classifications are fundamental to balance feeds, balance dimensions, and the reporting structures that aggregate payroll results across a payroll run, a year-to-date period, or a legislative reporting category.

In EBS 12.1.1 and 12.2.2 the package is registered in the APPS schema and carries a VALID status, and is classified in the ETRM documentation as an "OTHER" API, meaning it is an internal, non-public interface rather than a formally published open API. It should therefore be treated as a repository-level utility that supports higher-level payroll configuration and generation logic, not as a supported extension point for customer-developed integrations.

Key Procedures and Functions

ETRM documents four procedures, each corresponding to a standard CRUD operation on the balance classification definition records:

  • INSERT_ROW — Creates a new balance classification row, populating the base table with the definition values supplied by the caller.
  • LOCK_ROW — Acquires a row-level lock on an existing balance classification record to support controlled, concurrency-safe modification during a transaction.
  • UPDATE_ROW — Modifies the attributes of an existing balance classification record.
  • DELETE_ROW — Removes a balance classification record from the definition tables.

These procedures are the mechanical operations by which balance classification data is maintained. No public function interfaces are documented, and parameter lists are not exposed in the metadata; the package is invoked internally by payroll configuration flows rather than by external callers.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • PAY_BALANCE_CLASSIFICATIONS — The primary definition table holding balance classification records.
  • PAY_BALANCE_CLASSIFICATIONS_S — The date-tracked (datetrack) shadow table used to record historical versions of balance classification definitions, supporting effective-dated payroll configuration.
  • PAY_ELEMENT_CLASSIFICATIONS — The element classification table, which relates element classifications to the balance classification structure so that element results can be aggregated correctly into payroll balances.

Together these tables form the configuration backbone that determines how payroll element results feed and group into balances, and how those balances are classified for reporting.

Usage Notes

Because PAY_BAL_CLASSIFICATIONS_PKG is an internal DML helper, it is typically invoked indirectly. ETRM records that the package depends only on SYS.STANDARD and is referenced by the PAY_ELEMENT_TEMPLATE_GEN package, indicating that element template generation calls into it when creating or maintaining classification definitions. The package may also be invoked from Oracle Forms-based payroll setup screens or from concurrent programs that load and maintain payroll configuration data.

Custom code should avoid calling these procedures directly. Direct DML against the underlying tables — particularly the datetracked _S table — risks violating datetrack integrity, bypassing validation, and corrupting balance classification definitions. Where customers must extend payroll configuration, supported APIs or the standard setup forms should be used in preference to this internal package.