Search Results delete_data

Overview

APPS.QA_CHART_PARETO_PKG is a PL/SQL package body in the Oracle Quality (QA) module that supports the generation and maintenance of Pareto charts within the Oracle E-Business Suite. Pareto charts are a core quality-analysis visualization, combining a bar chart of defect or occurrence frequencies with a cumulative-percentage line, enabling quality managers to identify the small number of causes responsible for the majority of problems. The package acts as a specialized wrapper in the generic charting architecture: rather than implementing chart rendering independently, it delegates to QA_CHART_HEADERS_PKG and QA_CHART_GENERIC_PKG to persist chart metadata, populate data rows, and manage labels. In the EBS 12.1.1 and 12.2.2 releases, the package reflects the R12 Forms technology stack upgrade that obsoleted Oracle Graphics (Tracking Bug 4939897), reorienting charting toward a data-driven, table-based model. The package also incorporates change delivered under Bug 5044017, which introduced support for limiting displayed groups through a "top N groups" parameter, allowing Pareto charts to surface only the most significant contributors while aggregating the remainder.

Key Procedures and Functions

• CREATE_CHART — Constructs a Pareto chart by first creating a header record via QA_CHART_HEADERS_PKG.CREATE_CHART (using a placeholder 'DUMMY' x-axis label and a function-derived y-axis label), then populating chart data through QA_CHART_GENERIC_PKG.POPULATE_DATA with an optional row limit for top-N groups. Because the x-axis label depends on the final row count, a separate header update sets the correct label after data population.
• CREATE_CHART_AUTONOMOUS — Performs the same chart creation logic within an autonomous transaction, allowing chart records to be committed independently of the caller's transaction scope. This is typically used where chart persistence must survive a rollback in the invoking process.
• DELETE_DATA — Removes chart data associated with a Pareto chart. This procedure supports the maintenance lifecycle of chart records, allowing stale or regenerated chart data to be purged within the caller's transaction.
• DELETE_DATA_AUTONOMOUS — Executes the same data deletion within an autonomous transaction, committing the removal independently of the invoking transaction. This variant is used when deletion must be durable regardless of the caller's commit or rollback outcome.

The package also contains a helper function, GET_X_AXIS_LABEL, which builds the x-axis label from the message QA_CHART_PARETO_X_LABEL, substituting the element name (via QA_CHARS_API.GET_ELEMENT_NAME) and the occurrence count.

Tables Accessed

The documented metadata does not enumerate specific tables referenced through APPS synonyms. Based on the delegation pattern visible in the source, the package operates indirectly on the underlying chart header and chart data tables maintained by QA_CHART_HEADERS_PKG and QA_CHART_GENERIC_PKG, which store chart definitions, axis labels, and populated data rows. The DELETE_DATA and DELETE_DATA_AUTONOMOUS procedures act on these same chart data structures, removing rows keyed to a given chart identifier. The package also reads characteristic element definitions through QA_CHARS_API to resolve element names for labeling.

Usage Notes

QA_CHART_PARETO_PKG is invoked from Oracle Quality charting flows, typically triggered by the Quality workbench forms or by concurrent programs that regenerate chart contents for quality collection plans. The package is referenced by one other package, indicating a contained dependency footprint. When customizing or extending quality analytics, developers should call CREATE_CHART rather than manipulating chart tables directly, and should choose the AUTONOMOUS variants only when the chart data must be committed independently of surrounding business logic. The "top N groups" capability should be supplied when the Pareto analysis is intended to focus on leading contributors, mirroring standard Pareto methodology.