eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_PROFILE

Line 20: , FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id) lang_pref

16: IS
17: SELECT inp.person_id
18: , per.party_id
19: , to_number(inp.matching_job_freq) show_jobs_since
20: , FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id) lang_pref
21: FROM irc_notification_preferences inp
22: , per_all_people_f per
23: , fnd_user usr
24: WHERE inp.matching_jobs = 'Y'

Line 402: l_function_name fnd_profile_option_values.profile_option_value%type;

398: l_job_content VARCHAR2(15599);
399: l_length NUMBER;
400: l_available_size NUMBER := 13500;
401: l_break VARCHAR2(10) := '
';
402: l_function_name fnd_profile_option_values.profile_option_value%type;
403: l_resp_key fnd_responsibility.responsibility_key%type;
404: l_resp_id fnd_responsibility.responsibility_id%type;
405: --
406: BEGIN

Line 414: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value_specific(name =>'IRC_FRAMEWORK_AGENT',responsibility_id => l_resp_id),fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0))

410: SELECT responsibility_id into l_resp_id
411: FROM fnd_responsibility
412: WHERE responsibility_key = l_resp_key;
413:
414: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value_specific(name =>'IRC_FRAMEWORK_AGENT',responsibility_id => l_resp_id),fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0))
415: ||fnd_profile.value('ICX_PREFIX'),'/');
416: l_function_name := get_job_notification_function('Y');
417: ELSE
418: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

411: FROM fnd_responsibility
412: WHERE responsibility_key = l_resp_key;
413:
414: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value_specific(name =>'IRC_FRAMEWORK_AGENT',responsibility_id => l_resp_id),fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0))
415: ||fnd_profile.value('ICX_PREFIX'),'/');
416: l_function_name := get_job_notification_function('Y');
417: ELSE
418: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
419: ||fnd_profile.value('ICX_PREFIX'),'/');

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

414: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value_specific(name =>'IRC_FRAMEWORK_AGENT',responsibility_id => l_resp_id),fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0))
415: ||fnd_profile.value('ICX_PREFIX'),'/');
416: l_function_name := get_job_notification_function('Y');
417: ELSE
418: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
419: ||fnd_profile.value('ICX_PREFIX'),'/');
420: l_function_name := get_job_notification_function('N');
421: END IF;
422: --commented in bug fix 6004149.

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

415: ||fnd_profile.value('ICX_PREFIX'),'/');
416: l_function_name := get_job_notification_function('Y');
417: ELSE
418: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
419: ||fnd_profile.value('ICX_PREFIX'),'/');
420: l_function_name := get_job_notification_function('N');
421: END IF;
422: --commented in bug fix 6004149.
423: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

Line 423: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

419: ||fnd_profile.value('ICX_PREFIX'),'/');
420: l_function_name := get_job_notification_function('N');
421: END IF;
422: --commented in bug fix 6004149.
423: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
424:
425: -- Loop through the suitable jobs and and list them.
426: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION') || l_break;
427: l_job_html_end := l_break || l_break || '

' || get_conclusion_msg(

Line 519: l_function_name fnd_profile_option_values.profile_option_value%type;

515: l_job_content VARCHAR2(15599);
516: l_length NUMBER;
517: l_available_size NUMBER := 13500;
518: l_new_line VARCHAR2(10) := '\n';
519: l_function_name fnd_profile_option_values.profile_option_value%type;
520: --
521: BEGIN
522: --
523: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN

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

520: --
521: BEGIN
522: --
523: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN
524: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
525: ||fnd_profile.value('ICX_PREFIX'),'/');
526: l_function_name := get_job_notification_function('Y');
527: ELSE
528: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

521: BEGIN
522: --
523: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN
524: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
525: ||fnd_profile.value('ICX_PREFIX'),'/');
526: l_function_name := get_job_notification_function('Y');
527: ELSE
528: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
529: ||fnd_profile.value('ICX_PREFIX'),'/');

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

