Search Results p_phys_inv_id

Overview

INV_INVARPTS_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite Oracle Reports executable associated with the physical inventory variance and adjustment report (the "INVARPTS" report). In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (XMLP) and Oracle Reports report definitions are wrapped by a package whose body contains the report-level triggers and formula columns referenced from the .rdf report layout. The package is owned by APPS and classified as OTHER in the ETRM metadata, indicating it is not a public API and is not intended for direct invocation by other code; the metadata records zero dependent packages referencing it.

The business purpose of the package is to supply the runtime logic needed by the physical inventory variance and adjustment report: establishing the concurrent request context, resolving the physical inventory name from the user-entered physical inventory identifier, and computing percentage-based adjustment and variance metrics used in the report output. Because the report is driven by parameters such as the physical inventory ID, the package exposes the functions that translate those identifiers into descriptive report values.

The user search term p_phys_inv_id reflects the report parameter that identifies the physical inventory to be reported on. This parameter is consumed directly by the package's name-resolution function, which is the principal link between the report's parameter form and the report's data.

Key Procedures and Functions

• BEFOREREPORT — Standard Oracle Reports "Before Report" trigger. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID and assigns it to the package-level variable P_CONC_REQUEST_ID. The FND SRWINIT user exit calls appear commented out in the source, and the routine returns TRUE on success.
• AFTERREPORT — Standard Oracle Reports "After Report" trigger. It is the counterpart to BEFOREREPORT and returns TRUE; the FND SRWEXIT user exit invocation is likewise commented out in the documented source.
• C_CURRENCY_CODEFORMULA — Formula column that formats a currency code by enclosing the supplied currency code value in parentheses.
• C_PHYS_INV_NAMEFORMULA — Formula column that resolves the physical inventory name. It reads the package parameter P_ORG_ID and the report parameter P_PHYS_INV_ID, queries MTL_PHYSICAL_INVENTORIES for the matching organization and physical inventory, and returns the PHYSICAL_INVENTORY_NAME. A NO_DATA_FOUND exception returns NULL.
• C_ADJ_PCTFORMULA — Formula column that computes an adjustment percentage by dividing an adjustment value by a count value, multiplying by 100, and rounding to two decimal places. Errors return NULL.
• C_VAR_PCTFORMULA — Formula column that computes a variance percentage from an absolute variance value and a count value, rounded to two decimal places, with NULL returned on error.
• C_ADJ_PCT_SUMFORMULA — Formula column that produces the summarized adjustment percentage across the report's aggregated rows.
• C_VAR_PCT_SUMFORMULA — Formula column that produces the summarized variance percentage across the report's aggregated rows.
• C_WHERE_OPTIONFORMULA — Formula column that returns the lexical WHERE clause fragment selected by the report's "where option" parameter, used to switch between report filter variants.
• C_NUM_TAGSFORMULA — Formula column that returns the count of physical inventory tags associated with the reported physical inventory.

Tables Accessed

The package references two application tables through APPS synonyms:

• MTL_PHYSICAL_INVENTORIES — Queried by C_PHYS_INV_NAMEFORMULA to translate the physical inventory ID and organization ID into the physical inventory name displayed on the report.
• MTL_PHYSICAL_INVENTORY_TAGS — Underlies the tag count logic exposed by C_NUM_TAGSFORMULA, providing the number of tags defined for the physical inventory.

No inserts, updates, or deletes against these tables are documented; the package is a read-only reporting component.

Usage Notes

The package is invoked indirectly by the Oracle Reports runtime when the physical inventory variance and adjustment report is run from the Submit Requests form or the Physical Inventory form in Oracle Inventory. It is not an API: no other documented package references it, and the routines are intended to be called only by the associated report definition. The p_phys_inv_id parameter searched by the user is the value passed from the report parameter form into C_PHYS_INV_NAMEFORMULA and the report's query predicates. Customizations should be applied by copying the report definition rather than by modifying this generated package, since its contents are regenerated whenever the report is compiled against the database.