The Bishop of Cork and Ross has confirmed his intention to submit his letter of resignation to the Pope within two weeks.