DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 3204: wsh_delivery_details wdd

3200:
3201: CURSOR c_lock_delivery_details (c_delivery_id IN number) IS
3202: SELECT wdd.delivery_detail_id
3203: FROM wsh_delivery_assignments wda,
3204: wsh_delivery_details wdd
3205: WHERE wda.delivery_id = c_delivery_id
3206: AND wda.delivery_detail_id = wdd.delivery_detail_id
3207: FOR UPDATE OF wdd.load_seq_number NOWAIT;
3208:

Line 3230: UPDATE wsh_delivery_details

3226: last_update_login = FND_GLOBAL.LOGIN_ID
3227: WHERE delivery_id = p_del_rows(i);
3228:
3229: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3230: UPDATE wsh_delivery_details
3231: SET load_seq_number = NULL,
3232: last_update_date = SYSDATE,
3233: last_updated_by = FND_GLOBAL.USER_ID,
3234: last_update_login = FND_GLOBAL.LOGIN_ID