Search Results distribute_ws




Overview
Explore in AI Chat

Overview

PSB_WORKFLOW_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite budgeting and worksheet workflow infrastructure. It is part of the Public Sector Budgeting (PSB) module and is classified as a PVT package, meaning it is intended for internal use by the PSB application rather than as a public integration API. Its primary business function is to orchestrate workflow-related activities for budget worksheets and budget revisions, including the submission and distribution of worksheet and revision data across the organizations and budget groups defined in the PSB configuration.

The package also performs supporting utility functions such as resolving accounting flexfield combinations and reporting diagnostic or configuration errors. Because it is bound to workflow routing logic, PSB_WORKFLOW_PVT is closely tied to the approval and distribution cycles that govern how budget data moves between preparers, reviewers, and approvers within the organization hierarchy.

Key Procedures and Functions

The package exposes seven documented procedures and functions, all oriented toward workflow and account resolution:

  • SUBMIT_WS — Submits a budget worksheet into the workflow process, initiating the routing or approval cycle for that worksheet.
  • DISTRIBUTE_WS — Distributes a submitted worksheet according to the configured distribution rules and budget group assignments.
  • SUBMIT_BR — Submits a budget revision to the workflow, analogous to worksheet submission but for revision records.
  • DISTRIBUTE_BR — Distributes a budget revision to the appropriate organizations or recipients.
  • GENERATE_ACCOUNT — Resolves or generates an accounting flexfield combination, supporting the creation of budget cost distributions.
  • NO_PROCESS_DEFINED — Handles the condition where no workflow process has been defined for the requested operation, typically raising or reporting an error condition.
  • GET_DEBUG — Returns the debug setting used to control diagnostic trace output during workflow execution.

Tables Accessed

The package reads and writes several core PSB tables through APPS synonyms. Worksheet and revision data are sourced from PSB_WORKSHEETS and PSB_BUDGET_REVISIONS, with distribution targets held in PSB_WS_DISTRIBUTIONS, PSB_WS_DISTRIBUTION_DETAILS, and PSB_WS_DISTRIBUTION_RULE_LINES. Workflow process configuration is read from PSB_WORKFLOW_PROCESSES and PSB_WORKFLOW_PROCESSES_S. Budget group and responsibility assignments come from PSB_BUDGET_GROUPS and PSB_BUDGET_GROUP_RESP, while HR_ALL_ORGANIZATION_UNITS provides the organization hierarchy used to route work. GENERATE_ACCOUNT interacts with GL_CODE_COMBINATIONS and PSB_COST_DISTRIBUTIONS_I to build accounting distributions, and DUAL is used for singleton lookups. The package also calls FND_API for standard API error and message handling.

Usage Notes

PSB_WORKFLOW_PVT is an internal package and is not intended to be called directly from custom code. It is invoked indirectly by the Public Sector Budgeting forms and concurrent programs when users submit or distribute worksheets and budget revisions, and it is referenced by the companion package PSB_HR_POPULATE_DATA_PVT. Customizations that require worksheet or revision workflow submission should be routed through the supported PSB interfaces rather than this private package, since its signature and behavior may change without notice. Administrators should ensure that workflow processes are defined in PSB_WORKFLOW_PROCESSES; otherwise the NO_PROCESS_DEFINED path will surface an error. The GET_DEBUG function allows developers to confirm whether diagnostic tracing is enabled when troubleshooting distribution or submission failures.