Search Results clob_to_varchar

Overview

INV_COPY_ORG_REPORT_PUB is a public PL/SQL package within the Oracle E-Business Suite Inventory (INV) module, owned by the APPS schema and defined with AUTHID CURRENT_USER. Its header file, INVVCORS.pls, was originally created on 02-Oct-2001 by Vincent Chu and carries a version stamp of 115.4 dated 16-May-2002. The package supports the Copy Organization feature of Oracle Inventory by managing the interface and reporting data generated when inventory items, item attributes, and related setup data are copied from a source inventory organization to one or more destination organizations. It provides the programmatic entry points that purge staging records and submit the copy organization report request, allowing the migration of master-level and organization-level item information to be monitored and audited.

Key Procedures and Functions

• PURGE_INTERFACE_DATA — Removes records from the copy organization interface table that correspond to a particular group code. The procedure accepts the group code identifying the batch to be purged and a control flag that determines whether the interface table is purged. It returns a completion status and any associated error message through its output parameters, following the standard concurrent program return convention.
• PURGE_REPORTS_DATA — Removes records from the copy organization report table that correspond to a particular group code, mirroring the behaviour of the interface purge at the reporting level.
• CLOB_TO_VARCHAR — A utility routine that converts CLOB data into a VARCHAR2 value. This is significant because the report and interface structures can hold large character payloads, and downstream processing or display requires a bounded character representation. The procedure exists specifically to bridge the large-object storage in the database with the VARCHAR2-based reporting layer.
• SUBMIT_REPORT_CONC_REQ — Submits the copy organization report as a concurrent request, enabling the standard Oracle EBS concurrent manager to execute and track the report job.

Tables Accessed

• MTL_COPY_ORG_INTERFACE — The staging table holding records generated during the copy organization process. PURGE_INTERFACE_DATA deletes rows from this table for a given group code, and CLOB_TO_VARCHAR supports conversion of its large character columns.
• MTL_COPY_ORG_REPORT — The reporting table that stores the output or status information produced by the copy organization report. PURGE_REPORTS_DATA removes rows for the specified group code.
• DBMS_LOB — The Oracle-supplied large object package, referenced by CLOB_TO_VARCHAR to read and convert CLOB content.

Usage Notes

As a PUBLIC API, INV_COPY_ORG_REPORT_PUB is intended for invocation from Oracle Inventory copy organization forms, concurrent programs, and customer-written extensions. The purge procedures are typically called with a group code that identifies the specific copy batch, most often after the report has been reviewed or the interface data has been fully processed, so that obsolete staging rows do not accumulate. The CLOB_TO_VARCHAR routine is generally called internally or by custom reporting code that must present CLOB content as a VARCHAR2 value. SUBMIT_REPORT_CONC_REQ follows standard concurrent submission patterns, passing the copy organization request to the concurrent manager. Because the package is documented as an API, the standard Oracle EBS practice applies: only documented procedures should be called directly, and the group code value must correspond to a valid, existing copy organization batch. No other packages in the ETRM 12.2.2 inventory reference this package, indicating it is a top-level entry point rather than a dependency of other shipped APIs.