DBA Data[Home] [Help]

APPS.ICX_POR_INTERMEDIA_INDEX dependencies on CTX_DDL

Line 97: ctx_ddl.drop_preference(ctx_pref_datastore);

93:
94: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
95: -- drop the existing preferences
96: BEGIN
97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');

Line 99: ctx_ddl.drop_preference('ICX_CAT_FILTER');

95: -- drop the existing preferences
96: BEGIN
97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');

Line 101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');

97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');

Line 103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');

99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);

Line 105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');

101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);
108: xErrLoc := 170;
109: EXCEPTION

Line 107: ctx_ddl.drop_section_group(ctx_section_group);

103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);
108: xErrLoc := 170;
109: EXCEPTION
110: WHEN OTHERS THEN
111: null;

Line 116: ctx_ddl.create_preference(ctx_pref_datastore, 'DETAIL_DATASTORE');

112: END;
113:
114: xErrLoc := 200;
115: -- create preferences
116: ctx_ddl.create_preference(ctx_pref_datastore, 'DETAIL_DATASTORE');
117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;

Line 119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');

115: -- create preferences
116: ctx_ddl.create_preference(ctx_pref_datastore, 'DETAIL_DATASTORE');
117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;

Line 121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',

117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');

Line 124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',

120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;

Line 127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');

123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;

Line 129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');

125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;

Line 132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');

128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');

Line 134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');

130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');

Line 136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');

132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');
139:
140: -- Bug 1802907, zxzhang, May-24-01

Line 138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');

134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');
139:
140: -- Bug 1802907, zxzhang, May-24-01
141: -- Enabled the storage clause to have the index created in
142: -- the INDEX tablespace

Line 144: ctx_ddl.create_preference('ICX_CAT_STORAGE', 'BASIC_STORAGE');

140: -- Bug 1802907, zxzhang, May-24-01
141: -- Enabled the storage clause to have the index created in
142: -- the INDEX tablespace
143: xErrLoc := 270;
144: ctx_ddl.create_preference('ICX_CAT_STORAGE', 'BASIC_STORAGE');
145:
146: -- sosingha bug 3175547 to use AD API for getting the tablespace
147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN

Line 149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',

145:
146: -- sosingha bug 3175547 to use AD API for getting the tablespace
147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN
149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',

Line 151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',

147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN
149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',

Line 153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',

149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',

Line 155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',

151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',

Line 157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',

153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',
160: 'tablespace '||ctx_index_tbsp);
161: END IF;

Line 159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',

155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',
160: 'tablespace '||ctx_index_tbsp);
161: END IF;
162:
163:

Line 165: ctx_ddl.create_section_group(ctx_section_group, 'basic_section_group');

161: END IF;
162:
163:
164: xErrLoc := 280;
165: ctx_ddl.create_section_group(ctx_section_group, 'basic_section_group');
166: xErrLoc := 290;
167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:

Line 167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',

163:
164: xErrLoc := 280;
165: ctx_ddl.create_section_group(ctx_section_group, 'basic_section_group');
166: xErrLoc := 290;
167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',

Line 171: ctx_ddl.add_field_section(ctx_section_group, 'supid',

167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',

Line 173: ctx_ddl.add_field_section(ctx_section_group, 'catid',

169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',

Line 175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',

171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;

Line 177: ctx_ddl.add_field_section(ctx_section_group, 'language',

173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;
180: ctx_ddl.add_zone_section(ctx_section_group, 'catnm',
181: 'catnm' );

Line 180: ctx_ddl.add_zone_section(ctx_section_group, 'catnm',

176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;
180: ctx_ddl.add_zone_section(ctx_section_group, 'catnm',
181: 'catnm' );
182:
183: FOR counter in 1..100
184: LOOP

Line 187: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),

183: FOR counter in 1..100
184: LOOP
185: xErrLoc := 320;
186: ctx_desc_tag := counter;
187: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),
188: ctx_desc_tag);
189: END LOOP;
190:
191: FOR counter in 1000..1300

Line 195: ctx_ddl.add_zone_section(ctx_section_group, to_char(counter),

191: FOR counter in 1000..1300
192: LOOP
193: xErrLoc := 330;
194: ctx_desc_tag := counter;
195: ctx_ddl.add_zone_section(ctx_section_group, to_char(counter),
196: ctx_desc_tag);
197: END LOOP;
198:
199: FOR counter in 5000..5150

Line 204: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),

200: LOOP
201: xErrLoc := 340;
202: -- OEX_IP_PORTING
203: ctx_desc_tag := counter;
204: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),
205: ctx_desc_tag);
206: END LOOP;
207:
208:

Line 211: ctx_ddl.create_preference('ICX_CAT_LEXER_GLOBAL', 'MULTI_LEXER');

207:
208:
209: xErrLoc := 400;
210: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
211: ctx_ddl.create_preference('ICX_CAT_LEXER_GLOBAL', 'MULTI_LEXER');
212:
213: xErrLoc := 420;
214: FOR language_row IN installed_languages_csr LOOP
215: xLang := language_row.language_code;

Line 224: ctx_ddl.drop_preference(ctx_pref_lexer);

220:
221: -- drop the existing preference
222: BEGIN
223: xErrLoc := 450;
224: ctx_ddl.drop_preference(ctx_pref_lexer);
225: xErrLoc := 460;
226: EXCEPTION
227: WHEN OTHERS THEN
228: null;

Line 236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

232: -- create preferences
233: if (xLang IN ('US', 'GB')) then
234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.

Line 237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

233: if (xLang IN ('US', 'GB')) then
234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then

Line 241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then
243: -- Japanese (JA)
244: xErrLoc := 500;
245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');

Line 245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');

241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then
243: -- Japanese (JA)
244: xErrLoc := 500;
245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
246: elsif (xLang = 'KO') then
247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');

Line 249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');

245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
246: elsif (xLang = 'KO') then
247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');

Line 251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');

247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');

Line 252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');

248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');

Line 253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');

249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');

Line 254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');

250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');

Line 255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');

251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');

Line 256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');

252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');

Line 257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');

253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');

Line 258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');

254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');

Line 259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');

255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then

Line 260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');

256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)

Line 261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');

257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;

Line 262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');

258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;
266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');

Line 266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');

262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;
266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then

Line 272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)

Line 274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.

Line 279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');

276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then

Line 281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)

Line 283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then

Line 289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)

Line 291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then

Line 297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)

Line 299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else

Line 305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages

Line 307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

Line 311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');

307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

Line 312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');

308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;

Line 313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');

309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:

Line 315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');

311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:
318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,

Line 319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,

315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:
318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,
320: ctx_pref_lexer);
321: if (language_row.installed_flag = 'B') then
322: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', 'default',
323: ctx_pref_lexer);

Line 322: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', 'default',

318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,
320: ctx_pref_lexer);
321: if (language_row.installed_flag = 'B') then
322: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', 'default',
323: ctx_pref_lexer);
324: end if;
325:
326: END LOOP;

Line 388: ctx_ddl.drop_preference(ctx_pref_datastore);

384: xErrLoc := 100;
385:
386: -- drop the existing preferences
387: BEGIN
388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');

Line 390: ctx_ddl.drop_preference('ICX_CAT_FILTER');

386: -- drop the existing preferences
387: BEGIN
388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');

Line 392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');

388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');

Line 394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');

390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);

Line 396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');

392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);
399: xErrLoc := 170;
400: EXCEPTION

Line 398: ctx_ddl.drop_section_group(ctx_section_group);

394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);
399: xErrLoc := 170;
400: EXCEPTION
401: WHEN OTHERS THEN
402: NULL;

Line 412: ctx_ddl.drop_preference(ctx_pref_lexer);

408: ctx_pref_lexer := 'ICX_CAT_LEXER_' || language_row.language_code;
409:
410: BEGIN
411: xErrLoc := 210;
412: ctx_ddl.drop_preference(ctx_pref_lexer);
413: EXCEPTION
414: WHEN OTHERS THEN
415: NULL;
416: END;

Line 451: ad_ctx_ddl.sync_index(xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_DESC');

447: BEGIN
448: xErrLoc := 100;
449: -- bug 1663129: to avoid deadlock
450: -- bug 1854624: calling ctxsys.ICX_CAT_index_rebuild....
451: ad_ctx_ddl.sync_index(xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_DESC');
452: xErrLoc := 200;
453:
454: EXCEPTION
455: WHEN OTHERS THEN