1 PACKAGE QLTCONTB AUTHID CURRENT_USER as
2 /* $Header: qltcontb.pls 115.3 2002/11/27 19:23:20 jezheng ship $ */
3
4 -- 3/19/96 - CREATED
5 -- Jacqueline Chang
6
7 -- This is the procedure that does the processing and computation of
8 -- new data points to graph, as well as new control limits.
9
10
11 PROCEDURE X_BAR_R (sql_string VARCHAR2,
12 subgrp_size NUMBER,
13 num_subgroups IN OUT NOCOPY NUMBER,
14 dec_prec NUMBER,
15 grand_mean IN OUT NOCOPY NUMBER,
16 range_average IN OUT NOCOPY NUMBER,
17 UCL OUT NOCOPY NUMBER,
18 LCL OUT NOCOPY NUMBER,
19 R_UCL OUT NOCOPY NUMBER,
20 R_LCL OUT NOCOPY NUMBER,
21 not_enough_data OUT NOCOPY NUMBER,
22 compute_new_limits IN BOOLEAN default FALSE);
23
24 PROCEDURE X_BAR_S (sql_string VARCHAR2,
25 subgrp_size NUMBER,
26 num_subgroups IN OUT NOCOPY NUMBER,
27 dec_prec NUMBER,
28 grand_mean IN OUT NOCOPY NUMBER,
29 std_dev_average IN OUT NOCOPY NUMBER,
30 UCL OUT NOCOPY NUMBER,
31 LCL OUT NOCOPY NUMBER,
32 R_UCL OUT NOCOPY NUMBER,
33 R_LCL OUT NOCOPY NUMBER,
34 not_enough_data OUT NOCOPY NUMBER,
35 compute_new_limits IN BOOLEAN default FALSE);
36
37
38 PROCEDURE XmR (sql_string VARCHAR2,
39 subgrp_size NUMBER,
40 num_points IN OUT NOCOPY NUMBER,
41 dec_prec NUMBER,
42 grand_mean IN OUT NOCOPY NUMBER,
43 range_average IN OUT NOCOPY NUMBER,
44 UCL OUT NOCOPY NUMBER,
45 LCL OUT NOCOPY NUMBER,
46 R_UCL OUT NOCOPY NUMBER,
47 R_LCL OUT NOCOPY NUMBER,
48 not_enough_data OUT NOCOPY NUMBER,
49 compute_new_limits IN BOOLEAN default FALSE);
50
51 PROCEDURE mXmR (sql_string VARCHAR2,
52 subgrp_size NUMBER,
53 num_points IN OUT NOCOPY NUMBER,
54 dec_prec NUMBER,
55 grand_mean IN OUT NOCOPY NUMBER,
56 range_average IN OUT NOCOPY NUMBER,
57 UCL OUT NOCOPY NUMBER,
58 LCL OUT NOCOPY NUMBER,
59 R_UCL OUT NOCOPY NUMBER,
60 R_LCL OUT NOCOPY NUMBER,
61 not_enough_data OUT NOCOPY NUMBER,
62 compute_new_limits IN BOOLEAN default FALSE);
63
64 PROCEDURE HISTOGRAM (sql_string VARCHAR2,
65 num_points IN OUT NOCOPY NUMBER,
66 dec_prec NUMBER,
67 num_bars IN OUT NOCOPY NUMBER,
68 USL IN NUMBER,
69 LSL IN NUMBER,
70 cp IN OUT NOCOPY NUMBER,
71 cpk IN OUT NOCOPY NUMBER,
72 not_enough_data OUT NOCOPY NUMBER);
73
74 -- Bug 2459633. This function added.
75 -- rponnusa Mon Jul 15 04:31:49 PDT 2002
76
77 FUNCTION validate_query(p_query_str IN VARCHAR2,
78 x_error_num OUT NOCOPY NUMBER)
79 RETURN VARCHAR2;
80
81
82 END QLTCONTB;
83