524: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
525: ||fnd_profile.value('ICX_PREFIX'),'/');
526: l_function_name := get_job_notification_function('Y');
527: ELSE
528: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
529: ||fnd_profile.value('ICX_PREFIX'),'/');
530: l_function_name := get_job_notification_function('N');
531: END IF;
532: --commented in bug fix 6004149.

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

525: ||fnd_profile.value('ICX_PREFIX'),'/');
526: l_function_name := get_job_notification_function('Y');
527: ELSE
528: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
529: ||fnd_profile.value('ICX_PREFIX'),'/');
530: l_function_name := get_job_notification_function('N');
531: END IF;
532: --commented in bug fix 6004149.
533: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

Line 533: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

529: ||fnd_profile.value('ICX_PREFIX'),'/');
530: l_function_name := get_job_notification_function('N');
531: END IF;
532: --commented in bug fix 6004149.
533: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
534: -- Loop through the suitable jobs and and list them.
535: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT') || l_new_line;
536: l_job_text_end := l_new_line ||get_conclusion_msg(
537: p_message_text =>fnd_message.get_string('PER','IRC_412619_JOB_CONCL_TEXT')

Line 608: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');

604: l_new_html varchar2(30000);
605: l_url varchar2(4000);
606: l_max_length number;
607: BEGIN
608: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
609: if substr(l_url,-1,1)<>'/' then
610: l_url:=l_url||'/';
611: end if;
612: if fnd_profile.value('ICX_PREFIX') is not null then

Line 612: if fnd_profile.value('ICX_PREFIX') is not null then

608: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
609: if substr(l_url,-1,1)<>'/' then
610: l_url:=l_url||'/';
611: end if;
612: if fnd_profile.value('ICX_PREFIX') is not null then
613: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
614: else
615: l_url:=l_url||'OA_HTML/';
616: end if;

Line 613: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';

609: if substr(l_url,-1,1)<>'/' then
610: l_url:=l_url||'/';
611: end if;
612: if fnd_profile.value('ICX_PREFIX') is not null then
613: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
614: else
615: l_url:=l_url||'OA_HTML/';
616: end if;
617: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

Line 617: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

613: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
614: else
615: l_url:=l_url||'OA_HTML/';
616: end if;
617: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
618: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
619: -- Loop through the suitable jobs and and list them.
620: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
621: || '
';

Line 656: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');

652: l_new_text VARCHAR2(30000);
653: l_url varchar2(4000);
654: l_max_length number;
655: BEGIN
656: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
657: if substr(l_url,-1,1)<>'/' then
658: l_url:=l_url||'/';
659: end if;
660: if fnd_profile.value('ICX_PREFIX') is not null then

Line 660: if fnd_profile.value('ICX_PREFIX') is not null then

656: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
657: if substr(l_url,-1,1)<>'/' then
658: l_url:=l_url||'/';
659: end if;
660: if fnd_profile.value('ICX_PREFIX') is not null then
661: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
662: else
663: l_url:=l_url||'OA_HTML/';
664: end if;

Line 661: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';

657: if substr(l_url,-1,1)<>'/' then
658: l_url:=l_url||'/';
659: end if;
660: if fnd_profile.value('ICX_PREFIX') is not null then
661: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
662: else
663: l_url:=l_url||'OA_HTML/';
664: end if;
665: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

Line 665: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

661: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
662: else
663: l_url:=l_url||'OA_HTML/';
664: end if;
665: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
666: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
667: -- Loop through the suitable jobs and and list them.
668: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
669: || '\n';

Line 782: l_function_name fnd_profile_option_values.profile_option_value%type;

778: WHERE responsibility_key = resp_key;
779:
780: l_resp_key fnd_responsibility.responsibility_key%type;
781: l_resp_id fnd_responsibility.responsibility_id%type;
782: l_function_name fnd_profile_option_values.profile_option_value%type;
783: BEGIN
784:
785: if(lower(p_is_internal) = 'y')
786: then

Line 796: l_function_name := fnd_profile.value_specific

792: open csr_get_resp_id(l_resp_key);
793: fetch csr_get_resp_id into l_resp_id ;
794: close csr_get_resp_id;
795:
796: l_function_name := fnd_profile.value_specific
797: (name => 'IRC_JOB_NOTIFICATION_URL'
798: ,responsibility_id => l_resp_id);
799: return l_function_name;
800:

Line 804: l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

800:
801: EXCEPTION
802: WHEN NO_DATA_FOUND
803: THEN
804: l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
805: return l_function_name;
806: END get_job_notification_function;
807: --
808: -- ----------------------------------------------------------------------------

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

879: --
880: -- If the base URL isn't set up, it is futile performing a job search
881: -- as the URL for the seekers to click on won't work.
882: --
883: l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
884: IF l_base_url IS NULL THEN
885: hr_utility.set_location('base_url is null', 20);
886: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
887: RAISE e_no_base_url;

Line 890: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');

886: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
887: RAISE e_no_base_url;
888: END IF;
889:
890: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
891:
892: --
893: -- ***************************************************************************
894: -- Inner SQL to match the Job Seeker criteria to Vacancies

Line 1559: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');

1555: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1556: BEGIN
1557: hr_utility.set_location('Entering'||l_proc, 10);
1558: --
1559: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
1560: --
1561: if (p_candidacy_age>0) then
1562: l_date_registered:=trunc(sysdate)-p_candidacy_age;
1563: else

Line 1826: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');

1822: statement => l_sql,
1823: language_flag => dbms_sql.native);
1824:
1825:
1826: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
1827: IF l_base_url IS NULL THEN
1828: hr_utility.set_location(l_proc, 20);
1829: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');
1830: RAISE e_no_base_url;

