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_BIS_MEASURE_PUB dependencies on BIS_INDICATORS

Line 205: FROM BIS_INDICATORS BIS_IND

201: , BSC_DSET.Name Bsc_Name
202: , BIS_TAR.Source Bis_Source
203: , BIS_IND.Indicator_Id Bis_Ind_Id
204: , BIS_IND.Actual_Data_Source Bis_Act_Source
205: FROM BIS_INDICATORS BIS_IND
206: , BSC_SYS_MEASURES BSC_MEAS
207: , BSC_SYS_DATASETS_VL BSC_DSET
208: , BIS_TARGET_LEVELS BIS_TAR
209: WHERE UPPER(TRIM(BSC_DSET.Name)) = UPPER(x_measure_name)

Line 220: FROM BIS_INDICATORS BIS_IND

216: , BSC_DSET.Name Bsc_Name
217: , BIS_TAR.Source Bis_Source
218: , BIS_IND.Indicator_Id Bis_Ind_Id
219: , BIS_IND.Actual_Data_Source Bis_Act_Source
220: FROM BIS_INDICATORS BIS_IND
221: , BSC_SYS_MEASURES BSC_MEAS
222: , BSC_SYS_DATASETS_VL BSC_DSET
223: , BIS_TARGET_LEVELS BIS_TAR
224: WHERE UPPER(TRIM(BSC_DSET.Name)) = UPPER(x_measure_name)

Line 362: l_measure_short_name BIS_INDICATORS.short_name%TYPE;

358: ,x_return_status OUT NOCOPY VARCHAR2
359: ,x_msg_count OUT NOCOPY NUMBER
360: ,x_msg_data OUT NOCOPY VARCHAR2
361: ) is
362: l_measure_short_name BIS_INDICATORS.short_name%TYPE;
363: l_temp_var BIS_INDICATORS.short_name%TYPE;
364: l_alias VARCHAR2(5);
365: l_flag BOOLEAN;
366: l_count NUMBER;

Line 363: l_temp_var BIS_INDICATORS.short_name%TYPE;

359: ,x_msg_count OUT NOCOPY NUMBER
360: ,x_msg_data OUT NOCOPY VARCHAR2
361: ) is
362: l_measure_short_name BIS_INDICATORS.short_name%TYPE;
363: l_temp_var BIS_INDICATORS.short_name%TYPE;
364: l_alias VARCHAR2(5);
365: l_flag BOOLEAN;
366: l_count NUMBER;
367: begin

Line 381: FROM BIS_INDICATORS

377: l_alias := NULL;
378: l_temp_var := l_measure_short_name;
379: WHILE (l_flag) LOOP
380: SELECT count(1) INTO l_count
381: FROM BIS_INDICATORS
382: WHERE UPPER(TRIM(Short_Name)) = UPPER(TRIM(l_temp_var));
383: IF (l_count = 0) THEN
384: l_flag := FALSE;
385: l_measure_short_name := l_temp_var;

Line 698: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE

694: ,p_dimension7_id IN NUMBER
695: ,p_y_axis_title IN VARCHAR2 := NULL
696: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
697: ,p_ui_flag IN VARCHAR2 := c_UI_FLAG
698: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE
699: ,p_func_area_short_name IN VARCHAR2 := NULL
700: ,x_return_status OUT NOCOPY VARCHAR2
701: ,x_msg_count OUT NOCOPY NUMBER
702: ,x_msg_data OUT NOCOPY VARCHAR2

Line 710: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;

706: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
708: l_Measure_Col_Help VARCHAR2(150);
709: l_count NUMBER;
710: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
711: begin
712: SAVEPOINT SP_CREATE_MEASURE;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 769: FROM BIS_INDICATORS

765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: SELECT COUNT(Short_Name) INTO l_count
769: FROM BIS_INDICATORS
770: WHERE UPPER(TRIM(Short_Name)) = l_Dataset_Rec.Bsc_Measure_Short_Name;
771: IF (l_count > 0) THEN
772: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_SHORT_NAME_UNIQUE');
773: FND_MSG_PUB.ADD;

Line 1522: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE

1518: ,p_dimension7_id IN NUMBER
1519: ,p_y_axis_title IN VARCHAR2 := NULL
1520: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1521: ,p_ui_flag IN VARCHAR2
1522: ,p_last_update_date IN BIS_INDICATORS.LAST_UPDATE_DATE%TYPE
1523: ,p_func_area_short_name IN VARCHAR2 := NULL
1524: ,x_return_status OUT NOCOPY VARCHAR2
1525: ,x_msg_count OUT NOCOPY NUMBER
1526: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1546: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;

1542: l_Delete_Source BOOLEAN;
1543: l_Dataset_Name BSC_SYS_DATASETS_VL.Name%TYPE;
1544: l_Same_Name BOOLEAN := FALSE;
1545:
1546: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
1547:
1548: -- Added for Bug#4617140
1549: l_Old_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
1550: l_Old_Measure_Id1 BSC_SYS_DATASETS_B.MEASURE_ID1%TYPE;

Line 1582: FROM BIS_INDICATORS_VL

1578: WHERE DATASET_ID = p_dataset_id;
1579:
1580: CURSOR c_Bis_Measure_Name IS
1581: SELECT NAME
1582: FROM BIS_INDICATORS_VL
1583: WHERE DATASET_ID = p_dataset_id;
1584:
1585: CURSOR c_Intial_Formula_Content IS
1586: SELECT D.MEASURE_ID1, D.MEASURE_ID2, M.MEASURE_COL

