Search Results manual_bal_feeds_exist

Overview

HR_BALANCE_FEEDS is an Oracle Application Object Library package owned by APPS in the Oracle E-Business Suite Human Resources (Payroll) module. Its stated purpose, taken directly from the package header, is to maintain balance feeds. It supplies functions and procedures that permit the safe creation of manual balance feeds, together with procedures that generate automatic balance feeds when configuration events occur — for example, when a balance classification is added or when a sub-classification rule is created. The package header (pybalfed.pkh, version 115.2, dated 15-Apr-2003) traces its origin to 01-Mar-1994.

The package is declared AUTHID CURRENT_USER, meaning all unqualified references to the PAY tables resolve against the invoking schema's privileges. In practice it is executed under APPS with synonyms to the underlying payroll tables. It is classified as an OTHER API and is referenced by eleven other packages, indicating its role as a shared internal service for payroll balance configuration rather than a public, standalone interface.

Key Procedures and Functions

The documented interface comprises twelve callable units. Grouped by role:

• BAL_CLASSIFICATIONS_EXIST — a boolean function that returns TRUE if a balance classification exists for the supplied balance type.
• MANUAL_BAL_FEEDS_EXIST — a boolean function returning TRUE if a manual balance feed exists.
• LOCK_BALANCE_TYPE — the routine associated with the search term "lock_balance_type". It acquires a lock on a balance type, serializing concurrent maintenance of feeds and classifications attached to that balance type so that parallel configuration or data-load processes cannot corrupt the feed definition.
• BAL_FEED_END_DATE and PAY_VALUE_NAME — supporting lookups that derive an end-dating value for a balance feed and resolve a pay value name respectively.
• INS_BF_BAL_CLASS / UPD_DEL_BF_BAL_CLASS — insert and the combined update/delete of balance classification feeds.
• INS_BF_PAY_VALUE — creates feed definitions driven by input values.
• INS_BF_SUB_CLASS_RULE / DEL_BF_SUB_CLASS_RULE — insert and delete of sub-classification rule feeds.
• DEL_BF_INPUT_VALUE — removes input-value feeds.
• BF_CHK_PROC_RUN_RESULTS — a diagnostic check over run results associated with balance feeds.

History entries show the p_mode parameter was added to INS_BF_BAL_CLASS (Bug 2430399) and to INS_BF_SUB_CLASS_RULE and INS_BF_PAY_VALUE (Bug 2888183) so that callers such as HR_LEGISLATION and HR_LEGISLATION_ELEMENTS do not raise an error inside INS_BAL_FEED when the feed already exists.

Tables Accessed

• PAY_BALANCE_FEEDS_F and PAY_BALANCE_FEEDS_S — the date-tracked base and secondary tables that hold the balance feed rows created, updated or deleted by this package.
• PAY_BALANCE_CLASSIFICATIONS, PAY_SUB_CLASSIFICATION_RULES_F — classification and sub-classification definitions used to derive automatic feeds.
• PAY_BALANCE_TYPES — the balance type locked and validated via LOCK_BALANCE_TYPE and BAL_CLASSIFICATIONS_EXIST.
• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_INPUT_VALUES_F — element and input value metadata used to resolve pay values and element-driven feeds.
• PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS — run result and action data inspected during validation and procedural checks.
• DUAL — used for simple expression evaluation.

Usage Notes

HR_BALANCE_FEEDS is not intended for direct end-user invocation. It is called by other PL/SQL packages (eleven documented referrers) and by payroll configuration logic during patch application and legislation setup, particularly when balance feeds must be regenerated after classifications or sub-classification rules change. The recent p_mode additions exist explicitly to support legislative startup. Custom code should invoke these routines only with the standard p_mode convention and should expect the LOCK_BALANCE_TYPE serialization pattern, since the package assumes a single writer per balance type at any moment.