APPS.FND_OID_SUBSCRIPTIONS dependencies on WF_ATTRIBUTE_CACHE

Line 230: -- Read the values from wf_attribute_cache

226: then
227: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
228: end if;
229:
230: -- Read the values from wf_attribute_cache
231: l_description := wf_entity_mgr.get_attribute_value(p_event_type,
232: p_user_name, 'DESCRIPTION');
233: l_email_address := wf_entity_mgr.get_attribute_value(p_event_type,
234: p_user_name, 'MAIL');

Line 643: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is

639: p_subscription_guid in raw
640: , p_event in out nocopy wf_event_t)
641: return varchar2 is
642:
643: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
644: select attribute_name
645: , attribute_value
646: from wf_attribute_cache
647: where entity_type = fnd_oid_util.G_USER

Line 646: from wf_attribute_cache

642:
643: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
644: select attribute_name
645: , attribute_value
646: from wf_attribute_cache
647: where entity_type = fnd_oid_util.G_USER
648: and entity_key_value = p_user_name
649: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
650: