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 624: last_updated_by = FND_GLOBAL.user_id,

620: unit_weight = NVL(unit_weight,l_item_unit_wt),
621: unit_volume = NVL(unit_volume,l_item_unit_vol),
622: wv_frozen_flag = decode(l_frozen_flag,NULL,wv_frozen_flag,l_frozen_flag),
623: last_update_date = SYSDATE,
624: last_updated_by = FND_GLOBAL.user_id,
625: last_update_login = FND_GLOBAL.login_id
626: WHERE delivery_detail_id = p_delivery_detail_id;
627:
628: IF SQL%NOTFOUND THEN

Line 625: last_update_login = FND_GLOBAL.login_id

621: unit_volume = NVL(unit_volume,l_item_unit_vol),
622: wv_frozen_flag = decode(l_frozen_flag,NULL,wv_frozen_flag,l_frozen_flag),
623: last_update_date = SYSDATE,
624: last_updated_by = FND_GLOBAL.user_id,
625: last_update_login = FND_GLOBAL.login_id
626: WHERE delivery_detail_id = p_delivery_detail_id;
627:
628: IF SQL%NOTFOUND THEN
629: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1095: last_updated_by = FND_GLOBAL.user_id,

1091: --Included update for new wt/vol columns
1092: IF p_stop_type = 'DROPOFF' THEN
1093: update wsh_trip_stops
1094: set last_update_date = SYSDATE,
1095: last_updated_by = FND_GLOBAL.user_id,
1096: last_update_login = FND_GLOBAL.login_id,
1097: drop_off_weight = l_drop_off_weight,
1098: drop_off_volume = l_drop_off_volume
1099: where stop_id = p_entity_id;

Line 1096: last_update_login = FND_GLOBAL.login_id,

1092: IF p_stop_type = 'DROPOFF' THEN
1093: update wsh_trip_stops
1094: set last_update_date = SYSDATE,
1095: last_updated_by = FND_GLOBAL.user_id,
1096: last_update_login = FND_GLOBAL.login_id,
1097: drop_off_weight = l_drop_off_weight,
1098: drop_off_volume = l_drop_off_volume
1099: where stop_id = p_entity_id;
1100:

Line 1104: last_updated_by = FND_GLOBAL.user_id,

1100:
1101: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1102: update wsh_trip_stops
1103: set last_update_date = SYSDATE,
1104: last_updated_by = FND_GLOBAL.user_id,
1105: last_update_login = FND_GLOBAL.login_id,
1106: pick_up_weight = l_pick_up_weight,
1107: pick_up_volume = l_pick_up_volume
1108: where stop_id = p_entity_id;

Line 1105: last_update_login = FND_GLOBAL.login_id,

1101: ELSIF l_frozen_flag = 'Y' AND p_stop_type = 'PICKUP' THEN
1102: update wsh_trip_stops
1103: set last_update_date = SYSDATE,
1104: last_updated_by = FND_GLOBAL.user_id,
1105: last_update_login = FND_GLOBAL.login_id,
1106: pick_up_weight = l_pick_up_weight,
1107: pick_up_volume = l_pick_up_volume
1108: where stop_id = p_entity_id;
1109: ELSIF NVL(l_frozen_flag, 'N') = 'N' THEN

Line 1117: last_updated_by = FND_GLOBAL.user_id,

1113: departure_net_weight = l_net_weight,
1114: departure_volume = l_volume,
1115: departure_fill_percent = l_fill_percent,
1116: last_update_date = SYSDATE,
1117: last_updated_by = FND_GLOBAL.user_id,
1118: last_update_login = FND_GLOBAL.login_id,
1119: pick_up_weight = l_pick_up_weight,
1120: pick_up_volume = l_pick_up_volume
1121: where stop_id = p_entity_id;

Line 1118: last_update_login = FND_GLOBAL.login_id,

1114: departure_volume = l_volume,
1115: departure_fill_percent = l_fill_percent,
1116: last_update_date = SYSDATE,
1117: last_updated_by = FND_GLOBAL.user_id,
1118: last_update_login = FND_GLOBAL.login_id,
1119: pick_up_weight = l_pick_up_weight,
1120: pick_up_volume = l_pick_up_volume
1121: where stop_id = p_entity_id;
1122: ELSE

Line 1129: last_updated_by = FND_GLOBAL.user_id,

1125: departure_net_weight = l_net_weight,
1126: departure_volume = l_volume,
1127: departure_fill_percent = l_fill_percent,
1128: last_update_date = SYSDATE,
1129: last_updated_by = FND_GLOBAL.user_id,
1130: last_update_login = FND_GLOBAL.login_id
1131: where stop_id = p_entity_id;
1132: END IF;
1133: END IF;

Line 1130: last_update_login = FND_GLOBAL.login_id

1126: departure_volume = l_volume,
1127: departure_fill_percent = l_fill_percent,
1128: last_update_date = SYSDATE,
1129: last_updated_by = FND_GLOBAL.user_id,
1130: last_update_login = FND_GLOBAL.login_id
1131: where stop_id = p_entity_id;
1132: END IF;
1133: END IF;
1134:

Line 1234: last_updated_by = FND_GLOBAL.user_id,

1230: set gross_weight = l_gross_weight,
1231: net_weight = l_net_weight,
1232: volume = l_volume,
1233: last_update_date = SYSDATE,
1234: last_updated_by = FND_GLOBAL.user_id,
1235: last_update_login = FND_GLOBAL.login_id
1236: where delivery_id = p_entity_id;
1237:
1238: -- Call Adjust_parent_WV recursively to adjust W/V on parent stops, if any

Line 1235: last_update_login = FND_GLOBAL.login_id

1231: net_weight = l_net_weight,
1232: volume = l_volume,
1233: last_update_date = SYSDATE,
1234: last_updated_by = FND_GLOBAL.user_id,
1235: last_update_login = FND_GLOBAL.login_id
1236: where delivery_id = p_entity_id;
1237:
1238: -- Call Adjust_parent_WV recursively to adjust W/V on parent stops, if any
1239: --

Line 1946: last_updated_by = FND_GLOBAL.user_id,

1942: net_weight = null,
1943: volume = null,
1944: wv_frozen_flag = 'N',
1945: last_update_date = SYSDATE,
1946: last_updated_by = FND_GLOBAL.user_id,
1947: last_update_login = FND_GLOBAL.login_id
1948: WHERE delivery_id = l_delivery_id;
1949:
1950: CLOSE C5;

Line 1947: last_update_login = FND_GLOBAL.login_id

1943: volume = null,
1944: wv_frozen_flag = 'N',
1945: last_update_date = SYSDATE,
1946: last_updated_by = FND_GLOBAL.user_id,
1947: last_update_login = FND_GLOBAL.login_id
1948: WHERE delivery_id = l_delivery_id;
1949:
1950: CLOSE C5;
1951:

Line 2251: last_updated_by = FND_GLOBAL.user_id,

2247: departure_volume = null,
2248: departure_fill_percent = null,
2249: wv_frozen_flag = 'N',
2250: last_update_date = SYSDATE,
2251: last_updated_by = FND_GLOBAL.user_id,
2252: last_update_login = FND_GLOBAL.login_id,
2253: pick_up_weight = null,
2254: pick_up_volume = null,
2255: drop_off_weight = null,

Line 2252: last_update_login = FND_GLOBAL.login_id,

2248: departure_fill_percent = null,
2249: wv_frozen_flag = 'N',
2250: last_update_date = SYSDATE,
2251: last_updated_by = FND_GLOBAL.user_id,
2252: last_update_login = FND_GLOBAL.login_id,
2253: pick_up_weight = null,
2254: pick_up_volume = null,
2255: drop_off_weight = null,
2256: drop_off_volume = null

Line 2747: last_updated_by = FND_GLOBAL.user_id,

2743: unit_weight = NVL(unit_weight,decode(p_unit_weight,-99,NULL,p_unit_weight)),
2744: unit_volume = NVL(unit_volume,decode(p_unit_volume,-99,NULL,p_unit_volume)),
2745: wv_frozen_flag = 'N',
2746: last_update_date = SYSDATE,
2747: last_updated_by = FND_GLOBAL.user_id,
2748: last_update_login = FND_GLOBAL.login_id
2749: WHERE delivery_detail_id = p_container_instance_id;
2750:
2751: IF SQL%NOTFOUND THEN

Line 2748: last_update_login = FND_GLOBAL.login_id

2744: unit_volume = NVL(unit_volume,decode(p_unit_volume,-99,NULL,p_unit_volume)),
2745: wv_frozen_flag = 'N',
2746: last_update_date = SYSDATE,
2747: last_updated_by = FND_GLOBAL.user_id,
2748: last_update_login = FND_GLOBAL.login_id
2749: WHERE delivery_detail_id = p_container_instance_id;
2750:
2751: IF SQL%NOTFOUND THEN
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3303: last_updated_by = FND_GLOBAL.user_id,

3299: unit_weight = NVL(unit_weight,childInfo_rec.unit_weight),
3300: unit_volume = NVL(unit_volume,childInfo_rec.unit_volume),
3301: wv_frozen_flag = 'N',
3302: last_update_date = SYSDATE,
3303: last_updated_by = FND_GLOBAL.user_id,
3304: last_update_login = FND_GLOBAL.login_id
3305: WHERE delivery_detail_id = childInfo_rec.delivery_detail_id;
3306: --
3307: --

Line 3304: last_update_login = FND_GLOBAL.login_id

3300: unit_volume = NVL(unit_volume,childInfo_rec.unit_volume),
3301: wv_frozen_flag = 'N',
3302: last_update_date = SYSDATE,
3303: last_updated_by = FND_GLOBAL.user_id,
3304: last_update_login = FND_GLOBAL.login_id
3305: WHERE delivery_detail_id = childInfo_rec.delivery_detail_id;
3306: --
3307: --
3308: IF SQL%NOTFOUND OR SQL%ROWCOUNT = 0

Line 5696: last_updated_by = FND_GLOBAL.user_id,

5692: gross_weight = x_gross_weight,
5693: volume = x_volume,
5694: wv_frozen_flag = 'N',
5695: last_update_date = SYSDATE,
5696: last_updated_by = FND_GLOBAL.user_id,
5697: last_update_login = FND_GLOBAL.login_id
5698: WHERE delivery_id = p_delivery_id;
5699:
5700: IF (SQL%NOTFOUND) THEN

Line 5697: last_update_login = FND_GLOBAL.login_id

5693: volume = x_volume,
5694: wv_frozen_flag = 'N',
5695: last_update_date = SYSDATE,
5696: last_updated_by = FND_GLOBAL.user_id,
5697: last_update_login = FND_GLOBAL.login_id
5698: WHERE delivery_id = p_delivery_id;
5699:
5700: IF (SQL%NOTFOUND) THEN
5701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 6902: last_updated_by = FND_GLOBAL.user_id,

6898: SET gross_weight = l_dd_upd_gross_wt_tbl(i),
6899: net_weight = l_dd_upd_net_wt_tbl(i),
6900: wv_frozen_flag = 'Y',
6901: last_update_date = SYSDATE,
6902: last_updated_by = FND_GLOBAL.user_id,
6903: last_update_login = FND_GLOBAL.login_id
6904: WHERE delivery_detail_id = l_dd_upd_tbl(i);
6905:
6906: -- Make the recursive call to prorate the weights further down.

Line 6903: last_update_login = FND_GLOBAL.login_id

6899: net_weight = l_dd_upd_net_wt_tbl(i),
6900: wv_frozen_flag = 'Y',
6901: last_update_date = SYSDATE,
6902: last_updated_by = FND_GLOBAL.user_id,
6903: last_update_login = FND_GLOBAL.login_id
6904: WHERE delivery_detail_id = l_dd_upd_tbl(i);
6905:
6906: -- Make the recursive call to prorate the weights further down.
6907: IF l_lpn_tab.COUNT > 0 THEN