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_LEAD_IMPORT_FACTS_PKG dependencies on BIM_R_LIMP_WEEKLY_FACTS

Line 317: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_weekly_facts nologging';

313: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

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 495: p_table_name :='BIM_R_LIMP_WEEKLY_FACTS';

491: ams_utility_pvt.write_conc_log('LEAD IMPORT: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
492: RAISE FND_API.G_EXC_ERROR;
493: end;
494:
495: p_table_name :='BIM_R_LIMP_WEEKLY_FACTS';
496:
497: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
498: fnd_message.set_token('table_name', p_table_name, FALSE);
499: ams_utility_pvt.write_conc_log(fnd_message.get);

Line 501: EXECUTE IMMEDIATE 'truncate table '||l_schema||'. bim_r_limp_weekly_facts';

497: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
498: fnd_message.set_token('table_name', p_table_name, FALSE);
499: ams_utility_pvt.write_conc_log(fnd_message.get);
500:
501: EXECUTE IMMEDIATE 'truncate table '||l_schema||'. bim_r_limp_weekly_facts';
502: --insert into BIM_R_LIMP_WEEKLY_FACTS table
503: BEGIN
504:
505: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 502: --insert into BIM_R_LIMP_WEEKLY_FACTS table

498: fnd_message.set_token('table_name', p_table_name, FALSE);
499: ams_utility_pvt.write_conc_log(fnd_message.get);
500:
501: EXECUTE IMMEDIATE 'truncate table '||l_schema||'. bim_r_limp_weekly_facts';
502: --insert into BIM_R_LIMP_WEEKLY_FACTS table
503: BEGIN
504:
505: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
506: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_WEEKLY_FACTS', FALSE);

Line 506: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_WEEKLY_FACTS', FALSE);

502: --insert into BIM_R_LIMP_WEEKLY_FACTS table
503: BEGIN
504:
505: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
506: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_WEEKLY_FACTS', FALSE);
507: ams_utility_pvt.write_conc_log(fnd_message.get);
508:
509: INSERT INTO
510: BIM_R_LIMP_WEEKLY_FACTS EDF(

Line 510: BIM_R_LIMP_WEEKLY_FACTS EDF(

506: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_WEEKLY_FACTS', FALSE);
507: ams_utility_pvt.write_conc_log(fnd_message.get);
508:
509: INSERT INTO
510: BIM_R_LIMP_WEEKLY_FACTS EDF(
511: weekly_transaction_id,
512: Creation_date,
513: Last_update_date,
514: Created_by,

Line 535: BIM_R_LIMP_WEEKLY_FACTS_S.nextval,

531: leads_new,
532: Weekend_date
533: )
534: SELECT
535: BIM_R_LIMP_WEEKLY_FACTS_S.nextval,
536: sysdate,
537: sysdate,
538: l_user_id,
539: l_user_id,

Line 604: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_weekly_facts', estimate_percent => 5,

600: fnd_message.set_token('table_name', p_table_name, FALSE);
601: ams_utility_pvt.write_conc_log(fnd_message.get);
602:
603: BEGIN
604: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_weekly_facts', estimate_percent => 5,
605: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
606: END;
607:
608: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');

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:

Line 614: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_weekly_facts_s CACHE 20';

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:
617: EXCEPTION
618: