APPS.BIM_CAMPAIGN_FACTS dependencies on DBMS_STATS

Line 2303: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,

2299: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2300: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);
2301:
2302: -- Analyze the daily facts table
2303: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
2304: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2305:
2306: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2307: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);

Line 2517: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,

2513: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2514: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
2515:
2516: -- Analyze the daily facts table
2517: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
2518: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2519:
2520: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2521: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);

Line 4525: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,

4521: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4522: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);
4523:
4524: -- Analyze the daily facts table
4525: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
4526: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4527:
4528: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4529: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);

Line 4740: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,

4736: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4737: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
4738:
4739: -- Analyze the daily facts table
4740: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
4741: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4742:
4743: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4744: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);