APPS.AMW_VIOLATION_PUB dependencies on FND_MENU_ENTRIES

Line 1760: FROM fnd_menu_entries

1756: m_return_text VARCHAR2(3000);
1757:
1758: CURSOR all_menus_in_hierarchy(p_menu_id NUMBER) is
1759: SELECT sub_menu_id menu_id
1760: FROM fnd_menu_entries
1761: START WITH menu_id =p_menu_id
1762: CONNECT BY PRIOR sub_menu_id = menu_id
1763: UNION
1764: SELECT menu_id

Line 1765: FROM fnd_menu_entries

1761: START WITH menu_id =p_menu_id
1762: CONNECT BY PRIOR sub_menu_id = menu_id
1763: UNION
1764: SELECT menu_id
1765: FROM fnd_menu_entries
1766: START WITH menu_id =p_menu_id
1767: CONNECT BY PRIOR menu_id = sub_menu_id;
1768:
1769:

Line 1771: use FND_MENU_ENTRIES i.s.o. FND_COMPILED_MENU_FUNCTION because FND_COMPILED_MENU_FUNCTION

1767: CONNECT BY PRIOR menu_id = sub_menu_id;
1768:
1769:
1770: /** dliao modified on 11/08/2006 for the bug 5610537
1771: use FND_MENU_ENTRIES i.s.o. FND_COMPILED_MENU_FUNCTION because FND_COMPILED_MENU_FUNCTION
1772: won't be populated until all of menu entries are created. Our goal is to check multiple
1773: menu entries that violating the sod before they are created in the database.
1774: ***/
1775:

Line 1778: from FND_MENU_ENTRIES --FND_COMPILED_MENU_FUNCTIONS

1774: ***/
1775:
1776: cursor MENU_FUNCTIONS(p_menu_id NUMBER) is
1777: select distinct FUNCTION_ID
1778: from FND_MENU_ENTRIES --FND_COMPILED_MENU_FUNCTIONS
1779: where MENU_ID = p_menu_id;
1780:
1781: cursor MENU_AND_SUB_MENU_FUNCTIONS(p_menu_id NUMBER, p_sub_menu_id NUMBER) is
1782: select distinct FUNCTION_ID

Line 1783: from FND_MENU_ENTRIES --FND_COMPILED_MENU_FUNCTIONS

1779: where MENU_ID = p_menu_id;
1780:
1781: cursor MENU_AND_SUB_MENU_FUNCTIONS(p_menu_id NUMBER, p_sub_menu_id NUMBER) is
1782: select distinct FUNCTION_ID
1783: from FND_MENU_ENTRIES --FND_COMPILED_MENU_FUNCTIONS
1784: where MENU_ID = p_menu_id or MENU_ID = p_sub_menu_id;
1785:
1786: flag BOOLEAN;
1787: