CREATE OR REPLACE FUNCTION f_validate_migrate_merchant(character varying, character varying)
  RETURNS SETOF refcursor AS
$BODY$
DECLARE
	pRefErrorValidate	REFCURSOR := 'errorValidate';
    pMerchantCode		ALIAS FOR $1;
	pMerchantName		ALIAS FOR $2;

	vYes	 						character varying := 'Y';
	vNo		 						character varying := 'N';
	vEmptyChar		 				character varying := '';

BEGIN
	DELETE FROM temp_error_data WHERE data = pMerchantCode;

	/* update nilai flg_valid dan flg_migrate = N */
	UPDATE temp_supp_merchant
	SET flg_valid = vNo,
	flg_migrate = vNo
	WHERE (flg_valid IS NULL OR flg_valid <> vYes)
		AND company = pCompany;

	SELECT merchant_code
	FROM supp_merchant
	WHERE merchant_code = pMerchantCode;

	IF FOUND THEN
		INSERT INTO temp_error_data(
		 	data, group_data, validasi_data)
		SELECT pSessionId, 'MERCHANT', 'KODE SUDAH ADA';
    END IF;

	Open pRefErrorValidate FOR
		SELECT data, group_data, validasi_data
		FROM temp_error_data
		WHERE data = pMerchantCode;
	RETURN NEXT pRefErrorValidate;

	DELETE FROM temp_error_data WHERE data = pMerchantCode;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
/