APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_SPECIFICATIONS_B

Line 18: UPDATE gmd_specifications_b

14: ELSE
15: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
16: END IF;
17: IF l_signature_status = 'SUCCESS' THEN
18: UPDATE gmd_specifications_b
19: SET spec_status = p_to_status
20: WHERE spec_id = p_spec_id;
21: ELSIF l_signature_status = 'PENDING' THEN
22: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status

Line 26: UPDATE gmd_specifications_b

22: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status
23: ,p_to_status => p_to_status
24: ,p_entity_type => 'S');
25: IF l_pending_status IS NOT NULL THEN
26: UPDATE gmd_specifications_b
27: SET spec_status = l_pending_status
28: WHERE spec_id = p_spec_id;
29: END IF;
30: ELSIF l_signature_status = 'REJECTED' THEN

Line 35: UPDATE gmd_specifications_b

31: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status
32: ,p_to_status => p_to_status
33: ,p_entity_type => 'S');
34: IF l_rework_status IS NOT NULL THEN
35: UPDATE gmd_specifications_b
36: SET spec_status = l_rework_status
37: WHERE spec_id = p_spec_id;
38: END IF;
39: END IF;

Line 219: UPDATE gmd_specifications_b

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
219: UPDATE gmd_specifications_b
220: SET spec_status = p_to_status
221: WHERE spec_id = p_event_key
222: AND spec_status <> p_to_status;
223: END IF;