eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CHR_KEYWORD_PVT dependencies on AD_CTX_DDL

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

12: slno BINARY_INTEGER;
13:
14: PROCEDURE sync IS
15: BEGIN
16: ad_ctx_ddl.set_effective_schema('okc');
17: ad_ctx_ddl.sync_index('okc_k_headers_tl_ctx');
18: EXCEPTION
19: WHEN OTHERS THEN
20: RAISE;

Line 17: ad_ctx_ddl.sync_index('okc_k_headers_tl_ctx');

13:
14: PROCEDURE sync IS
15: BEGIN
16: ad_ctx_ddl.set_effective_schema('okc');
17: ad_ctx_ddl.sync_index('okc_k_headers_tl_ctx');
18: EXCEPTION
19: WHEN OTHERS THEN
20: RAISE;
21: END;

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

21: END;
22:
23: PROCEDURE optimize IS
24: BEGIN
25: ad_ctx_ddl.set_effective_schema('okc');
26: ad_ctx_ddl.optimize_index
27: ( idx_name => 'okc_k_headers_tl_ctx',
28: optlevel => ad_ctx_ddl.optlevel_full,
29: maxtime => ad_ctx_ddl.maxtime_unlimited);

Line 26: ad_ctx_ddl.optimize_index

22:
23: PROCEDURE optimize IS
24: BEGIN
25: ad_ctx_ddl.set_effective_schema('okc');
26: ad_ctx_ddl.optimize_index
27: ( idx_name => 'okc_k_headers_tl_ctx',
28: optlevel => ad_ctx_ddl.optlevel_full,
29: maxtime => ad_ctx_ddl.maxtime_unlimited);
30: EXCEPTION

Line 28: optlevel => ad_ctx_ddl.optlevel_full,

24: BEGIN
25: ad_ctx_ddl.set_effective_schema('okc');
26: ad_ctx_ddl.optimize_index
27: ( idx_name => 'okc_k_headers_tl_ctx',
28: optlevel => ad_ctx_ddl.optlevel_full,
29: maxtime => ad_ctx_ddl.maxtime_unlimited);
30: EXCEPTION
31: WHEN OTHERS THEN
32: RAISE;

Line 29: maxtime => ad_ctx_ddl.maxtime_unlimited);

25: ad_ctx_ddl.set_effective_schema('okc');
26: ad_ctx_ddl.optimize_index
27: ( idx_name => 'okc_k_headers_tl_ctx',
28: optlevel => ad_ctx_ddl.optlevel_full,
29: maxtime => ad_ctx_ddl.maxtime_unlimited);
30: EXCEPTION
31: WHEN OTHERS THEN
32: RAISE;
33: END;

Line 146: ad_ctx_ddl.drop_preference('okc_k_headers_tl_datastore');

142:
143: BEGIN
144: BEGIN
145: fnd_file.put_line(fnd_file.log,'Before drop preference');
146: ad_ctx_ddl.drop_preference('okc_k_headers_tl_datastore');
147: fnd_file.put_line(fnd_file.log,'Preference dropped successfully');
148: EXCEPTION
149: WHEN OTHERS THEN
150: NULL;

Line 153: ad_ctx_ddl.create_preference('okc_k_headers_tl_datastore','multi_column_datastore');

149: WHEN OTHERS THEN
150: NULL;
151: END;
152: fnd_file.put_line(fnd_file.log,'Before create preference');
153: ad_ctx_ddl.create_preference('okc_k_headers_tl_datastore','multi_column_datastore');
154: ad_ctx_ddl.set_attribute('okc_k_headers_tl_datastore','columns',
155: 'cognomen, short_description, description');
156: fnd_file.put_line(fnd_file.log,'Preference created successfully');
157: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 4, 13);

Line 154: ad_ctx_ddl.set_attribute('okc_k_headers_tl_datastore','columns',

150: NULL;
151: END;
152: fnd_file.put_line(fnd_file.log,'Before create preference');
153: ad_ctx_ddl.create_preference('okc_k_headers_tl_datastore','multi_column_datastore');
154: ad_ctx_ddl.set_attribute('okc_k_headers_tl_datastore','columns',
155: 'cognomen, short_description, description');
156: fnd_file.put_line(fnd_file.log,'Preference created successfully');
157: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 4, 13);
158: END;

Line 164: ad_ctx_ddl.drop_preference('okc_k_headers_tl_lexer');

160: -- Creating all Lexers and sublexers
161: BEGIN
162: BEGIN
163: fnd_file.put_line(fnd_file.log,'Dropping multi lexer');
164: ad_ctx_ddl.drop_preference('okc_k_headers_tl_lexer');
165: fnd_file.put_line(fnd_file.log,'Multi lexer successfully');
166: EXCEPTION
167: WHEN OTHERS THEN
168: NULL;

Line 171: ad_ctx_ddl.create_preference('okc_k_headers_tl_lexer','multi_lexer');

167: WHEN OTHERS THEN
168: NULL;
169: END;
170: fnd_file.put_line(fnd_file.log,'Creating multi lexer');
171: ad_ctx_ddl.create_preference('okc_k_headers_tl_lexer','multi_lexer');
172: BEGIN
173: fnd_file.put_line(fnd_file.log,'Dropping basic lexer');
174: ad_ctx_ddl.drop_preference('okc_chrtl_blexer');
175: fnd_file.put_line(fnd_file.log,'Basic lexer dropped successfully');

Line 174: ad_ctx_ddl.drop_preference('okc_chrtl_blexer');

170: fnd_file.put_line(fnd_file.log,'Creating multi lexer');
171: ad_ctx_ddl.create_preference('okc_k_headers_tl_lexer','multi_lexer');
172: BEGIN
173: fnd_file.put_line(fnd_file.log,'Dropping basic lexer');
174: ad_ctx_ddl.drop_preference('okc_chrtl_blexer');
175: fnd_file.put_line(fnd_file.log,'Basic lexer dropped successfully');
176: EXCEPTION
177: WHEN OTHERS THEN
178: NULL;

Line 181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');

177: WHEN OTHERS THEN
178: NULL;
179: END;
180: fnd_file.put_line(fnd_file.log,'Creating basic lexer with its attributes');
181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');
182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');
183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');
184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');
185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');

Line 182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');

178: NULL;
179: END;
180: fnd_file.put_line(fnd_file.log,'Creating basic lexer with its attributes');
181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');
182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');
183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');
184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');
185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');
186: fnd_file.put_line(fnd_file.log,'Basic lexer with its attributes created successfully');

Line 183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');

179: END;
180: fnd_file.put_line(fnd_file.log,'Creating basic lexer with its attributes');
181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');
182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');
183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');
184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');
185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');
186: fnd_file.put_line(fnd_file.log,'Basic lexer with its attributes created successfully');
187:

Line 184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');

180: fnd_file.put_line(fnd_file.log,'Creating basic lexer with its attributes');
181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');
182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');
183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');
184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');
185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');
186: fnd_file.put_line(fnd_file.log,'Basic lexer with its attributes created successfully');
187:
188: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 13);

Line 185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');

181: ad_ctx_ddl.create_preference('okc_chrtl_blexer','basic_lexer');
182: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_themes','false');
183: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','index_text','true');
184: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','base_letter','true');
185: ad_ctx_ddl.set_attribute('okc_chrtl_blexer','mixed_case','false');
186: fnd_file.put_line(fnd_file.log,'Basic lexer with its attributes created successfully');
187:
188: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 13);
189:

Line 192: ad_ctx_ddl.drop_preference('okc_chrtl_clexer');

188: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 13);
189:
190: BEGIN
191: fnd_file.put_line(fnd_file.log,'Dropping Chinese lexer');
192: ad_ctx_ddl.drop_preference('okc_chrtl_clexer');
193: fnd_file.put_line(fnd_file.log,'Chinese lexer dropped successfully');
194: EXCEPTION
195: WHEN OTHERS THEN
196: NULL;

Line 212: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_lexer');

208: WHEN OTHERS THEN yes_no := 'N';
209: END;
210: fnd_file.put_line(fnd_file.log,'Chinese lexer: yes_no: ' || yes_no);
211: IF yes_no = 'Y' THEN
212: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_lexer');
213: ELSE
214: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_vgram_lexer');
215: END IF;
216: fnd_file.put_line(fnd_file.log,'Chinese lexer created successfully');

Line 214: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_vgram_lexer');

210: fnd_file.put_line(fnd_file.log,'Chinese lexer: yes_no: ' || yes_no);
211: IF yes_no = 'Y' THEN
212: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_lexer');
213: ELSE
214: ad_ctx_ddl.create_preference('okc_chrtl_clexer','chinese_vgram_lexer');
215: END IF;
216: fnd_file.put_line(fnd_file.log,'Chinese lexer created successfully');
217: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 13);
218:

Line 223: ad_ctx_ddl.drop_preference('okc_chrtl_jlexer');

219: END;
220:
221: BEGIN
222: fnd_file.put_line(fnd_file.log,'Dropping Japanese lexer');
223: ad_ctx_ddl.drop_preference('okc_chrtl_jlexer');
224: fnd_file.put_line(fnd_file.log,'Japanese lexer dropped successfully');
225: EXCEPTION
226: WHEN OTHERS THEN
227: NULL;

Line 244: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_lexer');

240: yes_no := 'N';
241: END;
242: fnd_file.put_line(fnd_file.log,'Japanese lexer: yes_no: ' || yes_no);
243: IF yes_no = 'Y' THEN
244: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_lexer');
245: ELSE
246: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_vgram_lexer');
247: END IF;
248: fnd_file.put_line(fnd_file.log,'Japanese lexer created successfully');

Line 246: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_vgram_lexer');

242: fnd_file.put_line(fnd_file.log,'Japanese lexer: yes_no: ' || yes_no);
243: IF yes_no = 'Y' THEN
244: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_lexer');
245: ELSE
246: ad_ctx_ddl.create_preference('okc_chrtl_jlexer','japanese_vgram_lexer');
247: END IF;
248: fnd_file.put_line(fnd_file.log,'Japanese lexer created successfully');
249: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 7, 13);
250: END;

Line 254: ad_ctx_ddl.drop_preference('okc_chrtl_klexer');

250: END;
251:
252: BEGIN
253: fnd_file.put_line(fnd_file.log,'Dropping korean lexer');
254: ad_ctx_ddl.drop_preference('okc_chrtl_klexer');
255: fnd_file.put_line(fnd_file.log,'Korean lexer dropped successfully');
256: EXCEPTION
257: WHEN OTHERS THEN
258: NULL;

Line 275: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_morph_lexer');

271: yes_no := 'N';
272: END;
273: fnd_file.put_line(fnd_file.log,'Korean lexer: yes_no: ' || yes_no);
274: IF yes_no = 'Y' THEN
275: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_morph_lexer');
276: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'one_char_word', 'true');
277: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'number', 'true');
278: ELSE
279: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_lexer');

Line 276: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'one_char_word', 'true');

272: END;
273: fnd_file.put_line(fnd_file.log,'Korean lexer: yes_no: ' || yes_no);
274: IF yes_no = 'Y' THEN
275: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_morph_lexer');
276: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'one_char_word', 'true');
277: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'number', 'true');
278: ELSE
279: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_lexer');
280: END IF;

Line 277: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'number', 'true');

273: fnd_file.put_line(fnd_file.log,'Korean lexer: yes_no: ' || yes_no);
274: IF yes_no = 'Y' THEN
275: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_morph_lexer');
276: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'one_char_word', 'true');
277: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'number', 'true');
278: ELSE
279: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_lexer');
280: END IF;
281:

Line 279: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_lexer');

275: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_morph_lexer');
276: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'one_char_word', 'true');
277: ad_ctx_ddl.set_attribute('okc_chrtl_klexer', 'number', 'true');
278: ELSE
279: ad_ctx_ddl.create_preference('okc_chrtl_klexer', 'korean_lexer');
280: END IF;
281:
282: fnd_file.put_line(fnd_file.log,'Korean lexer created successfully');
283: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 8, 13);

Line 288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');

284:
285: END;
286:
287: fnd_file.put_line(fnd_file.log,'Before Add Sub Lexer');
288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');
289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');
290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');
291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');
292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');

Line 289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');

285: END;
286:
287: fnd_file.put_line(fnd_file.log,'Before Add Sub Lexer');
288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');
289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');
290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');
291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');
292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');
293:

Line 290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');

286:
287: fnd_file.put_line(fnd_file.log,'Before Add Sub Lexer');
288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');
289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');
290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');
291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');
292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');
293:
294: fnd_file.put_line(fnd_file.log,'Sub Lexer Added Successfully');

Line 291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');

287: fnd_file.put_line(fnd_file.log,'Before Add Sub Lexer');
288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');
289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');
290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');
291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');
292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');
293:
294: fnd_file.put_line(fnd_file.log,'Sub Lexer Added Successfully');
295: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 13);

Line 292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');

288: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','default','okc_chrtl_blexer');
289: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ja','okc_chrtl_jlexer');
290: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','ko','okc_chrtl_klexer');
291: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zhs','okc_chrtl_clexer');
292: ad_ctx_ddl.add_sub_lexer('okc_k_headers_tl_lexer','zht','okc_chrtl_clexer');
293:
294: fnd_file.put_line(fnd_file.log,'Sub Lexer Added Successfully');
295: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 13);
296:

Line 303: ad_ctx_ddl.drop_preference('okc_k_headers_tl_wordlist');

299: --Create wordlist okc_k_headers_tl_wordlist
300: BEGIN
301: BEGIN
302: fnd_file.put_line(fnd_file.log,'Dropping WordList');
303: ad_ctx_ddl.drop_preference('okc_k_headers_tl_wordlist');
304: fnd_file.put_line(fnd_file.log,'WordList dropped successfully');
305: EXCEPTION
306: WHEN OTHERS THEN
307: NULL;

Line 310: ad_ctx_ddl.create_preference('okc_k_headers_tl_wordlist','basic_wordlist');

306: WHEN OTHERS THEN
307: NULL;
308: END;
309: fnd_file.put_line(fnd_file.log,'Creating WordList...');
310: ad_ctx_ddl.create_preference('okc_k_headers_tl_wordlist','basic_wordlist');
311: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','stemmer','auto');
312: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','fuzzy_match','auto');
313: fnd_file.put_line(fnd_file.log,'WordList created succesfully');
314: END;

Line 311: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','stemmer','auto');

307: NULL;
308: END;
309: fnd_file.put_line(fnd_file.log,'Creating WordList...');
310: ad_ctx_ddl.create_preference('okc_k_headers_tl_wordlist','basic_wordlist');
311: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','stemmer','auto');
312: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','fuzzy_match','auto');
313: fnd_file.put_line(fnd_file.log,'WordList created succesfully');
314: END;
315:

Line 312: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','fuzzy_match','auto');

308: END;
309: fnd_file.put_line(fnd_file.log,'Creating WordList...');
310: ad_ctx_ddl.create_preference('okc_k_headers_tl_wordlist','basic_wordlist');
311: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','stemmer','auto');
312: ad_ctx_ddl.set_attribute('okc_k_headers_tl_wordlist','fuzzy_match','auto');
313: fnd_file.put_line(fnd_file.log,'WordList created succesfully');
314: END;
315:
316: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 10, 13);