APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_PROFILE

Line 121: (fnd_profile.VALUE('IRC_OFFER_SEND_METHOD'))) extended_method

117: (p_number_of_days in number)
118: IS
119: select iof.offer_id
120: ,nvl((iof.offer_extended_method),
121: (fnd_profile.VALUE('IRC_OFFER_SEND_METHOD'))) extended_method
122: ,iof.applicant_assignment_id
123: ,vac.name as vacancy_name
124: ,vac.manager_id as manager_id
125: ,job.name as job_title

Line 228: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')

224: l_url varchar2(4000);
225: l_apps_fwk_agent varchar2(2000);
226: BEGIN
227: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
228: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
229: ||fnd_profile.value('ICX_PREFIX'),'/');
230: else
231: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

225: l_apps_fwk_agent varchar2(2000);
226: BEGIN
227: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
228: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
229: ||fnd_profile.value('ICX_PREFIX'),'/');
230: else
231: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
233: ||fnd_profile.value('ICX_PREFIX'),'/');

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

227: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
228: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
229: ||fnd_profile.value('ICX_PREFIX'),'/');
230: else
231: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
233: ||fnd_profile.value('ICX_PREFIX'),'/');
234: end if;
235:

Line 232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))

228: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
229: ||fnd_profile.value('ICX_PREFIX'),'/');
230: else
231: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
233: ||fnd_profile.value('ICX_PREFIX'),'/');
234: end if;
235:
236: l_url:=l_apps_fwk_agent

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

229: ||fnd_profile.value('ICX_PREFIX'),'/');
230: else
231: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
232: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
233: ||fnd_profile.value('ICX_PREFIX'),'/');
234: end if;
235:
236: l_url:=l_apps_fwk_agent
237: ||'/OA_HTML/OA.jsp?OAFunc='

Line 238: ||fnd_profile.value('IRC_VIEW_OFFER_DETAILS_FUNC')

234: end if;
235:
236: l_url:=l_apps_fwk_agent
237: ||'/OA_HTML/OA.jsp?OAFunc='
238: ||fnd_profile.value('IRC_VIEW_OFFER_DETAILS_FUNC')
239: ||'&addBreadCrumb=Y'
240: ||'&retainAM=Y&p_aplid='||to_char(p_apl_asg_id);
241: RETURN l_url;
242: END get_view_offer_url;

Line 256: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')

252: IS
253: l_url varchar2(4000);
254: l_apps_fwk_agent varchar2(2000);
255: BEGIN
256: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
257: ||fnd_profile.value('ICX_PREFIX'),'/');
258:
259: l_url:=l_apps_fwk_agent
260: ||'/OA_HTML/OA.jsp?OAFunc='

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

253: l_url varchar2(4000);
254: l_apps_fwk_agent varchar2(2000);
255: BEGIN
256: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
257: ||fnd_profile.value('ICX_PREFIX'),'/');
258:
259: l_url:=l_apps_fwk_agent
260: ||'/OA_HTML/OA.jsp?OAFunc='
261: ||fnd_profile.value('IRC_EXTEND_OFFER_DURATION_FUNC')

Line 261: ||fnd_profile.value('IRC_EXTEND_OFFER_DURATION_FUNC')

257: ||fnd_profile.value('ICX_PREFIX'),'/');
258:
259: l_url:=l_apps_fwk_agent
260: ||'/OA_HTML/OA.jsp?OAFunc='
261: ||fnd_profile.value('IRC_EXTEND_OFFER_DURATION_FUNC')
262: ||'&addBreadCrumb=Y'
263: ||'&retainAM=Y&p_sofferid='||to_char(p_offer_id);
264: RETURN l_url;
265: END get_extend_offer_duration_url;

Line 403: if (fnd_profile.value('IRC_OFFER_SEND_METHOD')='SYSTEM') then

399:
400: l_html_body := l_html_body
401: || '
' || l_note_text;
402:
403: if (fnd_profile.value('IRC_OFFER_SEND_METHOD')='SYSTEM') then
404: l_html_body := l_html_body
405: || '

'
407: || 'View Offer'