Search Results p_wms_installed

Overview

The package body APPS.INV_INVARCPA_XMLP_PKG serves as the supporting PL/SQL library for the Oracle E-Business Suite concurrent program and Oracle Reports (XML Publisher) output associated with the Inventory Accounting Period Close/Reconciliation report — internally referenced as the INVARCPA report. It encapsulates the report-level trigger logic and column-level formula functions that Oracle Reports generates and requires when publishing a report through the XML Publisher (BI Publisher) integration in EBS 12.1.1 and 12.2.2. The package is classified under ETRM as OTHER, reflecting that it is a generated report-support package rather than a public application programming interface.

The package's central responsibilities are threefold: it establishes the concurrent request context and organization profile at report startup, it resolves reporting values such as formatted currency codes, ordering clauses, and license plate number (LPN) attributes on a per-row basis, and it detects whether Oracle Warehouse Management (WMS) is installed so that the report can conditionally render LPN-related columns. The last capability is directly associated with the search term p_wms_installed, a package-level global variable populated at runtime.

Key Procedures and Functions

• BEFOREREPORT — The main report initialization function. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, sets the MFG_ORGANIZATION_ID profile value through the FND SRWINIT/FND PUTPROFILE user exits, and invokes WMS_INSTALL.CHECK_INSTALL against the current ORGANIZATION_ID. When that check succeeds, the global P_WMS_INSTALLED is set to 'TRUE', which downstream report logic uses to determine whether LPN information is displayed. It returns a Boolean success indicator.
• AFTERREPORT — The report teardown function, responsible for the FND SRWEXIT user exit that releases the report session resources. It always returns TRUE.
• AFTERPFORM — The post-parameter-form trigger, invoked after the concurrent program parameter form completes, used for parameter-dependent initialization.
• C_FORMATTEDCURRENCYCODEFORMULA — A column formula that takes a currency code and returns it wrapped in parentheses, controlling the display format of the currency column on the report layout.
• C_ORDERBYFORMULA — A column formula that constructs a dynamic ORDER BY fragment. It references P_LOCATOR_FLEXSQL; when the locator flexfield SQL is empty it returns a blank ordering element, otherwise it appends the locator sorting expression to the report's base ordering.
• CF_OUTERMOST_LPNFORMULA — A column formula resolving the outermost (top-level) license plate number associated with the reported inventory transaction or cost row.
• CF_PARENT_LPNFORMULA — A column formula resolving the parent LPN in the license plate hierarchy, enabling the report to present LPN nesting relationships.
• CF_COST_GROUPFORMULA — A column formula that derives the cost group description or code for the reported row, based on the cost group identifier.

Tables Accessed

The package reads from two documented tables through APPS synonyms:

• CST_COST_GROUPS — Consulted by CF_COST_GROUPFORMULA to translate the cost group identifier carried on the report query into a displayable cost group value.
• WMS_LICENSE_PLATE_NUMBERS — Consulted by the LPN formula functions (CF_OUTERMOST_LPNFORMULA, CF_PARENT_LPNFORMULA) to resolve license plate number descriptions and their parent-child relationships. Access is meaningful only when P_WMS_INSTALLED evaluates to TRUE.

Additional inputs, such as the organization identifier and the locator flexfield SQL, are supplied as report parameters and globals rather than being read directly from tables by the package itself.

Usage Notes

INV_INVARCPA_XMLP_PKG is not intended for direct invocation by custom code. It is referenced exclusively by the Oracle Reports definition behind the Inventory accounting period concurrent program, and by XML Publisher when the report is executed with the XMLP engine. The ETRM metadata records that no other PL/SQL package depends on it, confirming its role as a leaf-level report artifact.

Because the package is applied identically across 12.1.1 and 12.2.2, the behavior of P_WMS_INSTALLED is governed entirely by whether the Warehouse Management product is licensed and installed for the reporting organization. Implementations that extend or clone the report should preserve the WMS_INSTALL.CHECK_INSTALL call in BEFOREREPORT; removing it will cause the LPN formula columns to be evaluated unconditionally and may produce errors or blank output for organizations where WMS is not installed. Any modification to the report layout should be applied through the underlying report definition rather than by editing this generated package body, since the package is regenerated when the report is recompiled or republished.