APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DELIVERY_DETAILS

Line 67: wsh_delivery_details wdd

63:
64: CURSOR cont_not_recv_cur(l_delivery_id NUMBER, l_delivery_interface_id NUMBER) IS
65: SELECT wda.delivery_detail_id
66: FROM wsh_delivery_assignments_v wda,
67: wsh_delivery_details wdd
68: where wdd.delivery_detail_id = wda.delivery_detail_id
69: and wdd.container_flag = 'Y'
70: and wda.parent_delivery_detail_id IS NULL
71: and wda.delivery_id IS NOT NULL

Line 94: FROM wsh_delivery_details

90: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
91:
92: CURSOR det_qtys_cur(l_del_detail_id NUMBER) IS
93: SELECT requested_quantity, picked_quantity, container_flag
94: FROM wsh_delivery_details
95: WHERE delivery_detail_id = l_del_detail_id;
96:
97: --Bug 3346237:ENFORCE SHIP METHOD NOT ENFORCED WHILE SHIP CONFIRMING
98: --Created new cursor get_defer_interface_info to get defer_interface

Line 276: UPDATE wsh_delivery_details

272:
273: IF (nvl(l_warehouse_type, '!') = 'TPW') THEN
274: -- This update is only for transactions from TPW
275:
276: UPDATE wsh_delivery_details
277: SET released_status = 'Y'
278: WHERE delivery_detail_id IN (
279: SELECT delivery_detail_id
280: FROM wsh_delivery_assignments_v

Line 311: -- Update of wsh_delivery_details where requested_quantity/released_status

307: END LOOP;
308: --Done Raise Event: Pick To Pod Workflow
309: --
310: -- DBI Project
311: -- Update of wsh_delivery_details where requested_quantity/released_status
312: -- are changed, call DBI API after the update.
313: -- This API will also check for DBI Installed or not
314: IF l_debug_on THEN
315: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);