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.IBE_SEARCH_SETUP_PVT dependencies on IBE_CT_IMEDIA_SEARCH

Line 189: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;

185: l_search_category_set :='';
186: l_search_web_status := 'PUBLISHED';
187: l_use_category_search := 'N ';
188: l_use_fuzzy_search := 'N';
189: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
190: l_create_fuzzy_index2 := ' parameters ('' lexer ibe_global_lexer language column language Wordlist IBE_STEM_FUZZY_PREF '') ' ;
191: l_create_fuzzy_index := l_create_fuzzy_index1 || l_create_fuzzy_index2 ;
192: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
193: l_create_index2 := ' parameters('' lexer ibe_global_lexer language column language '') ' ;

Line 192: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;

188: l_use_fuzzy_search := 'N';
189: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
190: l_create_fuzzy_index2 := ' parameters ('' lexer ibe_global_lexer language column language Wordlist IBE_STEM_FUZZY_PREF '') ' ;
191: l_create_fuzzy_index := l_create_fuzzy_index1 || l_create_fuzzy_index2 ;
192: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
193: l_create_index2 := ' parameters('' lexer ibe_global_lexer language column language '') ' ;
194: l_create_index := l_create_index1 || l_create_index2 ;
195: l_base_language := ' ';
196:

Line 201: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';

197:
198: select count(*)
199: into l_index_exists
200: from user_indexes
201: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
202:
203:
204: DBMS_UTILITY.db_version(l_db_version_str, l_compatibility);
205: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);

Line 219: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';

215: then
216:
217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Intermedia index exists , dropping intermedia index ');
218: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
219: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
220: end if ;
221:
222: FND_FILE.PUT_LINE(FND_FILE.LOG,' deleting data from Search table ');
223: --dbms_output.put_line(' deleting data from Search table ');

Line 236: --execute immediate 'truncate table ibe_ct_imedia_search';

232: if (fnd_installation.get_app_info(l_application_short_name,
233: l_status_AppInfo ,
234: l_industry_AppInfo ,
235: l_oracle_schema_AppInfo )) then
236: --execute immediate 'truncate table ibe_ct_imedia_search';
237: l_trunc_tab := 'truncate table '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search';
238: execute immediate l_trunc_tab;
239: commit;
240: end if;

Line 237: l_trunc_tab := 'truncate table '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search';

233: l_status_AppInfo ,
234: l_industry_AppInfo ,
235: l_oracle_schema_AppInfo )) then
236: --execute immediate 'truncate table ibe_ct_imedia_search';
237: l_trunc_tab := 'truncate table '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search';
238: execute immediate l_trunc_tab;
239: commit;
240: end if;
241:

Line 242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');

238: execute immediate l_trunc_tab;
239: commit;
240: end if;
241:
242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');

Line 244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');

240: end if;
241:
242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
247:
248: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

