Search Results check_ccid_type

Overview

PSB_WS_ACCT_PVT is a private (PVT-classified) PL/SQL package owned by APPS within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It belongs to the Public Sector Budgeting (PSB) product family, and its naming convention — PSB_WS_ACCT — indicates that it supports the worksheet accounting and budget account distribution layer of the budgeting module. The package provides the programmatic infrastructure that allows budget worksheets to validate accounts, project account distributions, update General Ledger balances, and generate rollup totals. As a private package, it is not exposed as a public API for third-party consumption; instead it is invoked internally by the higher-level PSB worksheet APIs and concurrently-run budget processes. This is consistent with the header comment showing the procedure Check_CCID_Type was originally created on 03/09/1998 by Supriyo Ghosh, with a note that on 16-NOV-1998 a call to the concurrent manager was moved into this package to handle balance updates and rollup creation.

Key Procedures and Functions

The ETRM metadata documents nine procedures/functions, of which the excerpt exposes the declaration for CHECK_CCID_TYPE and begins CREATE_ACCO. The documented members are:

• CHECK_CCID_TYPE — A private interface procedure that returns the CCID type for a supplied account. Its documented output values are 'PERSONNEL_SERVICES' and 'NON_PERSONNEL_SERVICES', allowing the budgeting engine to classify an account according to the type of expenditure it represents.
• CREATE_ACCOUNT_DIST — Creates account distributions used during worksheet processing.
• REVISE_ACCOUNT_PROJECTIONS — Revises existing account projections, typifying the projection recalculation logic used in budget worksheets.
• UPDATE_GL_BALANCES — Updates balances held in General Ledger in the standard (non-CP) processing path.
• CREATE_ROLLUP_TOTALS — Builds rollup totals in the standard processing path.
• UPDATE_GL_BALANCES_CP — The concurrent-program ("_CP") variant that performs the GL balance update when invoked through the concurrent manager.
• CREATE_ROLLUP_TOTALS_CP — The concurrent-program variant for creating rollup totals.
• REVISE_ACCOUNT_PROJECTIONS_CP — The concurrent-program variant for revising account projections.

The paired naming convention (with and without the _CP suffix) reflects the historical design noted in the header: two code paths exist, one executed synchronously within a calling process and one delegated to a concurrent manager job.

Tables Accessed

The ETRM metadata lists no directly referenced tables via APPS synonyms. Given the nature of the routines, however, the package necessarily operates against the PSB worksheet and budget account tables, the GL balance tables affected by UPDATE_GL_BALANCES, and the rollup structures written by CREATE_ROLLUP_TOTALS. Its declared prerequisites — FND_API, FND_MESSAGE, and PSB_WS_ACCT1 — confirm reliance on the standard Oracle Application Object Library message and API infrastructure.

Usage Notes

PSB_WS_ACCT_PVT is referenced by seven other packages in the PSB schema. It should be treated as an internal implementation package rather than a supported public interface; custom code should not call it directly. Invocation occurs from the standard PSB worksheet flows and from concurrent programs that, per the header note, were introduced so that balance update and rollup creation could be decoupled from the interactive session. The CHECK_CCID_TYPE procedure is accordingly reached indirectly during worksheet validation, where each account's personnel-versus-non-personnel classification governs subsequent budget logic. The redundant package-level flag g_soft_error_flag referenced in the header comments was superseded by PSB_WS_ACCT1.g_soft_error_flag, illustrating that error-state handling for this package is centralized in its companion package.