APPS.CUG_INCIDNT_ATTR_VALS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 44: SELECT incident_type_id into l_incident_type_id from cs_incidents_all_b where incident_id = l_incident_id;

40:
41: -- Fix for bug 2505327. Changed table index from 0 to 1. rmanabat 08/13/02.
42: l_incident_id := p_sr_tbl(1).incident_id;
43:
44: SELECT incident_type_id into l_incident_type_id from cs_incidents_all_b where incident_id = l_incident_id;
45: OPEN l_CheckIfSRHdrInfoPresent_csr;
46: FETCH l_CheckIfSRHdrInfoPresent_csr into l_CheckIfSRHdrInfoPresent_rec;
47: IF(l_CheckIfSRHdrInfoPresent_csr%NOTFOUND) THEN
48: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 202: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST

198: CSI.workflow_process_id,
199: CSI.incident_type_id,
200: CST.name,CST.workflow,
201: CST.autolaunch_workflow_flag
202: FROM cs_incidents_all_b CSI, cs_incident_types_vl CST
203: WHERE CSI.incident_id = p_incident_id
204: AND CST.incident_type_id = CSI.incident_type_id
205: FOR UPDATE OF workflow_process_id NOWAIT;
206:

Line 232: UPDATE CS_INCIDENTS_ALL_B

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

Line 238: UPDATE CS_INCIDENTS_ALL_B

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
239: SET workflow_process_id = l_wf_process_id,
240: last_update_date = sysdate
241: WHERE CURRENT OF l_ServeReq_csr;
242: END IF;

Line 380: From cs_incidents_all_b

376: ' || 'State : ' || nvl(incident_state, ' ') || '
377: ' || 'Postal Code : ' || nvl(incident_postal_code, ' ') || '
378: ' || 'Country : ' || nvl(incident_country, ' ')
379: into l_addr_notes
380: From cs_incidents_all_b
381: Where incident_id = l_incident_id;
382: EXCEPTION
383: When NO_DATA_FOUND then
384: null;