DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on GMD_SUPPLIER_SPEC_VRS

Line 137: UPDATE gmd_supplier_spec_vrs

133: UPDATE gmd_customer_spec_vrs
134: SET spec_vr_status = p_to_status
135: WHERE spec_vr_id = pspec_vr_id;
136: ELSIF(pentity_type = 'S') THEN
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

Line 171: FROM gmd_supplier_spec_vrs v

167: WHERE v.spec_id = p_spec_id
168: AND v.spec_vr_status < p_to_status
169: UNION
170: SELECT v.spec_vr_id,'S' spec_type
171: FROM gmd_supplier_spec_vrs v
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

Line 250: UPDATE gmd_supplier_spec_vrs

246: SET spec_vr_status = p_to_status
247: WHERE spec_vr_id = p_event_key
248: AND spec_vr_status <> p_to_status;
249: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.sup' THEN
250: UPDATE gmd_supplier_spec_vrs
251: SET spec_vr_status = p_to_status
252: WHERE spec_vr_id = p_event_key
253: AND spec_vr_status <> p_to_status;
254: ELSIF p_event = 'oracle.apps.gmd.qm.spec' THEN