ACS3 Data Model

     1: function uniq_group_module_section_key2
     2: (v_module_key IN acs_modules.module_key%TYPE, v_group_id IN user_groups.group_id%TYPE, v_identifier IN integer)
     3:      return varchar
     4:      IS
     5:         v_new_section_key content_sections.section_key%TYPE;
     6: 
     7: 	cursor c1 is select section_key
     8: 	from content_sections
     9: 	where scope='group'
    10: 	and group_id=v_group_id
    11: 	and section_key=v_module_key || decode(v_identifier, 0, '', v_identifier);
    12:      BEGIN
    13: 	OPEN c1;
    14: 	FETCH c1 into v_new_section_key;
    15: 
    16: 	if c1%NOTFOUND then
    17: 	    select v_module_key || decode(v_identifier, 0, '', v_identifier) into v_new_section_key from dual;
    18: 	    return v_new_section_key;
    19:         else
    20: 	    return uniq_group_module_section_key2(v_module_key, v_group_id, v_identifier+1);
    21: 	end if;
    22: 
    23:      END uniq_group_module_section_key2;