APPS.GMD_SPEC_GRP dependencies on GMD_SPEC_TESTS_B

Line 403: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;

399: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;
400: l_test_min_value_num NUMBER;
401: l_test_max_value_num NUMBER;
402: l_test_method_id NUMBER;
403: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;
404: l_test_method_replicate NUMBER;
405:
406: BEGIN
407:

Line 1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um

1008: RETURN BOOLEAN IS
1009:
1010: CURSOR c_class_combo (p_spec_name VARCHAR2, p_spec_vers NUMBER, p_to_uom VARCHAR2) IS
1011: SELECT 1
1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um
1013: WHERE st.spec_id = p_spec_id
1014: AND st.test_id <> p_test_id
1015: AND st.to_qty_uom = um.uom_code
1016: AND um.uom_class =

Line 1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b

1454: x_return_status OUT NOCOPY VARCHAR2) IS
1455:
1456: CURSOR cr_expression_tests IS
1457: SELECT a.test_id,a.seq
1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b
1459: WHERE
1460: a.spec_id = p_spec_id
1461: AND a.test_id = b.test_id
1462: AND b.test_type = 'E' ;

Line 1479: FROM GMD_SPEC_TESTS_B

1475: END IF;
1476:
1477: -- atleast one test should be present in the spec.
1478: SELECT NVL(COUNT(1),0) INTO l_test_count
1479: FROM GMD_SPEC_TESTS_B
1480: WHERE spec_id = p_spec_id ;
1481:
1482: IF l_test_count = 0 THEN
1483: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');

Line 1745: FROM GMD_SPEC_TESTS_B

1741: BEGIN
1742:
1743: IF p_exclude_test_id IS NULL THEN
1744: SELECT 1 INTO dummy
1745: FROM GMD_SPEC_TESTS_B
1746: WHERE spec_id = p_spec_id
1747: AND seq = p_seq ;
1748: ELSE
1749: SELECT 1 INTO dummy

Line 1750: FROM GMD_SPEC_TESTS_B

1746: WHERE spec_id = p_spec_id
1747: AND seq = p_seq ;
1748: ELSE
1749: SELECT 1 INTO dummy
1750: FROM GMD_SPEC_TESTS_B
1751: WHERE spec_id = p_spec_id
1752: AND seq = p_seq
1753: AND test_id <> p_exclude_test_id ;
1754: END IF;

Line 1792: FROM GMD_SPEC_TESTS_B

1788:
1789: BEGIN
1790:
1791: SELECT 1 INTO dummy
1792: FROM GMD_SPEC_TESTS_B
1793: WHERE spec_id = p_spec_id
1794: AND test_id = p_test_id;
1795:
1796: RETURN TRUE;

Line 1835: FROM GMD_SPEC_TESTS_B

1831: WHERE test_id = p_exp_test_id;
1832:
1833: CURSOR c_spec_test (p_spec_id NUMBER, p_exp_test_seq NUMBER, p_ref_test_id NUMBER) IS
1834: SELECT 1
1835: FROM GMD_SPEC_TESTS_B
1836: WHERE spec_id = p_spec_id
1837: AND test_id = p_ref_test_id
1838: AND seq < p_exp_test_seq;
1839: