[Home] [Help]
487: (p_log_prefix IN VARCHAR2,
488: p_crossdock_type IN NUMBER,
489: p_batch_id IN NUMBER,
490: p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp,
491: p_trolin_delivery_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
492: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,
493: l_wdd_index IN OUT NOCOPY NUMBER,
494: l_debug IN OUT NOCOPY NUMBER,
495: l_inventory_item_id IN OUT NOCOPY NUMBER,
503: l_conversion_rate IN OUT NOCOPY NUMBER,
504: l_conversion_precision IN NUMBER,
505: l_demand_line_detail_id IN OUT NOCOPY NUMBER,
506: l_index IN OUT NOCOPY NUMBER,
507: l_detail_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
508: l_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
509: l_action_out_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type,
510: l_split_wdd_id IN OUT NOCOPY NUMBER,
511: l_detail_info_tab IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.Delivery_Details_Attr_Tbl_Type,
1697: x_msg_count OUT NOCOPY NUMBER,
1698: x_msg_data OUT NOCOPY VARCHAR2,
1699: p_batch_id IN NUMBER,
1700: p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp,
1701: p_trolin_delivery_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1702: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp)
1703: IS
1704: l_api_name CONSTANT VARCHAR2(30) := 'Planned_Cross_Dock';
1705: l_api_version CONSTANT NUMBER := 1.0;
2376: l_supply_index NUMBER;
2377:
2378: -- Variables used to call the Shipping API to split a WDD line if a partial quantity
2379: -- is crossdocked on the WDD line.
2380: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
2381: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
2382: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2383: l_split_wdd_rel_rec WSH_PR_CRITERIA.relRecTyp;
2384: l_split_wdd_id NUMBER;
6139: -- lines could not be crossdocked, return a 'Warning' status. This is so Shipping can alert
6140: -- the user that some lines were not able to be allocated through crossdock. The other
6141: -- allocation methods are taken care of when backordering unallocated WDD lines.
6142: IF (l_allocation_method = G_CROSSDOCK_ONLY AND l_unable_to_crossdock) THEN
6143: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6144: ELSE
6145: x_return_status := fnd_api.g_ret_sts_success;
6146: END IF;
6147: l_progress := '630';
6662: l_atd_mol_qty2 NUMBER;
6663:
6664: -- Variables used to call the Shipping API to split a WDD line if a partial quantity
6665: -- is crossdocked on the WDD line.
6666: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
6667: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
6668: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
6669: l_split_wdd_rel_rec WSH_PR_CRITERIA.relRecTyp;
6670: l_split_wdd_id NUMBER;
6682: -- Dummy variables used when calling the private Crossdock_WDD procedure.
6683: -- These are variables used in the Planned Crossdocking case but not needed here.
6684: l_batch_id NUMBER;
6685: l_wsh_release_table WSH_PR_CRITERIA.relRecTabTyp;
6686: l_trolin_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
6687: l_del_detail_id WSH_PICK_LIST.DelDetTabTyp;
6688: l_dummy_wdd_index NUMBER;
6689: l_allocation_method VARCHAR2(1);
6690: l_split_wdd_index NUMBER;