Search Results wip_wipmtdlt_xmlp_pkg

Overview

WIP_WIPMTDLT_XMLP_PKG is an Oracle Application Object Library package belonging to the APPS schema that supports the Discrete Job Material Detail Listing concurrent program (report short name WIPMTDLT). It is a thin PL/SQL wrapper built specifically to service the XML Publisher (BI Publisher) report definition associated with the WIPMTDLT concurrent program. The package declares the bind and lexical parameters consumed by the report, including organization, assembly, job, lot, and date ranges, and it exposes a set of column-level and before/after report functions that construct dynamic data source SQL and formatting behavior at runtime.

The user-relevant parameter p_flexwhere appears as P_FLEXWHERE VARCHAR2(2500), a package-level variable that carries a user-supplied or program-generated WHERE fragment applied to the assembly/flexfield criteria. It is the mechanism through which the report supplies additional filtering on descriptive flexfield or key flexfield segments beyond the standard assembly low/high selection, and is typically populated by the report parameter form's flexfield value-set logic and consumed inside the data source query built by the package's before-report and formula functions.

Key Procedures and Functions

• BeforeReport — The main entry point invoked by the report trigger prior to data retrieval. It initializes session context such as organization ID, precision, and date formats, and prepares dynamic SQL where clauses that include the flexwhere fragment.
• AfterReport — Cleanup routine executed after report completion, used to reset package state.
• AfterPForm — Executed after the Oracle Reports parameter form is accepted; used to validate and transform user-entered parameters before execution.
• Limit_Jobs — Builds the lexical WHERE clause restricting the report to the entered from/to job ranges.
• Limit_Lots — Builds the lexical WHERE clause restricting the report to the entered from/to lot ranges.
• Limit_Dates — Builds the lexical WHERE clause applying the from/to date selection.
• Limit_AssemblyFormula — Returns the assembly filtering predicate used by the data model, referencing the assembly flexfield selection.
• Sort_Option — Supplies the ORDER BY clause based on the user's selected sort option.
• C_Sort_Sum — Formatting/column formula controlling sort summary display.
• C_Comp_OrderFormula — Column formula for computing component ordering within the report layout.

Package-level variables such as P_FLEXWHERE, P_ASSY_FLEX, P_ASSEMBLY, and P_OUTER are shared across these functions, forming the interface between the Oracle Reports parameter form and the XML Publisher data template.

Tables Accessed

The ETRM metadata for this package does not enumerate directly referenced tables. As a report driver, the package itself largely manipulates parameters and lexical clauses rather than performing DML. The actual table access occurs inside the WIPMTDLT report data source, which queries WIP_DISCRETE_JOBS, WIP_REQUIREMENT_OPERATIONS, WIP_ENTITIES, BOM structures, MTL_SYSTEM_ITEMS, and related WIP/BOM/INV views through APPS synonyms. The p_flexwhere fragment is embedded into these queries to filter on flexfield-based attributes.

Usage Notes

The package is not called directly by external application code; it is invoked implicitly when the WIPMTDLT concurrent program is submitted from the Discrete Job Material Detail Listing form or the Submit Requests window. In Oracle EBS 12.1.1 and 12.2.2 the report is executed under the XML Publisher engine, with WIP_WIPMTDLT_XMLP_PKG serving as the server-side PL/SQL backing for parameters and formulas. Because it is a report-specific internal package (noshift, private), it should not be referenced from custom code. The p_flexwhere parameter specifically should be populated through the standard flexfield parameter mechanism so that lexical substitution remains valid; direct manipulation is unsupported.