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 217: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search

213: l_use_category_search := 'N ';
214: l_use_fuzzy_search := 'N';
215: /*
216: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
217: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
218: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
219: */
220: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
221:

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

214: l_use_fuzzy_search := 'N';
215: /*
216: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
217: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
218: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
219: */
220: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
221:
222: l_create_fuzzy_index2 := ' parameters ('' lexer ibe_global_lexer language column language Wordlist IBE_STEM_FUZZY_PREF '') ' ;

Line 220: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara

216: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
217: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
218: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
219: */
220: l_create_fuzzy_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
221:
222: l_create_fuzzy_index2 := ' parameters ('' lexer ibe_global_lexer language column language Wordlist IBE_STEM_FUZZY_PREF '') ' ;
223: l_create_fuzzy_index := l_create_fuzzy_index1 || l_create_fuzzy_index2 ;
224: /*

Line 226: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search

222: l_create_fuzzy_index2 := ' parameters ('' lexer ibe_global_lexer language column language Wordlist IBE_STEM_FUZZY_PREF '') ' ;
223: l_create_fuzzy_index := l_create_fuzzy_index1 || l_create_fuzzy_index2 ;
224: /*
225: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
226: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
227: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
228: */
229: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
230:

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

223: l_create_fuzzy_index := l_create_fuzzy_index1 || l_create_fuzzy_index2 ;
224: /*
225: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
226: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
227: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
228: */
229: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
230:
231: l_create_index2 := ' parameters('' lexer ibe_global_lexer language column language '') ' ;

Line 229: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara

225: Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER.
226: Index creation was susscessful if schema name is prefixed e.g. IBE.ibe_ct_imedia_search
227: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ctxsys.context ' ;
228: */
229: l_create_index1 := 'create index IBE_CT_IMEDIA_SEARCH_IM on '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search(INDEXED_SEARCH) indextype is ' || l_ctxsys_user_name || '.context ' ; -- bug 13935780, scnagara
230:
231: l_create_index2 := ' parameters('' lexer ibe_global_lexer language column language '') ' ;
232: l_create_index := l_create_index1 || l_create_index2 ;
233: l_base_language := ' ';

Line 239: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';

235:
236: select count(*)
237: into l_index_exists
238: from user_indexes
239: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
240:
241:
242: DBMS_UTILITY.db_version(l_db_version_str, l_compatibility);
243: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);

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

253: then
254:
255: FND_FILE.PUT_LINE(FND_FILE.LOG,' Intermedia index exists , dropping intermedia index ');
256: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
257: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
258: end if ;
259:
260: FND_FILE.PUT_LINE(FND_FILE.LOG,' deleting data from Search table ');
261: --dbms_output.put_line(' deleting data from Search table ');

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

273: l_oracle_schema_AppInfo )) then
274: */
275:
276: if (l_return_app_info) then
277: --execute immediate 'truncate table ibe_ct_imedia_search';
278: l_trunc_tab := 'truncate table '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search';
279: execute immediate l_trunc_tab;
280: commit;
281: end if;

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

274: */
275:
276: if (l_return_app_info) then
277: --execute immediate 'truncate table ibe_ct_imedia_search';
278: l_trunc_tab := 'truncate table '||l_oracle_schema_AppInfo||'.ibe_ct_imedia_search';
279: execute immediate l_trunc_tab;
280: commit;
281: end if;
282:

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

279: execute immediate l_trunc_tab;
280: commit;
281: end if;
282:
283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');

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

281: end if;
282:
283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
288:
289: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

Line 330: INSERT INTO IBE_CT_IMEDIA_SEARCH(

326:
327: If (l_search_category_set is null and l_search_web_status='ALL')
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: If (l_search_category_set is null and l_search_web_status='ALL')
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 341: ibe_ct_imedia_search_s1.nextval,

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

Line 371: INSERT INTO IBE_CT_IMEDIA_SEARCH(

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

Line 372: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

368: (l_search_web_status='PUBLISHED' or l_search_web_status is null))
369: Then
370:
371: INSERT INTO IBE_CT_IMEDIA_SEARCH(
372: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
373: CREATED_BY,CREATION_DATE,
374: LAST_UPDATED_BY,LAST_UPDATE_DATE,
375: LAST_UPDATE_LOGIN,CATEGORY_ID,
376: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 381: (SELECT ibe_ct_imedia_search_s1.nextval,

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

Line 410: INSERT INTO IBE_CT_IMEDIA_SEARCH(

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

Line 411: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

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

Line 420: (SELECT ibe_ct_imedia_search_s1.nextval,

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

Line 449: INSERT INTO IBE_CT_IMEDIA_SEARCH(

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

Line 450: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

446: Elsif (l_search_category_set is not null and l_search_web_status='ALL')
447: Then
448:
449: INSERT INTO IBE_CT_IMEDIA_SEARCH(
450: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
451: CREATED_BY,CREATION_DATE,
452: LAST_UPDATED_BY,LAST_UPDATE_DATE,
453: LAST_UPDATE_LOGIN,CATEGORY_ID,
454: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 459: (SELECT ibe_ct_imedia_search_s1.nextval,

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

Line 488: INSERT INTO IBE_CT_IMEDIA_SEARCH(

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

Line 489: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

485: (l_search_web_status='PUBLISHED' OR l_search_web_status is null))
486: Then
487:
488: INSERT INTO IBE_CT_IMEDIA_SEARCH(
489: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
490: CREATED_BY,CREATION_DATE,
491: LAST_UPDATED_BY,LAST_UPDATE_DATE,
492: LAST_UPDATE_LOGIN,CATEGORY_ID,
493: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 498: (SELECT ibe_ct_imedia_search_s1.nextval,

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

Line 528: INSERT INTO IBE_CT_IMEDIA_SEARCH(

524:
525: Elsif (l_search_category_set is not null and l_search_web_status= 'PUBLISHED_UNPUBLISHED')
526: Then
527:
528: INSERT INTO IBE_CT_IMEDIA_SEARCH(
529: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
530: CREATED_BY,CREATION_DATE,
531: LAST_UPDATED_BY,LAST_UPDATE_DATE,
532: LAST_UPDATE_LOGIN,CATEGORY_ID,

Line 529: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,

525: Elsif (l_search_category_set is not null and l_search_web_status= 'PUBLISHED_UNPUBLISHED')
526: Then
527:
528: INSERT INTO IBE_CT_IMEDIA_SEARCH(
529: IBE_CT_IMEDIA_SEARCH_ID,OBJECT_VERSION_NUMBER,
530: CREATED_BY,CREATION_DATE,
531: LAST_UPDATED_BY,LAST_UPDATE_DATE,
532: LAST_UPDATE_LOGIN,CATEGORY_ID,
533: ORGANIZATION_ID,CATEGORY_SET_ID,

Line 538: (SELECT ibe_ct_imedia_search_s1.nextval,

534: INVENTORY_ITEM_ID,LANGUAGE,
535: DESCRIPTION,LONG_DESCRIPTION,
536: INDEXED_SEARCH,WEB_STATUS,
537: SECURITY_GROUP_ID)
538: (SELECT ibe_ct_imedia_search_s1.nextval,
539: 1,
540: FND_GLOBAL.user_id,
541: SYSDATE,
542: FND_GLOBAL.user_id,

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

650:
651:
652:
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
656: execute immediate l_create_fuzzy_index;
657:
658:

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

656: execute immediate l_create_fuzzy_index;
657:
658:
659: else
660: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
662:
663: execute immediate l_create_index;
664: