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

Line 629: last_updated_by = FND_GLOBAL.user_id,

625: unit_weight = NVL(unit_weight,l_item_unit_wt),
626: unit_volume = NVL(unit_volume,l_item_unit_vol),
627: wv_frozen_flag = decode(l_frozen_flag,NULL,wv_frozen_flag,l_frozen_flag),
628: last_update_date = SYSDATE,
629: last_updated_by = FND_GLOBAL.user_id,
630: last_update_login = FND_GLOBAL.login_id
631: WHERE delivery_detail_id = p_delivery_detail_id;
632:
633: IF SQL%NOTFOUND THEN

Line 630: last_update_login = FND_GLOBAL.login_id

626: unit_volume = NVL(unit_volume,l_item_unit_vol),
627: wv_frozen_flag = decode(l_frozen_flag,NULL,wv_frozen_flag,l_frozen_flag),
628: last_update_date = SYSDATE,
629: last_updated_by = FND_GLOBAL.user_id,
630: last_update_login = FND_GLOBAL.login_id
631: WHERE delivery_detail_id = p_delivery_detail_id;
632:
633: IF SQL%NOTFOUND THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1100: last_updated_by = FND_GLOBAL.user_id,

1096: --Included update for new wt/vol columns
1097: IF p_stop_type = 'DROPOFF' THEN
1098: update wsh_trip_stops
1099: set last_update_date = SYSDATE,
1100: last_updated_by = FND_GLOBAL.user_id,
1101: last_update_login = FND_GLOBAL.login_id,
1102: drop_off_weight = l_drop_off_weight,
1103: drop_off_volume = l_drop_off_volume
1104: where stop_id = p_entity_id;

Line 1101: last_update_login = FND_GLOBAL.login_id,

1097: IF p_stop_type = 'DROPOFF' THEN
1098: update wsh_trip_stops
1099: set last_update_date = SYSDATE,
1100: last_updated_by = FND_GLOBAL.user_id,
1101: last_update_login = FND_GLOBAL.login_id,
1102: drop_off_weight = l_drop_off_weight,
1103: drop_off_volume = l_drop_off_volume
1104: where stop_id = p_entity_id;
1105:

Line 1109: last_updated_by = FND_GLOBAL.user_id,

1105:
1106: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1107: update wsh_trip_stops
1108: set last_update_date = SYSDATE,
1109: last_updated_by = FND_GLOBAL.user_id,
1110: last_update_login = FND_GLOBAL.login_id,
1111: pick_up_weight = l_pick_up_weight,
1112: pick_up_volume = l_pick_up_volume
1113: where stop_id = p_entity_id;

Line 1110: last_update_login = FND_GLOBAL.login_id,

1106: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1107: update wsh_trip_stops
1108: set last_update_date = SYSDATE,
1109: last_updated_by = FND_GLOBAL.user_id,
1110: last_update_login = FND_GLOBAL.login_id,
1111: pick_up_weight = l_pick_up_weight,
1112: pick_up_volume = l_pick_up_volume
1113: where stop_id = p_entity_id;
1114: ELSIF NVL(l_frozen_flag, 'N') = 'N' THEN

Line 1122: last_updated_by = FND_GLOBAL.user_id,

1118: departure_net_weight = l_net_weight,
1119: departure_volume = l_volume,
1120: departure_fill_percent = l_fill_percent,
1121: last_update_date = SYSDATE,
1122: last_updated_by = FND_GLOBAL.user_id,
1123: last_update_login = FND_GLOBAL.login_id,
1124: pick_up_weight = l_pick_up_weight,
1125: pick_up_volume = l_pick_up_volume
1126: where stop_id = p_entity_id;

Line 1123: last_update_login = FND_GLOBAL.login_id,

1119: departure_volume = l_volume,
1120: departure_fill_percent = l_fill_percent,
1121: last_update_date = SYSDATE,
1122: last_updated_by = FND_GLOBAL.user_id,
1123: last_update_login = FND_GLOBAL.login_id,
1124: pick_up_weight = l_pick_up_weight,
1125: pick_up_volume = l_pick_up_volume
1126: where stop_id = p_entity_id;
1127: ELSE

Line 1134: last_updated_by = FND_GLOBAL.user_id,

1130: departure_net_weight = l_net_weight,
1131: departure_volume = l_volume,
1132: departure_fill_percent = l_fill_percent,
1133: last_update_date = SYSDATE,
1134: last_updated_by = FND_GLOBAL.user_id,
1135: last_update_login = FND_GLOBAL.login_id
1136: where stop_id = p_entity_id;
1137: END IF;
1138: END IF;

Line 1135: last_update_login = FND_GLOBAL.login_id

1131: departure_volume = l_volume,
1132: departure_fill_percent = l_fill_percent,
1133: last_update_date = SYSDATE,
1134: last_updated_by = FND_GLOBAL.user_id,
1135: last_update_login = FND_GLOBAL.login_id
1136: where stop_id = p_entity_id;
1137: END IF;
1138: END IF;
1139:

Line 1247: last_updated_by = FND_GLOBAL.user_id,

1243: set gross_weight = l_gross_weight,
1244: net_weight = l_net_weight,
1245: volume = l_volume,
1246: last_update_date = SYSDATE,
1247: last_updated_by = FND_GLOBAL.user_id,
1248: last_update_login = FND_GLOBAL.login_id
1249: where delivery_id = p_entity_id;
1250:
1251: -- Call Adjust_parent_WV recursively to adjust W/V on parent stops, if any

Line 1248: last_update_login = FND_GLOBAL.login_id

1244: net_weight = l_net_weight,
1245: volume = l_volume,
1246: last_update_date = SYSDATE,
1247: last_updated_by = FND_GLOBAL.user_id,
1248: last_update_login = FND_GLOBAL.login_id
1249: where delivery_id = p_entity_id;
1250:
1251: -- Call Adjust_parent_WV recursively to adjust W/V on parent stops, if any
1252: --

Line 1959: last_updated_by = FND_GLOBAL.user_id,

1955: net_weight = null,
1956: volume = null,
1957: wv_frozen_flag = 'N',
1958: last_update_date = SYSDATE,
1959: last_updated_by = FND_GLOBAL.user_id,
1960: last_update_login = FND_GLOBAL.login_id
1961: WHERE delivery_id = l_delivery_id;
1962:
1963: CLOSE C5;

Line 1960: last_update_login = FND_GLOBAL.login_id

1956: volume = null,
1957: wv_frozen_flag = 'N',
1958: last_update_date = SYSDATE,
1959: last_updated_by = FND_GLOBAL.user_id,
1960: last_update_login = FND_GLOBAL.login_id
1961: WHERE delivery_id = l_delivery_id;
1962:
1963: CLOSE C5;
1964:

Line 2264: last_updated_by = FND_GLOBAL.user_id,

2260: departure_volume = null,
2261: departure_fill_percent = null,
2262: wv_frozen_flag = 'N',
2263: last_update_date = SYSDATE,
2264: last_updated_by = FND_GLOBAL.user_id,
2265: last_update_login = FND_GLOBAL.login_id,
2266: pick_up_weight = null,
2267: pick_up_volume = null,
2268: drop_off_weight = null,

Line 2265: last_update_login = FND_GLOBAL.login_id,

2261: departure_fill_percent = null,
2262: wv_frozen_flag = 'N',
2263: last_update_date = SYSDATE,
2264: last_updated_by = FND_GLOBAL.user_id,
2265: last_update_login = FND_GLOBAL.login_id,
2266: pick_up_weight = null,
2267: pick_up_volume = null,
2268: drop_off_weight = null,
2269: drop_off_volume = null

Line 2760: last_updated_by = FND_GLOBAL.user_id,

2756: unit_weight = NVL(unit_weight,decode(p_unit_weight,-99,NULL,p_unit_weight)),
2757: unit_volume = NVL(unit_volume,decode(p_unit_volume,-99,NULL,p_unit_volume)),
2758: wv_frozen_flag = 'N',
2759: last_update_date = SYSDATE,
2760: last_updated_by = FND_GLOBAL.user_id,
2761: last_update_login = FND_GLOBAL.login_id
2762: WHERE delivery_detail_id = p_container_instance_id;
2763:
2764: IF SQL%NOTFOUND THEN

Line 2761: last_update_login = FND_GLOBAL.login_id

2757: unit_volume = NVL(unit_volume,decode(p_unit_volume,-99,NULL,p_unit_volume)),
2758: wv_frozen_flag = 'N',
2759: last_update_date = SYSDATE,
2760: last_updated_by = FND_GLOBAL.user_id,
2761: last_update_login = FND_GLOBAL.login_id
2762: WHERE delivery_detail_id = p_container_instance_id;
2763:
2764: IF SQL%NOTFOUND THEN
2765: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3316: last_updated_by = FND_GLOBAL.user_id,

3312: unit_weight = NVL(unit_weight,childInfo_rec.unit_weight),
3313: unit_volume = NVL(unit_volume,childInfo_rec.unit_volume),
3314: wv_frozen_flag = 'N',
3315: last_update_date = SYSDATE,
3316: last_updated_by = FND_GLOBAL.user_id,
3317: last_update_login = FND_GLOBAL.login_id
3318: WHERE delivery_detail_id = childInfo_rec.delivery_detail_id;
3319: --
3320: --

Line 3317: last_update_login = FND_GLOBAL.login_id

3313: unit_volume = NVL(unit_volume,childInfo_rec.unit_volume),
3314: wv_frozen_flag = 'N',
3315: last_update_date = SYSDATE,
3316: last_updated_by = FND_GLOBAL.user_id,
3317: last_update_login = FND_GLOBAL.login_id
3318: WHERE delivery_detail_id = childInfo_rec.delivery_detail_id;
3319: --
3320: --
3321: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0

Line 5709: last_updated_by = FND_GLOBAL.user_id,

5705: gross_weight = x_gross_weight,
5706: volume = x_volume,
5707: wv_frozen_flag = 'N',
5708: last_update_date = SYSDATE,
5709: last_updated_by = FND_GLOBAL.user_id,
5710: last_update_login = FND_GLOBAL.login_id
5711: WHERE delivery_id = p_delivery_id;
5712:
5713: IF (SQL%NOTFOUND) THEN

Line 5710: last_update_login = FND_GLOBAL.login_id

5706: volume = x_volume,
5707: wv_frozen_flag = 'N',
5708: last_update_date = SYSDATE,
5709: last_updated_by = FND_GLOBAL.user_id,
5710: last_update_login = FND_GLOBAL.login_id
5711: WHERE delivery_id = p_delivery_id;
5712:
5713: IF (SQL%NOTFOUND) THEN
5714: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 6934: last_updated_by = FND_GLOBAL.user_id,

6930: SET gross_weight = l_dd_upd_gross_wt_tbl(i),
6931: net_weight = l_dd_upd_net_wt_tbl(i),
6932: wv_frozen_flag = 'Y',
6933: last_update_date = SYSDATE,
6934: last_updated_by = FND_GLOBAL.user_id,
6935: last_update_login = FND_GLOBAL.login_id
6936: WHERE delivery_detail_id = l_dd_upd_tbl(i);
6937:
6938: -- Make the recursive call to prorate the weights further down.

Line 6935: last_update_login = FND_GLOBAL.login_id

6931: net_weight = l_dd_upd_net_wt_tbl(i),
6932: wv_frozen_flag = 'Y',
6933: last_update_date = SYSDATE,
6934: last_updated_by = FND_GLOBAL.user_id,
6935: last_update_login = FND_GLOBAL.login_id
6936: WHERE delivery_detail_id = l_dd_upd_tbl(i);
6937:
6938: -- Make the recursive call to prorate the weights further down.
6939: IF l_lpn_tab.COUNT > 0 THEN