Search Results pqp_ert_bus




Overview
Explore in AI Chat

Overview

PQP_ERT_SHD is an Oracle Applications (APPS) PL/SQL package belonging to the Payroll (PQP) module of Oracle E-Business Suite. In ETRM 12.1.1 and 12.2.2, this package operates within the Exception Reports subsystem, providing the private, reusable PL/SQL constructs that support the maintenance and processing of exception report definitions. Its classification is recorded as OTHER, indicating that it is an internal/utility package rather than a published public API.

The "_SHD" suffix in EBS naming conventions typically denotes a shadow or secondary package. The ETRM dependency record confirms that PQP_ERT_SHD is referenced by several sibling packages in the same family, including PQP_ERT_BUS, PQP_ERT_DEL, PQP_ERT_INS, PQP_ERT_UPD, and itself. This pattern indicates that PQP_ERT_SHD supplies shared low-level logic — row loading, locking, language handling, and argument conversion — consumed by the business, insert, update, and delete layers of the PQP_ERT (Payroll Exception Report) objects. Although the package is not directly exposed to end users, it forms an integral part of the data-access layer behind exception report configuration.

Key Procedures and Functions

The ETRM documentation lists seven procedures and functions within this package:

  • RETURN_API_DML_STATUS — Returns the DML status of the preceding API operation, allowing callers to determine whether an insert, update, or delete completed successfully.
  • CONSTRAINT_ERROR — Handles or reports constraint violations encountered during DML operations on exception report data.
  • API_UPDATING — Signals or tracks whether an API-driven update is in progress, supporting correct sequencing of the update logic.
  • LCK — Implements locking behavior for exception report rows, ensuring that concurrent modifications do not corrupt data.
  • ADD_LANGUAGE — Inserts or registers a language row in the translation (TL) tables, supporting multi-language exception report content.
  • CONVERT_ARGS — Converts argument values between internal formats, bridging the calling API and the underlying data structures.
  • LOAD_ROW — Loads a row of exception report data, used by the insert, update, and delete wrapper packages during processing.

Tables Accessed

PQP_ERT_SHD reads and writes the following objects through APPS synonyms:

  • PQP_EXCEPTION_REPORTS — The base table holding exception report definitions; the package loads and manipulates rows here.
  • PQP_EXCEPTION_REPORTS_TL — The translation table for exception report definitions, populated via ADD_LANGUAGE to support multilingual environments.
  • FND_LANGUAGES — Oracle Applications' language repository, queried to validate or identify installed languages when adding translation rows.
  • ALL_CONSTRAINTS — The data dictionary view used to inspect constraint definitions, supporting CONSTRAINT_ERROR handling and validation logic.

Usage Notes

PQP_ERT_SHD is an internal layer and is not invoked directly by Oracle Forms or concurrent programs. It is called by the family of wrapper packages — PQP_ERT_INS, PQP_ERT_UPD, PQP_ERT_DEL, and PQP_ERT_BUS — which are in turn invoked by exception report setup forms, concurrent processes, and any custom code that maintains exception report data. Developers extending the exception report functionality should call the public wrapper APIs rather than PQP_ERT_SHD, since the shadow package is undocumented as a public interface and may change between releases.