PROCEDURE transform_promotions IS
   BEGIN
      pck_log.write_log('  Transforming data ["TRANSFORM_PROMOTIONS"]');

      INSERT INTO t_clean_promotions (id,name,start_date,end_date,reduction,on_street,on_tv)
      SELECT id,name,start_date,end_date,reduction,
             CASE WHEN on_outdoor=1 THEN 'YES' ELSE 'NO' END,
             CASE WHEN on_tv=1 THEN 'YES' ELSE 'NO' END
      FROM t_data_promotions
      WHERE rejected_by_screen='0';

      pck_log.write_log('    Done!');
   EXCEPTION
      WHEN NO_DATA_FOUND THEN
         pck_log.write_log('    Found no lines to transform','    Done!');
      WHEN OTHERS THEN
         pck_log.write_uncomplete_task_msg;
         RAISE e_transformation;
   END;