[Home] [Help]
204:
205:
206: FUNCTION Is_Assign_To_Tab
207: (
208: p_indicator IN BSC_KPIS_B.indicator%TYPE
209: ,p_tabId IN BSC_TABS_B.tab_id%TYPE
210: )RETURN VARCHAR2 IS
211:
212: l_count NUMBER;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:
885: SELECT COUNT(1) INTO l_Count
886: FROM BSC_KPIS_B
887: WHERE INDICATOR = l_Kpi_Id;
888: IF l_count = 0 THEN
889: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
890: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','KPI'));
1839: l_Has_One_Row NUMBER;
1840: BEGIN
1841: SELECT COUNT(1)
1842: INTO l_Has_One_Row
1843: FROM BSC_KPIS_B A
1844: WHERE A.SHORT_NAME = p_Portlet_Function_Name
1845: AND A.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
1846:
1847: IF (l_Has_One_Row > 0) THEN
2098: l_Time_Dim_obj_sns:= p_Time_Dim_obj_sns;
2099: IF (p_Time_Dim_obj_sns IS NULL AND p_Is_XTD_Enabled = FND_API.G_TRUE) THEN
2100: SELECT CALENDAR_ID
2101: INTO l_kpi_calendar_id
2102: FROM BSC_KPIS_B
2103: WHERE INDICATOR = p_kpi_id;
2104: IF (l_kpi_calendar_id IS NOT NULL) THEN
2105: l_Time_Dim_obj_sns := BSC_PERIODS_UTILITY_PKG.Get_Daily_Periodicity_Sht_Name(l_kpi_calendar_id);
2106: END IF;
2662: -- when there is no matching, return -1000 to inform the caller
2663: -- Fixed for Bug#3781764 added PROTOTYPE_FLAG
2664: SELECT K.INDICATOR
2665: INTO l_Kpi_Id
2666: FROM BSC_KPIS_B K
2667: WHERE K.SHORT_NAME = p_Page_Function_Name
2668: AND K.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
2669:
2670: RETURN l_kpi_id;
3426:
3427: This function assumes the Short_Name passed is valid and exists in
3428: BSC Metadata. It will not be checked from BSC tables due to performance reasons.
3429:
3430: p_Short_Name Corresponds to BSC_KPIS_B.Short_Name
3431: */
3432: FUNCTION is_KPI_EndToEnd_KPI(p_Short_Name VARCHAR2)
3433: RETURN VARCHAR2 IS
3434: BEGIN
4450: l_Kpi_Id NUMBER;
4451:
4452: CURSOR c_Production IS
4453: SELECT PROTOTYPE_FLAG
4454: FROM BSC_KPIS_B
4455: WHERE INDICATOR = l_Kpi_Id;
4456:
4457: BEGIN
4458: l_Prototype_Flag := 3;
5755: -- Pass the KPI Back;
5756: x_Kpi_Id := l_Kpi_Id;
5757:
5758: -- called Delete_Kpi_AT() to remove AT created KPI base metadata, Bug#4064587
5759: -- its necessary to be called, since there would be still metadata left in BSC_KPIS_B/TL table.
5760: EXCEPTION
5761: WHEN FND_API.G_EXC_ERROR THEN
5762:
5763: ROLLBACK TO CreateBscBisMetadata;
8376: END IF;
8377:
8378: SELECT DISTINCT INDICATOR
8379: INTO l_Kpi_Id
8380: FROM BSC_KPIS_B
8381: WHERE SHORT_NAME = (SELECT SUBSTR(ACTUAL_DATA_SOURCE, 1, INSTR(ACTUAL_DATA_SOURCE, '.') - 1) REGION_CODE
8382: FROM BIS_INDICATORS
8383: WHERE SHORT_NAME = p_Short_Name);
8384:
10271: ) RETURN VARCHAR2 IS
10272: l_Region_Code BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;
10273: BEGIN
10274: SELECT G.SHORT_NAME INTO l_Region_Code
10275: FROM BSC_KPIS_B K,
10276: BSC_KPI_DIM_GROUPS KG,
10277: BSC_SYS_DIM_GROUPS_VL G
10278: WHERE K.SHORT_NAME = p_Page_Function_Name
10279: AND KG.INDICATOR = K.INDICATOR
10916:
10917: BEGIN
10918:
10919: SELECT COUNT(1) INTO l_Count
10920: FROM BSC_KPIS_B K
10921: , BSC_KPI_DIM_GROUPS KG
10922: , BSC_SYS_DIM_GROUPS_VL G
10923: WHERE
10924: K.INDICATOR = p_Kpi_Id
11300: , x_Return_Status OUT NOCOPY VARCHAR2
11301: , x_Msg_Count OUT NOCOPY NUMBER
11302: , x_Msg_Data OUT NOCOPY VARCHAR2
11303: ) IS
11304: l_Kpi_Id BSC_KPIS_B.INDICATOR%TYPE;
11305: x_Non_Time_Dimension_Groups BSC_VARCHAR2_TBL_TYPE;
11306: x_Non_Time_Dimension_Objects BSC_VARCHAR2_TBL_TYPE;
11307: x_Non_Time_Dim_Obj_Short_Names VARCHAR2(2056);
11308: x_Time_Dimension_Groups BSC_VARCHAR2_TBL_TYPE;