APPS.GMD_SPEC_GRP dependencies on GMD_QC_TESTS

Line 380: FROM gmd_qc_tests_b

376:
377:
378: CURSOR cr_test(p_test_id NUMBER) IS
379: SELECT test_code,test_method_id,test_type,min_value_num,max_value_num,priority
380: FROM gmd_qc_tests_b
381: WHERE test_id = p_test_id
382: AND delete_mark = 0 ;
383:
384: CURSOR cr_test_method_valid(p_test_method_id NUMBER) IS

Line 399: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;

395:
396: l_temp VARCHAR2(1);
397: l_grade_ctl NUMBER(1);
398: l_test_type VARCHAR2(1);
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;

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

633:
634: IF x_spec_tests.test_priority IS NULL THEN
635: x_spec_tests.test_priority := l_test_priority;
636:
637: ELSIF (NOT GMD_QC_TESTS_GRP.validate_test_priority(p_test_priority => x_spec_tests.test_priority)) THEN
638: GMD_API_PUB.Log_Message('GMD_INVALID_TEST_PRIORITY');
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:

Line 1111: l_test GMD_QC_TESTS%ROWTYPE;

1107:
1108:
1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1111: l_test GMD_QC_TESTS%ROWTYPE;
1112: l_test_out GMD_QC_TESTS%ROWTYPE;
1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1114: -- Bug 3401368
1115: x_viability_time NUMBER;

Line 1112: l_test_out GMD_QC_TESTS%ROWTYPE;

1108:
1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1111: l_test GMD_QC_TESTS%ROWTYPE;
1112: l_test_out GMD_QC_TESTS%ROWTYPE;
1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1114: -- Bug 3401368
1115: x_viability_time NUMBER;
1116: x_viability_status varchar2(100);

Line 1165: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(

1161:
1162:
1163: -- Fetch Test Record.
1164: l_test.test_id := x_spec_test.test_id;
1165: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1166: p_gmd_qc_tests => l_test,
1167: x_gmd_qc_tests => l_test_out)
1168: ) THEN
1169: -- Fetch Error

Line 1166: p_gmd_qc_tests => l_test,

1162:
1163: -- Fetch Test Record.
1164: l_test.test_id := x_spec_test.test_id;
1165: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1166: p_gmd_qc_tests => l_test,
1167: x_gmd_qc_tests => l_test_out)
1168: ) THEN
1169: -- Fetch Error
1170: RAISE e_test_fetch_error;

Line 1167: x_gmd_qc_tests => l_test_out)

1163: -- Fetch Test Record.
1164: l_test.test_id := x_spec_test.test_id;
1165: IF NOT ( GMD_QC_TESTS_PVT.Fetch_Row(
1166: p_gmd_qc_tests => l_test,
1167: x_gmd_qc_tests => l_test_out)
1168: ) THEN
1169: -- Fetch Error
1170: RAISE e_test_fetch_error;
1171: END IF;

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