DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 12: container_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

8: G_CALLED_FROM_INBOUND BOOLEAN := FALSE;
9:
10: TYPE empty_container_info IS RECORD (
11: container_index NUMBER,
12: container_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
13: mast_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
14: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
15: group_id NUMBER,
16: numerator NUMBER,

Line 32: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

28: volume WSH_DELIVERY_DETAILS.volume%TYPE,
29: delivery_id wsh_delivery_assignments_v.delivery_id%TYPE,
30: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
31: -- J: W/V Changes
32: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
33: weight_uom WSH_DELIVERY_DETAILS.weight_uom_code%TYPE,
34: volume_uom WSH_DELIVERY_DETAILS.volume_uom_code%TYPE,
35: -- K LPN CONV
36: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE);

Line 44: container_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

40:
41: -- added number_of_containers to the record structure
42: TYPE new_container_info IS RECORD (
43: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
44: container_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
45: mast_cont_item_id WSH_DELIVERY_DETAILS.master_container_item_id%TYPE,
46: cont_instance_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
47: number_of_containers NUMBER
48: );

Line 5580: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

5576: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_DD_FOR_PACK';
5577: --
5578:
5579: -- HW OPMCONV - New variable to hold item info
5580: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
5581: -- HW OPM BUG# 3011758
5582: -- HW OPMCONV - Removed opm variables
5583:
5584: -- HW OPMCONV - Renamed variable from lot_indivisible to l_lot_divisible_flag

Line 5711: WSH_DELIVERY_DETAILS_INV.Get_item_information

5707: -- HW OPMCONV - 1)Change the call from OPM API to get item info
5708: -- to a new WSH API
5709: -- - 2) Remove checking for process
5710:
5711: WSH_DELIVERY_DETAILS_INV.Get_item_information
5712: (
5713: p_organization_id => rec.organization_id
5714: , p_inventory_item_id => rec.inventory_item_id
5715: , x_mtl_system_items_rec => l_item_info

Line 8404: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8400:
8401: -- HW OPMCONV - Renamed variable to l_lot_divisible_flag
8402: l_lot_divisible_flag VARCHAR2(1);
8403: -- HW OPMCONV - New variable to hold item info
8404: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8405:
8406: -- LPN CONV. rv
8407: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8408: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 8716: WSH_DELIVERY_DETAILS_INV.Get_item_information

8712: -- HW OPMCONV - 1) Removed branching code
8713: -- - 2) Removed call to OPM API to get item info
8714: -- - 3) New WSH API call to get item info
8715:
8716: WSH_DELIVERY_DETAILS_INV.Get_item_information
8717: (
8718: p_organization_id =>l_det_org_id
8719: , p_inventory_item_id => l_det_inv_item_id
8720: , x_mtl_system_items_rec => l_item_info

Line 9207: WSH_DELIVERY_DETAILS_INV.Get_item_information

9203: -- HW OPMCONV - 1)Change the call from OPM API to get item info
9204: -- to a new WSH API
9205: -- - 2) Remove checking for process
9206:
9207: WSH_DELIVERY_DETAILS_INV.Get_item_information
9208: (
9209: p_organization_id => l_det_org_id
9210: , p_inventory_item_id => l_det_inv_item_id
9211: , x_mtl_system_items_rec => l_item_info