304: PROCEDURE get_test_method_code(p_test_method_id VARCHAR2,
305: p_test_method_code OUT NOCOPY VARCHAR2) IS
306: CURSOR Cur_get_test_method IS
307: SELECT TEST_METHOD_CODE
308: FROM gmd_test_methods
309: WHERE TEST_METHOD_ID = p_test_method_id;
310: BEGIN
311: OPEN Cur_get_test_method;
312: FETCH Cur_get_test_method INTO p_test_method_code;
315: PROCEDURE get_test_method_desc(p_test_method_id VARCHAR2,
316: p_test_method_desc OUT NOCOPY VARCHAR2) IS
317: CURSOR Cur_get_test_method IS
318: SELECT TEST_METHOD_DESC
319: FROM gmd_test_methods
320: WHERE TEST_METHOD_ID = p_test_method_id;
321: BEGIN
322: OPEN Cur_get_test_method;
323: FETCH Cur_get_test_method INTO p_test_method_desc;