DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_PERIODS_UTILITY_PKG

Line 2105: l_Time_Dim_obj_sns := BSC_PERIODS_UTILITY_PKG.Get_Daily_Periodicity_Sht_Name(l_kpi_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;
2107: END IF;
2108:
2109:

Line 2133: l_flag := BSC_PERIODS_UTILITY_PKG.Get_Bsc_Periodicity(

2129: ELSE
2130:
2131: -- Fixed for Bug#4566634
2132: l_Time_Dim_Object := l_Time_Dim_Obj_sh;
2133: l_flag := BSC_PERIODS_UTILITY_PKG.Get_Bsc_Periodicity(
2134: x_time_level_name => l_Time_Dim_Object
2135: ,x_periodicity_id => l_periodicity_Id
2136: ,x_calendar_id => l_calendar_id_aux
2137: ,x_message => l_message

Line 9190: l_flag := BSC_PERIODS_UTILITY_PKG.Get_Bsc_Periodicity(

9186: l_Periodicity_Id := NULL;
9187:
9188: l_Time_Dim_Object := l_Time_Dim_Obj_Short_Name;
9189:
9190: l_flag := BSC_PERIODS_UTILITY_PKG.Get_Bsc_Periodicity(
9191: x_time_level_name => l_Time_Dim_Object
9192: ,x_periodicity_id => l_Periodicity_Id
9193: ,x_calendar_id => l_Calendar_Id_Aux
9194: ,x_message => l_Message

Line 9216: IF(NOT BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(l_Periodicity_Id))THEN

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
9217: l_Loop_Count := l_Loop_Count + 1;
9218: ELSE
9219: l_Daily_Found := TRUE;
9220: END IF;