DBA Data[Home] [Help]

APPS.CUG_LAUNCH_WORKFLOW_PVT dependencies on FND_PROFILE

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

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

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

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