eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_RESPONSE_FACTS_PKG dependencies on BIM_R_RRSN_WEEKLY_FACTS

Line 411: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rrsn_weekly_facts nologging ';

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:

Line 417: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 1000 ';

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');

Line 424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_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:

Line 614: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rrsn_weekly_facts';

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);

Line 701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';

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:

Line 708: INTO bim_r_rrsn_weekly_facts RWF

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

Line 731: bim_r_rrsn_weekly_facts_s.nextval

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

Line 779: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';

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:

Line 798: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';

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:

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');

Line 815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');

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:

Line 818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';

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