--
-- acs_sc_contract__get_name/1
--
create or replace function acs_sc_contract__get_name(
  integer
) returns varchar as $$

declare
    p_contract_id		alias for $1;
    v_contract_name		varchar;
begin

    select contract_name into v_contract_name
    from acs_sc_contracts
    where contract_id = p_contract_id;

    return v_contract_name;

end;$$ language plpgsql;