Search Results wip_wiprepck_xmlp_pkg

Overview

APPS.WIP_WIPREPCK_XMLP_PKG is a generated PL/SQL package body that supports the Oracle Work in Process (WIP) reporting framework in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package name follows Oracle's standard convention for XML Publisher (BI Publisher) report support packages: the "XMLP_PKG" suffix indicates that the package exists to service a concurrent program whose output is defined through an XML Publisher data template and report definition. In this case, the package underpins a WIP report executed through the concurrent manager.

The package is owned by the APPS schema and is classified under the API classification OTHER, meaning it is not a public, callable business API. It is a report-internal construct and should not be treated as an extension point. Its status is VALID, and it is not referenced by any other database object, confirming its role as a top-level orchestrator rather than a reusable utility.

Functionally, the package performs the classic duties of an Oracle report package: initialization before the report runs, retrieval of user-entered concurrent program parameters, formatting and sorting logic applied to report columns, and finalization logic after the report has executed.

Key Procedures and Functions

Fourteen documented procedures and functions are recorded for this package. They divide into lifecycle hooks, formatting formulas, and report data access routines.

• BEFOREREPORT — Executes prior to report data retrieval, establishing session context and preparing report-level state.
• AFTERREPORT — Runs after report completion, releasing resources and finalizing output.
• AFTERPFORM — Handles post-parameter-form processing, typically used to act on values set in a parameter form.
• C_LIMIT_SUPPLY_TYPEFORMULA, C_LIMIT_SUBINVFORMULA, C_P_SUPPLY_TYPEFORMULA, C_LIMIT_STATUSFORMULA — Formula columns controlling supply type, subinventory, and status filtering and display on the report.
• C_COMP_SORTFORMULA, C_LOC_SORTFORMULA — Sort-key formulas used to order report output by component and by location.
• ZEROFORMULA — Supplies a zero-value placeholder, commonly used for conditional column display.
• LIMIT_LINES, LIMIT_JOBS — Data retrieval routines that constrain the returned WIP lines and jobs.
• ORDER_FUNC — Governs ordering of the report's result set.
• GET_PRECISION — Returns a numeric precision value used to format quantities on the report.

Tables Accessed

The documented ETRM metadata lists no directly referenced tables via APPS synonyms. The package's SQL statements and data sources are encapsulated, and the report's underlying queries are resolved through the XML Publisher data template and concurrent program definition rather than being exposed as explicit table dependencies. Dependency information records only APPS.FND_GLOBAL and the SYS.STANDARD package. The reference to FND_GLOBAL indicates the package relies on Oracle Application Object Library context routines, such as retrieval of the current user, responsibility, and concurrent request identifiers, during report execution.

Usage Notes

This package is invoked automatically by the Oracle concurrent manager when the associated WIP report concurrent program executes. It is not designed to be called from forms, custom PL/SQL, or other packages; the ETRM metadata confirms that no database object references it. Developers maintaining or debugging the corresponding WIP report should treat the package as read-only generated code. Because it is a report support package, modifications are overwritten during patching or upgrade. Anyone needing to extend report behavior should do so through the XML Publisher template or by creating a separate custom concurrent program rather than altering this package body.