DBA Data[Home] [Help]

APPS.IBE_SEARCHUPDATE_PVT dependencies on FND_PROFILE

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

371: -- ========= ab start =============================================
372:
373: --Original Section Refresh logic in the program, including populating ibe_section_search table and refresh materialized view ibe_sct_search_mv;
374: --Get category search profile setting IBE_USE_CATEGORY_SEARCH;
375: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
376:
377: If l_use_category_search='N' Then
378: l_tmp:=0;
379: ----dbms_output.put_line('category search is N');

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

378: l_tmp:=0;
379: ----dbms_output.put_line('category search is N');
380:
381: --Get search category set profile setting IBE_SEARCH_CATEGORY_SET;
382: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
383: ----dbms_output.put_line('search category set value='||l_search_category_set);
384: If (l_search_category_set is not null) Then
385: INSERT INTO ibe_ct_imedia_search
386: (IBE_CT_IMEDIA_SEARCH_ID,