APPS.CS_KB_CONC_PROG_PKG SQL Statements

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

Line: 38

     SELECT tl.rowid -- tl.set_id
     FROM cs_kb_sets_tl tl, cs_kb_sets_b b
     WHERE b.set_id = tl.set_id
     AND b.status = 'PUB';

Line: 57

          UPDATE cs_kb_sets_tl
          SET composite_assoc_index = 'R'
             --  ,last_update_date = SYSDATE  --- do not checkin updating last_update_date
          WHERE rowid = l_rowid_list(i);

Line: 116

    UPDATE /*+ parallel(t) */ cs_kb_elements_tl t
    SET t.composite_text_index = 'B';

Line: 150

    UPDATE /*+ parallel(t) */ cs_kb_soln_categories_tl t
    SET t.name = t.name;

Line: 185

    UPDATE /*+ parallel(t) */ cs_forum_messages_tl t
    SET t.composite_assoc_col = 'B';

Line: 213

     SELECT to_number(nvl(VALUE, 0))
     FROM v$parameter
     WHERE name = lower(p_name);

Line: 268

   l_update VARCHAR2(1) := 'Y';

Line: 694

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

Line: 740

      SELECT set_id
      FROM cs_kb_sets_b
     -- 3679483
       -- WHERE reindex_flag = 'Y'
      WHERE reindex_flag = 'U'
     -- 3679483 eof
      AND ROWNUM <= c_batch_size;

Line: 750

    l_num_batch_rows_updated NUMBER := 0;

Line: 816

        l_num_batch_rows_updated := 0;

Line: 826

          UPDATE cs_kb_sets_tl
          SET composite_assoc_index = 'U'
          WHERE set_id = l_solution_id;

Line: 831

          UPDATE cs_kb_sets_b
          SET reindex_flag = NULL
          WHERE set_id = l_solution_id;

Line: 835

          l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line: 841

        EXIT WHEN l_num_batch_rows_updated = 0;

Line: 851

    Update_Magic_Word;

Line: 904

      SELECT element_id
      FROM cs_kb_elements_b
      -- 3679483
      -- WHERE reindex_flag = 'Y'
      WHERE reindex_flag = 'U'
      -- 3679483 eof
      AND ROWNUM <= c_batch_size;

Line: 914

    l_num_batch_rows_updated NUMBER := 0;

Line: 971

          l_num_batch_rows_updated := 0;

Line: 981

            UPDATE cs_kb_elements_tl
            SET composite_text_index = 'U'
            WHERE element_id = l_statement_id;

Line: 986

            UPDATE cs_kb_elements_b
            SET reindex_flag = NULL
            WHERE element_id = l_statement_id;

Line: 990

            l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line: 996

          EXIT WHEN l_num_batch_rows_updated = 0;

Line: 1210

  fnd_program.delete_program ('CS_KB_SYNC_INDEX', 'CS');

Line: 1211

  fnd_program.delete_executable ('CS_KB_SYNC_INDEX', 'CS');

Line: 1216

PROCEDURE update_set_count_sum (ERRBUF OUT NOCOPY VARCHAR2,
                                RETCODE OUT NOCOPY NUMBER)
  AS

  TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE
    INDEX BY BINARY_INTEGER;

Line: 1234

    SELECT SET_ID FROM CS_KB_SETS_B;

Line: 1236

  SELECT SysDate INTO current_date FROM dual;

Line: 1240

  SELECT def_id, days BULK COLLECT INTO list_of_def_id, list_of_days
          FROM CS_KB_USED_SUM_DEFS_B;

Line: 1251

      SELECT count(H.HISTORY_ID) INTO v_used_count
      FROM CS_KB_HISTORIES_B H, CS_KB_SET_USED_HISTS USED_HISTS
      WHERE H.HISTORY_ID=USED_HISTS.HISTORY_ID AND
        USED_HISTS.SET_ID=set_record.set_id AND
        USED_HISTS.USED_TYPE=CS_KNOWLEDGE_PVT.G_PF AND
        ((current_date-H.entry_date)<=list_of_days(i));

Line: 1261

        SELECT count(SET_ID) INTO whether_exist
          FROM CS_KB_SET_USED_SUMS
          WHERE SET_ID=set_record.SET_ID AND DEF_ID=list_of_def_id(i);

Line: 1267

          INSERT INTO CS_KB_SET_USED_SUMS (
          SET_ID,
          DEF_ID,
          USED_COUNT,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN)
          VALUES (
          set_record.set_id,
          list_of_def_id(i),
          v_used_count,
          current_date,
          x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
          current_date,
          x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
          x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
          );

Line: 1289

          UPDATE CS_KB_SET_USED_SUMS SET
            USED_COUNT=v_used_count,
            LAST_UPDATE_DATE=current_date,
            LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
            LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
          WHERE set_id = set_record.set_id
          AND def_id = list_of_def_id(i);

Line: 1300

         DELETE FROM CS_KB_SET_USED_SUMS
         WHERE set_id = set_record.set_id
         AND def_id = list_of_def_id(i);

Line: 1311

  DELETE FROM cs_kb_set_used_sums
  WHERE def_id NOT IN (SELECT def_id
  FROM cs_kb_used_sum_defs_b);

Line: 1317

END update_set_count_sum;

Line: 1322

 * UPDATE THE magic word PROFILE.
 *
 */
PROCEDURE Update_Magic_Word IS
  CURSOR Get_Magic_Word_Csr IS
    SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

Line: 1330

    SELECT NULL
    FROM cs_kb_sets_vl SetEO
    WHERE
    contains(SetEO.composite_assoc_index, p_keyword, 10) >= 1
    AND ROWNUM < 2
    AND SetEO.status = 'PUB';

Line: 1347

   SELECT dbms_random.string( 'l', 5) FROM dual;

Line: 1354

  SAVEPOINT Update_Magic_Word_Sav;

Line: 1399

   ROLLBACK TO Update_Magic_Word_Sav;

Line: 1400

END Update_Magic_Word;

Line: 1403

PROCEDURE Update_Usage_Score(ERRBUF OUT NOCOPY VARCHAR2,
                             RETCODE OUT NOCOPY NUMBER) AS

BEGIN
  SAVEPOINT Update_Usage_Score_Sav;

Line: 1408

  Cs_Knowledge_Audit_Pvt.Update_Solution_Usage_Score(p_commit =>fnd_api.g_true);

Line: 1413

    ROLLBACK TO Update_Usage_Score_Sav;

Line: 1423

END Update_Usage_Score;

Line: 1436

     SELECT tl.set_id
     FROM cs_kb_sets_tl tl, cs_kb_sets_b b
     WHERE b.set_id = tl.set_id
       AND b.status = 'PUB';