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 OKC_ARTICLE_KEYWORD_PVT

Line 1: package body okc_article_keyword_pvt as

1: package body okc_article_keyword_pvt as
2: -- $Header: OKCVAKWB.pls 120.11.12020000.2 2012/07/16 16:16:34 harchand ship $
3:
4: retcode_success constant varchar2(1) := '0';
5: retcode_warning constant varchar2(1) := '1';

Line 133: request_id := okc_article_keyword_pvt.request_id('OKCARTSYNCCTX');

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

Line 174: request_id := okc_article_keyword_pvt.request_id('OKCARTOPTCTX');

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

Line 214: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');

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

Line 238: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');

234: generic exception;
235:
236: request_id fnd_concurrent_requests.request_id%type;
237: begin
238: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
239: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_CTX text index creation started');
240:
241: begin
242: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLE_KEYWORD_PVT package ...');

Line 242: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLE_KEYWORD_PVT package ...');

238: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
239: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_CTX text index creation started');
240:
241: begin
242: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLE_KEYWORD_PVT package ...');
243: select owner into apps
244: from sys.dba_objects
245: where object_name = 'OKC_ARTICLE_KEYWORD_PVT'
246: and object_type = 'PACKAGE';

Line 245: where object_name = 'OKC_ARTICLE_KEYWORD_PVT'

241: begin
242: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLE_KEYWORD_PVT package ...');
243: select owner into apps
244: from sys.dba_objects
245: where object_name = 'OKC_ARTICLE_KEYWORD_PVT'
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:

Line 247: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_KEYWORD_PVT package exists');

243: select owner into apps
244: from sys.dba_objects
245: where object_name = 'OKC_ARTICLE_KEYWORD_PVT'
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:

Line 248: fnd_file.put_line(fnd_file.log,'OKC_ARTICLE_KEYWORD_PVT package owner is '||apps);

244: from sys.dba_objects
245: where object_name = 'OKC_ARTICLE_KEYWORD_PVT'
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

Line 253: fnd_file.put_line(fnd_file.log,'ERROR: OKC_ARTICLE_KEYWORD_PVT package doesn''t exist');

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;
255: end;
256:
257: begin

Line 273: execute immediate 'grant execute on '||apps||'.OKC_ARTICLE_KEYWORD_PVT to '||okc;

269: raise generic;
270: end;
271:
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:

Line 274: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_ARTICLE_KEYWORD_PVT to '||okc);

270: end;
271:
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

Line 279: fnd_file.put_line(fnd_file.log,'ERROR: Couldn''t grant 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;
281: end;
282:
283: -- ===================================================================

Line 306: apps||'.okc_article_keyword_pvt.article_title(article_version_id) art_title,

302: fnd_file.put_line(fnd_file.log,'Creating new OKC_ARTICLES_DATASTORE preference');
303: end;
304: ad_ctx_ddl.create_preference('okc_articles_datastore','multi_column_datastore');
305: ad_ctx_ddl.set_attribute('okc_articles_datastore','columns',
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);