Search Results delete_reports

Overview

QPR_REPORT_ENTITIES_PVT is a private (PVT) PL/SQL package in the Oracle EBS APPS schema that belongs to the Oracle Pricing (QPR) module. It encapsulates the deletion logic for pricing report definitions, providing a controlled, reusable API layer through which report headers, report lines, report translations, and report relationships are removed from the pricing repository. A private package in Oracle EBS convention is not intended to be called directly by end users or external integrations; instead it is invoked internally by other pricing packages or public APIs that front the report maintenance functionality. The package centralizes the referential integrity rules that govern report deletion, ensuring that dependent rows (lines, translations, and relations) are cleaned up consistently rather than being left orphaned. Its header comment identifies the version as 120.0, dated 2007, indicating it is a long-standing component of the pricing schema that has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes four documented procedures, all oriented around deletion of pricing report entities. The user's search term, "delete_reports," corresponds to the fourth of these procedures.

• DELETE_REPORT_HEADER — Removes a single report header record identified by a report ID, returning a status indicator to the caller.
• DELETE_REPORT — Performs a full deletion of a report by report ID, encompassing the report header, its lines, and its relations. This is the broadest single-report operation.
• DELETE_RELATED_REPORTS — Deletes all related report headers and lines associated with a given parent report ID, allowing cascading removal of a report hierarchy.
• DELETE_REPORTS — Deletes reports in the context of a price plan ID, enabling bulk removal of reports belonging to a pricing plan.

Each procedure returns a status value through an OUT parameter so that invoking code can detect success or failure and act accordingly. No functions (as opposed to procedures) are documented in this package.

Tables Accessed

The package writes to and reads from four core pricing report tables through APPS synonyms. QPR_REPORT_HDRS_B holds the base (non-translated) report header rows and is the primary target of header deletion. QPR_REPORT_HDRS_TL stores the translated header attributes; deletions here are required to keep the base and translation tables synchronized and to avoid orphaned language rows. QPR_REPORT_LINES contains the individual line items that make up each report and must be removed before or alongside the parent header to respect foreign key constraints. QPR_REPORT_RELNS captures relationships between reports, such as parent-child associations, and is cleaned up by the related-reports and full-report deletion routines. Together these tables define the complete report entity, and the package's procedures exist to delete them in the correct dependency order.

Usage Notes

Because QPR_REPORT_ENTITIES_PVT is classified as a private API, it is not part of Oracle's supported public interface. It is invoked internally by other pricing packages — ETRM metadata indicates it is referenced by one other package — and indirectly through the Oracle Pricing user interface when a user deletes a pricing report or a price plan containing reports. Customizations and extensions should avoid calling this package directly, since its signature and semantics are not guaranteed across patches and releases. Developers who need to remove pricing reports programmatically should instead use the supported public APIs or concurrent programs exposed by the Pricing module, which handle validation, security, and multi-org context. Direct calls to the private procedures risk bypassing such checks and leaving inconsistent data across the header, translation, line, and relation tables.