ACS3 Data Model

     1: function group_section_module_exists_p
     2: (v_module_key IN acs_modules.module_key%TYPE, v_group_id IN user_groups.group_id%TYPE)
     3:      return char
     4:      IS
     5:         v_dummy integer;
     6: 
     7: 	cursor c1 is select 1
     8: 	from content_sections
     9: 	where scope='group'
    10: 	and group_id=v_group_id
    11: 	and module_key=v_module_key;
    12:      BEGIN
    13: 	OPEN c1;
    14: 	FETCH c1 into v_dummy;
    15: 
    16: 	if c1%NOTFOUND then
    17: 	    return 'f';
    18:         else
    19: 	    return 't';
    20: 	end if;
    21: 
    22:      END group_section_module_exists_p;