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_DAILY_FACTS_S

Line 978: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';

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:
980: l_table_name :='bim_r_fund_daily_facts';
981: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
982: fnd_message.set_token('TABLE_NAME','bim_r_fund_daily_facts', FALSE);

Line 1020: bim_r_fund_daily_facts_s.nextval,

1016: ,fis_qtr
1017: ,fis_year
1018: ,business_unit_id)
1019: SELECT /*+ parallel(inner, p_para_num) */
1020: bim_r_fund_daily_facts_s.nextval,
1021: sysdate,
1022: sysdate,
1023: l_user_id,
1024: l_user_id,

Line 1295: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';

1291: original_budget
1292: )inner;
1293: l_count:=l_count+SQL%ROWCOUNT;
1294: EXECUTE IMMEDIATE 'COMMIT';
1295: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1296: EXCEPTION
1297: WHEN others THEN
1298: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1299: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1298: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';

1294: EXECUTE IMMEDIATE 'COMMIT';
1295: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1296: EXCEPTION
1297: WHEN others THEN
1298: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1301: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1302: FND_MSG_PUB.Add;

Line 1348: bim_r_fund_daily_facts_s.nextval,

1344: ,fis_year
1345: ,business_unit_id)
1346: -- ,security_group_id)
1347: SELECT
1348: bim_r_fund_daily_facts_s.nextval,
1349: sysdate,
1350: sysdate,
1351: l_user_id,
1352: l_user_id,

Line 2143: bim_r_fund_daily_facts_s.nextval,

2139: ,fis_qtr
2140: ,fis_year
2141: ,business_unit_id)
2142: SELECT
2143: bim_r_fund_daily_facts_s.nextval,
2144: sysdate,
2145: sysdate,
2146: l_user_id,
2147: l_user_id,

Line 2576: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';

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:
2578: /* First insert: Insert transactions happened between p_start_date and p_end_date. */
2579: INSERT /*+ append parallel(fdf,p_para_num) */
2580: INTO bim_r_fund_daily_facts fdf(

Line 2615: bim_r_fund_daily_facts_s.nextval,

2611: ,fis_year
2612: ,business_unit_id)
2613: --,security_group_id)
2614: SELECT /*+ parallel(inner, p_para_num) */
2615: bim_r_fund_daily_facts_s.nextval,
2616: sysdate,
2617: sysdate,
2618: l_user_id,
2619: l_user_id,

Line 2795: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';

2791: original_budget
2792: )inner;
2793: l_count:=l_count+SQL%ROWCOUNT;
2794: EXECUTE IMMEDIATE 'COMMIT';
2795: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
2796: EXCEPTION
2797: WHEN others THEN
2798: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily'||sqlerrm(sqlcode));
2799: --dbms_output.put_line('error inserting INTO bim_r_fund_daily_facts'||sqlerrm(sqlcode));

Line 2800: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';

2796: EXCEPTION
2797: WHEN others THEN
2798: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily'||sqlerrm(sqlcode));
2799: --dbms_output.put_line('error inserting INTO bim_r_fund_daily_facts'||sqlerrm(sqlcode));
2800: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2803: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2804: FND_MSG_PUB.Add;

Line 2849: bim_r_fund_daily_facts_s.nextval,

2845: ,fis_year
2846: ,business_unit_id)
2847: --,security_group_id)
2848: SELECT /*+ parallel(inner, p_para_num) */
2849: bim_r_fund_daily_facts_s.nextval,
2850: sysdate,
2851: sysdate,
2852: l_user_id,
2853: l_user_id,

Line 3084: bim_r_fund_daily_facts_s.nextval,

3080: ,fis_year
3081: ,business_unit_id)
3082: --,security_group_id)
3083: SELECT /*+ parallel(inner, p_para_num) */
3084: bim_r_fund_daily_facts_s.nextval,
3085: sysdate,
3086: sysdate,
3087: l_user_id,
3088: l_user_id,

Line 3207: bim_r_fund_daily_facts_s.nextval,

3203: ,fis_year
3204: ,business_unit_id)
3205: --,security_group_id)
3206: SELECT /*+ parallel(inner, p_para_num) */
3207: bim_r_fund_daily_facts_s.nextval,
3208: sysdate,
3209: sysdate,
3210: l_user_id,
3211: l_user_id,

Line 4041: bim_r_fund_daily_facts_s.nextval,

4037: ,fis_qtr
4038: ,fis_year
4039: ,business_unit_id)
4040: SELECT
4041: bim_r_fund_daily_facts_s.nextval,
4042: sysdate,
4043: sysdate,
4044: l_user_id,
4045: l_user_id,