DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on FND_RESPONSIBILITY_VL

Line 744: l_application_id fnd_responsibility_vl.application_id%type;

740: --multi org access control project.
741: --This function returns the current responsibility name the user is in.
742: FUNCTION Get_Window_Title RETURN VARCHAR2 IS
743:
744: l_application_id fnd_responsibility_vl.application_id%type;
745: l_resp_id fnd_responsibility_vl.responsibility_id%TYPE;
746: l_wnd_context fnd_responsibility_vl.responsibility_name%TYPE;
747:
748: BEGIN

Line 745: l_resp_id fnd_responsibility_vl.responsibility_id%TYPE;

741: --This function returns the current responsibility name the user is in.
742: FUNCTION Get_Window_Title RETURN VARCHAR2 IS
743:
744: l_application_id fnd_responsibility_vl.application_id%type;
745: l_resp_id fnd_responsibility_vl.responsibility_id%TYPE;
746: l_wnd_context fnd_responsibility_vl.responsibility_name%TYPE;
747:
748: BEGIN
749:

Line 746: l_wnd_context fnd_responsibility_vl.responsibility_name%TYPE;

742: FUNCTION Get_Window_Title RETURN VARCHAR2 IS
743:
744: l_application_id fnd_responsibility_vl.application_id%type;
745: l_resp_id fnd_responsibility_vl.responsibility_id%TYPE;
746: l_wnd_context fnd_responsibility_vl.responsibility_name%TYPE;
747:
748: BEGIN
749:
750: fnd_profile.get('RESP_ID',l_resp_id);

Line 756: FROM fnd_responsibility_vl

752:
753:
754: SELECT responsibility_name
755: INTO l_wnd_context
756: FROM fnd_responsibility_vl
757: WHERE application_id = l_application_id
758: AND responsibility_id = l_resp_id;
759:
760: