DBA Data[Home] [Help]

APPS.HRI_OPL_GEO_LOCHR dependencies on FND_STATS

Line 776: fnd_stats.gather_table_stats(g_schema, g_target_lochr_table);

772: dbg('Re-Enabling Who Trigger');
773: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_LOCHR_CT_WHO ENABLE');
774: --
775: dbg_time('Gather Stats Start');
776: fnd_stats.gather_table_stats(g_schema, g_target_lochr_table);
777: dbg_time('Gather Stats End');
778: --
779: dbg('Exiting -> Full Refresh LocHR Struct');
780: --

Line 857: fnd_stats.gather_table_stats(g_schema, g_target_region_table);

853: dbg('Re-Enabling Who Trigger');
854: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_REGION_CT_WHO ENABLE');
855: --
856: dbg_time('Gather Stats Start');
857: fnd_stats.gather_table_stats(g_schema, g_target_region_table);
858: dbg_time('Gather Stats End');
859: --
860: dbg('Exiting -> Full Refresh Region Struct');
861: --

Line 935: fnd_stats.gather_table_stats(g_schema, g_target_country_table);

931: dbg('Re-Enabling Who Trigger');
932: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_COUNTRY_CT_WHO ENABLE');
933: --
934: dbg_time('Gather Stats Start');
935: fnd_stats.gather_table_stats(g_schema, g_target_country_table);
936: dbg_time('Gather Stats End');
937: --
938: dbg('Exiting -> Full Refresh Country Struct');
939: --

Line 1155: fnd_stats.gather_table_stats(g_schema, g_target_lochr_table);

1151: --
1152: dbg('gather table stats Schema = '
1153: ||g_schema||', Table = '||g_target_lochr_table);
1154: --
1155: fnd_stats.gather_table_stats(g_schema, g_target_lochr_table);
1156: --
1157: dbg('Gathered stats: ' ||
1158: to_char(sysdate,'HH24:MI:SS'));
1159: /**/