Search Results delete_report_header

Overview

QPR_REPORT_ENTITIES_PVT is a private PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the Oracle Quality/Product Quality reporting infrastructure. It belongs to the ETRM (Enterprise Transaction Reporting Model) family of packages and is classified as a PVT (private) API, meaning it is intended for internal invocation by the owning application rather than as a supported public interface for customer extensions. The package encapsulates the deletion logic for report entities stored in the Quality reporting schema, providing a controlled mechanism for removing report headers, report lines, and the relationships that bind related reports together.

The business function is administrative and structural: it allows the application to purge or remove report definitions and their associated child records in a single, atomic operation. This is essential when reports become obsolete, when a parent report and all of its dependent related reports must be removed together, or when report data needs to be reorganized. Because it is a private package, its procedures are generally called from within the QPR reporting engine itself, not directly by end users.

Key Procedures and Functions

The documented package exposes four procedures. Each returns a standard status variable (x_return_status) so the caller can detect success or failure.

• DELETE_REPORT_HEADER — Deletes a single report header record, identified by a report ID. This is the narrowest of the four procedures and removes only the header-level row.
• DELETE_REPORT — Removes a complete report, including its header, lines, and relations, for a given report ID. This provides a full cascade delete for a single logical report.
• DELETE_RELATED_REPORTS — Deletes all related report headers and lines associated with a given parent report ID, cleaning up the relationship graph that connects dependent reports.
• DELETE_REPORTS — Deletes reports associated with a specified price plan ID. This ties report cleanup to the price plan context, supporting bulk removal when a pricing scenario is retired.

Tables Accessed

The package operates against four documented tables through APPS synonyms:

• QPR_REPORT_HDRS_B — the base report header table, holding the core report definition rows.
• QPR_REPORT_HDRS_TL — the translatable (language) table for report header descriptions and names.
• QPR_REPORT_LINES — the detail line rows belonging to each report.
• QPR_REPORT_RELNS — the relationship table linking parent and child reports.

The procedures delete rows from these tables in the appropriate order to respect referential integrity, removing child lines and relations before headers.

Usage Notes

As a private package, QPR_REPORT_ENTITIES_PVT is not exposed as a supported public API. It is invoked by other QPR reporting packages (the metadata indicates it is referenced by one other package) and potentially by Oracle Forms or concurrent programs that manage report lifecycle. Custom code should avoid calling these procedures directly unless the calling application fully understands the cascading effects on report headers, lines, and relations. Callers should always inspect x_return_status to confirm the deletion succeeded and handle any error conditions raised by the underlying DML.