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 362: l_function_name fnd_profile_option_values.profile_option_value%type;

358: l_return_job_html VARCHAR2(15599);
359: l_brief_description_clob CLOB;
360: l_brief_description_v2 Varchar2(240) default '';
361: l_apps_fwk_agent VARCHAR2(2000);
362: l_function_name fnd_profile_option_values.profile_option_value%type;
363: BEGIN
364:
365: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
366: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)

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

362: l_function_name fnd_profile_option_values.profile_option_value%type;
363: BEGIN
364:
365: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
366: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
367: ||fnd_profile.value('ICX_PREFIX'),'/');
368: l_function_name := get_job_notification_function('Y');
369: else
370: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

363: BEGIN
364:
365: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
366: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
367: ||fnd_profile.value('ICX_PREFIX'),'/');
368: l_function_name := get_job_notification_function('Y');
369: else
370: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
371: ||fnd_profile.value('ICX_PREFIX'),'/');

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

366: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
367: ||fnd_profile.value('ICX_PREFIX'),'/');
368: l_function_name := get_job_notification_function('Y');
369: else
370: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
371: ||fnd_profile.value('ICX_PREFIX'),'/');
372: l_function_name := get_job_notification_function('N');
373: end if;
374: --commented in bug fix 6004149.

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

367: ||fnd_profile.value('ICX_PREFIX'),'/');
368: l_function_name := get_job_notification_function('Y');
369: else
370: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
371: ||fnd_profile.value('ICX_PREFIX'),'/');
372: l_function_name := get_job_notification_function('N');
373: end if;
374: --commented in bug fix 6004149.
375: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

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

371: ||fnd_profile.value('ICX_PREFIX'),'/');
372: l_function_name := get_job_notification_function('N');
373: end if;
374: --commented in bug fix 6004149.
375: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
376:
377: -- Loop through the suitable jobs and and list them.
378: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION')
379: || '
';

Line 458: l_function_name fnd_profile_option_values.profile_option_value%type;

454: l_return_job_text VARCHAR2(15599);
455: l_brief_description_clob CLOB;
456: l_brief_description_v2 Varchar2(240) default '';
457: l_apps_fwk_agent VARCHAR2(2000);
458: l_function_name fnd_profile_option_values.profile_option_value%type;
459: BEGIN
460:
461: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
462: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)

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

458: l_function_name fnd_profile_option_values.profile_option_value%type;
459: BEGIN
460:
461: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
462: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
463: ||fnd_profile.value('ICX_PREFIX'),'/');
464: l_function_name := get_job_notification_function('Y');
465: else
466: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))

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

459: BEGIN
460:
461: if (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') then
462: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
463: ||fnd_profile.value('ICX_PREFIX'),'/');
464: l_function_name := get_job_notification_function('Y');
465: else
466: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
467: ||fnd_profile.value('ICX_PREFIX'),'/');

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

462: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',0,0,0,0,0)
463: ||fnd_profile.value('ICX_PREFIX'),'/');
464: l_function_name := get_job_notification_function('Y');
465: else
466: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
467: ||fnd_profile.value('ICX_PREFIX'),'/');
468: l_function_name := get_job_notification_function('N');
469: end if;
470: --commented in bug fix 6004149.

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

463: ||fnd_profile.value('ICX_PREFIX'),'/');
464: l_function_name := get_job_notification_function('Y');
465: else
466: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),fnd_profile.value('APPS_FRAMEWORK_AGENT'))
467: ||fnd_profile.value('ICX_PREFIX'),'/');
468: l_function_name := get_job_notification_function('N');
469: end if;
470: --commented in bug fix 6004149.
471: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');

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

467: ||fnd_profile.value('ICX_PREFIX'),'/');
468: l_function_name := get_job_notification_function('N');
469: end if;
470: --commented in bug fix 6004149.
471: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
472: -- Loop through the suitable jobs and and list them.
473: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT')
474: || '\n';
475: l_job_text_end := '\n' ||

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

535: l_new_html varchar2(30000);
536: l_url varchar2(4000);
537: l_max_length number;
538: BEGIN
539: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
540: if substr(l_url,-1,1)<>'/' then
541: l_url:=l_url||'/';
542: end if;
543: if fnd_profile.value('ICX_PREFIX') is not null then

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

539: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
540: if substr(l_url,-1,1)<>'/' then
541: l_url:=l_url||'/';
542: end if;
543: if fnd_profile.value('ICX_PREFIX') is not null then
544: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
545: else
546: l_url:=l_url||'OA_HTML/';
547: end if;

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

540: if substr(l_url,-1,1)<>'/' then
541: l_url:=l_url||'/';
542: end if;
543: if fnd_profile.value('ICX_PREFIX') is not null then
544: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
545: else
546: l_url:=l_url||'OA_HTML/';
547: end if;
548: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

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

544: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
545: else
546: l_url:=l_url||'OA_HTML/';
547: end if;
548: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
549: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
550: -- Loop through the suitable jobs and and list them.
551: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
552: || '
';

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

583: l_new_text VARCHAR2(30000);
584: l_url varchar2(4000);
585: l_max_length number;
586: BEGIN
587: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
588: if substr(l_url,-1,1)<>'/' then
589: l_url:=l_url||'/';
590: end if;
591: if fnd_profile.value('ICX_PREFIX') is not null then

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

587: l_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT');
588: if substr(l_url,-1,1)<>'/' then
589: l_url:=l_url||'/';
590: end if;
591: if fnd_profile.value('ICX_PREFIX') is not null then
592: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
593: else
594: l_url:=l_url||'OA_HTML/';
595: end if;

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

588: if substr(l_url,-1,1)<>'/' then
589: l_url:=l_url||'/';
590: end if;
591: if fnd_profile.value('ICX_PREFIX') is not null then
592: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
593: else
594: l_url:=l_url||'OA_HTML/';
595: end if;
596: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')

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

592: l_url:=l_url||fnd_profile.value('ICX_PREFIX')||'/OA_HTML/';
593: else
594: l_url:=l_url||'OA_HTML/';
595: end if;
596: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
597: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
598: -- Loop through the suitable jobs and and list them.
599: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
600: || '\n';

Line 713: l_function_name fnd_profile_option_values.profile_option_value%type;

709: WHERE responsibility_key = resp_key;
710:
711: l_resp_key fnd_responsibility.responsibility_key%type;
712: l_resp_id fnd_responsibility.responsibility_id%type;
713: l_function_name fnd_profile_option_values.profile_option_value%type;
714: BEGIN
715:
716: if(lower(p_is_internal) = 'y')
717: then

Line 727: l_function_name := fnd_profile.value_specific

723: open csr_get_resp_id(l_resp_key);
724: fetch csr_get_resp_id into l_resp_id ;
725: close csr_get_resp_id;
726:
727: l_function_name := fnd_profile.value_specific
728: (name => 'IRC_JOB_NOTIFICATION_URL'
729: ,responsibility_id => l_resp_id);
730: return l_function_name;
731:

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

731:
732: EXCEPTION
733: WHEN NO_DATA_FOUND
734: THEN
735: l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
736: return l_function_name;
737: END get_job_notification_function;
738: --
739: -- ----------------------------------------------------------------------------

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

804:
805: -- If the base URL isn't set up, it is futile performing a job search
806: -- as the URL for the seekers to click on won't work.
807: --
808: l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
809: IF l_base_url IS NULL THEN
810: hr_utility.set_location('base_url is null', 20);
811: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
812: RAISE e_no_base_url;

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

811: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
812: RAISE e_no_base_url;
813: END IF;
814:
815: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
816:
817: --
818: -- ***************************************************************************
819: -- Inner SQL to match the Job Seeker criteria to Vacancies

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

1374: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1375: BEGIN
1376: hr_utility.set_location('Entering'||l_proc, 10);
1377: --
1378: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
1379: --
1380: if (p_candidacy_age>0) then
1381: l_date_registered:=trunc(sysdate)-p_candidacy_age;
1382: else

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

1565: statement => l_sql,
1566: language_flag => dbms_sql.native);
1567:
1568:
1569: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
1570: IF l_base_url IS NULL THEN
1571: hr_utility.set_location(l_proc, 20);
1572: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');
1573: RAISE e_no_base_url;