DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 8716: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

8712: l_num_of_split NUMBER;
8713:
8714: old_delivery_detail_rec SplitDetailRecType;
8715:
8716: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
8717:
8718:
8719: -- Bug 2637876
8720: l_original_shipped_qty NUMBER;

Line 9132: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

9128: l_org_wv_qty NUMBER;
9129: l_new_wv_qty NUMBER;
9130: l_final_req_qty NUMBER; --bug# 6689448 (replenishment project)
9131:
9132: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
9133:
9134:
9135: WSH_SN_SPLIT_ERR EXCEPTION;
9136: WSH_NO_DATA_FOUND EXCEPTION;

Line 10000: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

9996:
9997:
9998: old_delivery_detail_rec SplitDetailRecType;
9999:
10000: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
10001:
10002:
10003: --
10004: l_debug_on BOOLEAN;

Line 10364: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

10360:
10361: -- HW OPMCONV. Removed OPM excpetion
10362:
10363:
10364: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
10365:
10366: WSH_CREATE_DET_ERR EXCEPTION;
10367: WSH_SN_SPLIT_ERR EXCEPTION;
10368:

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

11216:
11217: -- we have at least one record in MTL_SERIAL_NUMBERS_TEMP
11218: --
11219: IF l_debug_on THEN
11220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11221: END IF;
11222: --
11223: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(
11224: p_organization_id => x_old_detail_rec.organization_id,

Line 11223: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(

11219: IF l_debug_on THEN
11220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
11221: END IF;
11222: --
11223: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty(
11224: p_organization_id => x_old_detail_rec.organization_id,
11225: p_delivery_detail_id => x_old_detail_rec.delivery_detail_id);
11226: l_qty_to_split := l_ser_qty - p_old_shipped_quantity;
11227: --

Line 12666: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

12662: l_organization_id NUMBER := NULL;
12663: l_subinventory VARCHAR2(10) := NULL;
12664: l_serial_number VARCHAR2(30) := NULL;
12665: l_transaction_temp_id NUMBER := NULL;
12666: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
12667: l_return_status VARCHAR2(5) := NULL;
12668:
12669: --
12670: l_debug_on BOOLEAN;