DBA Data[Home] [Help]

APPS.IBE_SEARCH_SETUP_PVT dependencies on CTX_DDL

Line 573: ctx_ddl.drop_preference('IBE_GLOBAL_LEXER');

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);

Line 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:

Line 582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');

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');

Line 584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_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 */

Line 585: ctx_ddl.create_preference('ibe_lobs_clexer', 'chinese_vgram_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 */
589: If l_db_version > 8 Then

Line 586: ctx_ddl.create_preference('ibe_lobs_jlexer', 'japanese_vgram_lexer');

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

Line 594: ctx_ddl.drop_preference('IBE_LOBS_KLEXER');

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;

Line 601: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_morph_lexer');

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;

Line 604: ctx_ddl.create_preference('ibe_lobs_klexer', 'korean_lexer');

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');

Line 607: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'JA', 'ibe_lobs_jlexer');

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');

Line 608: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'KO', 'ibe_lobs_klexer');

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:

Line 609: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHS', 'ibe_lobs_clexer');

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 ------------ */

Line 610: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'ZHT', 'ibe_lobs_clexer');

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:

Line 611: ctx_ddl.add_sub_lexer('ibe_global_lexer', 'default', 'ibe_lobs_blexer');

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:

Line 638: Ctx_Ddl.Drop_Preference('IBE_STEM_FUZZY_PREF');

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');

Line 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');

Line 645: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_MATCH','AUTO');

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');

Line 646: --ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','0');

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:

Line 647: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_SCORE','1');

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:

Line 648: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000');

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:

Line 649: ctx_ddl.set_attribute('IBE_STEM_FUZZY_PREF','STEMMER','AUTO');

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: