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_UPGRADE dependencies on FND_GLOBAL

Line 62: last_updated_by = FND_GLOBAL.USER_ID

58:
59: UPDATE bsc_kpis_b
60: SET color_rollup_type = 'DEFAULT_KPI',
61: last_update_date = SYSDATE,
62: last_updated_by = FND_GLOBAL.USER_ID
63: WHERE color_rollup_type IS NULL;
64:
65: --COMMIT;
66: RETURN TRUE;

Line 91: last_updated_by = FND_GLOBAL.USER_ID

87: 'X', 8421504,
88: 8421504
89: ),
90: last_update_date = SYSDATE,
91: last_updated_by = FND_GLOBAL.USER_ID
92: WHERE prototype_color_id IS NULL;
93: --COMMIT;
94: RETURN TRUE;
95: EXCEPTION

Line 326: l_kpi_measure_props_rec.created_by := FND_GLOBAL.USER_ID;

322: l_kpi_measure_props_rec.disable_color := 'T';
323: l_kpi_measure_props_rec.disable_trend := 'T';
324: l_kpi_measure_props_rec.prototype_color := 24865;
325: l_kpi_measure_props_rec.color_by_total := 1;
326: l_kpi_measure_props_rec.created_by := FND_GLOBAL.USER_ID;
327: l_kpi_measure_props_rec.creation_date := SYSDATE;
328: l_kpi_measure_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
329: l_kpi_measure_props_rec.last_update_date := SYSDATE;
330: l_kpi_measure_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 328: l_kpi_measure_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

324: l_kpi_measure_props_rec.prototype_color := 24865;
325: l_kpi_measure_props_rec.color_by_total := 1;
326: l_kpi_measure_props_rec.created_by := FND_GLOBAL.USER_ID;
327: l_kpi_measure_props_rec.creation_date := SYSDATE;
328: l_kpi_measure_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
329: l_kpi_measure_props_rec.last_update_date := SYSDATE;
330: l_kpi_measure_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
331:
332: l_kpi_measure_props_rec.apply_color_flag := get_apply_color_flag

Line 330: l_kpi_measure_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

326: l_kpi_measure_props_rec.created_by := FND_GLOBAL.USER_ID;
327: l_kpi_measure_props_rec.creation_date := SYSDATE;
328: l_kpi_measure_props_rec.last_updated_by := FND_GLOBAL.USER_ID;
329: l_kpi_measure_props_rec.last_update_date := SYSDATE;
330: l_kpi_measure_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
331:
332: l_kpi_measure_props_rec.apply_color_flag := get_apply_color_flag
333: ( l_kpi_measure_rec.indicator
334: , l_kpi_measure_rec.kpi_measure_id

Line 525: last_updated_by = FND_GLOBAL.USER_ID

521: IF l_default_kpi_measure_id IS NOT NULL THEN
522: UPDATE bsc_kpi_measure_props
523: SET default_calculation = l_obj_default_calc_rec.calculation_id,
524: last_update_date = SYSDATE,
525: last_updated_by = FND_GLOBAL.USER_ID
526: WHERE indicator = l_obj_default_calc_rec.objective_id
527: AND kpi_measure_id = l_default_kpi_measure_id
528: AND default_calculation IS NULL;
529: END IF;

Line 920: last_updated_by = FND_GLOBAL.USER_ID

916: IF (c_init_colors.property_code = 'LGREEN_COLOR') THEN
917: UPDATE bsc_sys_colors_b
918: SET user_forecast_color = c_init_colors.property_value,
919: last_update_date = SYSDATE,
920: last_updated_by = FND_GLOBAL.USER_ID
921: WHERE perf_sequence = (SELECT
922: MIN(perf_sequence) FROM bsc_sys_colors_b);
923: ELSIF (c_init_colors.property_code = 'GREEN_COLOR') THEN
924: UPDATE bsc_sys_colors_b

Line 927: last_updated_by = FND_GLOBAL.USER_ID

923: ELSIF (c_init_colors.property_code = 'GREEN_COLOR') THEN
924: UPDATE bsc_sys_colors_b
925: SET user_color = c_init_colors.property_value,
926: last_update_date = SYSDATE,
927: last_updated_by = FND_GLOBAL.USER_ID
928: WHERE perf_sequence = (SELECT
929: MIN(perf_sequence) FROM bsc_sys_colors_b);
930: ELSIF (c_init_colors.property_code = 'LYELLOW_COLOR') THEN
931: UPDATE bsc_sys_colors_b

Line 934: last_updated_by = FND_GLOBAL.USER_ID

930: ELSIF (c_init_colors.property_code = 'LYELLOW_COLOR') THEN
931: UPDATE bsc_sys_colors_b
932: SET user_forecast_color = c_init_colors.property_value,
933: last_update_date = SYSDATE,
934: last_updated_by = FND_GLOBAL.USER_ID
935: WHERE short_name = 'AVERAGE_COLOR';
936: ELSIF (c_init_colors.property_code = 'YELLOW_COLOR') THEN
937: UPDATE bsc_sys_colors_b
938: SET user_color = c_init_colors.property_value,

Line 940: last_updated_by = FND_GLOBAL.USER_ID

936: ELSIF (c_init_colors.property_code = 'YELLOW_COLOR') THEN
937: UPDATE bsc_sys_colors_b
938: SET user_color = c_init_colors.property_value,
939: last_update_date = SYSDATE,
940: last_updated_by = FND_GLOBAL.USER_ID
941: WHERE short_name = 'AVERAGE_COLOR';
942: ELSIF (c_init_colors.property_code = 'LRED_COLOR') THEN
943: UPDATE bsc_sys_colors_b
944: SET user_forecast_color = c_init_colors.property_value,

Line 946: last_updated_by = FND_GLOBAL.USER_ID

942: ELSIF (c_init_colors.property_code = 'LRED_COLOR') THEN
943: UPDATE bsc_sys_colors_b
944: SET user_forecast_color = c_init_colors.property_value,
945: last_update_date = SYSDATE,
946: last_updated_by = FND_GLOBAL.USER_ID
947: WHERE perf_sequence = (SELECT
948: MAX(perf_sequence) FROM bsc_sys_colors_b);
949: ELSIF (c_init_colors.property_code = 'RED_COLOR') THEN
950: UPDATE bsc_sys_colors_b

Line 953: last_updated_by = FND_GLOBAL.USER_ID

949: ELSIF (c_init_colors.property_code = 'RED_COLOR') THEN
950: UPDATE bsc_sys_colors_b
951: SET user_color = c_init_colors.property_value,
952: last_update_date = SYSDATE,
953: last_updated_by = FND_GLOBAL.USER_ID
954: WHERE perf_sequence = (SELECT
955: MAX(perf_sequence) FROM bsc_sys_colors_b);
956: ELSIF (c_init_colors.property_code = 'LGRAY_COLOR') THEN
957: UPDATE bsc_sys_colors_b

Line 960: last_updated_by = FND_GLOBAL.USER_ID

956: ELSIF (c_init_colors.property_code = 'LGRAY_COLOR') THEN
957: UPDATE bsc_sys_colors_b
958: SET user_forecast_color = c_init_colors.property_value,
959: last_update_date = SYSDATE,
960: last_updated_by = FND_GLOBAL.USER_ID
961: WHERE perf_sequence IS NULL;
962: ELSIF (c_init_colors.property_code = 'DGRAY_COLOR') THEN
963: UPDATE bsc_sys_colors_b
964: SET user_color = c_init_colors.property_value,

Line 966: last_updated_by = FND_GLOBAL.USER_ID

962: ELSIF (c_init_colors.property_code = 'DGRAY_COLOR') THEN
963: UPDATE bsc_sys_colors_b
964: SET user_color = c_init_colors.property_value,
965: last_update_date = SYSDATE,
966: last_updated_by = FND_GLOBAL.USER_ID
967: WHERE perf_sequence IS NULL;
968: END IF;
969: EXCEPTION
970: WHEN OTHERS THEN