[Home] [Help]
PACKAGE: APPS.QA_CHART_HISTOGRAM_PKG
Source
1 PACKAGE qa_chart_histogram_pkg AS
2 /* $Header: qachists.pls 120.2 2006/08/09 01:04:54 bso noship $ */
3 /*#
4 * This package is currently a private API to manage
5 * Quality's Release 12 Histogram charting feature. It is used to
6 * populate create and delete histogram charting data.
7 * @rep:scope private
8 * @rep:product QA
9 * @rep:displayname Histogram 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 -- Bug 5130880 Added target value.
21 /*#
22 * This procedure creates a histogram charting instance.
23 * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
24 * @param p_element_id Charting collection element ID
25 * @param p_spec_id Specification used if non-null
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 p_dec_prec Decimal precision
30 * @param p_usl Upper spec limit
31 * @param p_lsl Lower spec limit
32 * @param p_target_value Target value
33 * @param x_cp Statistical data: cp
34 * @param x_cpk Statistical data: cpk
35 * @param x_num_points Statistical data: number of points
36 * @param x_num_bars Number of bars to show in the histogram
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 histogram charting instance
40 */
41 PROCEDURE create_chart(
42 p_criteria_id NUMBER,
43 p_element_id NUMBER,
44 p_spec_id NUMBER,
45 p_title VARCHAR2,
46 p_description VARCHAR2,
47 p_sql VARCHAR2,
48 p_dec_prec NUMBER,
49 p_usl NUMBER,
50 p_lsl NUMBER,
51 p_target_value NUMBER,
52 x_cp IN OUT NOCOPY NUMBER,
53 x_cpk IN OUT NOCOPY NUMBER,
54 x_num_points IN OUT NOCOPY NUMBER,
55 x_num_bars IN OUT NOCOPY NUMBER,
56 x_chart_id OUT NOCOPY NUMBER,
57 x_row_count OUT NOCOPY NUMBER);
58
59
60 -- Bug 5130880 Added target value.
61 /*#
62 * This procedure creates a histogram charting instance.
63 * It performs autonomous commit.
64 * @param p_criteria_id Foreign key to qa_criteria_headers.criteria_id
65 * @param p_element_id Charting collection element ID
66 * @param p_spec_id Specification used if non-null
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_dec_prec Decimal precision
71 * @param p_usl Upper spec limit
72 * @param p_lsl Lower spec limit
73 * @param p_target_value Target value
74 * @param x_cp Statistical data: cp
75 * @param x_cpk Statistical data: cpk
76 * @param x_num_points Statistical data: number of points
77 * @param x_num_bars Number of bars to show in the histogram
78 * @param x_chart_id Return a new chart instance header ID (from qa_chart_headers_s).
79 * @param x_row_count Return the no. of data rows created
80 * @rep:displayname Create a histogram charting instance and commit autonomously
81 */
82 PROCEDURE create_chart_autonomous(
83 p_criteria_id NUMBER,
84 p_element_id NUMBER,
85 p_spec_id NUMBER,
86 p_title VARCHAR2,
87 p_description VARCHAR2,
88 p_sql VARCHAR2,
89 p_dec_prec NUMBER,
90 p_usl NUMBER,
91 p_lsl NUMBER,
92 p_target_value NUMBER,
93 x_cp IN OUT NOCOPY NUMBER,
94 x_cpk IN OUT NOCOPY NUMBER,
95 x_num_points IN OUT NOCOPY NUMBER,
96 x_num_bars IN OUT NOCOPY NUMBER,
97 x_chart_id OUT NOCOPY NUMBER,
98 x_row_count OUT NOCOPY NUMBER);
99
100
101 /*#
102 * This procedure deletes the histogram data points.
103 * @param p_chart_id Chart instance header ID to be deleted.
104 * @rep:displayname Delete a histogram's data points
105 */
106 PROCEDURE delete_data(p_chart_id NUMBER);
107
108 /*#
109 * This procedure deletes the histogram data points.
110 * It performs autonomous commit.
111 * @param p_chart_id Chart instance header ID to be deleted.
112 * @rep:displayname Delete a histogram's data points and commit autonomously
113 */
114 PROCEDURE delete_data_autonomous(p_chart_id NUMBER);
115
116
117 END qa_chart_histogram_pkg;