APPS.BSC_CALENDAR_PUB dependencies on BSC_SYS_PERIODICITIES

Line 344: FROM bsc_sys_periodicities

340: , x_Msg_Data OUT NOCOPY VARCHAR2
341: )IS
342: CURSOR C_Periodicity_ShortNames IS
343: SELECT short_name
344: FROM bsc_sys_periodicities
345: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
346:
347: CURSOR C_Per_Views IS
348: SELECT B.level_values_view_name

Line 349: FROM bsc_sys_periodicities P,

345: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
346:
347: CURSOR C_Per_Views IS
348: SELECT B.level_values_view_name
349: FROM bsc_sys_periodicities P,
350: bis_levels B
351: WHERE b.short_name = P.short_name
352: AND P.calendar_id = p_Calendar_Record.Calendar_Id
353: AND P.db_column_name IS NOT NULL;

Line 615: BSC_SYS_PERIODICITIES S

611: l_count := 0;
612: SELECT COUNT(K.INDICATOR)
613: INTO l_count
614: FROM BSC_KPI_PERIODICITIES K,
615: BSC_SYS_PERIODICITIES S
616: WHERE S.PERIODICITY_ID = K.PERIODICITY_ID
617: AND S.CALENDAR_ID = p_Calendar_Record.Calendar_Id;
618:
619: SELECT name

Line 1119: bsc_sys_periodicities S

1115:
1116: CURSOR C_FLAG_OBJECTIVES IS
1117: SELECT DISTINCT(K.indicator)
1118: FROM bsc_kpi_periodicities K,
1119: bsc_sys_periodicities S
1120: WHERE S.periodicity_id = K.periodicity_id
1121: AND S.calendar_id = p_Calendar_Id;
1122:
1123: BEGIN

Line 1196: FROM BSC_SYS_PERIODICITIES

1192: l_Count NUMBER;
1193:
1194: CURSOR c_base_per (p_calendar_id NUMBER, p_custom_code NUMBER) IS
1195: SELECT PERIODICITY_ID
1196: FROM BSC_SYS_PERIODICITIES
1197: WHERE CALENDAR_ID = p_calendar_id
1198: AND CUSTOM_CODE < p_custom_code
1199: ORDER BY PERIODICITY_ID;
1200:

Line 1203: FROM BSC_SYS_PERIODICITIES

1199: ORDER BY PERIODICITY_ID;
1200:
1201: CURSOR c_new_per (p_calendar_id NUMBER) IS
1202: SELECT PERIODICITY_ID,SOURCE
1203: FROM BSC_SYS_PERIODICITIES
1204: WHERE CALENDAR_ID = p_calendar_id
1205: ORDER BY PERIODICITY_ID;
1206:
1207: CURSOR c_get_per (p_calendar_id NUMBER, p_periodicity_type NUMBER) IS

Line 1209: FROM BSC_SYS_PERIODICITIES

1205: ORDER BY PERIODICITY_ID;
1206:
1207: CURSOR c_get_per (p_calendar_id NUMBER, p_periodicity_type NUMBER) IS
1208: SELECT PERIODICITY_ID
1209: FROM BSC_SYS_PERIODICITIES
1210: WHERE CALENDAR_ID = p_calendar_id
1211: AND PERIODICITY_TYPE = p_periodicity_type;
1212:
1213: BEGIN

Line 1257: FROM bsc_sys_periodicities_vl

1253: , l_Periodicity_Record.Custom_Code
1254: , l_Periodicity_Record.Db_Column_Name
1255: , l_Periodicity_Record.Periodicity_Type
1256: , l_Periodicity_Record.Name
1257: FROM bsc_sys_periodicities_vl
1258: WHERE periodicity_id = CD.periodicity_id;
1259:
1260: IF (p_Calendar_Record.Base_Periodicities_Ids IS NOT NULL) THEN
1261: IF (l_Periodicity_Count > 0) THEN

Line 1299: UPDATE bsc_sys_periodicities

1295: END IF;
1296: CLOSE c_get_per;
1297: END LOOP;
1298:
1299: UPDATE bsc_sys_periodicities
1300: SET source = h_new_source
1301: WHERE periodicity_id = cd_new_per.periodicity_id;
1302: END IF;
1303: END LOOP;