DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on FND_MENUS

Line 4735: l_menu_name FND_MENUS.MENU_NAME%TYPE;

4731: l_item_id_sql VARCHAR2(1000);
4732:
4733: l_inventory_item_id NUMBER;
4734: l_organization_id NUMBER;
4735: l_menu_name FND_MENUS.MENU_NAME%TYPE;
4736: l_grantee_type FND_GRANTS.GRANTEE_TYPE%TYPE;
4737: l_grantee_key FND_GRANTS.GRANTEE_KEY%TYPE;
4738: l_end_date DATE;
4739: BEGIN

Line 4765: FROM FND_MENUS

4761: RETURN;
4762: END IF;
4763:
4764: SELECT MENU_ID INTO l_menu_id
4765: FROM FND_MENUS
4766: WHERE MENU_NAME = 'EGO_ITEM_OWNER';
4767:
4768: Debug_Conc_Log('Default_Item_People: l_menu_id-'||l_menu_id);
4769:

Line 4801: FND_MENUS menus

4797: grants.END_DATE
4798: FROM
4799: MTL_SYSTEM_ITEMS_INTERFACE msii,
4800: FND_GRANTS grants,
4801: FND_MENUS menus
4802: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
4803: AND msii.PROCESS_FLAG = 7
4804: AND msii.TRANSACTION_TYPE = 'CREATE'
4805: AND msii.REQUEST_ID = #' || l_request_id || q'#

Line 4896: FND_MENUS menus

4892: FROM
4893: MTL_SYSTEM_ITEMS_KFV msik,
4894: EGO_ITEM_PEOPLE_INTF intf,
4895: MTL_PARAMETERS mp,
4896: FND_MENUS menus
4897: WHERE intf.DATA_SET_ID = p_batch_id
4898: AND intf.PROCESS_STATUS = 4
4899: AND intf.REQUEST_ID = cp_request_id
4900: AND intf.TRANSACTION_TYPE = 'CREATE'