APPS.BIM_EVENT_FACTS dependencies on BIM_R_EVEN_WEEKLY_FACTS_S

Line 2455: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 1000';

2451: --insert into bim_r_even_weekly_facts table
2452: BEGIN
2453: l_table_name :='bim_r_even_weekly_facts';
2454:
2455: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 1000';
2456:
2457: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2458: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);
2459:

Line 2515: bim_r_even_weekly_facts_s.nextval

2511: ,booked_orders_amt
2512: )
2513: SELECT
2514: /*+ parallel(INNER, 4) */
2515: bim_r_even_weekly_facts_s.nextval
2516: ,sysdate
2517: ,sysdate
2518: ,l_user_id
2519: ,l_user_id

Line 2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';

2660:
2661: RAISE FND_API.G_EXC_ERROR;
2662: WHEN OTHERS THEN
2663:
2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';
2665:
2666: x_return_status := FND_API.G_RET_STS_ERROR;
2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

Line 4337: bim_r_even_weekly_facts_s.nextval

4333: ,booked_orders_amt
4334: )
4335: SELECT
4336: /*+ parallel(INNER, 4) */
4337: bim_r_even_weekly_facts_s.nextval
4338: ,sysdate
4339: ,sysdate
4340: ,l_user_id
4341: ,l_user_id