Search Results get_unit_desc

Overview

PQH_WKS_BUDGET is an Oracle Application Object Library (APPS) PL/SQL package within the Oracle E-Business Suite HRMS/Payroll family of objects. It belongs to the Public Sector/HR budgeting and worksheet infrastructure and is classified under the ETRM as an "OTHER" API (neither a fully public nor an internal-only API, but one that is intended for controlled use and is not formally exposed as a documented public interface). Its primary business function is to support the Budget Worksheet feature set: the calculation, aggregation, validation, and propagation of budget amounts across organizational units, grades, and position hierarchies used in budgeting and position control workflows.

In EBS 12.1.1 and 12.2.2 the package operates under the APPS schema and references other PQH (Public Sector Human Resources) packages and HR tables. It is not a standalone application; it is a supporting utility package invoked by higher-level budget and worksheet APIs. It depends on the STANDARD package supplied by SYS and is referenced by several PQH budget and worksheet components, indicating it sits in the middle of the budget processing call stack.

Key Procedures and Functions

The package exposes 39 documented procedures and functions. The main groupings are as follows. (Parameter lists are intentionally omitted; only documented purposes are described.)

• VALID_GRADE — validates whether a grade is valid for the budgeting context, typically against the PER_VALID_GRADES and PER_GRADES data.
• CAN_APPROVE / CAN_APPLY — return approval and application eligibility for budget or worksheet records, used by the approval workflow and apply logic.
• GET_ALL_UNIT_DESC, GET_UNIT_DESC, GET_UNIT_TYPE — retrieve descriptive and type information about budget units and worksheets.
• GET_ORG_HIER, GET_PARENT_VALUE — return organizational hierarchy and parent-value data, leveraging the PER_ORGANIZATION_STRUCTURES tables.
• GET_VALUE, LOOKUP_DESC — resolve values and lookup descriptions used throughout the budgeting logic.
• WKD_PROPAGATION_METHOD, DELEGATING_ORG — determine the worksheet propagation method and the delegating organization for a budgeting transaction.
• GET_BGT_UNIT_PRECISION, GET_WKS_UNIT_PRECISION, GET_WKD_UNIT_PRECISION — return the numeric precision for budget, worksheet, and worksheet-detail units respectively.
• GET_WKS_UNIT_AGGREGATE, GET_WKD_UNIT_AGGREGATE — compute aggregated unit amounts for worksheets and worksheet details.
• INSERT_BUDGETSET — creates a budget set record, an explicit write operation against the budget tables.
• WKS_DATE_VALIDATION — validates worksheet date ranges against the configured time periods.
• PROPAGATE_BOTTOM_UP — drives the bottom-up propagation of budget amounts through the unit hierarchy.

Tables Accessed

Access is performed through APPS synonyms. The documented tables include:

• PQH_BUDGETS, PQH_BUDGET_DETAILS — the core budget and budget-detail tables this package reads and writes (for example, via INSERT_BUDGETSET).
• PER_GRADES, PER_VALID_GRADES, PER_JOBS, PER_JOB_GROUPS — grade, grade-validity, job, and job-group reference data used for validation and lookup.
• PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_VERSIONS, HR_ALL_ORGANIZATION_UNITS — organizational hierarchy data used by GET_ORG_HIER and GET_PARENT_VALUE.
• PER_SHARED_TYPES, PER_TIME_PERIODS — shared lookup types and time-period definitions used for date validation and precision logic.
• FND_APPLICATION, FND_CURRENCIES, FND_PRODUCT_INSTALLATIONS, FND_USER — Application Object Library reference data for application context, currency, installation, and user information.

Usage Notes

PQH_WKS_BUDGET is not typically invoked directly by end users. It is called programmatically by the PQH budget and worksheet APIs, specifically PQH_BGT_BUS, PQH_BUDGET, PQH_PTX_UTL, PQH_WKS_ERROR_CHK, PQH_WORKSHEET_DETAILS_API, and the view PQH_TRANSACTIONS_V. Because it is documented as an "OTHER" API affecting budget data, any direct invocation from custom code should be treated cautiously: callers should rely on the higher-level public APIs where possible, and must account for the fact that the package depends on HRMS organization, grade, and time-period configuration being correctly set up. The presence of validation, aggregation, and propagation routines indicates it is designed to run within the budget worksheet approval and apply workflows rather than as a standalone concurrent program.