-- -- workflow_case__finish_task/2 -- create or replace function workflow_case__finish_task( integer, integer ) returns int4 as $$ declare finish_task__task_id alias for $1; finish_task__journal_id alias for $2; v_case_id integer; begin select case_id into v_case_id from wf_tasks where task_id = finish_task__task_id; PERFORM workflow_case__fire_transition_internal ( finish_task__task_id, finish_task__journal_id ); PERFORM workflow_case__sweep_automatic_transitions ( v_case_id, finish_task__journal_id ); return 0; end;$$ language plpgsql;