Hi everyone done the search on here and google but still need help

I have loosened the aluminum pipe that connects to the intake manifold and heater core while trying to remove the quick clips which has resulted in a coolant leak...

My questions

1. Is this a serviceable part? (part Number??)
2. How does it go in? (pressed or oring?)
3. What adhesive glue can i use to withstand the temperature of the coolant? (if i cannot get new one)

below are pictures of the pipe out of the car the third image I was trying to show its location