Search Results purge_reports_data




Overview
Explore in AI Chat

Overview

APPS.INV_COPY_ORG_REPORT_PUB is a public PL/SQL package body in Oracle E-Business Suite that supports the Copy Organization Report utility within Oracle Inventory. Its role is to manage the reporting and interface lifecycle associated with copying organization-level setup data from a source inventory organization to one or more target organizations. The package orchestrates the purge of staging records, provides helper routines for large text handling, and submits the concurrent request that produces the printed report. The body carries the source identifier INVVCORB.pls and records an original creation date of October 2001 (Vincent Chu), with the shipped header revision dated May 2002. Because it is classified as a PUB API under the APPS schema in ETRM for 12.1.1 and 12.2.2, it is intended to be called as a supported public interface rather than treated as internal implementation detail.

Key Procedures and Functions

The documented API surface consists of four procedures or functions:

  • PURGE_INTERFACE_DATA — Removes staging rows tied to a specific group code from the copy organization interface table. Its behavior is conditional: the delete is performed only when the caller supplies a purge indicator of 'Y'. It returns a status code and an error buffer to the caller.
  • PURGE_REPORTS_DATA — The routine surfaced by the search term. It clears previously generated report data so that a subsequent run does not display or re-use stale output. It is also referenced in the package's exception handler, where an unexpected-error message is registered against this routine name.
  • CLOB_TO_VARCHAR — A conversion helper that materialises character large object content into a VARCHAR2 value for use by the report generation logic.
  • SUBMIT_REPORT_CONC_REQ — Submits the concurrent request that executes the Copy Organization Report program, allowing report output to be produced through the standard concurrent manager framework.

Tables Accessed

Two application tables are referenced through APPS synonyms. MTL_COPY_ORG_INTERFACE is the staging table holding the organization copy records; PURGE_INTERFACE_DATA deletes rows from this table filtered by group code. MTL_COPY_ORG_REPORT stores the report data generated for the copy organization process and is the target of the report purge logic. The package additionally depends on the DBMS_LOB supplied package, consistent with the CLOB_TO_VARCHAR helper, and on FND_MSG_PUB for error message handling.

Usage Notes

The package is normally invoked during the Copy Organization Report flow — either from the Inventory setup forms that launch the copy process or from the concurrent program that renders the output. Callers use a group code to identify the batch of interface rows, and a purge flag to control whether staging data is removed before or after processing. Because the package is registered as PUB, custom code may safely call the documented procedures, but should respect the conditional purge convention and check the returned status code, where 0 indicates success and 2 indicates an unexpected error. Error text is retrieved via FND_MSG_PUB.Get and surfaced through the error buffer. As with other seeded EBS APIs, the package should not be modified; any extension should be performed in a custom wrapper package that calls these documented entry points.