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.EGO_ITEM_TEXT_PVT dependencies on CTX_DDL

Line 205: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);

201: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
202: FROM ctxsys.ctx_preferences
203: WHERE pre_name = l_pref_name )
204: LOOP
205: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
206: END LOOP;
207:
208: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
209: FROM ctxsys.ctx_preferences

Line 212: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);

208: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
209: FROM ctxsys.ctx_preferences
210: WHERE pre_name LIKE 'EGO_ITEM_LEXER%' )
211: LOOP
212: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
213: END LOOP;
214:
215: l_pref_name := 'EGO_ITEM_WORDLIST';
216: FOR wordlist_rec IN ( SELECT pre_owner, pre_name

Line 220: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);

216: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
217: FROM ctxsys.ctx_preferences
218: WHERE pre_name = l_pref_name )
219: LOOP
220: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
221: END LOOP;
222:
223: FOR stoplist_rec IN ( SELECT spl_owner, spl_name
224: FROM ctxsys.ctx_stoplists

Line 227: ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.EGO_ITEM_STOPLIST');

223: FOR stoplist_rec IN ( SELECT spl_owner, spl_name
224: FROM ctxsys.ctx_stoplists
225: WHERE spl_name = 'EGO_ITEM_STOPLIST' )
226: LOOP
227: ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.EGO_ITEM_STOPLIST');
228: END LOOP;
229:
230: FOR section_group_rec IN ( SELECT sgp_owner, sgp_name
231: FROM ctxsys.ctx_section_groups

Line 234: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);

230: FOR section_group_rec IN ( SELECT sgp_owner, sgp_name
231: FROM ctxsys.ctx_section_groups
232: WHERE sgp_name = 'EGO_ITEM_SECTION_GROUP' )
233: LOOP
234: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);
235: END LOOP;
236:
237: l_pref_name := 'EGO_ITEM_DATASTORE';
238: FOR datastore_rec IN ( SELECT pre_owner, pre_name

Line 242: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);

238: FOR datastore_rec IN ( SELECT pre_owner, pre_name
239: FROM ctxsys.ctx_preferences
240: WHERE pre_name = l_pref_name )
241: LOOP
242: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
243: END LOOP;
244:
245: l_pref_name := 'EGO_ITEM_STORAGE';
246: FOR storage_rec IN ( SELECT pre_owner, pre_name

Line 250: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);

246: FOR storage_rec IN ( SELECT pre_owner, pre_name
247: FROM ctxsys.ctx_preferences
248: WHERE pre_name = l_pref_name )
249: LOOP
250: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
251: END LOOP;
252:
253: ------------------------------
254: -- Create STORAGE preference

Line 278: ad_ctx_ddl.create_preference (g_Pref_Owner || '.EGO_ITEM_STORAGE', 'BASIC_STORAGE');

274: AND table_name = 'EGO_ITEM_TEXT_TL';
275:
276: Log_Line (l_api_name || ': creating STORAGE preference ...');
277:
278: ad_ctx_ddl.create_preference (g_Pref_Owner || '.EGO_ITEM_STORAGE', 'BASIC_STORAGE');
279:
280: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
281: 'I_TABLE_CLAUSE', tspace_tbl_param);
282:

Line 280: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

276: Log_Line (l_api_name || ': creating STORAGE preference ...');
277:
278: ad_ctx_ddl.create_preference (g_Pref_Owner || '.EGO_ITEM_STORAGE', 'BASIC_STORAGE');
279:
280: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
281: 'I_TABLE_CLAUSE', tspace_tbl_param);
282:
283: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
284: 'K_TABLE_CLAUSE', tspace_tbl_param);

Line 283: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

279:
280: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
281: 'I_TABLE_CLAUSE', tspace_tbl_param);
282:
283: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
284: 'K_TABLE_CLAUSE', tspace_tbl_param);
285:
286: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
287: 'R_TABLE_CLAUSE', tspace_tbl_param || ' LOB (data) STORE AS (CACHE)');

Line 286: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

