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 859: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

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

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

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

Line 1236: FROM Wsh_New_Deliveries Wnd,

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

Line 1246: FROM Wsh_New_Deliveries Del,

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

Line 1261: wsh_new_deliveries wnd

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

Line 1266: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED

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

Line 1273: FROM wsh_new_deliveries wnd

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

Line 1305: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 1316: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 1317: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

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

Line 1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

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

Line 1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

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

Line 1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

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

Line 1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

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

Line 1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

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

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

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

Line 1584: UPDATE WSH_NEW_DELIVERIES Wnd

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

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

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

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

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

Line 1640: p_table_name => 'WSH_NEW_DELIVERIES',

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

Line 1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

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

Line 1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

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

Line 1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

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

Line 1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

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

Line 1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

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

Line 1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

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

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

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

Line 1922: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

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

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

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

Line 2207: FROM Wsh_New_Deliveries WND

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

Line 2225: Wsh_New_Deliveries Dlvy

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

Line 2232: Wsh_New_Deliveries Wnd

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

Line 2301: UPDATE Wsh_New_Deliveries

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

Line 2326: p_table_name => 'WSH_NEW_DELIVERIES',

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

Line 2364: UPDATE Wsh_New_Deliveries

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

Line 2389: p_table_name => 'WSH_NEW_DELIVERIES',

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

Line 2505: Wsh_New_Deliveries WND,

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

Line 2801: FROM Wsh_New_Deliveries

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

Line 2927: Wsh_New_Deliveries WND

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

Line 2952: Wsh_New_Deliveries WND

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