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 631: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is

627: p_subscription_guid in raw
628: , p_event in out nocopy wf_event_t)
629: return varchar2 is
630:
631: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
632: select attribute_name
633: , attribute_value
634: from wf_attribute_cache
635: where entity_type = fnd_oid_util.G_USER

Line 634: from wf_attribute_cache

630:
631: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
632: select attribute_name
633: , attribute_value
634: from wf_attribute_cache
635: where entity_type = fnd_oid_util.G_USER
636: and entity_key_value = p_user_name
637: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
638: