Search Results p_catg_structure_id




Overview
Explore in AI Chat

Overview

INV_INVIRITS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS and classified as OTHER. It is a report logic package associated with an Oracle Reports XML Publisher (XMLP) concurrent program in the Oracle Inventory module. The "INVIRITS" naming corresponds to the Inventory Item Categories or Item Listing style of concurrent report, which allows users to extract item and category information filtered and displayed according to runtime report parameters. ETRM 12.2.2 records this package with 15 documented procedures and functions, all of which serve the standard XMLP report lifecycle.

Like other _XMLP_PKG packages in EBS, this package is declared with AUTHID CURRENT_USER and acts as the server-side container that holds global report parameters, resolves dynamic SQL fragments, and provides formatted values to the Oracle Reports XML data model.

The mentioned "c_icg_descformula" is one of the documented formula functions — specifically C_ICG_DESCFORMULA.

Key Procedures and Functions

  • BEFOREREPORT — Initializes global report parameters and prepares the runtime environment before the main query executes.
  • AFTERREPORT — Performs post-processing cleanup after the report body is generated.
  • BEFOREPFORM — Executes logic in advance of the report's parameter/formula phase, typically resetting or validating parameter state.
  • C_FROMFORMULA — Returns the FROM clause fragment of the dynamically built SQL statement.
  • C_WHEREFORMULA — Returns the WHERE clause fragment used to filter the main query.
  • C_CAT_SET_NAMEFORMULA — Supplies the descriptive name of the selected category set for display.
  • C_CATG_FROMFORMULA — Returns the FROM clause segment for the category-related query block.
  • C_CATG_WHEREFORMULA — Returns the WHERE clause predicate for the category block.
  • C_ICG_FROMFORMULA — Returns the FROM clause for the Item Category Group (ICG) query block.
  • C_ICG_WHEREFORMULA — Returns the WHERE clause for the Item Category Group query block.
  • C_ICG_DESCFORMULA — The function corresponding to the search term "c_icg_descformula". It builds the concatenated description of the ICG flexfield segments (SEGMENT1 through SEGMENT15) for formatted output, using the P_ICG_FLEXDATA global as its concatenation template.
  • C_CURRENCY_CODEFORMULA — Returns the functional or report currency code to the layout.
  • C_BREAK_OPTION_PADFORMULA — Provides padding logic for the break option value.
  • C_BREAK_OPTION_PAD_F — Helper for the break option formatting behavior.
  • C_BREAK_OPTION_VALUE_F — Returns the resolved value of the report break option.

Tables Accessed

ETRM documentation records a single referenced table, accessed through an APPS synonym: MTL_CATEGORY_SETS. This table defines category sets and their associated structures and is required because the report filters and displays category information. The global variables P_CATG_STRUCTURE_ID, P_CATG_SET_ID, and P_SORT_ID, together with P_STRUCT_NUM, are populated from this table at report runtime. Although only MTL_CATEGORY_SETS is explicitly documented, the dynamic SQL fragments built by the C_*FORMULA functions reference item and category flexfield views such as MTL_SYSTEM_ITEMS and MTL_ITEM_CATEGORIES through their MCAT and ICG aliases.

Usage Notes

INV_INVIRITS_XMLP_PKG is not invoked directly by forms or custom code. It is called exclusively by the Oracle Reports XML Publisher executable during execution of the associated Inventory concurrent program. ETRM records that the package is referenced by zero other packages, confirming it is a leaf reporting module.

The global variables defined in the package — including P_ORG, P_CONC_REQUEST_ID, P_CATG_LO, P_CATG_HI, P_CATG_FLEXDATA, P_ICG_FLEXDATA, P_ICG_WHERE, and P_DESC_OPTION — act as the shared parameter state populated from the concurrent program's parameter form. The C_*FORMULA functions are called by the report's data model to render WHERE clauses, FROM clauses, and display descriptions, with C_ICG_DESCFORMULA specifically producing the concatenated ICG segment description when the reporting layout requires it.

Because the package uses AUTHID CURRENT_USER, it executes with the privileges of the invoking APPS session. From an upgrade and customization perspective, the package is delivered as an APPS object and should be treated as read-only; any need for additional reporting filters is normally met by modifying the concurrent program's parameters or by creating a separate custom report package rather than altering this one.