APPS.CS_KB_CONC_PROG_PKG SQL Statements

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

Line: 40

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

		  UPDATE cs_kb_sets_tl
		  SET composite_assoc_attach_index = 'R'
		  WHERE rowid = l_rowid_list(i);

Line: 82

		  UPDATE cs_kb_sets_tl
		  SET composite_assoc_index = 'R'
		  WHERE rowid = l_rowid_list(i);

Line: 145

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

Line: 179

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

Line: 214

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

Line: 242

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

Line: 297

   l_update VARCHAR2(1) := 'Y';

Line: 797

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

Line: 844

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

    l_num_batch_rows_updated NUMBER := 0;

Line: 953

        l_num_batch_rows_updated := 0;

Line: 964

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

Line: 969

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

Line: 973

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

Line: 980

          UPDATE cs_kb_sets_b
          SET reindex_flag = NULL
          WHERE set_id = l_solution_id;

Line: 984

          l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line: 990

        EXIT WHEN l_num_batch_rows_updated = 0;

Line: 1000

    Update_Magic_Word;

Line: 1053

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

    l_num_batch_rows_updated NUMBER := 0;

Line: 1120

          l_num_batch_rows_updated := 0;

Line: 1130

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

Line: 1135

            UPDATE cs_kb_elements_b
            SET reindex_flag = NULL
            WHERE element_id = l_statement_id;

Line: 1139

            l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line: 1145

          EXIT WHEN l_num_batch_rows_updated = 0;

Line: 1359

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

Line: 1360

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

Line: 1365

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

    SELECT SET_ID FROM CS_KB_SETS_B;

Line: 1385

  SELECT SysDate INTO current_date FROM dual;

Line: 1389

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

Line: 1400

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

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

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

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

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

Line: 1460

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

Line: 1466

END update_set_count_sum;

Line: 1471

 * 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: 1479

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

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

Line: 1503

  SAVEPOINT Update_Magic_Word_Sav;

Line: 1548

   ROLLBACK TO Update_Magic_Word_Sav;

Line: 1549

END Update_Magic_Word;

Line: 1552

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

BEGIN
  SAVEPOINT Update_Usage_Score_Sav;

Line: 1557

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

Line: 1562

    ROLLBACK TO Update_Usage_Score_Sav;

Line: 1572

END Update_Usage_Score;

Line: 1585

     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';