--
-- acs_event__get_value/1
--
create or replace function acs_event__get_value(
  character varying
) returns varchar as $$
	-- return apm_parameter_values.attr_value%TYPE
declare
       get_value__parameter_name	alias for $1;
       v_package_id			apm_packages.package_id%TYPE;
begin
       select package_id into v_package_id
       from   apm_packages
       where  package_key = 'acs-events';

       return apm__get_value(v_package_id, get_value__parameter_name);

end;$$ language plpgsql;