APPS.BIS_GNRL_SEARCH_ENGINE_PVT_OA dependencies on FND_PROFILE

Line 189: ' fnd_profile_options a ' ||

185:
186: dc_query := 'select distinct ' ||
187: ' b.profile_option_value || ''_'' || c.language ' ||
188: ' from ' ||
189: ' fnd_profile_options a ' ||
190: ' ,fnd_profile_option_values b' ||
191: ' ,fnd_profile_options_tl c ' ||
192: ' where ' ||
193: ' a.profile_option_name = ''ICX_DEFAULT_EUL'' and ' ||

Line 190: ' ,fnd_profile_option_values b' ||

186: dc_query := 'select distinct ' ||
187: ' b.profile_option_value || ''_'' || c.language ' ||
188: ' from ' ||
189: ' fnd_profile_options a ' ||
190: ' ,fnd_profile_option_values b' ||
191: ' ,fnd_profile_options_tl c ' ||
192: ' where ' ||
193: ' a.profile_option_name = ''ICX_DEFAULT_EUL'' and ' ||
194: ' a.profile_option_id = b.profile_option_id and ' ||

Line 191: ' ,fnd_profile_options_tl c ' ||

187: ' b.profile_option_value || ''_'' || c.language ' ||
188: ' from ' ||
189: ' fnd_profile_options a ' ||
190: ' ,fnd_profile_option_values b' ||
191: ' ,fnd_profile_options_tl c ' ||
192: ' where ' ||
193: ' a.profile_option_name = ''ICX_DEFAULT_EUL'' and ' ||
194: ' a.profile_option_id = b.profile_option_id and ' ||
195: ' a.profile_option_name = c.profile_option_name ';

Line 257: l_disco_release fnd_profile_option_values.profile_option_value%TYPE;

253: -- *************************************************************
254: FUNCTION get_disco_release
255: RETURN VARCHAR2
256: IS
257: l_disco_release fnd_profile_option_values.profile_option_value%TYPE;
258: x_release_name VARCHAR2(50);
259: x_other_release_info VARCHAR2(50);
260: l_status BOOLEAN;
261: l_major_version VARCHAR2(50);

Line 273: l_disco_release := fnd_profile.value('ICX_DISCOVERER_RELEASE');

269: RETURN '10';-- In R12 the default value is 10
270: END IF;
271: END IF;
272: --The following code will be executed only in 11i
273: l_disco_release := fnd_profile.value('ICX_DISCOVERER_RELEASE');
274: IF (l_disco_release IS NULL) THEN
275: RETURN '4';
276: END IF;
277: