APPS.BSC_UPDATE_INC dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 263: UPDATE bsc_kpi_analysis_measures_b

259:
260: -- Color By KPI: Mark KPIs for color re-calculation
261: -- We need to update KPI Prototype flag since it is a Calendar change.
262: -- We would not have done so had it been a Periodicity change.
263: UPDATE bsc_kpi_analysis_measures_b
264: SET prototype_flag = 7
265: WHERE indicator IN (SELECT indicator FROM bsc_kpis_b WHERE calendar_id = h_calendar_id);
266:
267: --LOCKING: commit to release the lock

Line 482: 'SELECT 1 FROM bsc_kpi_analysis_measures_b kpi_meas ' ||

478: h_sql := 'SELECT DISTINCT indicator ' ||
479: 'FROM bsc_kpis_b obj ' ||
480: 'WHERE ( obj.prototype_flag = :1 ' ||
481: 'OR ( obj.prototype_flag = :2 AND EXISTS ( ' ||
482: 'SELECT 1 FROM bsc_kpi_analysis_measures_b kpi_meas ' ||
483: 'WHERE kpi_meas.indicator = obj.indicator ' ||
484: 'AND kpi_meas.prototype_flag = :3 ' ||
485: ')' ||
486: ')' ||

Line 1374: h_sql_kpi := 'UPDATE bsc_kpi_analysis_measures_b ' ||

1370: ' SET prototype_flag = 0, last_update_date = SYSDATE'||
1371: ' WHERE prototype_flag IN (6, 7)';
1372:
1373: -- Color By KPI: Mark KPIs for color re-calculation
1374: h_sql_kpi := 'UPDATE bsc_kpi_analysis_measures_b ' ||
1375: ' SET prototype_flag = 0 ' ||
1376: ' WHERE prototype_flag = 7 ';
1377:
1378: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

Line 1392: UPDATE bsc_kpi_analysis_measures_b

1388: SET prototype_flag = 0, last_update_date = SYSDATE
1389: WHERE prototype_flag IN (6, 7);
1390:
1391: -- Color By KPI: Mark KPIs for color re-calculation
1392: UPDATE bsc_kpi_analysis_measures_b
1393: SET prototype_flag = 0
1394: WHERE prototype_flag = 7;
1395: END IF;
1396: