DBA Data[Home] [Help]

APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_SYS_DATASETS_VL

Line 972: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;

968: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
969: l_Bsc_AnaOpt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
970: l_Count NUMBER := 0;
971: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
972: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
973: l_commit VARCHAR2(2) := FND_API.G_FALSE;
974:
975: l_config_type bsc_kpis_b.config_type%TYPE;
976: l_indicator_type bsc_kpis_b.indicator_type%TYPE;

Line 3147: l_Measure_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';

3143: l_GrandParent_Option_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE;
3144: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3145: l_Create_Group BOOLEAN := FALSE;
3146: l_commit VARCHAR2(2) := FND_API.G_FALSE;
3147: l_Measure_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
3148:
3149: l_temp_Parent_Id NUMBER := NULL;
3150: l_temp_GrandParent_Id NUMBER := NULL;
3151: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

Line 3261: FROM bsc_sys_datasets_vl

3257:
3258: IF p_Dataset_id IS NOT NULL THEN
3259: SELECT source
3260: INTO l_measure_source
3261: FROM bsc_sys_datasets_vl
3262: WHERE dataset_id = p_Dataset_id;
3263: END IF;
3264: --IF l_measure_source = 'BSC' THEN
3265: Bsc_Analysis_Option_Pvt.Create_Analysis_Options (