DBA Data[Home] [Help]

APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_SUPPLIER_SPEC_VRS

Line 100: UPDATE gmd_supplier_spec_vrs

96: UPDATE gmd_customer_spec_vrs
97: SET spec_vr_status = p_to_status
98: WHERE spec_vr_id = pspec_vr_id;
99: ELSIF(pentity_type = 'S') THEN
100: UPDATE gmd_supplier_spec_vrs
101: SET spec_vr_status = p_to_status
102: WHERE spec_vr_id = pspec_vr_id;
103: ELSIF(pentity_type = 'M') THEN
104: UPDATE gmd_monitoring_spec_vrs

Line 137: from GMD_SUPPLIER_SPEC_VRS

133: where spec_id = p_spec_id
134: and spec_vr_status < p_to_status
135: UNION
136: select spec_vr_id,'S' spec_type
137: from GMD_SUPPLIER_SPEC_VRS
138: where spec_id = p_spec_id
139: and spec_vr_status < p_to_status
140: UNION
141: select spec_vr_id, rule_type spec_type -- R or L

Line 214: UPDATE gmd_supplier_spec_vrs

210: SET spec_vr_status = p_to_status
211: WHERE spec_vr_id = p_event_key
212: AND spec_vr_status <> p_to_status;
213: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.sup' THEN
214: UPDATE gmd_supplier_spec_vrs
215: SET spec_vr_status = p_to_status
216: WHERE spec_vr_id = p_event_key
217: AND spec_vr_status <> p_to_status;
218: ELSIF p_event = 'oracle.apps.gmd.qm.spec' THEN