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.

[Home] [Help]

APPS.BSC_BIS_WRAPPER_PVT dependencies on BSC_BIS_MEASURES_DATA

Line 60: FROM bsc_bis_measures_data

56: BEGIN
57: l_value := NULL;
58:
59: SELECT actual_data INTO l_value
60: FROM bsc_bis_measures_data
61: WHERE user_id = p_user_id AND
62: responsibility_id = p_responsibility_id AND
63: indicator = p_kpi_code AND
64: analysis_option0 = p_analysis_option0 AND

Line 1012: FROM bsc_bis_measures_data

1008: BEGIN
1009: l_value := NULL;
1010:
1011: SELECT budget_data INTO l_value
1012: FROM bsc_bis_measures_data
1013: WHERE user_id = p_user_id AND
1014: responsibility_id = p_responsibility_id AND
1015: indicator = p_kpi_code AND
1016: analysis_option0 = p_analysis_option0 AND

Line 1747: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has

1743: l_db_user_id := BSC_APPS.fnd_global_user_id;
1744:
1745: --dbms_output.put_line('*l_db_user_id='||l_db_user_id);
1746:
1747: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has
1748: --been deleted, has been changed or user has not access.
1749:
1750: DELETE FROM
1751: bsc_bis_measures_data m

Line 1751: bsc_bis_measures_data m

1747: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has
1748: --been deleted, has been changed or user has not access.
1749:
1750: DELETE FROM
1751: bsc_bis_measures_data m
1752: WHERE
1753: m.user_id = p_user_id AND
1754: m.responsibility_id = p_responsibility_id AND
1755: m.indicator IN (

Line 1784: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination

1780: ));
1781:
1782: --dbms_output.put_line('*after delete');
1783:
1784: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination
1785: -- of each kpi which user has access and belongs to the given tab.
1786:
1787: l_sql := 'SELECT tk.indicator'||
1788: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||

Line 1792: ' FROM bsc_bis_measures_data'||

1788: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||
1789: ' WHERE tk.tab_id = :1 AND tk.indicator = ka.indicator AND ka.responsibility_id = :2';
1790:
1791: l_caching_sql := 'SELECT caching_key'||
1792: ' FROM bsc_bis_measures_data'||
1793: ' WHERE user_id = :1 AND responsibility_id = :2 AND indicator = :3 AND'||
1794: ' analysis_option0 = :4 AND analysis_option1 = :5 AND analysis_option2 = :6 AND'||
1795: ' series_id = :7';
1796:

Line 1797: l_update_sql := 'UPDATE bsc_bis_measures_data'||

1793: ' WHERE user_id = :1 AND responsibility_id = :2 AND indicator = :3 AND'||
1794: ' analysis_option0 = :4 AND analysis_option1 = :5 AND analysis_option2 = :6 AND'||
1795: ' series_id = :7';
1796:
1797: l_update_sql := 'UPDATE bsc_bis_measures_data'||
1798: ' SET actual_data = :a, budget_data = :b, caching_key = :c,'||
1799: ' last_updated_by = :d, last_update_date = :e'||
1800: ' WHERE user_id = :f AND responsibility_id = :g AND indicator = :h AND'||
1801: ' analysis_option0 = :i AND analysis_option1 = :j AND analysis_option2 = :k AND'||

Line 1804: l_insert_sql := 'INSERT INTO bsc_bis_measures_data (user_id, responsibility_id, indicator,'||

1800: ' WHERE user_id = :f AND responsibility_id = :g AND indicator = :h AND'||
1801: ' analysis_option0 = :i AND analysis_option1 = :j AND analysis_option2 = :k AND'||
1802: ' series_id = :l';
1803:
1804: l_insert_sql := 'INSERT INTO bsc_bis_measures_data (user_id, responsibility_id, indicator,'||
1805: ' analysis_option0, analysis_option1, analysis_option2, series_id,'||
1806: ' caching_key, actual_data, budget_data, created_by, creation_date,'||
1807: ' last_updated_by, last_update_date, last_update_login)'||
1808: ' VALUES (:a, :b, :c, :d, :e, :f, :g, :h, :i, :j, :k, :l, :m, :n, :o)';

Line 1909: -- Update actual and target in BSC_BIS_MEASURES_DATA

1905:
1906: -- Insert/Update
1907: FOR i IN 1..l_kpi_info_tbl.COUNT LOOP
1908: IF l_kpi_info_tbl(i).insert_update_flag = 'U' THEN
1909: -- Update actual and target in BSC_BIS_MEASURES_DATA
1910: EXECUTE IMMEDIATE l_update_sql USING l_kpi_info_tbl(i).actual_value,
1911: l_kpi_info_tbl(i).target_value, p_caching_key, l_db_user_id,
1912: l_sysdate, p_user_id, p_responsibility_id, l_kpi_info_tbl(i).kpi_code,
1913: l_kpi_info_tbl(i).analysis_option0, l_kpi_info_tbl(i).analysis_option1,

Line 1918: -- Insert actual and target in BSC_BIS_MEASURES_DATA

1914: l_kpi_info_tbl(i).analysis_option2, l_kpi_info_tbl(i).series_id;
1915:
1916: --dbms_output.put_line('*update executed');
1917: ELSE
1918: -- Insert actual and target in BSC_BIS_MEASURES_DATA
1919: EXECUTE IMMEDIATE l_insert_sql USING p_user_id, p_responsibility_id,
1920: l_kpi_info_tbl(i).kpi_code, l_kpi_info_tbl(i).analysis_option0,
1921: l_kpi_info_tbl(i).analysis_option1, l_kpi_info_tbl(i).analysis_option2,
1922: l_kpi_info_tbl(i).series_id, p_caching_key,

Line 2806: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination

2802: l_db_user_id := BSC_APPS.fnd_global_user_id;
2803:
2804: --dbms_output.put_line('*l_db_user_id='||l_db_user_id);
2805:
2806: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination
2807: -- of each kpi which user has access and belongs to the given tab.
2808:
2809: l_sql := 'SELECT tk.indicator'||
2810: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||

Line 2814: ' FROM bsc_bis_measures_data'||

2810: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||
2811: ' WHERE tk.tab_id = :1 AND tk.indicator = ka.indicator AND ka.responsibility_id = :2';
2812:
2813: l_caching_sql := 'SELECT caching_key'||
2814: ' FROM bsc_bis_measures_data'||
2815: ' WHERE user_id = :1 AND responsibility_id = :2 AND indicator = :3 AND'||
2816: ' analysis_option0 = :4 AND analysis_option1 = :5 AND analysis_option2 = :6 AND'||
2817: ' series_id = :7';
2818:

Line 2819: l_update_sql := 'UPDATE bsc_bis_measures_data'||

2815: ' WHERE user_id = :1 AND responsibility_id = :2 AND indicator = :3 AND'||
2816: ' analysis_option0 = :4 AND analysis_option1 = :5 AND analysis_option2 = :6 AND'||
2817: ' series_id = :7';
2818:
2819: l_update_sql := 'UPDATE bsc_bis_measures_data'||
2820: ' SET actual_data = :a, budget_data = :b, caching_key = :c,'||
2821: ' last_updated_by = :d, last_update_date = :e'||
2822: ' WHERE user_id = :f AND responsibility_id = :g AND indicator = :h AND'||
2823: ' analysis_option0 = :i AND analysis_option1 = :j AND analysis_option2 = :k AND'||

Line 2826: l_insert_sql := 'INSERT INTO bsc_bis_measures_data (user_id, responsibility_id, indicator,'||

2822: ' WHERE user_id = :f AND responsibility_id = :g AND indicator = :h AND'||
2823: ' analysis_option0 = :i AND analysis_option1 = :j AND analysis_option2 = :k AND'||
2824: ' series_id = :l';
2825:
2826: l_insert_sql := 'INSERT INTO bsc_bis_measures_data (user_id, responsibility_id, indicator,'||
2827: ' analysis_option0, analysis_option1, analysis_option2, series_id,'||
2828: ' caching_key, actual_data, budget_data, created_by, creation_date,'||
2829: ' last_updated_by, last_update_date, last_update_login)'||
2830: ' VALUES (:a, :b, :c, :d, :e, :f, :g, :h, :i, :j, :k, :l, :m, :n, :o)';

Line 2839: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has

2835: IF (p_kpi_info_tbl(i).kpi_code IS NOT NULL) AND (p_kpi_info_tbl(i).analysis_option0 IS NOT NULL) AND
2836: (p_kpi_info_tbl(i).analysis_option1 IS NOT NULL) AND (p_kpi_info_tbl(i).analysis_option2 IS NOT NULL) AND
2837: (p_kpi_info_tbl(i).series_id IS NOT NULL) THEN
2838:
2839: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has
2840: --been deleted, has been changed or user has not access.
2841:
2842: DELETE FROM
2843: bsc_bis_measures_data m

Line 2843: bsc_bis_measures_data m

2839: --Delete from BSC_BIS_MEASURES_DATA kpis that belong to the given tab, which has
2840: --been deleted, has been changed or user has not access.
2841:
2842: DELETE FROM
2843: bsc_bis_measures_data m
2844: WHERE
2845: m.user_id = p_user_id AND
2846: m.responsibility_id = p_responsibility_id AND
2847: m.indicator = p_kpi_info_tbl(i).kpi_code

Line 2879: -- Update actual and target in BSC_BIS_MEASURES_DATA

2875: FETCH cv_caching INTO l_caching_key;
2876: IF cv_caching%FOUND THEN
2877: --dbms_output.put_line('*l_caching_key='||l_caching_key);
2878: -- The record exists --> Calculate data and update if caching key is different
2879: -- Update actual and target in BSC_BIS_MEASURES_DATA
2880: EXECUTE IMMEDIATE l_update_sql USING p_kpi_info_tbl(i).actual_value,
2881: p_kpi_info_tbl(i).target_value, p_caching_key, l_db_user_id,
2882: l_sysdate, p_user_id, p_responsibility_id, p_kpi_info_tbl(i).kpi_code,
2883: p_kpi_info_tbl(i).analysis_option0, p_kpi_info_tbl(i).analysis_option1,

Line 2890: -- Insert actual and target in BSC_BIS_MEASURES_DATA

2886: --dbms_output.put_line('*update executed');
2887:
2888: ELSE
2889: -- The record does not exists --> Calculate data and Insert
2890: -- Insert actual and target in BSC_BIS_MEASURES_DATA
2891: EXECUTE IMMEDIATE l_insert_sql USING p_user_id, p_responsibility_id,
2892: p_kpi_info_tbl(i).kpi_code, p_kpi_info_tbl(i).analysis_option0,
2893: p_kpi_info_tbl(i).analysis_option1, p_kpi_info_tbl(i).analysis_option2,
2894: p_kpi_info_tbl(i).series_id, p_caching_key,