ACS3 Data Model

     1: function user_group_group_type (v_group_id IN user_groups.group_id%TYPE)
     2:      return varchar
     3:      IS
     4:         v_group_type user_group_types.group_type%TYPE;
     5: 
     6:      BEGIN
     7: 	select group_type into v_group_type
     8: 	from user_groups
     9: 	where group_id=v_group_id;
    10: 
    11: 	return v_group_type;
    12:      END user_group_group_type;