Search Results pqp_ert_del




Overview
Explore in AI Chat

Overview

PQP_ERT_DEL is a PL/SQL package body owned by the APPS schema that supports Oracle E-Business Suite's Enterprise Resource Time Management (ETRM) functionality, specifically the management of exception report definitions. The package name follows Oracle's developer naming convention in which the suffix _DEL designates "delete" logic: PQP identifies the ETRM product family, ERT denotes exception reports, and DEL signals that the unit is responsible for removing (or marking for deletion) exception report translation records. It operates in close conjunction with its sibling packages — most notably PQP_ERT_BUS (business logic), PQP_ERT_RKD (row-keyed deletes), and PQP_ERT_SHD (shadow table processing) — which together form the DML layer that Oracle uses to keep exception report definitions consistent across the base table and its associated translation and shadow tables. The package is classified as VALID and is documented in ETRM 12.2.2 as an "OTHER" API, meaning it is an internal, non-public interface rather than a customer-callable API.

Key Procedures and Functions

ETRM metadata documents exactly one procedure in this package body:

  • DEL_TL — As the name implies, and consistent with Oracle's _TL convention for translation tables, this procedure handles deletion of translation rows for exception report definitions. It is designed to remove the language-specific description rows from the translation table while the parent business logic (typically driven by PQP_ERT_BUS) manages the corresponding base record. It is not intended for direct invocation by end users or external custom code.

No functions are documented. Because the package body is a private implementation unit, parameter lists are not part of the documented API surface, and callers should not rely on them remaining stable across patch levels.

Tables Accessed

The only table documented as referenced (via an APPS synonym) is PQP_EXCEPTION_REPORTS_TL. This is the translation ("_TL") table that stores the multilingual description of each exception report definition, keyed to the base exception report record and to a language code. PQP_ERT_DEL performs DELETE operations against this table so that obsolete or back-level translation rows are purged when an exception report definition is deleted or re-created. The dependency list confirms this usage and shows that the package also depends on HR_API, HR_UTILITY, STANDARD, and the sibling ETRM packages (PQP_ERT_BUS, PQP_ERT_RKD, PQP_ERT_SHD), which provide the transactional context and row-processing logic in which the deletion occurs.

Usage Notes

PQP_ERT_DEL is an internal dependency of the ETRM exception report framework rather than a publicly callable API. Per the ETRM metadata, it is referenced by one other database object, and it does not appear as a published interface for customer extension. In practice it is invoked during the delete flow of exception report definitions, most likely triggered from the OAF or Forms-based ETRM setup UI or from a concurrent program that maintains exception report metadata. Customizations should avoid calling PQP_ERT_DEL directly; instead, developers should use the supported business API layer (PQP_ERT_BUS) and allow the internal delete/RKD/SHD chain to manage translation and shadow rows. Because the package is a private body, its signature and behavior may change between releases 12.1.1 and 12.2.2 and across patches; any dependency on it should be treated as unsupported and revalidated after each upgrade.