DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WSH_PICK_LIST

Line 492: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp,

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

Line 1702: p_del_detail_id IN OUT NOCOPY WSH_PICK_LIST.DelDetTabTyp)

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;
1706: l_progress VARCHAR2(10);

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

2546: -- p_wsh_release_table, p_trolin_delivery_ids and p_del_detail_id in case a rollback
2547: -- occurs. The rollback will deal with the database changes to WDD, RSV, and MOL records.
2548: -- However, we are locally storing the changes to WDD records in the data structures
2549: -- mentioned above. We should clean that up and rollback the similar changes made there.
2550: -- Also need to keep track of the WDD values inserted into WSH_PICK_LIST.G_XDOCK_DETAIL_TAB
2551: -- and WSH_PICK_LIST.G_XDOCK_MOL_TAB used for updating the crossdocked WDD records.
2552: l_split_wdd_index NUMBER;
2553: l_split_delivery_index NUMBER;
2554: l_xdocked_wdd_index NUMBER;

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

2547: -- occurs. The rollback will deal with the database changes to WDD, RSV, and MOL records.
2548: -- However, we are locally storing the changes to WDD records in the data structures
2549: -- mentioned above. We should clean that up and rollback the similar changes made there.
2550: -- Also need to keep track of the WDD values inserted into WSH_PICK_LIST.G_XDOCK_DETAIL_TAB
2551: -- and WSH_PICK_LIST.G_XDOCK_MOL_TAB used for updating the crossdocked WDD records.
2552: l_split_wdd_index NUMBER;
2553: l_split_delivery_index NUMBER;
2554: l_xdocked_wdd_index NUMBER;
2555:

Line 6687: l_del_detail_id WSH_PICK_LIST.DelDetTabTyp;

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