Search Results p_catg_flexdata

Overview

The APPS.INV_INVIRXRF_XMLP_PKG package is a generated Oracle Reports PL/SQL library package associated with the Oracle Inventory (INV) XML Publisher report executable INVIRXRF. Its purpose is to support the "Item Cross-Reference Report" in Oracle E-Business Suite, a concurrent program that extracts and prints cross-reference relationships defined between inventory items and external identifiers such as manufacturer part numbers, customer part numbers, supplier part numbers, and substitute items. In ETRM the object is classified as OTHER (a report-support package rather than a public API), owned by the APPS schema and shipped with version header 120.1.

Because the report is authored in Oracle Reports, the package essentially acts as the server-side anchor for the report's user parameters and format triggers. The numerous package-level variables declared in the specification are the report's bind parameters, populated at runtime from the concurrent program's parameter form and passed into the report query. The user search term p_catg_flexdata maps directly to the variable P_CATG_FLEXDATA VARCHAR2(480), which carries the concatenated, comma-delimited key flexfield segment values for the category flexfield used to filter the report by item category.

Key Procedures and Functions

• BEFOREREPORT — Executes prior to the report's main query and layout processing. It initializes session-level state, derives the flexfield WHERE clauses and sort orders (for example the category and item flexfield predicates), and prepares the value lists that the report consumes at runtime.
• AFTERPFORM — Runs after the parameter form is submitted but before the main data query is executed. It is the mechanism through which report parameters such as P_CATG_FLEXDATA, P_CATG_STRUCT_ID, P_CATG_SET_ID, and the LO/HI range pairs are validated and normalized for use in the SELECT statement.
• C_XREF_TYPE_MARG_FORMULAFORMUL — A format trigger formula at the report level, used to derive display content related to the cross-reference type (the P_XREF_TYPE parameter) rendered on the report output.
• C_ORG_INDPFORMULA — A format trigger formula that evaluates the organization indicator supplied by the report to control conditional display of organization-dependent columns or sections.
• C_ORG_INDP1FORMULA — A companion format trigger formula providing a second organization-indicator evaluation, typically used where the report distinguishes between multiple organization contexts (for example, current organization versus the item's owning organization).
• AFTERREPORT — Executes after report output generation completes. It performs post-processing and cleanup, releasing report-level state established in BEFOREREPORT.

Tables Accessed

The ETRM metadata for this package records no directly referenced tables through APPS synonyms. This is expected: the package is populated with report bind variables and format triggers, while the actual SELECT statements against Inventory cross-reference entities — such as the item cross-reference table and item master/category assignment tables — reside in the Oracle Reports definition (the .RDF file compiled into INVIRXRF), not in the PL/SQL package itself.

Usage Notes

This package is not intended for direct invocation by customer code; no other packages reference it. It is invoked implicitly when the associated concurrent program or Oracle Reports executable runs. Because it is regenerated whenever the report is recompiled, extensions should be applied in a custom copy rather than by modifying the seeded package. When troubleshooting the p_catg_flexdata parameter, note that the value arrives as a 480-character concatenated flexfield string, and its interpretation depends on P_CATG_STRUCT_ID and P_CATG_SET_ID; discrepancies in the category filter are therefore most often traceable to these companion parameters or to the derived P_CATG_WHERE clause rather than to the variable's declaration. The same pattern applies to the item flexfield parameters (P_ITEM_FLEXDATA, P_ITEM_WHERE, P_ITEM_ORDER_BY).