APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_KPI_PERIODICITIES

Line 1169: bsc_kpi_periodicities kp,

1165: SELECT
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

Line 1186: bsc_kpi_periodicities

1182: SAVEPOINT BscUpdAnnCurPeriod;
1183:
1184: FOR cd IN c_Periodicity LOOP
1185: UPDATE
1186: bsc_kpi_periodicities
1187: SET
1188: current_period = cd.fiscal_year
1189: WHERE
1190: indicator = p_Target_Indicator AND

Line 1288: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT periodicity_id FROM bsc_kpi_periodicities');

1284: END IF;
1285: RETURN;
1286: END IF;
1287:
1288: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT periodicity_id FROM bsc_kpi_periodicities');
1289: l_sql := l_sql || 'WHERE indicator = :1';
1290: l_Deleted_Periodicities := FND_TABLE_OF_NUMBER();
1291: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
1292: LOOP

Line 1309: l_sql := ' DELETE FROM bsc_kpi_periodicities';

1305: END LOOP;
1306: CLOSE c_cursor;
1307:
1308: IF l_Deleted_Periodicities.COUNT > 0 THEN
1309: l_sql := ' DELETE FROM bsc_kpi_periodicities';
1310: l_sql := l_sql || ' WHERE indicator = :1 AND periodicity_id IN (' ;
1311: FOR i IN 1..l_Deleted_Periodicities.COUNT LOOP
1312: l_sql := l_sql || l_Deleted_Periodicities(i) || ',';
1313: END LOOP;

Line 1323: bsc_kpi_periodicities

1319: FOR i IN 1..p_Old_Periodicities.COUNT LOOP
1320: -- If it is mapped to some other periodicity
1321: IF p_Old_Periodicities(i) <> p_New_Periodicities(i) THEN
1322: UPDATE
1323: bsc_kpi_periodicities
1324: SET
1325: periodicity_id = p_New_Periodicities(i) ,
1326: display_order = (i - 1)
1327: WHERE

Line 1358: l_sql := ' UPDATE bsc_kpi_periodicities';

1354: periodicity_id = p_New_Periodicities(i);
1355:
1356:
1357: IF l_Source_Per_Type <> l_Target_Per_Type THEN
1358: l_sql := ' UPDATE bsc_kpi_periodicities';
1359: l_sql := l_sql || ' SET viewport_flag = 0';
1360: IF l_Target_Per_Type = 1 THEN
1361: l_sql := l_sql || ' , num_of_years = 2 , previous_years = 1 ';
1362: ELSE

Line 1407: bsc_kpi_periodicities

1403: periodicity_id
1404: INTO
1405: l_New_Periodicity
1406: FROM
1407: bsc_kpi_periodicities
1408: WHERE
1409: indicator = p_Target_Indicator AND
1410: ROWNUM < 2
1411: ORDER BY

Line 2242: bsc_kpi_periodicities

2238: ,'?' level_comb
2239: ,NULL table_name
2240: ,NULL filter_condition
2241: FROM
2242: bsc_kpi_periodicities
2243: WHERE
2244: INDICATOR = p_Target_Indicator);
2245: END IF;
2246: