Results for “hr_balances”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.HR_BALANCES package body encapsulates the core maintenance routines for Oracle EBS payroll balance configuration metadata. Within Oracle Human Resources and Oracle Payroll, a "balance" represents an accumulating quantity of pay or hours (for example, gross earnings, federal taxable wages, or vacation accrued) that is fed from one or more element input values through balance feeds. The HR_BALANCES package exists to create, modify, validate, and delete those balance feed definitions and the associated balance types on which the payroll run depends.

Because balance feeds determine how an element's processed input values roll up into accumulators used by reports, costing, and tax calculation, this package sits on a critical configuration path. Its documented API classification is "OTHER," indicating that it is an internal, non-public utility package rather than a formally published open interface. The body is VALID in both Oracle EBS 12.1.1 and 12.2.2 and, per the ETRM metadata, is referenced by 36 other database objects, reflecting its role as a shared low-level service for the payroll balance setup layer.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions in this package body:

• INS_BALANCE_FEED — Inserts a new balance feed record, establishing the relationship by which a source element input value contributes to a target balance.
• UPD_BALANCE_FEED — Updates an existing balance feed definition, such as when the source input value or additive/subtractive indicator changes.
• CHK_INS_BALANCE_FEED — Performs validation before a balance feed insert, enforcing the business rules that guard against duplicate or inconsistent feeds.
• CHK_DEL_BALANCE_FEED — Validates whether a balance feed may be safely deleted, protecting accumulators that are still in use.
• DEL_BALANCE_FEED — Deletes a balance feed record once validation has passed.
• DEL_BALANCE_TYPE_CASCADE — Deletes a balance type together with its dependent configuration, providing the cascade cleanup required to preserve referential integrity.
• CHK_INS_SUB_CLASS_RULES — Validates balance sub-classification rules prior to insertion, ensuring balances are correctly grouped for reporting and processing.
• DECODE_BALANCE — A helper function that decodes or resolves balance-related identifiers into their meaningful business representation.

No parameter signatures are asserted here; only the documented purpose of each routine is described.

Tables Accessed

The package reads and writes the principal Payroll balance configuration tables, accessed through APPS synonyms:

• PAY_BALANCE_FEEDS_F / PAY_BALANCE_FEEDS_S — the base and seed tables storing balance feed definitions, the primary target of the insert, update, and delete routines.
• PAY_BALANCE_TYPES / PAY_BALANCE_TYPES_TL — balance type definitions and their translated names, referenced when deleting types and resolving balance identity.
• PAY_DEFINED_BALANCES — the defined balance accumulators to which feeds are attached.
• PAY_ELEMENT_TYPES_F — element definitions that supply feed sources.
• PAY_INPUT_VALUES_F / PAY_INPUT_VALUES_F_TL — the element input values that act as the actual feed contributors.
• PAY_BALANCE_CLASSIFICATIONS and PAY_SUB_CLASSIFICATION_RULES_F — classification and sub-classification rules validated by CHK_INS_SUB_CLASS_RULES.
• HR_APPLICATION_OWNERSHIPS — used to confirm application-level ownership of configuration data.
• DUAL — standard single-row utility table.

The dependencies also list internal helpers (HR_UTILITY, HR_INPUT_VALUES, PAY_DEFINED_BALANCES_PKG, STANDARD), which supply shared validation and error-handling services.

Usage Notes

HR_BALANCES is an internal package and is not intended for direct invocation by customers or custom integrations. It is typically called behind the scenes by the Balance Feeds and Balance Types setup forms in Oracle Payroll, by concurrent processes that create or migrate balance configuration, and by the 36 dependent packages identified in the ETRM metadata. Because balance feed integrity directly affects payroll calculation, any custom code that manipulates balance configuration should reuse these routines rather than performing direct DML on PAY_BALANCE_FEEDS_F. As with all undocumented EBS internals, signatures may change between patch levels, so dependency on this package should be minimized.