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_DAILY_FACTS_S

Line 1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';

1541: l_table_name :='bim_r_fdsp_daily_facts';
1542: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */
1548: BEGIN
1549: INSERT /*+ append parallel(bfl,p_para_num) */

Line 1680: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

1676: EXCEPTION
1677: WHEN OTHERS THEN
1678: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
1679: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
1680: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1683: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1684: FND_MSG_PUB.Add;

Line 1722: bim_r_fdsp_daily_facts_s.nextval,

1718: ,fis_qtr
1719: ,fis_year
1720: )
1721: SELECT /*+ parallel(inner, p_para_num) */
1722: bim_r_fdsp_daily_facts_s.nextval,
1723: sysdate,
1724: sysdate,
1725: l_user_id,
1726: l_user_id,

Line 1879: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

1875: AND AU.transaction_create_date (+) BETWEEN TRUNC(AD.trdate) AND TRUNC(AD.trdate) + 0.99999
1876: ) inner;
1877: l_count :=l_count +SQL%ROWCOUNT;
1878: EXECUTE IMMEDIATE 'COMMIT';
1879: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
1883: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));

Line 1884: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
1883: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
1884: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1885: x_return_status := FND_API.G_RET_STS_ERROR;
1886: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1887: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1888: FND_MSG_PUB.Add;

Line 1922: bim_r_fdsp_daily_facts_s.nextval,

1918: ,fis_qtr
1919: ,fis_year
1920: )
1921: SELECT
1922: bim_r_fdsp_daily_facts_s.nextval,
1923: sysdate,
1924: sysdate,
1925: l_user_id,
1926: l_user_id,

Line 3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';

3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN
3300: INSERT /*+ append parallel(bfl,p_para_num) */
3301: INTO bim_r_fdsp_load bfl(

Line 3430: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

3426: EXCEPTION
3427: WHEN OTHERS THEN
3428: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
3429: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
3430: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3433: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3434: FND_MSG_PUB.Add;

Line 3471: bim_r_fdsp_daily_facts_s.nextval,

3467: ,fis_qtr
3468: ,fis_year
3469: )
3470: SELECT /*+ parallel(inner, p_para_num) */
3471: bim_r_fdsp_daily_facts_s.nextval,
3472: sysdate,
3473: sysdate,
3474: l_user_id,
3475: l_user_id,

Line 3622: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

3618: AND AU.fund_id = AD.fund_id
3619: ) inner;
3620: l_count :=l_count +SQL%ROWCOUNT;
3621: EXECUTE IMMEDIATE 'COMMIT';
3622: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3623: EXCEPTION
3624: WHEN OTHERS THEN
3625: FND_FILE.put_line(fnd_file.log,'first insert:error insert fdsp daily'||sqlerrm(sqlcode));
3626: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));

Line 3627: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';

3623: EXCEPTION
3624: WHEN OTHERS THEN
3625: FND_FILE.put_line(fnd_file.log,'first insert:error insert fdsp daily'||sqlerrm(sqlcode));
3626: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
3627: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3628: x_return_status := FND_API.G_RET_STS_ERROR;
3629: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3630: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3631: FND_MSG_PUB.Add;

Line 3666: bim_r_fdsp_daily_facts_s.nextval,

3662: ,fis_qtr
3663: ,fis_year
3664: )
3665: SELECT /*+ parallel(inner, p_para_num) */
3666: bim_r_fdsp_daily_facts_s.nextval,
3667: sysdate,
3668: sysdate,
3669: l_user_id,
3670: l_user_id,

Line 3861: bim_r_fdsp_daily_facts_s.nextval,

3857: ,fis_qtr
3858: ,fis_year
3859: )
3860: SELECT /*+ parallel(inner, p_para_num) */
3861: bim_r_fdsp_daily_facts_s.nextval,
3862: sysdate,
3863: sysdate,
3864: l_user_id,
3865: l_user_id,

Line 3954: bim_r_fdsp_daily_facts_s.nextval,

3950: ,fis_qtr
3951: ,fis_year
3952: )
3953: SELECT /*+ parallel(inner, p_para_num) */
3954: bim_r_fdsp_daily_facts_s.nextval,
3955: sysdate,
3956: sysdate,
3957: l_user_id,
3958: l_user_id,