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 DBMS_APPLICATION_INFO

Line 103: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 13);

99: AND object_type = 'PACKAGE';
100: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package exists');
101: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package owner is '||apps);
102:
103: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 13);
104: EXCEPTION WHEN OTHERS THEN
105: fnd_file.put_line(fnd_file.log,'ERROR: OKC_CHR__KEYWORD_PVT package doesn''t exist');
106: RAISE anyexp;
107: END;

Line 117: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 2, 13);

113: WHERE table_name = 'OKC_K_HEADERS_TL';
114: fnd_file.put_line(fnd_file.log,'OKC_K_HEADERS_TL table exists');
115: fnd_file.put_line(fnd_file.log,'OKC_K_HEADERS_TL table owner is '||okc);
116:
117: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 2, 13);
118:
119: EXCEPTION WHEN OTHERS THEN
120: fnd_file.put_line(fnd_file.log,'ERROR: OKC_K_HEADERS_TL table doesn''t exist');
121: RAISE anyexp;

Line 128: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 13);

124: BEGIN
125: EXECUTE IMMEDIATE 'GRANT EXECUTE ON '||apps||'.OKC_CHR_KEYWORD_PVT TO '||okc;
126: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);
127:
128: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 13);
129:
130: EXCEPTION WHEN OTHERS THEN
131: fnd_file.put_line(fnd_file.log,'ERROR: Couldn''t grant execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);
132: RAISE anyexp;

Line 157: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 4, 13);

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;
159:
160: -- Creating all Lexers and sublexers
161: BEGIN

Line 188: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 5, 13);

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:
190: BEGIN
191: fnd_file.put_line(fnd_file.log,'Dropping Chinese lexer');
192: ad_ctx_ddl.drop_preference('okc_chrtl_clexer');

Line 217: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 6, 13);

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:
219: END;
220:
221: BEGIN

Line 249: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 7, 13);

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;
251:
252: BEGIN
253: fnd_file.put_line(fnd_file.log,'Dropping korean lexer');

Line 283: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 8, 13);

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);
284:
285: END;
286:
287: fnd_file.put_line(fnd_file.log,'Before Add Sub Lexer');

Line 295: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 9, 13);

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:
297: END;
298:
299: --Create wordlist okc_k_headers_tl_wordlist

Line 316: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 10, 13);

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);
317:
318: -- Drop context index okc_k_headers_tl_ctx (if exists)
319: BEGIN
320: fnd_file.put_line(fnd_file.log,'Dropping INDEX okc_k_headers_tl_ctx...');

Line 328: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 11, 13);

324: WHEN OTHERS THEN
325: NULL;
326: END;
327:
328: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 11, 13);
329:
330: -- Create context index okc_k_headers_tl_ctx
331: DECLARE
332: l_max_memory NUMBER;

Line 358: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 13);

354:
355: fnd_file.put_line(fnd_file.log,'CPU Count: '||l_cpu_count);
356: fnd_file.put_line(fnd_file.log,'Before Index Creation');
357:
358: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 12, 13);
359:
360: -- Changes for Bug# 6921424
361: -- l_max_memory and l_cpu_count should be an integer in order to
362: -- pass them as parameters to the create index statement

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

376: ' STOPLIST ctxsys.default_stoplist
377: WORDLIST ' || apps || '.okc_k_headers_tl_wordlist'') PARALLEL ' || l_cpu_count; -- For Bug# 6921424
378:
379: fnd_file.put_line(fnd_file.log,'Index OKC_K_HEADERS_TL_CTX created successfully');
380: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 13, 13);
381:
382: EXCEPTION
383: WHEN ANYEXP THEN
384: x_return_status := 'E';

Line 402: rindex := dbms_application_info.set_session_longops_nohint;

398: request_id fnd_concurrent_requests.request_id%type;
399: l_return_status VARCHAR2(3) := 'S';
400: stop_proc EXCEPTION;
401: BEGIN
402: rindex := dbms_application_info.set_session_longops_nohint;
403: request_id := get_request_id('OKCCHRCRCTX');
404: dbms_application_info.set_session_longops
405: (rindex, slno, 'Create Contract Header Text Index', request_id, request_id, 0, 13,
406: 'OKCCHRCRCTX concurrent program', 'steps');

Line 404: dbms_application_info.set_session_longops

400: stop_proc EXCEPTION;
401: BEGIN
402: rindex := dbms_application_info.set_session_longops_nohint;
403: request_id := get_request_id('OKCCHRCRCTX');
404: dbms_application_info.set_session_longops
405: (rindex, slno, 'Create Contract Header Text Index', request_id, request_id, 0, 13,
406: 'OKCCHRCRCTX concurrent program', 'steps');
407:
408: create_ctx(x_return_status => l_return_status);