APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_DELIVERY_DETAILS

Line 249: UPDATE wsh_delivery_details

245:
246:
247: --updates the status of all i/p lines to 'P' (purge).
248: FORALL i IN p_in_rec.header_ids.FIRST..p_in_rec.header_ids.LAST
249: UPDATE wsh_delivery_details
250: SET released_status = 'P'
251: where source_header_id = p_in_rec.header_ids(i)
252: AND source_code = 'PO'
253: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab;

Line 257: -- Update of wsh_delivery_details where released_status

253: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab;
254:
255: --
256: -- DBI Project
257: -- Update of wsh_delivery_details where released_status
258: -- are changed, call DBI API after the update.
259: -- This API will also check for DBI Installed or not
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Delivery Details l_detail_tab count : ',l_detail_tab.COUNT);

Line 448: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd

444: ORDER BY NVL(revision_number, -99) DESC;
445: --
446: CURSOR c_GetLastUpdateDates(p_delId NUMBER) IS
447: SELECT MAX(wda.last_update_date), MAX(wdd.last_update_date)
448: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd
449: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
450: AND wda.delivery_id = p_delId;
451: --
452: -- This cursor gets the dates for the initial pickup location

Line 725: from wsh_delivery_details

721: p_po_line_id NUMBER,
722: p_location_id NUMBER)
723: IS
724: Select 1
725: from wsh_delivery_details
726: where
727: po_shipment_line_id = p_shipment_line_id
728: and (ship_from_location_id = p_location_id or ship_from_location_id = -1 )
729: and released_status = 'X'

Line 738: from wsh_delivery_details

734: Cursor open_line_without_sf_csr (p_shipment_line_id NUMBER,
735: p_po_line_id NUMBER)
736: IS
737: Select 1
738: from wsh_delivery_details
739: where
740: po_shipment_line_id = p_shipment_line_id
741: and released_status = 'X'
742: and source_code = 'PO'