APPS.BIM_LEAD_FACTS_PKG dependencies on BIM_UTL_PKG

Line 448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');

444:
445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */
448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');
449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
450:
451:
452:

Line 449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');

445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */
448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');
449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
450:
451:
452:
453: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';

Line 1003: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_DAILY_FACTS');

999: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1000:
1001:
1002: /* Recreating Indexes */
1003: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_DAILY_FACTS');
1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
1005:
1006:
1007:

Line 1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');

1000:
1001:
1002: /* Recreating Indexes */
1003: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_DAILY_FACTS');
1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
1005:
1006:
1007:
1008: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 20';