Search Results qp_purge_entity




Overview
Explore in AI Chat

Overview

QP_PURGE_ENTITY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Advanced Pricing (QP) module's archive and purge infrastructure. Its primary business function is to permanently remove — or purge — pricing entities that were previously archived according to user-defined archive criteria. In regulated environments, pricing data such as price lists, qualifiers, modifiers, and pricing attributes must be retained for audit purposes before being deleted from the transactional tables. QP_PURGE_ENTITY provides the controlled mechanism by which that final deletion step is executed, working in tandem with the QP archive tables that stage the historical copies of the data.

The package is classified in the ETRM repository as an "OTHER" API, meaning it is not a formally published public API, but rather an internal utility invoked by Oracle's own concurrent program infrastructure. Its single documented procedure, Purge_Entity, encapsulates the entire purge operation for a targeted pricing entity.

Key Procedures and Functions

The package exposes exactly one documented procedure:

  • Purge_Entity — Performs the purge of a designated pricing entity. Per the documented header, it accepts an archive context that includes a source system code, an archive name, an entity type, a numeric entity identifier, and an archive date range (start and end). The procedure follows the standard Oracle concurrent program interface contract, returning the conventional errbuf and retcode OUT parameters used by concurrent managers to capture error messages and completion status. The date range and archive name parameters allow the purge to be scoped to the specific archived set rather than deleting the entire entity unconditionally.

Tables Accessed

The package operates against the QP archive schema tables, which are accessed through APPS synonyms. These tables hold the staged archive data and its defining criteria:

Together these tables represent the historical copies of pricing entities. Purge_Entity reads from them to identify what should be removed and deletes the corresponding archived records once the retention criteria are satisfied.

Usage Notes

QP_PURGE_ENTITY is not intended for direct invocation by end users or custom code. It is typically called from the Oracle Advanced Pricing archive and purge concurrent programs, which manage the bulk cleanup of historical pricing data. The procedure is designed to run in a concurrent manager context, as evidenced by its errbuf and retcode signature. Because the package is classified as "OTHER" and is referenced by zero other packages in the ETRM metadata, it should be treated as an internal implementation detail rather than a supported integration point. Customizations that need to purge pricing entities should invoke the standard Oracle-provided archive and purge concurrent programs rather than calling Purge_Entity directly, ensuring that criterion evaluation, ordering, and referential integrity checks are performed correctly. The presence of both an archive name and a start/end date range confirms that purging is always scoped to a previously archived batch, preserving the audit trail until the designated retention window closes.