ACS3 Data Model

     1: function group_names_of_user_by_type ( p_user_id IN Integer, p_group_type IN varchar)
     2: Return varchar2 IS
     3: 	   v_counter integer;
     4: 	   v_return_string 	varchar(2000);
     5: 	CURSOR c_user_groups is
     6:            select group_name
     7: 	     from user_groups, user_group_map
     8: 	    where user_groups.group_id = user_group_map.group_id
     9: 	      and user_groups.group_type = p_group_type
    10: 	      and user_group_map.user_id = p_user_id;
    11: BEGIN
    12: 	v_counter := 0;
    13: 	for v_group_data in c_user_groups LOOP
    14: 		v_counter := v_counter + 1;
    15: 		if v_counter = 1 then
    16: 			v_return_string := v_group_data.group_name;
    17: 		else
    18: 			v_return_string := v_return_string || ', ' || v_group_data.group_name;
    19: 		end if;
    20: 	End Loop;
    21: 	Return v_return_string;
    22: END;