APPS.FND_CTL SQL Statements

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

Line: 61

               SELECT substr(replace(user_concurrent_program_name,'''',' '),1,240),
                  substr(concurrent_program_name,1,30)
               INTO   user_conc_program_name, conc_program_name
               FROM   FND_CONCURRENT_PROGRAMS_VL
               WHERE  concurrent_program_id = conc_program_id
               AND    APPLICATION_ID        = fnd_global.prog_appl_id;

Line: 75

          SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS')
          INTO   timestamp
          FROM SYS.DUAL;

Line: 80

          concat_var :='SELECT ' ||  ''''||
                  'TRACE_USER_DETAILS: '||
                  'TIMESTAMP='||
                  nvl(timestamp,' ')||': '||
                  'USER_NAME='||
                  nvl(user_name,' ')||': '||
                  'CONC_REQUEST_ID='||
                  nvl(output_conc_request_id,' ')||': '||
                  'OLTP_OPT_MODE='||
                  nvl(oltp_opt_mode,' ')||': '||
                  'CONC_OPT_MODE='||
                  nvl(conc_opt_mode,' ')||': '||
                  'CONC_PROG_EXE='||
                  nvl(conc_program_name,' ')||': '||
                  'CONC_PROG_NAME='||
                  nvl(user_conc_program_name,' ')||': '||
                  'RESPONSIBILITY='||
                  nvl(resp_name,' ')||': '||
                  'APPL_NAME='||
                  nvl(application_short_name,' ')||
                  ''''|| ' FROM DUAL' ;

Line: 108

         INSERT INTO FND_TRACE_LOG VALUES (
            user_name,
            sysdate,
            conc_request_id,
            oltp_opt_mode,
            conc_opt_mode,
            conc_program_name,
            user_conc_program_name,
            resp_name,
            application_short_name
         );