APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_QC_TESTS

Line 28: FROM gmd_qc_tests_b

24:
25: FUNCTION get_test_code(p_test_id IN NUMBER) RETURN VARCHAR2 IS
26: cursor get_test IS
27: SELECT TEST_CODE
28: FROM gmd_qc_tests_b
29: WHERE test_id = p_test_id;
30:
31: l_test_code gmd_qc_tests_b.test_code%TYPE;
32: BEGIN

Line 31: l_test_code gmd_qc_tests_b.test_code%TYPE;

27: SELECT TEST_CODE
28: FROM gmd_qc_tests_b
29: WHERE test_id = p_test_id;
30:
31: l_test_code gmd_qc_tests_b.test_code%TYPE;
32: BEGIN
33: OPEN get_test;
34: FETCH get_test INTO l_test_code;
35: CLOSE get_test;

Line 165: l_test_code gmd_qc_tests_b.test_code%TYPE;

161: c_get_composite_test_row c_get_composite_test%ROWTYPE;
162: l_common_test_count NUMBER:=0;
163: l_child_composite_result_id NUMBER;
164: l_place NUMBER;
165: l_test_code gmd_qc_tests_b.test_code%TYPE;
166:
167:
168:
169: BEGIN

Line 399: FROM gmd_qc_tests t,gmd_units b, gmd_test_methods_b tm

395: below_max_action_code, above_max_action_code,
396: priority,
397: t.display_precision, t.report_precision,
398: t.expression, tm.resources
399: FROM gmd_qc_tests t,gmd_units b, gmd_test_methods_b tm
400: WHERE t.test_id = p_test_id
401: AND t.test_method_id = tm.test_method_id
402: AND t.test_unit = b.qcunit_code (+) ;
403:

Line 485: l_tests_rec_in GMD_QC_TESTS%ROWTYPE;

481: l_spec_id NUMBER;
482: l_event_spec_disp_id NUMBER;
483: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
484: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
485: l_tests_rec_in GMD_QC_TESTS%ROWTYPE;
486: l_tests_rec GMD_QC_TESTS%ROWTYPE;
487: l_test_qty GMD_RESULTS.TEST_QTY%TYPE;
488: l_test_qty_uom GMD_RESULTS.TEST_QTY_UOM%TYPE;
489:

Line 486: l_tests_rec GMD_QC_TESTS%ROWTYPE;

482: l_event_spec_disp_id NUMBER;
483: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
484: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
485: l_tests_rec_in GMD_QC_TESTS%ROWTYPE;
486: l_tests_rec GMD_QC_TESTS%ROWTYPE;
487: l_test_qty GMD_RESULTS.TEST_QTY%TYPE;
488: l_test_qty_uom GMD_RESULTS.TEST_QTY_UOM%TYPE;
489:
490: l_in_spec VARCHAR2(1);

Line 549: IF NOT GMD_QC_TESTS_PVT.fetch_row

545: FOR temp_table_rslt_row in c_temp_table_rslt LOOP
546: -- Get Test record for results
547: l_tests_rec_in.test_id := temp_table_rslt_row.test_id;
548: l_place := 15;
549: IF NOT GMD_QC_TESTS_PVT.fetch_row
550: ( p_gmd_qc_tests => l_tests_rec_in,
551: x_gmd_qc_tests => l_tests_rec) THEN
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;

Line 550: ( p_gmd_qc_tests => l_tests_rec_in,

546: -- Get Test record for results
547: l_tests_rec_in.test_id := temp_table_rslt_row.test_id;
548: l_place := 15;
549: IF NOT GMD_QC_TESTS_PVT.fetch_row
550: ( p_gmd_qc_tests => l_tests_rec_in,
551: x_gmd_qc_tests => l_tests_rec) THEN
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:

Line 551: x_gmd_qc_tests => l_tests_rec) THEN

547: l_tests_rec_in.test_id := temp_table_rslt_row.test_id;
548: l_place := 15;
549: IF NOT GMD_QC_TESTS_PVT.fetch_row
550: ( p_gmd_qc_tests => l_tests_rec_in,
551: x_gmd_qc_tests => l_tests_rec) THEN
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:
555: IF (l_debug = 'Y') THEN