Oracle has nice feature that you can use use '%type' to specify type of parameter in procedure. For example:
id_ticket ticket.id%type;

so it's easy to use same type in procedure as in table. I know, we have now domains in procedures, but not everytime you create domain for column.