APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DEL_ASSGN_INTERFACE

Line 197: wsh_del_assgn_interface wdai

193: wddi.LATEST_PICKUP_DATE ,
194: wddi.EARLIEST_DROPOFF_DATE ,
195: wddi.LATEST_DROPOFF_DATE
196: FROM wsh_del_details_interface wddi,
197: wsh_del_assgn_interface wdai
198: WHERE wddi.delivery_detail_id= nvl(l_detail_id, wddi.delivery_detail_id)
199: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
200: AND wdai.delivery_interface_id= l_dlvy_interface_id
201: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 249: - This procedure updates the wsh_del_assgn_interface table.

245: x_return_status - return status of API
246: DESCRIPTION :
247: - This procedure is called in the Inbound Map, to relate the SHIPITEM records
248: with the SHIPUNIT/CONTAINER records through the parent_detail_interface_id.
249: - This procedure updates the wsh_del_assgn_interface table.
250: - This takes the parent_delivery_detail_id and parent_detail_interface_id.
251: - For those records which have parent_delivery_detail_id is equal to the
252: parameter value, the parent_detail_interface_id is updated with the give
253: value.

Line 287: UPDATE wsh_del_assgn_interface

283: END IF;
284:
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
286:
287: UPDATE wsh_del_assgn_interface
288: SET parent_detail_interface_id = p_parent_detail_interface_id
289: WHERE parent_delivery_detail_id = p_parent_delivery_detail_id;
290:
291: IF (SQL%NOTFOUND) THEN

Line 525: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi

521: l_validation_level NUMBER;
522: -- cursors
523: CURSOR detail_ids_cur IS
524: SELECT count(*), wdai.delivery_detail_id, wddi.container_flag
525: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi
526: WHERE wdai.delivery_interface_id = p_delivery_interface_id
527: AND wdai.delivery_detail_interface_id = wddi.delivery_detail_interface_id
528: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND'
529: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1217: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1213: l_index NUMBER;
1214: --Cursors
1215: CURSOR c_det_count_cur(p_detail_id NUMBER, p_dlvy_int_id NUMBER) IS
1216: SELECT COUNT(*)
1217: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1218: WHERE wddi.delivery_Detail_interface_id = wdai.delivery_detail_interface_id
1219: AND wdai.delivery_interface_id = p_dlvy_int_id
1220: AND wddi.delivery_detail_id=p_detail_id
1221: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 3776: FROM wsh_del_assgn_interface wdai

3772: AND wdd.organization_id = p_del_det_int_rec.organization_id;
3773:
3774: CURSOR intf_parent_det_cur IS
3775: SELECT wdai.parent_delivery_detail_id
3776: FROM wsh_del_assgn_interface wdai
3777: WHERE wdai.delivery_detail_interface_id = p_del_det_int_rec.delivery_detail_interface_id
3778: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND';
3779:
3780: --exceptions