APPS.OKC_CHR_KEYWORD_PVT SQL Statements

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

Line: 68

    SELECT request_id INTO result
    FROM fnd_concurrent_requests
    WHERE concurrent_program_id IN (SELECT concurrent_program_id
                                    FROM fnd_concurrent_programs
                                    WHERE concurrent_program_name = prog_name)
    AND phase_code = 'R';

Line: 96

      SELECT owner INTO apps
      FROM sys.dba_objects
      WHERE object_name = 'OKC_CHR_KEYWORD_PVT'
      AND object_type = 'PACKAGE';

Line: 111

      SELECT owner INTO okc
      FROM sys.dba_tables
      WHERE table_name = 'OKC_K_HEADERS_TL';

Line: 203

          SELECT 'Y' INTO yes_no
          FROM ctx_objects
          WHERE obj_class = 'LEXER'
          AND obj_name = 'CHINESE_LEXER';

Line: 234

          SELECT 'Y' INTO yes_no
          FROM ctx_objects
          WHERE obj_class = 'LEXER'
          AND obj_name = 'JAPANESE_LEXER';

Line: 265

          SELECT 'Y' INTO yes_no
          FROM ctx_objects
          WHERE obj_class = 'LEXER'
          AND obj_name = 'KOREAN_MORPH_LEXER';

Line: 338

      SELECT par_value INTO l_max_memory
      FROM ctx_parameters
      WHERE par_name = 'MAX_INDEX_MEMORY';

Line: 348

      SELECT value INTO l_cpu_count
      FROM v$parameter
      WHERE name = 'cpu_count';