APPS.BIM_LEAD_IMPORT_FACTS_PKG dependencies on BIM_R_LIMP_DAILY_FACTS_S

Line 318: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_daily_facts_s CACHE 1000';

314:
315: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
316: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_daily_facts nologging';
317: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_weekly_facts nologging';
318: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_daily_facts_s CACHE 1000';
319:
320: p_table_name := 'BIM_R_LIMP_DAILY_FACTS';
321:
322: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');

Line 360: BIM_R_LIMP_DAILY_FACTS_S.nextval,

356: leads_new,
357: Transaction_create_date,
358: weekend_date)
359: select /*+ parallel(OUTER,1) */
360: BIM_R_LIMP_DAILY_FACTS_S.nextval,
361: sysdate,
362: sysdate,
363: l_user_id,
364: l_user_id,

Line 486: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_daily_facts_s CACHE 20';

482:
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_daily_facts_s CACHE 20';
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
489: FND_MESSAGE.Set_token('table_name', p_table_name, FALSE);
490: FND_MSG_PUB.Add;