DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on WF_ENTITY_MGR

Line 2300: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());

2296: --
2297: -- Fetch the new values from the attribute cache
2298: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
2299: --
2300: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2301:
2302: -- NOTE: While we have the ability to distinguish between null
2303: -- and "known to be null", the standard apis do not.
2304: -- For now, we're must pass null regardless which is

Line 2308: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2304: -- For now, we're must pass null regardless which is
2305: -- treated as a "don't change". We do not yet support
2306: -- the ability to "null out" an attribute value.
2307:
2308: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2309: 'DESCRIPTION');
2310: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2311: 'MAIL');
2312: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

Line 2310: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2306: -- the ability to "null out" an attribute value.
2307:
2308: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2309: 'DESCRIPTION');
2310: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2311: 'MAIL');
2312: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2313: 'FACSIMILETELEPHONENUMBER');
2314: --

Line 2312: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2308: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2309: 'DESCRIPTION');
2310: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2311: 'MAIL');
2312: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2313: 'FACSIMILETELEPHONENUMBER');
2314: --
2315: -- Determine if there are any changes to the attributes we're
2316: -- interested in. And if so, update the user record.

Line 2319: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR

2315: -- Determine if there are any changes to the attributes we're
2316: -- interested in. And if so, update the user record.
2317: --
2318:
2319: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2320: wf_entity_mgr.isChanged(new_email, old_email) OR
2321: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2322:
2323: -- at least one of the attributes has changed -> update the user --

Line 2320: wf_entity_mgr.isChanged(new_email, old_email) OR

2316: -- interested in. And if so, update the user record.
2317: --
2318:
2319: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2320: wf_entity_mgr.isChanged(new_email, old_email) OR
2321: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2322:
2323: -- at least one of the attributes has changed -> update the user --
2324:

Line 2321: wf_entity_mgr.isChanged(new_fax, old_fax)) then

2317: --
2318:
2319: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2320: wf_entity_mgr.isChanged(new_email, old_email) OR
2321: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2322:
2323: -- at least one of the attributes has changed -> update the user --
2324:
2325: --

Line 2372: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());

2368: -- If CHANGE_SOURCE is OID, it means it's raised from two-way sync code.
2369: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
2370:
2371: my_cachekey := p_event.GetEventKey();
2372: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2373: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2374: 'ORCLGUID');
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2373: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2369: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
2370:
2371: my_cachekey := p_event.GetEventKey();
2372: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2373: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2374: 'ORCLGUID');
2375: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2376: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2377: 'OID - event_key ='||my_cachekey);

Line 2423: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2419: -- treated as a "don't change". fnd_user_pkg apis do
2420: -- not yet support the ability to "null out" an
2421: -- attribute value. Weak.
2422: --
2423: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2424: 'DESCRIPTION');
2425: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2426: 'MAIL');
2427: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

Line 2425: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2421: -- attribute value. Weak.
2422: --
2423: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2424: 'DESCRIPTION');
2425: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2426: 'MAIL');
2427: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2428: 'FACSIMILETELEPHONENUMBER');
2429: --

Line 2427: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2423: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2424: 'DESCRIPTION');
2425: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2426: 'MAIL');
2427: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2428: 'FACSIMILETELEPHONENUMBER');
2429: --
2430: -- Determine if there are any changes to the attributes we're
2431: -- interested in. And if so, update the user record.

Line 2433: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR

2429: --
2430: -- Determine if there are any changes to the attributes we're
2431: -- interested in. And if so, update the user record.
2432: --
2433: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2434: wf_entity_mgr.isChanged(new_email, old_email) OR
2435: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2436: --Start Bug 3147423
2437: if (new_desc in ('*NULL*', '*UNKNOWN*')) then

Line 2434: wf_entity_mgr.isChanged(new_email, old_email) OR

2430: -- Determine if there are any changes to the attributes we're
2431: -- interested in. And if so, update the user record.
2432: --
2433: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2434: wf_entity_mgr.isChanged(new_email, old_email) OR
2435: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2436: --Start Bug 3147423
2437: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
2438: new_desc := null_char;

Line 2435: wf_entity_mgr.isChanged(new_fax, old_fax)) then

2431: -- interested in. And if so, update the user record.
2432: --
2433: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
2434: wf_entity_mgr.isChanged(new_email, old_email) OR
2435: wf_entity_mgr.isChanged(new_fax, old_fax)) then
2436: --Start Bug 3147423
2437: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
2438: new_desc := null_char;
2439: end if;

Line 2536: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());

2532: exception
2533: when others then
2534:
2535: -- user doesn't exist yet, we have work to do --
2536: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2537:
2538: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2539: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2540: 'LDAP - entity_type ='||my_ent_type);

Line 2547: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2543: --
2544: -- Fetch the new values from the attribute cache
2545: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
2546: --
2547: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2548: 'DESCRIPTION');
2549: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2550: 'MAIL');
2551: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

Line 2549: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2545: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
2546: --
2547: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2548: 'DESCRIPTION');
2549: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2550: 'MAIL');
2551: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2552: 'FACSIMILETELEPHONENUMBER');
2553: --

Line 2551: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

2547: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2548: 'DESCRIPTION');
2549: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2550: 'MAIL');
2551: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
2552: 'FACSIMILETELEPHONENUMBER');
2553: --
2554: -- NOTE: the following conversions are necessary until we resolve
2555: -- null and "null out"

Line 2598: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());

2594: -- If CHANGE_SOURCE is OID, it means it's raised from two-way sync code.
2595: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
2596:
2597: my_cachekey := p_event.GetEventKey();
2598: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2599: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2600: 'ORCLGUID');
2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2599: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2595: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
2596:
2597: my_cachekey := p_event.GetEventKey();
2598: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
2599: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2600: 'ORCLGUID');
2601: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2602: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2603: 'OID - event_key ='||my_cachekey);

Line 2619: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2615:
2616: exception
2617: when others then -- CREATE NEW USER --
2618:
2619: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2620: 'DESCRIPTION');
2621: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2622: 'MAIL');
2623: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

Line 2621: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2617: when others then -- CREATE NEW USER --
2618:
2619: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2620: 'DESCRIPTION');
2621: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2622: 'MAIL');
2623: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2624: 'FACSIMILETELEPHONENUMBER');
2625: if (new_desc in ('*NULL*', '*UNKNOWN*')) then

Line 2623: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

2619: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2620: 'DESCRIPTION');
2621: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2622: 'MAIL');
2623: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2624: 'FACSIMILETELEPHONENUMBER');
2625: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
2626: new_desc := null;
2627: end if;

Line 2877: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2873: -- -----------------------------------------------------------------
2874:
2875: -- don't make this call anymore - code unstubbed
2876:
2877: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2878: -- 'MAIL', my_email);
2879: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2880: -- 'DESCRIPTION', my_desc);
2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2879: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2875: -- don't make this call anymore - code unstubbed
2876:
2877: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2878: -- 'MAIL', my_email);
2879: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2880: -- 'DESCRIPTION', my_desc);
2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2882: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2877: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2878: -- 'MAIL', my_email);
2879: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2880: -- 'DESCRIPTION', my_desc);
2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2882: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2884: -- 'USER_NAME', upper(p_user_name));
2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2879: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2880: -- 'DESCRIPTION', my_desc);
2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2882: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2884: -- 'USER_NAME', upper(p_user_name));
2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2886: -- 'SN', upper(p_user_name));
2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2881: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2882: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2884: -- 'USER_NAME', upper(p_user_name));
2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2886: -- 'SN', upper(p_user_name));
2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2888: -- 'ORCLACTIVESTARTDATE', ch_start);
2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2883: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2884: -- 'USER_NAME', upper(p_user_name));
2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2886: -- 'SN', upper(p_user_name));
2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2888: -- 'ORCLACTIVESTARTDATE', ch_start);
2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2890: -- 'ORCLACTIVEENDDATE', ch_exp);
2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2885: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2886: -- 'SN', upper(p_user_name));
2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2888: -- 'ORCLACTIVESTARTDATE', ch_start);
2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2890: -- 'ORCLACTIVEENDDATE', ch_exp);
2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2892: -- 'ORCLGUID', my_guid);
2893: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2887: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2888: -- 'ORCLACTIVESTARTDATE', ch_start);
2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2890: -- 'ORCLACTIVEENDDATE', ch_exp);
2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2892: -- 'ORCLGUID', my_guid);
2893: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2894: -- 'USERPASSWORD', my_pwd);
2895: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

Line 2893: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2889: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2890: -- 'ORCLACTIVEENDDATE', ch_exp);
2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2892: -- 'ORCLGUID', my_guid);
2893: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2894: -- 'USERPASSWORD', my_pwd);
2895: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2896: -- 'PER_PERSON_ID',
2897: -- fnd_number.number_to_canonical(my_empid));

Line 2895: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

2891: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2892: -- 'ORCLGUID', my_guid);
2893: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2894: -- 'USERPASSWORD', my_pwd);
2895: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2896: -- 'PER_PERSON_ID',
2897: -- fnd_number.number_to_canonical(my_empid));
2898: -- wf_entity_mgr.process_changes('USER', upper(p_user_name), 'FND_USR');
2899:

Line 2898: -- wf_entity_mgr.process_changes('USER', upper(p_user_name), 'FND_USR');

2894: -- 'USERPASSWORD', my_pwd);
2895: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2896: -- 'PER_PERSON_ID',
2897: -- fnd_number.number_to_canonical(my_empid));
2898: -- wf_entity_mgr.process_changes('USER', upper(p_user_name), 'FND_USR');
2899:
2900: -- Added for bug 3804617
2901: -- If a user_name is changed, we need to update all foreign key children.
2902: if (g_old_user_name is not null) then