Search Results pqh_budget_analysis_pkg




Overview
Explore in AI Chat

Overview

The APPS.PQH_BUDGET_ANALYSIS_PKG package is a server-side PL/SQL component within the Oracle E-Business Suite Human Resources (HR) and Public Sector/Position Budgeting modules. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is typical of packages that rely on APPS synonyms and session-level context. The package provides the analytical engine behind position budgeting and budget-versus-actual reporting. Its core responsibility is to consolidate budgeted amounts, actual expenditures, and commitment (encumbrance) figures across a variety of budgetable "entities" — positions, jobs, grades, and organizations — and to surface that comparison through concurrent-program-style procedures that accept standard concurrent arguments (errbuf, retcode) alongside business filters such as business group, effective date, and date range.

Key Procedures and Functions

Nine documented procedures comprise the package. The GET_ENTITY procedure is the one most relevant to the user's search; it accepts a concurrent request context alongside parameters identifying an entity code, unit of measure, effective date, start and end dates, business group, start organization, and organization structure. It resolves the requested budgetable entity (for example a position, job, grade, or organization) into a comparable form so the analysis procedures can evaluate budgeted versus actual amounts against it. The SALARY_ANALYSIS procedure performs salary-specific budget analysis, and GET_POS_ACTUAL_COMMIT_AMT returns the actual, commitment, and combined total amounts for a given position over a specified period at a given effective date.

The remaining analysis procedures — POSITION_ANALYSIS, JOB_ANALYSIS, GRADE_ANALYSIS, and ORGANIZATION_ANALYSIS — apply the same analytical pattern at successively different levels of the budgeting hierarchy, each driven by batch name, effective date, date range, unit of measure, and business group. Supporting procedures include FYI_NOTIFICATION, which manages notification behavior associated with budget analysis output, and GET_BUDGET_CURRENCY, which resolves the currency in which budget figures should be reported. All procedures use the standard concurrent-program interface, confirming the package is designed for submission as a concurrent program or for invocation from custom batch code.

Tables Accessed

The package reads and writes against a defined set of APPS-synonymed tables. Budget data resides in PQH_BUDGETS, PQH_BUDGET_DETAILS, PQH_BUDGET_ELEMENTS, PQH_BUDGET_PERIODS, PQH_BUDGET_SETS, and PQH_BDGT_CMMTMNT_ELMNTS (the commitment-element table that supplies encumbrance figures). HR setup and definitional data come from HR_ALL_ORGANIZATION_UNITS, HR_ALL_POSITIONS_F, PER_GRADES_TL, PER_JOBS_TL, PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS, which together allow the package to traverse organizational hierarchies and resolve valid position, job, and grade entries at the effective date. PER_TIME_PERIODS supplies calendar context for date-range analysis, and FND_USER is referenced for user identity, likely in support of the notification procedure.

Usage Notes

Because the documented procedures expose errbuf and retcode, PQH_BUDGET_ANALYSIS_PKG is intended primarily for execution as a concurrent program registered against the HR budget analysis business flow, or through the associated forms-based budget analysis UI. It is also referenced by one other package, indicating a callable dependency from higher-level budget automation. Custom integrations that need position-level actual-versus-commitment figures should call GET_POS_ACTUAL_COMMIT_AMT directly, while GET_ENTITY is best treated as the entry point for generic entity resolution prior to invoking the relevant analysis procedure. Callers should always evaluate retcode and log errbuf to honor the standard concurrent error protocol.