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 132: rindex := dbms_application_info.set_session_longops_nohint;

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

Line 134: dbms_application_info.set_session_longops(rindex, slno,

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

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

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

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

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

Line 173: rindex := dbms_application_info.set_session_longops_nohint;

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

Line 175: dbms_application_info.set_session_longops(rindex, slno,

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

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

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

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

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

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

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

Line 213: rindex := dbms_application_info.set_session_longops_nohint;

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

Line 215: dbms_application_info.set_session_longops(rindex, slno,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

591: when others then
592: null;
593: end;
594:
595: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 16, 18);
596:
597: max_memory := round(max_memory/2);
598: cpu_count := round(cpu_count/2);
599: -- Bug# 7508004

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

616: wordlist '||apps||'.okc_articles_wordlist'') parallel '||index_parallel;
617: fnd_file.put_line(fnd_file.log, 'Executing '||okc||'.OKC_ARTICLES_CTX text index creation DDL ...');
618: fnd_file.put_line(fnd_file.log, cmd);
619:
620: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 17, 18);
621:
622: execute immediate cmd;
623:
624: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 18, 18);

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

620: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 17, 18);
621:
622: execute immediate cmd;
623:
624: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 18, 18);
625:
626: fnd_file.put_line(fnd_file.log, okc||'.OKC_ARTICLES_CTX text index has been created successfully');
627: exception when others then
628: fnd_file.put_line(fnd_file.log, 'ERROR: Couldn''t create '||okc||'.OKC_ARTICLES_CTX text index');