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

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

Line: 160

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

Line: 280

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

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

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

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

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

Line: 346

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

Line: 411

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

Line: 425

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

Line: 505

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

Line: 528

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

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

Line: 769

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

Line: 773

        delete from cs_kb_ele_type_links
          where link_id = p_link_id_tbl(i1);

Line: 876

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

Line: 888

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

Line: 892

        delete from cs_kb_set_links
          where link_id = p_link_id_tbl(i1);

Line: 1000

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

Line: 1012

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

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

Line: 1170

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

Line: 1174

        delete from cs_kb_element_links
          where link_id = p_link_id_tbl(i1);

Line: 1223

  p_update_sets_b in varchar2
) return number is
  l_date date;

Line: 1237

    select element_id
    from cs_kb_set_eles
    where set_id = c_sid;

Line: 1242

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

Line: 1257

  select element_type_id into l_ele_type_id
    from cs_kb_elements_b
    where element_id = p_ele_id;

Line: 1267

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

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

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

Line: 1305

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

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

Line: 1334

  p_update_sets_b in varchar2
) return number is
  l_count  pls_integer;

Line: 1342

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

Line: 1354

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

Line: 1363

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

Line: 1384

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

Line: 1395

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

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

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

Line: 1785

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

   SELECT user_profile_option_name
   FROM FND_PROFILE_OPTIONS_VL
   WHERE profile_option_name = 'CS_KB_CAT_FOR_INT_CREATE_API';

Line: 1800

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

Line: 1981

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

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

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

      OPEN  Check_Dup_Ele_Insert( l_set_id, p_ele_id_tbl(i1) );

Line: 2300

      FETCH Check_Dup_Ele_Insert INTO l_set_ele_count;

Line: 2301

      CLOSE Check_Dup_Ele_Insert;

Line: 2305

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

  select cs_kb_histories_s.nextval into l_hist_id from dual;

Line: 2589

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

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

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

Line: 3341

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

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

Line: 3658

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

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

Line: 3826

    ' select count(*) ';

Line: 3829

    ' 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: 4035

    ' select count(*) ';

Line: 4038

    ' 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: 4208

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

Line: 4211

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

Line: 4218

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

Line: 4370

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

     select sr_agent_security from CS_SYSTEM_OPTIONS
     where rownum = 1;

Line: 4466

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

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