APPS.CS_KNOWLEDGE_PVT dependencies on DUAL

Line 2527: -- Should I incr (each) individual ele_ele's? No.

2523:
2524: --
2525: -- Incr_Set_Useful
2526: -- When a set is found useful, update usefulness history table.
2527: -- Should I incr (each) individual ele_ele's? No.
2528: -- wt_code indicates which column in ele_ele to update. - just use set_count.
2529: --
2530: PROCEDURE Incr_Set_Useful(
2531: p_api_version in number,

Line 2582: select cs_kb_histories_s.nextval into l_hist_id from dual;

2578: -- insert into histories table (who, when)
2579: -- insert or update cs_kb_set_used_hists(set, usedtype, histid)
2580:
2581: --prepare data, then insert new ele
2582: select cs_kb_histories_s.nextval into l_hist_id from dual;
2583: CS_Knowledge_PVT.Get_Who(l_date, l_created_by, l_login);
2584:
2585: CS_KB_HISTORIES_PKG.Insert_Row(
2586: X_Rowid => l_rowid,

Line 3307: From dual;

3303: l_and_operator VARCHAR2(10) := ' ';
3304: -- klou (PRODFILTER)
3305: Cursor get_product_filter_csr Is
3306: Select nvl(fnd_profile.value('CS_KB_NO_GENERIC_SOLN_IN_PROD_SRCH'), 'N')
3307: From dual;
3308: l_exclude_generic_soln VARCHAR(1) := 'Y';
3309: -- klou (SMARTSCORE)
3310: l_query_filter VARCHAR2(30000) := '';
3311: l_query_keyword VARCHAR2(30000) := '';

Line 3327: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

3323: l_soln_visibility_id NUMBER;
3324:
3325: -- 39836966_cursor
3326: CURSOR Get_Magic_Word_Csr IS
3327: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
3328:
3329: l_magic_word VARCHAR2(255);
3330: -- 39836966_cursor_eof
3331: begin

Line 3647: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

3643: l_access_level_filter VARCHAR2(500);
3644:
3645: -- 39836966_cursor
3646: CURSOR Get_Magic_Word_Csr IS
3647: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
3648:
3649: l_magic_word VARCHAR2(255);
3650: -- 39836966_cursor_eof
3651: begin

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

4179: p_search_option in Number) IS
4180: l_magic_word VARCHAR2(240) := null;
4181: l_not_use_freq VARCHAR2(1) := 'Y';
4182: Cursor Get_Frequency_Csr Is
4183: Select nvl(fnd_profile.value('CS_KB_SEARCH_FREQUENCY_MODE'), 'Y') from dual;
4184:
4185: Cursor Get_Magic_Word_Csr Is
4186: Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;
4187:

Line 4186: Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;

4182: Cursor Get_Frequency_Csr Is
4183: Select nvl(fnd_profile.value('CS_KB_SEARCH_FREQUENCY_MODE'), 'Y') from dual;
4184:
4185: Cursor Get_Magic_Word_Csr Is
4186: Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;
4187:
4188: l_query VARCHAR2(32000) := p_query_str;
4189:
4190: --3534598. We can use substr because value from

Line 4453: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

4449: l_first boolean;
4450:
4451: -- 39836966_cursor
4452: CURSOR Get_Magic_Word_Csr IS
4453: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
4454:
4455: l_magic_word VARCHAR2(255);
4456: -- 39836966_cursor_eof
4457: begin