APPS.BSC_UPDATE_INC dependencies on BSC_KPIS_B

Line 256: UPDATE bsc_kpis_b

252: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicators(h_calendar_id) THEN
253: RAISE e_could_not_get_lock;
254: END IF;
255:
256: UPDATE bsc_kpis_b
257: SET prototype_flag = 0, last_update_date = SYSDATE
258: WHERE prototype_flag IN (6, 7) AND calendar_id = h_calendar_id;
259:
260: -- Color By KPI: Mark KPIs for color re-calculation

Line 265: WHERE indicator IN (SELECT indicator FROM bsc_kpis_b WHERE calendar_id = h_calendar_id);

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
268: COMMIT;
269: END LOOP;

Line 479: 'FROM bsc_kpis_b obj ' ||

475: -- Insert into the array x_color_indicators the indicators
476: -- indicators with prototype flag = 7
477:
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 ' ||

Line 1201: ' FROM bsc_kpis_b'||

1197:
1198: -- LOCKING: review not commit between this point and the commit to release the locks
1199:
1200: h_sql := 'SELECT DISTINCT calendar_id'||
1201: ' FROM bsc_kpis_b'||
1202: ' WHERE ('||h_where_indics||')';
1203:
1204: OPEN h_cursor FOR h_sql;
1205: FETCH h_cursor INTO h_calendar_id;

Line 1369: h_sql := 'UPDATE bsc_kpis_b'||

1365: h_where_indics VARCHAR2(32000);
1366: h_i NUMBER;
1367: BEGIN
1368: IF (BSC_UPDATE.g_kpi_mode) AND (BSC_UPDATE.g_num_indicators > 0) THEN
1369: h_sql := 'UPDATE bsc_kpis_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

Line 1387: UPDATE bsc_kpis_b

1383: h_sql_kpi := h_sql_kpi || ' AND (' || h_where_indics || ')';
1384: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1385: BSC_UPDATE_UTIL.Execute_Immediate(h_sql_kpi);
1386: ELSE
1387: UPDATE bsc_kpis_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