APPS.BSC_UPDATE dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 2842: UPDATE bsc_kpi_analysis_measures_b

2838: x_indicator IN NUMBER
2839: ) RETURN BOOLEAN IS
2840: BEGIN
2841: -- Color By KPI: Mark KPIs for color re-calculation
2842: UPDATE bsc_kpi_analysis_measures_b
2843: SET prototype_flag = 7
2844: WHERE indicator = x_indicator;
2845:
2846: RETURN TRUE;

Line 3609: UPDATE bsc_kpi_analysis_measures_b

3605: SET prototype_flag = 0, last_updated_by = BSC_APPS.fnd_global_user_id, last_update_date = SYSDATE
3606: WHERE indicator = h_color_indicators(h_i) AND prototype_flag IN (6, 7);
3607:
3608: -- Color By KPI: Mark KPIs for color done
3609: UPDATE bsc_kpi_analysis_measures_b
3610: SET prototype_flag = 0
3611: WHERE indicator = h_color_indicators(h_i) AND prototype_flag = 7;
3612:
3613: --LOCKING: commit to release the lock