--
-- apm__register_p/1
--
create or replace function apm__register_p(
  character varying
) returns int4 as $$

declare
  register_p__package_key            alias for $1;  
  v_register_p                       integer;       
begin
    select case when count(*) = 0 then 0 else 1 end into v_register_p 
    from apm_package_types 
    where package_key = register_p__package_key;

    return v_register_p;
   
end;$$ language plpgsql;