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 BSC_DESIGNER_PVT

Line 789: IF BSC_DESIGNER_PVT.g_DbLink_Name IS NOT NULL THEN

785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: SAVEPOINT BscValIndCopyUIWrap;
788:
789: IF BSC_DESIGNER_PVT.g_DbLink_Name IS NOT NULL THEN
790:
791: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT NVL(edw_flag,0) FROM bsc_kpis_b');
792: l_sql := l_sql || ' WHERE indicator = :1';
793: OPEN c_cursor FOR l_sql USING p_Source_Indicator;

Line 791: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT NVL(edw_flag,0) FROM bsc_kpis_b');

787: SAVEPOINT BscValIndCopyUIWrap;
788:
789: IF BSC_DESIGNER_PVT.g_DbLink_Name IS NOT NULL THEN
790:
791: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT NVL(edw_flag,0) FROM bsc_kpis_b');
792: l_sql := l_sql || ' WHERE indicator = :1';
793: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
794: FETCH c_cursor INTO l_EDW_Flag;
795: CLOSE c_cursor;

Line 802: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT indicator_type,config_type FROM bsc_kpis_b');

798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT indicator_type,config_type FROM bsc_kpis_b');
803: l_sql := l_sql || ' WHERE indicator = :1';
804: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
805: FETCH c_cursor INTO l_indicator_type,l_config_type;
806: CLOSE c_cursor;

Line 809: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT COUNT(1) FROM bsc_kpi_analysis_measures_b');

805: FETCH c_cursor INTO l_indicator_type,l_config_type;
806: CLOSE c_cursor;
807:
808: IF NOT (l_indicator_type = 1 AND l_config_type = 7) THEN
809: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT COUNT(1) FROM bsc_kpi_analysis_measures_b');
810: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' km ,bsc_sys_datasets_b');
811: l_sql := l_sql || ' ds WHERE km.indicator = :1 AND ds.dataset_id = km.dataset_id AND ds.source = :2';
812: OPEN c_cursor FOR l_sql USING p_Source_Indicator, 'PMF';
813: FETCH c_cursor INTO l_PMF_Meas_Cnt;

Line 810: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' km ,bsc_sys_datasets_b');

806: CLOSE c_cursor;
807:
808: IF NOT (l_indicator_type = 1 AND l_config_type = 7) THEN
809: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String(' SELECT COUNT(1) FROM bsc_kpi_analysis_measures_b');
810: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' km ,bsc_sys_datasets_b');
811: l_sql := l_sql || ' ds WHERE km.indicator = :1 AND ds.dataset_id = km.dataset_id AND ds.source = :2';
812: OPEN c_cursor FOR l_sql USING p_Source_Indicator, 'PMF';
813: FETCH c_cursor INTO l_PMF_Meas_Cnt;
814: CLOSE c_cursor;

Line 1070: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(',dataset_id FROM bsc_kpi_analysis_measures_b');

1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067: SAVEPOINT BscCopyIndicAnaMeasPub;
1068:
1069: l_sql := 'SELECT analysis_option0 ,analysis_option1 ,analysis_option2,series_id';
1070: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(',dataset_id FROM bsc_kpi_analysis_measures_b');
1071: l_sql := l_sql || 'WHERE indicator = :1 ORDER BY analysis_option0';
1072: l_sql := l_sql || ',analysis_option1 ,analysis_option2 ,series_id';
1073: OPEN c_Ana_Meas FOR l_sql USING p_Source_Indicator;
1074: LOOP

Line 1091: BSC_DESIGNER_PVT.g_DbLink_Name IS NULL THEN

1087: AND analysis_option2 = l_analysis_option2
1088: AND series_id = l_series_id;
1089:
1090: IF p_Old_DataSet_Map(i) <> p_New_DataSet_Map(i) AND
1091: BSC_DESIGNER_PVT.g_DbLink_Name IS NULL THEN
1092: UPDATE bsc_kpi_analysis_measures_tl km
1093: SET name = (SELECT d.name FROM bsc_sys_datasets_tl d WHERE
1094: d.dataset_id = p_New_DataSet_Map(i) AND d.language = km.language),
1095: help = (SELECT d.help FROM bsc_sys_datasets_tl d WHERE

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 1332: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT calendar_id FROM bsc_kpis_b');

1328: indicator = p_Target_Indicator AND
1329: periodicity_id = p_Old_Periodicities(i);
1330: END IF;
1331:
1332: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT calendar_id FROM bsc_kpis_b');
1333: l_sql := l_sql || 'WHERE indicator = :1';
1334:
1335: OPEN c_cursor FOR l_sql USING p_Source_Indicator;
1336: FETCH c_cursor INTO l_Source_Calendar;

Line 1339: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT periodicity_type FROM bsc_sys_periodicities');

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;

Line 1606: ,p_DbLink_Name => BSC_DESIGNER_PVT.g_DbLink_Name

1602: ,p_Indicator => p_Target_Indicator
1603: ,p_Region_Code => p_Region_Code
1604: ,p_Old_Region_Code => p_Old_Region_Code
1605: ,p_New_Dim_Levels => p_New_Dim_Levels
1606: ,p_DbLink_Name => BSC_DESIGNER_PVT.g_DbLink_Name
1607: ,x_return_status => x_return_status
1608: ,x_msg_count => x_msg_count
1609: ,x_msg_data => x_msg_data
1610: );

Line 1631: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT dim_set_id,dim_group_id,dim_group_index FROM bsc_kpi_dim_groups');

1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;
1629:
1630: ELSE
1631: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT dim_set_id,dim_group_id,dim_group_index FROM bsc_kpi_dim_groups');
1632: l_sql := l_sql || 'WHERE indicator = :1 ORDER BY dim_set_id,dim_group_index';
1633: OPEN c_Dim_Group_Info FOR l_sql USING p_Source_Indicator;
1634: LOOP
1635: FETCH c_Dim_Group_Info INTO l_dim_set_id, l_dim_group_id, l_dim_group_index;

Line 1670: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT distinct dim_set_id FROM bsc_kpi_dim_levels_vl');

1666: END IF;
1667: END LOOP;
1668: CLOSE c_Dim_Group_Info;
1669:
1670: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT distinct dim_set_id FROM bsc_kpi_dim_levels_vl');
1671: l_sql := l_sql || 'WHERE indicator = :1 MINUS SELECT distinct dim_set_id FROM bsc_kpi_dim_levels_vl';
1672: l_sql := l_sql || ' WHERE indicator = :2';
1673: OPEN c_Dim_Group_Info FOR l_sql USING p_Source_Indicator,p_Target_Indicator;
1674: LOOP

Line 1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');

1839:
1840: l_sql := 'SELECT kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,';
1841: l_sql := l_sql || 'parent_level_index,parent_level_rel,table_relation,';
1842: l_sql := l_sql || 'parent_level_index2,parent_level_rel2 ';
1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');
1845: l_sql := l_sql || ' dl WHERE kl.indicator = :1 AND dl.dim_level_id = :2 AND kl.dim_set_id = :3 AND ';
1846: l_sql := l_sql || ' kl.level_table_name = dl.level_Table_name ORDER BY dim_set_id,dim_level_index ';
1847:

Line 1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');

1840: l_sql := 'SELECT kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,';
1841: l_sql := l_sql || 'parent_level_index,parent_level_rel,table_relation,';
1842: l_sql := l_sql || 'parent_level_index2,parent_level_rel2 ';
1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');
1845: l_sql := l_sql || ' dl WHERE kl.indicator = :1 AND dl.dim_level_id = :2 AND kl.dim_set_id = :3 AND ';
1846: l_sql := l_sql || ' kl.level_table_name = dl.level_Table_name ORDER BY dim_set_id,dim_level_index ';
1847:
1848: FOR cd IN c_Check_Config_Change LOOP

