Search Results qa_chart_trend_pkg




Overview
Explore in AI Chat

Overview

QA_CHART_TREND_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER API within ETRM. It belongs to the Oracle Quality (QA) product family and addresses the trend-charting side of Quality data collection and analysis. In EBS environments, Quality collection elements, collection plans, and specifications generate large volumes of measured results. Trend charts let quality engineers and production supervisors visualize how a given collection element behaves over time so that shifts, drift, and out-of-specification conditions can be detected before they become systemic defects. QA_CHART_TREND_PKG provides the backend logic that assembles chart definitions and the underlying trend data, persists or deletes chart-related records, and supports the chart rendering layer used by the Quality charting UI. Its status is VALID, and it is referenced by QA_CHART_HEADERS_PKG, indicating that chart header processing delegates trend-data operations to this package. Dependencies are limited to the SYS STANDARD package, so it relies on the core PL/SQL runtime rather than on other EBS APIs, which keeps its coupling narrow and its behavior stable across 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents four callable units in this package. They divide cleanly into two functional pairs — chart creation and data cleanup — each with a standard and an autonomous-transaction variant.

  • CREATE_CHART — Builds the trend chart definition and the associated data set for a requested collection element or charting context. It is the primary entry point for generating trend-chart content and operates within the caller's transaction.
  • CREATE_CHART_AUTONOMOUS — Performs the same chart-creation work but inside a pragma autonomous transaction. This ensures the chart record is committed independently of the calling process, so a chart can survive a rollback of surrounding work or be written without holding the parent transaction open.
  • DELETE_DATA — Removes trend chart data associated with a chart or collection context, executing as part of the caller's transaction.
  • DELETE_DATA_AUTONOMOUS — The autonomous counterpart to DELETE_DATA, used where cleanup must be committed regardless of the outcome of the calling transaction.

Parameter lists are not documented in the ETRM extract and therefore are not reproduced here; callers should inspect the package specification in the target instance before invoking the APIs directly.

Tables Accessed

The ETRM metadata records no table references through APPS synonyms for this package. This typically indicates that the package works through PL/SQL constructs, temporary structures, or indirect access rather than issuing direct DML against base Quality tables. In practice, trend-chart logic of this type is closely associated with QA chart definition data (for example QA_CHARTS) and Quality results collected against collection plans, but the documented evidence does not confirm specific tables. Any statement of table-level dependencies beyond the ETRM record would be speculative.

Usage Notes

QA_CHART_TREND_PKG is intended to be invoked from the Oracle Quality charting user interface and from dependent PL/SQL such as QA_CHART_HEADERS_PKG, which ETRM lists as the only package referencing it. It is not a public, general-purpose API and should not be treated as one. Customizations that need trend-chart creation or cleanup should call the documented procedures rather than reimplementing chart data logic. Because the package depends only on STANDARD, it does not require additional package-level grants or dependency ordering during patching. Customers on 12.1.1 and 12.2.2 should expect the same four procedures and the same low-coupling profile. Direct calls should be validated against the live package specification, since ETRM does not publish parameter signatures for this object.