eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CUST_MERGE dependencies on WSH_NEW_DELIVERIES

Line 555: Wsh_New_Deliveries Dlvy

551: SELECT Det.Delivery_Detail_Id, Det.Rowid,
552: Dlvy.Customer_Id
553: FROM Wsh_Delivery_Details Det,
554: Wsh_Delivery_Assignments DelAsgn,
555: Wsh_New_Deliveries Dlvy
556: WHERE Dlvy.Delivery_Id = DelAsgn.Delivery_Id
557: AND DelAsgn.Delivery_Detail_Id = Det.Delivery_Detail_Id
558: AND Det.Container_Flag = 'Y'
559: AND Det.Delivery_Detail_Id IN

Line 568: WSH_NEW_DELIVERIES Wnd,

564: START WITH Asgn.delivery_detail_id IN
565: ( SELECT Wdd.Delivery_Detail_Id
566: FROM WSH_DELIVERY_DETAILS Wdd,
567: WSH_DELIVERY_ASSIGNMENTS Wda,
568: WSH_NEW_DELIVERIES Wnd,
569: Wsh_Tmp Tmp
570: WHERE Wdd.Container_Flag = 'N'
571: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )
572: AND Wdd.Customer_id = p_customer_id

Line 607: WSH_NEW_DELIVERIES Wnd,

603: Wdd.Move_Order_Line_Id, Wdd.Released_Status,
604: Wnd.Ignore_For_Planning -- OTM R12 : unassign delivery detail
605: FROM WSH_DELIVERY_DETAILS Wdd,
606: WSH_DELIVERY_ASSIGNMENTS Wda,
607: WSH_NEW_DELIVERIES Wnd,
608: Wsh_Freight_Costs Wfc,
609: Wsh_Tmp Tmp
610: WHERE Wdd.Container_Flag = 'N'
611: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )

Line 838: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

834: raise FND_API.G_EXC_ERROR;
835: ELSIF (l_is_delivery_empty = 'Y') THEN
836: l_count := l_count + 1;
837: l_delivery_id_tab(l_count) := l_deliveryIdTab(l_index);
838: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
839: IF (l_debug_on) THEN
840: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));
841: END IF;
842: ELSIF (l_is_delivery_empty = 'N') THEN

Line 862: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

858: l_index := l_deliveryIdTab.NEXT(l_index);
859: END LOOP;
860:
861: IF l_count > 0 THEN
862: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
863: p_delivery_id_tab => l_delivery_id_tab,
864: p_tms_interface_flag_tab => l_interface_flag_tab,
865: x_return_status => l_return_status);
866:

Line 870: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

866:
867: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
868: --
869: IF l_debug_on THEN
870: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
871: END IF;
872: RAISE Unassign_Del_Exp;
873: END IF;
874: END IF;

Line 1239: FROM Wsh_New_Deliveries Wnd,

1235: SELECT Wdl.Delivery_Id, Wdl.Drop_Off_Stop_Id, Wts.Trip_Id,
1236: Wdl.Delivery_Leg_Id, Wnd.Gross_Weight, Wnd.Net_Weight,
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

Line 1249: FROM Wsh_New_Deliveries Del,

1245: AND Wnd.Delivery_Id = Wdl.Delivery_Id
1246: AND Wdl.Delivery_Id = Tmp.Column1
1247: AND exists (
1248: SELECT 'x'
1249: FROM Wsh_New_Deliveries Del,
1250: Wsh_Delivery_Legs Legs
1251: WHERE Del.Ultimate_Dropoff_Location_Id <> p_location_id
1252: AND Del.Delivery_Id = Legs.Delivery_Id
1253: AND Legs.Drop_Off_Stop_Id = Wdl.Drop_Off_Stop_Id

Line 1264: wsh_new_deliveries wnd

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
1268: AND wnd.status_code = 'OP'

Line 1269: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED

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
1268: AND wnd.status_code = 'OP'
1269: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED
1270: AND wnd.delivery_id <> p_exclude_dlvy;
1271:
1272: -- getting empty deliveries that belongs to the customer and matches the drop
1273: -- off location id

Line 1276: FROM wsh_new_deliveries wnd

1272: -- getting empty deliveries that belongs to the customer and matches the drop
1273: -- off location id
1274: CURSOR c_get_empty_deliveries(p_customer_id IN NUMBER, p_dropoff_location_id IN NUMBER) IS
1275: SELECT wnd.delivery_id
1276: FROM wsh_new_deliveries wnd
1277: WHERE NVL(wnd.Customer_Id, p_customer_id) = p_customer_id
1278: AND wnd.ultimate_dropoff_location_Id = p_dropoff_location_id
1279: AND wnd.status_code = 'OP'
1280: AND NOT EXISTS

Line 1308: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1304: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1305: l_gc3_is_installed VARCHAR2(1);
1306:
1307: frcost_not_found EXCEPTION;
1308: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1309: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;
1310: l_new_delivery_leg_tab g_rowid_tbl_type;
1311: l_delivery_leg_count NUMBER;
1312: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1315:
1316: -- End of OTM R12 : customer merge
1317:
1318: -- OTM R12 : update delivery
1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1321: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1323: l_trip_not_found VARCHAR2(1);

Line 1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

1316: -- End of OTM R12 : customer merge
1317:
1318: -- OTM R12 : update delivery
1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1321: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1322: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1323: l_trip_not_found VARCHAR2(1);
1324: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

1552: = nvl(G_FROM_LOCATION_ID, -1) AND
1553: nvl(l_delivery_info.ultimate_dropoff_location_id, -1)
1554: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1555: IF (l_delivery_info.tms_interface_flag NOT IN
1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

1553: nvl(l_delivery_info.ultimate_dropoff_location_id, -1)
1554: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1555: IF (l_delivery_info.tms_interface_flag NOT IN
1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1561: l_tms_update(l_index) := 'Y';

Line 1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

1554: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1555: IF (l_delivery_info.tms_interface_flag NOT IN
1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1561: l_tms_update(l_index) := 'Y';
1562: l_delivery_count := l_delivery_count + 1;

Line 1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

1555: IF (l_delivery_info.tms_interface_flag NOT IN
1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1561: l_tms_update(l_index) := 'Y';
1562: l_delivery_count := l_delivery_count + 1;
1563: l_delivery_info_tab(l_delivery_count) := l_delivery_info;

Line 1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1561: l_tms_update(l_index) := 'Y';
1562: l_delivery_count := l_delivery_count + 1;
1563: l_delivery_info_tab(l_delivery_count) := l_delivery_info;
1564: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 1564: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1561: l_tms_update(l_index) := 'Y';
1562: l_delivery_count := l_delivery_count + 1;
1563: l_delivery_info_tab(l_delivery_count) := l_delivery_info;
1564: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1565: l_tms_version_number(l_index) := nvl(l_delivery_info.tms_version_number, 1) + 1;
1566: l_tms_interface_flag(l_index) := l_new_interface_flag_tab(l_delivery_count);
1567: END IF;
1568: END IF; -- checking the value differences

Line 1587: UPDATE WSH_NEW_DELIVERIES Wnd

1583: END IF; -- if GC3 is installed
1584: -- End of OTM R12 : update delivery
1585:
1586: FORALL updCnt IN l_hash_value_tab.FIRST..l_hash_value_tab.LAST
1587: UPDATE WSH_NEW_DELIVERIES Wnd
1588: SET Hash_Value = nvl(l_hash_value_tab(updCnt), Hash_Value),
1589: Hash_String = nvl(l_hash_string_tab(updCnt), Hash_String),
1590: customer_id = decode(customer_id,
1591: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,

Line 1606: nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

1602: program_update_date = SYSDATE,
1603: -- OTM R12 : update delivery
1604: TMS_INTERFACE_FLAG = decode(l_tms_update(updCnt), 'Y',
1605: l_tms_interface_flag(updCnt),
1606: nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
1607: TMS_VERSION_NUMBER = decode(l_tms_update(updCnt), 'Y',
1608: l_tms_version_number(updCnt),
1609: nvl(TMS_VERSION_NUMBER, 1))
1610: -- End of OTM R12 : update delivery

Line 1629: setARMessageRowCount( 'WSH_NEW_DELIVERIES', SQL%ROWCOUNT );

1625: END IF;
1626: -- End of OTM R12 : update delivery
1627:
1628: --
1629: setARMessageRowCount( 'WSH_NEW_DELIVERIES', SQL%ROWCOUNT );
1630:
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.log('my module', 'rows updated', l_deliveryIdTab.COUNT);
1633: WSH_DEBUG_SV.log('my module', 'rows suppose to update', l_hash_value_tab.COUNT);

Line 1643: p_table_name => 'WSH_NEW_DELIVERIES',

1639: l_return_status := NULL;
1640:
1641: Insert_Log_Table (
1642: p_id_tab => l_deliveryIdTab,
1643: p_table_name => 'WSH_NEW_DELIVERIES',
1644: p_req_id => p_req_id,
1645: x_return_status => l_return_status );
1646:
1647: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

1875: -- Include DR to count empty deliveries that are assigned
1876: -- to trip, they should be unassigned + the drop off location should be updated
1877: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1878: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

Line 1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

1876: -- to trip, they should be unassigned + the drop off location should be updated
1877: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1878: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

Line 1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

1877: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1878: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1885: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND

Line 1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

1878: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1885: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1886: l_tms_trip_tab(l_index).status_code = 'OP') THEN

Line 1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1885: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1886: l_tms_trip_tab(l_index).status_code = 'OP') THEN
1887:

Line 1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1885: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1886: l_tms_trip_tab(l_index).status_code = 'OP') THEN
1887:
1888: -- it is already assigned to a trip,

Line 1903: l_aw_interface_flag_tab(l_aw_interface_flag_tab.count + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;

1899: -- with the trip
1900:
1901: FOR rec in c_get_deliveries(l_tms_trip_tab(l_index).trip_id, l_tms_delivery_info_tab(l_index).delivery_id) LOOP
1902: l_aw_dlvy_tab(l_aw_dlvy_tab.count + 1) := rec.delivery_id;
1903: l_aw_interface_flag_tab(l_aw_interface_flag_tab.count + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
1904: END LOOP;
1905:
1906: IF l_debug_on THEN
1907: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);

Line 1925: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

1921: -- Log appropriate exceptions(within the API)
1922: -- Need to update the version number also
1923: IF l_aw_dlvy_tab.count > 0 THEN
1924: -- Call Update after the above LOOP
1925: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
1926: p_delivery_id_tab => l_aw_dlvy_tab,
1927: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1928: x_return_status => l_return_status);
1929: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 1931: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

1927: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1928: x_return_status => l_return_status);
1929: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1930: IF l_debug_on THEN
1931: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
1932: END IF;
1933: RAISE Update_Del_Exp;
1934: END IF;
1935: END IF;

Line 2210: FROM Wsh_New_Deliveries WND

2206: p_customer_id NUMBER,
2207: p_location_id NUMBER )
2208: IS
2209: SELECT Wnd.Delivery_Id, Wnd.Rowid
2210: FROM Wsh_New_Deliveries WND
2211: WHERE nvl(Wnd.Customer_Id, p_customer_id) = p_customer_id
2212: AND Wnd.Ultimate_Dropoff_Location_Id = p_location_id
2213: AND Wnd.Status_Code = 'OP'
2214: AND NOT EXISTS

Line 2228: Wsh_New_Deliveries Dlvy

2224: SELECT Det.Delivery_Detail_Id, Dlvy.Delivery_Id,
2225: Det.Rowid, Dlvy.Rowid
2226: FROM Wsh_Delivery_Details Det,
2227: Wsh_Delivery_Assignments Asg,
2228: Wsh_New_Deliveries Dlvy
2229: WHERE Det.Delivery_Detail_Id = Asg.Delivery_Detail_Id
2230: AND Asg.Delivery_Id = Dlvy.Delivery_Id
2231: AND Dlvy.Delivery_Id in
2232: ( SELECT Wnd.Delivery_Id

Line 2235: Wsh_New_Deliveries Wnd

2231: AND Dlvy.Delivery_Id in
2232: ( SELECT Wnd.Delivery_Id
2233: FROM Wsh_Delivery_Details Wdd,
2234: Wsh_Delivery_Assignments Wda,
2235: Wsh_New_Deliveries Wnd
2236: WHERE Wdd.Container_Flag = 'Y'
2237: AND Wdd.Delivery_Detail_Id = Wda.Delivery_Detail_id
2238: AND Wda.Delivery_Id = Wnd.Delivery_Id
2239: AND nvl(Wnd.Customer_Id, p_customer_id) = p_customer_id

Line 2304: UPDATE Wsh_New_Deliveries

2300: -- since the deliveries selected by cursor Get_Empty_Deliveries are
2301: -- empty deliveries
2302:
2303: FORALL updCnt in l_deliveryRowidTab.FIRST..l_deliveryRowidTab.LAST
2304: UPDATE Wsh_New_Deliveries
2305: SET customer_id = decode(customer_id,
2306: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,
2307: customer_id),
2308: ultimate_dropoff_location_id = decode(ultimate_dropoff_location_id,

Line 2329: p_table_name => 'WSH_NEW_DELIVERIES',

2325: l_return_status := NULL;
2326:
2327: Insert_Log_Table (
2328: p_id_tab => l_deliveryIdTab,
2329: p_table_name => 'WSH_NEW_DELIVERIES',
2330: p_req_id => p_req_id,
2331: x_return_status => l_return_status );
2332:
2333: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 2367: UPDATE Wsh_New_Deliveries

2363: -- since the deliveries selected by cursor Get_Empty_Cont_Delivery are
2364: -- empty deliveries
2365:
2366: FORALL updCnt in l_deliveryRowidTab.FIRST..l_deliveryRowidTab.LAST
2367: UPDATE Wsh_New_Deliveries
2368: SET customer_id = decode(customer_id,
2369: G_FROM_CUSTOMER_ID, G_TO_CUSTOMER_ID,
2370: customer_id),
2371: ultimate_dropoff_location_id = decode(ultimate_dropoff_location_id,

Line 2392: p_table_name => 'WSH_NEW_DELIVERIES',

2388: l_return_status := NULL;
2389:
2390: Insert_Log_Table (
2391: p_id_tab => l_deliveryIdTab,
2392: p_table_name => 'WSH_NEW_DELIVERIES',
2393: p_req_id => p_req_id,
2394: x_return_status => l_return_status );
2395:
2396: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 2508: Wsh_New_Deliveries WND,

2504: Wdd.Inventory_Item_Id, Wdd.Organization_Id,
2505: WDD.Rowid, WDA.Rowid
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

Line 2804: FROM Wsh_New_Deliveries

2800: --Start of fix for bug 5900667
2801: --Populate details of delivery/stop into table only if location matches.
2802: AND EXISTS
2803: ( SELECT 'x'
2804: FROM Wsh_New_Deliveries
2805: WHERE ultimate_dropoff_location_id = G_FROM_LOCATION_ID
2806: AND delivery_id = l_deliveryIdTab(insCnt) )
2807: --End of fix for bug 5900667
2808: AND NOT EXISTS

Line 2930: Wsh_New_Deliveries WND

2926: START WITH wda.delivery_detail_id IN
2927: ( SELECT WDD.Delivery_Detail_Id
2928: FROM Wsh_Delivery_Details WDD,
2929: Wsh_Delivery_Assignments WDA,
2930: Wsh_New_Deliveries WND
2931: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2932: -- Added Parent_Delivery_Detail_Id for Perf. improvement,
2933: -- as per perf. team suggestion.
2934: AND Wda.Parent_Delivery_Detail_Id IS NOT NULL

Line 2955: Wsh_New_Deliveries WND

2951: IS
2952: SELECT Wdd.Delivery_Detail_Id, Wdd.Rowid
2953: FROM Wsh_Delivery_Details WDD,
2954: Wsh_Delivery_Assignments WDA,
2955: Wsh_New_Deliveries WND
2956: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2957: AND Wnd.Delivery_Id = Wda.Delivery_Id
2958: AND Wda.Delivery_Detail_Id = Wdd.Delivery_Detail_Id
2959: AND Wdd.Container_Flag = 'N'