APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 55: cs_incidents_all_b inc,

51: inc.incident_owner_id,
52: inc.incident_id,
53: inc.object_version_number
54: FROM cs_incident_statuses status,
55: cs_incidents_all_b inc,
56: cs_incident_types cit
57: WHERE inc.incident_number = l_request_number
58: AND inc.incident_status_id = status.incident_status_id
59: and cit.incident_type_id = inc.incident_type_id;

Line 721: cs_incidents_all_b inc,

717: inc.incident_owner_id,
718: inc.incident_id,
719: inc.object_version_number
720: FROM cs_incident_statuses status,
721: cs_incidents_all_b inc,
722: cs_incident_types cit
723: WHERE inc.incident_number = p_Incident_Number
724: AND inc.incident_status_id = status.incident_status_id
725: and cit.incident_type_id = inc.incident_type_id;

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

799: and TRUNC(NVL(csad.end_date_active, SYSDATE))
800: and csat.from_to_status_code IS not NULL
801: and csad.resolution_code IS NULL
802: and csat.incident_status_id IS NOT NULL
803: and csat.incident_status_id = (select incident_status_id from cs_incidents_all_b
804: where incident_number = p_incident_number)
805: and csad.action_code like 'NOTIFY%';
806:
807:

Line 1504: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id

1500: x_wf_process_id := SUBSTR(l_itemkey, l_pos+1);
1501:
1502: --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);
1503:
1504: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id
1505: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id
1506: WHERE INCIDENT_ID = l_sel_request_rec.incident_id;
1507:
1508: /* Roopa - begin

Line 1505: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id

1501:
1502: --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);
1503:
1504: --UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = l_event_id
1505: UPDATE CS_INCIDENTS_ALL_B set WORKFLOW_PROCESS_ID = x_wf_process_id
1506: WHERE INCIDENT_ID = l_sel_request_rec.incident_id;
1507:
1508: /* Roopa - begin
1509: Fix for bug 2798269