657: INSERT INTO EAM_SAFETY_WORKFLOWS
658: (OBJECT_ID,TRANSACTION_ID,WORKFLOW_TYPE,LAST_UPDATE_DATE,LAST_UPDATED_BY,
659: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
660: VALUES
661: (p_eam_wc_rec.WORK_CLEARANCE_ID,l_wf_event_seq,2,SYSDATE,FND_GLOBAL.user_id,
662: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
663: );
664:
665:
658: (OBJECT_ID,TRANSACTION_ID,WORKFLOW_TYPE,LAST_UPDATE_DATE,LAST_UPDATED_BY,
659: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
660: VALUES
661: (p_eam_wc_rec.WORK_CLEARANCE_ID,l_wf_event_seq,2,SYSDATE,FND_GLOBAL.user_id,
662: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
663: );
664:
665:
666: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Permit Released change event','Building parameter list');
689: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
690: p_value => TO_CHAR(2),
691: p_parameterlist => l_parameter_list);
692: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
693: p_value =>FND_GLOBAL.USER_NAME ,
694: p_parameterlist => l_parameter_list);
695: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
696: p_value => p_workflow_name,
697: p_parameterlist => l_parameter_list);