--
-- acs_object__package_id/1
--
create or replace function acs_object__package_id(
  integer
) returns int4 as $$

declare
  p_object_id  alias for $1;
  v_package_id acs_objects.package_id%TYPE;
begin
  if p_object_id is null then
    return null;
  end if;

  select package_id into v_package_id
  from acs_objects
  where object_id = p_object_id;

  return v_package_id;
end;$$ language plpgsql;