Search Results p_catg_struct_id

Overview

INV_INVIRCAT_XMLP_PKG is a public PL/SQL package owned by the APPS schema that supports the Oracle Inventory concurrent report "Item Categories" (internal name INV_INVIRCAT). The report is a multi-organization, XML Publisher–based listing of inventory items grouped and sorted by a chosen item category structure and category set, and it is one of the standard diagnostic and review tools used by inventory managers, category administrators, and implementation teams in EBS 12.1.1 and 12.2.2.

The package performs the classic role of an XML Publisher concurrent program wrapper. It declares a set of global package-level variables that correspond directly to the report's concurrent program parameters and holds the SQL fragments and formatting values derived from those parameters. The most significant of these globals is P_CATG_STRUCT_ID, which stores the identifier of the category structure selected at run time; related globals include P_CATG_SET_ID, P_CATG_WHERE, P_CATG_HI, P_CATG_LO, and P_CATG_ORDER_BY, along with item-side globals such as P_ITEM_NUM, P_ITEM_FLEXDATA, and P_ITEM_WHERE. The package also exposes P_CONC_REQUEST_ID (defaulted to 0), the standard request identifier passed by the concurrent manager.

Business use is typically regulatory and operational review: verifying that items are correctly assigned to categories within a specific structure or category set, auditing category assignments across organizations, and producing printable category listings. The header version ($Header: INVIRCATS.pls 120.2, dated 2008/01/08) indicates a long-stable, low-change code line.

Key Procedures and Functions

Three documented functions are exposed, all of which return BOOLEAN and follow the standard Oracle Reports XML Publisher PL/SQL interface:

• BEFOREREPORT — Executed before the report's data model query is parsed and run. It is the standard hook for initializing fnd_global context, resolving the selected category structure and category set identifiers, and populating the package globals that are subsequently referenced by the report's query. It is commonly used to derive the WHERE and ORDER BY fragments (including P_CATG_WHERE and P_CATG_ORDER_BY) and to set the request-independent values needed by the XML data template.
• AFTERPFORM — Executed after the report's parameter form is processed but before the data model executes. It is used to validate, default, or transform the entered concurrent program parameters, for example widening or normalizing category and item ranges, or deriving dependent values from the category structure ID.
• AFTERREPORT — Executed after the report output is generated. It is typically used for post-processing such as restoring session state, releasing resources, or final cleanup.

No parameter lists for these functions are documented in the ETRM metadata; the declarations are retained in the package specification as BOOLEAN-returning functions, as is customary for Oracle Reports–registered PL/SQL libraries.

Tables Accessed

The ETRM metadata provided documents no base tables directly referenced through APPS synonyms by this package. This is consistent with the design of XML Publisher report wrappers: the package specification holds the PL/SQL logic and parameter validation, while the report's data is retrieved by the concurrent program's query, which in this case is defined against the item category assignment tables — principally MTL_CATEGORY_SETS, MTL_CATEGORIES, MTL_CATEGORY_SETS_VL, MTL_ITEM_CATEGORIES, MTL_SYSTEM_ITEMS, and the category set / structure definition tables referenced via P_CATG_SET_ID and P_CATG_STRUCT_ID values supplied by the user.

Because the package's APPS-schema visibility is broad, any tables it would query at run time are resolved through APPS synonyms for the corresponding MTL_% base objects. The absence of documented table references should be treated as a metadata gap rather than an indication that the report reads no data.

Usage Notes

INV_INVIRCAT_XMLP_PKG is invoked implicitly by the Oracle Inventory Item Categories concurrent program. The concurrent manager calls the report definition and its associated PL/SQL library; the three functions execute automatically at their designated points in the Oracle Reports execution cycle. End users and developers do not normally invoke this package directly.

The user search term "p_catg_struct_id" refers to the category structure identifier parameter reflected in the package global P_CATG_STRUCT_ID (NUMBER). Users selecting a category structure on the concurrent program's parameter form are effectively supplying the value that the package stores and passes to the report query; the values are used to filter category assignments to a single structure. While the package is intentionally narrow in scope, the Category Structure parameter is the primary driver of report output because it determines which category set and hierarchy the report traverses.

Customization is generally discouraged. If extension is required, Oracle's supported approach in 12.1.1 and 12.2.2 is to copy the report and PL/SQL library to a custom application and register a new concurrent program, leaving the seeded APPS package unmodified to preserve patching and upgrade integrity.