Search Results ins_bf_pay_value

Overview

HR_BALANCE_FEEDS is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the API/OTHER category. Its declared purpose is to maintain balance feeds within Oracle Payroll. Balance feeds are the associative links that join an element's input value (or a balance classification) to a payroll balance, determining which element results accumulate into which balance. The package provides functions and procedures that permit the safe creation of manual balance feeds, along with routines that generate automatic balance feeds when the underlying payroll configuration changes, such as when a new balance classification is added or a sub-classification rule is created.

The package is declared AUTHID CURRENT_USER and dates back to Release 40.0, with a documented header revision of 115.2 (April 2003). Its central design concern is idempotency: repeated calls must not raise errors when a balance feed already exists.

Key Procedures and Functions

• BAL_CLASSIFICATIONS_EXIST — Returns a Boolean indicating whether a balance classification exists for a given balance type.
• MANUAL_BAL_FEEDS_EXIST — Returns a Boolean indicating whether a manual balance feed exists.
• LOCK_BALANCE_TYPE — Acquires a lock on the balance type, protecting feed maintenance operations from concurrent modification.
• BAL_FEED_END_DATE — Ends the effective date of an existing balance feed rather than physically removing it.
• PAY_VALUE_NAME — Returns the name associated with a pay value, used by calling code that works with input values by identifier rather than name.
• INS_BF_BAL_CLASS — Creates a balance feed derived from a balance classification. Revision 115.1 added a p_mode parameter so the procedure can be invoked from hr_legislation without raising an error in ins_bal_feed when the feed already exists.
• UPD_DEL_BF_BAL_CLASS — Updates or deletes a balance-classification balance feed.
• INS_BF_PAY_VALUE — Creates a balance feed linking a pay value (element input value) to a balance. Revision 115.2 (Bug 2888183) added a p_mode parameter, permitting invocation from hr_legislation_elements without raising an error when the feed already exists. This is the routine most closely associated with the search term ins_bf_pay_value.
• INS_BF_SUB_CLASS_RULE — Creates a balance feed driven by a sub-classification rule; also received the p_mode parameter in revision 115.2.
• DEL_BF_INPUT_VALUE — Deletes a balance feed associated with an input value.
• DEL_BF_SUB_CLASS_RULE — Deletes a balance feed associated with a sub-classification rule.
• BF_CHK_PROC_RUN_RESULTS — Validates or checks payroll run results in the context of balance feed processing.

Tables Accessed

The package reads and writes the core payroll balance model tables via APPS synonyms. PAY_BALANCE_FEEDS_F and PAY_BALANCE_FEEDS_S hold the dated base and translation records for balance feeds. PAY_BALANCE_CLASSIFICATIONS, PAY_BALANCE_TYPES, PAY_SUB_CLASSIFICATION_RULES_F, and PAY_ELEMENT_CLASSIFICATIONS supply classification and rule definitions. PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F provide element and input value definitions, while PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES supply the processed results that feeds ultimately accumulate. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS support the run-result checking routine. DUAL is used for simple single-row queries.

Usage Notes

HR_BALANCE_FEEDS is an internal API referenced by eleven other packages, including HR_LEGISLATION and HR_LEGISLATION_ELEMENTS, which call INS_BF_BAL_CLASS, INS_BF_SUB_CLASS_RULE, and INS_BF_PAY_VALUE during legislative data installation and upgrade. The p_mode parameters exist specifically to make those callers tolerant of pre-existing feeds. Custom code should invoke the INS_BF_* routines rather than inserting directly into PAY_BALANCE_FEEDS_F, because the package manages surrogate keys, effective dates, and locking consistently. Direct inserts risk duplicate or orphaned feed rows that corrupt balance calculation in payroll runs.