eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on AD_CTX_DDL

Line 49: ad_ctx_ddl.set_effective_schema('okc');

45: end;
46:
47: procedure sync is
48: begin
49: ad_ctx_ddl.set_effective_schema('okc');
50: ad_ctx_ddl.sync_index('okc_articles_ctx');
51: exception when others then raise;
52: end;
53:

Line 50: ad_ctx_ddl.sync_index('okc_articles_ctx');

46:
47: procedure sync is
48: begin
49: ad_ctx_ddl.set_effective_schema('okc');
50: ad_ctx_ddl.sync_index('okc_articles_ctx');
51: exception when others then raise;
52: end;
53:
54: procedure optimize is

Line 56: ad_ctx_ddl.set_effective_schema('okc');

52: end;
53:
54: procedure optimize is
55: begin
56: ad_ctx_ddl.set_effective_schema('okc');
57: ad_ctx_ddl.optimize_index (
58: idx_name => 'okc_articles_ctx',
59: optlevel => ad_ctx_ddl.optlevel_full,
60: maxtime => ad_ctx_ddl.maxtime_unlimited

Line 57: ad_ctx_ddl.optimize_index (

53:
54: procedure optimize is
55: begin
56: ad_ctx_ddl.set_effective_schema('okc');
57: ad_ctx_ddl.optimize_index (
58: idx_name => 'okc_articles_ctx',
59: optlevel => ad_ctx_ddl.optlevel_full,
60: maxtime => ad_ctx_ddl.maxtime_unlimited
61: );

Line 59: optlevel => ad_ctx_ddl.optlevel_full,

55: begin
56: ad_ctx_ddl.set_effective_schema('okc');
57: ad_ctx_ddl.optimize_index (
58: idx_name => 'okc_articles_ctx',
59: optlevel => ad_ctx_ddl.optlevel_full,
60: maxtime => ad_ctx_ddl.maxtime_unlimited
61: );
62: exception when others then raise;
63: end;

Line 60: maxtime => ad_ctx_ddl.maxtime_unlimited

56: ad_ctx_ddl.set_effective_schema('okc');
57: ad_ctx_ddl.optimize_index (
58: idx_name => 'okc_articles_ctx',
59: optlevel => ad_ctx_ddl.optlevel_full,
60: maxtime => ad_ctx_ddl.maxtime_unlimited
61: );
62: exception when others then raise;
63: end;
64:

Line 299: ad_ctx_ddl.drop_preference('okc_articles_datastore');

295: begin
296: -- DATASTORE
297: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_DATASTORE preference creation ...');
298: begin
299: ad_ctx_ddl.drop_preference('okc_articles_datastore');
300: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_DATASTORE preference');
301: exception when others then
302: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_DATASTORE preference');
303: end;

Line 304: ad_ctx_ddl.create_preference('okc_articles_datastore','multi_column_datastore');

300: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_DATASTORE preference');
301: exception when others then
302: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_DATASTORE preference');
303: end;
304: ad_ctx_ddl.create_preference('okc_articles_datastore','multi_column_datastore');
305: ad_ctx_ddl.set_attribute('okc_articles_datastore','columns',
306: apps||'.okc_article_keyword_pvt.article_title(article_version_id) art_title,
307: display_name art_disp, article_description art_descr, article_text art_text, additional_instructions art_instr');
308: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_DATASTORE preference has been created successfully as MULTI_COLUMN_DATASTORE');

Line 305: ad_ctx_ddl.set_attribute('okc_articles_datastore','columns',

301: exception when others then
302: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_DATASTORE preference');
303: end;
304: ad_ctx_ddl.create_preference('okc_articles_datastore','multi_column_datastore');
305: ad_ctx_ddl.set_attribute('okc_articles_datastore','columns',
306: apps||'.okc_article_keyword_pvt.article_title(article_version_id) art_title,
307: display_name art_disp, article_description art_descr, article_text art_text, additional_instructions art_instr');
308: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_DATASTORE preference has been created successfully as MULTI_COLUMN_DATASTORE');
309:

Line 321: ad_ctx_ddl.drop_section_group('okc_article_sections');

317: begin
318: -- SECTION GROUP
319: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS section group creation ...');
320: begin
321: ad_ctx_ddl.drop_section_group('okc_article_sections');
322: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLE_SECTIONS section group');
323: exception when others then
324: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLE_SECTIONS section group');
325: end;

Line 326: ad_ctx_ddl.create_section_group('okc_article_sections', 'BASIC_SECTION_GROUP');

322: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLE_SECTIONS section group');
323: exception when others then
324: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLE_SECTIONS section group');
325: end;
326: ad_ctx_ddl.create_section_group('okc_article_sections', 'BASIC_SECTION_GROUP');
327: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Title');
328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);
329: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Display');
330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);

Line 328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);

324: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLE_SECTIONS section group');
325: end;
326: ad_ctx_ddl.create_section_group('okc_article_sections', 'BASIC_SECTION_GROUP');
327: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Title');
328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);
329: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Display');
330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);
331: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Description');
332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);

