APPS.GMD_QC_TEST_VALUES_GRP dependencies on GMD_QC_TEST_VALUES_B

Line 36: FROM gmd_qc_test_values_b

32: l_prev_max NUMBER;
33:
34: CURSOR CR_TEST_VALUES IS
35: SELECT min_num,max_num
36: FROM gmd_qc_test_values_b
37: WHERE test_id = p_test_id
38: ORDER BY NVL(min_num, -999999999.999999999) ;
39:
40: BEGIN

Line 335: FROM GMD_QC_TEST_VALUES_B

331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333:
334: SELECT NVL(MAX(text_range_seq),0) + 1 INTO x_qc_test_values_rec.text_range_seq
335: FROM GMD_QC_TEST_VALUES_B
336: WHERE test_id = x_qc_test_values_rec.test_id ;
337:
338: ELSE
339:

Line 386: SELECT 'x' FROM GMD_QC_TEST_VALUES_B

382: l_test_type VARCHAR2(1);
383: l_display_precision NUMBER(1);
384:
385: CURSOR cr_test_value_exist IS
386: SELECT 'x' FROM GMD_QC_TEST_VALUES_B
387: WHERE test_id = p_qc_test_values_rec.test_id
388: AND value_char = p_qc_test_values_rec.value_char ;
389:
390: BEGIN

Line 498: FROM GMD_QC_TEST_VALUES_B

494:
495: -- atleast one test value record must be there.
496: IF x_gmd_qc_tests_rec.test_type in ('V','T','L') THEN
497: SELECT NVL(COUNT(1),0) INTO l_test_values_count
498: FROM GMD_QC_TEST_VALUES_B
499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:
501: IF l_test_values_count = 0 THEN
502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');

Line 561: FROM GMD_QC_TEST_VALUES_B

557:
558: IF x_gmd_qc_tests_rec.test_type = 'T' THEN
559: SELECT MIN(text_range_seq),MAX(text_range_seq)
560: INTO l_min_range,l_max_range
561: FROM GMD_QC_TEST_VALUES_B
562: WHERE test_id = x_gmd_qc_tests_rec.test_id;
563:
564: UPDATE GMD_QC_TESTS_B
565: SET min_value_num = l_min_range,

Line 614: SELECT test_id FROM GMD_QC_TEST_VALUES_B

610: l_test_id NUMBER;
611: l_display_precision NUMBER(1);
612:
613: CURSOR cr_get_test_id IS
614: SELECT test_id FROM GMD_QC_TEST_VALUES_B
615: WHERE test_value_id = p_test_value_id ;
616:
617: BEGIN
618: l_progress := '010';

Line 708: FROM GMD_QC_TEST_VALUES_B

704: l_seq BINARY_INTEGER;
705: BEGIN
706:
707: SELECT text_range_seq INTO l_seq
708: FROM GMD_QC_TEST_VALUES_B
709: WHERE test_id = p_test_id
710: AND value_char = p_value_char ;
711:
712: RETURN (l_seq);