Search Results pay_balance_feeds_s

Overview

HR_BALANCE_FEEDS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It supports the Oracle HRMS / Oracle Payroll balance feed framework, which controls how individual payroll run results, element input values, and assignment-level processed values are aggregated into balance types. A "balance feed" defines the contribution of a specific element, input value, or run result to a target balance, including the classification and sub-classification rules that determine where that contribution is accumulated. The package encapsulates the validation, locking, and maintenance logic that underpins the Balance Feeds and Balance Classifications setup and processing windows. Its status is VALID in the documented environment, and it is referenced by eleven other database objects, indicating it is a shared utility within the payroll balance configuration layer rather than an entry-point only API. The package is classified as OTHER and is not a public, supported API in the same sense as the HRMS Business Process APIs; it functions primarily as a supporting internal package invoked by the forms and concurrent logic that maintain balance feed definitions.

Key Procedures and Functions

The documented interface contains twelve procedures and functions, whose names indicate their responsibilities:

• BAL_CLASSIFICATIONS_EXIST — checks whether balance classification records exist for a given balance type or feed context, used as a prerequisite validation.
• MANUAL_BAL_FEEDS_EXIST — determines whether manually defined balance feeds exist, typically to prevent conflicting configuration or to gate a setup step.
• LOCK_BALANCE_TYPE — acquires a lock on a balance type record so that concurrent maintenance of its feeds does not corrupt the definition.
• BAL_FEED_END_DATE — resolves or returns the effective end date applicable to a balance feed, supporting date-tracked definitions.
• PAY_VALUE_NAME — returns the display name associated with a payroll value or input value, used in validation messages and lookup resolution.
• INS_BF_BAL_CLASS — inserts balance classification detail rows associated with a balance feed.
• UPD_DEL_BF_BAL_CLASS — updates or deletes existing balance classification rows when a feed definition changes.
• INS_BF_PAY_VALUE — inserts the payroll value (input value or run result) participation record for a balance feed.
• INS_BF_SUB_CLASS_RULE — inserts sub-classification rules that govern how feeds are grouped into balance classifications.
• DEL_BF_INPUT_VALUE — deletes the input value association for a balance feed.
• DEL_BF_SUB_CLASS_RULE — deletes sub-classification rules previously defined for a feed.
• BF_CHK_PROC_RUN_RESULTS — validates processed run results against the balance feed definition, typically before a feed is confirmed or before payroll processing accepts the configuration.

Parameter lists are not documented and are deliberately omitted here.

Tables Accessed

The package reads and writes the core balance feed and classification tables, all referenced through APPS synonyms. PAY_BALANCE_FEEDS_F and PAY_BALANCE_FEEDS_S hold the date-tracked and translated feed definitions respectively. PAY_BALANCE_TYPES and PAY_BALANCE_CLASSIFICATIONS provide the target balance and grouping definitions. PAY_SUB_CLASSIFICATION_RULES_F stores the sub-classification rules attached to feeds. PAY_INPUT_VALUES_F and PAY_ELEMENT_TYPES_F supply the element and input value identity behind each feed. PAY_ELEMENT_CLASSIFICATIONS is used to resolve element classification context. PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES are consulted by BF_CHK_PROC_RUN_RESULTS to verify processed values. PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, and PAY_ACTION_PARAMETERS provide payroll processing context. HR_LOOKUPS is read for lookup validation, HR_UTILITY for shared HR utilities, and PER_BUSINESS_GROUPS_PERF for business group resolution. DUAL is used for trivial select expressions.

Usage Notes

HR_BALANCE_FEEDS is normally invoked indirectly. The balance feed setup and balance classification forms in Oracle Payroll call these routines when a user creates, updates, or deletes a feed, its classifications, its input values, or its sub-classification rules. Validation procedures such as BAL_CLASSIFICATIONS_EXIST, MANUAL_BAL_FEEDS_EXIST, and BF_CHK_PROC_RUN_RESULTS are used to enforce configuration integrity, while LOCK_BALANCE_TYPE protects concurrent edits by multiple users. Because eleven other packages reference this object, custom code should avoid depending on it directly; supported extension should be built through documented HRMS APIs and, where necessary, through the underlying base tables with careful attention to date-tracked columns. When troubleshooting balance feed behaviour in 12.1.1 or 12.2.2, this package is a primary diagnostic target for errors raised during feed maintenance or payroll action validation.