APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on OKC_ARTICLES_ALL

Line 65: l_art_title okc_articles_all.article_title%type;

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

Line 68: from okc_articles_all a, okc_article_versions v

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

Line 89: okc_articles_all a

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

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

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

Line 257: where table_name = 'OKC_ARTICLES_ALL';

253: begin
254: fnd_file.put_line(fnd_file.log,'Checking OKC_ARTICLES_ALL table ...');
255: select owner into okc
256: from sys.dba_tables
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);

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

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

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

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

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

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;
266: end;
267:
268: begin