APPS.GMD_ERES_UTILS dependencies on GMD_FORMULATION_SPECS

Line 532: UPDATE gmd_formulation_specs

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

Line 539: UPDATE gmd_formulation_specs

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

Line 547: UPDATE gmd_formulation_specs

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