Search Results update_baseline_values

Overview

PSB_SUBMIT_REVISION_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that implements the core business logic behind the Oracle E-Business Suite Public Sector Budgeting (PSB) budget revision submission and approval cycle. It is the engine invoked when a budget group submits a set of budget revisions for review, approval, rejection, or posting. The package coordinates the workflow-driven approval process, validates budget constraints, enforces concurrency controls, freezes the affected revision lines against further edits, records approver decisions, dispatches notifications, updates revision and view-line status flags, and ultimately posts approved revisions to the General Ledger. It also manages the funds reservation and baseline update steps that accompany an approved budget revision. Because it is a private package, it is not designed as a public integration point; it is consumed internally by the Public Sector Budgeting workflow layer, principally PSB_WORKFLOW_PVT. The package is marked VALID in the APPS schema and depends on the standard Oracle Application Object Library API (FND_API) for message handling, savepoint management, and error/exception semantics.

Key Procedures and Functions

The package exposes twenty-five documented procedures and functions covering the full revision lifecycle:

• START_PROCESS — the primary entry point that initiates the revision submission process.
• POPULATE_REVISION — builds the working revision data set prior to submission.
• ENFORCE_CONCURRENCY_CHECK and VALIDATE_CONSTRAINTS — guard against simultaneous edits and verify that submission rules are satisfied.
• SELECT_OPERATION — determines the operation to be applied to the revision.
• FREEZE_REVISIONS and UNFREEZE_REVISIONS — lock and release revision lines so they cannot be modified while in approval.
• UPDATE_VIEW_LINE_FLAG — toggles the UI view-line indicator reflecting revision state.
• SELECT_APPROVERS and FIND_OVERRIDE_APPROVER — resolve the approval routing list and apply any overriding approver.
• CALLBACK — the workflow callback invoked on approval outcome.
• SET_REVIEWED_FLAG, SET_APPROVAL_STATUS, and SET_REJECTION_STATUS — record review and decision state on the revision.
• SEND_APPROVAL_NOTIFICATION — dispatches workflow notifications to approvers.
• UPDATE_REVISIONS_STATUS — persists the overall revision status.
• POST_REVISIONS_TO_GL — transfers approved revisions to the General Ledger.
• UPDATE_BASELINE_VALUES — refreshes baseline figures after approval.
• FUNDS_RESERVATION_UPDATE — updates funds reservation records.
• START_DISTRIBUTION_PROCESS — launches downstream distribution processing.

Tables Accessed

The package reads and writes the principal PSB tables through APPS synonyms. It uses PSB_BUDGET_REVISIONS, PSB_BUDGET_REVISION_LINES, and PSB_BUDGET_REVISION_POS_LINES to hold the revision header, detail lines, and position lines under submission. PSB_BUDGET_GROUPS and PSB_BUDGET_GROUP_RESP supply the budget group definition and responsible approver assignments used in approver selection. PSB_WORKFLOW_PROCESSES tracks the running workflow instance, while PSB_WS_SUBMIT_COMMENTS stores user-entered submission comments. FND_USER is queried to resolve approver identities and notification recipients. PLITBLM is the Oracle Application Object Library PL/SQL table used for list-based processing.

Usage Notes

PSB_SUBMIT_REVISION_PVT is not called directly from forms or concurrent programs by end users; it is invoked internally, primarily by PSB_WORKFLOW_PVT, and referenced by no other external package. The workflow callback mechanism (CALLBACK) is the standard path by which the approval workflow returns control to the package when an approver responds. Custom code should avoid calling this private package directly and should instead drive the public submission path in the PSB workflow layer or the Public Sector Budgeting concurrent programs. Because the package is classified PVT, its signatures are not a supported interface and may change between 12.1.1 and 12.2.2 without notice.