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 5652: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

5648: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_DD_FOR_PACK';
5649: --
5650:
5651: -- HW OPMCONV - New variable to hold item info
5652: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
5653: -- HW OPM BUG# 3011758
5654: -- HW OPMCONV - Removed opm variables
5655:
5656: -- HW OPMCONV - Renamed variable from lot_indivisible to l_lot_divisible_flag

Line 5783: WSH_DELIVERY_DETAILS_INV.Get_item_information

5779: -- HW OPMCONV - 1)Change the call from OPM API to get item info
5780: -- to a new WSH API
5781: -- - 2) Remove checking for process
5782:
5783: WSH_DELIVERY_DETAILS_INV.Get_item_information
5784: (
5785: p_organization_id => rec.organization_id
5786: , p_inventory_item_id => rec.inventory_item_id
5787: , x_mtl_system_items_rec => l_item_info

Line 8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8529:
8530: -- HW OPMCONV - Renamed variable to l_lot_divisible_flag
8531: l_lot_divisible_flag VARCHAR2(1);
8532: -- HW OPMCONV - New variable to hold item info
8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8534:
8535: -- LPN CONV. rv
8536: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8537: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 8845: WSH_DELIVERY_DETAILS_INV.Get_item_information

8841: -- HW OPMCONV - 1) Removed branching code
8842: -- - 2) Removed call to OPM API to get item info
8843: -- - 3) New WSH API call to get item info
8844:
8845: WSH_DELIVERY_DETAILS_INV.Get_item_information
8846: (
8847: p_organization_id =>l_det_org_id
8848: , p_inventory_item_id => l_det_inv_item_id
8849: , x_mtl_system_items_rec => l_item_info

Line 9336: WSH_DELIVERY_DETAILS_INV.Get_item_information

9332: -- HW OPMCONV - 1)Change the call from OPM API to get item info
9333: -- to a new WSH API
9334: -- - 2) Remove checking for process
9335:
9336: WSH_DELIVERY_DETAILS_INV.Get_item_information
9337: (
9338: p_organization_id => l_det_org_id
9339: , p_inventory_item_id => l_det_inv_item_id
9340: , x_mtl_system_items_rec => l_item_info