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;
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;