137: UPDATE gmd_supplier_spec_vrs
138: SET spec_vr_status = p_to_status
139: WHERE spec_vr_id = pspec_vr_id;
140: ELSIF(pentity_type = 'M') THEN
141: UPDATE gmd_monitoring_spec_vrs
142: SET spec_vr_status = p_to_status
143: WHERE spec_vr_id = pspec_vr_id;
144: END IF;
145:
172: WHERE v.spec_id = p_spec_id
173: AND v.spec_vr_status < p_to_status
174: UNION
175: SELECT v.spec_vr_id,v.rule_type
176: FROM gmd_monitoring_spec_vrs v
177: WHERE v.spec_id = p_spec_id
178: AND v.spec_vr_status < p_to_status
179: UNION
180: SELECT v.spec_vr_id,'T' spec_type