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'),'/');
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'))
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'),'/');
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: --
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
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');
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'))
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'),'/');
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: --
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
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