CREATE DEFINER=`computraceqa`@`%` PROCEDURE `computraceqa`.`UpdateUserIsActive`(
    IN p_user_id INT,
    IN p_is_active bool
)
BEGIN
    -- Update the is_active status for the specified user_id
    UPDATE user_details
    SET is_active = p_is_active,
        updated_on = CURRENT_TIMESTAMP
    WHERE user_id = p_user_id;
END