608: x_role_display_name => l_dummy );
609: END IF;
610:
611:
612: wf_event.AddParameterToList(p_name => 'REQUEST_NUMBER',
613: p_value => p_request_number,
614: p_parameterlist => l_param_list);
615:
616: wf_event.AddParameterToList(p_name => 'USER_ID',
612: wf_event.AddParameterToList(p_name => 'REQUEST_NUMBER',
613: p_value => p_request_number,
614: p_parameterlist => l_param_list);
615:
616: wf_event.AddParameterToList(p_name => 'USER_ID',
617: p_value => p_initiator_user_id,
618: p_parameterlist => l_param_list);
619:
620: wf_event.AddParameterToList(p_name => 'RESP_ID',
616: wf_event.AddParameterToList(p_name => 'USER_ID',
617: p_value => p_initiator_user_id,
618: p_parameterlist => l_param_list);
619:
620: wf_event.AddParameterToList(p_name => 'RESP_ID',
621: p_value => p_initiator_resp_id,
622: p_parameterlist => l_param_list);
623:
624: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
620: wf_event.AddParameterToList(p_name => 'RESP_ID',
621: p_value => p_initiator_resp_id,
622: p_parameterlist => l_param_list);
623:
624: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
625: p_value => p_initiator_resp_appl_id,
626: p_parameterlist => l_param_list);
627:
628: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
624: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
625: p_value => p_initiator_resp_appl_id,
626: p_parameterlist => l_param_list);
627:
628: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
629: p_value => l_initiator_role,
630: p_parameterlist => l_param_list);
631:
632: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
628: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
629: p_value => l_initiator_role,
630: p_parameterlist => l_param_list);
631:
632: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
633: p_value => 'Y',
634: p_parameterlist => l_param_list);
635:
636:
637:
638: BEGIN
639: l_administrator := FND_PROFILE.VALUE('CS_WF_ADMINISTRATOR');
640:
641: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',
642: p_value => l_administrator,
643: p_parameterlist => l_param_list);
644: EXCEPTION
645: WHEN NO_DATA_FOUND THEN
658: --INSERT INTO rm_tmp values (p_request_number, 'Raising Update event from start_servereq ',rm_tmp_seq.nextval);
659: --INSERT INTO rm_tmp values (p_request_number, 'oracle.apps.cs.sr.ServiceRequest.updated'||' l_event_key= '|| l_event_key ,rm_tmp_seq.nextval);
660:
661: -- Raise Workflow Business Event based on the event code.
662: wf_event.raise(p_event_name => 'oracle.apps.cs.sr.ServiceRequest.updated',
663: p_event_key => l_event_key,
664: p_parameters => l_param_list);
665:
666: