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_DAILY_FACTS

Line 316: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_daily_facts nologging';

312: -- Initialize API return status to SUCCESS
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';

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 320: p_table_name := 'BIM_R_LIMP_DAILY_FACTS';

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');
323: ams_utility_pvt.write_conc_log(fnd_message.get);
324:

Line 330: fnd_message.set_token('TABLE_NAME', 'BIM_R_LIMP_DAILY_FACTS', FALSE);

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);
331: ams_utility_pvt.write_conc_log(fnd_message.get);
332:
333: BEGIN
334: INSERT INTO /*+ append parallel(EDF,1) */

Line 335: BIM_R_LIMP_DAILY_FACTS EDF(

331: ams_utility_pvt.write_conc_log(fnd_message.get);
332:
333: BEGIN
334: INSERT INTO /*+ append parallel(EDF,1) */
335: BIM_R_LIMP_DAILY_FACTS EDF(
336: Daily_transaction_id,
337: Creation_date,
338: Last_update_date,
339: Created_by,

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 472: -- analyze the bim_r_limp_daily_facts with dbms_stats

468:
469: commit;
470: -- dbms_output.put_line('after daily insert ');
471:
472: -- analyze the bim_r_limp_daily_facts with dbms_stats
473: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
474: fnd_message.set_token('table_name', p_table_name, FALSE);
475: ams_utility_pvt.write_conc_log(fnd_message.get);
476:

Line 479: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_daily_facts', estimate_percent => 5,

475: ams_utility_pvt.write_conc_log(fnd_message.get);
476:
477:
478: BEGIN
479: DBMS_STATS.gather_table_stats('BIM','bim_r_limp_daily_facts', estimate_percent => 5,
480: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
481: END;
482:
483:

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;

Line 573: FROM BIM_R_LIMP_DAILY_FACTS

569: sum(Leads_valid) leads_valid,
570: sum(Leads_invalid) leads_invalid,
571: sum(Leads_new) leads_new,
572: Weekend_date
573: FROM BIM_R_LIMP_DAILY_FACTS
574: group by
575: Lead_Region,
576: Lead_Country,
577: Object_Business_unit_id,

Line 598: -- analyze the bim_r_limp_daily_facts with dbms_stats

594: );
595:
596: COMMIT;
597:
598: -- analyze the bim_r_limp_daily_facts with dbms_stats
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('table_name', p_table_name, FALSE);
601: ams_utility_pvt.write_conc_log(fnd_message.get);
602:

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: