APPS.CS_KNOWLEDGE_PVT SQL Statements

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

Line: 94

 *                        column to the search query select list.
 *   25-Oct-2005 klou (3983696)
 *               - Fix bug 3983696.
 *   19-May-2006 klou (5217204)
 *               - Escape % that is prefixed or postfixed with by a symbol that
 *                 will be parsed as blank by the text parser. This fix only supports
 *                 the out-of-box symbols and has a drawback to ignore wildcard
 *                 expansion if customers define a symobol as printjoins character,
 *                 e.g. we will escape .% to .\% because the dot (.)
 *                 will be parsed as blank by the text parser.  But, if it is
 *                 printjoin character, the parser will consider it as alphanumeric;

Line: 129

    select element_type_id
    from cs_kb_set_ele_types
    where set_type_id = p_set_type_id
    and optional_flag = 'N';

Line: 158

        select element_type_id into l_type_id
          from cs_kb_elements_b
          where element_id = p_ele_def_tbl(i1).element_id;

Line: 278

      select count(*) into l_count
        from cs_kb_set_ele_types se,
             cs_kb_sets_b s,
             cs_kb_elements_b e
        where se.set_type_id = s.set_type_id
        and se.element_type_id = e.element_type_id
        and s.set_id = p_set_id
        and e.element_id = p_ele_id;

Line: 288

      select count(*) into l_count
        from cs_kb_set_ele_types se,
             cs_kb_sets_b s
        where se.set_type_id = s.set_type_id
        and s.set_id = p_set_id
        and se.element_type_id = p_ele_type_id;

Line: 298

      select count(*) into l_count
        from cs_kb_set_ele_types se,
             cs_kb_elements_b e
        where se.set_type_id = p_set_type_id
        and e.element_id = p_ele_id
        and se.element_type_id = e.element_type_id;

Line: 306

      select count(*) into l_count
        from cs_kb_set_ele_types se
        where se.set_type_id = p_set_type_id
        and se.element_type_id = p_ele_type_id;

Line: 327

 select count(*) into l_count
    from cs_kb_set_types_b
    where set_type_id = p_set_type_id;

Line: 344

  select count(*) into l_count
    from cs_kb_element_types_b
    where element_type_id = p_ele_type_id;

Line: 409

    ' select set_id, count(*) count from cs_kb_set_eles c '||
    ' where element_id in (';

Line: 423

    return G_TRUE; --i.e. should abort insert/create set.

Line: 503

    select select_id, select_name, from_table, where_clause
    from jtf_objects_vl
    where object_code = c_objcode;

Line: 526

    l_query := 'select distinct ' || l_jtfobj_rec.select_id || ', '||
        l_jtfobj_rec.select_name || ' from ' ||
        l_jtfobj_rec.from_table || ' where '||
        l_jtfobj_rec.select_id || '=:1';

Line: 754

        select count(*) into l_count
          from cs_kb_element_types_b
          where element_type_id = l_ele_type_id;

Line: 767

        update cs_kb_ele_type_links set
          element_type_id = l_ele_type_id
          where link_id = p_link_id_tbl(i1);

Line: 771

        delete from cs_kb_ele_type_links
          where link_id = p_link_id_tbl(i1);

Line: 874

        select count(*) into l_count
          from cs_kb_sets_b
          where set_id = l_set_id;

Line: 886

        update cs_kb_set_links set
          set_id = l_set_id
          where link_id = p_link_id_tbl(i1);

Line: 890

        delete from cs_kb_set_links
          where link_id = p_link_id_tbl(i1);

Line: 998

        select count(*) into l_count
          from cs_kb_elements_b
          where element_id = l_element_id;

Line: 1010

        select count(*) into l_count
          from cs_kb_set_eles
          where set_id = p_set_id_tbl(i1)
          and element_id = l_element_id;

Line: 1157

        select count(*) into l_count
          from cs_kb_elements_b
          where element_id = l_element_id;

Line: 1168

        update cs_kb_element_links set
          element_id = l_element_id
          where link_id = p_link_id_tbl(i1);

Line: 1172

        delete from cs_kb_element_links
          where link_id = p_link_id_tbl(i1);

Line: 1221

  p_update_sets_b in varchar2
) return number is
  l_date date;

Line: 1235

    select element_id
    from cs_kb_set_eles
    where set_id = c_sid;

Line: 1240

    select s.set_type_id
    from cs_kb_sets_vl s
    where s.set_id = p_set_id;

Line: 1255

  select element_type_id into l_ele_type_id
    from cs_kb_elements_b
    where element_id = p_ele_id;

Line: 1265

   select optional_flag into l_optional_flag
     from cs_kb_set_ele_types
     where set_type_id = l_set_rec.set_type_id
     and element_type_id = l_ele_type_id;

Line: 1281

    select count(*) into l_count
      from cs_kb_set_eles se, cs_kb_elements_b e
      where se.set_id = p_set_id
      and se.element_id = e.element_id
      and e.element_type_id = l_ele_type_id;

Line: 1293

  delete from cs_kb_set_eles
    where element_id = p_ele_id
    and set_id = p_set_id;

Line: 1303

  if(p_update_sets_b = 'T') then

    update cs_kb_sets_b set
     last_update_date = l_date,
     last_updated_by = l_user,
     last_update_login = l_login
     where set_id = p_set_id;

Line: 1313

  update cs_kb_sets_tl set
    positive_assoc_index = 'c',
    negative_assoc_index = 'c',
    composite_assoc_index = 'c'
    where set_id = p_set_id;

Line: 1331

  p_update_sets_b in varchar2
) return number is
  l_count  pls_integer;

Line: 1339

    select element_id
    from cs_kb_set_eles
    where set_id = c_sid; /* can add: and element_id <> p_ele_id */

Line: 1351

  select count(*) into l_count
      from cs_kb_elements_b
      where element_id = p_ele_id;

Line: 1360

  select count(*) into l_count
      from cs_kb_set_eles
      where set_id = p_set_id
      and element_id = p_ele_id;

Line: 1381

  select max(element_order) into l_order
    from cs_kb_set_eles
    where set_id = p_set_id;

Line: 1392

  insert into cs_kb_set_eles (
        set_id, element_id, element_order, assoc_degree,
        creation_date, created_by,
        last_update_date, last_updated_by, last_update_login)
        values(
        p_set_id, p_ele_id, l_order, p_assoc_degree,
        l_date, l_created_by, l_date, l_created_by, l_login);

Line: 1401

  if(p_update_sets_b = 'T') then

    update cs_kb_sets_b set
      last_update_date = l_date,
      last_updated_by = l_created_by,
      last_update_login = l_login
      where set_id = p_set_id;

Line: 1411

  update cs_kb_sets_tl set
    positive_assoc_index = 'c',
    negative_assoc_index = 'c',
    composite_assoc_index = 'c'
    where set_id = p_set_id;

Line: 1781

   SELECT category_id
   FROM CS_KB_SOLN_CATEGORIES_B
   WHERE category_id = to_number(fnd_profile.value('CS_KB_CAT_FOR_INT_CREATE_API'));

Line: 1788

   SELECT user_profile_option_name
   FROM FND_PROFILE_OPTIONS_VL
   WHERE profile_option_name = 'CS_KB_CAT_FOR_INT_CREATE_API';

Line: 1796

   SELECT count(*)
   FROM CS_KB_ELEMENTS_B
   WHERE Element_Id = v_ele_id
   AND status = 'PUBLISHED';

Line: 1977

      INSERT INTO CS_KB_SET_CATEGORIES (
              SET_ID,
              CATEGORY_ID,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN	)
      VALUES (x_set_id,
              l_defaulted_category,
              sysdate,
              l_user,
              sysdate,
              l_user,
              l_user_login);

Line: 2125

   SELECT visibility_id
   FROM cs_kb_visibilities_b
   WHERE position = ( SELECT min(position)
                      FROM cs_kb_visibilities_b
                      WHERE sysdate BETWEEN nvl(start_date_active, sysdate-1)
                      AND  nvl(end_date_active, sysdate+1));

Line: 2137

  CURSOR Check_Dup_Ele_Insert (v_set_id NUMBER,
                               v_ele_id NUMBER ) IS
   SELECT count(*)
   FROM CS_KB_SET_ELES
   WHERE set_id = v_set_id
   AND   element_id = v_ele_id;

Line: 2295

      OPEN  Check_Dup_Ele_Insert( l_set_id, p_ele_id_tbl(i1) );

Line: 2296

      FETCH Check_Dup_Ele_Insert INTO l_set_ele_count;

Line: 2297

      CLOSE Check_Dup_Ele_Insert;

Line: 2301

        insert into cs_kb_set_eles (
          set_id, element_id, element_order, assoc_degree,
          creation_date, created_by,
          last_update_date, last_updated_by, last_update_login)
        values(
        l_set_id, p_ele_id_tbl(i1), i1, l_assoc,
        l_date, l_created_by, l_date, l_created_by, l_login);

Line: 2582

  select cs_kb_histories_s.nextval into l_hist_id from dual;

Line: 2585

  CS_KB_HISTORIES_PKG.Insert_Row(
    X_Rowid => l_rowid,
    X_History_Id => l_hist_id,
    X_History_Name => null,
    X_User_Id => p_user_id,
    X_Entry_Date => l_date,
    X_Name => null,
    X_Description => null,
    X_Creation_Date => l_date,
    X_Created_By => l_created_by,
    X_Last_Update_Date => l_date,
    X_Last_Updated_By => l_created_by,
    X_Last_Update_Login => l_login);

Line: 2599

  insert into cs_kb_set_used_hists(
        set_id, history_id,
        creation_date, created_by, last_update_date,
        last_updated_by, last_update_login,used_type, session_id)
        values(
        p_set_id, l_hist_id, l_date, l_created_by, l_date,
        l_created_by, l_login, p_used_type, p_session_id );

Line: 3306

      Select nvl(fnd_profile.value('CS_KB_NO_GENERIC_SOLN_IN_PROD_SRCH'), 'N')
      From dual;

Line: 3316

    SELECT VISIBILITY_ID
    FROM CS_KB_VISIBILITIES_B
    WHERE VISIBILITY_ID =
      fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
    AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
                  AND nvl(End_Date_Active, sysdate+1);

Line: 3327

    SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

Line: 3633

    SELECT VISIBILITY_ID
    FROM CS_KB_VISIBILITIES_B
    WHERE VISIBILITY_ID =
      fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
    AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
                  AND nvl(End_Date_Active, sysdate+1);

Line: 3647

    SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

Line: 3801

    ' select count(*) ';

Line: 3804

    ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
    ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
    ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
    ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
    ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
    ' cs_kb_sets_b.set_number ';

Line: 4010

    ' select count(*) ';

Line: 4013

    ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
    ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
    ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
    ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
    ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
    ' cs_kb_sets_b.set_number ';

Line: 4183

    Select nvl(fnd_profile.value('CS_KB_SEARCH_FREQUENCY_MODE'), 'Y') from dual;

Line: 4186

    Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;

Line: 4193

    select substr(value, 1,1) from v$nls_parameters
    where parameter = 'NLS_NUMERIC_CHARACTERS';

Line: 4345

    SELECT VISIBILITY_ID
    FROM CS_KB_VISIBILITIES_B
    WHERE VISIBILITY_ID =
      fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
    AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
                  AND nvl(End_Date_Active, sysdate+1);

Line: 4437

     select sr_agent_security from CS_SYSTEM_OPTIONS
     where rownum = 1;

Line: 4441

    SELECT incident_type_id
    FROM cs_sr_type_mapping csmap
    WHERE csmap.responsibility_id = fnd_global.resp_id
    AND  trunc(sysdate)between trunc(nvl(csmap.start_date, sysdate))
    AND  trunc(nvl(csmap.end_date,sysdate));

Line: 4453

    SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;