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_ARTICLE_KEYWORD_PVT dependencies on DBMS_APPLICATION_INFO

Line 130: rindex := dbms_application_info.set_session_longops_nohint;

126: as
127: counter number;
128: request_id fnd_concurrent_requests.request_id%type;
129: begin
130: rindex := dbms_application_info.set_session_longops_nohint;
131: request_id := okc_article_keyword_pvt.request_id('OKCARTSYNCCTX');
132: dbms_application_info.set_session_longops(rindex, slno,
133: 'Synchronize Clause Text Index', request_id, 0, 0, 1,
134: 'OKCARTSYNCCTX concurrent program', 'steps');

Line 132: dbms_application_info.set_session_longops(rindex, slno,

128: request_id fnd_concurrent_requests.request_id%type;
129: begin
130: rindex := dbms_application_info.set_session_longops_nohint;
131: request_id := okc_article_keyword_pvt.request_id('OKCARTSYNCCTX');
132: dbms_application_info.set_session_longops(rindex, slno,
133: 'Synchronize Clause Text Index', request_id, 0, 0, 1,
134: 'OKCARTSYNCCTX concurrent program', 'steps');
135:
136: --Modified for performance bug 6943402. Removing counter since its taking long time to fetch the value of counter.

Line 151: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 1);

147: IF FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
148: counter := check_pending_rows(finish);
149: END IF;
150:
151: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 1);
152: /* else
153: fnd_file.put_line(fnd_file.log, 'Skipped synchronization (no pending rows)');
154:
155: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 1);

Line 155: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 1);

151: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 1);
152: /* else
153: fnd_file.put_line(fnd_file.log, 'Skipped synchronization (no pending rows)');
154:
155: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 1);
156: end if;*/
157:
158:
159: errbuf := 'OKC_ARTICLES_CTX text index has been synchronized successfully';

Line 171: rindex := dbms_application_info.set_session_longops_nohint;

167: procedure optimize_ctx(errbuf out nocopy varchar2, retcode out nocopy varchar2)
168: as
169: request_id fnd_concurrent_requests.request_id%type;
170: begin
171: rindex := dbms_application_info.set_session_longops_nohint;
172: request_id := okc_article_keyword_pvt.request_id('OKCARTOPTCTX');
173: dbms_application_info.set_session_longops(rindex, slno,
174: 'Optimize Clause Text Index', request_id, 0, 0, 2,
175: 'OKCARTOPTCTX concurrent program', 'steps');

Line 173: dbms_application_info.set_session_longops(rindex, slno,

169: request_id fnd_concurrent_requests.request_id%type;
170: begin
171: rindex := dbms_application_info.set_session_longops_nohint;
172: request_id := okc_article_keyword_pvt.request_id('OKCARTOPTCTX');
173: dbms_application_info.set_session_longops(rindex, slno,
174: 'Optimize Clause Text Index', request_id, 0, 0, 2,
175: 'OKCARTOPTCTX concurrent program', 'steps');
176:
177: begin

Line 189: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 2);

185: end;
186:
187: if retcode <> retcode_success then
188: fnd_file.put_line(fnd_file.log, 'ERROR: Synchronization failed (have to skip optimization)');
189: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 2);
190: return;
191: end if;
192:
193: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 2);

Line 193: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 2);

189: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 0, 2);
190: return;
191: end if;
192:
193: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 2);
194: fnd_file.put_line(fnd_file.log, 'Start optimization ...');
195: optimize;
196:
197: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 2, 2);

Line 197: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 2, 2);

193: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 1, 2);
194: fnd_file.put_line(fnd_file.log, 'Start optimization ...');
195: optimize;
196:
197: dbms_application_info.set_session_longops( rindex, slno, null, request_id, 0, 2, 2);
198: fnd_file.put_line(fnd_file.log, 'Optimization complete');
199: errbuf := 'OKC_ARTICLES_CTX text index has been optimized successfully';
200: retcode := retcode_success;
201: exception when others then

Line 211: rindex := dbms_application_info.set_session_longops_nohint;

207: procedure create_ctx(errbuf out nocopy varchar2, retcode out nocopy varchar2)
208: is
209: request_id fnd_concurrent_requests.request_id%type;
210: begin
211: rindex := dbms_application_info.set_session_longops_nohint;
212: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
213: dbms_application_info.set_session_longops(rindex, slno,
214: 'Create Clause Text Index', request_id, request_id, 0, 18,
215: 'OKCARTCRTCTX concurrent program', 'steps');

Line 213: dbms_application_info.set_session_longops(rindex, slno,

209: request_id fnd_concurrent_requests.request_id%type;
210: begin
211: rindex := dbms_application_info.set_session_longops_nohint;
212: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
213: dbms_application_info.set_session_longops(rindex, slno,
214: 'Create Clause Text Index', request_id, request_id, 0, 18,
215: 'OKCARTCRTCTX concurrent program', 'steps');
216:
217: retcode := retcode_success;

Line 246: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 18);

242: and object_type = 'PACKAGE';
243: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_KEYWORD_PVT package exists');
244: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_KEYWORD_PVT package owner is '||apps);
245:
246: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 18);
247:
248: exception when others then
249: fnd_file.put_line(fnd_file.log,'ERROR: OKC_ARTICLE_KEYWORD_PVT package doesn''t exist');
250: raise generic;

Line 261: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 2, 18);

257: where table_name = 'OKC_ARTICLES_ALL';
258: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_ALL table exists');
259: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_ALL table owner is '||okc);
260:
261: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 2, 18);
262:
263: exception when others then
264: fnd_file.put_line(fnd_file.log,'ERROR: OKC_ARTICLES_ALL table doesn''t exist');
265: raise generic;

Line 272: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 18);

268: begin
269: execute immediate 'grant execute on '||apps||'.OKC_ARTICLE_KEYWORD_PVT to '||okc;
270: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_ARTICLE_KEYWORD_PVT to '||okc);
271:
272: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 18);
273:
274: exception when others then
275: fnd_file.put_line(fnd_file.log,'ERROR: Couldn''t grant execute on '||apps||'.OKC_ARTICLE_KEYWORD_PVT to '||okc);
276: raise generic;

Line 306: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 4, 18);

302: apps||'.okc_article_keyword_pvt.article_title(article_version_id) art_title,
303: display_name art_disp, article_description art_descr, article_text art_text, additional_instructions art_instr');
304: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_DATASTORE preference has been created successfully as MULTI_COLUMN_DATASTORE');
305:
306: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 4, 18);
307:
308: end;
309:
310: -- -------------------------------------------------------------------

Line 335: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 18);

331: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS: add field section Text');
332: ad_ctx_ddl.add_field_section('okc_article_sections', 'Text', '', true);
333: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_SECTIONS section group has been created successfully as BASIC_SECTION_GROUP');
334:
335: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 18);
336:
337: end;
338:
339: -- -------------------------------------------------------------------

Line 369: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 18);

365: fnd_file.put_line(fnd_file.log,'OKC_BLEXER: set attribute mixed_case=false');
366: ad_ctx_ddl.set_attribute('okc_blexer','mixed_case','false');
367: fnd_file.put_line(fnd_file.log,'OKC_BLEXER preference has been created as BASIC_LEXER');
368:
369: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 18);
370:
371: -- Chinese lexer
372: begin
373: ad_ctx_ddl.drop_preference('okc_clexer');

Line 398: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 7, 18);

394: ad_ctx_ddl.create_preference('okc_clexer','chinese_vgram_lexer');
395: fnd_file.put_line(fnd_file.log,'OKC_CLEXER preference has been created as CHINESE_VGRAM_LEXER');
396: end if;
397:
398: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 7, 18);
399:
400: end;
401:
402: -- Japanese lexer

Line 431: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 8, 18);

427: ad_ctx_ddl.create_preference('okc_jlexer','japanese_vgram_lexer');
428: fnd_file.put_line(fnd_file.log,'OKC_JLEXER preference has been created as JAPANESE_VGRAM_LEXER');
429: end if;
430:
431: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 8, 18);
432:
433: end;
434:
435: -- Korean lexer

Line 466: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 18);

462: ad_ctx_ddl.set_attribute('okc_klexer', 'one_char_word', 'true');
463: fnd_file.put_line(fnd_file.log,'OKC_KLEXER: set attribute number=true');
464: ad_ctx_ddl.set_attribute('okc_klexer', 'number', 'true');
465:
466: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 18);
467:
468: end;
469:
470: -- sublexers

Line 483: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 10, 18);

479: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER: add sublexer zht=okc_clexer');
480: ad_ctx_ddl.add_sub_lexer('okc_articles_lexer','zht','okc_clexer');
481: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_LEXER preference has been created as MULTI_LEXER');
482:
483: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 10, 18);
484:
485: end;
486:
487: -- -------------------------------------------------------------------

Line 499: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 11, 18);

495: exception when others then
496: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_STOPLIST preference already exists');
497: end;
498:
499: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 11, 18);
500:
501: -- -------------------------------------------------------------------
502: -- Create wordlist okc_articles_wordlist
503: -- -------------------------------------------------------------------

Line 529: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 18);

525: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','fuzzy_numresults',100);
526: -- ad_ctx_ddl.set_attribute('okc_articles_wordlist','substring_index','true');
527: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_WORDLIST preference has been created as BASIC_WORDLIST');
528:
529: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 18);
530:
531: end;
532:
533: -- -------------------------------------------------------------------

Line 543: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 13, 18);

539: exception when others then
540: null;
541: end;
542:
543: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 13, 18);
544:
545: fnd_file.put_line(fnd_file.log, 'Generating '||okc||'.OKC_ARTICLES_CTX text index creation DDL ...');
546: -- -------------------------------------------------------------------
547: -- Create context index okc_articles_ctx

Line 569: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 14, 18);

565: exception when others then
566: null;
567: end;
568:
569: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 14, 18);
570:
571: begin
572: select value into cpu_count
573: from v$parameter

Line 580: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 15, 18);

576: exception when others then
577: null;
578: end;
579:
580: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 15, 18);
581:
582: begin
583: select to_number(substr(version,0,2)) into db_version
584: from v$instance;

Line 591: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 16, 18);

587: when others then
588: null;
589: end;
590:
591: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 16, 18);
592:
593: max_memory := round(max_memory/2);
594: cpu_count := round(cpu_count/2);
595: if db_version < 10 then sync := ' '; end if;

Line 610: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 17, 18);

606: wordlist '||apps||'.okc_articles_wordlist'') parallel '||cpu_count;
607: fnd_file.put_line(fnd_file.log, 'Executing '||okc||'.OKC_ARTICLES_CTX text index creation DDL ...');
608: fnd_file.put_line(fnd_file.log, cmd);
609:
610: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 17, 18);
611:
612: execute immediate cmd;
613:
614: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 18, 18);

Line 614: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 18, 18);

610: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 17, 18);
611:
612: execute immediate cmd;
613:
614: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 18, 18);
615:
616: fnd_file.put_line(fnd_file.log, okc||'.OKC_ARTICLES_CTX text index has been created successfully');
617: exception when others then
618: fnd_file.put_line(fnd_file.log, 'ERROR: Couldn''t create '||okc||'.OKC_ARTICLES_CTX text index');