APPS.BIM_RESPONSE_FACTS_PKG dependencies on DBMS_STATS

Line 595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,

591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
592: fnd_file.put_line(fnd_file.log,fnd_message.get);
593:
594: -- Analyze the daily facts table
595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,
596: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
597:
598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

Line 604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,

600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:
603: -- Analyze the daily facts table
604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,
605: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
606:
607: /***************************************************************/
608:

Line 795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,

791: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
792: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
793: fnd_file.put_line(fnd_file.log,fnd_message.get);
794:
795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,
796: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
797:
798: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

Line 803: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_WEEKLY_FACTS', estimate_percent => 5,

799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802:
803: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_WEEKLY_FACTS', estimate_percent => 5,
804: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
805:
806:
807: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');