ACS3 Data Model

     1: function short_name_from_group_name
     2: (v_group_name IN user_groups.group_name%TYPE)
     3:      return varchar
     4:      IS
     5:      BEGIN
     6: 	return short_name_from_group_name2(lower(substr(translate(v_group_name, '_ ','--'), 1, 80)), 0);
     7:      END short_name_from_group_name;