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';
229:
285:
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
293: if (sql%notfound) then
294: -- When WF_CACHE.Reset is called for the very first time on a system
295: -- we will jump into this code to insert the record.
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