DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on WF_ENTITY_MGR

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

1689: --
1690: -- Fetch the new values from the attribute cache
1691: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
1692: --
1693: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1694:
1695: -- NOTE: While we have the ability to distinguish between null
1696: -- and "known to be null", the standard apis do not.
1697: -- For now, we're must pass null regardless which is

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

1697: -- For now, we're must pass null regardless which is
1698: -- treated as a "don't change". We do not yet support
1699: -- the ability to "null out" an attribute value.
1700:
1701: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1702: 'DESCRIPTION');
1703: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1704: 'MAIL');
1705: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

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

1699: -- the ability to "null out" an attribute value.
1700:
1701: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1702: 'DESCRIPTION');
1703: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1704: 'MAIL');
1705: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1706: 'FACSIMILETELEPHONENUMBER');
1707: --

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

1701: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1702: 'DESCRIPTION');
1703: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1704: 'MAIL');
1705: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1706: 'FACSIMILETELEPHONENUMBER');
1707: --
1708: -- Determine if there are any changes to the attributes we're
1709: -- interested in. And if so, update the user record.

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

1708: -- Determine if there are any changes to the attributes we're
1709: -- interested in. And if so, update the user record.
1710: --
1711:
1712: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1713: wf_entity_mgr.isChanged(new_email, old_email) OR
1714: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1715:
1716: -- at least one of the attributes has changed -> update the user --

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

1709: -- interested in. And if so, update the user record.
1710: --
1711:
1712: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1713: wf_entity_mgr.isChanged(new_email, old_email) OR
1714: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1715:
1716: -- at least one of the attributes has changed -> update the user --
1717:

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

1710: --
1711:
1712: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1713: wf_entity_mgr.isChanged(new_email, old_email) OR
1714: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1715:
1716: -- at least one of the attributes has changed -> update the user --
1717:
1718: --

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

1761: -- If CHANGE_SOURCE is OID, it means it's raised from two-way sync code.
1762: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
1763:
1764: my_cachekey := p_event.GetEventKey();
1765: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1766: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1767: 'ORCLGUID');
1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

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

1762: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
1763:
1764: my_cachekey := p_event.GetEventKey();
1765: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1766: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1767: 'ORCLGUID');
1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1770: 'OID - event_key ='||my_cachekey);

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

1812: -- treated as a "don't change". fnd_user_pkg apis do
1813: -- not yet support the ability to "null out" an
1814: -- attribute value. Weak.
1815: --
1816: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1817: 'DESCRIPTION');
1818: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1819: 'MAIL');
1820: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

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

1814: -- attribute value. Weak.
1815: --
1816: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1817: 'DESCRIPTION');
1818: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1819: 'MAIL');
1820: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1821: 'FACSIMILETELEPHONENUMBER');
1822: --

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

1816: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1817: 'DESCRIPTION');
1818: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1819: 'MAIL');
1820: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1821: 'FACSIMILETELEPHONENUMBER');
1822: --
1823: -- Determine if there are any changes to the attributes we're
1824: -- interested in. And if so, update the user record.

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

1822: --
1823: -- Determine if there are any changes to the attributes we're
1824: -- interested in. And if so, update the user record.
1825: --
1826: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1827: wf_entity_mgr.isChanged(new_email, old_email) OR
1828: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1829: --Start Bug 3147423
1830: if (new_desc in ('*NULL*', '*UNKNOWN*')) then

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

1823: -- Determine if there are any changes to the attributes we're
1824: -- interested in. And if so, update the user record.
1825: --
1826: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1827: wf_entity_mgr.isChanged(new_email, old_email) OR
1828: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1829: --Start Bug 3147423
1830: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
1831: new_desc := null_char;

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

1824: -- interested in. And if so, update the user record.
1825: --
1826: if (wf_entity_mgr.isChanged(new_desc, old_desc) OR
1827: wf_entity_mgr.isChanged(new_email, old_email) OR
1828: wf_entity_mgr.isChanged(new_fax, old_fax)) then
1829: --Start Bug 3147423
1830: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
1831: new_desc := null_char;
1832: end if;

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

1925: exception
1926: when others then
1927:
1928: -- user doesn't exist yet, we have work to do --
1929: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1930:
1931: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1932: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1933: 'LDAP - entity_type ='||my_ent_type);

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

1936: --
1937: -- Fetch the new values from the attribute cache
1938: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
1939: --
1940: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1941: 'DESCRIPTION');
1942: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1943: 'MAIL');
1944: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,

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

1938: -- New values can either be *NULL*, *UNKNOWN*, or an actual value
1939: --
1940: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1941: 'DESCRIPTION');
1942: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1943: 'MAIL');
1944: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1945: 'FACSIMILETELEPHONENUMBER');
1946: --

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

