APPS.CS_KB_SYNC_INDEX_PKG SQL Statements

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

Line: 44

    select content_cache into l_cache
    from cs_kb_sets_tl
    where set_id = p_solution_id and language = p_lang
    for update;

Line: 52

      update cs_kb_sets_tl
      set content_cache = empty_clob()
      where set_id = p_solution_id and language = p_lang;

Line: 57

      select content_cache into l_cache
      from cs_kb_sets_tl
      where set_id = p_solution_id and language = p_lang
      for update;

Line: 92

      select language_code --into l_language_code
      from fnd_languages where installed_flag in ('I','B');

Line: 208

     select set_id --into l_prev_pub_soln_id
     from cs_kb_sets_b
     where set_number = p_solution_number
     and status = 'OUT'
     order by creation_date desc;

Line: 217

    select set_id into l_new_soln_id
    from cs_kb_sets_b
    where set_number = p_solution_number
      and status = 'PUB';

Line: 259

     select set_id --into l_prev_pub_soln_id
     from cs_kb_sets_b
     where set_number = p_solution_number
     and status = 'OUT'
     order by creation_date desc;

Line: 268

    select set_id into l_new_soln_id
    from cs_kb_sets_b
    where set_number = p_solution_number
      and status = 'OBS';

Line: 302

   *  update is performed.
   */
  PROCEDURE Mark_Idxs_on_Global_Stmt_Upd( p_statement_id number )
  is
  begin
    -- IMMEDIATE mark the statement and all of the solutions linked
    -- to it.
    Immediate_Mark_Stmt_And_Solns( p_statement_id );

Line: 323

    update cs_kb_sets_b
    set reindex_flag = 'U'
    where set_id in
      ( select a.set_id
        from cs_kb_sets_b a, cs_kb_visibilities_b b
        where a.visibility_id = b.visibility_id
          and b.position >= p_added_vis_pos );

Line: 333

    update cs_kb_elements_b
    set reindex_flag = 'U'
    where element_id in
      ( select unique c.element_id
        from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
        where a.visibility_id = b.visibility_id
          and a.set_id = c.set_id
          and b.position >= p_added_vis_pos );

Line: 344

    update cs_kb_sets_b
    set reindex_flag = 'U'
    where set_id in
      ( select unique a.set_id
        from cs_kb_set_categories a, cs_kb_soln_categories_b b,
        cs_kb_visibilities_b c
        where a.category_id = b.category_id
          and b.visibility_id = c.visibility_id
          and c.position >= p_added_vis_pos );

Line: 357

    update cs_kb_elements_b
    set reindex_flag = 'U'
    where element_id in
      ( select unique d.element_id
        from cs_kb_set_categories a, cs_kb_soln_categories_b b,
          cs_kb_visibilities_b c, cs_kb_set_eles d
        where a.category_id = b.category_id
          and a.set_id = d.set_id
          and b.visibility_id = c.visibility_id
          and c.position >= p_added_vis_pos );

Line: 379

    update cs_kb_sets_b
    set reindex_flag = 'U'
    where set_id in
      ( select a.set_id
        from cs_kb_sets_b a, cs_kb_visibilities_b b
        where a.visibility_id = b.visibility_id
          and b.position >= p_removed_vis_pos );

Line: 389

    update cs_kb_elements_b
    set reindex_flag = 'U'
    where element_id in
      ( select unique c.element_id
        from cs_kb_sets_b a, cs_kb_visibilities_b b, cs_kb_set_eles c
        where a.visibility_id = b.visibility_id
          and a.set_id = c.set_id
          and b.position >= p_removed_vis_pos );

Line: 400

    update cs_kb_sets_b
    set reindex_flag = 'U'
    where set_id in
      ( select unique a.set_id
        from cs_kb_set_categories a, cs_kb_soln_categories_b b,
        cs_kb_visibilities_b c
        where a.category_id = b.category_id
          and b.visibility_id = c.visibility_id
          and c.position >= p_removed_vis_pos );

Line: 413

    update cs_kb_elements_b
    set reindex_flag = 'U'
    where element_id in
      ( select unique d.element_id
        from cs_kb_set_categories a, cs_kb_soln_categories_b b,
          cs_kb_visibilities_b c, cs_kb_set_eles d
        where a.category_id = b.category_id
          and a.set_id = d.set_id
          and b.visibility_id = c.visibility_id
          and c.position >= p_removed_vis_pos );

Line: 437

    select position into l_orig_cat_vis_pos
    from cs_kb_visibilities_b
    where visibility_id = p_orig_vis_id;

Line: 441

    select v.position into l_new_cat_vis_pos
    from cs_kb_soln_categories_b c, cs_kb_visibilities_b v
    where c.category_id = p_cat_id
      and c.visibility_id = v.visibility_id;

Line: 451

      update cs_kb_sets_b
      set reindex_flag = 'U'
      where set_id in
        ( select set_id
          from cs_kb_set_categories
          where category_id = p_cat_id );

