DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 964: FROM cs_incident_statuses_vl

960: IF (p_Old_SR_Rec.STATUS_ID <> p_New_SR_Rec.STATUS_ID) THEN
961:
962: SELECT name
963: INTO l_old_request_status
964: FROM cs_incident_statuses_vl
965: WHERE INCIDENT_STATUS_ID = p_Old_SR_Rec.STATUS_ID;
966:
967: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_OLD',
968: p_value => l_old_request_status,

Line 978: FROM cs_incident_statuses_vl

974: -- This is to avoid missing/wrong notifications being sent when status change happens rapidly
975:
976: SELECT name
977: INTO l_new_request_status
978: FROM cs_incident_statuses_vl
979: WHERE INCIDENT_STATUS_ID = p_New_SR_Rec.STATUS_ID;
980:
981:
982: wf_event.AddParameterToList(p_name => 'REQUEST_STATUS_NEW',