Line 2204: l_apps_fwk_agent := fnd_profile.value_specific('APPS_FRAMEWORK_AGENT');

2200: (p_person_id=> p_person_id,
2201: p_eff_date => trunc(sysdate)
2202: );
2203: if (l_isInternalPerson ='TRUE') then
2204: l_apps_fwk_agent := fnd_profile.value_specific('APPS_FRAMEWORK_AGENT');
2205: else
2206: l_apps_fwk_agent := nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
2207: fnd_profile.value('APPS_FRAMEWORK_AGENT'));
2208: end if;

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

2202: );
2203: if (l_isInternalPerson ='TRUE') then
2204: l_apps_fwk_agent := fnd_profile.value_specific('APPS_FRAMEWORK_AGENT');
2205: else
2206: l_apps_fwk_agent := nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
2207: fnd_profile.value('APPS_FRAMEWORK_AGENT'));
2208: end if;
2209: --
2210: l_url := l_apps_fwk_agent;

Line 2207: fnd_profile.value('APPS_FRAMEWORK_AGENT'));

2203: if (l_isInternalPerson ='TRUE') then
2204: l_apps_fwk_agent := fnd_profile.value_specific('APPS_FRAMEWORK_AGENT');
2205: else
2206: l_apps_fwk_agent := nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
2207: fnd_profile.value('APPS_FRAMEWORK_AGENT'));
2208: end if;
2209: --
2210: l_url := l_apps_fwk_agent;
2211: --

Line 2216: if fnd_profile.value('ICX_PREFIX') is not null then

2212: if substr(l_url,-1,1)<>'/' then
2213: l_url:=l_url||'/';
2214: end if;
2215: --
2216: if fnd_profile.value('ICX_PREFIX') is not null then
2217: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
2218: else
2219: l_url:=l_url||'OA_HTML/';
2220: end if;

Line 2217: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';

2213: l_url:=l_url||'/';
2214: end if;
2215: --
2216: if fnd_profile.value('ICX_PREFIX') is not null then
2217: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
2218: else
2219: l_url:=l_url||'OA_HTML/';
2220: end if;
2221: --