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_PVT dependencies on FND_PROFILE

Line 64: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

60: --||':new_inventory_item_id='||new_inventory_item_id
61: --||':new_organization_id ='||new_organization_id);
62:
63: --Get IBE_SEARCH_CATEGORY_SET Profile value
64: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
65: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
66: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
67: --Get product status profile IBE_SEARCH_WEB_STATUS;
68: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

Line 66: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);

62:
63: --Get IBE_SEARCH_CATEGORY_SET Profile value
64: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
65: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
66: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
67: --Get product status profile IBE_SEARCH_WEB_STATUS;
68: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
69:
70: --dbms_output.put_line('use_category_search='||l_use_category_search

Line 68: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

64: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
65: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
66: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
67: --Get product status profile IBE_SEARCH_WEB_STATUS;
68: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
69:
70: --dbms_output.put_line('use_category_search='||l_use_category_search
71: --||'search_category_set='||l_search_category_set||':search_web_status='||l_search_web_status);
72:

Line 88: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

84: IF (l_insert_flag) THEN
85: --dbms_output.put_line('l_insert_flag=true');
86:
87: --Get IBE_SEARCH_WEB_STATUS profile value
88: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
89:
90: IF l_search_web_status = 'PUBLISHED' or l_search_web_status is NULL THEN
91:
92: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED/NULL');

Line 260: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);

256:
257: ELSE -- the old and new category set ids are different-------------
258:
259: --Get IBE_SEARCH_CATEGORY_SET Profile value
260: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
261: ----dbms_output.put_line('Search category set='||l_search_category_set);
262: IF l_search_category_set is NULL THEN
263: ------dbms_output.put_line('Updating data :search category set is null');
264: update ibe_ct_imedia_search c

Line 282: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

278: IF old_category_set_id = l_search_category_set THEN
279: ----dbms_output.put_line('Deleting row:old category set id = l_search category set');
280:
281: --------------enhancement -check for section search -------------
282: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
283:
284: IF l_use_category_search ='N' then --profile set for section search
285: -- check whether item associated to some section
286: OPEN c_check_section_item_csr(old_inventory_item_id,old_organization_id);

Line 326: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

322: --Insert item into ibe_ct_imedia_search table based on the new value and IBE_SEARCH_WEB_STATUS profile value;
323:
324: select web_status into l_web_status from mtl_system_items_b
325: where inventory_item_id=new_inventory_item_id and organization_id= new_organization_id;
326: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
327:
328: ----dbms_output.put_line('l_web_status='||l_web_status||':search web status='||l_search_web_status);
329:
330: if ( l_search_web_status ='ALL'

Line 403: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);

399: l_item_exists_count NUMBER := 0 ;
400:
401: begin
402: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
403: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
404: -- Check if item is under the category set specified by IBE_SEARCH_CATEGORY_SET
405: if l_search_category_set is not null then
406: select 1 into l_item_exists_count from mtl_item_categories
407: where inventory_item_id = p_inventory_item_id and

Line 445: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

441: --||':oldWebStatus='||old_web_status
442: --||':newWebStatus='||new_web_status);
443:
444: --Get IBE_SEARCH_WEB_STATUS Profile value
445: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
446:
447: IF l_search_web_status='ALL' THEN
448: --dbms_output.put_line('updating data;Web status =ALL');
449: update ibe_ct_imedia_search

Line 662: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

658: --||':new_long_description='||new_long_description);
659:
660: l_insert_flag := FALSE;
661: --Get IBE_SEARCH_CATEGORY_SET Profile value
662: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
663:
664: ----dbms_output.put_line('l_use_category_search='||l_use_category_search);
665:
666: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);

Line 666: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);

662: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
663:
664: ----dbms_output.put_line('l_use_category_search='||l_use_category_search);
665:
666: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
667:
668: ----dbms_output.put_line('l_search_category_set='||l_search_category_set);
669:
670: IF l_search_category_set is not null then

Line 704: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

700: IF (l_insert_flag) THEN
701:
702: ----dbms_output.put_line('l_insert_flag=true');
703: --Get IBE_SEARCH_WEB_STATUS profile value
704: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
705:
706: ----dbms_output.put_line('l_search_web_status='||l_search_web_status);
707:
708: IF l_search_web_status = 'PUBLISHED' THEN