[Home] [Help]
497: (p_log_prefix IN VARCHAR2,
498: p_crossdock_type IN NUMBER,
499: p_batch_id IN NUMBER,
500: p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp,
501: p_trolin_delivery_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
502: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,
503: l_wdd_index IN OUT NOCOPY NUMBER,
504: l_debug IN OUT NOCOPY NUMBER,
505: l_inventory_item_id IN OUT NOCOPY NUMBER,
513: l_conversion_rate IN OUT NOCOPY NUMBER,
514: l_conversion_precision IN NUMBER,
515: l_demand_line_detail_id IN OUT NOCOPY NUMBER,
516: l_index IN OUT NOCOPY NUMBER,
517: l_detail_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
518: l_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
519: l_action_out_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type,
520: l_split_wdd_id IN OUT NOCOPY NUMBER,
521: l_detail_info_tab IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.Delivery_Details_Attr_Tbl_Type,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_batch_id IN NUMBER,
1724: p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp,
1725: p_trolin_delivery_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1726: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,
1727: p_simulation_mode in varchar2 default 'N')
1728: IS
1729: l_api_name CONSTANT VARCHAR2(30) := 'Planned_Cross_Dock';
2401: l_supply_index NUMBER;
2402:
2403: -- Variables used to call the Shipping API to split a WDD line if a partial quantity
2404: -- is crossdocked on the WDD line.
2405: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
2406: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
2407: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2408: l_split_wdd_rel_rec WSH_PR_CRITERIA.relRecTyp;
2409: l_split_wdd_id NUMBER;
6309: -- lines could not be crossdocked, return a 'Warning' status. This is so Shipping can alert
6310: -- the user that some lines were not able to be allocated through crossdock. The other
6311: -- allocation methods are taken care of when backordering unallocated WDD lines.
6312: IF (l_allocation_method = G_CROSSDOCK_ONLY AND l_unable_to_crossdock) THEN
6313: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6314: ELSE
6315: x_return_status := fnd_api.g_ret_sts_success;
6316: END IF;
6317: l_progress := '630';
6837: l_atd_mol_qty2 NUMBER;
6838:
6839: -- Variables used to call the Shipping API to split a WDD line if a partial quantity
6840: -- is crossdocked on the WDD line.
6841: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
6842: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
6843: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
6844: l_split_wdd_rel_rec WSH_PR_CRITERIA.relRecTyp;
6845: l_split_wdd_id NUMBER;
6857: -- Dummy variables used when calling the private Crossdock_WDD procedure.
6858: -- These are variables used in the Planned Crossdocking case but not needed here.
6859: l_batch_id NUMBER;
6860: l_wsh_release_table WSH_PR_CRITERIA.relRecTabTyp;
6861: l_trolin_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
6862: l_del_detail_id WSH_PICK_LIST.DelDetTabTyp;
6863: l_dummy_wdd_index NUMBER;
6864: l_allocation_method VARCHAR2(1);
6865: l_split_wdd_index NUMBER;