Search Results delete_data_autonomous

Overview

APPS.QA_CHART_TREND_PKG is a PL/SQL package body in the Oracle E-Business Suite Quality (QA) module that supports the creation and management of Trend Charts. Trend Charts are used within the Oracle Quality charting framework to visualize time-series quality data, allowing quality analysts and managers to identify patterns, deviations, and trends across collected quality results. The package was introduced or modified in conjunction with the R12 Forms Technology Stack Upgrade (Tracking Bug 4939897), which obsoleted Oracle Graphics. It therefore forms part of the replacement charting architecture built on the QA chart framework.

The package functions primarily as a specialized wrapper around the generic charting packages QA_CHART_HEADERS_PKG and QA_CHART_GENERIC_PKG. By delegating core header creation and data population to these generic components, QA_CHART_TREND_PKG integrates Trend Charts into the unified generic charting architecture while supplying Trend Chart-specific labeling logic.

Key Procedures and Functions

• CREATE_CHART — The primary procedure for building a Trend Chart. It accepts inputs describing the chart criteria, chart elements, function code, title, description, and the SQL query supplying the data. It returns the newly created chart identifier and row count. Internally, it calls QA_CHART_HEADERS_PKG.CREATE_CHART to create the chart header, deriving the x-axis label from the QA_TIME_SERIES_AXIS lookup meaning and the y-axis label from the function axis label, then invokes QA_CHART_GENERIC_PKG.POPULATE_DATA to populate the chart with query results.
• CREATE_CHART_AUTONOMOUS — A wrapper around CREATE_CHART that performs an autonomous transaction commit, allowing the chart to be created and persisted independently of the calling transaction's commit or rollback scope.
• DELETE_DATA — Removes data associated with a chart, supporting cleanup or refresh operations within the charting lifecycle.
• DELETE_DATA_AUTONOMOUS — The autonomous-transaction counterpart to DELETE_DATA, committing data removal independently of the caller's transaction context.

The helper function GET_X_AXIS_LABEL is also present in the source excerpt; it resolves the x-axis label by calling QA_ERES_UTIL.GET_MFG_LOOKUPS_MEANING against the QA_TIME_SERIES_AXIS lookup type.

Tables Accessed

The documented metadata does not enumerate the base tables referenced through APPS synonyms. Functionally, the package reads lookup values through the QA_ERES_UTIL utility (using MFG_LOOKUPS for the QA_TIME_SERIES_AXIS lookup type) and writes chart header and chart data records via QA_CHART_HEADERS_PKG and QA_CHART_GENERIC_PKG. The underlying persistence tables are the QA chart header and chart data tables managed by those generic packages.

Usage Notes

QA_CHART_TREND_PKG is typically invoked from Oracle Quality charting forms or concurrent processes that generate trend visualizations from quality collection plans and results. The CREATE_CHART procedure is the entry point for standard in-transaction chart creation, while CREATE_CHART_AUTONOMOUS and DELETE_DATA_AUTONOMOUS are used when chart creation or data removal must be committed independent of the caller's transaction — for example, in background or long-running processes. The package is referenced by one other package, indicating it is consumed within the broader QA charting framework rather than called directly by end users. Custom code extending Oracle Quality charting should call these procedures rather than manipulating chart tables directly, preserving consistency with the generic charting architecture.