DBA Data[Home] [Help]

APPS.BIS_PMV_UTIL dependencies on FND_RESPONSIBILITY

Line 628: l_resp_id fnd_responsibility.responsibility_id%TYPE;

624: function getDefaultResponsibility(pUserId in varchar2
625: , pFunctionName in varchar2
626: , pCheckPMVSpecific in varchar2 default 'N')
627: return varchar2 IS
628: l_resp_id fnd_responsibility.responsibility_id%TYPE;
629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;

Line 629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;

625: , pFunctionName in varchar2
626: , pCheckPMVSpecific in varchar2 default 'N')
627: return varchar2 IS
628: l_resp_id fnd_responsibility.responsibility_id%TYPE;
629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;

Line 630: l_appl_id fnd_responsibility.application_id%TYPE;

626: , pCheckPMVSpecific in varchar2 default 'N')
627: return varchar2 IS
628: l_resp_id fnd_responsibility.responsibility_id%TYPE;
629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS

Line 632: l_menu_id fnd_responsibility.menu_id%TYPE;

628: l_resp_id fnd_responsibility.responsibility_id%TYPE;
629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1
636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

Line 664: from fnd_responsibility a,

660: AND FF.function_name = l_function_name
661: AND RF.APPLICATION_ID(+) = l_appl_id;
662: CURSOR c_resp IS
663: select a.responsibility_id resp_id , a.menu_id menu_id, a.application_id appl_id
664: from fnd_responsibility a,
665: fnd_user_resp_groups b
666: where b.user_id = l_user_id
667: and a.version = 'W'
668: and b.responsibility_id = a.responsibility_id