DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_UTIL_CORE

Line 30: G_ASSIGNED_DEL_TBL WSH_UTIL_CORE.Id_Tab_Type;

26: G_SEED_DOC_SET NUMBER := NULL;
27: G_AUTO_PICK_CONFIRM VARCHAR2(1) := NULL;
28: G_PICK_REL_PARALLEL BOOLEAN := FALSE;
29: G_NUM_WORKERS NUMBER;
30: G_ASSIGNED_DEL_TBL WSH_UTIL_CORE.Id_Tab_Type;
31:
32: TYPE unassign_delivery_id_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
33: G_UNASSIGNED_DELIVERY_IDS WSH_PICK_LIST.unassign_delivery_id_type;
34:

Line 212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,

208: -- bug# 6719369 (replenishment project): For dynamic replenishment case, WMS passes the delivery detail ids as well as
209: -- the picking batch id value. In this case it shoud create a new batch by taking the attribute values from the old batch
210: -- information.
211: PROCEDURE Launch_Pick_Release(
212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,
216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,

209: -- the picking batch id value. In this case it shoud create a new batch by taking the attribute values from the old batch
210: -- information.
211: PROCEDURE Launch_Pick_Release(
212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,
216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
217: p_auto_pack_ship IN VARCHAR2 DEFAULT NULL,

Line 214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,

210: -- information.
211: PROCEDURE Launch_Pick_Release(
212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,
216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
217: p_auto_pack_ship IN VARCHAR2 DEFAULT NULL,
218: p_batch_id IN NUMBER DEFAULT NULL, -- bug# 6719369 (replenishment project)

Line 215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,

211: PROCEDURE Launch_Pick_Release(
212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,
216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
217: p_auto_pack_ship IN VARCHAR2 DEFAULT NULL,
218: p_batch_id IN NUMBER DEFAULT NULL, -- bug# 6719369 (replenishment project)
219: x_return_status OUT NOCOPY VARCHAR2

Line 216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

212: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
213: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
214: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
215: p_detail_ids IN WSH_UTIL_CORE.Id_Tab_Type,
216: x_request_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
217: p_auto_pack_ship IN VARCHAR2 DEFAULT NULL,
218: p_batch_id IN NUMBER DEFAULT NULL, -- bug# 6719369 (replenishment project)
219: x_return_status OUT NOCOPY VARCHAR2
220: );