mysql:='update dispatch_entitylog '||

'set sendstatus=1, receiveuserid='||n_userId||','||

'receivedate=sysdate,receivestatus=1,'||

'receiveusername=(select u.realname from tbuser u where u.userid='||n_userId||'),'||

'receiveentityname=(select e1.entityname from tbuser u, tbentity e1 where u.currententityid=e1.entityid and u.userid='||n_userId||'),'||

'receiveorgname=(select e2.entityname from tbuser u, tbentity e1, tbentity e2 where u.currententityid=e1.entityid and e1.belongedentityid = e2.entityid and u.userid = '||n_userId||') '||

'where nFlowId='||n_nFlowId||' and receivedate is null and nProcId = 64'; -- 承办部门修改，其它暂时不修改

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql:='insert into wf_proc_flow (nFlowId,nDocId, nProcId, nDocsortId, '||

'dRecvDate,dFnshDate, nFinishStatus,nOrder, nAndOr)'||

'select '||n_nFlowId||', '||n_nDocId||', 64, 1, sysdate,sysdate,1, 0,0 from dual where not exists '||

'(select nFlowId from wf_proc_flow where nDocId='||n_nDocId||' '||

'and nProcId=64 and nFlowId='||n_nFlowId||')';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql := 'update wf_proc_flow set cUserList='||to_char(n_userId)||' '||

'where nFlowId = '||n_nFlowId||' and nDocId='||n_nDocId||' '||

'and cUserList is null';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql := 'update wf_proc_flow set dFnshDate=sysdate, nFinishStatus=1 '||

'where nFlowId ='||n_nFlowId||' and nDocId='||n_nDocId||' '||

'and dFnshDate is null';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql := 'insert into wf_proc_action (nDocId, nUserId, nDocsortId, nProcId,dRecvDate,dFnshDate, nFinishStatus,nOrder, nAndOr, nFlowId) '||

'select '||n_nDocId||','||n_userId||',1,64,sysdate,sysdate,1,0,0,'||n_nFlowId||' '||

'from dual where not exists '||

'(select nFlowId from wf_proc_action where nDocId='||n_nDocId||' and nProcId=64 and nFlowId='||n_nFlowId||')';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql:= 'update wf_proc_action set nUserId='||n_userId||' '||

'where nFlowId ='||n_nFlowId||' and nDocId='||n_nDocId||' and nUserId is null';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql := 'update wf_proc_action set dFnshDate=sysdate, nFinishStatus=1 '||

'where nFlowId = '||n_nFlowId||' and nDocId='||n_nDocId||' and dFnshDate is null';

execute immediate mysql;

Dbms_Output.put_line(mysql);

mysql := 'delete from wf_doc_gw_entity where nFlowid='||n_nFlowId;