eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_PURGE dependencies on WF_ACTIVITY

Line 874: delete from WF_ACTIVITY_ATTR_VALUES WAAV

870: -- Purge the activity if no reference found
871:
872: -- Delete any process activities and
873: -- their attribute values and transitions
874: delete from WF_ACTIVITY_ATTR_VALUES WAAV
875: where WAAV.PROCESS_ACTIVITY_ID in
876: (select WPA.INSTANCE_ID
877: from WF_PROCESS_ACTIVITIES WPA
878: where WPA.PROCESS_NAME = c_name

Line 882: delete from WF_ACTIVITY_TRANSITIONS WAT

878: where WPA.PROCESS_NAME = c_name
879: and WPA.PROCESS_ITEM_TYPE = c_item_type
880: and WPA.PROCESS_VERSION = ver.version);
881:
882: delete from WF_ACTIVITY_TRANSITIONS WAT
883: where WAT.TO_PROCESS_ACTIVITY in
884: (select WPA.INSTANCE_ID
885: from WF_PROCESS_ACTIVITIES WPA
886: where WPA.PROCESS_NAME = c_name

Line 890: delete from WF_ACTIVITY_TRANSITIONS WAT

886: where WPA.PROCESS_NAME = c_name
887: and WPA.PROCESS_ITEM_TYPE = c_item_type
888: and WPA.PROCESS_VERSION = ver.version);
889:
890: delete from WF_ACTIVITY_TRANSITIONS WAT
891: where WAT.FROM_PROCESS_ACTIVITY in
892: (select WPA.INSTANCE_ID
893: from WF_PROCESS_ACTIVITIES WPA
894: where WPA.PROCESS_NAME = c_name

Line 904: delete from WF_ACTIVITY_ATTRIBUTES_TL WAAT

900: and WPA.PROCESS_ITEM_TYPE = c_item_type
901: and WPA.PROCESS_VERSION = ver.version;
902:
903: -- Delete activity attributes and _tl
904: delete from WF_ACTIVITY_ATTRIBUTES_TL WAAT
905: where WAAT.ACTIVITY_NAME = c_name
906: and WAAT.ACTIVITY_ITEM_TYPE = c_item_type
907: and WAAT.ACTIVITY_VERSION = ver.version;
908:

Line 909: delete from WF_ACTIVITY_ATTRIBUTES WAA

905: where WAAT.ACTIVITY_NAME = c_name
906: and WAAT.ACTIVITY_ITEM_TYPE = c_item_type
907: and WAAT.ACTIVITY_VERSION = ver.version;
908:
909: delete from WF_ACTIVITY_ATTRIBUTES WAA
910: where WAA.ACTIVITY_NAME = c_name
911: and WAA.ACTIVITY_ITEM_TYPE = c_item_type
912: and WAA.ACTIVITY_VERSION = ver.version;
913:

Line 974: Wf_Activity.ClearCache;

970: close actcurs3;
971: end if;
972:
973: -- Clear engine runtime cache for convenience
974: Wf_Activity.ClearCache;
975:
976: exception
977: when others then
978: if (actcurs1%ISOPEN) then