Search Results p_include_vendor

Overview

APPS.WIP_WIPREORQ_XMLP_PKG is the report logic package that backs the Oracle E-Business Suite "WIP Reorder Point Report" (short name WIPREORQ), a Work in Process supply/demand inquiry delivered through the XML Publisher (BI Publisher) concurrent program framework. The package encapsulates the PL/SQL that Oracle Reports-style report triggers previously performed, exposing it as callable functions for a concurrent program and XML template combination. Its business purpose is to evaluate component supply and demand across an organization, calculate net quantity on hand, open requirements, shortages, and total available quantity, and present the results ordered by assembly and component so planners can identify components that fall short of reorder requirements within a supply window.

The package declares the standard report bind/public parameter variables as package globals — including P_ASSY, P_COMP, P_CONC_REQUEST_ID, P_ORGANIZATION_ID, QTY, P_SUPPLY_LOC, P_FROM_LINE, P_TO_LINE, P_FROM_ASSEMBLY, P_TO_ASSEMBLY, P_SUPPLY_DAYS, P_OPEN_SHORT, P_AHEAD_BEHIND, P_NETTABLE, P_QTY_PRECISION, P_FROM_COMP, P_TO_COMP, P_FLEXWHERE, P_REQ_END_DATE, P_DEBUG, P_ITEM_ORG, P_INCLUDE_BULK and P_INCLUDE_VENDOR. These globals hold the report's selection criteria and formatting inputs, and are populated by the concurrent manager before the report functions execute. The header date stamp ($Header: WIPREORQS.pls 120.1 2008/01/31) identifies the source file WIPREORQS.pls. The package is compiled AUTHID CURRENT_USER, so it executes with the privileges of the calling schema.

Key Procedures and Functions

The ETRM metadata documents nineteen callable units. The before/after report triggers — BEFOREREPORT, AFTERREPORT, and the after-parameter trigger AFTERPFORM — initialize and finalize report state. Limiter functions — LIMIT_LINES, OPEN_SHORT_LIMITER, ASSEMBLY_LIMITER — return character strings that constrain the values allowed in their corresponding report parameters. GET_PRECISION supplies the quantity precision used for numeric display.

The core computational functions perform the reorder-point math. C_TOTAL_QTY_FORMULAFORMULA returns a number computed from a total quantity and a supply flag, and is the function surfaced when users search for "c_total_qty_formulaformula." C_QTY_SHORT_QOHFORMULA computes the quantity short based on net component quantity, item total quantity, a short-quantity result, a textual open-requirements value and available quantity. C_QTY_SHORT_SUB_LOCFORMULA derives the sub-inventory short quantity from a short-quantity value and an open quantity. NET_QTY_DETAILFORMULA and AVAIL_QTYFORMULA compute net component quantity and available quantity from availability type, quantity on hand and item total quantity inputs. C_NETTABLE_CONSTRAINTFORMULA and C_LIMIT_COMPONENTSFORMULA return VARCHAR2 constraint expressions used to build dynamic WHERE clauses and component limits. ZEROFORMULA returns a constant numeric zero for report layout defaults, and C_COMPONENT_DISP_SORTFORMULA returns a VARCHAR2 sort key controlling component display order. Supplemental supply-type limiters LIMIT_BULK_SUPPLY_TYPE and LIMIT_VENDOR_SUPPLY_TYPE constrain the bulk and vendor supply inclusion parameters.

Tables Accessed

The ETRM documentation for this package lists no tables accessed through APPS synonyms. The metadata records an empty table reference set, reflecting that the extract in the ETRM repository captures the package specification rather than a parsed dependency list. In practice the report queries WIP and inventory supply/demand views to compute on-hand, open requirements and nettable quantities, but no table-level access is asserted in the supplied documentation and none should be assumed.

Usage Notes

The package is referenced by zero other PL/SQL packages, confirming it is a terminal report library rather than a shared utility. It is invoked by the WIP Reorder Point Report concurrent program, which populates the P_ package globals, calls BEFOREREPORT and AFTERPFORM, executes the query whose columns bind the formula functions (including C_TOTAL_QTY_FORMULAFORMULA), and calls AFTERREPORT on completion. Custom code should call these functions only within the same reporting context, because the functions read package-global parameters and are not designed for independent reuse. The P_DEBUG global and P_FLEXWHERE global support diagnostics and dynamic flexfield filtering respectively, and the P_INCLUDE_BULK and P_INCLUDE_VENDOR flags toggle the supply types evaluated by the LIMIT_BULK_SUPPLY_TYPE and LIMIT_VENDOR_SUPPLY_TYPE limiters.