Search Results psb_ws_acct1




Overview
Explore in AI Chat

Overview

PSB_WS_ACCT2 is a public PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Public Sector Budgeting (PSB) module. Operating under the Oracle Enterprise Technical Reference Model (ETRM) classification "OTHER," the package handles worksheet-level account processing. Its principal business function is to take budget group hierarchy definitions and generate, distribute, revise, and aggregate the account worksheet lines that budget analysts work with during the budget preparation cycle. The package works in close coordination with its companion package PSB_WS_ACCT1, which supplies shared global variables such as period table types and date range globals (for example, g_startdate_pp, g_enddate_cy, and the g_budgetperiod_tbl_type collections). PSB_WS_ACCT2 assembles account sets, GL account ranges, budget and actual balances, allocation rule percentages, and rollup totals into a coherent worksheet view for downstream processing and reporting.

Key Procedures and Functions

Nine documented procedures and functions comprise the public API of this package body:

  • CREATE_WORKSHEET_ACCOUNTS — Builds the account lines that populate a budget worksheet for a given budget group.
  • UPDATE_GL_BALANCES — Refreshes the General Ledger balance amounts associated with worksheet accounts.
  • REVISE_ACCOUNT_PROJECTIONS — Recalculates projected account amounts, typically after changes to budget parameters or prior-period actuals.
  • PROCESS_DEFERRED_CCIDS — Resolves deferred code combinations that were queued during worksheet creation and applies them to the working set.
  • APPLY_ACCOUNT_PARAMETERS — Applies budget parameters and parameter formulas to account records.
  • DISTRIBUTE_ACCOUNT_LINES — Spreads account amounts across applicable periods or organizational dimensions based on allocation rules.
  • CREATE_ROLLUP_TOTALS — Aggregates account-level detail into rollup totals for higher-level budget group reporting.
  • GET_DEBUG — Utility routine exposing internal debug state for troubleshooting.

Tables Accessed

The package reads and writes the following APPS synonyms.

Usage Notes

PSB_WS_ACCT2 is invoked primarily from the Public Sector Budgeting worksheet forms and from related concurrent programs that build or refresh budget worksheets. It is also referenced by four other packages in the PSB family, indicating its role as a shared service component. Because the package relies on globals initialized by PSB_WS_ACCT1, callers must ensure that the companion package is initialized before invoking PSB_WS_ACCT2 routines. The g_process_cy_estimates flag (introduced per Bug#3514350) controls whether current-year estimates are processed, allowing administrators to suppress this step where not required. Environments upgrading from 12.1.1 to 12.2.2 should verify that psb_set_relations_v and all referenced APPS synonyms remain valid after patching, since the package depends heavily on these views for cursor definitions.