DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on FND_MENUS

Line 5485: l_menu_name FND_MENUS.MENU_NAME%TYPE;

5481: l_item_id_sql VARCHAR2(1000);
5482:
5483: l_inventory_item_id NUMBER;
5484: l_organization_id NUMBER;
5485: l_menu_name FND_MENUS.MENU_NAME%TYPE;
5486: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
5487: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
5488: l_end_date DATE;
5489: BEGIN

Line 5515: FROM FND_MENUS

5511: RETURN;
5512: END IF;
5513:
5514: SELECT MENU_ID INTO l_menu_id
5515: FROM FND_MENUS
5516: WHERE MENU_NAME = 'EGO_ITEM_OWNER';
5517:
5518: Debug_Conc_Log('Default_Item_People: l_menu_id-'||l_menu_id);
5519:

Line 5551: FND_MENUS menus

5547: grants.END_DATE
5548: FROM
5549: MTL_SYSTEM_ITEMS_INTERFACE msii,
5550: FND_GRANTS grants,
5551: FND_MENUS menus
5552: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
5553: AND msii.PROCESS_FLAG = 7
5554: AND msii.TRANSACTION_TYPE = 'CREATE'
5555: AND msii.REQUEST_ID = #' || l_request_id || q'#

Line 5646: FND_MENUS menus

5642: FROM
5643: MTL_SYSTEM_ITEMS_KFV msik,
5644: EGO_ITEM_PEOPLE_INTF intf,
5645: MTL_PARAMETERS mp,
5646: FND_MENUS menus
5647: WHERE intf.DATA_SET_ID = p_batch_id
5648: AND intf.PROCESS_STATUS = 4
5649: AND intf.REQUEST_ID = cp_request_id
5650: AND intf.TRANSACTION_TYPE = 'CREATE'