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_FUND_FACTS dependencies on BIM_R_FUND_WEEKLY_FACTS

Line 975: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts nologging';

971: BEGIN
972:
973: --for performance reasons
974: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts nologging';
975: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts nologging';
976: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts nologging';
977: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_weekly_facts nologging';
978: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';
979:

Line 2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.

2205: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2206: FND_MSG_PUB.Add;
2207: fnd_file.put_line(fnd_file.log,fnd_message.get);
2208: END;
2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.
2210: Weekly table are summarized on daily tables. */
2211: BEGIN
2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 2212: l_table_name :='bim_r_fund_weekly_facts';

2208: END;
2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.
2210: Weekly table are summarized on daily tables. */
2211: BEGIN
2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

Line 2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
2218: fund_transaction_id
2219: ,creation_date
2220: ,last_update_date

Line 2217: INSERT /+ append parallel(fwf,p_para_num) / INTO bim_r_fund_weekly_facts fwf(

2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
2218: fund_transaction_id
2219: ,creation_date
2220: ,last_update_date
2221: ,created_by

Line 2251: bim_r_fund_weekly_facts_s.nextval

2247: ,fis_qtr
2248: ,fis_year
2249: ,business_unit_id)
2250: SELECT /*+ parallel(inner, p_para_num) */
2251: bim_r_fund_weekly_facts_s.nextval
2252: ,sysdate
2253: ,sysdate
2254: ,l_user_id
2255: ,l_user_id

Line 2325: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

2321: ,status
2322: ,original_budget
2323: ,currency_code_fc) inner;
2324: EXECUTE IMMEDIATE 'commit';
2325: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2326: EXCEPTION
2327: WHEN others THEN
2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
2329: -- dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));

Line 2330: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

2326: EXCEPTION
2327: WHEN others THEN
2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
2329: -- dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
2330: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2333: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2334: FND_MSG_PUB.Add;

Line 2474: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts noparallel';

2470: END;
2471:
2472: -- For performance reasons.
2473: BEGIN
2474: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts noparallel';
2475: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_weekly_facts noparallel';
2476: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';
2477: EXCEPTION
2478: WHEN OTHERS THEN

Line 2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

2482: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
2483: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2484: END;
2485: BEGIN
2486: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
2487: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2488: END;
2489: BEGIN
2490: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,

Line 2573: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts nologging';

2569: --dbms_output.put_line('b4 first inserting into fund daily');
2570:
2571: BEGIN -- Alter table for performance reasons
2572: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts nologging';
2573: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts nologging';
2574: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts nologging';
2575: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_weekly_facts nologging';
2576: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';
2577:

Line 4118: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_weekly_facts';

4114: x_msg_count,
4115: x_msg_data,
4116: x_return_status) ;
4117: -- END IF;
4118: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_weekly_facts';
4119: --Start of inserting into 'bim_r_fund_weekly_facts'
4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 4119: --Start of inserting into 'bim_r_fund_weekly_facts'

4115: x_msg_data,
4116: x_return_status) ;
4117: -- END IF;
4118: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_weekly_facts';
4119: --Start of inserting into 'bim_r_fund_weekly_facts'
4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);

Line 4121: l_table_name :='bim_r_fund_weekly_facts';

4117: -- END IF;
4118: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_weekly_facts';
4119: --Start of inserting into 'bim_r_fund_weekly_facts'
4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

Line 4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
4127: fund_transaction_id
4128: ,creation_date
4129: ,last_update_date

Line 4126: INSERT /+ append parallel(fwf,p_para_num) / INTO bim_r_fund_weekly_facts fwf(

4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
4127: fund_transaction_id
4128: ,creation_date
4129: ,last_update_date
4130: ,created_by

Line 4160: bim_r_fund_weekly_facts_s.nextval

4156: ,fis_qtr
4157: ,fis_year
4158: ,business_unit_id)
4159: SELECT /*+ parallel(inner, p_para_num) */
4160: bim_r_fund_weekly_facts_s.nextval
4161: ,sysdate
4162: ,sysdate
4163: ,l_user_id
4164: ,l_user_id

Line 4234: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

4230: ,status
4231: ,original_budget
4232: ,currency_code_fc) inner;
4233: EXECUTE IMMEDIATE 'commit';
4234: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4235: EXCEPTION
4236: WHEN others THEN
4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
4238: --dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));

Line 4239: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

4235: EXCEPTION
4236: WHEN others THEN
4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
4238: --dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
4239: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4240: x_return_status := FND_API.G_RET_STS_ERROR;
4241: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4242: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4243: FND_MSG_PUB.Add;

Line 4339: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts noparallel';

4335: FND_MSG_PUB.Add;
4336: END;
4337: -- for performance reasons
4338: BEGIN
4339: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts noparallel';
4340: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_weekly_facts noparallel';
4341: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';
4342: EXCEPTION
4343: WHEN OTHERS THEN

Line 4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,

4349: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_DAILY_FACTS', estimate_percent => 5,
4350: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4351: END;
4352: BEGIN
4353: DBMS_STATS.gather_table_stats('BIM','BIM_R_FUND_WEEKLY_FACTS', estimate_percent => 5,
4354: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4355: END;
4356: BEGIN
4357: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_DAILY_FACTS', estimate_percent => 5,