DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on GMD_CUSTOMER_SPEC_VRS

Line 133: UPDATE gmd_customer_spec_vrs

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
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

Line 166: FROM gmd_customer_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
166: FROM gmd_customer_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

Line 245: UPDATE gmd_customer_spec_vrs

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
244:
245: UPDATE gmd_customer_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