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

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

Line: 427

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

Line: 737

    select user_name, user_id
      from fnd_user
     where user_guid = hextoraw(p_user_guid);

Line: 827

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 = hextoraw(p_user_guid);

Line: 841

  l_module_source := G_MODULE_SOURCE || 'process_identity_delete: ';

Line: 872

        G_OID, G_DELETE);

Line: 875

  /* Bug 13829710 - Raise the oracle.apps.fnd.identity.delete event so that
   * administrators can add custom subscription
   */

   if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
   then
       fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Raise identity_delete event for user: '||l_user_name);

Line: 887

    wf_event.AddParameterToList('CHANGE_TYPE', G_DELETE, my_parms);

Line: 896

      , p_entity_type       => wf_oid.IDENTITY_DELETE
      , p_entity_key_value  => l_user_name);

Line: 904

    wf_event.raise('oracle.apps.fnd.identity.delete', upper(l_user_name), null, null);

Line: 915

      update fnd_user
      set   user_guid = null
      where user_name = l_user_name;

Line: 947

end process_identity_delete;

Line: 1019

procedure process_subscription_delete(p_event in ldap_event) is

  l_module_source varchar2(256);

Line: 1024

  l_module_source := G_MODULE_SOURCE || 'process_subscription_delete: ';

Line: 1048

end process_subscription_delete;

Line: 1130

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

Line: 1137

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

Line: 1274

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

Line: 1281

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

Line: 1343

    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 = hextoraw(p_user_guid))
       and sysdate >= start_date
       and (end_date is NULL or end_date > sysdate);

Line: 1434

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

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

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

Line: 1685

    select entity_key_value
    from wf_entity_changes
   where entity_id = p_event_id;

Line: 2362

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

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

Line: 2432

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

Line: 2434

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