APPS.BIM_CAMPAIGN_FACTS dependencies on BIM_R_CAMP_DAILY_FACTS_S

Line 557: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';

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 ';
560:
561: /*Get the tablespace name for the purpose of creating the index on that tablespace. */

Line 667: bim_r_camp_daily_facts_s.nextval

663: ,budget_requested
664: ,budget_approved
665: )
666: SELECT /*+ parallel(OUTER,1) */
667: bim_r_camp_daily_facts_s.nextval
668: ,sysdate
669: ,sysdate
670: ,-1
671: ,-1

Line 1174: bim_r_camp_daily_facts_s.nextval

1170: ,budget_requested
1171: ,budget_approved
1172: )
1173: SELECT /*+ parallel(INNER,1) */
1174: bim_r_camp_daily_facts_s.nextval
1175: ,sysdate
1176: ,sysdate
1177: ,-1
1178: ,-1

Line 1702: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 20';

1698: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1699: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER SECOND INSERT ' || l_temp_msg);
1700:
1701: COMMIT;
1702: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 20';
1703:
1704: /* This insert deals with the budgets for campaigns */
1705:
1706: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');

Line 1768: bim_r_camp_daily_facts_s.nextval

1764: ,budget_requested
1765: ,budget_approved
1766: )
1767: SELECT /*+ parallel(INNER,1) */
1768: bim_r_camp_daily_facts_s.nextval
1769: ,sysdate
1770: ,sysdate
1771: ,-1
1772: ,-1

Line 2040: bim_r_camp_daily_facts_s.nextval

2036: ,budget_requested
2037: ,budget_approved
2038: )
2039: SELECT /*+ parallel(INNER,1) */
2040: bim_r_camp_daily_facts_s.nextval
2041: ,sysdate
2042: ,sysdate
2043: ,-1
2044: ,-1

Line 2760: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 1000 ';

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 ';
2763:
2764: /*Get the tablespace name for the purpose of creating the index on that tablespace. */

Line 2878: bim_r_camp_daily_facts_s.nextval

2874: ,budget_requested
2875: ,budget_approved
2876: )
2877: SELECT /*+ parallel(OUTER,1) */
2878: bim_r_camp_daily_facts_s.nextval
2879: ,sysdate
2880: ,sysdate
2881: ,-1
2882: ,-1

Line 3386: bim_r_camp_daily_facts_s.nextval

3382: ,budget_requested
3383: ,budget_approved
3384: )
3385: SELECT /*+ parallel(INNER,1) */
3386: bim_r_camp_daily_facts_s.nextval
3387: ,sysdate
3388: ,sysdate
3389: ,-1
3390: ,-1

Line 3917: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 20';

3913:
3914: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL dml ';
3915: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
3916:
3917: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 20';
3918:
3919: /* The above main INSERT statement handles the amounts associated with the SCHEDULEs. Here with this stmt we
3920: are dealing with the CAMPAIGNs of the campaigns table */
3921:

Line 3983: bim_r_camp_daily_facts_s.nextval

3979: ,budget_requested
3980: ,budget_approved
3981: )
3982: SELECT /*+ parallel(INNER,1) */
3983: bim_r_camp_daily_facts_s.nextval
3984: ,sysdate
3985: ,sysdate
3986: ,-1
3987: ,-1

Line 4255: bim_r_camp_daily_facts_s.nextval

4251: ,budget_requested
4252: ,budget_approved
4253: )
4254: SELECT /*+ parallel(INNER,1) */
4255: bim_r_camp_daily_facts_s.nextval
4256: ,sysdate
4257: ,sysdate
4258: ,-1
4259: ,-1