DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on WSH_DETAILS_VALIDATIONS

Line 152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;

148: FROM wsh_delivery_details
149: WHERE move_order_line_id = p_mo_line_id;
150:
151: l_detail_info c_detail_info%ROWTYPE;
152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
153: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
155: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
156: l_min_quantity NUMBER;

Line 153: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;

149: WHERE move_order_line_id = p_mo_line_id;
150:
151: l_detail_info c_detail_info%ROWTYPE;
152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
153: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
155: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
156: l_min_quantity NUMBER;
157: l_max_quantity NUMBER;

Line 154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;

150:
151: l_detail_info c_detail_info%ROWTYPE;
152: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
153: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
154: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
155: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
156: l_min_quantity NUMBER;
157: l_max_quantity NUMBER;
158: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

Line 220: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity

216: l_minmaxinrectype.lock_flag := 'N';
217: l_minmaxinrectype.quantity_uom := l_detail_info.requested_quantity_uom;
218: l_minmaxinrectype.quantity_uom2 := l_detail_info.requested_quantity_uom2;
219:
220: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
221: (p_in_attributes => l_minmaxinrectype,
222: x_out_attributes => l_minmaxoutrectype,
223: p_inout_attributes => l_minmaxinoutrectype,
224: x_return_status => x_return_status,