Search Results p_to_line

Overview

APPS.WIP_WIPSULIN_XMLP_PKG is the generated PL/SQL package body that backs the Oracle EBS Work in Process (WIP) concurrent program report "WIP Supply Line Report" (internal short name WIPSULIN, XML Publisher / BI Publisher source module WIPSULINB.pls). Its role is to provide the report's server-side programmatic logic: initializing the runtime environment for the Oracle Reports / XML Publisher engine, deriving a dynamic SQL predicate from the report's line-range parameters, and performing cleanup at report completion. The package is part of the standard APPS schema infrastructure shipped with Oracle EBS 12.1.1 and 12.2.2 and is owned exclusively by the E-Business Suite rather than by any customer extension. Its only present business logic concerns filtering WIP supply lines by line code ranges supplied as concurrent program parameters.

Key Procedures and Functions

The package body documents four program units, all of which are standard report lifecycle hooks or filter helpers:

• BEFOREREPORT — Runs once before the report body. It captures the concurrent request identifier into P_CONC_REQUEST_ID using FND_GLOBAL.CONC_REQUEST_ID. The historical SRW.USER_EXIT calls for FND SRWINIT and for the Inventory locator flexfield SQL (FND FLEXSQL against IL, output to :P_LOCATOR_DATA) are commented out in the shipped source, indicating the current report relies on the alternative XML Publisher initialization path rather than the legacy SRW user exits.
• LIMIT_BY_LINE_RANGE — The function directly relevant to the search term p_from_line. It builds and returns a character string containing a SQL fragment used to constrain WIP supply lines by their line code. When P_FROM_LINE is populated and P_TO_LINE is populated, it produces a BETWEEN ... AND ... predicate on WL.LINE_CODE; when only P_FROM_LINE is populated it produces a >= comparison; when only P_TO_LINE is provided it produces a <= comparison; and when neither is supplied it returns a single space so that the resulting WHERE clause remains syntactically valid. The predicate is emitted as literal text with the parameter values concatenated between single quotes.
• AFTERPFORM — The after-parameter-form trigger. In the shipped body it simply returns TRUE and performs no additional processing, serving as a placeholder extension point.
• AFTERREPORT — The post-report cleanup hook. As shipped it returns TRUE; the legacy SRW.USER_EXIT('FND SRWEXIT') call is commented out, consistent with the modernized XML Publisher execution path.

Tables Accessed

No base tables are directly referenced inside the package body itself. The only table alias appearing in the package source is WL (WIP lines), and it appears solely inside the concatenated string returned by LIMIT_BY_LINE_RANGE; the actual query that consumes this string is defined in the report's data model, not in the PL/SQL package. The Inventory locator flexfield reference to alias IL is present only within a commented-out FND FLEXSQL call. Consequently, the ETRM metadata correctly records no APPS-synonym table references attributable to this package body.

Usage Notes

This package is not an API and must not be called from custom code. It is invoked automatically by the Oracle Reports / XML Publisher runtime whenever the WIP Supply Line Report concurrent program is submitted, with the report engine calling BEFOREREPORT, AFTERPFORM, LIMIT_BY_LINE_RANGE, and AFTERREPORT at their respective lifecycle points. The P_FROM_LINE and P_TO_LINE values originate from the report's parameter form and are bound at runtime. The ETRM metadata records that no other PL/SQL package references this package, confirming its role as a terminal report implementation object. In EBS 12.2.2 the report is executed under the online patching editioning model, and the package inherits the standard APPS-schema compilation and privilege characteristics of all Oracle-delivered XML Publisher report packages.