eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_EVENT_FACTS dependencies on BIM_R_EVEN_WEEKLY_FACTS

Line 511: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_weekly_facts nologging';

507:
508: BEGIN
509:
510: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
511: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_weekly_facts nologging';
512:
513: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 1000';
514:
515: /*This insert statement is getting transactions book of order, leads happen and event header level between p_start_date and p_end_date */

Line 2451: --insert into bim_r_even_weekly_facts table

2447: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2448: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: END UPDATE FOR COST AND REVENUE.' || l_temp_msg);
2449: commit;
2450:
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';

Line 2453: l_table_name :='bim_r_even_weekly_facts';

2449: commit;
2450:
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');

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 2461: bim_r_even_weekly_facts ewf(

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:
2460: INSERT /*+ append */ INTO
2461: bim_r_even_weekly_facts ewf(
2462: event_weekly_transaction_id
2463: ,creation_date
2464: ,last_update_date
2465: ,created_by

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 2636: /* If there are some data insert into bim_r_even_daily_facts and bim_r_even_weekly_facts, then insert a record into bim_rep_history*/

2632: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2633: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER INSERT INTO WEEKLY FACTS.' || l_temp_msg);
2634: COMMIT;
2635:
2636: /* If there are some data insert into bim_r_even_daily_facts and bim_r_even_weekly_facts, then insert a record into bim_rep_history*/
2637:
2638: --IF SQL%ROWCOUNT >0 THEN
2639:
2640: LOG_HISTORY(

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 2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats

2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));
2671: RAISE FND_API.G_EXC_ERROR;
2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats
2675: BEGIN
2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,
2677: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2678: END;

Line 2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,

2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats
2675: BEGIN
2676: DBMS_STATS.gather_table_stats('BIM','BIM_R_EVEN_WEEKLY_FACTS', estimate_percent => 5,
2677: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2678: END;
2679:
2680: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */

Line 3797: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_weekly_facts nologging';

3793:
3794: BEGIN
3795:
3796: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
3797: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_weekly_facts nologging';
3798:
3799: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 1000';
3800:
3801: --insert into bim_r_even_daily_facts on event header level

Line 4273: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_even_weekly_facts';

4269: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4270: END;
4271:
4272:
4273: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_even_weekly_facts';
4274:
4275: BEGIN
4276: /* insert into bim_r_even_weekly_facts */
4277: l_table_name :='bim_r_even_weekly_facts';

Line 4276: /* insert into bim_r_even_weekly_facts */

4272:
4273: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_even_weekly_facts';
4274:
4275: BEGIN
4276: /* insert into bim_r_even_weekly_facts */
4277: l_table_name :='bim_r_even_weekly_facts';
4278:
4279: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4280: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);

Line 4277: l_table_name :='bim_r_even_weekly_facts';

4273: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_even_weekly_facts';
4274:
4275: BEGIN
4276: /* insert into bim_r_even_weekly_facts */
4277: l_table_name :='bim_r_even_weekly_facts';
4278:
4279: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4280: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);
4281:

Line 4283: bim_r_even_weekly_facts ewf(

4279: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4280: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);
4281:
4282: INSERT /*+ append */ INTO
4283: bim_r_even_weekly_facts ewf(
4284: event_weekly_transaction_id
4285: ,creation_date
4286: ,last_update_date
4287: ,created_by

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