ACS3 Data Model

     1: procedure user_group_member_field_add (v_group_id   IN integer,
     2:                                                          v_field_name IN varchar,
     3:                                                          v_field_type IN varchar,
     4:                                                          v_sort_key   IN integer)
     5: IS
     6:   n_groups          integer;
     7: BEGIN
     8:   -- make sure we don't violate the unique constraint of user_groups_member_fields
     9:   select decode(count(1),0,0,1) into n_groups
    10:     from all_member_fields_for_group
    11:    where group_id = v_group_id
    12:      and field_name = v_field_name;
    13: 
    14:   if n_groups = 0 then
    15:      -- member_field is new - add it
    16: 
    17:      insert into user_group_member_fields
    18:      (group_id, field_name, field_type, sort_key)
    19:      values
    20:      (v_group_id, v_field_name, v_field_type, v_sort_key);
    21: 
    22:    end if;
    23: end;