872: where WPA.PROCESS_NAME = c_name
873: and WPA.PROCESS_ITEM_TYPE = c_item_type
874: and WPA.PROCESS_VERSION = ver.version);
875:
876: delete from WF_ACTIVITY_TRANSITIONS WAT
877: where WAT.TO_PROCESS_ACTIVITY in
878: (select WPA.INSTANCE_ID
879: from WF_PROCESS_ACTIVITIES WPA
880: where WPA.PROCESS_NAME = c_name
880: where WPA.PROCESS_NAME = c_name
881: and WPA.PROCESS_ITEM_TYPE = c_item_type
882: and WPA.PROCESS_VERSION = ver.version);
883:
884: delete from WF_ACTIVITY_TRANSITIONS WAT
885: where WAT.FROM_PROCESS_ACTIVITY in
886: (select WPA.INSTANCE_ID
887: from WF_PROCESS_ACTIVITIES WPA
888: where WPA.PROCESS_NAME = c_name