o_payload := queue_PushSMS_payload_Type_var(:NEW.Messagetext, 'Android', V_TOKEN,'CBQ Promotional SMS',:NEW.Notiid, :NEW.Messageid);
  
  DBMS_AQ.ENQUEUE(
        queue_name         => 'SMSII.PUSHSMS_queue_var',
        enqueue_options    => r_enqueue_options,
        message_properties => r_message_properties,
        payload            => o_payload,
        msgid              => v_message_handle
        );

insert into test.test_sms values(:NEW.Messagetext);

commit;