ACS3 Data Model

     1: function user_groups_number_submembers (v_parent_group_id IN integer)
     2: return integer
     3: IS
     4:   v_count   integer;
     5: BEGIN
     6:   select count(1) into v_count
     7:     from user_group_map
     8:    where group_id in (select group_id
     9:                         from user_groups
    10:                        where parent_group_id=v_parent_group_id);
    11:   return v_count;
    12: END;