APPS.IBE_SEARCH_SETUP_PVT dependencies on CTX_PREFERENCES

Line 159: cursor old_multi_lexer is select pre_name from ctx_preferences

155: l_create_index2 VARCHAR2(1000) ;
156: l_create_index VARCHAR2(1000) ;
157: l_base_language VARCHAR2(30);
158: -- bug 13935780, scnagara
159: cursor old_multi_lexer is select pre_name from ctx_preferences
160: where pre_name = 'IBE_GLOBAL_LEXER';
161:
162: cursor old_sub_lexers is select pre_name from ctx_preferences
163: where pre_name like 'IBE_LOBS__LEXER';

Line 162: cursor old_sub_lexers is select pre_name from ctx_preferences

158: -- bug 13935780, scnagara
159: cursor old_multi_lexer is select pre_name from ctx_preferences
160: where pre_name = 'IBE_GLOBAL_LEXER';
161:
162: cursor old_sub_lexers is select pre_name from ctx_preferences
163: where pre_name like 'IBE_LOBS__LEXER';
164: l_ctxsys_oracle_id NUMBER := 20129;
165: l_ctxsys_user_name VARCHAR2(10);
166: CURSOR c_get_owner(l_oracle_id NUMBER) IS

Line 591: -- since it will not show in the CTX_PREFERENCES post 10gR2 upgrade.

587:
588: /* bug fix 4585787 */
589: If l_db_version > 8 Then
590: -- bug 4674288 - 10gR2 compatibility issue force explicit KOREAN_LEXER drop
591: -- since it will not show in the CTX_PREFERENCES post 10gR2 upgrade.
592: if ( l_db_version >= 10 ) then
593: begin
594: ctx_ddl.drop_preference('IBE_LOBS_KLEXER');
595: exception

Line 631: from CTX_PREFERENCES

627: /* Checking if Preference exists before trying to drop it
628: */
629:
630: select count(*) into l_fuzzy_count
631: from CTX_PREFERENCES
632: where
633: pre_name = 'IBE_STEM_FUZZY_PREF' ;
634:
635: