Search Results p_cat_hi

Overview

The APPS.INV_INVIRDIS_XMLP_PKG package body supports the Oracle EBS Inventory report "INVIRDIS" (Inventory Item Distribution), an XML Publisher (BI Publisher) based concurrent program that produces a distribution-oriented listing of inventory items and their associated category assignments. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher concurrent programs are implemented as PL/SQL packages whose functions supply runtime values to the data template and report definition. The package encapsulates the display logic for category flexfield selection, the WHERE-clause fragments applied to the underlying inventory queries, and the before/after report processing hooks required by the report engine.

The package is classified as an OTHER API under the APPS schema, meaning it is not part of the formally supported public API surface and is intended solely as internal runtime glue for the concurrent program. The search term "p_cat_hi" corresponds to the high category range parameter passed to this report; the package references this parameter within its BEFOREREPORT logic to determine whether a category range was supplied by the user.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions, each of which plays a specific role in constructing or validating the report at runtime.

• WHERE_STAT_EFF — Builds a SQL WHERE fragment restricting status records by effective date, based on the P_STAT_EFF parameter. When the parameter is null, an empty string is returned so that no date filtering is applied.
• WHERE_STATUS — Builds a WHERE fragment limiting results to a specific status code supplied through P_STATUS. A null parameter yields an empty predicate.
• BEFOREREPORT — The standard BeforeReport trigger. It initializes the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, evaluates the break group parameter, sets the category flexfield context (for example, 'MC'), and inspects the category and item range parameters such as P_CAT_LO and P_CAT_HI to decide how the category WHERE clause should behave.
• AFTERREPORT — The complementary AfterReport trigger, used to release resources and perform post-processing once the report query completes.
• C_CAT_FROMFORMULA — Returns the displayed "from" value for the category range in the report output.
• C_CAT_WHEREFORMULA — Supplies the WHERE-clause text that constrains the category flexfield segment based on the user's range selection.
• C_CAT_PADFORMULA — Performs padding of category values so that range comparisons align to the expected flexfield width.
• C_CAT_SET_NAMEFORMULA — Resolves and returns the category set name applied to the report's category flexfield.
• C_ITEM_PADFORMULA — Pads item values to the item flexfield width, supporting correct range comparison for item concatenated segments.
• AFTERPFORM — The AfterParameterForm trigger, executed after the user has supplied parameters but before the report query executes; it validates and finalizes parameter-derived values.
• C_MORG_IDFORMULA — Resolves the operating unit (organization) identifier used to scope the report to the correct inventory organization context.

Tables Accessed

Through APPS synonyms, the package's report queries reference the following documented tables:

• MTL_CATEGORY_SETS — Provides the definition of the category set (including the 'MC' set) used to constrain and label category ranges in the report output.
• MTL_ITEM_ATTRIBUTES — Supplies item-level attribute data included in the distribution listing.
• MTL_PARAMETERS — Supplies organization-level parameters, such as the organization code and default category set, used to contextualize and filter the report results.

These tables are read-only from the package's perspective; the package does not modify inventory data.

Usage Notes

This package body is invoked exclusively by the Oracle Reports/XML Publisher runtime when the INVIRDIS concurrent program is executed. It is registered as the PL/SQL library backing the report definition and is not called directly from forms, custom concurrent programs, or external code. Because it is classified as OTHER, it carries no supported API guarantee, and its internal structure may change between patch levels without notice.

When users launch the report and enter a high category value in the "p_cat_hi" parameter, BEFOREREPORT and the C_CAT_* formula functions cooperate to translate that selection into the appropriate WHERE fragment and padded comparison values. Administrators tuning the report should therefore focus on the category flexfield setup and the category set definition, since the package relies on those configurations to resolve range filters correctly.