APPS.BSC_DATASETS_PVT dependencies on BSC_DB_MEASURE_COLS_VL

Line 136: from BSC_DB_MEASURE_COLS_VL

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
137: where upper(measure_col) = upper(l_Dataset_Rec.Bsc_Measure_Col);
138: if (l_count_mescol > 0) then
139: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
140: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);

Line 305: ,bsc_db_measure_cols_vl b

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:
309: if (p_commit = FND_API.G_TRUE) then

Line 502: from BSC_DB_MEASURE_COLS_VL

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
502: from BSC_DB_MEASURE_COLS_VL
503: where upper(measure_col) = upper(p_Dataset_Rec.Bsc_Measure_Col);
504: if (l_count_mescol > 0) then
505: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
506: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);

Line 791: FROM BSC_DB_MEASURE_COLS_VL

787: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
788:
789: IF l_Count = 0 THEN
790: SELECT COUNT(1) INTO l_count
791: FROM BSC_DB_MEASURE_COLS_VL
792: WHERE MEASURE_COL = l_Measure_Col;
793: IF l_Count > 0 THEN
794: BSC_DB_MEASURE_COLS_PKG.delete_row(l_Measure_Col);
795: END IF;

Line 834: FROM BSC_DB_MEASURE_COLS_VL

830: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
831:
832: IF l_Count = 0 THEN
833: SELECT COUNT(1) INTO l_count
834: FROM BSC_DB_MEASURE_COLS_VL
835: WHERE MEASURE_COL = l_Measure_Col;
836: IF l_Count > 0 THEN
837: BSC_DB_MEASURE_COLS_PKG.delete_row(l_Measure_Col);
838: END IF;