282:
283: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
284: 'K_TABLE_CLAUSE', tspace_tbl_param);
285:
286: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
287: 'R_TABLE_CLAUSE', tspace_tbl_param || ' LOB (data) STORE AS (CACHE)');
288:
289: -- Caching the "data" LOB column is the default (at later versions of Oracle Text).
290: -- For index specific STORAGE preference, setting the clause "lob (data) (cache reads)"

Line 294: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

290: -- For index specific STORAGE preference, setting the clause "lob (data) (cache reads)"
291: -- should be ensured (the "lob .. store as" clause is only for newly added LOB columns).
292: --alter table dr$prd_ctx_index$r modify lob (data) (cache reads);
293:
294: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
295: 'N_TABLE_CLAUSE', tspace_tbl_param);
296:
297: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
298: 'P_TABLE_CLAUSE', tspace_tbl_param);

Line 297: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

293:
294: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
295: 'N_TABLE_CLAUSE', tspace_tbl_param);
296:
297: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
298: 'P_TABLE_CLAUSE', tspace_tbl_param);
299:
300: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
301: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');

Line 300: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

296:
297: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
298: 'P_TABLE_CLAUSE', tspace_tbl_param);
299:
300: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
301: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');
302:
303: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
304: -- 'I_ROWID_INDEX_CLAUSE', tspace_idx_param);

Line 303: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',

299:
300: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
301: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');
302:
303: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EGO_ITEM_STORAGE',
304: -- 'I_ROWID_INDEX_CLAUSE', tspace_idx_param);
305:
306: --------------------------------
307: -- Create DATASTORE preference

Line 312: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'USER_DATASTORE');

308: --------------------------------
309:
310: Log_Line (l_api_name || ': creating DATASTORE preference ...');
311:
312: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'USER_DATASTORE');
313:
314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');
316:

Line 314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');

310: Log_Line (l_api_name || ': creating DATASTORE preference ...');
311:
312: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'USER_DATASTORE');
313:
314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');
316:
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_VARCHAR2"');

Line 315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');

311:
312: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'USER_DATASTORE');
313:
314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');
316:
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_VARCHAR2"');
319:

Line 317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');

313:
314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');
316:
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_VARCHAR2"');
319:
320: ------------------------------------
321: -- Create SECTION GROUP preference

Line 318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_VARCHAR2"');

314: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
315: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_CLOB"');
316:
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_DATASTORE', 'PROCEDURE', '"EGO_ITEM_TEXT_CTX_PKG"."Get_Item_Text_VARCHAR2"');
319:
320: ------------------------------------
321: -- Create SECTION GROUP preference
322: ------------------------------------

Line 326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');

322: ------------------------------------
323:
324: Log_Line (l_api_name || ': creating SECTION_GROUP preference ...');
325:
326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');
327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');

Line 327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');

323:
324: Log_Line (l_api_name || ': creating SECTION_GROUP preference ...');
325:
326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');
327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');

Line 328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');

324: Log_Line (l_api_name || ': creating SECTION_GROUP preference ...');
325:
326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');
327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');

Line 329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');

325:
326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');
327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');

Line 330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');

326: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'BASIC_SECTION_GROUP');
327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');

Line 331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');

327: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ITEM_SECTION', 'item');
328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin

Line 332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');

328: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_DESC_SECTION', 'desc');
329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin
336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');

Line 333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');

329: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_SHORTDESC_SECTION', 'shortdesc');
330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin
336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');
337: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LANG_SECTION', 'lang');

Line 334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');

330: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LONGDESC_SECTION', 'longdesc');
331: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_CAT_SECTION', 'cat');
332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin
336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');
337: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LANG_SECTION', 'lang');
338: --Bug 5094325 end

Line 336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');

332: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_AML_SECTION', 'aml');
333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin
336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');
337: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LANG_SECTION', 'lang');
338: --Bug 5094325 end
339:
340: -------------------------------

Line 337: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LANG_SECTION', 'lang');

333: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MFG_SECTION', 'mfg');
334: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_MPN_SECTION', 'mpn');
335: --Bug 5094325 begin
336: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_ORG_SECTION', 'org');
337: ad_ctx_ddl.Add_Zone_Section (g_Pref_Owner || '.EGO_ITEM_SECTION_GROUP', 'EGO_ITEM_LANG_SECTION', 'lang');
338: --Bug 5094325 end
339:
340: -------------------------------
341: -- Create STOPLIST preference

Line 348: --ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.EGO_ITEM_STOPLIST');

344: --We are sticking with the default stoplist, containing several common English words and abbreviations
345: --Log_Line (l_api_name || ': creating STOPLIST preference ...');
346:
347: -- This should create stoplist equivalent to CTXSYS.EMPTY_STOPLIST
348: --ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.EGO_ITEM_STOPLIST');
349:
350: -------------------------------
351: -- Create WORDLIST preference
352: -------------------------------

Line 356: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'BASIC_WORDLIST');

352: -------------------------------
353:
354: Log_Line (l_api_name || ': creating WORDLIST preference ...');
355:
356: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'BASIC_WORDLIST');
357:
358: -- Enable prefix indexing to improve performance for wildcard searches
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);

Line 359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');

355:
356: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'BASIC_WORDLIST');
357:
358: -- Enable prefix indexing to improve performance for wildcard searches
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);

Line 360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);

356: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'BASIC_WORDLIST');
357:
358: -- Enable prefix indexing to improve performance for wildcard searches
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);

Line 361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);

357:
358: -- Enable prefix indexing to improve performance for wildcard searches
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
365:

Line 362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);

358: -- Enable prefix indexing to improve performance for wildcard searches
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
365:
366: -- This option should be TRUE only when left-truncated wildcard searching is expected

Line 363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);

359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_INDEX', 'TRUE');
360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
365:
366: -- This option should be TRUE only when left-truncated wildcard searching is expected
367: -- to be frequent and needs to be fast (at the cost of increased index time and space).

Line 364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);

360: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
361: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
362: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
363: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
365:
366: -- This option should be TRUE only when left-truncated wildcard searching is expected
367: -- to be frequent and needs to be fast (at the cost of increased index time and space).
368: --

Line 369: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');

365:
366: -- This option should be TRUE only when left-truncated wildcard searching is expected
367: -- to be frequent and needs to be fast (at the cost of increased index time and space).
368: --
369: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');
370:
371: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
372: -- Use automatic language detection for stemming and fuzzy matching
373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');

Line 373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');

369: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');
370:
371: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
372: -- Use automatic language detection for stemming and fuzzy matching
373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');
374: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_MATCH', 'AUTO');
375: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_SCORE', 40);
376: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_NUMRESULTS', 120);
377:

Line 374: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_MATCH', 'AUTO');

370:
371: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
372: -- Use automatic language detection for stemming and fuzzy matching
373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');
374: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_MATCH', 'AUTO');
375: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_SCORE', 40);
376: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_NUMRESULTS', 120);
377:
378: -----------------------------------------------

Line 375: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_SCORE', 40);

371: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
372: -- Use automatic language detection for stemming and fuzzy matching
373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');
374: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_MATCH', 'AUTO');
375: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_SCORE', 40);
376: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_NUMRESULTS', 120);
377:
378: -----------------------------------------------
379: -- Create language-specific LEXER preferences

Line 376: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_NUMRESULTS', 120);

372: -- Use automatic language detection for stemming and fuzzy matching
373: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'STEMMER', 'AUTO');
374: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_MATCH', 'AUTO');
375: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_SCORE', 40);
376: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EGO_ITEM_WORDLIST', 'FUZZY_NUMRESULTS', 120);
377:
378: -----------------------------------------------
379: -- Create language-specific LEXER preferences
380: -----------------------------------------------

Line 392: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');

388: IF ( Lang_Code_List(i) = 'JA' ) THEN
389:
390: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
391: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
392: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
393: ELSE
394: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
395: END IF;
396:

Line 394: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');

390: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
391: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
392: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
393: ELSE
394: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
395: END IF;
396:
397: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
398:

Line 401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');

397: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
398:
399: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
400: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');

Line 402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');

398:
399: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
400: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

Line 403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');

399: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
400: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');

Line 404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

400: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');

Line 405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');

401: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');

Line 406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

402: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');

Line 407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');

403: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');

Line 408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');

404: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE

Line 409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');

405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');

Line 410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');

406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');

Line 411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');

407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');

Line 413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');

409: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');

Line 414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');

410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

Line 415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');

411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');

Line 416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');

412: ELSE
413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

Line 417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');

413: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');

Line 418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

414: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');

Line 419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');

415: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
423: END IF;

Line 420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

416: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
423: END IF;
424:

Line 421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');

417: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
423: END IF;
424:
425: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN

Line 422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');

418: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
419: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
420: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
421: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
422: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
423: END IF;
424:
425: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
426:

Line 428: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');

424:
425: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
426:
427: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
428: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
429: ELSE
430: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
431: END IF;
432:

Line 430: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');

426:
427: IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
428: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
429: ELSE
430: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
431: END IF;
432:
433: ELSE
434: -- All other languages use basic lexer.

Line 436: ad_ctx_ddl.Create_Preference (Lexer_Name, 'BASIC_LEXER');

432:
433: ELSE
434: -- All other languages use basic lexer.
435:
436: ad_ctx_ddl.Create_Preference (Lexer_Name, 'BASIC_LEXER');
437:
438: -- The following language-independent attributes are
439: -- common to the BASIC_LEXER preference object.
440:

Line 441: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');

437:
438: -- The following language-independent attributes are
439: -- common to the BASIC_LEXER preference object.
440:
441: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
442: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
443:
444: -- For printjoin characters include all possible flex segment separators
445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');

Line 442: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');

438: -- The following language-independent attributes are
439: -- common to the BASIC_LEXER preference object.
440:
441: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
442: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
443:
444: -- For printjoin characters include all possible flex segment separators
445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
446: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');

Line 445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');

441: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
442: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
443:
444: -- For printjoin characters include all possible flex segment separators
445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
446: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
447: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
448:
449: -- The default values for numjoin and numgroup are determined by

Line 446: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');

442: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
443:
444: -- For printjoin characters include all possible flex segment separators
445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
446: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
447: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
448:
449: -- The default values for numjoin and numgroup are determined by
450: -- the NLS initialization parameters that are specified for the database.

Line 447: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');

443:
444: -- For printjoin characters include all possible flex segment separators
445: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
446: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
447: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
448:
449: -- The default values for numjoin and numgroup are determined by
450: -- the NLS initialization parameters that are specified for the database.
451: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');

Line 451: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');

447: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
448:
449: -- The default values for numjoin and numgroup are determined by
450: -- the NLS initialization parameters that are specified for the database.
451: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');
452: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');
453:
454: -- Stem indexing stems tokens at indexing time to a single base form in addition
455: -- to the normal forms. This enables better query performance for stem ($) queries.

Line 452: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');

448:
449: -- The default values for numjoin and numgroup are determined by
450: -- the NLS initialization parameters that are specified for the database.
451: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');
452: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');
453:
454: -- Stem indexing stems tokens at indexing time to a single base form in addition
455: -- to the normal forms. This enables better query performance for stem ($) queries.
456:

Line 462: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');

458: -- This would not affect stem expansion (with $) at query time.
459: --
460: --IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
461: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
462: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
463: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
464: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
465: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');

Line 464: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');

