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 1092: last_updated_by = fnd_global.user_id,

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

Line 1093: last_update_login = fnd_global.login_id

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

Line 1326: last_updated_by = fnd_global.user_id,

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

Line 1327: last_update_login = fnd_global.login_id

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

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

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

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

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

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

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

Line 4485: last_updated_by = FND_GLOBAL.USER_ID

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

Line 4668: last_updated_by = FND_GLOBAL.USER_ID

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

Line 7048: last_updated_by = FND_GLOBAL.user_id,

7044: UPDATE wsh_trip_stops
7045: SET planned_arrival_date = l_stop_rec.planned_arrival_date,
7046: planned_departure_date = l_stop_rec.planned_departure_date,
7047: last_update_date = SYSDATE,
7048: last_updated_by = FND_GLOBAL.user_id,
7049: last_update_login = FND_GLOBAL.login_id
7050: WHERE stop_id = l_stop_rec.stop_id;
7051:
7052: -- DBI Project

Line 7049: last_update_login = FND_GLOBAL.login_id

7045: SET planned_arrival_date = l_stop_rec.planned_arrival_date,
7046: planned_departure_date = l_stop_rec.planned_departure_date,
7047: last_update_date = SYSDATE,
7048: last_updated_by = FND_GLOBAL.user_id,
7049: last_update_login = FND_GLOBAL.login_id
7050: WHERE stop_id = l_stop_rec.stop_id;
7051:
7052: -- DBI Project
7053: -- Updating WSH_TRIP_STOPS.

Line 7913: last_updated_by = FND_GLOBAL.USER_ID,

7909: PLANNED_ARRIVAL_DATE = l_getstops_pl_arr_date(j),
7910: PLANNED_DEPARTURE_DATE = l_getstops_pl_dep_date(j),
7911: STOP_SEQUENCE_NUMBER = l_getstops_stop_seq_num(j),
7912: last_update_date = SYSDATE,
7913: last_updated_by = FND_GLOBAL.USER_ID,
7914: last_update_login = FND_GLOBAL.LOGIN_ID
7915: WHERE STOP_ID = l_getstops_stop_id(j);
7916: IF l_debug_on THEN
7917: WSH_DEBUG_SV.log(l_module_name,'done update' , l_getstops_stop_id.count);

Line 7914: last_update_login = FND_GLOBAL.LOGIN_ID

7910: PLANNED_DEPARTURE_DATE = l_getstops_pl_dep_date(j),
7911: STOP_SEQUENCE_NUMBER = l_getstops_stop_seq_num(j),
7912: last_update_date = SYSDATE,
7913: last_updated_by = FND_GLOBAL.USER_ID,
7914: last_update_login = FND_GLOBAL.LOGIN_ID
7915: WHERE STOP_ID = l_getstops_stop_id(j);
7916: IF l_debug_on THEN
7917: WSH_DEBUG_SV.log(l_module_name,'done update' , l_getstops_stop_id.count);
7918: END IF;