Search Results c_comp_sortformula

Overview

APPS.WIP_WIPREPCK_XMLP_PKG is the Oracle E-Business Suite concurrent program library package that backs the Discrete Manufacturing "WIP Component Shortage / Supply and Demand" style XML Publisher report (WIPREPCK). Its core business purpose is to assemble the runtime state needed to print a work-in-process report that lists component requirements (demand) against on-hand inventory supply, and to drive report-level formatting and sorting logic. The package implements the standard Oracle Reports/XML Publisher "XMLP_PKG" wrapper pattern: it exposes public parameters that are bound to the concurrent program's parameter form, plus helper functions called from the report's data model and layout triggers.

The parameter p_supply_days (declared as P_SUPPLY_DAYS NUMBER) is the key control the user searched for. It defines the number of future days over which the report considers open supply — that is, the planning horizon window used to decide which supply receipts, purchase orders, or job completions should be counted against component shortages. It is passed by the user at report submission and consumed by the report's query formatting logic.

Key Procedures and Functions

The package is documented with 14 functions, primarily report-trigger and format helpers rather than business APIs:

• BEFOREREPORT — Standard XML Publisher wrapper trigger executed before report data retrieval; used to initialize session/parameter state.
• AFTERREPORT — Post-report trigger used for cleanup and finalization.
• AFTERPFORM — Executed after the report parameter form is populated; typically used to derive or default parameter values such as supply dates and precision.
• GET_PRECISION — Returns a quantity precision formatting string, driven by the P_QTY_PRECISION parameter, so that on-hand and requirement quantities display consistently.
• C_LIMIT_SUPPLY_TYPEFORMULA — Builds the display/limit text for the supply type selection.
• C_LIMIT_SUBINVFORMULA — Builds the display/limit text for the supply subinventory selection.
• C_P_SUPPLY_TYPEFORMULA — Returns the numeric supply type value used in the report query.
• LIMIT_LINES / LIMIT_JOBS — Return the character flags governing whether the report is constrained to specific lines or jobs.
• ORDER_FUNC — Provides the sort/ordering key for report rows based on supply subinventory, component, department, and locator sort criteria.
• C_LIMIT_STATUSFORMULA — Supplies the status limit string used to filter report rows.
• ZEROFORMULA — Returns a constant zero value used in report layout formulas.
• C_COMP_SORTFORMULA and C_LOC_SORTFORMULA — Produce sort keys for component and locator ordering respectively.

Tables Accessed

The provided ETRM metadata does not enumerate the underlying tables referenced through APPS synonyms; no table list is documented for this object. In practice, this report package derives its cursor results from WIP and inventory base tables — principally WIP_DISCRETE_JOBS, WIP_REQUIREMENT_OPERATIONS, WIP_MTL_OVERHEAD_ALIASES, MTL_ONHAND_QUANTITIES, MTL_SYSTEM_ITEMS, and related inventory/PO supply tables — but because the metadata is silent, these cannot be treated as certified referenced objects. Analysis should be confirmed against the report's actual SELECT statement (WIPREPCK.RDF) and the database's DBA_DEPENDENCIES view.

Usage Notes

The package is not an integration API and is not invoked by any other documented package (0 referencing packages). It is executed exclusively through its owning concurrent program, launched from the Discrete Manufacturing responsibility. Custom code should not call these functions directly; instead, use supported WIP and inventory public APIs. When customizing the report, the p_supply_days parameter is the primary user-facing control for tuning the supply planning horizon and must be supplied as an integer number of days. Because the package header is versioned at 120.1 (2008), behaviour is consistent across 12.1.1 and 12.2.2, with no documented signature changes between releases.