APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_PROFILE_OPTION_VALUES

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 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 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