-- -- 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;