DBA Data[Home] [Help]

APPS.CUG_INCIDNT_ATTR_VALS_PVT dependencies on FND_PROFILE

Line 231: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN

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

Line 234: last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

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