APPS.BSC_UTILITY dependencies on BSC_SYS_DATASETS_B

Line 3812: FROM bsc_sys_datasets_b d, bsc_sys_measures m

3808: l_count NUMBER;
3809:
3810: CURSOR c_formula_meas IS
3811: SELECT COUNT(1)
3812: FROM bsc_sys_datasets_b d, bsc_sys_measures m
3813: WHERE d.dataset_id = p_dataset_id
3814: AND m.measure_id = d.measure_id1
3815: AND ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR
3816: (d.measure_id2 IS NOT NULL) OR

Line 3818: ((SELECT COUNT(1) FROM bsc_sys_datasets_b

3814: AND m.measure_id = d.measure_id1
3815: AND ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR
3816: (d.measure_id2 IS NOT NULL) OR
3817: (BSC_UTILITY.Is_Src_Col_In_Formulas(m.measure_Col) = 'T') OR
3818: ((SELECT COUNT(1) FROM bsc_sys_datasets_b
3819: WHERE dataset_id <> d.dataset_id
3820: AND (measure_id1 = d.measure_id1 OR measure_id2 = d.measure_id1)) > 0)
3821: );
3822:

Line 4029: ,p_Dataset_Id IN BSC_SYS_DATASETS_B.dataset_id%TYPE

4025:
4026: FUNCTION Is_Report_Primary_Data_Source
4027: (
4028: p_Indicator IN BSC_KPIS_B.indicator%TYPE
4029: ,p_Dataset_Id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
4030: ) RETURN VARCHAR2
4031: IS
4032: l_region_code BSC_KPIS_B.short_name%TYPE;
4033: l_meas_short_name BIS_INDICATORS.short_name%TYPE;

Line 4064: p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE

4060:
4061:
4062: FUNCTION is_Calculated_kpi
4063: (
4064: p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
4065: )RETURN VARCHAR2
4066: IS
4067: l_flag VARCHAR2(10);
4068: l_measure_type VARCHAR2(10);

Line 4090: p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE

4086:
4087:
4088: FUNCTION Is_Meas_Used_In_Wam_Report
4089: (
4090: p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
4091: )RETURN VARCHAR2
4092: IS
4093: l_count NUMBER;
4094: l_flag VARCHAR2(10);