APPS.WSH_LPN_SYNC_COMM_PKG dependencies on WSH_WMS_SYNC_TMP

Line 33: wsh_wms_sync_tmp wlst

29: wddp.lpn_id old_parent_lpn_id
30: from wsh_delivery_details wddc,
31: wsh_delivery_details wddp,
32: wsh_delivery_assignments_v wda,
33: wsh_wms_sync_tmp wlst
34: where wlst.delivery_detail_id = wda.delivery_detail_id
35: and wddc.delivery_detail_id = wda.delivery_detail_id
36: and wlst.parent_delivery_detail_id = wddp.delivery_detail_id
37: and nvl(wda.parent_delivery_detail_id, -1) <> nvl(wlst.parent_delivery_detail_id,-1)

Line 56: wsh_wms_sync_tmp wlst

52: wddp.lpn_id parent_lpn_id
53: from wsh_delivery_details wddc,
54: wsh_delivery_details wddp,
55: wsh_delivery_assignments_v wda,
56: wsh_wms_sync_tmp wlst
57: where wlst.delivery_detail_id = wda.delivery_detail_id
58: and wddc.delivery_detail_id = wda.delivery_detail_id
59: and wda.parent_delivery_detail_id = wddp.delivery_detail_id
60: and nvl(wda.parent_delivery_detail_id, -1) <> nvl(wlst.parent_delivery_detail_id,-1)

Line 78: wsh_wms_sync_tmp wlst

74: select wdd.lpn_id,
75: wlst.delivery_id old_delivery_id
76: from wsh_delivery_details wdd,
77: wsh_delivery_assignments_v wda,
78: wsh_wms_sync_tmp wlst
79: where wlst.delivery_detail_id = wda.delivery_detail_id
80: and wdd.delivery_detail_id = wda.delivery_detail_id
81: and nvl(wda.delivery_id, -1) <> nvl(wlst.delivery_id,-1)
82: and wlst.delivery_id is not null

Line 99: wsh_wms_sync_tmp wlst

95: select wdd.lpn_id,
96: wda.delivery_id new_delivery_id
97: from wsh_delivery_details wdd,
98: wsh_delivery_assignments_v wda,
99: wsh_wms_sync_tmp wlst
100: where wlst.delivery_detail_id = wda.delivery_detail_id
101: and wdd.delivery_detail_id = wda.delivery_detail_id
102: and nvl(wda.delivery_id, -1) <> nvl(wlst.delivery_id,-1)
103: and wda.delivery_id is not null

Line 129: wsh_wms_sync_tmp wlst

125: wdd.volume,
126: wdd.weight_uom_code,
127: wdd.net_weight
128: from wsh_delivery_details wdd,
129: wsh_wms_sync_tmp wlst
130: where wlst.delivery_detail_id = wdd.delivery_detail_id
131: and wdd.lpn_id is not null
132: and wlst.operation_type = 'UPDATE'
133: and wlst.creation_date = p_hw_time_stamp;

Line 193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp

189: WSH_DEBUG_SV.log(l_module_name,'l_current_hw_time_stamp', l_current_hw_time_stamp);
190: END IF;
191:
192: -- Bug 8314220: Moved following query out from debug
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);

Line 197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);

193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
198: END IF;
199:
200: -- Bug 8314220: Execute following code only if there are any records in wsh_wms_sync_tmp table.
201: IF l_tmp_tbl_size > 0 THEN

Line 200: -- Bug 8314220: Execute following code only if there are any records in wsh_wms_sync_tmp table.

196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
198: END IF;
199:
200: -- Bug 8314220: Execute following code only if there are any records in wsh_wms_sync_tmp table.
201: IF l_tmp_tbl_size > 0 THEN
202: --{
203: -- We are doing the following update because, if a particular went through various
204: -- steps of for example, update, assign, unassign, and was finally deleted, then

Line 206: update wsh_wms_sync_tmp

202: --{
203: -- We are doing the following update because, if a particular went through various
204: -- steps of for example, update, assign, unassign, and was finally deleted, then
205: -- we do not want to call WMS for these operations
206: update wsh_wms_sync_tmp
207: set operation_type = 'DELETE'
208: where delivery_detail_id in (select delivery_detail_id
209: from wsh_wms_sync_tmp
210: where operation_type = 'DELETE'

Line 209: from wsh_wms_sync_tmp

205: -- we do not want to call WMS for these operations
206: update wsh_wms_sync_tmp
207: set operation_type = 'DELETE'
208: where delivery_detail_id in (select delivery_detail_id
209: from wsh_wms_sync_tmp
210: where operation_type = 'DELETE'
211: and creation_date = l_current_hw_time_stamp)
212: and operation_type = 'UPDATE'
213: and creation_date = l_current_hw_time_stamp;

Line 442: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

438: p_commit => FND_API.G_FALSE,
439: x_return_status => l_return_status,
440: x_msg_count => l_msg_count,
441: x_msg_data => l_msg_data,
442: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
443: p_lpn_table => l_wms_lpn_tbl
444: );
445: -- resetting the values back to the original values
446: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

Line 564: wsh_wms_sync_tmp wlst

560: wdd.weight_uom_code,
561: wdd.net_weight,
562: wlst.call_level
563: from wsh_delivery_details wdd,
564: wsh_wms_sync_tmp wlst
565: where wlst.delivery_detail_id = wdd.delivery_detail_id
566: and wdd.lpn_id is not null
567: and wlst.operation_type = 'UPDATE'
568: and wlst.creation_date = p_hw_time_stamp

Line 654: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

650: p_commit => FND_API.G_FALSE,
651: x_return_status => l_return_status,
652: x_msg_count => l_msg_count,
653: x_msg_data => l_msg_data,
654: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
655: p_lpn_table => l_wms_lpn_tbl
656: );
657: -- resetting the values back to the original values
658: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;

Line 732: p_caller => 'WSH_WMS_SYNC_TMP_PKG',

728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,
732: p_caller => 'WSH_WMS_SYNC_TMP_PKG',
733: p_lpn_table => l_wms_lpn_tbl
734: );
735: -- resetting the values back to the original values
736: WSH_WMS_LPN_GRP.g_call_group_api := l_original_call_grp_api;