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_I_BGT_FACTS_PKG dependencies on BIM_I_BUDGET_FACTS_STG

Line 402: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';

398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: error:'||sqlerrm(sqlcode));
399: --dbms_output.put_line('error first:'||sqlerrm(sqlcode));
400: END;
401: l_table_name :='BIM_I_BUDGET_FACTS';
402: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
403: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');
405: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
406: INSERT /*+ append parallel */

Line 404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');

400: END;
401: l_table_name :='BIM_I_BUDGET_FACTS';
402: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
403: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');
405: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
406: INSERT /*+ append parallel */
407: INTO BIM_I_BUDGET_FACTS_STG CDF(
408: creation_date

Line 407: INTO BIM_I_BUDGET_FACTS_STG CDF(

403: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');
405: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
406: INSERT /*+ append parallel */
407: INTO BIM_I_BUDGET_FACTS_STG CDF(
408: creation_date
409: ,last_update_date
410: ,created_by
411: ,last_updated_by

Line 1411: from bim_i_budget_facts_stg);

1407: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
1408: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
1409: FROM (select distinct from_currency from_currency,
1410: transaction_create_date transaction_create_date
1411: from bim_i_budget_facts_stg);
1412: commit;
1413: l_check_missing_rate := Check_Missing_Rates (p_start_date);
1414: if (l_check_missing_rate = -1) then
1415: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );

Line 1416: l_stmt := 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_stg';

1412: commit;
1413: l_check_missing_rate := Check_Missing_Rates (p_start_date);
1414: if (l_check_missing_rate = -1) then
1415: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1416: l_stmt := 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_stg';
1417: EXECUTE IMMEDIATE l_stmt;
1418: commit;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1524: FROM bim_i_budget_facts_stg inner, bim_i_bgt_rates rt

1520: inner.committed*sec_conversion_rate,
1521: inner.utilized*sec_conversion_rate,
1522: inner.accrual*sec_conversion_rate,
1523: inner.paid*sec_conversion_rate
1524: FROM bim_i_budget_facts_stg inner, bim_i_bgt_rates rt
1525: where inner.from_currency = rt.tc_code
1526: and inner.transaction_create_date= rt.trx_date;
1527: commit;
1528: --dbms_output.put_line('b4 put into history');

Line 1685: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';

1681: when others then
1682: BIS_COLLECTION_UTILITIES.log('BIM_I_budget_facts: Error in deleting data:'|| sqlerrm(sqlcode));
1683: --dbms_output.put_line('error inserting:'||sqlerrm(sqlcode));
1684: END;
1685: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
1686: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
1687: --dbms_output.put_line('right b4 inserting');
1688: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental load start');
1689: INSERT INTO BIM_I_BUDGET_FACTS_STG CDF(

Line 1689: INSERT INTO BIM_I_BUDGET_FACTS_STG CDF(

1685: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
1686: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
1687: --dbms_output.put_line('right b4 inserting');
1688: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental load start');
1689: INSERT INTO BIM_I_BUDGET_FACTS_STG CDF(
1690: creation_date
1691: ,last_update_date
1692: ,created_by
1693: ,last_updated_by

Line 2687: from bim_i_budget_facts_stg);

2683: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2684: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2685: FROM (select distinct from_currency from_currency,
2686: transaction_create_date transaction_create_date
2687: from bim_i_budget_facts_stg);
2688:
2689: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2690: if (l_check_missing_rate = -1) then
2691: DELETE from BIM_I_BUDGET_FACTS_stg where transaction_create_date>= p_start_date;

Line 2691: DELETE from BIM_I_BUDGET_FACTS_stg where transaction_create_date>= p_start_date;

2687: from bim_i_budget_facts_stg);
2688:
2689: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2690: if (l_check_missing_rate = -1) then
2691: DELETE from BIM_I_BUDGET_FACTS_stg where transaction_create_date>= p_start_date;
2692: commit;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2695: end if;

Line 2792: FROM bim_i_budget_facts_stg inner, bim_i_bgt_rates rt

2788: inner.committed*sec_conversion_rate,
2789: inner.utilized*sec_conversion_rate,
2790: inner.accrual*sec_conversion_rate,
2791: inner.paid*sec_conversion_rate
2792: FROM bim_i_budget_facts_stg inner, bim_i_bgt_rates rt
2793: where inner.from_currency = rt.tc_code
2794: and inner.transaction_create_date= rt.trx_date;
2795:
2796: -- Analyze the daily facts table