2926: -- Added code to populate material_detail_id so that Line and Type fields are populated when queried from the applications
2927: l_material_detail_id := NULL;
2928: IF v_samp_rec.source = 'W' AND v_samp_rec.batch_id IS NOT NULL AND v_samp_rec.formulaline_id IS NOT NULL THEN
2929: SELECT material_detail_id INTO l_material_detail_id
2930: FROM gme_material_details
2931: WHERE batch_id = v_samp_rec.batch_id
2932: AND formulaline_id = v_samp_rec.formulaline_id;
2933: END IF;
2934:
5186: l_material_detail_id := NULL;
5187: IF l_wip_spec.batch_id IS NOT NULL AND l_wip_spec.formulaline_id IS NOT NULL THEN
5188: BEGIN
5189: SELECT material_detail_id INTO l_material_detail_id
5190: FROM gme_material_details
5191: WHERE batch_id = l_wip_spec.batch_id
5192: AND formulaline_id = l_wip_spec.formulaline_id;
5193: EXCEPTION
5194: WHEN OTHERS THEN