APPS.GMD_SPEC_GRP dependencies on GMD_SPEC_TESTS_B

Line 382: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;

378: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;
379: l_test_min_value_num NUMBER;
380: l_test_max_value_num NUMBER;
381: l_test_method_id NUMBER;
382: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;
383: l_test_method_replicate NUMBER;
384:
385: BEGIN
386:

Line 970: FROM gmd_spec_tests_b st, mtl_units_of_measure um

966: RETURN BOOLEAN IS
967:
968: CURSOR c_class_combo (p_spec_name VARCHAR2, p_spec_vers NUMBER, p_to_uom VARCHAR2) IS
969: SELECT 1
970: FROM gmd_spec_tests_b st, mtl_units_of_measure um
971: WHERE st.spec_id = p_spec_id
972: AND st.test_id <> p_test_id
973: AND st.to_qty_uom = um.uom_code
974: AND um.uom_class =

Line 1386: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b

1382: x_return_status OUT NOCOPY VARCHAR2) IS
1383:
1384: CURSOR cr_expression_tests IS
1385: SELECT a.test_id,a.seq
1386: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b
1387: WHERE
1388: a.spec_id = p_spec_id
1389: AND a.test_id = b.test_id
1390: AND b.test_type = 'E' ;

Line 1407: FROM GMD_SPEC_TESTS_B

1403: END IF;
1404:
1405: -- atleast one test should be present in the spec.
1406: SELECT NVL(COUNT(1),0) INTO l_test_count
1407: FROM GMD_SPEC_TESTS_B
1408: WHERE spec_id = p_spec_id ;
1409:
1410: IF l_test_count = 0 THEN
1411: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');

Line 1673: FROM GMD_SPEC_TESTS_B

1669: BEGIN
1670:
1671: IF p_exclude_test_id IS NULL THEN
1672: SELECT 1 INTO dummy
1673: FROM GMD_SPEC_TESTS_B
1674: WHERE spec_id = p_spec_id
1675: AND seq = p_seq ;
1676: ELSE
1677: SELECT 1 INTO dummy

Line 1678: FROM GMD_SPEC_TESTS_B

1674: WHERE spec_id = p_spec_id
1675: AND seq = p_seq ;
1676: ELSE
1677: SELECT 1 INTO dummy
1678: FROM GMD_SPEC_TESTS_B
1679: WHERE spec_id = p_spec_id
1680: AND seq = p_seq
1681: AND test_id <> p_exclude_test_id ;
1682: END IF;

Line 1720: FROM GMD_SPEC_TESTS_B

1716:
1717: BEGIN
1718:
1719: SELECT 1 INTO dummy
1720: FROM GMD_SPEC_TESTS_B
1721: WHERE spec_id = p_spec_id
1722: AND test_id = p_test_id;
1723:
1724: RETURN TRUE;

Line 1763: FROM GMD_SPEC_TESTS_B

1759: WHERE test_id = p_exp_test_id;
1760:
1761: CURSOR c_spec_test (p_spec_id NUMBER, p_exp_test_seq NUMBER, p_ref_test_id NUMBER) IS
1762: SELECT 1
1763: FROM GMD_SPEC_TESTS_B
1764: WHERE spec_id = p_spec_id
1765: AND test_id = p_ref_test_id
1766: AND seq < p_exp_test_seq;
1767: