What is the difference between NAME_IN and COPY?

Copy is package procedure and writes values into a field.

Name in is a package function and returns the contents of the variable to which you apply.