PROCEDURE deleteGroup(p_vo_group_name IN VARCHAR2, p_vo_group_company_nr IN VARCHAR2, p_vehicle_owner_id IN NUMBER) IS
v_vo_group_id NUMBER(10);
BEGIN
SELECT vo_group_id
INTO v_vo_group_id
FROM vo_group
WHERE vehicle_owner_id = p_vehicle_owner_id
AND LOWER(name) = LOWER(p_vo_group_name)
AND LOWER(company_nr) = LOWER(p_vo_group_company_nr);

DELETE FROM vo_group_person
WHERE vo_group_id = v_vo_group_id;

DELETE FROM vo_group_vehicle
WHERE vo_group_id = v_vo_group_id;

DELETE FROM vo_group_oc_poi
WHERE vo_group_id = v_vo_group_id;

DELETE FROM vo_group
WHERE vo_group_id = v_vo_group_id;

END;