Search Results c_cat_set_nameformula

Overview

The package APPS.INV_INVIRSLO_XMLP_PKG is the PL/SQL package body that backs an Oracle Inventory XML Publisher (BI Publisher) concurrent report. The suffix _XMLP_PKG identifies it as a report-support package, automatically generated from an Oracle Reports (RDF) definition and re-pointed at an XML Publisher data template. The report it serves is the Inventory Item Subinventory Listing with lot and serial detail — the INVIRSLO report — used to produce a printable record of on-hand stock held across one or more subinventories, broken out by category set, item, and, where applicable, lot and serial attributes.

As with all *_XMLP_PKG units, the package does not itself execute the query logic. Instead, it declares global variables bound to the report's concurrent program parameters, and exposes a small set of functions invoked by the XML Publisher template and by the report trigger framework. These functions perform parameter cleanup, build dynamic SQL fragments for lexical (system-parameter) substitution, and run any pre-report initialization needed before the data model is fetched. At runtime the package executes under AUTHID CURRENT_USER, so it inherits the privileges of the invoking schema (typically APPS) and resolves database objects through APPS-owned synonyms.

Key Procedures and Functions

• BEFOREREPORT — The main pre-report trigger. It initializes global state and validates or defaults report parameters before the XML data model is run.
• AFTERREPORT — The post-processing trigger, called after the report output is generated; typically used to release or reset global state.
• C_CAT_SET_NAMEFORMULA — Returns the display name of the selected category set. It derives that name from the MTL_CATEGORY_SETS table using the category set identifier held in P_CAT_SET_ID, so the report header and grouping labels show a meaningful category set name rather than a numeric ID.
• C_SUBINV_WHEREFORMULA — Returns a SQL predicate fragment used to restrict the report by subinventory. It leverages the low and high subinventory parameters (P_SUBINV_LO and P_SUBINV_HI) to support a range or single-value selection.
• C_ITEM_PADFORMULA — Accepts an incoming item value and returns a formatted result, applying the padding/formatting behavior defined for the item flexfield. It ensures that concatenated flexfield segments align correctly in the report output.
• BEFOREPFORM — The "before parameter form" trigger, executed when the concurrent program's parameter entry form is displayed; it is the conventional hook for setting up dependent parameter behavior or default values.

Tables Accessed

Per the documented metadata, the package references MTL_CATEGORY_SETS via an APPS synonym. This access supports the C_CAT_SET_NAMEFORMULA function, which resolves the human-readable category set name from the category set identifier supplied as a report parameter. No other base tables are documented as referenced by the package itself; the bulk of transaction and on-hand data retrieval is performed by the XML Publisher data template and its underlying view or query, not by this PL/SQL unit.

Usage Notes

INV_INVIRSLO_XMLP_PKG is not intended for direct invocation from forms or custom code. It is invoked exclusively by the Oracle Inventory concurrent program that runs the INVIRSLO XML Publisher report. When a user submits that report from the Inventory responsibility, the concurrent manager calls the report's executable, which in turn triggers BEFOREPFORM while the parameter form is open, BEFOREREPORT before data retrieval, and AFTERREPORT after output generation. The C_* formula functions are called in-line by the data template to compute derived display values.

Because the package is generated and owned by APPS, customizations should never be applied directly to it; they would be overwritten by patching. For a custom report variant, the supported approach is to copy the package to a custom schema and modify the copy. Consult MTL_CATEGORY_SETS for category set definitions and confirm the concurrent program definition in the Inventory module when troubleshooting report parameter behavior.