Search Results cf_3formula

Overview

WMS_WMSASNI_XMLP_PKG is a PL/SQL package owned by APPS that supports the Oracle Warehouse Management (WMS) XML Publisher report commonly identified as "WMSASNI" (Advanced Shipping Notice / ASN Information). In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (BI Publisher) concurrent programs rely on a companion PL/SQL package to supply bind parameters, execute before/after report logic, and resolve formulas used in the report layout. This package is classified as "OTHER" within the ETRM inventory, meaning it is a report-supporting package rather than a public API. Its primary role is to receive the concurrent program's user-entered parameters into package globals, prepare session context, and expose calculation formulas that the XML template references during data rendering.

The parameter of interest, P_CHECK_LOT_NUMBER, is declared as VARCHAR2(1). It acts as a control flag indicating whether lot/serial number validation or display should be applied to the ASN data being reported. Related flags in the same package — P_CHECK_LOT_ATTRIBUTES, P_CHECK_LPN, and P_CHECK_SER_NUMBER — follow the same pattern, confirming that this family of parameters governs conditional rendering and lot/serial discipline on the ASN report output.

Key Procedures and Functions

• BEFOREREPORT — Executes before the report data model runs. Typically used to initialize session context, resolve organization identification, and prepare global variables for the report.
• AFTERREPORT — Runs after the report completes; conventionally used for cleanup or post-processing.
• AFTERPFORM — Fires after the parameter form is submitted. This is the standard hook for validating and storing user-entered concurrent program parameters such as P_CHECK_LOT_NUMBER into package globals.
• BETWEENPAGE — Called between report pages; used for page-level logic and header/footer state management.
• CF_1FORMULA through CF_9FORMULA — A set of nine layout-level formula functions. These supply derived values (character and numeric) referenced by the XML template. CF_2FORMULA takes an ITEM_ID parameter, and CF_9FORMULA takes a VENDOR_ID parameter, allowing item- and vendor-specific computed values on the report output.

Tables Accessed

The documented table reference is MTL_SYSTEM_ITEMS_KFV, accessed through its APPS synonym. This is the key-flexfield view of the item master (MTL_SYSTEM_ITEMS). The package reads this view to resolve item descriptions, concatenated segment values, and item-level attributes used in report formulas and display columns — particularly relevant where lot-controlled or serial-controlled items must be distinguished on an ASN.

Usage Notes

This package is not invoked by other PL/SQL packages (referenced by 0 objects). It is bound to its XML Publisher concurrent program as the report's PL/SQL support package. At runtime, the concurrent manager executes the report, calls AFTERPFORM after the user submits parameters, executes BEFOREREPORT before the data query, and evaluates the CF_*FORMULA functions as the XML template is rendered. The P_CHECK_LOT_NUMBER flag is populated from the concurrent program's parameter form and consumed by template logic to conditionally validate or display lot information. Customizations should avoid modifying this package directly; the supported extension point is the XML template and the concurrent program definition. Because the package carries a "noship" header tag and is classified as OTHER, it is treated as internal report infrastructure rather than a public interface.