1940: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1941: 'DESCRIPTION');
1942: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1943: 'MAIL');
1944: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_username,
1945: 'FACSIMILETELEPHONENUMBER');
1946: --
1947: -- NOTE: the following conversions are necessary until we resolve
1948: -- null and "null out"

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

1987: -- If CHANGE_SOURCE is OID, it means it's raised from two-way sync code.
1988: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
1989:
1990: my_cachekey := p_event.GetEventKey();
1991: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1992: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1993: 'ORCLGUID');
1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

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

1988: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'OID') then
1989:
1990: my_cachekey := p_event.GetEventKey();
1991: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1992: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1993: 'ORCLGUID');
1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1996: 'OID - event_key ='||my_cachekey);

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

2008:
2009: exception
2010: when others then -- CREATE NEW USER --
2011:
2012: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2013: 'DESCRIPTION');
2014: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2015: 'MAIL');
2016: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,

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

2010: when others then -- CREATE NEW USER --
2011:
2012: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2013: 'DESCRIPTION');
2014: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2015: 'MAIL');
2016: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2017: 'FACSIMILETELEPHONENUMBER');
2018: if (new_desc in ('*NULL*', '*UNKNOWN*')) then

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

2012: new_desc := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2013: 'DESCRIPTION');
2014: new_email := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2015: 'MAIL');
2016: new_fax := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
2017: 'FACSIMILETELEPHONENUMBER');
2018: if (new_desc in ('*NULL*', '*UNKNOWN*')) then
2019: new_desc := null;
2020: end if;

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

2266: -- -----------------------------------------------------------------
2267:
2268: -- don't make this call anymore - code unstubbed
2269:
2270: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2271: -- 'MAIL', my_email);
2272: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2273: -- 'DESCRIPTION', my_desc);
2274: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2268: -- don't make this call anymore - code unstubbed
2269:
2270: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2271: -- 'MAIL', my_email);
2272: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2273: -- 'DESCRIPTION', my_desc);
2274: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2275: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2276: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2270: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2271: -- 'MAIL', my_email);
2272: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2273: -- 'DESCRIPTION', my_desc);
2274: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2275: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2276: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2277: -- 'USER_NAME', upper(p_user_name));
2278: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2272: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2273: -- 'DESCRIPTION', my_desc);
2274: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2275: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2276: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2277: -- 'USER_NAME', upper(p_user_name));
2278: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2279: -- 'SN', upper(p_user_name));
2280: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2274: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2275: -- 'FACSIMILETELEPHONENUMBER', my_fax);
2276: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2277: -- 'USER_NAME', upper(p_user_name));
2278: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2279: -- 'SN', upper(p_user_name));
2280: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2281: -- 'ORCLACTIVESTARTDATE', ch_start);
2282: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2276: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2277: -- 'USER_NAME', upper(p_user_name));
2278: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2279: -- 'SN', upper(p_user_name));
2280: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2281: -- 'ORCLACTIVESTARTDATE', ch_start);
2282: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2283: -- 'ORCLACTIVEENDDATE', ch_exp);
2284: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2278: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2279: -- 'SN', upper(p_user_name));
2280: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2281: -- 'ORCLACTIVESTARTDATE', ch_start);
2282: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2283: -- 'ORCLACTIVEENDDATE', ch_exp);
2284: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2285: -- 'ORCLGUID', my_guid);
2286: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2280: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2281: -- 'ORCLACTIVESTARTDATE', ch_start);
2282: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2283: -- 'ORCLACTIVEENDDATE', ch_exp);
2284: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2285: -- 'ORCLGUID', my_guid);
2286: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2287: -- 'USERPASSWORD', my_pwd);
2288: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),

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

2282: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2283: -- 'ORCLACTIVEENDDATE', ch_exp);
2284: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2285: -- 'ORCLGUID', my_guid);
2286: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2287: -- 'USERPASSWORD', my_pwd);
2288: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2289: -- 'PER_PERSON_ID',
2290: -- fnd_number.number_to_canonical(my_empid));

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

2284: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2285: -- 'ORCLGUID', my_guid);
2286: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2287: -- 'USERPASSWORD', my_pwd);
2288: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2289: -- 'PER_PERSON_ID',
2290: -- fnd_number.number_to_canonical(my_empid));
2291: -- wf_entity_mgr.process_changes('USER', upper(p_user_name), 'FND_USR');
2292:

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

2287: -- 'USERPASSWORD', my_pwd);
2288: -- wf_entity_mgr.put_attribute_value('USER', upper(p_user_name),
2289: -- 'PER_PERSON_ID',
2290: -- fnd_number.number_to_canonical(my_empid));
2291: -- wf_entity_mgr.process_changes('USER', upper(p_user_name), 'FND_USR');
2292:
2293: -- Added for bug 3804617
2294: -- If a user_name is changed, we need to update all foreign key children.
2295: if (g_old_user_name is not null) then