APPS.OKC_ARTICLE_KEYWORD_PVT SQL Statements

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

Line: 34

   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: 69

	select article_title into l_art_title
	from okc_articles_all a, okc_article_versions v
	where a.article_id = v.article_id
   and article_version_id = p_article_version_id;

Line: 82

      select
         to_char(pnd_timestamp,'DD-Mon-YYYY HH24:MI:SS') time,
         a.article_id art_id,
         article_version_id ver_id,
         org_id,
         v.article_language lang
      from
         ctxsys.ctx_pending p,
         okc_article_versions v,
         okc_articles_all a
      where pnd_index_name = 'OKC_ARTICLES_CTX'
      and a.article_id = v.article_id
      and v.rowid = pnd_rowid;

Line: 243

   select owner into apps
   from sys.dba_objects
   where object_name = 'OKC_ARTICLE_KEYWORD_PVT'
   and object_type = 'PACKAGE';

Line: 259

   select owner into okc
   from sys.dba_tables
   where table_name = 'OKC_ARTICLES_ALL';

Line: 387

      select 'Y' into yes_no
      from ctx_objects
      where obj_class = 'LEXER'
      and obj_name = 'CHINESE_LEXER';

Line: 419

      select 'Y' into yes_no
      from ctx_objects
      where obj_class = 'LEXER'
      and obj_name = 'JAPANESE_LEXER';

Line: 451

      select 'Y' into yes_no
      from ctx_objects
      where obj_class = 'LEXER'
      and obj_name = 'KOREAN_MORPH_LEXER';

Line: 565

   select par_value into max_memory
   from ctx_parameters
   where par_name = 'MAX_INDEX_MEMORY';

Line: 576

   select value into cpu_count
   from v$parameter
   where name = 'cpu_count';

Line: 587

   select to_number(substr(version,0,2)) into db_version
   from v$instance;