717: x_exception_id => l_dummy_exception_id ,
718: p_logged_at_location_id => l_pickup_location_id,
719: p_exception_location_id => l_pickup_location_id,
720: p_logging_entity => 'SHIPPER',
721: p_logging_entity_id => FND_GLOBAL.USER_ID,
722: p_exception_name => l_exception_name,
723: p_message => l_msg,
724: p_trip_id => p_trip_id
725: );
1098: set planned_departure_date=least(nvl(l_pickup_date,sysdate),planned_departure_date),
1099: planned_arrival_date=least(nvl(l_pickup_date,sysdate),planned_arrival_date),
1100: shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1101: last_update_date = SYSDATE, -- J-IB-NPARIKH
1102: last_updated_by = FND_GLOBAL.USER_ID, -- J-IB-NPARIKH
1103: last_update_login = FND_GLOBAL.LOGIN_ID -- J-IB-NPARIKH
1104: where stop_id=l_pickup_stop_id;
1105:
1106: --
1099: planned_arrival_date=least(nvl(l_pickup_date,sysdate),planned_arrival_date),
1100: shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1101: last_update_date = SYSDATE, -- J-IB-NPARIKH
1102: last_updated_by = FND_GLOBAL.USER_ID, -- J-IB-NPARIKH
1103: last_update_login = FND_GLOBAL.LOGIN_ID -- J-IB-NPARIKH
1104: where stop_id=l_pickup_stop_id;
1105:
1106: --
1107: -- DBI Project
1518: /* End of H integration - call Multi Leg FTE */
1519: update wsh_trip_stops
1520: set shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1521: last_update_date = SYSDATE,
1522: last_updated_by = FND_GLOBAL.USER_ID,
1523: last_update_login = FND_GLOBAL.LOGIN_ID
1524: where stop_id=l_dropoff_stop_id;
1525: END IF;
1526:
1519: update wsh_trip_stops
1520: set shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1521: last_update_date = SYSDATE,
1522: last_updated_by = FND_GLOBAL.USER_ID,
1523: last_update_login = FND_GLOBAL.LOGIN_ID
1524: where stop_id=l_dropoff_stop_id;
1525: END IF;
1526:
1527: END IF;
1792: update wsh_trip_stops
1793: set planned_departure_date=p_pickup_dep_date,
1794: planned_arrival_date=p_pickup_arr_date,
1795: last_update_date = SYSDATE,
1796: last_updated_by = FND_GLOBAL.USER_ID,
1797: last_update_login = FND_GLOBAL.LOGIN_ID
1798: where stop_id=p_pickup_stop_id;
1799:
1800: --
1793: set planned_departure_date=p_pickup_dep_date,
1794: planned_arrival_date=p_pickup_arr_date,
1795: last_update_date = SYSDATE,
1796: last_updated_by = FND_GLOBAL.USER_ID,
1797: last_update_login = FND_GLOBAL.LOGIN_ID
1798: where stop_id=p_pickup_stop_id;
1799:
1800: --
1801: -- DBI Project
1869: update wsh_trip_stops
1870: set planned_departure_date=p_dropoff_dep_date,
1871: planned_arrival_date=p_dropoff_arr_date,
1872: last_update_date = SYSDATE,
1873: last_updated_by = FND_GLOBAL.USER_ID,
1874: last_update_login = FND_GLOBAL.LOGIN_ID
1875: where stop_id=p_dropoff_stop_id;
1876:
1877: --
1870: set planned_departure_date=p_dropoff_dep_date,
1871: planned_arrival_date=p_dropoff_arr_date,
1872: last_update_date = SYSDATE,
1873: last_updated_by = FND_GLOBAL.USER_ID,
1874: last_update_login = FND_GLOBAL.LOGIN_ID
1875: where stop_id=p_dropoff_stop_id;
1876:
1877: --
1878: -- DBI Project
2086: /* End of H integration - call Multi Leg FTE */
2087: update wsh_trip_stops
2088: set shipments_type_flag = l_pu_stop_shipments_type_flag, -- J-IB-NPARIKH
2089: last_update_date = SYSDATE,
2090: last_updated_by = FND_GLOBAL.USER_ID,
2091: last_update_login = FND_GLOBAL.LOGIN_ID
2092: where stop_id=l_pickup_stop_id;
2093: --}
2094: END IF;
2087: update wsh_trip_stops
2088: set shipments_type_flag = l_pu_stop_shipments_type_flag, -- J-IB-NPARIKH
2089: last_update_date = SYSDATE,
2090: last_updated_by = FND_GLOBAL.USER_ID,
2091: last_update_login = FND_GLOBAL.LOGIN_ID
2092: where stop_id=l_pickup_stop_id;
2093: --}
2094: END IF;
2095: --
2170: /* End of H integration - call Multi Leg FTE */
2171: update wsh_trip_stops
2172: set shipments_type_flag = l_do_stop_shipments_type_flag, -- J-IB-NPARIKH
2173: last_update_date = SYSDATE,
2174: last_updated_by = FND_GLOBAL.USER_ID,
2175: last_update_login = FND_GLOBAL.LOGIN_ID
2176: where stop_id=l_dropoff_stop_id;
2177: --}
2178: END IF;
2171: update wsh_trip_stops
2172: set shipments_type_flag = l_do_stop_shipments_type_flag, -- J-IB-NPARIKH
2173: last_update_date = SYSDATE,
2174: last_updated_by = FND_GLOBAL.USER_ID,
2175: last_update_login = FND_GLOBAL.LOGIN_ID
2176: where stop_id=l_dropoff_stop_id;
2177: --}
2178: END IF;
2179: --
2230: THEN
2231: UPDATE WSH_TRIPS
2232: SET shipments_type_flag = l_trip_shipments_type_flag_new, -- 'M',
2233: last_update_date = SYSDATE,
2234: last_updated_by = FND_GLOBAL.USER_ID,
2235: last_update_login = FND_GLOBAL.LOGIN_ID
2236: WHERE trip_id = p_trip_id;
2237:
2238: IF (l_trip_shipments_type_flag_new <> 'M') THEN
2231: UPDATE WSH_TRIPS
2232: SET shipments_type_flag = l_trip_shipments_type_flag_new, -- 'M',
2233: last_update_date = SYSDATE,
2234: last_updated_by = FND_GLOBAL.USER_ID,
2235: last_update_login = FND_GLOBAL.LOGIN_ID
2236: WHERE trip_id = p_trip_id;
2237:
2238: IF (l_trip_shipments_type_flag_new <> 'M') THEN
2239:
2239:
2240: UPDATE WSH_TRIP_STOPS
2241: SET shipments_type_flag = l_trip_shipments_type_flag_new,
2242: last_update_date = SYSDATE,
2243: last_updated_by = FND_GLOBAL.USER_ID,
2244: last_update_login = FND_GLOBAL.LOGIN_ID
2245: WHERE trip_id = p_trip_id
2246: and shipments_type_flag <> l_trip_shipments_type_flag_new;
2247:
2240: UPDATE WSH_TRIP_STOPS
2241: SET shipments_type_flag = l_trip_shipments_type_flag_new,
2242: last_update_date = SYSDATE,
2243: last_updated_by = FND_GLOBAL.USER_ID,
2244: last_update_login = FND_GLOBAL.LOGIN_ID
2245: WHERE trip_id = p_trip_id
2246: and shipments_type_flag <> l_trip_shipments_type_flag_new;
2247:
2248: IF l_debug_on THEN
3221:
3222: UPDATE wsh_new_deliveries
3223: SET loading_sequence = NULL,
3224: last_update_date = SYSDATE,
3225: last_updated_by = FND_GLOBAL.USER_ID,
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
3222: UPDATE wsh_new_deliveries
3223: SET loading_sequence = NULL,
3224: last_update_date = SYSDATE,
3225: last_updated_by = FND_GLOBAL.USER_ID,
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
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
3235: WHERE delivery_detail_id = l_del_det_tab(i);
3236:
3237: END IF;
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
3235: WHERE delivery_detail_id = l_del_det_tab(i);
3236:
3237: END IF;
3238: