APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_QC_STATUS_NEXT_PVT

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

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

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

27: SET spec_status = l_pending_status
28: WHERE spec_id = p_spec_id;
29: END IF;
30: ELSIF l_signature_status = 'REJECTED' THEN
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

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

58: update_vr_status(p_entity_type,
59: p_spec_vr_id,
60: p_to_status);
61: ELSIF l_signature_status = 'PENDING' THEN
62: l_pending_status := GMD_QC_STATUS_NEXT_PVT.get_pending_status(p_from_status => p_from_status
63: ,p_to_status => p_to_status
64: ,p_entity_type => 'S');
65: IF l_pending_status IS NOT NULL THEN
66: update_vr_status(p_entity_type,

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

67: p_spec_vr_id,
68: l_pending_status);
69: END IF;
70: ELSIF l_signature_status = 'REJECTED' THEN
71: l_rework_status := GMD_QC_STATUS_NEXT_PVT.get_rework_status(p_from_status => p_from_status
72: ,p_to_status => p_to_status
73: ,p_entity_type => 'S');
74: IF l_rework_status IS NOT NULL THEN
75: update_vr_status(p_entity_type,