Search Results c_adj_per_totformula




Overview
Explore in AI Chat

Overview

APPS.INV_INVARPIA_XMLP_PKG is the Oracle E-Business Suite PL/SQL package that backs the Physical Inventory Adjustments Report, a concurrent-program report generated from the Oracle Inventory module. The package belongs to the XML Publisher (BI Publisher) report framework, which is why its name carries the XMLP suffix and the header text file INVVARPIAS.pls. Its central purpose is to supply the report's data model with formatted values that cannot be produced by the report SQL query alone: physical inventory names, category set names, currency codes, category-level and total adjustment statistics, sort criteria, and padded category descriptions.

The package operates on a single-org or organization-aware basis. It declares public variables including P_ORG_ID, P_PHYS_INV_ID, P_STRUCT_NUM, P_CAT_STRUCT_NUM, P_ITEM_FLEX, P_CAT_FLEX, P_CATEGORY_SET_ID, P_LOC_FLEX, P_CONDITION, P_SORT_ID, P_QTY_PRECISION, P_CAT_SORT, P_ORDER_ITEM, P_CBO_FLAG, P_TRACE_FLAG, and P_INCLUDE_REJ_ITEMS, together with the associated rejection-item option and title fields. These variables hold parameter values passed by the concurrent program and are read by the formula functions during report rendering.

Key Procedures and Functions

The package exposes three lifecycle hooks and seven formula functions, each mapped to a report-level or cell-level calculation in the XML Publisher template.

  • BEFOREREPORT — Initialization logic executed before the report output is produced, typically setting up globals and derived values.
  • AFTERREPORT — Cleanup logic executed after the report completes.
  • AFTERPFORM — Post-parameter-form processing that runs after the concurrent program's parameters have been entered, used to prepare or default parameter-driven state.
  • C_PHYS_INV_NAMEFORMULA — Derives the display name of the physical inventory being reported.
  • C_CAT_SET_NAMEFORMULA — Derives the display name of the item category set.
  • C_CURRENCY_CODEFORMULA — Resolves a currency code for display purposes.
  • C_ADJ_PER_CATFORMULA — Computes adjustment values at the category level, producing a formatted result based on count and adjustment inputs.
  • C_ADJ_PER_TOTFORMULA — Computes the corresponding adjustment totals at the overall level.
  • C_SORTFORMULA — Produces the sort expression or sort label used to order report rows.
  • C_CAT_PADFORMULA — Produces the padded category value (the c_cat_pad field) that aligns category descriptions in the report layout. This function is the anchor for the search term c_cat_padformula.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • MTL_PHYSICAL_INVENTORIES — the base table for physical inventory definitions; used to resolve the inventory name and related scheduling or organizational attributes.
  • MTL_CATEGORY_SETS — the category set definition table; used to resolve category set names and structure identifiers.

Both tables are read-only within the context of this report package; the report performs no data manipulation.

Usage Notes

INV_INVARPIA_XMLP_PKG is invoked indirectly through the Physical Inventory Adjustments Report concurrent program in Oracle Inventory. The report's XML template calls the formula functions to populate derived columns. It is not referenced by any other PL/SQL package, so its interface is consumed exclusively by the XML Publisher data model. Customizations should avoid modifying the package directly; instead, create a copy of the template and extend via supported report hooks. Because the package still carries the "noship" header marker, its internal variable names and signatures should be treated as non-public API.