Search Results p_line_to

Overview

APPS.FLM_FLMRFSCH_XMLP_PKG is the packaged body that supports the Oracle E-Business Suite concurrent program report FLMFLMRFSCH (the Flow Manufacturing "Routing/Flow Schedule" XML Publisher report). Implemented in Release 12.1.1 and 12.2.2, the package provides the PL/SQL building blocks that an Oracle Reports and XML Publisher executable relies upon to assemble report parameters before the result set is generated. Its most visible role is to normalize the "line from" and "line to" range parameters supplied on the concurrent program submission form, derive an organization name from ORG_ORGANIZATION_DEFINITIONS, resolve the enabled and frozen Material Status (MSTK) key flexfield structure, and produce dynamically concatenated SQL fragments used as a WHERE clause against the flow line Code column (wl.line_code).

Key Procedures and Functions

• BEFOREREPORT — Executes the bulk of the package logic before the report's data query runs. It fetches the organization name into P_ORGANIZATION, then resolves the user's p_line_from and p_line_to parameters. Where only one bound is supplied, BEFOREREPORT mirrors the value to the opposite bound so that range logic behaves symmetrically. It then constructs P_LIMIT_LINE, a text fragment containing "and wl.line_code >= ..." and/or "... <= ..." predicates built by string concatenation, and builds P_LIMIT_SCH_GROUP from p_sch_group. It additionally selects the ID_FLEX_NUM of the enabled, frozen MSTK structure from FND_ID_FLEX_STRUCTURES, captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, and converts the date parameters to DD-MON-YY display format. The FND SRWINIT and FND FLEXSQL user exits are commented out and replaced with NULL placeholders, indicating this is a converted XML Publisher package.
• AFTERREPORT — Runs after report completion. It currently contains only a NULL statement in place of the legacy FND SRWEXIT user exit and returns TRUE.
• AFTERPFORM — The after-parameter-form trigger. It performs no additional work and simply returns TRUE.

Tables Accessed

The package references ORG_ORGANIZATION_DEFINITIONS to translate the operating unit's P_ORG_ID into a printable organization name, and FND_ID_FLEX_STRUCTURES to determine the active Material Status (MSTK) key flexfield structure for application 401 (Inventory) where ENABLED_FLAG and FREEZE_FLEX_DEFINITION_FLAG are 'Y'. The ETRM metadata lists FND_ID_FLEX_STRUCTURES as the documented table, accessed through the APPS synonym. It performs read-only queries; no inserts, updates, or deletes are issued.

Usage Notes

This package body is not called by other PL/SQL packages — the ETRM metadata records zero referencing packages. It is invoked indirectly by the Oracle Reports/XML Publisher runtime whenever the associated Flow Manufacturing routing schedule concurrent program is submitted, with the report executable calling BEFOREREPORT, AFTERPFORM, and AFTERREPORT at the appropriate report lifecycle points. Because the p_line_from and p_line_to values are concatenated into P_LIMIT_LINE and P_LIMIT_SCH_GROUP as literal text rather than bound variables, the report's underlying query must consume these placeholders directly; this is typical of the XML Publisher migration pattern where the legacy SRW user exits are retired. Customizations that introduce additional line filters should follow the same concatenation convention so the generated WHERE clause remains syntactically valid.