36: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
37: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
38:
39: --DBMS_OUTPUT.PUT_LINE('l_event_key : '||l_event_key );
40: wf_event.AddParameterToList( p_name => 'SITEID'
41: ,p_value => p_siteId
42: ,p_ParameterList => l_parameter_List);
43: wf_event.AddParameterToList( p_name => 'SITE_IDENTIFICATION_NUMBER'
44: ,p_value => p_site_identification_number
39: --DBMS_OUTPUT.PUT_LINE('l_event_key : '||l_event_key );
40: wf_event.AddParameterToList( p_name => 'SITEID'
41: ,p_value => p_siteId
42: ,p_ParameterList => l_parameter_List);
43: wf_event.AddParameterToList( p_name => 'SITE_IDENTIFICATION_NUMBER'
44: ,p_value => p_site_identification_number
45: ,p_ParameterList => l_parameter_List);
46: wf_event.AddParameterToList( p_name => 'SGTYPE'
47: ,p_value => p_sg_type
42: ,p_ParameterList => l_parameter_List);
43: wf_event.AddParameterToList( p_name => 'SITE_IDENTIFICATION_NUMBER'
44: ,p_value => p_site_identification_number
45: ,p_ParameterList => l_parameter_List);
46: wf_event.AddParameterToList( p_name => 'SGTYPE'
47: ,p_value => p_sg_type
48: ,p_ParameterList => l_parameter_List);
49: wf_event.AddParameterToList( p_name => 'SGNAME'
50: ,p_value => p_sg_name
45: ,p_ParameterList => l_parameter_List);
46: wf_event.AddParameterToList( p_name => 'SGTYPE'
47: ,p_value => p_sg_type
48: ,p_ParameterList => l_parameter_List);
49: wf_event.AddParameterToList( p_name => 'SGNAME'
50: ,p_value => p_sg_name
51: ,p_ParameterList => l_parameter_List);
52:
53: WF_EVENT.Raise( p_event_name => l_event_name
49: wf_event.AddParameterToList( p_name => 'SGNAME'
50: ,p_value => p_sg_name
51: ,p_ParameterList => l_parameter_List);
52:
53: WF_EVENT.Raise( p_event_name => l_event_name
54: ,p_event_key => l_event_key
55: ,p_event_data => l_event_data
56: ,p_parameters => l_parameter_list
57: ,p_send_date => l_send_date);