APPS.BSC_UPDATE_COLOR dependencies on BSC_KPIS_B

Line 105: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;

101: h_dim_index NUMBER;
102: l_message VARCHAR2(4000);
103:
104: l_ag_report BOOLEAN;
105: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;
106: l_short_name BSC_KPIS_B.SHORT_NAME%TYPE;
107: BEGIN
108:
109: SELECT config_type, short_name into l_config_type,l_short_name

Line 106: l_short_name BSC_KPIS_B.SHORT_NAME%TYPE;

102: l_message VARCHAR2(4000);
103:
104: l_ag_report BOOLEAN;
105: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;
106: l_short_name BSC_KPIS_B.SHORT_NAME%TYPE;
107: BEGIN
108:
109: SELECT config_type, short_name into l_config_type,l_short_name
110: FROM bsc_kpis_b

Line 110: FROM bsc_kpis_b

106: l_short_name BSC_KPIS_B.SHORT_NAME%TYPE;
107: BEGIN
108:
109: SELECT config_type, short_name into l_config_type,l_short_name
110: FROM bsc_kpis_b
111: WHERE indicator=p_objective_color_rec.objective_id;
112:
113: l_ag_report := (l_short_name is not null) and l_config_type <> 7;
114: FOR l_objective_kpis IN c_objective_kpis(p_objective_color_rec.objective_id) LOOP

Line 300: FROM bsc_kpis_b

296: l_config_type NUMBER;
297: BEGIN
298: SELECT config_type
299: INTO l_config_type
300: FROM bsc_kpis_b
301: WHERE indicator=p_objective_id;
302:
303: IF( l_config_type = 3) THEN
304: l_color_method := 1;

Line 1722: bsc_kpis_b kpi

1718: --kpi.apply_color_flag,
1719: kpi.indicator_type,
1720: kpi.config_type
1721: FROM bsc_tab_indicators ti,
1722: bsc_kpis_b kpi
1723: WHERE ti.indicator = kpi.indicator
1724: AND kpi.prototype_flag <> 2
1725: AND kpi.indicator = p_indicator;
1726: l_objective_color_props c_objective_color_props%ROWTYPE;

Line 1735: FROM bsc_kpis_b

1731: h_cursor t_cursor;
1732:
1733: CURSOR c_indic_type ( pIndicator number ) is
1734: SELECT indicator_type, config_type
1735: FROM bsc_kpis_b
1736: WHERE indicator = pIndicator ;
1737:
1738: TYPE t_indic_type IS RECORD (
1739: indicator_type bsc_kpis_b.indicator_type%TYPE

Line 1739: indicator_type bsc_kpis_b.indicator_type%TYPE

1735: FROM bsc_kpis_b
1736: WHERE indicator = pIndicator ;
1737:
1738: TYPE t_indic_type IS RECORD (
1739: indicator_type bsc_kpis_b.indicator_type%TYPE
1740: , config_type bsc_kpis_b.config_type%TYPE
1741: );
1742: h_indic_type t_indic_type;
1743:

Line 1740: , config_type bsc_kpis_b.config_type%TYPE

1736: WHERE indicator = pIndicator ;
1737:
1738: TYPE t_indic_type IS RECORD (
1739: indicator_type bsc_kpis_b.indicator_type%TYPE
1740: , config_type bsc_kpis_b.config_type%TYPE
1741: );
1742: h_indic_type t_indic_type;
1743:
1744: CURSOR c_indic_transformation(pIndicator number,pPropertyCode varchar2) is

Line 3046: l_rollup_type bsc_kpis_b.color_rollup_type%TYPE;

3042: ,x_kpi_measure_id OUT NOCOPY NUMBER
3043: ,x_color_flag OUT NOCOPY BOOLEAN
3044: ) IS
3045:
3046: l_rollup_type bsc_kpis_b.color_rollup_type%TYPE;
3047: e_unexpected_error EXCEPTION;
3048:
3049: BEGIN
3050: