Search Results p_order_item

Overview

APPS.INV_INVARPSL_XMLP_PKG is the generated PL/SQL package body that backs the Oracle EBS Oracle Reports executable for the Inventory physical inventory report (report short name INVARPSL). In Oracle EBS 12.1.1 and 12.2.2, concurrent programs based on Oracle Reports are wrapped in an automatically generated XML Publisher (XMLP) package that supplies report-level formula columns, format triggers, and Before/After Report logic. This package is the runtime container for that logic for the Inventory physical inventory listing report.

The package is classified as API classification OTHER, meaning it is not a public, supported business API. It exists solely to service the report's execution, providing the calculations and database lookups that the report layout references. The $.pls header comment indicates the source file INVARPSLB.pls at version 120.1 (2007/12/25), and the "noship" designation confirms it is a seeded, non-customer-modifiable object. The user search term "p_order_item" does not correspond to any documented procedure or function in this package; it is likely referenced by a related report parameter or by the report's XML data model rather than exposed in this metadata.

Key Procedures and Functions

Twelve procedures and functions are documented for this package:

• C_TOTAL_VALUEFORMULA — A formula function that computes the total value of inventory on hand by combining quantity and cost, rounded to the standard precision supplied by the report. It multiplies quantity by cost and applies rounding to the report's standard precision setting.
• BEFOREREPORT — The Before Report trigger. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, initializes the report environment, and sets the organization profile context used by the report query.
• AFTERREPORT — The After Report trigger, which performs cleanup and any post-processing required when report execution completes.
• C_ORDER_BYFORMULA — A formula function that supplies the ordering clause used by the report query, allowing the report layout to control row sequencing.
• C_CAT_SET_NAMEFORMULA — A formula function that resolves and returns the category set name associated with the report's category data.
• C_PHYS_INV_NAMEFORMULA — A formula function that returns the physical inventory name for the reporting context.
• C_CURRENCY_CODEFORMULA — A formula function that derives and returns the currency code applicable to the costing amounts displayed on the report.
• AFTERPFORM — The After Parameter Form trigger, used to validate or transform user-supplied report parameters before the main query executes.
• GET_P_STRUCT_NUM — A function that retrieves the structure number used to key the report data; the Before Report logic verifies that this initialization succeeded.
• CF_OUTERMOST_LPNFORMULA — A formula function producing the outermost license plate number for the reported inventory unit, supporting warehouse management LPN reporting.
• CF_PARENT_LPNFORMULA — A formula function producing the parent license plate number for the reported inventory unit.
• CF_COST_GROUPFORMULA — A formula function returning the cost group associated with the reported inventory quantity.

Tables Accessed

The package reads from four tables through APPS synonyms:

• CST_COST_GROUPS — Supplies cost group definitions used by CF_COST_GROUPFORMULA and related costing value calculations.
• MTL_CATEGORY_SETS — Provides category set metadata used by C_CAT_SET_NAMEFORMULA and by the report's category ordering.
• MTL_PHYSICAL_INVENTORIES — Holds physical inventory definitions and status, used by C_PHYS_INV_NAMEFORMULA to label the report.
• WMS_LICENSE_PLATE_NUMBERS — Provides license plate number records for the outer LPN and parent LPN formula columns, relevant when Warehouse Management is installed.

Usage Notes

This package is referenced by zero other packages; it is not an entry point for custom code. It is invoked exclusively by the Oracle Reports runtime when the INVARPSL concurrent program is submitted, either directly by users or through the physical inventory workflows. The Before Report function depends on FND_GLOBAL.CONC_REQUEST_ID, so it must run within a concurrent manager session. Customizations should not modify this package body, as it is regenerated and overwritten by patching; report layout or query changes should be applied through supported report customization techniques or by extending the underlying SQL, not by editing this package.