[Home] [Help]
1004: , x_msg_data OUT NOCOPY VARCHAR2
1005: ) IS
1006: l_Region_Code VARCHAR2(30);
1007: l_Function_Code VARCHAR2(30);
1008: l_DimObj_ViewBy_Tbl BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type;
1009: l_count NUMBER := 0;
1010: l_table_index NUMBER := 0;
1011:
1012: l_dimension VARCHAR2(100);
1027: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.get_Dimensions_In_Meas Failed: at BSC_JV_PMF.get_Pmf_Measure');
1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1029: END IF;
1030: END IF;
1031: BIS_PMV_BSC_API_PUB.Get_Dimlevel_Viewby
1032: ( p_api_version => 1
1033: , p_Region_Code => l_Region_Code
1034: , p_Measure_Short_Name => p_measure_short_name
1035: , x_DimLevel_Viewby_Tbl => l_DimObj_ViewBy_Tbl
1037: , x_msg_count => x_msg_count
1038: , x_msg_data => x_msg_data
1039: );
1040: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1041: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.get_DimObj_ViewBy_Tbl Failed: at BIS_PMV_BSC_API_PUB.Get_Dimlevel_Viewby');
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044: FOR i IN 1..l_DimObj_ViewBy_Tbl.COUNT LOOP
1045: l_flag := TRUE;
8016: , p_Property_Type IN VARCHAR2
8017: ) RETURN VARCHAR2 IS
8018: l_region_code AK_REGIONS.REGION_CODE%TYPE;
8019: l_actual_data_source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
8020: l_DimObj_ViewBy_Tbl BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type;
8021: l_return_status VARCHAR2(100);
8022: l_msg_data VARCHAR2(2000);
8023: l_msg_count NUMBER;
8024: l_dim_DimObj VARCHAR2(100);
8029: FROM BIS_INDICATORS
8030: WHERE SHORT_NAME = p_Measure_Short_Name;
8031: l_region_code := SUBSTR(l_actual_data_source, 0, (INSTR(l_actual_data_source,'.')-1));
8032: IF(l_region_code IS NOT NULL) THEN
8033: BIS_PMV_BSC_API_PUB.Get_Dimlevel_Viewby
8034: ( p_Region_Code => l_Region_Code
8035: , p_Measure_Short_Name => p_Measure_Short_Name
8036: , x_DimLevel_Viewby_Tbl => l_DimObj_ViewBy_Tbl
8037: , x_return_status => l_return_status