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_RGRD_DAILY_FACTS

Line 407: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_rgrd_daily_facts nologging ';

403: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
404:
405:
406:
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 ';

Line 413: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_daily_facts_s CACHE 1000 ';

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

Line 421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');

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

Line 429: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';

425:
426:
427: l_org_id := 204;
428:
429: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
430: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
432: fnd_file.put_line(fnd_file.log,fnd_message.get);
433:

Line 435: INTO bim_r_rgrd_daily_facts RDF

431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
432: fnd_file.put_line(fnd_file.log,fnd_message.get);
433:
434: INSERT /*+ append parallel(RDF,1) */
435: INTO bim_r_rgrd_daily_facts RDF
436: (
437: Grade_daily_transaction_id
438: ,creation_date
439: ,last_update_date

Line 459: bim_r_rgrd_daily_facts_s.nextval

455: ,transaction_Create_Date
456: ,weekend_date
457: )
458: SELECT
459: bim_r_rgrd_daily_facts_s.nextval
460: ,sysdate
461: ,sysdate
462: ,-1
463: ,-1

Line 500: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';

496: 'CSCH',d.object_id,'EVEO',d.object_id)
497: AND a.object_type = d.object_type
498: AND a.interface_header_id = b.interface_header_id;
499:
500: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
501: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------

Line 589: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';

585: /***************************************************************/
586:
587: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
588:
589: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
590: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
592: fnd_file.put_line(fnd_file.log,fnd_message.get);
593:

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 680: FROM bim_r_rgrd_daily_facts

676: ,weekend_date
677: ,sum(Response_Grade_Count) Response_Grade_Count
678: ,sum(landing_pad_hits) Landing_pad_hits
679: ,sum(survey_completed) Survey_Completed
680: FROM bim_r_rgrd_daily_facts
681: GROUP BY
682: Object_Id
683: ,Object_type
684: ,Object_status

Line 812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');

808: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
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: