Search Results create_review_group_worksheet

Overview

PSB_SUBMIT_WORKSHEET_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema and is a core component of the Public Sector Budgeting (PSB) module, part of the Enterprise Resource Planning footprint distributed with EBS 12.1.1 and 12.2.2. Its principal responsibility is to orchestrate the submission of a budgeting worksheet through the Oracle Workflow engine, driving the worksheet from a draft state through validation, constraint enforcement, approval routing, review group processing, and final freeze or merge operations. Because the package is classified as a private API, it is not intended for direct invocation by external customizations; instead it is called by the Public Sector Budgeting forms and by the workflow processes that those forms launch. The package exposes an API-style entry point, Start_Process, together with a set of workflow callback procedures whose standard signature (itemtype, itemkey, actid, funcmode, result) enables Oracle Workflow to invoke each step of the worksheet submission lifecycle.

Key Procedures and Functions

The package documents 23 procedures and functions. The central public-style routine is START_PROCESS, which accepts the API version, initialization and commit flags, validation level, and standard message return parameters alongside the business parameters: item key, submitter identity, operation type, review group flag, originating system, merge-to worksheet identifier, comments, operation identifier, and constraint set identifier. This procedure establishes the workflow context for the submission.

The workflow callback procedures follow the standard PL/SQL workflow signature and perform discrete lifecycle steps:

• POPULATE_WORKSHEET — builds the worksheet line content for submission.
• ENFORCE_CONCURRENCY_CHECK — verifies that the worksheet has not been modified since submission.
• PERFORM_VALIDATION — runs general worksheet validation.
• VALIDATE_CONSTRAINTS — evaluates the submitted worksheet against the applicable budget constraint set. This is the procedure most relevant to the search term "validate_constraints," receiving the constraint set identifier passed into the workflow from START_PROCESS.
• SELECT_OPERATION — determines the operation to be applied to the worksheet.
• COPY_WORKSHEET and MERGE_WORKSHEETS — perform copy and merge-to operations on worksheets.
• FREEZE_WORKSHEETS and UNFREEZE_WORKSHEETS — lock and release worksheets against further edits.
• UPDATE_VIEW_LINE_FLAG — updates the line flag controlling worksheet view behaviour.
• CHANGE_WORKSHEET_STAGE — moves the worksheet through its budget stage positions.
• PERFORM_REVIEW_GROUP_APPROVAL, SELECT_APPROVERS, CREATE_REVIEW_GROUP_WORKSHEET, NEW_WORKSHEET_CREATED, FIND_APPROVAL_OPTION, SEND_APPROVAL_NOTIFICATION — collectively implement review group routing, approver selection, approval option lookup, and notification delivery.
• SET_LOOP_LIMIT — caps workflow iteration.
• SET_REVIEWED_FLAG — records completion of review.

Tables Accessed

The package reads and writes through APPS synonyms. The central table is PSB_WORKSHEETS, which holds worksheet header data, including the merge-to worksheet identifier and operation identifier referenced in START_PROCESS. PSB_WS_LINES and PSB_WS_ACCOUNT_LINES store worksheet and account line detail used during population and validation. PSB_WS_LINES_POSITIONS links worksheet lines to budget positions. PSB_BUDGET_ACCOUNTS, PSB_BUDGET_GROUPS, PSB_BUDGET_GROUP_CATEGORIES, PSB_BUDGET_GROUP_RESP, and PSB_BUDGET_POSITIONS define the budget structure against which submissions are validated. PSB_BUDGET_STAGES drives stage transitions, while PSB_BUDGET_WORKFLOW_RULES, PSB_WORKFLOW_PROCESSES, and PSB_WF_REVIEW_GROUPS support workflow routing and review group approval. PSB_POSITIONS and PSB_SET_RELATIONS provide position and set relationship information needed for constraint and approver evaluation.

Usage Notes

PSB_SUBMIT_WORKSHEET_PVT is invoked from the Public Sector Budgeting worksheet forms when a user submits, copies, merges, freezes, unfreezes, or routes a worksheet for review. The forms call START_PROCESS, which launches the PSB worksheet submission workflow; Oracle Workflow then calls the individual callback procedures as the workflow progresses. Because the package is a private API and is referenced by only one other package, direct calls from custom code are not supported and are explicitly discouraged: Oracle may change private signatures without notice. Integrators requiring worksheet submission functionality should use the corresponding public API surfaced through the Public Sector Budgeting product rather than invoking these procedures directly.