DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on FND_STATS

Line 654: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');

650: WHERE SET_PROCESS_ID = p_data_set_id;
651:
652: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);
653: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
654: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
655: Debug_Conc_Log('Collected Statistics on MTL_SYSTEM_ITEMS_INTERFACE');
656: END IF;
657:
658: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE

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

660: FROM MTL_ITEM_REVISIONS_INTERFACE
661: WHERE SET_PROCESS_ID = p_data_set_id;
662:
663: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
664: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
665: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');
666: END IF;
667: */
668: -- Bug 12669090 : End

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

672: FROM MTL_ITEM_CATEGORIES_INTERFACE
673: WHERE SET_PROCESS_ID = p_data_set_id;
674:
675: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
677: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
678: END IF;
679:
680: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);

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

683: FROM EGO_ITEM_PEOPLE_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_ITEM_PEOPLE_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_ITEM_PEOPLE_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_AML_INTF

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

693: FROM EGO_AML_INTF
694: WHERE DATA_SET_ID = p_data_set_id;
695:
696: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');
698: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');
699: END IF;
700: /* Bug 12669090 : Commenting the Gather Stats.
701: As mentioned in the note 1208945.1 and suggested by performance team,

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

707: FROM EGO_ITM_USR_ATTR_INTRFC
708: WHERE DATA_SET_ID = p_data_set_id;
709:
710: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
711: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
712: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
713: END IF;
714: */
715: -- Bug 12669090 : End

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

720: FROM EGO_ITEM_ASSOCIATIONS_INTF
721: WHERE BATCH_ID = p_data_set_id;
722:
723: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
724: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');
725: Debug_Conc_Log('Collected Statistics on EGO_ITEM_ASSOCIATIONS_INTF');
726: END IF;
727:
728: --R12C: END