[Home] [Help]
1633:
1634: -- Bug# 5882074 get the char test values
1635: CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS
1636: SELECT value_char
1637: FROM gmd_qc_test_values
1638: WHERE test_id = p_test_id
1639: AND text_range_seq = p_num_value;
1640:
1641:
1647: l_seq_max NUMBER :=0;
1648: l_seq_target NUMBER :=0;
1649:
1650: Cursor List_of_values_tests Is
1651: select VALUE_CHAR from gmd_qc_test_values
1652: where test_id = l_gmd_test_rec.test_id;
1653:
1654: Cursor text_range_tests Is
1655: select text_range_seq, VALUE_CHAR from gmd_qc_test_values
1651: select VALUE_CHAR from gmd_qc_test_values
1652: where test_id = l_gmd_test_rec.test_id;
1653:
1654: Cursor text_range_tests Is
1655: select text_range_seq, VALUE_CHAR from gmd_qc_test_values
1656: where test_id = l_gmd_test_rec.test_id;
1657:
1658: --End smalluru Bug#6415285
1659:
2032: --Bug#6415285 commented the below cursor
2033: -- Bug# 5882074 get the char test values
2034: /* CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS
2035: SELECT value_char
2036: FROM gmd_qc_test_values
2037: WHERE test_id = p_test_id
2038: AND text_range_seq = p_num_value;
2039: */
2040: