APPS.BSC_MO_UI_PKG dependencies on BSC_KPIS_B

Line 479: SELECT count(1) INTO l_total_kpis FROM BSC_KPIS_B;

475: return;
476: end if;
477:
478: -- Only Modified mode, now, all other Modes would have returned.
479: SELECT count(1) INTO l_total_kpis FROM BSC_KPIS_B;
480: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
481: SELECT INDICATOR, prototype_flag, :1
482: FROM BSC_KPIS_VL
483: WHERE (PROTOTYPE_FLAG = 2 OR PROTOTYPE_FLAG = 3) ';

Line 508: l_stmt := 'SELECT INDICATOR FROM BSC_KPIS_B WHERE PROTOTYPE_FLAG = 4

504: --in the collection gIndicadores
505: --Of course if the indicator is already in gIndicadores (Structural changes) we do not change it.
506: --Init an array with the Kpis in prototype 4 (changes in loader configuration)
507:
508: l_stmt := 'SELECT INDICATOR FROM BSC_KPIS_B WHERE PROTOTYPE_FLAG = 4
509: MINUS
510: SELECT INDICATOR FROM BSC_TMP_OPT_ui_kpis WHERE process_id = :1
511: ORDER BY INDICATOR';
512: open cv for l_stmt USING pProcessId;

Line 601: -- Update bsc_kpis_b for all indicators

597: raise;
598: END;
599:
600: -- Incremental Run call from UI
601: -- Update bsc_kpis_b for all indicators
602:
603: PROCEDURE RenameInputTable(pOld IN VARCHAR2, pNew IN VARCHAR2, pStatus OUT NOCOPY VARCHAR2, pMessage OUT NOCOPY VARCHAR2)
604: IS
605: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1245: FROM BSC_KPIS_B

1241: --DBMS_OUTPUT.PUT_LINE(TO_CHAR(l_selected_kpis)||' '||l_cur_kpi);
1242: IF LENGTH(l_cur_kpi) > 0 THEN
1243: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
1244: SELECT INDICATOR, PROTOTYPE_FLAG, :1
1245: FROM BSC_KPIS_B
1246: WHERE INDICATOR = :2 ';
1247: EXECUTE IMMEDIATE l_stmt using pProcessId, l_cur_kpi;
1248: END IF;
1249: l_old_pos := l_cur_pos+1;

Line 1255: SELECT COUNT(1) INTO l_total_kpis FROM BSC_KPIS_B;

1251:
1252: IF (l_selected_kpis = 0) THEN
1253: RETURN;
1254: END IF;
1255: SELECT COUNT(1) INTO l_total_kpis FROM BSC_KPIS_B;
1256: IF (l_selected_kpis = l_total_kpis) THEN
1257: COMMIT;
1258: RETURN;
1259: END IF;

Line 1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))

1270: FROM BSC_KPIS_VL k,
1271: BSC_TMP_OPT_UI_KPIS t
1272: WHERE ((k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR = t.INDICATOR)
1273: OR (k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR IN
1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))
1275: OR (k.SHARE_FLAG = 1 AND k.INDICATOR IN
1276: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR)))
1277: AND t.PROCESS_ID = :2
1278: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE c.indicator = k.indicator AND c.PROCESS_ID = :3)';

Line 1276: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR)))

1272: WHERE ((k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR = t.INDICATOR)
1273: OR (k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR IN
1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))
1275: OR (k.SHARE_FLAG = 1 AND k.INDICATOR IN
1276: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR)))
1277: AND t.PROCESS_ID = :2
1278: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE c.indicator = k.indicator AND c.PROCESS_ID = :3)';
1279: EXECUTE IMMEDIATE l_stmt using pProcessId, pProcessId, pProcessId;
1280: