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.WSH_TRIPS_ACTIONS dependencies on FND_GLOBAL

Line 1090: last_updated_by = fnd_global.user_id,

1086:
1087: UPDATE wsh_trips
1088: SET status_code = p_status_code,
1089: last_update_date = SYSDATE,
1090: last_updated_by = fnd_global.user_id,
1091: last_update_login = fnd_global.login_id
1092: WHERE trip_id = p_trip_id;
1093:
1094: IF (SQL%NOTFOUND) THEN

Line 1091: last_update_login = fnd_global.login_id

1087: UPDATE wsh_trips
1088: SET status_code = p_status_code,
1089: last_update_date = SYSDATE,
1090: last_updated_by = fnd_global.user_id,
1091: last_update_login = fnd_global.login_id
1092: WHERE trip_id = p_trip_id;
1093:
1094: IF (SQL%NOTFOUND) THEN
1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1324: last_updated_by = fnd_global.user_id,

1320:
1321: UPDATE wsh_trips
1322: SET status_code = p_in_rec.new_status_code,
1323: last_update_date = SYSDATE,
1324: last_updated_by = fnd_global.user_id,
1325: last_update_login = fnd_global.login_id
1326: WHERE trip_id = p_in_rec.trip_id;
1327:
1328: IF (SQL%NOTFOUND) THEN

Line 1325: last_update_login = fnd_global.login_id

1321: UPDATE wsh_trips
1322: SET status_code = p_in_rec.new_status_code,
1323: last_update_date = SYSDATE,
1324: last_updated_by = fnd_global.user_id,
1325: last_update_login = fnd_global.login_id
1326: WHERE trip_id = p_in_rec.trip_id;
1327:
1328: IF (SQL%NOTFOUND) THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2769: l_trip_info.created_by := fnd_global.user_id;

2765: l_trip_info.ignore_for_planning := l_ignore_for_planning;
2766: l_trip_info.planned_flag := 'N';
2767: l_trip_info.status_code := 'OP';
2768: l_trip_info.creation_date := SYSDATE;
2769: l_trip_info.created_by := fnd_global.user_id;
2770: l_trip_info.last_update_date := SYSDATE;
2771: l_trip_info.last_updated_by := fnd_global.user_id;
2772: l_trip_info.last_update_login := fnd_global.login_id;
2773: --

Line 2771: l_trip_info.last_updated_by := fnd_global.user_id;

2767: l_trip_info.status_code := 'OP';
2768: l_trip_info.creation_date := SYSDATE;
2769: l_trip_info.created_by := fnd_global.user_id;
2770: l_trip_info.last_update_date := SYSDATE;
2771: l_trip_info.last_updated_by := fnd_global.user_id;
2772: l_trip_info.last_update_login := fnd_global.login_id;
2773: --
2774: /* H integration */
2775: /* The trip level call should have been made at parent level */

Line 2772: l_trip_info.last_update_login := fnd_global.login_id;

2768: l_trip_info.creation_date := SYSDATE;
2769: l_trip_info.created_by := fnd_global.user_id;
2770: l_trip_info.last_update_date := SYSDATE;
2771: l_trip_info.last_updated_by := fnd_global.user_id;
2772: l_trip_info.last_update_login := fnd_global.login_id;
2773: --
2774: /* H integration */
2775: /* The trip level call should have been made at parent level */
2776: --

Line 4483: last_updated_by = FND_GLOBAL.USER_ID

4479: UPDATE wsh_trip_stops
4480: SET stop_location_id= l_phys_trip_pickup_loc_id,
4481: physical_location_id=null,
4482: last_update_date = sysdate,
4483: last_updated_by = FND_GLOBAL.USER_ID
4484: WHERE stop_id=p_pickup_stop_id;
4485:
4486: --set the l_trip_pickup_loc_id to point to the new value
4487: x_pickup_location_id:=l_phys_trip_pickup_loc_id;

Line 4666: last_updated_by = FND_GLOBAL.USER_ID

4662: UPDATE wsh_trip_stops
4663: SET stop_location_id= l_dropoff_location_id,
4664: physical_location_id=l_trip_dropoff_loc_id,
4665: last_update_date = sysdate,
4666: last_updated_by = FND_GLOBAL.USER_ID
4667: WHERE stop_id=p_dropoff_stop_id;
4668:
4669: --set the l_trip_dropoff_loc_id to point to the new value
4670: x_dropoff_location_id:=l_dropoff_location_id;

Line 7037: last_updated_by = FND_GLOBAL.user_id,

7033: UPDATE wsh_trip_stops
7034: SET planned_arrival_date = l_stop_rec.planned_arrival_date,
7035: planned_departure_date = l_stop_rec.planned_departure_date,
7036: last_update_date = SYSDATE,
7037: last_updated_by = FND_GLOBAL.user_id,
7038: last_update_login = FND_GLOBAL.login_id
7039: WHERE stop_id = l_stop_rec.stop_id;
7040:
7041: -- DBI Project

Line 7038: last_update_login = FND_GLOBAL.login_id

7034: SET planned_arrival_date = l_stop_rec.planned_arrival_date,
7035: planned_departure_date = l_stop_rec.planned_departure_date,
7036: last_update_date = SYSDATE,
7037: last_updated_by = FND_GLOBAL.user_id,
7038: last_update_login = FND_GLOBAL.login_id
7039: WHERE stop_id = l_stop_rec.stop_id;
7040:
7041: -- DBI Project
7042: -- Updating WSH_TRIP_STOPS.

Line 7902: last_updated_by = FND_GLOBAL.USER_ID,

7898: PLANNED_ARRIVAL_DATE = l_getstops_pl_arr_date(j),
7899: PLANNED_DEPARTURE_DATE = l_getstops_pl_dep_date(j),
7900: STOP_SEQUENCE_NUMBER = l_getstops_stop_seq_num(j),
7901: last_update_date = SYSDATE,
7902: last_updated_by = FND_GLOBAL.USER_ID,
7903: last_update_login = FND_GLOBAL.LOGIN_ID
7904: WHERE STOP_ID = l_getstops_stop_id(j);
7905: IF l_debug_on THEN
7906: WSH_DEBUG_SV.log(l_module_name,'done update' , l_getstops_stop_id.count);

Line 7903: last_update_login = FND_GLOBAL.LOGIN_ID

7899: PLANNED_DEPARTURE_DATE = l_getstops_pl_dep_date(j),
7900: STOP_SEQUENCE_NUMBER = l_getstops_stop_seq_num(j),
7901: last_update_date = SYSDATE,
7902: last_updated_by = FND_GLOBAL.USER_ID,
7903: last_update_login = FND_GLOBAL.LOGIN_ID
7904: WHERE STOP_ID = l_getstops_stop_id(j);
7905: IF l_debug_on THEN
7906: WSH_DEBUG_SV.log(l_module_name,'done update' , l_getstops_stop_id.count);
7907: END IF;