APPS.WF_OID SQL Statements

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

Line: 89

  elsif (event.event_type = wf_oid.IDENTITY_DELETE)
  then
    fnd_oid_util.process_identity_delete(event);

Line: 97

  elsif (event.event_type = wf_oid.SUBSCRIPTION_DELETE)
  then
    fnd_oid_util.process_subscription_delete(event);

Line: 188

      delete from wf_entity_changes
       where entity_key_value = l_entity_changes_rec.entity_key_value
       and entity_type = l_entity_changes_rec.entity_type;

Line: 218

      delete from wf_entity_changes
       where entity_key_value = l_entity_changes_rec.entity_key_value
       and entity_type = l_entity_changes_rec.entity_type;

Line: 231

  l_ldap_attr_list.delete;

Line: 300

      update fnd_user
       set user_guid = event_status.orclguid
      where user_name = l_entity_key_value;

Line: 309

        , 'Update FND_USER where user_name = ' ||  l_entity_key_value ||
        ' with user_guid = ' || event_status.orclguid);

Line: 317

      update fnd_user
        set encrypted_user_password = fnd_oid_util.G_EXTERNAL
       where user_name = l_entity_key_value;

Line: 322

   delete from wf_entity_changes
     where entity_id = event_status.event_id;

Line: 328

        , 'Deleted WF_ENTITY_CHANGES where entity_id = ' ||
        event_status.event_id);