Line 289: INSERT INTO IBE_CT_IMEDIA_SEARCH(

285:
286: If (l_search_category_set is null and l_search_web_status='ALL')
287: Then --{
288:
289: INSERT INTO IBE_CT_IMEDIA_SEARCH(
290: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
291: CREATED_BY,CREATION_DATE,
292: LAST_UPDATED_BY,LAST_UPDATE_DATE,
293: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 290: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

286: If (l_search_category_set is null and l_search_web_status='ALL')
287: Then --{
288:
289: INSERT INTO IBE_CT_IMEDIA_SEARCH(
290: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
291: CREATED_BY,CREATION_DATE,
292: LAST_UPDATED_BY,LAST_UPDATE_DATE,
293: LAST_UPDATE_LOGIN,CATEGORY_ID,
294: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 300: ibe_ct_imedia_search_s1.nextval,

296: DESCRIPTION,LONG_DESCRIPTION,
297: INDEXED_SEARCH,WEB_STATUS,
298: SECURITY_GROUP_ID)
299: (SELECT
300: ibe_ct_imedia_search_s1.nextval,
301: 1,
302: FND_GLOBAL.user_id,
303: SYSDATE,
304: FND_GLOBAL.user_id,

Line 330: INSERT INTO IBE_CT_IMEDIA_SEARCH(

326: Elsif (l_search_category_set is null and
327: (l_search_web_status='PUBLISHED' or l_search_web_status is null))
328: Then
329:
330: INSERT INTO IBE_CT_IMEDIA_SEARCH(
331: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
332: CREATED_BY,CREATION_DATE,
333: LAST_UPDATED_BY,LAST_UPDATE_DATE,
334: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 331: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

327: (l_search_web_status='PUBLISHED' or l_search_web_status is null))
328: Then
329:
330: INSERT INTO IBE_CT_IMEDIA_SEARCH(
331: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
332: CREATED_BY,CREATION_DATE,
333: LAST_UPDATED_BY,LAST_UPDATE_DATE,
334: LAST_UPDATE_LOGIN,CATEGORY_ID,
335: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 340: (SELECT ibe_ct_imedia_search_s1.nextval,

336: INVENTORY_ITEM_ID,LANGUAGE,
337: DESCRIPTION,LONG_DESCRIPTION,
338: INDEXED_SEARCH,WEB_STATUS,
339: SECURITY_GROUP_ID)
340: (SELECT ibe_ct_imedia_search_s1.nextval,
341: 1,
342: FND_GLOBAL.user_id,
343: SYSDATE,
344: FND_GLOBAL.user_id,

Line 369: INSERT INTO IBE_CT_IMEDIA_SEARCH(

365:
366: Elsif (l_search_category_set is null and l_search_web_status='PUBLISHED_UNPUBLISHED')
367: Then
368:
369: INSERT INTO IBE_CT_IMEDIA_SEARCH(
370: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
371: CREATED_BY,CREATION_DATE,
372: LAST_UPDATED_BY,LAST_UPDATE_DATE,
373: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 370: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

366: Elsif (l_search_category_set is null and l_search_web_status='PUBLISHED_UNPUBLISHED')
367: Then
368:
369: INSERT INTO IBE_CT_IMEDIA_SEARCH(
370: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
371: CREATED_BY,CREATION_DATE,
372: LAST_UPDATED_BY,LAST_UPDATE_DATE,
373: LAST_UPDATE_LOGIN,CATEGORY_ID,
374: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 379: (SELECT ibe_ct_imedia_search_s1.nextval,

375: INVENTORY_ITEM_ID,LANGUAGE,
376: DESCRIPTION,LONG_DESCRIPTION,
377: INDEXED_SEARCH,WEB_STATUS,
378: SECURITY_GROUP_ID)
379: (SELECT ibe_ct_imedia_search_s1.nextval,
380: 1,
381: FND_GLOBAL.user_id,
382: SYSDATE,
383: FND_GLOBAL.user_id,

Line 408: INSERT INTO IBE_CT_IMEDIA_SEARCH(

404:
405: Elsif (l_search_category_set is not null and l_search_web_status='ALL')
406: Then
407:
408: INSERT INTO IBE_CT_IMEDIA_SEARCH(
409: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
410: CREATED_BY,CREATION_DATE,
411: LAST_UPDATED_BY,LAST_UPDATE_DATE,
412: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 409: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

405: Elsif (l_search_category_set is not null and l_search_web_status='ALL')
406: Then
407:
408: INSERT INTO IBE_CT_IMEDIA_SEARCH(
409: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
410: CREATED_BY,CREATION_DATE,
411: LAST_UPDATED_BY,LAST_UPDATE_DATE,
412: LAST_UPDATE_LOGIN,CATEGORY_ID,
413: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 418: (SELECT ibe_ct_imedia_search_s1.nextval,

414: INVENTORY_ITEM_ID,LANGUAGE,
415: DESCRIPTION,LONG_DESCRIPTION,
416: INDEXED_SEARCH,WEB_STATUS,
417: SECURITY_GROUP_ID)
418: (SELECT ibe_ct_imedia_search_s1.nextval,
419: 1,
420: FND_GLOBAL.user_id,
421: SYSDATE,
422: FND_GLOBAL.user_id,

Line 447: INSERT INTO IBE_CT_IMEDIA_SEARCH(

443: Elsif (l_search_category_set is not null and
444: (l_search_web_status='PUBLISHED' OR l_search_web_status is null))
445: Then
446:
447: INSERT INTO IBE_CT_IMEDIA_SEARCH(
448: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
449: CREATED_BY,CREATION_DATE,
450: LAST_UPDATED_BY,LAST_UPDATE_DATE,
451: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 448: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

444: (l_search_web_status='PUBLISHED' OR l_search_web_status is null))
445: Then
446:
447: INSERT INTO IBE_CT_IMEDIA_SEARCH(
448: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
449: CREATED_BY,CREATION_DATE,
450: LAST_UPDATED_BY,LAST_UPDATE_DATE,
451: LAST_UPDATE_LOGIN,CATEGORY_ID,
452: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 457: (SELECT ibe_ct_imedia_search_s1.nextval,

453: INVENTORY_ITEM_ID,LANGUAGE,
454: DESCRIPTION,LONG_DESCRIPTION,
455: INDEXED_SEARCH,WEB_STATUS,
456: SECURITY_GROUP_ID)
457: (SELECT ibe_ct_imedia_search_s1.nextval,
458: 1,
459: FND_GLOBAL.user_id,
460: SYSDATE,
461: FND_GLOBAL.user_id,

Line 487: INSERT INTO IBE_CT_IMEDIA_SEARCH(

483:
484: Elsif (l_search_category_set is not null and l_search_web_status= 'PUBLISHED_UNPUBLISHED')
485: Then
486:
487: INSERT INTO IBE_CT_IMEDIA_SEARCH(
488: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
489: CREATED_BY,CREATION_DATE,
490: LAST_UPDATED_BY,LAST_UPDATE_DATE,
491: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 488: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

484: Elsif (l_search_category_set is not null and l_search_web_status= 'PUBLISHED_UNPUBLISHED')
485: Then
486:
487: INSERT INTO IBE_CT_IMEDIA_SEARCH(
488: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
489: CREATED_BY,CREATION_DATE,
490: LAST_UPDATED_BY,LAST_UPDATE_DATE,
491: LAST_UPDATE_LOGIN,CATEGORY_ID,
492: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 497: (SELECT ibe_ct_imedia_search_s1.nextval,

493: INVENTORY_ITEM_ID,LANGUAGE,
494: DESCRIPTION,LONG_DESCRIPTION,
495: INDEXED_SEARCH,WEB_STATUS,
496: SECURITY_GROUP_ID)
497: (SELECT ibe_ct_imedia_search_s1.nextval,
498: 1,
499: FND_GLOBAL.user_id,
500: SYSDATE,
501: FND_GLOBAL.user_id,

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');

608:
609:
610:
611:
612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
614: execute immediate l_create_fuzzy_index;
615:
616:

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');

614: execute immediate l_create_fuzzy_index;
615:
616:
617: else
618: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
620:
621: execute immediate l_create_index;
622: