APPS.BIM_CAMPAIGN_FACTS dependencies on BIM_R_CAMP_WEEKLY_FACTS_S

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