APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_NEW_DELIVERIES

Line 923: UPDATE wsh_new_deliveries

919:
920:
921: IF (p_delivery_id IS NOT NULl) THEN
922: --{
923: UPDATE wsh_new_deliveries
924: SET vendor_id = p_to_id,
925: party_id = p_to_party_id,
926: last_update_date = sysdate,
927: last_updated_by = fnd_global.user_id,

Line 933: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

929: WHERE delivery_id = p_delivery_id
930: RETURNING name INTO l_dlvy_name;
931: IF l_debug_on THEN
932: --{
933: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
934: --}
935: END IF;
936:
937: ELSE

Line 939: UPDATE wsh_new_deliveries

935: END IF;
936:
937: ELSE
938:
939: UPDATE wsh_new_deliveries
940: SET vendor_id = p_to_id,
941: party_id = p_to_party_id,
942: last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,

Line 964: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

960: )
961: AND vendor_id = p_from_id;
962: IF l_debug_on THEN
963: --{
964: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_new_deliveries. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
965: --}
966: END IF;
967: --}
968: END IF;

Line 1541: Wsh_new_deliveries wnd

1537: d.delivery_detail_id
1538: FROM po_headers_all p,
1539: wsh_delivery_details d,
1540: wsh_delivery_assignments w,
1541: Wsh_new_deliveries wnd
1542: WHERE p.vendor_id = p_to_id
1543: AND d.source_code = 'PO'
1544: AND p.po_header_id = d.source_header_id
1545: AND p.vendor_site_id = p_to_site_id

Line 1576: FROM wsh_new_deliveries wnd,

1572: wnd.status_code,
1573: wnd.routing_response_id,
1574: wnd.name,
1575: wnd.ultimate_dropoff_location_id
1576: FROM wsh_new_deliveries wnd,
1577: wsh_delivery_details wdd,
1578: wsh_delivery_assignments wda
1579: WHERE wnd.delivery_id = p_del_id
1580: AND wnd.delivery_id = wda.delivery_id

Line 1637: wsh_new_deliveries wnd

1633: wnd.name
1634: FROM wsh_delivery_details wdd,
1635: wsh_delivery_assignments wda ,
1636: wsh_inbound_txn_history wth,
1637: wsh_new_deliveries wnd
1638: WHERE wda.delivery_id = p_delivery_id
1639: AND nvl(wda.type,'S') IN ('S','O')
1640: AND wda.delivery_detail_Id = wdd.delivery_detail_id
1641: AND wdd.routing_req_id = wth.transaction_id

Line 1683: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

1679: --
1680:
1681: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1682: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1683: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1684: l_dlvy_tbl wsh_util_core.id_tab_type;
1685: l_chk_delivery_id NUMBER :=0;
1686: l_prev_new_rr_id NUMBER :=0;
1687: l_site_merge BOOLEAN;

Line 1997: --Update WSH_NEW_DELIVERIES with the merge to vendor

1993: );
1994:
1995: l_chk_delivery_id := l_new_delivery_id;
1996:
1997: --Update WSH_NEW_DELIVERIES with the merge to vendor
1998: IF l_debug_on THEN
1999: --{
2000: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2001: --}

Line 2088: FROM wsh_new_deliveries

2084: --
2085: SELECT initial_pickup_location_id, routing_response_id,
2086: name, status_code
2087: INTO l_location_id, l_routing_response_id, l_dlvy_name, l_dlvy_status_code
2088: FROM wsh_new_deliveries
2089: WHERE delivery_id = l_delivery_rec.delivery_id;
2090: --
2091: --Update WSH_NEW_DELIVERIES with the merge to vendor
2092: IF l_debug_on THEN

Line 2091: --Update WSH_NEW_DELIVERIES with the merge to vendor

2087: INTO l_location_id, l_routing_response_id, l_dlvy_name, l_dlvy_status_code
2088: FROM wsh_new_deliveries
2089: WHERE delivery_id = l_delivery_rec.delivery_id;
2090: --
2091: --Update WSH_NEW_DELIVERIES with the merge to vendor
2092: IF l_debug_on THEN
2093: --{
2094: --wsh_debug_sv.log(l_module_name, 'l_dup', l_dup);
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2465: FROM wsh_new_deliveries

2461: l_dlvy_rr_tbl(l_respIndex).delivery_id := l_dlvy_rr_cache_tbl( l_cache_index );
2462: --
2463: SELECT organization_id
2464: INTO l_dlvy_rr_tbl(l_respIndex).organization_id
2465: FROM wsh_new_deliveries
2466: WHERE delivery_id = l_dlvy_rr_tbl(l_respIndex).delivery_id;
2467: --
2468: l_cache_index := l_dlvy_rr_cache_tbl.Next( l_cache_index );
2469: --}