APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 8880: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

8876: l_num_of_split NUMBER;
8877:
8878: old_delivery_detail_rec SplitDetailRecType;
8879:
8880: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
8881:
8882:
8883: -- Bug 2637876
8884: l_original_shipped_qty NUMBER;

Line 9296: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

9292: l_org_wv_qty NUMBER;
9293: l_new_wv_qty NUMBER;
9294: l_final_req_qty NUMBER; --bug# 6689448 (replenishment project)
9295:
9296: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
9297:
9298:
9299: WSH_SN_SPLIT_ERR EXCEPTION;
9300: WSH_NO_DATA_FOUND EXCEPTION;

Line 10182: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

10178:
10179:
10180: old_delivery_detail_rec SplitDetailRecType;
10181:
10182: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
10183: -- muom
10184: l_fulfillment_base VARCHAR2(1);
10185: l_dummy NUMBER;
10186:

Line 10637: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

10633:
10634: -- HW OPMCONV. Removed OPM excpetion
10635:
10636:
10637: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
10638:
10639: WSH_CREATE_DET_ERR EXCEPTION;
10640: WSH_SN_SPLIT_ERR EXCEPTION;
10641:

Line 11651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);

11647:
11648: -- we have at least one record in MTL_SERIAL_NUMBERS_TEMP
11649: --
11650: IF l_debug_on THEN
11651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11652: END IF;
11653: --
11654: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(
11655: p_organization_id => x_old_detail_rec.organization_id,

Line 11654: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(

11650: IF l_debug_on THEN
11651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11652: END IF;
11653: --
11654: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(
11655: p_organization_id => x_old_detail_rec.organization_id,
11656: p_delivery_detail_id => x_old_detail_rec.delivery_detail_id);
11657: l_qty_to_split := l_ser_qty - p_old_shipped_quantity;
11658: --

Line 13144: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

13140: l_organization_id NUMBER := NULL;
13141: l_subinventory VARCHAR2(10) := NULL;
13142: l_serial_number VARCHAR2(30) := NULL;
13143: l_transaction_temp_id NUMBER := NULL;
13144: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
13145: l_return_status VARCHAR2(5) := NULL;
13146: --Added for bug 10062808
13147: CURSOR c_detail(c_detail_id NUMBER) IS
13148: SELECT organization_id,

Line 13155: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

13151: FROM wsh_delivery_details
13152: WHERE delivery_detail_id = c_detail_id AND
13153: NVL(container_flag, 'N') = 'N';
13154: l_qty_unres NUMBER;
13155: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
13156: l_bo_mode VARCHAR2(30);
13157: -- muom
13158: l_qty2_unres NUMBER;
13159: l_fulfillment_base VARCHAR2(1);

Line 13216: WSH_DELIVERY_DETAILS_INV.Get_item_information(

13212: OPEN c_detail(p_delivery_detail_id );
13213: FETCH c_detail INTO l_organization_id,l_inventory_item_id,l_fulfillment_base; --muom
13214: CLOSE c_detail;
13215:
13216: WSH_DELIVERY_DETAILS_INV.Get_item_information(
13217: p_organization_id => l_organization_id,
13218: p_inventory_item_id => l_inventory_item_id,
13219: x_mtl_system_items_rec => l_item_info,
13220: x_return_status => l_return_status