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_CAMPAIGN_FACTS dependencies on BIM_R_CAMP_WEEKLY_FACTS

Line 555: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';

551: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
552:
553: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_daily_facts nologging ';
554:
555: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';
556:
557: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';
558:
559: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';

Line 559: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';

555: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';
556:
557: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';
558:
559: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';
560:
561: /*Get the tablespace name for the purpose of creating the index on that tablespace. */
562:
563:

Line 2319: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';

2315:
2316: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2317: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);
2318:
2319: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
2320:
2321: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
2322:
2323: l_table_name := 'bim_r_camp_weekly_facts';

Line 2323: l_table_name := 'bim_r_camp_weekly_facts';

2319: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
2320:
2321: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
2322:
2323: l_table_name := 'bim_r_camp_weekly_facts';
2324: l_seq_name := 'bim_r_camp_weekly_facts_s';
2325:
2326: INSERT /*+ append parallel(CWF,1) */
2327: INTO bim_r_camp_weekly_facts CWF

Line 2324: l_seq_name := 'bim_r_camp_weekly_facts_s';

2320:
2321: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
2322:
2323: l_table_name := 'bim_r_camp_weekly_facts';
2324: l_seq_name := 'bim_r_camp_weekly_facts_s';
2325:
2326: INSERT /*+ append parallel(CWF,1) */
2327: INTO bim_r_camp_weekly_facts CWF
2328: (

Line 2327: INTO bim_r_camp_weekly_facts CWF

2323: l_table_name := 'bim_r_camp_weekly_facts';
2324: l_seq_name := 'bim_r_camp_weekly_facts_s';
2325:
2326: INSERT /*+ append parallel(CWF,1) */
2327: INTO bim_r_camp_weekly_facts CWF
2328: (
2329: campaign_weekly_transaction_id
2330: ,creation_date
2331: ,last_update_date

Line 2381: bim_r_camp_weekly_facts_s.nextval

2377: ,budget_requested
2378: ,budget_approved
2379: )
2380: SELECT /*+ parallel(INNER,8) */
2381: bim_r_camp_weekly_facts_s.nextval
2382: ,sysdate
2383: ,sysdate
2384: ,l_user_id
2385: ,l_user_id

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 2572: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 20';

2568:
2569: /* End of Code for Recreating the index on the same tablespace with the same storage parameters */
2570:
2571:
2572: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 20';
2573:
2574:
2575: EXCEPTION
2576:

Line 2758: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';

2754: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
2755:
2756: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_daily_facts nologging ';
2757:
2758: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';
2759:
2760: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';
2761:
2762: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';

Line 2762: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';

2758: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_camp_weekly_facts nologging ';
2759:
2760: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';
2761:
2762: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 1000 ';
2763:
2764: /*Get the tablespace name for the purpose of creating the index on that tablespace. */
2765:
2766:

Line 4541: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';

4537:
4538: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4539: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);
4540:
4541: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
4542:
4543: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
4544:
4545: l_table_name := 'bim_r_camp_weekly_facts';

Line 4545: l_table_name := 'bim_r_camp_weekly_facts';

4541: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
4542:
4543: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
4544:
4545: l_table_name := 'bim_r_camp_weekly_facts';
4546: l_seq_name := 'bim_r_camp_weekly_facts_s';
4547:
4548: INSERT /*+ append parallel(CWF,1) */
4549: INTO bim_r_camp_weekly_facts CWF

Line 4546: l_seq_name := 'bim_r_camp_weekly_facts_s';

4542:
4543: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
4544:
4545: l_table_name := 'bim_r_camp_weekly_facts';
4546: l_seq_name := 'bim_r_camp_weekly_facts_s';
4547:
4548: INSERT /*+ append parallel(CWF,1) */
4549: INTO bim_r_camp_weekly_facts CWF
4550: (

Line 4549: INTO bim_r_camp_weekly_facts CWF

4545: l_table_name := 'bim_r_camp_weekly_facts';
4546: l_seq_name := 'bim_r_camp_weekly_facts_s';
4547:
4548: INSERT /*+ append parallel(CWF,1) */
4549: INTO bim_r_camp_weekly_facts CWF
4550: (
4551: campaign_weekly_transaction_id
4552: ,creation_date
4553: ,last_update_date

Line 4603: bim_r_camp_weekly_facts_s.nextval

4599: ,budget_requested
4600: ,budget_approved
4601: )
4602: SELECT /*+ parallel(INNER,8) */
4603: bim_r_camp_weekly_facts_s.nextval
4604: ,sysdate
4605: ,sysdate
4606: ,l_user_id
4607: ,l_user_id

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

Line 4786: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 20';

4782:
4783: /* End of Code for Recreating the index on the same tablespace with the same storage parameters */
4784:
4785:
4786: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_weekly_facts_s CACHE 20';
4787:
4788:
4789:
4790: EXCEPTION