[Home] [Help]
196: , st.test_qty
197: , st.test_qty_uom
198: , tm.test_method_id
199: , tm.test_duration
200: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
201: WHERE st.spec_id = p_spec_id
202: AND st.exclude_ind IS NULL
203: AND ((p_lot_retest_ind IS NULL) OR
204: (st.retest_lot_expiry_ind = p_lot_retest_ind)
1409: tm.test_method_id, -- 5353794
1410: tm.test_qty,
1411: tm.test_qty_uom,
1412: tm.test_duration -- Bug 13476354
1413: FROM gmd_qc_tests_b t, gmd_test_methods_b tm
1414: WHERE t.test_id = p_test_id
1415: AND t.test_method_id = tm.test_method_id
1416: ;
1417:
1440: dummy PLS_INTEGER;
1441: out_var_idx PLS_INTEGER := 0;
1442: l_meaning VARCHAR2(80);
1443: l_viability_duration NUMBER;
1444: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;
1445:
1446: l_sample GMD_SAMPLES%ROWTYPE;
1447: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1448: l_results GMD_RESULTS%ROWTYPE;
1640: IF (l_additional_test_ind IS NULL) THEN
1641: -- Test is part of the Spec so get the replicate from spec.
1642: SELECT st.test_replicate, st.viability_duration, tm.resources
1643: INTO l_replicate,l_viability_duration, l_resources
1644: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
1645: WHERE st.spec_id = l_event_spec_disp.spec_id
1646: AND st.exclude_ind IS NULL
1647: AND st.test_id = p_test_ids(i)
1648: AND st.test_method_id = tm.test_method_id
2134: CURSOR c_spec_tests (p_spec_id NUMBER) IS
2135: SELECT st.test_id
2136: , st.test_replicate
2137: , tm.test_kit_inv_item_id
2138: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
2139: WHERE st.spec_id = p_spec_id
2140: AND st.exclude_ind IS NULL
2141: AND st.test_method_id = tm.test_method_id
2142: ;
2175:
2176: CURSOR c_get_type IS
2177: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2178: m.test_method_code
2179: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2180: WHERE t.test_id = l_test_id
2181: AND t.test_method_id = m.test_method_id;
2182:
2183: LocalTypeRec c_get_type%ROWTYPE;
2999:
3000: CURSOR c_get_type IS
3001: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
3002: m.test_method_code
3003: FROM gmd_qc_tests_b t , gmd_test_methods_b m
3004: WHERE t.test_id = l_test_id
3005: AND t.test_method_id = m.test_method_id;
3006: LocalTypeRec c_get_type%ROWTYPE;
3007:
3041: FROM gmd_results
3042: WHERE sample_id = p_sample_id;
3043:
3044: l_qc_test gmd_qc_tests%rowtype;
3045: l_test_mthd gmd_test_methods%rowtype;
3046:
3047: l_in_qc_test gmd_qc_tests%rowtype;
3048: l_in_test_mthd gmd_test_methods%rowtype;
3049:
3044: l_qc_test gmd_qc_tests%rowtype;
3045: l_test_mthd gmd_test_methods%rowtype;
3046:
3047: l_in_qc_test gmd_qc_tests%rowtype;
3048: l_in_test_mthd gmd_test_methods%rowtype;
3049:
3050: l_ret_sts BOOLEAN;
3051:
3052: BEGIN
3083: l_results_rec_tbl(i).test_type := l_qc_test.test_type;
3084: l_results_rec_tbl(i).unit := l_qc_test.test_unit;
3085:
3086: l_in_test_mthd.test_method_id := l_qc_test.test_method_id;
3087: l_ret_sts := GMD_TEST_METHODS_PVT.fetch_row(p_test_methods => l_in_test_mthd,
3088: x_test_methods => l_test_mthd);
3089: l_results_rec_tbl(i).method := l_test_mthd.test_method_code;
3090: l_results_rec_tbl(i).result_num := c_result_rec.result_value_num;
3091: l_results_rec_tbl(i).result_char:= c_result_rec.result_value_char;
5043: LocalComResRec c_get_composite_results%ROWTYPE;
5044:
5045: CURSOR c_get_type IS
5046: SELECT t.test_type, t.test_code, t.test_method_id, m.test_method_code
5047: FROM gmd_qc_tests_b t , gmd_test_methods_b m
5048: WHERE t.test_id = l_test_id
5049: AND t.test_method_id = m.test_method_id;
5050: LocalTypeRec c_get_type%ROWTYPE;
5051: