Search Results pqp_ini_bal




Overview
Explore in AI Chat

Overview

PQP_INI_BAL is an Oracle EBS payroll package owned by the APPS schema and classified as an OTHER API. It is part of the Oracle Payroll product family (the PQP prefix), and its name denotes its role in initialising balance values. The package exists to seed, create, and resolve payroll balance amounts so that downstream payroll processing, balance feeds, and reporting operate on correct opening values. In EBS 12.1.1 and 12.2.2 the balance framework is central to every payroll run: balances accumulate run results, element entries, and assignment-level activity. PQP_INI_BAL provides the programmatic entry point for establishing those balances and for translating a balance request into the element entry records that the payroll engine consumes. The ETRM dependency listing confirms this object is both a dependency of itself and a referenced-by object for PQP_PQP_VEHICLE_MILEAGE, indicating it is called from at least one other payroll application package rather than being a purely standalone utility.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within the package body:

  • INITIALIZE_BALANCES — the primary driver that establishes or resets balance values for the processing context, preparing balances for use before subsequent payroll operations.
  • GET_BALANCE_VALUE — retrieves the current value of a defined balance, allowing callers to read accumulated amounts without duplicating balance lookup logic.
  • CREATE_ELEMENT_ENTRY — creates an element entry, the mechanism through which a balance adjustment or initialisation is written back into the payroll data model.
  • ROUTE_BALANCE_AMT — routes a balance amount to the appropriate target, directing the value to the correct element entry or processing path.
  • GET_ELEMENT_ID — resolves the surrogate element type identifier required by the other procedures, bridging a logical element reference to its PAY_ELEMENT_TYPES_F key.

No parameter lists are published in the ETRM extract; callers should obtain signatures from the package specification in the APPS schema before invoking these routines directly.

Tables Accessed

The package reads and writes through APPS synonyms across the core payroll and HR tables. Balance definition and value data are held in PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_FEEDS_F. The actual accumulated amounts and element-level detail come from PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, and PAY_ELEMENT_ENTRY_VALUES_F. Element configuration is resolved through PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPE_EXTRA_INFO, and PAY_INPUT_VALUES_F. Assignment and process context are supplied by PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, and HR_SOFT_CODING_KEYFLEX. Patch level awareness is supported by PAY_PATCH_STATUS and PAY_PATCH_STATUS_S, allowing behaviour to vary by applied patch. Collectively these tables confirm the package bridges balance definitions, element configuration, and actual run result values.

Usage Notes

PQP_INI_BAL is a low-level payroll API, not a user-facing screen. It is invoked from PL/SQL — typically from payroll batch processing, balance initialisation routines, or custom extensions that must seed balances before a run. The dependency metadata records that PQP_VEHICLE_MILEAGE references this package, demonstrating the standard pattern of a functional payroll package delegating balance creation and element entry logic to PQP_INI_BAL. In 12.1.1 and 12.2.2 the APPS synonym and VALID status confirm the package is compiled and available. Custom code should call these routines rather than inserting directly into the balance tables, since CREATE_ELEMENT_ENTRY and ROUTE_BALANCE_AMT enforce the relationships between element types, input values, and run results. Developers modifying or calling this package should verify the current patch status via PAY_PATCH_STATUS, as balance-related logic is frequently patched.