DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on WSH_DETAILS_VALIDATIONS

Line 167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;

163: FROM wsh_delivery_details
164: WHERE move_order_line_id = p_mo_line_id;
165:
166: l_detail_info c_detail_info%ROWTYPE;
167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
168: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
171: l_min_quantity NUMBER;

Line 168: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;

164: WHERE move_order_line_id = p_mo_line_id;
165:
166: l_detail_info c_detail_info%ROWTYPE;
167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
168: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
171: l_min_quantity NUMBER;
172: l_max_quantity NUMBER;

Line 169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;

165:
166: l_detail_info c_detail_info%ROWTYPE;
167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
168: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
171: l_min_quantity NUMBER;
172: l_max_quantity NUMBER;
173: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

Line 240: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity

236: l_minmaxinrectype.lock_flag := 'N';
237: l_minmaxinrectype.quantity_uom := l_detail_info.requested_quantity_uom;
238: l_minmaxinrectype.quantity_uom2 := l_detail_info.requested_quantity_uom2;
239:
240: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
241: (p_in_attributes => l_minmaxinrectype,
242: x_out_attributes => l_minmaxoutrectype,
243: p_inout_attributes => l_minmaxinoutrectype,
244: x_return_status => x_return_status,