DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on FND_STATS

Line 646: FND_STATS.GATHER_TABLE_STATS(l_schema, '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;
649:
650: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE

Line 656: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');

652: FROM MTL_ITEM_REVISIONS_INTERFACE
653: WHERE SET_PROCESS_ID = p_data_set_id;
654:
655: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
656: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
657: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');
658: END IF;
659:
660: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE

Line 666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

662: FROM MTL_ITEM_CATEGORIES_INTERFACE
663: WHERE SET_PROCESS_ID = p_data_set_id;
664:
665: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
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);

Line 677: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');

673: FROM EGO_ITEM_PEOPLE_INTF
674: WHERE DATA_SET_ID = p_data_set_id;
675:
676: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
677: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_PEOPLE_INTF');
678: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');
679: END IF;
680:
681: -- checking whether stats needs to be collected on EGO_AML_INTF

Line 687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');

683: FROM EGO_AML_INTF
684: WHERE DATA_SET_ID = p_data_set_id;
685:
686: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC

Line 697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');

693: FROM EGO_ITM_USR_ATTR_INTRFC
694: WHERE DATA_SET_ID = p_data_set_id;
695:
696: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
698: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
699: END IF;
700:
701: -- R12C: BEGIN

Line 709: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');

705: FROM EGO_ITEM_ASSOCIATIONS_INTF
706: WHERE BATCH_ID = p_data_set_id;
707:
708: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
709: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');
710: Debug_Conc_Log('Collected Statistics on EGO_ITEM_ASSOCIATIONS_INTF');
711: END IF;
712:
713: --R12C: END