--
-- acs_sc_impl__get_id/2
--
create or replace function acs_sc_impl__get_id(
  character varying,
  character varying
) returns int4 as $$

declare
    p_impl_contract_name	alias for $1;
    p_impl_name			alias for $2;
    v_impl_id			integer;
begin

    select impl_id into v_impl_id
    from acs_sc_impls
    where impl_name = p_impl_name
    and impl_contract_name = p_impl_contract_name;

    return v_impl_id;

end;$$ language plpgsql;