APPS.JTF_DEBUG_PUB SQL Statements

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

Line: 73

     select  user_profile_option_name
     from   fnd_profile_options_vl
     where  profile_option_name = 'UTL_FILE_LOG';

Line: 281

      SELECT message_text
      FROM   fnd_log_messages
      WHERE  module like p_module
      AND    session_id = p_session_id
      AND    user_id = p_user_id
      AND    timestamp >= to_date(p_timestamp, 'DD-MM-YYYY HH24:MI:SS')
      ORDER BY log_sequence;

Line: 290

     SELECT to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')
     FROM dual;

Line: 323

        SELECT substr(value,1,instr(value,',',1,1)-1)
        INTO   l_dir
        FROM  v$parameter
        WHERE name = 'utl_file_dir';

Line: 328

           SELECT value
           INTO l_dir
           FROM v$parameter
           WHERE name = 'utl_file_dir';

Line: 340

        SELECT  substr('l'|| substr(to_char(sysdate,'MI'),1,1)
                 || lpad(jtf_Debug_s.nextval,6,'0'),1,8) || '.dbg'
          into l_filename
          from dual;

Line: 511

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 516

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 580

         fnd_msg_pub.delete_msg(MSG_INDEX);