APPS.FND_LDAP_USER SQL Statements

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

Line: 8

  G_UPDATE             constant  pls_integer := 2;

Line: 18

function delete_user_by_name(p_ldap_session in dbms_ldap.session, p_cn in varchar2) return pls_integer;

Line: 19

function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

Line: 20

function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;

Line: 21

function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

Line: 28

function update_user(p_ldap_user in fnd_ldap_util.ldap_user_type) return pls_integer;

Line: 29

function update_user(p_ldap_user in fnd_ldap_util.ldap_user_type, p_expire_password in pls_integer) return pls_integer;

Line: 30

function update_user_nodes(p_ldap_session in dbms_ldap.session, p_mod_array in dbms_ldap.mod_array, p_orclguid in raw) return pls_integer;

Line: 42

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


 l_module_source   varchar2(256) := G_MODULE_SOURCE || 'delete_user: ';

Line: 69

  l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line: 131

            x_result := delete_user_subscription(ldapSession, l_guid);

Line: 136

            x_result := delete_uniquemember(ldapSession, l_orclguid);

Line: 137

            x_result := delete_user_nodes(ldapSession, l_orclguid);

Line: 162

end delete_user;

Line: 164

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

ldapSession  dbms_ldap.session;

Line: 171

  delete_user(ldapSession,p_user_guid,x_result);

Line: 173

end delete_user;

Line: 203

  select user_id into l_user_id
  from fnd_user
  where user_name = p_user_name;

Line: 242

    x_result := update_user(usertype, p_expire_password);

Line: 444

								x_result := update_user(usertype);

Line: 590

  the flag to enabled after the password has been updated by proxying as that user. This is because
  we cannot proxy as a disabled user. */
  if ( (l_password is null) and  (usertype.orclisEnabled = fnd_oid_util.G_DISABLED) ) then
    l_enabled := fnd_oid_util.G_DISABLED;

Line: 651

        delete_user(x_user_guid, x_result);

Line: 776

      result := delete_user_by_name(ldapSession, p_ldap_user.cn);

Line: 979

    select user_id, decode(p_start_date, fnd_user_pkg.null_date, null,
                                null, start_date,
                                p_start_date) l_start_date,
           decode(p_end_date, fnd_user_pkg.null_date, null,
                                null, end_date,
                                p_end_date) l_end_date
           from fnd_user
           where user_name = p_user_name;

Line: 1048

function delete_user_by_name(p_ldap_session in dbms_ldap.session, p_cn in varchar2)
return pls_integer is

l_module_source   varchar2(256);

Line: 1059

  l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line: 1067

  delete_user(p_ldap_session,l_guid,result);

Line: 1083

end delete_user_by_name;

Line: 1088

function delete_user_nodes(p_ldap_session in dbms_ldap.session,
                     p_orclguid in fnd_user.user_guid%type) return pls_integer is

l_module_source   varchar2(256);

Line: 1097

  l_module_source := G_MODULE_SOURCE || 'delete_user_nodes: ';

Line: 1113

  l_result := dbms_ldap.delete_s(ld => p_ldap_session, entrydn => usersNode);

Line: 1120

end delete_user_nodes;

Line: 1123

function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid in raw)
return pls_integer is

l_module_source   varchar2(256);

Line: 1135

  l_module_source := G_MODULE_SOURCE || 'delete_user_subscription ';

Line: 1148

           l_result := dbms_ldap.delete_s(ld => p_ldap_session, entrydn => 'orclOwnerGUID=' || l_user_guid||','||subsNode);

Line: 1157

end delete_user_subscription;

Line: 1160

function delete_uniquemember(p_ldap_session in dbms_ldap.session,
                      p_orclguid in fnd_user.user_guid%type) return pls_integer is

l_module_source   varchar2(256);

Line: 1174

  l_module_source := G_MODULE_SOURCE || 'delete_uniquemember: ';

Line: 1188

  dbms_ldap.populate_mod_array(modptr => modArray, mod_op => dbms_ldap.mod_delete, mod_type => 'uniquemember', modval => modmultivalues);

Line: 1214

end delete_uniquemember;

Line: 1243

  x_result := update_user(usertype);

Line: 1710

  select user_name
  from fnd_user
  where user_guid = p_user_guid
  and user_name <> p_user_name;

Line: 1751

      x_result := delete_user_subscription(l_ldap_session, p_user_guid);

Line: 1752

      x_result := delete_uniquemember(l_ldap_session, p_user_guid);

Line: 1788

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,
                     x_result out nocopy pls_integer) is
  l_password pls_integer;

Line: 1799

  update_user(p_user_guid ,
                     p_user_name,
                     p_password ,
                     p_start_date ,
                     p_end_date,
                     p_description,
                     p_email_address ,
                     p_fax,
                     l_password,
                     x_result );

Line: 1809

end update_user;

Line: 1812

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,
   		     x_password out nocopy varchar2,
                     x_result out nocopy pls_integer) is


  l_orclisEnabled varchar2(256);

Line: 1840

  l_module_source := G_MODULE_SOURCE || 'update_user[proc]: ';

Line: 1923

    x_result := update_user(usertype);

Line: 1969

end update_user;

Line: 1972

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_orclisEnabled varchar2(256);

Line: 1998

  l_module_source := G_MODULE_SOURCE || 'update_user: ';

Line: 2086

    x_result := update_user(usertype);

Line: 2134

end update_user;

Line: 2137

function update_user(p_ldap_user in fnd_ldap_util.ldap_user_type)
return pls_integer is

l_module_source   varchar2(256);

Line: 2161

  l_module_source := G_MODULE_SOURCE || 'update_user: ';

Line: 2176

    num_attributes := process_attributes(p_ldap_user, G_UPDATE,
                                         x_atts => l_atts, x_att_values => l_att_values);

Line: 2192

        retval := update_user_nodes(ldapSession, modArray, p_ldap_user.orclGUID);

Line: 2223

end update_user;

Line: 2226

function update_user(p_ldap_user in fnd_ldap_util.ldap_user_type, p_expire_password in pls_integer)
return pls_integer is

l_module_source   varchar2(256);

Line: 2248

  l_module_source := G_MODULE_SOURCE || 'update_user: ';

Line: 2269

    num_attributes := process_attributes(p_ldap_user, G_UPDATE,
                                         x_atts => l_atts, x_att_values => l_att_values);

Line: 2279

    retval := update_user_nodes(ldapSession, modArray, p_ldap_user.orclGUID);

Line: 2300

end update_user;

Line: 2303

function update_user_nodes(p_ldap_session in dbms_ldap.session, p_mod_array in dbms_ldap.mod_array, p_orclguid in raw)
return pls_integer is

l_module_source   varchar2(256);

Line: 2312

  l_module_source := G_MODULE_SOURCE || 'update_user_nodes: ';

Line: 2343

end update_user_nodes;

Line: 2502

      select user_guid into l_user_guid from fnd_user where user_name=p_user_name;