The following lines contain the word 'select', 'insert', 'update' or 'delete':
ItemAttrValues.DELETE;
Activities.DELETE;
ActivityAttributes.DELETE;
ActivityAttrValues.DELETE;
ActivityTransitions.DELETE;
ItemAttributes.DELETE;
ItemTypes.DELETE;
ProcessActivities.DELETE;
NLSParameters.DELETE;
Activities.DELETE;
ActivityTransitions.DELETE;
ActivityAttributes.DELETE;
Activities.DELETE;
ProcessActivities.DELETE;
ActivityAttrValues.DELETE;
ItemAttributes.DELETE;
ItemTypes.DELETE;
ProcessActivities.DELETE;
ProcessStartActivities.DELETE;
| has been updated by wfload. |
+===============================================*/
FUNCTION MetaRefreshed return BOOLEAN is
l_UpdateTime DATE;
| last updated. |
+----------------------------------------*/
begin
select to_date(text, WF_ENGINE.date_format) into l_UpdateTime
from WF_RESOURCES
where TYPE='WFTKN'
and NAME = 'WFCACHE_META_UPD'
and LANGUAGE = 'US';
if ( l_UpdateTime > CacheSessionID ) then
/*---------------------------------------+
| The itemType was updated. We will |
| Clear the cache and reset our |
| CacheSessionID for a new Caching |
| session |
+---------------------------------------*/
WF_CACHE.Clear;
| This api will update the WFCACHE_META_UPD |
| resource token to the current sysdate to |
| cause any running caches to be cleared. This |
| code is called by WF_LOAD when an upload event|
| has taken place. |
+===============================================*/
PROCEDURE Reset IS
BEGIN
if ((NOT trustedTransaction) or (trustedTransaction is NULL)) then
-- We will update the token to the current sysdate.
update WF_RESOURCES set text = to_char(sysdate,
WF_ENGINE.date_format)
where name = 'WFCACHE_META_UPD';
insert into WF_RESOURCES (TYPE, NAME, LANGUAGE,SOURCE_LANG, ID,
TEXT, PROTECT_LEVEL, CUSTOM_LEVEL)
values ('WFTKN', 'WFCACHE_META_UPD', 'US', 'US', 0,
to_char(sysdate, WF_ENGINE.date_format), 0, 0);
WF_CACHE.ActivityTransitions.DELETE;
WF_CACHE.ProcessStartActivities.DELETE;