Line 330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);

326: ad_ctx_ddl.create_section_group('okc_article_sections', 'BASIC_SECTION_GROUP');
327: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Title');
328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);
329: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Display');
330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);
331: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Description');
332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);
333: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Instruction');
334: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);

Line 332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);

328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);
329: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Display');
330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);
331: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Description');
332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);
333: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Instruction');
334: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);
335: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Text');
336: ad_ctx_ddl.add_field_section('okc_article_sections', 'Text', '', true);

Line 334: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);

330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);
331: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Description');
332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);
333: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Instruction');
334: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);
335: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Text');
336: ad_ctx_ddl.add_field_section('okc_article_sections', 'Text', '', true);
337: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS section group has been created successfully as BASIC_SECTION_GROUP');
338:

Line 336: ad_ctx_ddl.add_field_section('okc_article_sections', 'Text', '', true);

332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);
333: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Instruction');
334: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);
335: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Text');
336: ad_ctx_ddl.add_field_section('okc_article_sections', 'Text', '', true);
337: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS section group has been created successfully as BASIC_SECTION_GROUP');
338:
339: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 18);
340:

Line 350: ad_ctx_ddl.drop_preference('okc_articles_lexer');

346: begin
347: -- LEXER
348: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER preference creation ...');
349: begin
350: ad_ctx_ddl.drop_preference('okc_articles_lexer');
351: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_LEXER preference');
352: exception when others then
353: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_LEXER preference');
354: end;

Line 355: ad_ctx_ddl.create_preference('okc_articles_lexer','multi_lexer');

351: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_LEXER preference');
352: exception when others then
353: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_LEXER preference');
354: end;
355: ad_ctx_ddl.create_preference('okc_articles_lexer','multi_lexer');
356: begin
357: ad_ctx_ddl.drop_preference('okc_blexer');
358: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_BLEXER preference');
359: exception when others then

Line 357: ad_ctx_ddl.drop_preference('okc_blexer');

353: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_LEXER preference');
354: end;
355: ad_ctx_ddl.create_preference('okc_articles_lexer','multi_lexer');
356: begin
357: ad_ctx_ddl.drop_preference('okc_blexer');
358: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_BLEXER preference');
359: exception when others then
360: fnd_file.put_line(fnd_file.log,'Creating new OKC_BLEXER preference');
361: end;

Line 362: ad_ctx_ddl.create_preference('okc_blexer','basic_lexer');

358: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_BLEXER preference');
359: exception when others then
360: fnd_file.put_line(fnd_file.log,'Creating new OKC_BLEXER preference');
361: end;
362: ad_ctx_ddl.create_preference('okc_blexer','basic_lexer');
363: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_themes=false');
364: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');
365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_text=true');
366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');

Line 364: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');

360: fnd_file.put_line(fnd_file.log,'Creating new OKC_BLEXER preference');
361: end;
362: ad_ctx_ddl.create_preference('okc_blexer','basic_lexer');
363: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_themes=false');
364: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');
365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_text=true');
366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');
367: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute base_letter=true');
368: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');

Line 366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');

362: ad_ctx_ddl.create_preference('okc_blexer','basic_lexer');
363: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_themes=false');
364: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');
365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_text=true');
366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');
367: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute base_letter=true');
368: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');
369: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute mixed_case=false');
370: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');

Line 368: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');

364: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');
365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_text=true');
366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');
367: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute base_letter=true');
368: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');
369: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute mixed_case=false');
370: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');
371: fnd_file.put_line(fnd_file.log,'OKC_BLEXER preference has been created as BASIC_LEXER');
372:

Line 370: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');

366: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');
367: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute base_letter=true');
368: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');
369: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute mixed_case=false');
370: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');
371: fnd_file.put_line(fnd_file.log,'OKC_BLEXER preference has been created as BASIC_LEXER');
372:
373: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 18);
374:

Line 377: ad_ctx_ddl.drop_preference('okc_clexer');

373: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 18);
374:
375: -- Chinese lexer
376: begin
377: ad_ctx_ddl.drop_preference('okc_clexer');
378: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_CLEXER preference');
379: exception when others then
380: fnd_file.put_line(fnd_file.log,'Creating new OKC_CLEXER preference');
381: end;

Line 395: ad_ctx_ddl.create_preference('okc_clexer','chinese_lexer');

