1 PACKAGE GMD_QC_TEST_VALUES_GRP AUTHID CURRENT_USER as
2 /* $Header: GMDGTVLS.pls 115.4 2002/11/14 15:18:11 mchandak noship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: check_range_overlap
6
7 DESCRIPTION: This procedure checks for test type 'L' - numeric
8 range with label whether the subrange overlaps
9 with any other subrange within a test.
10 This procedure should be called after insert/update
11 of GMD_QC_TEST_VALUES_TL for test type 'L' but BEFORE
12 COMMIT.
13
14 PARAMETERS: In : p_test_id
15 OUT : x_min_range - minimum value of the whole range.
16 x_max_range - maximum value of the whole range.
17
18 CHANGE HISTORY: Created 09-JUL-02 MCHANDAK
19 ===========================================================================*/
20 PROCEDURE CHECK_RANGE_OVERLAP(
21 p_test_id IN VARCHAR2,
22 x_min_range OUT NOCOPY NUMBER,
23 x_max_range OUT NOCOPY NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_message_data OUT NOCOPY VARCHAR2);
26
27 /*===========================================================================
28
29 PROCEDURE NAME: validate_before_insert
30 DESCRIPTION: This procedure validates test values before insert.
31 ===========================================================================*/
32
33 PROCEDURE VALIDATE_BEFORE_INSERT(
34 p_qc_test_values_rec IN GMD_QC_TEST_VALUES%ROWTYPE,
35 x_qc_test_values_rec OUT NOCOPY GMD_QC_TEST_VALUES%ROWTYPE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_message_data OUT NOCOPY VARCHAR2) ;
38
39
40 /*===========================================================================
41
42 PROCEDURE NAME: validate_after_insert_all
43 DESCRIPTION: This procedure updates min_value_num and max_value_num
44 in test header table and also validates if the range
45 doesnt overlap.
46 NOTE : Call after all test values are inserted.
47
48 ===========================================================================*/
49
50 PROCEDURE VALIDATE_AFTER_INSERT_ALL(
51 p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
52 x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_message_data OUT NOCOPY VARCHAR2) ;
55
56 PROCEDURE VALIDATE_BEFORE_DELETE(
57 p_test_value_id IN NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_message_data OUT NOCOPY VARCHAR2) ;
60
61 PROCEDURE VALIDATE_AFTER_DELETE_ALL(
62 p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
63 x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_message_data OUT NOCOPY VARCHAR2) ;
66
67 FUNCTION get_test_value_desc (
68 p_test_id IN NUMBER,
69 p_test_value_num IN NUMBER DEFAULT NULL,
70 p_test_value_char IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2;
71 FUNCTION text_range_char_to_seq ( p_test_id IN NUMBER,
72 p_value_char IN VARCHAR2) RETURN NUMBER;
73
74
75 END GMD_QC_TEST_VALUES_GRP;