DBA Data[Home] [Help]

APPS.FND_SSO_MANAGER dependencies on FND_USER

Line 39: procedure synch_user_from_LDAP(p_user_name in fnd_user.user_name%type) is

35: -- return FND_WEB_CONFIG.trail_slash(cs_anchor)|| 'oracle.apps.fnd.sso.AppsLogin?requestUrl=' || wfa_html.conv_special_url_chars(l_requestUrl) || '&' || 'cancelUrl=' || wfa_html.conv_special_url_chars(l_cancelUrl);
36: --
37: --end;
38:
39: procedure synch_user_from_LDAP(p_user_name in fnd_user.user_name%type) is
40: l_module_source varchar2(256);
41: l_result pls_integer;
42: l_user_name fnd_user.user_name%type;
43: begin

Line 42: l_user_name fnd_user.user_name%type;

38:
39: procedure synch_user_from_LDAP(p_user_name in fnd_user.user_name%type) is
40: l_module_source varchar2(256);
41: l_result pls_integer;
42: l_user_name fnd_user.user_name%type;
43: begin
44: l_module_source := G_MODULE_SOURCE || 'synch_user_from_LDAP';
45:
46: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 227: l_fnd_user pls_integer;

223: p_user_id number;
224: l_profile_defined boolean;
225: l_pwd_changable boolean;
226: l_attribute varchar2(40);
227: l_fnd_user pls_integer;
228: l_oid pls_integer;
229: l_apps_sso varchar2(50);
230: l_module_source varchar2(256);
231: p_user_guid raw(256);

Line 248: select user_id, user_guid into p_user_id, p_user_guid from fnd_user where user_name = upper(username);

244: then
245: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
246: end if;
247:
248: select user_id, user_guid into p_user_id, p_user_guid from fnd_user where user_name = upper(username);
249:
250: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
251: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Retrieved user_id and user_guid for user '||username);
252: end if;

Line 281: x_fnd_user => l_fnd_user,

277: p_direction => fnd_ldap_wrapper.G_EBIZ_TO_OID,
278: p_entity => fnd_ldap_wrapper.G_IDENTITY,
279: p_operation => fnd_ldap_wrapper.G_MODIFY,
280: x_attribute => l_attribute,
281: x_fnd_user => l_fnd_user,
282: x_oid => l_oid);
283:
284: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
285: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User is an SSO user. Verifying password can be synched');

Line 331: function get_ldap_user_name(p_user_name in fnd_user.user_name%type)

327: return false;
328:
329: end;
330:
331: function get_ldap_user_name(p_user_name in fnd_user.user_name%type)
332: return varchar2 is
333:
334: l_module_source varchar2(256);
335: l_result varchar2(4000);