[Home] [Help]
4437:
4438: Procedure InitIndicators IS
4439: l_stmt varchar2(1000);
4440: l_Code number;
4441: l_Name BSC_KPIS_VL.NAME%TYPE;
4442: l_IndicatorType number;
4443: l_ConfigType number;
4444: l_per_inter number;
4445: l_OptimizationMode number;
4496:
4497: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
4498: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
4499: SHARE_FLAG, SOURCE_INDICATOR,
4500: EDW_FLAG FROM BSC_KPIS_VL ';
4501:
4502: IF BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE = 0 THEN
4503: l_stmt := l_stmt || ' where short_name is null OR
4504: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = ''OBJECTIVE'')';
4507: -- as ALL should now exclude KPIs created using report designer
4508: DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;
4509: INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)
4510: SELECT INDICATOR, PROTOTYPE_FLAG, BSC_METADATA_OPTIMIZER_PKG.g_processID
4511: FROM BSC_KPIS_VL
4512: where short_name is null OR
4513: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = 'OBJECTIVE');
4514: l_objectives_count := SQL%ROWCOUNT;
4515: commit;
4512: where short_name is null OR
4513: (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = 'OBJECTIVE');
4514: l_objectives_count := SQL%ROWCOUNT;
4515: commit;
4516: SELECT COUNT(1) INTO l_total_count FROM BSC_KPIS_VL;
4517: IF (l_objectives_count <> l_total_count) THEN -- there are autogenerated reports, dont process them
4518: BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE := 1;
4519: ELSE
4520: writeTmp('Entire system consists of objectives, no autogenerated reports found', FND_LOG.LEVEL_PROCEDURE, true);
4575: --Init an array with the Kpis in prototype 4 (changes in loader configuration)
4576: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
4577: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
4578: SHARE_FLAG, SOURCE_INDICATOR,
4579: EDW_FLAG FROM BSC_KPIS_VL WHERE INDICATOR in
4580: (select indicator from bsc_tmp_opt_ui_kpis where prototype_flag =4 and process_id= :1) ORDER BY INDICATOR';
4581: open cv for l_stmt using BSC_METADATA_OPTIMIZER_PKG.g_processID;
4582: BSC_METADATA_OPTIMIZER_PKG.logProgress('INIT', 'Indics with non structural changes are');
4583: LOOP
4639: IF BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 THEN
4640: --There is change of summarization level
4641: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG, INDICATOR_TYPE,
4642: CONFIG_TYPE, PERIODICITY_ID, SHARE_FLAG, SOURCE_INDICATOR,
4643: EDW_FLAG FROM BSC_KPIS_VL ';
4644: -- added for selected indicators
4645: l_stmt := l_stmt ||' WHERE INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=:1) ';
4646: IF (BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0) And (BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 > 0) THEN
4647: l_stmt := l_stmt ||' AND (' || strWhereNotInIndics || ') AND ('|| strWhereNotInIndics4 || ')';
7262: l_count number;
7263: begin
7264: select count(1) into l_count
7265: from bsc_kpi_properties p
7266: , bsc_kpis_vl k
7267: where p.indicator=k.indicator
7268: and p.property_code=bsc_metadata_optimizer_pkg.impl_type
7269: and p.property_value = 2
7270: -- only production objectives