DBA Data[Home] [Help]

APPS.FND_OID_SUBSCRIPTIONS dependencies on WF_ENTITY_MGR

Line 123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table

119: then
120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);
122: end if;
123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table
124: -- we should not populate the fnd_user table with this, for fax and description.
125:
126: -- Bug 5347086 - fnd_user_pkg does not check for UNKNOWN when creating the user. Doing it here
127: if (p_description in ('*UNKNOWN*','*NULL*')) then

Line 231: l_description := wf_entity_mgr.get_attribute_value(p_event_type,

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');
235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,

Line 233: l_email_address := wf_entity_mgr.get_attribute_value(p_event_type,

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');
235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,
236: p_user_name, 'FACSIMILETELEPHONENUMBER');
237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,

Line 235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,

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');
235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,
236: p_user_name, 'FACSIMILETELEPHONENUMBER');
237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,
238: p_user_name, 'ORCLACTIVESTARTDATE');
239: l_end_date := wf_entity_mgr.get_attribute_value(p_event_type,

Line 237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,

233: l_email_address := wf_entity_mgr.get_attribute_value(p_event_type,
234: p_user_name, 'MAIL');
235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,
236: p_user_name, 'FACSIMILETELEPHONENUMBER');
237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,
238: p_user_name, 'ORCLACTIVESTARTDATE');
239: l_end_date := wf_entity_mgr.get_attribute_value(p_event_type,
240: p_user_name, 'ORCLACTIVEENDDATE');
241: l_isenabled := wf_entity_mgr.get_attribute_value(p_event_type,

Line 239: l_end_date := wf_entity_mgr.get_attribute_value(p_event_type,

235: l_fax := wf_entity_mgr.get_attribute_value(p_event_type,
236: p_user_name, 'FACSIMILETELEPHONENUMBER');
237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,
238: p_user_name, 'ORCLACTIVESTARTDATE');
239: l_end_date := wf_entity_mgr.get_attribute_value(p_event_type,
240: p_user_name, 'ORCLACTIVEENDDATE');
241: l_isenabled := wf_entity_mgr.get_attribute_value(p_event_type,
242: p_user_name, 'ORCLISENABLED');
243: if (l_isenabled = '*UNKNOWN*') then

Line 241: l_isenabled := wf_entity_mgr.get_attribute_value(p_event_type,

237: l_start_date := wf_entity_mgr.get_attribute_value(p_event_type,
238: p_user_name, 'ORCLACTIVESTARTDATE');
239: l_end_date := wf_entity_mgr.get_attribute_value(p_event_type,
240: p_user_name, 'ORCLACTIVEENDDATE');
241: l_isenabled := wf_entity_mgr.get_attribute_value(p_event_type,
242: p_user_name, 'ORCLISENABLED');
243: if (l_isenabled = '*UNKNOWN*') then
244: l_isenabled := wf_entity_mgr.get_attribute_value('USER',
245: p_user_name, 'ORCLISENABLED');

Line 244: l_isenabled := wf_entity_mgr.get_attribute_value('USER',

240: p_user_name, 'ORCLACTIVEENDDATE');
241: l_isenabled := wf_entity_mgr.get_attribute_value(p_event_type,
242: p_user_name, 'ORCLISENABLED');
243: if (l_isenabled = '*UNKNOWN*') then
244: l_isenabled := wf_entity_mgr.get_attribute_value('USER',
245: p_user_name, 'ORCLISENABLED');
246: end if;
247:
248: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)