DECLARE
   CURSOR c1
   IS
      SELECT DISTINCT sl_activ_code
                 FROM ow_stage_shipper_upld
                WHERE sl_jh_job_no = '1018'
                  AND sl_activ_code NOT IN (SELECT DISTINCT job_no
                                                       FROM os_fab_summary)
                  AND sl_activ_code NOT LIKE '%BU%';

   m_found   VARCHAR2 (200);
BEGIN
   FOR i IN c1
   LOOP
      m_found := m_found || ' ' || i.sl_activ_code;
   END LOOP;

  

   IF NVL (m_found, 'Y') != 'Y'
   THEN
      disp_alert ('MISSING STRUCTURES KINDLY REQUEST IT FROM EGYPT');

      INSERT INTO temp_1018
           VALUES (:m_struct_no, :t_struct_no, :GLOBAL.m_user_id, SYSDATE,
                   'OR7015_AIC', m_found);

      COMMIT;
      --dummy1('forms'||'-'||M_FOUND);
      RAISE form_trigger_failure;
   END IF;
END;