Search Results dynamic_order_by

Overview

WIP_WIPDJLIS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS and classified under ETRM as OTHER. Its naming convention follows the standard Oracle Reports integration pattern used throughout EBS: the "XMLP" suffix identifies it as the server-side support package generated for a BI Publisher (XML Publisher) concurrent program report, and the "WIPDJLIS" component identifies the specific report — a Work in Process discrete job listing report. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, consistent with Oracle Reports/BI Publisher concurrent program conventions.

Functionally, the package supplies the runtime logic and parameter handling that a BI Publisher report cannot express natively in its data model. Its primary responsibilities are to hold report parameter values, construct dynamic WHERE and ORDER BY fragments for the report query, and provide the before/after report and before-parameter-form hooks that control defaulting, validation, and query construction at execution time.

Key Procedures and Functions

• BEFOREREPORT — Returns BOOLEAN; the standard Reports before-report trigger fired prior to report execution, typically used to initialize session and report state.
• AFTERREPORT — Returns BOOLEAN; the corresponding after-report trigger, used for post-execution cleanup or finalization.
• DATE_LIMITER — Returns CHARACTER; builds the date-range restriction fragment applied to the report query based on the entered start-date parameters.
• JOB_LIMITER — Returns CHARACTER; constructs the job-number restriction fragment, supporting the from-job and to-job parameters.
• DYNAMIC_ORDER_BY — Returns CHARACTER; assembles the ORDER BY clause dynamically, driven by the sort-code parameter, so the user's chosen sort sequence is applied at runtime.
• C_STATUS_LIMITERFORMULA — Returns VARCHAR2; the status restriction formula. This is the object referenced by the search term "c_status_limiterformula" and is the query component that filters discrete jobs by status according to the P_STATUS parameter.
• AFTERPFORM — Returns BOOLEAN; the after-parameter-form trigger, invoked once parameter entry is complete and before the report query is run, the usual place where the dynamic WHERE and ORDER BY fragments are assembled.
• C_LIMITER — Returns VARCHAR2; a general purpose limiter used by the report data model to combine restriction predicates.

No parameter lists are documented for these functions beyond their return types; they should be treated as report-internal callables.

Tables Accessed

The documented table reference for this package is FND_ID_FLEX_STRUCTURES, an Applications Foundation key-flexfield definition table. It is read to resolve the key flexfield structure used by the item flexfield, which explains the package's p_item_flex_num and P_ITEM_DATA variables and the ITEM_WHERE fragment — the report needs the flexfield structure identifier to build the correct item concatenation and item range predicates. No insert or update activity against application data tables is documented; the package is essentially read-only with respect to the database.

Usage Notes

The package is invoked indirectly by the concurrent manager when the associated WIP discrete job listing report is submitted; users do not call it directly. It is referenced by no other PL/SQL packages, so its call surface is confined to the report definition itself. Because it carries AUTHID CURRENT_USER, any customization must respect the privileges of the invoking report session. In 12.1.1 and 12.2.2 the header comments indicate a long-stable source base (120.1), and the file is flagged noship, meaning it is not a seedable object subject to standard patching of shipped data. Customizations to status, job, date, or sort behavior should be made by copying and extending the report and its supporting package rather than modifying the delivered object.