1 PACKAGE qa_chart_generic_pkg AS
2 /* $Header: qacgens.pls 120.2 2006/03/20 12:08:09 bso noship $ */
3 /*#
4 * This package is currently a private API to interface with
5 * Quality's Release 12 Charting Architecture. It is used to
6 * create data points for a generic chart. A generic chart is
7 * one that has simple x-axis ticker labels and y-axis numeric
8 * values.
9 * @rep:scope private
10 * @rep:product QA
11 * @rep:displayname Generic Chart Data API
12 * @rep:lifecycle active
13 * @rep:category BUSINESS_ENTITY QA_RESULT
14 */
15
16 --
17 -- Tracking Bug 4939897
18 -- R12 Forms Tech Stack Upgrade - Obsolete Oracle Graphics
19 --
20
21
22 /*#
23 * This procedure populates the qa_chart_generic table with
24 * data points. The caller passes in a SQL string that must
25 * select two columns, x-axis ticker labels and numeric y-axis
26 * values. The SQL should almost always have an ORDER BY clause
27 * so the leftmost x-axis ticker as appear on the resultant
28 * graph comes first and so forth.
29 * @param p_chart_id Foreign key to qa_chart_headers.chart_id.
30 * @param p_sql A SQL string
31 * @param p_row_limit No. of rows to fetch (default to all)
32 * @param x_row_count Return the no. of data rows created
33 * @rep:displayname Create generic chart data from a SQL
34 */
35 PROCEDURE populate_data(
36 p_chart_id NUMBER,
37 p_sql VARCHAR2,
38 p_row_limit NUMBER DEFAULT NULL,
39 x_row_count OUT NOCOPY NUMBER);
40
41
42 /*#
43 * This procedure populates the qa_chart_generic table with
44 * data points. It is the same as populate_data except it
45 * performs an autonomous commit.
46 * @param p_chart_id Foreign key to qa_chart_headers.chart_id
47 * @param p_sql A SQL string
48 * @param p_row_limit No. of rows to fetch (default to all)
49 * @param x_row_count Return the no. of data rows created
50 * @rep:displayname Create generic chart data from a SQL and commit autonomously
51 */
52 PROCEDURE populate_data_autonomous(
53 p_chart_id NUMBER,
54 p_sql VARCHAR2,
55 p_row_limit NUMBER DEFAULT NULL,
56 x_row_count OUT NOCOPY NUMBER);
57
58
59 /*#
60 * This procedure deletes chart details from qa_chart_generic.
61 * @param p_chart_id Chart ID whose data are to be deleted
62 * @rep:displayname Delete chart details
63 */
64 PROCEDURE delete_data(p_chart_id NUMBER);
65
66
67 /*#
68 * This procedure deletes chart details from qa_chart_generic
69 * and performs an autonomous commit.
70 * @param p_chart_id Chart ID whose data are to be deleted
71 * @rep:displayname Delete chart details and commit autonomously
72 */
73 PROCEDURE delete_data_autonomous(p_chart_id NUMBER);
74
75
76 END qa_chart_generic_pkg;