PACKAGE: APPS.QA_CHART_TREND_PKG

Source

1 PACKAGE qa_chart_trend_pkg AUTHID CURRENT_USER AS
2 /* $Header: qactrnds.pls 120.1 2006/02/07 23:46:42 bso noship $ */
3 /*#
4  * This package is currently a private API to manage
5  * Quality's Release 12 Trend charting feature.  It is used to
6  * populate create and delete Trend chart charting data.
7  * @rep:scope private
8  * @rep:product QA
9  * @rep:displayname Trend Chart API
10  * @rep:lifecycle active
11  * @rep:category BUSINESS_ENTITY QA_RESULT
12  */
13 
14     --
15     -- Tracking Bug 4939897
16     -- R12 Forms Tech Stack Upgrade - Obsolete Oracle Graphics
17     --
18 
19 
20     /*#
21      * This procedure creates a trend chart charting instance.
22      * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
23      * @param p_x_element_id x-axis label ID.  Actually mfg_lookup_code of QA_TIME_SERIES_AXIS.
24      * @param p_y_element_id y-axis collection element ID
25      * @param p_function_code Function used for y-axis calculation
26      * @param p_title Chart title to be displayed in the chart
27      * @param p_description Chart description for information only
28      * @param p_sql SQL string to retrieve the charting data points
29      * @param x_chart_id Return a new chart instance header ID (from qa_chart_headers_s).
30      * @param x_row_count Return the no. of data rows created
31      * @rep:displayname Create a Trend chart charting instance
32      */
33     PROCEDURE create_chart(
34         p_criteria_id                   NUMBER,
35         p_x_element_id                  NUMBER,
36         p_y_element_id                  NUMBER,
37         p_function_code                 NUMBER,
38         p_title                         VARCHAR2,
39         p_description                   VARCHAR2,
40         p_sql                           VARCHAR2,
41         x_chart_id           OUT NOCOPY NUMBER,
42         x_row_count          OUT NOCOPY NUMBER);
43 
44 
45     /*#
46      * This procedure creates a trend chart charting instance.  It performs
47      * autonomous commit.
48      * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
49      * @param p_x_element_id x-axis label ID.  Actually mfg_lookup_code of QA_TIME_SERIES_AXIS.
50      * @param p_y_element_id y-axis collection element ID
51      * @param p_function_code Function used for y-axis calculation
52      * @param p_title Chart title to be displayed in the chart
53      * @param p_description Chart description for information only
54      * @param p_sql SQL string to retrieve the charting data points
55      * @param x_chart_id Return a new chart instance header ID (from qa_chart_headers_s).
56      * @param x_row_count Return the no. of data rows created
57      * @rep:displayname Create a Trend chart charting instance and commit autonomously
58      */
59     PROCEDURE create_chart_autonomous(
60         p_criteria_id                   NUMBER,
61         p_x_element_id                  NUMBER,
62         p_y_element_id                  NUMBER,
63         p_function_code                 NUMBER,
64         p_title                         VARCHAR2,
65         p_description                   VARCHAR2,
66         p_sql                           VARCHAR2,
67         x_chart_id           OUT NOCOPY NUMBER,
68         x_row_count          OUT NOCOPY NUMBER);
69 
70 
71     /*#
72      * This procedure deletes the Trend chart data points.
73      * @param p_chart_id Chart instance header ID to be deleted.
74      * @rep:displayname Delete a Trend chart's data points
75      */
76     PROCEDURE delete_data(p_chart_id NUMBER);
77 
78     /*#
79      * This procedure deletes the Trend chart data points.
80      * It performs autonomous commit.
81      * @param p_chart_id Chart instance header ID to be deleted.
82      * @rep:displayname Delete a Trend chart's data points and commit autonomously
83      */
84     PROCEDURE delete_data_autonomous(p_chart_id NUMBER);
85 
86 
87 END qa_chart_trend_pkg;