Line: 460

      update cs_kb_elements_b
      set reindex_flag = 'U'
      where element_id in
        ( select b.element_id
          from cs_kb_set_categories a, cs_kb_set_eles b
          where a.set_id = b.set_id
          and a.category_id = p_cat_id );

Line: 473

      update cs_kb_sets_tl
      set composite_assoc_index = 'U'
      where set_id in
        ( select set_id
          from cs_kb_set_categories
          where category_id = p_cat_id );

Line: 482

      update cs_kb_elements_tl
      set composite_text_index = 'U'
      where element_id in
        ( select b.element_id
          from cs_kb_set_categories a, cs_kb_set_eles b
          where a.set_id = b.set_id
          and a.category_id = p_cat_id );

Line: 503

    select b.set_id
    from cs_kb_set_categories c, cs_kb_sets_b b
    where c.category_id in
    (
        select category_id
        from cs_kb_soln_categories_b
        start with category_id = cp_cat_id
        connect by prior category_id = Parent_category_id
    )
    and c.set_id = b.set_id
    and b.status = 'PUB';

Line: 523

          update cs_kb_sets_tl
          set composite_assoc_index = 'U'
          where set_id = l_set_id;

Line: 529

          update cs_kb_elements_tl
          set composite_text_index = 'U'
          where element_id in
            ( select element_id
              from cs_kb_set_eles
              where set_id = l_set_id);

Line: 548

    select set_id
    from cs_kb_sets_b
    where set_id = cp_set_id
    and status = 'PUB';

Line: 563

          update cs_kb_sets_tl
          set composite_assoc_index = 'U'
          where set_id = l_set_id;

Line: 571

          update cs_kb_elements_tl
          set composite_text_index = 'U'
          where element_id in
            ( select element_id
              from cs_kb_set_eles
              where set_id = l_set_id);

Line: 590

    update cs_kb_sets_b
    set reindex_flag = 'U'
    where set_id in
      ( select unique set_id
        from cs_kb_set_categories
        where category_id in
          ( select category_id
            from cs_kb_soln_categories_b
              start with category_id = p_cat_id
              connect by prior category_id = parent_category_id ));

Line: 603

    update cs_kb_elements_b
    set reindex_flag = 'U'
    where element_id in
      ( select unique b.element_id
        from cs_kb_set_categories a, cs_kb_set_eles b
        where a.set_id = b.set_id
          and a.category_id in
            ( select category_id
              from cs_kb_soln_categories_b
                start with category_id = p_cat_id
                connect by prior category_id = parent_category_id ));

Line: 626

    update cs_kb_sets_tl
    set composite_assoc_index = 'U'
    where set_id in
      ( select unique set_id
        from cs_kb_set_categories
        where category_id in
          ( select category_id
            from cs_kb_soln_categories_b
              start with category_id = p_cat_id
              connect by prior category_id = parent_category_id ));

Line: 639

    update cs_kb_elements_tl
    set composite_text_index = 'U'
    where element_id in
      ( select unique b.element_id
        from cs_kb_set_categories a, cs_kb_set_eles b
        where a.set_id = b.set_id
          and a.category_id in
            ( select category_id
              from cs_kb_soln_categories_b
                start with category_id = p_cat_id
                connect by prior category_id = parent_category_id ));

Line: 665

    update cs_kb_sets_tl
    set composite_assoc_index = 'U'
    where set_id = p_solution_id;

Line: 676

    update cs_kb_elements_tl
    set composite_text_index = 'U'
    where element_id in
      ( select element_id from cs_kb_set_eles
        where set_id = p_solution_id );

Line: 693

     select se.set_id from cs_kb_set_eles se, cs_kb_sets_b sb
        where se.element_id = p_statement_id
          and se.set_id = sb.set_id
          and sb.status = 'PUB';

Line: 702

    update cs_kb_elements_tl
    set composite_text_index = 'U'
    where element_id = p_statement_id;

Line: 717

      UPDATE cs_kb_sets_tl
      set composite_assoc_index = 'U'
      where set_id  = l_set_ids(i);

Line: 727

        update cs_kb_sets_tl
        set composite_assoc_index = 'U'
        where set_id in
        ( select se.set_id from cs_kb_set_eles se,
          cs_kb_sets_b sb
          where se.element_id = p_statement_id
          and se.set_id = sb.set_id
          and sb.status = 'PUB');

Line: 760

    select count(*)
    into l_num_pending_requests
    from fnd_concurrent_programs cp,
      fnd_application ap,
      fnd_concurrent_requests cr
    where ap.application_short_name = l_CS_appsname
      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;

Line: 828

    select count(*)
    into l_num_pending_requests
    from fnd_concurrent_programs cp,
      fnd_application ap,
      fnd_concurrent_requests cr
    where ap.application_short_name = l_CS_appsname
      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;