391: exception when others then
392: yes_no := 'N';
393: end;
394: if yes_no = 'Y' then
395: ad_ctx_ddl.create_preference('okc_clexer','chinese_lexer');
396: fnd_file.put_line(fnd_file.log,'OKC_CLEXER preference has been created as CHINESE_LEXER');
397: else
398: ad_ctx_ddl.create_preference('okc_clexer','chinese_vgram_lexer');
399: fnd_file.put_line(fnd_file.log,'OKC_CLEXER preference has been created as CHINESE_VGRAM_LEXER');

Line 398: ad_ctx_ddl.create_preference('okc_clexer','chinese_vgram_lexer');

394: if yes_no = 'Y' then
395: ad_ctx_ddl.create_preference('okc_clexer','chinese_lexer');
396: fnd_file.put_line(fnd_file.log,'OKC_CLEXER preference has been created as CHINESE_LEXER');
397: else
398: ad_ctx_ddl.create_preference('okc_clexer','chinese_vgram_lexer');
399: fnd_file.put_line(fnd_file.log,'OKC_CLEXER preference has been created as CHINESE_VGRAM_LEXER');
400: end if;
401:
402: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 7, 18);

Line 408: ad_ctx_ddl.drop_preference('okc_jlexer');

404: end;
405:
406: -- Japanese lexer
407: begin
408: ad_ctx_ddl.drop_preference('okc_jlexer');
409: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_JLEXER preference');
410: exception
411: when others then
412: fnd_file.put_line(fnd_file.log,'Creating new OKC_JLEXER preference');

Line 428: ad_ctx_ddl.create_preference('okc_jlexer','japanese_lexer');

424: when others then
425: yes_no := 'N';
426: end;
427: if yes_no = 'Y' then
428: ad_ctx_ddl.create_preference('okc_jlexer','japanese_lexer');
429: fnd_file.put_line(fnd_file.log,'OKC_JLEXER preference has been created as JAPANESE_LEXER');
430: else
431: ad_ctx_ddl.create_preference('okc_jlexer','japanese_vgram_lexer');
432: fnd_file.put_line(fnd_file.log,'OKC_JLEXER preference has been created as JAPANESE_VGRAM_LEXER');

Line 431: ad_ctx_ddl.create_preference('okc_jlexer','japanese_vgram_lexer');

427: if yes_no = 'Y' then
428: ad_ctx_ddl.create_preference('okc_jlexer','japanese_lexer');
429: fnd_file.put_line(fnd_file.log,'OKC_JLEXER preference has been created as JAPANESE_LEXER');
430: else
431: ad_ctx_ddl.create_preference('okc_jlexer','japanese_vgram_lexer');
432: fnd_file.put_line(fnd_file.log,'OKC_JLEXER preference has been created as JAPANESE_VGRAM_LEXER');
433: end if;
434:
435: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 8, 18);

Line 441: ad_ctx_ddl.drop_preference('okc_klexer');

437: end;
438:
439: -- Korean lexer
440: begin
441: ad_ctx_ddl.drop_preference('okc_klexer');
442: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_KLEXER preference');
443: exception when others then
444: fnd_file.put_line(fnd_file.log,'Creating new OKC_KLEXER preference');
445: end;

Line 459: ad_ctx_ddl.create_preference('okc_klexer', 'korean_morph_lexer');

455: exception when others then
456: yes_no := 'N';
457: end;
458: if yes_no = 'Y' then
459: ad_ctx_ddl.create_preference('okc_klexer', 'korean_morph_lexer');
460: fnd_file.put_line(fnd_file.log,'OKC_KLEXER preference has been created as KOREAN_MORPH_LEXER');
461: else
462: ad_ctx_ddl.create_preference('okc_klexer', 'korean_lexer');
463: fnd_file.put_line(fnd_file.log,'OKC_KLEXER preference has been created as KOREAN_LEXER');

Line 462: ad_ctx_ddl.create_preference('okc_klexer', 'korean_lexer');

458: if yes_no = 'Y' then
459: ad_ctx_ddl.create_preference('okc_klexer', 'korean_morph_lexer');
460: fnd_file.put_line(fnd_file.log,'OKC_KLEXER preference has been created as KOREAN_MORPH_LEXER');
461: else
462: ad_ctx_ddl.create_preference('okc_klexer', 'korean_lexer');
463: fnd_file.put_line(fnd_file.log,'OKC_KLEXER preference has been created as KOREAN_LEXER');
464: end if;
465: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute one_char_word=true');
466: ad_ctx_ddl.set_attribute('okc_klexer', 'one_char_word', 'true');

Line 466: ad_ctx_ddl.set_attribute('okc_klexer', 'one_char_word', 'true');

