Results for “g_budget_version_id”

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

Overview

PA_BUDGETARY_CONTROLS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the business logic that governs budgetary control at the project and task level within Oracle Project Costing and Oracle Project Budgeting. Budgetary control determines whether a project, task, or resource is permitted to incur additional commitments, actual costs, or budget entries once a defined funding or budget threshold has been reached. The package provides the programmatic interface used internally to configure budgetary control levels, to verify whether control is enabled for a given project or task, to create and reset control records, and to retrieve the current budget status during transaction validation.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Their names and purposes are consistent with the budgetary control lifecycle:

• INSERT_ROWS — Inserts one or more budgetary control definition rows into the underlying control tables, typically during setup or mass configuration of control levels.
• CREATE_BC_LEVELS — Creates the budgetary control hierarchy levels that determine the granularity (project, task, resource, or resource group) at which funds are monitored.
• BUD_CTRL_CREATE — Establishes a new budgetary control record for a project or task, linking it to the applicable budget type and version.
• BUDG_CONTROL_RESET — Resets existing budgetary control settings, allowing control parameters to be reinitialized when budgets or funding structures change.
• BUDGET_CTRL_EXISTS — Returns whether a budgetary control record already exists for a given entity, preventing duplicate configuration.
• BUDG_CONTROL_ENABLED — Confirms whether budgetary control is currently enabled for a project, task, or resource, which governs whether transactions are validated against available funds.
• GET_BUDGET_STATUS — Retrieves the current status of a budget relative to its control threshold, supporting downstream decision logic during transaction processing.

Tables Accessed

The package reads and writes several core Project Accounting tables through APPS synonyms. PA_BUDGETARY_CONTROLS and PA_BUDGETARY_CONTROLS_S store the budgetary control definitions and their translated or secondary records, while PA_BUDGETARY_CONTROL_OPTIONS holds configuration options that influence how control is applied. PA_BUDGET_TYPES, PA_BUDGET_VERSIONS, and PA_BUDGET_ENTRY_METHODS define the budget structure and entry rules against which control is evaluated. PA_PROJECTS_ALL and PA_TASKS supply the project and task context. PA_RESOURCE_LISTS_ALL_BG and PA_RESOURCE_LIST_MEMBERS provide resource-list and resource-group information used when control is applied at the resource level. DUAL is referenced for simple lookups and existence checks.

Usage Notes

PA_BUDGETARY_CONTROLS_PKG is an internal, non-public API classified as OTHER in the ETRM metadata. It is not intended as a documented extension point for customer customization; direct invocation should be limited to Oracle-delivered code and carefully controlled custom extensions. The package is referenced by PA_BUDGET_FUND_PKG and by several financial control results views, including PA_PRJ_FC_RESULTS_V, PA_PROJECT_BAL_V, PA_RES_FC_RESULTS_V, PA_RES_GRP_FC_RESULTS_V, PA_TASK_FC_RESULTS_V, and PA_TOP_TASK_FC_RESULTS_V, which surface budgetary control outcomes to inquiry and reporting screens. In practice, the package is invoked during project and task setup, when budgetary control is enabled or disabled, when budgets are submitted or adjusted, and during transaction validation in Oracle Project Costing. Because its procedures rely on the underlying PA_BUDGETARY_CONTROLS tables being properly configured, any custom code that calls these routines should first verify control existence and enablement using BUDGET_CTRL_EXISTS and BUDG_CONTROL_ENABLED.