APPS.WF_ENTITY_MGR dependencies on WF_ATTRIBUTE_CACHE

Line 12: insert into wf_attribute_cache (

8: procedure InitCache(p_entity_type in varchar2,
9: p_entity_key_value in varchar2) is
10: pragma autonomous_transaction;
11: begin
12: insert into wf_attribute_cache (
13: entity_type,
14: entity_key_value,
15: attribute_name,
16: attribute_value,

Line 66: update wf_attribute_cache

62: --First lock the cache or call InitCache() if the attribute
63: --does not exist..
64: l_cacheLocked := FALSE;
65: while not (l_cacheLocked) loop
66: update wf_attribute_cache
67: set attribute_value = 'YES'
68: where entity_type = p_entity_type
69: and entity_key_value = upper(p_entity_key_value)
70: and attribute_name = 'CACHE_CHANGED';

Line 84: update wf_attribute_cache

80: end if;
81:
82: --We acquired a lock on the entity_type/entity_key so we can update/create
83: --Attributes.
84: update wf_attribute_cache
85: set attribute_value = nvl(p_value, '*NULL*'),
86: last_update_date = sysdate,
87: change_number = nvl(p_change_number, change_number)
88: where entity_type = p_entity_type

Line 95: insert into wf_attribute_cache (

91:
92: --No need to worry about race condition here because we have a lock on the
93: --entity_type/entity_key.
94: if SQL%notfound then
95: insert into wf_attribute_cache (
96: entity_type,
97: entity_key_value,
98: attribute_name,
99: attribute_value,

Line 198: from wf_attribute_cache

194: p_attribute||')');
195: end if;
196:
197: select attribute_value into my_att_val
198: from wf_attribute_cache
199: where entity_type = upper(p_entity_type)
200: and entity_key_value = upper(p_entity_key_value)
201: and attribute_name = upper(p_attribute);
202:

Line 289: execute immediate 'truncate table wf_attribute_cache';

285: p_entity_key_value in varchar2 )
286: is pragma autonomous_transaction;
287: begin
288: if (p_entity_type = '*ALL*') then
289: execute immediate 'truncate table wf_attribute_cache';
290: elsif ((p_entity_type is NOT NULL) and (p_entity_key_value is NOT NULL)) then
291: delete from wf_attribute_cache
292: where entity_type = upper(p_entity_type)
293: and entity_key_value = upper(p_entity_key_value);

Line 291: delete from wf_attribute_cache

287: begin
288: if (p_entity_type = '*ALL*') then
289: execute immediate 'truncate table wf_attribute_cache';
290: elsif ((p_entity_type is NOT NULL) and (p_entity_key_value is NOT NULL)) then
291: delete from wf_attribute_cache
292: where entity_type = upper(p_entity_type)
293: and entity_key_value = upper(p_entity_key_value);
294: else
295: delete from wf_attribute_cache

Line 295: delete from wf_attribute_cache

291: delete from wf_attribute_cache
292: where entity_type = upper(p_entity_type)
293: and entity_key_value = upper(p_entity_key_value);
294: else
295: delete from wf_attribute_cache
296: where ((entity_type is NULL) or (entity_type = upper(p_entity_type)))
297: and ((entity_key_value is NULL) or
298: (entity_key_value = upper(p_entity_key_value)));
299: end if;

Line 333: from wf_attribute_cache

329:
330: cursor attribute_data is
331: select attribute_name aname,
332: attribute_value avalue
333: from wf_attribute_cache
334: where entity_type = my_ent_type
335: and entity_key_value = upper(p_event_key)
336: and attribute_name <> 'CACHE_CHANGED';
337: