APPS.FND_LDAP_WRAPPER SQL Statements

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

Line: 56

    select user_guid
      from fnd_user
     where user_name = upper(p_user_name);

Line: 94

				select object_name into l_obj_name from all_objects
				where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
		  	and status = 'VALID' and owner = 'SYS';

Line: 302

      select object_name into l_obj_name from all_objects
      where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
      and status = 'VALID' and owner = 'SYS';

Line: 577

procedure delete_user(p_user_guid in fnd_user.user_guid%type,
		     x_result out nocopy pls_integer) is

  l_module_source   varchar2(256);

Line: 588

  l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line: 598

		       p_operation => G_DELETE,
		       x_attribute => l_attribute,
		       x_fnd_user => l_fnd_user,
		       x_oid => l_oid);

Line: 606

      'begin fnd_ldap_user.delete_user(:1, :2); end;';

Line: 635

end delete_user;

Line: 727

		       p_operation => G_DELETE,
		       x_attribute => l_attribute,
		       x_fnd_user => l_fnd_user,
		       x_oid => l_oid);

Line: 818

      select object_name into l_obj_name from all_objects
      where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
      and status = 'VALID' and owner = 'SYS';

Line: 886

procedure update_user(p_user_guid in raw,
		     p_user_name in varchar2,
		     p_password in varchar2 default null,
		     p_start_date in date default null,
		     p_end_date in date default null,
		     p_description in varchar2 default null,
		     p_email_address in varchar2 default null,
		     p_fax in varchar2 default null,
     		     p_expire_password in pls_integer,
  		     x_password out nocopy varchar2,
		     x_result out nocopy pls_integer) is

  l_module_source   varchar2(256);

Line: 915

  l_module_source := G_MODULE_SOURCE || 'update_user: ';

Line: 973

      'begin fnd_ldap_user.update_user(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); end;';

Line: 1019

end update_user;

Line: 1072

      select object_name into l_obj_name from all_objects
      where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
      and status = 'VALID' and owner = 'SYS';

Line: 1144

  select fnd_preference.get('#INTERNAL','LDAP_SYNCH', 'USERNAME')
  into orclAppName
  from dual;

Line: 1215

      select user_id into l_user_id
      from fnd_user
      where user_name = p_user_name;

Line: 1349

      select object_name into l_obj_name from all_objects
      where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
      and status = 'VALID' and owner = 'SYS';

Line: 1456

		select object_name into l_obj_name from all_objects
		where object_name = 'DBMS_LDAP' and object_type = 'PACKAGE BODY'
		and status = 'VALID' and owner = 'SYS';

Line: 1685

    select user_name, user_id, user_guid
    from fnd_user
    where user_name like upper(p_user_name)
    and user_guid is not null;

Line: 1717

       update fnd_user
       set user_guid = null
       where user_name = l_user_name and user_guid is not null;

Line: 1735

              fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Local login is SSO - delete user level profile');

Line: 1738

          l_del_prof := fnd_profile.delete(
            x_name => 'APPS_SSO_LOCAL_LOGIN',
            x_level_name => 'USER',
            x_level_value => l_user_id);

Line: 1746

          fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Delete APPS_SSO_LDAP_SYNC user level profile');

Line: 1749

       l_del_prof := fnd_profile.delete(
            x_name => 'APPS_SSO_LDAP_SYNC',
            x_level_name => 'USER',
            x_level_value => l_user_id);