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

declare
    p_contract_name             alias for $1;
    v_contract_id               integer;
begin

    select contract_id into v_contract_id
    from acs_sc_contracts
    where contract_name = p_contract_name;

    return v_contract_id;

end;$$ language plpgsql;