Search Results itemcp_p

Overview

The APPS.GMF_GMFINVAL_XMLP_PKG package is the generated PL/SQL specification behind the Oracle Process Manufacturing (OPM) "Item Cost Comparison" style BI Publisher / XML Publisher report (report short name GMFINVAL, concurrent program output type XML). It belongs to the Process Manufacturing Financials family and is classified in ETRM as an OTHER API — meaning it is not a supported integration or public API, but rather the automatically produced package that accompanies an Oracle Reports/XML Publisher definition. The header comment ($Header: GMFINVALS.pls 120.0 ... krreddy noship $) confirms it was last versioned in 2007 and is shipped "noship", i.e. it is not a standalone patchable entity but is regenerated whenever the underlying report is edited.

The package exists to expose report parameters as package-level variables and to provide the data-formatting and lookup logic the XML template calls at runtime. It is the runtime container that holds the concurrent request context, the user-entered report parameters, and the derived cost values used by the template.

Key Procedures and Functions

The specification declares 18 program units. The lifecycle entry points are BEFOREREPORT, AFTERPFORM, and AFTERREPORT; these are the standard Report Builder triggers that initialize session state, run any pre-query defaults after the parameter form is submitted, and perform cleanup. HEADER populates the report header block (legal entity, organization, item range, currency and period descriptions).

The remaining units are formatting and derived-value functions. UNITCOSTCFFORMULA and TOTALCOSTCFFORMULA compute unit cost and total cost from item quantity and transaction data; BALANCECFFORMULA, CF_BASE_CURRENCYFORMULA, and LEGAL_ENTITY_NAME_CFFORMULA supply balance, base currency, and legal entity display values.

Four functions — ORGANIZATIONCPFORMULA, ITEMCPFORMULA, ITEMCFFORMULA, and ORGANIZATIONCFFORMULA — construct the dynamic WHERE-clause fragments used to filter the report by organization and item. This is the area most relevant to a search on "itemcp_p": the paired accessor functions ITEMCP_P, ORGANIZATIONCP_P, TOTALCOSTCP_P, UNITCOSTCP_P, and BALANCECP_P return the current values of the underlying package globals (ITEMCP, ORGANIZATIONCP, TOTALCOSTCP, UNITCOSTCP, BALANCECP). The "CP" convention denotes "constant/column parameter" placeholders that Oracle Reports substitutes into the query at runtime.

Tables Accessed

The package reads the following APPS synonyms: MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B for item and description lookups; MTL_PARAMETERS for organization defaults and currency context; CM_WHSE_ASC for warehouse/organization associations; GMF_FISCAL_POLICIES and GL_PLCY_MST for OPM fiscal calendar policy and legal entity mapping; and FND_CONCURRENT_REQUESTS to retrieve the concurrent request context captured in P_CONC_REQUEST_ID. All accesses are read-only; the package performs no DML.

Usage Notes

This package should not be invoked directly by custom code and is not referenced by any other package (ETRM records zero referencing objects). It is executed only when the associated OPM concurrent program/XML Publisher report is submitted from the OPM responsibilities. Because it is a generated "noship" artifact, any modification is overwritten on the next report patch, so extensions should be implemented through the underlying report definition rather than by altering this package. References to ITEMCP_P in code searches typically indicate the report template's data model, not a callable API.