APPS.IBE_SEARCH_SETUP_PVT dependencies on CTX_PREFERENCES

Line 156: cursor old_multi_lexer is select pre_name from ctxsys.ctx_preferences

152: l_create_index2 VARCHAR2(1000) ;
153: l_create_index VARCHAR2(1000) ;
154: l_base_language VARCHAR2(30);
155:
156: cursor old_multi_lexer is select pre_name from ctxsys.ctx_preferences
157: where pre_name = 'IBE_GLOBAL_LEXER';
158:
159: cursor old_sub_lexers is select pre_name from ctxsys.ctx_preferences
160: where pre_name like 'IBE_LOBS__LEXER';

Line 159: cursor old_sub_lexers is select pre_name from ctxsys.ctx_preferences

155:
156: cursor old_multi_lexer is select pre_name from ctxsys.ctx_preferences
157: where pre_name = 'IBE_GLOBAL_LEXER';
158:
159: cursor old_sub_lexers is select pre_name from ctxsys.ctx_preferences
160: where pre_name like 'IBE_LOBS__LEXER';
161: -- sytong, bug fix 2926852
162:
163: -- TYPE searchCurType IS REF CURSOR;

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

546:
547: /* bug fix 4585787 */
548: If l_db_version > 8 Then
549: -- bug 4674288 - 10gR2 compatibility issue force explicit KOREAN_LEXER drop
550: -- since it will not show in the CTX_PREFERENCES post 10gR2 upgrade.
551: if ( l_db_version >= 10 ) then
552: begin
553: ctx_ddl.drop_preference('IBE_LOBS_KLEXER');
554: exception

Line 590: from CTX_PREFERENCES

586: /* Checking if Preference exists before trying to drop it
587: */
588:
589: select count(*) into l_fuzzy_count
590: from CTX_PREFERENCES
591: where
592: pre_name = 'IBE_STEM_FUZZY_PREF' ;
593:
594: