APPS.GMD_QC_ERES_UTILS dependencies on GMD_WIP_SPEC_VRS

Line 129: UPDATE gmd_wip_spec_vrs

125: UPDATE gmd_inventory_spec_vrs
126: SET spec_vr_status = p_to_status
127: WHERE spec_vr_id = pspec_vr_id;
128: ELSIF(pentity_type = 'W') THEN
129: UPDATE gmd_wip_spec_vrs
130: SET spec_vr_status = p_to_status
131: WHERE spec_vr_id = pspec_vr_id;
132: ELSIF(pentity_type = 'C') THEN
133: UPDATE gmd_customer_spec_vrs

Line 161: FROM gmd_wip_spec_vrs v

157: WHERE v.spec_id = p_spec_id
158: AND v.spec_vr_status < p_to_status
159: UNION
160: SELECT v.spec_vr_id,'W' spec_type
161: FROM gmd_wip_spec_vrs v
162: WHERE v.spec_id = p_spec_id
163: AND v.spec_vr_status < p_to_status
164: UNION
165: SELECT v.spec_vr_id,'C' spec_type

Line 239: UPDATE gmd_wip_spec_vrs

235: SET spec_vr_status = p_to_status
236: WHERE spec_vr_id = p_event_key
237: AND spec_vr_status <> p_to_status;
238: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.wip' THEN
239: UPDATE gmd_wip_spec_vrs
240: SET spec_vr_status = p_to_status
241: WHERE spec_vr_id = p_event_key
242: AND spec_vr_status <> p_to_status;
243: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.cus' THEN