APPS.PA_SECURITY_PVT dependencies on FND_MENUS

Line 1045: l_default_menu_name fnd_menus.menu_name%TYPE := null;

1041: l_instance_set_id number;
1042: l_grantee_key fnd_grants.grantee_key%TYPE;
1043: l_grant_exists VARCHAR2(1);
1044: l_status_level VARCHAR2(30);
1045: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1046: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1047: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1048: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1049: l_exp_error varchar2(1) := 'F';

Line 1636: from fnd_menus menu,

1632: l_api_name varchar2(30):='get_menu_name';
1633: begin
1634: select menu.menu_name
1635: into v_menu_name
1636: from fnd_menus menu,
1637: --pa_project_role_types role
1638: pa_project_role_types_b role --Bug 4867700
1639: where menu.menu_id=role.menu_id
1640: and role.project_role_id= p_project_role_id;

Line 1664: from fnd_menus menu

1660: v_menu_name varchar2(30);
1661: begin
1662: select menu.menu_name
1663: into v_menu_name
1664: from fnd_menus menu
1665: where menu.menu_id=p_menu_id;
1666: return v_menu_name;
1667: exception
1668: when others then

Line 1680: from fnd_menus menu,

1676: l_api_name varchar2(30):='get_menu_name';
1677: begin
1678: select menu.menu_name
1679: into v_menu_name
1680: from fnd_menus menu,
1681: pa_project_role_types role
1682: where menu.menu_id=role.menu_id
1683: and role.meaning= p_project_role_name;
1684: return v_menu_name;

Line 1708: from fnd_menus

1704: v_menu_id number;
1705: l_api_name varchar2(30):='get_menu_id';
1706: begin
1707: select menu_id into v_menu_id
1708: from fnd_menus
1709: where menu_name =p_menu_name;
1710: return v_menu_id;
1711: exception
1712: when no_data_found then

Line 1779: ,p_role_id IN FND_MENUS.MENU_ID%TYPE

1775: ----This FUnction is created by Hari. It is used in resource model
1776: --------------------------------------------------------------------------
1777: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
1778: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
1779: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
1780: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
1781: ,p_party_id IN NUMBER
1782: ) RETURN BOOLEAN IS
1783:

Line 2264: l_default_menu_name fnd_menus.menu_name%TYPE := null;

2260: l_instance_set_id number;
2261: l_grantee_key fnd_grants.grantee_key%TYPE;
2262: l_grant_exists VARCHAR2(1);
2263: l_status_level VARCHAR2(30);
2264: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2265: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2266: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2267: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2268: l_exp_error varchar2(1) := 'F';