DBA Data[Home] [Help]

APPS.WF_CACHE dependencies on WF_RESOURCES

Line 225: from WF_RESOURCES

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:

Line 289: update WF_RESOURCES set text = to_char(sysdate,

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

Line 297: insert into WF_RESOURCES (TYPE, NAME, LANGUAGE,SOURCE_LANG, ID,

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