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_FDSP_WEEKLY_FACTS_S

Line 2342: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';

2338: l_table_name :='bim_r_fdsp_weekly_facts';
2339: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2340: fnd_message.set_token('table_name', l_table_name, FALSE);
2341: fnd_file.put_line(fnd_file.log,fnd_message.get);
2342: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
2343: INSERT /*+ append parallel(fwf,p_para_num) */
2344: INTO bim_r_fdsp_weekly_facts fwf(
2345: spend_transaction_id
2346: ,creation_date

Line 2370: bim_r_fdsp_weekly_facts_s.nextval

2366: ,fis_qtr
2367: ,fis_year
2368: )
2369: SELECT /*+ parallel(inner.p_para_num) */
2370: bim_r_fdsp_weekly_facts_s.nextval
2371: ,sysdate
2372: ,sysdate
2373: ,l_user_id
2374: ,l_user_id

Line 2414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';

2410: ,object_type
2411: ,fund_id
2412: ,util_org_id) inner;
2413: EXECUTE IMMEDIATE 'commit';
2414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
2415: EXCEPTION
2416: when others THEN
2417: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
2418: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));

Line 2419: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';

2415: EXCEPTION
2416: when others THEN
2417: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
2418: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));
2419: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
2420: x_return_status := FND_API.G_RET_STS_ERROR;
2421: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2422: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2423: FND_MSG_PUB.Add;

Line 4251: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';

4247: l_table_name :='bim_r_fdsp_weekly_facts';
4248: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4249: fnd_message.set_token('table_name', l_table_name, FALSE);
4250: fnd_file.put_line(fnd_file.log,fnd_message.get);
4251: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
4252: --dbms_output.put_line('inside fist inserting into fdsp weekly');
4253:
4254: --Insert into bim_r_fdsp_weekly_facts
4255: INSERT /*+ append parallel(fwf,p_para_num) */

Line 4282: bim_r_fdsp_weekly_facts_s.nextval

4278: ,fis_qtr
4279: ,fis_year
4280: )
4281: SELECT /*+ parallel(inner.p_para_num) */
4282: bim_r_fdsp_weekly_facts_s.nextval
4283: ,sysdate
4284: ,sysdate
4285: ,l_user_id
4286: ,l_user_id

Line 4326: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';

4322: ,object_type
4323: ,fund_id
4324: ,util_org_id) inner;
4325: EXECUTE IMMEDIATE 'commit';
4326: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
4327: EXCEPTION
4328: when others THEN
4329: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
4330: --dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));

Line 4331: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';

4327: EXCEPTION
4328: when others THEN
4329: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
4330: --dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));
4331: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
4332: x_return_status := FND_API.G_RET_STS_ERROR;
4333: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4334: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4335: FND_MSG_PUB.Add;