Results for “psb_budget_revisions_pvt”

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

Overview

PSB_BUDGET_REVISIONS_PVT is the private application programming interface for budget revision processing within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. In Oracle EBS 12.1.1 and 12.2.2, the PSB schema underpins the budgeting and funds-checking functionality used by public sector, higher education, and federal customers who require position-based and account-based budget control. This package body implements the core business logic that creates, modifies, and validates budget revisions against the General Ledger and against PSB budget structures.

The "PVT" classification indicates an internal API layer. The package is not intended as a published integration point; it is invoked by the PSB forms, concurrent programs, and by the companion public package PSB_BUDGET_REVISIONS_PUB. Its responsibilities span revision header creation, revision account and position line generation, funds availability checking, constraint application, and General Ledger balance retrieval. Because budget revisions frequently involve mass processing across many accounts or positions, the package also implements concurrency control and caching mechanisms to support high-volume batch execution.

Key Procedures and Functions

• CREATE_BUDGET_REVISION / CREATE_BASE_BUDGET_REVISION — Inserts the revision header record into PSB_BUDGET_REVISIONS and establishes the revision context used by subsequent line-level operations.
• CREATE_REVISION_ACCOUNTS / DELETE_REVISION_ACCOUNTS — Populate and remove account-level revision lines in PSB_BUDGET_REVISION_ACCOUNTS, drawing from the source budget structure specified on the revision.
• CREATE_REVISION_POSITIONS / DELETE_REVISION_POSITIONS — Build and delete position-level revision rows in PSB_BUDGET_REVISION_POSITIONS, applying position cost calculations where applicable.
• CREATE_MASS_REVISION_ENTRIES / MASS_BUDGET_REVISION_CP — Generate revision lines in bulk; the CP variant is the entry point for the mass budget revision concurrent program.
• BUDGET_REVISION_FUNDS_CHECK — Validates that a proposed revision passes funds-availability rules, typically by delegating to PSA_FUNDS_CHECKER_PKG.
• APPLY_CONSTRAINTS / APPLY_REVISION_ACCT_PARAMETERS — Enforce constraint sets and default account parameters onto revision lines prior to commit.
• FIND_ORIGINAL_BUDGET_BALANCE, GET_GL_BALANCE, GET_ROUNDED_AMOUNT — Retrieve baseline or GL balances and apply rounding rules for comparison and display.
• FIND_FTE, CALCULATE_POSITION_COST — Derive full-time-equivalent values and position costs used in position-based revisions.
• UPDATE_BASELINE_VALUES, UPDATE_BASELINE_VALUES — Adjust baseline reference amounts after a revision is applied.
• CACHE_REVISION_VARIABLES — Loads frequently accessed revision attributes into package-level state to reduce repeated queries during batch runs.
• FIND_SYSTEM_DATA_EXTRACT, DELETE_ROW — Utility routines for locating system data extracts and removing individual revision records.

Tables Accessed

The package operates primarily on the PSB revision entity tables: PSB_BUDGET_REVISIONS, PSB_BUDGET_REVISIONS_S, and PSB_BUDGET_REVISIONS_V for header data; PSB_BUDGET_REVISION_ACCOUNTS, PSB_BUDGET_REVISION_ACCOUNTS_S, and PSB_BUDGET_REVISION_ACCOUNTS_V for account lines; and PSB_BUDGET_REVISION_POSITIONS, PSB_BUDGET_REVISION_POS_LINES, PSB_BUDGET_REVISION_POS_LINE_S, and PSB_BUDGET_REVISION_POSITION_V for position lines. Supporting PSB structures include PSB_BUDGET_ACCOUNTS, PSB_BUDGET_GROUPS, PSB_BUDGET_POSITIONS, PSB_ATTRIBUTE_VALUES, and constraint tables such as PSB_CONSTRAINT_SETS_V and PSB_CONSTRAINT_FORMULAS.

Integration with the General Ledger uses GL_CODE_COMBINATIONS, GL_PERIOD_STATUSES, GL_PERIODS_V, GL_SETS_OF_BOOKS, FND_CURRENCIES, and the GL_BC_PACKETS and GL_BC_PACKETS_S budget control packet tables. Balance and transfer operations leverage GL_BUDGET_TRANSFER_PKG and PSB_GL_BUDGET_PVT. Funds checking is delegated to PSA_FUNDS_CHECKER_PKG. The package also references various view objects (PSB_PARAMETERS_V, PSB_PARAMETER_ASSIGNMENTS_V, PSB_CONSTRAINT_ASSIGNMENTS_V) to resolve configuration, and PSA_FUNDS_CHECKER_PKG for validation. Each of these is accessed through APPS synonyms, consistent with standard EBS schema separation.

Usage Notes

PSB_BUDGET_REVISIONS_PVT is not normally called directly by end users or external integrations. It is invoked from the Public Sector Budgeting forms when a user creates, submits, or applies a budget revision, and from concurrent programs such as the mass budget revision process (MASS_BUDGET_REVISION_CP), the funds check process, and various GL interface and reconciliation programs. Dependent packages including PSB_CREATE_BR_PVT and PSB_COMMITMENTS_PVT call into this API to reuse its caching and account/position generation logic.

Because the package caches revision variables in package-level state, it is intended to operate within a single logical revision session; concurrent invocations against the same revision should be serialized. Concurrency control is generally provided by PSB_CONCURRENCY_CONTROL_PVT. Customizations that need to create or modify budget revisions should invoke the public wrapper API rather than this private package, preserving upgrade safety across EBS 12.1.1 and 12.2.2. Any direct call into the private procedures requires careful attention to the expected commit points, since the package does not unconditionally commit; the calling form or concurrent manager is responsible for transaction control. The package is marked VALID in APPS and references 13 other dependent packages, confirming it is an actively maintained component of the PSB budget revision framework.