633:
634: BEGIN
635: SELECT sts.status_code,sts.name
636: INTO x_create_nr_output_rec.service_request_status_code,x_create_nr_output_rec.service_request_status
637: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts
638: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
639: AND sts.INCIDENT_STATUS_ID = cs.incident_Status_id;
640: EXCEPTION
641: WHEN OTHERS THEN
821: END IF;
822: BEGIN
823: SELECT status_code
824: INTO x_create_nr_output_rec.SERVICE_REQUEST_STATUS_CODE
825: FROM CS_INCIDENT_STATUSES_B
826: WHERE INCIDENT_STATUS_ID = p_sr_task_rec.Status_id;
827: EXCEPTION
828: WHEN OTHERS THEN
829: NULL;