ACS3 Data Model

     1: function pretty_name_from_module_key (v_module_key IN acs_modules.module_key%TYPE)
     2:      return varchar
     3:      IS
     4: 	v_pretty_name acs_modules.pretty_name%TYPE;
     5:      BEGIN
     6: 	select pretty_name into v_pretty_name
     7: 	from acs_modules
     8: 	where module_key=v_module_key;
     9: 
    10: 	return v_pretty_name;
    11: 
    12:      END pretty_name_from_module_key;