569: -- Create the multi lexer preference and its constituent components --
570: ----------------------------------------------------------------------*/
571:
572: for dropit in old_multi_lexer loop
573: ctx_ddl.drop_preference('IBE_GLOBAL_LEXER');
574: end loop;
575:
576: for dropit in old_sub_lexers loop
577: ctx_ddl.drop_preference(dropit.pre_name);
573: ctx_ddl.drop_preference('IBE_GLOBAL_LEXER');
574: end loop;
575:
576: for dropit in old_sub_lexers loop
577: ctx_ddl.drop_preference(dropit.pre_name);
578: end loop;
579:
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');
581:
578: end loop;
579:
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');
581:
582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
583:
584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');
585: ctx_ddl.create_preference('ibe_lobs_clexer', 'chinese_vgram_lexer');
586: ctx_ddl.create_preference('ibe_lobs_jlexer', 'japanese_vgram_lexer');
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');
581:
582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
583:
584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');
585: ctx_ddl.create_preference('ibe_lobs_clexer', 'chinese_vgram_lexer');
586: ctx_ddl.create_preference('ibe_lobs_jlexer', 'japanese_vgram_lexer');
587:
588: /* bug fix 4585787 */
581:
582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
583:
584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');
585: ctx_ddl.create_preference('ibe_lobs_clexer', 'chinese_vgram_lexer');
586: ctx_ddl.create_preference('ibe_lobs_jlexer', 'japanese_vgram_lexer');
587:
588: /* bug fix 4585787 */
589: If l_db_version > 8 Then
582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
583:
584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');
585: ctx_ddl.create_preference('ibe_lobs_clexer', 'chinese_vgram_lexer');
586: ctx_ddl.create_preference('ibe_lobs_jlexer', 'japanese_vgram_lexer');
587:
588: /* bug fix 4585787 */
589: If l_db_version > 8 Then
590: -- bug 4674288 - 10gR2 compatibility issue force explicit KOREAN_LEXER drop
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
596: -- We need to try the drop, no worries if it is not there ...
597: when others then null;
598: end;
597: when others then null;
598: end;
599: end if;
600:
601: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_morph_lexer');
602:
603: else
604: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_lexer');
605: end if;
600:
601: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_morph_lexer');
602:
603: else
604: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_lexer');
605: end if;
606:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
603: else
604: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_lexer');
605: end if;
606:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');
610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');
611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');
604: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_lexer');
605: end if;
606:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');
610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');
611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');
612:
605: end if;
606:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');
610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');
611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');
612:
613: /*----------------end of mulit lexer ------------ */
606:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');
610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');
611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');
612:
613: /*----------------end of mulit lexer ------------ */
614:
607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');
608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');
609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');
610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');
611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');
612:
613: /*----------------end of mulit lexer ------------ */
614:
615:
634:
635:
636: if(l_fuzzy_count = 1 )
637: then
638: Ctx_Ddl.Drop_Preference('IBE_STEM_FUZZY_PREF');
639: FND_FILE.PUT_LINE(FND_FILE.LOG,' Dropped existing IBE_STEM_FUZZY_PREF preference ');
640: end if ;
641:
642: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
638: Ctx_Ddl.Drop_Preference('IBE_STEM_FUZZY_PREF');
639: FND_FILE.PUT_LINE(FND_FILE.LOG,' Dropped existing IBE_STEM_FUZZY_PREF preference ');
640: end if ;
641:
642: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
643: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01
644: */
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
641:
642: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
643: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01
644: */
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');
648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');
649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');
642: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
643: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01
644: */
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');
648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');
649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');
650:
643: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01
644: */
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');
648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');
649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');
650:
651:
644: */
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');
648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');
649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');
650:
651:
652:
645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');
646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');
647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');
648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');
649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');
650:
651:
652:
653: