[Home] [Help]
1166: sp.periodicity_id ,
1167: sc.fiscal_year
1168: FROM
1169: bsc_kpi_periodicities kp,
1170: bsc_sys_periodicities_vl sp,
1171: bsc_sys_calendars_vl sc
1172: WHERE
1173: kp.indicator = p_Target_Indicator AND
1174: sp.periodicity_id = kp.periodicity_id AND
1252: , x_return_status OUT NOCOPY VARCHAR2
1253: , x_msg_count OUT NOCOPY NUMBER
1254: , x_msg_data OUT NOCOPY VARCHAR2
1255: )IS
1256: l_Source_Per_Type bsc_sys_periodicities.periodicity_type%TYPE;
1257: l_Target_Per_Type bsc_sys_periodicities.periodicity_type%TYPE;
1258: l_sql VARCHAR2(32000);
1259: TYPE c_cur_type IS REF CURSOR;
1260: c_cursor c_cur_type;
1253: , x_msg_count OUT NOCOPY NUMBER
1254: , x_msg_data OUT NOCOPY VARCHAR2
1255: )IS
1256: l_Source_Per_Type bsc_sys_periodicities.periodicity_type%TYPE;
1257: l_Target_Per_Type bsc_sys_periodicities.periodicity_type%TYPE;
1258: l_sql VARCHAR2(32000);
1259: TYPE c_cur_type IS REF CURSOR;
1260: c_cursor c_cur_type;
1261: l_Source_Calendar bsc_kpis_b.calendar_id%TYPE;
1262: l_Default_Periodicity bsc_kpis_b.periodicity_id%TYPE;
1263: l_New_Periodicity bsc_kpis_b.periodicity_id%TYPE := NULL;
1264: l_Count NUMBER := 0;
1265: l_Deleted_Periodicities FND_TABLE_OF_NUMBER;
1266: l_Periodicity_Id bsc_sys_periodicities.periodicity_id%TYPE;
1267: l_Found BOOLEAN := FALSE;
1268: BEGIN
1269:
1270: FND_MSG_PUB.Initialize;
1335: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
1336: FETCH c_cursor INTO l_Source_Calendar;
1337: CLOSE c_cursor;
1338:
1339: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT periodicity_type FROM bsc_sys_periodicities');
1340: l_sql := l_sql || 'WHERE calendar_id = :1 AND periodicity_id = :2 ';
1341:
1342: OPEN c_cursor FOR l_sql USING l_Source_Calendar, p_Old_Periodicities(i);
1343: FETCH c_cursor INTO l_Source_Per_Type;
1347: periodicity_type
1348: INTO
1349: l_Target_Per_Type
1350: FROM
1351: bsc_sys_periodicities
1352: WHERE
1353: calendar_id = p_Target_Calendar AND
1354: periodicity_id = p_New_Periodicities(i);
1355: