Search Results get_ren_balance

Overview

HR_PRE_PAY is a PL/SQL package owned by the APPS schema that supports the pre-payments processing path within the Oracle E-Business Suite Payroll (Pay) application. The package header identifies it explicitly as the "Pre-Payments package (called from pro*C)," indicating that its primary consumer is an external Pro*C program that drives the Oracle Payroll prepayment and rollup logic rather than a user-facing form directly. Its declared purpose is to prepare and apply prepayments, resolve dynamic organization payment methods, evaluate rollup rules for assignment actions and payroll actions, and consolidate balances and transactional dates required during payroll run processing.

Under Oracle EBS 12.1.1 and 12.2.2, the package is classified as "OTHER" in the ETRM/API classification, meaning it is not a formally published public API and is subject to change between releases. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session. Package-level variables track legislation code, business group, and currency across procedure calls during a single payroll processing session.

Key Procedures and Functions

• PAY_COIN — Handles coin (cash rounding) calculations by applying a factor to a specified number of units.
• INITIALISE — Establishes the initial processing context for a given action ID, returning the action ID in an in-out parameter.
• INIT_OVERRIDE — Initializes override processing for an action, returning both the action ID and the override method.
• GET_REN_BALANCE — Retrieves the relevant balance identifier for a business group, returning the default balance ID.
• OVERRIDE_MULT_TAX_UNIT_PAYMENT — Determines whether multi-tax-unit payment processing is overridden for a business group.
• CLOSE_CURSORS — Releases open cursors held by the package session.
• SET_CASH_RULE — Returns a cash rule value derived from a payment type and segment; carries a pragma restrict_references for WNDS/WNPS purity.
• GET_DYNAMIC_ORG_METHOD — Resolves a dynamic organization payment method by evaluating a PL/SQL procedure name, assignment action, effective date, and organization method, returning the resolved organization method ID. This is the procedure most often sought when diagnosing dynamic payment method resolution during prepayment.
• DO_PREPAYMENT — Performs the prepayment itself, accepting the assignment action, effective date, multiple assignment flag, default balance ID, assignment ID, override method, and multi-gre payment indicator.
• GET_TRX_DATE — Returns a transaction date, accepting business group, payroll action, assignment action, payroll, consolidation set, organization payment method, effective date, date earned, override date, and prepayment ID, most with defaults.
• PROCESS_ASG_ROLLUP and PROCESS_PACT_ROLLUP — Handle rollup of assignment actions and payroll actions respectively.

Tables Accessed

The package reads and writes payroll and balance data through APPS synonyms, including PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INTERLOCKS, PAY_ALL_PAYROLLS_F, PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_INPUT_VALUES_F, PAY_COIN_ANAL_ELEMENTS and its _S variant, PAY_CONTRIBUTING_PAYMENTS, PAY_EXTERNAL_ACCOUNTS, and FND_CURRENCIES for currency resolution. These support balance determination, element entry evaluation, prepayment recording, and organization payment method resolution.

Usage Notes

HR_PRE_PAY is invoked primarily from Pro*C payroll processing programs, not directly by end users. It is referenced by one other package within the APPS schema. Because it is classified as OTHER and is not a published API, customizations should treat it as internal and subject to change across patches and upgrades. When troubleshooting dynamic organization payment method behavior, GET_DYNAMIC_ORG_METHOD is the relevant entry point; direct calls should be avoided in favor of supported payroll APIs.