APPS.FND_LOGVIEW SQL Statements

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

Line: 181

');

Line: 524

    nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(FND_GLOBAL.USER_ID,
                                   icx_sec.getsessioncookie());

Line: 532

    nrows := FND_LOG_ADMIN.DELETE_BY_USER(FND_GLOBAL.USER_ID);

Line: 581

        select user_id into f_user_id from fnd_user
        where user_name = upper(username);

Line: 624

  'select MODULE||to_number(rownum), LOG_LEVEL, MESSAGE_TEXT, SESSION_ID, USER_ID, TIMESTAMP '||
   'from fnd_log_messages '||
  'where ';

Line: 939

             select user_name into found_username
               from fnd_user
              where user_id = l_user_id;

Line: 1044

procedure Update_Prefs(
                ENABLED     in VARCHAR2 default 'off',
                FILENAME    in VARCHAR2,
                LEVEL       in VARCHAR2 default NULL,
                MODULE      in VARCHAR2,
                SESSION_TO_PURGE   in VARCHAR2 default NULL,
                USER_TO_PURGE      in VARCHAR2 default NULL,
                USER_TO_SET        in VARCHAR2 default NULL,
                SAVE               in VARCHAR2 default NULL,
                clearprefs         in VARCHAR2 default NULL,
                clearsessionlog    in VARCHAR2 default NULL,
                clearuserlog       in VARCHAR2 default NULL,
                clear              in VARCHAR2 default NULL,
                sysclear           in VARCHAR2 default NULL,
                syssave            in VARCHAR2 default NULL,
                syspurgeallusers   in VARCHAR2 default NULL,
                syssetuserprefs    in VARCHAR2 default NULL,
                SYSCLEARPREFS      in VARCHAR2 default NULL,
                SYSCLEARSESSIONLOG in VARCHAR2 default NULL,
                SYSCLEARUSERLOG    in VARCHAR2 default NULL,
                USER_ID            in VARCHAR2 default NULL) is

c_error_message varchar2(2000);

Line: 1162

      nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));

Line: 1173

      nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,
                                   icx_sec.getsessioncookie());

Line: 1181

        select user_id into user_id_x from fnd_user
          where user_name = upper(USER_TO_PURGE);

Line: 1189

         nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

Line: 1198

      nrows := FND_LOG_ADMIN.DELETE_ALL;

Line: 1206

        select user_id into user_id_x from fnd_user
          where user_name = upper(USER_TO_SET);

Line: 1224

      nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

Line: 1230

      htp.p('
Internal Error- update_prefs call missing args.');

Line: 1258

        select substr(c_error_message, 12, 512) into err_mesg from dual;

Line: 1278

  FND_LOGVIEW.Update_Prefs('on', null, 3,
    'FnD.sRc.FlEx.%, fnd.src.dict.afdict.afdget.start, fnd.src.flex.fdfv.fdfval.dff',
    null, null, null, 'Save', null, null, null, null, null, null,
            null, null, null, null, null, null);

Line: 1315

delete from FND_LOG_MESSAGES where user_id = USER_ID;