APPS.IBC_CONTENT_SYNC_INDEX_PKG SQL Statements

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

Line: 74

     SELECT to_number(nvl(VALUE, 0)) INTO  l_worker FROM v$parameter
     WHERE NAME = 'job_queue_processes';

Line: 149

   select idx_name from ctxsys.ctx_indexes
   where idx_name=l_index_name
   and upper(idx_owner)=UPPER('IBC');

Line: 265

       SELECT COUNT(*) FROM dba_indexes
       WHERE index_name = UPPER(p_index_name)
       AND owner= UPPER(p_owner);

Line: 312

    select count(*)
    into l_num_pending_requests
    from fnd_concurrent_programs cp,
      fnd_application ap,
      fnd_concurrent_requests cr
    where ap.application_short_name = g_ibc_short_name
      and cp.concurrent_program_name = l_sync_idx_progname
      and cp.application_id = ap.application_id
      and cr.concurrent_program_id = cp.concurrent_program_id
      and cr.phase_code = l_pending_phase_code
      and cr.requested_start_date <= sysdate;