Search Results pqp_ert_upd




Overview
Explore in AI Chat

Overview

PQP_ERT_UPD is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite, classified under the ETRM (Enterprise Transaction and Reference Model) taxonomy as an "OTHER" API object. It forms part of the Product Quality / Enterprise Resource Tracking module families whose object prefixes (PQP_) are associated with Oracle Quality and related exception-reporting functionality. Its principal business role is to perform the update operations against the exception report translation tables, specifically PQP_EXCEPTION_REPORTS_TL, providing the low-level write logic that maintains translated descriptive data for exception reports.

The package body is reported as VALID in the data dictionary and is registered in EBS as a dependency-bearing object. It references several supporting packages, including HR_API, HR_UTILITY, HR_STARTUP_DATA_API_SUPPORT, PQP_ERT_BUS, PQP_ERT_RKU, and PQP_ERT_SHD. This dependency set indicates that PQP_ERT_UPD participates in a layered architecture: PQP_ERT_SHD supplies shadow (audit/history) handling, PQP_ERT_RKU supplies row-key unique (primary key) maintenance, and PQP_ERT_BUS is the business logic package that coordinates these components. PQP_ERT_UPD itself is not referenced by any other database object, confirming that it operates as a leaf-level implementation package rather than a public entry point.

Key Procedures and Functions

The documented package metadata identifies a single procedure or function: UPD_TL. The "_TL" suffix follows the Oracle EBS convention for translation-table maintenance and indicates that the routine updates translated (language-specific) rows rather than the base entity rows. UPD_TL is therefore responsible for writing or refreshing the translated description columns held in the exception report translation table for a given language and report identifier.

Because the procedure name is the only documented element, its parameter list is not reproduced here. In general, a translation update routine of this type accepts an identifier for the parent exception report, a language code, and the translated description value, and writes the row using the HR_API and HR_UTILITY infrastructure that provides commit, validation, and error-handling services.

Tables Accessed

The only table documented as referenced through APPS synonyms is PQP_EXCEPTION_REPORTS_TL. This is the translation table holding language-dependent text for exception reports. The UPD_TL procedure reads and writes this table to keep translated descriptions synchronized with the base exception report definition maintained in the corresponding non-translated table.

Indirect table access also occurs through the referenced body packages and the HR_API / HR_UTILITY layer; however, those internal objects are dependencies rather than directly documented tables of PQP_ERT_UPD.

Usage Notes

PQP_ERT_UPD is not intended to be called directly by external code or by interactive forms. Its discoverability through ETRM and its role as a non-referenced leaf package indicate that it is invoked indirectly, through the PQP_ERT_BUS business package, whenever an exception report definition or its translation is created or modified. Typical invocation paths include the standard Oracle Quality exception report setup forms and any concurrent or pl/sql-based processes that perform batch maintenance of exception report translations.

  • Invoke through the parent business package (PQP_ERT_BUS) rather than calling UPD_TL directly.
  • Ensure the target language is installed and available in the FND_LANGUAGES setup before updating translation rows.
  • Standard HR_API commit and validation semantics apply; avoid issuing additional commits around the call.
  • Because the package is classified as OTHER rather than PUBLIC, it is not covered by Oracle's public API compatibility guarantee and may change between release levels (12.1.1 to 12.2.2).