ACS3 Data Model

     1: function user_groups_number_subgroups (v_group_id IN integer)
     2: return integer
     3: IS
     4:   v_count   integer;
     5: BEGIN
     6:   select count(1) into v_count from user_groups where parent_group_id = v_group_id;
     7:   return v_count;
     8: END;