460: --IF ( EGO_ITEM_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
461: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
462: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
463: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
464: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
465: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
467: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');

Line 466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');

462: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
463: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
464: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
465: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
467: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
469: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
470: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');

Line 468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');

464: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
465: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
467: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
469: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
470: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
471: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
472: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');

Line 470: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');

466: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
467: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
469: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
470: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
471: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
472: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');
473: -- END IF;
474: --END IF;

Line 472: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');

468: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
469: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
470: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
471: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
472: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');
473: -- END IF;
474: --END IF;
475:
476: -- Language-specific attribute values for BASIC_LEXER preference object

Line 479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');

475:
476: -- Language-specific attribute values for BASIC_LEXER preference object
477:
478: IF ( Lang_Code_List(i) = 'NL' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');
480:
481: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
483: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.

Line 482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');

478: IF ( Lang_Code_List(i) = 'NL' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');
480:
481: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
483: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
484: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
485: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
486:

Line 484: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');

480:
481: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
483: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
484: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
485: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
486:
487: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
488: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

Line 485: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');

481: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
483: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
484: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
485: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
486:
487: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
488: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
489:

Line 488: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

484: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
485: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
486:
487: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
488: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
489:
490: ELSIF ( Lang_Code_List(i) = 'S' ) THEN
491: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');
492:

Line 491: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');

487: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
488: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
489:
490: ELSIF ( Lang_Code_List(i) = 'S' ) THEN
491: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');
492:
493: ELSIF ( Lang_Code_List(i) = 'N' ) THEN
494: -- Both Norwegian and Danish use the same special characters that are
495: -- rendered alternatively as "aa", "ae", and "oe".

Line 496: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

492:
493: ELSIF ( Lang_Code_List(i) = 'N' ) THEN
494: -- Both Norwegian and Danish use the same special characters that are
495: -- rendered alternatively as "aa", "ae", and "oe".
496: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
497:
498: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
499: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
500:

Line 499: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');

495: -- rendered alternatively as "aa", "ae", and "oe".
496: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
497:
498: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
499: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
500:
501: ELSE
502: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');
503:

Line 502: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');

498: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
499: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
500:
501: ELSE
502: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');
503:
504: END IF;
505: END IF;
506:

Line 515: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER', 'MULTI_LEXER');

511: ----------------------------------
512:
513: Log_Line (l_api_name || ': creating MULTI_LEXER preference ...');
514:
515: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER', 'MULTI_LEXER');
516:
517: FOR i IN Lang_Code_List.FIRST .. Lang_Code_List.LAST
518: LOOP
519: Lexer_Name := g_Pref_Owner || '.EGO_ITEM_LEXER_' || Lang_Code_List(i);

Line 528: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER', 'DEFAULT'

524: -- when adding the sub lexers:
525:
526: IF ( Lang_Code_List(i) = 'US' ) THEN
527: -- US English lexer to handle everything else.
528: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER', 'DEFAULT'
529: , g_Pref_Owner || '.EGO_ITEM_LEXER_US' );
530: ELSE
531: ad_ctx_ddl.Add_Sub_Lexer
532: ( lexer_name => g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER'

Line 531: ad_ctx_ddl.Add_Sub_Lexer

527: -- US English lexer to handle everything else.
528: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER', 'DEFAULT'
529: , g_Pref_Owner || '.EGO_ITEM_LEXER_US' );
530: ELSE
531: ad_ctx_ddl.Add_Sub_Lexer
532: ( lexer_name => g_Pref_Owner || '.EGO_ITEM_MULTI_LEXER'
533: , language => Lang_Code_List(i)
534: , sub_lexer => Lexer_Name
535: --, alt_value => Lang_ISO_List(i)

Line 699: ctx_ddl.Drop_Policy(g_Index_Owner || '.' || p_Policy_Name);

695: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
696: -- Drop the policy too, if it exists
697: IF (p_Policy_Name IS NOT NULL) THEN
698: BEGIN
699: ctx_ddl.Drop_Policy(g_Index_Owner || '.' || p_Policy_Name);
700: EXCEPTION
701: WHEN OTHERS THEN
702: Log_Line (l_api_name || ': policy does not exist; cannot be dropped.');
703: END;

Line 875: ctx_ddl.Copy_Policy(g_Index_Owner || '.' || p_Index_Name, g_Index_Owner || '.' || p_Policy_Name);

871: -- Copy the policy too, if it doesn't already exist
872: IF (p_Policy_Name IS NOT NULL) THEN
873: BEGIN
874: Log_Line (l_api_name || ': Copying policy from index...');
875: ctx_ddl.Copy_Policy(g_Index_Owner || '.' || p_Index_Name, g_Index_Owner || '.' || p_Policy_Name);
876: EXCEPTION
877: WHEN OTHERS THEN
878: Log_Line (l_api_name || ': policy could not be copied - probably already exists.');
879: END;