APPS.FND_CORE_LOG SQL Statements

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

Line: 23

     select lower(host_name), lower(instance_name)
     into lhost, linstance
     from v$instance;

Line: 40

      ** select is done since Core Logging can be performed in FND_PROFILE APIs
      ** and this could result in conflicts.  AFCORE_LOGGING_ENABLED is
      ** currently only settable only at the site level.
      */
      if CORELOG_ENABLED is NULL then
         select FPOV.PROFILE_OPTION_VALUE
         into CORELOG_ENABLED
         from fnd_profile_option_values FPOV, fnd_profile_options FPO
         where FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED'
         and FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
         and FPOV.level_id = 10001
         and FPO.APPLICATION_ID = FPOV.APPLICATION_ID; -- bug 4620968

Line: 93

      ** select is done since Core Logging can be performed in FND_PROFILE APIs
      ** and this could result in conflicts.  AFCORE_LOGGING_PROFILE_OPTION is
      ** currently only enabled at the site level.
      */
      if CORELOG_PROFILE is NULL then
         select FPOV.PROFILE_OPTION_VALUE
         into CORELOG_PROFILE
         from fnd_profile_option_values FPOV, fnd_profile_options FPO
         where FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_PROFILE_OPTION'
         and FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
         and FPOV.level_id = 10001
         and FPO.APPLICATION_ID = FPOV.APPLICATION_ID; -- bug 4620968

Line: 324

         select translate(ltrim(value),',',' ')
         into TEMP_DIR
         from v$parameter
         where lower(name) = 'utl_file_dir';

Line: 330

            select substrb(TEMP_DIR, 1, instr(TEMP_DIR,' ') - 1)
            into UTL_DIR
            from dual;