24:
25: FUNCTION get_test_code(p_test_id IN NUMBER) RETURN VARCHAR2 IS
26: cursor get_test IS
27: SELECT TEST_CODE
28: FROM gmd_qc_tests_b
29: WHERE test_id = p_test_id;
30:
31: l_test_code gmd_qc_tests_b.test_code%TYPE;
32: BEGIN
27: SELECT TEST_CODE
28: FROM gmd_qc_tests_b
29: WHERE test_id = p_test_id;
30:
31: l_test_code gmd_qc_tests_b.test_code%TYPE;
32: BEGIN
33: OPEN get_test;
34: FETCH get_test INTO l_test_code;
35: CLOSE get_test;
161: c_get_composite_test_row c_get_composite_test%ROWTYPE;
162: l_common_test_count NUMBER:=0;
163: l_child_composite_result_id NUMBER;
164: l_place NUMBER;
165: l_test_code gmd_qc_tests_b.test_code%TYPE;
166:
167:
168:
169: BEGIN