Search Results p_icg_hi




Overview
Explore in AI Chat

Overview

INV_INVIRITS_XMLP_PKG is the generated package body that backs the Oracle EBS concurrent program report "INVIRITS" (Inventory Item Detail / item summary style XML Publisher report). In Oracle EBS 12.1.1 and 12.2.2 the report runs through the Oracle Reports / XML Publisher integration stack, and the report's PL/SQL library logic is packaged as an APPS-owned PL/SQL package. The header comment ($Header: INVIRITSB.pls 120.2 2011/06/30) confirms this is a standard Oracle-shipped file, and the object is classified as "OTHER" because it is not a formal public API but rather a report-support package used only by the INVIRITS concurrent program and its report definition.

The package's central responsibility is to establish report execution context (concurrent request ID, initialization and cleanup of the Reports user exit), to resolve flexfield query fragments at runtime, and to supply group/column values to the XML Publisher layout. Sorting and parameter handling revolve around P_SORT_ID, which drives the branching logic in the Before Report trigger.

Key Procedures and Functions

  • BEFOREREPORT — Executes the report's Before Report trigger. It assigns P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID, performs SRW init, evaluates parameter blocks for the category (MCAT), inventory item catalog group (ICG) and item ranges, and uses P_SORT_ID to decide which flexfield select/where fragments are built. When P_SORT_ID = 2 the category flexdata select is exercised; when P_SORT_ID = 3 the ICG flexdata select is exercised. Otherwise the corresponding flexdata tokens (P_CATG_FLEXDATA := '''MCAT''', P_ICG_FLEXDATA := '''ICG''') are populated literally.
  • AFTERREPORT — Executes the After Report trigger and performs SRW exit / cleanup, returning TRUE. All user-exit calls are wrapped in exception handlers so report failures are trapped without aborting the concurrent request unexpectedly.
  • BEFOREPFORM — Before Report (pre-format / parameter form) processing hook.
  • C_FROMFORMULA, C_WHEREFORMULA — Formula columns returning the FROM and WHERE SQL fragments used by the report query.
  • C_CATG_FROMFORMULA, C_CATG_WHEREFORMULA, C_CAT_SET_NAMEFORMULA — Formula columns returning the category flexfield FROM/WHERE fragments and the category set name.
  • C_ICG_FROMFORMULA, C_ICG_WHEREFORMULA, C_ICG_DESCFORMULA — Formula columns returning the item catalog group FROM/WHERE fragments and its description.
  • C_CURRENCY_CODEFORMULA — Formula column returning currency code display value.
  • C_BREAK_OPTION_PADFORMULA, C_BREAK_OPTION_PAD_F, C_BREAK_OPTION_VALUE_F — Formula/helper functions that compute break-option padding and break-option display values used by the report layout.

Tables Accessed

The documented table reference is MTL_CATEGORY_SETS (via APPS synonym), read to resolve the category set name and its associated key flexfield structure when building the MCAT/ICG flexfield SQL fragments. Additional item and category views are referenced indirectly through dynamic FlexSQL against the key flexfield views, but MTL_CATEGORY_SETS is the sole documented base table.

Usage Notes

INV_INVIRITS_XMLP_PKG is not called directly by custom code; it is invoked implicitly by the INVIRITS concurrent program when the report is submitted. Parameters such as P_SORT_ID, P_CATG_LO, P_CATG_HI, P_ICG_LO, P_ICG_HI, P_ITEM_LO, and P_ITEM_HI are supplied through the concurrent program parameter form and exposed to the Before Report trigger. Sorting behavior is controlled by P_SORT_ID, so customizing report output should be done by adjusting parameter values or the underlying report definition rather than by modifying this locked Oracle package.