APPS.GMD_QC_ERES_UTILS dependencies on GMD_SPECIFICATIONS

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;

Line 742: FROM gmd_specifications

738: PROCEDURE get_spec_name(p_spec_id VARCHAR2,
739: p_spec_name OUT NOCOPY VARCHAR2) IS
740: CURSOR cur_get_spec_name IS
741: SELECT SPEC_NAME
742: FROM gmd_specifications
743: WHERE SPEC_ID = p_spec_id ;
744: BEGIN
745: OPEN cur_get_spec_name;
746: FETCH cur_get_spec_name INTO p_spec_name;

Line 754: FROM gmd_specifications

750: PROCEDURE get_spec_vers(p_spec_id VARCHAR2,
751: p_spec_vers OUT NOCOPY VARCHAR2) IS
752: CURSOR cur_get_spec_vers IS
753: SELECT SPEC_VERS
754: FROM gmd_specifications
755: WHERE SPEC_ID = p_spec_id ;
756: BEGIN
757: OPEN cur_get_spec_vers;
758: FETCH cur_get_spec_vers INTO p_spec_vers;