A data engineer needs to build a reusable routine that iterates over a control table, performs conditional INSERT and UPDATE statements against multiple target tables, and returns a status message when complete. The routine must execute DML and manage control flow within Snowflake. Which object type should the engineer use?