[Home] [Help]
220: | Checking to see when the itemType was |
221: | last updated. |
222: +----------------------------------------*/
223: begin
224: select to_date(text, WF_ENGINE.date_format) into l_UpdateTime
225: from WF_RESOURCES
226: where TYPE='WFTKN'
227: and NAME = 'WFCACHE_META_UPD'
228: and LANGUAGE = 'US';
286: BEGIN
287: if ((NOT trustedTransaction) or (trustedTransaction is NULL)) then
288: -- We will update the token to the current sysdate.
289: update WF_RESOURCES set text = to_char(sysdate,
290: WF_ENGINE.date_format)
291: where name = 'WFCACHE_META_UPD';
292:
293: if (sql%notfound) then
294: -- When WF_CACHE.Reset is called for the very first time on a system
296: begin
297: insert into WF_RESOURCES (TYPE, NAME, LANGUAGE,SOURCE_LANG, ID,
298: TEXT, PROTECT_LEVEL, CUSTOM_LEVEL)
299: values ('WFTKN', 'WFCACHE_META_UPD', 'US', 'US', 0,
300: to_char(sysdate, WF_ENGINE.date_format), 0, 0);
301: exception
302: when DUP_VAL_ON_INDEX then
303: -- there is a race condition where it can potentially
304: -- have several insert at once the first time this is called.
625:
626: if (WF_CACHE.ActivityTransitions.EXISTS(iKey)) then
627: if ((WF_CACHE.ActivityTransitions(iKey).FROM_PROCESS_ACTIVITY <> FromActID)
628: or (WF_CACHE.ActivityTransitions(iKey).RESULT_CODE not in
629: (result, WF_ENGINE.eng_trans_default, WF_ENGINE.eng_trans_any))) then
630: raise HashCollision;
631:
632: else
633: status := WF_CACHE.task_SUCCESS;