The replication status of a stored procedure determines if DML statements within it are replicated as statements:
If a stored procedure is not marked for replication, a DML statement within it is replicated as a statement, provided that:
The configuration allows SQL statement replication.
The DML statement does not conform to any of the conditions in “Exceptions to using SQL statement replication”.
If a stored procedure is marked for replication, only the call to it is replicated, not the individual statements that make up the stored procedure.
