DECLARE
l_event_name VARCHAR2 (240)
:= 'oracle.apps.ont.genesis.outbound.update';
l_event_parameter_list wf_parameter_list_t := wf_parameter_list_t ();
BEGIN
wf_event.addparametertolist (
p_name=> 'HEADER_ID',
p_value=> '96567456745',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'LINE_ID',
p_value=> '865875768',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'HOLD_SOURCE_ID',
p_value=>'54326456',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'CHANGE_TYPE',
p_value=> 'APPLY',
p_parameterlist=> l_event_parameter_list
);
BEGIN
wf_event.RAISE (
p_event_name=> l_event_name,
p_event_key=> SYS_GUID (),
p_parameters=> l_event_parameter_list
);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
' Unexpected Error : '
|| SUBSTR (SQLERRM, 1, 250)
);
END;
COMMIT;
l_event_parameter_list.DELETE;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
' Unexpected Error in main block : '
|| SUBSTR (SQLERRM, 1, 250)
);
END;
l_event_name VARCHAR2 (240)
:= 'oracle.apps.ont.genesis.outbound.update';
l_event_parameter_list wf_parameter_list_t := wf_parameter_list_t ();
BEGIN
wf_event.addparametertolist (
p_name=> 'HEADER_ID',
p_value=> '96567456745',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'LINE_ID',
p_value=> '865875768',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'HOLD_SOURCE_ID',
p_value=>'54326456',
p_parameterlist=> l_event_parameter_list
);
wf_event.addparametertolist (
p_name=> 'CHANGE_TYPE',
p_value=> 'APPLY',
p_parameterlist=> l_event_parameter_list
);
BEGIN
wf_event.RAISE (
p_event_name=> l_event_name,
p_event_key=> SYS_GUID (),
p_parameters=> l_event_parameter_list
);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
' Unexpected Error : '
|| SUBSTR (SQLERRM, 1, 250)
);
END;
COMMIT;
l_event_parameter_list.DELETE;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
' Unexpected Error in main block : '
|| SUBSTR (SQLERRM, 1, 250)
);
END;