227: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;
228: l_itemkey := l_servereq_csr_rec.incident_number || '-' || to_char(l_wf_process_id);
229:
230: -- Update the workflow process ID of the request
231: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN
232: UPDATE CS_INCIDENTS_ALL_B
233: SET workflow_process_id = l_wf_process_id,
234: last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
235: last_update_date = sysdate
230: -- Update the workflow process ID of the request
231: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN
232: UPDATE CS_INCIDENTS_ALL_B
233: SET workflow_process_id = l_wf_process_id,
234: last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
235: last_update_date = sysdate
236: WHERE CURRENT OF l_ServeReq_csr;
237: ELSE
238: UPDATE CS_INCIDENTS_ALL_B