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_KPI_ANALYSIS_MEASURES_B

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 1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;

1051: , x_msg_data OUT NOCOPY VARCHAR2
1052: )IS
1053: TYPE c_cur_type IS REF CURSOR;
1054: c_Ana_Meas c_cur_type;
1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;
1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;

Line 1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;

1052: )IS
1053: TYPE c_cur_type IS REF CURSOR;
1054: c_Ana_Meas c_cur_type;
1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;
1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1060:

Line 1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;

1053: TYPE c_cur_type IS REF CURSOR;
1054: c_Ana_Meas c_cur_type;
1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;
1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1060:
1061: l_sql VARCHAR2(32000);

Line 1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;

1054: c_Ana_Meas c_cur_type;
1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;
1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1060:
1061: l_sql VARCHAR2(32000);
1062:

Line 1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;

1055: l_analysis_option0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
1056: l_analysis_option1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
1057: l_analysis_option2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
1058: l_series_id bsc_kpi_analysis_measures_b.series_id%TYPE;
1059: l_dataset_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1060:
1061: l_sql VARCHAR2(32000);
1062:
1063: BEGIN

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 1080: bsc_kpi_analysis_measures_b

1076: EXIT WHEN c_Ana_Meas%NOTFOUND;
1077: FOR i IN 1..p_Old_DataSet_Map.COUNT LOOP
1078: IF p_Old_DataSet_Map(i) = l_dataset_id THEN
1079: UPDATE
1080: bsc_kpi_analysis_measures_b
1081: SET
1082: dataset_id = p_New_DataSet_Map(i)
1083: WHERE
1084: indicator = p_Target_Indicator