DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on FND_PROFILE

Line 123: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

119: --
120: -- Obtain all the data for use in the message.
121: --
122: --Commented for Bug 6004149
123: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
124:
125: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
126: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
127: ||fnd_profile.value('ICX_PREFIX'),'/');

Line 126: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)

122: --Commented for Bug 6004149
123: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
124:
125: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
126: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
127: ||fnd_profile.value('ICX_PREFIX'),'/');
128: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
129: else
130: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

Line 127: ||fnd_profile.value('ICX_PREFIX'),'/');

123: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
124:
125: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
126: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
127: ||fnd_profile.value('ICX_PREFIX'),'/');
128: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
129: else
130: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
131: ||fnd_profile.value('ICX_PREFIX'),'/');

Line 130: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

126: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
127: ||fnd_profile.value('ICX_PREFIX'),'/');
128: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
129: else
130: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
131: ||fnd_profile.value('ICX_PREFIX'),'/');
132: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
133: end if;
134: --

Line 131: ||fnd_profile.value('ICX_PREFIX'),'/');

127: ||fnd_profile.value('ICX_PREFIX'),'/');
128: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
129: else
130: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
131: ||fnd_profile.value('ICX_PREFIX'),'/');
132: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
133: end if;
134: --
135: if l_base_url is null then

Line 277: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

273: --
274: -- Obtain all the data for use in the message.
275: --
276: --Commented for Bug 6004149
277: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
278: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
279: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
280: ||fnd_profile.value('ICX_PREFIX'),'/');
281: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');

Line 279: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)

275: --
276: --Commented for Bug 6004149
277: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
278: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
279: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
280: ||fnd_profile.value('ICX_PREFIX'),'/');
281: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
282: else
283: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

Line 280: ||fnd_profile.value('ICX_PREFIX'),'/');

276: --Commented for Bug 6004149
277: --l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
278: if (irc_utilities_pkg.is_internal_person(p_person_id,p_effective_date)='TRUE') then
279: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
280: ||fnd_profile.value('ICX_PREFIX'),'/');
281: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
282: else
283: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
284: ||fnd_profile.value('ICX_PREFIX'),'/');

Line 283: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

279: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
280: ||fnd_profile.value('ICX_PREFIX'),'/');
281: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
282: else
283: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
284: ||fnd_profile.value('ICX_PREFIX'),'/');
285: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
286: end if;
287: --

Line 284: ||fnd_profile.value('ICX_PREFIX'),'/');

280: ||fnd_profile.value('ICX_PREFIX'),'/');
281: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('Y');
282: else
283: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
284: ||fnd_profile.value('ICX_PREFIX'),'/');
285: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
286: end if;
287: --
288: if l_base_url is null then

Line 397: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)

393: from fnd_languages_vl
394: where language_code = p_dft_lang;
395:
396: cursor get_user_lang(p_user_name varchar2) is
397: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
398: from fnd_user usr
399: where usr.user_name = p_user_name;
400: --- End Added for 14500909
401: begin