APPS.BIM_LEAD_IMPORT_FACTS_PKG dependencies on DBMS_STATS

Line 472: -- analyze the bim_r_limp_daily_facts with dbms_stats

468:
469: commit;
470: -- dbms_output.put_line('after daily insert ');
471:
472: -- analyze the bim_r_limp_daily_facts with dbms_stats
473: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
474: fnd_message.set_token('table_name', p_table_name, FALSE);
475: ams_utility_pvt.write_conc_log(fnd_message.get);
476:

Line 479: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_daily_facts', estimate_percent => 5,

475: ams_utility_pvt.write_conc_log(fnd_message.get);
476:
477:
478: BEGIN
479: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_daily_facts', estimate_percent => 5,
480: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
481: END;
482:
483:

Line 598: -- analyze the bim_r_limp_daily_facts with dbms_stats

594: );
595:
596: COMMIT;
597:
598: -- analyze the bim_r_limp_daily_facts with dbms_stats
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('table_name', p_table_name, FALSE);
601: ams_utility_pvt.write_conc_log(fnd_message.get);
602:

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

600: fnd_message.set_token('table_name', p_table_name, FALSE);
601: ams_utility_pvt.write_conc_log(fnd_message.get);
602:
603: BEGIN
604: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_weekly_facts', estimate_percent => 5,
605: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
606: END;
607:
608: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');