CREATE OR REPLACE FUNCTION martor.pkg_gennp_actualizeazacmd1(acodprogramf1 numeric, acodcomanda1 numeric, acodobiect numeric, aprioritate numeric, acodgest numeric, acodpers numeric, acodformatie numeric, aschimb numeric, atermen character varying, acant numeric, arebut numeric)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
DECLARE
  V     RECORD;
  oData date;
begin
  --Florin 19.01.2026 - sinc. Oracle
	BEGIN 
	  oData := to_date( aTermen, 'dd.mm.yyyy');
	EXCEPTION WHEN others THEN
	  oData := null;
	END; 

	FOR V IN (SELECT aCodProgramF1 CODPROGRAMF1, aCodComanda1 CODCOMANDA1, aCodObiect CODOBIECT, aPrioritate PRIORITATE, aCodGest CODGEST, aCodPers CODPERS, 
	                 aCodFormatie CODFORMATIE, aSchimb SCHIMB, oData TERMEN, aCant CANT, aRebut REBUT
	         ) 
	LOOP
		UPDATE TMP_GENNP_CMD1_TMP TMP
		 SET CANT = COALESCE(TMP.CANT, 0) + V.CANT
		WHERE
		 TMP.CODPROGRAMF1 = V.CODPROGRAMF1 AND  TMP.CODCOMANDA1 = V.CODCOMANDA1;
		
		IF NOT FOUND THEN  
		  INSERT INTO TMP_GENNP_CMD1_TMP(CODPROGRAMF1, CODCOMANDA1, CODOBIECT, PRIORITATE, CODGEST, CODPERS, CODFORMATIE, SCHIMB, TERMEN, CANT, REBUT) 
		  VALUES (V.CODPROGRAMF1, V.CODCOMANDA1, V.CODOBIECT, V.PRIORITATE, V.CODGEST, V.CODPERS, V.CODFORMATIE, V.SCHIMB, V.TERMEN, V.CANT, V.REBUT) ;
		END IF;  
	END LOOP;
end;
$function$
;