create or replace procedure tmd.etl_sp_start_wf
	(
	wf_name IN varchar(100),
	wf_load_id_new INOUT numeric
	)
LANGUAGE plpgsql
AS $$
DECLARE
	wf_id integer;
	wf_load_id integer;
	--wf_load_id_new tmd.etl_wf_load.wf_load_id%TYPE;
BEGIN
 wf_load_id_new := NULL; 
 
 select wf_id
 into wf_id
 from tmd.etl_wf
 where wf_name = wf_name;
 
 if wf_id is null then
   RAISE EXCEPTION 'Unknown name of Workflow %', wf_name;
 END IF;
 
 Select wf_load_id
 into wf_load_id
 from tmd.etL_wf_load
 where wf_id = wf_id 
 		and (end_date is NULL or status = 'START');
		
 if wf_load_id is not null then
   RAISE EXCEPTION 'Workflow is already running, wf_load_id %', wf_load_id;
 END IF;
 
 BEGIN 
 Insert into tmd.etl_wf_load(wf_id, status, start_date, end_date, description)
 Select 
 	wf_id = wf_id
   , status = 'START'
   , start_date = current_date
   , end_date = NULL
   ,description = NULL
   RETURNING wf_id INTO wf_load_id_new;
   COMMIT;
   --wf_load_id_new :=  wf_id;
 EXCEPTION 
  WHEN OTHERS THEN ROLLBACK;
END;
END;
$$

create or replace procedure tmd.etl_sp_start_wf
	(
	_wf_name IN varchar(100),
	wf_load_id_new INOUT numeric
	)
LANGUAGE plpgsql
AS $$
DECLARE
	_wf_id integer;
	_wf_load_id integer;
	--wf_load_id_new tmd.etl_wf_load.wf_load_id%TYPE;
BEGIN
 wf_load_id_new := NULL; 
BEGIN
 select wf_id
 into _wf_id
 from tmd.etl_wf
 where wf_name = _wf_name;
 
 if _wf_id is null then
   RAISE EXCEPTION 'Unknown name of Workflow %', _wf_name;
 END IF;
 
 Select wf_load_id
 into _wf_load_id
 from tmd.etL_wf_load
 where wf_id = _wf_id 
 		and (end_date is NULL or status = 'START');
		
 if _wf_load_id is not null then
   RAISE NOTICE 'Illegal operation: %', SQLERRM;
   RAISE EXCEPTION 'Workflow is already running, wf_load_id %', _wf_load_id;
 END IF;
 
insert into tmd.etl_wf_load(wf_id, status, start_date, end_date, description)
values(_wf_id, 'START', current_date, NULL, NULL);
   COMMIT;
   wf_load_id_new :=  _wf_id;
 EXCEPTION 
  WHEN OTHERS THEN
   RAISE NOTICE 'Rollback'; 
   RAISE NOTICE 'Illegal operation: %', SQLERRM;
  ROLLBACK;
END;
END;
$$

При вызове 
DO
$$
DECLARE res numeric;
BEGIN
    CALL tmd.etl_sp_start_wf('dev_wf_r_ai_fx_spreds_model', res);
    RAISE NOTICE '%', res;
END
$$