Results for “initialize_balances”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PQP_VEHICLE_MILEAGE is a PL/SQL package body in Oracle E-Business Suite that supports vehicle mileage and car benefit processing within the Payroll (Payroll/PQP) product family. The header comment, referencing file pqbladwr.pkb (version 115.5, dated 2003/06/27), indicates the package is a legacy component that predates later 12.x runtimes while remaining valid in EBS 12.1.1 and 12.2.2. Its business purpose centers on generating and reconciling balance entries for elements that represent company cars and mileage reimbursement, so that payroll results for those elements can be initialized, validated, and linked correctly to employee assignments.

The package is classified as an "OTHER" API, meaning it is not a published public interface but rather an internal utility invoked by higher-level payroll processes or concurrent requests. The unit logic operates against a business group and typically processes a defined reporting window (the code excerpt cites 6-Apr-2003 through 5-Apr-2004), demonstrating that the package is time-window driven and intended to calculate or seed balances from historical payroll run results.

Key Procedures and Functions

• INITIALIZE_BALANCES — The sole documented program unit. It is a public procedure in the package specification that accepts a business group identifier and returns the standard concurrent-program OUT parameters errbuf and retcode. Its purpose is to identify vehicle and mileage elements that have associated run result entries, verify whether each element has a corresponding element link, and initialize balance values accordingly. Internally it declares cursors including c_ele_exst, which scans pay_element_types_f joined to pay_element_type_extra_info for element types carrying the PQP_VEHICLE_MILEAGE_INFO information category and ownership codes such as C, P, PM, PP, CM, and CP; and c_get_link, which detects elements lacking a link definition. A diagnostic cursor (c_err_log) produces descriptive error text, for example where a location requires linkage to an assignment, using per_all_assignments_f.

No other procedures or functions are documented in the ETRM metadata for this package.

Tables Accessed

• PAY_ELEMENT_TYPES_F — Identifies the car and mileage element types for the business group.
• PAY_ELEMENT_TYPE_EXTRA_INFO — Supplies ownership classification through EEI_INFORMATION1 and confirms the PQP_VEHICLE_MILEAGE_INFO category.
• PAY_RUN_RESULTS — Confirms that the candidate element has actual payroll run results in the target window.
• PAY_ASSIGNMENT_ACTIONS — Links run results to assignment-level payroll processing instances.
• PAY_PAYROLL_ACTIONS — Provides the effective date used to filter the processing window.
• PAY_ELEMENT_LINKS_F — Determines whether an element is already linked for the business group.
• PAY_US_RPT_TOTALS — Referenced for aggregated reporting totals related to the initialization.
• PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — Used for assignment and person context in validation and error reporting.

Usage Notes

The package is normally invoked in the context of US payroll year-end or benefit reconciliation. Because INITIALIZE_BALANCES exposes concurrent-program style parameters, it is typically called from a concurrent program or from custom wrapper code rather than directly from a form. It is not referenced by any other documented package, so callers must be aware that the responsibility for chaining and error handling lies with the invoking process. Any use should pass a valid business group and observe the returned errbuf/retcode values before proceeding to downstream balance processing.