APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_KPIS_B

Line 44: -- BSC_KPIS_B.SHORT_NAME and BSC_TABS_B.SHORT_NAME have existed before Start-to-End KPI.

40: REM +=======================================================================+
41: */
42:
43: -- changed to use BSC_KPI_ANALYSIS_OPTIONS_B
44: -- BSC_KPIS_B.SHORT_NAME and BSC_TABS_B.SHORT_NAME have existed before Start-to-End KPI.
45:
46:
47: PROCEDURE SetGlobalFlag
48: IS

Line 131: l_kpi_id BSC_KPIS_B.INDICATOR%TYPE;

127: ) IS
128:
129: l_tab_id BSC_TABS_B.TAB_ID%TYPE;
130: l_kpi_group_id BSC_TAB_IND_GROUPS_B.IND_GROUP_ID%TYPE;
131: l_kpi_id BSC_KPIS_B.INDICATOR%TYPE;
132: l_tab_name BSC_TABS_VL.NAME%TYPE;
133: l_tab_ind_group_name BSC_TAB_IND_GROUPS_VL.NAME%TYPE;
134: not_S_To_E_Kpi EXCEPTION;
135:

Line 748: FROM BSC_KPIS_B K

744:
745: l_Count := 0;
746:
747: SELECT COUNT(1) INTO l_Count
748: FROM BSC_KPIS_B K
749: WHERE K.SHORT_NAME = p_Region_Function_Name;
750:
751: IF l_Count <> 0 THEN
752: RETURN 'N';

Line 787: FROM bsc_kpis_b

783:
784: IF (l_Count <> 0) THEN
785: SELECT COUNT(0)
786: INTO l_Count
787: FROM bsc_kpis_b
788: WHERE short_name = p_Short_Name
789: AND config_Type =7;
790: IF(l_Count <> 0) THEN
791: RETURN FND_API.G_FALSE;

Line 797: FROM BSC_KPIS_B

793: RETURN FND_API.G_TRUE;
794: END IF;
795: ELSE -- Bug#4476730
796: SELECT COUNT(1) INTO l_Count
797: FROM BSC_KPIS_B
798: WHERE SHORT_NAME = p_Short_Name
799: AND PROTOTYPE_FLAG = BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_DELETED_OBJECTIVE_FLAG; -- deleted flag
800: -- bug 5959433 we don't need following condition here
801: -- in simulation flow code won't come here