DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on MTL_SERIAL_CHECK

Line 271: IF (NOT MTL_Serial_Check.inv_serial_info

267:
268: -- Call this API to parse the serial numbers into prefixes and numbers.
269: -- Only call this procedure if the from and to serial numbers differ
270: IF (p_from_serial_number <> p_to_serial_number) THEN
271: IF (NOT MTL_Serial_Check.inv_serial_info
272: ( p_from_serial_number => p_from_serial_number,
273: p_to_serial_number => p_to_serial_number,
274: x_prefix => l_prefix,
275: x_quantity => l_quantity,

Line 726: l_temp_bool := MTL_Serial_Check.inv_serial_info

722: FROM mtl_physical_inventory_tags
723: WHERE physical_inventory_id = p_physical_inventory_id
724: AND organization_id = p_organization_id;
725: -- Now parse the tag number and increment the numerical part
726: l_temp_bool := MTL_Serial_Check.inv_serial_info
727: ( p_from_serial_number => l_tag_number,
728: p_to_serial_number => NULL,
729: x_prefix => l_prefix,
730: x_quantity => l_quantity,

Line 744: l_temp_bool := MTL_Serial_Check.inv_serial_info

740: CLOSE tag_number_cursor;
741:
742: -- Update the next_tag_number column in the physical inventories table
743: -- since we have just generated a new tag number value here
744: l_temp_bool := MTL_Serial_Check.inv_serial_info
745: ( p_from_serial_number => l_tag_number,
746: p_to_serial_number => NULL,
747: x_prefix => l_prefix,
748: x_quantity => l_quantity,