ACS3 Data Model

     1: function enabled_section_p
     2:        ( v_section_id content_sections.section_id%TYPE)
     3:      return varchar
     4:      is
     5:        v_enabled_p char(1);
     6:      BEGIN
     7:        select enabled_p into v_enabled_p
     8:          from content_sections
     9:          where section_id = v_section_id;
    10: 
    11:       if v_enabled_p is null then
    12:          return 'f';
    13:        else
    14:          return v_enabled_p;
    15:        end if;
    16:      END enabled_section_p;