...

Logic

1. Fetch records from PRM.medications, where:

   1. is_active = TRUE

   2. end_date < current_date()

2. Update all records to:

   1. is_active = FALSE

   2. updated_at = now()

   3. updated_by = SYSTEM_USER

3. Write changes to audit log

4. Write changes to event manager

...