APPS.BSC_UTILITY dependencies on BIS_INDICATORS

Line 2700: FROM BIS_INDICATORS B

2696: RETURN VARCHAR2 IS
2697: l_Count NUMBER;
2698: BEGIN
2699: SELECT COUNT(1) INTO l_Count
2700: FROM BIS_INDICATORS B
2701: WHERE B.SHORT_NAME = p_Short_Name
2702: AND BIS_UTIL.is_Seeded(B.CREATED_BY,'Y','N') = 'Y';
2703:
2704: IF (l_Count <> 0 AND NOT BIS_UTIL.Is_Internal_Customer) THEN

Line 3959: FROM bis_indicators

3955: l_flag :=FND_API.G_FALSE;
3956:
3957: SELECT measure_type
3958: INTO l_measure_type
3959: FROM bis_indicators
3960: WHERE short_name = p_Measure_Short_Name;
3961:
3962: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
3963: l_flag:=FND_API.G_TRUE;

Line 3987: bis_indicators i

3983:
3984: SELECT COUNT(0)
3985: INTO l_count
3986: FROM bis_target_levels tl,
3987: bis_indicators i
3988: WHERE i.dataset_id = p_Dataset_Id
3989: AND tl.indicator_id = i.indicator_id;
3990:
3991: IF(l_count>0)THEN

Line 4012: FROM bis_indicators

4008: l_flag :=FND_API.G_FALSE;
4009:
4010: SELECT measure_type
4011: INTO l_measure_type
4012: FROM bis_indicators
4013: WHERE dataset_id = p_dataset_id;
4014:
4015: IF((l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_SCORE) OR (l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_PERF))THEN
4016: l_flag:=FND_API.G_TRUE;

Line 4033: l_meas_short_name BIS_INDICATORS.short_name%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;
4034: l_flag VARCHAR2(10);
4035: BEGIN
4036:
4037: l_flag := FND_API.G_FALSE;

Line 4046: FROM bis_indicators

4042: WHERE indicator =p_Indicator;
4043:
4044: SELECT short_name
4045: INTO l_meas_short_name
4046: FROM bis_indicators
4047: WHERE dataset_id =p_Dataset_Id;
4048:
4049: l_flag := BSC_BIS_KPI_CRUD_PUB.Is_Primary_Source_Of_Measure
4050: (

Line 4074: FROM bis_indicators

4070: l_flag :=FND_API.G_FALSE;
4071:
4072: SELECT measure_type
4073: INTO l_measure_type
4074: FROM bis_indicators
4075: WHERE dataset_id = p_dataset_id;
4076:
4077: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
4078: l_flag:=FND_API.G_TRUE;

Line 4103: FROM bis_indicators

4099: l_count := 0;
4100:
4101: SELECT short_name
4102: INTO l_attribute2
4103: FROM bis_indicators
4104: WHERE dataset_id =p_dataset_id;
4105:
4106: SELECT COUNT(1)
4107: INTO l_count