APPS.GMD_QC_ERES_UTILS dependencies on GMD_QC_STATUS_NEXT_PVT

Line 63: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status

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
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

Line 72: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status

68: SET spec_status = l_pending_status
69: WHERE spec_id = p_spec_id;
70: END IF;
71: ELSIF l_signature_status = 'REJECTED' THEN
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

Line 100: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status

96: update_vr_status(p_entity_type,
97: p_spec_vr_id,
98: p_to_status);
99: ELSIF l_signature_status = 'PENDING' THEN
100: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status
101: ,p_to_status => p_to_status
102: ,p_entity_type => 'S');
103: IF l_pending_status IS NOT NULL THEN
104: update_vr_status(p_entity_type,

Line 109: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status

105: p_spec_vr_id,
106: l_pending_status);
107: END IF;
108: ELSIF l_signature_status = 'REJECTED' THEN
109: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status
110: ,p_to_status => p_to_status
111: ,p_entity_type => 'S');
112: IF l_rework_status IS NOT NULL THEN
113: update_vr_status(p_entity_type,

Line 620: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status

616: GMD_API_PUB.RAISE('oracle.apps.gmd.qm.ss.test',p_ss_id);
617: END IF;
618:
619: ELSIF l_signature_status = 'PENDING' THEN
620: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status
621: ,p_to_status => p_to_status
622: ,p_entity_type => 'STABILITY');
623: IF l_pending_status IS NOT NULL THEN
624: UPDATE gmd_stability_studies_b

Line 629: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status

625: SET status = l_pending_status
626: WHERE ss_id = p_ss_id;
627: END IF;
628: ELSIF l_signature_status = 'REJECTED' THEN
629: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status
630: ,p_to_status => p_to_status
631: ,p_entity_type => 'STABILITY');
632: IF l_rework_status IS NOT NULL THEN
633: UPDATE gmd_stability_studies_b