Friday, August 14, 2015

Raising a Standard Business event

Raising a standard business event is pretty simple.

The following block should give you an idea -

declare
p_event_name    VARCHAR2(4000);
p_event_key     VARCHAR2(4000);
p_event_data    VARCHAR2(4000);
p_parameters    wf_parameter_list_t;  

begin
     
      dbms_output.put_line('Before Event Raise');
   
      wf_event.RAISE (p_event_name   => 'oracle.apps.gme.batch.rescheduled',
                      p_event_key    => p_event_key,
                      p_event_data   => NULL,
                      p_parameters   => p_parameters);
                     
      dbms_output.put_line('After Event Raise');
exception
    when others then
        dbms_output.put_line('SQLERRM - '||SQLERRM);                    
end;