APPS.ETRM_SEARCH dependencies on CATSEARCH

Line 180: where catsearch(c1.description, :search, null) > 0';

176: v_stmt :=
177: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
178: select application_id, table_id, ''COL''
179: from fnd_columns c1
180: where catsearch(c1.description, :search, null) > 0';
181:
182: execute immediate v_stmt using c_search;
183:
184: v_stmt :=

Line 188: where catsearch(c1.description, :search, null) > 0';

184: v_stmt :=
185: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
186: select application_id, table_id, ''TAB''
187: from fnd_tables c1
188: where catsearch(c1.description, :search, null) > 0';
189:
190: execute immediate v_stmt using c_search;
191:
192: v_stmt :=

Line 196: where catsearch(c1.description, :search, null) > 0';

192: v_stmt :=
193: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
194: select application_id, view_id, ''VW''
195: from fnd_views c1
196: where catsearch(c1.description, :search, null) > 0';
197:
198: execute immediate v_stmt using c_search;
199:
200:

Line 257: where catsearch(title, c_search, null) > 0

253: select file_id
254: , application
255: , title
256: from fnd_help_documents
257: where catsearch(title, c_search, null) > 0
258: order by application, title;
259:
260: begin
261: htp.p('

Documents

Line 425: v_search := replace(v_search, '&', ' '); -- catsearch does not like '&' characters

421: htp.p('');
422: end loop;
423:
424: v_search := c_search;
425: v_search := replace(v_search, '&', ' '); -- catsearch does not like '&' characters
426: v_search := ltrim(v_search);
427: v_search := rtrim(v_search);
428:
429: v_search := replace(v_search, '|', '{|}'); -- escape '|' (OR) characters to prevent http 404