APPS.CS_KNOWLEDGE_PVT dependencies on DUAL

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

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

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

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

Line 3332: From dual;

3328: l_and_operator VARCHAR2(10) := ' ';
3329: -- klou (PRODFILTER)
3330: Cursor get_product_filter_csr Is
3331: Select nvl(fnd_profile.value('CS_KB_NO_GENERIC_SOLN_IN_PROD_SRCH'), 'N')
3332: From dual;
3333: l_exclude_generic_soln VARCHAR(1) := 'Y';
3334: -- klou (SMARTSCORE)
3335: l_query_filter VARCHAR2(30000) := '';
3336: l_query_keyword VARCHAR2(30000) := '';

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

3348: l_soln_visibility_id NUMBER;
3349:
3350: -- 39836966_cursor
3351: CURSOR Get_Magic_Word_Csr IS
3352: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
3353:
3354: l_magic_word VARCHAR2(255);
3355: -- 39836966_cursor_eof
3356: begin

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

3668: l_access_level_filter VARCHAR2(500);
3669:
3670: -- 39836966_cursor
3671: CURSOR Get_Magic_Word_Csr IS
3672: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
3673:
3674: l_magic_word VARCHAR2(255);
3675: -- 39836966_cursor_eof
3676: begin

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

4204: p_search_option in Number) IS
4205: l_magic_word VARCHAR2(240) := null;
4206: l_not_use_freq VARCHAR2(1) := 'Y';
4207: Cursor Get_Frequency_Csr Is
4208: Select nvl(fnd_profile.value('CS_KB_SEARCH_FREQUENCY_MODE'), 'Y') from dual;
4209:
4210: Cursor Get_Magic_Word_Csr Is
4211: Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;
4212:

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

4207: Cursor Get_Frequency_Csr Is
4208: Select nvl(fnd_profile.value('CS_KB_SEARCH_FREQUENCY_MODE'), 'Y') from dual;
4209:
4210: Cursor Get_Magic_Word_Csr Is
4211: Select fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') from dual;
4212:
4213: l_query VARCHAR2(32000) := p_query_str;
4214:
4215: --3534598. We can use substr because value from

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

4474: l_first boolean;
4475:
4476: -- 39836966_cursor
4477: CURSOR Get_Magic_Word_Csr IS
4478: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
4479:
4480: l_magic_word VARCHAR2(255);
4481: -- 39836966_cursor_eof
4482: begin