APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_KPI_CALCULATIONS

Line 344: l_YTD_Value bsc_kpi_calculations.default_Value%TYPE;

340: ,x_msg_count OUT NOCOPY NUMBER
341: ,x_msg_data OUT NOCOPY VARCHAR2
342: ) IS
343:
344: l_YTD_Value bsc_kpi_calculations.default_Value%TYPE;
345: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
346: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
347: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
348: l_Count NUMBER := 0;

Line 353: bsc_kpi_calculations

349: CURSOR c_YTD_Value IS
350: SELECT
351: default_value
352: FROM
353: bsc_kpi_calculations
354: WHERE
355: indicator = p_Indicator AND
356: calculation_id = 2; -- YTD Default Value
357:

Line 402: bsc_kpi_calculations

398: FETCH c_Is_YTD_Valid INTO l_Count;
399: IF l_Count > 0 THEN
400: -- If YTD calculation is disabled at the measure level then disable it for the new default kpi
401: UPDATE
402: bsc_kpi_calculations
403: SET
404: default_value = 0,
405: user_level0 = 1,
406: user_level1 = 1