[Home] [Help]
1783:
1784: CURSOR Get_Defaulted_Category IS
1785: SELECT category_id
1786: FROM CS_KB_SOLN_CATEGORIES_B
1787: WHERE category_id = to_number(fnd_profile.value('CS_KB_CAT_FOR_INT_CREATE_API'));
1788:
1789: l_defaulted_category NUMBER;
1790:
1791: CURSOR Get_Profile_Name IS
1789: l_defaulted_category NUMBER;
1790:
1791: CURSOR Get_Profile_Name IS
1792: SELECT user_profile_option_name
1793: FROM FND_PROFILE_OPTIONS_VL
1794: WHERE profile_option_name = 'CS_KB_CAT_FOR_INT_CREATE_API';
1795:
1796: l_profile_name VARCHAR2(240);
1797:
3327: l_close_text VARCHAR2(1) := ')';
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) := '';
3340: Cursor visibility_csr Is
3341: SELECT VISIBILITY_ID
3342: FROM CS_KB_VISIBILITIES_B
3343: WHERE VISIBILITY_ID =
3344: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3345: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3346: AND nvl(End_Date_Active, sysdate+1);
3347:
3348: l_soln_visibility_id NUMBER;
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
3423:
3424: -- 2. At this point the l_query_keyword contributes the score due to the raw text.
3425: -- Next, we will include the scores from the filter of product, platfom, category,
3426: -- or statement fitlers only if the smart score mode is ON.
3427: l_smart_score_flag := fnd_profile.value('CS_KB_SMART_SCORING');
3428: If l_smart_score_flag is null or l_smart_score_flag = 'Y' Then
3429: l_query_keyword := Build_Smart_Score_Query(
3430: l_query_keyword,
3431: p_product_id_tbl,
3657: Cursor visibility_csr Is
3658: SELECT VISIBILITY_ID
3659: FROM CS_KB_VISIBILITIES_B
3660: WHERE VISIBILITY_ID =
3661: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
3662: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
3663: AND nvl(End_Date_Active, sysdate+1);
3664:
3665: l_soln_visibility_id NUMBER;
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
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:
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
4369: Cursor visibility_csr Is
4370: SELECT VISIBILITY_ID
4371: FROM CS_KB_VISIBILITIES_B
4372: WHERE VISIBILITY_ID =
4373: fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
4374: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
4375: AND nvl(End_Date_Active, sysdate+1);
4376:
4377: begin
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