delete FROM act_ru_task where PROC_INST_ID_
in
#{instId}
delete FROM act_ru_identitylink where PROC_INST_ID_
in
#{instId}
delete FROM act_ru_event_subscr where PROC_INST_ID_
in
#{instId}
delete FROM act_ru_variable where PROC_INST_ID_
in
#{instId}
delete FROM act_hi_varinst where PROC_INST_ID_
in
#{instId}
delete FROM act_hi_taskinst where PROC_INST_ID_
in
#{instId}
delete FROM act_hi_procinst where PROC_INST_ID_
in
#{instId}
delete FROM act_hi_identitylink where PROC_INST_ID_
in
#{instId}
delete FROM act_hi_actinst where PROC_INST_ID_
in
#{instId}
delete FROM act_ru_execution where PROC_INST_ID_
in
#{instId}
delete FROM act_ru_execution where PROC_INST_ID_
in
#{instId}
AND ID_ != PARENT_ID_
delete FROM act_ru_variable where execution_id_ in (
select id_ from act_ru_execution where PROC_INST_ID_
in
#{instId}
AND ID_ != PARENT_ID_
)
UPDATE act_ru_execution SET IS_SCOPE_ = 0,IS_ACTIVE_ = 0,ACT_ID_=#{actId},CACHED_ENT_STATE_=1 WHERE PARENT_ID_=#{parentId} AND ID_ != #{execId}
UPDATE act_ru_execution SET IS_SCOPE_ = false,IS_ACTIVE_ = false,ACT_ID_=#{actId},CACHED_ENT_STATE_=1 WHERE PARENT_ID_=#{parentId} AND ID_ != #{execId}
delete FROM act_ru_execution where PARENT_ID_
in
#{parentId}
AND ID_ != PARENT_ID_