DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_PICK_LIST

Line 2101: l_delivery_info.batch_id := wsh_pick_list.g_batch_id;

2097: l_delivery_info.party_id := l_group_info(l_group_index).party_id;
2098: l_delivery_info.mode_of_transport := l_group_info(l_group_index).mode_of_transport;
2099: l_delivery_info.service_level := l_group_info(l_group_index).service_level;
2100: l_delivery_info.status_code := l_group_info(l_group_index).status_code;
2101: l_delivery_info.batch_id := wsh_pick_list.g_batch_id;
2102: l_delivery_info.hash_value := l_group_info(l_group_index).l1_hash_value;
2103: l_delivery_info.hash_string := l_group_info(l_group_index).l1_hash_string;
2104:
2105: IF l_debug_on THEN

Line 2117: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL

2113:
2114: -- 5415196: frontport reconciled with parallel pick release
2115: -- and LPN convergence
2116:
2117: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL
2118: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'Acquiring lock on :'||l_delivery_info.hash_value||'-'||l_delivery_info.batch_id);
2121: END IF;

Line 2118: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{

2114: -- 5415196: frontport reconciled with parallel pick release
2115: -- and LPN convergence
2116:
2117: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL
2118: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'Acquiring lock on :'||l_delivery_info.hash_value||'-'||l_delivery_info.batch_id);
2121: END IF;
2122: DBMS_LOCK.Allocate_Unique(lockname => l_delivery_info.hash_value||'-'||l_delivery_info.batch_id,

Line 2441: IF ((WSH_PICK_LIST.G_BATCH_ID is null) AND

2437: --
2438: l_check_fte_inst := WSH_UTIL_CORE.FTE_Is_Installed;
2439: IF (l_check_fte_inst = 'Y') THEN
2440:
2441: IF ((WSH_PICK_LIST.G_BATCH_ID is null) AND
2442: (l_delivery_rows.COUNT > 0) AND l_del_select_carrier.count > 0 ) THEN
2443: --
2444: -- no batch Id so this is not from pick release
2445: -- so lets try it

Line 2487: IF (l_del_rate.count > 0) AND (WSH_PICK_LIST.G_BATCH_ID is null) THEN

2483: -- Pack J: Added Rate delivery for autocreate deliveries.
2484: -- Bug 3714834: Since autocreate del at pick release does rating
2485: -- do not rate if called by pick release.
2486:
2487: IF (l_del_rate.count > 0) AND (WSH_PICK_LIST.G_BATCH_ID is null) THEN
2488:
2489: l_in_param_rec.delivery_id_list := l_del_rate;
2490: l_in_param_rec.action := 'RATE';
2491: l_in_param_rec.seq_tender_flag := 'Y'; -- R12 Select Carrier

Line 3211: p_delivery_ids IN WSH_PICK_LIST.unassign_delivery_id_type,

3207: -- x_return_status - Status of execution
3208: --------------------------------------------------------------------------
3209:
3210: PROCEDURE unassign_empty_containers(
3211: p_delivery_ids IN WSH_PICK_LIST.unassign_delivery_id_type,
3212: x_return_status OUT NOCOPY VARCHAR2 ) IS
3213:
3214:
3215: -- LPN CONV. rv