APPS.BIM_LEAD_FACTS_PKG dependencies on DBMS_STATS

Line 847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,

843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:
846: -- Analyze the daily facts table
847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,
848: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
849:
850:
851: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 20';

Line 998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,

994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:
997: -- Analyze the daily facts table
998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,
999: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1000:
1001:
1002: /* Recreating Indexes */