DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on FND_STATS

Line 726: FND_STATS.gather_table_stats(ownname => l_temp_char_30

722: FROM sys.all_objects
723: WHERE object_name = G_INTF_PTP_TABLE_NAME
724: AND object_type = 'TABLE';
725:
726: FND_STATS.gather_table_stats(ownname => l_temp_char_30
727: ,tabname => G_INTF_PTP_TABLE_NAME);
728: FND_STATS.gather_table_stats(ownname => l_temp_char_30
729: ,tabname => G_INTF_REG_TABLE_NAME);
730: FND_STATS.gather_table_stats(ownname => l_temp_char_30

Line 728: FND_STATS.gather_table_stats(ownname => l_temp_char_30

724: AND object_type = 'TABLE';
725:
726: FND_STATS.gather_table_stats(ownname => l_temp_char_30
727: ,tabname => G_INTF_PTP_TABLE_NAME);
728: FND_STATS.gather_table_stats(ownname => l_temp_char_30
729: ,tabname => G_INTF_REG_TABLE_NAME);
730: FND_STATS.gather_table_stats(ownname => l_temp_char_30
731: ,tabname => G_INTF_EXE_TABLE_NAME);
732: FND_STATS.gather_table_stats(ownname => l_temp_char_30

Line 730: FND_STATS.gather_table_stats(ownname => l_temp_char_30

726: FND_STATS.gather_table_stats(ownname => l_temp_char_30
727: ,tabname => G_INTF_PTP_TABLE_NAME);
728: FND_STATS.gather_table_stats(ownname => l_temp_char_30
729: ,tabname => G_INTF_REG_TABLE_NAME);
730: FND_STATS.gather_table_stats(ownname => l_temp_char_30
731: ,tabname => G_INTF_EXE_TABLE_NAME);
732: FND_STATS.gather_table_stats(ownname => l_temp_char_30
733: ,tabname => G_INTF_RCA_TABLE_NAME);
734: FND_STATS.gather_table_stats(ownname => l_temp_char_30

Line 732: FND_STATS.gather_table_stats(ownname => l_temp_char_30

728: FND_STATS.gather_table_stats(ownname => l_temp_char_30
729: ,tabname => G_INTF_REG_TABLE_NAME);
730: FND_STATS.gather_table_stats(ownname => l_temp_char_30
731: ,tabname => G_INTF_EXE_TABLE_NAME);
732: FND_STATS.gather_table_stats(ownname => l_temp_char_30
733: ,tabname => G_INTF_RCA_TABLE_NAME);
734: FND_STATS.gather_table_stats(ownname => l_temp_char_30
735: ,tabname => 'ZX_ERRORS_INT');
736:

Line 734: FND_STATS.gather_table_stats(ownname => l_temp_char_30

730: FND_STATS.gather_table_stats(ownname => l_temp_char_30
731: ,tabname => G_INTF_EXE_TABLE_NAME);
732: FND_STATS.gather_table_stats(ownname => l_temp_char_30
733: ,tabname => G_INTF_RCA_TABLE_NAME);
734: FND_STATS.gather_table_stats(ownname => l_temp_char_30
735: ,tabname => 'ZX_ERRORS_INT');
736:
737: G_DEBUG_STATEMENT:='Completed Gathering Stats on interface tables';
738: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN