76: -- We need this in a separate block since if these don't exist
77: -- they will throw exception and we are ok with this
78: l_err_loc := 400;
79: BEGIN
80: ctx_ddl.drop_preference(l_ctx_pref_datastore);
81: l_err_loc := 410;
82: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
83: l_err_loc := 420;
84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
78: l_err_loc := 400;
79: BEGIN
80: ctx_ddl.drop_preference(l_ctx_pref_datastore);
81: l_err_loc := 410;
82: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
83: l_err_loc := 420;
84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
85: l_err_loc := 430;
86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
80: ctx_ddl.drop_preference(l_ctx_pref_datastore);
81: l_err_loc := 410;
82: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
83: l_err_loc := 420;
84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
85: l_err_loc := 430;
86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
87: l_err_loc := 440;
88: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
82: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
83: l_err_loc := 420;
84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
85: l_err_loc := 430;
86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
87: l_err_loc := 440;
88: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
89: l_err_loc := 450;
90: ctx_ddl.drop_section_group(l_ctx_section_group);
84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
85: l_err_loc := 430;
86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
87: l_err_loc := 440;
88: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
89: l_err_loc := 450;
90: ctx_ddl.drop_section_group(l_ctx_section_group);
91: l_err_loc := 460;
92: EXCEPTION
86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
87: l_err_loc := 440;
88: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
89: l_err_loc := 450;
90: ctx_ddl.drop_section_group(l_ctx_section_group);
91: l_err_loc := 460;
92: EXCEPTION
93: WHEN OTHERS THEN
94: null;
97: -- now we will go ahead and create the preferences
98: l_err_loc := 500;
99:
100: -- create the detail datastore preferences
101: ctx_ddl.create_preference(l_ctx_pref_datastore, 'DETAIL_DATASTORE');
102:
103: -- Set the attributes specific to DETAIL_DATASTORE.
104: l_err_loc := 510;
105: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'binary', 'false');
101: ctx_ddl.create_preference(l_ctx_pref_datastore, 'DETAIL_DATASTORE');
102:
103: -- Set the attributes specific to DETAIL_DATASTORE.
104: l_err_loc := 510;
105: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'binary', 'false');
106: l_err_loc := 520;
107: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_table',
108: l_icx_schema_name || '.ICX_CAT_ITEMS_CTX_DTLS_TLP');
109: l_err_loc := 530;
103: -- Set the attributes specific to DETAIL_DATASTORE.
104: l_err_loc := 510;
105: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'binary', 'false');
106: l_err_loc := 520;
107: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_table',
108: l_icx_schema_name || '.ICX_CAT_ITEMS_CTX_DTLS_TLP');
109: l_err_loc := 530;
110: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_key',
111: 'po_line_id, inventory_item_id, req_template_name, req_template_line_num, org_id, language');
106: l_err_loc := 520;
107: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_table',
108: l_icx_schema_name || '.ICX_CAT_ITEMS_CTX_DTLS_TLP');
109: l_err_loc := 530;
110: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_key',
111: 'po_line_id, inventory_item_id, req_template_name, req_template_line_num, org_id, language');
112: l_err_loc := 540;
113: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_lineno', 'sequence');
114: l_err_loc := 550;
109: l_err_loc := 530;
110: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_key',
111: 'po_line_id, inventory_item_id, req_template_name, req_template_line_num, org_id, language');
112: l_err_loc := 540;
113: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_lineno', 'sequence');
114: l_err_loc := 550;
115: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_text', 'CTX_DESC');
116:
117: -- create the other preferences
111: 'po_line_id, inventory_item_id, req_template_name, req_template_line_num, org_id, language');
112: l_err_loc := 540;
113: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_lineno', 'sequence');
114: l_err_loc := 550;
115: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_text', 'CTX_DESC');
116:
117: -- create the other preferences
118: l_err_loc := 600;
119: ctx_ddl.create_preference('ICX_CAT_FILTER_HDRS', 'NULL_FILTER');
115: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_text', 'CTX_DESC');
116:
117: -- create the other preferences
118: l_err_loc := 600;
119: ctx_ddl.create_preference('ICX_CAT_FILTER_HDRS', 'NULL_FILTER');
120:
121: l_err_loc := 610;
122: ctx_ddl.create_preference('ICX_CAT_WORDLIST_HDRS', 'BASIC_WORDLIST');
123: l_err_loc := 620;
118: l_err_loc := 600;
119: ctx_ddl.create_preference('ICX_CAT_FILTER_HDRS', 'NULL_FILTER');
120:
121: l_err_loc := 610;
122: ctx_ddl.create_preference('ICX_CAT_WORDLIST_HDRS', 'BASIC_WORDLIST');
123: l_err_loc := 620;
124: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'STEMMER', 'AUTO');
125: l_err_loc := 630;
126: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'FUZZY_MATCH', 'AUTO');
120:
121: l_err_loc := 610;
122: ctx_ddl.create_preference('ICX_CAT_WORDLIST_HDRS', 'BASIC_WORDLIST');
123: l_err_loc := 620;
124: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'STEMMER', 'AUTO');
125: l_err_loc := 630;
126: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'FUZZY_MATCH', 'AUTO');
127:
128: l_err_loc := 700;
122: ctx_ddl.create_preference('ICX_CAT_WORDLIST_HDRS', 'BASIC_WORDLIST');
123: l_err_loc := 620;
124: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'STEMMER', 'AUTO');
125: l_err_loc := 630;
126: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'FUZZY_MATCH', 'AUTO');
127:
128: l_err_loc := 700;
129: ctx_ddl.create_preference('ICX_CAT_STORAGE_HDRS', 'BASIC_STORAGE');
130:
125: l_err_loc := 630;
126: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'FUZZY_MATCH', 'AUTO');
127:
128: l_err_loc := 700;
129: ctx_ddl.create_preference('ICX_CAT_STORAGE_HDRS', 'BASIC_STORAGE');
130:
131: -- Check if the tablespace exists before using it
132: l_err_loc := 710;
133: IF (l_ts_exists = 'Y') THEN
130:
131: -- Check if the tablespace exists before using it
132: l_err_loc := 710;
133: IF (l_ts_exists = 'Y') THEN
134: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_TABLE_CLAUSE',
135: 'tablespace '||l_ctx_data_tbsp);
136: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','K_TABLE_CLAUSE',
137: 'tablespace '||l_ctx_data_tbsp);
138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_TABLE_CLAUSE',
132: l_err_loc := 710;
133: IF (l_ts_exists = 'Y') THEN
134: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_TABLE_CLAUSE',
135: 'tablespace '||l_ctx_data_tbsp);
136: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','K_TABLE_CLAUSE',
137: 'tablespace '||l_ctx_data_tbsp);
138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_TABLE_CLAUSE',
139: 'tablespace '||l_ctx_data_tbsp);
140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_TABLE_CLAUSE',
134: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_TABLE_CLAUSE',
135: 'tablespace '||l_ctx_data_tbsp);
136: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','K_TABLE_CLAUSE',
137: 'tablespace '||l_ctx_data_tbsp);
138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_TABLE_CLAUSE',
139: 'tablespace '||l_ctx_data_tbsp);
140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_TABLE_CLAUSE',
141: 'tablespace '||l_ctx_data_tbsp);
142: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','P_TABLE_CLAUSE',
136: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','K_TABLE_CLAUSE',
137: 'tablespace '||l_ctx_data_tbsp);
138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_TABLE_CLAUSE',
139: 'tablespace '||l_ctx_data_tbsp);
140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_TABLE_CLAUSE',
141: 'tablespace '||l_ctx_data_tbsp);
142: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','P_TABLE_CLAUSE',
143: 'tablespace '||l_ctx_data_tbsp);
144: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_INDEX_CLAUSE',
138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_TABLE_CLAUSE',
139: 'tablespace '||l_ctx_data_tbsp);
140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_TABLE_CLAUSE',
141: 'tablespace '||l_ctx_data_tbsp);
142: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','P_TABLE_CLAUSE',
143: 'tablespace '||l_ctx_data_tbsp);
144: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_INDEX_CLAUSE',
145: 'tablespace '||l_ctx_index_tbsp);
146: END IF;
140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_TABLE_CLAUSE',
141: 'tablespace '||l_ctx_data_tbsp);
142: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','P_TABLE_CLAUSE',
143: 'tablespace '||l_ctx_data_tbsp);
144: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_INDEX_CLAUSE',
145: 'tablespace '||l_ctx_index_tbsp);
146: END IF;
147:
148: l_err_loc := 720;
145: 'tablespace '||l_ctx_index_tbsp);
146: END IF;
147:
148: l_err_loc := 720;
149: ctx_ddl.create_section_group(l_ctx_section_group, 'basic_section_group');
150:
151: -- add all the field sections
152: l_err_loc := 730;
153: ctx_ddl.add_field_section(l_ctx_section_group, 'source_type', 'source_type', FALSE);
149: ctx_ddl.create_section_group(l_ctx_section_group, 'basic_section_group');
150:
151: -- add all the field sections
152: l_err_loc := 730;
153: ctx_ddl.add_field_section(l_ctx_section_group, 'source_type', 'source_type', FALSE);
154: l_err_loc := 740;
155: ctx_ddl.add_field_section(l_ctx_section_group, 'supid', 'supid', FALSE);
156: l_err_loc := 750;
157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', FALSE);
151: -- add all the field sections
152: l_err_loc := 730;
153: ctx_ddl.add_field_section(l_ctx_section_group, 'source_type', 'source_type', FALSE);
154: l_err_loc := 740;
155: ctx_ddl.add_field_section(l_ctx_section_group, 'supid', 'supid', FALSE);
156: l_err_loc := 750;
157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', FALSE);
158: l_err_loc := 760;
159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', FALSE);
153: ctx_ddl.add_field_section(l_ctx_section_group, 'source_type', 'source_type', FALSE);
154: l_err_loc := 740;
155: ctx_ddl.add_field_section(l_ctx_section_group, 'supid', 'supid', FALSE);
156: l_err_loc := 750;
157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', FALSE);
158: l_err_loc := 760;
159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', FALSE);
160: l_err_loc := 770;
161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', FALSE);
155: ctx_ddl.add_field_section(l_ctx_section_group, 'supid', 'supid', FALSE);
156: l_err_loc := 750;
157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', FALSE);
158: l_err_loc := 760;
159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', FALSE);
160: l_err_loc := 770;
161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', FALSE);
162: l_err_loc := 780;
163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', FALSE);
157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', FALSE);
158: l_err_loc := 760;
159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', FALSE);
160: l_err_loc := 770;
161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', FALSE);
162: l_err_loc := 780;
163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', FALSE);
164: l_err_loc := 790;
165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', FALSE);
159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', FALSE);
160: l_err_loc := 770;
161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', FALSE);
162: l_err_loc := 780;
163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', FALSE);
164: l_err_loc := 790;
165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', FALSE);
166: l_err_loc := 800;
167: ctx_ddl.add_field_section(l_ctx_section_group, 'language', 'language', FALSE);
161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', FALSE);
162: l_err_loc := 780;
163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', FALSE);
164: l_err_loc := 790;
165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', FALSE);
166: l_err_loc := 800;
167: ctx_ddl.add_field_section(l_ctx_section_group, 'language', 'language', FALSE);
168: l_err_loc := 810;
169: ctx_ddl.add_field_section(l_ctx_section_group, 'item_type', 'item_type', FALSE);
163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', FALSE);
164: l_err_loc := 790;
165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', FALSE);
166: l_err_loc := 800;
167: ctx_ddl.add_field_section(l_ctx_section_group, 'language', 'language', FALSE);
168: l_err_loc := 810;
169: ctx_ddl.add_field_section(l_ctx_section_group, 'item_type', 'item_type', FALSE);
170:
171: l_err_loc := 900;
165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', FALSE);
166: l_err_loc := 800;
167: ctx_ddl.add_field_section(l_ctx_section_group, 'language', 'language', FALSE);
168: l_err_loc := 810;
169: ctx_ddl.add_field_section(l_ctx_section_group, 'item_type', 'item_type', FALSE);
170:
171: l_err_loc := 900;
172: FOR counter in 1..100
173: LOOP
172: FOR counter in 1..100
173: LOOP
174: l_err_loc := 910;
175: l_ctx_desc_tag := counter;
176: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);
177: END LOOP;
178:
179: FOR counter in 1000..1300
180: LOOP
179: FOR counter in 1000..1300
180: LOOP
181: l_err_loc := 920;
182: l_ctx_desc_tag := counter;
183: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);
184: END LOOP;
185:
186: FOR counter in 5000..5150
187: LOOP
186: FOR counter in 5000..5150
187: LOOP
188: l_err_loc := 930;
189: l_ctx_desc_tag := counter;
190: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);
191: END LOOP;
192:
193: l_err_loc := 940;
194: ctx_ddl.create_preference('ICX_CAT_LEXER_GLOBAL_HDRS', 'MULTI_LEXER');
190: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);
191: END LOOP;
192:
193: l_err_loc := 940;
194: ctx_ddl.create_preference('ICX_CAT_LEXER_GLOBAL_HDRS', 'MULTI_LEXER');
195:
196: -- we now loop through the installed languages and create
197: -- lexers for each of them
198: l_err_loc := 1000;
206: -- drop the existing lexer preference for this langauge
207: -- don't do anything on exception since preference may not exist
208: BEGIN
209: l_err_loc := 1020;
210: ctx_ddl.drop_preference(l_ctx_pref_lexer);
211: l_err_loc := 1030;
212: EXCEPTION
213: WHEN OTHERS THEN
214: null;
218: -- Now create the lexer preferences and set appropriate attributes
219: IF (l_lang IN ('US', 'GB')) THEN
220: -- American English (US), English (GB)
221: l_err_loc := 1110;
222: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
223:
224: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
225: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
220: -- American English (US), English (GB)
221: l_err_loc := 1110;
222: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
223:
224: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
225: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
227: ELSIF (l_lang = 'JA') THEN
228: -- Japanese (JA)
221: l_err_loc := 1110;
222: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
223:
224: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
225: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
227: ELSIF (l_lang = 'JA') THEN
228: -- Japanese (JA)
229: l_err_loc := 1120;
222: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
223:
224: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
225: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
227: ELSIF (l_lang = 'JA') THEN
228: -- Japanese (JA)
229: l_err_loc := 1120;
230: ctx_ddl.create_preference(l_ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
227: ELSIF (l_lang = 'JA') THEN
228: -- Japanese (JA)
229: l_err_loc := 1120;
230: ctx_ddl.create_preference(l_ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
231: ELSIF (l_lang = 'KO') THEN
232: -- Korean (KO)
233: l_err_loc := 1130;
234: ctx_ddl.create_preference(l_ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
230: ctx_ddl.create_preference(l_ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
231: ELSIF (l_lang = 'KO') THEN
232: -- Korean (KO)
233: l_err_loc := 1130;
234: ctx_ddl.create_preference(l_ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
235:
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
232: -- Korean (KO)
233: l_err_loc := 1130;
234: ctx_ddl.create_preference(l_ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
235:
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
233: l_err_loc := 1130;
234: ctx_ddl.create_preference(l_ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
235:
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
234: ctx_ddl.create_preference(l_ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
235:
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
235:
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', 'TRUE');
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
248: ELSIF (l_lang IN ('ZHS', 'ZHT')) THEN
241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
248: ELSIF (l_lang IN ('ZHS', 'ZHT')) THEN
249: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', 'TRUE');
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
248: ELSIF (l_lang IN ('ZHS', 'ZHT')) THEN
249: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
250: l_err_loc := 1140;
243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', 'TRUE');
244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');
245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
248: ELSIF (l_lang IN ('ZHS', 'ZHT')) THEN
249: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
250: l_err_loc := 1140;
251: ctx_ddl.create_preference(l_ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');
248: ELSIF (l_lang IN ('ZHS', 'ZHT')) THEN
249: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
250: l_err_loc := 1140;
251: ctx_ddl.create_preference(l_ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
252: ELSIF (l_lang IN ('F', 'FRC')) THEN
253: -- French (F), Canadian French (FRC)
254: l_err_loc := 1150;
255: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
251: ctx_ddl.create_preference(l_ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
252: ELSIF (l_lang IN ('F', 'FRC')) THEN
253: -- French (F), Canadian French (FRC)
254: l_err_loc := 1150;
255: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
256:
257: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
258: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
253: -- French (F), Canadian French (FRC)
254: l_err_loc := 1150;
255: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
256:
257: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
258: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
260: ELSIF (l_lang = 'D') THEN
261: -- German (D)
254: l_err_loc := 1150;
255: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
256:
257: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
258: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
260: ELSIF (l_lang = 'D') THEN
261: -- German (D)
262: l_err_loc := 1160;
255: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
256:
257: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
258: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
260: ELSIF (l_lang = 'D') THEN
261: -- German (D)
262: l_err_loc := 1160;
263: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
260: ELSIF (l_lang = 'D') THEN
261: -- German (D)
262: l_err_loc := 1160;
263: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
264:
265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
261: -- German (D)
262: l_err_loc := 1160;
263: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
264:
265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
269: ELSIF (l_lang = 'I') THEN
262: l_err_loc := 1160;
263: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
264:
265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
269: ELSIF (l_lang = 'I') THEN
270: -- Italian (I)
263: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
264:
265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
269: ELSIF (l_lang = 'I') THEN
270: -- Italian (I)
271: l_err_loc := 1170;
264:
265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
269: ELSIF (l_lang = 'I') THEN
270: -- Italian (I)
271: l_err_loc := 1170;
272: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
269: ELSIF (l_lang = 'I') THEN
270: -- Italian (I)
271: l_err_loc := 1170;
272: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
273:
274: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
275: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
270: -- Italian (I)
271: l_err_loc := 1170;
272: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
273:
274: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
275: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
277: ELSIF (l_lang in ('E','ESA')) THEN
278: -- Spanish (E), Latin American Spanish (ESA)
271: l_err_loc := 1170;
272: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
273:
274: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
275: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
277: ELSIF (l_lang in ('E','ESA')) THEN
278: -- Spanish (E), Latin American Spanish (ESA)
279: l_err_loc := 1180;
272: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
273:
274: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
275: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
277: ELSIF (l_lang in ('E','ESA')) THEN
278: -- Spanish (E), Latin American Spanish (ESA)
279: l_err_loc := 1180;
280: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
277: ELSIF (l_lang in ('E','ESA')) THEN
278: -- Spanish (E), Latin American Spanish (ESA)
279: l_err_loc := 1180;
280: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
281:
282: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
283: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
278: -- Spanish (E), Latin American Spanish (ESA)
279: l_err_loc := 1180;
280: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
281:
282: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
283: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
285: ELSIF (l_lang = 'NL') THEN
286: -- Dutch (NL)
279: l_err_loc := 1180;
280: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
281:
282: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
283: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
285: ELSIF (l_lang = 'NL') THEN
286: -- Dutch (NL)
287: l_err_loc := 1190;
280: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
281:
282: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
283: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
285: ELSIF (l_lang = 'NL') THEN
286: -- Dutch (NL)
287: l_err_loc := 1190;
288: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
285: ELSIF (l_lang = 'NL') THEN
286: -- Dutch (NL)
287: l_err_loc := 1190;
288: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
289:
290: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
291: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
286: -- Dutch (NL)
287: l_err_loc := 1190;
288: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
289:
290: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
291: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
293: -- 16177309 Starts
294: ELSIF (l_lang = 'SQ' OR l_lang = 'AZ') then
287: l_err_loc := 1190;
288: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
289:
290: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
291: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
293: -- 16177309 Starts
294: ELSIF (l_lang = 'SQ' OR l_lang = 'AZ') then
295: -- AZERBAIJANI(AZ), Albanian (SQ)
288: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
289:
290: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
291: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
293: -- 16177309 Starts
294: ELSIF (l_lang = 'SQ' OR l_lang = 'AZ') then
295: -- AZERBAIJANI(AZ), Albanian (SQ)
296: l_err_loc := 11901;
293: -- 16177309 Starts
294: ELSIF (l_lang = 'SQ' OR l_lang = 'AZ') then
295: -- AZERBAIJANI(AZ), Albanian (SQ)
296: l_err_loc := 11901;
297: ctx_ddl.create_preference(l_ctx_pref_lexer, 'WORLD_LEXER');
298: -- 16177309 Ends
299: ELSE
300: -- All other languages
301: l_err_loc := 1200;
298: -- 16177309 Ends
299: ELSE
300: -- All other languages
301: l_err_loc := 1200;
302: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
303: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
304: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
305: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
306: END IF;
299: ELSE
300: -- All other languages
301: l_err_loc := 1200;
302: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
303: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
304: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
305: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
306: END IF;
307:
300: -- All other languages
301: l_err_loc := 1200;
302: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
303: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
304: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
305: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
306: END IF;
307:
308: -- 16177309 Starts
301: l_err_loc := 1200;
302: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
303: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
304: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
305: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
306: END IF;
307:
308: -- 16177309 Starts
309: if (l_lang <> 'SQ' AND l_lang <> 'AZ') then
309: if (l_lang <> 'SQ' AND l_lang <> 'AZ') then
310: -- AZERBAIJANI(AZ), Albanian (SQ)
311: l_err_loc := 1210;
312: -- add a sub lexer for this language
313: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', l_nls_lang,
314: l_ctx_pref_lexer);
315:
316: l_err_loc := 1220;
317: -- make the base language sub lexer the default
315:
316: l_err_loc := 1220;
317: -- make the base language sub lexer the default
318: IF (language_row.installed_flag = 'B') THEN
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', 'default',
320: l_ctx_pref_lexer);
321: END IF;
322: END IF;
323: END LOOP;
428:
429: -- drop the existing preferences
430: BEGIN
431: l_err_loc := 110;
432: ctx_ddl.drop_preference(l_ctx_pref_datastore);
433: l_err_loc := 120;
434: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
435: l_err_loc := 130;
436: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
430: BEGIN
431: l_err_loc := 110;
432: ctx_ddl.drop_preference(l_ctx_pref_datastore);
433: l_err_loc := 120;
434: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
435: l_err_loc := 130;
436: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
437: l_err_loc := 140;
438: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
432: ctx_ddl.drop_preference(l_ctx_pref_datastore);
433: l_err_loc := 120;
434: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
435: l_err_loc := 130;
436: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
437: l_err_loc := 140;
438: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
439: l_err_loc := 150;
440: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
434: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
435: l_err_loc := 130;
436: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
437: l_err_loc := 140;
438: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
439: l_err_loc := 150;
440: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
441: l_err_loc := 160;
442: ctx_ddl.drop_section_group(l_ctx_section_group);
436: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
437: l_err_loc := 140;
438: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
439: l_err_loc := 150;
440: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
441: l_err_loc := 160;
442: ctx_ddl.drop_section_group(l_ctx_section_group);
443: l_err_loc := 170;
444: EXCEPTION
438: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
439: l_err_loc := 150;
440: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
441: l_err_loc := 160;
442: ctx_ddl.drop_section_group(l_ctx_section_group);
443: l_err_loc := 170;
444: EXCEPTION
445: WHEN OTHERS THEN
446: NULL;
452: l_ctx_pref_lexer := 'ICX_CAT_LEXER_HDRS_' || language_row.language_code;
453:
454: BEGIN
455: l_err_loc := 210;
456: ctx_ddl.drop_preference(l_ctx_pref_lexer);
457: EXCEPTION
458: WHEN OTHERS THEN
459: NULL;
460: END;
491:
492: l_icx_schema_name := ICX_CAT_UTIL_PVT.getIcxSchemaName;
493:
494: l_err_loc := 200;
495: ad_ctx_ddl.sync_index(l_icx_schema_name || '.ICX_CAT_ITEMSCTXDESC_HDRS');
496:
497: l_err_loc := 300;
498:
499: EXCEPTION