APPS.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_OAF_ANALYSYS_OPT_COMB_V

Line 3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE

3291: /************************************************************************************
3292: ************************************************************************************/
3293:
3294: PROCEDURE Validate_Custom_Measure
3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE

Line 3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE

3292: ************************************************************************************/
3293:
3294: PROCEDURE Validate_Custom_Measure
3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE
3300: , x_return_status OUT NOCOPY VARCHAR2

Line 3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE

3293:
3294: PROCEDURE Validate_Custom_Measure
3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE
3300: , x_return_status OUT NOCOPY VARCHAR2
3301: , x_msg_count OUT NOCOPY NUMBER

Line 3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE

3294: PROCEDURE Validate_Custom_Measure
3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE
3300: , x_return_status OUT NOCOPY VARCHAR2
3301: , x_msg_count OUT NOCOPY NUMBER
3302: , x_msg_data OUT NOCOPY VARCHAR2

Line 3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE

3295: ( p_kpi_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.INDICATOR%TYPE
3296: , p_option0 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION0%TYPE
3297: , p_option1 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION1%TYPE
3298: , p_option2 IN BSC_OAF_ANALYSYS_OPT_COMB_V.ANALYSIS_OPTION2%TYPE
3299: , p_series_id IN BSC_OAF_ANALYSYS_OPT_COMB_V.SERIES_ID%TYPE
3300: , x_return_status OUT NOCOPY VARCHAR2
3301: , x_msg_count OUT NOCOPY NUMBER
3302: , x_msg_data OUT NOCOPY VARCHAR2
3303: ) IS

Line 3306: l_Measure_DatasetId BSC_OAF_ANALYSYS_OPT_COMB_V.DATASET_ID%TYPE;

3302: , x_msg_data OUT NOCOPY VARCHAR2
3303: ) IS
3304: l_Measure_AKRegion BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
3305: l_Measure_Function BIS_INDICATORS.FUNCTION_NAME%TYPE;
3306: l_Measure_DatasetId BSC_OAF_ANALYSYS_OPT_COMB_V.DATASET_ID%TYPE;
3307: l_AnaOpt_AKRegion varchar2(50);
3308: l_position NUMBER;
3309: l_index integer;
3310: l_ret_status varchar2(10);

Line 3318: l_AnaOpt_Name BSC_OAF_ANALYSYS_OPT_COMB_V.FULL_NAME%TYPE;

3314: l_Allow_Delete BOOLEAN;
3315: l_mess_count NUMBER;
3316: l_dep_obj_message varchar2(1000);
3317: l_message varchar2(1000);
3318: l_AnaOpt_Name BSC_OAF_ANALYSYS_OPT_COMB_V.FULL_NAME%TYPE;
3319: l_kpi_name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
3320: l_objective_name BSC_KPIS_VL.NAME%TYPE;
3321: l_objective BSC_KPIS_VL.NAME%TYPE;
3322:

Line 3327: FROM bsc_oaf_analysys_opt_comb_v a,

3323: CURSOR c_Measure_ak IS
3324: SELECT c.actual_data_source actual_data_source , c.function_name function_name
3325: ,a.dataset_id dataset_id
3326: ,a.full_name name
3327: FROM bsc_oaf_analysys_opt_comb_v a,
3328: bsc_sys_datasets_b b,
3329: bis_indicators c
3330: WHERE a.dataset_id = b.dataset_id
3331: AND b.dataset_id = c.dataset_id