APPS.GMD_QUALITY_GRP dependencies on GMD_RESULTS

Line 244: x_results GMD_RESULTS_GRP.gmd_results_rec_tbl;

240: )
241: IS
242: l_api_name VARCHAR2(100) := 'GET_INV_RESULT_TEST_VALUE';
243: x_sampling_events GMD_QUALITY_GRP.sampling_events_tbl_type;
244: x_results GMD_RESULTS_GRP.gmd_results_rec_tbl;
245: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;
246: l_return_status VARCHAR2(1);
247: l_composite_spec_disp_id NUMBER;
248: i NUMBER := 0;

Line 257: l_result_id gmd_results.result_id%TYPE;

253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;
258: l_result_value_num gmd_results.result_value_num%TYPE;
259: l_result_value_char gmd_results.result_value_char%TYPE;
260:
261: -- Cursor defn

Line 258: l_result_value_num gmd_results.result_value_num%TYPE;

254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;
258: l_result_value_num gmd_results.result_value_num%TYPE;
259: l_result_value_char gmd_results.result_value_char%TYPE;
260:
261: -- Cursor defn
262: -- Get simple results

Line 259: l_result_value_char gmd_results.result_value_char%TYPE;

255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;
258: l_result_value_num gmd_results.result_value_num%TYPE;
259: l_result_value_char gmd_results.result_value_char%TYPE;
260:
261: -- Cursor defn
262: -- Get simple results
263: Cursor get_simple_results(vSample_id NUMBER,

Line 267: FROM gmd_results sr,

263: Cursor get_simple_results(vSample_id NUMBER,
264: vEvent_Spec_disp_id NUMBER,
265: vTest_id NUMBER) IS
266: SELECT sr.result_id, sr.result_value_num, sr.result_value_char
267: FROM gmd_results sr,
268: gmd_spec_results spr
269: WHERE sr.sample_id = vSample_id
270: AND sr.test_id = vTest_id
271: AND spr.result_id = sr.result_id

Line 572: From gmd_samples s, gmd_results r

568: -- B3698232 Added dispostion 'In-Progress' and 'Complete' for single sample
569: -- AND sd.disposition IN ('4A','5AV')
570: AND sd.disposition IN ('2I', '3C', '4A','5AV')
571: AND EXISTS (Select 1
572: From gmd_samples s, gmd_results r
573: Where s.sample_id = r.sample_id
574: AND r.test_id = p_inv_rslt_inp_rec.test_id
575: AND s.organization_id = p_inv_rslt_inp_rec.organization_id
576: AND s.delete_mark = 0