APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 49: cs_incidents_all_b inc,

45: inc.incident_owner_id,
46: inc.incident_id,
47: inc.object_version_number
48: FROM cs_incident_statuses status,
49: cs_incidents_all_b inc,
50: cs_incident_types cit
51: WHERE inc.incident_number = l_request_number
52: AND inc.incident_status_id = status.incident_status_id
53: and cit.incident_type_id = inc.incident_type_id;

Line 413: cs_incidents_all_b inc,

409: inc.incident_owner_id,
410: inc.incident_id,
411: inc.object_version_number
412: FROM cs_incident_statuses status,
413: cs_incidents_all_b inc,
414: cs_incident_types cit
415: WHERE inc.incident_number = p_Incident_Number
416: AND inc.incident_status_id = status.incident_status_id
417: and cit.incident_type_id = inc.incident_type_id;

Line 495: and csat.incident_status_id = (select incident_status_id from cs_incidents_all_b

491: and TRUNC(NVL(csad.end_date_active, SYSDATE))
492: and csat.from_to_status_code IS not NULL
493: and csad.resolution_code IS NULL
494: and csat.incident_status_id IS NOT NULL
495: and csat.incident_status_id = (select incident_status_id from cs_incidents_all_b
496: where incident_number = p_incident_number)
497: and csad.action_code like 'NOTIFY%';
498:
499:

Line 1151: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id

1147: x_wf_process_id := SUBSTR(l_itemkey, l_pos+1);
1148:
1149: --INSERT INTO rm_tmp values (p_Incident_Number, 'Update event raised successfuly,updating table.x_wf_process_id= '||x_wf_process_id||' l_itemkey='||l_itemkey,rm_tmp_seq.nextval);
1150:
1151: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id
1152: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id
1153: WHERE INCIDENT_ID = l_sel_request_rec.incident_id;
1154:
1155: /* Roopa - begin

Line 1152: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id

1148:
1149: --INSERT INTO rm_tmp values (p_Incident_Number, 'Update event raised successfuly,updating table.x_wf_process_id= '||x_wf_process_id||' l_itemkey='||l_itemkey,rm_tmp_seq.nextval);
1150:
1151: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id
1152: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id
1153: WHERE INCIDENT_ID = l_sel_request_rec.incident_id;
1154:
1155: /* Roopa - begin
1156: Fix for bug 2798269