APPS.FND_LDAP_WRAPPER SQL Statements

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

Line: 36

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

Line: 74

				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: 282

      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: 540

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: 551

  l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line: 561

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

Line: 569

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

Line: 598

end delete_user;

Line: 690

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

Line: 781

      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: 849

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: 877

  l_module_source := G_MODULE_SOURCE || 'update_user: ';

Line: 939

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

Line: 985

end update_user;

Line: 1038

      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: 1110

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

Line: 1283

      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: 1390

		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';