Search Results cf_cr_tot_rformula

Overview

APPS.BOM_CSTRPDSS_XMLP_PKG is the generated PL/SQL package that supports the Oracle E-Business Suite concurrent program and XML Publisher (BI Publisher) report "Cost Reporting Details Summary" — internally identified as CSTRPDSS. The package encapsulates the report's parameters, its before-report and after-report PL/SQL logic, and the formula functions embedded in the XML Publisher template. It belongs to the Oracle Bills of Material / Cost Management product family (BOM prefix) and is classified under ETRM as an "OTHER" API, meaning it is not a supported public interface but an internally referenced report package.

The package's primary business purpose is to present cost activity for a given range of accounting periods and cost groups. The user's search term, p_acct_from, corresponds to the package's global variable P_ACCT_FROM, which captures the "From Accounting Period" parameter supplied at report submission. Together with its counterpart, the range defined by p_acct_from and the "to" period drives the SQL that selects cost activity rows from the Cost Management tables.

Key Procedures and Functions

ETRM documents 25 procedures and functions in this package. Their purposes are as follows:

• BEFOREREPORT / AFTERPFORM / AFTERREPORT — Standard XML Publisher report trigger functions. BEFOREREPORT performs setup and parameter validation prior to data retrieval; AFTERPFORM executes after the parameter form values are processed and is typically used to build the dynamic WHERE clauses that incorporate p_acct_from and related parameters; AFTERREPORT performs cleanup and finalization after report output.
• C_ITEM — A report column function used to format and return item identifier values.
• C_ACCT_PADFORMULA — A formatting function that pads or structures the accounting flexfield account string for display in the report.
• CF_NET_ACTIVITY_RFORMULA, CF_SUM_CREDITS_RFORMULA, CF_SUM_DEBITS_RFORMULA, CF_ACCT_TOT_RFORMULA, CF_CR_ACCT_TOT_RFORMULA, CF_DR_ACCT_TOT_RFORMULA, CF_CR_TOT_RFORMULA, CF_DR_TOT_RFORMULA, CF_REPORT_TOT_RFORMULA — A family of calculation functions (the "CF_" prefix denotes calculated fields). Each returns a numeric value used by the XML template to compute net activity, credit subtotals, debit subtotals, and account-level and report-level totals for the cost activity detail rows.
• CP_*_P functions (CP_RESPONSIBILITY_P, CP_REQUEST_TIME_P, CP_APPLICATION_P, CP_REQUESTED_BY_P, CP_LEGAL_ENTITY_P, CP_ACCT_ID_P, and others) — These are getter functions that expose the values of the concurrent program context globals (responsibility, request time, application, requested-by, legal entity, and accounting ID) to the report layout for header display and audit purposes.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• CST_AE_HEADERS — Cost Management accounting entry headers; the primary source of cost activity records filtered by the accounting period range beginning at p_acct_from.
• CST_COST_GROUPS and CST_COST_TYPES — Used to resolve cost group and cost type identifiers into descriptive names for report display and parameter validation.
• FND_CONCURRENT_REQUESTS — Retrieves concurrent request context data for the report header and audit trail.
• FND_CURRENCIES — Supplies currency code and formatting information used by the amount calculation functions.
• FND_USER — Resolves the requesting user identity for the report header.

Usage Notes

This package is invoked indirectly. It is not called by other packages (ETRM records zero references) and is not a supported public API. It is executed only when the associated concurrent program "Cost Reporting Details Summary" is run, either directly from the Cost Management responsibility or via the standard request submission form. The concurrent manager invokes the report, which raises the package's BEFOREREPORT trigger; parameter values such as p_acct_from, cost group, cost type, and period range are then bound into the dynamic SQL constructed in AFTERPFORM. Custom code should not call the package's internal functions, as they are regenerated by the report builder and may change between patch levels or releases.