DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on FND_INSTALLATION

Line 644: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);

640: SELECT COUNT(1) INTO l_records
641: FROM MTL_SYSTEM_ITEMS_INTERFACE
642: WHERE SET_PROCESS_ID = p_data_set_id;
643:
644: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);
645: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
646: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
647: Debug_Conc_Log('Collected Statistics on MTL_SYSTEM_ITEMS_INTERFACE');
648: END IF;

Line 670: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);

666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
667: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
668: END IF;
669:
670: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);
671: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF
672: SELECT COUNT(1) INTO l_records
673: FROM EGO_ITEM_PEOPLE_INTF
674: WHERE DATA_SET_ID = p_data_set_id;