Search Results psb_create_br_pvt




Overview
Explore in AI Chat

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:

Tables Accessed

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

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.