DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_KPI_PERIODICITIES

Line 163: REM | is not updating bsc_kpi_periodicities |

159: REM | an AG Report is not showing warning |
160: REM | 26-SEP-2005 arhegde bug# 4624100 Moved get_format_mask code to |
161: REM | BSC_BIS_CUSTOM_KPI_UTIL_PUB since pure BIS can use it too. |
162: REM | 28-SEP-2005 akoduri Bug #4626935 Unchecking all the periodicities|
163: REM | is not updating bsc_kpi_periodicities |
164: REM | 26-SEP-2005 ashankar Bug#4619367 Made chnages to the following API|
165: REM | 1.Has_Time_Dim_Obj_Changed |
166: REM | 2.Has_Measure_Column_Changed |
167: REM | 30-SEP-2005 adrao Modified code to ensure that the compare is |

Line 9212: FROM BSC_KPI_PERIODICITIES K

9208:
9209: l_Calendar_Id := l_Calendar_Id_Aux;
9210:
9211: SELECT COUNT(1) INTO l_Count
9212: FROM BSC_KPI_PERIODICITIES K
9213: WHERE K.INDICATOR = p_Kpi_Id
9214: AND K.PERIODICITY_ID = l_Periodicity_Id;
9215:
9216: IF(NOT BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(l_Periodicity_Id))THEN

Line 9230: FROM BSC_KPI_PERIODICITIES K

9226:
9227: END LOOP;
9228:
9229: SELECT COUNT(1) INTO l_Count
9230: FROM BSC_KPI_PERIODICITIES K
9231: WHERE K.INDICATOR = p_Kpi_Id;
9232:
9233: -- We need to ignore the DAY365, since it is mandatory.
9234: IF ((p_Is_Xtd <> FND_API.G_TRUE) AND (NOT l_Daily_Found)) THEN