APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_PICK_LIST

Line 1320: -- API WSH_PICK_LIST.xx to here and to recognize the change pick release API is

1316:
1317:
1318: -- Need to validate the input action.
1319: -- LSP PROJECT : Use_header_flag value defaulting (from org/client defaults) has been moved from pick release
1320: -- API WSH_PICK_LIST.xx to here and to recognize the change pick release API is
1321: -- passing action code as 'MATCH_GROUPS_AT_PICK' instead of 'MATCH_GROUPS'.
1322: IF p_action_rec.action NOT IN ('MATCH_GROUPS', 'CREATE_GROUPS', 'AUTOCREATE_DELIVERIES','MATCH_GROUPS_AT_PICK') THEN
1323:
1324: RAISE INVALID_ACTION;

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

2333: l_delivery_info.party_id := l_group_info(l_group_index).party_id;
2334: l_delivery_info.mode_of_transport := l_group_info(l_group_index).mode_of_transport;
2335: l_delivery_info.service_level := l_group_info(l_group_index).service_level;
2336: l_delivery_info.status_code := l_group_info(l_group_index).status_code;
2337: l_delivery_info.batch_id := wsh_pick_list.g_batch_id;
2338: l_delivery_info.hash_value := l_group_info(l_group_index).l1_hash_value;
2339: l_delivery_info.hash_string := l_group_info(l_group_index).l1_hash_string;
2340: l_delivery_info.client_id := l_group_info(l_group_index).client_id ; -- LSP PROJECT
2341: l_delivery_info.consignee_flag := l_group_info(l_group_index).consignee_flag; -- RTV changes

Line 2367: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL

2363:
2364: -- 5415196: frontport reconciled with parallel pick release
2365: -- and LPN convergence
2366:
2367: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL
2368: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.logmsg(l_module_name,'Acquiring lock on :'||l_delivery_info.hash_value||'-'||l_delivery_info.batch_id);
2371: END IF;

Line 2368: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{

2364: -- 5415196: frontport reconciled with parallel pick release
2365: -- and LPN convergence
2366:
2367: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL
2368: AND WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN --{
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.logmsg(l_module_name,'Acquiring lock on :'||l_delivery_info.hash_value||'-'||l_delivery_info.batch_id);
2371: END IF;
2372: DBMS_LOCK.Allocate_Unique(lockname => l_delivery_info.hash_value||'-'||l_delivery_info.batch_id,

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

2687: --
2688: l_check_fte_inst := WSH_UTIL_CORE.FTE_Is_Installed;
2689: IF (l_check_fte_inst = 'Y') THEN
2690:
2691: IF ((WSH_PICK_LIST.G_BATCH_ID is null) AND
2692: (l_delivery_rows.COUNT > 0) AND l_del_select_carrier.count > 0 ) THEN
2693: --
2694: -- no batch Id so this is not from pick release
2695: -- so lets try it

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

2733: -- Pack J: Added Rate delivery for autocreate deliveries.
2734: -- Bug 3714834: Since autocreate del at pick release does rating
2735: -- do not rate if called by pick release.
2736:
2737: IF (l_del_rate.count > 0) AND (WSH_PICK_LIST.G_BATCH_ID is null) THEN
2738:
2739: l_in_param_rec.delivery_id_list := l_del_rate;
2740: l_in_param_rec.action := 'RATE';
2741: l_in_param_rec.seq_tender_flag := 'Y'; -- R12 Select Carrier

Line 3469: p_delivery_ids IN WSH_PICK_LIST.unassign_delivery_id_type,

3465: -- x_return_status - Status of execution
3466: --------------------------------------------------------------------------
3467:
3468: PROCEDURE unassign_empty_containers(
3469: p_delivery_ids IN WSH_PICK_LIST.unassign_delivery_id_type,
3470: x_return_status OUT NOCOPY VARCHAR2 ) IS
3471:
3472:
3473: -- LPN CONV. rv