Search Results cp_org_name_p

Overview

The APPS.BOM_CSTRIVTI_XMLP_PKG package body supports the Oracle EBS Bill of Materials (BOM) cost rollup and cost visibility reporting infrastructure. It is a generated XML Publisher (XMLP) wrapper package associated with a concurrent program that produces cost information output, most likely the "Cost Rollup" or "Item Costs" style report in the Discrete Manufacturing suite. The package header and body follow the standard Oracle Reports-to-XMLP conversion pattern, in which server-side report triggers are transformed into PL/SQL functions encapsulated within a package prefixed by the report name and suffixed with _XMLP_PKG. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, the body carries the $Header: CSTRIVTIB.pls 120.0 2007/12/24 identifier, confirming a longstanding file that has been stabilised across releases with no functional revisions since the 2007 baseline.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions in this package body:

• BEFOREREPORT — The report initialisation trigger. It resolves the functional currency and the reporting organisation by querying GL_SETS_OF_BOOKS and ORG_ORGANIZATION_DEFINITIONS, assigns the currency to the global P_CURRENCY_CODE parameter, derives the organisation name and a rounding unit (MINIMUM_ACCOUNTABLE_UNIT or a power-of-ten fallback based on currency precision), and sets P_CONC_REQUEST_ID. It also validates the P_VIEW_COST parameter, raising an application error when cost visibility is not requested.
• AFTERREPORT — The complementary teardown function, invoked after report generation completes. It performs the standard SRWEXIT equivalent to release report resources and returns a boolean completion flag.
• ITEM_PSEGFORMULA — A formula/formatting function specific to this report. It accepts an item segment value, item name, and an item pseudo-segment value, and returns the pseudo-segment string unchanged. This is the function referenced by users searching for item_psegformula, reflecting its role as the display formula for concatenated or derived item segment fields in the report layout.
• CP_ORG_NAME_P — A parameter accessor function returning the current organisation name value (CP_ORG_NAME) for use in the report data model and layout.

Tables Accessed

The ETRM metadata explicitly lists FND_CURRENCIES as a referenced table, accessed through the APPS synonym. It is joined in BEFOREREPORT to obtain currency attributes, including the precision used to compute the rounding unit applied to reported cost amounts. Additional tables referenced in the source excerpt — GL_SETS_OF_BOOKS and ORG_ORGANIZATION_DEFINITIONS — supply the functional currency code, organisation name, and set of books linkage for the requested P_ORG_ID. All access is read-only; the package does not modify application data.

Usage Notes

The package is invoked automatically whenever the associated BOM cost report concurrent program executes in XML Publisher mode. Users do not call it directly. Because the ETRM metadata records zero dependent packages, its exposure is confined to the report engine and to any custom concurrent program that explicitly reuses the ITEM_PSEGFORMULA formatting logic. Customisations that require a different pseudo-segment display should avoid modifying this seeded package and instead create a copy, since the file is flagged noship and is maintained by Oracle.