When using transactional replication, you have the option of using a custom stored procedure instead of a standard insert at the subscriber.  This stored proc would run instead of the regular insert.  The same is true for updates and deletes.  The default behavior is to use the regular insert, update, and delete.  No stored proc is automatically generated. 

Devin