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

declare
    p_contract_name		alias for $1;
    p_contract_desc		alias for $2;
    v_contract_id		integer;
begin

    v_contract_id := acs_object__new(
                null,
                'acs_sc_contract',
                now(),
                null,
                null,
                null
            );

    insert into acs_sc_contracts (
        contract_id,
        contract_name,
        contract_desc
    ) values (
        v_contract_id,
        p_contract_name,
        p_contract_desc
    );

    return v_contract_id;

end;$$ language plpgsql;