1 PACKAGE qa_chart_control_pkg AUTHID CURRENT_USER AS
2 /* $Header: qacctrls.pls 120.2 2006/02/08 15:59:46 bso noship $ */
3 /*#
4 * This package is currently a private API to manage
5 * Quality's Release 12 Control Chart charting feature. It is used to
6 * populate create and delete Control chart charting data.
7 * @rep:scope private
8 * @rep:product QA
9 * @rep:displayname Control 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 control chart charting instance.
22 * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
23 * @param p_chart_type Control chart subtype code
24 * @param p_element_id Charting collection element ID
25 * @param p_title Chart title to be displayed in the chart
26 * @param p_description Chart description for information only
27 * @param p_sql SQL string to retrieve the charting data points
28 * @param p_subgroup_size Subgroup size
29 * @param p_subgroup_num Number of subgroups
30 * @param p_dec_prec Decimal precision
31 * @param p_top_ucl Upper Control Limit of top chart
32 * @param p_top_mean Center line of top chart
33 * @param p_top_lcl Lower Control Limit of top chart
34 * @param p_bottom_ucl Upper Control Limit of bottom chart
35 * @param p_bottom_mean Center line of bottom chart
36 * @param p_bottom_lcl Lower Control Limit of bottom chart
37 * @param x_chart_id Return a new chart instance header ID (from qa_chart_headers_s).
38 * @param x_row_count Return the no. of data rows created
39 * @rep:displayname Create a Control chart charting instance
40 */
41 PROCEDURE create_chart(
42 p_criteria_id NUMBER,
43 p_chart_type NUMBER,
44 p_element_id NUMBER,
45 p_title VARCHAR2,
46 p_description VARCHAR2,
47 p_sql VARCHAR2,
48 p_subgroup_size NUMBER,
49 p_subgroup_num NUMBER,
50 p_dec_prec NUMBER,
51 p_top_ucl NUMBER,
52 p_top_mean NUMBER,
53 p_top_lcl NUMBER,
54 p_bottom_ucl NUMBER,
55 p_bottom_mean NUMBER,
56 p_bottom_lcl NUMBER,
57 x_chart_id OUT NOCOPY NUMBER,
58 x_row_count OUT NOCOPY NUMBER);
59
60
61 /*#
62 * This procedure creates a Control chart charting instance. It performs
63 * autonomous commit.
64 * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
65 * @param p_chart_type Control chart subtype code
66 * @param p_element_id Charting collection element ID
67 * @param p_title Chart title to be displayed in the chart
68 * @param p_description Chart description for information only
69 * @param p_sql SQL string to retrieve the charting data points
70 * @param p_subgroup_size Subgroup size
71 * @param p_subgroup_num Number of subgroups
72 * @param p_dec_prec Decimal precision
73 * @param p_top_ucl Upper Control Limit of top chart
74 * @param p_top_mean Center line of top chart
75 * @param p_top_lcl Lower Control Limit of top chart
76 * @param p_bottom_ucl Upper Control Limit of bottom chart
77 * @param p_bottom_mean Center line of bottom chart
78 * @param p_bottom_lcl Lower Control Limit of bottom chart
79 * @param x_chart_id Return a new chart instance header ID (from qa_chart_headers_s).
80 * @param x_row_count Return the no. of data rows created
81 * @rep:displayname Create a Control chart charting instance and commit autonomously
82 */
83 PROCEDURE create_chart_autonomous(
84 p_criteria_id NUMBER,
85 p_chart_type NUMBER,
86 p_element_id NUMBER,
87 p_title VARCHAR2,
88 p_description VARCHAR2,
89 p_sql VARCHAR2,
90 p_subgroup_size NUMBER,
91 p_subgroup_num NUMBER,
92 p_dec_prec NUMBER,
93 p_top_ucl NUMBER,
94 p_top_mean NUMBER,
95 p_top_lcl NUMBER,
96 p_bottom_ucl NUMBER,
97 p_bottom_mean NUMBER,
98 p_bottom_lcl NUMBER,
99 x_chart_id OUT NOCOPY NUMBER,
100 x_row_count OUT NOCOPY NUMBER);
101
102
103 /*#
104 * This procedure deletes the Control chart data points.
105 * @param p_chart_id Chart instance header ID to be deleted.
106 * @rep:displayname Delete a Control chart's data points
107 */
108 PROCEDURE delete_data(p_chart_id NUMBER);
109
110 /*#
111 * This procedure deletes the Control chart data points.
112 * It performs autonomous commit.
113 * @param p_chart_id Chart instance header ID to be deleted.
114 * @rep:displayname Delete a Control chart's data points and commit autonomously
115 */
116 PROCEDURE delete_data_autonomous(p_chart_id NUMBER);
117
118
119 END qa_chart_control_pkg;
[Home] [Help]