Search Results check_br_ops_concurrency

Overview

PSB_CREATE_BR_PVT is a private PL/SQL API package in the Oracle EBS Public Sector Budgeting (PSB) module, owned by the APPS schema. It implements the core business logic for creating, maintaining, and freezing Budget Revisions, which are versioned working copies of a budget that participants can modify, compare, and ultimately freeze as a baseline. The package is classified as PVT, meaning it is an internal implementation layer rather than a public, supported entry point; callers are expected to reach it through the corresponding public API wrapper, PSB_CREATE_BR_PUB, which validates inputs and delegates to this private package. In addition to revision lifecycle operations, PSB_CREATE_BR_PVT provides the concurrency-control procedures that prevent conflicting budget revision operations, such as two users attempting to modify the same revision or a parent/child revision hierarchy simultaneously. The package operates against the PSB budget revision entity model, including budget groups, revision headers, revision accounts, lines, positions, and position lines.

Key Procedures and Functions

• ENFORCE_BR_CONCURRENCY — Applies concurrency rules for a budget revision, taking into account whether the revision is being handled in parent or child mode and the maintenance mode in effect. It safeguards against conflicting edits across the revision hierarchy.
• CHECK_BR_OPS_CONCURRENCY — Validates whether a specific operation type may proceed against a given budget revision at the current time. This is the procedure most directly relevant to the search term check_br_ops_concurrency, and it is typically called before an operation is attempted so that the caller receives a return status and message rather than encountering a database-level failure.
• CREATE_BUDGET_REVISION — Creates a new budget revision, accepting the budget group and revision option flag and returning the identifier of the newly created revision.
• FREEZE_BUDGET_REVISION — Transitions a budget revision into a frozen state, making it a locked baseline that can no longer be modified.
• FIND_PARENT_BUDGET_REVISION — Locates the immediate parent revision of a given revision.
• FIND_PARENT_BUDGET_REVISIONS — Returns the set of parent revisions, typically used when resolving the full revision hierarchy.
• FIND_CHILD_BUDGET_REVISIONS — Returns the child revisions associated with a revision, supporting hierarchical navigation and concurrency checks.
• UPDATE_TARGET_BUDGET_REVISION — Updates attributes of a target budget revision as part of revision maintenance and synchronization.

Tables Accessed

• PSB_BUDGET_GROUPS — Defines the budget group context under which revisions are created and grouped.
• PSB_BUDGET_REVISIONS — The revision header table; the primary read/write target for creation, freezing, and status updates.
• PSB_BUDGET_REVISION_ACCOUNTS — Account-level revision data copied and maintained when revisions are created.
• PSB_BUDGET_REVISION_LINES — Line-level revision detail populated during revision creation.
• PSB_BUDGET_REVISION_POSITIONS — Position records associated with a revision.
• PSB_BUDGET_REVISION_POS_LINES — Position line detail for the revision.
• PLITBLM — A PL/SQL index-by table used internally for bulk processing.

Usage Notes

PSB_CREATE_BR_PVT is invoked indirectly. Standard callers include Public Sector Budgeting forms and concurrent programs that manage budget revisions, along with the public wrapper PSB_CREATE_BR_PUB, which enforces the FND_API standard parameter contract (API version, message list initialization, commit flag, validation level, and the return status, message count, and message data outputs). Because it is a private package, customizations should not call PSB_CREATE_BR_PVT directly; custom code should use the PUB layer instead to remain upgrade-safe. Callers performing revision operations should invoke CHECK_BR_OPS_CONCURRENCY beforehand and respect the return status, since the concurrency procedures are designed to detect in-flight operations and prevent corrupting a revision or its hierarchy. The package is referenced by three other packages and is available in both EBS 12.1.1 and 12.2.2, with the source header dating to 2005.