19235: FUNCTION Get_Importance_Level(P_Severity_Id IN NUMBER)
19236: RETURN NUMBER IS
19237: CURSOR c_imp_csr IS
19238: SELECT importance_level
19239: FROM cs_incident_severities_b
19240: WHERE incident_severity_id = p_severity_id;
19241: l_imp_level NUMBER;
19242: BEGIN
19243: OPEN c_imp_csr;
19250: FUNCTION Get_Old_Importance_level(p_incident_id IN NUMBER)
19251: RETURN NUMBER IS
19252: CURSOR c_imp_old_csr IS
19253: SELECT importance_level
19254: FROM cs_incident_severities_b
19255: WHERE incident_severity_id =( SELECT incident_severity_id
19256: FROM CS_INCIDENTS_ALL_B
19257: WHERE incident_id = p_incident_id);
19258: l_old_imp_level NUMBER;