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_