DBA Data[Home] [Help]

APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_CUSTOMER_SPEC_VRS

Line 96: UPDATE gmd_customer_spec_vrs

92: UPDATE gmd_wip_spec_vrs
93: SET spec_vr_status = p_to_status
94: WHERE spec_vr_id = pspec_vr_id;
95: ELSIF(pentity_type = 'C') THEN
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

Line 132: from GMD_CUSTOMER_SPEC_VRS

128: where spec_id = p_spec_id
129: and spec_vr_status < p_to_status
130: UNION
131: select spec_vr_id,'C' spec_type
132: from GMD_CUSTOMER_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

Line 209: UPDATE gmd_customer_spec_vrs

205: SET spec_vr_status = p_to_status
206: WHERE spec_vr_id = p_event_key
207: AND spec_vr_status <> p_to_status;
208: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.cus' THEN
209: UPDATE gmd_customer_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