APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_DB_MEASURE_COLS_TL

Line 101: -- bsc_db_measure_cols_tl

97: -- 03-MAY-05 akoduri Enh #4268374 -- Weighted Average Measures --
98: -- 23-May-05 visuri Bug#3994115 Added Get_Meas_With_Src_Col() and Get_Sing_Par_Meas_DS()
99: -- 17-JUL-05 sawu Bug#4482736: Added Get_Primary_Data_Source
100: -- 20-Sep-05 akoduri Bug#4613172: CDS type measures should not get populated into
101: -- bsc_db_measure_cols_tl
102: -- 22-Sep-05 ashankar Bug#4605142:Modified the API Get_Incr_Truigger
103: -- 21-oct-05 ashankar Bug#4630974 Modified the API Get_Incr_Trigger
104: -- by moving the check for structural modifications
105: -- before color changes

Line 798: -- Bug#3817894; SUBSTR is used since BSC_DB_MEASURE_COLS_TL.HELP is of VARCHAR2(150) type.

794: else
795: l_Dataset_Rec.Bsc_Measure_Col := p_measure_col;
796: end if;
797:
798: -- Bug#3817894; SUBSTR is used since BSC_DB_MEASURE_COLS_TL.HELP is of VARCHAR2(150) type.
799: IF p_Measure_Col_Help IS NULL THEN
800: -- SUBSTR does not work with pseudo-translated chars. We would pass NULL then.
801: BEGIN
802: IF (p_Dataset_Help IS NOT NULL) THEN

Line 1537: l_measure_group_id BSC_DB_MEASURE_COLS_TL.Measure_Group_Id%TYPE;

1533: l_measure_col_help VARCHAR2(150);
1534: l_old_measure_id NUMBER;
1535: l_count NUMBER;
1536:
1537: l_measure_group_id BSC_DB_MEASURE_COLS_TL.Measure_Group_Id%TYPE;
1538: l_projection_id BSC_DB_MEASURE_COLS_TL.Projection_Id%TYPE;
1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;
1540:
1541: l_Del_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

Line 1538: l_projection_id BSC_DB_MEASURE_COLS_TL.Projection_Id%TYPE;

1534: l_old_measure_id NUMBER;
1535: l_count NUMBER;
1536:
1537: l_measure_group_id BSC_DB_MEASURE_COLS_TL.Measure_Group_Id%TYPE;
1538: l_projection_id BSC_DB_MEASURE_COLS_TL.Projection_Id%TYPE;
1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;
1540:
1541: l_Del_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1542: l_Delete_Source BOOLEAN;

Line 1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;

1535: l_count NUMBER;
1536:
1537: l_measure_group_id BSC_DB_MEASURE_COLS_TL.Measure_Group_Id%TYPE;
1538: l_projection_id BSC_DB_MEASURE_COLS_TL.Projection_Id%TYPE;
1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;
1540:
1541: l_Del_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1542: l_Delete_Source BOOLEAN;
1543: l_Dataset_Name BSC_SYS_DATASETS_VL.Name%TYPE;

Line 3545: FROM BSC_DB_MEASURE_COLS_TL

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
3546: WHERE UPPER(measure_col) = UPPER(l_temp_var);
3547:
3548: ELSE
3549: SELECT COUNT(1) INTO l_count

Line 3555: FROM BSC_DB_MEASURE_COLS_TL

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
3555: FROM BSC_DB_MEASURE_COLS_TL
3556: WHERE UPPER(measure_col) = UPPER(l_temp_var);
3557: END IF;
3558:
3559: IF(l_count_col > 0 OR l_count > 0) THEN