226: errbuf := 'ERROR: Couldn''t create OKC_ARTICLES_CTX text index';
227: end;
228:
229: procedure crt is
230: apps sys.dba_objects.owner%type;
231: okc sys.dba_objects.owner%type;
232: cmd varchar2(4000);
233:
234: generic exception;
227: end;
228:
229: procedure crt is
230: apps sys.dba_objects.owner%type;
231: okc sys.dba_objects.owner%type;
232: cmd varchar2(4000);
233:
234: generic exception;
235:
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';
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);