APPS.FND_OID_UTIL SQL Statements

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

Line: 86

    select decode(employee_id,
         null, decode(customer_id, null, 'FND', 'TCA'),
         'HR'),
         user_id, start_date, end_date
      into my_flavor, my_userid, my_start, my_end
      from fnd_user
     where user_name = p_username;

Line: 100

    insert into wf_entity_changes(
    entity_type, entity_key_value, flavor, change_date)
    values('USER', p_username, my_flavor, sysdate);

Line: 351

    select user_id, user_name, user_guid, person_party_id
      from fnd_user
     where user_guid = p_user_guid;

Line: 401

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

Line: 732

    select user_name, user_id
      from fnd_user
     where user_guid = p_user_guid;

Line: 810

procedure process_identity_delete(p_event in ldap_event) is

  cursor cur_fnd_users(p_user_guid in varchar2) is
    select user_name, user_id
      from  fnd_user
     where  user_guid = p_user_guid;

Line: 823

  l_module_source := G_MODULE_SOURCE || 'process_identity_delete: ';

Line: 849

        G_OID, G_DELETE);

Line: 852

      update fnd_user
      set end_date = sysdate,
          user_guid = null
      where user_name = l_user_name;

Line: 879

end process_identity_delete;

Line: 951

procedure process_subscription_delete(p_event in ldap_event) is

  l_module_source varchar2(256);

Line: 956

  l_module_source := G_MODULE_SOURCE || 'process_subscription_delete: ';

Line: 980

end process_subscription_delete;

Line: 1062

     fnd_oid_users.hz_update(
        p_ldap_message  => l_ldap_message
      , x_return_status => l_return_status);

Line: 1069

          'after hz_update return Status: '||l_return_status);

Line: 1206

      fnd_oid_users.hz_update(
        p_ldap_message  => l_ldap_message
      , x_return_status => l_return_status);

Line: 1213

          'after hz_update return Status: '||l_return_status);

Line: 1275

    select user_id, start_date, end_date, encrypted_user_password
      from fnd_user
     where user_name = p_user_name
       and (user_guid is NULL or user_guid = p_user_guid)
       and sysdate >= start_date
       and (end_date is NULL or end_date > sysdate);

Line: 1366

	     fnd_user_pkg.UpdateUser(
  	        x_user_name=>p_user_name
   	      , x_owner=>null
              , x_unencrypted_password=>fnd_web_sec.EXTERNAL_PWD
   	      , x_email_address => l_ldap_message.mail
  	      , x_fax => l_ldap_message.facsimileTelephoneNumber
  	      , x_user_guid=>p_user_guid
	      , x_change_source =>  fnd_user_pkg.change_source_oid
             );

Line: 1377

	     fnd_user_pkg.UpdateUser(
  	        x_user_name=>p_user_name
   	      , x_owner=>null
   	      , x_email_address => l_ldap_message.mail
  	      , x_fax => l_ldap_message.facsimileTelephoneNumber
  	      , x_user_guid=>p_user_guid
	      , x_change_source =>  fnd_user_pkg.change_source_oid
             );

Line: 1421

    'After calling CreateUser or UpdateUser username: '||p_user_name||' GUID: '||p_user_guid);

Line: 1617

    select entity_key_value
    from wf_entity_changes
   where entity_id = p_event_id;

Line: 2198

   insert into wf_entity_changes(
    entity_type, entity_key_value, flavor, change_date)
    values(wf_oid.SUBSCRIPTION_ADD, upper(l_user_name), 'FND', sysdate);

Line: 2265

     select status into l_status from wf_event_subscriptions
     where rule_function = 'fnd_oid_subscriptions.hz_identity_add';

Line: 2268

     select status into l_status from wf_event_subscriptions
     where rule_function = 'fnd_oid_subscriptions.hz_identity_modify';

Line: 2270

  elsif (p_action = 'DELETE') then
     select status into l_status from wf_event_subscriptions
     where rule_function = 'fnd_oid_subscriptions.hz_identity_delete';