APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_RESPONSIBILITY

Line 403: l_resp_key fnd_responsibility.responsibility_key%type;

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

Line 404: l_resp_id fnd_responsibility.responsibility_id%type;

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
407: --
408: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN

Line 411: FROM fnd_responsibility

407: --
408: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN
409: l_resp_key := 'IRC_EMP_CANDIDATE';
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'),'/');

Line 777: FROM fnd_responsibility

773: IS
774: CURSOR csr_get_resp_id (resp_key varchar2)
775: IS
776: SELECT responsibility_id
777: FROM fnd_responsibility
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;

Line 780: l_resp_key fnd_responsibility.responsibility_key%type;

776: SELECT responsibility_id
777: FROM fnd_responsibility
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:

Line 781: l_resp_id fnd_responsibility.responsibility_id%type;

777: FROM fnd_responsibility
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')