Search Results p_displaycumvalue




Overview
Explore in AI Chat

Overview

INV_INVARADV_XMLP_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is the generated report-supporting package associated with an Oracle Reports XML Publisher (BI Publisher) concurrent program in the Inventory module, referenced in the source header as INVARADVB.pls. The "INVARADV" naming convention indicates an Inventory valuation or inventory advices report, and the presence of predefined report trigger functions such as BEFOREREPORT, AFTERREPORT, and AFTERPFORM confirms that the package was generated to sit behind a Reports-based XMLP definition. Its role is to supply report-level initialization logic, formula columns, and derived display values that the report layout invokes at runtime. The package contains no persistent business logic or DML; it is a thin, report-specific wrapper. The API classification is OTHER, meaning Oracle does not expose it as a public or supported programmatic interface.

Key Procedures and Functions

  • C_FORMATTEDCURRENCYCODEFORMULA — A formula column function that accepts a currency code and returns the same value wrapped in parentheses, producing the "(USD)"-style formatting commonly used on currency-labelled report columns. This is the object the user searched for; it exists solely to decorate the report output and performs no validation or lookup.
  • BEFOREREPORT — The BeforeReport trigger. It populates the concurrent request ID from FND_GLOBAL, derives quantity precision through the shared inventory package inv_common_xmlp_pkg, and in the original Reports form invoked the FND SRWINIT user exit. It returns a Boolean success flag.
  • AFTERREPORT — The AfterReport trigger, originally paired with the FND SRWEXIT user exit, used to release report resources after output generation. It returns a Boolean flag.
  • VAR_BOILERPLATEFORMULA — A formula column function that inspects the P_DISPLAYCUMVALUE parameter and substitutes the incoming base value with the literal display texts " Cum Value" or " Cum Quantity" when cumulative display is requested; otherwise it passes the supplied value through unchanged.
  • AFTERPFORM — The AfterParameterForm trigger. In this package it is an empty stub returning TRUE, retained for structural compatibility with the generated report template.

Tables Accessed

The package body performs no direct SQL against application tables. All data retrieval for the report is handled by the underlying report query or by the shared inventory report package invoked during BeforeReport. Because the source contains only SRW.REFERENCE calls and simple string manipulation, no APPS synonyms are dereferenced from within this package. Any inventory tables the report reads belong to the associated report definition and its query, not to this PL/SQL unit.

Usage Notes

INV_INVARADV_XMLP_PKG is not intended for direct invocation by custom code. It is called automatically by the Oracle Reports runtime engine when the associated inventory advices or valuation XMLP concurrent program executes. The report engine calls BEFOREREPORT, AFTERPFORM, and AFTERREPORT at the appropriate trigger points and calls the two formula functions once per report row for their respective columns. Customizations should target the underlying report definition or the shared inv_common_xmlp_pkg, not this generated body, since regeneration of the report will overwrite any manual edits. The package is documented as referenced by zero other packages, confirming its narrow, report-scoped usage. Because it is classified as OTHER and is marked noship in its header, it should be treated as internal Oracle implementation rather than a supported extension point.