Search Results psb_workflow_processes_s

Overview

PSB_WORKFLOW_PVT is an internal Oracle E-Business Suite package body owned by the APPS schema, classified as a private (PVT) API within the Public Sector Budgeting (PSB) product family. It provides the workflow orchestration layer for the budgeting cycle, bridging the PSB budget worksheet and budget revision entities to the Oracle Workflow engine (WF_ENGINE and WF_CORE). The package is responsible for launching, routing, and completing the approval workflows that govern worksheet submission and budget revision submission, including the downstream distribution of approved worksheets and revisions to general ledger and cost distribution targets.

The package is intended solely for internal consumption by other PSB packages; it is not referenced by any database object outside the PSB module and is documented as referencing native ETRM budget tables through APPS synonyms. It also performs diagnostic and message-handling duties through the FND_MESSAGE, FND_MSG_PUB, and PSB_MESSAGE_S APIs.

Key Procedures and Functions

• DISTRIBUTE_WS — Drives outbound distribution of an approved budget worksheet, invoking the PSB_DISTRIBUTE_WORKSHEET_PVT logic and related distribution rules.
• SUBMIT_WS — Initiates the approval workflow for a submitted budget worksheet, delegating to PSB_SUBMIT_WORKSHEET_PVT and FND_FLEX_WORKFLOW.
• SUBMIT_BR — Initiates the approval workflow for a submitted budget revision, coordinating with PSB_SUBMIT_REVISION_PVT and PSB_CREATE_BR_PVT.
• DISTRIBUTE_BR — Handles downstream distribution of an approved budget revision to the cost distribution interface and GL code combinations.
• GENERATE_ACCOUNT — Derives and populates account information (code combination) for worksheet and revision distribution records.
• NO_PROCESS_DEFINED — Diagnostic routine that raises or reports the condition where no matching Oracle Workflow process definition is configured for the requested PSB workflow type.
• GET_DEBUG — Returns the current debug/diagnostic flag controlling verbose logging behavior for the package's workflow and distribution routines.

Tables Accessed

• PSB_WORKFLOW_PROCESSES and PSB_WORKFLOW_PROCESSES_S — Configures the workflow item type, process name, and status mapping used when launching a PSB workflow. The concurrent/PLSQL search term psb_workflow_processes_s maps directly to this table.
• PSB_WORKSHEETS, PSB_WS_DISTRIBUTIONS, PSB_WS_DISTRIBUTION_DETAILS, and PSB_WS_DISTRIBUTION_RULE_LINES — Source and target records for worksheet submission and distribution.
• PSB_BUDGET_REVISIONS and PSB_COST_DISTRIBUTIONS_I — Source and target records for budget revision submission and cost distribution.
• PSB_BUDGET_GROUPS and PSB_BUDGET_GROUP_RESP — Resolves approver routing based on budget group responsibilities.
• GL_CODE_COMBINATIONS and HR_ALL_ORGANIZATION_UNITS — Supplies account validation and organization context for generated distributions.
• DUAL — Supports utility and single-row queries.

Usage Notes

PSB_WORKFLOW_PVT is invoked programmatically rather than directly by end users. Typical call points include the Public Sector Budgeting worksheet submission and revision submission forms, the worksheet distribution concurrent programs, and internal PSB packages such as PSB_SUBMIT_WORKSHEET_PVT, PSB_SUBMIT_REVISION_PVT, PSB_DISTRIBUTE_WORKSHEET_PVT, PSB_CREATE_BR_PVT, and PSB_WS_OPS_PVT. The package is not referenced by any external database object.

Because PSB_WORKFLOW_PVT is a PVT-class API, Oracle does not guarantee its signature across releases; customizations should call the public PSB APIs instead. Correct operation requires that a matching Oracle Workflow process definition be defined and active in PSB_WORKFLOW_PROCESSES; otherwise the NO_PROCESS_DEFINED routine signals a configuration failure. Debug behavior is controlled via GET_DEBUG, enabling diagnostic tracing through PSB_MESSAGE_S when troubleshooting workflow routing in 12.1.1 and 12.2.2 environments.