eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_COLOR_TYPE_PROPS

Line 513: FROM bsc_color_type_props

509: SAVEPOINT BscColorRangePub_SaveColorRng;
510: IF (p_kpi_measure_id IS NULL) THEN
511: SELECT COUNT(1)
512: INTO l_range_count
513: FROM bsc_color_type_props
514: WHERE indicator = p_objective_id
515: AND kpi_measure_id IS NULL;
516: ELSE
517: IF (p_property_value IS NULL) THEN

Line 520: FROM bsc_color_type_props

516: ELSE
517: IF (p_property_value IS NULL) THEN
518: SELECT COUNT(1)
519: INTO l_range_count
520: FROM bsc_color_type_props
521: WHERE indicator = p_objective_id
522: AND kpi_measure_id = p_kpi_measure_id;
523: ELSE
524: SELECT COUNT(1)

Line 526: FROM bsc_color_type_props

522: AND kpi_measure_id = p_kpi_measure_id;
523: ELSE
524: SELECT COUNT(1)
525: INTO l_range_count
526: FROM bsc_color_type_props
527: WHERE indicator = p_objective_id
528: AND kpi_measure_id = p_kpi_measure_id
529: AND property_value = p_property_value;
530: END IF;

Line 794: FROM bsc_color_type_props

790: IS
791:
792: CURSOR c_obj_range_id IS
793: SELECT color_range_id
794: FROM bsc_color_type_props
795: WHERE indicator = p_objective_id;
796:
797: CURSOR c_kpi_range_id IS
798: SELECT color_range_id

Line 799: FROM bsc_color_type_props

795: WHERE indicator = p_objective_id;
796:
797: CURSOR c_kpi_range_id IS
798: SELECT color_range_id
799: FROM bsc_color_type_props
800: WHERE indicator = p_objective_id
801: AND kpi_measure_id = p_kpi_measure_id
802: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
803:

Line 845: FROM bsc_color_type_props

841: l_range_lud DATE;
842:
843: CURSOR c_color_range_ids IS
844: SELECT color_range_id, last_update_date
845: FROM bsc_color_type_props
846: WHERE indicator = p_objective_id
847: AND NVL(kpi_measure_id, -999) = NVL(p_kpi_measure_id, -999)
848: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
849:

Line 881: UPDATE bsc_color_type_props

877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880: IF (p_kpi_measure_id IS NULL) THEN
881: UPDATE bsc_color_type_props
882: SET last_update_date = sysdate
883: ,last_updated_by = FND_GLOBAL.USER_ID
884: WHERE indicator = p_objective_id
885: AND kpi_measure_id IS NULL;

Line 887: UPDATE bsc_color_type_props

883: ,last_updated_by = FND_GLOBAL.USER_ID
884: WHERE indicator = p_objective_id
885: AND kpi_measure_id IS NULL;
886: ELSE
887: UPDATE bsc_color_type_props
888: SET last_update_date = sysdate
889: ,last_updated_by = FND_GLOBAL.USER_ID
890: WHERE indicator = p_objective_id
891: AND kpi_measure_id = p_kpi_measure_id

Line 923: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am

919: IF (p_kpi_measure_id IS NOT NULL) THEN
920: SELECT am.analysis_option0, am.analysis_option1,
921: am.analysis_option2, am.series_id
922: INTO l_an_opt0, l_an_opt1, l_an_opt2, l_series_id
923: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am
924: WHERE cprop.kpi_measure_id = am.kpi_measure_id
925: AND cprop.indicator = am.indicator
926: AND color_range_id = l_color_range_ids_rec.color_range_id;
927: END IF;

Line 933: FROM bsc_color_type_props

929: FOR c_shared IN c_shared_obj LOOP
930: IF (p_kpi_measure_id IS NULL) THEN
931: SELECT color_range_id
932: INTO l_range_id
933: FROM bsc_color_type_props
934: WHERE indicator = c_shared.indicator
935: AND kpi_measure_id IS NULL;
936:
937: UPDATE bsc_color_type_props

Line 937: UPDATE bsc_color_type_props

933: FROM bsc_color_type_props
934: WHERE indicator = c_shared.indicator
935: AND kpi_measure_id IS NULL;
936:
937: UPDATE bsc_color_type_props
938: SET last_update_date = sysdate
939: ,last_updated_by = FND_GLOBAL.USER_ID
940: WHERE indicator = c_shared.indicator
941: AND kpi_measure_id IS NULL;

Line 952: UPDATE bsc_color_type_props

948: AND analysis_option1 = l_an_opt1
949: AND analysis_option2 = l_an_opt2
950: AND series_id = l_series_id;
951:
952: UPDATE bsc_color_type_props
953: SET last_update_date = sysdate
954: ,last_updated_by = FND_GLOBAL.USER_ID
955: WHERE indicator = c_shared.indicator
956: AND kpi_measure_id = l_kpi_measure_id

Line 1249: FROM bsc_color_type_props ct

1245: AND prototype_flag <> 2;
1246:
1247: CURSOR c_all_ranges IS
1248: SELECT color_range_id
1249: FROM bsc_color_type_props ct
1250: WHERE indicator = l_objective_id;
1251:
1252: CURSOR c_measure_ranges IS
1253: SELECT color_range_id

Line 1254: FROM bsc_color_type_props ct

1250: WHERE indicator = l_objective_id;
1251:
1252: CURSOR c_measure_ranges IS
1253: SELECT color_range_id
1254: FROM bsc_color_type_props ct
1255: WHERE indicator = l_objective_id
1256: AND kpi_measure_id = l_kpi_measure_id;
1257:
1258: BEGIN

Line 1421: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am

1417: SELECT cprop.indicator, am.analysis_option0,
1418: am.analysis_option1, am.analysis_option2, am.series_id,
1419: cprop.property_value
1420: INTO l_objective_id, l_an_opt0, l_an_opt1, l_an_opt2, l_series_id, l_property_value
1421: FROM bsc_color_type_props cprop, bsc_kpi_analysis_measures_b am
1422: WHERE cprop.kpi_measure_id = am.kpi_measure_id
1423: AND color_range_id = p_color_range_id;
1424:
1425: FOR c_shared IN c_shared_obj LOOP