APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_PROFILE

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

123: (p_number_of_days in number)
124: IS
125: select iof.offer_id
126: ,nvl((iof.offer_extended_method),
127: (fnd_profile.VALUE('IRC_OFFER_SEND_METHOD'))) extended_method
128: ,iof.applicant_assignment_id
129: ,vac.name as vacancy_name
130: ,vac.manager_id as manager_id
131: ,job.name as job_title

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

231: from fnd_languages_vl
232: where language_code = p_dft_lang;
233: --
234: cursor get_user_lang(l_applicant_id number) is
235: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
236: from fnd_user usr
237: where EMPLOYEE_ID = l_applicant_id;
238: -- ----------------------------------------------------------------------------
239: -- FUNCTIONS

Line 259: l_function_name fnd_profile_option_values.profile_option_value%type;

255: l_resp_key fnd_responsibility.responsibility_key%type;
256: l_resp_id fnd_responsibility.responsibility_id%type;
257: l_apl_id fnd_application.application_id%type;
258: l_apl_asg_id per_all_assignments_f.assignment_id%type;
259: l_function_name fnd_profile_option_values.profile_option_value%type;
260: --
261: --
262: CURSOR csr_get_apl_id (apl_short_name varchar2)
263: IS

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

282: --
283: l_apl_asg_id := p_apl_asg_id;
284: --
285: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
286: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
287: ||fnd_profile.value('ICX_PREFIX'),'/');
288: l_resp_key := 'IRC_EMP_CANDIDATE';
289: else
290: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),

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

283: l_apl_asg_id := p_apl_asg_id;
284: --
285: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
286: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
287: ||fnd_profile.value('ICX_PREFIX'),'/');
288: l_resp_key := 'IRC_EMP_CANDIDATE';
289: else
290: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
291: fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

286: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
287: ||fnd_profile.value('ICX_PREFIX'),'/');
288: l_resp_key := 'IRC_EMP_CANDIDATE';
289: else
290: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
291: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
292: ||fnd_profile.value('ICX_PREFIX'),'/');
293: l_resp_key := 'IRC_EXT_CANDIDATE';
294: end if;

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

287: ||fnd_profile.value('ICX_PREFIX'),'/');
288: l_resp_key := 'IRC_EMP_CANDIDATE';
289: else
290: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
291: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
292: ||fnd_profile.value('ICX_PREFIX'),'/');
293: l_resp_key := 'IRC_EXT_CANDIDATE';
294: end if;
295: --

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

288: l_resp_key := 'IRC_EMP_CANDIDATE';
289: else
290: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
291: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
292: ||fnd_profile.value('ICX_PREFIX'),'/');
293: l_resp_key := 'IRC_EXT_CANDIDATE';
294: end if;
295: --
296: open csr_get_apl_id('PER');

Line 304: l_function_name := fnd_profile.value_specific

300: open csr_get_resp_id(l_resp_key,l_apl_id);
301: fetch csr_get_resp_id into l_resp_id ;
302: close csr_get_resp_id;
303: --
304: l_function_name := fnd_profile.value_specific
305: (name => 'IRC_VIEW_OFFER_DETAILS_FUNC'
306: ,responsibility_id => l_resp_id
307: ,application_id => l_apl_id);
308: --

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

345: l_funcId number;
346: l_apl_asg_id per_all_assignments_f.assignment_id%type;
347: BEGIN
348: l_apl_asg_id := p_apl_asg_id;
349: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
350: ||fnd_profile.value('ICX_PREFIX'),'/');
351: --
352: l_apps_fwk_agent := l_apps_fwk_agent ||'/OA_HTML';
353: --

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

346: l_apl_asg_id per_all_assignments_f.assignment_id%type;
347: BEGIN
348: l_apl_asg_id := p_apl_asg_id;
349: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
350: ||fnd_profile.value('ICX_PREFIX'),'/');
351: --
352: l_apps_fwk_agent := l_apps_fwk_agent ||'/OA_HTML';
353: --
354: open c_func('IRC_RELAUNCH_PG');

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

385: IS
386: l_url varchar2(4000);
387: l_apps_fwk_agent varchar2(2000);
388: BEGIN
389: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
390: ||fnd_profile.value('ICX_PREFIX'),'/');
391:
392: l_url:=l_apps_fwk_agent
393: ||'/OA_HTML/OA.jsp?OAFunc='

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

386: l_url varchar2(4000);
387: l_apps_fwk_agent varchar2(2000);
388: BEGIN
389: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
390: ||fnd_profile.value('ICX_PREFIX'),'/');
391:
392: l_url:=l_apps_fwk_agent
393: ||'/OA_HTML/OA.jsp?OAFunc='
394: ||fnd_profile.value('IRC_EXTEND_OFFER_DURATION_FUNC')

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

390: ||fnd_profile.value('ICX_PREFIX'),'/');
391:
392: l_url:=l_apps_fwk_agent
393: ||'/OA_HTML/OA.jsp?OAFunc='
394: ||fnd_profile.value('IRC_EXTEND_OFFER_DURATION_FUNC')
395: ||'&addBreadCrumb=Y'
396: ||'&retainAM=Y&p_sofferid='||to_char(p_offer_id);
397: RETURN l_url;
398: END get_extend_offer_duration_url;

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

560:
561: l_html_body := l_html_body
562: || '
' || l_note_text;
563:
564: if (fnd_profile.value('IRC_OFFER_SEND_METHOD')='SYSTEM') then
565: l_html_body := l_html_body
566: || '

'
568: || 'View Offer'