APPS.BSC_KPI_SERIES_PUB dependencies on BSC_KPIS_B

Line 183: l_color_rollup_type bsc_kpis_b.color_rollup_type%TYPE;

179: ) IS
180:
181: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
182: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
183: l_color_rollup_type bsc_kpis_b.color_rollup_type%TYPE;
184:
185: CURSOR c_kpi_measure_id IS
186: SELECT
187: km.kpi_measure_id

Line 200: bsc_kpis_b

196: CURSOR c_shared_objs IS
197: SELECT
198: indicator
199: FROM
200: bsc_kpis_b
201: WHERE
202: source_indicator = p_Indicator AND
203: prototype_flag <> 2 AND
204: share_flag = 2;

Line 419: bsc_kpis_b

415: CURSOR c_shared_objs IS
416: SELECT
417: indicator
418: FROM
419: bsc_kpis_b
420: WHERE
421: source_indicator = p_Indicator AND
422: prototype_flag <> 2 AND
423: share_flag = 2;

Line 550: bsc_kpis_b

546: CURSOR c_shared_objs IS
547: SELECT
548: indicator
549: FROM
550: bsc_kpis_b
551: WHERE
552: source_indicator = p_Indicator AND
553: prototype_flag <> 2 AND
554: share_flag = 2;

Line 560: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

556: BEGIN
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558:
559: IF p_Indicator IS NOT NULL THEN
560: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
561: ,'indicator'
562: , p_Indicator);
563: IF l_Count = 0 THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 798: bsc_kpis_b

794: CURSOR c_shared_objs IS
795: SELECT
796: indicator
797: FROM
798: bsc_kpis_b
799: WHERE
800: source_indicator = p_Indicator AND
801: prototype_flag <> 2 AND
802: share_flag = 2;

Line 808: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

804: BEGIN
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806:
807: IF p_Indicator IS NOT NULL THEN
808: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
809: ,'indicator'
810: , p_Indicator);
811: IF l_Count = 0 THEN
812: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1090: bsc_kpis_b

1086: CURSOR c_shared_objs IS
1087: SELECT
1088: indicator
1089: FROM
1090: bsc_kpis_b
1091: WHERE
1092: source_indicator = p_Indicator AND
1093: prototype_flag <> 2 AND
1094: share_flag = 2;

Line 1099: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1095: BEGIN
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: IF p_Indicator IS NOT NULL THEN
1099: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1100: ,'indicator'
1101: , p_Indicator);
1102: IF l_Count = 0 THEN
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1571: bsc_kpis_b

1567: CURSOR c_shared_objs IS
1568: SELECT
1569: indicator
1570: FROM
1571: bsc_kpis_b
1572: WHERE
1573: source_indicator = p_Indicator AND
1574: prototype_flag <> 2 AND
1575: share_flag = 2;

Line 1746: bsc_kpis_b

1742: CURSOR c_shared_objs IS
1743: SELECT
1744: indicator
1745: FROM
1746: bsc_kpis_b
1747: WHERE
1748: source_indicator = p_Indicator AND
1749: prototype_flag <> 2 AND
1750: share_flag = 2;