APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on AHL_ROUTES_B
Line 822: UPDATE ahl_routes_b
818: OPEN get_route_status (p_object_id);
819: FETCH get_route_status INTO l_obj_status;
820: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
821: THEN 822: UPDATE ahl_routes_b 823: SET revision_status_code = 'DRAFT'
824: WHERE route_id = p_object_id;
825: END IF;
826: CLOSE get_route_status;