Search Results psb_submit_worksheet_pvt




Overview
Explore in AI Chat

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:

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.