DBA Data[Home] [Help]

APPS.BIM_LEAD_IMPORT_FACTS_PKG dependencies on BIM_UTL_PKG

Line 325: BIM_UTL_PKG.DROP_INDEX(p_table_name);

321:
322: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');
323: ams_utility_pvt.write_conc_log(fnd_message.get);
324:
325: BIM_UTL_PKG.DROP_INDEX(p_table_name);
326: BIM_UTL_PKG.DROP_INDEX('BIM_R_LIMP_WEEKLY_FACTS');
327:
328:
329: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 326: BIM_UTL_PKG.DROP_INDEX('BIM_R_LIMP_WEEKLY_FACTS');

322: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');
323: ams_utility_pvt.write_conc_log(fnd_message.get);
324:
325: BIM_UTL_PKG.DROP_INDEX(p_table_name);
326: BIM_UTL_PKG.DROP_INDEX('BIM_R_LIMP_WEEKLY_FACTS');
327:
328:
329: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
330: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_DAILY_FACTS', FALSE);

Line 611: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_DAILY_FACTS');

607:
608: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
609: ams_utility_pvt.write_conc_log(fnd_message.get);
610:
611: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_DAILY_FACTS');
612: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_WEEKLY_FACTS');
613:
614: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_weekly_facts_s CACHE 20';
615:

Line 612: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_WEEKLY_FACTS');

608: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
609: ams_utility_pvt.write_conc_log(fnd_message.get);
610:
611: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_DAILY_FACTS');
612: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LIMP_WEEKLY_FACTS');
613:
614: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_weekly_facts_s CACHE 20';
615:
616: