Search Results cf_outermost_lpnformula

Overview

The APPS.INV_INVARCPA_XMLP_PKG package is a PL/SQL wrapper package associated with the Oracle EBS Inventory report Inventory Replenishment / Receiving Accounting family (the "INVARCPA" concurrent program). It is declared with AUTHID CURRENT_USER and is generated by Oracle XML Publisher (BI Publisher) to bind a concurrent program's XML data template to the underlying SQL query and to expose user-defined "formula" columns to the report layout. In practice, the package encapsulates the report's bind parameters, before/after report triggers, and row-level formatting functions that the RTF or XSL-FO template calls at runtime.

Its primary business function is to support the reporting of inventory container and cost-group information for a specified organization, enriching raw inventory transaction rows with human-readable currency, container (LPN), and cost group descriptions used in the printed output.

Key Procedures and Functions

The package exposes eight documented functions. Package-level variables such as P_CONC_REQUEST_ID, ORGANIZATION_ID, P_SORT_OPTION, P_QTY_PRECISION, and P_WMS_INSTALLED are initialized by the concurrent manager and consumed by the report query.

• BEFOREREPORT — Executes setup logic prior to the report query, typically populating global parameters and determining organization context.
• AFTERPFORM — Runs after the report parameter form is processed, adjusting parameters such as sort options and precision before data retrieval.
• AFTERREPORT — Post-processing trigger executed after the data set is complete, used for cleanup and final formatting.
• C_FORMATTEDCURRENCYCODEFORMULA — Accepts a currency code and returns a formatted currency string for display in the report output.
• C_ORDERBYFORMULA — Returns the ORDER BY clause string used to sort the report results dynamically based on the selected sort option.
• CF_OUTERMOST_LPNFORMULA — Returns the outermost License Plate Number (LPN) description for a container, honoring the WMS container-enabled flag.
• CF_PARENT_LPNFORMULA — Returns the parent LPN description for nested containers, used in hierarchical container reporting.
• CF_COST_GROUPFORMULA — The function corresponding to the user's search term "cf_cost_groupformula"; it accepts a COST_GROUP_ID and returns the descriptive cost group name for display.

Tables Accessed

Two APPS-synonymed tables are referenced by this package:

• CST_COST_GROUPS — The cost group definition table, read by CF_COST_GROUPFORMULA to translate a numeric cost group identifier into its descriptive name. Cost groups are a core construct in Oracle Cost Management, used to categorize and default costs on items and transactions.
• WMS_LICENSE_PLATE_NUMBERS — The Warehouse Management System LPN master table, read by CF_OUTERMOST_LPNFORMULA and CF_PARENT_LPNFORMULA to resolve container identifiers into license plate numbers and to traverse the parent/child container hierarchy.

Usage Notes

This package is not intended for direct invocation by custom code; it is generated and managed by Oracle's XML Publisher and Concurrent Manager frameworks. It is referenced by zero other packages within the ETRM 12.2.2 metadata, confirming it functions as a leaf-level report support artifact. Typical invocation occurs when the associated concurrent program is submitted from the Inventory responsibility, or scheduled via the standard concurrent request submission APIs. The AUTHID CURRENT_USER declaration means execution is performed with the privileges of the invoking user rather than the APPS schema owner, an important consideration when diagnosing permission-related runtime failures. Because the package name and functions are generated, they should be treated as Oracle-owned and not modified, as changes may be overwritten during patching or upgrades between 12.1.1 and 12.2.2.