407: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_daily_facts nologging ';
408: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_daily_facts nologging ';
409:
410: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_weekly_facts nologging ';
411: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_weekly_facts nologging ';
412:
413: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_daily_facts_s CACHE 1000 ';
414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_daily_facts_s CACHE 1000 ';
415:
413: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_daily_facts_s CACHE 1000 ';
414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_daily_facts_s CACHE 1000 ';
415:
416: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 1000 ';
417: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 1000 ';
418:
419:
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:
426:
427: l_org_id := 204;
428:
610:
611: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
612:
613: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rgrd_weekly_facts';
614: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rrsn_weekly_facts';
615:
616: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
617: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
618: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
697: fnd_file.put_line(fnd_file.log,fnd_message.get);
698:
699: ---------------
700:
701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
702: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
703: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
704: fnd_file.put_line(fnd_file.log,fnd_message.get);
705:
704: fnd_file.put_line(fnd_file.log,fnd_message.get);
705:
706:
707: INSERT /*+ append parallel(RWF,1) */
708: INTO bim_r_rrsn_weekly_facts RWF
709: (
710: Reason_Weekly_transaction_id
711: ,creation_date
712: ,last_update_date
727: ,landing_pad_hits
728: ,survey_completed
729: )
730: SELECT
731: bim_r_rrsn_weekly_facts_s.nextval
732: ,sysdate
733: ,sysdate
734: ,-1
735: ,-1
775: ,Invalid_Reason
776: ,weekend_date
777: );
778:
779: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
780: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
781: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783:
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');
800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802:
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');
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';
818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';
819:
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';
818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';
819:
820: EXCEPTION
821:
822: WHEN FND_API.G_EXC_ERROR THEN