APPS.GMD_QC_ERES_UTILS dependencies on GMD_SPECIFICATIONS_B

Line 59: UPDATE gmd_specifications_b

55:
56: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
57:
58: IF l_signature_status = 'SUCCESS' THEN
59: UPDATE gmd_specifications_b
60: SET spec_status = p_to_status
61: WHERE spec_id = p_spec_id;
62: ELSIF l_signature_status = 'PENDING' THEN
63: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status

Line 67: UPDATE gmd_specifications_b

63: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status
64: ,p_to_status => p_to_status
65: ,p_entity_type => 'S');
66: IF l_pending_status IS NOT NULL THEN
67: UPDATE gmd_specifications_b
68: SET spec_status = l_pending_status
69: WHERE spec_id = p_spec_id;
70: END IF;
71: ELSIF l_signature_status = 'REJECTED' THEN

Line 76: UPDATE gmd_specifications_b

72: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status
73: ,p_to_status => p_to_status
74: ,p_entity_type => 'S');
75: IF l_rework_status IS NOT NULL THEN
76: UPDATE gmd_specifications_b
77: SET spec_status = l_rework_status
78: WHERE spec_id = p_spec_id;
79: END IF;
80: END IF;

Line 255: UPDATE gmd_specifications_b

251: SET spec_vr_status = p_to_status
252: WHERE spec_vr_id = p_event_key
253: AND spec_vr_status <> p_to_status;
254: ELSIF p_event = 'oracle.apps.gmd.qm.spec' THEN
255: UPDATE gmd_specifications_b
256: SET spec_status = p_to_status
257: WHERE spec_id = p_event_key
258: AND spec_status <> p_to_status;
259: END IF;