APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_DELIVERY_LEGS

Line 2566: UPDATE wsh_delivery_legs

2562: END IF;
2563:
2564: /*
2565: FORALL I IN l_dlvy_tbl.first..l_dlvy_tbl.last
2566: UPDATE wsh_delivery_legs
2567: SET reprice_required = 'Y',
2568: last_update_date = sysdate,
2569: last_updated_by = fnd_global.user_id,
2570: last_update_login = fnd_global.login_id

Line 3396: wsh_delivery_legs wdl,

3392: wda.parent_delivery_detail_id, wda.delivery_id, wts.stop_id
3393: FROM wsh_delivery_assignments wda,
3394: wsh_delivery_details wdd,
3395: wsh_new_deliveries wnd,
3396: wsh_delivery_legs wdl,
3397: wsh_trip_stops wts
3398: WHERE wts.stop_id (+) = wdl.drop_off_stop_id
3399: AND wdl.delivery_id (+) = wnd.delivery_id
3400: AND nvl(wnd.status_code, 'OP') = 'OP'

Line 3478: FROM wsh_delivery_legs wdl,

3474:
3475: CURSOR get_unassign_stops ( c_to_location_id NUMBER) IS
3476: SELECT wdl.rowid, tmp.rowid, wnd.delivery_id, wdl.delivery_leg_id, wts.trip_id,
3477: wts.stop_id, wnd.gross_weight, wnd.net_weight, wnd.volume
3478: FROM wsh_delivery_legs wdl,
3479: wsh_new_deliveries wnd,
3480: Wsh_trip_stops wts,
3481: wsh_tmp tmp
3482: WHERE wnd.ultimate_dropoff_location_id = c_to_location_id

Line 3489: wsh_delivery_legs legs

3485: AND wnd.delivery_id = tmp.column1
3486: AND EXISTS
3487: ( SELECT 'x'
3488: FROM wsh_new_deliveries del,
3489: wsh_delivery_legs legs
3490: WHERE del.ultimate_dropoff_location_id <> c_to_location_id
3491: AND del.delivery_id = legs.delivery_id
3492: AND legs.drop_off_stop_id = wdl.drop_off_stop_id );
3493:

Line 4271: DELETE FROM wsh_delivery_legs

4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.log(l_module_name, 'l_wdl_rowid.count', l_wdl_rowid.count);
4269: END IF;
4270: FORALL I IN l_wdl_rowid.FIRST..l_wdl_rowid.LAST
4271: DELETE FROM wsh_delivery_legs
4272: WHERE ROWID = l_wdl_rowid(i);
4273:
4274: l_sql_count := SQL%rowcount;
4275: IF l_debug_on THEN

Line 4276: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_delivery_legs. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

4272: WHERE ROWID = l_wdl_rowid(i);
4273:
4274: l_sql_count := SQL%rowcount;
4275: IF l_debug_on THEN
4276: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_delivery_legs. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4277: END IF;
4278:
4279: FORALL I IN l_tmp_rowid.FIRST..l_tmp_rowid.LAST
4280: DELETE FROM wsh_tmp