Search Results create_rollup_totals

Overview

PSB_WS_ACCT_PVT is a private PL/SQL package body owned by APPS within Oracle E-Business Suite. Its header revision ($Header: PSBPWCAB.pls 120.6 2006/05/30) indicates it belongs to the Public Sector Budgeting (PSB) workspace account processing family, originating with the Grants Accounting / Public Sector Financials module. The package serves as the private implementation layer for the account-oriented public APIs used by the PSB workspace application, encapsulating validation, distribution creation, projection revision, GL balance maintenance, and rollup total generation for budget accounts.

The classification PVT confirms that this package is not intended for direct customer invocation. Its procedures are invoked internally by corresponding public wrapper packages, which perform API version compatibility checks, message list initialization, and standardized exception handling. The package follows the canonical Oracle EBS private API pattern: the public wrapper validates the API version via FND_API.Compatible_API_Call, initializes FND_MSG_PUB if requested, delegates to the private implementation, then calls FND_MSG_PUB.Count_And_Get to propagate messages and statuses.

Key Procedures and Functions

• CHECK_CCID_TYPE — Determines the type of a given code combination identifier (CCID) based on a supplied flex code and budget group, returning a CCID type indicator. Used to classify accounts before downstream processing.
• CREATE_ACCOUNT_DIST — Creates account distribution records for budget workspace account processing, allocating amounts across applicable accounts.
• REVISE_ACCOUNT_PROJECTIONS — Revises existing account projection records, adjusting future-period budget projections when account or budget data changes.
• UPDATE_GL_BALANCES — Updates General Ledger balance information in response to account-level budget changes processed through the PSB workspace.
• CREATE_ROLLUP_TOTALS — Generates rollup totals for budget accounts, aggregating detailed account balances into summary rollup balances. This procedure is the object returned for the search term "create_rollup_totals."
• UPDATE_GL_BALANCES_CP — A variant of UPDATE_GL_BALANCES intended for use within a concurrent program (CP) context, allowing bulk GL balance updates outside the online form session.
• CREATE_ROLLUP_TOTALS_CP — A concurrent program variant of CREATE_ROLLUP_TOTALS, enabling rollup total generation as a background batch process.
• REVISE_ACCOUNT_PROJECTIONS_CP — A concurrent program variant of REVISE_ACCOUNT_PROJECTIONS, supporting bulk projection revision in batch mode.

The observable signature of CHECK_CCID_TYPE in the source excerpt shows standard EBS API parameters: p_api_version, p_init_msg_list, p_validation_level, p_return_status, p_msg_count, p_msg_data, plus business parameters p_ccid_type, p_flex_code, p_ccid, and p_budget_group_id.

Tables Accessed

The supplied metadata does not enumerate the specific tables referenced through APPS synonyms. However, based on the procedure names and PSB functional domain, the package is expected to operate against PSB workspace account and projection tables (such as account distribution and projection entities), GL balance and GL summary tables for the UPDATE_GL_BALANCES procedures, and rollup/flexfield combination tables for CCID classification and rollup total generation. Precise table names should be confirmed by inspecting the package body source in the target environment.

Usage Notes

PSB_WS_ACCT_PVT is referenced by seven other packages, indicating a shared utility role within the PSB workspace call stack. It is invoked indirectly through public API wrappers, and several of its procedures are exposed through concurrent program variants (the _CP suffix), meaning typical invocation paths include online Public Sector Budgeting forms and background concurrent programs. Custom code should avoid calling this PVT package directly and instead use the corresponding public API or concurrent program to preserve version compatibility and message handling.