Search Results cp_precision

Overview

The APPS.BOM_CSTRPDSS_XMLP_PKG package body is the PL/SQL implementation behind the Oracle EBS concurrent program Cost Reporting DSS (internal report short name CSTRPDSS). It belongs to the Bills of Material / Cost Management reporting family and is designed to be executed as an Oracle Reports XML Publisher (XMLP) server-side package. The package assembles the query and layout data required for a cost reporting Decision Support System (DSS) output, driven by concurrent program parameters such as a cost group, a period identifier, and the user's ledger context. Its overall purpose is to fetch cost activity and cost accounting detail for a specified cost group and accounting period and to present hierarchical debit, credit, net activity, account total, and report total figures.

Key Procedures and Functions

The package exposes 25 documented procedures and functions executed across the report lifecycle. Within the context of the user's search term, the relevant initialization path resolves the reporting currency's decimal precision in BEFOREREPORT.

• BEFOREREPORT — the primary initialization routine. It retrieves the concurrent request id, populates the request responsibility, request time, application, and requested-by values, and then selects the legal entity, cost group, cost type, currency code, period name, and CP_PRECISION (the reporting precision, defaulted to 2 via NVL(FC.PRECISION, 2)) for the run.
• AFTERPFORM — called from within BEFOREREPORT to perform after-parameter-form processing.
• AFTERREPORT — closing routine invoked at report completion.
• C_ITEM — a column/group function controlling the ordering or grouping of cost items in the report layout.
• C_ACCT_PADFORMULA — a formula column used to pad/format account values (typically cost account segments) for display.
• CF_NET_ACTIVITY_RFORMULA — computes the net activity (debits less credits) for the reporting period.
• CF_SUM_CREDITS_RFORMULA — computes total credit amounts.
• CF_SUM_DEBITS_RFORMULA — computes total debit amounts.
• CF_ACCT_TOT_RFORMULA — computes the account-level total.
• CF_CR_ACCT_TOT_RFORMULA and CF_DR_ACCT_TOT_RFORMULA — compute credit and debit account-level totals respectively.
• CF_CR_TOT_RFORMULA and CF_DR_TOT_RFORMULA — compute overall credit and debit grand totals.
• CF_REPORT_TOT_RFORMULA — computes the final report total.
• CP_RESPONSIBILITY_P, CP_REQUEST_TIME_P, CP_APPLICATION_P, CP_REQUESTED_BY_P, CP_LEGAL_ENTITY_P, CP_ACCT_ID_P — accessor functions (the _P suffix is the XML Publisher convention) that expose the corresponding package-level variables to the report template.

Tables Accessed

• CST_AE_HEADERS — the cost accounting events header; supplies the legal entity, cost group, and period linkage.
• CST_COST_GROUPS and CST_COST_TYPES — provide the cost group and cost type descriptive values.
• FND_CURRENCIES — provides the currency code and, critically for this search, the PRECISION value used to format monetary output.
• FND_CONCURRENT_REQUESTS, FND_USER, and the responsibility/application views — provide request audit information (requested-by user, responsibility name, request date, application name).
• Ledger and first-party views (e.g., GL_LEDGER_LE_V, XLE_FIRSTPARTY_INFORMATION_V) — supply the primary ledger and legal entity context.

Usage Notes

This package is not a general-purpose API; it is tightly bound to the Cost Reporting DSS concurrent program and is invoked by the Oracle Reports runtime during report execution. BEFOREREPORT runs first to seed the report's package globals, followed by the formula columns during data retrieval and AFTERREPORT at completion. The CP_*_P accessors are referenced by the XML Publisher template to reference the initialized globals. Custom code should not call these routines directly; the report should be run as a concurrent program so that parameter context (cost group, period, ledger) is established correctly. Because CP_PRECISION is derived from FND_CURRENCIES.PRECISION with a default of 2, its value reflects the reporting currency's defined decimal precision for the ledger in use.