APPS.BIM_I_BGT_FACTS_PKG dependencies on BIM_I_BGT_RATES

Line 23: FROM BIM_I_BGT_RATES

19: CURSOR C_missing_rates1
20: IS
21: SELECT tc_code from_currency,
22: decode(prim_conversion_rate,-3,to_date('01/01/1999','MM/DD/RRRR'),trx_date) transaction_create_date
23: FROM BIM_I_BGT_RATES
24: WHERE prim_conversion_rate < 0
25: AND tc_code is not null
26: AND trx_date >= p_start_date
27: ORDER BY tc_code,

Line 34: FROM BIM_I_BGT_RATES

30: CURSOR C_missing_rates2
31: IS
32: SELECT tc_code from_currency,
33: decode(sec_conversion_rate,-3,to_date('01/01/1999','MM/DD/RRRR'),trx_date) transaction_create_date
34: FROM BIM_I_BGT_RATES
35: WHERE sec_conversion_rate < 0
36: AND tc_code is not null
37: AND trx_date >= p_start_date
38: ORDER BY tc_code,

Line 42: SELECT COUNT(*) INTO l_cnt_miss_rate1 FROM BIM_I_BGT_RATES

38: ORDER BY tc_code,
39: trx_date ;
40: BEGIN
41: l_msg_name:= 'BIS_DBI_CURR_NO_LOAD';
42: SELECT COUNT(*) INTO l_cnt_miss_rate1 FROM BIM_I_BGT_RATES
43: WHERE
44: prim_conversion_rate < 0
45: AND tc_code is not null
46: AND trx_date >= p_start_date;

Line 48: SELECT COUNT(*) INTO l_cnt_miss_rate2 FROM BIM_I_BGT_RATES

44: prim_conversion_rate < 0
45: AND tc_code is not null
46: AND trx_date >= p_start_date;
47:
48: SELECT COUNT(*) INTO l_cnt_miss_rate2 FROM BIM_I_BGT_RATES
49: WHERE
50: sec_conversion_rate <0
51: AND tc_code is not null
52: AND trx_date >= p_start_date;

Line 403: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';

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 */
407: INTO BIM_I_BUDGET_FACTS_STG CDF(

Line 1398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');

1394: metric_type,
1395: conversion_rate_s
1396: )inner;
1397: commit;
1398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
1399: --insert into bim_i_mkt_rates
1400: INSERT /*+ append parallel */
1401: INTO BIM_I_BGT_RATES BRT(tc_code,
1402: trx_date,

Line 1401: INTO BIM_I_BGT_RATES BRT(tc_code,

1397: commit;
1398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
1399: --insert into bim_i_mkt_rates
1400: INSERT /*+ append parallel */
1401: INTO BIM_I_BGT_RATES BRT(tc_code,
1402: trx_date,
1403: prim_conversion_rate,
1404: sec_conversion_rate)
1405: SELECT from_currency,

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 1686: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';

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(
1690: creation_date

Line 2674: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');

2670: metric_type,
2671: conversion_rate_s
2672: )inner;
2673:
2674: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
2675: --insert into bim_i_mkt_rates
2676: INSERT
2677: INTO BIM_I_BGT_RATES BRT(tc_code,
2678: trx_date,

Line 2677: INTO BIM_I_BGT_RATES BRT(tc_code,

2673:
2674: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
2675: --insert into bim_i_mkt_rates
2676: INSERT
2677: INTO BIM_I_BGT_RATES BRT(tc_code,
2678: trx_date,
2679: prim_conversion_rate,
2680: sec_conversion_rate)
2681: SELECT from_currency,

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