APPS.INV_PHY_INV_LOVS dependencies on MTL_SERIAL_CHECK

Line 297: IF (NOT MTL_Serial_Check.inv_serial_info

293:
294: -- Call this API to parse the serial numbers into prefixes and numbers.
295: -- Only call this procedure if the from and to serial numbers differ
296: IF (p_from_serial_number <> p_to_serial_number) THEN
297: IF (NOT MTL_Serial_Check.inv_serial_info
298: ( p_from_serial_number => p_from_serial_number,
299: p_to_serial_number => p_to_serial_number,
300: x_prefix => l_prefix,
301: x_quantity => l_quantity,

Line 836: l_temp_bool := MTL_Serial_Check.inv_serial_info

832: FROM mtl_physical_inventory_tags
833: WHERE physical_inventory_id = p_physical_inventory_id
834: AND organization_id = p_organization_id;
835: -- Now parse the tag number and increment the numerical part
836: l_temp_bool := MTL_Serial_Check.inv_serial_info
837: ( p_from_serial_number => l_tag_number,
838: p_to_serial_number => NULL,
839: x_prefix => l_prefix,
840: x_quantity => l_quantity,

Line 854: l_temp_bool := MTL_Serial_Check.inv_serial_info

850: CLOSE tag_number_cursor;
851:
852: -- Update the next_tag_number column in the physical inventories table
853: -- since we have just generated a new tag number value here
854: l_temp_bool := MTL_Serial_Check.inv_serial_info
855: ( p_from_serial_number => l_tag_number,
856: p_to_serial_number => NULL,
857: x_prefix => l_prefix,
858: x_quantity => l_quantity,