Search Results validate_unit_of_measure

Overview

The APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG package body provides the calculation and retrieval engine for budget actuals and commitments within the Oracle E-Business Suite Public Sector / Human Resources budgeting framework. It supports the Oracle HRMS Budgeting functionality, which allows organizations to define position and organization budgets, track actual expenditures against those budgets, and report commitments (encumbrances) that have been recorded but not yet fully expended. The package is the computational core that aggregates payroll cost data, commitment transactions, and budget definition data into a form that budgeting forms and reports can present to end users.

The package follows a consistent internal convention documented in the source header: validation and internal helper functions return 0 when a validation succeeds and -1 when an error is encountered. This allows calling code to test results consistently without exception handling. The package header comment also identifies the package with a global constant g_package set to 'pqh_bdgt_actual_cmmtmnt_pkg.', which is used for error message formatting.

Key Procedures and Functions

• GET_FACTOR — Computes a proportional factor between two date ranges. When the source and target ranges are identical, it returns 1; otherwise it returns the ratio of the target range length to the source range length, used for prorating budget amounts across periods.
• GET_LAST_PAYROLL_DT — Returns the last payroll run date associated with an assignment. The original implementation joined PER_TIME_PERIODS, PAY_PAYROLL_ACTIONS, and PER_ALL_ASSIGNMENTS_F; the revised cursor uses the latest sequenced payroll action performed on the assignment, providing more accurate results.
• GET_BUDGET_ACTUALS — Retrieves actual expenditure amounts recorded against a budget for a given period or set of criteria.
• GET_BUDGET_COMMITMENT — Retrieves committed (encumbered) amounts associated with a budget.
• GET_POS_ACTUAL_AND_CMMTMNT — Returns combined actual and commitment figures at the position level.
• GET_ENT_ACTUAL_AND_CMMTMNT — Returns combined actual and commitment figures at the entity or organization level.
• GET_ACTUAL_AND_CMMTMNT — General-purpose function combining actual and commitment values.
• GET_POS_MONEY_AMOUNTS — Derives monetary amounts associated with a position, typically from element and input value definitions.
• GET_POS_MONEY_TOTAL9 — Returns a monetary total for a position, indexed by a value set or dimension (denoted by the trailing "9").
• GET_ASSIGNMENT_ACTUALS — Returns actual cost amounts recorded for a specific assignment.
• GET_ASSIGNMENT_COMMITMENT — Returns commitment amounts recorded for a specific assignment.
• GET_BG_LEGISLATION_CODE — Retrieves the legislation code associated with a budget group, used to drive country-specific budget logic.

Tables Accessed

The package reads from the core budgeting tables PQH_BUDGETS, PQH_BUDGET_DETAILS, and PQH_BUDGET_VERSIONS, which define budget headers, line details, and version history. Position and organization context is drawn from HR_ALL_POSITIONS_F, HR_ALL_ORGANIZATION_UNITS, and HR_ORGANIZATION_INFORMATION. Payroll cost and commitment data is sourced from PAY_COSTS, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_ACTION_CLASSIFICATIONS, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F. These joins allow the package to translate raw payroll run results into budget-actual figures.

Usage Notes

The package is invoked by four other PL/SQL packages within the EBS schema and is typically called from the HRMS Budgeting forms and concurrent programs that display budget versus actual and commitment reporting. Because the package references payroll actions, it should be called after payroll runs have been costed and processed for the relevant period to ensure accurate actuals. Customizations that call this package should observe the 0/-1 return convention for validation functions and be aware that the assignment-level routines depend on the latest sequenced payroll action. The user search term validate_unit_of_measure does not correspond to a documented procedure in this metadata; unit-of-measure validation is not among the documented entries for this package, and callers seeking that validation should reference the appropriate budgeting validation API rather than this cost-aggregation package.