APPS.CUG_LAUNCH_WORKFLOW_PVT dependencies on CS_INCIDENTS_ALL_B

Line 47: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST

43:
44: CURSOR l_servereq_csr IS
45: SELECT CSI.incident_number,CSI.workflow_process_id,CSI.incident_type_id,CST.name,CST.workflow,
46: CST.autolaunch_workflow_flag
47: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST
48: WHERE CSI.incident_id = p_incident_id
49: AND CST.incident_type_id = CSI.incident_type_id
50: FOR UPDATE OF workflow_process_id NOWAIT;
51:

Line 100: UPDATE CS_INCIDENTS_ALL_B

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
104: WHERE CURRENT OF l_ServeReq_csr;

Line 106: UPDATE CS_INCIDENTS_ALL_B

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
107: SET workflow_process_id = l_wf_process_id,
108: last_update_date = sysdate
109: WHERE CURRENT OF l_ServeReq_csr;
110: END IF;