Search Results put_data_to_output_table

Overview

APPS.GML_GPOAO is a server-side PL/SQL package in Oracle E-Business Oracle Process Manufacturing (OPM) that implements outbound PO Acknowledgment (PO Ack) extraction. The header comment identifies the package as containing "all server side procedures to export PO Ack to a flat file," with one flat file created for all PO Acks. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than as a definer-rights unit. The last recorded source revision is 115.5, dated 08-NOV-2002, and the package was created on 14-FEB-1999 by dgrailic, later modified to adopt the GML_ prefix and updated on 26-OCT-2002 to add the NOCOPY hint (Bug#2642152). The primary driver procedure, Extract_GPOAO_Outbound, produces an ASCII file containing the OPM PO Ack Outbound transaction, intended for consumption by third-party EDI translation software that generates and transmits the corresponding EDI outbound document.

Key Procedures and Functions

The ETRM metadata documents three callable units in the package. The user's search term, "put_data_to_output_table," corresponds directly to one of them, indicating interest in the write path that stages export data for flat-file generation.

• Populate_Interface_Tables() — Gathers the source PO acknowledgment data from OPM order and document tables and stages it into the package's interface structures, establishing the working set from which the outbound extract is built.
• Put_Data_To_Output_Table() — Moves the staged interface data into the designated output table so that the rows can subsequently be rendered into the ASCII flat file by the extraction driver.
• Extract_GPOAO_Outbound — The main concurrent-program entry point. It accepts nine parameters: output path, output file name, OPM organization code (required), from/to order number, from/to creation date, OF customer name, and a debug flag. It writes the ASCII outbound PO Ack file and returns the standard concurrent errbuf and retcode status values.

Tables Accessed

The package reads OPM order and document data and writes to the ECE output staging schema. Documented references are:

• OP_ORDR_HDR — the OPM order header, providing the purchase order data being acknowledged.
• GML_GPOAO_DETAILS_S and GML_GPOAO_ORDERS_S — package-specific staging/interface tables holding extracted order and detail rows.
• SY_DOCS_SEQ — OPM document sequence, used to obtain identifier values for the outbound document.
• ECE_OUTPUT and ECE_OUTPUT_RUNS_S — the e-Commerce Gateway output repository where generated outbound content and its run record are persisted.
• UTL_FILE, DBMS_SQL, PLITBLM, and DUAL — supporting utilities for file I/O, dynamic SQL, PL/SQL table manipulation, and single-row queries.

Usage Notes

GML_GPOAO is a concurrent-program-only package. It is invoked by submitting the OPM PO Ack Outbound extract concurrent program, which supplies the nine entry parameters to Extract_GPOAO_Outbound and executes the full sequence: interface table population, output table population, and flat-file generation to the specified path and file name. It is classified as API type OTHER and is referenced by no other packages, so it is a standalone integration point rather than a dependency for other EBS code. Because the package performs direct filesystem writes via UTL_FILE, the database-tier output directory must be configured appropriately for the concurrent manager node. Custom integrations should call the package through the standard concurrent submission interface rather than executing its internal procedures directly, in order to preserve run tracking in ECE_OUTPUT_RUNS_S. Substitute GMLPAOS.pls may be used to compile the package in a development environment.