61: -- 2 - None
62: BEGIN
63: SELECT lot_number_uniqueness -- Lot number uniqueness
64: INTO l_lot_type
65: FROM mtl_parameters
66: WHERE organization_id = p_instance_rec.vld_organization_id;
67: EXCEPTION
68: WHEN no_data_found THEN
69: l_return_value := FALSE;
118: --
119: BEGIN
120: SELECT serial_number_type -- serial number uniqueness control
121: INTO l_serial_type
122: FROM mtl_parameters
123: WHERE organization_id = p_instance_rec.vld_organization_id;
124: EXCEPTION
125: WHEN no_data_found THEN
126: l_return_value := FALSE;
248: BEGIN
249: SELECT 'x'
250: INTO l_temp
251: FROM mtl_serial_numbers s,
252: mtl_parameters p
253: WHERE s.current_organization_id = p.organization_id
254: AND s.serial_number = p_instance_rec.serial_number
255: AND p.serial_number_type = 3
256: AND ROWNUM = 1;