462: ad_ctx_ddl.create_preference('okc_klexer', 'korean_lexer');
463: fnd_file.put_line(fnd_file.log,'OKC_KLEXER preference has been created as KOREAN_LEXER');
464: end if;
465: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute one_char_word=true');
466: ad_ctx_ddl.set_attribute('okc_klexer', 'one_char_word', 'true');
467: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute number=true');
468: ad_ctx_ddl.set_attribute('okc_klexer', 'number', 'true');
469:
470: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 18);

Line 468: ad_ctx_ddl.set_attribute('okc_klexer', 'number', 'true');

464: end if;
465: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute one_char_word=true');
466: ad_ctx_ddl.set_attribute('okc_klexer', 'one_char_word', 'true');
467: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute number=true');
468: ad_ctx_ddl.set_attribute('okc_klexer', 'number', 'true');
469:
470: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 18);
471:
472: end;

Line 476: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','default','okc_blexer');

472: end;
473:
474: -- sublexers
475: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer default=okc_blexer');
476: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','default','okc_blexer');
477: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ja=okc_jlexer');
478: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');
479: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ko=okc_klexer');
480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');

Line 478: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');

474: -- sublexers
475: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer default=okc_blexer');
476: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','default','okc_blexer');
477: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ja=okc_jlexer');
478: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');
479: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ko=okc_klexer');
480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');
481: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zhs=okc_clexer');
482: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zhs','okc_clexer');

Line 480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');

476: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','default','okc_blexer');
477: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ja=okc_jlexer');
478: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');
479: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ko=okc_klexer');
480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');
481: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zhs=okc_clexer');
482: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zhs','okc_clexer');
483: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zht=okc_clexer');
484: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zht','okc_clexer');

Line 482: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zhs','okc_clexer');

478: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');
479: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ko=okc_klexer');
480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');
481: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zhs=okc_clexer');
482: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zhs','okc_clexer');
483: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zht=okc_clexer');
484: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zht','okc_clexer');
485: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER preference has been created as MULTI_LEXER');
486:

Line 484: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zht','okc_clexer');

480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');
481: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zhs=okc_clexer');
482: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zhs','okc_clexer');
483: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zht=okc_clexer');
484: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zht','okc_clexer');
485: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER preference has been created as MULTI_LEXER');
486:
487: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 10, 18);
488:

Line 497: ad_ctx_ddl.create_stoplist ('okc_articles_stoplist', 'multi_stoplist');

493: -- -------------------------------------------------------------------
494: begin
495: -- STOPLIST
496: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_STOPLIST preference creation ...');
497: ad_ctx_ddl.create_stoplist ('okc_articles_stoplist', 'multi_stoplist');
498: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_STOPLIST preference has been created as MULTI_STOPLIST');
499: exception when others then
500: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_STOPLIST preference already exists');
501: end;

Line 512: ad_ctx_ddl.drop_preference('okc_articles_wordlist');

508: begin
509: -- WORDLIST
510: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference creation ...');
511: begin
512: ad_ctx_ddl.drop_preference('okc_articles_wordlist');
513: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_WORDLIST preference');
514: exception when others then
515: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_WORDLIST preference');
516: end;

Line 517: ad_ctx_ddl.create_preference('okc_articles_wordlist','basic_wordlist');

513: fnd_file.put_line(fnd_file.log,'Re-creating old OKC_ARTICLES_WORDLIST preference');
514: exception when others then
515: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_WORDLIST preference');
516: end;
517: ad_ctx_ddl.create_preference('okc_articles_wordlist','basic_wordlist');
518: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute stemmer=auto');
519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');

Line 519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');

515: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_WORDLIST preference');
516: end;
517: ad_ctx_ddl.create_preference('okc_articles_wordlist','basic_wordlist');
518: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute stemmer=auto');
519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
522: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');

Line 521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');

517: ad_ctx_ddl.create_preference('okc_articles_wordlist','basic_wordlist');
518: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute stemmer=auto');
519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
522: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
524: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);

Line 523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');

519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
522: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
524: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);

Line 525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);

521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
522: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
524: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);
528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);
529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);

Line 527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);

523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
524: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);
528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);
529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);
530: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');
531: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference has been created as BASIC_WORDLIST');

Line 528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);

524: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);
528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);
529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);
530: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');
531: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference has been created as BASIC_WORDLIST');
532:

Line 529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);

525: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);
528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);
529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);
530: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');
531: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference has been created as BASIC_WORDLIST');
532:
533: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 18);

Line 530: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');

526: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
527: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);
528: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_score',60);
529: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);
530: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');
531: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference has been created as BASIC_WORDLIST');
532:
533: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 18);
534: