--
-- acs_sc_operation__delete/1
--
create or replace function acs_sc_operation__delete(
  integer
) returns int4 as $$

declare
    p_operation_id		alias for $1;
begin

    delete from acs_sc_operations
    where operation_id = p_operation_id;

    return 0;

end;$$ language plpgsql;


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

declare
    p_contract_name		alias for $1;
    p_operation_name		alias for $2;
    v_operation_id		integer;
begin

    v_operation_id := acs_sc_operation__get_id(
		          p_contract_name,
			  p_operation_name
		      );

    perform acs_sc_operation__delete(v_operation_id);

    return v_operation_id;

end;$$ language plpgsql;