Search Results c_assembly_limiterformula

Overview

The APPS.WIP_WIPLBOSP_XMLP_PKG package is the PL/SQL wrapper package generated for the Oracle EBS Work in Process (WIP) concurrent program and XML Publisher (BI Publisher) report commonly known as the WIP Lot / Bill of Materials and Outside Processing report (internal report short name WIPLBOSP). The package follows the standard Oracle Reports-to-XML-Publisher migration pattern used in release 12.1.1 and 12.2.2, where each concurrent report is backed by a specification-defined package in the APPS schema that declares report-level bind variables and helper functions. It is declared with AUTHID CURRENT_USER, so it executes with the privileges of the invoking user, consistent with Oracle EBS security conventions for concurrent program packages.

The package serves as the hosting container for the report's parameter variables and its limiting/formatting logic. It exposes global variables such as P_ORG_ID, P_ITEM_WHERE, P_ASSEMBLY, P_PO_ASSY, P_STATUS, P_FROM_JOB/P_TO_JOB, P_FROM_ASSEMBLY/P_TO_ASSEMBLY, P_FROM_LINE/P_TO_LINE, P_QTY_PRECISION, P_CONC_REQUEST_ID, P_OPEN_ONLY, and P_DEBUG. These variables drive the report query ranges at runtime.

Key Procedures and Functions

• C_ASSEMBLY_LIMITERFORMULA — The user-relevant function in this search. It returns a VARCHAR2 value that supplies the assembly-limiting formula for the report's SQL query, dynamically constructing the WHERE-clause predicate that constrains the assembly (item) selection based on user-supplied report parameters such as the from/to assembly range.
• C_DJ_LINE_LIMITERFORMULA — Returns a VARCHAR2 formula that builds the department/job line limiting predicate, restricting report output to the requested line ranges.
• JOB_LIMITER — Returns a CHARACTER value that supplies the job-number limiting clause used by the report query, filtering WIP jobs against the from/to job parameters.
• LINE_LIMITER — Returns a CHARACTER value providing the line-number limiting clause applied to the report dataset.
• OPEN_PO_ONLY — Returns a CHARACTER flag that indicates whether the report should restrict results to open purchase orders / outside processing entries.
• BEFOREREPORT — Returns BOOLEAN; the standard XML Publisher before-report trigger used to initialize globals and prepare the run context.
• AFTERREPORT — Returns BOOLEAN; the standard after-report cleanup trigger.
• AFTERPFORM — Returns BOOLEAN; invoked after the parameter form is processed, typically to populate derived parameter values such as P_ITEM_WHERE.

Tables Accessed

The only documented table reference is FND_ID_FLEX_STRUCTURES (via APPS synonym). This is read to resolve the key flexfield structure definition for the item (assembly) flexfield, which is necessary to build the item-limiting WHERE fragments produced by the *_LIMITER* functions correctly against the enabled flexfield segments. No other base tables are documented in the package specification itself; the main report data query resides in the XML Publisher data definition rather than in the package body.

Usage Notes

This package is invoked automatically as part of the XML Publisher concurrent program execution flow. The Oracle Reports/XML Publisher runtime calls BEFOREREPORT, executes the data model (which references the *LIMITER* and *LIMITERFORMULA functions), and finally calls AFTERREPORT. The parameters declared here—P_ASSEMBLY, P_FROM_ASSEMBLY, P_TO_ASSEMBLY, P_OPEN_ONLY, and related—are surfaced to the user through the concurrent program's parameter dialog. Custom code generally should not call these functions directly, as they are report-internal. Developers troubleshooting assembly filtering behavior should inspect C_ASSEMBLY_LIMITERFORMULA and the derived P_ITEM_WHERE value. The header indicates the package has been marked noship since 2008, meaning it is not shipped as a standalone object but is delivered/maintained as part of the WIP report patch stream across both 12.1.1 and 12.2.2.