[Home] [Help]
864: -- Purge the activity if no reference found
865:
866: -- Delete any process activities and
867: -- their attribute values and transitions
868: delete from WF_ACTIVITY_ATTR_VALUES WAAV
869: where WAAV.PROCESS_ACTIVITY_ID in
870: (select WPA.INSTANCE_ID
871: from WF_PROCESS_ACTIVITIES WPA
872: where WPA.PROCESS_NAME = c_name
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
894: and WPA.PROCESS_ITEM_TYPE = c_item_type
895: and WPA.PROCESS_VERSION = ver.version;
896:
897: -- Delete activity attributes and _tl
898: delete from WF_ACTIVITY_ATTRIBUTES_TL WAAT
899: where WAAT.ACTIVITY_NAME = c_name
900: and WAAT.ACTIVITY_ITEM_TYPE = c_item_type
901: and WAAT.ACTIVITY_VERSION = ver.version;
902:
899: where WAAT.ACTIVITY_NAME = c_name
900: and WAAT.ACTIVITY_ITEM_TYPE = c_item_type
901: and WAAT.ACTIVITY_VERSION = ver.version;
902:
903: delete from WF_ACTIVITY_ATTRIBUTES WAA
904: where WAA.ACTIVITY_NAME = c_name
905: and WAA.ACTIVITY_ITEM_TYPE = c_item_type
906: and WAA.ACTIVITY_VERSION = ver.version;
907:
964: close actcurs3;
965: end if;
966:
967: -- Clear engine runtime cache for convenience
968: Wf_Activity.ClearCache;
969:
970: exception
971: when others then
972: if (actcurs1%ISOPEN) then