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 47: ad_ctx_ddl.set_effective_schema('okc');

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

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

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

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

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

Line 55: ad_ctx_ddl.optimize_index (

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

Line 57: optlevel => ad_ctx_ddl.optlevel_full,

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

Line 58: maxtime => ad_ctx_ddl.maxtime_unlimited

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

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

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

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

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

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

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

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

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

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

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

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

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

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

322: ad_ctx_ddl.create_section_group('okc_article_sections', 'BASIC_SECTION_GROUP');
323: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Title');
324: ad_ctx_ddl.add_field_section('okc_article_sections', 'Title', '', true);
325: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Display');
326: ad_ctx_ddl.add_field_section('okc_article_sections', 'Display', '', true);
327: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Description');
328: ad_ctx_ddl.add_field_section('okc_article_sections', 'Description', '', true);
329: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Instruction');
330: ad_ctx_ddl.add_field_section('okc_article_sections', 'Instruction', '', true);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

358: ad_ctx_ddl.create_preference('okc_blexer','basic_lexer');
359: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_themes=false');
360: ad_ctx_ddl.set_attribute('okc_blexer','index_themes','false');
361: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute index_text=true');
362: ad_ctx_ddl.set_attribute('okc_blexer','index_text','true');
363: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute base_letter=true');
364: ad_ctx_ddl.set_attribute('okc_blexer','base_letter','true');
365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute mixed_case=false');
366: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

468: end;
469:
470: -- sublexers
471: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer default=okc_blexer');
472: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','default','okc_blexer');
473: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ja=okc_jlexer');
474: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ja','okc_jlexer');
475: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer ko=okc_klexer');
476: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','ko','okc_klexer');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

513: ad_ctx_ddl.create_preference('okc_articles_wordlist','basic_wordlist');
514: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute stemmer=auto');
515: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
516: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
517: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
518: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);

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

515: ad_ctx_ddl.set_attribute('okc_articles_wordlist','stemmer','auto');
516: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute fuzzy_match=auto');
517: ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_match','auto');
518: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_index=true');
519: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_index','true');
520: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_min_length=3');
521: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_min_length',3);
522: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST: set attribute prefix_max_length=5');
523: ad_ctx_ddl.set_attribute('okc_articles_wordlist','prefix_max_length',5);

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

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

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

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

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

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

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

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

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

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