[Home] [Help]
24: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
25: --***************************************************************************
26: Function IsIndicatorPnL(Ind IN Integer) return Boolean IS
27: CURSOR cBalance IS
28: SELECT indicator_type, config_type FROM BSC_KPIS_VL where INDICATOR= Ind;
29: l_indicator_type NUMBER;
30: l_config_type NUMBER;
31: BEGIN
32: If l_indicator_type = 1 And l_config_type = 3 Then
51: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
52: --***************************************************************************
53: Function IsIndicatorBalance(Ind IN NUMBER) return Boolean IS
54: CURSOR cBalance IS
55: SELECT indicator_type, config_type FROM BSC_KPIS_VL where INDICATOR= Ind;
56: l_indicator_type NUMBER;
57: l_config_type NUMBER;
58: BEGIN
59: OPEN cBalance;
82: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
83: --***************************************************************************
84: Function IsIndicatorBalanceOrPnL(Ind IN Integer) return Boolean IS
85: CURSOR cBalance IS
86: SELECT indicator_type, config_type FROM BSC_KPIS_VL where INDICATOR= Ind;
87: l_indicator_type NUMBER;
88: l_config_type NUMBER;
89: BEGIN
90: OPEN cBalance;
879:
880: FUNCTION Get_Fact_Info(p_process_id IN NUMBER, p_prototype_flag IN NUMBER, p_fact_list IN DBMS_SQL.NUMBER_TABLE ) return BSC_DBGEN_STD_METADATA.tab_clsFact IS
881: l_stmt varchar2(1000);
882: l_Code number;
883: l_Name BSC_KPIS_VL.NAME%TYPE;
884: l_IndicatorType number;
885: l_ConfigType number;
886: l_per_inter number;
887: l_OptimizationMode number;
898:
899: l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
900: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
901: SHARE_FLAG, SOURCE_INDICATOR
902: FROM BSC_KPIS_VL ';
903: IF (p_process_id IS NOT NULL) THEN
904: l_stmt := l_stmt || ' where prototype_flag =:prototype_flag and indicator in
905: (SELECT to_number(fact_name) FROM BSC_DB_GEN_KPI_LIST WHERE process_id = :process_ID)';
906: l_Stmt := l_stmt || ' ORDER BY INDICATOR ';
1735: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2 (1, p_levels(i));
1736: END LOOP;
1737: --insert the children
1738: l_stmt := 'SELECT distinct dim.INDICATOR, dim.DIM_SET_ID, kpi.name , ''BSC''
1739: FROM BSC_KPI_DIM_LEVELS_B dim, BSC_KPIS_VL kpi
1740: WHERE dim.indicator = kpi.indicator and ('|| l_stmt||') order by indicator, dim_set_id';
1741: OPEN cv FOR l_stmt;
1742: LOOP
1743: FETCH cv INTO l_fact.fact_id, l_fact.dimension_set(1), l_fact.fact_name, l_fact.application_short_name;
2207:
2208: function get_year_periodicity_for_fact(p_fact varchar2) return number is
2209: cursor cYearPeriodicity IS
2210: select p.periodicity_id from
2211: bsc_sys_periodicities p, bsc_kpis_vl k
2212: where
2213: p.yearly_flag =1
2214: and p.calendar_id=k.calendar_id
2215: and k.indicator = to_number(p_fact);
2234:
2235: -- changed for bug 4549520
2236: cursor cCurrentYearFromCal IS
2237: select c.fiscal_year
2238: from bsc_sys_calendars_b c, bsc_kpis_vl k
2239: where c.calendar_id = k.calendar_id
2240: and k.indicator = to_number(p_fact);
2241:
2242: l_current_year NUMBER;
2407:
2408: function get_all_facts_in_aw return dbms_sql.varchar2_table is
2409: CURSOR cAWFacts IS
2410: SELECT kpi.indicator
2411: FROM BSC_KPIS_VL KPI,
2412: BSC_KPI_PROPERTIES PROP
2413: WHERE KPI.INDICATOR = PROP.INDICATOR
2414: AND PROP.PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE
2415: AND PROP.PROPERTY_VALUE = '2';
2604: begin
2605: select count(1) into l_count
2606: from bsc_kpi_dim_levels_b lvl,
2607: bsc_kpi_properties prop,
2608: bsc_kpis_vl kpis
2609: where kpis.indicator= lvl.indicator
2610: and kpis.indicator=prop.indicator
2611: and lvl.level_table_name=p_level_name
2612: and prop.property_code='IMPLEMENTATION_TYPE'
2645:
2646: select count(1) into l_count
2647: from bsc_kpi_dim_levels_b lvl,
2648: bsc_kpi_properties prop,
2649: bsc_kpis_vl kpis
2650: where kpis.indicator= lvl.indicator
2651: and kpis.indicator=prop.indicator
2652: and lvl.level_table_name=p_level_name
2653: and prop.property_code='IMPLEMENTATION_TYPE'
2790:
2791:
2792: function get_last_update_date_for_fact(p_fact in varchar2) return date is
2793: cursor cdate is
2794: select last_update_date from bsc_kpis_vl
2795: where indicator=p_fact;
2796: l_date date;
2797: begin
2798: open cdate;