Search Results p_item_hi

Overview

The APPS.INV_INVTRELT_XMLP_PKG package is the PL/SQL specification that supports the Oracle Inventory item-related XML Publisher (BI Publisher) concurrent report known internally as INVTRELT. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the package owner, a standard convention for XML Publisher report support packages in the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. The principal business function of the package is to hold the runtime bind variables and formatting parameters consumed by the report's data model and layout templates. Because the report is driven entirely by XML Publisher, the package does not build output text directly; instead it exposes public variables that the concurrent manager populates and the XML data template reads during report execution.

Key Procedures and Functions

The specification declares three report event functions, all of which return BOOLEAN in accordance with the Oracle Reports/XML Publisher PL/SQL API convention:

• BEFOREREPORT — the report-level initialization hook. It is invoked by the report engine before the data model query executes, and it is the point at which default values, session context, and derived parameters are resolved for the run.
• AFTERPFORM — the after-parameter-form hook. This function fires once the concurrent program's parameter form has been submitted, allowing the package to validate or transform the parameter values before the query is issued.
• AFTERREPORT — the teardown hook, executed after the report completes, used for any post-processing or cleanup logic associated with the report run.

The package also declares a substantial set of package-level variables that carry the parameter values into the report. These include P_ORG (operating unit), P_ITEM_FLEXDATA and P_ITEM_WHERE (item flexfield and dynamic WHERE fragments), P_LOCATOR_FLEXDATA, the expiration date pair P_EXPIRE_DATE and P_EXPIRE_DATE_1, the item range parameters P_ITEM_LO and P_ITEM_HI, P_CONC_REQUEST_ID, P_QTY_PRECISION, P_ITEM_ORDER_BY, P_SORT_ID, P_TRACE_FLAG, P_OPTIMIZER_CODE, and P_ITEM_NUM. The user query term p_locator_flexdata corresponds directly to the declared variable P_LOCATOR_FLEXDATA VARCHAR2(400), which holds the concatenated key flexfield segments (or the preparsed flexfield display string) used to filter stock locators in the report's query.

Tables Accessed

ETRM metadata for this package does not record any directly referenced tables through APPS synonyms. In practice, the underlying XML Publisher data template associated with the INVTRELT report performs the physical data access against the Inventory-related tables (item master, item locator, and transaction entities), while this package contributes only the bind values and the dynamic WHERE/ORDER BY fragments such as P_ITEM_WHERE and P_ITEM_ORDER_BY.

Usage Notes

The package is not invoked by other PL/SQL packages; the ETRM metadata confirms that it is referenced by zero other packages. It is invoked exclusively at runtime by the XML Publisher report engine when the INVTRELT concurrent program is submitted. Customizations should never modify the package body directly, since it is delivered under the APPS schema and would be overwritten by patching; instead, extend the report through the supported XML Publisher data template or a custom concurrent program that sets the same bind variables. Because the variables are declared at package level, they are session-scoped and are reinitialized on each concurrent request execution. The AUTHID CURRENT_USER clause must be preserved to allow the flexfield-related dynamic SQL to resolve correctly under the executing user's privileges.