DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WSH_PICK_LIST

Line 502: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,

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,
506: l_wdd_txn_qty IN OUT NOCOPY NUMBER,

Line 1726: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,

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';
1730: l_api_version CONSTANT NUMBER := 1.0;

Line 2575: -- Also need to keep track of the WDD values inserted into WSH_PICK_LIST.G_XDOCK_DETAIL_TAB

2571: -- p_wsh_release_table, p_trolin_delivery_ids and p_del_detail_id in case a rollback
2572: -- occurs. The rollback will deal with the database changes to WDD, RSV, and MOL records.
2573: -- However, we are locally storing the changes to WDD records in the data structures
2574: -- mentioned above. We should clean that up and rollback the similar changes made there.
2575: -- Also need to keep track of the WDD values inserted into WSH_PICK_LIST.G_XDOCK_DETAIL_TAB
2576: -- and WSH_PICK_LIST.G_XDOCK_MOL_TAB used for updating the crossdocked WDD records.
2577: l_split_wdd_index NUMBER;
2578: l_split_delivery_index NUMBER;
2579: l_xdocked_wdd_index NUMBER;

Line 2576: -- and WSH_PICK_LIST.G_XDOCK_MOL_TAB used for updating the crossdocked WDD records.

2572: -- occurs. The rollback will deal with the database changes to WDD, RSV, and MOL records.
2573: -- However, we are locally storing the changes to WDD records in the data structures
2574: -- mentioned above. We should clean that up and rollback the similar changes made there.
2575: -- Also need to keep track of the WDD values inserted into WSH_PICK_LIST.G_XDOCK_DETAIL_TAB
2576: -- and WSH_PICK_LIST.G_XDOCK_MOL_TAB used for updating the crossdocked WDD records.
2577: l_split_wdd_index NUMBER;
2578: l_split_delivery_index NUMBER;
2579: l_xdocked_wdd_index NUMBER;
2580:

Line 6862: l_del_detail_id WSH_PICK_LIST.DelDetTabTyp;

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;
6866: l_split_delivery_index NUMBER;