APPS.GMD_QC_ERES_UTILS dependencies on GMD_STABILITY_STUDIES_B

Line 607: UPDATE gmd_stability_studies_b

603:
604: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
605:
606: IF l_signature_status = 'SUCCESS' THEN
607: UPDATE gmd_stability_studies_b
608: SET status = p_to_status
609: WHERE ss_id = p_ss_id;
610:
611: IF (p_to_status = 400) THEN

Line 624: UPDATE gmd_stability_studies_b

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
625: SET status = l_pending_status
626: WHERE ss_id = p_ss_id;
627: END IF;
628: ELSIF l_signature_status = 'REJECTED' THEN

Line 633: UPDATE gmd_stability_studies_b

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
634: SET status = l_rework_status
635: WHERE ss_id = p_ss_id;
636: END IF;
637: END IF;