eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COPY_INDICATOR_PUB dependencies on FND_TABLE_OF_NUMBER

Line 871: p_DataSet_Map IN FND_TABLE_OF_NUMBER

867: -- All the measures, dimension objects, dimensions , periodicities, calendars
868: -- that will be used have to be locked
869: ************************************************************************************/
870: PROCEDURE Lock_Target_Entities (
871: p_DataSet_Map IN FND_TABLE_OF_NUMBER
872: , p_DimLevel_Map IN FND_TABLE_OF_NUMBER
873: , p_DimGroup_Map IN FND_TABLE_OF_NUMBER
874: , p_Periodicity_Map IN FND_TABLE_OF_NUMBER
875: , p_Calendar IN NUMBER

Line 872: , p_DimLevel_Map IN FND_TABLE_OF_NUMBER

868: -- that will be used have to be locked
869: ************************************************************************************/
870: PROCEDURE Lock_Target_Entities (
871: p_DataSet_Map IN FND_TABLE_OF_NUMBER
872: , p_DimLevel_Map IN FND_TABLE_OF_NUMBER
873: , p_DimGroup_Map IN FND_TABLE_OF_NUMBER
874: , p_Periodicity_Map IN FND_TABLE_OF_NUMBER
875: , p_Calendar IN NUMBER
876: , p_Time_Stamp IN VARCHAR2 := NULL

Line 873: , p_DimGroup_Map IN FND_TABLE_OF_NUMBER

869: ************************************************************************************/
870: PROCEDURE Lock_Target_Entities (
871: p_DataSet_Map IN FND_TABLE_OF_NUMBER
872: , p_DimLevel_Map IN FND_TABLE_OF_NUMBER
873: , p_DimGroup_Map IN FND_TABLE_OF_NUMBER
874: , p_Periodicity_Map IN FND_TABLE_OF_NUMBER
875: , p_Calendar IN NUMBER
876: , p_Time_Stamp IN VARCHAR2 := NULL
877: , x_return_status OUT NOCOPY VARCHAR2

Line 874: , p_Periodicity_Map IN FND_TABLE_OF_NUMBER

870: PROCEDURE Lock_Target_Entities (
871: p_DataSet_Map IN FND_TABLE_OF_NUMBER
872: , p_DimLevel_Map IN FND_TABLE_OF_NUMBER
873: , p_DimGroup_Map IN FND_TABLE_OF_NUMBER
874: , p_Periodicity_Map IN FND_TABLE_OF_NUMBER
875: , p_Calendar IN NUMBER
876: , p_Time_Stamp IN VARCHAR2 := NULL
877: , x_return_status OUT NOCOPY VARCHAR2
878: , x_msg_count OUT NOCOPY NUMBER

Line 1047: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER

1043: PROCEDURE Copy_Analysis_Measures(
1044: p_commit IN VARCHAR2 := FND_API.G_FALSE
1045: , p_Source_Indicator IN NUMBER
1046: , p_Target_Indicator IN NUMBER
1047: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
1048: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
1049: , x_return_status OUT NOCOPY VARCHAR2
1050: , x_msg_count OUT NOCOPY NUMBER
1051: , x_msg_data OUT NOCOPY VARCHAR2

Line 1048: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER

1044: p_commit IN VARCHAR2 := FND_API.G_FALSE
1045: , p_Source_Indicator IN NUMBER
1046: , p_Target_Indicator IN NUMBER
1047: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
1048: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
1049: , x_return_status OUT NOCOPY VARCHAR2
1050: , x_msg_count OUT NOCOPY NUMBER
1051: , x_msg_data OUT NOCOPY VARCHAR2
1052: )IS

Line 1250: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER

1246: p_commit IN VARCHAR2 := FND_API.G_FALSE
1247: , p_Source_Indicator IN NUMBER
1248: , p_Target_Indicator IN NUMBER
1249: , p_Target_Calendar IN NUMBER
1250: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
1251: , p_New_Periodicities IN FND_TABLE_OF_NUMBER
1252: , x_return_status OUT NOCOPY VARCHAR2
1253: , x_msg_count OUT NOCOPY NUMBER
1254: , x_msg_data OUT NOCOPY VARCHAR2

Line 1251: , p_New_Periodicities IN FND_TABLE_OF_NUMBER

1247: , p_Source_Indicator IN NUMBER
1248: , p_Target_Indicator IN NUMBER
1249: , p_Target_Calendar IN NUMBER
1250: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
1251: , p_New_Periodicities IN FND_TABLE_OF_NUMBER
1252: , x_return_status OUT NOCOPY VARCHAR2
1253: , x_msg_count OUT NOCOPY NUMBER
1254: , x_msg_data OUT NOCOPY VARCHAR2
1255: )IS

Line 1265: l_Deleted_Periodicities FND_TABLE_OF_NUMBER;

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:

Line 1290: l_Deleted_Periodicities := FND_TABLE_OF_NUMBER();

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
1293: FETCH c_cursor INTO l_Periodicity_Id;
1294: EXIT WHEN c_cursor%NOTFOUND;

Line 1575: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER

1571: PROCEDURE Copy_Dim_Level_Props(
1572: p_commit IN VARCHAR2 := FND_API.G_FALSE
1573: , p_Source_Indicator IN NUMBER
1574: , p_Target_Indicator IN NUMBER
1575: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1576: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1577: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
1578: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
1579: , p_Region_Code IN VARCHAR2

Line 1576: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

1572: p_commit IN VARCHAR2 := FND_API.G_FALSE
1573: , p_Source_Indicator IN NUMBER
1574: , p_Target_Indicator IN NUMBER
1575: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1576: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1577: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
1578: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
1579: , p_Region_Code IN VARCHAR2
1580: , p_Old_Region_Code IN VARCHAR2

Line 1577: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER

1573: , p_Source_Indicator IN NUMBER
1574: , p_Target_Indicator IN NUMBER
1575: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1576: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1577: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
1578: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
1579: , p_Region_Code IN VARCHAR2
1580: , p_Old_Region_Code IN VARCHAR2
1581: , x_return_status OUT NOCOPY VARCHAR2

Line 1578: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER

1574: , p_Target_Indicator IN NUMBER
1575: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1576: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1577: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
1578: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
1579: , p_Region_Code IN VARCHAR2
1580: , p_Old_Region_Code IN VARCHAR2
1581: , x_return_status OUT NOCOPY VARCHAR2
1582: , x_msg_count OUT NOCOPY NUMBER

Line 1806: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER

1802: PROCEDURE Check_Key_Item_Props(
1803: p_commit IN VARCHAR2 := FND_API.G_FALSE
1804: , p_Source_Indicator IN NUMBER
1805: , p_Target_Indicator IN NUMBER
1806: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1807: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1808: , x_return_status OUT NOCOPY VARCHAR2
1809: , x_msg_count OUT NOCOPY NUMBER
1810: , x_msg_data OUT NOCOPY VARCHAR2

Line 1807: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

1803: p_commit IN VARCHAR2 := FND_API.G_FALSE
1804: , p_Source_Indicator IN NUMBER
1805: , p_Target_Indicator IN NUMBER
1806: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
1807: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
1808: , x_return_status OUT NOCOPY VARCHAR2
1809: , x_msg_count OUT NOCOPY NUMBER
1810: , x_msg_data OUT NOCOPY VARCHAR2
1811: )IS

Line 2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER

2420: , p_Description IN VARCHAR2 := NULL
2421: , p_Source_Indicator IN NUMBER
2422: , p_Target_Group IN NUMBER
2423: , p_New_Position IN NUMBER
2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER

Line 2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

2421: , p_Source_Indicator IN NUMBER
2422: , p_Target_Group IN NUMBER
2423: , p_New_Position IN NUMBER
2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER

Line 2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER

2422: , p_Target_Group IN NUMBER
2423: , p_New_Position IN NUMBER
2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER

Line 2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER

2423: , p_New_Position IN NUMBER
2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER
2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER

Line 2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER

2424: , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER
2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
2432: , p_New_Periodicities IN FND_TABLE_OF_NUMBER

Line 2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER

2425: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
2426: , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER
2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
2432: , p_New_Periodicities IN FND_TABLE_OF_NUMBER
2433: , p_Time_Stamp IN VARCHAR2 := NULL

Line 2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER

2427: , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER
2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
2432: , p_New_Periodicities IN FND_TABLE_OF_NUMBER
2433: , p_Time_Stamp IN VARCHAR2 := NULL
2434: , x_return_status OUT NOCOPY VARCHAR2
2435: , x_msg_count OUT NOCOPY NUMBER

Line 2432: , p_New_Periodicities IN FND_TABLE_OF_NUMBER

2428: , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
2429: , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
2430: , p_Target_Calendar IN NUMBER
2431: , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
2432: , p_New_Periodicities IN FND_TABLE_OF_NUMBER
2433: , p_Time_Stamp IN VARCHAR2 := NULL
2434: , x_return_status OUT NOCOPY VARCHAR2
2435: , x_msg_count OUT NOCOPY NUMBER
2436: , x_msg_data OUT NOCOPY VARCHAR2