APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on CTX_DDL

Line 80: ctx_ddl.drop_preference(l_ctx_pref_datastore);

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');

Line 82: ctx_ddl.drop_preference('ICX_CAT_FILTER_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');

Line 84: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_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');

Line 86: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_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);

Line 88: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');

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

Line 90: ctx_ddl.drop_section_group(l_ctx_section_group);

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;

Line 101: ctx_ddl.create_preference(l_ctx_pref_datastore, 'DETAIL_DATASTORE');

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');

Line 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;

Line 107: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_table',

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');

Line 110: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_key',

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;

Line 113: ctx_ddl.set_attribute(l_ctx_pref_datastore, 'detail_lineno', 'sequence');

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

Line 115: ctx_ddl.set_attribute(l_ctx_pref_datastore,'detail_text', 'CTX_DESC');

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');

Line 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;

Line 122: ctx_ddl.create_preference('ICX_CAT_WORDLIST_HDRS', 'BASIC_WORDLIST');

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');

Line 124: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'STEMMER', '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;

Line 126: ctx_ddl.set_attribute('ICX_CAT_WORDLIST_HDRS', 'FUZZY_MATCH', 'AUTO');

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:

Line 129: ctx_ddl.create_preference('ICX_CAT_STORAGE_HDRS', 'BASIC_STORAGE');

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

Line 134: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_TABLE_CLAUSE',

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',

Line 136: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','K_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',

Line 138: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','R_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',

Line 140: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','N_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',

Line 142: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','P_TABLE_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;

Line 144: ctx_ddl.set_attribute('ICX_CAT_STORAGE_HDRS','I_INDEX_CLAUSE',

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;

Line 149: ctx_ddl.create_section_group(l_ctx_section_group, 'basic_section_group');

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);

Line 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);

Line 155: ctx_ddl.add_field_section(l_ctx_section_group, 'supid', 'supid', 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);

Line 157: ctx_ddl.add_field_section(l_ctx_section_group, 'ipcatid', 'ipcatid', 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);

Line 159: ctx_ddl.add_field_section(l_ctx_section_group, 'pocatid', 'pocatid', 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);

Line 161: ctx_ddl.add_field_section(l_ctx_section_group, 'siteid', 'siteid', 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);

Line 163: ctx_ddl.add_field_section(l_ctx_section_group, 'orgid', 'orgid', 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);

Line 165: ctx_ddl.add_field_section(l_ctx_section_group, 'purchorgid', 'purchorgid', 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);

Line 167: ctx_ddl.add_field_section(l_ctx_section_group, 'language', 'language', 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;

Line 169: ctx_ddl.add_field_section(l_ctx_section_group, 'item_type', 'item_type', FALSE);

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

Line 176: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);

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

Line 183: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);

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

Line 190: ctx_ddl.add_zone_section(l_ctx_section_group, to_char(counter), l_ctx_desc_tag);

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');

Line 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;

Line 210: ctx_ddl.drop_preference(l_ctx_pref_lexer);

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;

Line 222: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');

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');

Line 224: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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)

Line 225: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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;

Line 226: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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');

Line 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');

Line 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');

Line 236: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'VERB_ADJECTIVE', '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');

Line 237: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ONE_CHAR_WORD', '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');

Line 238: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'NUMBER', 'TRUE');

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');

Line 239: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'USER_DIC', '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');

Line 240: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'STOP_DIC', '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');

Line 241: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');

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');

Line 242: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'MORPHEME', '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');
246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');

Line 243: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'TO_UPPER', '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');
247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', 'TRUE');

Line 244: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'HANJA', 'FALSE');

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

Line 245: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'LONG_WORD', 'FALSE');

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)

Line 246: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'JAPANESE', 'FALSE');

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;

Line 247: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ENGLISH', '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;
251: ctx_ddl.create_preference(l_ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');

Line 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');

Line 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');

Line 257: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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)

Line 258: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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;

Line 259: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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');

Line 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', '-_');

Line 265: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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

Line 266: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');

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)

Line 267: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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;

Line 268: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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');

Line 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');

Line 274: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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)

Line 275: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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;

Line 276: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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');

Line 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');

Line 282: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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)

Line 283: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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;

Line 284: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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');

Line 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');

Line 290: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

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: ELSE
294: -- All other languages

Line 291: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

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: ELSE
294: -- All other languages
295: l_err_loc := 1200;

Line 292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');

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: ELSE
294: -- All other languages
295: l_err_loc := 1200;
296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');

Line 296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');

292: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
293: ELSE
294: -- All other languages
295: l_err_loc := 1200;
296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
297: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
298: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
299: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: END IF;

Line 297: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');

293: ELSE
294: -- All other languages
295: l_err_loc := 1200;
296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
297: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
298: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
299: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: END IF;
301:

Line 298: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');

294: -- All other languages
295: l_err_loc := 1200;
296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
297: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
298: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
299: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: END IF;
301:
302: l_err_loc := 1210;

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

295: l_err_loc := 1200;
296: ctx_ddl.create_preference(l_ctx_pref_lexer, 'BASIC_LEXER');
297: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'INDEX_THEMES', 'NO');
298: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'PRINTJOINS', '-_');
299: ctx_ddl.set_attribute(l_ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: END IF;
301:
302: l_err_loc := 1210;
303: -- add a sub lexer for this language

Line 304: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', l_nls_lang,

300: END IF;
301:
302: l_err_loc := 1210;
303: -- add a sub lexer for this language
304: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', l_nls_lang,
305: l_ctx_pref_lexer);
306:
307: l_err_loc := 1220;
308: -- make the base language sub lexer the default

Line 310: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', 'default',

306:
307: l_err_loc := 1220;
308: -- make the base language sub lexer the default
309: IF (language_row.installed_flag = 'B') THEN
310: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL_HDRS', 'default',
311: l_ctx_pref_lexer);
312: END IF;
313:
314: END LOOP;

Line 423: ctx_ddl.drop_preference(l_ctx_pref_datastore);

419:
420: -- drop the existing preferences
421: BEGIN
422: l_err_loc := 110;
423: ctx_ddl.drop_preference(l_ctx_pref_datastore);
424: l_err_loc := 120;
425: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
426: l_err_loc := 130;
427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');

Line 425: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');

421: BEGIN
422: l_err_loc := 110;
423: ctx_ddl.drop_preference(l_ctx_pref_datastore);
424: l_err_loc := 120;
425: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
426: l_err_loc := 130;
427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
428: l_err_loc := 140;
429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');

Line 427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');

423: ctx_ddl.drop_preference(l_ctx_pref_datastore);
424: l_err_loc := 120;
425: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
426: l_err_loc := 130;
427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
428: l_err_loc := 140;
429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
430: l_err_loc := 150;
431: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');

Line 429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');

425: ctx_ddl.drop_preference('ICX_CAT_FILTER_HDRS');
426: l_err_loc := 130;
427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
428: l_err_loc := 140;
429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
430: l_err_loc := 150;
431: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
432: l_err_loc := 160;
433: ctx_ddl.drop_section_group(l_ctx_section_group);

Line 431: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');

427: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL_HDRS');
428: l_err_loc := 140;
429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
430: l_err_loc := 150;
431: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
432: l_err_loc := 160;
433: ctx_ddl.drop_section_group(l_ctx_section_group);
434: l_err_loc := 170;
435: EXCEPTION

Line 433: ctx_ddl.drop_section_group(l_ctx_section_group);

429: ctx_ddl.drop_preference('ICX_CAT_WORDLIST_HDRS');
430: l_err_loc := 150;
431: ctx_ddl.drop_preference('ICX_CAT_STORAGE_HDRS');
432: l_err_loc := 160;
433: ctx_ddl.drop_section_group(l_ctx_section_group);
434: l_err_loc := 170;
435: EXCEPTION
436: WHEN OTHERS THEN
437: NULL;

Line 447: ctx_ddl.drop_preference(l_ctx_pref_lexer);

443: l_ctx_pref_lexer := 'ICX_CAT_LEXER_HDRS_' || language_row.language_code;
444:
445: BEGIN
446: l_err_loc := 210;
447: ctx_ddl.drop_preference(l_ctx_pref_lexer);
448: EXCEPTION
449: WHEN OTHERS THEN
450: NULL;
451: END;

Line 486: ad_ctx_ddl.sync_index(l_icx_schema_name || '.ICX_CAT_ITEMSCTXDESC_HDRS');

482:
483: l_icx_schema_name := ICX_CAT_UTIL_PVT.getIcxSchemaName;
484:
485: l_err_loc := 200;
486: ad_ctx_ddl.sync_index(l_icx_schema_name || '.ICX_CAT_ITEMSCTXDESC_HDRS');
487:
488: l_err_loc := 300;
489:
490: EXCEPTION