Search Results populate_worksheet




Overview
Explore in AI Chat

Overview

APPS.PSB_DISTRIBUTE_WORKSHEET_PVT is a private PL/SQL package body in the Oracle EBS Public Sector Budgeting (PSB) module. It encapsulates the workflow-driven logic used to distribute budget worksheets to recipients. The package name follows the EBS private API naming convention (the _PVT suffix), indicating it is intended to be called internally by other PSB packages or workflow components rather than directly by external integrations.

The primary business function served is the initiation and population of the worksheet distribution workflow. When budget worksheets are distributed to budget groups and recipients, this package creates a workflow instance of item type PSBWS, launches the "Distribute Worksheet" process, and enriches the worksheet with the appropriate recipient and distribution instruction data. The package's header comment reflects a ship date of 2005/08/25 (revision 120.3), which is consistent with the code line shipped in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package:

  • START_PROCESS — As described in the embedded source comments, this procedure creates an instance of the workflow item type PSBWS and starts the workflow process named "Distribute Worksheet." It accepts standard Oracle API parameters (API version, initialization message list, commit flag, validation level, and return status/message outputs) along with a worksheet item key and distribution-related inputs such as distribution instructions and recipient name. Standard defensive coding is applied, including an FND_API.Compatible_API_Call version check and a SAVEPOINT for partial rollback. Global WHO columns (g_current_date, g_current_user_id, g_current_login_id) are captured at package initialization from SYSDATE and FND_GLOBAL.
  • POPULATE_WORKSHEET — This is the procedure most commonly associated with the search term "populate_worksheet." It is responsible for populating the worksheet record with the data needed for distribution, typically invoked within the workflow or as a preparatory step before START_PROCESS. Because it is a private procedure, its parameter list is not exposed for direct external invocation; it is expected to be called by the parent PSB distribution logic.

Tables Accessed

The package references three tables through APPS synonyms:

  • PSB_BUDGET_GROUPS — Provides the grouping of budget recipients to whom worksheets are distributed.
  • PSB_WORKFLOW_PROCESSES — Supports workflow process bookkeeping, linking the distribution to the active workflow instance.
  • PSB_WORKSHEETS — The central transactional table holding worksheet records; the package reads and updates worksheet rows, including population of recipient and distribution data.

Usage Notes

This package is classified as a private API (PVT) and is referenced by one other package, confirming it is not intended for direct customer invocation. It is typically triggered through the PSB worksheet distribution UI or the associated concurrent process, which in turn calls the public-facing PSB package that delegates to this private body. Customizations should not call START_PROCESS or POPULATE_WORKSHEET directly, as signature changes between patch levels are possible. In Oracle EBS 12.1.1 and 12.2.2, the workflow item type PSBWS must be active for distribution to function; if worksheets fail to distribute, the PSB_WORKFLOW_PROCESSES and workflow status views are the first diagnostic points.