[Home] [Help]
148: , tm.resources, st.viability_duration
149: , st.test_qty
150: , st.test_qty_uom
151: , tm.test_method_id
152: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
153: WHERE st.spec_id = p_spec_id
154: AND st.exclude_ind IS NULL
155: AND ((p_lot_retest_ind IS NULL) OR
156: (st.retest_lot_expiry_ind = p_lot_retest_ind)
1334: tm.test_replicate,
1335: tm.test_method_id, -- 5353794
1336: tm.test_qty,
1337: tm.test_qty_uom
1338: FROM gmd_qc_tests_b t, gmd_test_methods_b tm
1339: WHERE t.test_id = p_test_id
1340: AND t.test_method_id = tm.test_method_id
1341: ;
1342:
1365: dummy PLS_INTEGER;
1366: out_var_idx PLS_INTEGER := 0;
1367: l_meaning VARCHAR2(80);
1368: l_viability_duration NUMBER;
1369: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;
1370:
1371: l_sample GMD_SAMPLES%ROWTYPE;
1372: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1373: l_results GMD_RESULTS%ROWTYPE;
1563: IF (l_additional_test_ind IS NULL) THEN
1564: -- Test is part of the Spec so get the replicate from spec.
1565: SELECT st.test_replicate, st.viability_duration, tm.resources
1566: INTO l_replicate,l_viability_duration, l_resources
1567: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
1568: WHERE st.spec_id = l_event_spec_disp.spec_id
1569: AND st.exclude_ind IS NULL
1570: AND st.test_id = p_test_ids(i)
1571: AND st.test_method_id = tm.test_method_id
2047: CURSOR c_spec_tests (p_spec_id NUMBER) IS
2048: SELECT st.test_id
2049: , st.test_replicate
2050: , tm.test_kit_inv_item_id
2051: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
2052: WHERE st.spec_id = p_spec_id
2053: AND st.exclude_ind IS NULL
2054: AND st.test_method_id = tm.test_method_id
2055: ;
2088:
2089: CURSOR c_get_type IS
2090: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2091: m.test_method_code
2092: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2093: WHERE t.test_id = l_test_id
2094: AND t.test_method_id = m.test_method_id;
2095:
2096: LocalTypeRec c_get_type%ROWTYPE;
2831:
2832: CURSOR c_get_type IS
2833: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2834: m.test_method_code
2835: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2836: WHERE t.test_id = l_test_id
2837: AND t.test_method_id = m.test_method_id;
2838: LocalTypeRec c_get_type%ROWTYPE;
2839:
2873: FROM gmd_results
2874: WHERE sample_id = p_sample_id;
2875:
2876: l_qc_test gmd_qc_tests%rowtype;
2877: l_test_mthd gmd_test_methods%rowtype;
2878:
2879: l_in_qc_test gmd_qc_tests%rowtype;
2880: l_in_test_mthd gmd_test_methods%rowtype;
2881:
2876: l_qc_test gmd_qc_tests%rowtype;
2877: l_test_mthd gmd_test_methods%rowtype;
2878:
2879: l_in_qc_test gmd_qc_tests%rowtype;
2880: l_in_test_mthd gmd_test_methods%rowtype;
2881:
2882: l_ret_sts BOOLEAN;
2883:
2884: BEGIN
2915: l_results_rec_tbl(i).test_type := l_qc_test.test_type;
2916: l_results_rec_tbl(i).unit := l_qc_test.test_unit;
2917:
2918: l_in_test_mthd.test_method_id := l_qc_test.test_method_id;
2919: l_ret_sts := GMD_TEST_METHODS_PVT.fetch_row(p_test_methods => l_in_test_mthd,
2920: x_test_methods => l_test_mthd);
2921: l_results_rec_tbl(i).method := l_test_mthd.test_method_code;
2922: l_results_rec_tbl(i).result_num := c_result_rec.result_value_num;
2923: l_results_rec_tbl(i).result_char:= c_result_rec.result_value_char;
4874: LocalComResRec c_get_composite_results%ROWTYPE;
4875:
4876: CURSOR c_get_type IS
4877: SELECT t.test_type, t.test_code, t.test_method_id, m.test_method_code
4878: FROM gmd_qc_tests_b t , gmd_test_methods_b m
4879: WHERE t.test_id = l_test_id
4880: AND t.test_method_id = m.test_method_id;
4881: LocalTypeRec c_get_type%ROWTYPE;
4882: