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_ARTICLES_ALL

Line 67: l_art_title okc_articles_all.article_title%type;

63: end;
64:
65: function article_title(p_article_version_id in number) return varchar2
66: as
67: l_art_title okc_articles_all.article_title%type;
68: begin
69: select article_title into l_art_title
70: from okc_articles_all a, okc_article_versions v
71: where a.article_id = v.article_id

Line 70: from okc_articles_all a, okc_article_versions v

66: as
67: l_art_title okc_articles_all.article_title%type;
68: begin
69: select article_title into l_art_title
70: from okc_articles_all a, okc_article_versions v
71: where a.article_id = v.article_id
72: and article_version_id = p_article_version_id;
73: return l_art_title;
74: exception when others then

Line 91: okc_articles_all a

87: v.article_language lang
88: from
89: ctxsys.ctx_pending p,
90: okc_article_versions v,
91: okc_articles_all a
92: where pnd_index_name = 'OKC_ARTICLES_CTX'
93: and a.article_id = v.article_id
94: and v.rowid = pnd_rowid;
95: begin

Line 258: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLES_ALL table ...');

254: raise generic;
255: end;
256:
257: begin
258: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLES_ALL table ...');
259: select owner into okc
260: from sys.dba_tables
261: where table_name = 'OKC_ARTICLES_ALL';
262: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_ALL table exists');

Line 261: where table_name = 'OKC_ARTICLES_ALL';

257: begin
258: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLES_ALL table ...');
259: select owner into okc
260: from sys.dba_tables
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);

Line 262: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_ALL table exists');

258: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLES_ALL table ...');
259: select owner into okc
260: from sys.dba_tables
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:

Line 263: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_ALL table owner is '||okc);

259: select owner into okc
260: from sys.dba_tables
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

Line 268: fnd_file.put_line(fnd_file.log,'ERROR: OKC_ARTICLES_ALL table doesn''t exist');

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