Line 1906: BSC_DESIGNER_PVT.ActionFlag_Change( p_Target_Indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

1902: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1904: END IF;*/
1905:
1906: BSC_DESIGNER_PVT.ActionFlag_Change( p_Target_Indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
1907: ELSE
1908: l_sql := 'UPDATE bsc_kpi_dim_levels_b tar SET tar.default_key_value = (SELECT src.default_key_value ';
1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1910: l_sql := l_sql || ' src WHERE src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';

Line 1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');

1905:
1906: BSC_DESIGNER_PVT.ActionFlag_Change( p_Target_Indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
1907: ELSE
1908: l_sql := 'UPDATE bsc_kpi_dim_levels_b tar SET tar.default_key_value = (SELECT src.default_key_value ';
1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1910: l_sql := l_sql || ' src WHERE src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;
1913:

Line 1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');

1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;
1913:
1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';

Line 1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');

1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;
1913:
1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';
1920: l_sql := l_sql || ' src.dim_set_id = dl.dim_set_id AND src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';

Line 1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');

1913:
1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';
1920: l_sql := l_sql || ' src.dim_set_id = dl.dim_set_id AND src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1921: l_sql := l_sql || ' sys.dim_level_id = tar.dim_level_id) WHERE tar.indicator = :2';

Line 1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');

1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';
1920: l_sql := l_sql || ' src.dim_set_id = dl.dim_set_id AND src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1921: l_sql := l_sql || ' sys.dim_level_id = tar.dim_level_id) WHERE tar.indicator = :2';
1922: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;

Line 2451: BSC_DESIGNER_PVT.g_DbLink_Name := p_DbLink_Name;

2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448:
2449: SAVEPOINT BscCopyIndicatorUIWrap;
2450:
2451: BSC_DESIGNER_PVT.g_DbLink_Name := p_DbLink_Name;
2452: Validate_Indicator_Copy (
2453: p_Source_Indicator => p_Source_Indicator
2454: ,x_return_status => x_return_status
2455: ,x_msg_count => x_msg_count

Line 2497: BSC_DESIGNER_PVT.Copy_Kpi_Metadata(

2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494: END IF;
2495: --END IF;*/
2496:
2497: BSC_DESIGNER_PVT.Copy_Kpi_Metadata(
2498: p_commit => FND_API.G_FALSE
2499: ,p_DbLink_Name => p_DbLink_Name
2500: ,p_Source_Indicator => p_Source_Indicator
2501: ,x_Target_Indicator => l_Target_Indicator

Line 2545: BSC_DESIGNER_PVT.ActionFlag_Change(

2541: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2542: RAISE FND_API.G_EXC_ERROR;
2543: END IF;
2544:
2545: BSC_DESIGNER_PVT.ActionFlag_Change(
2546: x_indicator => l_Target_Indicator
2547: ,x_newflag => 1 );
2548:
2549: Check_KPI_Name (

Line 2606: BSC_DESIGNER_PVT.Deflt_Update_Dim_Values (

2602: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2604: END IF;
2605:
2606: BSC_DESIGNER_PVT.Deflt_Update_Dim_Values (
2607: x_indicator => l_Target_Indicator
2608: );
2609:
2610: BSC_DESIGNER_PVT.Deflt_Update_Dim_Names (

Line 2610: BSC_DESIGNER_PVT.Deflt_Update_Dim_Names (

2606: BSC_DESIGNER_PVT.Deflt_Update_Dim_Values (
2607: x_indicator => l_Target_Indicator
2608: );
2609:
2610: BSC_DESIGNER_PVT.Deflt_Update_Dim_Names (
2611: x_indicator => l_Target_Indicator
2612: );
2613:
2614: -- END IF;

Line 2641: BSC_DESIGNER_PVT.Deflt_Update_SN_FM_CM (

2637: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2639: END IF;
2640:
2641: BSC_DESIGNER_PVT.Deflt_Update_SN_FM_CM (
2642: x_indicator => l_Target_Indicator
2643: );
2644:
2645: Copy_Periodicities (