[Home] [Help]
48: --| Also in GMD_SPEC_GRP.validate_spec_test, |
49: --| do not call proc spec_test_min_target_max_valid for test type V and U |
50: --| Peter Lowe 29-MAR-2013 -bug 16484751 rework code for bug 14364421 |
51: --| In proc validate_spec_test , take out T for 16484751 as we need to |
52: --| preserve these values added above from the gmd_qc_test_values_b table |
53: --+==========================================================================+
54: -- End of comments
55:
56:
1064: --| max_value_num are not applicable so initialize for test types |
1065: --| U(nvalidated) and V(ariable) - T was already there . |
1066: --| Peter Lowe 29-MAR-2013 -bug 16484751 rework code for bug 14364421 |
1067: --| In proc validate_spec_test , take out T for 16484751 as we need to |
1068: --| preserve these values added above from the gmd_qc_test_values_b table |
1069: --| |
1070: --+========================================================================+
1071: -- End of comments
1072: PROCEDURE validate_spec_test
1085: AND spec_vers = p_spec_vers;
1086:
1087: CURSOR c_test_value (p_test_id NUMBER, p_value_char VARCHAR2) IS
1088: SELECT text_range_seq
1089: FROM gmd_qc_test_values_b
1090: WHERE test_id = p_test_id
1091: AND value_char = p_value_char ;
1092:
1093: CURSOR c_spec_type (p_spec_id NUMBER) IS
1327:
1328: /* Added the below code in Bug No.14364421 */
1329:
1330: IF (l_test.test_type IN ('V','U')) THEN -- added V for bug 9200937 -- added U for 9235815
1331: -- take out T for 16484751 as we need to preserve these values added above from the gmd_qc_test_values_b table
1332: x_spec_test.min_value_num := NULL;
1333: x_spec_test.max_value_num := NULL;
1334: x_spec_test.target_value_num := NULL;
1335: END IF;
1826: RETURN BOOLEAN IS
1827:
1828: CURSOR c_test_values (p_exp_test_id NUMBER) IS
1829: SELECT EXPRESSION_REF_TEST_ID
1830: FROM gmd_qc_test_values_b
1831: WHERE test_id = p_exp_test_id;
1832:
1833: CURSOR c_spec_test (p_spec_id NUMBER, p_exp_test_seq NUMBER, p_ref_test_id NUMBER) IS
1834: SELECT 1
1894: RETURN BOOLEAN IS
1895:
1896: CURSOR cr_test_values IS
1897: SELECT '1'
1898: FROM gmd_qc_test_values_b
1899: WHERE test_id = p_test_id
1900: AND p_value >= nvl(min_num,p_value)
1901: AND p_value <= nvl(max_num,p_value);
1902: