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 BSC_SYS_MEASURES

Line 32: -- BSC_SYS_MEASURES.Type must be 0, for BSC type of measures

28: -- 25-AUG-2003 mahrao Added procedure Ret_Dataset_Fr_Meas_Shrt_Name and
29: -- Order_Dimensions_For_Ldt
30: -- 01-SEP-2003 PAJOHRI Bug #3122612
31: -- Updated the API so that whenever any measure is created/updated
32: -- BSC_SYS_MEASURES.Type must be 0, for BSC type of measures
33: -- 03-Sep-03 mdamle Fixed Bug #3123734, 3123558 - Get measure col, isFormula
34: -- 07-Sep-03 arhegde bug# 3123901 Propogate error to outer layers.
35: -- 11-Sep-03 mdamle BSC_SYS_MEASURES.Type is different from BSC_DB_MEASURE_COLS.MEASURE_TYPE
36: -- 26-Sep-03 adrao Removed the logic to generate Duplicate Display Name for Measured

Line 35: -- 11-Sep-03 mdamle BSC_SYS_MEASURES.Type is different from BSC_DB_MEASURE_COLS.MEASURE_TYPE

31: -- Updated the API so that whenever any measure is created/updated
32: -- BSC_SYS_MEASURES.Type must be 0, for BSC type of measures
33: -- 03-Sep-03 mdamle Fixed Bug #3123734, 3123558 - Get measure col, isFormula
34: -- 07-Sep-03 arhegde bug# 3123901 Propogate error to outer layers.
35: -- 11-Sep-03 mdamle BSC_SYS_MEASURES.Type is different from BSC_DB_MEASURE_COLS.MEASURE_TYPE
36: -- 26-Sep-03 adrao Removed the logic to generate Duplicate Display Name for Measured
37: -- for Bug #3163366
38: -- 01-Oct-03 mdamle Bug#3163261 - Don't remove beginning numbers from source column name
39: -- 07-Oct-03 mdamle Bug#3170184 - For BSC type measure, always use short name in PMF display name

Line 206: , BSC_SYS_MEASURES BSC_MEAS

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)
210: AND BIS_IND.Indicator_Id = BIS_TAR.Indicator_Id(+)

Line 221: , BSC_SYS_MEASURES BSC_MEAS

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)
225: AND BIS_IND.Indicator_Id = BIS_TAR.Indicator_Id(+)

Line 833: FROM BSC_SYS_MEASURES

829: -- Insert the Dataset and Measure Record
830: -- When DataSource (measure_id1) is passed as -1 from the UI then Bug #3292146
831: SELECT COUNT(Measure_Id)
832: INTO l_count
833: FROM BSC_SYS_MEASURES
834: WHERE Measure_Id = -1
835: AND Measure_Col = l_Dataset_Rec.Bsc_Measure_Col;
836:
837: if (l_Dataset_Rec.Bsc_Measure_id = -1) and (l_count = 0) then

Line 1303: FROM BSC_SYS_MEASURES;

1299: ) RETURN BOOLEAN IS
1300:
1301: CURSOR c_All_Formula IS
1302: SELECT MEASURE_COL
1303: FROM BSC_SYS_MEASURES;
1304:
1305: BEGIN
1306:
1307: FOR cd in c_All_Formula LOOP

Line 1338: l_Dataset_Rec.Bsc_Measure_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_MEASURES'

1334: BEGIN
1335: l_Dataset_Rec := p_Dataset_Rec;
1336: SAVEPOINT SP_UPD_TO_FORMULA;
1337:
1338: l_Dataset_Rec.Bsc_Measure_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_MEASURES'
1339: ,'measure_id');
1340: if l_Dataset_Rec.Bsc_Measure_Col IS NULL then
1341: l_Dataset_Rec.Bsc_Measure_Col := p_Dataset_Rec_db.Bsc_Measure_Col;
1342: end if;

Line 1549: l_Old_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;

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;
1551: l_Old_Measure_Id2 BSC_SYS_DATASETS_B.MEASURE_ID2%TYPE;
1552: l_Is_Converted_To_Formula_Type BOOLEAN;
1553: l_Report_Objectives VARCHAR2(2000);

Line 1566: FROM BSC_SYS_MEASURES

1562:
1563: CURSOR c_Bsc_Measure_Color_Formula IS
1564: SELECT s_Color_Formula
1565: , Measure_Col
1566: FROM BSC_SYS_MEASURES
1567: WHERE Measure_Id = l_Dataset_Rec.Bsc_Measure_Id;
1568:
1569: CURSOR c_Dataset_Measures IS
1570: SELECT MEASURE_ID1

Line 1587: FROM BSC_SYS_DATASETS_B D, BSC_SYS_MEASURES M

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
1587: FROM BSC_SYS_DATASETS_B D, BSC_SYS_MEASURES M
1588: WHERE D.DATASET_ID = p_Dataset_ID
1589: AND M.MEASURE_ID = D.MEASURE_ID1;
1590:
1591: begin

Line 1753: The following logic ensures that no dangling entries in bsc_sys_measures

1749: -- END Granular Locking
1750:
1751: -- Fix for Bug#3781176
1752: /*
1753: The following logic ensures that no dangling entries in bsc_sys_measures
1754: remains within the system. When one Measure (bsc_sys_datasets_b) has its datasource
1755: changed, then we need to delete it during update and ensure that it is not orphened
1756: i.e its achieved using the Delete_Measures from the Private datasets package (BSC_DATASETS_PVT)
1757: */

Line 1792: a new Measure Record should be inserted in bsc_sys_measures

1788: END IF;
1789:
1790: /*
1791: Should check if present change is from Single Source Column to Formula based measure then
1792: a new Measure Record should be inserted in bsc_sys_measures
1793: */
1794:
1795:
1796: BSC_DATASETS_PUB.Retrieve_Measures(

Line 1812: /*Create a new entry in BSC_SYS_MEASURES if a Single Source Column is being changed to a Formula

1808: -- added an additional condition 'Is_Src_Col_In_Formulas' for Bug#5071121
1809: IF ((NOT isFormula(l_Dataset_Rec_db.Bsc_Measure_Col)) AND
1810: (isFormula(l_Dataset_Rec.Bsc_Measure_Col)) AND
1811: Is_Src_Col_In_Formulas(l_Dataset_Rec_db.Bsc_Measure_Col)) THEN
1812: /*Create a new entry in BSC_SYS_MEASURES if a Single Source Column is being changed to a Formula
1813: of A+B type while the source column is being used in other Formula. Then associate this new Measure Id
1814: as the Measure Id1 of the dataset*/
1815: BSC_BIS_MEASURE_PUB.Update_Single_To_Formula(
1816: p_commit => p_commit

Line 1850: -- this API deletes only the source columns (bsc_sys_measures) and not the actual measure itself.

1846: -- Fix for Bug#3781176
1847: -- Delete the source columns that may no more be used and are dangling
1848: -- This is called after update, since the API checks if the passed measure_id is being used or not.
1849: IF (l_Delete_Source = TRUE) THEN
1850: -- this API deletes only the source columns (bsc_sys_measures) and not the actual measure itself.
1851: BSC_DATASETS_PVT.Delete_Measures(
1852: p_commit => p_commit
1853: ,p_Dataset_Rec => l_Del_Dataset_Rec
1854: ,x_return_status => x_return_status

Line 3517: l_mes_short_name BSC_SYS_MEASURES.SHORT_NAME%TYPE;

3513: l_temp_var VARCHAR2(30);
3514: l_count NUMBER;
3515: l_is_mes_exist BOOLEAN := FALSE;
3516: l_count_col NUMBER;
3517: l_mes_short_name BSC_SYS_MEASURES.SHORT_NAME%TYPE;
3518: BEGIN
3519:
3520: l_measure_col := gen_name_for_column(p_dataset_name);
3521:

Line 3541: FROM BSC_SYS_MEASURES

3537: WHILE (l_flag) LOOP
3538: l_is_mes_exist := FALSE;
3539: IF (p_measure_id IS NULL) THEN
3540: SELECT COUNT(1) INTO l_count
3541: FROM BSC_SYS_MEASURES
3542: WHERE UPPER(measure_col) = UPPER(l_temp_var);
3543:
3544: SELECT COUNT(1) INTO l_count_col
3545: FROM BSC_DB_MEASURE_COLS_TL

Line 3550: FROM bsc_sys_measures

3546: WHERE UPPER(measure_col) = UPPER(l_temp_var);
3547:
3548: ELSE
3549: SELECT COUNT(1) INTO l_count
3550: FROM bsc_sys_measures
3551: WHERE UPPER(measure_col) = UPPER(l_temp_var)
3552: AND measure_id <> p_measure_id;
3553:
3554: SELECT COUNT(1) INTO l_count_col

Line 3643: , bsc_sys_measures m

3639:
3640: CURSOR c_Meas_Grp IS
3641: SELECT measure_group_id
3642: FROM bsc_sys_datasets_vl d
3643: , bsc_sys_measures m
3644: , bsc_db_measure_cols_vl db
3645: WHERE d.dataset_id = p_dataset_id
3646: AND m.measure_id = d.measure_id1
3647: AND m.measure_col =db.measure_col;

Line 3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3652:
3653: if bsc_utility.isBscInProductionMode then
3654: select count(c.projection_id)
3655: into l_count
3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3657: where m.measure_id = d.measure_id1
3658: and c.measure_col = m.measure_col
3659: and d.dataset_id = p_dataset_id;
3660:

Line 3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3663:
3664: if(l_count <> 0) then
3665: select c.projection_id, c.measure_type
3666: into l_proj_id, l_measure_type
3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3668: where m.measure_id = d.measure_id1
3669: and c.measure_col = m.measure_col
3670: and d.dataset_id = p_dataset_id;
3671: end if;

Line 3701: from bsc_sys_datasets_vl d, bsc_sys_measures m

3697:
3698: if(p_rollup_calc is not null) then
3699: select decode(nvl(BSC_APPS.Get_Property_Value(m.S_COLOR_FORMULA, 'pAvgL'), 'N'), 'Y', 'AVL', m.operation) rollup
3700: into l_rollup_calc
3701: from bsc_sys_datasets_vl d, bsc_sys_measures m
3702: where m.measure_id = d.measure_id1
3703: and d.dataset_id = p_dataset_id ;
3704: end if;
3705:

Line 3709: from bsc_sys_datasets_vl d, bsc_sys_measures m

3705:
3706: if(p_formula is not null) then
3707: select m.measure_col formula
3708: into l_formula
3709: from bsc_sys_datasets_vl d, bsc_sys_measures m
3710: where m.measure_id = d.measure_id1
3711: and d.dataset_id = p_dataset_id ;
3712: end if;
3713:

Line 4422: FROM bsc_sys_measures

4418: l_measure_id VARCHAR2(30);
4419:
4420: CURSOR c_chk_col_in_formula(p_measure_col VARCHAR2) IS
4421: SELECT measure_id,measure_col
4422: FROM bsc_sys_measures
4423: WHERE measure_col like '%'||p_measure_col||'%';
4424:
4425:
4426: CURSOR c_chk_measid_in_measure(p_measure_id VARCHAR2) IS