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_DATASETS_PVT dependencies on BSC_SYS_MEASURES

Line 125: from BSC_SYS_MEASURES

121:
122: -- Verify that measure id does not exist.
123: select count(1)
124: into l_count
125: from BSC_SYS_MEASURES
126: where measure_id = l_Dataset_Rec.Bsc_Measure_Id;
127:
128: -- If measure id does not exist then go ahead and create it, if it does then raise
129: -- an error.

Line 132: g_db_object := 'BSC_SYS_MEASURES';

128: -- If measure id does not exist then go ahead and create it, if it does then raise
129: -- an error.
130: if l_count = 0 then
131:
132: g_db_object := 'BSC_SYS_MEASURES';
133:
134: -- Check if measure_col already exists
135: select count(1) into l_count_mescol
136: from BSC_DB_MEASURE_COLS_VL

Line 146: -- Insert pertaining values into table bsc_sys_measures.

142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144:
145:
146: -- Insert pertaining values into table bsc_sys_measures.
147: -- Reminder: Some values are hard coded. Find source.
148: insert into BSC_SYS_MEASURES( measure_id
149: ,measure_col
150: ,operation

Line 148: insert into BSC_SYS_MEASURES( measure_id

144:
145:
146: -- Insert pertaining values into table bsc_sys_measures.
147: -- Reminder: Some values are hard coded. Find source.
148: insert into BSC_SYS_MEASURES( measure_id
149: ,measure_col
150: ,operation
151: ,type
152: ,min_actual_value

Line 304: from BSC_SYS_MEASURES a

300: ,x_Dataset_Rec.Bsc_Measure_Last_Update_Login -- PMD
301: ,x_Dataset_Rec.Bsc_Measure_Projection_Id
302: ,x_Dataset_Rec.Bsc_Measure_Type
303: ,x_Dataset_Rec.Bsc_Measure_Group_Id
304: from BSC_SYS_MEASURES a
305: ,bsc_db_measure_cols_vl b
306: where a.measure_id = p_Dataset_Rec.Bsc_Measure_Id
307: and a.measure_col = b.Measure_Col(+);
308:

Line 473: FROM BSC_SYS_MEASURES

469: AND dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
470:
471: CURSOR c_measures_col IS
472: SELECT Type
473: FROM BSC_SYS_MEASURES
474: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
475:
476: begin
477:

Line 480: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'

476: begin
477:
478: -- Check that valid measure id was entered.
479: if p_Dataset_Rec.Bsc_Measure_Id is not null then
480: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
481: ,'measure_id'
482: ,p_Dataset_Rec.Bsc_Measure_Id);
483: if l_count = 0 then
484: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

Line 497: FROM BSC_SYS_MEASURES

493: end if;
494:
495: SELECT MEASURE_COL
496: INTO l_current_formula
497: FROM BSC_SYS_MEASURES
498: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
499:
500: IF(l_current_formula <> p_Dataset_Rec.Bsc_Measure_Col) THEN
501: select count(1) into l_count_mescol

Line 651: UPDATE BSC_SYS_MEASURES

647: END IF;
648: CLOSE c_measures_col;*/
649:
650:
651: UPDATE BSC_SYS_MEASURES
652: -- mdamle 03/12/2003 - PMD - Measure Definer
653: -- Changed set measure_col = l_Dataset_Rec.Bsc_Measure_Short_Name
654: SET measure_col = l_Dataset_Rec.Bsc_Measure_Col
655: ,operation = l_Dataset_Rec.Bsc_Measure_Operation

Line 741: FROM BSC_SYS_MEASURES

737: -- Check that measure is valid
738: IF p_Dataset_Rec.Bsc_Measure_Id IS NOT NULL THEN
739:
740: SELECT COUNT(1) INTO l_Count
741: FROM BSC_SYS_MEASURES
742: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
743:
744: IF l_count = 0 THEN
745: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

Line 754: FROM BSC_SYS_MEASURES

750:
751: -- If the Meeasure_Id1 is not null (A+B Formula)
752: IF p_Dataset_Rec.Bsc_Measure_Id2 IS NOT NULL THEN
753: SELECT COUNT(1) INTO l_Count
754: FROM BSC_SYS_MEASURES
755: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
756:
757: IF l_count = 0 THEN
758: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

Line 776: FROM BSC_SYS_MEASURES

772:
773: IF l_Count = 0 THEN
774: -- mdamle 04/23/2003 - PMD - Measure Definer - Delete db column if not being used by any other measure
775: SELECT MEASURE_COL INTO l_Measure_Col
776: FROM BSC_SYS_MEASURES
777: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
778:
779: DELETE FROM BSC_SYS_MEASURES
780: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;

Line 779: DELETE FROM BSC_SYS_MEASURES

775: SELECT MEASURE_COL INTO l_Measure_Col
776: FROM BSC_SYS_MEASURES
777: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
778:
779: DELETE FROM BSC_SYS_MEASURES
780: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
781:
782: -- mdamle 04/23/2003 - PMD - Measure Definer - Delete db column if not being used by any other measure
783: -- Delete column if no other dataset is using it.

Line 785: FROM BSC_SYS_MEASURES

781:
782: -- mdamle 04/23/2003 - PMD - Measure Definer - Delete db column if not being used by any other measure
783: -- Delete column if no other dataset is using it.
784: SELECT COUNT(1) INTO l_count
785: FROM BSC_SYS_MEASURES
786: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC
787: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
788:
789: IF l_Count = 0 THEN

Line 802: -- mdamle 04/23/2003 - PMD - Measure Definer - No need to raise error, just don't delete the from bsc_sys_measures

798: IF (p_Commit = FND_API.G_TRUE) THEN
799: COMMIT;
800: END IF;
801:
802: -- mdamle 04/23/2003 - PMD - Measure Definer - No need to raise error, just don't delete the from bsc_sys_measures
803: END IF;
804:
805: -- Delete the Formulae based MEASURE_ID2 if not used in any
806: -- Dataset based formula.

Line 820: FROM BSC_SYS_MEASURES

816: -- We can have both Meaaure_Id1 and Measure_Id2 same, in that case measure_id1
817: -- would have been delete already and the following code can give no-data-found issue
818: IF ((l_Count = 0) AND (p_Dataset_Rec.Bsc_Measure_Id <> p_Dataset_Rec.Bsc_Measure_Id2)) THEN
819: SELECT MEASURE_COL INTO l_Measure_Col
820: FROM BSC_SYS_MEASURES
821: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
822:
823: DELETE FROM BSC_SYS_MEASURES
824: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;

Line 823: DELETE FROM BSC_SYS_MEASURES

819: SELECT MEASURE_COL INTO l_Measure_Col
820: FROM BSC_SYS_MEASURES
821: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
822:
823: DELETE FROM BSC_SYS_MEASURES
824: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
825:
826: -- Delete column if no other dataset is using it.
827: SELECT COUNT(1) INTO l_Count

Line 828: FROM BSC_SYS_MEASURES

824: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
825:
826: -- Delete column if no other dataset is using it.
827: SELECT COUNT(1) INTO l_Count
828: FROM BSC_SYS_MEASURES
829: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC
830: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
831:
832: IF l_Count = 0 THEN

Line 1245: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'

1241:
1242: /* commented, apparently not needed.
1243: -- Check that valid measure id was entered.
1244: if p_Dataset_Rec.Bsc_Measure_Id is not null then
1245: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
1246: ,'measure_id'
1247: ,p_Dataset_Rec.Bsc_Measure_Id);
1248: if l_count = 0 then
1249: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

Line 1264: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'

1260:
1261: -- Check that valid 2nd measure id was entered.
1262: if p_Dataset_Rec.Bsc_Measure_Id2 is not null and
1263: p_Dataset_Rec.Bsc_Measure_Id2 <> 0 then
1264: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
1265: ,'measure_id'
1266: ,p_Dataset_Rec.Bsc_Measure_Id2);
1267: if l_count = 0 then
1268: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

Line 1896: -- from BSC_SYS_MEASURES

1892: begin
1893: -- mdamle 04/23/2003 - PMD - Measure Definer - short_name not used, instead dataset_id added to bis_indicators
1894: select count(1)
1895: into l_count
1896: -- from BSC_SYS_MEASURES
1897: from bis_indicators i, bsc_sys_datasets_vl d
1898: where short_name = p_Measure_Name
1899: and i.dataset_id = d.dataset_id;
1900: