APPS.GMD_ERES_UTILS dependencies on GMD_FORMULATION_SPECS

Line 530: UPDATE gmd_formulation_specs

526: l_rework_status gmd_status.status_code%TYPE;
527: BEGIN
528:
529: IF p_signature_status = 'SUCCESS' THEN
530: UPDATE gmd_formulation_specs
531: SET spec_status = p_to_status
532: WHERE formulation_spec_id = p_formulation_spec_id;
533: ELSIF p_signature_status = 'PENDING' THEN
534: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 537: UPDATE gmd_formulation_specs

533: ELSIF p_signature_status = 'PENDING' THEN
534: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
535: ,p_to_status => p_to_status);
536: IF l_pending_status IS NOT NULL THEN
537: UPDATE gmd_formulation_specs
538: SET spec_status = l_pending_status
539: WHERE formulation_spec_id = p_formulation_spec_id;
540: END IF;
541: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 545: UPDATE gmd_formulation_specs

541: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
542: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
543: ,p_to_status => p_to_status);
544: IF l_rework_status IS NOT NULL THEN
545: UPDATE gmd_formulation_specs
546: SET spec_status = l_rework_status
547: WHERE formulation_spec_id = p_formulation_spec_id;
548: END IF;
549: END IF;