APPS.GMD_SPEC_GRP dependencies on GMD_QC_TESTS

Line 359: FROM gmd_qc_tests_b

355:
356:
357: CURSOR cr_test(p_test_id NUMBER) IS
358: SELECT test_code,test_method_id,test_type,min_value_num,max_value_num,priority
359: FROM gmd_qc_tests_b
360: WHERE test_id = p_test_id
361: AND delete_mark = 0 ;
362:
363: CURSOR cr_test_method_valid(p_test_method_id NUMBER) IS

Line 378: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;

374:
375: l_temp VARCHAR2(1);
376: l_grade_ctl NUMBER(1);
377: l_test_type VARCHAR2(1);
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;

Line 595: ELSIF (NOT GMD_QC_TESTS_GRP.validate_test_priority(p_test_priority => x_spec_tests.test_priority)) THEN

591:
592: IF x_spec_tests.test_priority IS NULL THEN
593: x_spec_tests.test_priority := l_test_priority;
594:
595: ELSIF (NOT GMD_QC_TESTS_GRP.validate_test_priority(p_test_priority => x_spec_tests.test_priority)) THEN
596: GMD_API_PUB.Log_Message('GMD_INVALID_TEST_PRIORITY');
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:

Line 1059: l_test GMD_QC_TESTS%ROWTYPE;

1055:
1056:
1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1059: l_test GMD_QC_TESTS%ROWTYPE;
1060: l_test_out GMD_QC_TESTS%ROWTYPE;
1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1062: -- Bug 3401368
1063: x_viability_time NUMBER;

Line 1060: l_test_out GMD_QC_TESTS%ROWTYPE;

1056:
1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1059: l_test GMD_QC_TESTS%ROWTYPE;
1060: l_test_out GMD_QC_TESTS%ROWTYPE;
1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1062: -- Bug 3401368
1063: x_viability_time NUMBER;
1064: x_viability_status varchar2(100);

Line 1113: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(

1109:
1110:
1111: -- Fetch Test Record.
1112: l_test.test_id := x_spec_test.test_id;
1113: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1114: p_gmd_qc_tests => l_test,
1115: x_gmd_qc_tests => l_test_out)
1116: ) THEN
1117: -- Fetch Error

Line 1114: p_gmd_qc_tests => l_test,

1110:
1111: -- Fetch Test Record.
1112: l_test.test_id := x_spec_test.test_id;
1113: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1114: p_gmd_qc_tests => l_test,
1115: x_gmd_qc_tests => l_test_out)
1116: ) THEN
1117: -- Fetch Error
1118: RAISE e_test_fetch_error;

Line 1115: x_gmd_qc_tests => l_test_out)

1111: -- Fetch Test Record.
1112: l_test.test_id := x_spec_test.test_id;
1113: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1114: p_gmd_qc_tests => l_test,
1115: x_gmd_qc_tests => l_test_out)
1116: ) THEN
1117: -- Fetch Error
1118: RAISE e_test_fetch_error;
1119: END IF;

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' ;