APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_SYS_PERIODICITIES

Line 2084: FROM BSC_sys_periodicities a

2080: l_Time_Dim_Object BIS_LEVELS.SHORT_NAME%TYPE;
2081:
2082: CURSOR c_YearPeriodity IS
2083: SELECT a.PERIODICITY_ID
2084: FROM BSC_sys_periodicities a
2085: WHERE a.CALENDAR_id = l_calendar_id
2086: AND a.PERIODICITY_TYPE = 9;
2087:
2088: CURSOR c1(p_Calendar NUMBER) IS

Line 7026: -- call the DBI API to populate DBI Calendars into BSC_SYS_CALENDARS and BSC_SYS_PERIODICITIES.

7022:
7023: FND_MSG_PUB.Initialize;
7024: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
7025:
7026: -- call the DBI API to populate DBI Calendars into BSC_SYS_CALENDARS and BSC_SYS_PERIODICITIES.
7027: BSC_DBI_CALENDAR.Load_Dbi_Cal_Metadata(l_Error_Msg);
7028:
7029: IF (l_Error_Msg IS NOT NULL) THEN
7030: FND_MESSAGE.SET_NAME('BSC','BSC_ERR_LOAD_DBI_CAL_METADATA');

Line 9636: FROM BSC_SYS_PERIODICITIES P

9632: BEGIN
9633: l_Count := 0;
9634:
9635: SELECT COUNT(1) INTO l_Count
9636: FROM BSC_SYS_PERIODICITIES P
9637: WHERE P.SHORT_NAME = p_Short_Name;
9638:
9639: IF (l_Count <> 0) THEN
9640: RETURN FND_API.G_TRUE;

Line 9675: -- except that it queries directly from the BSC_SYS_PERIODICITIES table

9671: RETURN FND_API.G_FALSE;
9672: END Is_Dimension_Calendar;
9673:
9674: -- This API is similar to BSC_DBI_CALENDAR.get_bsc_Periodicity,
9675: -- except that it queries directly from the BSC_SYS_PERIODICITIES table
9676: PROCEDURE Get_Non_DBI_Periodicities (
9677: p_Time_Short_Name IN VARCHAR2
9678: , x_Periodicity_Id OUT NOCOPY VARCHAR2
9679: , x_Calendar_Id OUT NOCOPY VARCHAR2

Line 9697: FROM BSC_SYS_PERIODICITIES B

9693: END IF;
9694:
9695: SELECT B.PERIODICITY_ID, B.CALENDAR_ID
9696: INTO x_Periodicity_Id, x_Calendar_Id
9697: FROM BSC_SYS_PERIODICITIES B
9698: WHERE B.SHORT_NAME = p_Time_Short_Name;
9699:
9700: EXCEPTION
9701: WHEN NO_DATA_FOUND THEN