1526:
1527: -- Bug# 5882074 get the char test values
1528: CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS
1529: SELECT value_char
1530: FROM gmd_qc_test_values
1531: WHERE test_id = p_test_id
1532: AND text_range_seq = p_num_value;
1533:
1534:
1540: l_seq_max NUMBER :=0;
1541: l_seq_target NUMBER :=0;
1542:
1543: Cursor List_of_values_tests Is
1544: select VALUE_CHAR from gmd_qc_test_values
1545: where test_id = l_gmd_test_rec.test_id;
1546:
1547: Cursor text_range_tests Is
1548: select text_range_seq, VALUE_CHAR from gmd_qc_test_values
1544: select VALUE_CHAR from gmd_qc_test_values
1545: where test_id = l_gmd_test_rec.test_id;
1546:
1547: Cursor text_range_tests Is
1548: select text_range_seq, VALUE_CHAR from gmd_qc_test_values
1549: where test_id = l_gmd_test_rec.test_id;
1550:
1551: --End smalluru Bug#6415285
1552:
1925: --Bug#6415285 commented the below cursor
1926: -- Bug# 5882074 get the char test values
1927: /* CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS
1928: SELECT value_char
1929: FROM gmd_qc_test_values
1930: WHERE test_id = p_test_id
1931: AND text_range_seq = p_num_value;
1932: */
1933: