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