[Home] [Help]
2500: l_index number;
2501: l_variable_id number := 1;
2502: CURSOR c1(p_session_id NUMBER, p_variable_id NUMBER) IS
2503: SELECT nvl(sysm.measure_col, tmp.value_v) measure_col
2504: FROM bsc_sys_measures sysm, bsc_tmp_big_in_cond tmp
2505: where tmp.session_id = p_session_id
2506: and tmp.variable_id = p_variable_id
2507: and tmp.value_v = sysm.short_name(+)
2508: order by tmp.value_n;
2506: and tmp.variable_id = p_variable_id
2507: and tmp.value_v = sysm.short_name(+)
2508: order by tmp.value_n;
2509: begin
2510: DELETE bsc_tmp_big_in_cond WHERE session_id=l_session_id and variable_id=l_variable_id;
2511: l_index := p_short_names.first;
2512: LOOP
2513: EXIT WHEN p_short_names.count=0;
2514: --l_counter := l_counter+1;
2511: l_index := p_short_names.first;
2512: LOOP
2513: EXIT WHEN p_short_names.count=0;
2514: --l_counter := l_counter+1;
2515: INSERT INTO BSC_TMP_BIG_IN_COND (session_id, variable_id, value_n, value_v)
2516: VALUES (l_session_id, l_variable_id, l_index/*l_counter*/, p_short_names(l_index));
2517: EXIT WHEN l_index = p_short_names.last;
2518: l_index := p_short_names.next(l_index);
2519: END LOOP;
2539: l_index number;
2540: l_variable_id number := 1;
2541: CURSOR c1(p_session_id NUMBER, p_variable_id NUMBER) IS
2542: SELECT nvl(sysd.level_table_name, tmp.value_v) level_table_name
2543: FROM bsc_sys_dim_levels_b sysd, bsc_tmp_big_in_cond tmp
2544: where tmp.session_id = p_session_id
2545: and tmp.variable_id = p_variable_id
2546: and tmp.value_v = sysd.short_name(+)
2547: order by tmp.value_n;
2546: and tmp.value_v = sysd.short_name(+)
2547: order by tmp.value_n;
2548: l_counter number;
2549: begin
2550: DELETE bsc_tmp_big_in_cond WHERE session_id=l_session_id and variable_id=l_variable_id;
2551: l_index := p_short_names.first;
2552: LOOP
2553: EXIT WHEN p_short_names.count=0;
2554: INSERT INTO BSC_TMP_BIG_IN_COND (session_id, variable_id, value_n, value_v)
2550: DELETE bsc_tmp_big_in_cond WHERE session_id=l_session_id and variable_id=l_variable_id;
2551: l_index := p_short_names.first;
2552: LOOP
2553: EXIT WHEN p_short_names.count=0;
2554: INSERT INTO BSC_TMP_BIG_IN_COND (session_id, variable_id, value_n, value_v)
2555: VALUES (l_session_id, l_variable_id, l_index/*l_counter*/, p_short_names(l_index));
2556: EXIT WHEN l_index = p_short_names.last;
2557: l_index := p_short_names.next(l_index);
2558: END LOOP;
2637: return false;
2638: END IF;
2639: -- now see if objectives being processed have these levels
2640: l_session_id := userenv('SESSIONID');
2641: delete bsc_tmp_big_in_cond where session_id=l_session_id and variable_id=1;
2642: FORALL i in 1..BSC_DBGEN_METADATA_READER.g_assume_production_facts.count
2643: insert into bsc_tmp_big_in_cond (session_id, variable_id, value_n) values (l_session_id, 1,
2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));
2645:
2639: -- now see if objectives being processed have these levels
2640: l_session_id := userenv('SESSIONID');
2641: delete bsc_tmp_big_in_cond where session_id=l_session_id and variable_id=1;
2642: FORALL i in 1..BSC_DBGEN_METADATA_READER.g_assume_production_facts.count
2643: insert into bsc_tmp_big_in_cond (session_id, variable_id, value_n) values (l_session_id, 1,
2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));
2645:
2646: select count(1) into l_count
2647: from bsc_kpi_dim_levels_b lvl,
2653: and prop.property_code='IMPLEMENTATION_TYPE'
2654: and prop.property_value=2
2655: and kpis.prototype_flag<>2
2656: and kpis.indicator in
2657: (select value_n from bsc_tmp_big_in_cond where session_id=l_session_id
2658: and variable_id=1);
2659: if l_count > 0 then
2660: return true;
2661: end if;