Search Results get_chart_of_accounts_id

Overview

APPS.BOM_CSTRPWRO_XMLP_PKG is the server-side PL/SQL package body that supports the Oracle E-Business Suite concurrent program and XML Publisher (BI Publisher) report associated with cost write-off processing in Oracle Cost Management. The package encapsulates report-level initialization logic, parameter derivation, and lookup routines needed to render the Cost Write-Off Report within the Discrete Manufacturing and Cost Management product family.

The package follows the standard Oracle Reports XMLP integration pattern, in which report-specific PL/SQL is packaged as a PL/SQL package body stored in the APPS schema and referenced from the concurrent program definition. Its initialization routines establish the reporting context — the operating unit, ledger, cost type, cost group, and accounting period — and resolve the numeric identifiers and display names required to present the report output consistently across the enterprise structure.

Its API classification is OTHER, indicating it is not a published public API but an internal component intended solely for the report with which it is delivered.

Key Procedures and Functions

• BEFOREREPORT — The primary initialization function, executed before report data is fetched. It sets precision values via BOM_COMMON_XMLP_PKG, captures the concurrent request ID from FND_GLOBAL, invokes the ledger chart-of-accounts resolution, and populates the legal entity name, cost type name, cost group name, and period name, along with write-off and period date ranges.
• AFTERREPORT — Post-report cleanup routine.
• GET_CHART_OF_ACCOUNTS_ID — Resolves the CHART_OF_ACCOUNTS_ID for the set of books defined in FINANCIALS_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS, assigning it to the report parameter P_CHART_OF_ACCOUNTS_ID. This is the function that matched the search term.
• C_YESY_NO_DISPFORMULA — Display formula for yes/no indicator formatting.
• C_FLEX_ACC_SORTFORMULA — Flexfield account sort formula used for ordering accounting flexfield output.
• BEFOREPFORM and AFTERPFORM — Pre- and post-format triggers.
• LEGAL_ENTITY_NAME_P, COST_GROUP_NAME_P, COST_TYPE_NAME_P, PERIOD_NAME_P, FROM_DATE_P, TO_DATE_P — Accessor functions returning the values resolved during BEFOREREPORT.

Tables Accessed

• CST_COST_GROUPS — Source of the cost group name keyed by cost group, cost type, and legal entity.
• CST_COST_TYPES — Provides the cost type name.
• CST_PAC_PERIODS — Supplies period name, start date, and end date for the selected cost type, legal entity, and PAC period.
• FINANCIALS_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS — Joined in GET_CHART_OF_ACCOUNTS_ID to derive the ledger chart of accounts.
• XLE_FIRSTPARTY_INFORMATION_V — Legal entity name lookup, referenced through the view layer.

Usage Notes

This package is invoked exclusively by the concurrent program and XML Publisher data template that generate the Cost Write-Off Report. It is not intended for direct invocation from Forms or custom code, and it is referenced by zero other packages. Administrators diagnosing report failures involving the chart of accounts typically inspect GET_CHART_OF_ACCOUNTS_ID, since a missing or misconfigured FINANCIALS_SYSTEM_PARAMETERS row causes report initialization to fail before data extraction. The $Header indicates version 120.1, last updated January 2008, and it is shipped as noship, confirming it is a report-support component rather than a supported public API.