Search Results p_view_cost

Overview

APPS.BOM_CSTRIVTI_XMLP_PKG is a server-side PL/SQL package associated with an Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program. The package name suffix "_XMLP_PKG" follows the standard EBS convention whereby a report's data model is driven by a generated package that holds report parameters, global variables, and formula functions. The program is identified by the "CSTRIVTI" designator, which relates to a cost rollup item structure detail report. The package declares global variables that mirror the report's runtime parameters — including P_BATCH_ID, P_ORG_ID, P_INVENTORY_ITEM_ID, P_ITEM_STRUCTURE_ID, P_CONC_REQUEST_ID, P_GL_NUM, P_VIEW_COST, P_CURRENCY_CODE, and various accounting and item segment holders — which are populated by the Oracle Reports/XML Publisher runtime before the report layout is executed. The package operates with AUTHID CURRENT_USER, meaning its SQL is resolved against the invoking schema's privileges, a standard characteristic of EBS XML Publisher report packages.

Key Procedures and Functions

• BEFOREREPORT — A Boolean function invoked by the report runtime before report execution. It performs pre-report initialization such as resolving report parameters and session context required for the query.
• AFTERREPORT — A Boolean function invoked after the report body has been produced. It is used for post-processing cleanup and for finalizing any report-level state.
• ITEM_PSEGFORMULA — A character formula function that accepts an item segment, item name, and previous segment, and returns a formatted segment string. It supports derivation of concatenated flexfield/item segment display values within the report output.
• CP_ORG_NAME_P — A function returning the current organization name (CP_ORG_NAME), used to expose the operating unit/organization context to the report layout.

Note that P_ITEM_STRUCTURE_ID, the value the user searched for, is declared here as a global package variable rather than a formal parameter of any documented procedure.

Tables Accessed

Per the documented metadata, the package references FND_CURRENCIES through an APPS synonym. This table supplies valid currency definitions and is used to validate and resolve the report's P_CURRENCY_CODE parameter, which defaults to 'USD'. No other tables are documented as being referenced directly by the package itself; the primary data extraction for the report is typically performed by the XML Publisher data definition or associated query, not within this package body.

Usage Notes

This package is not an application programming interface and is classified as OTHER. It is invoked indirectly by the Oracle EBS concurrent manager when the associated XML Publisher cost rollup item structure report is submitted from the Cost Management responsibility or via the Submit Requests form. Because the package is generated and regenerated by the XML Publisher report definition, it should not be called from custom code, nor should its globals be relied upon outside the report's execution context. Customizations should instead target the underlying report definition and data model. The absence of dependencies (referenced by 0 other packages) confirms that it is a terminal, report-scoped artifact within the EBS 12.1.1 and 12.2.2 file systems.