DBA Data[Home] [Help]

APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_SPEC_TESTS

Line 483: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;

479: l_return_status VARCHAR2(100);
480: -- l_sample_disp VARCHAR2(3);
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;

Line 484: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;

480: -- l_sample_disp VARCHAR2(3);
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;

Line 566: IF NOT GMD_SPEC_TESTS_PVT.fetch_row

562: l_spec_tests_in.spec_id := l_spec_id;
563:
564: l_place := 25;
565:
566: IF NOT GMD_SPEC_TESTS_PVT.fetch_row
567: ( p_spec_tests => l_spec_tests_in,
568: x_spec_tests => l_spec_tests) THEN
569: -- Assume that this is an additional test
570: -- For this sample.