APPS.FND_SSO_MANAGER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

 API returns true if profile APPS_SSO_USER_CREATE_UPDATE is ENABLED
*/
function isUserCreateUpdateAllowed
  return boolean is

  l_apps_sso_user_create_update  varchar2(10);

Line: 86

  l_module_source := G_MODULE_SOURCE || 'isUserCreateUpdateAllowed: ';

Line: 93

  fnd_profile.get(name => 'APPS_SSO_USER_CREATE_UPDATE',
                   val => l_apps_sso_user_create_update);

Line: 99

           'APPS_SSO_USER_CREATE_UPDATE: ' || l_apps_sso_user_create_update);

Line: 102

 if (l_apps_sso_user_create_update = 'N')
  then
    l_returnVal := FALSE;

Line: 180

         select login_id into l_login_id
         from  ICX_SESSIONS
         where  SESSION_ID = l_session_id;

Line: 248

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