Search Results update_target_budget_revision

Overview

PSB_CREATE_BR_PVT is a private PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite HRMS/Public Sector Budgeting (PSB) module. Its name reflects its role: it is the internal implementation layer responsible for creating Budget Revisions ("BR") within the budgeting hierarchy. In Oracle EBS 12.1.1 and 12.2.2, Public Sector Budgeting allows agencies to construct, submit, approve, and freeze budget revisions against organizational budget groups. PSB_CREATE_BR_PVT supplies the low-level programmatic logic that supports these revision lifecycle operations.

As a PVT (private) package, it is not intended to be called directly by end users or external integrations. It sits beneath the public-facing budgeting APIs and concurrent processes, encapsulating creation, freezing, hierarchical navigation (parent/child revision lookup), and target revision updates. The package status is VALID, indicating it is successfully compiled in the referenced instance.

Key Procedures and Functions

The documented package exposes eight procedures/functions:

• ENFORCE_BR_CONCURRENCY — Applies concurrency control rules to budget revision operations, guarding against conflicting simultaneous requests.
• CHECK_BR_OPS_CONCURRENCY — Validates whether a budget revision operation may proceed given the current concurrency state.
• CREATE_BUDGET_REVISION — The core routine that instantiates a new budget revision record and its associated detail rows.
• FREEZE_BUDGET_REVISION — Locks a budget revision so that no further modifications are permitted.
• FIND_PARENT_BUDGET_REVISION — Resolves the immediate parent revision within the budget hierarchy.
• FIND_PARENT_BUDGET_REVISIONS — Retrieves the broader set of ancestor revisions for hierarchical traversal.
• FIND_CHILD_BUDGET_REVISIONS — Returns child revisions subordinate to a given parent revision.
• UPDATE_TARGET_BUDGET_REVISION — Updates the target revision reference used in copy/move operations between revisions.

Tables Accessed

The package operates across the core Public Sector Budgeting schema, referencing tables through APPS synonyms:

• PSB_BUDGET_GROUPS — Defines the budget group context under which revisions are created.
• PSB_BUDGET_REVISIONS — The master revision header records created and updated by this package.
• PSB_BUDGET_REVISION_ACCOUNTS — Account-level distribution lines tied to a revision.
• PSB_BUDGET_REVISION_LINES — Detailed expenditure/revenue lines within a revision.
• PSB_BUDGET_REVISION_POSITIONS — Position (headcount) information attached to a revision.
• PSB_BUDGET_REVISION_POS_LINES — Line-level position detail records.
• PLITBLM — The standard PL/SQL index-by table type used for in-memory array processing.

The package also depends heavily on PL/SQL and EBS infrastructure packages, notably FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and PSB_BUDGET_REVISIONS_PVT and PSB_CONCURRENCY_CONTROL_PUB, which provide error handling, message stacking, and concurrency management.

Usage Notes

PSB_CREATE_BR_PVT is invoked indirectly. It is referenced by three other database objects, most likely the public budgeting APIs and concurrent programs that drive the "Create Budget Revision," "Freeze Budget Revision," and revision copy/rollover workflows surfaced through the Budgeting forms and the Budget Revisions concurrent program. Standard practice is to call the corresponding public API (for example, PSB_BUDGET_REVISIONS_PVT) rather than this private package directly.

Customizations and extensions should avoid direct dependence on PSB_CREATE_BR_PVT, since private package signatures are not guaranteed stable across patch applications or upgrades between 12.1.1 and 12.2.2. Developers integrating budgeting automation should route requests through the documented public APIs, which in turn invoke this implementation layer while ensuring proper FND message handling, concurrency enforcement, and validation.