Line 2181: SELECT short_name INTO l_Meas_Extn_Rec.Measure_Short_Name FROM bis_indicators WHERE dataset_id = p_dataset_id;

2177: ,x_msg_count => x_msg_count
2178: ,x_msg_data => x_msg_data
2179: ) ;
2180: -- Get the Measure Short Name
2181: SELECT short_name INTO l_Meas_Extn_Rec.Measure_Short_Name FROM bis_indicators WHERE dataset_id = p_dataset_id;
2182:
2183:
2184: -- Added measure_id2 to be passed to lower APIs Bug#3628113
2185: select measure_id1, measure_id2, pm.measure_id

Line 3481: FROM bis_indicators

3477: ) IS
3478:
3479: CURSOR c_dataset_id (cp_measure_short_name VARCHAR2)IS
3480: SELECT dataset_id
3481: FROM bis_indicators
3482: WHERE short_name = cp_measure_short_name;
3483:
3484: BEGIN
3485:

Line 4240: l_display_name BIS_INDICATORS_TL.NAME%TYPE;

4236: p_dataset_id NUMBER
4237: ,p_display_name VARCHAR2
4238: ,p_source_type VARCHAR2
4239: ) RETURN VARCHAR2 IS
4240: l_display_name BIS_INDICATORS_TL.NAME%TYPE;
4241: BEGIN
4242: BSC_BIS_MEASURE_PUB.get_Measure_Name
4243: ( p_dataset_id => p_dataset_id
4244: ,p_ui_flag => 'Y'

Line 4367: FROM bis_indicators_vl

4363: ) RETURN BOOLEAN
4364: IS
4365: CURSOR mea_cur (cp_measure_short_name VARCHAR2) IS
4366: SELECT last_updated_by, last_update_date
4367: FROM bis_indicators_vl
4368: WHERE short_name = cp_measure_short_name;
4369:
4370: CURSOR mea_tl_cur (cp_measure_short_name VARCHAR2) IS
4371: SELECT tl.last_updated_by, tl.last_update_date

Line 4372: FROM bis_indicators b, bis_indicators_tl tl

4368: WHERE short_name = cp_measure_short_name;
4369:
4370: CURSOR mea_tl_cur (cp_measure_short_name VARCHAR2) IS
4371: SELECT tl.last_updated_by, tl.last_update_date
4372: FROM bis_indicators b, bis_indicators_tl tl
4373: WHERE b.INDICATOR_ID = tl.indicator_id
4374: AND b.short_name = cp_measure_short_name
4375: AND tl.LANGUAGE = userenv('LANG');
4376:

Line 4377: l_db_lub BIS_INDICATORS.LAST_UPDATED_BY%TYPE;

4373: WHERE b.INDICATOR_ID = tl.indicator_id
4374: AND b.short_name = cp_measure_short_name
4375: AND tl.LANGUAGE = userenv('LANG');
4376:
4377: l_db_lub BIS_INDICATORS.LAST_UPDATED_BY%TYPE;
4378: l_db_lud BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
4379: BEGIN
4380:
4381: IF (mea_cur%ISOPEN) THEN

Line 4378: l_db_lud BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;

4374: AND b.short_name = cp_measure_short_name
4375: AND tl.LANGUAGE = userenv('LANG');
4376:
4377: l_db_lub BIS_INDICATORS.LAST_UPDATED_BY%TYPE;
4378: l_db_lud BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
4379: BEGIN
4380:
4381: IF (mea_cur%ISOPEN) THEN
4382: CLOSE mea_cur;

Line 4496: p_indicator_id IN BIS_INDICATORS.INDICATOR_ID%TYPE

4492: END Get_Sing_Par_Meas_DS;
4493:
4494: --Return primary data source (i.e. region_code portion of actual_data_source) of the indicator
4495: FUNCTION Get_Primary_Data_Source (
4496: p_indicator_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
4497: ) RETURN BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE
4498: IS
4499: l_retval BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4500: BEGIN

Line 4497: ) RETURN BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE

4493:
4494: --Return primary data source (i.e. region_code portion of actual_data_source) of the indicator
4495: FUNCTION Get_Primary_Data_Source (
4496: p_indicator_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
4497: ) RETURN BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE
4498: IS
4499: l_retval BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4500: BEGIN
4501: SELECT substr(actual_data_source, 1, instr(actual_data_source, '.') -1) INTO l_retval

Line 4499: l_retval BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

4495: FUNCTION Get_Primary_Data_Source (
4496: p_indicator_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
4497: ) RETURN BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE
4498: IS
4499: l_retval BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4500: BEGIN
4501: SELECT substr(actual_data_source, 1, instr(actual_data_source, '.') -1) INTO l_retval
4502: FROM bis_indicators
4503: WHERE indicator_id = p_indicator_id;

Line 4502: FROM bis_indicators

4498: IS
4499: l_retval BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4500: BEGIN
4501: SELECT substr(actual_data_source, 1, instr(actual_data_source, '.') -1) INTO l_retval
4502: FROM bis_indicators
4503: WHERE indicator_id = p_indicator_id;
4504: RETURN l_retval;
4505: EXCEPTION
4506: WHEN OTHERS THEN