[Home] [Help]
1234: Wnd.Volume, Wdl.Rowid, Tmp.Rowid,
1235: NVL(Wnd.ignore_for_planning, 'N') --OTM R12
1236: FROM Wsh_New_Deliveries Wnd,
1237: Wsh_Delivery_Legs Wdl,
1238: Wsh_Trip_Stops Wts,
1239: Wsh_Tmp Tmp
1240: WHERE Wnd.Ultimate_Dropoff_Location_Id = p_location_id
1241: AND Wts.Stop_Id = Wdl.Drop_Off_Stop_Id
1242: AND Wnd.Delivery_Id = Wdl.Delivery_Id
1256: -- these deliveries will be set to AW
1257: CURSOR c_get_deliveries (p_trip_id IN NUMBER,p_exclude_dlvy IN NUMBER) IS
1258: SELECT wdl.delivery_id
1259: FROM wsh_delivery_legs wdl,
1260: wsh_trip_stops wts,
1261: wsh_new_deliveries wnd
1262: WHERE wdl.pick_up_stop_id = wts.stop_id
1263: AND wts.trip_id = p_trip_id
1264: AND wdl.delivery_id = wnd.delivery_id
2063: WHERE column1 = l_dlvy_id_tab(delCnt);
2064: END IF;
2065: -- End of OTM R12 : customer merge
2066:
2067: UPDATE WSH_TRIP_STOPS Wts
2068: SET stop_location_id = G_TO_LOCATION_ID,
2069: last_update_date = SYSDATE,
2070: last_updated_by = arp_standard.profile.user_id,
2071: last_update_login = arp_standard.profile.last_update_login,
2079: WHERE Column2 IS NOT NULL )
2080: RETURNING Wts.Stop_Id BULK COLLECT INTO l_stopIdTab;
2081:
2082: --
2083: setARMessageRowCount( 'WSH_TRIP_STOPS', SQL%ROWCOUNT );
2084:
2085: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
2086: THEN
2087: l_return_status := NULL;
2087: l_return_status := NULL;
2088:
2089: Insert_Log_Table (
2090: p_id_tab => l_stopIdTab,
2091: p_table_name => 'WSH_TRIP_STOPS',
2092: p_req_id => p_req_id,
2093: x_return_status => l_return_status );
2094:
2095: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2314: program_update_date = SYSDATE
2315: WHERE Rowid = l_deliveryRowidTab(updCnt);
2316:
2317: --
2318: setARMessageRowCount( 'WSH_TRIP_STOPS', SQL%ROWCOUNT );
2319:
2320: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
2321: THEN
2322: l_return_status := NULL;
2377: program_update_date = SYSDATE
2378: WHERE Rowid = l_deliveryRowidTab(updCnt);
2379:
2380: --
2381: setARMessageRowCount( 'WSH_TRIP_STOPS', SQL%ROWCOUNT );
2382:
2383: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
2384: THEN
2385: l_return_status := NULL;
2503: FROM Wsh_Delivery_Details WDD,
2504: Wsh_Delivery_Assignments WDA,
2505: Wsh_New_Deliveries WND,
2506: Wsh_Delivery_Legs WDL,
2507: Wsh_Trip_Stops WTS
2508: WHERE WTS.Stop_id (+) = WDL.Drop_Off_Stop_Id
2509: AND WDL.Delivery_Id (+) = WND.Delivery_Id
2510: AND NVL(WND.Status_Code, 'OP') = 'OP'
2511: AND WND.Delivery_Id (+) = WDA.Delivery_Id