Search Results gen_wo_xml

Overview

APPS.AHL_PRD_PRINT_PVT_W is a private PL/SQL wrapper package belonging to the Oracle Complex Maintenance, Repair, and Overhaul (CMRO) / Enterprise Asset Management product family, identified by the AHL application prefix. Its business purpose is to generate XML output for production work orders so that they can be printed, previewed, or transmitted to downstream reporting and document-generation facilities. The package is declared with AUTHID CURRENT_USER, meaning that all SQL and PL/SQL execution is performed under the privileges of the calling schema rather than the package owner. This is characteristic of an internal wrapper that is invoked from a controlled entry point rather than being exposed directly to end users. The "_W" suffix indicates that the package is a wrapper layer that adapts the public or internal API surface to the underlying implementation package AHL_PRD_PRINT_PVT, converting collection types and orchestrating calls on its behalf.

Key Procedures and Functions

• GEN_WO_XML — The principal procedure of the package and the object associated with the search term "gen_wo_xml". It accepts API version, initialization and commit flags, validation level, module type, a work order identifier collection, employee and role context, and a material requirements flag, and it returns the standard EBS API return status, message count, and message data, together with an XML output parameter of type CLOB. Its purpose is to produce an XML document representing one or more production work orders, with the concurrent flag controlling whether the call behaves as a concurrent-program invocation. The procedure is the entry point used by printing and reporting logic to obtain the work order XML payload.
• ROSETTA_TABLE_COPY_IN_P0 — A Rosetta-generated helper that copies a JTF_NUMBER_TABLE (a standard EBS number array) into the package-local workorder_tbl_type used by the underlying implementation. It exists to marshal collection data across the wrapper boundary.
• ROSETTA_TABLE_COPY_OUT_P0 — The inverse helper, copying a workorder_tbl_type collection back out into a JTF_NUMBER_TABLE for consumption by the caller. Together, the two Rosetta procedures isolate callers from the internal PL/SQL record and table type definitions.

Tables Accessed

The documented reference to the APPS synonym PLITBLM indicates that the package, or the code path it exercises, uses a temporary/hold table for storing intermediate values such as selected work order identifiers or generated output fragments during XML assembly. In the broader CMRO context, the work order XML is ultimately sourced from production work order entities such as AHL_WORKORDERS and their associated operations, materials, and resource requirements, while PLITBLM serves as the transient staging structure supporting the print and XML generation process.

Usage Notes

The package is a private wrapper and is not intended as a public integration API. It is typically invoked by the CMRO production work order printing flow, by concurrent programs that generate work order documentation, or by custom code that requires the work order XML in CLOB form for transformation or external delivery. Callers must supply a valid work order identifier collection, an employee identifier, and a role, and must inspect x_return_status and the message count/data outputs in accordance with standard Oracle EBS API error-handling conventions. Because it is referenced by no other documented packages, its consumers are confined to forms, concurrent programs, and bespoke extensions. The AUTHID CURRENT_USER clause requires that the invoking schema hold the necessary object privileges.