Stop Medication request

Purpose

This procedure is designed to expire previously created Request for Medication request after ended time-life in ACTIVE status.

Procedure logic for transition

1. For info - status charts: Medication_request

2. Get list Medication request 

   SELECT * FROM requests_for_medication_request RMR
       WHERE RMR.status == NEW
           AND RMR.expiry_to <= current_date()

   SELECT * FROM requests_for_medication_request RMR WHERE RMR.status == NEW AND RMR.expiry_to <= current_date()

3. Update (Set values) Request for Medication request
   1. status  =  STOPPED
   2. updated_by = user_id
   3. updated_at = timestamp