[Home] [Help]
1779:
1780: CURSOR Get_Defaulted_Category IS
1781: SELECT category_id
1782: FROM CS_KB_SOLN_CATEGORIES_B
1783: WHERE category_id = to_number(fnd_profile.value('CS_KB_CAT_FOR_INT_CREATE_API'));
1784:
1785: l_defaulted_category NUMBER;
1786:
1787: CURSOR Get_Profile_Name IS
1785: l_defaulted_category NUMBER;
1786:
1787: CURSOR Get_Profile_Name IS
1788: SELECT user_profile_option_name
1789: FROM FND_PROFILE_OPTIONS_VL
1790: WHERE profile_option_name = 'CS_KB_CAT_FOR_INT_CREATE_API';
1791:
1792: l_profile_name VARCHAR2(240);
1793:
3302: l_close_text VARCHAR2(1) := ')';
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) := '';
3315: Cursor visibility_csr Is
3316: SELECT VISIBILITY_ID
3317: FROM CS_KB_VISIBILITIES_B
3318: WHERE VISIBILITY_ID =
3319: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3320: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3321: AND nvl(End_Date_Active, sysdate+1);
3322:
3323: l_soln_visibility_id NUMBER;
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
3398:
3399: -- 2. At this point the l_query_keyword contributes the score due to the raw text.
3400: -- Next, we will include the scores from the filter of product, platfom, category,
3401: -- or statement fitlers only if the smart score mode is ON.
3402: l_smart_score_flag := fnd_profile.value('CS_KB_SMART_SCORING');
3403: If l_smart_score_flag is null or l_smart_score_flag = 'Y' Then
3404: l_query_keyword := Build_Smart_Score_Query(
3405: l_query_keyword,
3406: p_product_id_tbl,
3632: Cursor visibility_csr Is
3633: SELECT VISIBILITY_ID
3634: FROM CS_KB_VISIBILITIES_B
3635: WHERE VISIBILITY_ID =
3636: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3637: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3638: AND nvl(End_Date_Active, sysdate+1);
3639:
3640: l_soln_visibility_id NUMBER;
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
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:
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
4344: Cursor visibility_csr Is
4345: SELECT VISIBILITY_ID
4346: FROM CS_KB_VISIBILITIES_B
4347: WHERE VISIBILITY_ID =
4348: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
4349: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
4350: AND nvl(End_Date_Active, sysdate+1);
4351:
4352: begin
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