APPS.PA_SECURITY_PVT dependencies on FND_MENUS

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

1052: l_instance_set_id number;
1053: l_grantee_key fnd_grants.grantee_key%TYPE;
1054: l_grant_exists VARCHAR2(1);
1055: l_status_level VARCHAR2(30);
1056: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1057: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1058: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1059: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1060: l_exp_error varchar2(1) := 'F';

Line 1647: from fnd_menus menu,

1643: l_api_name varchar2(30):='get_menu_name';
1644: begin
1645: select menu.menu_name
1646: into v_menu_name
1647: from fnd_menus menu,
1648: --pa_project_role_types role
1649: pa_project_role_types_b role --Bug 4867700
1650: where menu.menu_id=role.menu_id
1651: and role.project_role_id= p_project_role_id;

Line 1675: from fnd_menus menu

1671: v_menu_name varchar2(30);
1672: begin
1673: select menu.menu_name
1674: into v_menu_name
1675: from fnd_menus menu
1676: where menu.menu_id=p_menu_id;
1677: return v_menu_name;
1678: exception
1679: when others then

Line 1691: from fnd_menus menu,

1687: l_api_name varchar2(30):='get_menu_name';
1688: begin
1689: select menu.menu_name
1690: into v_menu_name
1691: from fnd_menus menu,
1692: pa_project_role_types role
1693: where menu.menu_id=role.menu_id
1694: and role.meaning= p_project_role_name;
1695: return v_menu_name;

Line 1719: from fnd_menus

1715: v_menu_id number;
1716: l_api_name varchar2(30):='get_menu_id';
1717: begin
1718: select menu_id into v_menu_id
1719: from fnd_menus
1720: where menu_name =p_menu_name;
1721: return v_menu_id;
1722: exception
1723: when no_data_found then

Line 1790: ,p_role_id IN FND_MENUS.MENU_ID%TYPE

1786: ----This FUnction is created by Hari. It is used in resource model
1787: --------------------------------------------------------------------------
1788: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
1789: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
1790: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
1791: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
1792: ,p_party_id IN NUMBER
1793: ) RETURN BOOLEAN IS
1794:

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

2271: l_instance_set_id number;
2272: l_grantee_key fnd_grants.grantee_key%TYPE;
2273: l_grant_exists VARCHAR2(1);
2274: l_status_level VARCHAR2(30);
2275: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2276: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2277: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2278: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2279: l_exp_error varchar2(1) := 'F';