APPS.BIM_EVENT_FACTS dependencies on DBMS_STATS

Line 2271: -- analyze the bim_r_event_daily_facts with dbms_stats

2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2268: RAISE FND_API.G_EXC_ERROR;
2269: END;
2270:
2271: -- analyze the bim_r_event_daily_facts with dbms_stats
2272: BEGIN
2273: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,
2274: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2275: END;

Line 2273: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,

2269: END;
2270:
2271: -- analyze the bim_r_event_daily_facts with dbms_stats
2272: BEGIN
2273: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,
2274: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2275: END;
2276:
2277: /*This update statement is to updating forecasted_cost, actual_cost, forecasted_revenue, and actual_revenue that event header happened between p_start_date and p_end_date parameter*/

Line 2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats

2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));
2671: RAISE FND_API.G_EXC_ERROR;
2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats
2675: BEGIN
2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,
2677: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2678: END;

Line 2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,

2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats
2675: BEGIN
2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,
2677: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2678: END;
2679:
2680: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */

Line 4266: -- analyze the BIM_R_EVEN_daily_facts with dbms_stats

4262: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
4263: RAISE FND_API.G_EXC_ERROR;
4264: END;
4265:
4266: -- analyze the BIM_R_EVEN_daily_facts with dbms_stats
4267: BEGIN
4268: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,
4269: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4270: END;

Line 4268: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,

4264: END;
4265:
4266: -- analyze the BIM_R_EVEN_daily_facts with dbms_stats
4267: BEGIN
4268: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_DAILY_FACTS', estimate_percent => 5,
4269: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4270: END;
4271:
4272: