95: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;
96: l_itemkey := l_servereq_csr_rec.incident_number || '-' || to_char(l_wf_process_id);
97:
98: -- Update the workflow process ID of the request
99: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN
100: UPDATE CS_INCIDENTS_ALL_B
101: SET workflow_process_id = l_wf_process_id,
102: last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
103: last_update_date = sysdate
98: -- Update the workflow process ID of the request
99: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN
100: UPDATE CS_INCIDENTS_ALL_B
101: SET workflow_process_id = l_wf_process_id,
102: last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
103: last_update_date = sysdate
104: WHERE CURRENT OF l_ServeReq_csr;
105: ELSE
106: UPDATE CS_INCIDENTS_ALL_B