SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure [dbo].[p_act_actors_change_prospect_to_client]
	@actor_id int,
	@internal_reference ais_code_medium,
	@sequence_code ais_code_short = '%'
as 

	exec p_act_actors_change_internal_reference @actor_id = @actor_id, @internal_reference = @internal_reference, @sequence_code = @sequence_code
	
	update act_clients 
	set cli_statut_code = 'C'
	where cli_actor_id = @actor_id and isnull(cli_statut_code,'P') <> 'C'










GO
